From 508dd8dde98b7da379e56a819d1cb8d78b98a110 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期一, 23 八月 2021 15:55:42 +0800
Subject: [PATCH] 随手拍新增图片宽高

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActEasyPhotoDO.java |    8 ++++++++
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml                          |    7 ++++++-
 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java             |    6 ++++++
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java      |    8 ++++++--
 4 files changed, 26 insertions(+), 3 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java
index 8796d79..2da7584 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActEasyPhotoVO.java
@@ -200,4 +200,10 @@
         int yes = 1;
         int ret = 2;
     }
+    @ApiModelProperty(value = "单张图片宽度")
+    private BigDecimal imgWidth;
+
+    @ApiModelProperty(value = "单张图片高度")
+    private BigDecimal imgHeight;
+
 }
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
index 6e51573..be971e5 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
@@ -199,13 +199,15 @@
             "p.activity_id, " +
             "p.activity_amount, " +
             "count(pu.id)giveThumbsUpNum, " +
-            "p.handle_photo_list," +
             "c.name communityName," +
             "p.transfer_time," +
             "p.is_report_urban," +
             "p.transfer_reason," +
             "ca.`name` as classifyName," +
-            "p.urban_status " +
+            "p.urban_status, " +
+            "p.img_width, " +
+            "p.img_height, " +
+            "p.handle_photo_list " +
             "FROM " +
             "com_act_easy_photo p " +
             "JOIN sys_user u on p.sponsor_id=u.user_id " +
@@ -258,6 +260,8 @@
             "p.activity_amount, " +
             "p.classify_id, " +
             "class.`name` as classifyName, " +
+            "p.img_width, " +
+            "p.img_height, " +
             "p.examine_at  " +
             "FROM " +
             "com_act_easy_photo p " +
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActEasyPhotoDO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActEasyPhotoDO.java
index b2b5cf5..0db0dbe 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActEasyPhotoDO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActEasyPhotoDO.java
@@ -173,6 +173,14 @@
      * 随手拍分类id
      */
     private Long classifyId;
+    /**
+     * 单张图片宽度
+     */
+    private BigDecimal imgWidth;
+    /**
+     * 单张图片高度
+     */
+    private BigDecimal imgHeight;
 
     /**
      * 参加活动标签(1.优质 2.精良 3.普通 4.一般)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
index de1da02..7fa1ddc 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
@@ -29,11 +29,16 @@
         <result column="activity_type" property="activityType" />
         <result column="activity_amount" property="activityAmount" />
         <result column="activity_id" property="activityId" />
+        <result column="img_width" property="imgWidth" />
+        <result column="img_height" property="imgHeight" />
     </resultMap>
 
     <!-- 通用查询结果列 -->
     <sql id="Base_Column_List">
-        id, sponsor_id, happen_addr, addr_remark, status, handler_id, create_at, examine_at, detail, photo_path_list, handle_result, handle_photo_list, community_id, is_hide, is_need_feed_back, feedback_at, reject_reason, del_tag, is_report, is_publicity, handle_status, lng_lat, activity_type, activity_amount, activity_id
+        id, sponsor_id, happen_addr, addr_remark, status, handler_id, create_at, examine_at, detail, photo_path_list
+        , handle_result, handle_photo_list, community_id, is_hide, is_need_feed_back, feedback_at, reject_reason
+        , del_tag, is_report, is_publicity, handle_status, lng_lat, activity_type, activity_amount, activity_id
+        , img_width, img_height
     </sql>
 
     <select id="pageEasyPhotoAdmin" parameterType="com.panzhihua.common.model.vos.community.ComActEasyPhotoVO"

--
Gitblit v1.7.1