| | |
|---|
| | | <select id="listDykeUnitDanger" resultType="cn.gistack.sm.sjztmd.vo.TbDykeUnitDangerVO"> |
|---|
| | | select tdi.*,ifnull(tdud."danger_level",0) dangerLevel,tdud."id" from ( |
|---|
| | | select |
|---|
| | | "dyke_guid" dykeGuid,"unit",count(*) dangerNum,wm_concat(distinct "signs_of_termite_activity") hdjxs, |
|---|
| | | "dyke_guid" dykeGuid,"unit",count(*) dangerNum,wm_concat(distinct "signs_of_termite_activity") hdjxs,max("tb_year") as "tb_year",max("tb_quarter") as "tb_quarter", |
|---|
| | | sum("danger_length") as dangerLength |
|---|
| | | from sjzt_md."tb_dyke_investigation" |
|---|
| | | where "hazard_rating" = '有危害' |
|---|
| | |
|---|
| | | </if> |
|---|
| | | group by "dyke_guid","unit" |
|---|
| | | ) tdi |
|---|
| | | left join sjzt_md."tb_dyke_unit_danger" tdud on (tdi.dykeGuid = tdud."dyke_id" and tdi."unit" = tdud."unit") |
|---|
| | | left join sjzt_md."tb_dyke_unit_danger" tdud on (tdi.dykeGuid = tdud."dyke_id" and tdi."unit" = tdud."unit" and tdi."tb_year" = tdud."tb_year" and tdi."tb_quarter" = tdud."tb_quarter") |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | </mapper> |
|---|
