| WebTM/views/生产管理/宝工排产/Cg_PODemandPlanConfigBillReportForLack.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/生产管理/宝工排产/Gy_RoutingBillReportForLack.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/生产管理/宝工排产/JIT_NeedMaterPlanConfigBillReportForLack.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/Cg_PODemandPlanConfigBillReportForLack.html
New file @@ -0,0 +1,633 @@ <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <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"> <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../../layuiadmin/style/admin.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/HideButton.js"></script> </head> <body> <div class="layui-fluid"> <div class="layui-col-md12"> <div class="layui-card" style="padding: 1px"> <div class="layui-card-body" style="padding: 1px;"> <form class="layui-form" action="" lay-filter="component-form-group"> <div class="layui-collapse"> <div class="layui-colla-item"> <div class="layui-colla-title layui-inline"> <div class="layui-inline"> <span>æ´å¤</span> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ä¾åºå</label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HSupName" id="HSupName"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç©æ代ç </label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç©æå称</label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HMaterName" id="HMaterName"> </div> </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <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-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:5px"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" 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" 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> <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="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬ç¨åé var $ = layui.$ , admin = layui.admin , layer = layui.layer , table = layui.table , form = layui.form , element = layui.element , laypage = layui.laypage , laydate = layui.laydate var option = []; var sWhere = ""; var HModName = "Cg_PODemandPlanConfigBillReportForLack"; //ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± var titleData = []; var ins; //ç¨äºå¯¼åºexcel //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç //#region å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //导åºexcel case 'get_export': get_Export(); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å设置 case 'set_HideColumn': get_HideColumn(); break; //æé®è®¾ç½® case 'HideButton': var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Cg_PODemandPlanConfigBillReportForLack"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; }; }); //#endregion //#region ç¹å»è¡éä¸é«äº® 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; } }); }) //#endregion //#region éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(2); }); //#endregion //#region æ¬é¡µé¢ææ被è°ç¨çæ¹æ³ //#region åå§åçé¢ function set_ClearBill() { //åå§åè¡¨æ ¼ set_InitGrid(); //æ¥è¯¢ get_FastQuery(1); //Organ(); } //#endregion //#region åå§åè¡¨æ ¼æ¹æ³ function set_InitGrid() { option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , height: 'full-50' , page: true , totalRow: true //, cellMinWidth: 90 , limit: 50 , limits: [50, 500, 5000, 20000] }; } //#endregion //#endregion //#region æ¥è¯¢ function get_Display(sql) { var ajaxLoad = layer.load(); var ModRightNameCheck = ""; $.ajax({ url: GetWEBURL() + '/CommonModel/searchMethod', type: "GET", data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, success: function (data1) { if (data1.count == 1) { var totalArray = []; var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); for (var key in data1.list) { data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); } //å¨å表左边添å å¾éæ¡ //col.push({ type: 'checkbox', fixed: 'left' }); for (var i = 0; i < data.length; i++) { // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { 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 { switch (data[i].Type) { //int case 'DateTime': col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width:120 }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 }); } } } option.cols = [col]; option.data = data1.data; ins = table.render(option); //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Cg_PODemandPlanConfigBillReportForLack"; Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); //å·æ°è¡¨æ ¼æ°æ® //DisPlay_HideColumn(); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å¿«éè¿æ»¤ function get_FastQuery(number) { var HMaterNumber = $("#HMaterNumber").val();//ç©æ代ç var HMaterName = $("#HMaterName").val();//ç©æå称 var HDeptName = $("#HDeptName").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 (HMaterNumber) { sWhere += " and ç©æ代ç like '%" + HMaterNumber + "%'"; } if (HMaterName) { sWhere += " and ç©æå称 like '%" + HMaterName + "%'"; } if (HDeptName) { sWhere += " and çäº§è½¦é´ like '%" + HDeptName + "%'"; } var sql = "select * from h_v_Cg_PODemandPlanConfigBillReportForLack where 1=1 " + sWhere; get_Display(sql); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //#endregion //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ function set_ClearQuery() { $("#HDeptName").val(""); $("#HMaterNumber").val(""); $("#HMaterName").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 = ""; } //#endregion //#region 导åºExecel function get_Export() { var ModRightNameCheck = "Cg_PODemandPlanConfigBillReportForLack"; //é»è¾å®¡æ ¸æ¹æ³ $.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 //#region å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } //#endregion //#region éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } 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.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) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å ç ", "æºååå ç "];//ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { var dataCols = dataCol[i].split('|'); //éèå 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 (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå 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 }); } }) } //#endregion //#region ä»»æå段è¿æ»¤ï¼ååæ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; 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>'; } } $("#ColName").empty(); $("#ColName1").empty(); $("#ColName2").empty(); $("#ColName").append(Organization); $("#ColName1").append(Organization); $("#ColName2").append(Organization); form.render('select'); } //#endregion }); //#endregion //以ä¸æ¯layui模å </script> </body> </html> WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/Gy_RoutingBillReportForLack.html
New file @@ -0,0 +1,624 @@ <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <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"> <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../../layuiadmin/style/admin.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/HideButton.js"></script> </head> <body> <div class="layui-fluid"> <div class="layui-col-md12"> <div class="layui-card" style="padding: 1px"> <div class="layui-card-body" style="padding: 1px;"> <form class="layui-form" action="" lay-filter="component-form-group"> <div class="layui-collapse"> <div class="layui-colla-item"> <div class="layui-colla-title layui-inline"> <div class="layui-inline"> <span>æ´å¤</span> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç©æ代ç </label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç©æå称</label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HMaterName" id="HMaterName"> </div> </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <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-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:5px"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" 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" 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> <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="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬ç¨åé var $ = layui.$ , admin = layui.admin , layer = layui.layer , table = layui.table , form = layui.form , element = layui.element , laypage = layui.laypage , laydate = layui.laydate var option = []; var sWhere = ""; var HModName = "Gy_RoutingBillReportForLack"; //ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± var titleData = []; var ins; //ç¨äºå¯¼åºexcel //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç //#region å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //导åºexcel case 'get_export': get_Export(); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å设置 case 'set_HideColumn': get_HideColumn(); break; //æé®è®¾ç½® case 'HideButton': var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Gy_RoutingBillReportForLack"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; }; }); //#endregion //#region ç¹å»è¡éä¸é«äº® 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; } }); }) //#endregion //#region éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(2); }); //#endregion //#region æ¬é¡µé¢ææ被è°ç¨çæ¹æ³ //#region åå§åçé¢ function set_ClearBill() { //åå§åè¡¨æ ¼ set_InitGrid(); //æ¥è¯¢ get_FastQuery(1); //Organ(); } //#endregion //#region åå§åè¡¨æ ¼æ¹æ³ function set_InitGrid() { option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , height: 'full-50' , page: true , totalRow: true //, cellMinWidth: 90 , limit: 50 , limits: [50, 500, 5000, 20000] }; } //#endregion //#endregion //#region æ¥è¯¢ function get_Display(sql) { var ajaxLoad = layer.load(); var ModRightNameCheck = ""; $.ajax({ url: GetWEBURL() + '/CommonModel/searchMethod', type: "GET", data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, success: function (data1) { if (data1.count == 1) { var totalArray = []; var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); for (var key in data1.list) { data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); } //å¨å表左边添å å¾éæ¡ //col.push({ type: 'checkbox', fixed: 'left' }); for (var i = 0; i < data.length; i++) { // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { 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 { switch (data[i].Type) { //int case 'DateTime': col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width:120 }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 }); } } } option.cols = [col]; option.data = data1.data; ins = table.render(option); //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Gy_RoutingBillReportForLack"; Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); //å·æ°è¡¨æ ¼æ°æ® //DisPlay_HideColumn(); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å¿«éè¿æ»¤ function get_FastQuery(number) { var HMaterNumber = $("#HMaterNumber").val();//ç©æ代ç var HMaterName = $("#HMaterName").val();//ç©æå称 var HDeptName = $("#HDeptName").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 (HMaterNumber) { sWhere += " and ç©æ代ç like '%" + HMaterNumber + "%'"; } if (HMaterName) { sWhere += " and ç©æå称 like '%" + HMaterName + "%'"; } var sql = "select * from h_v_Gy_RoutingBillReportForLack where 1=1 " + sWhere; get_Display(sql); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //#endregion //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ function set_ClearQuery() { $("#HDeptName").val(""); $("#HMaterNumber").val(""); $("#HMaterName").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 = ""; } //#endregion //#region 导åºExecel function get_Export() { var ModRightNameCheck = "Gy_RoutingBillReportForLack"; //é»è¾å®¡æ ¸æ¹æ³ $.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 //#region å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } //#endregion //#region éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } 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.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) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å ç ", "æºååå ç "];//ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { var dataCols = dataCol[i].split('|'); //éèå 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 (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå 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 }); } }) } //#endregion //#region ä»»æå段è¿æ»¤ï¼ååæ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; 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>'; } } $("#ColName").empty(); $("#ColName1").empty(); $("#ColName2").empty(); $("#ColName").append(Organization); $("#ColName1").append(Organization); $("#ColName2").append(Organization); form.render('select'); } //#endregion }); //#endregion //以ä¸æ¯layui模å </script> </body> </html> WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/JIT_NeedMaterPlanConfigBillReportForLack.html
New file @@ -0,0 +1,633 @@ <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <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"> <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../../layuiadmin/style/admin.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/HideButton.js"></script> </head> <body> <div class="layui-fluid"> <div class="layui-col-md12"> <div class="layui-card" style="padding: 1px"> <div class="layui-card-body" style="padding: 1px;"> <form class="layui-form" action="" lay-filter="component-form-group"> <div class="layui-collapse"> <div class="layui-colla-item"> <div class="layui-colla-title layui-inline"> <div class="layui-inline"> <span>æ´å¤</span> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç产车é´</label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HDeptName" id="HDeptName"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç©æ代ç </label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">ç©æå称</label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="text" class="layui-input" name="HMaterName" id="HMaterName"> </div> </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <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-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:5px"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" 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" 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> <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="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬ç¨åé var $ = layui.$ , admin = layui.admin , layer = layui.layer , table = layui.table , form = layui.form , element = layui.element , laypage = layui.laypage , laydate = layui.laydate var option = []; var sWhere = ""; var HModName = "JIT_NeedMaterPlanConfigBillReportForLack"; //ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± var titleData = []; var ins; //ç¨äºå¯¼åºexcel //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç //#region å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //导åºexcel case 'get_export': get_Export(); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å设置 case 'set_HideColumn': get_HideColumn(); break; //æé®è®¾ç½® case 'HideButton': var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "JIT_NeedMaterPlanConfigBillReportForLack"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; }; }); //#endregion //#region ç¹å»è¡éä¸é«äº® 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; } }); }) //#endregion //#region éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(2); }); //#endregion //#region æ¬é¡µé¢ææ被è°ç¨çæ¹æ³ //#region åå§åçé¢ function set_ClearBill() { //åå§åè¡¨æ ¼ set_InitGrid(); //æ¥è¯¢ get_FastQuery(1); //Organ(); } //#endregion //#region åå§åè¡¨æ ¼æ¹æ³ function set_InitGrid() { option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , height: 'full-50' , page: true , totalRow: true //, cellMinWidth: 90 , limit: 50 , limits: [50, 500, 5000, 20000] }; } //#endregion //#endregion //#region æ¥è¯¢ function get_Display(sql) { var ajaxLoad = layer.load(); var ModRightNameCheck = ""; $.ajax({ url: GetWEBURL() + '/CommonModel/searchMethod', type: "GET", data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, success: function (data1) { if (data1.count == 1) { var totalArray = []; var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); for (var key in data1.list) { data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); } //å¨å表左边添å å¾éæ¡ //col.push({ type: 'checkbox', fixed: 'left' }); for (var i = 0; i < data.length; i++) { // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { 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 { switch (data[i].Type) { //int case 'DateTime': col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width:120 }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 }); } } } option.cols = [col]; option.data = data1.data; ins = table.render(option); //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "JIT_NeedMaterPlanConfigBillReportForLack"; Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); //å·æ°è¡¨æ ¼æ°æ® //DisPlay_HideColumn(); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å¿«éè¿æ»¤ function get_FastQuery(number) { var HMaterNumber = $("#HMaterNumber").val();//ç©æ代ç var HMaterName = $("#HMaterName").val();//ç©æå称 var HDeptName = $("#HDeptName").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 (HMaterNumber) { sWhere += " and ç©æ代ç like '%" + HMaterNumber + "%'"; } if (HMaterName) { sWhere += " and ç©æå称 like '%" + HMaterName + "%'"; } if (HDeptName) { sWhere += " and çäº§è½¦é´ like '%" + HDeptName + "%'"; } var sql = "select * from h_v_JIT_NeedMaterPlanConfigBillReportForLack where 1=1 " + sWhere; get_Display(sql); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //#endregion //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ function set_ClearQuery() { $("#HDeptName").val(""); $("#HMaterNumber").val(""); $("#HMaterName").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 = ""; } //#endregion //#region 导åºExecel function get_Export() { var ModRightNameCheck = "JIT_NeedMaterPlanConfigBillReportForLack"; //é»è¾å®¡æ ¸æ¹æ³ $.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 //#region å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } //#endregion //#region éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } 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.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) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å ç ", "æºååå ç "];//ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { var dataCols = dataCol[i].split('|'); //éèå 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 (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå 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 }); } }) } //#endregion //#region ä»»æå段è¿æ»¤ï¼ååæ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; 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>'; } } $("#ColName").empty(); $("#ColName1").empty(); $("#ColName2").empty(); $("#ColName").append(Organization); $("#ColName1").append(Organization); $("#ColName2").append(Organization); form.render('select'); } //#endregion }); //#endregion //以ä¸æ¯layui模å </script> </body> </html>
