package com.xzx.gc.user.service; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.comparator.IndexedComparator; import cn.hutool.core.convert.Convert; import cn.hutool.core.date.DateUtil; import cn.hutool.core.lang.Dict; import com.xzx.gc.common.constant.Constants; import com.xzx.gc.entity.SysEnvironmentalInfo; import com.xzx.gc.user.mapper.SysEnvironmentalInfoMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import tk.mybatis.mapper.entity.Example; import java.math.BigDecimal; import java.util.Arrays; import java.util.List; import java.util.stream.Collectors; @Service @Transactional public class SysEnvironmentalInfoService { @Autowired private SysEnvironmentalInfoMapper sysEnvironmentalInfoMapper; public SysEnvironmentalInfo findById(Long id) { return sysEnvironmentalInfoMapper.selectByPrimaryKey(id); } public List findByIds(String[] ids) { Example example=new Example(SysEnvironmentalInfo.class); example.createCriteria().andIn("id",Arrays.asList(ids)); return sysEnvironmentalInfoMapper.selectByExample(example); } public void insertBatch(List list){ sysEnvironmentalInfoMapper.insertList(list); } public void deleteGoods(String partnerId){ Example example=new Example(SysEnvironmentalInfo.class); Example.Criteria criteria = example.createCriteria(); criteria.andEqualTo("partnerId",partnerId); SysEnvironmentalInfo info = new SysEnvironmentalInfo(); info.setDelFlag(1); sysEnvironmentalInfoMapper.updateByExampleSelective(info,example); } public void insertInfo(SysEnvironmentalInfo info){ info.setId(null); info.setCreateTime(DateUtil.now()); sysEnvironmentalInfoMapper.insertSelective(info); } public List find() { Example example=new Example(SysEnvironmentalInfo.class); Example.Criteria criteria = example.createCriteria(); criteria.andEqualTo("delFlag",Constants.DEL_NOT_FLAG); criteria.andIsNotNull("parentId"); return sysEnvironmentalInfoMapper.selectByExample(example); } /** * 根据父Id查找子类 * @param parentId * @return */ public List findByParentId(Long parentId){ SysEnvironmentalInfo sysEnvironmentalInfo=new SysEnvironmentalInfo(); sysEnvironmentalInfo.setParentId(parentId); sysEnvironmentalInfo.setDelFlag(Constants.DEL_NOT_FLAG); List sysEnvironmentalInfo2 = sysEnvironmentalInfoMapper.select(sysEnvironmentalInfo); return sysEnvironmentalInfo2; } public SysEnvironmentalInfo findByItemTypeAndAreaNotDel(String itemType,Integer areaId) { Example example=new Example(SysEnvironmentalInfo.class); Example.Criteria criteria = example.createCriteria(); criteria.andEqualTo("itemType",itemType); criteria.andEqualTo("cityId",areaId); criteria.andEqualTo("delFlag",Constants.DEL_NOT_FLAG); SysEnvironmentalInfo sysEnvironmentalInfo1 = sysEnvironmentalInfoMapper.selectOneByExample(example); return sysEnvironmentalInfo1; } public List findByCityId(String cityId) { SysEnvironmentalInfo sysEnvironmentalInfo = new SysEnvironmentalInfo(); sysEnvironmentalInfo.setDelFlag(0); sysEnvironmentalInfo.setCityId(Convert.toInt(cityId)); List list = sysEnvironmentalInfoMapper.select(sysEnvironmentalInfo); return list; } }