| | |
| | | "p.urban_status, " + |
| | | "p.img_width, " + |
| | | "p.img_height, " + |
| | | "p.evaluate_date, " + |
| | | "caepe.score," + |
| | | "caepe.`content`, " + |
| | | "p.handle_photo_list " + |
| | | "FROM " + |
| | | "com_act_easy_photo p " + |
| | |
| | | "LEFT JOIN com_act_easy_photo_user pu on p.id=pu.easy_photo_id " + |
| | | "LEFT JOIN com_act c on p.community_id=c.community_id " + |
| | | "left join com_act_easy_photo_classify ca on ca.id = p.classify_id " + |
| | | "left join com_act_easy_photo_evaluate as caepe on caepe.service_id = p.id and caepe.service_type = 1 " + |
| | | "WHERE p.del_tag = 0 and p.id=#{id}") |
| | | ComActEasyPhotoVO detailEasyPhoto(Long id); |
| | | @Select("SELECT " + |
| | |
| | | * @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); |
| | | } |