| | |
|---|
| | | <select id="getAttResBaseUserPage" resultType="cn.gistack.sm.sjztmd.dto.AttResBaseUserDTO"> |
|---|
| | | select |
|---|
| | | arb."guid", arb."name", arb."res_loc" as place, arb."res_reg_code" as resRegCode, arb."eng_scal" as engScal,arb."center_long" as lon,arb."center_lat" as lat, |
|---|
| | | REGEXP_SUBSTR (arb."res_loc",'[^-]+',1,2) as cityName, |
|---|
| | | REGEXP_SUBSTR (arb."res_loc",'[^-]+',1,3) as countyName, |
|---|
| | | REGEXP_SUBSTR (arb."res_loc",'[^-]+',1,4) as townName, |
|---|
| | | dri."city_nm" cityName,dri."county_nm" countyName,dri."town_nm" townName, |
|---|
| | | aab."ad_name" as adName, |
|---|
| | | trmp1."user_unit" areaUnitName,trmp1."user_name" areaUsername,trmp1."user_phone" areaPhone,trmp1."position" |
|---|
| | | areaPosition,trmp1."guid" areaUserGuid, |
|---|
| | |
|---|
| | | trmp5."user_unit" patrolUnitName,trmp5."user_name" patrolUsername,trmp5."user_phone" |
|---|
| | | patrolPhone,trmp5."position" patrolPosition,trmp5."guid" patrolUserGuid |
|---|
| | | from SJZT_MD."att_res_base" arb |
|---|
| | | left join "SJZT_DW"."dim_res_info_a" dri on arb."guid" = dri."guid" |
|---|
| | | left join "SJZT_MD"."att_ad_base" aab on aab."guid" = arb."interior_ad_guid" |
|---|
| | | left join "SJZT_MD"."att_ad_base" aa on aab."p_ad_code" = aa."ad_code" |
|---|
| | | left join "SJZT_MD"."att_ad_base" ab on aa."p_ad_code" = ab."ad_code" |
|---|
