-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathreport_worker.php
More file actions
146 lines (145 loc) · 6.4 KB
/
report_worker.php
File metadata and controls
146 lines (145 loc) · 6.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<?php
require(dirname(__FILE__)."/include/config_base.php");
require(dirname(__FILE__)."/include/config_rglobals.php");
require(dirname(__FILE__)."/include/page.php");
require_once(dirname(__FILE__)."/include/checklogin.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/2019/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<link href="style/main.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="include/calendar.js"></script>
<title>员工工资报表管理</title>
<script language=javascript>
function preview(oper)
{
if (oper < 10){
bdhtml=window.document.body.innerHTML;//获取当前页的html代码
sprnstr="<!--startprint"+oper+"-->";//设置打印开始区域
eprnstr="<!--endprint"+oper+"-->";//设置打印结束区域
prnhtml=bdhtml.substring(bdhtml.indexOf(sprnstr)+18); //从开始代码向后取html
prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));//从结束代码向前取html
window.document.body.innerHTML=prnhtml;
window.print();
window.document.body.innerHTML=bdhtml;
}
else {
window.print();
}
}
</script>
</head>
<body>
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
<tr>
<td id="table_style" class="l_t"> </td>
<td> </td>
<td id="table_style" class="r_t"> </td>
</tr>
<tr>
<td> </td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong> 员工工资报表管理</strong> <a href="report_worker.php?type=month">月报表</a> | <a href="report_worker.php?type=year">年报表</a> <input type="button" onClick="preview(1);" value=" 打印员工工资报表 "></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<?php
if($type=='')$type='month';
switch($type){
case 'month':
?>
<table width="100%" cellspacing="0" cellpadding="0" border="0" id="table_border">
<tr height="40"><form action="report_worker.php?action=save&type=month" name="form1" method="post">
<td id="row_style" colspan="10">请选择日期 <input type="text" name="sday" onclick="setday(this)" value="<?php echo ($action=='save')?$sday:GetDateMk(time());?>">(单击输入框选择报表日期) <input type="submit" value=" 显示月报表 "></td>
</tr>
<?php
break;
case 'year':
?>
<table width="100%" cellspacing="0" cellpadding="0" border="0" id="table_border">
<tr height="40"><form action="report_worker.php?action=save&type=year" name="form1" method="post">
<td id="row_style" colspan="10">请选择日期 <input type="text" name="sday" onclick="setday(this)" value="<?php echo ($action=='save')?$sday:GetDateMk(time());?>">(单击输入框选择报表日期) <input type="submit" value=" 显示年报表 "></td>
</tr>
<?php
break;
}
if($action=='save'){//显示报表
$row=new dedesql(false);
$plist=new datalist();
$plist->pageSize = $cfg_record;
//设置GET参数表
switch($type){
case "month":
$query="select * from #@__wages,#@__basic where month(#@__wages.dtime)=month('$sday') and #@__wages.productid=#@__basic.cp_number";
$query1="select * from #@__wages,#@__basic where month(#@__wages.dtime)=month('$sday') and #@__wages.productid=#@__basic.cp_number";
$report_title="员工工资月报表";
break;
case "year":
$query="select * from #@__wages,#@__basic where YEAR(#@__wages.dtime)=YEAR('$sday') and #@__wages.productid=#@__basic.cp_number";
$query1="select * from #@__wages,#@__basic where year(#@__wages.dtime)=year('$sday') and #@__wages.productid=#@__basic.cp_number";
$report_title="员工工资年报表";
break;
case "other":
$query="select * from #@__wages,#@__basic where to_days(#@__wages.dtime)=to_days('$sday') and #@__wages.productid=#@__basic.cp_number";
$report_title="员工工资任意时间段报表";
break;
}
$p_name=Getcookie('VioomaUserID');
$p_date=GetDateMk(time());
$row->setquery($query1);
$row->execute();
while($rs=$row->getArray()){
$allmoney+=$rs['number']*$rs['cp_jj'];
$alln+=$rs['number'];
}
$row->close();
$plist->SetParameter("type",$type);
$plist->SetParameter("action",$action);
$plist->SetParameter("sday",$sday);
$plist->SetSource($query);
$p_rtitle= "<tr class='row_report_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>报废单号</td><td>报废数量</td><td>金额</td></tr>";
$mylist = $plist->GetDataList();
while($row = $mylist->GetArray('dm')){
$n+=$row['number'];
$money+=$row['number']*$row['cp_jj'];
$p_string=$p_string."<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>".$row['productid']."</td>\r\n<td> ".$row['cp_name']."</td>\r\n<td>".$row['cp_gg']."</td>\r\n<td>".get_name($row['cp_categories'],'categories').">".get_name($row['cp_categories_down'],'categories')."</td>\r\n<td>".get_name($row['cp_dwname'],'dw')."</td><td>￥".$row['cp_jj']."</td>\r\n<td>".get_name($row['productid'],'gys')."</td>\r\n<td>".$row['rdh']."</td>\r\n<td>".$row['number']."</td>\r\n<td>￥".$row['number']*$row['cp_jj']."</td>\r\n</tr>";
}
$p_string="<table width='100%' id='report_table' border='1' cellspacing='0' cellpadding='0'>". $p_rtitle .$p_string. "<tr>\r\n<td> 小 计：</td><td colspan='5'> </td><td colspan='2'>数量：".$n."</td><td colspan='2'>金额：￥".$money."</td>\r\n</tr>\r\n
<tr><td> 合 计:</td><td colspan='5'> </td><td colspan='2'>数量：".$alln."</td><td colspan='2'>金额:￥".number_format($allmoney,2,'.',',')."</td></tr>
</table>";
$p_pagestring=$plist->GetPageList($cfg_record);
}
?>
</table><?php if($action=='save'){?>
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td>
<!--startprint1-->
<?php
require(dirname(__FILE__)."/templets/t_worker.html");
?>
<!--endprint1-->
</td>
</tr>
</table>
<?php } ?>
</td>
</tr></form>
</table>
</td>
<td> </td>
</tr>
<tr>
<td id="table_style" class="l_b"> </td>
<td> </td>
<td id="table_style" class="r_b"> </td>
</tr>
</table>
<?php
copyright();
?>
</body>
</html>