| | |
| | | <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 }); |
| | |
| | | } |
| | | option.data = dataPush; |
| | | table.render(option); |
| | | |
| | | //è·å䏿¹æäº§åè¡¨æ°æ®,ç¨äºå¯¹æ¯ä¸æ¹ç产订åå表ï¼å°ä¸æ¹ç产订åå表ç¸åçæ°æ®ä¸æ¾ç¤º |
| | | var compareList = []; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | var temp = option.data[i]["æºå主å
ç "] + "|" + option.data[i]["æºååå
ç "]; |
| | | compareList.push(temp); |
| | | } |
| | | |
| | | //åé¤ä¸æ¹æäº§å表ä¸å·²ç»å å
¥çç产订å |
| | | var tables = []; |
| | | for (var i = 0; i < option2.data.length; i++) { |
| | | var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"]; |
| | | if ($.inArray(temp, compareList) == -1) { |
| | | tables.push(option2.data[i]); |
| | | } |
| | | } |
| | | option2.data = tables; |
| | | |
| | | //éæ°æ¸²æå表2 |
| | | table.render(option2); |
| | | |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | |
| | | if (checkStatus.data.length != 1) { |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®"); |
| | | } |
| | | OptionData = checkStatus.data[0]; |
| | | OptionData[0] = checkStatus.data[0]; |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | , end: function () { |
| | |
| | | break; |
| | | } |
| | | if (option.data[i]["LAY_CHECKED"] == true) { |
| | | option.data[i]["HSourceID"] = OptionData.HItemID; |
| | | option.data[i]["çäº§èµæº"] = OptionData.çäº§èµæºåç§°; |
| | | option.data[i]["HSourceID"] = OptionData[0].HItemID; |
| | | option.data[i]["çäº§èµæº"] = OptionData[0].çäº§èµæºåç§°; |
| | | num += 1; |
| | | } |
| | | } |
| | |
| | | if (checkStatus.data.length != 1) { |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®"); |
| | | } |
| | | OptionData = checkStatus.data[0]; |
| | | OptionData[0] = checkStatus.data[0]; |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | obj.update({ |
| | | "HSourceID": checkStatus.data[0].HItemID |
| | |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | , end: function () { |
| | | obj.update({ |
| | | "HSourceID": OptionData.HItemID |
| | | , "çäº§èµæº": OptionData.çäº§èµæºåç§° |
| | | }) |
| | | if (OptionData.length > 0) { |
| | | obj.update({ |
| | | "HSourceID": OptionData[0].HItemID |
| | | , "çäº§èµæº": OptionData[0].çäº§èµæºåç§° |
| | | }) |
| | | OptionData = []; |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | obj.event = ""; |
| | | return false; |
| | | } |
| | | } else if (event.key == "F8") { |
| | | //çäº§èµæº |
| | | if (obj.event == "HSourceID") { |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "çäº§èµæºå表" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["90%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ["../../Baseset/åºç¡èµæ/Gy_Source.html?HMaterID=" + obj.data["HMaterID"], "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //æé®ä¸ çåè° |
| | | var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ® |
| | | |
| | | if (checkStatus.data.length != 1) { |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®"); |
| | | } |
| | | OptionData[0] = checkStatus.data[0]; |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | obj.update({ |
| | | "HSourceID": checkStatus.data[0].HItemID |
| | | , "çäº§èµæº": checkStatus.data[0].HName |
| | | }) |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | , end: function () { |
| | | if (OptionData.length > 0) { |
| | | obj.update({ |
| | | "HSourceID": OptionData[0].HItemID |
| | | , "çäº§èµæº": OptionData[0].HName |
| | | }) |
| | | OptionData = []; |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | obj.event = ""; |
| | | } |
| | | }) |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | //æ¥è¯¢æªæäº§çç产订å |
| | | function get_Display2(sWhere_ICMO) { |
| | | var ajaxLoad = layer.load(); |
| | |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn_ICMO(); |
| | | |
| | | |
| | | //è·å䏿¹æäº§åè¡¨æ°æ®,ç¨äºå¯¹æ¯ä¸æ¹ç产订åå表ï¼å°ä¸æ¹ç产订åå表ç¸åçæ°æ®ä¸æ¾ç¤º |
| | | var compareList = []; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | var temp = option.data[i]["æºå主å
ç "] + "|" + option.data[i]["æºååå
ç "]; |
| | | compareList.push(temp); |
| | | } |
| | | |
| | | //åé¤ä¸æ¹æäº§å表ä¸å·²ç»å å
¥çç产订å |
| | | var tables = []; |
| | | for (var i = 0; i < option2.data.length; i++) { |
| | | var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"]; |
| | | if ($.inArray(temp, compareList) == -1) { |
| | | tables.push(option2.data[i]); |
| | | } |
| | | } |
| | | option2.data = tables; |
| | | |
| | | //éæ°æ¸²æå表2 |
| | | table.render(option2); |
| | | |
| | | layer.close(ajaxLoad); |
| | | //if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | |
| | | }) |
| | | } |
| | | |
| | | 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') |
| | |
| | | // obj[key] = value; |
| | | //} |
| | | //è·åå¾éä¸çå¾
æç产订å |
| | | //è·åæ°æ® |
| | | var hmainid = []; |
| | | //var HEntryID = []; |
| | | for (var i = 0; i < checkStatus.data.length; i++) { |
| | | var newObj = { |
| | | "HMaterID" : data[i].HMaterID, |
| | | "HProdORGID" : data[i].HPRDORGID, |
| | | "HUnitID" : data[i].HUnitID, |
| | | "HWorkShopID" : data[i].HDeptID, |
| | | "æåæ°é" : data[i].ç产任å¡åæ°é, |
| | | "æºå主å
ç " : data[i].hmainid, |
| | | "æºååå
ç " : data[i].HEntryID, |
| | | "ç©æä»£ç " : data[i].产å代ç , |
| | | "ç©æåç§°" : data[i].产ååç§°, |
| | | "ç产ç»ç»": data[i].ç产ç»ç», |
| | | "ç产订ååæ®ç±»å" : data[i].åæ®ç±»å, |
| | | "ç产订åå·" : data[i].åæ®å·, |
| | | "ç产订åæç»è¡å·" : data[i].HEntryID, |
| | | "ç产车é´" : data[i].ç产车é´, |
| | | "è§æ ¼åå·" : data[i].è§æ ¼åå·, |
| | | "计åå¼å§æ¥æ" : data[i].计åå¼å·¥æ¥æ, |
| | | "è®¡åæ°é" : data[i].ç产任å¡åæ°é, |
| | | "计åç»ææ¥æ" : data[i].计åå®å·¥æ¥æ, |
| | | "计éåä½" : data[i].计éåä½, |
| | | "订å坿æ°é" : data[i].ç产任å¡åæ°é, |
| | | "订åç级" : data[i].订åç级, |
| | | "订åç±»å" : data[i].åæ®ç±»å, |
| | | "éå®è®¢åå·" : data[i].éå®è®¢åå·, |
| | | "éå®è®¢åæ°é" : data[i].é宿°é |
| | | } |
| | | |
| | | option.data.push(newObj); |
| | | table.render(option) |
| | | } |
| | | |
| | | //è·å䏿¹æäº§åè¡¨æ°æ®,ç¨äºå¯¹æ¯ä¸æ¹ç产订åå表ï¼å°ä¸æ¹ç产订åå表ç¸åçæ°æ®ä¸æ¾ç¤º |
| | | var compareList = []; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | var temp = option.data[i]["æºå主å
ç "] + "|" + option.data[i]["æºååå
ç "]; |
| | | compareList.push(temp); |
| | | } |
| | | |
| | | //åé¤ä¸æ¹æäº§å表ä¸å·²ç»å å
¥çç产订å |
| | | var tables = []; |
| | | for (var i = 0; i < option2.data.length; i++) { |
| | | var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"]; |
| | | if ($.inArray(temp, compareList) == -1) { |
| | | tables.push(option2.data[i]); |
| | | if ($.inArray(checkStatus.data[i]["hmainid"] + '_' + checkStatus.data[i]["HEntryID"], hmainid) == -1) { |
| | | hmainid.push(checkStatus.data[i]["hmainid"] + '_' + checkStatus.data[i]["HEntryID"]); |
| | | } |
| | | } |
| | | option2.data = tables; |
| | | |
| | | //éæ°æ¸²æå表2 |
| | | table.render(option2); |
| | | //æ¥è¯¢ç产订å |
| | | SelectICMOBill(hmainid); |
| | | |
| | | //var wait = layer.load(); |
| | | ////é»è¾æ¹æ³ |
| | |
| | | |
| | | //åå»è¿åçäº§èµæº |
| | | function GetGySource(data) { |
| | | OptionData = data |
| | | OptionData[0] = data |
| | | } |
| | | |
| | | </script> |