| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="selectGdTaskResultListByPatrolTaskId" resultMap="gdTaskResultResultMap"> |
|---|
| | | select tr.*, |
|---|
| | | SELECT tr.*, |
|---|
| | | IFNULL(bu.real_name, bu.name) as distribute_user_name, |
|---|
| | | bd.dept_name as distribute_dept_name |
|---|
| | | from ja_gd_task_result tr |
|---|
| | | left join ja_gd_clue_event ce on ce.result_id = tr.id and ce.is_deleted = 0 |
|---|
| | | left join blade_user bu on bu.id = ce.create_user and bu.is_deleted = 0 |
|---|
| | | left join blade_dept bd on bd.id = ce.create_dept and bd.is_deleted = 0 |
|---|
| | | where tr.is_deleted = 0 |
|---|
| | | and tr.patrol_task_id = #{patrolTaskId} |
|---|
| | | bd.dept_name as distribute_dept_name |
|---|
| | | FROM ja_gd_task_result tr |
|---|
| | | LEFT JOIN (SELECT * |
|---|
| | | FROM ja_gd_clue_event ce1 |
|---|
| | | WHERE ce1.is_deleted = 0 |
|---|
| | | AND ce1.create_time = (SELECT MAX(create_time) |
|---|
| | | FROM ja_gd_clue_event ce2 |
|---|
| | | WHERE ce2.result_id = ce1.result_id |
|---|
| | | AND ce2.is_deleted = 0)) ce ON ce.result_id = tr.id |
|---|
| | | LEFT JOIN blade_user bu ON bu.id = ce.create_user AND bu.is_deleted = 0 |
|---|
| | | LEFT JOIN blade_dept bd ON bd.id = ce.create_dept AND bd.is_deleted = 0 |
|---|
| | | WHERE tr.is_deleted = 0 |
|---|
| | | AND tr.patrol_task_id = #{patrolTaskId} |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | |
|---|
