督办单增加组织id

jinpengyong

2022-02-17 273defb3cc6cbbd74494a853a23cb8fe14c22b8b

 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;
@@ -15,6 +17,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.system.ApplicationHome;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import org.springframework.web.multipart.MultipartFile;

@@ -43,12 +46,16 @@
    @Autowired
    private SupervisionMapper supervisionMapper;

    @Autowired
    private OrganizationService organizationService;

    @Override
    @Transactional
    public Map<String, Object> add(MultipartFile[] files, Supervision supervision) {
        //获取jar包所在目录
        ApplicationHome h = new ApplicationHome(getClass());
        ApplicationHome applicationHome = new ApplicationHome(getClass());
        //在jar包所在目录下生成一个upload文件夹用来存储上传的图片
        String path = h.getSource().getParentFile().toString() + "/static/img";
        String path = applicationHome.getSource().getParentFile().toString() + "/static/img";

        Map<String, Object> result = new HashMap<>();

@@ -88,30 +95,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());
@@ -124,10 +145,13 @@
    }

    @Override
    @Transactional
    public Map<String, Object> updateSupervision(MultipartFile[] files, Supervision supervision) {

        String path = this.getClass().getClassLoader()
                .getResource("").getFile() + "static/img";
        //获取jar包所在目录
        ApplicationHome applicationHome = new ApplicationHome(getClass());
        //在jar包所在目录下生成一个upload文件夹用来存储上传的图片
        String path = applicationHome.getSource().getParentFile().toString() + "/static/img";

        Map<String, Object> result = new HashMap<>();

@@ -165,6 +189,7 @@
    }

    @Override
    @Transactional
    public void deleteSupervision(Integer supervisionId) {
        QueryWrapper<Supervision> queryWrapper = new QueryWrapper<>();
        queryWrapper.select("id", "images").eq("id", supervisionId);
@@ -178,12 +203,11 @@


        //删除服务器中的督办单中图片
        String path = this.getClass().getClassLoader()
                .getResource("").getFile() + "static/img";
        ApplicationHome applicationHome = new ApplicationHome(getClass());
        String path = applicationHome.getSource().getParentFile().toString() + "/static/img";
        for (String image : images) {
            String realPath = path + File.separator + image;
            File file = new File(realPath);
            log.info(realPath);
            if (file.exists() && file.isFile()) {
                file.delete();
            }