From ae0a308278e39b89d2e7dda7b09baed72ae44edd Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 17 Feb 2022 15:30:23 +0800 Subject: [PATCH] update --- screen-api/src/main/java/com/moral/api/service/impl/SupervisionServiceImpl.java | 49 +++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 39 insertions(+), 10 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/service/impl/SupervisionServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/SupervisionServiceImpl.java index 7a6d770..e6df36e 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/SupervisionServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/SupervisionServiceImpl.java @@ -2,8 +2,10 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.moral.api.entity.Organization; import com.moral.api.entity.Supervision; import com.moral.api.mapper.SupervisionMapper; +import com.moral.api.service.OrganizationService; import com.moral.api.service.SupervisionService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; @@ -44,6 +46,9 @@ @Autowired private SupervisionMapper supervisionMapper; + @Autowired + private OrganizationService organizationService; + @Override @Transactional public Map<String, Object> add(MultipartFile[] files, Supervision supervision) { @@ -54,8 +59,16 @@ Map<String, Object> result = new HashMap<>(); - List<String> images = new ArrayList<>(); + //��������������������� + QueryWrapper<Supervision> queryWrapper = new QueryWrapper<>(); + queryWrapper.eq("number", supervision.getNumber()).eq("is_delete", Constants.NOT_DELETE); + if (supervisionMapper.selectOne(queryWrapper) != null) { + result.put("code", ResponseCodeEnum.SUPERVISION_NUMBER_EXIT.getCode()); + result.put("msg", ResponseCodeEnum.SUPERVISION_NUMBER_EXIT.getMsg()); + return result; + } + List<String> images = new ArrayList<>(); for (MultipartFile file : files) { //������������������������ String fileType = file.getContentType(); @@ -83,6 +96,8 @@ .collect(Collectors.joining(",")); supervision.setImages(image); } + + supervisionMapper.insert(supervision); return result; } @@ -90,30 +105,44 @@ @Override public Map<String, Object> selectSupervisions(Map<String, Object> params) { //������������������ - int cityCode = Integer.parseInt(params.get("cityCode").toString()); int page = Integer.parseInt(params.get("page").toString()); int size = Integer.parseInt(params.get("size").toString()); Object start = params.get("start"); Object end = params.get("end"); + Integer orgId = Integer.parseInt(params.get("organizationId").toString()); - QueryWrapper<Supervision> queryWrapper = new QueryWrapper<>(); - queryWrapper.eq("city_code", cityCode) - .eq("is_delete", Constants.NOT_DELETE); + //������������������������������ + List<Organization> organizations = organizationService.getChildrenOrganizationsById(orgId); + List<Integer> orgIds = organizations.stream().map(Organization::getId).collect(Collectors.toList()); + orgIds.add(orgId); + + QueryWrapper<Supervision> supervisionQueryWrapper = new QueryWrapper<>(); + supervisionQueryWrapper.eq("is_delete", Constants.NOT_DELETE).in("organization_id", orgIds); + //��������������������������������������������������������������������������������������������������������������������������� + if (params.get("cityCode") != null) { + String cityCode = params.get("cityCode").toString(); + //��������������������������������������������������������������������������������������� + if (cityCode.endsWith("00")) { + supervisionQueryWrapper.eq("CONCAT(LEFT(city_code,4),'00')", cityCode); + } else { + supervisionQueryWrapper.eq("city_code", cityCode); + } + } + if (start != null) { - queryWrapper.ge("time", start); + supervisionQueryWrapper.ge("time", start); } if (start != null) { - queryWrapper.le("time", end); + supervisionQueryWrapper.le("time", end); } //���time������ - queryWrapper.orderByDesc("time"); + supervisionQueryWrapper.orderByDesc("time"); //������ Page<Supervision> supervisionPage = new Page<>(page, size); - supervisionMapper.selectPage(supervisionPage, queryWrapper); + supervisionMapper.selectPage(supervisionPage, supervisionQueryWrapper); List<Supervision> supervisions = supervisionPage.getRecords(); - Map<String, Object> result = new LinkedHashMap<>(); result.put("total", supervisionPage.getTotal()); -- Gitblit v1.8.0