From e9f4b1002914c7eb7a426b7a163bf49079f61d2f Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期二, 27 七月 2021 11:26:28 +0800
Subject: [PATCH] 基础数据库bug修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java
index 25c91a1..8befd43 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComSwPatrolRecordDAO.java
@@ -25,9 +25,9 @@
"cspr.id, " +
"cspr.community_id AS communityId, " +
"cspr.patrol_time AS patrolTime, " +
- "cspr.weather" +
- "cspr.temperature" +
- "cspr.wind" +
+ "cspr.weather," +
+ "cspr.temperature," +
+ "cspr.wind," +
"cspr.patrol_type AS patrolType, " +
"cspr.patrol_person AS patrolPerson, " +
"cspr.address, " +
@@ -38,11 +38,11 @@
"cspr.succession_person AS successionPerson, " +
"cspr.succession_time AS successionTime, " +
"cspr.create_at AS createAt, " +
- "cspr.create_time AS createTime," +
- "csprr.report_id AS reportId" +
- "FROM " +
- "com_sw_patrol_record AS cspr" +
- "left join com_sw_patrol_record_report AS csprr on cspr.id = csprr.patrol_record_id" +
+ "cspr.create_by AS createBy, " +
+ "csprr.report_id AS reportId " +
+ "FROM " +
+ "com_sw_patrol_record as cspr " +
+ "left join com_sw_patrol_record_report as csprr on csprr.patrol_record_id = cspr.id " +
"<where>" +
"<if test='comSwPatrolRecordDTO.communityId != null and comSwPatrolRecordDTO.communityId != ""'>" +
"AND cspr.community_id = #{comSwPatrolRecordDTO.communityId} " +
@@ -60,7 +60,7 @@
"AND cspr.patrol_time <![CDATA[ <= ]]> #{comSwPatrolRecordDTO.patrolTime} " +
" </if> " +
" </where>" +
- " order by create_at desc" +
+ " order by cspr.create_at desc" +
"</script>")
IPage<ComSwPatrolRecordVO> pagePatrolRecord(Page page, @Param("comSwPatrolRecordDTO") ComSwPatrolRecordDTO comSwPatrolRecordDTO);
}
--
Gitblit v1.7.1