取水口日取水量漏损(历史)
取水口日取水量漏损(最新)
修改控制器报警与状态查询的排序、
修改农户日用水量统计的排序、日期类型
重构代码放置结构
2 文件已重命名
11个文件已修改
8个文件已添加
| | |
| | | import com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDay; |
| | | import com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDayLast; |
| | | import com.dy.pipIrrGlobal.pojoRm.RmLossLast; |
| | | import com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @Author: liurunyu |
| | |
| | | * @return update count |
| | | */ |
| | | int updateByPrimaryKey(RmIntakeAmountDayLast record); |
| | | |
| | | /** |
| | | * 根据指定条件获取记录总数 |
| | | * @param params |
| | | * @return |
| | | */ |
| | | Long getRecordCount(Map<?, ?> params); |
| | | |
| | | /** |
| | | * 根据指定条件获取记录 |
| | | * @param params |
| | | * @return |
| | | */ |
| | | List<VoIntakeAmountDay> getIntakeAmountDayLast(Map<?, ?> params); |
| | | } |
| | |
| | | import com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDay; |
| | | import com.dy.pipIrrGlobal.pojoRm.RmLossHistory; |
| | | import com.dy.pipIrrGlobal.pojoRm.RmOnHourReportHistory; |
| | | import com.dy.pipIrrGlobal.voRm.VoClientAmountDay; |
| | | import com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @Author: liurunyu |
| | |
| | | * @return update count |
| | | */ |
| | | int updateByPrimaryKey(RmIntakeAmountDay record); |
| | | |
| | | /** |
| | | * 根据指定条件获取记录总数 |
| | | * @param params |
| | | * @return |
| | | */ |
| | | Long getRecordCount(Map<?, ?> params); |
| | | |
| | | /** |
| | | * 根据指定条件获取记录 |
| | | * @param params |
| | | * @return |
| | | */ |
| | | List<VoIntakeAmountDay> getIntakeAmountDayHistory(Map<?, ?> params); |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrGlobal.voRm; |
| | | |
| | | import com.dy.common.po.BaseEntity; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import lombok.Data; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 10:27 |
| | | * @LastEditTime :2024/7/24 10:27 |
| | | * @Description |
| | | */ |
| | | @Data |
| | | @Schema(title = "取水口日取水量漏损视图对象") |
| | | public class VoIntakeAmountDay implements BaseEntity { |
| | | |
| | | private static final long serialVersionUID = 202407241028001L; |
| | | |
| | | |
| | | @Schema(description = "取水口ID", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private String intakeId; |
| | | |
| | | @Schema(description = "取水口名称", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private String intakeName; |
| | | |
| | | @Schema(description = "日取水量(不包括漏损水量)", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private Double amount; |
| | | |
| | | @Schema(description = "统计日期(yyyy-mm-dd)", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private java.sql.Date dt; |
| | | |
| | | @Schema(description = "最后计水量上报数据接收时间(yyyy-mm-dd hh:mm:ss)", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private java.util.Date dtLast; |
| | | |
| | | @Schema(description = "最后计水量的控制器地址", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private String rtuAddrLast; |
| | | |
| | | @Schema(description = "最后计水量的控制器ID(外键)", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private String controllerIdLast; |
| | | |
| | | @Schema(description = "最后计水量时控制器累计水量", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private Double totalAmountLast; |
| | | |
| | | @Schema(description = "最后计水量时控制器时钟(yyyy-mm-dd HH:MM:SS)", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private java.util.Date rtuDtLast; |
| | | } |
| | |
| | | |
| | | pipIrr: |
| | | global: |
| | | dev: false #是否开发阶段,true或false |
| | | dev: true #是否开发阶段,true或false |
| | | dsName: ym #开发阶段,设置临时的数据库名称 |
| | | mw: |
| | | webPort: 8070 |
| | |
| | | and rash.valve_state = #{valveState,jdbcType=TINYINT} |
| | | </if> |
| | | <if test="intakeName != null"> |
| | | and pint.name = #{intakeName,jdbcType=VARCHAR} |
| | | and pint.name like CONCAT('%',#{intakeName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and rash.dt >= #{startDt,jdbcType=TIMESTAMP} |
| | |
| | | and rash.dt <= #{endDt,jdbcType=TIMESTAMP} |
| | | </if> |
| | | </where> |
| | | ORDER BY rash.dt DESC |
| | | ORDER BY rash.id DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | | </if> |
| | |
| | | and rasl.valve_state = #{valveState,jdbcType=TINYINT} |
| | | </if> |
| | | <if test="intakeName != null"> |
| | | and pint.name = #{intakeName,jdbcType=VARCHAR} |
| | | and pint.name like CONCAT('%',#{intakeName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and rasl.dt >= #{startDt,jdbcType=TIMESTAMP} |
| | |
| | | rasl.alarm_valve as alarmValve, |
| | | rasl.power_type as powerType |
| | | from rm_alarm_state_last rasl |
| | | Left join pr_intake pint on intake_id = pint.id |
| | | Left join pr_intake pint on rasl.intake_id = pint.id |
| | | <where> |
| | | <if test="alarmState == 1"> |
| | | and ( |
| | |
| | | and rasl.dt <= #{endDt,jdbcType=TIMESTAMP} |
| | | </if> |
| | | </where> |
| | | ORDER BY rasl.dt DESC |
| | | ORDER BY rasl.id DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | | </if> |
| | |
| | | Left join se_client sc on sc.id = rcadl.client_id |
| | | <where> |
| | | <if test="clientName != null"> |
| | | and sc.name = #{clientName,jdbcType=VARCHAR} |
| | | and sc.name like CONCAT('%',#{clientName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and rash.dt >= #{startDt,jdbcType=TIMESTAMP} |
| | | and rcadl.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and rash.dt <= #{endDt,jdbcType=TIMESTAMP} |
| | | and rcadl.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | </select> |
| | |
| | | Left join se_client sc on sc.id = rcadl.client_id |
| | | <where> |
| | | <if test="clientName != null"> |
| | | and sc.name = #{clientName,jdbcType=VARCHAR} |
| | | and sc.name like CONCAT('%',#{clientName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and rash.dt >= #{startDt,jdbcType=TIMESTAMP} |
| | | and rcadl.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and rash.dt <= #{endDt,jdbcType=TIMESTAMP} |
| | | and rcadl.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | ORDER BY rcadl.dt DESC |
| | | ORDER BY rcadl.id DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | | </if> |
| | |
| | | Left join se_client sc on sc.id = rcad.client_id |
| | | <where> |
| | | <if test="clientName != null"> |
| | | and sc.name = #{clientName,jdbcType=VARCHAR} |
| | | and sc.name like CONCAT('%',#{clientName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and rash.dt >= #{startDt,jdbcType=TIMESTAMP} |
| | | and rcad.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and rash.dt <= #{endDt,jdbcType=TIMESTAMP} |
| | | and rcad.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | </select> |
| | |
| | | Left join se_client sc on sc.id = rcad.client_id |
| | | <where> |
| | | <if test="clientName != null"> |
| | | and sc.name = #{clientName,jdbcType=VARCHAR} |
| | | and sc.name like CONCAT('%',#{clientName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and rash.dt >= #{startDt,jdbcType=TIMESTAMP} |
| | | and rcad.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and rash.dt <= #{endDt,jdbcType=TIMESTAMP} |
| | | and rcad.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | ORDER BY rcad.dt DESC |
| | | ORDER BY rcad.id DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | | </if> |
| | |
| | | rtu_dt_last = #{rtuDtLast,jdbcType=TIMESTAMP} |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <!--根据指定条件获取记录总数--> |
| | | <select id="getRecordCount" resultType="java.lang.Long"> |
| | | select count(*) |
| | | from rm_intake_amount_day_last riadl |
| | | Left join pr_intake pint on pint.id = riadl.intake_id |
| | | <where> |
| | | <if test="intakeName != null"> |
| | | and pint.name like CONCAT('%',#{intakeName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and riadl.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and riadl.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | <!--根据指定条件获取记录--> |
| | | <select id="getIntakeAmountDayLast" resultType="com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay"> |
| | | select |
| | | CAST(riadl.intake_id AS char)AS intakeId, |
| | | pint.name as intakeName, |
| | | riadl.dt as dt, |
| | | riadl.amount as amount, |
| | | riadl.dt_last as dtLast, |
| | | riadl.rtu_addr_last as rtuAddrLast, |
| | | CAST(riadl.controller_id_last AS char)AS controllerIdLast, |
| | | riadl.total_amount_last as totalAmountLast, |
| | | riadl.rtu_dt_last as rtuDtLast |
| | | from rm_intake_amount_day_last riadl |
| | | Left join pr_intake pint on pint.id = riadl.intake_id |
| | | <where> |
| | | <if test="intakeName != null"> |
| | | and pint.name like CONCAT('%',#{intakeName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and riadl.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and riadl.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | ORDER BY riadl.id DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | | </if> |
| | | </select> |
| | | </mapper> |
| | |
| | | rtu_dt_last = #{rtuDtLast,jdbcType=TIMESTAMP} |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <!--根据指定条件获取记录总数--> |
| | | <select id="getRecordCount" resultType="java.lang.Long"> |
| | | select count(*) |
| | | from rm_intake_amount_day riad |
| | | Left join pr_intake pint on pint.id = riad.intake_id |
| | | <where> |
| | | <if test="intakeName != null"> |
| | | and pint.name like CONCAT('%',#{intakeName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and riad.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and riad.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | <!--根据指定条件获取记录--> |
| | | <select id="getIntakeAmountDayHistory" resultType="com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay"> |
| | | select |
| | | CAST(riad.intake_id AS char)AS intakeId, |
| | | pint.name as intakeName, |
| | | riad.dt as dt, |
| | | riad.amount as amount, |
| | | riad.dt_last as dtLast, |
| | | riad.rtu_addr_last as rtuAddrLast, |
| | | CAST(riad.controller_id_last AS char)AS controllerIdLast, |
| | | riad.total_amount_last as totalAmountLast, |
| | | riad.rtu_dt_last as rtuDtLast |
| | | from rm_intake_amount_day riad |
| | | Left join pr_intake pint on pint.id = riad.intake_id |
| | | <where> |
| | | <if test="intakeName != null"> |
| | | and pint.name like CONCAT('%',#{intakeName,jdbcType=VARCHAR},'%') |
| | | </if> |
| | | <if test="startDt != null"> |
| | | and riad.dt >= #{startDt,jdbcType=DATE} |
| | | </if> |
| | | <if test="endDt != null"> |
| | | and riad.dt <= #{endDt,jdbcType=DATE} |
| | | </if> |
| | | </where> |
| | | ORDER BY riad.id DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | | </if> |
| | | </select> |
| | | </mapper> |
| | |
| | | import com.dy.common.webUtil.ResultCodeMsg; |
| | | import com.dy.pipIrrGlobal.voRm.VoClientAmountDay; |
| | | import com.dy.pipIrrGlobal.voRm.VoControllerAlarmState; |
| | | import com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay; |
| | | import com.dy.pipIrrGlobal.voSe.VoActiveCard; |
| | | import com.dy.pipIrrRemote.records.clientAmountDay.ClientAmountDayQueryVo; |
| | | import com.dy.pipIrrRemote.records.controllerAlarmState.ControllerAlarmStateQueryVo; |
| | | import com.dy.pipIrrRemote.records.intakeAmountDay.IntakeAmountDayQueryVo; |
| | | import io.swagger.v3.oas.annotations.Operation; |
| | | import io.swagger.v3.oas.annotations.media.Content; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页控制器报警与状态数据(BaseResponse.content:QueryResultVo[{}])", |
| | | description = "返回一页农户日用水量统计数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页控制器报警与状态数据(BaseResponse.content:QueryResultVo[{}])", |
| | | description = "返回一页农户日用水量统计数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 根据指定条件获取取水口日取水量漏损列表(历史) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的取水口日取水量漏损列表(历史) |
| | | */ |
| | | @Operation(summary = "获得一页取水口日取水量漏损记录", description = "返回一页取水口日取水量漏损数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页取水口日取水量漏损数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getIntakeAmountDayHistory") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoIntakeAmountDay>>> getIntakeAmountDayHistory(@RequestBody IntakeAmountDayQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoIntakeAmountDay>> res = recordsSv.getIntakeAmountDayHistory(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取农户日用水量统计记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 根据指定条件获取取水口日取水量漏损列表(最新) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的取水口日取水量漏损列表(最新) |
| | | */ |
| | | @Operation(summary = "获得一页取水口日取水量漏损记录", description = "返回一页取水口日取水量漏损数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页取水口日取水量漏损数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getIntakeAmountDayLast") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoIntakeAmountDay>>> getIntakeAmountDayLast(@RequestBody IntakeAmountDayQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoIntakeAmountDay>> res = recordsSv.getIntakeAmountDayLast(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取农户日用水量统计记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | } |
| | |
| | | package com.dy.pipIrrRemote.records; |
| | | |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.pipIrrGlobal.daoRm.RmAlarmStateHistoryMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.RmAlarmStateLastMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayLastMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.*; |
| | | import com.dy.pipIrrGlobal.voRm.VoClientAmountDay; |
| | | import com.dy.pipIrrGlobal.voRm.VoControllerAlarmState; |
| | | import com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay; |
| | | import com.dy.pipIrrRemote.records.clientAmountDay.ClientAmountDayQueryVo; |
| | | import com.dy.pipIrrRemote.records.controllerAlarmState.ControllerAlarmStateQueryVo; |
| | | import com.dy.pipIrrRemote.records.intakeAmountDay.IntakeAmountDayQueryVo; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.dubbo.common.utils.PojoUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | |
| | | private RmAlarmStateLastMapper rmAlarmStateLastMapper; |
| | | |
| | | @Autowired |
| | | private RmClientAmountDayLastMapper rmClientAmountDayLastMapper; |
| | | @Autowired |
| | | private RmClientAmountDayMapper rmClientAmountDayMapper; |
| | | @Autowired |
| | | private RmClientAmountDayLastMapper rmClientAmountDayLastMapper; |
| | | |
| | | @Autowired |
| | | private RmIntakeAmountDayMapper rmIntakeAmountDayMapper; |
| | | @Autowired |
| | | private RmIntakeAmountDayLastMapper rmIntakeAmountDayLastMapper; |
| | | |
| | | |
| | | /** |
| | |
| | | rsVo.obj = rmClientAmountDayLastMapper.getClientAmountDayLast(params); |
| | | return rsVo; |
| | | } |
| | | |
| | | /** |
| | | * 获得一页取水口日取水量漏损记录(历史) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoIntakeAmountDay>> getIntakeAmountDayHistory(IntakeAmountDayQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmIntakeAmountDayMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoIntakeAmountDay>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmIntakeAmountDayMapper.getIntakeAmountDayHistory(params); |
| | | return rsVo; |
| | | } |
| | | |
| | | /** |
| | | * 获得一页取水口日取水量漏损记录(最新) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoIntakeAmountDay>> getIntakeAmountDayLast(IntakeAmountDayQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmIntakeAmountDayLastMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoIntakeAmountDay>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmIntakeAmountDayLastMapper.getIntakeAmountDayLast(params); |
| | | return rsVo; |
| | | } |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.clientAmountDay; |
| | | |
| | | import com.dy.common.aop.SsoAop; |
| | | import com.dy.common.webUtil.BaseResponse; |
| | | import com.dy.common.webUtil.BaseResponseUtils; |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.common.webUtil.ResultCodeMsg; |
| | | import com.dy.pipIrrGlobal.voRm.VoClientAmountDay; |
| | | import com.dy.pipIrrGlobal.voSe.VoActiveCard; |
| | | import io.swagger.v3.oas.annotations.Operation; |
| | | import io.swagger.v3.oas.annotations.media.Content; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import io.swagger.v3.oas.annotations.responses.ApiResponse; |
| | | import io.swagger.v3.oas.annotations.responses.ApiResponses; |
| | | import io.swagger.v3.oas.annotations.tags.Tag; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.http.MediaType; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 14:30 |
| | | * @LastEditTime :2024/7/24 14:30 |
| | | * @Description |
| | | */ |
| | | @Slf4j |
| | | @Tag(name = "农户日用水量统计查询", description = "农户日用水量统计查询") |
| | | @RestController |
| | | @RequestMapping(path = "clientAmountDay") |
| | | public class ClientAmountDayCtrl { |
| | | |
| | | @Autowired |
| | | private ClientAmountDaySv clientAmountDaySv; |
| | | |
| | | |
| | | /** |
| | | * 根据指定条件获取农户日用水量统计列表(历史) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的农户日用水量统计列表(历史) |
| | | */ |
| | | @Operation(summary = "获得一页农户日用水量统计记录", description = "返回一页农户日用水量统计数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页农户日用水量统计数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getClientAmountDayHistory") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoClientAmountDay>>> getClientAmountDayHistory(@RequestBody ClientAmountDayQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoClientAmountDay>> res = clientAmountDaySv.getClientAmountDayHistory(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取农户日用水量统计记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 根据指定条件获取农户日用水量统计列表(最新) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的农户日用水量统计列表(最新) |
| | | */ |
| | | @Operation(summary = "获得一页农户日用水量统计记录", description = "返回一页农户日用水量统计数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页农户日用水量统计数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getClientAmountDayLast") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoClientAmountDay>>> getClientAmountDayLast(@RequestBody ClientAmountDayQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoClientAmountDay>> res = clientAmountDaySv.getClientAmountDayLast(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取农户日用水量统计记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | } |
File was renamed from pipIrr-platform/pipIrr-web/pipIrr-web-remote/src/main/java/com/dy/pipIrrRemote/records/ClientAmountDayQueryVo.java |
| | |
| | | package com.dy.pipIrrRemote.records; |
| | | package com.dy.pipIrrRemote.records.clientAmountDay; |
| | | |
| | | import com.dy.common.webUtil.QueryConditionVo; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import lombok.*; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.util.Date; |
| | | import java.sql.Date; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | |
| | | private String clientName; |
| | | |
| | | @Schema(description = "统计开始日期", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date startDt; |
| | | |
| | | @Schema(description = "统计结束日期", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date endDt; |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.clientAmountDay; |
| | | |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayLastMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayMapper; |
| | | import com.dy.pipIrrGlobal.voRm.VoClientAmountDay; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.dubbo.common.utils.PojoUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 14:30 |
| | | * @LastEditTime :2024/7/24 14:30 |
| | | * @Description |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class ClientAmountDaySv { |
| | | |
| | | @Autowired |
| | | private RmClientAmountDayMapper rmClientAmountDayMapper; |
| | | @Autowired |
| | | private RmClientAmountDayLastMapper rmClientAmountDayLastMapper; |
| | | |
| | | |
| | | /** |
| | | * 获得一页农户日用水量统计记录(历史) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoClientAmountDay>> getClientAmountDayHistory(ClientAmountDayQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmClientAmountDayMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoClientAmountDay>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmClientAmountDayMapper.getClientAmountDayHistory(params); |
| | | return rsVo; |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 获得一页农户日用水量统计记录(最新) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoClientAmountDay>> getClientAmountDayLast(ClientAmountDayQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmClientAmountDayLastMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoClientAmountDay>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmClientAmountDayLastMapper.getClientAmountDayLast(params); |
| | | return rsVo; |
| | | } |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.controllerAlarmState; |
| | | |
| | | import com.dy.common.aop.SsoAop; |
| | | import com.dy.common.webUtil.BaseResponse; |
| | | import com.dy.common.webUtil.BaseResponseUtils; |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.common.webUtil.ResultCodeMsg; |
| | | import com.dy.pipIrrGlobal.voRm.VoControllerAlarmState; |
| | | import com.dy.pipIrrGlobal.voSe.VoActiveCard; |
| | | import io.swagger.v3.oas.annotations.Operation; |
| | | import io.swagger.v3.oas.annotations.media.Content; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import io.swagger.v3.oas.annotations.responses.ApiResponse; |
| | | import io.swagger.v3.oas.annotations.responses.ApiResponses; |
| | | import io.swagger.v3.oas.annotations.tags.Tag; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.http.MediaType; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 14:22 |
| | | * @LastEditTime :2024/7/24 14:22 |
| | | * @Description |
| | | */ |
| | | @Slf4j |
| | | @Tag(name = "控制器报警与状态查询", description = "控制器报警与状态查询") |
| | | @RestController |
| | | @RequestMapping(path = "controllerAlarmState") |
| | | public class ControllerAlarmStateCtrl { |
| | | |
| | | @Autowired |
| | | private ControllerAlarmStateSv controllerAlarmStateSv; |
| | | |
| | | |
| | | /** |
| | | * 根据指定条件获取控制器报警与状态列表(历史) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的控制器报警与状态列表(历史) |
| | | */ |
| | | @Operation(summary = "获得一页控制器报警与状态记录", description = "返回一页控制器报警与状态数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页控制器报警与状态数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getControllerAlarmStateHistory") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoControllerAlarmState>>> getControllerAlarmStateHistory(@RequestBody ControllerAlarmStateQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoControllerAlarmState>> res = controllerAlarmStateSv.getControllerAlarmStateHistory(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取控制器报警与状态记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 根据指定条件获取控制器报警与状态列表(最新) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的控制器报警与状态列表(最新) |
| | | */ |
| | | @Operation(summary = "获得一页控制器报警与状态记录", description = "返回一页控制器报警与状态数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页控制器报警与状态数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getControllerAlarmStateLast") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoControllerAlarmState>>> getControllerAlarmStateLast(@RequestBody ControllerAlarmStateQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoControllerAlarmState>> res = controllerAlarmStateSv.getControllerAlarmStateLast(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取控制器记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | } |
File was renamed from pipIrr-platform/pipIrr-web/pipIrr-web-remote/src/main/java/com/dy/pipIrrRemote/records/ControllerAlarmStateQueryVo.java |
| | |
| | | package com.dy.pipIrrRemote.records; |
| | | package com.dy.pipIrrRemote.records.controllerAlarmState; |
| | | |
| | | import com.dy.common.webUtil.QueryConditionVo; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.controllerAlarmState; |
| | | |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.pipIrrGlobal.daoRm.RmAlarmStateHistoryMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.RmAlarmStateLastMapper; |
| | | import com.dy.pipIrrGlobal.voRm.VoControllerAlarmState; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.dubbo.common.utils.PojoUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 14:22 |
| | | * @LastEditTime :2024/7/24 14:22 |
| | | * @Description |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class ControllerAlarmStateSv { |
| | | |
| | | @Autowired |
| | | private RmAlarmStateHistoryMapper rmAlarmStateHistoryMapper; |
| | | @Autowired |
| | | private RmAlarmStateLastMapper rmAlarmStateLastMapper; |
| | | |
| | | |
| | | |
| | | /** |
| | | * 获得一页控制器报警与状态记录(历史) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoControllerAlarmState>> getControllerAlarmStateHistory(ControllerAlarmStateQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmAlarmStateHistoryMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoControllerAlarmState>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmAlarmStateHistoryMapper.getControllerAlarmStateHistory(params); |
| | | return rsVo; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获得一页控制器报警与状态记录(最新) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoControllerAlarmState>> getControllerAlarmStateLast(ControllerAlarmStateQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmAlarmStateLastMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoControllerAlarmState>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmAlarmStateLastMapper.getControllerAlarmStateLast(params); |
| | | return rsVo; |
| | | } |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.intakeAmountDay; |
| | | |
| | | import com.dy.common.aop.SsoAop; |
| | | import com.dy.common.webUtil.BaseResponse; |
| | | import com.dy.common.webUtil.BaseResponseUtils; |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.common.webUtil.ResultCodeMsg; |
| | | import com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay; |
| | | import com.dy.pipIrrGlobal.voSe.VoActiveCard; |
| | | import io.swagger.v3.oas.annotations.Operation; |
| | | import io.swagger.v3.oas.annotations.media.Content; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import io.swagger.v3.oas.annotations.responses.ApiResponse; |
| | | import io.swagger.v3.oas.annotations.responses.ApiResponses; |
| | | import io.swagger.v3.oas.annotations.tags.Tag; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.http.MediaType; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 14:37 |
| | | * @LastEditTime :2024/7/24 14:37 |
| | | * @Description |
| | | */ |
| | | @Slf4j |
| | | @Tag(name = "取水口日取水量漏损查询", description = "取水口日取水量漏损查询") |
| | | @RestController |
| | | @RequestMapping(path = "intakeAmountDay") |
| | | public class IntakeAmountDayCtrl { |
| | | |
| | | @Autowired |
| | | private IntakeAmountDaySv intakeAmountDaySv; |
| | | |
| | | /** |
| | | * 根据指定条件获取取水口日取水量漏损列表(历史) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的取水口日取水量漏损列表(历史) |
| | | */ |
| | | @Operation(summary = "获得一页取水口日取水量漏损记录", description = "返回一页取水口日取水量漏损数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页取水口日取水量漏损数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getIntakeAmountDayHistory") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoIntakeAmountDay>>> getIntakeAmountDayHistory(@RequestBody IntakeAmountDayQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoIntakeAmountDay>> res = intakeAmountDaySv.getIntakeAmountDayHistory(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取农户日用水量统计记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 根据指定条件获取取水口日取水量漏损列表(最新) |
| | | * |
| | | * @param vo 查询条件 |
| | | * @return 符合条件的取水口日取水量漏损列表(最新) |
| | | */ |
| | | @Operation(summary = "获得一页取水口日取水量漏损记录", description = "返回一页取水口日取水量漏损数据") |
| | | @ApiResponses(value = { |
| | | @ApiResponse( |
| | | responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE, |
| | | description = "返回一页取水口日取水量漏损数据(BaseResponse.content:QueryResultVo[{}])", |
| | | content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE, |
| | | schema = @Schema(implementation = VoActiveCard.class))} |
| | | ) |
| | | }) |
| | | @GetMapping(path = "/getIntakeAmountDayLast") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoIntakeAmountDay>>> getIntakeAmountDayLast(@RequestBody IntakeAmountDayQueryVo vo) { |
| | | try { |
| | | QueryResultVo<List<VoIntakeAmountDay>> res = intakeAmountDaySv.getIntakeAmountDayLast(vo); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | | } catch (Exception e) { |
| | | log.error("获取农户日用水量统计记录异常", e); |
| | | return BaseResponseUtils.buildException(e.getMessage()); |
| | | } |
| | | } |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.intakeAmountDay; |
| | | |
| | | import com.dy.common.webUtil.QueryConditionVo; |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import lombok.*; |
| | | |
| | | import java.sql.Date; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 10:21 |
| | | * @LastEditTime :2024/7/24 10:21 |
| | | * @Description |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @ToString(callSuper = true) |
| | | @NoArgsConstructor |
| | | @AllArgsConstructor |
| | | @Builder |
| | | @Schema(name = "取水口日取水量漏损查询条件") |
| | | public class IntakeAmountDayQueryVo extends QueryConditionVo { |
| | | |
| | | @Schema(description = "intakeName", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private String intakeName; |
| | | |
| | | @Schema(description = "统计开始日期", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private Date startDt; |
| | | |
| | | @Schema(description = "统计结束日期", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | private Date endDt; |
| | | } |
New file |
| | |
| | | package com.dy.pipIrrRemote.records.intakeAmountDay; |
| | | |
| | | import com.dy.common.webUtil.QueryResultVo; |
| | | import com.dy.pipIrrGlobal.daoRm.RmIntakeAmountDayLastMapper; |
| | | import com.dy.pipIrrGlobal.daoRm.RmIntakeAmountDayMapper; |
| | | import com.dy.pipIrrGlobal.voRm.VoIntakeAmountDay; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.dubbo.common.utils.PojoUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @author :WuZeYu |
| | | * @Date :2024/7/24 14:38 |
| | | * @LastEditTime :2024/7/24 14:38 |
| | | * @Description |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class IntakeAmountDaySv { |
| | | |
| | | @Autowired |
| | | private RmIntakeAmountDayMapper rmIntakeAmountDayMapper; |
| | | @Autowired |
| | | private RmIntakeAmountDayLastMapper rmIntakeAmountDayLastMapper; |
| | | |
| | | |
| | | /** |
| | | * 获得一页取水口日取水量漏损记录(历史) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoIntakeAmountDay>> getIntakeAmountDayHistory(IntakeAmountDayQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmIntakeAmountDayMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoIntakeAmountDay>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmIntakeAmountDayMapper.getIntakeAmountDayHistory(params); |
| | | return rsVo; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获得一页取水口日取水量漏损记录(最新) |
| | | * @param vo |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoIntakeAmountDay>> getIntakeAmountDayLast(IntakeAmountDayQueryVo vo) { |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo); |
| | | |
| | | Long itemTotal = rmIntakeAmountDayLastMapper.getRecordCount(params); |
| | | |
| | | QueryResultVo<List<VoIntakeAmountDay>> rsVo = new QueryResultVo<>(); |
| | | rsVo.pageSize = vo.pageSize; |
| | | rsVo.pageCurr = vo.pageCurr; |
| | | |
| | | rsVo.calculateAndSet(itemTotal, params); |
| | | rsVo.obj = rmIntakeAmountDayLastMapper.getIntakeAmountDayLast(params); |
| | | return rsVo; |
| | | } |
| | | } |