获取附近相机增加数据权限

‘liusuyi’

2024-02-29 133098a6f81de1de99cb0a5c829b7d1b39105e84

 ard-work/src/main/java/com/ruoyi/alarmpoints/tube/service/impl/ArdTubesServiceImpl.java

@@ -1,15 +1,22 @@
package com.ruoyi.alarmpoints.tube.service.impl;

import java.util.List;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruoyi.alarmpoints.tube.domain.ArdTubes;
import com.ruoyi.alarmpoints.tube.domain.ArdTubesDetails;
import com.ruoyi.alarmpoints.tube.domain.ArdTubesParam;
import com.ruoyi.alarmpoints.tube.mapper.ArdTubesDetailsMapper;
import com.ruoyi.alarmpoints.tube.mapper.ArdTubesMapper;
import com.ruoyi.alarmpoints.tube.service.IArdTubesService;
import com.ruoyi.common.annotation.DataScope;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.uuid.IdUtils;
import com.ruoyi.utils.result.Results;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
@@ -24,6 +31,7 @@
    private ArdTubesMapper ardTubesMapper;
    @Resource
    private ArdTubesDetailsMapper ardTubesDetailsMapper;

    /**
     * 查询管线管理
     *
@@ -44,13 +52,16 @@
    @Override
    @DataScope(deptAlias = "d", userAlias = "u")
    public List<ArdTubes> selectArdTubesList(ArdTubes ardTubes) {
        ArdTubesDetails tubesDetails=new ArdTubesDetails();
        tubesDetails.setTubeId(ardTubes.getId());
        List<ArdTubesDetails> ardTubesDetails = ardTubesDetailsMapper.selectArdTubesDetailsList(tubesDetails);
        ArdTubes arttube=new ArdTubes();
        arttube.setChildCount(ardTubesDetails.size());
        ardTubesMapper.updateArdTubes(arttube);
        return ardTubesMapper.selectArdTubesList(ardTubes);

        List<ArdTubes> tubes = ardTubesMapper.selectArdTubesList(ardTubes);
        for (ArdTubes tube : tubes) {
            ArdTubesDetails tubesDetails = new ArdTubesDetails();
            tubesDetails.setTubeId(tube.getId());
            List<ArdTubesDetails> ardTubesDetails = ardTubesDetailsMapper.selectArdTubesDetailsList(tubesDetails);
            tube.setChildCount(ardTubesDetails.size());
            ardTubesMapper.updateArdTubes(tube);
        }
        return tubes;
    }

    /**
@@ -61,6 +72,7 @@
     */
    @Override
    public int insertArdTubes(ArdTubes ardTubes) {
        ardTubes.setId(IdUtils.simpleUUID());
        ardTubes.setChildCount(0);
        ardTubes.setUserId(SecurityUtils.getUserId());
        ardTubes.setCreateBy(SecurityUtils.getUsername());
@@ -90,11 +102,11 @@
     */
    @Override
    public int deleteArdTubesByIds(String[] ids) {
        for (String id: ids ) {
            ArdTubesDetails tubesDetails=new ArdTubesDetails();
        for (String id : ids) {
            ArdTubesDetails tubesDetails = new ArdTubesDetails();
            tubesDetails.setTubeId(id);
            List<ArdTubesDetails> ardTubesDetails = ardTubesDetailsMapper.selectArdTubesDetailsList(tubesDetails);
            if(ardTubesDetails.size()>0) {
            if (ardTubesDetails.size() > 0) {
                for (ArdTubesDetails tubesDetail : ardTubesDetails) {
                    int i = ardTubesDetailsMapper.deleteArdTubesDetailsById(tubesDetail.getId());
                }
@@ -111,14 +123,66 @@
     */
    @Override
    public int deleteArdTubesById(String id) {
        ArdTubesDetails tubesDetails=new ArdTubesDetails();
        ArdTubesDetails tubesDetails = new ArdTubesDetails();
        tubesDetails.setTubeId(id);
        List<ArdTubesDetails> ardTubesDetails = ardTubesDetailsMapper.selectArdTubesDetailsList(tubesDetails);
        if(ardTubesDetails.size()>0) {
        if (ardTubesDetails.size() > 0) {
            for (ArdTubesDetails tubesDetail : ardTubesDetails) {
                int i = ardTubesDetailsMapper.deleteArdTubesDetailsById(tubesDetail.getId());
            }
        }
        return ardTubesMapper.deleteArdTubesById(id);
    }

    @Override
    public Results tubeById(String id) {
        ArdTubes ardTubes = ardTubesMapper.selectById(id);
        if(ardTubes!=null){
            QueryWrapper<ArdTubesDetails> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("tube_id",id);
            List<ArdTubesDetails> list = ardTubesDetailsMapper.selectList(queryWrapper);
            ardTubes.setArdTubesDetails(list);
        }
        return Results.succeed(ardTubes);
    }

    @Override
    public Results tobeList(List<Long> deptList) {
        QueryWrapper<ArdTubes> queryWrapper = new QueryWrapper<>();
        queryWrapper.in("dept_id",deptList);
        List<ArdTubes> list = ardTubesMapper.selectList(queryWrapper);
        if(list.size()>0){
            for (int i = 0; i < list.size(); i++) {
                ArdTubes ardTubes = list.get(i);
                QueryWrapper<ArdTubesDetails> detailsQueryWrapper = new QueryWrapper<>();
                queryWrapper.eq("tube_id",ardTubes.getId());
                List<ArdTubesDetails> details = ardTubesDetailsMapper.selectList(detailsQueryWrapper);
                ardTubes.setArdTubesDetails(details);
            }
        }
        return Results.succeed(list);
    }

    @Override
    public Results conditionList(ArdTubesParam ardTubesParam) {
        QueryWrapper<ArdTubes> queryWrapper = new QueryWrapper<>();
        queryWrapper.in("dept_id",ardTubesParam.getDeptList())
                .eq(!StringUtils.isBlank(ardTubesParam.getName()),"name",ardTubesParam.getName())
                .eq(!StringUtils.isBlank(ardTubesParam.getType()),"type",ardTubesParam.getType())
                .eq(!StringUtils.isBlank(ardTubesParam.getPipeDiameter()),"pipe_diameter",ardTubesParam.getPipeDiameter())
                .eq(!StringUtils.isBlank(ardTubesParam.getColor()),"color",ardTubesParam.getColor());
        List<ArdTubes> list = ardTubesMapper.selectList(queryWrapper);
        if(list.size()>0){
            for (int i = 0; i < list.size(); i++) {
                ArdTubes ardTubes = list.get(i);
                QueryWrapper<ArdTubesDetails> detailsQueryWrapper = new QueryWrapper<>();
                queryWrapper.eq("tube_id",ardTubes.getId());
                List<ArdTubesDetails> details = ardTubesDetailsMapper.selectList(detailsQueryWrapper);
                ardTubes.setArdTubesDetails(details);
            }
        }
        return Results.succeed(list);
    }


}