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;
wzp's avatar
wzp committed
8
import cn.wisenergy.chnmuseum.party.model.TArea;
9
import cn.wisenergy.chnmuseum.party.model.TUser;
wzp's avatar
wzp committed
10
import cn.wisenergy.chnmuseum.party.service.TAreaService;
11
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
wzp's avatar
wzp committed
12
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import cn.wisenergy.chnmuseum.party.web.controller.base.BaseController;
import cn.wisenergy.chnmuseum.party.model.TOrgan;
import cn.wisenergy.chnmuseum.party.service.TOrganService;
import cn.wisenergy.chnmuseum.party.common.enums.AuditStatusEnum;
import cn.wisenergy.chnmuseum.party.common.validator.groups.Add;
import cn.wisenergy.chnmuseum.party.common.validator.groups.Update;
import cn.wisenergy.chnmuseum.party.common.vo.GenericPageParam;

import com.beust.jcommander.Parameter;
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;
import org.apache.commons.lang3.SystemUtils;
import org.apache.ibatis.annotations.Param;
34
import org.apache.shiro.authz.annotation.RequiresAuthentication;
35
import org.apache.shiro.authz.annotation.RequiresPermissions;
36 37
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
38 39 40
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
import org.springframework.stereotype.Controller;
41
import org.springframework.web.multipart.MultipartFile;
42 43 44

import javax.annotation.Resource;
import javax.validation.constraints.NotNull;
45
import java.time.LocalDateTime;
wzp's avatar
wzp committed
46
import java.util.*;
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

/**
 * <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
65 66 67
    @Resource
    private TAreaService tAreaService;

68 69

    @PostMapping("/add")
wzp's avatar
wzp committed
70
    @RequiresAuthentication  //@RequiresPermissions("/organ/add")
71
    @ApiOperation(value = "添加机构", notes = "添加机构")
wzp's avatar
wzp committed
72
    @MethodLog(operModule = OperModule.ORG, operType = OperType.ADD)
73
    public Map<String, Object> add(TOrgan organ) {
wzp's avatar
wzp committed
74 75 76 77 78 79 80

        QueryWrapper<TOrgan> ew = new QueryWrapper<>();
        if (StringUtils.isNoneBlank(organ.getName())) {
            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
81
            if (list != null && list.size() > 0 && list.get(0) != null) {
wzp's avatar
wzp committed
82 83 84 85 86 87
                HashMap<String, Object> resultMap = new HashMap<>();
                resultMap.put("resultCode", "500");
                resultMap.put("message", "机构名称不能重复!");
                return resultMap;
            }
        }
88 89
        organ.setCreateTime(DateUtil80.getDateTimeOfTimestamp(System.currentTimeMillis()));
        organ.setUpdateTime(DateUtil80.getDateTimeOfTimestamp(System.currentTimeMillis()));
wzp's avatar
wzp committed
90
        String organCode = getOrganCode(organ.getParentId());
wzp's avatar
wzp committed
91 92 93 94 95 96 97
        organ.setLevel(organCode.length() / 3);
        if (organ.getLevel() > 3) {
            HashMap<String, Object> resultMap = new HashMap<>();
            resultMap.put("resultCode", "500");
            resultMap.put("message", "不能添加4级机构!");
            return resultMap;
        }
wzp's avatar
wzp committed
98
        organ.setCode(organCode);
99 100 101 102 103 104 105 106 107 108 109 110
        // 保存业务节点信息
        boolean result = tOrganService.save(organ);
        // 返回操作结果
        if (result) {
            return getSuccessResult();
        } else {
            // 保存失败
            return getFailResult();
        }
    }

    @PutMapping("/update")
wzp's avatar
wzp committed
111
    @RequiresAuthentication  //@RequiresPermissions("/organ/update")
112
    @ApiOperation(value = "update", notes = "修改机构信息")
wzp's avatar
wzp committed
113
    @MethodLog(operModule = OperModule.ORG, operType = OperType.UPDATE)
114
    public Map<String, Object> updateTOrgan(TOrgan tOrgan) {
wzp's avatar
wzp committed
115 116 117

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

150 151 152 153 154
        return getFailResult();
    }


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

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

196 197
    }

198

199 200 201 202 203 204 205 206
    @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
207
    @RequiresAuthentication  //@RequiresPermissions("/organ/getPageList")
208
    @ApiOperation(value = "获取机构分页列表", notes = "获取机构分页列表")
wzp's avatar
wzp committed
209
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
210
    public Map<String, Object> getTOrganPageList(GenericPageParam genericPageParam) {
211
        TUser user = getcurUser();
wzp's avatar
wzp committed
212 213 214 215 216 217 218 219 220 221 222 223
        Page<TOrgan> page = null;
        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));
            }
224
            //设置用户数据权限
wzp's avatar
wzp committed
225 226
            queryWrapper.likeRight(TOrgan::getCode, user.getOrgCode());
            queryWrapper.eq(TOrgan::getIsDeleted, false);
wzp's avatar
wzp committed
227 228 229 230 231 232
            // 设置排序规则
            queryWrapper.orderByDesc(TOrgan::getCreateTime);
            page = this.tOrganService.page(getPage(), queryWrapper);
            return getResult(page);
        } catch (Exception e) {
            e.printStackTrace();
233
        }
wzp's avatar
wzp committed
234
        return getFailResult();
235 236 237 238
    }

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


wzp's avatar
wzp committed
253 254 255 256 257
    @GetMapping("/getTree")
    @RequiresAuthentication  //@RequiresPermissions("/organ/getTree")
    @ApiOperation(value = "获取机构树", notes = "获取机构树")
    @MethodLog(operModule = OperModule.ORG, operType = OperType.SELECT)
    public Map<String, Object> getTree(String name) {
258
        TUser user = getcurUser();
259
        List<TOrgan> list = new ArrayList<>();
wzp's avatar
wzp committed
260 261
        try {
            if (StringUtils.isBlank(name)) {
wzp's avatar
wzp committed
262
                list = tOrganService.getTree(user.getOrgCode());
wzp's avatar
wzp committed
263 264
            } else {
                list = tOrganService.list(new UpdateWrapper<TOrgan>().like("name", name).likeRight("code", user.getOrgCode()));
wzp's avatar
wzp committed
265 266 267 268
            }
            return getResult(list);
        } catch (Exception e) {
            e.printStackTrace();
269
        }
wzp's avatar
wzp committed
270 271
        return getFailResult();
    }
272

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

288 289 290 291

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

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

340 341
}