package com.product.saas.service;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.spring.context.SpringMVCContextHolder;
|
import com.product.module.sys.entity.SystemUser;
|
import com.product.util.BaseUtil;
|
|
/**
|
* 租户信息
|
*
|
*/
|
@Service
|
public class SaasClientService extends AbstractBaseService{
|
|
@Autowired
|
BaseDao baseDao;
|
|
/**
|
* 租户列表
|
* @param fse
|
* @return
|
*/
|
public DataTableEntity listClient(FieldSetEntity fse) {
|
SystemUser user = SpringMVCContextHolder.getCurrentUser();
|
if (user == null) {
|
return null;
|
}
|
List<Object> param = new ArrayList<>();;
|
StringBuilder sql = new StringBuilder();
|
sql.append("\n SELECT");
|
sql.append("\n A.uuid,A.client_name,A.client_unit_type,A.platform_admin,A.expiration_date,B.apply_status,");
|
sql.append("\n E.user_name AS client_admin,E.user_mobile_number AS client_admin_phone,E.user_primary_email AS client_admin_email ");
|
sql.append("\n FROM product_sys_clients A");
|
sql.append("\n LEFT JOIN product_sys_tenant_apply B ON B.client_uuid = A.uuid ");
|
sql.append("\n LEFT JOIN product_sys_org_levels C ON C.client_uuid = A.uuid AND C.org_level_type = 0 ");
|
sql.append("\n LEFT JOIN product_sys_org_manager D ON D.org_level_uuid = C.uuid ");
|
sql.append("\n LEFT JOIN product_sys_users E ON E.user_id = D.user_id ");
|
sql.append("\n WHERE A.uuid != '00000000-0000-0000-0000-000000000000' ");
|
FieldSetEntity fsePost = user.getJobPost();
|
if(fsePost.getString("job_post_name").contains("平台管理员")) {
|
param.add(user.getUser_id());
|
sql.append("\n AND A.platform_admin = ?");
|
}
|
DataTableEntity dte = baseDao.listTable(sql.toString(), param.toArray(), fse.getInteger("pagesize"), fse.getInteger("cpage"));
|
if (!BaseUtil.dataTableIsEmpty(dte)) {
|
baseDao.loadPromptData(dte);
|
}
|
return dte;
|
}
|
|
/**
|
* 租户详情
|
* @param uuid
|
* @return
|
*/
|
public FieldSetEntity findClient(String uuid) {
|
StringBuilder sql = new StringBuilder();
|
sql.append("\n SELECT A.*,B.legal_person,B.credit_code,B.business_license,E.user_name,E.user_mobile_number,E.user_primary_email ");
|
sql.append("\n FROM product_sys_clients A ");
|
sql.append("\n LEFT JOIN product_sys_tenant_apply B ON B.client_uuid = A.uuid ");
|
sql.append("\n LEFT JOIN product_sys_org_levels C ON C.client_uuid = A.uuid AND C.org_level_type = 0 ");
|
sql.append("\n LEFT JOIN product_sys_org_manager D ON D.org_level_uuid = C.uuid ");
|
sql.append("\n LEFT JOIN product_sys_users E ON E.user_id = D.user_id ");
|
sql.append("\n WHERE A.uuid = ? ");
|
return baseDao.getFieldSetEntityBySQL(sql.toString(), new Object[] {uuid}, false);
|
}
|
}
|
