hbwri/skjcmanager.git

			@@ -55,6 +55,13 @@
			@ApiModelProperty(value = "所在地点")
			private String place;


			/**
			* 行政责任人-id
			*/
			@ApiModelProperty(value = "行政责任人-id")
			private String areaUserGuid;

			/**
			* 行政责任人-姓名
			*/
			@@ -75,6 +82,12 @@
			*/
			@ApiModelProperty(value = "行政责任人-所属单位")
			private String areaUnitName;

			/**
			* 主管部门责任人-id
			*/
			@ApiModelProperty(value = "主管部门责任人-id")
			private String customsUserGuid;
			/**
			* 主管部门责任人-姓名
			*/
			@@ -97,6 +110,12 @@
			private String customsUnitName;

			/**
			* 管理单位责任人-id
			*/
			@ApiModelProperty(value = "管理单位责任人-id")
			private String manageUnitUserGuid;

			/**
			* 管理单位责任人-姓名
			*/
			@ApiModelProperty(value = "管理单位责任人-姓名")
			@@ -116,6 +135,14 @@
			*/
			@ApiModelProperty(value = "管理单位责任人-所属单位")
			private String manageUnitUnitName;


			/**
			* 技术责任人-id
			*/
			@ApiModelProperty(value = "技术责任人-id")
			private String technologyUserGuid;

			/**
			* 技术责任人-姓名
			*/
			@@ -136,6 +163,13 @@
			*/
			@ApiModelProperty(value = "技术责任人-所属单位")
			private String technologyUnitName;

			/**
			* 巡查责任人-id
			*/
			@ApiModelProperty(value = "巡查责任人-id")
			private String patrolUserGuid;

			/**
			* 巡查责任人-姓名
			*/

			@@ -28,36 +28,35 @@
			select
			arb."guid", arb."name", arb."res_loc" as place, arb."res_reg_code" as resRegCode, arb."eng_scal" as engScal,
			aab."ad_name" as adName,
			trmp1."user_unit" areaUnitName,trmp1."user_name" areaUsername,trmp1."user_phone" areaPhone,trmp1."position" areaPosition,
			trmp2."user_unit" customsUnitName,trmp2."user_name" customsUsername,trmp2."user_phone" customsPhone,trmp2."position" customsPosition,
			trmp3."user_unit" manageUnitUnitName,trmp3."user_name" manageUnitUsername,trmp3."user_phone" manageUnitPhone,trmp3."position" manageUnitPosition,
			trmp4."user_unit" technologyUnitName,trmp4."user_name" technologyUsername,trmp4."user_phone" technologyPhone,trmp4."position" technologyPosition,
			trmp5."user_unit" patrolUnitName,trmp5."user_name" patrolUsername,trmp5."user_phone" patrolPhone,trmp5."position" patrolPosition
			trmp1."user_unit" areaUnitName,trmp1."user_name" areaUsername,trmp1."user_phone" areaPhone,trmp1."position" areaPosition,trmp1."guid" areaUserGuid,
			trmp2."user_unit" customsUnitName,trmp2."user_name" customsUsername,trmp2."user_phone" customsPhone,trmp2."position" customsPosition,trmp2."guid" customsUserGuid,
			trmp3."user_unit" manageUnitUnitName,trmp3."user_name" manageUnitUsername,trmp3."user_phone" manageUnitPhone,trmp3."position" manageUnitPosition,trmp3."guid" manageUnitUserGuid,
			trmp4."user_unit" technologyUnitName,trmp4."user_name" technologyUsername,trmp4."user_phone" technologyPhone,trmp4."position" technologyPosition,trmp4."guid" technologyUserGuid,
			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_MD"."att_ad_base" aab on aab."guid" = concat(arb."ad_guid",'000000')

			left join (
			select "res_guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			select "res_guid",WM_Concat("guid") "guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			from "SJZT_MD"."att_res_manage_person" where "type"=1 GROUP BY "res_guid"
			) trmp1 on arb."guid" = trmp1."res_guid"

			left join (
			select "res_guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			select "res_guid",WM_Concat("guid") "guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			from "SJZT_MD"."att_res_manage_person" where "type"=2 GROUP BY "res_guid"
			) trmp2 on arb."guid" = trmp2."res_guid"

			left join (
			select "res_guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			select "res_guid",WM_Concat("guid") "guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			from "SJZT_MD"."att_res_manage_person" where "type"=3 GROUP BY "res_guid"
			) trmp3 on arb."guid" = trmp3."res_guid"

			left join (
			select "res_guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			select "res_guid",WM_Concat("guid") "guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			from "SJZT_MD"."att_res_manage_person" where "type"=4 GROUP BY "res_guid"
			) trmp4 on arb."guid" = trmp4."res_guid"

			left join (
			select "res_guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			select "res_guid",WM_Concat("guid") "guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
			from "SJZT_MD"."att_res_manage_person" where "type"=5 GROUP BY "res_guid"
			) trmp5 on arb."guid" = trmp5."res_guid"
			where 1=1

	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/dto/AttResBaseUserDTO.java	34 ●●●●● patch \| view \| raw \| blame \| history
	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml	21 ●●●●● patch \| view \| raw \| blame \| history