| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="getDetailVO" resultMap="vo"> |
|---|
| | | SELECT R.*,arb."name" reservoirName FROM SM_REPORT_FLOOD_RECORD r |
|---|
| | | SELECT R.*,arb."name" reservoirName , |
|---|
| | | arb."res_reg_code" as resRegCode, |
|---|
| | | arb."eng_scal" as engScal, |
|---|
| | | arb."center_long" lon, |
|---|
| | | arb."center_lat" lat, |
|---|
| | | case when town."ad_grad" = 4 THEN town."ad_code" ELSE NULL END AS townCode, |
|---|
| | | case when town."ad_grad" = 4 THEN town."ad_name" ELSE NULL END AS townName, |
|---|
| | | case when town."ad_grad" = 3 THEN town."ad_code" |
|---|
| | | when county."ad_grad" = 3 THEN county."ad_code" END AS countyCode, |
|---|
| | | case when town."ad_grad" = 3 THEN town."ad_name" |
|---|
| | | when county."ad_grad" = 3 THEN county."ad_name" END AS countyName, |
|---|
| | | case when town."ad_grad" = 2 THEN town."ad_code" |
|---|
| | | when county."ad_grad" = 2 THEN county."ad_code" |
|---|
| | | ELSE city."ad_code" END AS cityCode, |
|---|
| | | case when town."ad_grad" = 2 THEN town."ad_name" |
|---|
| | | when county."ad_grad" = 2 THEN county."ad_name" |
|---|
| | | ELSE city."ad_name" END AS cityName |
|---|
| | | FROM SM_REPORT_FLOOD_RECORD r |
|---|
| | | LEFT JOIN "SJZT_MD"."att_res_base" arb on arb."guid" = r.reservoir_id |
|---|
| | | LEFT JOIN SJZT_MD."att_ad_base"town ON arb."interior_ad_guid" = town."guid" |
|---|
| | | LEFT JOIN SJZT_MD."att_ad_base" county ON town."p_ad_code" = county."guid" |
|---|
| | | LEFT JOIN SJZT_MD."att_ad_base" city ON county."p_ad_code" = city."guid" |
|---|
| | | LEFT JOIN SJZT_MD."att_ad_base" province ON province."guid" = city."p_ad_code" |
|---|
| | | WHERE r.is_deleted = 0 AND r.id = #{id} |
|---|
| | | </select> |
|---|
| | | </mapper> |
|---|
