| | |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | |
| | | } |
| | | } |
| | | TTemplate tTemplate = templates.stream().filter(e -> e.getId().equals(record.getTemplateId())).findFirst().orElse(null); |
| | | // todo 应生成计划数 |
| | | record.setNum1(1); |
| | | if(Objects.nonNull(tTemplate)){ |
| | | // todo 应生成计划数 |
| | | LocalDateTime createTime = tTemplate.getCreateTime(); |
| | | // 转化为yyyy-MM-dd字符串 |
| | | StringBuilder stringBuilder = new StringBuilder(); |
| | |
| | | LocalDateTime localDateTime = tTemplate.getCreateTime().plusDays(temp); |
| | | stringBuilder.append(localDateTime.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))); |
| | | record.setTemplateDate(stringBuilder.toString()); |
| | | } |
| | | } |
| | | if (record.getNum2() != 0) { |
| | | record.setNum4(new BigDecimal((double) record.getNum2() / (double) record.getNum1() * 100).setScale(2, RoundingMode.HALF_DOWN)); |
| | | } else { |
| | | record.setNum4(new BigDecimal(0)); |
| | | } |
| | | } |
| | | String templateId = record.getTemplateId(); |
| | | Long count = leaveService.lambdaQuery() |
| | |
| | | leaveListVO.setLeaveTime(start+"至"+end); |
| | | if (leaveListVO.getDeptType() == 1){ |
| | | TProjectDept tProjectDept = projectDeptMapper.selectById(leaveListVO.getDeptId()); |
| | | if (!tProjectDept.getParentId().equals("0")){ |
| | | if (!"0".equals(tProjectDept.getParentId())){ |
| | | TProjectDept tProjectDept1 = projectDeptMapper.selectById(tProjectDept.getParentId()); |
| | | leaveListVO.setDeptName(tProjectDept1.getProjectName()+">"+tProjectDept.getProjectName()); |
| | | }else{ |
| | |
| | | @ApiModelProperty("部门类型 前端忽略") |
| | | private Integer deptType; |
| | | @ApiModelProperty("部门id 前端忽略") |
| | | private Integer deptId; |
| | | private String deptId; |
| | | } |
| | |
| | | select t1.*,t2.location_name as locationName,t3.location_name as locationTypeName, |
| | | t4.nick_name as patrolInspectorName, |
| | | t4.phonenumber as phonenumber, |
| | | t3.location_type_icon as locationTypeIcon |
| | | t3.location_icon as locationTypeIcon |
| | | from t_appeal t1 |
| | | left join t_task t5 on t5.id = t1.task_id |
| | | left join sys_user t4 on t5.patrol_inspector = t4.user_id |
| | |
| | | , create_time, update_time, create_by, update_by, disabled, leave_person, start_time, end_time, leave_type, leave_day, leave_cause, pictures, audit_status, audit_id, audit_time, audit_remark |
| | | </sql> |
| | | <select id="pageList" resultType="com.ruoyi.system.vo.system.LeaveListVO"> |
| | | select t1.*, t2.nick_name as nickName, t2.phonenumber as phone,t2.deptType |
| | | select t1.*, t2.nick_name as nickName, t2.phonenumber as phone,t2.deptType,t2.deptId |
| | | from t_leave t1 |
| | | left join sys_user t2 on t1.leave_person = t2.id |
| | | left join sys_user t2 on t1.leave_person = t2.user_id |
| | | where |
| | | t1.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()} |
| | | <if test="query.nickName != null and query.nickName != ''"> |