20210804

xiaoyong931011

2021-08-04 ea868a98b776b9e89db429a195704a1412ca8905

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
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; 
    } 
}