SysTableInfoController.java
5.46 KB
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
package com.huaheng.pc.system.systable.controller;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.huaheng.common.utils.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.huaheng.common.support.Convert;
import com.huaheng.common.utils.StringUtils;
import com.huaheng.common.utils.security.ShiroUtils;
import com.huaheng.framework.aspectj.lang.annotation.Log;
import com.huaheng.framework.aspectj.lang.constant.BusinessType;
import com.huaheng.framework.web.controller.BaseController;
import com.huaheng.framework.web.domain.AjaxResult;
import com.huaheng.framework.web.page.PageDomain;
import com.huaheng.framework.web.page.TableDataInfo;
import com.huaheng.framework.web.page.TableSupport;
import com.huaheng.pc.system.systable.domain.SysTableInfo;
import com.huaheng.pc.system.systable.service.SysTableInfoService;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
/**
* Created by Enzo Cotter on 2020/3/20.
*/
@Controller
@RequestMapping("/system/tableInfo")
public class SysTableInfoController extends BaseController {
@Resource
private SysTableInfoService sysTableInfoService;
private String prefix = "/system/table";
@RequiresPermissions("system:table:view")
@GetMapping()
public String sysTableInfo() {
return prefix + "/table";
}
/**
* 查询表格列表
*/
@RequiresPermissions("system:table:list")
@Log(title = "系统-通用-表格", operating = "查看表格", action = BusinessType.GRANT)
@PostMapping("/list")
@ResponseBody
public TableDataInfo list(SysTableInfo sysTableInfo, String createdBegin, String createdEnd) {
LambdaQueryWrapper<SysTableInfo> lambdaQueryWrapper = Wrappers.lambdaQuery();
PageDomain pageDomain = TableSupport.buildPageRequest();
Integer pageNum = pageDomain.getPageNum();
Integer pageSize = pageDomain.getPageSize();
lambdaQueryWrapper.ge(StringUtils.isNotEmpty(createdBegin), SysTableInfo::getCreated, createdBegin)
.le(StringUtils.isNotEmpty(createdEnd), SysTableInfo::getCreated, createdEnd)
.like(StringUtils.isNotEmpty(sysTableInfo.getTableCode()), SysTableInfo::getTableCode, sysTableInfo.getTableCode())
.like(StringUtils.isNotEmpty(sysTableInfo.getTableName()), SysTableInfo::getTableName, sysTableInfo.getTableName())
.eq(StringUtils.isNotEmpty(sysTableInfo.getWarehouseCode()), SysTableInfo::getWarehouseCode, sysTableInfo.getWarehouseCode());
if (StringUtils.isNotNull(pageNum) && StringUtils.isNotNull(pageSize)) {
/**
* 使用分页查询
*/
Page<SysTableInfo> page = new Page<>(pageNum, pageSize);
IPage<SysTableInfo> iPage = sysTableInfoService.page(page, lambdaQueryWrapper);
return getMpDataTable(iPage.getRecords(), iPage.getTotal());
} else {
List<SysTableInfo> list = sysTableInfoService.list(lambdaQueryWrapper);
return getDataTable(list);
}
}
/**
* 新增表格
*/
@GetMapping("/add")
public String add() {
return prefix + "/add";
}
/**
* 新增保存表格
*/
@RequiresPermissions("system:table:add")
@Log(title = "系统-通用-表格", operating = "新增表格", action = BusinessType.INSERT)
@PostMapping("/add")
@ResponseBody
public AjaxResult addSave(SysTableInfo sysTableInfo) {
sysTableInfo.setCreated(new Date());
sysTableInfo.setCreatedBy(ShiroUtils.getLoginName());
sysTableInfo.setLastUpdated(new Date());
sysTableInfo.setLastUpdateBy(ShiroUtils.getLoginName());
return toAjax(sysTableInfoService.save(sysTableInfo));
}
/**
* 修改表格
*/
@GetMapping("/edit/{id}")
public String edit(@PathVariable("id") Integer id, ModelMap mmap) {
mmap.put("sysTableInfo", sysTableInfoService.getById(id));
return prefix + "/edit";
}
/**
* 修改保存表格
*/
@RequiresPermissions("system:table:edit")
@Log(title = "系统-通用-表格", operating = "修改表格", action = BusinessType.UPDATE)
@PostMapping("/edit")
@ResponseBody
public AjaxResult editSave(SysTableInfo sysTableInfo) {
sysTableInfo.setLastUpdated(new Date());
sysTableInfo.setLastUpdateBy(ShiroUtils.getLoginName());
return toAjax(sysTableInfoService.saveOrUpdate(sysTableInfo));
}
/**
* 删除表格
*/
@RequiresPermissions("system:table:remove")
@Log(title = "系统-通用-表格", operating = "修改表格", action = BusinessType.DELETE)
@PostMapping("/remove")
@ResponseBody
public AjaxResult remove(String ids) {
if (StringUtils.isEmpty(ids)) {
return AjaxResult.error("id不能为空");
}
return toAjax(sysTableInfoService.removeByIds(Arrays.asList(Convert.toIntArray(ids))));
}
@GetMapping("/init")
@Log(title = "系统-通用-表格", operating = "表格初始化", action = BusinessType.DELETE)
@RequiresPermissions("system:table:init")
@ResponseBody
public AjaxResult init() {
return toAjax(sysTableInfoService.init());
}
}