增加一个vo

liurunyu

2025-01-13 37b627623f03f58fef28f4a87a049ccabda6f72d

增加一个vo

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/ChangeMapper.java

@@ -63,7 +63,7 @@
     * 删除所有取水口的日用水量统计
     * @return 影响实体数
     */
    int deleteAllIntakeAmountDay();
    int deleteSomeIntakeAmountDay();




 pipIrr-platform/pipIrr-global/src/main/resources/mapper/Temp4ChangeMapper.xml

@@ -44,8 +44,8 @@
    </update>


    <delete id="deleteAllIntakeAmountDay">
        delete from rm_intake_amount_day
    <delete id="deleteSomeIntakeAmountDay">
        delete from rm_intake_amount_day where times is null
    </delete>

    <!--  -->
@@ -55,8 +55,8 @@
        sum(cl_this_money) as money,
        count(id) as times
        from  rm_open_close_valve_history
        where cl_dt <![CDATA[>=]]> #{startDt, jdbcType=DATE}
        and cl_dt <![CDATA[<=]]> #{endDt, jdbcType=DATE}
        where cl_dt <![CDATA[>=]]> #{startDt, jdbcType=TIMESTAMP}
        and cl_dt <![CDATA[<=]]> #{endDt, jdbcType=TIMESTAMP}
        group by intake_id
    </select>
    <select id="selectStIntakeDayStatisticsByDate" resultType="com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDay">

 pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/changeSome/ChSomeCtrl.java

@@ -61,8 +61,10 @@
    @GetMapping(path = "reStatisticsAllIntakeDayAmount")
    @SsoAop()
    public BaseResponse<Boolean> reStatisticsAllIntakeDayAmount() throws Exception{
        this.intakeAmountSv.deleteAllIntakeAmountDay();
        // 不能删除，以保留原始id
        // this.intakeAmountSv.deleteAllIntakeAmountDay();
        this.intakeAmountSv.statisticsIntakeAmountDay();
        this.intakeAmountSv.deleteSomeIntakeAmountDay();
        return BaseResponseUtils.buildSuccess(true);
    }


 pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/changeSome/ChSomeIntakeAmountSv.java

@@ -138,11 +138,20 @@
     * 删除所有取水口日取水量统计
     * @throws Exception
     */
    //@Transactional
    //public void deleteAllIntakeAmountDay(){
    //    dao.deleteAllIntakeAmountDay();
    //}
    /**
     * 删除一些取水口日取水量统计
     * @throws Exception
     */
    @Transactional
    public void deleteAllIntakeAmountDay(){
        dao.deleteAllIntakeAmountDay();
    public void deleteSomeIntakeAmountDay(){
        dao.deleteSomeIntakeAmountDay();
    }


    /**
     * 统计取水口日取水量
     * @throws Exception