AdminMapper.java 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. package com.goafanti.common.dao;
  2. import com.goafanti.admin.bo.AdminContacts;
  3. import com.goafanti.admin.bo.AdminCustomerBo;
  4. import com.goafanti.admin.bo.AdminListBo;
  5. import com.goafanti.common.model.Admin;
  6. import com.goafanti.common.model.Department;
  7. import com.goafanti.common.model.Role;
  8. import org.apache.ibatis.annotations.Param;
  9. import java.util.List;
  10. public interface AdminMapper {
  11. int deleteByPrimaryKey(String id);
  12. int insert(Admin record);
  13. int insertSelective(Admin record);
  14. Admin selectByPrimaryKey(String id);
  15. int updateByPrimaryKeySelective(Admin record);
  16. int updateByPrimaryKey(Admin record);
  17. Admin selectByMobile(String mobile);
  18. List<Role> selectRolesByPrimaryKey(String uid);
  19. List<Admin> selectCognizanceConsultant();
  20. List<Admin> selectCognizancePrincipal();
  21. List<Admin> selectPatentAuthor();
  22. List<Admin> selectPatentPrincipal();
  23. List<Admin> selectCopyrightConsultant();
  24. List<Admin> selectCopyrightPrincipal();
  25. List<Admin> selectTechprojectConsultant();
  26. List<Admin> selectTechprojectPrincipal();
  27. List<String> selectRoleByPrimaryKey(String uid);
  28. List<Admin> selectAccoutManager();
  29. List<Admin> selectTechnician();
  30. List<Admin> selectSalesman();
  31. List<Admin> selectContractManager();
  32. List<Admin> selectTechBroder();
  33. List<Admin> listAdminSelectBySuperAdmin();
  34. List<Admin> listAdminSelectByAreaAdmin(@Param("provinceList")List<Integer> provinceList, @Param("cityList")List<Integer> cityList);
  35. List<Admin> listAdminByName(@Param("name")String name,@Param("status")Integer status);
  36. int insertn(Admin record);
  37. String selectUserNoBySuperiorId(String superiorId);
  38. int selectCountBySuperiorId(String superiorId);
  39. String selectIdByUserNo(String userNo);
  40. Admin selectAllByid(@Param("id") String id);
  41. String selectNameByid(String id);
  42. List<Role> selectRolesByUid(String id);
  43. String selectStatusByMobile(@Param("mobile")String mobile);
  44. int deleteById(String id);
  45. List<Admin> selectIDNBySuperiorId(String superiorId);
  46. String selectUserNoById(String superiorId);
  47. int updateByUserNo(Admin record);
  48. List<String>selectIdBySuperiorId(String superiorId);
  49. /**
  50. * 查询下级人员
  51. * @param adminId
  52. * @return
  53. */
  54. List<AdminListBo> selectSubList(@Param("adminId")String adminId);
  55. /**
  56. * @return
  57. */
  58. Admin selectAdminByRoleId(@Param("roleId")String roleId);
  59. /**
  60. * 查询部门下的员工
  61. * @param departmentId
  62. * @param name
  63. * @return
  64. */
  65. List<AdminListBo> selectDepartmentStaff(String departmentId, String name);
  66. Admin selectAdminName(@Param("name")String name);
  67. List<Admin> selectAllAdmin(@Param("depId")String depId);
  68. int updateLockIds(@Param("lockIds")String lockIds);
  69. int getCountById(String id);
  70. AdminListBo getDeptNameByAid(String id);
  71. List<Admin> getAdminRoleNameList(String roleName);
  72. List<Admin> getAdminRoleNamesList(List<String> list);
  73. List<Admin> getAdminRoleTypesList(List<String> list);
  74. List<Admin> getAdminRoleTypeList(String roleType);
  75. int addAdminContacts(AdminContacts a);
  76. int deleteFrequentContacts(String id);
  77. List<String> getaidFrequentContacts(String id);
  78. /**
  79. * 获取属于某部门的角色
  80. * @param depId
  81. * @param roleType
  82. * @return
  83. */
  84. List<String> listNameByDepAndName(@Param("depId")String depId,@Param("roleType")String roleType);
  85. List<Admin> listAdminBydepIdAndRoleType(@Param("depId")String depId,@Param("roleType")String roleType);
  86. List<String> selectBySuperId(String aid);
  87. Admin selectFinanceAdminByOrderDep(String orderDep);
  88. String getPermission(String transferId);
  89. List<String> selectDepIdWithSpuerId(String superId);
  90. List<String> getAdminRoleListByAid(String id);
  91. Admin selectByOpeid(String openid);
  92. Admin selectGetSuper(String aid);
  93. List<String> getFinanceDep(String aid);
  94. List<String> getLowerFinanceDep(String aid);
  95. int selectByAmbIdCount(String id);
  96. List<Admin> selectAdminByRoleType(@Param("roleType") String roleType);
  97. List<AdminCustomerBo > selectByDeps(@Param("depIds") List<Department> depIds,@Param("seniorStaff") Integer seniorStaff);
  98. Admin getAdminByFinanceId(String id);
  99. }