skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbProjectController.java
@@ -1,12 +1,14 @@ package cn.gistack.sm.sjztmd.controller; import cn.gistack.sm.sjztmd.dto.TbProjectDTO; import cn.gistack.sm.sjztmd.dto.TbProjectIsfillDTO; import cn.gistack.sm.sjztmd.excel.TbProjectExcel; import cn.gistack.sm.sjztmd.excel.TbProjectImporter; import cn.gistack.sm.sjztmd.service.ITbProjectService; import cn.gistack.sm.sjztmd.statisticsVO.*; import cn.gistack.sm.sjztmd.vo.StatisticsPrice; import cn.gistack.sm.sjztmd.vo.StatisticsPriceVO; import cn.gistack.sm.sjztmd.vo.TbProjectIsfillVO; import cn.gistack.sm.sjztmd.vo.TbProjectVO; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -103,4 +105,15 @@ return R.data(list); } @PostMapping("isFill") public R isFill(@RequestBody TbProjectIsfillDTO fil ){ tbProjectService.updateFill(fil); return R.success("操作成功"); } @GetMapping("/isfillList") public R isFillList(){ TbProjectIsfillVO tbProjectIsfillVO = tbProjectService.getfill(); return R.data(tbProjectIsfillVO); } } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/dto/TbProjectIsfillDTO.java
New file @@ -0,0 +1,24 @@ package cn.gistack.sm.sjztmd.dto; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; @Data public class TbProjectIsfillDTO{ private int isFil; @DateTimeFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd") private Date stratTime; @DateTimeFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd") private Date endTime; } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbProjectMapper.java
@@ -1,11 +1,13 @@ package cn.gistack.sm.sjztmd.mapper; import cn.gistack.sm.sjztmd.dto.TbProjectDTO; import cn.gistack.sm.sjztmd.dto.TbProjectIsfillDTO; import cn.gistack.sm.sjztmd.entity.TbProject; import cn.gistack.sm.sjztmd.statisticsVO.StatisticsParams; import cn.gistack.sm.sjztmd.statisticsVO.StatisticsTableProject; import cn.gistack.sm.sjztmd.vo.StatisticsPrice; import cn.gistack.sm.sjztmd.vo.StatisticsPriceVO; import cn.gistack.sm.sjztmd.vo.TbProjectIsfillVO; import cn.gistack.sm.sjztmd.vo.TbProjectVO; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; @@ -31,4 +33,8 @@ List<StatisticsPriceVO> getStatisticsPieBars(@Param("params") StatisticsParams statisticsParams); void updateallcheck(); void updateFill(@Param("params") TbProjectIsfillDTO fil); TbProjectIsfillVO getfill(); } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbProjectMapper.xml
@@ -41,6 +41,9 @@ <update id="updateallcheck"> update SJZT_MD."tb_project" set set "is_fill" ='', "check_state" =''; </update> <update id="updateFill"> update SJZT_MD."tb_project_fill" set "isFil" = #{params.isFil}, "start_time" = #{params.stratTime},"end_time"= #{params.endTime} </update> <select id="getList" resultType="cn.gistack.sm.sjztmd.vo.TbProjectVO"> @@ -414,4 +417,7 @@ WHERE b."p_ad_code" = #{params.adCode} </select> <select id="getfill" resultType="cn.gistack.sm.sjztmd.vo.TbProjectIsfillVO"> select "isFil","end_time" endTime, "start_time" stratTime from SJZT_MD."tb_project_fill" </select> </mapper> skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/ITbProjectService.java
@@ -1,6 +1,7 @@ package cn.gistack.sm.sjztmd.service; import cn.gistack.sm.sjztmd.dto.TbProjectDTO; import cn.gistack.sm.sjztmd.dto.TbProjectIsfillDTO; import cn.gistack.sm.sjztmd.entity.TbProject; import cn.gistack.sm.sjztmd.excel.TbProjectExcel; import cn.gistack.sm.sjztmd.statisticsVO.StatisticsParams; @@ -8,6 +9,7 @@ import cn.gistack.sm.sjztmd.statisticsVO.StatisticsTableProject; import cn.gistack.sm.sjztmd.vo.StatisticsPrice; import cn.gistack.sm.sjztmd.vo.StatisticsPriceVO; import cn.gistack.sm.sjztmd.vo.TbProjectIsfillVO; import cn.gistack.sm.sjztmd.vo.TbProjectVO; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; @@ -33,4 +35,8 @@ List<StatisticsPriceVO> statisticsBar(StatisticsParams statisticsParams); void updateallcheck() throws Exception; void updateFill(TbProjectIsfillDTO fil); TbProjectIsfillVO getfill(); } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbProjectServiceImpl.java
@@ -1,6 +1,7 @@ package cn.gistack.sm.sjztmd.service.impl; import cn.gistack.sm.sjztmd.dto.TbProjectDTO; import cn.gistack.sm.sjztmd.dto.TbProjectIsfillDTO; import cn.gistack.sm.sjztmd.entity.AttAdBase; import cn.gistack.sm.sjztmd.entity.TbProject; import cn.gistack.sm.sjztmd.entity.TbProjectSchedule; @@ -17,6 +18,7 @@ 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.TbProjectIsfillVO; import cn.gistack.sm.sjztmd.vo.TbProjectVO; import com.baomidou.dynamic.datasource.annotation.DS; import com.baomidou.mybatisplus.core.metadata.IPage; @@ -216,4 +218,14 @@ } } @Override public void updateFill(TbProjectIsfillDTO fil) { baseMapper.updateFill(fil); } @Override public TbProjectIsfillVO getfill() { return baseMapper.getfill(); } } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/TbProjectIsfillVO.java
New file @@ -0,0 +1,21 @@ package cn.gistack.sm.sjztmd.vo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; @Data public class TbProjectIsfillVO { private int isFil; @DateTimeFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd") private Date stratTime; @DateTimeFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd") private Date endTime; }
