package com.lf.server.controller.data; import com.lf.server.aspect.SysLog; import com.lf.server.controller.all.BaseController; import com.lf.server.entity.all.ResponseMsg; import com.lf.server.entity.data.DictEntity; import com.lf.server.entity.sys.UserEntity; import com.lf.server.service.data.DictService; import com.lf.server.service.sys.TokenService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.util.List; /** * 字典管理 * @author SWS + WWW * @date 2022-09.26 */ @Api(tags = "数据管理\\字典管理") @RestController @RequestMapping("/dict") public class DictController extends BaseController { @Autowired DictService dictService; @Autowired TokenService tokenService; @SysLog() @ApiOperation(value = "查询记录数") @ApiImplicitParams({ @ApiImplicitParam(name = "tab", value = "表名", dataType = "String", paramType = "query", required = false, example = "sys_dict") }) @GetMapping({"/selectCount"}) public ResponseMsg selectCount(String tab) { try { int count = dictService.selectCount(tab); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "分页查询") @ApiImplicitParams({ @ApiImplicitParam(name = "tab", value = "表名", dataType = "String", paramType = "query", example = "sys_dict"), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectByPage") public ResponseMsg> selectByPage(String tab, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } List rs = dictService.selectByPage(tab, pageSize, pageSize * (pageIndex - 1)); return success(rs); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "分页查询并返回记录数") @ApiImplicitParams({ @ApiImplicitParam(name = "tab", value = "表名", dataType = "String", paramType = "query", example = "sys_dict"), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectByPageAndCount") public ResponseMsg> selectByPageAndCount(String tab, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } int count = dictService.selectCount(tab); if (count == 0) { return success(0, null); } List rs = dictService.selectByPage(tab, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "插入一条") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "字典实体类", dataType = "com.lf.server.entity.data.DictEntity", paramType = "body", example = "") }) @PostMapping(value = "/insertDict", produces = "application/json; charset=UTF-8") public ResponseMsg insertDict(@RequestBody DictEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { entity.setCreateUser(ue.getId()); } int count = dictService.insertDict(entity); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "插入多条") @ApiImplicitParams({ @ApiImplicitParam(name = "list", value = "实体类集合", dataType = "List", paramType = "body", example = "") }) @PostMapping(value = "/insertDicts", produces = "application/json; charset=UTF-8") public ResponseMsg insertDicts(@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.insertDicts(list); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "删除一条") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "ID", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/deleteDict") public ResponseMsg deleteDict(int id) { try { int count = dictService.deleteDict(id); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "删除多条") @ApiImplicitParams({ @ApiImplicitParam(name = "ids", value = "ID集合", dataType = "List", paramType = "query", example = "1,2") }) @GetMapping(value = "/deleteDicts") public ResponseMsg deleteDicts(@RequestParam List ids) { try { if (ids == null || ids.isEmpty()) { return fail("id数组不能为空", -1); } int count = dictService.deleteDicts(ids); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "更新一条") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "字典集合", dataType = "DictEntity", paramType = "body", example = "") }) @ResponseBody @PostMapping(value = "/updateDict", produces = "application/json; charset=UTF-8") public ResponseMsg updateDict(@RequestBody DictEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); { entity.setUpdateUser(ue.getId()); } int count = dictService.updateDict(entity); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "根据ID查询") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "ID", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectDict") public ResponseMsg selectDict(int id) { try { DictEntity de = dictService.selectDict(id); return success(de); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "查询所有") @GetMapping(value = "/selectDictAll") public ResponseMsg> selectDictAll() { try { List list = dictService.selectDictAll(); return success(list); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "查询字典中的所有表名") @GetMapping(value = "/selectDictTab") public ResponseMsg> selectDictTab() { try { List list = dictService.selectDictTab(); return success(list); } catch (Exception ex) { return fail(ex.getMessage(), null); } } }