From f1f8c4a1d29cfcfd42d3b2265c4d4be57dc6df1a Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 13 八月 2025 11:35:33 +0800
Subject: [PATCH] 乔一：样品每日出库明细报表
---
WebTM/views/生产管理/宝工排产/JIT_NeedMaterPlanConfigBillReportForLack.html | 93 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 90 insertions(+), 3 deletions(-)
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_NeedMaterPlanConfigBillReportForLack.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_NeedMaterPlanConfigBillReportForLack.html"
index 876b9c5..0bdad88 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_NeedMaterPlanConfigBillReportForLack.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_NeedMaterPlanConfigBillReportForLack.html"
@@ -140,6 +140,7 @@
<script type="text/html" id="toolbarDemo">
<div class="layui-btn-container">
<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="get_insert" id="get_insert"><i class="layui-icon layui-icon-export"></i>蹇嵎鏂板</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
@@ -189,6 +190,10 @@
//瀵煎嚭excel
case 'get_export':
get_Export();
+ break;
+ //蹇嵎鏂板
+ case 'get_insert':
+ get_insert();
break;
//鍒锋柊
case 'get_Refresh': get_Refresh();
@@ -320,7 +325,7 @@
Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
//鍒锋柊琛ㄦ牸鏁版嵁
- //DisPlay_HideColumn();
+ DisPlay_HideColumn();
layer.close(ajaxLoad);
@@ -462,7 +467,7 @@
//#region 瀵煎嚭Execel
function get_Export() {
- var ModRightNameCheck = "JIT_NeedMaterPlanConfigBillReportForLack";
+ var ModRightNameCheck = "JIT_NeedMaterPlanConfigBillReportForLack_ExportExcel";
//閫昏緫瀹℃牳鏂规硶
$.ajax({
@@ -471,7 +476,28 @@
data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
success: function (result) {
if (result.count == 1) {
- table.exportFile(ins.config.id, option.data, "xls");
+ /* var addExportStr = ["鐢熶骇杞﹂棿浠ｇ爜"];*/
+ var data = option.data;
+ //for (var i = 0; i < data.length; i++) {
+ // for (var j = 0; j < addExportStr.length; j++) {
+ // var temp = data[i][addExportStr[j]].indexOf("'");
+ // if (temp != 0) {
+ // data[i][addExportStr[j]] = "'" + data[i][addExportStr[j]];
+ // }
+ // }
+ //}
+ 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, ''); // 灏嗘崲琛岀鏇挎崲涓虹┖瀛楃涓�
+ item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, '锛�'); // 灏嗘崲鍒嗗彿鏇挎崲涓虹┖瀛楃涓�
+ }
+ }
+ });
+ table.exportFile(ins.config.id, data, "xls");
} else {
layer.alert("褰撳墠妯″潡娌℃湁瀵煎嚭鏉冮檺!", { icon: 5 });
}
@@ -488,6 +514,47 @@
}
//#endregion
+ //#region 蹇嵎鏂板
+ function get_insert() {
+ var CheckStatus = table.checkStatus("mainTable");
+ if (set_ModCheck("JIT_NeedMaterPlanConfigBill_Edit") == false) {
+ return layer.msg("鏃犳潈闄�!")
+ }
+ if (CheckStatus.data.length == 0) {
+ return layer.msg("璇烽�夋嫨鏁版嵁!")
+ } else {
+ layer.confirm('鎮ㄧ‘瀹氳鏂板鍚楋紵', {
+ btn: ['纭畾', '鍙栨秷'] //鎸夐挳
+ , btn1: function () {
+ var ajaxLoad = layer.load();
+ var message = "";
+ for (var i = 0; i < CheckStatus.data.length; i++) {
+ var sql = "exec h_p_JIT_NeedMaterPlanConfigBillReportForLack_Copy " + CheckStatus.data[i].HOrgID + "," + CheckStatus.data[i].HMaterID + "," + CheckStatus.data[i].HDeptID
+ $.ajax({
+ url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
+ type: "GET",
+ async: false,
+ data: { "sWhere": sql },
+ success: function (data1) {
+ if (data1.count == 1) {
+ message += i + "." + data1.data[0].Remark + CheckStatus.data[i].鐗╂枡鍚嶇О+ "\\n"
+ } else {
+ layer.alert(data1.code + data1.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ }
+ layer.alert(message, { icon: 5 });
+ layer.close(ajaxLoad);
+ //鍒锋柊鏁版嵁
+ get_FastQuery(2);
+ }
+ })
+ }
+ }
+ //#endregion
//#region 闅愯棌鍒楄缃�
function get_HideColumn() {
var colName = "";
@@ -622,6 +689,26 @@
form.render('select');
}
//#endregion
+ //鏉冮檺鍒ゅ畾
+ function set_ModCheck(ModRightNameCheck) {
+ var Permission = false;
+ $.ajax({
+ type: "GET",
+ url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
+ async: false,
+ data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
+ success: function (result) {
+ if (result.count == 1) {
+ Permission = true;
+ } else {
+ layer.alert("褰撳墠妯″潡娌℃湁鏌ヨ鏉冮檺!", { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ return Permission;
+ }
});
//#endregion
--
Gitblit v1.9.1