| | |
| | | and unit_id=#{item.unitId} |
| | | </if> |
| | | <if test="item.speciality !=null and item.speciality !='' "> |
| | | and speciality like concat ('%',#{item.speciality},'%') |
| | | and (speciality like concat ('%',#{item.speciality},'%') or #{item.speciality} like concat ('%',speciality,'%')) |
| | | </if> |
| | | <if test="item.project !=null and item.project !='' "> |
| | | and project like concat ('%',#{item.project},'%') |
| | |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |
| | | left join com_act_neighbor_circle_topic_new as canct on canct.id=nfpi.classify_id |
| | | left join new_fight_need_problem_claim as nfnpc on nfnpc.task_id=nfpi.id and nfnpc.user_id=#{userIds} |
| | | left join new_fight_need_problem_claim as nfnpc on nfnpc.task_id=nfpi.id |
| | | <if test="userIds !=null and userIds != '' "> |
| | | and nfnpc.user_id=#{userIds} |
| | | </if> |
| | | <where> |
| | | 1=1 |
| | | <if test="isDisplay !=null and isDisplay != '' "> |