| | |
| | | |
| | | 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; |
| | |
| | | } |
| | | 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); |
| | | } |
| | | |
| | | |
| | | } |