WebTM/views/¹¤×ʹÜÀí/¹¤×ʽáËãµ¥(ÆäËû)/Pay_OtherBalBillList.html
@@ -31,11 +31,11 @@ <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-colla-title layui-inline"> <div class="layui-inline"> <span>æ´å¤</span> </div> </div>--> </div> <div class="layui-inline"> <label class="layui-form-label">åæ®å·</label> <div class="layui-input-block"> @@ -58,14 +58,36 @@ <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"> <div class="layui-inline"> <div class="layui-colla-content"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <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>--> </div> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> @@ -212,6 +234,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -329,6 +355,31 @@ var HDate = $("#HBeginDate").val();//å¼å§æ¥æ var HDate1 = $("#HEndDate").val();//ç»ææ¥æ var HBillNo = $("#HBillNo").val();//åæ®å·= var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -348,6 +399,10 @@ $("#HDate").val("");//å¼å§æ¥æ $("#HDate1").val("");//ç»ææ¥æ $("#HBillNo").val("");//åæ®å· $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //#endregion @@ -484,6 +539,18 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //以ä¸æ¯layui模å });
@@ -25,6 +25,11 @@ <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">å¼å§æ¥æ</label> <div class="layui-input-block"> @@ -47,7 +52,35 @@ <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"> <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" 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> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> @@ -209,6 +242,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -327,6 +364,31 @@ var HDate = $("#HBeginDate").val();//å¼å§æ¥æ var HDate1 = $("#HEndDate").val();//ç»ææ¥æ var HBillNo = $("#HBillNo").val(); //åæ®å· var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -348,6 +410,10 @@ $("#HBillNo").val(""); $("#HNumber").val(""); $("#HName").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //#endregion @@ -357,6 +423,19 @@ set_ClearQuery(); get_Display(sWhere); } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion ////#region æ¸ ç©ºè¿æ»¤æ¡ä»¶ WebTM/views/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/²úÁ¿»ã±¨/Sc_ProductReportStepBillList_Web.html
@@ -73,18 +73,44 @@ </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"> <div class="layui-inline"> <div class="layui-row"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç产èµæº</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Source" id="Source" style="width:190px;"> </div> </div> <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-inline"> <label class="layui-form-label">ç产èµæº</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Source" id="Source" style="width:190px;"> </div> </div> </div> </div> </div> @@ -198,11 +224,16 @@ //éç½®æé® form.on('submit(btnReSearch)', function (data) { $("#HDate").val("");//å¼å§æ¥æ $("#HDate1").val("");//ç»ææ¥æ $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); $("#HBillNo").val(""); $("#Part").val(""); $("#Source").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; }); //#endregion @@ -335,7 +366,7 @@ , { field: 'å ³éæ¥æ', title: 'å ³éæ¥æ', width: 200, templet: "<div>{{d.å ³éæ¥æ ==null ?'':layui.util.toDateString(d.å ³éæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } , { field: 'ä½åºäºº', title: 'ä½åºäºº', width: 200 } , { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ', width: 200, templet: "<div>{{d.ä½åºæ¥æ ==null ?'':layui.util.toDateString(d.ä½åºæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } , { field: 'HReportType', title: 'æ±æ¥ç±»å', width: 200 } //, { field: 'HReportType', title: 'æ±æ¥ç±»å', width: 200 } , { field: 'HRelationInterID', title: 'æ¯å¦æ¥æ£ç³è¯·', width: 200, hide: true } ]] }; @@ -355,6 +386,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -374,7 +409,33 @@ var HBillNo = $("#HBillNo").val(); //åæ®å· var Part = $("#Part").val(); //ç©æä¿¡æ¯ var Source = $("#Source").val(); //èµæº var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); sWhere += SchWhere; 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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -606,6 +667,19 @@ } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } // #endregion //以ä¸æ¯layui模å WebTM/views/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/Í£¹¤/Sc_MESStopStepWorkBillList.html
@@ -60,12 +60,34 @@ <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"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <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> </div> </div> @@ -166,6 +188,31 @@ var HDate1 = $("#HDate1").val();//ç»ææ¥æ var HBillNo = $("#HBillNo").val();//åæ®å· var HSource = $("#HSource").val();//ç产èµæº var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -205,6 +252,10 @@ $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); $("#HBillNo").val("");//åæ®å· $("#HSource").val("");//ç产èµæº $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click(); }); //#endregion @@ -363,6 +414,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -654,6 +709,18 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion
@@ -79,12 +79,33 @@ </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"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <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> </div> </div> @@ -184,6 +205,31 @@ var HDate1 = $("#HDate1").val();//ç»ææ¥æ var HBillNo = $("#HBillNo").val();//åæ®å· var HSource = $("#HSource").val();//ç产èµæº var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -224,6 +270,10 @@ $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); $("#HBillNo").val("");//åæ®å· $("#HSource").val("");//ç产èµæº $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click(); }); @@ -364,6 +414,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -656,6 +710,19 @@ } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion
@@ -79,12 +79,33 @@ </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"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <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> </div> </div> @@ -186,6 +207,31 @@ var HDate1 = $("#HDate1").val();//ç»ææ¥æ var HBillNo = $("#HBillNo").val();//åæ®å· var HSource = $("#HSource").val();//ç产èµæº var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -232,6 +278,10 @@ $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); $("#HBillNo").val("");//åæ®å· $("#HSource").val("");//ç产èµæº $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click(); }); //#endregion @@ -265,7 +315,7 @@ , cols: [[ { type: 'checkbox', fixed: 'left' } , { field: 'hmainid', title: 'åæ®ID', hide: true } , { field: 'æ¥æ', title: 'æ¥æ', width: 160, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } , { field: 'æ¥æ', title: 'æ¥æ', width: 160, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } , { field: 'åæ®å·', title: 'åæ®å·', width: 160 } , { field: 'åæ®ç±»å', title: 'åæ®ç±»å', width: 160, templet: function (d) { @@ -383,6 +433,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -678,6 +732,19 @@ } }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/Éú²ú¹ÜÀí/¼ðÁÏÅäË͵¥/JIT_ComplementGoodsList.html
@@ -126,6 +126,31 @@ </select> </div> </div> <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> <table class="" id="mainTable" lay-filter="mainTable"></table> @@ -304,7 +329,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); //layer.alert("æ¥è¯¢æå", { icon: 1 }); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -493,6 +521,33 @@ var HDeptName = $("#HDeptName").val(); //é¨é¨ var HJLStatus = $("#HJLStatus").val(); //æ£æç¶æ var user = sessionStorage["HUserName"]; //å¶å人 var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var Arbitrarily = ""; 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; } Arbitrarily = " and " + ColName + " " + com; } sWhere = { MaterialNumber: MaterialNumber, MaterialName: MaterialName, @@ -504,7 +559,8 @@ HEndDate: HEndDate, HDeptName: HDeptName, HJLStatus: HJLStatus, user: user user: user, Arbitrarily: Arbitrarily }; get_Display(JSON.stringify(sWhere)); sWhere = ""; @@ -693,6 +749,19 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion }); WebTM/views/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillList.html
@@ -58,69 +58,92 @@ </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">éæ°åæ¥</button> <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-row"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <label class="layui-form-label">ç产车é´</label> <div class="layui-input-block"> <select name="HDeptName" id="HDeptName" lay-verify="required" lay-search class="layui-input"> <!--å¨æ渲æ车é´--> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ä¸å¡ç¶æ</label> <div class="layui-input-block"> <select name="HStatus" id="HStatus" lay-verify="required" lay-search class="layui-input"> <!-- <option value="å ¨é¨">å ¨é¨</option>--> <option value="å¼å·¥">å¼å·¥</option> <option value="计å">计å</option> <option value="计å确认">计å确认</option> <option value="ä¸è¾¾">ä¸è¾¾</option> <option value="0">å ¨é¨</option> <option value="å®å·¥">å®å·¥</option> <option value="ç»æ¡">ç»æ¡</option> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label">åæ®ç±»å</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HBillType" id="HBillType"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æç¼ç </label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMaterName" id="HMaterName"> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç产车é´</label> <div class="layui-input-block"> <select name="HDeptName" id="HDeptName" lay-verify="required" lay-search class="layui-input"> <!--å¨æ渲æ车é´--> <div class="layui-row"> <div class="layui-inline"> <label class="layui-form-label">å¯ä¸ID</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HERPID" id="HERPID"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">æ¯å¦ä¸æ¨çææµè½¬å¡</label> <div class="layui-input-block"> <select name="HSF" id="HSF" lay-verify="required" lay-search class="layui-input"> <!-- <option value="å ¨é¨">å ¨é¨</option>--> <option value="å·²ä¸æ¨">å·²ä¸æ¨</option> <option value="æªä¸æ¨">æªä¸æ¨</option> <option value="å ¨é¨">å ¨é¨</option> </select> </div> </div> </div> <div class="layui-row"> <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> <div class="layui-inline"> <label class="layui-form-label">ä¸å¡ç¶æ</label> <div class="layui-input-block"> <select name="HStatus" id="HStatus" lay-verify="required" lay-search class="layui-input"> <!-- <option value="å ¨é¨">å ¨é¨</option>--> <option value="å¼å·¥">å¼å·¥</option> <option value="计å">计å</option> <option value="计å确认">计å确认</option> <option value="ä¸è¾¾">ä¸è¾¾</option> <option value="0">å ¨é¨</option> <option value="å®å·¥">å®å·¥</option> <option value="ç»æ¡">ç»æ¡</option> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label">åæ®ç±»å</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HBillType" id="HBillType"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æç¼ç </label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMaterName" id="HMaterName"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">å¯ä¸ID</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HERPID" id="HERPID"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">æ¯å¦ä¸æ¨çææµè½¬å¡</label> <div class="layui-input-block"> <select name="HSF" id="HSF" lay-verify="required" lay-search class="layui-input"> <!-- <option value="å ¨é¨">å ¨é¨</option>--> <option value="å·²ä¸æ¨">å·²ä¸æ¨</option> <option value="æªä¸æ¨">æªä¸æ¨</option> <option value="å ¨é¨">å ¨é¨</option> </select> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </div> @@ -434,6 +457,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); @@ -460,15 +487,41 @@ var HStatus = $("#HStatus").val();//åæ®å· var HBillType = $("#HBillType").val();//åæ®ç±»å var HSF = $("#HSF").val();//åæ®ç±»å var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HSF) {//å¤ææå°ç¶æ if (HSF == "å ¨é¨") { sWhere = ""; sWhere += ""; } if (HSF == "å·²ä¸æ¨") { sWhere = " and æ¯å¦ä¸æ¨çææµè½¬å¡ like '%" + HSF + "%' "; sWhere += " and æ¯å¦ä¸æ¨çææµè½¬å¡ like '%" + HSF + "%' "; } if (HSF == "æªä¸æ¨") { sWhere = " and æ¯å¦ä¸æ¨çææµè½¬å¡ like '%" + HSF + "%' "; sWhere += " and æ¯å¦ä¸æ¨çææµè½¬å¡ like '%" + HSF + "%' "; } } if (HDate) { @@ -517,6 +570,10 @@ $("#HDeptName").val("");//åæ®å· $("#HStatus").val("");//åæ®å· $("#btnSearch").click(); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //#endregion @@ -807,6 +864,19 @@ } }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/Éú²ú¹ÜÀí/Éú²ú½ÐÁÏƽ̨/JIT_ComplementGoodBillMain.html
@@ -71,81 +71,83 @@ </select> </div> </div> <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:10px;"> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ç©æ代ç </label> <div class="layui-input-block" style="margin-left: 77px;"> <input type="text" class="layui-input" lay-verify="MaterialNumber" name="MaterialNumber" id="MaterialNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnMaterial" id="btnMaterial" style="padding: 0 10px;float: right;margin-right: 3px;"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:10px;"> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ç©æ代ç </label> <div class="layui-input-block" style="margin-left: 77px;"> <input type="text" class="layui-input" lay-verify="MaterialNumber" name="MaterialNumber" id="MaterialNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnMaterial" id="btnMaterial" style="padding: 0 10px;float: right;margin-right: 3px;"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> </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="MaterialName" lay-verify="MaterialName" id="MaterialName" style="background-color:#efefef4d;" readonly> <input type="hidden" name="MaterialID" id="MaterialID" lay-verify="MaterialID" value="0"> </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="MaterialModel" id="MaterialModel" onmouseover="this.title=this.value" readonly> </div> </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="MaterialName" lay-verify="MaterialName" id="MaterialName" style="background-color:#efefef4d;" readonly> <input type="hidden" name="MaterialID" id="MaterialID" lay-verify="MaterialID" value="0"> <div class="layui-row" style="margin-top:10px;"> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产å代ç </label> <div class="layui-input-block" style="margin-left: 77px;"> <input type="text" class="layui-input" name="CPNumber" lay-verify="CPNumber" id="CPNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> <input type="hidden" name="CPID" id="CPID" lay-verify="CPID" value="0"> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCP" id="btnCP" style="padding: 0 10px;float: right;margin-right: 3px;"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> </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="CPName" lay-verify="CPName" id="CPName" style="background-color:#efefef4d;" readonly> </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="CPModel" lay-verify="CPModel" id="CPModel" value="" readonly onmouseover="this.title=this.value"> </div> </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="MaterialModel" id="MaterialModel" onmouseover="this.title=this.value" readonly> <div class="layui-row" style="margin-top:10px;"> <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> <div class="layui-row" style="margin-top:10px;"> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产å代ç </label> <div class="layui-input-block" style="margin-left: 77px;"> <input type="text" class="layui-input" name="CPNumber" lay-verify="CPNumber" id="CPNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> <input type="hidden" name="CPID" id="CPID" lay-verify="CPID" value="0"> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCP" id="btnCP" style="padding: 0 10px;float: right;margin-right: 3px;"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> </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="CPName" lay-verify="CPName" id="CPName" style="background-color:#efefef4d;" readonly> </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="CPModel" lay-verify="CPModel" id="CPModel" value="" readonly onmouseover="this.title=this.value"> </div> </div> </div> <div class="layui-row" style="margin-top:10px;"> <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="HICMOBillNo" lay-verify="HICMOBillNo" id="HICMOBillNo" value="" onmouseover="this.title=this.value"> </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="date" class="layui-input" lay-verify="HBeginDate" name="HBeginDate" id="HBeginDate" style="padding-left: 80px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;text-align:center;">â</label> <div class="layui-input-block" style="margin-left: 120px;"> <input type="date" class="layui-input" lay-verify="HEndDate" name="HEndDate" id="HEndDate" style="padding-left: 80px;"> </div> </div> <div class="layui-inline"> <div class="layui-input-block" style="margin-left: 90px;"> <input type="checkbox" name="ps" id="ps" lay-skin="primary" lay-filter="ps" title="ä» æ¾ç¤ºæªå®å ¨é é"> </div> </div> </div> </div> </div> </div> <div class="layui-collapse"> @@ -265,9 +267,6 @@ set_InitGrid(); get_Display(sWhere); Organ(); //æ¶é´åå§å $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); DisPlay_HideColumn(); } //è·åç»ç» @@ -358,6 +357,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); @@ -461,9 +464,34 @@ var CPName = $("#CPName").val(); //产åå称 var CPModel = $("#CPModel").val(); //产åè§æ ¼åå· var HICMOBillNo = $("#HICMOBillNo").val(); //ç产订åå· var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ var ps = $("#ps").prop("checked"); //ä» æ¾ç¤ºæªå®å ¨é é var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var Arbitrarily = ""; 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; } Arbitrarily = " and " + ColName + " " + com; } if (ps) { ps = 1; //ä» æ¾ç¤ºæªå®å ¨é é } @@ -482,10 +510,9 @@ CPName: CPName, CPModel: CPModel, HICMOBillNo: HICMOBillNo, HBeginDate: HBeginDate, HEndDate: HEndDate, ps: ps, user: user user: user, Arbitrarily: Arbitrarily }; get_Display(JSON.stringify(sWhere)); sWhere = ""; @@ -906,6 +933,19 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion }); WebTM/views/Éú²ú¹ÜÀí/Éú²ú»ã±¨µ¥/Sc_ICMOReportBillList.html
@@ -69,21 +69,50 @@ </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"> <div class="layui-inline"> <div class="layui-row"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨ä¿¡æ¯</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Dept" id="Dept" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æä¿¡æ¯</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Part" id="Part" style="width:190px;"> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨ä¿¡æ¯</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Dept" id="Dept" style="width:190px;"> <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" lay-filter="ColName" style="width:190px;"> </select> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æä¿¡æ¯</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Part" id="Part" style="width:190px;"> <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> @@ -333,6 +362,10 @@ option.data = data1.data; table.render(option); layer.close(wait); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(wait); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -353,6 +386,31 @@ var HBillNo = $("#HBillNo").val(); //åæ®å· var Dept = $("#Dept").val(); //é¨é¨ä¿¡æ¯ var Part = $("#Part").val(); //ç©æä¿¡æ¯ var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (Status) { switch (Status) { case '-1': //å ¨é¨ @@ -401,6 +459,10 @@ $("#HBillNo").val(""); $("#Dept").val(""); $("#Part").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); } //#endregion @@ -667,14 +729,17 @@ } //#endregion //#region æ¸ ç©ºè¿æ»¤æ¡ä»¶ function set_ClearQuery() { $('#Status').find("option[value='-1']").attr("selected", true); $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); $("#HBillNo").val(""); $("#Dept").val(""); $("#Part").val(""); //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion
@@ -92,6 +92,33 @@ </div> </div> </div> <div class="layui-row" style="margin-top:10px;"> <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> </div> </div> @@ -332,7 +359,10 @@ $("#MaterialModel").val("");//è§æ ¼åå· $("#HDeptName").val("");//çäº§è½¦é´ $("#ProcMul").val("");//工段 $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click();//å·æ° sWhere = ""; } @@ -350,7 +380,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); //layer.alert("æ¥è¯¢æå", { icon: 1 }); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -375,6 +408,32 @@ var ProcMul = $("#ProcMul").val();//工段 var Hmaker = sessionStorage["HUserName"] ;//å½åç¨æ· var HOrgID = sessionStorage["OrganizationID"];//ç»ç» var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var Arbitrarily = ""; 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; } Arbitrarily = " and " + ColName + " " + com; } sWhere = { HBeginDate: HBeginDate, @@ -386,7 +445,8 @@ HDeptName: HDeptName, ProcMul: ProcMul, Hmaker: Hmaker, HOrgID: HOrgID HOrgID: HOrgID, Arbitrarily: Arbitrarily } get_Display(JSON.stringify(sWhere)); @@ -536,6 +596,18 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/³µ¼ä¹ÜÀí/½ÐÁϹÜÀí/Jl_CallGoodsBillMain.html
@@ -82,6 +82,31 @@ </button> </div> </div> <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> </div> @@ -267,7 +292,10 @@ $("#MaterialID").val("");//ç©æid $("#MaterialModel").val("");//è§æ ¼åå· $("#HDeptName").val("");//çäº§è½¦é´ $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click();//å·æ° sWhere = ""; } @@ -288,7 +316,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); //layer.alert("æ¥è¯¢æå", { icon: 1 }); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -310,7 +341,31 @@ var MaterialCode = $("#MaterialCode").val();//ç©æ代ç var MaterialName =$("#MaterialName").val();//ç©æå称 var MaterialModel = $("#MaterialModel").val();//è§æ ¼åå· var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HBeginDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; @@ -530,6 +585,19 @@ } }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/³µ¼ä¹ÜÀí/½ÐÁϹÜÀí/½ÐÁÏÍËÁϵ¥/Jl_CallGoodsBillBackMain.html
@@ -107,11 +107,36 @@ <label class="layui-form-label">ä»åºæ¥æ¶</label> <div class="layui-input-block" style="margin-left: 120px;width: 184px;"> <select name="HCKStatus" lay-verify="HCKStatus" id="HCKStatus"> <option value="å ¨é¨" >å ¨é¨</option> <option value="å ¨é¨">å ¨é¨</option> <option value="å·²æ¥æ¶">å·²æ¥æ¶</option> <option value="æªæ¥æ¶">æªæ¥æ¶</option> </select> </div> </div> <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> @@ -342,7 +367,10 @@ $("#ProcMul").val("");//工段 $("#HPZStatus").val("å ¨é¨");//å质确认 $("#HCKStatus").val("å ¨é¨");//ä»åºæ¥æ¶ $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click();//å·æ° sWhere = ""; } @@ -360,7 +388,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); //layer.alert("æ¥è¯¢æå", { icon: 1 }); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -387,6 +418,32 @@ var HOrgID = sessionStorage["OrganizationID"];//ç»ç» var HPZStatus = $("#HPZStatus").val();//å质确认 var HCKStatus = $("#HCKStatus").val();//ä»åºæ¥æ¶ var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var Arbitrarily = ""; 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; } Arbitrarily = " and " + ColName + " " + com; } sWhere = { HBeginDate: HBeginDate, @@ -400,7 +457,8 @@ Hmaker: Hmaker, HOrgID: HOrgID, HPZStatus: HPZStatus, HCKStatus: HCKStatus HCKStatus: HCKStatus, Arbitrarily: Arbitrarily } get_Display(JSON.stringify(sWhere)); @@ -595,6 +653,19 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/³µ¼ä¹ÜÀí/½ÐÁϹÜÀí/Éú²úÈռƻ®µ¥/Sc_WorkBillAutoSortBillMain.html
@@ -74,23 +74,48 @@ </div> </div> <!--<div class="layui-inline"> <label class="layui-form-label">åæä»åº</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Warehouse" id="Warehouse" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">æºååå·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo" style="width:190px;"> </div> </div>--> <label class="layui-form-label">åæä»åº</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Warehouse" id="Warehouse" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">æºååå·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo" style="width:190px;"> </div> </div>--> <div class="layui-inline"> <label class="layui-form-label">å¶å人</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="Hmaker" id="Hmaker" style="width:190px;"> </div> </div> <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> @@ -259,7 +284,10 @@ //$("#Warehouse").val("");//åæä»åº //$("#HSourceBillNo").val("");//æºååå· $("#Hmaker").val("");//å¶å人 $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click();//å·æ° sWhere = ""; } @@ -277,7 +305,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); //layer.alert("æ¥è¯¢æå", { icon: 1 }); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -302,6 +333,31 @@ //var Warehouse = $("#Warehouse").val();//åæä»åº //var HSourceBillNo = $("#HSourceBillNo").val();//æºååå· var Hmaker = $("#Hmaker").val();//å¶å人 var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HBeginDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; @@ -441,6 +497,18 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/³µ¼ä¹ÜÀí/¹¤Ðò½øÕ¾½ÓÊÕµ¥/Cj_StationInBillList.html
@@ -110,7 +110,7 @@ </div> </div> </div> </div> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> WebTM/views/³µ¼ä¹ÜÀí/³µ¼äÊÕÁÏ/JIT_SendGoodsBillList.html
@@ -82,6 +82,31 @@ </button> </div> </div> <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> </div> @@ -267,7 +292,10 @@ $("#MaterialID").val("");//ç©æid $("#MaterialModel").val("");//è§æ ¼åå· $("#HDeptName").val("");//çäº§è½¦é´ $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); $("#btnSearch").click();//å·æ° sWhere = ""; } @@ -285,7 +313,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); //layer.alert("æ¥è¯¢æå", { icon: 1 }); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -308,6 +339,32 @@ var MaterialName =$("#MaterialName").val();//ç©æå称 var MaterialModel = $("#MaterialModel").val();//è§æ ¼åå· var HOrgID = sessionStorage["OrganizationID"];//å½åç»ç»id var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var Arbitrarily = ""; 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; } Arbitrarily = " and " + ColName + " " + com; } sWhere = { HBeginDate: HBeginDate, @@ -317,7 +374,8 @@ MaterialCode: MaterialCode, MaterialName: MaterialName, MaterialModel: MaterialModel, HOrgID: HOrgID HOrgID: HOrgID, Arbitrarily: Arbitrarily } get_Display(JSON.stringify(sWhere)); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å @@ -517,6 +575,18 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //#endregion //以ä¸æ¯layui模å WebTM/views/ÏúÊÛ¹ÜÀí/·¢»õ֪ͨµ¥/Xs_SeOutStockBillList.html
@@ -69,27 +69,51 @@ <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> <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" lay-filter="ColName" style="width:190px;"> </select> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> <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> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </div> @@ -253,6 +277,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -378,6 +406,31 @@ var HCusID = $("#HCusID").val(); var HDeptID = $("#HDeptID").val(); var HMangerID = $("#HMangerID").val(); var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -408,6 +461,10 @@ $("#HCusID").val(""); $("#HDeptID").val(""); $("#HMangerID").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //#endregion @@ -577,6 +634,19 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //以ä¸æ¯layui模å });
@@ -69,27 +69,51 @@ <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> <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" lay-filter="ColName" style="width:190px;"> </select> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> <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> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </div> @@ -249,6 +273,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -370,6 +398,31 @@ var HCusID = $("#HCusID").val(); var HDeptID = $("#HDeptID").val(); var HMangerID = $("#HMangerID").val(); var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -400,6 +453,10 @@ $("#HCusID").val(""); $("#HDeptID").val(""); $("#HMangerID").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //#endregion @@ -541,6 +598,19 @@ } }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //以ä¸æ¯layui模å });
@@ -69,29 +69,52 @@ </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">éæ°åæ¥</button> <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> <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" lay-filter="ColName" style="width:190px;"> </select> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> <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> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </div> @@ -260,6 +283,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -385,6 +412,31 @@ var HCusID = $("#HCusID").val(); var HDeptID = $("#HDeptID").val(); var HMangerID = $("#HMangerID").val(); var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -415,6 +467,10 @@ $("#HCusID").val(""); $("#HDeptID").val(""); $("#HMangerID").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //éæ°åæ¥æé® @@ -583,6 +639,19 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //以ä¸æ¯layui模å }); WebTM/views/ÁìÁÏ·¢»õ/ÏúÊÛ³ö¿â/Kf_SellOutBillList.html
@@ -59,27 +59,51 @@ </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"> <div class="layui-inline"> <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> <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" lay-filter="ColName" style="width:190px;"> </select> </div> </div> </div> <div class="layui-inline"> <label class="layui-form-label">é¨é¨</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> <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> <div class="layui-inline"> <label class="layui-form-label">主管</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </div> @@ -220,6 +244,10 @@ option.data = data1.data; table.render(option); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); @@ -341,6 +369,31 @@ var HCusID = $("#HCusID").val(); var HDeptID = $("#HDeptID").val(); var HMangerID = $("#HMangerID").val(); var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").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 (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; } @@ -371,6 +424,10 @@ $("#HCusID").val(""); $("#HDeptID").val(""); $("#HMangerID").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //#endregion @@ -485,6 +542,18 @@ }) } //åææ¾ç¤ºä¸ææ¡ 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(); $("#ColName").append(Organization); form.render('select'); } //以ä¸æ¯layui模å });
