zymesSrmLayUi.git

			@@ -142,14 +142,15 @@
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload" id="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit" id="btn-Audit"><i class="layui-icon layui-icon-radio"></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-back"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>-->
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details" id="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-changebg" id="btn-changebg"><i class="layui-icon layui-icon-form"></i>变更</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print" id="btn-print"><i class="layui-icon layui-icon-print"></i>打印送货单</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
			<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" 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 {
			@@ -400,15 +399,19 @@
			layer.close(ajaxLoad);
			}
			});
			})
			})
			}
			else {
			layer.msg('请选择数据！');
			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 = "";