web_server/src/main/java/thyyxxk/webserver/dao/his/LoginDao.java

package thyyxxk.webserver.dao.his;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import thyyxxk.webserver.entity.dictionary.CodeName;
import thyyxxk.webserver.entity.login.UserInfo;
import thyyxxk.webserver.entity.settings.permissions.MenuItem;

import java.util.List;

@Mapper
public interface LoginDao {
    @Select("select code, name, password, code_rs, " +
            "deptCode=(select dept_code from a_employee_mi where code=a.code) " +
            "from dj_user_base a " +
            "where code_rs=#{codeRs} and del_flag=0")
    UserInfo findUserByCodeRsFromDjUserBase(@Param("codeRs") String codeRs);

    @Select("select code, name, code_rs, password='123456' " +
            "from a_employee_mi where code_rs=#{codeRs} and del_flag=0")
    UserInfo findUserByCodeRsFromAEmployeeMi(@Param("codeRs") String codeRs);

    @Insert("insert into dj_user_base (code, code_rs, name, password, del_flag) " +
            "values (#{code}, #{codeRs}, #{name}, '123456', 0)")
    void insertNewUserToDjUserBase(UserInfo user);

    @Select("select code, name, password, code_rs, " +
            "deptCode=(select dept_code from a_employee_mi where code=#{code}) " +
            "from dj_user_base where code=#{code} and del_flag=0")
    UserInfo findUserByCode(@Param("code") String code);

    @Select("select role_id from dj_user_role where user_code=#{code}")
    List<Integer> getUserRoles(@Param("code") String code);

    @Select("SELECT DISTINCT " +
            "name=(SELECT name FROM zd_unit_code WHERE code=a.dept), " +
            "code=a.dept FROM zd_dept_all a, a_employee_mi b " +
            "WHERE b.code= #{code} " +
            "AND (b.dept_code=a.small_dept or b.dept_code=a.dept)")
    List<CodeName> getUserWards(@Param("code") String code);

    @Select("select code='', name='全部', py_code='qb' union " +
            "select rtrim(code) code, rtrim(name) name, rtrim(py_code) pyCode " +
            "from zd_unit_code where code like '8%' order by code")
    List<CodeName> getAllWards();

    @Select("<script>" +
            "select path from dj_dict_menu where code in " +
            "(select menu_code from dj_role_menu where role_id in " +
            "<foreach collection='roles' item='role' separator=',' open='(' close='))'>" +
            "#{role}" +
            "</foreach>" +
            "</script>")
    List<String> getMenusByRoles(@Param("roles") List<Integer> roles);

    @Select("<script>" +
            "select distinct path from dj_dict_menu " +
            "where code in (select parent from dj_dict_menu where path in " +
            "<foreach collection='paths' item='path' separator=',' open='(' close='))'>" +
            "#{path}" +
            "</foreach>" +
            "</script>")
    List<String> getParentPaths(@Param("paths") List<String> paths);


    @Select("select * from dj_dict_menu where parent=#{parent}")
    List<MenuItem> selectMenusByParent(@Param("parent") Integer parent);

    @Select("<script>" +
            "select * from dj_dict_menu where code in " +
            "(select menu_code from dj_role_menu where role_id in " +
            "<foreach collection='roles' item='role' separator=',' open='(' close='))'>" +
            "#{role}" +
            "</foreach>" +
            "</script>")
    List<MenuItem> selectMenusByRoles(@Param("roles") List<Integer> roles);

    @Select("select * from dj_dict_menu where code=#{code}")
    MenuItem selectMenuByCode(@Param("code") Integer code);
}