From 727ee25aeb5fcaf84e2cf009b2eacd3a86bcb3ca Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 28 十一月 2024 12:55:23 +0800
Subject: [PATCH] 新增 环境检测方案,环境检测单

---
 WebTM/views/质量管理/质量报表/QC_ErrManagerLedgerReport_SourceOfTheProblem.html |  120 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 112 insertions(+), 8 deletions(-)

diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html"
index f7dfbe8..33ada74 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html"
@@ -41,12 +41,38 @@
                                             <!--鍔ㄦ�佹覆鏌撳勾浠�-->
                                         </select>
                                     </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: 85px;">
                                         <select name="HMonth" id="HMonth" lay-verify="HMonth">
                                             <!--鍔ㄦ�佹覆鏌撴湀浠�-->
+                                        </select>
+                                    </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                         </select>
                                     </div>
                                 </div>
@@ -76,6 +102,7 @@
                         </div>
                         <script type="text/html" id="toolbarDemo">
                             <div class="layui-btn-container">
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Export" id="btn_Export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>闅愯棌鍒楄缃�</button>
                             </div>
@@ -107,6 +134,7 @@
             //鏌ヨ鏉′欢
             var sWhere = "";
             var option = [];
+            var ins;                //鐢ㄤ簬瀵煎嚭excel
             var HModName = "QC_ErrManagerLedgerReport_SourceOfTheProblem";
             var HSourceOfTheProblem = []; //寮傚父闂鏉ユ簮
             //#endregion
@@ -360,6 +388,9 @@
                     case 'HideColumn':
                         get_HideColumn();
                         break;
+                    //瀵煎嚭鎸夐挳
+                    case 'btn_Export': btn_Export();
+                        break;
                 };
             });
             //閲嶇疆鎸夐挳
@@ -378,7 +409,9 @@
             //鍒濆鍖栫晫闈�
             function set_ClearBill() {
                 Year();
-                Month();               
+                Month();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
                 //鍔犺浇鏁版嵁鍒扮綉鏍�
@@ -428,15 +461,13 @@
             }
 
             //鍔犺浇缃戞牸
-            function get_Display(DateYear) {
-                var HYear = $("#HYear").val();
-                var HMonth = $("#HMonth").val();
+            function get_Display(sWhere) {               
                 var wait = layer.load();//閬僵
                 $.ajax({
                     url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_SourceOfTheProblem',
                     type: "GET",
                     async: false,
-                    data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] },
+                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         var col = [];
                         if (data1.count == 1) {
@@ -478,6 +509,7 @@
                             option.data = data1.data;
 
                             table.render(option);
+                            ins = table.render(option);
                             layer.close(wait);
                         } else {
                             layer.close(wait);
@@ -492,7 +524,19 @@
 
             //蹇�熻繃婊�
             function get_FastQuery() {
-                get_Display(sWhere);
+                var HYear = $("#HYear").val();
+                var HMonth = $("#HMonth").val();
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HMonth: HMonth
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
                 sWhere = "";
                 set_Graphics();
@@ -503,13 +547,73 @@
                 var yyyy = new Date().getFullYear();
                 $("#HYear").val(yyyy);
                 var mm = new Date().getMonth() + 1;
-                $("#HMonth").val(mm)
+                $("#HMonth").val(mm);
+                $("#HProject").val("");
+                $("#HBatchWork").val("");
+                $("#HDivisionName").val("");
                 form.render('select');
 
                 sWhere = "";
                 get_FastQuery();
             }
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 瀵煎嚭Execel
+            function btn_Export() {
+                table.exportFile(ins.config.id, option.data, "xls");
+            }
+            //#endregion
+
+
             //闅愯棌鍒楄缃�
             function get_HideColumn() {
                 var colName = "";

--
Gitblit v1.9.1