项目管理每月初重置填报状态v0.2

yxm

2024-07-08 e7835f5a5feee4cad2388efe4e3af9003cb5e5c6

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbProjectServiceImpl.java

@@ -6,13 +6,17 @@
import cn.gistack.sm.sjztmd.entity.TbProjectSchedule;
import cn.gistack.sm.sjztmd.excel.TbProjectExcel;
import cn.gistack.sm.sjztmd.mapper.TbProjectMapper;
import cn.gistack.sm.sjztmd.service.IAttAdBaseService;
import cn.gistack.sm.sjztmd.service.IAttResBaseService;
import cn.gistack.sm.sjztmd.service.ITbProjectScheduleService;
import cn.gistack.sm.sjztmd.service.ITbProjectService;
import cn.gistack.sm.sjztmd.statisticsVO.StatisticsParams;
import cn.gistack.sm.sjztmd.statisticsVO.StatisticsPie;
import cn.gistack.sm.sjztmd.statisticsVO.StatisticsTable;
import cn.gistack.sm.sjztmd.statisticsVO.StatisticsTableProject;
import cn.gistack.sm.sjztmd.util.CalculateUtils;
import cn.gistack.sm.sjztmd.vo.StatisticsPrice;
import cn.gistack.sm.sjztmd.vo.StatisticsPriceVO;
import cn.gistack.sm.sjztmd.vo.TbProjectVO;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -21,10 +25,14 @@
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.StringUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import java.util.List;

@Service
@@ -35,6 +43,8 @@

   private final ITbProjectScheduleService tbProjectScheduleService;
   private final IAttResBaseService attResBaseService;
   @Autowired
   private  IAttAdBaseService iAttAdBaseService;

   @Override
   public Object getList(TbProjectVO tbProjectVO, IPage<TbProjectVO> page) {
@@ -165,4 +175,45 @@
      tbProject.setCheckState(checkState);
      return saveOrUpdate(tbProject);
   }

   @Override
   public StatisticsPrice statisticsPie(StatisticsParams statisticsParams) {

      AttAdBase ywxtAdDetail = iAttAdBaseService.getYwxtAdDetail(statisticsParams.getAdCode());
      if (ywxtAdDetail.getAdGrad().equals("1")) {
         StatisticsPrice    statisticsPie =baseMapper.getStatisticsPie(statisticsParams);
         return statisticsPie;
      }
      StatisticsPrice statisticsPie =baseMapper.getStatisticsPies(statisticsParams);

      return statisticsPie;
   }

   @Override
   public List<StatisticsPriceVO> statisticsBar(StatisticsParams statisticsParams) {
      AttAdBase ywxtAdDetail = iAttAdBaseService.getYwxtAdDetail(statisticsParams.getAdCode());
      if (ywxtAdDetail.getAdGrad().equals("1")) {
         List<StatisticsPriceVO>    statisticsPieBar =baseMapper.getStatisticsPieBar(statisticsParams);
         return statisticsPieBar;
      }
      List<StatisticsPriceVO>    statisticsPieBar =baseMapper.getStatisticsPieBars(statisticsParams);
      return statisticsPieBar;
   }

   @Override
   public void updateallcheck() throws Exception {
      Date now = new Date();
      SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
      String today = sdf.format(now);

      // 转换为年月格式，用于检查是否为月初
      String yearMonth = sdf.format(sdf.parse(today).getTime()).substring(0, 7);
      // 检查当前日期是否为月初
      if (today.startsWith(yearMonth + "-01")) {
         baseMapper.updateallcheck();
      } else {
         System.out.println("不是月初，不予修改状态");
      }

   }
}