| | |
|---|
| | | List<EastPhotoTypeVO> countPub(@Param("communityId")Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT t.name,COUNT(p.id) as num FROM com_act_easy_photo_type t LEFT JOIN com_act_easy_photo_type_relation r ON t.id = r.easy_type_id " + |
|---|
| | | "LEFT JOIN com_act_easy_photo p ON r.easy_id = p.id AND p.status = 4 where p.community_id = #{communityId} " + |
|---|
| | | "LEFT JOIN com_act_easy_photo p ON r.easy_id = p.id AND p.status = 4 and p.community_id = #{communityId} " + |
|---|
| | | "GROUP BY t.name ") |
|---|
| | | List<EastPhotoTypeVO> countApproved(@Param("communityId")Long communityId); |
|---|
| | | |
|---|
