SysTableFieldInfoController.java
5.86 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
146
147
package com.huaheng.pc.system.systable.controller;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.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.SysTableFieldInfo;
import com.huaheng.pc.system.systable.service.SysTableFieldInfoService;
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/tableFieldInfo")
public class SysTableFieldInfoController extends BaseController {
@Resource
private SysTableFieldInfoService tableFieldInfoService;
private String prefix = "/system/table";
@RequiresPermissions("system:table:view")
@GetMapping()
public String sysTableFieldInfo() {
return prefix + "/table";
}
/**
* 查询表格字段列表
*/
@RequiresPermissions("system:table:list")
@Log(title = "系统-表格字段", operating = "查看表格字段", action = BusinessType.GRANT)
@PostMapping("/list")
@ResponseBody
public TableDataInfo list(SysTableFieldInfo sysTableFieldInfo, String createdBegin, String createdEnd) {
LambdaQueryWrapper<SysTableFieldInfo> lambdaQueryWrapper = Wrappers.lambdaQuery();
PageDomain pageDomain = TableSupport.buildPageRequest();
Integer pageNum = pageDomain.getPageNum();
Integer pageSize = pageDomain.getPageSize();
lambdaQueryWrapper.ge(StringUtils.isNotEmpty(createdBegin), SysTableFieldInfo::getCreated, createdBegin)
.le(StringUtils.isNotEmpty(createdEnd), SysTableFieldInfo::getCreated, createdEnd)
.eq(StringUtils.isNotNull(sysTableFieldInfo.getHeadId()), SysTableFieldInfo::getHeadId, sysTableFieldInfo.getHeadId())
.like(StringUtils.isNotEmpty(sysTableFieldInfo.getFieldCode()), SysTableFieldInfo::getFieldCode, sysTableFieldInfo.getFieldCode())
.eq(StringUtils.isNotEmpty(sysTableFieldInfo.getFiledName()), SysTableFieldInfo::getFiledName, sysTableFieldInfo.getFiledName())
.eq(StringUtils.isNotEmpty(sysTableFieldInfo.getFiledFuncation()),SysTableFieldInfo::getFiledFuncation, sysTableFieldInfo.getFiledFuncation());
TableDataInfo rspData = new TableDataInfo();
rspData.setCode(0);
if (StringUtils.isNotNull(pageNum) && StringUtils.isNotNull(pageSize)) {
/**
* 使用分页查询
*/
Page<SysTableFieldInfo> page = new Page<>(pageNum, pageSize);
IPage<SysTableFieldInfo> iPage = tableFieldInfoService.page(page, lambdaQueryWrapper);
rspData.setData(iPage.getRecords());
rspData.setTotal(iPage.getTotal());
return rspData;
} else {
List<SysTableFieldInfo> list = tableFieldInfoService.list(lambdaQueryWrapper);
rspData.setData(list);
rspData.setTotal(list.size());
return rspData;
}
}
/**
* 新增表格字段
*/
@GetMapping("/add/{id}")
public String add(@PathVariable("id") Long id, ModelMap map) {
map.put("headId", id);
return prefix + "/addDetails";
}
/**
* 新增保存表格字段
*/
@RequiresPermissions("system:table:add")
@Log(title = "系统-表格字段", operating = "表格字段", action = BusinessType.INSERT)
@PostMapping("/add")
@ResponseBody
public AjaxResult addSave(SysTableFieldInfo sysTableFieldInfo) {
sysTableFieldInfo.setCreated(new Date());
sysTableFieldInfo.setCreatedBy(ShiroUtils.getLoginName());
sysTableFieldInfo.setLastUpdated(new Date());
sysTableFieldInfo.setLastUpdateBy(ShiroUtils.getLoginName());
return toAjax(tableFieldInfoService.save(sysTableFieldInfo));
}
/**
* 修改表格字段
*/
@GetMapping("/edit/{id}")
public String edit(@PathVariable("id") Integer id, ModelMap mmap) {
mmap.put("tableFieldInfo", tableFieldInfoService.getById(id));
return prefix + "/editDetails";
}
/**
* 修改保存表格字段
*/
@RequiresPermissions("system:table:edit")
@Log(title = "系统-表格字段", operating = "修改表格字段", action = BusinessType.UPDATE)
@PostMapping("/edit")
@ResponseBody
public AjaxResult editSave(SysTableFieldInfo sysTableFieldInfo) {
sysTableFieldInfo.setLastUpdated(new Date());
sysTableFieldInfo.setLastUpdateBy(ShiroUtils.getLoginName());
return toAjax(tableFieldInfoService.saveOrUpdate(sysTableFieldInfo));
}
/**
* 删除表格字段
*/
@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(tableFieldInfoService.removeByIds(Arrays.asList(Convert.toIntArray(ids))));
}
}