| | |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date estimatedTime; |
| | | |
| | | @ApiModelProperty("预计开始时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date startTime; |
| | | |
| | | @ApiModelProperty("协议定制时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date agreementCustomizationTime; |
| | |
| | | @PostMapping("/NeedProblem/timedNewFightNeedProblemInventoryHandler") |
| | | public R timedNewFightNeedProblemInventoryHandler(); |
| | | |
| | | @PostMapping("/NeedProblem/taskTimed/getListTime") |
| | | |
| | | //定时任务 社区组织共建 定时更新项目进度 |
| | | @PostMapping("/NewFightCommunity/taskTimed/getListTime") |
| | | public R taskTimedGetListTime(); |
| | | |
| | | |
| | |
| | | |
| | | for (NewFightCommunityConstructionDTO item:list) { |
| | | |
| | | // if(StringUtils.equals("1",item.getStatus())) |
| | | // { |
| | | // // 1 已发布 |
| | | // |
| | | // |
| | | // |
| | | // } |
| | | // else if(StringUtils.equals("2",item.getStatus())) |
| | | // { |
| | | // // 1 进行中 |
| | | // |
| | | // |
| | | // } |
| | | if(StringUtils.equals("1",item.getStatus())) |
| | | { |
| | | // 1 已发布 |
| | | Date startTime = item.getStartTime(); |
| | | if (startTime!=null) |
| | | { |
| | | if(new Date().getTime()>startTime.getTime()) |
| | | { |
| | | NewFightCommunityConstructionDTO dto=new NewFightCommunityConstructionDTO(); |
| | | dto.setId(item.getId()); |
| | | //进行中 |
| | | dto.setStatus("2"); |
| | | baseMapper.editData(dto); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //预计完成时间 |
| | | Date estimatedTime = item.getEstimatedTime(); |
| | |
| | | { |
| | | if(new Date().getTime()>estimatedTime.getTime()) |
| | | { |
| | | int pNum=projectPlanService.getNum(item.getId(),null); |
| | | int accomplishNum=projectPlanService.getNum(item.getId(),"1"); |
| | | NewFightCommunityConstructionDTO dto=new NewFightCommunityConstructionDTO(); |
| | | dto.setId(item.getId()); |
| | | dto.setStatus("3"); |
| | | if(pNum==accomplishNum) |
| | | { |
| | | //已完成 |
| | | dto.setStatus("3"); |
| | | } |
| | | else |
| | | { |
| | | //进行中 |
| | | dto.setStatus("2"); |
| | | } |
| | | baseMapper.editData(dto); |
| | | } |
| | | } |
| | |
| | | update_time, |
| | | user_id, |
| | | status, |
| | | start_time, |
| | | community_id |
| | | </sql> |
| | | |
| | |
| | | nfcc.update_time, |
| | | nfcc.user_id, |
| | | nfcc.status, |
| | | nfcc.start_time, |
| | | ca.name as communityName, |
| | | ifnull(count(nfpj.id),0) as isJoin, |
| | | nfcc.community_id |
| | |
| | | <if test="item.status != null and item.status != '' " > |
| | | status, |
| | | </if> |
| | | <if test="item.startTime != null " > |
| | | start_time, |
| | | </if> |
| | | creation_time |
| | | </trim> |
| | | values |
| | |
| | | </if> |
| | | <if test="item.status != null and item.status != '' " > |
| | | #{item.status}, |
| | | </if> |
| | | <if test="item.startTime != null " > |
| | | #{item.startTime}, |
| | | </if> |
| | | sysdate() |
| | | </trim> |
| | |
| | | <if test="item.status != null and item.status != '' " > |
| | | status=#{item.status}, |
| | | </if> |
| | | <if test="item.startTime != null " > |
| | | start_time=#{item.startTime}, |
| | | </if> |
| | | update_time=sysdate() |
| | | </set> |
| | | where id=#{item.id} |
| | |
| | | nfcc.update_time, |
| | | nfcc.user_id, |
| | | nfcc.status, |
| | | nfcc.start_time, |
| | | nfcc.community_id |
| | | FROM new_fight_community_construction as nfcc |
| | | where nfcc.status in (1,2) |