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<SysEnvironmentalInfo> findByIds(String[] ids) {
|
Example example=new Example(SysEnvironmentalInfo.class);
|
example.createCriteria().andIn("id",Arrays.asList(ids));
|
return sysEnvironmentalInfoMapper.selectByExample(example);
|
}
|
|
public void insertBatch(List<SysEnvironmentalInfo> 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<SysEnvironmentalInfo> 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<SysEnvironmentalInfo> findByParentId(Long parentId){
|
SysEnvironmentalInfo sysEnvironmentalInfo=new SysEnvironmentalInfo();
|
sysEnvironmentalInfo.setParentId(parentId);
|
sysEnvironmentalInfo.setDelFlag(Constants.DEL_NOT_FLAG);
|
List<SysEnvironmentalInfo> 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<SysEnvironmentalInfo> findByCityId(String cityId) {
|
SysEnvironmentalInfo sysEnvironmentalInfo = new SysEnvironmentalInfo();
|
sysEnvironmentalInfo.setDelFlag(0);
|
sysEnvironmentalInfo.setCityId(Convert.toInt(cityId));
|
List<SysEnvironmentalInfo> list = sysEnvironmentalInfoMapper.select(sysEnvironmentalInfo);
|
return list;
|
}
|
}
|
