From 7900b7157f4d324cc014a17d012f5da5e7c298b0 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期三, 02 七月 2025 13:54:13 +0800
Subject: [PATCH] 月度汇报统计表 添加 超链接 根据超链接打开任务汇报列表根据传递的数据查找对应职员在指定范围内的汇报任务

---
 WebTM/views/项目管理/工作任务/PM_WorkTaskReportBillList.html |   25 ++++++++++++++++++-------
 1 files changed, 18 insertions(+), 7 deletions(-)

diff --git "a/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskReportBillList.html" "b/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskReportBillList.html"
index 814c985..8e2c1ec 100644
--- "a/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskReportBillList.html"
+++ "b/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskReportBillList.html"
@@ -21,6 +21,7 @@
     <script src="../../../layuiadmin/PubCustom.js"></script>
     <script src="../../../layuiadmin/soulTable.slim.js"></script>
     <script src="../../../layuiadmin/PageTitle.js"></script>
+    <script src="../../../layuiadmin/common.js"></script>
 
 
 </head>
@@ -410,11 +411,6 @@
                 //鍒濆鍖栫粍缁�
                 Organ();
                 //鏌ヨ
-                if (addSWhereByOpenType()) {                        //addSWhereByOpenType()鏂规硶鍒ゆ柇鏄惁鍏跺畠椤甸潰鎵撳紑鏈〉闈紝鑻ユ槸鍒欏鐞嗚繃婊ゆ潯浠讹紝骞惰繑鍥瀟rue
-                    get_FastQuery(2);
-                } else {
-                    get_FastQuery(1);
-                }
                 //鏌ヨ褰撳墠鐧诲綍鐢ㄦ埛鏈夋病鏈夊湪褰撳墠妯″潡璁剧疆榛樿杩囨护鏂规
                 get_DefaultModule();
             }
@@ -620,11 +616,14 @@
             //#region 蹇�熻繃婊�
             function get_FastQuery(number) {
                 ////鑾峰彇鐧诲綍璐︽埛瀵瑰簲鑱屽憳鍚嶇О
+
+                let openType = addSWhereByOpenType()
                 var HUserName = getHEmpByHUserName();
                 if (HUserName != "" && HUserName != null) {
-                    sWhere = " and 姹囨姤浜� = N'" + HUserName + "' OR 鎺ユ敹浜� = N'" + HUserName + "' OR 鎶勯�佷汉 like N'%"
+                    sWhere += " and 姹囨姤浜� = N'" + HUserName + "' OR 鎺ユ敹浜� = N'" + HUserName + "' OR 鎶勯�佷汉 like N'%"
                         + HUserName + "%'";
                 }
+                
 
                 var HOrgID = "";
                 var HBillNo = $("#HBillNo").val();  //鍗曟嵁鍙�
@@ -707,7 +706,7 @@
                     }
                     sWhere += " and " + ColName2 + " " + com2;
                 }
-                if (number == 1) {
+                if (openType == false) {
                     HOrgID = sessionStorage["OrganizationID"];
                 }
                 else {
@@ -1245,6 +1244,18 @@
                 var params = getUrlVars();
                 var openType = params[params[0]]; //浠庡弬鏁颁腑鑾峰彇 鎵撳紑鏂瑰紡  1鐩存帴鎵撳紑 2鍏跺畠椤甸潰閫氳繃閫夋嫨鎸夐挳鎵撳紑
                 var HOrgID = params[params[1]];
+                var Employee = params[params[2]]; // 鑱屽憳
+                var DateInfo = params[params[3]]; // 鏃ユ湡淇℃伅
+                if (isEmpty(Employee) === false && isEmpty(DateInfo) === false) {
+                    let EmployeeDecode = decodeURIComponent(Employee)
+                    debugger
+                    $('#HReportEmp').val(EmployeeDecode)
+                    if (DateInfo.length == 7) { //骞存湀
+                        sWhere += " and 鏃ユ湡 >= CAST(N'" + DateInfo + "' + '-01' AS DATE) and 鏃ユ湡 < DATEADD(MONTH, 1, CAST(N'" + DateInfo + "' + '-01' AS DATE))"
+                    } else if (DateInfo.length == 10) { //骞存湀鏃�
+                        sWhere += " and 鏃ユ湡 >= CAST(N'" + DateInfo + "' AS DATE) and 鏃ユ湡 < DATEADD(DAY, 1, CAST(N'" + DateInfo + "' AS DATE))"
+                    }
+                }
                 if (openType == 2) {
                     sWhere += " and ISNULL(鍏抽棴浜�,'') = '' and ISNULL(浣滃簾浜�,'') = '' ";
                     $("#HOrgID").val(HOrgID);

--
Gitblit v1.9.1