| | |
| | | <html> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>ç½å¯åå¸æç»æ¥è¡¨</title> |
| | | <title>æåæ±æ»æ¥è¡¨</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <label class="layui-form-label">ç¶æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;width: 184px;"> |
| | | <select name="HState" lay-verify="HState" id="HState"> |
| | | <option value="0" selected="selected">å
¨é¨</option> |
| | | <option value="1">æªå¼å·¥</option> |
| | | <option value="3">å·²å
¥åº</option> |
| | | </select> |
| | | </div> |
| | | </div>--> |
| | | <label class="layui-form-label">ç¶æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;width: 184px;"> |
| | | <select name="HState" lay-verify="HState" id="HState"> |
| | | <option value="0" selected="selected">å
¨é¨</option> |
| | | <option value="1">æªå¼å·¥</option> |
| | | <option value="3">å·²å
¥åº</option> |
| | | </select> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å计å
¬æ¤æ°</label> |
| | | <div class="layui-inline" style="display:none;"> |
| | | <label class="layui-form-label">ç½å¯åå¸å计å
¬æ¤æ°</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="SumHMaterOutQty" id="SumHMaterOutQty" disabled="disabled"> |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <div style="padding-left: 10px;"> |
| | | <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="æªä¸æ¨åå·²å
¥åº"> |
| | | <div class="layui-inline" style="display:none;"> |
| | | <label class="layui-form-label">æååºç«å计å
¬æ¤æ°</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="SumDyeColorOut" id="SumDyeColorOut" disabled="disabled"> |
| | | </div> |
| | | </div>--> |
| | | </div> |
| | | <div class="layui-inline" style="display:none;"> |
| | | <label class="layui-form-label">å·®é¢</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="SumCompare" id="SumCompare" disabled="disabled"> |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <div style="padding-left: 10px;"> |
| | | <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="æªä¸æ¨åå·²å
¥åº"> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:10px;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <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> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-detail"><i class="layui-icon layui-icon-return"></i>æç»æ¥è¡¨</button> |
| | |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "MaterOutSumReport_Cloth"; |
| | | var HModName = "ProdProcessSumReport_DyeColor"; |
| | | |
| | | var titleData = ["HCusID"];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | //æç»æ¥è¡¨ |
| | | case 'btn-detail': |
| | | get_EntryReport(); |
| | | break; |
| | | }; |
| | | }); |
| | | //éç½®æé® |
| | |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | //è¡çå¬äºä»¶ |
| | | table.on('row(mainTable)', function (obj) { |
| | | var flag = !obj.tr.find(':checkbox:first').prop('checked'); |
| | | obj.tr.find(':checkbox').prop('checked', flag); |
| | | if (flag) { |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² |
| | | } else { |
| | | obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è² |
| | | } |
| | | //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = flag; |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | //è¡çå¬äºä»¶-åå» |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | //éä¸é«äº® åå»è¡ |
| | | obj.tr.find(':checkbox').prop('checked', true); |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² |
| | | //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = true; |
| | | } |
| | | }); |
| | | |
| | | //䏿¨ |
| | | var sBillNo = obj.data["ç产订åå·"]; |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['90%', '90%'] |
| | | , title: 'æåæç»æ¥è¡¨' |
| | | , closeBtn: 1 |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: 'Kf_ProdProcessEntryReport_DyeColor.html?sBillNo=' + sBillNo |
| | | , resize: false |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , end: function () { |
| | | //å·æ°é¡µé¢, |
| | | //location.reload(); |
| | | } |
| | | , cancel: function () { |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | }) |
| | | |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | |
| | | com = " and (" + ColName + " " + com + ")"; |
| | | } |
| | | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | var OtherSearch = getSWhereByHUser(); |
| | | |
| | | |
| | | sWhere = { |
| | | HBeginDate: HBeginDate |
| | | , HEndDate: HEndDate |
| | |
| | | , HProductName: HProductName |
| | | , HProductModel: HProductModel |
| | | , RandomSearch: com |
| | | , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch |
| | | } |
| | | sWhere = JSON.stringify(sWhere); |
| | | |
| | |
| | | url: GetWEBURL() + "/ProdProcessSumReport/ProdProcessSumReport_DyeColor", |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere }, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | //async: false, |
| | | success: function (data1) { |
| | | |
| | | if (data1.count == 1) { |
| | | |
| | | var totalArray = ["ç产任å¡åæ°é", "ç½å¯åå¸"]; |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | |
| | | } |
| | | |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'radio', fixed: 'left' }); |
| | | col.push({ type: 'checkbox', fixed: 'left' }); |
| | | for (var i = 0; i < data.length; i++) { |
| | | if ($.inArray(data[i].name, "") > -1) { |
| | | if ($.inArray(data[i].name, titleData) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } |
| | | else if ($.inArray(data[i].name, totalArray) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); |
| | | } |
| | | else if (data[i].ColName == 'ç½å¯åå¸') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | |
| | | , cols: [col] |
| | | , data: data1.data |
| | | }; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | } else { |
| | | option = { |
| | | elem: '#mainTable' |
| | |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 160 } |
| | | , { field: 'ä¸å¡å', title: 'ä¸å¡å', width: 160 } |
| | | , { field: '客æ·', title: '客æ·', width: 160 } |
| | | , { field: 'ç产任å¡åæ°é', title: 'ç产任å¡åæ°é', width: 200 } |
| | | , { field: 'ç产任å¡åæ°é', title: 'ç产任å¡åæ°é', totalRow: true, width: 200 } |
| | | , { field: 'ç½å¯åå¸', title: 'ç½å¯åå¸', width: 160, totalRow: true } |
| | | , { field: 'æ¯å¦ä¸æ¨çææµè½¬å¡', title: 'æ¯å¦ä¸æ¨çææµè½¬å¡', width: 160 } |
| | | ]] |
| | | , done: function (res) { |
| | | } |
| | | }; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | |
| | | }) |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | //ååæ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |
| | | for (var i = 0; i < option.cols[0].length; i++) { |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | if (option.cols[0][i].hide != true) { |
| | | Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; |
| | | } |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/ProdProcessSumReport/ProdProcessSumReport_DyeColor', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //è°æ´æ¥ææ ¼å¼ï¼æ¾ç¤º å¹´ææ¥ å æ¶ |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | data1.data[i].çäº§è®¢åæ¥æ = data1.data[i]["çäº§è®¢åæ¥æ"].split(":")[0] + ':' + data1.data[i]["çäº§è®¢åæ¥æ"].split(":")[1]; |
| | | data1.data[i].çäº§è®¢åæ¥æ = data1.data[i]["çäº§è®¢åæ¥æ"].replace("T", " "); |
| | | if (data1.data[i].çäº§è®¢åæ¥æ!=null) { |
| | | data1.data[i].çäº§è®¢åæ¥æ = data1.data[i]["çäº§è®¢åæ¥æ"].split("T")[0]; |
| | | } |
| | | } |
| | | |
| | | option.data = data1.data; |
| | |
| | | // } |
| | | // } |
| | | //} |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | |
| | | //计ç®å计å
¬æ¤æ° |
| | | //计ç®ç½å¯åå¸å计å
¬æ¤æ° |
| | | var sumHMaterOutQty = 0; |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | sumHMaterOutQty += data1.data[i]["ç½å¯åå¸"]; |
| | | } |
| | | $("#SumHMaterOutQty").val(sumHMaterOutQty); |
| | | |
| | | //è®¡ç®æååºç«å计å
¬æ¤æ° |
| | | var sumDyeColorOut = 0; |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | sumDyeColorOut += data1.data[i]["æååºç«"]; |
| | | } |
| | | $("#SumDyeColorOut").val(sumDyeColorOut); |
| | | |
| | | //计ç®å·®é¢ |
| | | var sumCompare = sumHMaterOutQty - sumDyeColorOut; |
| | | $("#SumCompare").val(sumCompare); |
| | | |
| | | |
| | | layer.close(wait); |
| | | } else { |
| | |
| | | com = " and (" + ColName + " " + com + ")"; |
| | | } |
| | | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | var OtherSearch = getSWhereByHUser(); |
| | | |
| | | |
| | | sWhere = { |
| | | HBeginDate: HBeginDate |
| | | , HEndDate: HEndDate |
| | | ,HMaterNumber: HMaterNumber |
| | | , HMaterNumber: HMaterNumber |
| | | , HBillNo: HBillNo |
| | | , HProductName: HProductName |
| | | , HProductModel: HProductModel |
| | | , RandomSearch:com |
| | | , RandomSearch: com |
| | | , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch |
| | | } |
| | | //set_InitGrid(JSON.stringify(sWhere)); |
| | | get_Display(JSON.stringify(sWhere)); |
| | |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | var ModRightNameCheck = "Kf_ProdProcessSumReport_DyeColor_ExportExcel"; |
| | | |
| | | //é»è¾å®¡æ ¸æ¹æ³ |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } else { |
| | | layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | |
| | | if (data1.data.length != 0) { |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | /*var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å±*/ |
| | | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | |
| | | }) |
| | | } |
| | | |
| | | //æç»æ¥è¡¨ |
| | | function get_EntryReport() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®ç¼è¾ï¼'); |
| | | } |
| | | } |
| | | |
| | | |
| | | //#region æ ¹æ®ç¨æ·è·åç¨æ·å
³è客æ·çè¿æ»¤æ¡ä»¶ |
| | | function getSWhereByHUser() { |
| | | var res = ""; |
| | | $.ajax({ |
| | | type: "GET", |
| | | async: false, |
| | | url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | res = result.data; |
| | | } else { |
| | | res = result.data; |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (err) { |
| | | res = " and 1 = 0"; |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | res = res.replaceAll("'", "''"); |
| | | return res; |
| | | } |
| | | //#endregion |
| | | //#endregion |
| | | }); |
| | | </script> |