| | |
| | | "p.urban_status, " + |
| | | "p.img_width, " + |
| | | "p.img_height, " + |
| | | "p.evaluate_date, " + |
| | | "caepe.score," + |
| | | "caepe.`content` " + |
| | | "caepe.`content`, " + |
| | | "p.handle_photo_list " + |
| | | "FROM " + |
| | | "com_act_easy_photo p " + |
| | |
| | | "AND p.sponsor_id =#{comActEasyPhotoVO.sponsorId} " + |
| | | " </if> " + |
| | | "<if test='comActEasyPhotoVO.sponsorId == null or comActEasyPhotoVO.sponsorId==0'>" + |
| | | "AND p.`status` in (2,4) and p.is_publicity = 1 " + |
| | | "AND p.`status` in (2,5) and p.is_publicity = 1 " + |
| | | " </if> " + |
| | | "<if test='comActEasyPhotoVO.keyWord != null and comActEasyPhotoVO.keyWord != ""'>" + |
| | | "AND (class.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or p.detail like concat(#{comActEasyPhotoVO.keyWord},'%')) " + |
| | |
| | | * @return |
| | | */ |
| | | IPage<ComActEasyPhotoVO> indexEasyPhotoList(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO); |
| | | |
| | | /** |
| | | * 随手拍治安防控记录列表 |
| | | * @param communityId |
| | | * @param pageSize |
| | | * @return |
| | | */ |
| | | List<ComActEasyPhotoVO> getPartyBuildIngRecord(@Param("communityId") Long communityId, @Param("pageSize") Integer pageSize); |
| | | } |