From 5d3b1302000fb9372fa4f0dfe7f839eb68c3871c Mon Sep 17 00:00:00 2001 From: pzy <2829717936@qq.com> Date: 星期一, 30 九月 2024 10:30:45 +0800 Subject: [PATCH] 删行 --- WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBillList.html | 353 +++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 298 insertions(+), 55 deletions(-) diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBillList.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBillList.html index 52db6b0..eaa037f 100644 --- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBillList.html +++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBillList.html @@ -82,6 +82,12 @@ </div> </div> <div class="layui-inline"> + <label class="layui-form-label">渚涘簲鍟�</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" name="HSupName" id="HSupName"> + </div> + </div> + <div class="layui-inline"> <label class="layui-form-label">寮�濮嬫棩鏈�</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDate1" id="HDate1"> @@ -118,7 +124,9 @@ <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm"><i class="layui-icon layui-icon-ok-circle"></i>纭</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back"><i class="layui-icon layui-icon-close-fill"></i>椹冲洖</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button>--> + <button type="button" class="layui-btn layui-btn-sm" id="btn_HideColumn" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>闅愯棌鍒楄缃�</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>鏉$爜鎵撳嵃</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print-Convenient"><i class="layui-icon layui-icon-print"></i>涓�閿墦鍗�</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button> </div> @@ -137,7 +145,7 @@ //CreateReport("Report"); //鎵撳嵃 // Report.LoadFromURL("鐗╂枡鏉$爜(涓冭绾稿ぇ)_浜斾簯.grf"); var _cur_page = 1; - var sql = " and 1=1"; + var sql = ""; var options = document.getElementById('HStatus').children; function getUrlVars() { @@ -190,6 +198,11 @@ , table = layui.table , form = layui.form , element = layui.element; + + //涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞� + var titleData = ["HItemID", "HParentID", "鍗曟嵁鍙�", "鏃ユ湡", "鏁伴噺", "鐘舵��", "鍗曚綅", "閲戦"]; + var HModName = "SRM_BarCodeBillList"; + var option = []; //甯歌鐢ㄦ硶 laydate.render({ elem: '#HDate1' @@ -212,12 +225,14 @@ // , where: { msg: "", NowPage: 1, OnePage: 10 } , cellMinWidth: 100 , cols: [[ - { checkbox: true/*, fixed: true*/ } + { type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' } + //{ checkbox: true/*, fixed: true*/ } , { field: 'sorderid', title: '搴忓彿', width: 80/*, fixed: true*/ } , { field: 'HItemID', title: '涓婚敭', width: 100, hide: true } , { field: '鐘舵��', title: '鐘舵��', width: 100, sort: true/*, fixed: true*/ } , { field: '鏉$爜缂栧彿', title: '鏉$爜缂栧彿', width: 180, sort: true/*, fixed: true*/ } , { field: '鐗╂枡缂栫爜', title: '鐗╂枡缂栫爜', width: 120, sort: true/*, fixed: true*/ } + , { field: '鏃х墿鏂欑紪鐮�', title: '鏃х墿鏂欑紪鐮�', width: 120, sort: true/*, fixed: true*/ } , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 120, sort: true/*, fixed: true*/ } , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 120, sort: true } , { field: '鏁伴噺', title: '鏁伴噺', width: 100, sort: true } @@ -237,7 +252,7 @@ //, skin: 'row' //琛ㄦ牸椋庢牸 // , even: true , page: true //鏄惁鏄剧ず鍒嗛〉 - , limits: [10, 20, 50, 100] + , limits: [10, 20, 50, 100,500,5000,10000] , limit: 50 //姣忛〉榛樿鏄剧ず鐨勬暟閲� //, height: 500 , done: function (res, curr, count) { @@ -283,44 +298,35 @@ layer.msg("鑷冲皯閫夋嫨涓�琛岃褰曪紒") } else { + var url = "linteridSession"; + $.ajax({ + type: "POST", + url: GetWEBURL() + url, //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + async: true, + data: { "linterid": rows.toString(), "HUserName": sessionStorage["HUserName"] }, + dataType: "json", + success: function (data) { + layer.closeAll("loading"); + }, + error: function (err) { + layer.alert("閿欒:" + err, { icon: 5 }); + } + }); + sessionStorage["linterid"] = rows.toString(); layer.open({ type: 2 - , area: ['50%', '50%'] + , area: ['80%', '80%'] , title: '鎵撳嵃妯$増閫夋嫨' , shade: 0.6 //閬僵閫忔槑搴� , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲 , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚� - , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + rows.toString() + '&HBarcode=' + rows2.toString() + '&Type=HBarCodePrint', 'yes'] + , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + sessionStorage["linterid"] + '&HBarcode=&Type=SRM_POOrderBillList', 'yes']// 瀹夌憺 type ='SRM_POOrderBillList' 鍘焧ype = 'HBarCodePrint' , resize: false - //, cancel: function () { - // $(".layui-btn").removeClass("layui-btn-disabled"); - //} }) } - //if (OpenTmp != "") - //{ - // window.open("../../views/SRM/HBarPlanPrint.html?linterid=" + rows.toString() + "&Type=HBarCodePrint&OpenTmp=" + OpenTmp.toString()); - // $.ajax( - // { - // type: "POST", - // url: GetWEBURL() + "UpdateBarcodePrintQty", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� - // async: true, - // data: { "msg": rows2 }, - // dataType: "json", - // success: function (data) { - // //if (data.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝 - // // layer.msg(data.Message, { icon: 1 }); - // //} - // //else { - // // layer.msg(data.Message, { icon: 5 }); - // //} - // layer.closeAll("loading"); - // }, - // error: function (err) { - // f_alert("閿欒:" + err); - // } - // }); - //} + break; + case 'btn-print-Convenient': + convenientPrint(); break; case 'btn-Delete': var checkStatus = table.checkStatus('mainTable') @@ -334,12 +340,15 @@ InterID += data[i].HItemID.toString() + ","; } InterID = InterID.substring(0, InterID.length - 1) + + var oData = JSON.stringify(InterID) + ";" + sessionStorage["HUserName"]; + //閫昏緫鍒犻櫎鏂规硶 layer.confirm("纭瑕佸垹闄ゅ悧锛屽垹闄ゅ悗涓嶈兘鎭㈠", { title: "鍒犻櫎纭" }, function (index) { $.ajax({ - type: "GET", + type: "POST", url: GetWEBURL() + "/DeltetBarCodeBill", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� - data: { "HInterID": InterID, "HUserName": sessionStorage["HUserName"] }, + data: { "oData": oData}, success: function (result) { if (result.count == 1) { layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { @@ -359,35 +368,112 @@ } }); }) - - + break; + case 'btn-HideColumn': + get_HideColumn(); break; case 'btn-exit': parent.layui.admin.events.closeThisTabs(); break; }; }); + + //琛岀洃鍚簨浠� + 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 涓鸿〃鏍糏D 娉ㄦ剰姝ゅ濡傛灉ID涓嶆纭皢瀵艰嚧浣犲湪鐩戝惉澶嶉�夋鏃惰幏鍙栦笉鍒颁綘閫夋嫨鐨勬暟鎹紝鍓嶉潰鐨勫彧鏄坊鍔犳垨鍒犻櫎閫変腑鏈�変腑鏍峰紡浠ュ強璁剧疆鑳屾櫙鑹诧紝瀛椾綋棰滆壊 + layui.each(table.cache.mainTable, function (i, l) { + if (obj.tr.index() == l.LAY_TABLE_INDEX) { + l.LAY_CHECKED = flag; + } + }); + }); + ///鍔犺浇鏄剧ず鏁版嵁 function RoadHBillNo(sqlWhere) { + var wait = layer.load();//閬僵 where = sqlWhere; $.ajax({ - type: "get", + type: "POST", url: GetWEBURL() + "GetBarCodeShowList", async: true, data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere }, - success: function (result) { - ajaxReturnData = JSON.parse(JSON.stringify(result)).data; - table.reload('mainTable', { - data: ajaxReturnData - , height: 'full-10' - , page: { - curr: _cur_page //蹇呴』浠庣 1 椤靛紑濮� - } - , loading: false - , done: function (index, res) { + success: function (data1) { + //ajaxReturnData = JSON.parse(JSON.stringify(result)).data; + //table.reload('mainTable', { + // data: ajaxReturnData + // , height: 'full-10' + // , page: { + // curr: _cur_page //蹇呴』浠庣 1 椤靛紑濮� + // } + // , loading: false + // , done: function (index, res) { + // } + //}); + if (data1.Message == "鑾峰彇鎴愬姛") { + var data = []; + var col = []; + //缁欑┖鐨勬暟缁勮祴鍊� + 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', totalRowText: '鍚堣' }); + 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 (data[i].name.indexOf('id') > -1) { + col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //id鍒� + } + 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: 200 }); + break; + default: + if (data[i].name == '璁㈠崟鏁伴噺' || data[i].name == '宸插彂璐ф暟閲�' || data[i].name == '鏈彂璐ф暟閲�') { + col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true }); + } else if (data[i].name == '渚涘簲鍟嗕氦鏈熷洖澶�') { + col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' }); + } else { + col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); + } + } + } + } + //鍔ㄦ�佹樉绀哄垪鍚� + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , cols: [col] + , data: data1.data + , height: 'full-80' + , totalRow: true + , page: true + , cellMinWidth: 90 + , limit: 500 + , limits: [50, 500, 5000, 20000] + } + table.render(option); + //鍒锋柊琛ㄦ牸鏁版嵁 + DisPlay_HideColumn(); + layer.close(wait); + } else { + layer.close(wait); + layer.alert(data1.Message, { icon: 5 }); + } }, error: function (result) { console.log(result); @@ -396,7 +482,7 @@ }); }; form.on('submit(f_Query)', function (data) {//鏌ヨ - var sqlWhere = " and 1=1 "; + var sqlWhere = ""; if ($("#HStatus").val() != "") sqlWhere += " and 鐘舵�� like ^^%" + $("#HStatus").val() + "%^^"; if ($("#HBarCode").val() != "") @@ -409,6 +495,8 @@ sqlWhere += " and 鐗╂枡浠g爜 like ^^%" + $("#HNumber").val() + "%^^"; if ($("#HName").val() != "") sqlWhere += " and 鐗╂枡鍚嶇О like ^^%" + $("#HName").val() + "%^^"; + if ($("#HSupName").val() != "") + sqlWhere += " and 渚涘簲鍟� like ^^%" + $("#HSupName").val() + "%^^"; if ($("#HModel").val() != "") sqlWhere += " and 瑙勬牸鍨嬪彿 like ^^%" + $("#HModel").val() + "%^^"; //if ($("#HClStatus").val() != "") @@ -429,17 +517,172 @@ RoadHBillNo(sqlWhere); }); var $ = layui.$, active = { - //f_Query: function () { //鏌ヨ - // var sqlWhere = " and 1=1 "; - // if ($("#HBarCode").val() != "") - // sqlWhere += " and 鏉$爜缂栧彿 like ''%" + $("#HBarCode").val() + "%''"; - // RoadHBillNo(sqlWhere); - //}, }; $('.test-table-reload-btn .layui-btn').on('click', function () { var type = $(this).data('type'); active[type] ? active[type].call(this) : ''; }); + + //涓�閿墦鍗� + function convenientPrint() { + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + var rows = ''; + var rows2 = ''; + for (var i = 0; i < data.length; i++) { + rows += data[i].HItemID.toString() + ','; + rows2 += data[i].鏉$爜缂栧彿.toString() + ','; + } + rows = rows.substring(rows.length - 1, 0); + rows2 = rows2.substring(rows2.length - 1, 0); + if (rows == "") { + layer.msg("鑷冲皯閫夋嫨涓�琛岃褰曪紒") + } + else { + var url = "linteridSession"; + $.ajax({ + type: "POST", + url: GetWEBURL() + url, //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + async: true, + data: { "linterid": rows.toString(), "HUserName": sessionStorage["HUserName"] }, + dataType: "json", + success: function (data) { + layer.closeAll("loading"); + }, + error: function (err) { + layer.alert("閿欒:" + err, { icon: 5 }); + } + }); + sessionStorage["linterid"] = rows.toString(); + $.ajax({ + type: "get", + url: GetWEBURL() + "/Open_PrintTem/GetDefaultOpenTmp_Json", + async: true, + data: { "HNumber": 'SRM_POOrderBillList' }, + //data: { "Value": Value }, + success: function (result) { + if (result.count == 1) { + var OpenTmp = result.data[0].妯℃澘鍚嶇О + window.open("../../views/SRM/HBarPlanPrint.html?linterid=" + sessionStorage["linterid"].toString() + "&Type=SRM_POOrderBillList" + "&OpenTmp=" + OpenTmp.toString()); + } else { + layer.msg(result.Message); + } + }, + error: function (result) { + console.log(result); + } + }); + } + } + + //闅愯棌鍒楄缃� + function get_HideColumn() { + var colName = ""; + for (var i = 1; i < option.cols[0].length - 1; i++) { + colName += option.cols[0][i]["title"] + ","; + } + + colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜 + layer.open({ + type: 2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "闅愯棌鍒楄缃�" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["50%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: ['../鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] + , btn: ["纭畾", "鍙栨秷"] + , btn1: function (index, laero) { + //鍒锋柊琛ㄦ牸鏁版嵁 + DisPlay_HideColumn(); + //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� + layer.close(index);//鍏抽棴寮圭獥 + } + }) + } + //鏄剧ず鍒楁暟鎹� + function DisPlay_HideColumn() { + $.ajax({ + url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', + type: "GET", + data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, + success: function (data1) { + if (data1.data.length != 0) { + var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁 + dataCol = data1.data[0].HGridString.split(','); + for (var i = 0; i < dataCol.length; i++) { + var dataCols = dataCol[i].split('|'); + //闅愯棌鍒� + if (dataCols[1] == 1) { + option.cols[0][i + 1]["hide"] = true; + } + //鏄剧ず鍒� + if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { + option.cols[0][i + 1]["hide"] = false; + } + //闅愯棌id + //璁剧疆鍒楀 + if (dataCols[3] > 0) { + if (option.cols[0][i + 1]["field"] == '渚涘簲鍟嗕氦鏈熷洖澶�') { + option.cols[0][i + 1]["width"] = 120; + } else { + 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"] = ""; + //} + + //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�) + 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 }); + } + }) + } }); </script> </body> -- Gitblit v1.9.1