From 9b8d8d7074a5ce0d686a9fc8651cee4482e696b2 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 03 六月 2025 14:03:48 +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 = ["鐢熶骇杞﹂棿浠g爜"];*/
+                            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