rpt_index.html 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  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. 产品商标:
  38. <input class="easyui-combobox" id="LOGONAME" name="LOGONAME" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getLogoByGoods&select=1',method:'get',valueField:'ID',textField:'TEXT',panelHeight:'300px',multiple:true" style="width:165px;height:32px;">
  39. </div>
  40. <div style="padding-top:10px;">
  41. 产品编码:
  42. <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;">
  43. 成型线号:
  44. <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;">
  45. 成型工号:
  46. <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;">
  47. 车间号:
  48. <input class="easyui-combobox" id="workshopcodeMaster" name="workshopcodeMaster" data-options="required:false,value:'0',valueField:'value',textField:'text',
  49. data:[{'value':'0','text':'全部'},{'value':'1','text':'一车间'},{'value':'2','text':'二车间'},{'value':'3','text':'三车间'}]" style=" width: 120px; height: 32px;">
  50. <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="tbSearchReset()">清空</a>
  51. <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
  52. </div>
  53. </form>
  54. </div>
  55. </div>
  56. </div>
  57. <!--中部-->
  58. <div id="tableLayout" data-options="border:false,region:'center',split:true,title:'',iconCls:'icon-grid'" title="East" style="width:700px;">
  59. <div id="tableTabs" class="easyui-tabs" data-options="border:false" style="width: 100%; height: 100%">
  60. <!--表格-->
  61. <div title="月度成品入库报表">
  62. <table class="easyui-datagrid"
  63. id="DataGrid"
  64. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow,rowStyler:rowStyle">
  65. <thead>
  66. </thead>
  67. </table>
  68. </div>
  69. </div>
  70. </div>
  71. <script type="text/javascript">
  72. function formatterUA(value, row, index) {
  73. return Math.round(value*10000) / 100 + '%';
  74. }
  75. $(document).ready(function () {
  76. var ctime = new Date();
  77. var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() +" 00:00:00";
  78. var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 23:59:59";
  79. $("#datebeginMaster").datetimebox("setValue", beginDate);
  80. $("#dateendMaster").datetimebox("setValue", endDate);
  81. //tbSearchSubmit();
  82. });
  83. //帮助事件
  84. function tbHelp() {
  85. $('#DataGrid0').datagridDialog({
  86. title: '帮助',
  87. width: 640,
  88. height: 480,
  89. url: 'rpt_help.html'
  90. });
  91. }
  92. //主表双击事件
  93. function dgDblclickrow(index, row) {
  94. }
  95. //清空条件
  96. function tbSearchReset() {
  97. $('#ffMaster').form('clear');
  98. var ctime = new Date();
  99. var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 00:00:00";
  100. var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 23:59:59";
  101. $("#datebeginMaster").datetimebox("setValue", beginDate);
  102. $("#dateendMaster").datetimebox("setValue", endDate);
  103. $('#workshopcodeMaster').selected('0');
  104. $('#totalMaster').selected('YYYY-MM-DD');
  105. }
  106. //搜索提交
  107. function tbSearchSubmit() {
  108. var line = $('#groutinglineMaster').val();
  109. var list = line.split(",");
  110. if (list != null && list.length > 0) {
  111. var newline = [];
  112. var i = 0;
  113. for (var i = 0; i < list.length; i++) {
  114. if (!isNaN(parseInt(list[i]))) {
  115. newline.push(list[i])
  116. }
  117. }
  118. $('#groutinglineMaster').combobox('setValues', newline);
  119. }
  120. var goods = $('#goodsMaster').val();
  121. var goodslist = goods.split(",");
  122. if (goodslist != null && goodslist.length > 0) {
  123. var newgoodslist = [];
  124. var i = 0;
  125. for (var i = 0; i < goodslist.length; i++) {
  126. if (!isNaN(parseInt(goodslist[i]))) {
  127. newgoodslist.push(goodslist[i])
  128. }
  129. }
  130. $('#goodsMaster').combobox('setValues', newgoodslist);
  131. }
  132. if ($('#ffMaster').form("validate")) {
  133. $('#DataGrid').datagridLoadRpt({
  134. title: '',
  135. idField: 'SID',
  136. queryParams: $('#ffMaster').serializeJson(),
  137. url: 'rpt.ashx?m=master',
  138. pageSize: 10,
  139. fixWidth: 140,
  140. mergeWidth: 140,
  141. splitChar: '_'
  142. });
  143. }
  144. }
  145. //导出
  146. function tbExport() {
  147. var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
  148. //加载表头
  149. var fields = $('#DataGrid').datagrid('getColumnFields');
  150. var headers = [];
  151. for (var i = 0; i < fields.length; i++) {
  152. headers.push(fields[i]);
  153. }
  154. $('#DataGrid').datagridExport({
  155. headers: headers,
  156. fileName: '导出数据(月度成品入库数据统计表).xls',
  157. workSheet: '导出数据(月度成品入库数据统计表)'
  158. });
  159. }
  160. //搜索按钮
  161. function tbSearch() {
  162. $('#tbSearchDiv').toggle();
  163. //$('#DataGridMaster').datagrid('resize');
  164. $('#toolbarLayout').panel('resize', { height: 'auto' });
  165. $('body').layout('resize');
  166. $('#tableTabs').tabs('resize');
  167. }
  168. //刷新
  169. function tbReload() {
  170. tbSearchSubmit();
  171. }
  172. function rowStyle(value, row, index) {
  173. if (row["产品名称"] == "总计" || row["产品名称"] == "合计【小件】" || row["产品名称"] == "合计【大件】") {
  174. return "background:red";
  175. }
  176. }
  177. </script>
  178. </body>
  179. </html>