| | |
| | | <title>ç产计åæäº§</title> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all"> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | </head> |
| | | <body> |
| | |
| | | columns.push({ type: 'checkbox', fixed: 'left'}); |
| | | columns.push({ type: 'numbers', field: 'åºå·', title: 'åºå·'}); |
| | | columns.push({ field: 'åæ®å·', title: 'åæ®å·', hide: true}); |
| | | columns.push({ field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', width: 150}); |
| | | columns.push({ field: 'ç产订åå·', title: 'ç产订åå·', width: 150, style: 'background-color: #f9f9f9;' }); |
| | | columns.push({ field: '客æ·è®¢åå·', title: '客æ·è®¢åå·', width: 150, style: 'background-color: #f9f9f9;' }); |
| | | columns.push({ field: 'ç产ç»ç»', title: 'ç产ç»ç»', width: 150 }); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', width: 150}); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 150 }); |
| | | columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', width: 150, edit: 'text' }); |
| | | columns.push({ field: 'éå®è®¢åæ°é', title: 'éå®è®¢åæ°é', width: 150 });//0 |
| | | columns.push({ field: 'è®¡åæ°é', title: 'çäº§è®¢åæ°é', width: 150 });//0 |
| | | columns.push({ field: 'æ¥è®¡åæ°éæ»é', title: 'æ¥è®¡åæ°éæ»é', width: 150 });//0 |
| | | columns.push({ field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', width: 150, filter: true, sort: true}); |
| | | columns.push({ field: 'ç产订åå·', title: 'ç产订åå·', width: 150, style: 'background-color: #f9f9f9;', filter: true, sort: true }); |
| | | columns.push({ field: '客æ·è®¢åå·', title: '客æ·è®¢åå·', width: 150, style: 'background-color: #f9f9f9;', filter: true, sort: true }); |
| | | columns.push({ field: 'ç产ç»ç»', title: 'ç产ç»ç»', width: 150, filter: true, sort: true }); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', width: 150, filter: true, sort: true}); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150, filter: true, sort: true}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 150, filter: true, sort: true }); |
| | | columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', width: 150, edit: 'text', filter: true, sort: true }); |
| | | columns.push({ field: 'éå®è®¢åæ°é', title: 'éå®è®¢åæ°é', width: 150, filter: true, sort: true });//0 |
| | | columns.push({ field: 'è®¡åæ°é', title: 'çäº§è®¢åæ°é', width: 150, filter: true, sort: true });//0 |
| | | columns.push({ field: 'æ¥è®¡åæ°éæ»é', title: 'æ¥è®¡åæ°éæ»é', width: 150, filter: true, sort: true });//0 |
| | | columns.push({ field: '仿¥ä¹åæ¥è®¡åæ°é', title: '仿¥ä¹åæ¥è®¡åæ°é', width: 150 });//0 |
| | | columns.push({ field: '计åå¼å§æ¥æ', title: 'é¢è®¡å¼å·¥æ¥æ', width: 150, templet: "<div>{{d.计åå¼å§æ¥æ ==null ?'':layui.util.toDateString(d.计åå¼å§æ¥æ, 'yyyy-MM-dd')}}</div>" }); |
| | | columns.push({ field: '计åç»ææ¥æ', title: '计åç»ææ¥æ', width: 150, templet: "<div>{{d.计åç»ææ¥æ ==null ?'':layui.util.toDateString(d.计åç»ææ¥æ, 'yyyy-MM-dd')}}</div>", event: "HPlanEndDate" }); |
| | | columns.push({ field: '订å坿æ°é', title: '订å坿æ°é', width: 150 }); |
| | | columns.push({ field: 'æåæ°é', title: 'æåæ°é', width: 150, edit: 'text' }); |
| | | columns.push({ field: 'æ¨æ¥æ°é', title: 'æ¨æ¥æ°é' }); |
| | | columns.push({ field: 'ä¼å
级', title: 'ä¼å
级', width: 150, edit: 'text' }); |
| | | columns.push({ field: 'çäº§èµæº', title: 'çäº§èµæº', width: 150, edit: 'text', event: "HSourceID" }); |
| | | columns.push({ field: 'æä½å·¥', title: 'æä½å·¥', width: 150, edit: 'text', event: "HEmpID" }); |
| | | columns.push({ field: 'çäº§è®¢åæ¥æ', title: 'çäº§è®¢åæ¥æ', width: 150, templet: "<div>{{d.çäº§è®¢åæ¥æ ==null ?'':layui.util.toDateString(d.çäº§è®¢åæ¥æ, 'yyyy-MM-dd')}}</div>", filter: true, sort: true }); |
| | | columns.push({ field: '计åå¼å§æ¥æ', title: 'é¢è®¡å¼å·¥æ¥æ', width: 150, templet: "<div>{{d.计åå¼å§æ¥æ ==null ?'':layui.util.toDateString(d.计åå¼å§æ¥æ, 'yyyy-MM-dd')}}</div>", filter: true, sort: true }); |
| | | columns.push({ field: '计åç»ææ¥æ', title: '计åç»ææ¥æ', width: 150, templet: "<div>{{d.计åç»ææ¥æ ==null ?'':layui.util.toDateString(d.计åç»ææ¥æ, 'yyyy-MM-dd')}}</div>", event: "HPlanEndDate", filter: true, sort: true }); |
| | | columns.push({ field: '订å坿æ°é', title: '订å坿æ°é', width: 150, filter: true, sort: true}); |
| | | columns.push({ field: 'æåæ°é', title: 'æåæ°é', width: 150, edit: 'text', filter: true, sort: true }); |
| | | columns.push({ field: 'æ¨æ¥æ°é', title: 'æ¨æ¥æ°é', filter: true, sort: true }); |
| | | columns.push({ field: 'ä¼å
级', title: 'ä¼å
级', width: 150, edit: 'text', filter: true, sort: true }); |
| | | columns.push({ field: 'çäº§èµæº', title: 'çäº§èµæº', width: 150, edit: 'text', event: "HSourceID", filter: true, sort: true }); |
| | | columns.push({ field: 'æä½å·¥', title: 'æä½å·¥', width: 150, edit: 'text', event: "HEmpID", filter: true, sort: true }); |
| | | |
| | | var dateColumns = setInit_columnsData(); |
| | | var HArrangeProductDayQty = $("#HArrangeProductDayQty").val() * 1; |
| | |
| | | if (HICMOBillNo_ICMO) { |
| | | sWhere_ICMO += " and (客æ·è®¢åå· like '%" + HICMOBillNo_ICMO + "%' or åæ®å· like '%" + + HICMOBillNo_ICMO + "%')"; |
| | | } |
| | | sWhere_ICMO += " and ç¶æ like '%å¼å·¥%' or ç¶æ like '%计å确认%'"; |
| | | sWhere_ICMO += " and (ç¶æ like '%å¼å·¥%' or ç¶æ like '%计å确认%')"; |
| | | get_Display2(sWhere_ICMO); |
| | | sWhere_ICMO = ""//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | |
| | | shift: 2, |
| | | area: ['100%', '100%'], |
| | | maxmin: true, |
| | | content: 'ç产管ç/å¼å¸¸åé¦å/Sc_MESExecptFeedBackBillType.html', |
| | | content: '../../ç产管ç/å¼å¸¸åé¦å/Sc_MESExecptFeedBackBillType.html', |
| | | end: function () { |
| | | |
| | | }, |
| | |
| | | , { field: 'ç»ç»åç§°', title: 'ç»ç»åç§°', width: 120, sort: true, filter: true } |
| | | , { field: 'ç产车é´åç§°', title: 'ç产车é´åç§°', sort: true, filter: true } |
| | | , { field: 'çäº§èµæºåç§°', title: 'çäº§èµæºåç§°', width: 100, sort: true, filter: true } |
| | | , { field: 'ç产订åå·', title: 'ç产订åå·', sort: true, filter: true } |
| | | , { field: 'ç产订åå·', title: 'ç产订åå·', sort: true, filter: true } |
| | | , { field: '客æ·è®¢åå·', title: '客æ·è®¢åå·', sort: true, filter: true } |
| | | , { field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', sort: true, filter: true } |
| | | , { field: 'FCOLUMN9', title: 'çµå/åç/åºæ¿', sort: true, filter: true } |
| | | , { field: '订å交æ', title: '订å交æ', templet: "<div>{{d.订å交æ ==null ?'':layui.util.toDateString(d.订å交æ, 'yyyy-MM-dd')}}</div>", sort: true, filter: { type: 'date[yyyy-MM-dd HH:mm:ss]' } } |
| | |
| | | if (result.count == 1) { |
| | | data = result.data; |
| | | |
| | | option.data = data; |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | |
| | | ins = table.render(option); |
| | | |
| | | data.forEach((item) => { |
| | | for (let itemobj in item) { |
| | | if (item[itemobj] == null) { |
| | | item[itemobj] = ""; |
| | | } |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | table.exportFile('mainTable', data, "xls"); |
| | | |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | |
| | | <title>ææè®¡åæ¥è¡¨(éè´è®¢å维度)</title> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all"> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | </head> |
| | | <body> |
| | |
| | | function set_InitGrid() { |
| | | var columns = []; |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true}); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼', sort: true}); |
| | | columns.push({ field: 'ä¾åºå', title: 'ä¾åºå', sort: true}); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true}); |
| | | columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true}); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éå®è®¢åå·', sort: true}); |
| | | columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦', sort: true }); |
| | | columns.push({ field: 'HPOOrderBillNote', title: '夿³¨', sort: true}); |
| | | columns.push({ field: 'éè´å', title: 'éè´å', sort: true}); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', sort: true}); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true}); |
| | | columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true}); |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true, filter: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true}); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true, filter: true}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼', sort: true, filter: true}); |
| | | columns.push({ field: 'ä¾åºå', title: 'ä¾åºå', sort: true, filter: true}); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true, filter: true }); |
| | | columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, filter: true }); |
| | | columns.push({ field: '客æ·è®¢åå·', title: '客æ·è®¢åå·', sort: true, filter: true }); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éå®è®¢åå·', sort: true, filter: true}); |
| | | columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦', sort: true, filter: true }); |
| | | columns.push({ field: 'HPOOrderBillNote', title: '夿³¨', sort: true, filter: true}); |
| | | columns.push({ field: 'éè´å', title: 'éè´å', sort: true, filter: true}); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', sort: true, filter: true}); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true, filter: true}); |
| | | columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true}); |
| | | |
| | | //è·å两个ææä¹é´çç¸å·® |
| | | var time1 = Date.parse(new Date($("#HBEGINDATE").val()));//å¼å§æ¶é´ |
| | |
| | | } |
| | | } |
| | | |
| | | columns.push({ field: 'ææè®¡åå计', title: 'ææè®¡åå计' }); |
| | | columns.push({ field: 'ææè®¡åå计', title: 'ææè®¡åå计', filter: true }); |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_Process/list', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "user": 'ç¿æ¶æ¶'}, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]}, |
| | | async: false, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |