hbwri/skjcmanager.git

			@@ -117,7 +117,7 @@
			public void exportUser(QualityManageVO qualityManageVO, HttpServletResponse response) {

			List<QualityManageExcel> list = qualityManageService.exportData(qualityManageVO);
			ExcelUtil.export(response, "大坝安全监测数据" + DateUtil.time(), "大坝安全监测数据表", list, QualityManageExcel.class);
			ExcelUtil.export(response, "水库数据质量管理数据" + DateUtil.time(), "水库数据质量管理数据表", list, QualityManageExcel.class);
			}

			}

			@@ -4,9 +4,12 @@
			import com.alibaba.excel.annotation.write.style.ColumnWidth;
			import com.alibaba.excel.annotation.write.style.ContentRowHeight;
			import com.alibaba.excel.annotation.write.style.HeadRowHeight;
			import com.fasterxml.jackson.annotation.JsonFormat;
			import lombok.Data;
			import org.springframework.format.annotation.DateTimeFormat;

			import java.io.Serializable;
			import java.util.Date;

			@Data
			@ColumnWidth(25)
			@@ -68,7 +71,9 @@

			//备注
			@ExcelProperty("校验时间")
			private String createTime;
			@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
			@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
			private Date createTime;


			}

			@@ -101,7 +101,9 @@
			${whereStr}
			</insert>

			<select id="exportData" resultType="cn.gistack.sm.resDataCheck.vo.QualityManageVO">
			<select id="exportData" resultType="cn.gistack.sm.resDataCheck.excel.QualityManageExcel">

			SELECT ROWNUM as no, TMP.* FROM (
			SELECT
			arb."guid" AS resGuid,
			arb."name" AS resName,
			@@ -118,7 +120,7 @@
			arb."eng_scal" AS engScal,
			rule.name AS ruleName,
			rule.description AS ruleDesc,
			rule.pro_description AS proDesc,
			bdb.dict_value AS proDesc,
			qm.*
			FROM (
			select * from SM_RES_DATA_QUALITY_MANAGE qm
			@@ -133,12 +135,13 @@

			LEFT JOIN SJZT_MD."att_res_base" arb ON arb."guid" = qm.res_id
			LEFT JOIN SM_RES_DATA_CHECK_RULES rule ON rule.id = qm.rule_id
			left join blade_dict_biz bdb on bdb.dict_key = rule.pro_description

			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"
			left join "SJZT_MD"."att_ad_base" ac on ab."p_ad_code" = ac."ad_code"
			<where>
			where 1=1 and bdb.code = 'RES_DATA_RULES_PRO_DESCRIPTION'
			<if test="vo.resName !=null and vo.resName !='' ">
			AND arb."name" LIKE CONCAT('%',#{vo.resName},'%')
			</if>
			@@ -152,8 +155,13 @@
			<if test="vo.adCode != null and vo.adCode != '' ">
			and (aab."ad_code" = #{vo.adCode} or aa."ad_code" = #{vo.adCode} or ab."ad_code" = #{vo.adCode} or ac."ad_code" = #{vo.adCode})
			</if>
			</where>
			order by qm.create_time desc

			)TMP




			</select>

	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/controller/QualityManageController.java	2 ●●●●● patch \| view \| raw \| blame \| history
	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/excel/QualityManageExcel.java	7 ●●●●● patch \| view \| raw \| blame \| history
	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/mapper/QualityManageMapper.xml	16 ●●●●● patch \| view \| raw \| blame \| history