| | |
| | | import com.dy.common.util.DateTime; |
| | | import com.dy.pipIrrGlobal.daoTmp.ChangeMapper; |
| | | import com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDay; |
| | | import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountMonth; |
| | | import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountYear; |
| | | import com.dy.pipIrrGlobal.voSt.VoIntake; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | this.dao = dao; |
| | | } |
| | | |
| | | |
| | | //////////////////////////////////////// |
| | | // |
| | | // 有关日统计 |
| | | // |
| | | /////////////////////////////////////// |
| | | |
| | | /** |
| | | * 调整取水口日取水量统计 |
| | | * @throws Exception |
| | | */ |
| | | public void chIntakeAmountDay() throws Exception{ |
| | | RmIntakeAmountDay lastAd = null ; |
| | | List<VoIntake> list = dao.selectAllPrIntakes() ; |
| | |
| | | }else{ |
| | | if(ad.amount != null && ad.amount > IntakeAmountDayFlag){ |
| | | if(ad.totalAmountLast != null && lastAd.totalAmountLast != null){ |
| | | //重新计算日取水量 |
| | | ad.amount = ad.totalAmountLast - lastAd.totalAmountLast; |
| | | if(ad.amount < 0){//存这种情况 |
| | | if(ad.amount < 0){//计算日取水量后,可能会有这种情况发生(负值) |
| | | log.info("出现调整后的日取水量出现负值" + ad.amount |
| | | + "情况,数据id=" + ad.id |
| | | + ",取水口id=" + ad.intakeId |
| | | + ",日期=" + ad.dt |
| | | + ",设置水量=0.0" |
| | | ); |
| | | ad.amount = 0.0 ; |
| | | } |
| | | if(ad.amount > IntakeAmountDayFlag){ |
| | | //计算日取水量后,仍大于IntakeAmountDayFlag |
| | | log.info("出现调整后的日取水量仍大于" |
| | | + IntakeAmountDayFlag |
| | | + "的情况,数据id=" + ad.id |
| | |
| | | ); |
| | | ad.amount = 0.0 ; |
| | | } |
| | | this.doUpdateOneIntakeAmountDay(ad.id, 0.0); |
| | | this.doUpdateOneIntakeAmountDay(ad.id, ad.amount); |
| | | } |
| | | } |
| | | lastAd = ad ; |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | @Transactional |
| | | int doUpdateOneIntakeAmountDay(Long id, Double amount){ |
| | | protected int doUpdateOneIntakeAmountDay(Long id, Double amount){ |
| | | return dao.updateOneIntakeAmountDay(id, amount); |
| | | } |
| | | |
| | | |
| | | |
| | | //////////////////////////////////////// |
| | | // |
| | | // 有关月统计 |
| | | // |
| | | /////////////////////////////////////// |
| | | |
| | | private static final int DealStartYear = 2024 ; |
| | | private static final int DealStartMonth = 8 ; |
| | | |
| | | /** |
| | | * 删除所有取水口月取水量统计 |
| | | * @throws Exception |
| | | */ |
| | | @Transactional |
| | | public void deleteAllIntakeAmountMonth(){ |
| | | dao.deleteAllIntakeAmountMonth(); |
| | | } |
| | | |
| | | /** |
| | | * 统计取水口月取水量 |
| | | * @throws Exception |
| | | */ |
| | | public void statisticsIntakeAmountMonth() throws Exception{ |
| | | int nowYear = Integer.parseInt(DateTime.yyyy()) ; |
| | | int nowMonth = Integer.parseInt(DateTime.mm()) ; |
| | | Date startDt ; |
| | | Date endDt ; |
| | | List<StIntakeAmountMonth> list ; |
| | | for(int year = DealStartYear; year <= nowYear; year ++){ |
| | | list = null ; |
| | | if(year < nowYear){ |
| | | for(int month = 1 ; month <= 12 ; month ++){ |
| | | startDt = DateTime.dateFrom_yyyy_MM_dd(year + "-" + month + "-01") ; |
| | | endDt = DateTime.dateFrom_yyyy_MM_dd(year + "-" + month + "-" + DateTime.endDayOfMonth(year, month)) ; |
| | | list = dao.statisticAllIntakeAmountMonthFromAmountDay(startDt, endDt) ; |
| | | this.doStatisticsIntakeAmountMonth(year, month, list) ; |
| | | } |
| | | }else{ |
| | | for(int month = 1 ; month <= nowMonth ; month ++){ |
| | | startDt = DateTime.dateFrom_yyyy_MM_dd(year + "-" + month + "-01") ; |
| | | endDt = DateTime.dateFrom_yyyy_MM_dd(year + "-" + month + "-" + DateTime.endDayOfMonth(year, month)) ; |
| | | list = dao.statisticAllIntakeAmountMonthFromAmountDay(startDt, endDt) ; |
| | | this.doStatisticsIntakeAmountMonth(year, month, list) ; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | @Transactional |
| | | protected void doStatisticsIntakeAmountMonth(int year, int month, List<StIntakeAmountMonth> list) throws Exception{ |
| | | if(list != null && list.size() > 0){ |
| | | for(StIntakeAmountMonth po : list){ |
| | | po.year = year ; |
| | | po.month = month ; |
| | | dao.saveOneIntakeAmountMonth(po) ; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | //////////////////////////////////////// |
| | | // |
| | | // 有关年统计 |
| | | // |
| | | /////////////////////////////////////// |
| | | /** |
| | | * 删除所有取水口年取水量统计 |
| | | * @throws Exception |
| | | */ |
| | | @Transactional |
| | | public void deleteAllIntakeAmountYear(){ |
| | | dao.deleteAllIntakeAmountYear(); |
| | | } |
| | | |
| | | /** |
| | | * 统计取水口月取水量 |
| | | * @throws Exception |
| | | */ |
| | | public void statisticsIntakeAmountYear() throws Exception{ |
| | | int nowYear = Integer.parseInt(DateTime.yyyy()) ; |
| | | Date startDt ; |
| | | Date endDt ; |
| | | List<StIntakeAmountYear> list ; |
| | | for(int year = DealStartYear; year <= nowYear; year ++){ |
| | | list = null ; |
| | | startDt = DateTime.dateFrom_yyyy_MM_dd(year + "-01-01") ; |
| | | endDt = DateTime.dateFrom_yyyy_MM_dd(year + "-12-31") ; |
| | | list = dao.statisticAllIntakeAmountYearFromAmountDay(startDt, endDt) ; |
| | | this.doStatisticsIntakeAmountYear(year, list) ; |
| | | } |
| | | } |
| | | @Transactional |
| | | protected void doStatisticsIntakeAmountYear(int year, List<StIntakeAmountYear> list) throws Exception{ |
| | | if(list != null && list.size() > 0){ |
| | | for(StIntakeAmountYear po : list){ |
| | | po.year = year ; |
| | | dao.saveOneIntakeAmountYear(po) ; |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |