WebTM/views/生产管理/日计划报表/ReportPODemandPlanBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebTM/views/生产管理/日计划报表/ReportPODemandPlanBillList_S.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportPODemandPlanBillList.html
@@ -88,89 +88,6 @@ </div> <hr /> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent"> </div> </div> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> </div> </div> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> </div> </div> </div> </div> </div> @@ -421,80 +338,6 @@ var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå var HXQD = $("#HXQD").val();//éæ±åå· var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå· var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var ColName1 = $("#ColName1").val();//å¤éæ¡ var Comparator1 = $("#Comparator1").val() var ColContent1 = $("#ColContent1").val(); var ColName2 = $("#ColName2").val();//å¤éæ¡ var Comparator2 = $("#Comparator2").val() var ColContent2 = $("#ColContent2").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (ColName1 != 0 && Comparator1 != 0) { var com1 = ""; switch (Comparator1) { case "7": com1 = "like'%" + ColContent1 + "%'"; break; case "8": com1 = "like'%" + ColContent1 + "'"; break; case "9": com1 = "like'" + ColContent1 + "%'"; break; case "10": com1 = "not like'%" + ColContent1 + "%'"; break; default: com1 = "" + Comparator1 + "'" + ColContent1 + "'"; break; } sWhere += " and " + ColName1 + " " + com1; } if (ColName2 != 0 && Comparator2 != 0) { var com2 = ""; switch (Comparator2) { case "7": com2 = "like'%" + ColContent2 + "%'"; break; case "8": com2 = "like'%" + ColContent2 + "'"; break; case "9": com2 = "like'" + ColContent2 + "%'"; break; case "10": com2 = "not like'%" + ColContent2 + "%'"; break; default: com2 = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName2 + " " + com2; } if (HBEGINDATE > HENDDATE) { return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); } @@ -526,15 +369,6 @@ $("#HSUPPLIERNAME").val(""); $("#HXQD").val("");//éæ±åå· $("#HPURORDERNO").val("");//éè´è®¢åå· $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); $("#ColContent1").val(""); $("#ColName1").val("0"); $("#Comparator1").val("0"); $("#ColContent2").val(""); $("#ColName2").val("0"); $("#Comparator2").val("0"); form.render('select'); sWhere = ""; } @@ -573,7 +407,7 @@ , area: ['90%', '90%']//å¤§å° , title: 'ä¾åºåå表'//æ é¢ , shift: 2//å¼¹åºå¨ç» , content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html', 'yes'] , content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html?Type=HSup', 'yes'] , btn: ['ç¡®å®', 'åæ¶'] , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ @@ -605,110 +439,6 @@ table.exportFile(ins.config.id, data, "xls"); } //éèå设置 function get_HideColumn() { var colName = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { if (dataCol[i]) { var dataCols = dataCol[i].split('|'); } //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //å使å¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } //åææ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; @@ -729,4 +459,12 @@ //#endregion //以䏿¯layui模å }); function GetHSupNameValue(obj) { $("#HSUPPLIERID").val(obj[0].HItemID); $("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°); } function GetGyMaterial(obj) { $("#HMATERIALID").val(obj.HItemID); $("#HMATERIALNAME").val(obj.ç©æåç§°); } </script> WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportPODemandPlanBillList_S.html
@@ -89,90 +89,6 @@ </div> </div> </div> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent"> </div> </div> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> </div> </div> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> </div> </div> </div> </div> </div> @@ -566,81 +482,6 @@ var HXQD = $("#HXQD").val();//éæ±åå· var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå· var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var ColName1 = $("#ColName1").val();//å¤éæ¡ var Comparator1 = $("#Comparator1").val() var ColContent1 = $("#ColContent1").val(); var ColName2 = $("#ColName2").val();//å¤éæ¡ var Comparator2 = $("#Comparator2").val() var ColContent2 = $("#ColContent2").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (ColName1 != 0 && Comparator1 != 0) { var com1 = ""; switch (Comparator1) { case "7": com1 = "like'%" + ColContent1 + "%'"; break; case "8": com1 = "like'%" + ColContent1 + "'"; break; case "9": com1 = "like'" + ColContent1 + "%'"; break; case "10": com1 = "not like'%" + ColContent1 + "%'"; break; default: com1 = "" + Comparator1 + "'" + ColContent1 + "'"; break; } sWhere += " and " + ColName1 + " " + com1; } if (ColName2 != 0 && Comparator2 != 0) { var com2 = ""; switch (Comparator2) { case "7": com2 = "like'%" + ColContent2 + "%'"; break; case "8": com2 = "like'%" + ColContent2 + "'"; break; case "9": com2 = "like'" + ColContent2 + "%'"; break; case "10": com2 = "not like'%" + ColContent2 + "%'"; break; default: com2 = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName2 + " " + com2; } if (HBEGINDATE > HENDDATE) { return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); } @@ -682,15 +523,6 @@ $("#HSUPPLIERNAME").val(""); $("#HXQD").val("");//éæ±åå· $("#HPURORDERNO").val("");//éè´è®¢åå· $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); $("#ColContent1").val(""); $("#ColName1").val("0"); $("#Comparator1").val("0"); $("#ColContent2").val(""); $("#ColName2").val("0"); $("#Comparator2").val("0"); form.render('select'); sWhere = " where 1=1 "; } @@ -729,7 +561,7 @@ , area: ['90%', '90%']//å¤§å° , title: 'ä¾åºåå表'//æ é¢ , shift: 2//å¼¹åºå¨ç» , content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html', 'yes'] , content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html?Type=HSup', 'yes'] , btn: ['ç¡®å®', 'åæ¶'] , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ @@ -764,140 +596,15 @@ form.render('select'); } //#region éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["field"] + ","; } var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ var urlLen = urlStr.split('/'); for (var i = 0; i < urlLen.length - 4; i++) { contentUrl += "../"; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName; layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º , content: [contentUrl, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //#endregion //#region æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { titleData = []; var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® var newCols = [[]];//å¯¹åºæ°æ®åºå顺åºcol newCols[0].push(option.cols[0][0]);//æ¾å ¥ç¬¬ä¸ä¸ªcheckbox dataCol = data1.data[0].HGridString.split(','); //åè®¾ç½®åæ°ä¸é¡µé¢åæ°æ¯å¦ä¸è´ if (dataCol.length == option.cols[0].length - 1) { //éå寻æ¾å设置对åºåæé¡ºåºæå ¥ for (var j = 0; j < option.cols[0].length - 1; j++) { for (var i = 0; i < option.cols[0].length - 1; i++) { var dataCols = dataCol[j].split('|'); //éæ©ä¸datacolsç¸åºåè¿è¡ä¿®æ¹ if (option.cols[0][i + 1]["field"] == dataCols[5]) { //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //ç»è®¡å if (dataCols[6] == 1) { option.cols[0][i + 1]["totalRow"] = true; } //å使å¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } //è®¾ç½®è¡¨æ ¼title屿§æ¾ç¤ºå«å if (dataCols[4] != null && dataCols[4] != "") { option.cols[0][i + 1]["title"] = dataCols[4]; } newCols[0].push(option.cols[0][i + 1]); } } } //éå循ç¯å夿坹åºåæ°æ¯å¦ä¸è´ if (dataCol.length == newCols[0].length - 1) { option.cols = newCols; //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } //#endregion //#endregion //以䏿¯layui模å }); function GetHSupNameValue(obj) { $("#HSUPPLIERID").val(obj[0].HItemID); $("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°); } function GetGyMaterial(obj) { $("#HMATERIALID").val(obj.HItemID); $("#HMATERIALNAME").val(obj.ç©æåç§°); } </script>