| | |
|---|
| | | WHEN t1.state = 8 THEN '核查' |
|---|
| | | WHEN t1.state = 9 THEN '结案' |
|---|
| | | END) `status` , |
|---|
| | | dd.`name` as grade |
|---|
| | | pdd.`name` as grade |
|---|
| | | FROM |
|---|
| | | ums_base_case t1 |
|---|
| | | LEFT JOIN ums_violations t2 ON t1.id = t2.id |
|---|
| | | LEFT JOIN ums_video_point t3 ON t3.id = t2.video_point_id |
|---|
| | | LEFT JOIN ums_video_alarm_report t4 ON t4.id = t2.video_alarm_report_id |
|---|
| | | LEFT JOIN ums_data_dictionary dd on t2.grade_id = dd.id |
|---|
| | | LEFT JOIN ums_data_dictionary pdd on pdd.id = dd.parent_id |
|---|
| | | <where> |
|---|
| | | t1.category=1 |
|---|
| | | <if test="beginTime !=''and beginTime!=null and endTime!=''and endTime!=null"> |
|---|
