数据质量明细添加数据来源,添加导出接口。巡查记录返回市区镇
14 files modified
2 files added
| | |
| | | |
| | | <result column="update_time" property="updateTime"/> |
| | | |
| | | <result column="city_name" property="cityName"/> |
| | | <result column="county_name" property="countyName"/> |
| | | <result column="town_name" property="townName"/> |
| | | |
| | | </resultMap> |
| | | |
| | | <select id="selectPatrolRecord" resultMap="selectPatrolRecordList"> |
| | |
| | | record.id,record.patrol_type,record.device_ids,record.images,record.videos,record.content,record.status,record.item_id,record.task_id,record.patrol_route,record.create_time,record.update_time,record.solution, |
| | | task.route_coordinates taskRoute,task.title taskName, |
| | | item.items_name itemsName,item.description, |
| | | u.real_name,res."name" resName,res."guid" resGuid,res."res_reg_code" resRegCode,res."res_loc" resLoc |
| | | u.real_name,res."name" resName,res."guid" resGuid, |
| | | res."res_reg_code" resRegCode,res."res_loc" resLoc, |
| | | |
| | | case when town."ad_grad" = 4 THEN town."ad_code" ELSE NULL END AS town_code, |
| | | case when town."ad_grad" = 4 THEN town."ad_name" ELSE NULL END AS town_name, |
| | | |
| | | case when town."ad_grad" = 3 THEN town."ad_code" |
| | | when county."ad_grad" = 3 THEN county."ad_code" END AS county_code, |
| | | |
| | | case when town."ad_grad" = 3 THEN town."ad_name" |
| | | when county."ad_grad" = 3 THEN county."ad_name" END AS county_name, |
| | | |
| | | 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 city_code, |
| | | |
| | | 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 city_name |
| | | |
| | | FROM SM_PATROL_RECORD record |
| | | LEFT JOIN sm_patrol_type type ON type.id = record.patrol_type |
| | | LEFT JOIN sm_patrol_task task ON task.id = record.task_id |
| | | LEFT JOIN sjzt_md."att_res_base" res ON task.project_id = res."guid" |
| | | |
| | | LEFT JOIN SJZT_MD."att_ad_base" town ON town."guid" = res."interior_ad_guid" |
| | | LEFT JOIN SJZT_MD."att_ad_base" county ON county."guid" = town."p_ad_code" |
| | | LEFT JOIN SJZT_MD."att_ad_base" city ON city."guid" = county."p_ad_code" |
| | | |
| | | LEFT JOIN sm_patrol_group_item item ON item.id = record.item_id |
| | | LEFT JOIN BLADE_USER u ON u.id = record.create_user |
| | | WHERE record.is_deleted = 0 |
| | |
| | | * 水库所在位置 |
| | | */ |
| | | private String resLoc; |
| | | |
| | | private String cityName; |
| | | private String countyName; |
| | | private String townName; |
| | | } |
| | |
| | | */ |
| | | @ApiOperation(value = "数据规则校验-分页列表查询", notes = "数据规则校验-分页列表查询") |
| | | @GetMapping(value = "/list") |
| | | public R<IPage<QualityManageVO>> queryPageList(Query query,QualityManageVO qualityManageVO) { |
| | | |
| | | |
| | | IPage<QualityManageVO> pageList = qualityManageService.selectCustomizePage(Condition.getPage(query), qualityManageVO); |
| | | public R queryPageList(Query query,QualityManageVO qualityManageVO) { |
| | | Object pageList = qualityManageService.selectCustomizePage(Condition.getPage(query), qualityManageVO); |
| | | return R.data(pageList); |
| | | } |
| | | |
| | |
| | | |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManage; |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManageDetail; |
| | | import cn.gistack.sm.resDataCheck.excel.QualityManageDetailExcel; |
| | | import cn.gistack.sm.resDataCheck.service.IQualityManageDetailService; |
| | | import cn.gistack.sm.resDataCheck.vo.QualityManageDetailVO; |
| | | import cn.gistack.sm.resDataCheck.vo.QualityManageVO; |
| | | import cn.gistack.system.user.entity.User; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.AllArgsConstructor; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import org.springblade.core.excel.util.ExcelUtil; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.secure.BladeUser; |
| | | import org.springblade.core.secure.utils.AuthUtil; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.constant.BladeConstant; |
| | | import org.springblade.core.tool.utils.DateUtil; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import springfox.documentation.annotations.ApiIgnore; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @Description: 数据规则校验 |
| | |
| | | return R.data(qualityManageDetailService.removeByIds(Arrays.asList(ids.split(",")))); |
| | | } |
| | | |
| | | /** |
| | | * 导出数据 |
| | | */ |
| | | @GetMapping("export-data") |
| | | public void exportUser(QualityManageDetailVO qualityManageDetailVO,HttpServletResponse response) { |
| | | |
| | | List<QualityManageDetailExcel> list = qualityManageDetailService.exportData(qualityManageDetailVO); |
| | | ExcelUtil.export(response, "大坝安全监测数据" + DateUtil.time(), "大坝安全监测数据表", list, QualityManageDetailExcel.class); |
| | | } |
| | | |
| | | } |
| | |
| | | */ |
| | | @ApiModelProperty("值") |
| | | private String val; |
| | | |
| | | //数据来源 |
| | | private String flag; |
| | | } |
| | |
| | | |
| | | //备注 |
| | | private String remark; |
| | | |
| | | //数据来源 |
| | | private String flag; |
| | | } |
| New file |
| | |
| | | package cn.gistack.sm.resDataCheck.excel; |
| | | |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | 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 io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.io.Serializable; |
| | | @Data |
| | | @ColumnWidth(25) |
| | | @HeadRowHeight(20) |
| | | @ContentRowHeight(18) |
| | | public class QualityManageDetailExcel implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 水库id |
| | | */ |
| | | @ExcelProperty(value = "序号") |
| | | private Integer no; |
| | | |
| | | //水库名称 |
| | | @ExcelProperty("水库名称") |
| | | private String resName; |
| | | |
| | | /** |
| | | * 数据来源 |
| | | */ |
| | | @ExcelProperty("数据来源") |
| | | private String flag; |
| | | |
| | | //市(州) |
| | | @ExcelProperty("市(州)") |
| | | private String cityName; |
| | | |
| | | |
| | | |
| | | //县(区) |
| | | @ExcelProperty("县(区)") |
| | | private String countyName; |
| | | |
| | | //注册登记号 |
| | | @ExcelProperty("注册登记号") |
| | | private String resRegCode; |
| | | |
| | | //工程规模 |
| | | @ExcelProperty("工程规模") |
| | | private String engScal; |
| | | |
| | | //是否有闸 |
| | | @ExcelProperty("是否有闸") |
| | | private String isGate; |
| | | |
| | | |
| | | //是否病险 |
| | | @ExcelProperty("是否病险") |
| | | private String isDanger; |
| | | |
| | | //实时水位 |
| | | @ExcelProperty("当前水位(m)") |
| | | private String rz; |
| | | |
| | | //堰顶高程 |
| | | @ExcelProperty("堰顶高程(m)") |
| | | private String tbWeirTopElevation; |
| | | |
| | | //主汛期限制水位 |
| | | @ExcelProperty("汛限水位(m)") |
| | | private String tbFlseLimStag; |
| | | |
| | | //正常蓄水位 |
| | | @ExcelProperty("正常水位(m)") |
| | | private String tbNormPoolStag; |
| | | |
| | | |
| | | //控制运行水位 |
| | | @ExcelProperty("控制水位(m)") |
| | | private String tbControlZ; |
| | | |
| | | |
| | | //设计洪水位 |
| | | @ExcelProperty("设计水位(m)") |
| | | private String tbDesFlStag; |
| | | |
| | | |
| | | //校核洪水位 |
| | | @ExcelProperty("校核水位(m)") |
| | | private String tbCheckFlStag; |
| | | |
| | | |
| | | //坝顶高程 |
| | | @ExcelProperty("坝顶高程(m)") |
| | | private String tbDamTopElevation; |
| | | |
| | | //死水位 |
| | | @ExcelProperty("死水位(m)") |
| | | private String tbDeadStag; |
| | | |
| | | //校验时间 |
| | | @ExcelProperty("校验时间") |
| | | private String createTime; |
| | | |
| | | //备注 |
| | | @ExcelProperty("备注") |
| | | @ColumnWidth(50) |
| | | private String remark; |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package cn.gistack.sm.resDataCheck.excel; |
| | | |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | 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 lombok.Data; |
| | | |
| | | import java.io.Serializable; |
| | | |
| | | @Data |
| | | @ColumnWidth(25) |
| | | @HeadRowHeight(20) |
| | | @ContentRowHeight(18) |
| | | public class QualityManageExcel implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 水库id |
| | | */ |
| | | @ExcelProperty(value = "序号") |
| | | private Integer no; |
| | | |
| | | //水库名称 |
| | | @ExcelProperty("水库名称") |
| | | private String resName; |
| | | |
| | | /** |
| | | * 数据来源 |
| | | */ |
| | | @ExcelProperty("数据来源") |
| | | private String flag; |
| | | |
| | | //市(州) |
| | | @ExcelProperty("市(州)") |
| | | private String cityName; |
| | | |
| | | |
| | | |
| | | //县(区) |
| | | @ExcelProperty("县(区)") |
| | | private String countyName; |
| | | |
| | | //注册登记号 |
| | | @ExcelProperty("注册登记号") |
| | | private String resRegCode; |
| | | |
| | | //工程规模 |
| | | @ExcelProperty("工程规模") |
| | | private String engScal; |
| | | |
| | | //是否有闸 |
| | | @ExcelProperty("是否有闸") |
| | | private String isGate; |
| | | |
| | | |
| | | //是否病险 |
| | | @ExcelProperty("是否病险") |
| | | private String isDanger; |
| | | |
| | | //实时水位 |
| | | @ExcelProperty("当前水位(m)") |
| | | private String rz; |
| | | |
| | | //堰顶高程 |
| | | @ExcelProperty("堰顶高程(m)") |
| | | private String tbWeirTopElevation; |
| | | |
| | | //主汛期限制水位 |
| | | @ExcelProperty("汛限水位(m)") |
| | | private String tbFlseLimStag; |
| | | |
| | | //正常蓄水位 |
| | | @ExcelProperty("正常水位(m)") |
| | | private String tbNormPoolStag; |
| | | |
| | | |
| | | //控制运行水位 |
| | | @ExcelProperty("控制水位(m)") |
| | | private String tbControlZ; |
| | | |
| | | |
| | | //设计洪水位 |
| | | @ExcelProperty("设计水位(m)") |
| | | private String tbDesFlStag; |
| | | |
| | | |
| | | //校核洪水位 |
| | | @ExcelProperty("校核水位(m)") |
| | | private String tbCheckFlStag; |
| | | |
| | | |
| | | //坝顶高程 |
| | | @ExcelProperty("坝顶高程(m)") |
| | | private String tbDamTopElevation; |
| | | |
| | | //死水位 |
| | | @ExcelProperty("死水位(m)") |
| | | private String tbDeadStag; |
| | | |
| | | //校验时间 |
| | | @ExcelProperty("校验时间") |
| | | private String createTime; |
| | | |
| | | //备注 |
| | | @ExcelProperty("备注") |
| | | @ColumnWidth(50) |
| | | private String remark; |
| | | |
| | | |
| | | } |
| | |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManage; |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManageDetail; |
| | | import cn.gistack.sm.resDataCheck.entity.Rules; |
| | | import cn.gistack.sm.resDataCheck.excel.QualityManageDetailExcel; |
| | | import cn.gistack.sm.resDataCheck.vo.QualityManageDetailVO; |
| | | import cn.gistack.sm.resDataCheck.vo.QualityManageVO; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | |
| | | |
| | | |
| | | Integer saveQualityManageDetail(@Param("rule")Rules rules, @Param("varStr") String varStr, @Param("whereStr") String whereStr); |
| | | |
| | | List<QualityManageDetailVO> getAll(@Param("vo") QualityManageDetailVO qualityManageDetailVO); |
| | | |
| | | List<QualityManageDetailExcel> exportData(@Param("vo") QualityManageDetailVO qualityManageDetailVO); |
| | | } |
| | |
| | | ( |
| | | res_id,rule_id,rule_name,rule_description,create_time,update_time,val, |
| | | is_gate,eng_scal,is_danger,town_code,town_name,county_code,county_name,city_code,city_name, |
| | | res_reg_code,res_name,rz,tb_weir_top_elevation,tb_flse_lim_stag,tb_norm_pool_stag,tb_control_z,tb_des_fl_stag,tb_dam_top_elevation,tb_dead_stag,remark |
| | | res_reg_code,res_name,rz,tb_weir_top_elevation,tb_flse_lim_stag,tb_norm_pool_stag,tb_control_z,tb_des_fl_stag,tb_dam_top_elevation,tb_dead_stag,flag,remark |
| | | ) |
| | | select |
| | | distinct |
| | |
| | | c."tb_des_fl_stag", |
| | | h."tb_dam_top_elevation", |
| | | c."tb_dead_stag", |
| | | case when f."flag" = '老库' THEN '地方平台' |
| | | when f."flag" = '物联网' THEN '省级平台' |
| | | when f."flag" = '水文' THEN '水文系统' |
| | | else '' |
| | | end as flag, |
| | | ${rule.description} as remark |
| | | |
| | | |
| | | from SJZT_MD."att_res_base" a |
| | | |
| | |
| | | MAX(tb_dam_top_elevation) tb_dam_top_elevation, |
| | | MAX(tb_dead_stag) tb_dead_stag, |
| | | replace(wm_concat(remark),',',';') as remark, |
| | | MAX(create_time) create_time |
| | | MAX(create_time) create_time, |
| | | MAX(flag) flag |
| | | from YWXT.SM_RES_DATA_QUALITY_MANAGE_DETAIL |
| | | where |
| | | 1=1 |
| | |
| | | AND res_name LIKE CONCAT('%', #{vo.resName},'%') |
| | | </if> |
| | | <if test="vo.startTime != null and vo.startTime != ''"> |
| | | AND DATE_FORMAT(create_time,'%Y-%m-%d') >= #{vo.startTime} |
| | | AND create_time >= #{vo.startTime} |
| | | </if> |
| | | <if test="vo.endTime != null and vo.endTime !='' "> |
| | | AND DATE_FORMAT(create_time,'%Y-%m-%d') <= #{vo.endTime} |
| | | AND create_time <= #{vo.endTime} |
| | | </if> |
| | | <if test="vo.engScal != null and vo.engScal != ''"> |
| | | and eng_scal = #{vo.engScal} |
| | |
| | | <if test="vo.townCode != null and vo.townCode != ''"> |
| | | and town_code= #{vo.townCode} |
| | | </if> |
| | | <if test="vo.flag != null and vo.flag != ''"> |
| | | and flag= #{vo.flag} |
| | | </if> |
| | | GROUP BY |
| | | RES_ID |
| | | </select> |
| | | <select id="getAll" resultType="cn.gistack.sm.resDataCheck.vo.QualityManageDetailVO"> |
| | | SELECT |
| | | MAX(id) id, |
| | | RES_ID, |
| | | MAX(is_gate) is_gate, |
| | | MAX(eng_scal) eng_scal, |
| | | MAX(is_danger) is_danger, |
| | | MAX(town_code) town_code, |
| | | MAX(town_name) town_name, |
| | | MAX(county_code)county_code, |
| | | MAX(county_name)county_name, |
| | | MAX(city_code) city_code, |
| | | MAX(city_name) city_name, |
| | | MAX(res_reg_code) res_reg_code, |
| | | MAX(res_name) res_name, |
| | | MAX(rz) rz, |
| | | MAX(tb_flse_lim_stag) tb_flse_lim_stag, |
| | | MAX(tb_weir_top_elevation) tb_weir_top_elevation, |
| | | MAX(tb_norm_pool_stag) tb_norm_pool_stag, |
| | | MAX(tb_control_z) tb_control_z, |
| | | MAX(tb_des_fl_stag) tb_des_fl_stag, |
| | | MAX(tb_dam_top_elevation) tb_dam_top_elevation, |
| | | MAX(tb_dead_stag) tb_dead_stag, |
| | | replace(wm_concat(remark),',',';') as remark, |
| | | MAX(create_time) create_time, |
| | | MAX(flag) flag |
| | | from YWXT.SM_RES_DATA_QUALITY_MANAGE_DETAIL |
| | | where |
| | | 1=1 |
| | | <if test="vo.resId != null and vo.resId != ''"> |
| | | AND res_id = #{vo.resId} |
| | | </if> |
| | | <if test="vo.resName != null and vo.resName != ''"> |
| | | AND res_name LIKE CONCAT('%', #{vo.resName},'%') |
| | | </if> |
| | | <if test="vo.startTime != null and vo.startTime != ''"> |
| | | AND create_time >= #{vo.startTime} |
| | | </if> |
| | | <if test="vo.endTime != null and vo.endTime !='' "> |
| | | AND create_time <= #{vo.endTime} |
| | | </if> |
| | | <if test="vo.engScal != null and vo.engScal != ''"> |
| | | and eng_scal = #{vo.engScal} |
| | | </if> |
| | | <if test="vo.isDanger != null and vo.isDanger != ''"> |
| | | and is_danger = #{vo.isDanger} |
| | | </if> |
| | | <if test="vo.cityCode != null and vo.cityCode != ''"> |
| | | and city_code = #{vo.cityCode} |
| | | </if> |
| | | <if test="vo.countyCode != null and vo.countyCode != ''"> |
| | | and county_code = #{vo.countyCode} |
| | | </if> |
| | | <if test="vo.townCode != null and vo.townCode != ''"> |
| | | and town_code= #{vo.townCode} |
| | | </if> |
| | | <if test="vo.flag != null and vo.flag != ''"> |
| | | and flag= #{vo.flag} |
| | | </if> |
| | | GROUP BY |
| | | RES_ID |
| | | </select> |
| | | |
| | | |
| | | <select id="exportData" resultType="cn.gistack.sm.resDataCheck.excel.QualityManageDetailExcel"> |
| | | SELECT ROWNUM AS no ,t.* from ( |
| | | SELECT |
| | | MAX(id) id, |
| | | RES_ID, |
| | | MAX(is_gate) is_gate, |
| | | MAX(eng_scal) eng_scal, |
| | | |
| | | case when max(is_danger)= 'false' THEN '否' |
| | | when max(is_danger)= 'true' THEN '是' |
| | | else '' |
| | | end as is_danger, |
| | | |
| | | MAX(town_code) town_code, |
| | | MAX(town_name) town_name, |
| | | MAX(county_code)county_code, |
| | | MAX(county_name)county_name, |
| | | MAX(city_code) city_code, |
| | | MAX(city_name) city_name, |
| | | MAX(res_reg_code) res_reg_code, |
| | | MAX(res_name) res_name, |
| | | MAX(rz) rz, |
| | | MAX(tb_flse_lim_stag) tb_flse_lim_stag, |
| | | MAX(tb_weir_top_elevation) tb_weir_top_elevation, |
| | | MAX(tb_norm_pool_stag) tb_norm_pool_stag, |
| | | MAX(tb_control_z) tb_control_z, |
| | | MAX(tb_des_fl_stag) tb_des_fl_stag, |
| | | MAX(tb_dam_top_elevation) tb_dam_top_elevation, |
| | | MAX(tb_dead_stag) tb_dead_stag, |
| | | replace(wm_concat(remark),',',';') as remark, |
| | | MAX(create_time) create_time, |
| | | MAX(flag) flag |
| | | from YWXT.SM_RES_DATA_QUALITY_MANAGE_DETAIL |
| | | where |
| | | 1=1 |
| | | <if test="vo.resId != null and vo.resId != ''"> |
| | | AND res_id = #{vo.resId} |
| | | </if> |
| | | <if test="vo.resName != null and vo.resName != ''"> |
| | | AND res_name LIKE CONCAT('%', #{vo.resName},'%') |
| | | </if> |
| | | <if test="vo.startTime != null and vo.startTime != ''"> |
| | | AND create_time >= #{vo.startTime} |
| | | </if> |
| | | <if test="vo.endTime != null and vo.endTime !='' "> |
| | | AND create_time <= #{vo.endTime} |
| | | </if> |
| | | <if test="vo.engScal != null and vo.engScal != ''"> |
| | | and eng_scal = #{vo.engScal} |
| | | </if> |
| | | <if test="vo.isDanger != null and vo.isDanger != ''"> |
| | | and is_danger = #{vo.isDanger} |
| | | </if> |
| | | <if test="vo.cityCode != null and vo.cityCode != ''"> |
| | | and city_code = #{vo.cityCode} |
| | | </if> |
| | | <if test="vo.countyCode != null and vo.countyCode != ''"> |
| | | and county_code = #{vo.countyCode} |
| | | </if> |
| | | <if test="vo.townCode != null and vo.townCode != ''"> |
| | | and town_code= #{vo.townCode} |
| | | </if> |
| | | <if test="vo.flag != null and vo.flag != ''"> |
| | | and flag= #{vo.flag} |
| | | </if> |
| | | GROUP BY |
| | | RES_ID |
| | | |
| | | ) t |
| | | |
| | | |
| | | </select> |
| | | </mapper> |
| | |
| | | </select> |
| | | |
| | | <insert id="addQualityManage"> |
| | | insert into SM_RES_DATA_QUALITY_MANAGE (res_id,rule_id,create_time,update_time,val) |
| | | select distinct a."guid" as res_id,${ruleId} AS rule_id,NOW() AS create_time,NOW() AS update_time, ${varStr} |
| | | insert into SM_RES_DATA_QUALITY_MANAGE (res_id,rule_id,create_time,update_time,flag,val) |
| | | select |
| | | distinct a."guid" as res_id, |
| | | ${ruleId} AS rule_id, |
| | | NOW() AS create_time, |
| | | NOW() AS update_time, |
| | | case when f."flag" = '老库' THEN '地方平台' |
| | | when f."flag" = '物联网' THEN '省级平台' |
| | | when f."flag" = '水文' THEN '水文系统' |
| | | else '' |
| | | end as flag, |
| | | ${varStr} |
| | | |
| | | from SJZT_MD."att_res_base" a |
| | | left join SJZT_MD."att_res_danger_manage_special" b on (a."guid" = b."res_guid") |
| | | left join SJZT_MD."att_res_stag_char" c on (a."guid" = c."res_guid") |
| | |
| | | |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManage; |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManageDetail; |
| | | import cn.gistack.sm.resDataCheck.excel.QualityManageDetailExcel; |
| | | import cn.gistack.sm.resDataCheck.vo.QualityManageDetailVO; |
| | | import cn.gistack.sm.resDataCheck.vo.QualityManageVO; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.core.mp.base.BaseService; |
| | | |
| | | import java.util.List; |
| | | |
| | | public interface IQualityManageDetailService extends BaseService<QualityManageDetail> { |
| | | Object selectCustomizePage(IPage<QualityManageDetailVO> page, QualityManageDetailVO qualityManageDetailVO); |
| | | |
| | | |
| | | Integer saveQualityManageDetail(Long ruleId, String varStr, String whereStr); |
| | | |
| | | List<QualityManageDetailExcel> exportData(QualityManageDetailVO qualityManageDetailVO); |
| | | } |
| | |
| | | import org.springblade.core.mp.base.BaseService; |
| | | |
| | | public interface IQualityManageService extends BaseService<QualityManage> { |
| | | IPage<QualityManageVO> selectCustomizePage(IPage<QualityManageVO> page, QualityManageVO qualityManageVO); |
| | | Object selectCustomizePage(IPage<QualityManageVO> page, QualityManageVO qualityManageVO); |
| | | |
| | | QualityManageVO getDetail(String id); |
| | | |
| | |
| | | |
| | | import cn.gistack.sm.resDataCheck.entity.QualityManageDetail; |
| | | import cn.gistack.sm.resDataCheck.entity.Rules; |
| | | import cn.gistack.sm.resDataCheck.excel.QualityManageDetailExcel; |
| | | import cn.gistack.sm.resDataCheck.mapper.QualityManageDetailMapper; |
| | | import cn.gistack.sm.resDataCheck.service.IQualityManageDetailService; |
| | | import cn.gistack.sm.resDataCheck.service.IRulesService; |
| | |
| | | import org.springblade.core.tool.utils.StringUtil; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Service |
| | | @AllArgsConstructor |
| | | public class QualityManageDetailServiceImpl extends BaseServiceImpl<QualityManageDetailMapper, QualityManageDetail> implements IQualityManageDetailService { |
| | |
| | | public Object selectCustomizePage(IPage<QualityManageDetailVO> page, QualityManageDetailVO qualityManageDetailVO) { |
| | | |
| | | if (qualityManageDetailVO.getIsExport() != null && qualityManageDetailVO.getIsExport().equals("1")){ |
| | | return baseMapper.selectCustomizePage(null,qualityManageDetailVO); |
| | | return baseMapper.getAll(qualityManageDetailVO); |
| | | } |
| | | return page.setRecords(baseMapper.selectCustomizePage(page, qualityManageDetailVO)); |
| | | } |
| | |
| | | |
| | | return baseMapper.saveQualityManageDetail(rule, varStr, whereStr); |
| | | } |
| | | |
| | | @Override |
| | | public List<QualityManageDetailExcel> exportData(QualityManageDetailVO qualityManageDetailVO) { |
| | | List<QualityManageDetailExcel> list = baseMapper.exportData(qualityManageDetailVO); |
| | | return list; |
| | | } |
| | | } |
| | |
| | | private final IQualityManageDetailService qualityManageDetailService; |
| | | |
| | | @Override |
| | | public IPage<QualityManageVO> selectCustomizePage(IPage<QualityManageVO> page, QualityManageVO qualityManageVO) { |
| | | public Object selectCustomizePage(IPage<QualityManageVO> page, QualityManageVO qualityManageVO) { |
| | | |
| | | if (qualityManageVO.getIsExport() != null && qualityManageVO.getIsExport().equals("1")){ |
| | | return baseMapper.selectCustomizePage(null,qualityManageVO); |
| | | } |
| | | |
| | | return page.setRecords(baseMapper.selectCustomizePage(page,qualityManageVO)); |
| | | } |
| | | |
| | |
| | | */ |
| | | private String adCode; |
| | | |
| | | private String isExport; |
| | | |
| | | } |