package com.nuvole.four.mapper;

import com.nuvole.four.domain.SysOrg;
import com.nuvole.four.domain.dto.ChannelOrgConfigDetailDto;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

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

public interface SysOrgMapper {
    int deleteByPrimaryKey(Long id);

    int insert(SysOrg record);

    int insertSelective(SysOrg record);

    SysOrg selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(SysOrg record);

    int updateByPrimaryKey(SysOrg record);

    /**
     * @Author : liu.q [916000612@qq.com]
     * @Date : 2019-04-04 14:15
     * @Description :查询全部
     */
    List<SysOrg> selectAll(Map map);

    /**
     * @Author : liu.q [916000612@qq.com]
     * @Date : 2019-04-07 19:21
     * @Description :查询全部
     */
    List<Map> selectAllOfMap(Map map);

    /**
     * 根据机构编号查询机构信息
     *
     * @author zxc
     * @Date 2019/6/4 11:35
     **/
    SysOrg getOrgByCode(String code);

    @Select("select org.*,org2.org_Code pOrgCode from sys_org org left join sys_org org2 on org.pid = org2.id where org.org_code=#{code}")
    Map getOrgByCode2(String code);

    List<Map> getBranchByOrgCode(@Param("code") String code, @Param("keyText") String keyText, @Param("userType") Short userType);


    /**
     * 查询机构byCode
     *
     * @Author: lc
     * @Date: 2019/6/12 16:20
     */
    SysOrg selectOrgByCode(String code);

    /**
     * 批量执行导入
     *
     * @author zxc
     * @Date 2019/6/11 18:59
     **/
    int batchImportOrg(List<Map> list);

    /**
     * 查询全部机构
     *
     * @Author: lc
     * @Date: 2019/6/13 9:39
     */
    @Select("select * from sys_org ")
    List<SysOrg> getOrgList();

    /**
     * 查询父机构useCode 以及 子机构maxCode
     *
     * @author zxc
     * @Date 2019/7/13 18:49
     **/
    @Select("select max(a.org_code) maxCode,a.pid,(select b.org_code from sys_org b where b.id = a.pid) pCode from sys_org a group by a.pid")
    List<Map> selectUseCodeForImport();

    /**
     * 查询本级最大code
     *
     * @Author: lc
     * @Date: 2019/6/13 13:40
     */
    @Select("select max(org_code) from sys_org where pid=#{pid} ")
    String getMaxCode(@Param("pid") Long pid);

    /**
     * 根据机构编号获取机构
     *
     * @param orgCode
     * @return
     */
    @Select("select * from sys_org where user_org_code = #{orgCode}")
    SysOrg selectByOrgCode(@Param("orgCode") String orgCode);

    /**
     * 角色管理人员配置机构树
     *
     * @author zxc
     * @Date 2019/6/13 17:19
     **/
    List<SysOrg> getListForRoleUser(Map map);

    /**
     * Createed by PKZ
     * Date 2019/6/17 16:11
     * Description：根据userOrgCode查询机构信息
     **/
    @Select("select a.org_code zj_org_code,a.id zj_id,a.name zj_name,b.id xq_id,b.name xq_name,c.id sj_id,c.name sj_name from sys_org a,sys_org b,sys_org c where a.user_org_code = #{orgCode} and b.id=a.pid and c.id=b.pid")
    Map getOrgByUserCode(@Param("orgCode") String code);

    List<SysOrg> getOrgForSelector(@Param("pid") Long pid, @Param("rootId") Long rootId);

    @Select("select pid from sys_org where id = #{id}")
    Long queryPidById(@Param("id") Long id);

    @Select("select lv from sys_org where id = #{id}")
    Integer queryLvById(@Param("id") Long id);

    Integer getByOrgCode(SysOrg sysOrg);


    @Select("select id,name,org_code,user_org_code,pid from sys_org where state=1 and lv<2")
    List<SysOrg> getOrgEndS();

    @Select("select id, name from sys_org where pid = #{orgId}")
    List<SysOrg> getOrgMapByLogin(Long orgId);

    @Select("select id, name from sys_org where id = #{orgId} and lv = 3")
    List<SysOrg> getOrgMapByLoginLv(Long orgId);

    @Select("select lv from sys_org where org_code = #{orgCode}")
    Integer getOrgLvByOrgCode(String orgCode);





    /**
     * 查询所有支局
     */
    @Select("select id, name from sys_org where  lv = 3")
    List<SysOrg> getWdIdOrName();

    /**
     * 查询所有支局
     */
    @Select("select * from sys_org where  lv = 0 limit 1")
    SysOrg getSjOrgInfo();

    @Select("select * from sys_org where pid=(select id from sys_org where org_code = #{orgCode} ) or org_code = #{orgCode}")
    List<SysOrg> selectOrgByOrgCode(String orgCode);

    @Select("select name as orgName ,org_code as orgCode from sys_org group by org_code ")
    List<Map> getOrgCodeCache();

    @Select("select a.name,c.org_code orgCode from sys_area a left join sys_org_area b on b.area_id = a.id left join sys_org c on c.id = b.org_id where a.lv = 2")
    List<Map> getSjOrgCodeAreaNameRef();


    /**
     * 禁用机构
     *
     * @param orgCode
     * @return CONCAT(' % ', # { 0 }, ' % ')
     */
    @Update("update sys_org set state=#{state} where org_code like CONCAT('%',#{orgCode},'%')")
    int updateState(@Param("orgCode") String orgCode, @Param("state") Integer state);

    /**
     * 方法描述: 根据orgId查询机构名称、父级机构名称
     *
     * @date  2024-04-11 20:30
     **/
    @Select("select a.id,a.name orgName,a.pid pId,a.lv,(select b.name from sys_org b where b.id = a.pid) parentOrgName from sys_org a where a.id = #{orgId}")
    ChannelOrgConfigDetailDto queryNameAndParentName(@Param("orgId") Long orgId);
}