package jnpf.base.controller;
|
|
import cn.dev33.satoken.annotation.SaCheckPermission;
|
import cn.dev33.satoken.annotation.SaMode;
|
import cn.hutool.core.util.ObjectUtil;
|
import com.google.common.base.CaseFormat;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.Parameter;
|
import io.swagger.v3.oas.annotations.Parameters;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import jakarta.validation.Valid;
|
import jnpf.base.ActionResult;
|
import jnpf.base.Pagination;
|
import jnpf.onlinedev.VisualdevOnlineApi;
|
import jnpf.base.entity.ModuleDataAuthorizeLinkEntity;
|
import jnpf.base.entity.ModuleEntity;
|
import jnpf.base.entity.VisualdevEntity;
|
import jnpf.base.model.dbtable.vo.DbFieldVO;
|
import jnpf.base.model.module.PropertyJsonModel;
|
import jnpf.base.model.moduledataauthorize.DataAuthorizeLinkForm;
|
import jnpf.base.model.moduledataauthorize.DataAuthorizeTableNameVO;
|
import jnpf.base.service.DbTableService;
|
import jnpf.base.service.ModuleDataAuthorizeLinkDataService;
|
import jnpf.base.service.ModuleService;
|
import jnpf.base.vo.PaginationVO;
|
import jnpf.constant.MsgCode;
|
import jnpf.database.model.dbfield.DbFieldModel;
|
import jnpf.flowable.TemplateApi;
|
import jnpf.model.visualJson.TableModel;
|
import jnpf.util.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
/**
|
* 数据权限字段管理 数据连接
|
*
|
* @author JNPF开发平台组
|
* @version V3.4.2
|
* @copyright 引迈信息技术有限公司（https://www.jnpfsoft.com）
|
* @date 2022/6/7
|
*/
|
@Tag(name = "数据权限字段管理数据连接" , description = "ModuleDataAuthorizeLink")
|
@RestController
|
@RequestMapping("/ModuleDataAuthorizeLink")
|
public class ModuleDataAuthorizeLinkController {
|
|
@Autowired
|
private ModuleDataAuthorizeLinkDataService linkDataService;
|
@Autowired
|
private ModuleService moduleService;
|
@Autowired
|
private DbTableService dbTableService;
|
@Autowired
|
private VisualdevOnlineApi visualdevApi;
|
@Autowired
|
private TemplateApi templateApi;
|
|
/**
|
* 页面参数
|
*
|
* @param linkForm 页面参数
|
* @return
|
*/
|
@Operation(summary = "保存编辑数据连接")
|
@Parameters({
|
@Parameter(name = "linkForm", description = "页面参数", required = true)
|
})
|
@SaCheckPermission(value = {"permission.resource", "appConfig.appResource"}, mode = SaMode.OR)
|
@PostMapping("/saveLinkData")
|
public ActionResult saveLinkData(@RequestBody @Valid DataAuthorizeLinkForm linkForm) {
|
ModuleDataAuthorizeLinkEntity linkDataEntity = JsonUtil.getJsonToBean(linkForm, ModuleDataAuthorizeLinkEntity.class);
|
if (StringUtil.isEmpty(linkDataEntity.getId())) {
|
linkDataEntity.setId(RandomUtil.uuId());
|
linkDataService.save(linkDataEntity);
|
return ActionResult.success(MsgCode.SU002.get());
|
} else {
|
linkDataService.updateById(linkDataEntity);
|
return ActionResult.success(MsgCode.SU004.get());
|
}
|
}
|
|
/**
|
* 获取表名
|
*
|
* @param menuId 菜单id
|
* @param type 分类
|
* @return
|
*/
|
@Operation(summary = "获取表名")
|
@Parameters({
|
@Parameter(name = "menuId", description = "菜单id", required = true),
|
@Parameter(name = "type", description = "分类", required = true)
|
})
|
@SaCheckPermission(value = {"permission.resource", "appConfig.appResource"}, mode = SaMode.OR)
|
@GetMapping("/getVisualTables/{menuId}/{type}")
|
public ActionResult<DataAuthorizeTableNameVO> getVisualTables(@PathVariable("menuId") String menuId, @PathVariable("type") Integer type) {
|
ModuleEntity info = moduleService.getInfo(menuId);
|
DataAuthorizeTableNameVO vo = null;
|
if (ObjectUtil.isNotNull(info)) {
|
PropertyJsonModel model = JsonUtil.getJsonToBean(info.getPropertyJson(), PropertyJsonModel.class);
|
if (model == null) {
|
model = new PropertyJsonModel();
|
}
|
//功能
|
if (info.getType() == 3 || info.getType() ==9 || info.getType() == 11) {
|
String formId = model.getModuleId();
|
if(info.getType()==9){
|
formId = templateApi.getFormByFlowId(model.getModuleId());
|
}
|
// 得到bean
|
VisualdevEntity visualdevEntity = visualdevApi.getFormConfig(formId);
|
if (visualdevEntity != null) {
|
List<TableModel> tables = JsonUtil.getJsonToList(visualdevEntity.getVisualTables(), TableModel.class);
|
List<String> collect = tables.stream().map(t -> t.getTable()).collect(Collectors.toList());
|
vo = DataAuthorizeTableNameVO.builder().linkTables(collect).linkId(visualdevEntity.getDbLinkId()).build();
|
}
|
} else {
|
ModuleDataAuthorizeLinkEntity linkDataEntity = linkDataService.getLinkDataEntityByMenuId(menuId,type);
|
String linkTables = linkDataEntity.getLinkTables();
|
List<String> tables = StringUtil.isNotEmpty(linkTables) ? Arrays.asList(linkTables.split(",")) : new ArrayList<>();
|
vo = DataAuthorizeTableNameVO.builder().linkTables(tables).linkId(linkDataEntity.getLinkId()).build();
|
}
|
}
|
return ActionResult.success(vo);
|
}
|
|
/**
|
* 数据连接信息
|
*
|
* @param menudId 菜单id
|
* @param type 分类
|
* @return
|
*/
|
@Operation(summary = "数据连接信息")
|
@Parameters({
|
@Parameter(name = "menudId", description = "菜单id", required = true),
|
@Parameter(name = "type", description = "分类", required = true)
|
})
|
@SaCheckPermission(value = {"permission.resource", "appConfig.appResource"}, mode = SaMode.OR)
|
@GetMapping("/getInfo/{menudId}/{type}")
|
public ActionResult getInfo(@PathVariable("menudId") String menudId,@PathVariable("type") Integer type) {
|
ModuleDataAuthorizeLinkEntity linkDataEntity = linkDataService.getLinkDataEntityByMenuId(menudId,type);
|
DataAuthorizeLinkForm linkForm = JsonUtil.getJsonToBean(linkDataEntity, DataAuthorizeLinkForm.class);
|
return ActionResult.success(linkForm);
|
}
|
|
/**
|
* 表名获取数据表字段
|
*
|
* @param linkId 连接id
|
* @param tableName 表名
|
* @param menuType 菜单类型
|
* @param dataType 数据类型
|
* @param pagination 分页模型
|
* @return
|
* @throws Exception
|
*/
|
@Operation(summary = "表名获取数据表字段")
|
@Parameters({
|
@Parameter(name = "linkId", description = "连接id", required = true),
|
@Parameter(name = "tableName", description = "表名", required = true),
|
@Parameter(name = "menuType", description = "菜单类型", required = true),
|
@Parameter(name = "dataType", description = "数据类型", required = true)
|
})
|
@SaCheckPermission(value = {"permission.resource", "appConfig.appResource"}, mode = SaMode.OR)
|
@GetMapping("/{linkId}/Tables/{tableName}/Fields/{menuType}/{dataType}")
|
public ActionResult getTableInfoByTableName(@PathVariable("linkId") String linkId, @PathVariable("tableName") String tableName, @PathVariable("menuType") Integer menuType,@PathVariable("dataType") Integer dataType, Pagination pagination) throws Exception {
|
List<DbFieldModel> data = dbTableService.getFieldList(linkId, tableName);
|
List<DbFieldVO> vos = JsonUtil.getJsonToList(data, DbFieldVO.class);
|
if (StringUtil.isNotEmpty(pagination.getKeyword())) {
|
vos = vos.stream().filter(vo -> {
|
boolean ensure;
|
String fieldName = vo.getFieldName();
|
fieldName = Optional.ofNullable(fieldName).orElse("");
|
ensure = fieldName.toLowerCase().contains(pagination.getKeyword().toLowerCase()) || vo.getField().toLowerCase().contains(pagination.getKeyword().toLowerCase());
|
return ensure;
|
}).collect(Collectors.toList());
|
}
|
List listPage = PageUtil.getListPage((int) pagination.getCurrentPage(), (int) pagination.getPageSize(), vos);
|
PaginationVO paginationVO = JsonUtil.getJsonToBean(pagination, PaginationVO.class);
|
paginationVO.setTotal(vos.size());
|
return ActionResult.page(listPage,paginationVO);
|
}
|
}
|
