| | |
| | | nput.user_id as unitUserId, |
| | | nput.unit_id, |
| | | npi.status, |
| | | canct.name as classifyName, |
| | | nput.creation_time, |
| | | nput.update_time |
| | | FROM |
| | | new_fight_need_problem_unit_task as nput |
| | | LEFT JOIN new_fight_need_problem_inventory AS npi ON npi.id=nput.task_id |
| | | left join com_act_neighbor_circle_topic as canct on canct.id=npi.classify_id |
| | | <where> |
| | | 1=1 |
| | | <if test="unitId !=null and unitId != '' "> |
| | | and nput.unit_id =#{unitId} |
| | | </if> |
| | | </where> |
| | | GROUP BY nput.id |
| | | </select> |
| | | |
| | | <select id="getDetails" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemUnitTaskDTO"> |
| | |
| | | nput.user_id as unitUserId, |
| | | nput.unit_id, |
| | | npi.status, |
| | | canct.name as classifyName, |
| | | nput.creation_time, |
| | | nput.update_time |
| | | FROM new_fight_need_problem_unit_task as nput |
| | | LEFT JOIN new_fight_need_problem_inventory AS npi ON npi.task_id=nput.id |
| | | left join com_act_neighbor_circle_topic as canct on canct.id=npi.classify_id |
| | | <where> |
| | | 1=1 |
| | | <if test="id !=null and id != '' "> |