rpt_index.html 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403
  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. <link rel="shortcut icon" href="/img/logo.png" />
  10. <link rel="bookmark" href="/img/logo.png" />
  11. <link rel="stylesheet" type="text/css" href="/plugins/easyui/themes/dongke/easyui.css">
  12. <link rel="stylesheet" type="text/css" href="/plugins/easyui/themes/icon.css">
  13. <link rel="stylesheet" type="text/css" href="/plugins/xeasyui/xuwell.css">
  14. <script type="text/javascript" src="/plugins/easyui/jquery.min.js"></script>
  15. <script type="text/javascript" src="/plugins/easyui/jquery.easyui.min.js"></script>
  16. <script type="text/javascript" src="/plugins/easyui/locale/easyui-lang-zh_CN.js"></script>
  17. <script type="text/javascript" src="/plugins/xeasyui/xuwell.js"></script>
  18. <link href="/plugins/xeasyui/toolbar.min.css" rel="stylesheet" />
  19. </head>
  20. <body class="easyui-layout">
  21. <!--中部主体-->
  22. <div id="toolbarLayout" data-options="border:false,region:'north',title:'',iconCls:'icon-grid'">
  23. <!--工具条-->
  24. <div id="tb" style="overflow: hidden;" class="i-toolbar" data-options="border:false,region:'north',title:'',iconCls:'icon-grid',height:210">
  25. <a href="javascript:void(0)" id="btnSearch" title="搜索" class="easyui-linkbutton" iconcls="icon-search" plain="true" toggle="true" onclick="tbSearch()">搜索</a>
  26. <a href="javascript:void(0)" id="btnExport" title="导出" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbExport()">导出</a>
  27. <a href="javascript:void(0)" id="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>
  28. <div id="tbSearchDiv" style="display: block; padding: 10px;">
  29. <form id="ffMaster">
  30. <div>
  31. 产成品交接时间:
  32. <input class="easyui-datetimebox" id="datebeginMasterS" name="datebeginMasterS" data-options="required:false,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
  33. -
  34. <input class="easyui-datetimebox" id="datebeginMasterD" name="datebeginMasterD" data-options="required:false,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
  35. 注浆日期:
  36. <input class="easyui-datebox" id="datebeginMasterG" name="datebeginMasterG" data-options="required:false,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
  37. - <input class="easyui-datebox" id="dateendMasterG" name="dateendMasterG" data-options="required:false,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
  38. 车间:
  39. <input class="easyui-combobox" id="workshop" name="workshop" data-options="required:false,valueField:'value',textField:'text',editable:true,multiple:true,
  40. data:[{'text': '1车间', 'value': '1'},{'text': '2车间', 'value': '2'},{'text': '3车间', 'value': '3'}]"
  41. style=" width: 160px; height: 32px;">产品类型:
  42. <input class="easyui-combotree" id="goodstypecode" name="goodstypecode" data-options="required:false,prompt:'',tipPosition:'top',url:'../../list.ashx?m=getGoodsType',method:'get',panelHeight:'200px',editable:true" style="width: 160px; height: 32px;"></span>
  43. 产品条码/外箱码:<input class="easyui-textbox" id="barcode" name="barcode" data-options="required:false,prompt:'',tipPosition:'top',required:false" style="width: 120px; height: 32px;"></span>
  44. 组件条码:<input class="easyui-textbox" id="IDNRKONLYCODE" name="IDNRKONLYCODE" data-options="required:false,prompt:'',tipPosition:'top',required:false" style="width: 120px; height: 32px;"></span>
  45. <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="$('#ffMaster').form('clear')">清空</a>
  46. <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
  47. </div>
  48. </form>
  49. </div>
  50. </div>
  51. </div>
  52. <div data-options="border:false,region:'center',title:'',iconCls:'icon-grid'">
  53. <div id="tableTabs" class="easyui-tabs" data-options="border:false" style="width: 100%; height: 100%">
  54. <div title="产成品交接表">
  55. <!--表格-->
  56. <table class="easyui-datagrid"
  57. id="DataGrid"
  58. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow,onDblClickCell: dgDblclickcelldetail">
  59. <thead>
  60. <tr>
  61. <th data-options="field:'注浆日期',title:'注浆日期',align:'center',sortable:false"></th>
  62. <th data-options="field:'交接时间',title:'交接时间',align:'center',sortable:false"></th>
  63. <th data-options="field:'车间',title:'车间',align:'center',sortable:false"></th>
  64. <th data-options="field:'产品类型',title:'产品类型',align:'center',sortable:false"></th>
  65. <th data-options="field:'产品型号',title:'产品型号',align:'center',sortable:false"></th>
  66. <th data-options="field:'产品名称',title:'产品名称',align:'center',sortable:false"></th>
  67. <th data-options="field:'产品条码',title:'产品条码',align:'center',sortable:false"></th>
  68. <th data-options="field:'产品外箱码',title:'产品外箱码',align:'center',sortable:false"></th>
  69. <th data-options="field:'生产入库单号',title:'生产入库单号',align:'center',sortable:false,styler:stylerSet"></th>
  70. <th data-options="field:'LOGIDLINK',title:'LOGIDLINK',align:'center',sortable:false,hidden:true"></th>
  71. </tr>
  72. </thead>
  73. </table>
  74. </div>
  75. <div title="产品跟踪表">
  76. <div class="easyui-layout" data-options="fit:true">
  77. <div data-options="border:false,region:'north',title:'',split:true,iconCls:'icon-grid'" style="width:100%; height: 110px">
  78. <table class="easyui-datagrid"
  79. id="PropertyGridDetail"
  80. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
  81. <thead>
  82. <tr>
  83. <th data-options="field:'当前条码',title:'当前条码',align:'center',sortable:false"></th>
  84. <th data-options="field:'产品商标',title:'产品商标',align:'center',sortable:false"></th>
  85. <th data-options="field:'产品类别',title:'产品类别',align:'center',sortable:false"></th>
  86. <th data-options="field:'产品型号',title:'产品型号',align:'center',sortable:false"></th>
  87. <th data-options="field:'产品名称',title:'产品名称',align:'center',sortable:false"></th>
  88. <th data-options="field:'物料编码',title:'物料编码',align:'center',sortable:false"></th>
  89. <th data-options="field:'包装条码',title:'包装条码',align:'center',sortable:false"></th>
  90. <th data-options="field:'产品规格',title:'产品规格',align:'center',sortable:false"></th>
  91. <th data-options="field:'釉色类别',title:'釉色类别',align:'center',sortable:false"></th>
  92. <th data-options="field:'成型线编码',title:'成型线编码',align:'center',sortable:false"></th>
  93. <th data-options="field:'模具编号',title:'模具编号',align:'center',sortable:false"></th>
  94. <th data-options="field:'注浆次数',title:'注浆次数',align:'center',sortable:false"></th>
  95. <th data-options="field:'成型工号',title:'成型工号',align:'center',sortable:false"></th>
  96. <th data-options="field:'注浆日期',title:'注浆日期',align:'center',sortable:false,formatter:getdate"></th>
  97. <th data-options="field:'注浆批次',title:'注浆批次',align:'center',sortable:false"></th>
  98. <th data-options="field:'产品状态',title:'产品状态',align:'center',sortable:false"></th>
  99. <th data-options="field:'产品等级',title:'产品等级',align:'center',sortable:false"></th>
  100. <th data-options="field:'干补标识',title:'干补标识',align:'center',sortable:false"></th>
  101. <th data-options="field:'损坯标识',title:'损坯标识',align:'center',sortable:false"></th>
  102. <th data-options="field:'公坯标识',title:'公坯标识',align:'center',sortable:false"></th>
  103. <th data-options="field:'防伪码',title:'防伪码',align:'center',sortable:false"></th>
  104. <th data-options="field:'喷釉房号',title:'喷釉房号',align:'center',sortable:false"></th>
  105. </tr>
  106. </thead>
  107. </table>
  108. </div>
  109. <div title="产品信息表" data-options="border:false,region:'center',title:'',split:true,iconCls:'icon-grid'" style="width:100%; height: 100%">
  110. <!--表格-->
  111. <table class="easyui-datagrid"
  112. id="DataGridMaster"
  113. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
  114. <thead>
  115. <tr>
  116. <!--<th data-options="field:'公司',title:'公司',align:'center',sortable:false"></th>-->
  117. <th data-options="field:'工厂',title:'工厂',align:'center',sortable:false"></th>
  118. <th data-options="field:'车间',title:'车间',align:'center',sortable:false"></th>
  119. <th data-options="field:'工作中心',title:'工作中心',align:'center',sortable:false"></th>
  120. <th data-options="field:'产线',title:'产线',align:'center',sortable:false"></th>
  121. <th data-options="field:'工序',title:'工序',align:'center',sortable:false"></th>
  122. <th data-options="field:'生产工号',title:'生产工号',align:'center',sortable:false"></th>
  123. <th data-options="field:'产品分级',title:'产品分级',align:'center',sortable:false"></th>
  124. <th data-options="field:'操作者',title:'操作者',align:'center',sortable:false"></th>
  125. <th data-options="field:'操作时间',title:'操作时间',align:'center',sortable:false"></th>
  126. </tr>
  127. </thead>
  128. </table>
  129. </div>
  130. </div>
  131. </div>
  132. <!--<div title="产品信息表">
  133. <table class="easyui-datagrid"
  134. id="PropertyGridDetail"
  135. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
  136. </table>
  137. </div>-->
  138. <div title="物料信息表">
  139. <!--表格-->
  140. <table class="easyui-datagrid"
  141. id="DataGridMateriel"
  142. data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
  143. <thead><tr>
  144. <th data-options="field:'物料',title:'物料',align:'center',sortable:false"></th>
  145. <th data-options="field:'项目',title:'项目',align:'center',sortable:false"></th>
  146. <th data-options="field:'条目类别',title:'条目类别',align:'center',sortable:false"></th>
  147. <th data-options="field:'组件',title:'组件',align:'center',sortable:false"></th>
  148. <th data-options="field:'名称',title:'名称',align:'left',sortable:false"></th>
  149. <th data-options="field:'组件数量',title:'组件数量',align:'center',sortable:false"></th>
  150. <th data-options="field:'组件单位',title:'组件单位',align:'center',sortable:false"></th>
  151. <th data-options="field:'组件报废率',title:'组件报废率',align:'center',sortable:false"></th>
  152. <th data-options="field:'工序报废率',title:'工序报废率',align:'center',sortable:false"></th>
  153. <th data-options="field:'组件条码',title:'组件条码',align:'center',sortable:false"></th>
  154. </tr>
  155. </thead>
  156. </table>
  157. </div>
  158. </div>
  159. </div>
  160. <script type="text/javascript">
  161. var pgColumns = [[
  162. { field: 'name', title: '属性', width: '150px', sortable: true, align: 'left' },
  163. { field: 'value', title: '值', width: '150px', resizable: false, align: 'left' }
  164. ]];
  165. function formatterUA(value, row, index) {
  166. return Math.round(value * 10000) / 100 + '%';
  167. }
  168. function getdate(value, row, index) {
  169. return new Date(value).getFullYear() + "-" + (new Date(value).getMonth() + 1) + "-" + new Date(value).getDate();
  170. }
  171. function stylerSet(value, row, index) {
  172. if (value != '') {
  173. return 'color:#00BBFF;text-decoration:underline;';
  174. }
  175. }
  176. $(document).ready(function () {
  177. var ctime = new Date();
  178. var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 00:00:00";
  179. var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + (ctime.getDate()) + " 23:59:59";
  180. $("#datebeginMasterS").datetimebox("setValue", beginDate);
  181. $("#datebeginMasterD").datetimebox("setValue", endDate);
  182. //var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
  183. //var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
  184. //$("#datebeginMasterG").datebox("setValue", beginDate);
  185. //$("#dateendMasterG").datebox("setValue", endDate);
  186. //tbSearchSubmit();
  187. });
  188. function dgDblclickcelldetail(index, field, value) {
  189. var row = $('#DataGrid').datagrid('getSelected', index);
  190. if (field == '生产入库单号' && value != '') {
  191. $.tabs.open({
  192. title: '生产入库单[' + value + ']',
  193. url: '/mes/pc/wmslog/wmslog_index.html?ss={LOGIDLINK:' + row["LOGIDLINK"] + '}'
  194. });
  195. }
  196. }
  197. //主表双击事件
  198. function dgDblclickrow(index, row) {
  199. $("#tableTabs").tabs("select", 1);
  200. LoadDataGridDetail(index, row);
  201. }
  202. //加载子表数据
  203. function LoadDataGridDetail(index, row) {
  204. var barcode = row["产品条码"];
  205. //产品追踪表
  206. $('#DataGridMaster').datagridLoad({
  207. title: '',
  208. idField: 'SID',
  209. queryParams: $('#ffMaster').serializeJson(),
  210. url: 'rpt.ashx?m=master&id=' + request('id') + '&barcodeDB=' + barcode,
  211. fixWidth: 160,
  212. mergeWidth: 100,
  213. splitChar: '_',
  214. columnMenu: '#btnColumnMenu',
  215. columnMoving: true,
  216. pagination: false
  217. });
  218. //产品属性表
  219. $('#PropertyGridDetail').datagridLoad({
  220. queryParams: $('#ffMaster').serializeJson(),
  221. url: 'rpt.ashx?m=property&barcodeDB=' + barcode,
  222. fixWidth: 160,
  223. mergeWidth: 100,
  224. //pageSize: 10,
  225. splitChar: '_',
  226. columnMenu: '#btnColumnMenu',
  227. columnMoving: true,
  228. pagination: false
  229. //method: 'get',
  230. //columns: pgColumns,
  231. //border: false,
  232. //showGroup: false,
  233. //scrollbarSize: 0
  234. });
  235. //物料信息表
  236. $('#DataGridMateriel').datagrid({
  237. title: '',
  238. idField: 'SID',
  239. queryParams: $('#ffMaster').serializeJson(),
  240. url: 'rpt.ashx?m=materiel&id=' + request('id') + '&barcodeDB=' + barcode,
  241. fixWidth: 160,
  242. mergeWidth: 100,
  243. Pagination: false,
  244. splitChar: '_',
  245. columnMenu: '#btnColumnMenu',
  246. columnMoving: true
  247. });
  248. }
  249. //搜索提交
  250. function tbSearchSubmit() {
  251. var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
  252. var barcode = $('#barcode').textbox('getValue');
  253. var IDNRKONLYCODE = $('#IDNRKONLYCODE').textbox('getValue');
  254. if (barcode.length > 0 || IDNRKONLYCODE.length > 0
  255. || ($("#datebeginMasterS").datetimebox("getValue") != "" && $("#datebeginMasterD").datetimebox("getValue") != "")
  256. || ($("#datebeginMasterG").datebox("getValue") != "" && $("#dateendMasterG").datebox("getValue") != "")) {
  257. if ($('#ffMaster').form("validate")) {
  258. if (index == 0) {
  259. $('#DataGrid').datagridLoad({
  260. title: '',
  261. idField: 'SID',
  262. queryParams: $('#ffMaster').serializeJson(),
  263. url: 'rpt.ashx?m=goods&id=' + request('id'),
  264. fixWidth: 160,
  265. mergeWidth: 100,
  266. splitChar: '_',
  267. columnMenu: '#btnColumnMenu',
  268. columnMoving: true
  269. });
  270. }
  271. if (index == 2 && (IDNRKONLYCODE.length > 0)) {
  272. //物料信息表
  273. $('#DataGridMateriel').datagrid({
  274. title: '',
  275. idField: 'SID',
  276. queryParams: $('#ffMaster').serializeJson(),
  277. url: 'rpt.ashx?m=materiel&id=' + request('id'),
  278. fixWidth: 160,
  279. mergeWidth: 100,
  280. Pagination: false,
  281. splitChar: '_',
  282. columnMenu: '#btnColumnMenu',
  283. columnMoving: true
  284. });
  285. }
  286. if ((index == 1 || index == 2 || index == 3) && barcode.length > 0) {
  287. //产品追踪表
  288. $('#DataGridMaster').datagridLoad({
  289. title: '',
  290. idField: 'SID',
  291. queryParams: $('#ffMaster').serializeJson(),
  292. url: 'rpt.ashx?m=master&id=' + request('id'),
  293. fixWidth: 160,
  294. mergeWidth: 100,
  295. splitChar: '_',
  296. columnMenu: '#btnColumnMenu',
  297. columnMoving: true
  298. });
  299. //产品属性表
  300. $('#PropertyGridDetail').datagridLoad({
  301. queryParams: $('#ffMaster').serializeJson(),
  302. url: 'rpt.ashx?m=property',
  303. fixWidth: 160,
  304. mergeWidth: 100,
  305. //pageSize: 10,
  306. splitChar: '_',
  307. columnMenu: '#btnColumnMenu',
  308. columnMoving: true,
  309. pagination: false
  310. //method: 'get',
  311. //columns: pgColumns,
  312. //border: false,
  313. //showGroup: false,
  314. //scrollbarSize: 0
  315. });
  316. //物料信息表
  317. $('#DataGridMateriel').datagridLoad({
  318. title: '',
  319. idField: 'SID',
  320. queryParams: $('#ffMaster').serializeJson(),
  321. url: 'rpt.ashx?m=materiel&id=' + request('id'),
  322. fixWidth: 160,
  323. mergeWidth: 100,
  324. pagination: false,
  325. splitChar: '_',
  326. columnMenu: '#btnColumnMenu',
  327. columnMoving: true
  328. });
  329. }
  330. }
  331. }
  332. else {
  333. $.messager.alert('搜索', "请填写交接时间或注浆日期范围", 'warning');
  334. return;
  335. }
  336. }
  337. //导出
  338. function tbExport() {
  339. var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
  340. var title = $('#tableTabs').tabs('getTab', index).panel('options').title;//表格名称
  341. var id = "DataGridMaster";
  342. if (index == 1) {
  343. id = "PropertyGridDetail";
  344. }
  345. //加载表头
  346. var fields = $('#' + id).datagrid('getColumnFields');
  347. var headers = [];
  348. for (var i = 0; i < fields.length; i++) {
  349. //headers.push($('#DataGridMaster').datagrid('getColumnOption', fields[i])['title']);
  350. headers.push(fields[i]);
  351. }
  352. $('#' + id).datagridExport({
  353. headers: headers,
  354. fileName: '导出数据(' + title + ').xls',
  355. workSheet: '导出数据(' + title + ')'
  356. });
  357. //导出多sheet
  358. //$.dataGridToExcel(
  359. // ['DataGridMaster', 'PropertyGridDetail'],
  360. // ['产品跟踪表', '产品信息'],
  361. // "导出数据(产品跟踪表).xls"
  362. //);
  363. }
  364. //搜索按钮
  365. function tbSearch() {
  366. $('#tbSearchDiv').toggle();
  367. $('#toolbarLayout').panel('resize', { height: 'auto' });
  368. $('body').layout('resize');
  369. $('#tableTabs').tabs('resize');
  370. }
  371. //刷新
  372. function tbReload() {
  373. tbSearchSubmit();
  374. }
  375. </script>
  376. </body>
  377. </html>