From d76cf1c3f365efe4bb3bcdc579e583b3587bef89 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 08 八月 2022 15:01:13 +0800 Subject: [PATCH] 工艺路线过滤 森楷 功能完善 其它入库缓存 销售出库缓存 --- WebTM/views/计划管理/工艺路线/Gy_RoutingBillList.html | 95 ++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 85 insertions(+), 10 deletions(-) diff --git "a/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillList.html" "b/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillList.html" index 9583018..9599f56 100644 --- "a/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillList.html" +++ "b/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillList.html" @@ -23,16 +23,15 @@ <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"> <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter"> - </div> - </div> - <div class="layui-inline"> - <label class="layui-form-label">鐗╂枡鍚嶇О</label> - <div class="layui-input-block"> - <input type="text" class="layui-input" name="hnumber" id="hnumber"> </div> </div> <div class="layui-inline"> @@ -53,7 +52,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" 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;">鐗╂枡浠g爜</label> + <div class="layui-input-block" style="margin-left: 77px;"> + <input type="hidden" class="layui-input" lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> + <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> + <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" 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="HMaterName" id="HMaterName" 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="HModel" id="HModel" style="background-color:#efefef4d;" readonly> + </div> + </div> + </div> + <div class="layui-row" style="margin: 10px 0 10px;"> + </div> + </div> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> @@ -138,6 +166,12 @@ get_FastQuery(2); }); //#endregion + + //鐗╂枡 + form.on('submit(btnHMaterID)', function (data) {//閫夋嫨浠撲綅 + + get_btnHMaterID(); + }); //閲嶇疆鎸夐挳 form.on('submit(btnReSearch)', function (data) { @@ -249,7 +283,10 @@ //#region 閲嶇疆杩囨护鏉′欢鏂规硶 function set_ClearQuery() { $("#WorkCenter").val("");//鍗曟嵁鍙� - $("#hnumber").val("");//鐗╂枡 + $("#HMaterID").val(0);//鐗╂枡 + $("#HMaterName").val("");//鐗╂枡 + $("#HMaterNumber").val("");//鐗╂枡 + $("#HModel").val("");//鐗╂枡 $("#HOrderProcNO").val("");//鍗曟嵁绫诲瀷 $("#btnSearch").click(); $("#HName").val(""); @@ -258,6 +295,35 @@ sWhere = ""; } //#endregion + + + //鐗╂枡 + function get_btnHMaterID() { + layer.open({ + type: 2 + , area: ['80%', '80%'] + , title: '鐗╂枡' + , shade: 0.6 //閬僵閫忔槑搴� + //, maxmin: true //鍏佽鍏ㄥ睆鏈�灏忓寲 + , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚� + , content: ['../../Baseset/鍩虹璧勬枡/Gy_MaterialList.html', 'yes'] + , btn: ['纭畾', '鍙栨秷'] + , btn1: function (index, layero) { + + //鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟 + var iframeWindow = window['layui-layer-iframe' + index] //鑾峰彇寮规椤甸潰 + var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//鑾峰彇table鐨別lem:"#test" + if (checkStatus.data.length === 0) { + return layer.msg('璇烽�夋嫨鏁版嵁'); + } + $("#HMaterID").val(checkStatus.data[0].HItemID); + $("#HMaterName").val(checkStatus.data[0].HName); + $("#HMaterNumber").val(checkStatus.data[0].HNumber); + $("#HModel").val(checkStatus.data[0].HModel); + layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� + } + }) + } //#region 鏌ヨ function get_Display(sWhere) { @@ -290,7 +356,10 @@ function get_FastQuery(number) { var HOrgID = ""; var HOrderProcNO = $("#HOrderProcNO").val();//鍗曟嵁绫诲瀷 - var hnumber = $("#hnumber").val(); + var HMaterID = $("#HMaterID").val(); + var HMaterName = $("#HMaterName").val(); + var HMaterNumber = $("#HMaterNumber").val(); + var HModel = $("#HModel").val(); //var HName = $("#HName").val(); var WorkCenter = $("#WorkCenter").val();//鍗曟嵁鍙� @@ -304,8 +373,14 @@ if (HOrderProcNO) { sWhere += " and 鍗曟嵁绫诲瀷 like '%" + HOrderProcNO + "%'"; } - if (hnumber) { - sWhere += " and 鐗╂枡浠g爜 like '%" + hnumber + "%' or 鐗╂枡鍚嶇О like '%" + hnumber + "%'"; + if (HMaterName) { + sWhere += "and HMaterID=" + HMaterID+" and 鐗╂枡鍚嶇О like '%" + HMaterName + "%'"; + } + if (HMaterNumber) { + sWhere += "and 鐗╂枡浠g爜 like '%" + HMaterNumber + "%'"; + } + if (HModel) { + sWhere += "and 瑙勬牸鍨嬪彿 like '%" + HModel + "%'"; } if (WorkCenter) { sWhere += " and 鍗曟嵁鍙� like '%" + WorkCenter + "%'"; -- Gitblit v1.9.1