linwe
2023-11-11 a1d8ea1a72cddf7651742b87f042602ab006c879
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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.place.service.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.springblade.common.node.TreeNode;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.doorplateAddress.service.IDoorplateAddressService;
import org.springblade.modules.grid.service.IGridService;
import org.springblade.modules.place.entity.PlaceEntity;
import org.springblade.modules.place.entity.PlaceExtEntity;
import org.springblade.modules.place.entity.PlacePoiLabel;
import org.springblade.modules.place.service.IPlaceExtService;
import org.springblade.modules.place.service.IPlacePoiLabelService;
import org.springblade.modules.place.vo.PlaceVO;
import org.springblade.modules.place.mapper.PlaceMapper;
import org.springblade.modules.place.service.IPlaceService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springframework.transaction.annotation.Transactional;
 
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
 
/**
 * 场所表 服务实现类
 *
 * @author BladeX
 * @since 2023-10-28
 */
@Service
public class PlaceServiceImpl extends ServiceImpl<PlaceMapper, PlaceEntity> implements IPlaceService {
    @Autowired
    private IUserService userService;
 
    @Autowired
    private IPlacePoiLabelService placePoiLabelService;
 
    @Autowired
    private IPlaceExtService placeExtService;
 
    @Autowired
    private IDoorplateAddressService doorplateAddressService;
 
    @Autowired
    private IGridService gridService;
 
    /**
     * 自定义列表查询
     * @param page
     * @param place
     * @return
     */
    @Override
    public IPage<PlaceVO> selectPlacePage(IPage<PlaceVO> page, PlaceVO place) {
        List<String> list = new ArrayList<>();
        if (null!=place.getRoleName() && !place.getRoleName().equals("")){
            if (place.getRoleName().equals("网格员")){
                // 查询对应的房屋地址code
                list = gridService.getAddressCodeListByUserId(AuthUtil.getUserId());
            }
        }
        place.setCreateUser(AuthUtil.getUserId());
        return page.setRecords(baseMapper.selectPlacePage(page, place,list));
    }
 
    /**
     * 查询场所集合信息
     * @param userId
     * @return
     */
    @Override
    public List<TreeNode> selectPlaceNodeList(Long userId) {
        return baseMapper.selectPlaceNodeList(userId.toString());
    }
 
    /**
     * 场所信息自定义新增
     * @param placeVO
     * @return
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Boolean addVO(PlaceVO placeVO) {
        // 设置基础数据
        placeVO.setCreateUser(AuthUtil.getUserId());
        placeVO.setCreateTime(new Date());
        placeVO.setUpdateUser(AuthUtil.getUserId());
        placeVO.setUpdateTime(new Date());
        // 绑定用户信息
        bindUserHandle(placeVO);
        // 新增场所信息
        boolean save = save(placeVO);
        // 保存场所详情及任务信息
        savePlaceExtAndTaskInfo(placeVO);
        // 场所标签信息绑定
        placeLabelBind(placeVO);
        // 返回结果
        return save;
    }
 
    /**
     * 场所标签信息绑定入库
     * @param placeVO
     */
    @Transactional(rollbackFor = Exception.class)
    public void placeLabelBind(PlaceVO placeVO) {
        List<String> labelList = Arrays.asList(placeVO.getLabel().split(","));
        // 遍历
        labelList.forEach(labelId->{
            PlacePoiLabel placePoiLabel = new PlacePoiLabel();
            placePoiLabel.setPlaceId(placeVO.getId());
            placePoiLabel.setPoiCode(Integer.parseInt(labelId));
            placePoiLabelService.save(placePoiLabel);
        });
    }
 
    /**
     * 场所负责人和用户绑定
     * @param placeVO
     */
    @Transactional(rollbackFor = Exception.class)
    public User bindUserHandle(PlaceVO placeVO) {
        User newUser = new User();
        if (null!=placeVO.getPhone() && !placeVO.getPhone().equals("")) {
            //根据手机号查询库里的数据
            User userParams = new User();
            userParams.setPhone(placeVO.getPhone());
            User user = userService.getOne(Condition.getQueryWrapper(userParams));
 
            if (user != null) {
                //如果用户存在,则该用户id绑定场所
                placeVO.setPrincipalUserId(user.getId());
            } else {
                //如果用户不存在,则新增一个用户
                newUser.setAccount(placeVO.getPhone());
                newUser.setPhone(placeVO.getPhone());
                newUser.setName(placeVO.getUsername());
                newUser.setRealName(placeVO.getUsername());
                // 目前暂定居民角色,默认密码为 123456
                newUser.setRoleId("1717429059648606209");
                newUser.setPassword("123456");
                // 用户新增
                boolean submit = userService.submit(newUser);
                //绑定id
                placeVO.setPrincipalUserId(newUser.getId());
                //给人员打上场所负责人的标签
                baseMapper.saveUserLabel(newUser.getId(),1002);
            }
        }
        return newUser;
    }
 
    /**
     * 保存场所详情及任务信息
     * @param placeVO
     */
    @Transactional(rollbackFor = Exception.class)
    public void savePlaceExtAndTaskInfo(PlaceVO placeVO) {
        PlaceExtEntity placeExtEntity = new PlaceExtEntity();
        placeExtEntity.setPlaceId(placeVO.getId());
        // 判断是否已存在,已存在则不新增
        QueryWrapper<PlaceExtEntity> wrapper = new QueryWrapper<>();
        wrapper.eq("is_deleted",0)
            .eq("place_id",placeVO.getId());
        PlaceExtEntity one = placeExtService.getOne(wrapper);
        if (null == one) {
            placeExtEntity.setPlaceId(placeVO.getId());
            //新增
            placeExtService.savePlaceExt(placeExtEntity);
        }
    }
 
    /**
     * 历史场所挂接处理-临时
     * @param place
     * @return
     */
    @Override
    public Object historyPlaceHandle(PlaceVO place) {
        // 查询所有的场所(手机号不为空)
        List<PlaceVO> list = baseMapper.getPlaceNotNullPhone();
        // 遍历
        for (PlaceVO placeVO : list) {
            User user = bindUserHandle(placeVO);
            if (null!=user){
                placeVO.setPrincipalUserId(user.getId());
                //更新场所用户id绑定
                baseMapper.updatePlaceEntity(placeVO);
            }
        }
        return null;
    }
 
    /**
     * 历史场所标签挂接处理-临时
     * @param place
     * @return
     */
    @Override
    @Transactional
    public Object historyPlaceLabelHandle(PlaceVO place) {
        // 查询所有的场所
        List<PlaceVO> list = baseMapper.getAllHistoryPlace();
        // 遍历
        for (PlaceVO placeVO : list) {
            if (null!=placeVO.getLabel()){
                String[] split = placeVO.getLabel().split(",");
                for (String s : split) {
                    PlacePoiLabel placePoiLabel = new PlacePoiLabel();
                    placePoiLabel.setPlaceId(placeVO.getId());
                    placePoiLabel.setPoiCode(Integer.parseInt(s));
                    placePoiLabelService.save(placePoiLabel);
                }
            }
        }
        return null;
    }
 
    /**
     * 场所表 自定义详情查询
     * @param place
     * @return
     */
    @Override
    public PlaceVO getDetail(PlaceEntity place) {
        // 查询场所信息
        PlaceVO placeVO = baseMapper.getDetail(place);
        if (null!= placeVO) {
            if (null != placeVO.getHouseCode() && !placeVO.getHouseCode().equals("")){
                place.setHouseCode(placeVO.getHouseCode());
            }
            // 查询门牌地址信息
            if (null != place.getHouseCode() && !place.getHouseCode().equals("")) {
                QueryWrapper<DoorplateAddressEntity> wrapper = new QueryWrapper<>();
                wrapper.eq("address_code", place.getHouseCode());
                List<DoorplateAddressEntity> list = doorplateAddressService.list(wrapper);
                if (list.size() > 0) {
                    placeVO.setDoorplateAddressEntity(list.get(0));
                }
                // 查询网格数据
                placeVO.setGrid(gridService.getGridDetailByHouseCode(place.getHouseCode()));
            }else {
                // 通过定位点落面分析网格位置,反向推出社区派出所相关数据
            }
        }
        // 返回
        return placeVO;
    }
}