TOrganController.java 13.9 KB
Newer Older
1 2
package cn.wisenergy.chnmuseum.party.web.controller;

wzp's avatar
wzp committed
3 4 5
import cn.wisenergy.chnmuseum.party.common.log.MethodLog;
import cn.wisenergy.chnmuseum.party.common.log.OperModule;
import cn.wisenergy.chnmuseum.party.common.log.OperType;
6
import cn.wisenergy.chnmuseum.party.common.util.DateUtil80;
7
import cn.wisenergy.chnmuseum.party.common.util.ImportExcelUtil;
liqin's avatar
liqin committed
8
import cn.wisenergy.chnmuseum.party.common.vo.GenericPageParam;
wzp's avatar
wzp committed
9
import cn.wisenergy.chnmuseum.party.model.TArea;
liqin's avatar
liqin committed
10
import cn.wisenergy.chnmuseum.party.model.TOrgan;
11
import cn.wisenergy.chnmuseum.party.model.TUser;
wzp's avatar
wzp committed
12
import cn.wisenergy.chnmuseum.party.service.TAreaService;
liqin's avatar
liqin committed
13 14
import cn.wisenergy.chnmuseum.party.service.TOrganService;
import cn.wisenergy.chnmuseum.party.web.controller.base.BaseController;
15
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
wzp's avatar
wzp committed
16
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
17 18 19 20 21 22 23 24
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
25
import org.apache.shiro.authz.annotation.RequiresAuthentication;
26
import org.springframework.web.bind.annotation.*;
27
import org.springframework.web.multipart.MultipartFile;
28 29

import javax.annotation.Resource;
wzp's avatar
wzp committed
30
import java.util.*;
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

/**
 * <pre>
 * 机构 前端控制器
 * </pre>
 *
 * @author Danny Lee
 * @since 2021-03-22
 */
@Slf4j
@RestController
@RequestMapping("/organ")
@Api(tags = {"机构操作接口"})
public class TOrganController extends BaseController {

    @Resource
    private TOrganService tOrganService;

wzp's avatar
wzp committed
49 50 51
    @Resource
    private TAreaService tAreaService;

52
    @PostMapping("/add")
wzp's avatar
wzp committed
53
    @RequiresAuthentication  //@RequiresPermissions("/organ/add")
54
    @ApiOperation(value = "添加机构", notes = "添加机构")
wzp's avatar
wzp committed
55
    @MethodLog(operModule = OperModule.ORG, operType = OperType.ADD)
56
    public Map<String, Object> add(TOrgan organ) {
wzp's avatar
wzp committed
57
        HashMap<String, Object> resultMap = new HashMap<>();
wzp's avatar
wzp committed
58
        QueryWrapper<TOrgan> ew = new QueryWrapper<>();
wzp's avatar
wzp committed
59 60 61
        if (StringUtils.isBlank(organ.getParentId())){
            organ.setParentId("0");
        }
wzp's avatar
wzp committed
62
        if (StringUtils.isNoneBlank(organ.getName().trim())) {
wzp's avatar
wzp committed
63 64 65 66
            organ.setName(organ.getName().trim());
            ew.eq("is_deleted", 0);
            ew.eq("name", organ.getName());
            List<TOrgan> list = this.tOrganService.list(ew);
wzp's avatar
wzp committed
67
            if (list != null && list.size()>0&&list.get(0)!=null) {
wzp's avatar
wzp committed
68
                resultMap.put("resultCode", "400");
wzp's avatar
wzp committed
69 70 71
                resultMap.put("message", "机构名称不能重复!");
                return resultMap;
            }
wzp's avatar
wzp committed
72 73 74 75 76
        }else {
            resultMap.put("resultCode", "400");
            resultMap.put("message", "机构名称不能为空!");
            return resultMap;

wzp's avatar
wzp committed
77
        }
78 79
        organ.setCreateTime(DateUtil80.getDateTimeOfTimestamp(System.currentTimeMillis()));
        organ.setUpdateTime(DateUtil80.getDateTimeOfTimestamp(System.currentTimeMillis()));
wzp's avatar
wzp committed
80
        String organCode = getOrganCode(organ.getParentId());
wzp's avatar
wzp committed
81 82
        organ.setLevel(organCode.length() / 3);
        if (organ.getLevel() > 3) {
wzp's avatar
wzp committed
83
            resultMap.put("resultCode", "400");
wzp's avatar
wzp committed
84 85 86
            resultMap.put("message", "不能添加4级机构!");
            return resultMap;
        }
wzp's avatar
wzp committed
87
        organ.setCode(organCode);
88 89 90 91 92 93 94 95 96 97 98 99
        // 保存业务节点信息
        boolean result = tOrganService.save(organ);
        // 返回操作结果
        if (result) {
            return getSuccessResult();
        } else {
            // 保存失败
            return getFailResult();
        }
    }

    @PutMapping("/update")
wzp's avatar
wzp committed
100
    @RequiresAuthentication  //@RequiresPermissions("/organ/update")
101
    @ApiOperation(value = "update", notes = "修改机构信息")
wzp's avatar
wzp committed
102
    @MethodLog(operModule = OperModule.ORG, operType = OperType.UPDATE)
103
    public Map<String, Object> updateTOrgan(TOrgan tOrgan) {
wzp's avatar
wzp committed
104
        try {
wzp's avatar
wzp committed
105 106 107 108 109 110 111
            if (StringUtils.isBlank(tOrgan.getName().trim())) {
                HashMap<String, Object> resultMap = new HashMap<>();
                resultMap.put("resultCode", "400");
                resultMap.put("message", "机构名称不能为空!");
                return resultMap;

            }
wzp's avatar
wzp committed
112
            TOrgan byId = tOrganService.selectById(tOrgan.getId());
wzp's avatar
wzp committed
113 114 115 116
            if (StringUtils.isNotBlank(tOrgan.getParentId())) {
                if (!byId.getParentId().equals(tOrgan.getParentId())) {
                    tOrgan.setCode(getOrganCode(tOrgan.getParentId()));
                }
wzp's avatar
wzp committed
117 118 119
            }
            if (StringUtils.isNotBlank(tOrgan.getCode())) {
                if (byId.getChildren().size() > 0) {
wzp's avatar
wzp committed
120
                    HashMap<String, Object> map = new HashMap<>();
wzp's avatar
wzp committed
121
                    map.put("resultCode", "400");
wzp's avatar
wzp committed
122 123 124 125 126 127 128
                    map.put("message", "机构存在下级机构,不能修改机构级别!");
                    map.put("data", "");
                    return map;
                }
                tOrgan.setLevel(tOrgan.getCode().length() / 3);
                if (tOrgan.getLevel() > 3) {
                    HashMap<String, Object> resultMap = new HashMap<>();
wzp's avatar
wzp committed
129
                    resultMap.put("resultCode", "400");
wzp's avatar
wzp committed
130 131 132
                    resultMap.put("message", "不能修改机构为4级!");
                    return resultMap;
                }
wzp's avatar
wzp committed
133
            }
wzp's avatar
wzp committed
134
            tOrgan.setUpdateTime(DateUtil80.getDateTimeOfTimestamp(System.currentTimeMillis()));
liqin's avatar
liqin committed
135
            boolean flag;
wzp's avatar
wzp committed
136 137 138 139
            flag = tOrganService.updateById(tOrgan);
            if (!flag) {
                return getFailResult();
            }
140
            return getSuccessResult();
wzp's avatar
wzp committed
141 142
        } catch (Exception e) {
            e.printStackTrace();
143
        }
wzp's avatar
wzp committed
144

145 146 147 148
        return getFailResult();
    }

    @DeleteMapping("/delete")
wzp's avatar
wzp committed
149
    @RequiresAuthentication  //@RequiresPermissions("/organ/delete")
150
    @ApiOperation(value = "根据ID删除机构", notes = "根据ID删除机构")
wzp's avatar
wzp committed
151 152 153
    @ApiImplicitParams(value = {
            @ApiImplicitParam(name = "id", value = "标识ID", paramType = "query", dataType = "String")
    })
wzp's avatar
wzp committed
154
    @MethodLog(operModule = OperModule.ORG, operType = OperType.DELETE)
wzp's avatar
wzp committed
155
    public Map<String, Object> deleteTOrgan(String id) {
liqin's avatar
liqin committed
156
        boolean result;
wzp's avatar
wzp committed
157
        try {
wzp's avatar
wzp committed
158 159 160
            TOrgan tOrgan = tOrganService.getById(id);
            tOrgan.setIsDeleted(true);
            tOrgan.setUpdateTime(DateUtil80.getDateTimeOfTimestamp(System.currentTimeMillis()));
wzp's avatar
wzp committed
161
            result = tOrganService.removeById(tOrgan);
wzp's avatar
wzp committed
162 163 164
            if (!result) {
                return getFailResult();
            }
165
            return getSuccessResult();
wzp's avatar
wzp committed
166 167
        } catch (Exception e) {
            e.printStackTrace();
168 169 170 171 172
        }
        return getFailResult();
    }

    @GetMapping("/getList")
wzp's avatar
wzp committed
173
    @RequiresAuthentication  //@RequiresPermissions("/organ/getList")
174
    @ApiOperation(value = "获取机构全部列表(无分页)", notes = "获取机构全部列表(无分页)")
wzp's avatar
wzp committed
175
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
176
    public Map<String, Object> getTOrganList() {
liqin's avatar
liqin committed
177
        TUser user;
178 179
        try {
            user = getcurUser();
wzp's avatar
wzp committed
180
            TOrgan tOrgan = new TOrgan();
liqin's avatar
liqin committed
181
            if (user.getRoleList().size() > 0 && !user.getRoleList().contains("1")) {
wzp's avatar
wzp committed
182 183 184
                //设置用户数据权限
                tOrgan.setCode(user.getOrgCode());
            }
wzp's avatar
wzp committed
185 186
            List<TOrgan> list = tOrganService.getAllList(tOrgan);
            return getResult(list);
187 188 189
        } catch (Exception e) {
            e.printStackTrace();
        }
wzp's avatar
wzp committed
190
        return getFailResult();
191 192 193 194 195 196 197 198 199 200
    }

    @ApiImplicitParams(value = {
            @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"),
            @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer"),
            @ApiImplicitParam(name = "nameOrCode", value = "名称或编码", paramType = "query", dataType = "String"),
            @ApiImplicitParam(name = "startDate", value = "创建时间-开始", paramType = "query", dataType = "String"),
            @ApiImplicitParam(name = "endDate", value = "创建时间-结束", paramType = "query", dataType = "String")
    })
    @PostMapping("/getPageList")
wzp's avatar
wzp committed
201
    @RequiresAuthentication  //@RequiresPermissions("/organ/getPageList")
202
    @ApiOperation(value = "获取机构分页列表", notes = "获取机构分页列表")
wzp's avatar
wzp committed
203
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
204
    public Map<String, Object> getTOrganPageList(GenericPageParam genericPageParam) {
205
        TUser user = getcurUser();
liqin's avatar
liqin committed
206
        Page<TOrgan> page;
wzp's avatar
wzp committed
207 208 209 210 211 212 213 214 215 216 217
        try {
            LambdaQueryWrapper<TOrgan> queryWrapper = new LambdaQueryWrapper<>();
            // 对名称或编码模糊查询
            if (StringUtils.isNotBlank(genericPageParam.getNameOrCode())) {
                queryWrapper.like(TOrgan::getName, genericPageParam.getNameOrCode());
            }
            // 根据创建时间区间检索
            if (genericPageParam.getStartDate() != null && genericPageParam.getEndDate() != null) {
                queryWrapper.ge(TOrgan::getCreateTime, genericPageParam.getStartDate().atTime(0, 0, 0))
                        .le(TOrgan::getCreateTime, genericPageParam.getEndDate().atTime(23, 59, 59));
            }
liqin's avatar
liqin committed
218
            if (user.getRoleList().size() > 0 && !user.getRoleList().contains("1")) {
wzp's avatar
wzp committed
219 220 221
                //设置用户数据权限
                queryWrapper.likeRight(TOrgan::getCode, user.getOrgCode());
            }
wzp's avatar
wzp committed
222
            queryWrapper.eq(TOrgan::getIsDeleted, false);
wzp's avatar
wzp committed
223 224 225 226 227 228
            // 设置排序规则
            queryWrapper.orderByDesc(TOrgan::getCreateTime);
            page = this.tOrganService.page(getPage(), queryWrapper);
            return getResult(page);
        } catch (Exception e) {
            e.printStackTrace();
229
        }
wzp's avatar
wzp committed
230
        return getFailResult();
231 232 233 234
    }

    @ApiOperation(value = "获取机构详情", notes = "获取机构详情")
    @GetMapping("/getById")
wzp's avatar
wzp committed
235
    @RequiresAuthentication  //@RequiresPermissions("/organ/getById")
wzp's avatar
wzp committed
236
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
237
    public Map<String, Object> getById(String id) {
liqin's avatar
liqin committed
238
        TOrgan tOrgan;
wzp's avatar
wzp committed
239 240 241 242 243 244 245
        try {
            tOrgan = tOrganService.selectById(id);
            return getResult(tOrgan);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return getFailResult();
246 247 248
    }


wzp's avatar
wzp committed
249 250 251 252 253
    @GetMapping("/getTree")
    @RequiresAuthentication  //@RequiresPermissions("/organ/getTree")
    @ApiOperation(value = "获取机构树", notes = "获取机构树")
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
    public Map<String, Object> getTree(String name) {
254
        TUser user = getcurUser();
liqin's avatar
liqin committed
255
        List<TOrgan> list;
wzp's avatar
wzp committed
256
        UpdateWrapper<TOrgan> wrapper = new UpdateWrapper<>();
wzp's avatar
wzp committed
257
        try {
liqin's avatar
liqin committed
258
            if (user.getRoleList().size() > 0 && !user.getRoleList().contains("1")) {
wzp's avatar
wzp committed
259 260
                //设置用户数据权限
                wrapper.likeRight("code", user.getOrgCode());
liqin's avatar
liqin committed
261
            } else {
wzp's avatar
wzp committed
262 263
                user.setOrgCode("");
            }
wzp's avatar
wzp committed
264
            if (StringUtils.isBlank(name)) {
wzp's avatar
wzp committed
265
                list = tOrganService.getTree(user.getOrgCode());
wzp's avatar
wzp committed
266
            } else {
wzp's avatar
wzp committed
267 268
                wrapper.like("name", name);
                list = tOrganService.list(wrapper);
wzp's avatar
wzp committed
269 270 271 272
            }
            return getResult(list);
        } catch (Exception e) {
            e.printStackTrace();
273
        }
wzp's avatar
wzp committed
274 275
        return getFailResult();
    }
276

wzp's avatar
wzp committed
277
    @GetMapping("/getAreaTree")
wzp's avatar
wzp committed
278
    @RequiresAuthentication  //@RequiresPermissions("/organ/getAreaTree")
wzp's avatar
wzp committed
279
    @ApiOperation(value = "获取区域树", notes = "获取区域树")
wzp's avatar
wzp committed
280
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
wzp's avatar
wzp committed
281
    public Map<String, Object> getAreaTree() {
liqin's avatar
liqin committed
282
        List<TArea> list;
wzp's avatar
wzp committed
283 284 285 286 287 288 289
        try {
            list = tAreaService.getAreaTree();
            return getResult(list);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return getFailResult();
wzp's avatar
wzp committed
290 291
    }

292 293 294 295

    // 导入EXCEL
    @ApiOperation(value = "导入EXCEL", notes = "导入EXCEL", httpMethod = "POST")
    @RequestMapping(value = "/import", method = RequestMethod.POST)
wzp's avatar
wzp committed
296
    @RequiresAuthentication  //@RequiresPermissions("/organ/import")
wzp's avatar
wzp committed
297
    @MethodLog(operModule = OperModule.ORG, operType = OperType.IMPORT)
wzp's avatar
wzp committed
298
    public Map<String, Object> upload(MultipartFile file) {
liqin's avatar
liqin committed
299
        Map<String, Object> resultMap = new LinkedHashMap<>();
300
        try {
liqin's avatar
liqin committed
301
            boolean flag;
302
            //使用工具类从文件中读取数据
liqin's avatar
liqin committed
303
            final List<Map<String, String>> excelList = ImportExcelUtil.readExcel(file.getOriginalFilename(), file.getInputStream());
304 305
            flag = tOrganService.batchUpload(excelList);
            if (!flag) {
wzp's avatar
wzp committed
306
                resultMap.put("resultCode", "500");
wzp's avatar
wzp committed
307
                resultMap.put("message", "导入失败!");
wzp's avatar
wzp committed
308
                return resultMap;
309
            }
wzp's avatar
wzp committed
310
            resultMap.put("resultCode", "200");
wzp's avatar
wzp committed
311
            resultMap.put("message", "导入成功!");
wzp's avatar
wzp committed
312
            return resultMap;
313
        } catch (Exception e) {
wzp's avatar
wzp committed
314
            resultMap.put("resultCode", "500");
wzp's avatar
wzp committed
315
            resultMap.put("message", e.getMessage());
wzp's avatar
wzp committed
316
            return resultMap;
317 318 319
        }
    }

wzp's avatar
wzp committed
320 321
    private String getOrganCode(String parentId) {
        TOrgan max = tOrganService.selectCodeMax(parentId);
wzp's avatar
wzp committed
322 323 324
        TOrgan byId = tOrganService.getById(parentId);
        if (max == null) {
            if (byId != null) {
liqin's avatar
liqin committed
325 326
                return byId.getCode() + "001";
            } else {
wzp's avatar
wzp committed
327 328
                return "001";
            }
wzp's avatar
wzp committed
329
        }
wzp's avatar
wzp committed
330
        String s = max.getCode().substring(max.getCode().length() - 3);
wzp's avatar
wzp committed
331
        String s1 = max.getCode().substring(0, max.getCode().length() - 3);
liqin's avatar
liqin committed
332
        int integer = Integer.parseInt(s) + 1;
wzp's avatar
wzp committed
333
        if (integer < 10) {
liqin's avatar
liqin committed
334
            s1 = s1 + "00" + integer;
wzp's avatar
wzp committed
335
        } else if (integer < 100) {
liqin's avatar
liqin committed
336
            s1 = s1 + "0" + integer;
wzp's avatar
wzp committed
337
        } else {
liqin's avatar
liqin committed
338
            s1 = s1 + integer;
wzp's avatar
wzp committed
339 340 341 342
        }
        return s1;
    }

343 344
}