AdminMapper.java 5.7 KB

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