package com.iplatform.base.service;

import com.iplatform.model.po.S_dept;
import com.iplatform.model.po.S_dict_data;
import com.iplatform.model.po.S_dict_type;
import com.walker.db.page.GenericPager;
import com.walker.db.page.ListPageContext;
import com.walker.db.page.PageSearch;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;

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

/**
 * 数据字典表操作。
 * @date 2022-09-19
 */
@Service
public class CodeServiceImpl extends BaseServiceImpl {

    private static final String SQL_PAGE_TYPE_PREFIX = "select * from s_dict_type where 1=1";
    private static final String SQL_PAGE_DATA_PREFIX = "select * from s_dict_data where 1=1";

    private static final String SQL_QUERY_EXIST_DATA = "select * from s_dict_data where dict_type=? and dict_value=?";

    public void execDeleteDictData(Long[] dictCodes){
        if(dictCodes == null || dictCodes.length == 0){
            return;
        }
        List<Object[]> parameters = new ArrayList<>(8);
        for(long dictCode : dictCodes){
            Object[] p = new Object[]{dictCode};
            parameters.add(p);
        }
        this.execBatchUpdate("delete from s_dict_data where dict_code=?", parameters);
    }

    private static final String SQL_DICT_TREE_LIST = "select * from s_dict_data where dict_type=? order by parent_id, dict_sort";

    /**
     * 返回代码树结构，需要的列表集合。<p></p>
     * 为前端展示树结构准备数据，集合已经按照父节点顺序排好顺序。
     * @param dictType 代码类型，如：question_root_catalog
     * @return
     * @date 2023-03-13
     */
    public List queryDictTreeList(String dictType){
        return this.select(SQL_DICT_TREE_LIST, new Object[]{dictType}, new S_dict_data());
    }

    /**
     * 返回所有代码项集合。<p></p>
     * 方法用在代码缓存功能。
     * @return
     * @date 2023-03-10
     */
    public List<S_dict_data> queryAllCodeItemList(){
        return this.select("select * from s_dict_data order by dict_sort", new Object[]{}, new S_dict_data());
    }

    /**
     * 返回数据字典所有根集合，即：字典表集合。<p></p>
     * 该方法缓存使用。
     * @return
     * @date 2023-03-10
     */
    public List<S_dict_type> queryRootCodeList(){
        return this.selectAll(new S_dict_type());
    }

    public S_dict_data queryOneDictData(long dictCode){
        return this.get(new S_dict_data(dictCode));
    }

    /**
     * 字典表中是否存在给定值一样的字典项。并返回字典项。
     * @param dictType
     * @param value
     * @return
     * @date 2022-11-20
     */
    public S_dict_data queryOneDictData(String dictType, String value){
        return this.get(SQL_QUERY_EXIST_DATA, new Object[]{dictType, value}, new S_dict_data());
    }

    /**
     * 获取一个字典类型详情。
     * @param dictId 字典id
     * @return
     * @date 2022-11-19
     */
    public S_dict_type queryOneDictType(long dictId){
        return this.get("select * from s_dict_type where dict_id=?", new Object[]{dictId}, new S_dict_type());
    }

    /**
     * 分页返回字典类型(代码表)列表
     * @param dictName
     * @param dictType
     * @param status
     * @param startTime
     * @param endTime
     * @return
     * @date 2022-11-16
     */
    public GenericPager<S_dict_type> queryPageDictType(String dictName, String dictType, int status, long startTime, long endTime){
        Map<String, Object> parameters = new HashMap<>();
        StringBuilder sql = new StringBuilder(SQL_PAGE_TYPE_PREFIX);

        if(StringUtils.isNotEmpty(dictName)){
            sql.append(" and dict_name like :dictName");
            parameters.put("dictName", "%" + dictName + "%");
        }
        if(StringUtils.isNotEmpty(dictType)){
            sql.append(" and dict_type = :dictType");
            parameters.put("dictType", dictType);
        }
        if(status >= 0){
            sql.append(" and status = :status");
            parameters.put("status", status);
        }
        if(startTime > 0){
            sql.append(" and create_time >= :startTime");
            parameters.put("startTime", startTime);
        }
        if(endTime > 0){
            sql.append(" and create_time <= :endTime");
            parameters.put("endTime", endTime);
        }

        PageSearch pageSearch = ListPageContext.getPageSearch();
        return this.selectSplit(sql.toString(), parameters, pageSearch.getPageIndex(), pageSearch.getPageSize(), new S_dict_type());
    }

    /**
     * 分页查询数据字典项列表。
     * @param dictType 字典类型(名称)
     * @param dictLabel 模糊查询字典项名称
     * @return
     * @date 2022-11-19
     */
    public GenericPager<S_dict_data> queryPageDictData(String dictType, String dictLabel){
        Map<String, Object> parameters = new HashMap<>();
        StringBuilder sql = new StringBuilder(SQL_PAGE_DATA_PREFIX);
        if(StringUtils.isNotEmpty(dictType)){
            sql.append(" and dict_type = :dictType");
            parameters.put("dictType", dictType);
        }
        if(StringUtils.isNotEmpty(dictLabel)){
            sql.append(" and dict_label like :dictLabel");
            parameters.put("dictLabel", "%" + dictLabel + "%");
        }
        PageSearch pageSearch = ListPageContext.getPageSearch();
        return this.selectSplit(sql.toString(), parameters, pageSearch.getPageIndex(), pageSearch.getPageSize(), new S_dict_data());
    }

    /**
     * 根据字典类型名称(代码表)，返回子代码集合。
     * @param dictType 代码类型
     * @return
     */
    public List<S_dict_data> queryDictDataByType(String dictType){
        return this.select(new S_dict_data(), "where status=0 and dict_type=? order by dict_sort asc", new Object[]{dictType});
    }
}