package com.ydtech.modules.esm.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ydtech.modules.esm.model.EsmUserInternal;
import org.springframework.stereotype.Repository;

@Repository
public interface EsmUserInternalMapper extends BaseMapper<EsmUserInternal> {

//    String internalUserSql = "select t.id,t.name,t.dept_id deptid,t2.name deptname,t3.id comid,t3.name comname,t.status " +
//            "from sys_user t left join sys_dept t2 on t.dept_id=t2.id " +
//            "left join sys_dept t3 on t2.parent_id=t3.id " +
//            "left join esm_user_internal a on t.id=a.id " +
//            "where t.id=#{userId}";
//
//    String internalUserByDeptIdSql = "select t1.id,t1.name,t1.dept_id deptid,sd.name deptname,sd2.id comid,sd2.name comname,t2.status " +
//            "from sys_user t1 left join esm_user_internal t2 on t1.id=t2.id " +
//            "LEFT JOIN sys_dept sd ON t1.dept_id=sd.id " +
//            "LEFT JOIN sys_dept sd2 ON sd2.id=sd.parent_id " +
//            "where 1=1  and t2.isteamleader = '1' and t1.dept_id=#{deptId}";
//
//
//    String selectUserParamSql = "select su.id as userId,su.name,su.sex,su.mobile,su.status\n" +
//            ",sd.id as deptId,sd.name as deptName\n" +
//            ",psd.id as pDeptId,psd.name as pDeptName\n" +
//            ",dict.label as jobName\n" +
//            ",dict2.label as approvalStatus";
//
//
//    String selectUserFromSql = " from sys_user su \n" +
//            "left JOIN sys_dept sd on su.dept_id=sd.id\n" +
//            "left join sys_dept psd on sd.parent_id=psd.id\n" +
//            "left join sys_dict dict on dict.value=su.job_code\n" +
//            "left join sys_dict dict2 on dict2.value=su.approval_status\n" +
//            "where 1=1\n" +
//            "and sd.id &lt;&gt; '' \n" +
//            "AND dict.itemname = 'jobcode'\n" +
//            "AND dict2.itemname = 'approval'";
//
//    String selectUserFromWhereSql = " " +
//            "<if test='page.columnFilters.usertype !=null and page.columnFilters.usertype.value!=\"\" and page.columnFilters.usertype.value!=null '>" +
//            "  and su.usertype = #{page.columnFilters.usertype.value}" +
//            "</if> " +
//            "<if test='page.columnFilters.approvalStatus !=null and page.columnFilters.approvalStatus.value!=\"\" and page.columnFilters.approvalStatus.value!=null '>" +
//            " and su.approval_status = #{page.columnFilters.approvalStatus.value}" +
//            "</if> " +
//            "<if test='page.columnFilters.realName !=null and page.columnFilters.realName.value!=\"\" and page.columnFilters.realName.value!=null '> " +
//            " and su.name like concat('%',#{page.columnFilters.realName.value},'%')" +
//            "</if> " +
//            "<if test='page.columnFilters.userId !=null and page.columnFilters.userId.value!=\"\" and page.columnFilters.userId.value!=null '>" +
//            " and su.id = #{page.columnFilters.userId.value}" +
//            "</if> " +
//            "<if test='page.columnFilters.mobile !=null and page.columnFilters.mobile.value!=\"\" and page.columnFilters.mobile.value!=null '>" +
//            " and su.mobile = #{page.columnFilters.mobile.value}" +
//            "</if> " +
//            "<if test='page.columnFilters.delFlag !=null and page.columnFilters.delFlag.value!=\"\" and page.columnFilters.delFlag.value!=null '>" +
//            " and su.del_flag = #{page.columnFilters.delFlag.value}" +
//            "</if> " +
//            "<if test='page.columnFilters.deptId !=null and page.columnFilters.deptId.value!=\"\" and page.columnFilters.deptId.value!=null '>" +
//            " and su.dept_id like concat('%',#{page.columnFilters.deptId.value},'%')" +
//            "</if> " +
//            "";
//
//
////    String selectUserFromWhereSql = " " +
////            " and su.usertype = #{page.columnFilters.usertype.value}" +
////            " and su.status = #{page.columnFilters.status.value}" +
////            " and su.name like concat('%',#{page.columnFilters.name.value},'%')" +
////            " and su.id = #{page.columnFilters.userId.value}" +
////            " and su.mobile = #{page.columnFilters.mobile.value}" +
////            "";
//
//
//    @Select(internalUserSql)
//    SysUserVO gainInternalUser(@Param("userId") String userId);
//
//
//    @Select(internalUserByDeptIdSql)
//    SysUserVO gainInternalUserByDeptId(@Param("deptId") String deptId);
//
//
//    //    @Select("select * from (" + selectUserParamSql + selectUserFromSql + selectUserFromWhereSql + " limit #{page.pageNum},#{page.pageSize} ) aaa")
//    @Select({"<script>",
//            "select * from (",
//            selectUserParamSql,
//            selectUserFromSql,
//            selectUserFromWhereSql,
//            " limit #{page.pageNum},#{page.pageSize} ) aaa",
//            "</script>"})
//    List<SysUserBaseVO> gainUserBaseInfo(@Param("page") PageRequest pageRequest);
//
//
//    //    @Select("select count(1) " + selectUserFromSql + selectUserFromWhereSql)
//    @Select({"<script>","select count(1) ",selectUserFromSql,selectUserFromWhereSql,"</script>"})
//    int gainUserBaseInfoCount(@Param("page") PageRequest pageRequest);

}