package com.ruoyi.oa.service.impl;
|
|
import cn.hutool.core.bean.BeanUtil;
|
import cn.hutool.http.HttpStatus;
|
import com.ruoyi.common.exception.ServiceException;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.common.utils.PageUtils;
|
import com.ruoyi.common.core.page.PagePlus;
|
import com.ruoyi.common.core.page.TableDataInfo;
|
import org.springframework.stereotype.Service;
|
import com.ruoyi.common.core.mybatisplus.core.ServicePlusImpl;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.ruoyi.oa.domain.bo.SgIotBo;
|
import com.ruoyi.oa.domain.vo.SgIotVo;
|
import com.ruoyi.oa.domain.SgIot;
|
import com.ruoyi.oa.mapper.SgIotMapper;
|
import com.ruoyi.oa.service.ISgIotService;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Collection;
|
|
/**
|
* IoT设备Service业务层处理
|
*
|
* @author ruoyi
|
* @date 2022-05-12
|
*/
|
@Service
|
public class SgIotServiceImpl extends ServicePlusImpl<SgIotMapper, SgIot, SgIotVo> implements ISgIotService {
|
|
@Override
|
public SgIotVo queryById(Long id) {
|
return getVoById(id);
|
}
|
|
@Override
|
public TableDataInfo<SgIotVo> queryPageList(SgIotBo bo) {
|
PagePlus<SgIot, SgIotVo> result = pageVo(PageUtils.buildPagePlus(), buildQueryWrapper(bo));
|
return PageUtils.buildDataInfo(result);
|
}
|
|
@Override
|
public List<SgIotVo> queryList(SgIotBo bo) {
|
return listVo(buildQueryWrapper(bo));
|
}
|
|
private LambdaQueryWrapper<SgIot> buildQueryWrapper(SgIotBo bo) {
|
Map<String, Object> params = bo.getParams();
|
LambdaQueryWrapper<SgIot> lqw = Wrappers.lambdaQuery();
|
lqw.like(StringUtils.isNotBlank(bo.getDeploymentName()), SgIot::getDeploymentName, bo.getDeploymentName());
|
lqw.eq(StringUtils.isNotBlank(bo.getEdition()), SgIot::getEdition, bo.getEdition());
|
lqw.eq(bo.getBuildingId() != null, SgIot::getBuildingId, bo.getBuildingId());
|
lqw.eq(bo.getOrganizationId() != null, SgIot::getOrganizationId, bo.getOrganizationId());
|
lqw.eq(bo.getConstructionBatchId() != null, SgIot::getConstructionBatchId, bo.getConstructionBatchId());
|
lqw.like(StringUtils.isNotBlank(bo.getMonitorObject()), SgIot::getMonitorObject, bo.getMonitorObject());
|
lqw.eq(SgIot::getSchoolId, bo.getSchoolId());
|
lqw.orderByDesc(SgIot::getUpdateTime);
|
if (bo.getPeripheralUnit() != null && StringUtils.isNotBlank(bo.getPassageway())) {
|
if ("1".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayOne, bo.getPeripheralUnit());
|
}
|
if ("2".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayTwo, bo.getPeripheralUnit());
|
}
|
if ("3".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayThree, bo.getPeripheralUnit());
|
}
|
if ("4".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayFour, bo.getPeripheralUnit());
|
}
|
if ("5".equals(bo.getPassageway())) {
|
lqw.and(i -> i.eq(SgIot::getPassagewayOne, bo.getPeripheralUnit())
|
.or().eq(SgIot::getPassagewayTwo, bo.getPeripheralUnit())
|
.or().eq(SgIot::getPassagewayThree, bo.getPeripheralUnit())
|
.or().eq(SgIot::getPassagewayFour, bo.getPeripheralUnit()));
|
}
|
}
|
return lqw;
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Boolean insertByBo(SgIotBo bo) {
|
List<SgIot> list = baseMapper.selectList(new LambdaQueryWrapper<SgIot>()
|
.eq(SgIot::getDeploymentName, bo.getDeploymentName())
|
.eq(SgIot::getSchoolId, bo.getSchoolId()));
|
if (list.size() > 0) {
|
throw new ServiceException("部署名称重复", HttpStatus.HTTP_PARTIAL);
|
}
|
List<SgIot> lanList = baseMapper.selectList(new LambdaQueryWrapper<SgIot>()
|
.eq(SgIot::getLan, bo.getLan())
|
.eq(SgIot::getSchoolId, bo.getSchoolId()));
|
if (lanList.size() > 0) {
|
throw new ServiceException("LAN重复", HttpStatus.HTTP_PARTIAL);
|
}
|
SgIot add = BeanUtil.toBean(bo, SgIot.class);
|
validEntityBeforeSave(add);
|
boolean flag = save(add);
|
if (flag) {
|
bo.setId(add.getId());
|
}
|
return flag;
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Boolean updateByBo(SgIotBo bo) {
|
List<SgIot> list = baseMapper.selectList(new LambdaQueryWrapper<SgIot>()
|
.eq(SgIot::getDeploymentName, bo.getDeploymentName())
|
.eq(SgIot::getSchoolId, bo.getSchoolId())
|
.ne(SgIot::getId, bo.getId()));
|
if (list.size() > 0) {
|
throw new ServiceException("部署名称重复", HttpStatus.HTTP_PARTIAL);
|
}
|
List<SgIot> lanList = baseMapper.selectList(new LambdaQueryWrapper<SgIot>()
|
.eq(SgIot::getLan, bo.getLan())
|
.eq(SgIot::getSchoolId, bo.getSchoolId())
|
.ne(SgIot::getId, bo.getId()));
|
if (lanList.size() > 0) {
|
throw new ServiceException("LAN重复", HttpStatus.HTTP_PARTIAL);
|
}
|
SgIot update = BeanUtil.toBean(bo, SgIot.class);
|
validEntityBeforeSave(update);
|
return updateById(update);
|
}
|
|
@Override
|
public int getNumber(SgIotBo bo) {
|
int sum = 0;
|
LambdaQueryWrapper<SgIot> lqw = Wrappers.lambdaQuery();
|
lqw.eq(SgIot::getSchoolId, bo.getSchoolId());
|
if (bo.getPeripheralUnit() != null && StringUtils.isNotBlank(bo.getPassageway())) {
|
if ("5".equals(bo.getPassageway())) {
|
lqw.and(i -> i.eq(SgIot::getPassagewayOne, bo.getPeripheralUnit())
|
.or().eq(SgIot::getPassagewayTwo, bo.getPeripheralUnit())
|
.or().eq(SgIot::getPassagewayThree, bo.getPeripheralUnit())
|
.or().eq(SgIot::getPassagewayFour, bo.getPeripheralUnit()));
|
List<SgIot> list = baseMapper.selectList(lqw);
|
if (list.size() > 0) {
|
for (SgIot s : list) {
|
if (s.getPassagewayOne() != null && s.getPassagewayOne().equals(bo.getPeripheralUnit())) {
|
sum = sum + 1;
|
}
|
if (s.getPassagewayTwo() != null && s.getPassagewayTwo().equals(bo.getPeripheralUnit())) {
|
sum = sum + 1;
|
}
|
if (s.getPassagewayThree() != null && s.getPassagewayThree().equals(bo.getPeripheralUnit())) {
|
sum = sum + 1;
|
}
|
if (s.getPassagewayFour() != null && s.getPassagewayFour().equals(bo.getPeripheralUnit())) {
|
sum = sum + 1;
|
}
|
}
|
} else {
|
sum = 0;
|
}
|
} else {
|
if ("1".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayOne, bo.getPeripheralUnit());
|
}
|
if ("2".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayTwo, bo.getPeripheralUnit());
|
}
|
if ("3".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayThree, bo.getPeripheralUnit());
|
}
|
if ("4".equals(bo.getPassageway())) {
|
lqw.eq(SgIot::getPassagewayFour, bo.getPeripheralUnit());
|
}
|
List<SgIot> list = baseMapper.selectList(lqw);
|
sum = list.size();
|
}
|
}
|
return sum;
|
}
|
|
/**
|
* 保存前的数据校验
|
*
|
* @param entity 实体类数据
|
*/
|
private void validEntityBeforeSave(SgIot entity) {
|
//TODO 做一些数据校验,如唯一约束
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Boolean deleteWithValidByIds(Collection<Long> ids, Boolean isValid) {
|
if (isValid) {
|
//TODO 做一些业务上的校验,判断是否需要校验
|
}
|
return removeByIds(ids);
|
}
|
}
|
