From 86edf5829b69a4cdd93ec443871f9d2ecb6702b2 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 02 七月 2025 17:00:39 +0800
Subject: [PATCH] 1
---
WebTM/views/生产管理/宝工排产/Cg_PODemandPlanConfigBillReportForLack.html | 119 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 116 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/Cg_PODemandPlanConfigBillReportForLack.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/Cg_PODemandPlanConfigBillReportForLack.html"
index 044367d..5836dda 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/Cg_PODemandPlanConfigBillReportForLack.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/Cg_PODemandPlanConfigBillReportForLack.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);
@@ -434,6 +439,10 @@
var sql = "select * from h_v_Cg_PODemandPlanConfigBillReportForLack where 1=1 " + sWhere;
+ if (defaintOperationByCompanyName()) {
+ sql += " and (ISNULL(FStaffId,0) = 0 or FStaffId in (select HEmpID from Gy_Czygl where Czymc = '" + sessionStorage["HUserName"] + "') or '" + sessionStorage["HUserName"] + "' = 'admin') ";
+ }
+
get_Display(sql);
sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
}
@@ -462,7 +471,7 @@
//#region 瀵煎嚭Execel
function get_Export() {
- var ModRightNameCheck = "Cg_PODemandPlanConfigBillReportForLack";
+ var ModRightNameCheck = "Cg_PODemandPlanConfigBillReportForLack_ExportExcel";
//閫昏緫瀹℃牳鏂规硶
$.ajax({
@@ -471,7 +480,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 });
}
@@ -479,6 +509,69 @@
layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
}
});
+ }
+ //#endregion
+
+ //#region 蹇嵎鏂板
+ function get_insert() {
+ var CheckStatus = table.checkStatus("mainTable");
+ if (set_ModCheck("Cg_PODemandPlanConfigBill_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_Cg_PODemandPlanConfigBillReportForLack_Copy " + CheckStatus.data[i].HOrgID + "," + CheckStatus.data[i].HMaterID + "," + CheckStatus.data[i].HSupID
+ $.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 defaintOperationByCompanyName() {
+ var result = false;
+ $.ajax({
+ url: GetWEBURL() + '/Xt_getInfo/getCompanyName',
+ async: false,
+ type: "GET",
+ data: {},
+ success: function (data1) {
+ if (data1.count == 1) {
+ if (data1.data == "瀹濆伐") {
+ result = true;
+ }
+ }
+ }, error: function (e) {
+ }
+ });
+ return result;
}
//#endregion
@@ -622,6 +715,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