AdminMapper.java 5.5 KB

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