From 1a2b07f01ba4616fd9e894dddf474b56d020158c Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期一, 07 四月 2025 15:18:51 +0800 Subject: [PATCH] 整理版本 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/ChangeMapper.java | 182 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 182 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/ChangeMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/ChangeMapper.java new file mode 100644 index 0000000..8700793 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/ChangeMapper.java @@ -0,0 +1,182 @@ +package com.dy.pipIrrGlobal.daoTmp; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDay; +import com.dy.pipIrrGlobal.pojoRm.RmLossDay; +import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountMonth; +import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountYear; +import com.dy.pipIrrGlobal.pojoSt.StLossMonth; +import com.dy.pipIrrGlobal.pojoSt.StLossYear; +import com.dy.pipIrrGlobal.voSt.VoIntake; +import com.dy.pipIrrGlobal.voTmp.VoRmIntakeAmountDay; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; + +import java.util.Date; +import java.util.List; + +/** + * @Author: liurunyu + * @Date: 2024/12/14 09:27 + * @Description + */ +@Mapper +public interface ChangeMapper extends BaseMapper<Object> { + + /** + * 鏌ヨ鍏ㄩ儴鍙栨按鍙� + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoIntake> selectAllPrIntakes(); + + /** + * 鏌ヨ涓�涓彇姘村彛鐨勬棩鐢ㄦ按閲忕粺璁¤褰� + * + * @return 瀹炰綋闆嗗悎 + */ + List<RmIntakeAmountDay> selectOneIntakeAllAmountDay(@Param("intakeId")Long intakeId); + + /** + * 鏇存柊涓�涓彇姘村彛鐨勬棩鐢ㄦ按閲忕粺璁� + * + * @return 褰卞搷瀹炰綋鏁� + */ + int updateOneIntakeAmountDay(@Param("id")Long id, @Param("amount")Double amount); + /** + * 鏇存柊涓�涓彇姘村彛鐨勬棩鐢ㄦ按閲忕粺璁� + * + * @return 褰卞搷瀹炰綋鏁� + */ + /** + * 鏇存柊涓�涓彇姘村彛鐨勬棩鐢ㄦ按閲忕粺璁� + * + * @return 褰卞搷瀹炰綋鏁� + */ + int updateOneIntakeAmountDay1(@Param("intakeId")Long intakeId, @Param("dt")Date dt, + @Param("amount")Double amount, @Param("money")Double money, @Param("times")Integer times); + + + + + /** + * 鍒犻櫎鎵�鏈夊彇姘村彛鐨勬棩鐢ㄦ按閲忕粺璁� + * @return 褰卞搷瀹炰綋鏁� + */ + int deleteSomeIntakeAmountDay(); + + + + /** + * 缁熻鎵�鏈夊彇姘村彛鐨勬棩鐢ㄦ按閲� + * @return 瀹炰綋闆嗗悎 + */ + List<VoRmIntakeAmountDay> statisticAllIntakeAmountDayFromOpenCloseValveHistory(@Param("startDt")Date startDt, + @Param("endDt")Date endDt); + + List<RmIntakeAmountDay> selectStIntakeDayStatisticsByDate(@Param("intakeId")Long intakeId, @Param("date")Date date); + + /** + * 鍒犻櫎鎵�鏈夊彇姘村彛鐨勬湀鐢ㄦ按閲忕粺璁� + * @return 褰卞搷瀹炰綋鏁� + */ + int deleteAllIntakeAmountMonth(); + + + /** + * 缁熻鎵�鏈夊彇姘村彛鐨勬湀鐢ㄦ按閲� + * @return 瀹炰綋闆嗗悎 + */ + List<StIntakeAmountMonth> statisticAllIntakeAmountMonthFromAmountDay(@Param("startDt")Date startDt, + @Param("endDt")Date endDt); + /** + * 淇濆瓨鍙栨按鍙g殑鏈堢敤姘撮噺缁熻 + * @return 褰卞搷瀹炰綋鏁� + */ + int saveOneIntakeAmountMonth(StIntakeAmountMonth pojo); + + + + + /** + * 鍒犻櫎鎵�鏈夊彇姘村彛鐨勫勾鐢ㄦ按閲忕粺璁� + * @return 褰卞搷瀹炰綋鏁� + */ + int deleteAllIntakeAmountYear(); + + + /** + * 缁熻鎵�鏈夊彇姘村彛鐨勫勾鐢ㄦ按閲� + * @return 瀹炰綋闆嗗悎 + */ + List<StIntakeAmountYear> statisticAllIntakeAmountYearFromAmountDay(@Param("startDt")Date startDt, + @Param("endDt")Date endDt); + /** + * 淇濆瓨鍙栨按鍙g殑鏈堢敤姘撮噺缁熻 + * @return 褰卞搷瀹炰綋鏁� + */ + int saveOneIntakeAmountYear(StIntakeAmountYear pojo); + + + //////////////////////////////////////// + // + //婕忔崯鐩稿叧 + // + //////////////////////////////////////// + + /** + * 鏌ヨ涓�涓彇姘村彛鐨勬棩婕忔崯閲忕粺璁¤褰� + * + * @return 瀹炰綋闆嗗悎 + */ + List<RmLossDay> selectOneIntakeAllLossDay(@Param("intakeId")Long intakeId); + + /** + * 鏇存柊涓�涓彇姘村彛鐨勬棩婕忔崯閲忕粺璁� + * + * @return 褰卞搷瀹炰綋鏁� + */ + int updateOneIntakeLossDay(@Param("id")Long id, @Param("loss")Double loss); + + + + /** + * 鍒犻櫎鎵�鏈夊彇姘村彛鐨勬湀婕忔崯閲忕粺璁� + * @return 褰卞搷瀹炰綋鏁� + */ + int deleteAllIntakeLossMonth(); + + + /** + * 缁熻鎵�鏈夊彇姘村彛鐨勬湀婕忔崯閲� + * @return 瀹炰綋闆嗗悎 + */ + List<StLossMonth> statisticAllIntakeLossMonthFromLossDay(@Param("startDt")Date startDt, + @Param("endDt")Date endDt); + /** + * 淇濆瓨鍙栨按鍙g殑鏈堟紡鎹熼噺缁熻 + * @return 褰卞搷瀹炰綋鏁� + */ + int saveOneIntakeLossMonth(StLossMonth pojo); + + + /** + * 鍒犻櫎鎵�鏈夊彇姘村彛鐨勫勾婕忔崯閲忕粺璁� + * @return 褰卞搷瀹炰綋鏁� + */ + int deleteAllIntakeLossYear(); + + + /** + * 缁熻鎵�鏈夊彇姘村彛鐨勫勾婕忔崯閲� + * @return 瀹炰綋闆嗗悎 + */ + List<StLossYear> statisticAllIntakeLossYearFromLossDay(@Param("startDt")Date startDt, + @Param("endDt")Date endDt); + /** + * 淇濆瓨鍙栨按鍙g殑鏈堟紡鎹熼噺缁熻 + * @return 褰卞搷瀹炰綋鏁� + */ + int saveOneIntakeLossYear(StLossYear pojo); + +} \ No newline at end of file -- Gitblit v1.8.0