package com.iplatform.base.service;

import com.iplatform.model.po.S_dept;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
public class DeptServiceImpl extends BaseServiceImpl {

    private static final String WHERE_QUERY_ROOT_LIST = "where parent_id=0 order by order_num";
    private static final String WHERE_QUERY_ROOT_LIST_BY_ID = "where parent_id=0 and id=? order by order_num";
    private static final String WHERE_QUERY_ROOT_ONE_CHILDREN = "where org_id=:orgId";
    private static final String QUERY_SUB_SIZE_IN_CURRENT = "select count(id) total from s_dept where parent_id=?";
    private static final String QUERY_USER_SIZE_IN_CURRENT = "select count(id) total from s_user_core where dept_id=?";
    private static final String QUERY_DEPT_FOR_CACHE = "select * from s_dept order by parent_id, order_num";
    private static final String QUERY_TREE_ALL = "select * from s_dept where del_flag=0 and status=0 order by parent_id, order_num";
    private static final String QUERY_TREE_ONE = "select * from s_dept where org_id=? and del_flag=0 and status=0 order by parent_id, order_num";

    /**
     * 返回所有根机构列表，也就是第一层独立单位(集团)
     * @param orgRootId 给定的单位ID，如果提供该参数，则表明只返回一条记录
     * @return
     * @date 2022-12-01
     */
    public List<S_dept> queryRootOrgList(long orgRootId){
        if(orgRootId <= 0){
            return this.select(new S_dept(),WHERE_QUERY_ROOT_LIST, new Object[]{});
        } else {
            return this.select(new S_dept(),WHERE_QUERY_ROOT_LIST_BY_ID, new Object[]{orgRootId});
        }
    }

    /**
     * 机构管理显示机构列表，由前端组织树结果。<p></p>
     * 注意: 这个列表包含根机构，也就是一个完整的独立机构列表，如果没有根节点，前端无法选择添加。2022-12-02
     * @param orgRootId 根机构ID，必填
     * @param deptName 查询的机构名称
     * @return
     * @date 2022-12-01
     */
    public List<S_dept> queryRootOrgChildrenList(long orgRootId, String deptName){
        Map<String, Object> parameters = new HashMap<>();
        parameters.put("orgId", orgRootId);
        StringBuilder sql = new StringBuilder(WHERE_QUERY_ROOT_ONE_CHILDREN);
        if(StringUtils.isNotEmpty(deptName)){
            sql.append(" and dept_name like :deptName");
            parameters.put("deptName", "%" + deptName + "%");
        }
        sql.append(" order by parent_id, order_num");
        return this.select(new S_dept(), sql.toString(), parameters);
    }

    public S_dept queryOneDept(long id){
        return this.get(new S_dept(id));
    }

    /**
     * 查询给定单位下存在多少个子机构。
     * @param id 当前机构ID
     * @return 返回子机构数量
     */
    public int querySubDeptSizeInCurrent(long id){
        return this.sqlMathQuery(QUERY_SUB_SIZE_IN_CURRENT, new Object[]{id}, Integer.class);
    }

    /**
     * 查询给定机构下存在多少用户
     * @param id 当前机构ID
     * @return 返回用户数量
     * @date 2022-12-03
     */
    public long queryUserSizeInCurrent(long id){
        return this.sqlMathQuery(QUERY_USER_SIZE_IN_CURRENT, new Object[]{id}, Long.class);
    }

    /**
     * 缓存使用该方法，加载所有机构列表。
     * @return
     * @date 2022-12-03
     */
    public List<S_dept> queryAllDeptListForCache(){
        return this.select(QUERY_DEPT_FOR_CACHE, new Object[]{}, new S_dept());
    }

    /**
     * 获取机构列表，为前端树管理展示用。
     * @param orgId 指定的顶级单位ID，如果没指定则展示所有顶级机构。
     * @return
     * @date 2022-12-08
     */
    public List<S_dept> queryOrgListForTree(long orgId){
        if(orgId <= 0){
            // 不存在指定的单位，就展示全部顶级点位
            return this.select(QUERY_TREE_ALL, new Object[]{}, new S_dept());
        } else {
            // 只显示给定顶级机构下的列表
            return this.select(QUERY_TREE_ONE, new Object[]{orgId}, new S_dept());
        }
    }
}