From b50e7f99c2f1b91dbc2a6cce7c9f113ad7ce459f Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期五, 20 八月 2021 10:56:25 +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/java/com/panzhihua/service_community/service/ComActEasyPhotoService.java | 3
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java | 17 ++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommunityApi.java | 8 +
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml | 98 +++++++++++++++++++
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/easyPhoto/ExportEasyPhotoDTO.java | 31 ++++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActEasyPhotoServiceImpl.java | 18 +++
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java | 26 +++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java | 4
springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java | 81 +++++++++++++++-
10 files changed, 285 insertions(+), 9 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/easyPhoto/ExportEasyPhotoDTO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/easyPhoto/ExportEasyPhotoDTO.java
new file mode 100644
index 0000000..47ba8da
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/easyPhoto/ExportEasyPhotoDTO.java
@@ -0,0 +1,31 @@
+package com.panzhihua.common.model.dtos.community.easyPhoto;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.io.Serializable;
+import java.util.Date;
+import java.util.List;
+
+@Data
+public class ExportEasyPhotoDTO {
+ @ApiModelProperty(value = "批量勾选时传参数组")
+ private List<Integer> ids;
+ @ApiModelProperty(value = "关键词")
+ private String keyWord;
+ @ApiModelProperty("社区id")
+ private Long communityId;
+ private Integer type;
+ @ApiModelProperty("处理人名字")
+ private String handlerName;
+ @ApiModelProperty("查询-创建开始时间")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+ private Date createBegin;
+
+ @ApiModelProperty("查询-创建结束时间")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+ private Date createEnd;
+ @ApiModelProperty("城管安排状态")
+ private Integer urbanStatus;
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java
new file mode 100644
index 0000000..b0d042f
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java
@@ -0,0 +1,26 @@
+package com.panzhihua.common.model.vos.community.easyPhoto;
+
+import com.alibaba.excel.annotation.ExcelProperty;
+import lombok.Data;
+
+import java.util.Date;
+
+@Data
+public class ExportEasyPhotoVO {
+ @ExcelProperty("所属社区")
+ private String communityName;
+ @ExcelProperty("发起人")
+ private String sponsorName;
+ @ExcelProperty("事件详情")
+ private String detail;
+ @ExcelProperty("发生地点")
+ private String happenAddr;
+ @ExcelProperty("事件类型")
+ private String photoType="其他";
+ @ExcelProperty("联系电话")
+ private String phone;
+ @ExcelProperty("处理人名字")
+ private String handlerName;
+ @ExcelProperty("创建时间")
+ private Date createAt;
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
index 21be336..e4bfba9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -10,10 +10,7 @@
import com.panzhihua.common.model.dtos.community.bigscreen.work.ScreenActActivityPeopleListDTO;
import com.panzhihua.common.model.dtos.community.bigscreen.work.ScreenDiscussListDTO;
import com.panzhihua.common.model.dtos.community.bigscreen.work.ScreenMicroListDTO;
-import com.panzhihua.common.model.dtos.community.easyPhoto.AddEasyPhotoActivityDTO;
-import com.panzhihua.common.model.dtos.community.easyPhoto.EditEasyPhotoActivityDTO;
-import com.panzhihua.common.model.dtos.community.easyPhoto.PageEasyPhotoActivityDTO;
-import com.panzhihua.common.model.dtos.community.easyPhoto.PageEasyPhotoActivityUserDTO;
+import com.panzhihua.common.model.dtos.community.easyPhoto.*;
import com.panzhihua.common.model.dtos.community.integral.ComActIntegralCommunityRankDTO;
import com.panzhihua.common.model.dtos.community.integral.admin.AddComActIntegralUserDTO;
import com.panzhihua.common.model.dtos.community.integral.admin.EditComActIntegralRuleDTO;
@@ -342,8 +339,19 @@
*/
@PostMapping("/esayPhotoCount")
R esayphotoCount(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO);
+
+ /**
+ *
+ * 城管安排
+ */
@PostMapping("updatePageeasyphoto")
R updatePageeasyphoto(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO);
+ /**
+ *
+ * 随手拍城管导出
+ */
+ @PostMapping("exportEasyPhoto")
+ R exportEasyPhoto(@RequestBody ExportEasyPhotoDTO exportEasyPhotoDTO);
/**
* 新增社区
*
@@ -4256,4 +4264,5 @@
*/
@GetMapping("/questnaire/statisticsSummary/header")
R statisticsSummaryHeader(@RequestParam("questId") Long questId);
+
}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java
index 2a57a43..88e70b4 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java
@@ -1,9 +1,13 @@
package com.panzhihua.community_backstage.api;
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.ExcelWriter;
+import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.dtos.community.GrantRewardDTO;
+import com.panzhihua.common.model.dtos.community.easyPhoto.ExportEasyPhotoDTO;
import com.panzhihua.common.model.dtos.community.integral.admin.AddComActIntegralUserDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
@@ -13,24 +17,25 @@
import com.panzhihua.common.model.vos.user.SysUserNoticeVO;
import com.panzhihua.common.service.community.CommunityService;
import com.panzhihua.common.service.user.UserService;
-import com.panzhihua.common.utlis.DateUtils;
-import com.panzhihua.common.utlis.StringUtils;
-import com.panzhihua.common.utlis.WxUtil;
-import com.panzhihua.common.utlis.WxXCXTempSend;
+import com.panzhihua.common.utlis.*;
+import com.panzhihua.common.model.vos.community.easyPhoto.ExportEasyPhotoVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Value;
import org.springframework.util.ObjectUtils;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import javax.validation.Valid;
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.InputStream;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
-import java.util.stream.Collectors;
/**
* @program: springcloud_k8s_panzhihuazhihuishequ
@@ -47,6 +52,21 @@
private UserService userService;
@Resource
private CommunityService communityService;
+ @Value("${excel.userurl}")
+ private String excelUrl;
+
+ // FTP 登录用户名
+ @Value("${ftp.username}")
+ private String userName;
+ // FTP 登录密码
+ @Value("${ftp.password}")
+ private String password;
+ // FTP 服务器地址IP地址
+ @Value("${ftp.host}")
+ private String host;
+ // FTP 端口
+ @Value("${ftp.port}")
+ private int port;
@ApiOperation(value = "活动负责人下拉选择", response = ActivityManagerVO.class)
@GetMapping("listactivitymanager")
@@ -284,6 +304,57 @@
public R updatePageeasyphoto(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO) {
return communityService.updatePageeasyphoto(comActEasyPhotoVO);
}
+ @ApiOperation(value = "城管随手拍导出")
+ @PostMapping("exportEasyPhoto")
+ public R exportEasyPhoto(@RequestBody ExportEasyPhotoDTO exportEasyPhotoDTO){
+ String url = excelUrl;
+ String name = "随手拍.xlsx";
+ String ftpUrl = "/mnt/data/web/excel/";
+ R r=communityService.exportEasyPhoto(exportEasyPhotoDTO);
+ if(R.isOk(r)){
+ List<ExportEasyPhotoVO> comActEasyPhotoVOS = JSONArray.parseArray(JSONArray.toJSONString(r.getData()), ExportEasyPhotoVO.class);
+ try {
+ SFTPUtil sftp = new SFTPUtil(userName, password, host, port);
+ sftp.login();
+ boolean existDir = sftp.isExistDir(ftpUrl + name);
+ if (!existDir) {
+ String property = System.getProperty("user.dir");
+ String fileName = property + File.separator + name;
+ // 这里 需要指定写用哪个class去写
+ ExcelWriter excelWriter = null;
+ InputStream inputStream = null;
+ try {
+ excelWriter = EasyExcel.write(fileName, ExportEasyPhotoVO.class).build();
+ WriteSheet writeSheet = EasyExcel.writerSheet("随手拍导出").build();
+ excelWriter.write(comActEasyPhotoVOS, writeSheet);
+ excelWriter.finish();
+ File file = new File(fileName);
+ inputStream = new FileInputStream(file);
+ sftp.uploadMore(ftpUrl, name, inputStream);
+ sftp.logout();
+ inputStream.close();
+ String absolutePath = file.getAbsolutePath();
+ boolean delete = file.delete();
+ log.info("删除excel【{}】结果【{}】", absolutePath, delete);
+ } finally {
+ // 千万别忘记finish 会帮忙关闭流
+ if (inputStream != null) {
+ inputStream.close();
+ }
+ if (excelWriter != null) {
+ excelWriter.finish();
+ }
+ }
+ }
+ return R.ok(url + name);
+ } catch (Exception e) {
+ e.printStackTrace();
+ log.error("文件传输失败【{}】", e.getMessage());
+ return R.fail();
+ }
+ }
+ return R.fail("未查询到数据");
+ }
@ApiOperation(value = "查询所有社区列表")
@GetMapping("community/list")
public R getCommunityLists(){
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommunityApi.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommunityApi.java
index 4437e70..cb62445 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommunityApi.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommunityApi.java
@@ -9,6 +9,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.exceptions.ServiceException;
import com.panzhihua.common.model.dtos.community.*;
+import com.panzhihua.common.model.dtos.community.easyPhoto.ExportEasyPhotoDTO;
import com.panzhihua.common.model.dtos.community.questnaire.StatisticsSummaryDTO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.SystemmanagementConfigVO;
@@ -487,6 +488,13 @@
public R updatePageeasyphoto(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO) {
return comActEasyPhotoService.updatePageeasyphoto(comActEasyPhotoVO);
}
+ /**
+ * 城管导出
+ */
+ @PostMapping("exportEasyPhoto")
+ public R exportEasyPhoto(@RequestBody ExportEasyPhotoDTO exportEasyPhotoDTO){
+ return comActEasyPhotoService.export(exportEasyPhotoDTO);
+ }
/**
* 随手拍详情
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 646463c..90d885b 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
@@ -3,10 +3,12 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.dtos.community.easyPhoto.ExportEasyPhotoDTO;
import com.panzhihua.common.model.vos.community.ComActEasyPhotoVO;
import com.panzhihua.common.model.vos.community.TodoEventsVO;
import com.panzhihua.common.model.vos.community.easyPhoto.ComActEasyPhotoCountVO;
import com.panzhihua.common.model.vos.community.easyPhoto.ComActEasyPhotoStatisticsVO;
+import com.panzhihua.common.model.vos.community.easyPhoto.ExportEasyPhotoVO;
import com.panzhihua.common.model.vos.screen.EastPhotoTypeVO;
import com.panzhihua.common.model.vos.screen.EastPhotoVO;
import com.panzhihua.service_community.model.dos.ComActEasyPhotoDO;
@@ -323,4 +325,6 @@
// " AND community_id = #{communityId} and del_tag = 0")
ComActEasyPhotoStatisticsVO getEasyPhotoStatistics(@Param("communityId")Long communityId);
ComActEasyPhotoCountVO easyPhotoCount(ComActEasyPhotoVO comActEasyPhotoVO);
+ List<ExportEasyPhotoVO> export(ExportEasyPhotoDTO exportEasyPhotoDTO);
+ List<ExportEasyPhotoVO> exportByIds(List<Integer> ids);
}
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 2dfc132..8449b47 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
@@ -145,6 +145,14 @@
* 完成人id
*/
private Long completeId;
+ /**
+ * 安排状态
+ */
+ private Integer urbanStatus;
+ /**
+ * 是否安排
+ */
+ private Integer isReportUrban;
/**
* 参加活动标签（1.优质 2.精良 3.普通 4.一般）
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActEasyPhotoService.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActEasyPhotoService.java
index a8f9f8d..4cbf4be 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActEasyPhotoService.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActEasyPhotoService.java
@@ -5,6 +5,7 @@
import com.panzhihua.common.model.dtos.community.GrantRewardDTO;
import com.panzhihua.common.model.dtos.community.PageComActEasyPhotoCommentDTO;
import com.panzhihua.common.model.dtos.community.ComActEasyPhotoCommentUserDTO;
+import com.panzhihua.common.model.dtos.community.easyPhoto.ExportEasyPhotoDTO;
import com.panzhihua.common.model.dtos.partybuilding.ComPbServiceTeamDTO;
import com.panzhihua.common.model.dtos.partybuilding.PageComPbServiceTeamDTO;
import com.panzhihua.common.model.vos.R;
@@ -117,4 +118,6 @@
R easyPhotoCount(ComActEasyPhotoVO comActEasyPhotoVO);
R updatePageeasyphoto(ComActEasyPhotoVO comActEasyPhotoVO);
+
+ R export(ExportEasyPhotoDTO exportEasyPhotoDTO);
}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActEasyPhotoServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActEasyPhotoServiceImpl.java
index ae71d68..d0fd140 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActEasyPhotoServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActEasyPhotoServiceImpl.java
@@ -8,8 +8,10 @@
import com.panzhihua.common.model.dtos.community.GrantRewardDTO;
import com.panzhihua.common.model.dtos.community.PageComActEasyPhotoCommentDTO;
import com.panzhihua.common.model.dtos.community.ComActEasyPhotoCommentUserDTO;
+import com.panzhihua.common.model.dtos.community.easyPhoto.ExportEasyPhotoDTO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.*;
+import com.panzhihua.common.model.vos.community.easyPhoto.ExportEasyPhotoVO;
import com.panzhihua.common.utlis.*;
import com.panzhihua.service_community.dao.*;
import com.panzhihua.service_community.model.dos.*;
@@ -18,6 +20,7 @@
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
+import org.springframework.util.CollectionUtils;
import org.springframework.util.ObjectUtils;
import javax.annotation.Resource;
@@ -644,5 +647,20 @@
return R.fail();
}
+ @Override
+ public R export(ExportEasyPhotoDTO exportEasyPhotoDTO) {
+ if(exportEasyPhotoDTO!=null){
+ List<ExportEasyPhotoVO> list;
+ if(!CollectionUtils.isEmpty(exportEasyPhotoDTO.getIds())){
+ list=this.comActEasyPhotoDAO.exportByIds(exportEasyPhotoDTO.getIds());
+ }
+ else {
+ list=this.comActEasyPhotoDAO.export(exportEasyPhotoDTO);
+ }
+ return R.ok(list);
+ }
+ return R.fail("参数错误");
+ }
+
}
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 ac4a904..fed2953 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
@@ -141,4 +141,102 @@
</where>
</select>
+ <select id="export" resultType="com.panzhihua.common.model.vos.community.ComActEasyPhotoVO">
+ SELECT
+ p.id,
+ u.`name` sponsor_name,
+ u.phone phone,
+ count( pu.id ) giveThumbsUpNum,
+ u.image_url,
+ p.happen_addr,
+ su.`name` handler_name,
+ p.`status`,
+ p.`detail`,
+ p.`is_need_feed_back`,
+ p.`photo_path_list`,
+ p.create_at,
+ p.feedback_at,
+ p.is_report,
+ p.is_publicity,
+ p.activity_type,
+ p.activity_amount,
+ p.activity_id,
+ p.examine_at,
+ c.name communityName,
+ p.is_report_urban,
+ p.urban_status
+ FROM
+ com_act_easy_photo p
+ LEFT JOIN sys_user u ON p.sponsor_id = u.user_id
+ LEFT JOIN com_act_easy_photo_user pu ON p.id = pu.easy_photo_id
+ LEFT JOIN sys_user su ON p.handler_id = su.user_id
+ left join com_act c on p.community_id =c.community_id
+ WHERE
+ p.del_tag = 0 and p.`is_report_urban` =1
+ <if test='communityId != null and communityId != 0'>
+ and p.community_id=#{communityId}
+ </if>
+ <if test='urbanStatus != null ' >
+ AND p.`urban_status` = #{urbanStatus}
+ </if>
+ <if test='createBegin != null '>
+ AND p.create_at BETWEEN #{createBegin}
+ AND #{createEnd}
+ </if>
+
+ <if test='keyWord != null and keyWord != ""'>
+ AND (u.`name` like concat(#{keyWord},'%') or
+ p.happen_addr like concat(#{keyWord},'%') or
+ su.`name` like concat(#{keyWord},'%') or
+ p.detail like concat(#{keyWord},'%')
+ )
+ </if>
+ GROUP BY
+ p.id
+ ORDER BY
+ p.create_at DESC
+ </select>
+
+ <select id="exportByIds" resultType="com.panzhihua.common.model.vos.community.easyPhoto.ExportEasyPhotoVO">
+ SELECT
+ p.id,
+ u.`name` sponsor_name,
+ u.phone phone,
+ count( pu.id ) giveThumbsUpNum,
+ u.image_url,
+ p.happen_addr,
+ su.`name` handler_name,
+ p.`status`,
+ p.`detail`,
+ p.`is_need_feed_back`,
+ p.`photo_path_list`,
+ p.create_at,
+ p.feedback_at,
+ p.is_report,
+ p.is_publicity,
+ p.activity_type,
+ p.activity_amount,
+ p.activity_id,
+ p.examine_at,
+ c.name communityName,
+ p.is_report_urban,
+ p.urban_status
+ FROM
+ com_act_easy_photo p
+ LEFT JOIN sys_user u ON p.sponsor_id = u.user_id
+ LEFT JOIN com_act_easy_photo_user pu ON p.id = pu.easy_photo_id
+ LEFT JOIN sys_user su ON p.handler_id = su.user_id
+ left join com_act c on p.community_id =c.community_id
+ WHERE
+ p.id in
+ <foreach collection="list" item="ids" index="index"
+ open="(" close=")" separator=",">
+ #{ids}
+ </foreach>
+ GROUP BY
+ p.id
+ ORDER BY
+ p.create_at DESC
+ </select>
+
</mapper>
--
Gitblit v1.7.1