| WebSRM/WebSRM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBill.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POInStockBackBillList_XB.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POInStockBillList_XB.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList_XB.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_SupMaterPackBillEdit.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebSRM/layuiAdmin.std-v1.2.1/src/views/index.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebSRM/WebSRM.csproj
@@ -870,6 +870,7 @@ <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_AskPriceBillList.html" /> <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_BarCodeBill_XB.html" /> <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_BarCodeBill_Bak.html" /> <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBackBillList_XB.html" /> <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBackBillList.html" /> <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_SupMaterPackBillEdit.html" /> <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_SupMaterPackBillList.html" /> WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBill.html
@@ -567,10 +567,10 @@ for (var i = 0; i < table.cache["mainTable"].length; i++) { if (table.cache["mainTable"][i].HMaterName.indexOf("\"") != -1 || table.cache["mainTable"][i].HMaterName.indexOf(";") != -1) { table.cache["mainTable"][i].HMaterName = table.cache["mainTable"][i].HMaterName.replace("\"", "”").replace(";", "；") table.cache["mainTable"][i].HMaterName = table.cache["mainTable"][i].HMaterName.replaceALL("\"", "”").replaceALL(";", "；") } if (table.cache["mainTable"][i].HMaterModel.indexOf("\"") != -1 || table.cache["mainTable"][i].HMaterModel.indexOf(";") != -1) { table.cache["mainTable"][i].HMaterModel = table.cache["mainTable"][i].HMaterModel.replace("\"", "”").replace(";", "；") table.cache["mainTable"][i].HMaterModel = table.cache["mainTable"][i].HMaterModel.replaceALL("\"", "”").replaceALL(";", "；") } }
New file @@ -0,0 +1,436 @@ <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>退货单列表</title> <meta name="renderer" content="webkit"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0"> <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all"> </head> <body> <!--<div class="layui-card layadmin-header"> <div class="layui-breadcrumb" lay-filter="breadcrumb"> <a lay-href="">主页</a> <a><cite>组件</cite></a> <a><cite>数据表格</cite></a> <a><cite>数据表格的重载</cite></a> </div> </div>--> <div class="layui-fluid"> <div class="layui-row layui-col-space15"> <div class="layui-col-md12"> <div class="layui-card"> <div class="layui-card-header">退货单列表</div> <div class="layui-card-body"> <form class="layui-form" action=""> <div class="layui-form-item"> <div class="layui-inline"> <label class="layui-form-label">订单状态</label> <div class="layui-input-block"> <select name="HStatus" id="HStatus" lay-filter=""> <option value="" selected="">全部</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"> <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> </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"> <label class="layui-form-label">产品名称</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HName" id="HName"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">规格型号</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HModel" id="HModel"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">关闭状态</label> <div class="layui-input-block"> <select id="HClStatus" name="HClStatus" lay-filter=""> <option value="" selected="">全部</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="HDate1" id="HDate1"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">结束日期</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HDate2" id="HDate2"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">采购组织</label> <div class="layui-input-block"> <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter=""> <option value="">组织1</option> <option value="">组织2</option> </select> </div> </div> <div class="layui-inline"> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> </div> </div> </form> <!--</div>--> </div> <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>--> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button> <!--<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" 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-generate"><i class="layui-icon layui-icon-file"></i>生成条码</button>--> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button> </div> </script> </div> </div> </div> </div> <!--<script src="../../layuiadmin/layui/lay/modules/mobile/jquery-3.3.1.min.js"></script>--> <script src="../../layuiadmin/layui/layui.js"></script> <script src="../../../../Scripts/webConfig.js"></script> <script> var _cur_page = 1; var sql = ""; var options = document.getElementById('HStatus').children; function getUrlVars() { var vars = [], hash; var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&'); for (var i = 0; i < hashes.length; i++) { hash = hashes[i].split('='); vars.push(hash[0]); vars[hash[0]] = hash[1]; } return vars; } function f_alert(sMsg) { layer.alert(sMsg, { icon: 5 }); //layer.open({ // type: 1 // , offset: 'auto' //具体配置参考：http://www.layui.com/doc/modules/layer.html#offset // , id: 'layerDemo' //防止重复弹出 // , content: '<div style="padding: 20px 100px;">' + sMsg + '</div>' // , shade: 0 //不显示遮罩 // , yes: function () { // layer.closeAll(); // } //}); } var params = getUrlVars(); var type = params[params[0]]; switch (type) { case "UnConfirm": options[1].selected = true; sql += " and 状态 like ^^%未确认%^^"; break; case "ReConfirm": options[2].selected = true; sql += " and 状态 like ^^%已确认%^^"; break; case "ReBack": options[3].selected = true; sql += " and 状态 like ^^%已驳回%^^"; break; } //CreateReport("Report"); //打印 //Report.LoadFromURL("退货单(A4纸).grf");//打印 layui.config({ base: '../../layuiadmin/' //静态资源所在路径 }).extend({ index: 'lib/index' //主入口模块 }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () { var $ = layui.$ , admin = layui.admin , layer = layui.layer , laydate = layui.laydate , table = layui.table , form = layui.form , element = layui.element; //常规用法 laydate.render({ elem: '#HDate1' }); laydate.render({ elem: '#HDate2' }); //layui.code(); var ins; //用于导出excel var option = []; set_InitGrid(); get_FastQuery(sql); layer.load(3) //方法级渲染 function set_InitGrid() { var columns = [ { checkbox: true, fixed: true } , { field: '状态', title: '状态', width: 100, sort: true, fixed: true } , { field: '单据号', title: '单据号', width: 200, sort: true, fixed: true } , { field: '采购订单号', title: '采购订单号', width: 150 } , { field: '源单单号', title: '源单单号', width: 150 } , { field: '计划跟踪单号', title: '计划跟踪单号', width: 100 } , { field: '物料代码', title: '物料代码', width: 200 } , { field: '物料', title: '物料名称', width: 200 } , { field: '规格型号', title: '规格型号', width: 200 } , { field: '计量单位', title: '计量单位', width: 80, sort: true } , { field: '数量', title: '数量', width: 130 } , { field: '合格数量', title: '合格数量', width: 130 } , { field: '不合格数量', title: '不合格数量', width: 130 } , { field: '日期', title: '日期', width: 150 } ]; option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , page: true //, cellMinWidth: 120 , totalRow: true , limit: 500 , height: 'full-50' , cols: [columns] , limits: [10, 20, 50, 100, 500, 1000 ] , done: function (res, curr, count) { layer.closeAll("loading"); } }; } //头工具栏事件 table.on('toolbar(mainTable)', function (obj) { var checkStatus = table.checkStatus(obj.config.id); switch (obj.event) { case 'btn-getCheckData': var data = checkStatus.data; layer.alert(JSON.stringify(data)); break; //自定义头工具栏右侧图标 - 提示 case 'btn-reload': _cur_page = $(".layui-laypage-em").next().html(); get_FastQuery(sql); break; case 'btn-details': var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; var linterid = data[0].hmainid.toString(); //if (AllowLoadData(sSubStr) != false) {//非空验证 layer.open({ type: 2 , area: ['100%', '100%'] , title: '要货通知单' , shade: 0.6 //遮罩透明度 , maxmin: true //允许全屏最小化 , anim: 0 //0-6的动画形式，-1不开启 , content: '../../../src/views/SRM/SRM_PODemandPlanBill.html?linterid=' + linterid , resize: false , cancel: function () { //$(".layui-btn").removeClass("layui-btn-disabled"); } }) break; case 'btn-print': var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; window.open("../../views/SRM/HBarPlanPrint.html?linterid=" + data[0].hmainid + "&Type=HPOInStockBill"); break; case 'btn-generate': var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; layer.open({ type: 2 , area: ['100%', '100%'] , title: '退货单' , shade: 0.6 //遮罩透明度 , maxmin: false //允许全屏最小化 , anim: 0 //0-6的动画形式，-1不开启 , content: ['../../views/SRM/SRM_BarCodeBill.html?linterid=' + data[0].hmainid + '&lentryid=' + data[0].hmainid, 'yes'] , resize: false , cancel: function () { $(".layui-btn").removeClass("layui-btn-disabled"); } }) break; case 'btn-exit': parent.layui.admin.events.closeThisTabs(); break; //导出excel case 'get_export': get_Export(); break; }; }); ///加载显示数据 function RoadHBillNo(sqlWhere) { where = sqlWhere; $.ajax({ type: "post", url: GetWEBURL() + "GetPOInStockBackBillList", async: true, data: { "HSupIDs": sessionStorage["HSupIDs"], "sqlWhere": sqlWhere }, success: function (result) { ajaxReturnData = JSON.parse(JSON.stringify(result)).data; if (ajaxReturnData == null) { ajaxReturnData = []; layer.msg("没有查询到数据，请核对过滤条件是否正确"); } option.data = ajaxReturnData; //table.render(option); ins = table.render(option); layer.closeAll("loading"); }, error: function (result) { console.log(result); //layer.msg('获取采购订单出现异常', { icon: 2, time: 2000 }); } }); }; function get_FastQuery(table, option) { var sqlWhere = " and 1=1 "; if ($("#HStatus").val() != "") sqlWhere += " and 状态 like ^^%" + $("#HStatus").val() + "%^^"; if ($("#HBillNo").val() != "") sqlWhere += " and 单据号 like ^^%" + $("#HBillNo").val() + "%^^"; if ($("#HNumber").val() != "") sqlWhere += " and 物料代码 like ^^%" + $("#HNumber").val() + "%^^"; if ($("#HName").val() != "") sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^"; if ($("#HModel").val() != "") sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^"; if ($("#HClStatus").val() != "") sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^"; if ($("#HPURCHASEORGID").val() != "") sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^"; if ($("#HDate1").val() != "") { sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^"; } if ($("#HDate2").val() != "") { sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^"; } sql = sqlWhere; //从第一页开始 _cur_page = 1; RoadHBillNo(sqlWhere); } form.on('submit(f_Query)', function (data) {//查询 var sqlWhere = " and 1=1 "; if ($("#HStatus").val() != "") sqlWhere += " and 状态 like ^^%" + $("#HStatus").val() + "%^^"; if ($("#HBillNo").val() != "") sqlWhere += " and 单据号 like ^^%" + $("#HBillNo").val() + "%^^"; if ($("#HNumber").val() != "") sqlWhere += " and 物料代码 like ^^%" + $("#HNumber").val() + "%^^"; if ($("#HName").val() != "") sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^"; if ($("#HModel").val() != "") sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^"; if ($("#HClStatus").val() != "") sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^"; if ($("#HPURCHASEORGID").val() != "") sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^"; if ($("#HDate1").val() != "") { sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^"; } if ($("#HDate2").val() != "") { sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^"; } sql = sqlWhere; //从第一页开始 _cur_page = 1; RoadHBillNo(sqlWhere); }); var $ = layui.$, active = { reload: function () { var demoReload = $('#HBillNo'); //执行重载 table.reload('mainTable', { page: { curr: 1 //重新从第 1 页开始 } , where: { key: { id: demoReload.val() } } }); }, f_Query: function () { //查询 //var sqlWhere = " and 1=1 "; //if ($("#HBillNo").val() != "") // sqlWhere += " and 单据号 like ''%" + $("#HBillNo").val() + "%''"; //RoadHBillNo(sqlWhere); }, }; $('.test-table-reload-btn .layui-btn').on('click', function () { var type = $(this).data('type'); active[type] ? active[type].call(this) : ''; }); //#region 导出Execel function get_Export() { option.data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // 假设字段名为field item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '').replaceAll(',', '，').replaceAll(';', '；').replaceAll('"', '“').replaceAll('\'', '‘'); // 将换行符替换为空字符串 } } }); table.exportFile(ins.config.id, option.data, "xls"); } //#endregion }); </script> </body> </html> WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POInStockBillList_XB.html
@@ -150,6 +150,7 @@ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate" id="btn-generate"><i class="layui-icon layui-icon-file"></i>生成条码</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit" id="btn-exit"><i class="layui-icon layui-icon-return"></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="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button> </div> </script> </div> @@ -256,6 +257,7 @@ var option = []; var titleData = ["hmainid", "hsubid", "含税单价", "金额", "生产日期", "预计到货日期", "源单主内码", "源单子内码", "源单类型", "采购订单号", "委外订单号", "收料组织", "采购组织", "需求组织"]; var HModName = "SRM_POInStockBillList"; var ins; //用于导出excel //初始化日期间隔、开始日期、结束日期 setSelect_HInitTimeCycle(); //若日期间隔不为 任意间隔，则禁用开始日期与结束日期的选择 @@ -359,15 +361,13 @@ var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; var InterID = ""; if (checkStatus.data.length > 0) { if (checkStatus.data.length > 0 && checkStatus.data.length <= 15) { for (var i = 0; i < checkStatus.data.length; i++) { InterID += data[i].hmainid.toString() + ","; } InterID = InterID.substring(0, InterID.length - 1); var HIsAudit = false; layer.confirm("确认审核送货单吗？", { title: "审核确认" }, function (index) { layer.close(index); var ajaxLoad = layer.load(); //逻辑审核方法 $.ajax({ @@ -388,7 +388,6 @@ }); layer.close(ajaxLoad); //查询表格数据 get_FastQuery(); } else { @@ -403,12 +402,16 @@ }) } else { if (checkStatus.data.length >= 1) { layer.msg('批量审核送货单，一次性不允许超过15单！'); } else { layer.msg('请选择数据！'); } } //自定义头工具栏右侧图标 - 提示 case 'btn-reload': _cur_page = $(".layui-laypage-em").next().html(); RoadHBillNo(sql); get_FastQuery(sql); // }); break; @@ -569,6 +572,10 @@ case 'btn-HideColumn': get_HideColumn(); break; //导出excel case 'get_export': get_Export(); break; }; }); @@ -585,7 +592,8 @@ success: function (result) { ajaxReturnData = JSON.parse(JSON.stringify(result)).data; option.data = ajaxReturnData; table.render(option); //table.render(option); ins = table.render(option); //刷新表格数据 DisPlay_HideColumn(); layer.closeAll("loading"); @@ -639,7 +647,7 @@ sqlWhere += " and 数量 = ^^" + $("#HQty").val() + "^^"; } sql = sqlWhere; //sql = sqlWhere; //从第一页开始 _cur_page = 1; RoadHBillNo(sqlWhere); @@ -648,7 +656,7 @@ //#endregion form.on('submit(f_Query)', function (data) {//查询 var sqlWhere = ""; var sqlWhere = sql; if ($("#HStatus").val() != "") if ($("#HStatus").val() == "未生成条码") { sqlWhere += " and 未生成条码数量 > 0"; @@ -687,7 +695,7 @@ sqlWhere += " and 数量 = ^^" + $("#HQty").val() + "^^"; } sql = sqlWhere; //sql = sqlWhere; //从第一页开始 _cur_page = 1; RoadHBillNo(sqlWhere); @@ -811,6 +819,23 @@ return fmt; } //#region 导出Execel function get_Export() { option.data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // 假设字段名为field item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '').replaceAll(',', '，').replaceAll(';', '；').replaceAll('"', '“').replaceAll('\'', '‘'); // 将换行符替换为空字符串 } } }); table.exportFile(ins.config.id, option.data, "xls"); } //#endregion //隐藏列设置 function get_HideColumn() { var colName = ""; WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList_XB.html
@@ -78,6 +78,26 @@ </div> </div> <div class="layui-inline"> <label class="layui-form-label">业务状态</label> <div class="layui-input-block" style="width:120px"> <select id="HIsClose" name="HIsClose" lay-filter=""> <option value="">全部</option> <option value="正常" selected>正常</option> <option value="业务关闭">业务关闭</option> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label">冻结状态</label> <div class="layui-input-block" style="width:120px"> <select id="HIsFreeze" name="HIsFreeze" lay-filter=""> <option value="">全部</option> <option value="正常" selected>正常</option> <option value="业务冻结">业务冻结</option> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label">是否已下推送货单</label> <div class="layui-input-block"> <select id="HISGenerate" name="HISGenerate" lay-filter=""> @@ -87,20 +107,20 @@ </select> </div> </div> <div class="layui-inline"> <div class="layui-inline" style="display:none;"> <label class="layui-form-label">日期间隔</label> <div class="layui-input-block"> <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <div class="layui-inline" style="display:none;"> <label class="layui-form-label">开始日期</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HBeginDate" id="HBeginDate"> </div> </div> <div class="layui-inline"> <div class="layui-inline" style="display:none;"> <label class="layui-form-label">结束日期</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HEndDate" id="HEndDate"> @@ -165,6 +185,7 @@ <i class="layui-icon layui-icon-file"></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="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button> </div> </script> @@ -336,8 +357,8 @@ optionPage = { elem: 'page', //注意，这里的 page 是 ID，不用加 # 号 count: 10000, //数据总数，从服务端得到 limit: 2, limits: [2,50, 500, 5000, 50000], limit: 50, limits: [50, 500, 5000, 50000], layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'], jump: function (obj, first) { //console.log(obj) @@ -687,6 +708,10 @@ case 'btn-HideColumn': get_HideColumn(); break; //导出excel case 'get_export': get_Export(); break; }; }); @@ -759,13 +784,13 @@ 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 }); col.push({ field: data[i].id, title: data[i].name, align: 'center', 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 == '未发货数量' || data[i].name == '剩余收料数量' || data[i].name == '未到货数量' || data[i].name == '累计收料数量' || 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 }); col.push({ field: data[i].id, title: data[i].name, align: 'center', width: 200, totalRow: true }); }else { col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); col.push({ field: data[i].id, title: data[i].name, align: 'center', width: 200 }); } } } @@ -810,12 +835,12 @@ sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^"; //if ($("#HPURCHASEORGID").val() != "") // sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^"; if ($("#HBeginDate").val() != "") { sqlWhere += " and 日期 >= ^^" + $("#HBeginDate").val() + "^^"; } if ($("#HEndDate").val() != "") { sqlWhere += " and 日期 <= ^^" + $("#HEndDate").val() + "^^"; } //if ($("#HBeginDate").val() != "") { //sqlWhere += " and 日期 >= ^^" + $("#HBeginDate").val() + "^^"; //} //if ($("#HEndDate").val() != "") { //sqlWhere += " and 日期 <= ^^" + $("#HEndDate").val() + "^^"; //} if ($("#HISGenerate").val() != "") { if ($("#HISGenerate").val() == "是") { sqlWhere += " and 未关联数量 <= 0"; @@ -825,6 +850,22 @@ } } if ($("#HIsClose").val() != "") { if ($("#HIsClose").val() == "正常") { sqlWhere += " and 业务关闭 = ^^正常^^"; } else if ($("#HIsClose").val() == "业务关闭") { sqlWhere += " and 业务关闭 = ^^业务关闭^^"; } } if ($("#HIsFreeze").val() != "") { if ($("#HIsFreeze").val() == "正常") { sqlWhere += " and 业务冻结 = ^^正常^^"; } else if ($("#HIsFreeze").val() == "业务冻结") { sqlWhere += " and 业务冻结 = ^^业务冻结^^"; } } var Time = $("#Time").val(); if (Time > 0) { @@ -882,18 +923,35 @@ sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^"; //if ($("#HPURCHASEORGID").val() != "") // sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^"; if ($("#HBeginDate").val() != "") { sqlWhere += " and 日期 >= ^^" + $("#HBeginDate").val() + "^^"; } if ($("#HEndDate").val() != "") { sqlWhere += " and 日期 <= ^^" + $("#HEndDate").val() + "^^"; } //if ($("#HBeginDate").val() != "") { //sqlWhere += " and 日期 >= ^^" + $("#HBeginDate").val() + "^^"; //} //if ($("#HEndDate").val() != "") { //sqlWhere += " and 日期 <= ^^" + $("#HEndDate").val() + "^^"; //} if ($("#HISGenerate").val() != "") { if ($("#HISGenerate").val() == "是") { sqlWhere += " and 未关联数量 <= 0"; } else if ($("#HISGenerate").val() == "否") { sqlWhere += " and 未关联数量 > 0"; } } if ($("#HIsClose").val() != "") { if ($("#HIsClose").val() == "正常") { sqlWhere += " and 业务关闭 = ^^正常^^"; } else if ($("#HIsClose").val() == "业务关闭") { sqlWhere += " and 业务关闭 = ^^业务关闭^^"; } } if ($("#HIsFreeze").val() != "") { if ($("#HIsFreeze").val() == "正常") { sqlWhere += " and 业务冻结 = ^^正常^^"; } else if ($("#HIsFreeze").val() == "业务冻结") { sqlWhere += " and 业务冻结 = ^^业务冻结^^"; } } @@ -1027,6 +1085,23 @@ } //#endregion //#region 导出Execel function get_Export() { option.data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // 假设字段名为field item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '').replaceAll(',', '，').replaceAll(';', '；').replaceAll('"', '“').replaceAll('\'', '‘'); // 将换行符替换为空字符串 } } }); table.exportFile(ins.config.id, option.data, "xls"); } //#endregion //隐藏列设置 function get_HideColumn() { var colName = ""; WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_SupMaterPackBillEdit.html
@@ -453,6 +453,10 @@ layer.msg("明细记录第" + (i + 1) + "行,外箱标准包装数不允许为0!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" }); return Result = false; } if (!isPositiveIntegerTimes(parseFloat(sSubStr[i].HInBoxPackQty), parseFloat(sSubStr[i].HOutBoxPackQty))) { layer.msg("明细记录第" + (i + 1) + "行,外箱标准包装数必须是内箱标准包装数的整数倍!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" }); return Result = false; } } } else { @@ -565,6 +569,26 @@ return vars; } function isPositiveIntegerTimes(x, y) { if (x > y) { var flag = x; x = y; y = flag; } var z = y % x; if (x == 0) { return true; } else { if (z == 0) { return true; } else { return false; } } } ////隐藏列设置 //function get_HideColumn() { // var colName = ""; WebSRM/layuiAdmin.std-v1.2.1/src/views/index.html
@@ -236,6 +236,7 @@ <dd data-name="SRM_POInStockBackBillList_UnConfirm"><a lay-href="SRM/SRM_POInStockBackBillList.html?type=UnConfirm">未确认退货单</a> </dd> <dd data-name="SRM_POInStockBackBillList_ReConfirm"><a lay-href="SRM/SRM_POInStockBackBillList.html?type=ReConfirm">已确认退货单</a></dd> <dd data-name="SRM_POInStockBackBillList_ReBack"><a lay-href="SRM/SRM_POInStockBackBillList.html?type=ReBack">已驳回退货单</a></dd> <dd data-name="SRM_POInStockBackBillList_XB"><a lay-href="SRM/SRM_POInStockBackBillList_XB.html">夏宝退货单</a></dd> </dl> </dd> </dl>
