diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
index a2f2780..e43cdcf 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
@@ -33,7 +33,13 @@
         `ter_device_info` ta
         JOIN ter_project_user pu ON ta.project_code = pu.project_code
         LEFT JOIN ter_device_monitoring_data_realtime tb ON ta.sn = tb.sn
-      where 1=1 and ta.del_flag = 0 and pu.user_id = #{request.userId} and pu.project_name like concat('%', #{request.projectName}, '%')
+      where 1=1 and ta.del_flag = 0
+        <if test="request.userId != null and request.userId != ''">
+            and pu.user_id = #{request.userId}
+        </if>
+        <if test="request.projectName != null and request.projectName != ''">
+            and pu.project_name  like concat('%',#{request.projectName},'%')
+        </if>
         <if test="request.sn != null and request.sn != ''">
             and ta.sn  like concat('%',#{request.sn},'%')
         </if>