From 011903d7e6f1e688095c56f2662b27b1cdbf700d Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 24 九月 2024 11:41:27 +0800
Subject: [PATCH] 防错装置清单 模具保养预警报表 质量查询 照片路径拼接

---
 WebTM/views/模治具管理/器具报表/Sc_MoldMainoverdueWarnReport.html   |  295 +++++++++++++++++++++++++++++++++++++++++++++++++
 WebTM/views/车间管理/防错验证/Gy_MaterPreventErrMouldBillList.html |    2 
 WebTM/views/车间管理/单品过站/RetrospectiveQueryReport.html        |   14 ++
 WebTM/views/index.html                                     |    1 
 WebTM/WebTM.csproj                                         |    1 
 5 files changed, 311 insertions(+), 2 deletions(-)

diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj
index 228c295..5903f0f 100644
--- a/WebTM/WebTM.csproj
+++ b/WebTM/WebTM.csproj
@@ -389,6 +389,7 @@
     <Content Include="views\宸ヨ祫绠$悊\鎶�鑳借�冩牳\HR_EmployeeSkillExamBillList.html" />
     <Content Include="views\搴旀敹绠$悊\鎶ヨ〃鍒嗘瀽\Xs_SeOrderBarCodeInAndOutStockDetailReport.html" />
     <Content Include="views\鏉$爜鏄庣粏\Kf_MateOutBillList_CodeDetail.html" />
+    <Content Include="views\妯℃不鍏风鐞哱鍣ㄥ叿鎶ヨ〃\Sc_MoldMainoverdueWarnReport.html" />
     <Content Include="views\妯℃不鍏风鐞哱鍣ㄥ叿鎶ヨ〃\Sc_MouldLifeUsePicReport.html" />
     <Content Include="views\妯℃不鍏风鐞哱鍣ㄥ叿鎶ヨ〃\Sc_MouldDotCheckTaskReport.html" />
     <Content Include="views\妯℃不鍏风鐞哱鍣ㄥ叿鎶ヨ〃\Sc_MouldMaintainTaskReport.html" />
diff --git a/WebTM/views/index.html b/WebTM/views/index.html
index 1cddf4a..06edaa3 100644
--- a/WebTM/views/index.html
+++ b/WebTM/views/index.html
@@ -824,6 +824,7 @@
                                         <dd><a lay-href="鍩虹璧勬枡/鍩虹璧勬枡/Gy_StockCheckItemList.html">鐩樼偣鏂规鍒楄〃</a></dd>
                                         <dd><a lay-href="鍩虹璧勬枡/鍩虹璧勬枡/Sc_MouldStockBillMain_Temp.html">鐩樼偣璁板綍琛�</a></dd>
                                         <dd><a lay-href="鍩虹璧勬枡/鍩虹璧勬枡/InventoryAnalysis.html">鐩樼偣鍒嗘瀽鍒楄〃</a></dd>
+                                        <dd><a lay-href="鍩虹璧勬枡/鍩虹璧勬枡/Sc_MoldMainoverdueWarnReport.html">妯″叿淇濆吇閫炬湡棰勮鎶ヨ〃</a></dd>
                                     </dl>
                                 </dd>
                             </dl>
diff --git "a/WebTM/views/\346\250\241\346\262\273\345\205\267\347\256\241\347\220\206/\345\231\250\345\205\267\346\212\245\350\241\250/Sc_MoldMainoverdueWarnReport.html" "b/WebTM/views/\346\250\241\346\262\273\345\205\267\347\256\241\347\220\206/\345\231\250\345\205\267\346\212\245\350\241\250/Sc_MoldMainoverdueWarnReport.html"
new file mode 100644
index 0000000..4fd6902
--- /dev/null
+++ "b/WebTM/views/\346\250\241\346\262\273\345\205\267\347\256\241\347\220\206/\345\231\250\345\205\267\346\212\245\350\241\250/Sc_MoldMainoverdueWarnReport.html"
@@ -0,0 +1,295 @@
+锘�<!DOCTYPE html>
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head>
+    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
+    <title>妯″叿淇濆吇閫炬湡棰勮鎶ヨ〃</title>
+    <meta name="renderer" content="webkit">
+    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
+    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
+    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
+    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
+    <script src="../../../layuiadmin/layui/layui.js"></script>
+    <script src="../../../layuiadmin/layui/layui1.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>
+    <script src="../../../layuiadmin/soulTable.slim.js"></script>
+    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
+    <style>
+        /*鏍戠姸鍥剧偣鍑婚珮浜彉鑹�*/
+        .layui-tree-set-active > .layui-tree-entry .layui-tree-main {
+            background: #aef0f7;
+        }
+    </style>
+</head>
+<body>
+    <div class="layui-fluid">
+        <div class="layui-col-md12">
+            <div class="layui-card" style="padding: 1px">
+                <div class="layui-card-body" style="padding: 1px;">
+                    <form class="layui-form" action="" lay-filter="component-form-group">
+                        <div class="layui-collapse">
+                            <div class="layui-colla-item">
+                                <div class="layui-inline">
+                                    <label class="layui-form-label" style="width: 85px;">妯″叿鍒嗙被锛�</label>
+                                    <div class="layui-input-block">
+                                        <input type="text" class="layui-input" lay-verify="HMouldType" name="HMouldType" id="HMouldType" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;">
+                                        <input type="hidden" name="HMouldTypeID" id="HMouldTypeID" class="layui-input" value="0" style="float:left;width:150px;">
+                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMouldType" id="btnHMouldType" style="">
+                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
+                                        </button>
+                                    </div>
+                                </div>
+                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch" style="margin-left:40px;">
+                                    鏌ヨ
+                                </button>
+                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
+                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExit" id="btnExit" style="padding:0 5px">閫�鍑�</button>
+                            </div>
+                        </div>
+                        <table class="" id="mainTable" lay-filter="mainTable" style="margin-top:10px;"></table>
+                    </form>
+                </div>
+            </div>
+        </div>
+    </div>
+    <script>
+        //#region 鎶樺彔娉ㄩ噴
+        //#endregion
+        layui.config({
+            base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
+        }).extend({
+            index: 'lib/index', //涓诲叆鍙fā鍧�
+        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable', 'tree'], function () {
+            //#region 鍏敤鍙橀噺
+            var $ = layui.$
+                , admin = layui.admin
+                , layer = layui.layer
+                , table = layui.table
+                , form = layui.form
+                , element = layui.element
+                , laypage = layui.laypage
+                , laydate = layui.laydate
+                , soulTable = layui.soulTable
+                , tree = layui.tree
+            var sWhere = "";
+            var option = [];
+            var HModName = "Sb_EquipMaintainWarningReport";
+            //涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
+            var titleData = ["HItemID", "Hprocid", "HUSEORGID","璁惧绫诲瀷"];
+            //#endregion
+
+            //#region 杩涘叆椤甸潰鍗冲姞杞�
+
+            //鍒濆鍖栫晫闈�
+            set_ClearBill();
+            //#endregion
+
+            //#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛�
+            //鏌ヨ鎸夐挳
+            form.on('submit(btnSearch)', function (data) {
+                get_FastQuery();
+            });
+
+            //閲嶇疆鎸夐挳
+            form.on('submit(btnReSearch)', function (data) {
+                set_ClearQuery();
+            });
+
+            //閫�鍑烘寜閽�
+            form.on('submit(btnExit)', function (data) {
+                Pub_Close(2);
+            });
+
+            //妯″叿鍒嗙被
+            form.on('submit(btnHMouldType)', function (data) {//閫夋嫨璁惧鍒嗙被
+                layer.open({
+                    type: 2
+                    , area: ['80%', '80%']
+                    , title: '璁惧鍒嗙被'
+                    , shade: 0.6 //閬僵閫忔槑搴�
+                    //, maxmin: true //鍏佽鍏ㄥ睆鏈�灏忓寲
+                    , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+                    , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_MouldType.html', 'yes']
+                    , btn: ['纭畾', '鍙栨秷']
+                    , btn1: function (index, layero) {
+
+                        //鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟
+                        var iframeWindow = window['layui-layer-iframe' + index]  //鑾峰彇寮规椤甸潰
+                        var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//鑾峰彇table鐨別lem:"#test"
+                        if (checkStatus.data.length === 0) {
+                            return layer.msg('璇烽�夋嫨鏁版嵁');
+                        }
+                        $("#HMouldTypeID").val(checkStatus.data[0].HItemID);
+                        $("#HMouldType").val(checkStatus.data[0].HName);
+                        layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨�
+                    }
+                })
+            });
+            //#endregion
+
+
+            //#region 鏈〉闈㈡墍鏈夎璋冪敤鐨勬柟娉�
+
+            //#region 鍒濆鍖栫晫闈�
+            function set_ClearBill() {
+                //鍒濆鍖栬〃鏍�
+                set_InitGrid();
+                //鏌ヨ
+                get_FastQuery();
+            }
+            //#endregion
+
+            //#region 鏌ヨ
+            function get_Display(sWhere) {
+                var ajaxLoad = layer.load();
+                var HMouldTypeID = $("#HMouldTypeID").val();
+                //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛�
+                $.ajax({
+                    url: GetWEBURL() + '/Sc_MouldRepairCheckTaskReport/Sc_MoldMainoverdueWarnReport',
+                    type: "GET",
+                    data: { "HMouldTypeID": HMouldTypeID,"user": sessionStorage["HUserName"] },
+                    success: function (data1) {
+                        if (data1.count == 1) {
+                            layer.close(ajaxLoad);
+                            var data = [];
+                            var col = [];
+                            //缁欑┖鐨勬暟缁勮祴鍊�
+                            for (var key in data1.list) {
+                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
+                                //鑾峰彇涓嶉渶瑕佹樉绀虹殑鍒楋紙H寮�澶寸殑鍒椾笉鏄剧ず锛�
+                                var patrn = new RegExp(/^h/i);
+                                if (patrn.test(data1.list[key].ColmCols)) {
+                                    titleData[key] = data1.list[key].ColmCols;
+                                }
+                            }
+                            //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
+                            //col.push({ type: 'checkbox', fixed: 'left' });
+                            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) {
+                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
+                                }
+                                else {
+                                    switch (data[i].Type) {
+                                        //int
+                                        case 'DateTime':
+                                            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;
+                                        case 'long':
+                                        case 'Int32':
+                                        case 'Int64':
+                                        case 'double':
+                                        case 'Decimal':
+                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
+                                            break;
+                                        default:
+                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
+                                    }
+                                }
+                            }
+                            //鍔ㄦ�佹樉绀哄垪鍚�
+                            option = {
+                                elem: '#mainTable'
+                                , cols: [col]
+                                , data: data1.data
+                                , height: 'full-80'
+                                , page: true
+                                , limits: [50, 500, 5000, 50000]
+                                , limit: 50
+                                , cellMinWidth: 90
+                                , totalRow: true
+                                , done: function (res, curr, count) {
+                                    ////淇敼鍗曞厓鏍奸鑹�
+                                    ////宸茬偣妫� Y
+                                    ////鏈偣妫� E
+                                    ////棰勮 P
+                                    //var that = this.elem.next();
+                                    //res.data.forEach(function (item, index) {
+                                    //    var tr = that.find("[data-index=" + index + "]").children();
+                                    //    tr.each(function () {
+                                    //        var tableText = $(this).text(); //鍗曞厓鏍间腑鐨勫唴瀹�
+                                    //        if (tableText == "Y") {
+                                    //            $(this).css("background-color", "#D6F7D1");//鍗曞厓鏍艰儗鏅鑹�
+                                    //            //$(this).css("color", "#ff241c");//鍗曞厓鏍煎瓧浣撻鑹�
+                                    //        }
+                                    //        else if (tableText == "E") {
+                                    //            $(this).css("background-color", "#F5C6C6");//鍗曞厓鏍艰儗鏅鑹�
+                                    //            //$(this).css("color", "#45ff2a");//鍗曞厓鏍煎瓧浣撻鑹�
+                                    //        } else if (tableText == "P") {
+                                    //            $(this).css("background-color", "#F5F5C1");//鍗曞厓鏍艰儗鏅鑹�
+                                    //            //$(this).css("color", "#45ff2a");//鍗曞厓鏍煎瓧浣撻鑹�
+                                    //        } else {
+                                    //            //$(this).css("background-color", "#fffefd");//鍗曞厓鏍艰儗鏅鑹�
+                                    //            //$(this).css("color", "#45ff2a");//鍗曞厓鏍煎瓧浣撻鑹�
+                                    //        }
+                                    //    })
+                                    //})
+
+                                    soulTable.render(this);
+                                }
+                            }
+
+                            ins = table.render(option);
+
+                           
+                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
+                                ColFilter();
+                            }
+                        } else {
+                            option.data = data1.data
+                            ins = table.render(option);
+                            layer.close(ajaxLoad);
+                            //layer.alert(data1.code + data1.Message, { icon: 5 });
+                        }
+                    }, error: function () {
+                        layer.close(ajaxLoad);
+                        layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                    }
+
+                });
+            }
+            //#endregion
+
+            //#region 蹇�熻繃婊�
+            function get_FastQuery(sql) {
+                var HMouldType = $("#HMouldType").val();
+          
+                get_Display(sWhere);
+                sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
+            }
+            //#endregion
+
+            //#region 閲嶇疆杩囨护鏉′欢鏂规硶
+            function set_ClearQuery() {
+                $("#HMouldType").val("");
+                $("#HMouldTypeID").val("0");
+                form.render('select');
+                sWhere = "";
+            }
+            //#endregion
+
+            //鍒濆鍖栬〃鏍�
+            function set_InitGrid() {
+                option = {
+                    elem: '#mainTable'
+                    , height: 'full-50'
+                    , page: true
+                    , totalRow: true
+                    , limits: [50, 500, 5000, 20000]
+                    , limit: 50 //姣忛〉榛樿鏄剧ず鐨勬暟閲�
+                    , cellMinWidth: 200
+                    , done: function (res, curr, count) {
+                        soulTable.render(this);
+                    }
+                };
+            }
+
+            //#endregion
+
+        //浠ヤ笂鏄痩ayui妯″潡
+        });
+    </script>
+</body>
+</html>
diff --git "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\215\225\345\223\201\350\277\207\347\253\231/RetrospectiveQueryReport.html" "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\215\225\345\223\201\350\277\207\347\253\231/RetrospectiveQueryReport.html"
index 029286f..15c1aad 100644
--- "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\215\225\345\223\201\350\277\207\347\253\231/RetrospectiveQueryReport.html"
+++ "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\215\225\345\223\201\350\277\207\347\253\231/RetrospectiveQueryReport.html"
@@ -333,7 +333,19 @@
                                         col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
                                         break;
                                     default:
-                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
+                                        if (data[i].name == "鐓х墖璺緞") {
+                                            col.push({
+                                                field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150, templet: function (e) {
+                                                    var html = "";
+                                                    if (e.宸ュ簭鍚嶇О == "鎷嶇収" ) {
+                                                        html = '<a style="color:#1E9FFF" href="' + e.鐓х墖璺緞 + '" target="main_self_frame">' + e.鐓х墖璺緞+'</a>';
+                                                    }
+                                                    return html
+                                                }
+                                            });
+                                        } else {
+                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
+                                        }
                                 }
                             }
                         }
diff --git "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\351\230\262\351\224\231\351\252\214\350\257\201/Gy_MaterPreventErrMouldBillList.html" "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\351\230\262\351\224\231\351\252\214\350\257\201/Gy_MaterPreventErrMouldBillList.html"
index 0eb26c6..dc73eca 100644
--- "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\351\230\262\351\224\231\351\252\214\350\257\201/Gy_MaterPreventErrMouldBillList.html"
+++ "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\351\230\262\351\224\231\351\252\214\350\257\201/Gy_MaterPreventErrMouldBillList.html"
@@ -430,7 +430,7 @@
             function get_Display(sWhere) {
                 var ajaxLoad = layer.load();
                 $.ajax({
-                    url: GetWEBURL() + '/Gy_MaterPreventErrMouldBill/get锘縂y_MaterPreventErrMouldBillMainList',
+                    url: GetWEBURL() + '/Gy_MaterPreventErrMouldBill/get锘縂y_MaterPreventErrMouldBillMainList_Main',
                     type: "GET",
                     async: false,
                     data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]},

--
Gitblit v1.9.1