rpt_index.html 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8" />
  5. <meta name="keywords" content="dongke,mes,ibossmes">
  6. <meta name="description" content="制造企业生产过程执行管理系统">
  7. <meta name="author" content="xuwei">
  8. <title>东科软件</title>
  9. <script src="/plugins/xeasyui/xeasyui.min.js"></script>
  10. <link href="/plugins/xeasyui/toolbar.min.css" rel="stylesheet" />
  11. </head>
  12. <body class="easyui-layout">
  13. <!--上部工具条-->
  14. <div id="toolbarLayout" data-options="border:false,region:'north',title:'',iconCls:'icon-grid'">
  15. <div class="i-toolbar">
  16. <a href="javascript:void(0)" id="btnSearch" title="搜索" class="easyui-linkbutton" iconcls="icon-search" plain="true" toggle="true" onclick="tbSearch()">搜索</a>
  17. <a href="javascript:void(0)" id="btnExport" title="导出" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbExport()">导出</a>
  18. <!--<a href="javascript:void(0)" id="btnColumn" class="easyui-menubutton" data-options="menu:'#btnColumnMenu',iconCls:'icon-undo'">列显示</a>-->
  19. <!--<div id="btnColumnMenu" style="width:150px;" ></div>-->
  20. <a href="javascript:void(0)" id="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>
  21. <a href="javascript:void(0)" id="btnHelp" title="帮助" class="easyui-linkbutton" iconcls="icon-help" plain="true" onclick="tbHelp()">帮助</a>
  22. <div id="tbSearchDiv" style="display:block;padding:10px;">
  23. <form id="ffMaster">
  24. <div>
  25. 开始日期:
  26. <input class="easyui-datetimebox" id="datebeginMaster" name="datebeginMaster" data-options="required:true,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
  27. 截止日期:
  28. <input class="easyui-datetimebox" id="dateendMaster" name="dateendMaster" data-options="required:true,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
  29. 高压标识:
  30. <input class="easyui-combobox" id="highFlagMaster" name="highFlagMaster" data-options="required:false,valueField:'value',textField:'text',
  31. data:[{'text': '普通', 'value': '0'}, {'text': '高压', 'value': '1'}]" style=" width: 120px; height: 32px;">
  32. 统计方式:
  33. <input class="easyui-combobox" id="totalMaster" name="totalMaster" data-options="required:true,value:'YYYY-MM-DD',valueField:'value',textField:'text',
  34. data:[{'text': '按日统计', 'value': 'YYYY-MM-DD'},{'text': '按月统计', 'value': 'YYYY-MM'}, {'text': '按年统计', 'value': 'YYYY'}]" style=" width: 120px; height: 32px;">
  35. 产品类别:
  36. <input class="easyui-combotree" id="goodstypecodeMaster" name="goodstypecodeMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getGoodsType',method:'get',panelHeight:'200px',editable:true" style="width:180px;height:32px;">
  37. </div>
  38. <div style="padding-top:10px;">
  39. 产品编码:
  40. <input class="easyui-combobox" id="goodsMaster" name="goodsMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getGoods&select=1',method:'get',valueField:'GOODSID',textField:'GOODSCODE',panelHeight:'300px',editable:true,multiple:true" style="width:415px;height:32px;">
  41. 成型线号:
  42. <input class="easyui-combobox" id="groutinglineMaster" name="groutinglineMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getLine&select=1',method:'get',valueField:'GROUTINGLINEID',textField:'GROUTINGLINECODE',panelHeight:'300px',editable:true,multiple:true" style="width: 322px; height: 32px;">
  43. 成型工号:
  44. <input class="easyui-combobox" id="usercodeMaster" name="usercodeMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../rpt.ashx?m=getUser&select=1',method:'get',valueField:'USERCODE',textField:'USERCODE',panelHeight:'300px',editable:'true'" style="width:120px;height:32px;">
  45. 车间号:
  46. <input class="easyui-combobox" id="workshopcodeMaster" name="workshopcodeMaster" data-options="required:false,value:'0',valueField:'value',textField:'text',
  47. data:[{'value':'0','text':'全部'},{'value':'1','text':'一车间'},{'value':'2','text':'二车间'},{'value':'3','text':'三车间'}]" style=" width: 120px; height: 32px;">
  48. <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="tbSearchReset()">清空</a>
  49. <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
  50. </div>
  51. </form>
  52. </div>
  53. </div>
  54. </div>
  55. <!--中部-->
  56. <div id="tableLayout" data-options="border:false,region:'center',split:true,title:'',iconCls:'icon-grid'" title="East" style="width:700px;">
  57. <div id="tableTabs" class="easyui-tabs" data-options="border:false" style="width: 100%; height: 100%">
  58. <!--表格-->
  59. <div title="月度成品入库报表">
  60. <table class="easyui-datagrid"
  61. id="DataGrid"
  62. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow,rowStyler:rowStyle">
  63. <thead>
  64. </thead>
  65. </table>
  66. </div>
  67. </div>
  68. </div>
  69. <script type="text/javascript">
  70. function formatterUA(value, row, index) {
  71. return Math.round(value*10000) / 100 + '%';
  72. }
  73. $(document).ready(function () {
  74. var ctime = new Date();
  75. var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() +" 00:00:00";
  76. var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 23:59:59";
  77. $("#datebeginMaster").datetimebox("setValue", beginDate);
  78. $("#dateendMaster").datetimebox("setValue", endDate);
  79. //tbSearchSubmit();
  80. });
  81. //帮助事件
  82. function tbHelp() {
  83. $('#DataGrid0').datagridDialog({
  84. title: '帮助',
  85. width: 640,
  86. height: 480,
  87. url: 'rpt_help.html'
  88. });
  89. }
  90. //主表双击事件
  91. function dgDblclickrow(index, row) {
  92. }
  93. //清空条件
  94. function tbSearchReset() {
  95. $('#ffMaster').form('clear');
  96. var ctime = new Date();
  97. var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 00:00:00";
  98. var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 23:59:59";
  99. $("#datebeginMaster").datetimebox("setValue", beginDate);
  100. $("#dateendMaster").datetimebox("setValue", endDate);
  101. $('#workshopcodeMaster').selected('0');
  102. $('#totalMaster').selected('YYYY-MM-DD');
  103. }
  104. //搜索提交
  105. function tbSearchSubmit() {
  106. var line = $('#groutinglineMaster').val();
  107. var list = line.split(",");
  108. if (list != null && list.length > 0) {
  109. var newline = [];
  110. var i = 0;
  111. for (var i = 0; i < list.length; i++) {
  112. if (!isNaN(parseInt(list[i]))) {
  113. newline.push(list[i])
  114. }
  115. }
  116. $('#groutinglineMaster').combobox('setValues', newline);
  117. }
  118. var goods = $('#goodsMaster').val();
  119. var goodslist = goods.split(",");
  120. if (goodslist != null && goodslist.length > 0) {
  121. var newgoodslist = [];
  122. var i = 0;
  123. for (var i = 0; i < goodslist.length; i++) {
  124. if (!isNaN(parseInt(goodslist[i]))) {
  125. newgoodslist.push(goodslist[i])
  126. }
  127. }
  128. $('#goodsMaster').combobox('setValues', newgoodslist);
  129. }
  130. if ($('#ffMaster').form("validate")) {
  131. $('#DataGrid').datagridLoadRpt({
  132. title: '',
  133. idField: 'SID',
  134. queryParams: $('#ffMaster').serializeJson(),
  135. url: 'rpt.ashx?m=master',
  136. pageSize: 10,
  137. fixWidth: 120,
  138. mergeWidth: 120,
  139. splitChar: '_'
  140. });
  141. }
  142. }
  143. //导出
  144. function tbExport() {
  145. var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
  146. //加载表头
  147. var fields = $('#DataGrid').datagrid('getColumnFields');
  148. var headers = [];
  149. for (var i = 0; i < fields.length; i++) {
  150. headers.push(fields[i]);
  151. }
  152. $('#DataGrid').datagridExport({
  153. headers: headers,
  154. fileName: '导出数据(月度成品入库数据统计表).xls',
  155. workSheet: '导出数据(月度成品入库数据统计表)'
  156. });
  157. }
  158. //搜索按钮
  159. function tbSearch() {
  160. $('#tbSearchDiv').toggle();
  161. //$('#DataGridMaster').datagrid('resize');
  162. $('#toolbarLayout').panel('resize', { height: 'auto' });
  163. $('body').layout('resize');
  164. $('#tableTabs').tabs('resize');
  165. }
  166. //刷新
  167. function tbReload() {
  168. tbSearchSubmit();
  169. }
  170. function rowStyle(value, row, index) {
  171. if (row["产品名称"] == "总计" || row["产品名称"] == "合计【小件】" || row["产品名称"] == "合计【大件】") {
  172. return "background:red";
  173. }
  174. }
  175. </script>
  176. </body>
  177. </html>