zymesSrmLayUi.git

			@@ -151,6 +151,17 @@
			</select>
			</div>
			</div>
			<!--瑞琪-->
			<div class="layui-inline">
			<label class="layui-form-label">业务关闭</label>
			<div class="layui-input-block">
			<select id="HIsClose" name="HIsClose" lay-filter="">
			<option value="全部" selected>全部</option>
			<option value="是">是</option>
			<option value="否">否</option>
			</select>
			</div>
			</div>
			</div>
			</div>
			</div>
			@@ -170,6 +181,7 @@
			<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="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button>
			</div>
			</script>
			</div>
			@@ -218,14 +230,15 @@
			base: '../../layuiadmin/' //静态资源所在路径
			}).extend({
			index: 'lib/index' //主入口模块
			}).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
			}).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			, laydate = layui.laydate
			, table = layui.table
			, form = layui.form
			, element = layui.element;
			, element = layui.element
			, excel = layui.excel;
			//常规用法
			laydate.render({
			elem: '#HDate1'
			@@ -256,7 +269,7 @@
			//$("#HBeginDate").val("2022-03-14");
			//$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			var columns = [
			{ type: 'checkbox', fixed: 'left' }
			{ type: 'checkbox', fixed: 'left', totalRowText: '合计' }
			//{ type: 'radio', fixed: true }
			, { field: 'sorderid', title: '序号', width: 80/, fixed: true / }
			, { field: 'hmainid', title: 'hmainid', sort: true, /fixed: true,/ hide: true }
			@@ -276,8 +289,8 @@
			, { field: '计量单位', title: '计量单位', width: 80, sort: true }
			, { field: '数量', title: '订单数量', sort: true }
			, { field: '打印条码数量', title: '打印条码数量', sort: true }
			, { field: '已发货数量', title: '已发货数量', sort: true }
			, { field: '可发货数量', title: '可发货数量', sort: true }
			, { field: '已发货数量', title: '已发货数量', sort: true, totalRow: true }
			, { field: '可发货数量', title: '可发货数量', sort: true, totalRow: true}
			, { field: '交货地点', title: '交货地点', sort: true }
			, { field: '交货日期', title: '交货日期', width: 180, sort: true }
			, { field: '日期', title: '日期', width: 120, sort: true/, fixed: 'left' / }
			@@ -360,7 +373,11 @@
			//隐藏id
			//设置列宽
			if (dataCols[3] > 0) {
			option.cols[0][i + 1]["width"] = dataCols[3];
			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) {
			@@ -374,7 +391,7 @@
			//} else {
			// option.cols[0][i + 1]["width"] = "";
			//}


			//字体所在位置(左居中右)
			switch (dataCols[2]) {
			case "L":
			@@ -432,7 +449,7 @@
			data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
			}
			//在列表左边添加勾选框
			col.push({ type: 'checkbox', fixed: 'left' });
			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) {
			@@ -449,7 +466,13 @@
			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:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
			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 == '入库数量') {
			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 });
			}
			}
			}
			}
			@@ -460,6 +483,7 @@
			, cols: [col]
			, data: data1.data
			, height: 'full-80'
			,totalRow: true
			, page: true
			, cellMinWidth: 90
			, limit: 500
			@@ -505,8 +529,8 @@
			sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^";
			if ($("#HClStatus").val() != "")
			sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^";
			//if ($("#HPURCHASEORGID").val() != "")
			// sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
			if ($("#HPURCHASEORGID").val() != "" && $("#HPURCHASEORGID option:selected").text() != "安瑞集团")
			sqlWhere += " and HPURCHASEORGID = ^^" + $("#HPURCHASEORGID").val() + "^^";
			if ($("#HDate1").val() != "") {
			sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^";
			}
			@@ -519,6 +543,15 @@
			}
			else if ($("#HISGenerate").val() == "否") {
			sqlWhere += " and 未关联数量 > 0";
			}
			}
			/瑞琪/
			if ($("#HIsClose").val() != "") {
			if ($("#HIsClose").val() == "是") {
			sqlWhere += " and 业务关闭 = ^^已关闭^^";
			}
			else if ($("#HIsClose").val() == "否") {
			sqlWhere += " and 业务关闭 = ^^未关闭^^";
			}
			}
			var Time = $("#Time").val();
			@@ -557,6 +590,42 @@
			_cur_page = 1;
			get_Display(sqlWhere);
			}

			//监听单元格事件
			table.on('tool(mainTable)', function (obj) {
			var data = obj.data;
			if (obj.event === 'HSupSendGoodsDateRemark') {
			layer.prompt({
			formType: 2
			, area: ['400px', '50px'] //自定义文本域宽高
			, title: '修改订单号为【 ' + data.单据号 + ' 】，物料代码为【 ' + data.物料代码 + ' 】的回复交期'
			, value: data.回复交期
			}, function (value, index) {
			layer.close(index);
			//更新回复交期
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "Cg_Poorder/UpdateSupSendGoodsDateRemark",
			async: false,
			data: { "HInterID": data.hmainid, "HEntryID": data.hsubid, "HSupSendGoodsDateRemark": value},
			success: function (result) {
			if (result.code == 1) {
			//同步更新表格和缓存对应的值
			obj.update({
			回复交期: value
			});
			} else {
			layer.alert(result.Message, { icon: 5 });
			}
			},
			error: function (result) {
			layer.alert(result.Message, { icon: 5 });
			}
			});
			});
			}
			});

			//头工具栏事件
			table.on('toolbar(mainTable)', function (obj) {
			var checkStatus = table.checkStatus(obj.config.id);
			@@ -576,11 +645,28 @@
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			_cur_page = $(".layui-laypage-em").next().html();

			var HInterIDArr = "";
			var HBillNoArr = "";
			var HBillInter = "";

			for (let i = 0; i < data.length; i++) {
			HInterIDArr += data[i].hmainid.toString() + ",";
			HBillNoArr += "'" + data[i].单据号.toString() + "'" + ",";
			HBillInter += data[i].单据号.toString() + "@" + data[i].hmainid.toString() + ",";
			}

			HInterIDArr = HInterIDArr.substring(0, HInterIDArr.length - 1)//内码
			HBillNoArr = HBillNoArr.substring(0, HBillNoArr.length - 1)//单据号
			HBillInter = HBillInter.substring(0, HBillInter.length - 1)//单据号 + @ + 内码拼接

			var oData = JSON.stringify(HInterIDArr) + ";" + JSON.stringify(HBillInter) + ";" + sessionStorage["HUserName"];

			layer.confirm('是否确认单据?', { icon: 3, title: '提示' }, function (index) {
			$.ajax({
			type: "get",
			type: "post",
			url: GetWEBURL() + "POOrderAccept",
			data: { "HInterID": data[0]["hmainid"].toString(), "HBillNo": data[0]["单据号"].toString(), "HUser": sessionStorage["HUserName"] },
			data: { "oData": oData },
			success: function (result) {
			if (result.count == 1) { // 说明验证成功了，
			layer.msg(result.Message, { icon: 1 });
			@@ -662,6 +748,9 @@
			layer.alert("请选择数据", { icon: 5 });
			return;
			}
			if (data[0].完成状态 == "已完成") {
			return layer.msg('订单已完成！')
			}
			ajaxLabelData = data;
			//根据选中的采购订单，重新从金蝶云同步采购订单关联数量过来。考虑采购订单删除和关闭状态，同步状态
			var ids = "";
			@@ -742,6 +831,9 @@
			, data = checkStatus.data;
			if (data.length == 0) {
			return layer.msg('请选择数据')
			}
			if (data[0].完成状态 == "已完成") {
			return layer.msg('订单已完成！')
			}
			layer.open({
			type: 2
			@@ -832,8 +924,33 @@
			}
			});
			break;
			case 'set_dao':
			//获取列表列数据源
			var ColName = [];
			for (var i = 1; i < option.cols[0].length; i++) {
			if (option.cols[0][i]["hide"] != true) {
			ColName.push(option.cols[0][i]["field"]);
			}
			}
			//绑定数据
			var data = excel.filterExportData(option.data, ColName)

			//赋值于表头列名
			var Title = [];
			for (var i = 0; i < ColName.length; i++) {
			Title.push("\"" + ColName[i] + "\":\"" + ColName[i] + "\"");
			}
			var TitleName = JSON.parse("{" + Title.toString() + "}");
			data.unshift(TitleName);

			//导出 sheet1 工作表名
			excel.exportExcel({
			sheet1: data
			}, '采购订单列表.xlsx', 'xlsx');
			break;
			};
			});

			});
			</script>
			</body>