diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
index e9eb461..c713a17 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
@@ -93,7 +93,9 @@
 
     <sql id="Join_Table">
         left join ter_project_info tpi on t.project_code = tpi.project_code
-        left join ter_project_user pu on tpi.project_code = pu.project_code
+        <if test="request.userId != null and request.userId != ''">
+            left join ter_project_user pu on tpi.project_code = pu.project_code
+        </if>
     </sql>
 
     <select id="selectSnByCondition" resultType="com.newfiber.termite.domain.SnDeviceInfo">

diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
index e9eb461..c713a17 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
@@ -93,7 +93,9 @@
 
     <sql id="Join_Table">
         left join ter_project_info tpi on t.project_code = tpi.project_code
-        left join ter_project_user pu on tpi.project_code = pu.project_code
+        <if test="request.userId != null and request.userId != ''">
+            left join ter_project_user pu on tpi.project_code = pu.project_code
+        </if>
     </sql>
 
     <select id="selectSnByCondition" resultType="com.newfiber.termite.domain.SnDeviceInfo">
diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml
index 2af53b5..38af744 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml
@@ -67,7 +67,10 @@
     <sql id="Join_Table">
         left join ter_device_info di on t.sn = di.sn
         left join ter_project_info tpi on di.project_code = tpi.project_code
-        left join ter_project_user pu on tpi.project_code = pu.project_code
+
+        <if test="request.userId != null and request.userId != ''">
+            left join ter_project_user pu on tpi.project_code = pu.project_code
+        </if>
     </sql>
 
     <select id="selectByCondition" resultMap="DeviceMonitoringDataRealtimeResult">

diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
index e9eb461..c713a17 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceInfoMapper.xml
@@ -93,7 +93,9 @@
 
     <sql id="Join_Table">
         left join ter_project_info tpi on t.project_code = tpi.project_code
-        left join ter_project_user pu on tpi.project_code = pu.project_code
+        <if test="request.userId != null and request.userId != ''">
+            left join ter_project_user pu on tpi.project_code = pu.project_code
+        </if>
     </sql>
 
     <select id="selectSnByCondition" resultType="com.newfiber.termite.domain.SnDeviceInfo">
diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml
index 2af53b5..38af744 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/DeviceMonitoringDataRealtimeMapper.xml
@@ -67,7 +67,10 @@
     <sql id="Join_Table">
         left join ter_device_info di on t.sn = di.sn
         left join ter_project_info tpi on di.project_code = tpi.project_code
-        left join ter_project_user pu on tpi.project_code = pu.project_code
+
+        <if test="request.userId != null and request.userId != ''">
+            left join ter_project_user pu on tpi.project_code = pu.project_code
+        </if>
     </sql>
 
     <select id="selectByCondition" resultMap="DeviceMonitoringDataRealtimeResult">
diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml
index fc813d9..773a999 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/MonitoringWarnRecordMapper.xml
@@ -85,7 +85,10 @@
     <sql id="Join_Table">
       left join ter_device_info di on t.sn = di.sn
       left join ter_project_info tpi on di.project_code = tpi.project_code
-      left join ter_project_user pu on tpi.project_code = pu.project_code
+
+        <if test="request.userId != null and request.userId != ''">
+            left join ter_project_user pu on tpi.project_code = pu.project_code
+        </if>
     </sql>
 
     <select id="selectByCondition" resultMap="MonitoringWarnRecordResult">