rpt_index.html 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226
  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-combobox" id="TESTFORMGUID" name="TESTFORMGUID" data-options="required:true,prompt:'',tipPosition:'top',url:'../testform/testform.ashx?m=getList' ,method:'get',valueField:'ID',textField:'NAME',panelHeight:'300px',editable:'false'" style="width: 360px; height: 32px;">
  27. 产品编码:
  28. <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:120px;height:32px;">
  29. <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="toClear()">清空</a>
  30. <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
  31. </div>
  32. </form>
  33. </div>
  34. </div>
  35. </div>
  36. <!--中部-->
  37. <div id="tableLayout" data-options="border:false,region:'center',split:true,title:'',iconCls:'icon-grid'" title="East" style="width:700px;">
  38. <div id="tableTabs" class="easyui-tabs" data-options="border:false" style="width: 100%; height: 100%">
  39. <!--表格-->
  40. <div title="实验产品质量汇总表">
  41. <table class="easyui-datagrid"
  42. id="DataGrid0"
  43. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow">
  44. <thead>
  45. <!--<tr>
  46. <th data-options="field:'ID',title:'ID',width:220,align:'left',checkbox:true,hidden:true">ID</th>
  47. <th data-options="field:'工序',title:'工序',align:'left',sortable:true"></th>
  48. <th data-options="field:'产量',title:'产量',align:'left',sortable:true"></th>
  49. <th data-options="field:'合格数',title:'合格数',align:'left',sortable:true"></th>
  50. <th data-options="field:'合格率',title:'合格率',align:'left',sortable:true"></th>
  51. <th data-options="field:'干补数',title:'干补数',align:'left',sortable:true"></th>
  52. <th data-options="field:'干补合格数',title:'干补合格数',align:'left',sortable:true"></th>
  53. <th data-options="field:'干补合格率',title:'干补合格率',align:'left',sortable:true"></th>
  54. <th data-options="field:'TOP1名称',title:'TOP1名称',align:'left',sortable:true"></th>
  55. <th data-options="field:'TOP1数量',title:'TOP1数量',align:'left',sortable:true"></th>
  56. <th data-options="field:'TOP1占比',title:'TOP1占比',align:'left',sortable:true"></th>
  57. <th data-options="field:'TOP2名称',title:'TOP2名称',align:'left',sortable:true"></th>
  58. <th data-options="field:'TOP2数量',title:'TOP2数量',align:'left',sortable:true"></th>
  59. <th data-options="field:'TOP2占比',title:'TOP2占比',align:'left',sortable:true"></th>
  60. <th data-options="field:'TOP3名称',title:'TOP3名称',align:'left',sortable:true"></th>
  61. <th data-options="field:'TOP3数量',title:'TOP3数量',align:'left',sortable:true"></th>
  62. <th data-options="field:'TOP3占比',title:'TOP3占比',align:'left',sortable:true"></th>
  63. </tr>-->
  64. </thead>
  65. </table>
  66. </div>
  67. <!--<div title="实验产品质量明细表">
  68. <table class="easyui-datagrid"
  69. id="DataGrid1"
  70. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
  71. <thead>
  72. </thead>
  73. </table>
  74. </div>-->
  75. <!--<div title="表名明细表2">
  76. <table class="easyui-datagrid"
  77. id="DataGrid2"
  78. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
  79. <thead>
  80. </thead>
  81. </table>
  82. </div>-->
  83. </div>
  84. </div>
  85. <script type="text/javascript">
  86. function formatterUA(value, row, index) {
  87. return Math.round(value*10000) / 100 + '%';
  88. }
  89. $(document).ready(function () {
  90. var ctime = new Date();
  91. var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
  92. var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
  93. $("#datebeginMaster").datebox("setValue", beginDate);
  94. $("#dateendMaster").datebox("setValue", endDate);
  95. //tbSearchSubmit();
  96. });
  97. //主表双击事件
  98. function dgDblclickrow(index, row) {
  99. //$("#tableTabs").tabs("select", 1);
  100. //LoadDataGridDetail(index, row);
  101. }
  102. //加载子表数据
  103. function LoadDataGridDetail(index, row) {
  104. //加载子表1
  105. //var id = $('#DataGridMaster').datagrid('getSelections')[0]['SID'];
  106. var id = row['测试列1'];
  107. $('#DataGrid1').datagridLoadRpt({
  108. idField: '测试列1',
  109. url: 'rpt.ashx?m=1&id=' + id,
  110. pageSize: 10,
  111. fixWidth: 120,
  112. mergeWidth: 100,
  113. splitChar: '_',
  114. columnMoving: true
  115. });
  116. }
  117. // 清除恢复默认值
  118. function toClear() {
  119. $("#TESTFORMGUID").combobox('clear');
  120. $("#goodsMaster").combobox('clear');
  121. }
  122. //搜索提交
  123. function tbSearchSubmit() {
  124. var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
  125. if (index == 0) {
  126. if ($('#ffMaster').form("validate")) {
  127. $('#DataGrid' + index).datagridLoad({
  128. title: '',
  129. idField: 'SID',
  130. queryParams: $('#ffMaster').serializeJson(),
  131. url: 'rpt.ashx?m=' + index + '&id=' + request('id'),
  132. pageSize: 10,
  133. fixWidth: 100,
  134. mergeWidth: 80,
  135. splitChar: '_'
  136. });
  137. }
  138. }
  139. if (index == 1) {
  140. if ($('#ffMaster').form("validate")) {
  141. $('#DataGrid' + index).datagridLoad({
  142. idField: '测试列1',
  143. url: 'rpt.ashx?m=' + index ,
  144. pageSize: 10,
  145. fixWidth: 100,
  146. mergeWidth: 80,
  147. splitChar: '_'
  148. });
  149. }
  150. }
  151. }
  152. //导出
  153. function tbExport() {
  154. var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
  155. //加载表头
  156. var fields1 = $('#DataGrid' + index).datagrid('getColumnFields');
  157. var fields2 = $('#DataGrid' + index).datagrid('getColumnFields', true);
  158. var fields = fields2.concat(fields1);
  159. var headers = [];
  160. for (var i = 0; i < fields.length; i++) {
  161. //headers.push($('#DataGridMaster').datagrid('getColumnOption', fields[i])['title']);
  162. headers.push(fields[i]);
  163. }
  164. $('#DataGrid' + index).datagridExport({
  165. headers: headers,
  166. fileName: '导出数据(表名1).xls',
  167. workSheet: '导出数据(表名1)'
  168. });
  169. //$('#DataGridMaster').datagridExport({
  170. // headers: headers,
  171. // fileName: '导出数据(表名).xls',
  172. // workSheet: '导出数据(表名)'
  173. //});
  174. //导出多sheet
  175. //$.dataGridToExcel(
  176. // ['DataGridMaster', 'DataGridDetail1', 'DataGridDetail2'],
  177. // ['表名','表名明细表1', '表名明细表2'],
  178. // "导出数据(表名).xls"
  179. //);
  180. }
  181. //搜索按钮
  182. function tbSearch() {
  183. $('#tbSearchDiv').toggle();
  184. //$('#DataGridMaster').datagrid('resize');
  185. $('#toolbarLayout').panel('resize', { height: 'auto' });
  186. $('body').layout('resize');
  187. $('#tableTabs').tabs('resize');
  188. }
  189. //刷新
  190. function tbReload() {
  191. tbSearchSubmit();
  192. }
  193. //帮助事件
  194. function tbHelp() {
  195. $('#DataGrid0').datagridDialog({
  196. title: '帮助',
  197. width: 640,
  198. height: 480,
  199. url: 'rpt_help.html'
  200. });
  201. }
  202. </script>
  203. </body>
  204. </html>