package com.product.admin.service;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.google.common.collect.Sets;
|
import com.product.admin.config.CmnConst;
|
import com.product.admin.config.SystemCode;
|
import com.product.common.lang.StringUtils;
|
import com.product.core.cache.DataPoolCacheImpl;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.exception.BaseException;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.service.support.QueryFilterService;
|
import com.product.core.spring.context.SpringMVCContextHolder;
|
import com.product.module.sys.entity.SystemUser;
|
import com.product.util.BaseUtil;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import java.util.*;
|
|
/**
|
* Copyright LX-BASE
|
*
|
* @Title: PagesService
|
* @Project: LX-BASE-SERVER
|
* @Date: 2021-03-16 09:36
|
* @Author: ZhouJie
|
* @Description: 栏目配置
|
*/
|
@Component
|
public class PagesService extends AbstractBaseService {
|
|
@Autowired
|
public BaseDao baseDao;
|
|
@Autowired
|
private QueryFilterService queryFilterService;
|
|
/**
|
* 获取所有公司的公司角色树 只适用于超级管理员
|
*
|
* @return
|
*/
|
public Object getCompanyRoleTree() {
|
SystemUser user = SpringMVCContextHolder.getCurrentUser();
|
if (user != null && 1 == user.getUserType()) {
|
//查出所有公司的角色
|
StringBuilder sql = new StringBuilder();
|
sql.append(" SELECT ");
|
sql.append(" a.*, ");
|
sql.append(" a.uuid org_level_code_parent ");
|
sql.append(" FROM ");
|
sql.append(" ( ");
|
sql.append(" SELECT ");
|
sql.append(" ( SELECT org_level_code FROM product_sys_org_levels WHERE uuid = a.org_level_uuid ) uuid, ");
|
sql.append(" uuid role_uuid, ");
|
sql.append(" role_name, ");
|
sql.append(" 1 type,( ");
|
sql.append(" SELECT ");
|
sql.append(" uuid()) org_level_code ");
|
sql.append(" FROM ");
|
sql.append(" product_sys_role a ");
|
sql.append(" WHERE ");
|
sql.append(" is_used = 1 ");
|
sql.append(" AND org_level_uuid !=? ");
|
sql.append(" AND length( org_level_uuid )> 0 ");
|
sql.append(" ORDER BY org_level_uuid,sequence ");
|
sql.append(" ) a ");
|
DataTableEntity dt = baseDao.listTable(sql.toString(), new Object[]{CmnConst.PRODUCT_SYS_ORG_CLIENT_UUID_VALUE});
|
if (!BaseUtil.dataTableIsEmpty(dt)) {
|
DataPoolCacheImpl dataPoolCache = DataPoolCacheImpl.getInstance();
|
Map<Object, List<FieldSetEntity>> fieldSets = dt.getFieldSets();
|
Set<Object> companyCodes = fieldSets.keySet();
|
Set<String> paramCode = Sets.newHashSet();
|
companyCodes.forEach(org_level_code -> {
|
String code = String.valueOf(org_level_code);
|
paramCode.add(code);
|
while (code.indexOf('-') > -1) {
|
paramCode.add(code = code.substring(0, code.lastIndexOf('-')));
|
}
|
});
|
paramCode.forEach(code -> {
|
DataTableEntity companyDt = dataPoolCache.getCacheData("所有公司信息", new String[]{code});
|
dt.getData().addAll(companyDt.clones().getData());
|
});
|
dt.setData(dt.getData());
|
//根据编码长度排序
|
dt.getData().sort((a, b) -> {
|
return a.getString(CmnConst.ORG_LEVEL_CODE).compareTo(b.getString(CmnConst.ORG_LEVEL_CODE));
|
});
|
return BaseUtil.dataTableToTreeData(dt, CmnConst.ORG_LEVEL_CODE, CmnConst.ORG_LEVEL_CODE_PARENT, object -> {
|
JSONObject jsonObject = object[0];
|
if (jsonObject.getString("type") != null) {
|
jsonObject.put(CmnConst.UUID, jsonObject.getString(CmnConst.ROLE_UUID));
|
}
|
}, false);
|
}
|
}
|
return null;
|
}
|
|
/**
|
* @Date: 2020-03-22 10:03
|
* @Author: ZhouJie
|
* @Description: 查询栏目类型列表
|
*/
|
public DataTableEntity getPageListPagetype(FieldSetEntity fs) throws BaseException {
|
StringBuilder sql = new StringBuilder();
|
sql.append(" select page_type FROM product_sys_portal_column_config group by page_type ");
|
DataTableEntity dt = baseDao.listTable(sql.toString(), new Object[]{});
|
return dt;
|
}
|
|
/**
|
* @Date: 2020-03-19 17:03
|
* @Author: ZhouJie
|
* @Description: 按照栏目类型查询栏目配置列表
|
*/
|
public DataTableEntity getPageListByPagetype(FieldSetEntity fs) throws BaseException {
|
String columnType = fs.getString(CmnConst.COLUMN_TYPE);
|
StringBuilder filter = new StringBuilder(32);
|
if (!StringUtils.isEmpty(columnType)) {
|
for (String singleColumnType : columnType.split(",")) {
|
if (filter.length() > 0) {
|
filter.append(" or ");
|
}
|
if (filter.length() == 0) {
|
filter.append("(");
|
}
|
filter.append("find_in_set('").append(singleColumnType).append("',column_type)");
|
}
|
}
|
if (filter.length() > 0) {
|
filter.append(") and ");
|
}
|
filter.append("is_use=1");
|
DataTableEntity dt = baseDao.listTable(CmnConst.PRODUCT_SYS_PORTAL_COLUMN_CONFIG, filter.toString(), null, null, null, Integer.MAX_VALUE, 0);
|
return dt;
|
}
|
|
/**
|
* @Date: 2020-03-18 09:58
|
* @Author: ZhouJie
|
* @Description: 栏目配置列表查询
|
*/
|
public DataTableEntity getPageList(FieldSetEntity fs) throws BaseException {
|
String queryFilter = queryFilterService.getQueryFilter(fs);
|
DataTableEntity dt = baseDao.listTable(CmnConst.PRODUCT_SYS_PORTAL_COLUMN_CONFIG, queryFilter, null, null, null, fs.getInteger(CmnConst.PAGESIZE), fs.getInteger(CmnConst.CPAGE));
|
baseDao.loadPromptData(dt);
|
return dt;
|
}
|
|
/**
|
* @Date: 2020-03-18 10:44
|
* @Author: ZhouJie
|
* @Description: 栏目配置详情查询
|
*/
|
public FieldSetEntity getPageInfo(FieldSetEntity fs) throws BaseException {
|
FieldSetEntity fss = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_PORTAL_COLUMN_CONFIG, fs.getUUID(), false);
|
FieldSetEntity fsrc = null;
|
FieldSetEntity fsmp = null;
|
if (fss.getInteger("page_type") == 1) {
|
fsrc = baseDao.getFieldSetEntityByFilter("product_sys_report_config", CmnConst.UUID + "=?", new Object[]{fss.getString("data_source")}, false);
|
}
|
if (fss.getInteger("page_type") == 2) {
|
fsrc = baseDao.getFieldSetEntityByFilter("product_sys_report_config", CmnConst.UUID + "=?", new Object[]{fss.getString("data_source")}, false);
|
}
|
if (fsrc != null) {
|
fsmp = baseDao.getFieldSetEntityByFilter("product_sys_mvc_page", "function_uuid = ?", new Object[]{fsrc.getString("function_uuid")}, false);
|
if (fsmp != null) {
|
fss.setValue("link_address", fsmp.getString("page_url"));
|
}
|
}
|
return fss;
|
//return baseDao.listInternationDataTable(baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_PORTAL_COLUMN_CONFIG, fs.getString(CmnConst.UUID), true),null);
|
}
|
|
/**
|
* @Date: 2020-03-16 14:59
|
* @Author: ZhouJie
|
* @Description: 新增栏目配置
|
*/
|
public String addPage(FieldSetEntity fs) throws BaseException {
|
//判断标题名称是否为空，为空则默认栏目名称
|
if (StringUtils.isEmpty(fs.getString("title_name"))) {
|
fs.setValue("title_name", fs.getString("page_name"));
|
}
|
//fs.setValue(CmnConst.CREATED_BY, SpringMVCContextHolder.getCurrentUser().getUser_id());
|
fs.setValue(CmnConst.CREATED_BY, 1);
|
fs.setValue(CmnConst.CREATED_UTC_DATETIME, new Date());
|
return baseDao.add(fs);
|
}
|
|
/**
|
* @Date: 2020-03-16 15:44
|
* @Author: ZhouJie
|
* @Description: 修改栏目配置
|
*/
|
public boolean updatePage(FieldSetEntity fs) throws BaseException {
|
//判断标题名称是否为空，为空则默认栏目名称
|
if (StringUtils.isEmpty(fs.getString("title_name"))) {
|
fs.setValue("title_name", fs.getString("page_name"));
|
}
|
//fs.setValue(CmnConst.UPDATED_BY, SpringMVCContextHolder.getCurrentUser().getUser_id());
|
fs.setValue(CmnConst.UPDATED_BY, 1);
|
fs.setValue(CmnConst.UPDATED_UTC_DATETIME, new Date());
|
return baseDao.update(fs);
|
}
|
|
/**
|
* @Date: 2020-03-16 16:30
|
* @Author: ZhouJie
|
* @Description: 删除栏目配置
|
*/
|
public boolean deletePage(FieldSetEntity fs) throws BaseException {
|
String sql="select 1 FROM product_sys_portals_sub where page_uuid=? limit 1";
|
FieldSetEntity fseprotal=baseDao.getFieldSetBySQL(sql, new Object[] {fs.getUUID()}, false);
|
if (fseprotal!=null) {
|
throw new BaseException(SystemCode.PAGES_HAS_REFERED.getValue(), SystemCode.PAGES_HAS_REFERED.getText());
|
}
|
return baseDao.delete(CmnConst.PRODUCT_SYS_PORTAL_COLUMN_CONFIG, fs.getUUID().split(","));
|
}
|
}
|
