| | |
|---|
| | | LEFT JOIN sys_user su ON p.handler_id = su.user_id |
|---|
| | | LEFT JOIN com_act_easy_photo_comment c ON p.id = c.easy_photo_id |
|---|
| | | LEFT JOIN com_act_easy_photo_classify class ON p.classify_id = class.id |
|---|
| | | LEFT JOIN com_act_easy_photo_feedback f ON p.id = f.easy_id |
|---|
| | | LEFT JOIN (SELECT * FROM com_act_easy_photo_feedback WHERE `type` = 2) f ON p.id = f.easy_id |
|---|
| | | <where> p.del_tag = 0 |
|---|
| | | <if test = 'comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0' > |
|---|
| | | AND p.community_id = ${comActEasyPhotoVO.communityId} |
|---|
| | |
|---|
| | | </if> |
|---|
| | | <if test='comActEasyPhotoVO.isReportDpc != null' > |
|---|
| | | AND p.`is_report_dpc` = #{comActEasyPhotoVO.isReportDpc} |
|---|
| | | AND f.`type` = 2 |
|---|
| | | </if> |
|---|
| | | <if test='comActEasyPhotoVO.keyWord != null and comActEasyPhotoVO.keyWord != ""'> |
|---|
| | | AND (class.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or p.detail like concat(#{comActEasyPhotoVO.keyWord},'%')) |
|---|
