|
|
1
2
3
4
|
package com.huaheng.pc.system.systable.controller;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
|
|
|
5
|
import com.huaheng.common.utils.Wrappers;
|
|
|
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
|
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")
|
huhai
authored
|
51
|
@Log(title = "系统-通用-表格", operating = "查看表格", action = BusinessType.GRANT)
|
|
|
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
|
@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")
|
huhai
authored
|
91
|
@Log(title = "系统-通用-表格", operating = "新增表格", action = BusinessType.INSERT)
|
|
|
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
@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")
|
huhai
authored
|
115
|
@Log(title = "系统-通用-表格", operating = "修改表格", action = BusinessType.UPDATE)
|
|
|
116
117
118
119
120
121
122
123
124
125
126
127
|
@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")
|
huhai
authored
|
128
|
@Log(title = "系统-通用-表格", operating = "修改表格", action = BusinessType.DELETE)
|
|
|
129
130
131
132
133
134
135
136
|
@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))));
}
|
|
|
137
138
|
@GetMapping("/init")
|
huhai
authored
|
139
140
|
@Log(title = "系统-通用-表格", operating = "表格初始化", action = BusinessType.DELETE)
@RequiresPermissions("system:table:init")
|
|
|
141
142
143
144
|
@ResponseBody
public AjaxResult init() {
return toAjax(sysTableInfoService.init());
}
|
|
|
145
|
}
|
