| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Routing"><i class="layui-icon layui-icon-form"></i>å·¥èºè·¯çº¿</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Calendar"><i class="layui-icon layui-icon-form"></i>工忥å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | </div> |
| | | </script> |
| | | <script type="text/html" id="toolbarDemo2"> |
| | |
| | | , excel = layui.excel |
| | | , soulTable = layui.soulTable |
| | | , element = layui.element; |
| | | |
| | | var ins; |
| | | var sWhere = ""; |
| | | var sWhere_ICMO = ""; |
| | | var option = []; |
| | |
| | | case 'set_Calendar': |
| | | set_Calendar(); |
| | | break; |
| | | break; |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | } |
| | | }); |
| | | |
| | |
| | | if (table.cache["mainTable"][i] != "") { |
| | | if (parseFloat(table.cache["mainTable"][i]["ä¼å
级"]) == 0) { |
| | | HYxjQty++ |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (HYxjQty > 0) { |
| | |
| | | columns.push({ field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', width: 150, sort: true }); |
| | | columns.push({ field: 'ç产订åå·', title: 'ç产订åå·', width: 150, style: 'background-color: #f9f9f9;', sort: true }); |
| | | columns.push({ field: 'ç产订åæç»è¡å·', title: 'ç产订åæç»è¡å·', width: 150, sort: true }); |
| | | columns.push({ field: 'ç产ç»ç»', title: 'ç产ç»ç»', width: 150, sort: true }); |
| | | columns.push({ field: 'HMaterID', title: 'HMaterID', hide: true }); |
| | | columns.push({ field: 'ç产ç»ç»', title: 'ç产ç»ç»', width: 150, sort: true }); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', width: 150, sort: true }); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150, sort: true }); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 150, sort: true }); |
| | | columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', width: 150, sort: true, edit: 'text' }); |
| | | columns.push({ field: 'éå®è®¢åæ°é', title: 'éå®è®¢åæ°é', width: 150, sort: true });//0 |
| | | columns.push({ field: 'è®¡åæ°é', title: 'çäº§è®¢åæ°é', width: 150, sort: true });//0 |
| | | columns.push({ field: 'æ¥è®¡åæ°éæ»é', title: 'æ¥è®¡åæ°éæ»é', width: 150, sort: true });//0 |
| | |
| | | columns.push({ field: '订åç级', title: '订åç级', width: 150, sort: true }); |
| | | columns.push({ field: '订å交货æ', title: '订å交货æ', width: 150, templet: "<div>{{d.订å交货æ =='1900-01-01' ?'':layui.util.toDateString(d.订å交货æ, 'yyyy-MM-dd')}}</div>", sort: true }); |
| | | columns.push({ field: '订åéæ±æ°é', title: '订åéæ±æ°é', width: 150, sort: true }); |
| | | columns.push({ field: 'å¼å·¥ä½é', title: 'å¼å·¥ä½é', width: 150, sort: true }); |
| | | columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', width: 150, sort: true, edit: 'text' }); |
| | | columns.push({ field: 'å¼å·¥ä½é', title: 'å¼å·¥ä½é', width: 150, sort: true }); |
| | | columns.push({ field: 'çäº§å¨æ', title: 'çäº§å¨æ', width: 150, sort: true }); |
| | | columns.push({ field: 'æè¿å¼å·¥æ¥æ', title: 'æè¿å¼å·¥æ¥æ', width: 150, templet: "<div>{{d.æè¿å¼å·¥æ¥æ =='' ?'':layui.util.toDateString(d.æè¿å¼å·¥æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true }); |
| | | columns.push({ field: 'æè¿å®å·¥æ¥æ', title: 'æè¿å®å·¥æ¥æ', width: 150, templet: "<div>{{d.æè¿å®å·¥æ¥æ =='' ?'':layui.util.toDateString(d.æè¿å®å·¥æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true }); |
| | |
| | | columns.push({ field: 'HGroupName', title: 'HGroupName', width: 150, hide:true }); |
| | | columns.push({ field: 'çäº§èµæºä»£ç ', title: 'çäº§èµæºä»£ç ', width: 150, hide: true }); |
| | | columns.push({ field: 'HSourceID', title: 'HSourceID', hide: true }); |
| | | |
| | | columns.push({ field: 'HMaterID', title: 'HMaterID', hide: true }); |
| | | columns.push({ field: 'HWorkShopID', title: 'HWorkShopID', hide: true }); |
| | | columns.push({ field: 'HUnitID', title: 'HUnitID', hide: true }); |
| | | columns.push({ field: 'HProdORGID', title: 'HProdORGID', hide: true }); |
| | |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | var HinterID_S = []; |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | HinterID_S.push(data1.data[i]["hmainid"]); |
| | |
| | | } |
| | | if (isNaN(data[i]["HSourceID"])) { |
| | | return layer.msg("éæ©çäº§èµæº!!") |
| | | } |
| | | } |
| | | HICOMNum.push(data[i]["HICMOInterID"] + ";" + data[i]["HICMOEntryID"] + ";" + data[i]["HSourceID"]); |
| | | } |
| | | |
| | | $('#HProgressBar').html(` |
| | | <div class="layui-progress" lay-filter="demo-filter-progress"> |
| | | <div class="layui-progress-bar" lay-percent="40%"></div> |
| | |
| | | |
| | | table.render(option); |
| | | |
| | | data = table.cache["mainTable"]; |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (parseFloat(data[i]["å°æ¶äº§è½"]) == 0 || parseFloat(data[i]["å°æ¶äº§è½"]) == null || parseFloat(data[i]["å°æ¶äº§è½"]) == undefined) { |
| | | return layer.alert("第" + (i + 1) + 'è¡ï¼å°æ¶äº§è½æªè®¾ç½®ï¼è¯·æ ¸å¯¹æ°æ®ã' + '</br>' + '1.ç©ææªæ·»å å·¥èºè·¯çº¿' + '</br>' + '2.å·¥èºè·¯çº¿ä¸æªè®¾ç½®å°æ¶äº§è½' + '</br>' + '3.çäº§èµæºæªè®¾ç½®åçå·¥æ¶' + '</br>' + '4.çäº§èµæºä¸ç»å®å·¥ä½ä¸å¿ä¸å·¥èºè·¯çº¿ä¸è®¾ç½®çå·¥ä½ä¸å¿ä¸ä¸è´'); |
| | | } |
| | | } |
| | | |
| | | } else { |
| | | //layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | |
| | | }) |
| | | } |
| | | |
| | | function get_Export() { |
| | | var data = option.data |
| | | data.forEach((item) => { |
| | | // 妿æä¸ªå段çå¼å¤ªé¿ï¼éè¦å»é¤æ¢è¡ç¬¦ |
| | | if (item.è§æ ¼åå·.length > 0) { // åè®¾åæ®µå为field |
| | | item.è§æ ¼åå· = item.è§æ ¼åå·.replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | item.è§æ ¼åå· = item.è§æ ¼åå·.replace(/[,]+/g, 'ï¼'); // å°æ¢åå·æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | }); |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | } |
| | | |
| | | //æäº§åè½ |
| | | function set_Arrangement() { |
| | | var checkStatus = table.checkStatus('mainTable_ICMO') |