From d6e4e8188943879e660f89b7bb082250caa34046 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期一, 21 四月 2025 15:47:51 +0800
Subject: [PATCH] 欠料运算报表更新,三升排产添加导入功能

---
 WebTM/views/生产管理/三升排产/JIT_DayPlanPlatForm.html                 |   23 +++
 WebTM/views/生产管理/三升排产/JIT_DayPlanPlatFormImport_SS.html        |  361 +++++++++++++++++++++++++++++++++++++++++++++++++++
 WebTM/views/生产管理/欠料运算/JIT_MaterialLevelShorAnalysisReport.html |    8 
 WebTM/WebTM.csproj                                             |    1 
 4 files changed, 387 insertions(+), 6 deletions(-)

diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj
index 0045d1e..e3ff0e8 100644
--- a/WebTM/WebTM.csproj
+++ b/WebTM/WebTM.csproj
@@ -578,6 +578,7 @@
     <Content Include="views\妯℃不鍏风鐞哱妯℃不鍏风鐞哱Sc_MouldMaintainRuleBill_Excel.html" />
     <Content Include="views\妯℃不鍏风鐞哱妯℃不鍏风鐞哱Sc_MouldMaintainRuleBillList_PDA.html" />
     <Content Include="views\鐢熶骇绠$悊\涓夊崌鎺掍骇\JIT_DayPlanPlatForm.html" />
+    <Content Include="views\鐢熶骇绠$悊\涓夊崌鎺掍骇\JIT_DayPlanPlatFormImport_SS.html" />
     <Content Include="views\鐢熶骇绠$悊\瀹濆伐鎺掍骇\JIT_PickUpCalculate_BaoGong.html" />
     <Content Include="views\鐢熶骇绠$悊\瀹濆伐鎺掍骇\JIT_UnLockRequestBillList.html" />
     <Content Include="views\鐢熶骇绠$悊\瀹濆伐鎺掍骇\JIT_UnLockRequestBill.html" />
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
index 4a2972e..73e787e 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
@@ -23,6 +23,7 @@
                     <form class="layui-form" action="" lay-filter="component-form-group">
                         <div style="padding: 10px; ">
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelImport" id="ExcelImport">Excel瀵煎叆</button>
+                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelDateImport" id="ExcelDateImport">瀹屽伐鏃ユ湡瀵煎叆</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">鐢熶骇璁㈠崟閫夊崟</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnAddICMO" id="btnAddICMO">娣诲姞璁㈠崟</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">淇濆瓨</button>
@@ -31,7 +32,7 @@
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLock" id="btnLock">閿佸畾</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">瑙i攣</button>
                             <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockRequest" id="btnLock">閿佸畾鐢宠</button>
-                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">瑙i攣鐢宠</button>-->
+    <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">瑙i攣鐢宠</button>-->
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">閿佸畾宸ュ崟</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">瑙i攣宸ュ崟</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">榻愬鍒嗘瀽</button>
@@ -644,7 +645,10 @@
         form.on('submit(ExcelImport)', function () {
             btnExcelImport();
         });
-
+        //瀹屽伐瀵煎叆
+        form.on('submit(ExcelDateImport)', function () {
+            btnExcelDateImport();
+        });
         //淇濆瓨
         form.on('submit(btnSave)', function (data) {
             var HWorkShopID = $("#HWorkShopID").val();//鐢熶骇杞﹂棿
@@ -1767,6 +1771,21 @@
                 }
             })
         }
+        //Excel瀹屽伐鏃ユ湡瀵煎叆
+        function btnExcelDateImport() {
+            layer.open({
+                type: 2
+                , skin: 'layui-layer-rim' //鍔犱笂杈规
+                , area: ['100%', '100%']
+                , title: 'Excel瀵煎叆'
+                , shift: 0//寮瑰嚭鍔ㄧ敾
+                , content: '../涓夊崌鎺掍骇/JIT_DayPlanPlatFormImport_SS.html?OperationType=1'
+                , end: function () {
+                    //鍒锋柊椤甸潰,
+                    location.reload();
+                }
+            })
+        }
 
         //鐗╂枡鍒楄〃
         function btnHMaterID() {
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html"
new file mode 100644
index 0000000..cadd3c7
--- /dev/null
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html"
@@ -0,0 +1,361 @@
+锘�<!DOCTYPE html>
+<html>
+<head>
+    <meta charset="utf-8" />
+    <title>鐢熶骇鏃ヨ鍒掑鍏�</title>
+    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
+    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
+    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
+    <script src="../../../layuiadmin/layui/layui.js"></script>
+    <script src="../../../layuiadmin/Scripts/json2.js"></script>
+    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
+    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
+    <script src="../../../layuiadmin/PubCustom.js"></script>
+</head>
+<body>
+    <div class="layui-fluid" style="padding: 0;">
+        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
+            <div class="layui-card-body" style="padding: 1px;">
+                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;">
+                    <div style="padding: 10px; ">
+                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">瀵煎叆鏁版嵁</button>
+                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">閫�鍑�</button>
+                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">鏂囦欢涓婁紶</button>
+                    </div>
+                    <div class="layui-tab" lay-filter="tab-POStockInBill">
+                        <div class="layui-tab-content">
+                            <!--鍩烘湰淇℃伅-->
+                            <div class="layui-tab-item layui-show">
+                                <div class="layui-form-item" style="padding-top: 10px;">
+                                    <div class="layui-row">
+                                        <div class="layui-inline">
+                                            <div class="layui-inline">
+                                                <label class="layui-form-label" style="width: 85px;">鍗曟嵁鏃ユ湡</label>
+                                                <div class="layui-input-block" style="margin-left: 120px;">
+                                                    <input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 75px;">
+                                                </div>
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label" style="width: 85px;">璁㈠崟绫诲瀷</label>
+                                            <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                                <select name="HOrderType" id="HOrderType" lay-verify="HOrderType">
+                                                    <option value="鐢熶骇璁㈠崟">鐢熶骇璁㈠崟</option>
+                                                    <option value="濮斿璁㈠崟">濮斿璁㈠崟</option>
+                                                </select>
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <div class="layui-inline">
+                                                <div class="layui-input-block" style="margin-left: 120px;">
+                                                    <input type="hidden" name="HPRDORGID" id="HPRDORGID" lay-verify="HPRDORGID">
+                                                </div>
+                                            </div>
+                                        </div>
+                                    </div>
+                                </div>
+                            </div>
+                        </div>
+                    </div>
+                    <table class="" id="mainTable" lay-filter="mainTable"></table>
+                </form>
+            </div>
+        </div>
+    </div>
+</body>
+</html>
+<script type="text/html" id="barDemo">
+    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">鍒犻櫎</a>
+</script>
+<script>
+
+    layui.config({
+        base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
+    }).extend({
+        index: 'lib/index' //涓诲叆鍙fā鍧�
+    }).use(['index', 'form', 'laydate', 'table', 'element', 'upload'], function () {
+
+        //#region 鍏叡鍙橀噺
+
+        var $ = layui.$
+            , admin = layui.admin
+            , layer = layui.layer
+            , table = layui.table
+            , form = layui.form
+            , laydate = layui.laydate
+            , excel = layui.excel
+            , upload = layui.upload
+            , element = layui.element;
+
+        var option = [];
+        //#endregion
+
+        //#region 杩涘叆椤甸潰鍗冲姞杞�
+
+        var params = getUrlVars();
+        var OperationType = params[params[0]]; //浠庡弬鏁颁腑鑾峰彇 鏁版嵁绫诲瀷  娣诲姞 淇濆瓨
+
+        //鍒濆鍖栫晫闈�
+        set_ClearBill();
+
+        //#endregion
+
+        //#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛�
+
+        //琛屽唴浜嬩欢
+        table.on('tool(mainTable)', function (obj) {
+            set_GridDelete(obj);   //琛屽唴鍒犻櫎
+            set_GridCellCheck(obj);//琛屽唴蹇嵎閿瓫閫�
+            //#region 淇敼鏃堕棿
+            var data = obj.data;
+            //鏃ヨ鍒掔敓浜ф棩鏈�
+            if (obj.event == 'HPlanEndDate') {
+                var field = $(this).data('field');
+                laydate.render({
+                    elem: this.firstChild
+                    , show: true //鐩存帴鏄剧ず
+                    , closeStop: this
+                    , done: function (nowDate) {
+                        //鏃堕棿閫夋嫨瀹屾垚锛岃鏁版嵁鏇存柊
+                        data[field] = nowDate;
+                        obj.update(data);
+                    }
+                });
+            }
+            //#endregion
+
+        });
+
+        //鏂囦欢涓婁紶
+        upload.render({
+            elem: '#UpLoad',
+            url: GetWEBURL() + '/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_SS',
+            contentType: 'application/json',
+            exts: 'xls|xlsx', //鍏佽涓婁紶鐨勭被鍨�
+            before: function (data) {
+                loadIndex = layer.load(2);
+            },
+            done: function (data1) {
+                if (data1.count == 1) {
+                    option.data = data1.data;
+                    table.render(option);
+                    layer.close(loadIndex);
+                } else {
+                    layer.close(loadIndex);
+                    layer.alert(data1.code + data1.Message, { icon: 5 });
+                }
+            },
+            error: function (err) {
+                debugger
+                layer.alert('瀵煎叆鍑虹幇寮傚父', { icon: 2 });
+            }
+        });
+
+        //閫�鍑�
+        form.on('submit(Cancel)', function () {
+            if (OperationType == 1) {
+                Pub_Close(1);
+            }
+            else {
+                Pub_Close(2);
+            }
+        })
+
+        //瀵煎叆  淇濆瓨鏁版嵁
+        form.on('submit(btnSave)', function (data) {
+            if (table.cache["mainTable"] != null) {
+                set_AddNew(data);
+            }
+            else {
+                layer.msg("鏃犳暟鎹�,璇峰厛瀵煎叆鏁版嵁!");
+            }
+        })
+
+
+        //#endregion
+
+        //#region 姝ら〉闈㈡墍鏈夌殑鏂规硶
+
+        //#region 鍒濆鍖栫晫闈�
+        function set_ClearBill() {
+            //鍒濆鍖栨椂闂�
+            $("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
+            //鍒濆鍖栬〃鏍�
+            set_InitGrid();
+        }
+
+         //#endregion
+
+        //鍒濆鍖栬〃鏍�
+        function set_InitGrid() {
+            var columns = [];
+
+            columns.push({ type: 'checkbox', fixed: 'left' });
+            columns.push({ field: 'HMaterID', title: 'HMaterID', width: 150, hide: true });
+            columns.push({ field: 'hmainid', title: 'hmainid', width: 150, hide: true });
+            columns.push({ field: 'ICMOBillHInterID', title: 'ICMOBillHInterID', width: 150, hide: true });
+            columns.push({ field: 'ICMOBillHEntryID', title: 'ICMOBillHEntryID', width: 150, hide: true });
+            columns.push({ field: '鐢熶骇璁㈠崟鍙�', title: '鐢熶骇璁㈠崟鍙�', width: 150, edit: true, hide: true });
+            columns.push({ field: '鐗╂枡缂栫爜', title: '鐗╂枡缂栫爜', width: 150, edit: true });
+            columns.push({ field: '瀹㈡埛璁㈠崟鍙�', title: '瀹㈡埛璁㈠崟鍙�', width: 200, edit: true });
+            columns.push({ field: '璁″垝缁撴潫鏃ユ湡', title: '璁″垝缁撴潫鏃ユ湡', width: 150, event: "HPlanEndDate", edit: true});
+
+            columns.push({ fixed: 'right', title: '鎿嶄綔', toolbar: '#barDemo' });
+
+            option = {
+                elem: '#mainTable'
+                , toolbar: '#toolbarDemo'
+                , height: 'full-190'
+                , page: true
+                , cellMinWidth: 90
+                , limit: 50
+                , limits: [50, 500, 5000, 20000]
+                , loading: false
+                , cols: [columns]
+            };
+
+            //娓叉煋椤甸潰
+            table.render(option);
+        }      
+
+        //瀵煎叆(淇濆瓨)
+        function set_AddNew(data) {
+
+            var num = [];
+
+            //鍒ゆ柇鏄惁鏈夊鍏ユ潈闄愶紝濡傛灉鏈夊垯灏嗘�昏杞﹂棿涔嬪墠鐨勬棩璁″垝宸ュ崟浣滃簾
+            if (!set_ModCheck("Sc_WorkBillSortBill_Edit")) {
+                layer.msg("瀵煎叆澶辫触锛佹棤瀵煎叆鏉冮檺锛�", { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
+                return;
+            } 
+
+            var HDataSub = [];
+
+            //JIT瀵煎叆璁″垝锛屾瘡娆″鍏�100琛屾暟鎹�,鍙慨鏀筰鐨勮嚜澧炲�煎喅瀹氭瘡娆″惊鐜鍏ョ殑琛屾暟
+            for (var i = 0; i < option.data.length; i += 300) {
+                HDataSub = option.data.slice(i, i + 100)
+
+                data.field.HPRDORGID = sessionStorage["OrganizationID"];//缁勭粐
+                var sMainStr = JSON.stringify(data.field);
+                var sSubStr = JSON.stringify(HDataSub);
+                var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"];
+                var index = layer.load();
+
+                $.ajax({
+                    type: "POST",
+                    url: GetWEBURL() + "/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_btnSave_SS",
+                    async: false,
+                    data: { "sMainSub": sMainSub },
+                    dataType: "json",
+                    success: function (data) {
+                        if (data.count == 1) {
+                            layer.close(index);
+                            $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
+                            layer.msg("鎻愪氦鎴愬姛");
+                        }
+                        else {
+                            layer.close(index);
+                            layer.msg(data.Message, { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
+                        }
+                    },
+                    error: function (err) {
+                        layer.close(index);
+                        layer.msg("閿欒:" + err, { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
+                    }
+                });
+            }            
+        }
+
+        //琛屽唴鍒犻櫎
+        function set_GridDelete(obj) {
+            var rowIndex = $(obj.tr).attr("data-index");
+            if (obj.event === 'del') {
+                layer.confirm('鐪熺殑鍒犻櫎琛屽悧锛�', function (index) {
+                    obj.del();
+                    table.cache["mainTable"].splice(rowIndex, 1);  //鈶″交搴曠Щ闄ゅ厓绱狅紝浠庣紦瀛橀噷绉婚櫎杩欎竴琛�
+                    option.data = table.cache["mainTable"];//灏嗘暟鎹粦瀹氬埌data涓�
+                    table.reload(option);
+                    layer.close(index);
+                });
+            }
+        }
+
+        //琛屽唴鍒犻櫎蹇嵎閿�
+        function set_GridCellCheck(obj) {
+            $(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
+                if (event.key == "F7") {
+                    //鐢熶骇璧勬簮
+                    if (obj.event == "HSourceID") {
+                        layer.open({
+                            type: 2
+                            , skin: "layui-layer-rim" //鍔犱笂杈规
+                            , title: "鐢熶骇璧勬簮鍒楄〃"  //鏍囬
+                            , closeBtn: 1  //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
+                            , shift: 2 //寮瑰嚭鍔ㄧ敾
+                            , area: ["90%", "90%"] //绐椾綋澶у皬
+                            , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
+                            , content: ["../../鍩虹璧勬枡/鐢熶骇鍩虹璧勬枡/Gy_Source.html", "yes"]
+                            , btn: ["纭畾", "鍙栨秷"]
+                            , btn1: function (index, laero) {
+                                //鎸夐挳涓�  鐨勫洖璋�
+                                var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰
+                                var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹�
+
+                                if (checkStatus.data.length != 1) {
+                                    return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
+                                }
+                                //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
+                                obj.update({
+                                    "HSourceID": checkStatus.data[0].HItemID
+                                    , "鐢熶骇璧勬簮缂栫爜*": checkStatus.data[0].鐢熶骇璧勬簮浠g爜
+                                })
+                                layer.close(index);//鍏抽棴寮圭獥
+                            }
+                        })
+                    }
+                    obj.event = "";
+                    return false;
+                }
+
+            })
+        }
+
+        //鑾峰彇鍙傛暟
+        function getUrlVars() {
+            var vars = [], hash;
+            var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
+            for (var i = 0; i < hashes.length; i++) {
+                hash = hashes[i].split('=');
+                vars.push(hash[0]);
+                vars[hash[0]] = hash[1];
+            }
+            return vars;
+        }
+
+        //#region 鏉冮檺鍒ゅ畾
+        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 (e) {
+                    layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                }
+            });
+            return Permission;
+        }
+        //#endregion
+
+        //#endregion
+
+    });
+
+</script>
\ No newline at end of file
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html"
index 51df9ce..31d1012 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html"
@@ -516,13 +516,13 @@
                             } else if (data[i].name == '鏈尮閰嶈鍗曟暟閲�') {
                                 col.push({
                                     field: '鏈尮閰嶈鍗曟暟閲�', title: '鏈尮閰嶈鍗曟暟閲�', sort: true, filter: true, templet: function (d) {
-                                        return d.鏈尮閰嶈鍗曟暟閲� > 0 ? '<span style="color: red;">' + d.鏈尮閰嶈鍗曟暟閲� + '</span>' : d.鏈尮閰嶈鍗曟暟閲�;
+                                        return d.鏈尮閰嶈鍗曟暟閲� > 0 ? '<span style="color: black;">' + d.鏈尮閰嶈鍗曟暟閲� + '</span>' : d.鏈尮閰嶈鍗曟暟閲�;
                                     } });
                             }
                             else if (data[i].name == '鏈尮閰嶈鏂欒鍒掍俊鎭暟閲�') {
                                 col.push({
                                     field: '鏈尮閰嶈鏂欒鍒掍俊鎭暟閲�', title: '鏈尮閰嶈鏂欒鍒掍俊鎭暟閲�', sort: true, filter: true, templet: function (d) {
-                                        return d.鏈尮閰嶈鏂欒鍒掍俊鎭暟閲� > 0 ? '<span style="color: red;">' + d.鏈尮閰嶈鏂欒鍒掍俊鎭暟閲� + '</span>' : d.鏈尮閰嶈鏂欒鍒掍俊鎭暟閲�;
+                                        return d.鏈尮閰嶈鏂欒鍒掍俊鎭暟閲� > 0 ? '<span style="color: black;">' + d.鏈尮閰嶈鏂欒鍒掍俊鎭暟閲� + '</span>' : d.鏈尮閰嶈鏂欒鍒掍俊鎭暟閲�;
                                     }
                                 });
                             } else if (isValidDate(data[i].name)) {
@@ -538,8 +538,8 @@
                                             dates.push(`${dateStr}`);
                                         }
                                         // 濡傛灉琛屾棩鏈熷湪褰撳墠鏃ユ湡涓夊ぉ鍚庯紝鍒欏唴瀹规爣绾�
-                                        if (this.field == dates[0] || this.field == dates[1] || this.field == dates[2]) {
-                                            return '<span style="color:red">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
+                                        if ((this.field == dates[0] || this.field == dates[1] || this.field == dates[2]) && d[this.field] != null) {
+                                            return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
                                         } else {
                                             return d[this.field] == null ? 0 : d[this.field]
                                         }

--
Gitblit v1.9.1