| | |
| | | |
| | | <select id="getMenuList" resultType="com.ycl.entity.user.UmsMenu"> |
| | | SELECT distinct m.id, |
| | | m.parent_id parentId, |
| | | m.create_time createTime, |
| | | m.title, |
| | | m.url, |
| | | m.level, |
| | | m.sort, |
| | | m.name, |
| | | m.icon, |
| | | m.hidden |
| | | m.parent_id parentId, |
| | | m.create_time createTime, |
| | | m.title, |
| | | m.url, |
| | | m.level, |
| | | m.sort, |
| | | m.name, |
| | | m.icon, |
| | | m.hidden |
| | | FROM ums_admin_role_relation arr |
| | | LEFT JOIN ums_role r ON arr.role_id = r.id |
| | | LEFT JOIN ums_role_menu_relation rmr ON r.id = rmr.role_id |
| | |
| | | </select> |
| | | |
| | | <select id="adminMenuRelation" resultType="com.ycl.entity.user.vo.UmsMenuVo"> |
| | | SELECT amr.id AS relationId, |
| | | amr.is_start AS isStart, |
| | | amr.sort, |
| | | m.id, |
| | | m.parent_id AS parentId, |
| | | m.title, |
| | | m.url, |
| | | m.`level`, |
| | | m.description, |
| | | m.create_time as createTime, |
| | | m.hidden, |
| | | m.icon |
| | | FROM `ums_admin_menu_relation` AS amr |
| | | JOIN ums_menu AS m ON amr.menu_id = m.id |
| | | WHERE amr.admin_id = #{id} |
| | | SELECT distinct m.id, |
| | | m.parent_id AS parentId, |
| | | m.title, |
| | | m.url, |
| | | m.`level`, |
| | | m.description, |
| | | m.create_time as createTime, |
| | | m.hidden, |
| | | m.icon |
| | | FROM ums_admin_role_relation arr |
| | | INNER JOIN `ums_role_menu_relation` AS rmr on rmr.role_id = arr.role_id |
| | | JOIN ums_menu AS m ON rmr.menu_id = m.id |
| | | WHERE arr.admin_id = #{id} |
| | | order by m.id |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | public Boolean saveOrUpdateUpload(UploadDisposingResultParam uploadDisposingResultParam) { |
| | | AdminUserDetails user = (AdminUserDetails) SecurityContextHolder.getContext().getAuthentication().getPrincipal(); |
| | | ArrivalSituation arrivalSituationed = iArrivalSituationService.getOne(new LambdaQueryWrapper<ArrivalSituation>().eq(ArrivalSituation::getBaseCaseId, uploadDisposingResultParam.getCaseId())); |
| | | if (arrivalSituationed != null || arrivalSituationed.getId() != null) { |
| | | if (arrivalSituationed != null) { |
| | | //当事人 |
| | | PartyInfo partyInfo = new PartyInfo(); |
| | | if (StringUtils.isNotEmpty(uploadDisposingResultParam.getName())) { |
| | |
| | | writ.setIllegalBuildingId(uploadDisposingResultParam.getCaseId()); |
| | | writ.setCreateTime(LocalDateTime.now()); |
| | | writ.setCreateUser(user.getUserId()); |
| | | writ.setLimitTime(LocalDateTime.parse(uploadDisposingResultParam.getLimitTime(), DateTimeFormatter.ofPattern("YYYY-MM-dd HH:mm:ss"))); |
| | | writ.setRectifyTime(LocalDateTime.parse(uploadDisposingResultParam.getRectifyTime(), DateTimeFormatter.ofPattern("YYYY-MM-dd HH:mm:ss"))); |
| | | writ.setSendTime(LocalDateTime.parse(uploadDisposingResultParam.getSendTime(), DateTimeFormatter.ofPattern("YYYY-MM-dd HH:mm:ss"))); |
| | | DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); |
| | | writ.setLimitTime(LocalDateTime.parse(uploadDisposingResultParam.getLimitTime(), dtf)); |
| | | writ.setRectifyTime(LocalDateTime.parse(uploadDisposingResultParam.getRectifyTime(), dtf)); |
| | | writ.setSendTime(LocalDateTime.parse(uploadDisposingResultParam.getSendTime(), dtf)); |
| | | iWritService.save(writ); |
| | | imageResources.setUrl(StringUtils |
| | | .joinWith(",", uploadDisposingResultParam.getPic() |
| | |
| | | package com.ycl.vo; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | |
| | | @Data |
| | | @ApiModel(value = "我的待办") |
| | | public class MyBacklogVO { |
| | | |
| | | /** |
| | | * 事件id |
| | | */ |
| | | @ApiModelProperty(value = "事件id") |
| | | private Integer caseId; |
| | | /** |
| | | * 事件编号 |
| | | */ |
| | |
| | | * 创建时间 |
| | | */ |
| | | @ApiModelProperty(value = "创建时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime createTime; |
| | | |
| | | /** |
| | | * 剩余时间 |
| | | */ |
| | | @ApiModelProperty(value = "开始时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime limitTime; |
| | | } |
| | |
| | | package com.ycl.vo.casePool; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | |
| | | * 报警时间 |
| | | */ |
| | | @ApiModelProperty(value = "报警时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm", timezone = "GMT+8") |
| | | private LocalDateTime alarmTime; |
| | | |
| | | |
| | |
| | | t3.event_source, |
| | | t3.category, |
| | | t2.step_name, |
| | | t3.`id` caseId, |
| | | t3.`code`, |
| | | t2.create_time, |
| | | t2.limit_time |
| | |
| | | left JOIN ums_dispose_record t2 ON t1.role_id = t2.handler_role_id |
| | | left JOIN ums_base_case t3 ON t2.base_case_id=t3.id |
| | | <where> |
| | | t1.admin_id = #{id} |
| | | t1.admin_id = #{id} and t3.`code` is not null |
| | | AND ISNULL( t2.end_time ) |
| | | <if test="code!='' and code!=null"> |
| | | and t3.`code` LIKE CONCAT('%',#{code},'%') |
| | |
| | | t3.event_source, |
| | | t3.category, |
| | | t2.step_name, |
| | | t3.`id` caseId, |
| | | t3.`code`, |
| | | t2.create_time, |
| | | t2.limit_time |