package com.terra.system.controller.data; import com.terra.common.annotation.SysLog; import com.terra.common.controller.all.BaseController; import com.terra.common.entity.all.ResponseMsg; import com.terra.system.entity.ctrl.TabEntity; import com.terra.system.entity.data.DictEntity; import com.terra.system.entity.sys.UserEntity; import com.terra.system.service.data.DictService; import com.terra.system.service.sys.TokenService; import io.swagger.v3.oas.annotations.Operation; import io.swagger.v3.oas.annotations.Parameter; import io.swagger.v3.oas.annotations.Parameters; import javax.annotation.Resource; import io.swagger.v3.oas.annotations.enums.ParameterIn; import io.swagger.v3.oas.annotations.tags.Tag; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.util.List; /** * 字典管理 * @author WWW */ @Tag(name = "数据管理\\字典管理") @RestController @RequestMapping("/dict") public class DictController extends BaseController { @Resource DictService dictService; @Resource TokenService tokenService; @SysLog() @Operation(summary = "查询记录数") @Parameters({ @Parameter(name = "ns", description = "表空间", in = ParameterIn.QUERY, required = false, example = "bd"), @Parameter(name = "tab", description = "表名", in = ParameterIn.QUERY, example = "dlg_25w_hyda") }) @GetMapping({"/selectCount"}) public ResponseMsg selectCount(String ns, String tab) { try { int count = dictService.selectCount(ns, tab); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @Operation(summary = "分页查询") @Parameters({ @Parameter(name = "ns", description = "表空间", in = ParameterIn.QUERY, example = "bd"), @Parameter(name = "tab", description = "表名", in = ParameterIn.QUERY, example = "dlg_25w_hyda"), @Parameter(name = "pageSize", description = "每页条数", in = ParameterIn.QUERY, example = "10"), @Parameter(name = "pageIndex", description = "分页数(从1开始)", in = ParameterIn.QUERY, example = "1") }) @GetMapping(value = "/selectByPage") public ResponseMsg> selectByPage(String ns, String tab, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } List rs = dictService.selectByPage(ns, tab, pageSize, pageSize * (pageIndex - 1)); return success(rs); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @Operation(summary = "分页查询并返回记录数") @Parameters({ @Parameter(name = "ns", description = "表空间", in = ParameterIn.QUERY, example = "bd"), @Parameter(name = "tab", description = "表名", in = ParameterIn.QUERY, example = "dlg_25w_hyda"), @Parameter(name = "pageSize", description = "每页条数", in = ParameterIn.QUERY, example = "10"), @Parameter(name = "pageIndex", description = "分页数(从1开始)", in = ParameterIn.QUERY, example = "1") }) @GetMapping(value = "/selectByPageAndCount") public ResponseMsg> selectByPageAndCount(String ns, String tab, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } int count = dictService.selectCount(ns, tab); if (count == 0) { return success(0, null); } List rs = dictService.selectByPage(ns, tab, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @Operation(summary = "根据ID查询") @Parameters({ @Parameter(name = "id", description = "ID", in = ParameterIn.QUERY, example = "1") }) @GetMapping(value = "/selectById") public ResponseMsg selectById(int id) { try { DictEntity entity = dictService.selectById(id); return success(entity); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @Operation(summary = "查询字典表结构") @Parameters({ @Parameter(name = "name", description = "名称", in = ParameterIn.QUERY, example = "点"), @Parameter(name = "hasGeom", description = "含有Geom字段", in = ParameterIn.QUERY, example = "false") }) @GetMapping(value = "/selectDictTab") public ResponseMsg> selectDictTab(String name, Boolean hasGeom) { try { List list = dictService.selectDictTab(name, null == hasGeom || !hasGeom ? "gid" : "geom"); return success(list); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @Operation(summary = "插入一条") @Parameters({ @Parameter(name = "entity", description = "实体类") }) @PostMapping(value = "/insert", produces = "application/json; charset=UTF-8") public ResponseMsg insert(@RequestBody DictEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { entity.setCreateUser(ue.getId()); } int count = dictService.insert(entity); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @Operation(summary = "插入多条") @Parameters({ @Parameter(name = "list", description = "实体类集合") }) @PostMapping(value = "/inserts", produces = "application/json; charset=UTF-8") public ResponseMsg inserts(@RequestBody List list, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { for (DictEntity entity : list) { entity.setCreateUser(ue.getId()); } } int count = dictService.inserts(list); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @Operation(summary = "删除一条") @Parameters({ @Parameter(name = "id", description = "ID", in = ParameterIn.QUERY, example = "1") }) @GetMapping(value = "/delete") public ResponseMsg delete(int id) { try { int count = dictService.delete(id); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @Operation(summary = "删除多条") @Parameters({ @Parameter(name = "ids", description = "ID数组", in = ParameterIn.QUERY, example = "1,2") }) @GetMapping(value = "/deletes") public ResponseMsg deletes(@RequestParam List ids) { try { if (ids == null || ids.isEmpty()) { return fail("id数组不能为空", -1); } int count = dictService.deletes(ids); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @Operation(summary = "更新一条") @Parameters({ @Parameter(name = "entity", description = "实体类") }) @ResponseBody @PostMapping(value = "/update", produces = "application/json; charset=UTF-8") public ResponseMsg update(@RequestBody DictEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { entity.setUpdateUser(ue.getId()); } int count = dictService.update(entity); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @Operation(summary = "更新多条") @Parameters({ @Parameter(name = "list", description = "实体类集合") }) @ResponseBody @PostMapping(value = "/updates", produces = "application/json; charset=UTF-8") public ResponseMsg updates(@RequestBody List list, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { for (DictEntity entity : list) { entity.setUpdateUser(ue.getId()); } } int count = dictService.updates(list); return success(count); } catch (Exception ex) { return fail(ex, -1); } } }