DepartmentMapper.java 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107
  1. package com.goafanti.common.dao;
  2. import com.goafanti.admin.bo.AdminCustomerBo;
  3. import com.goafanti.admin.bo.AdminListBo;
  4. import com.goafanti.admin.bo.depCountBo;
  5. import com.goafanti.common.model.Department;
  6. import com.goafanti.organization.bo.OrganizationListOut;
  7. import org.apache.ibatis.annotations.Param;
  8. import java.util.List;
  9. public interface DepartmentMapper {
  10. int deleteByPrimaryKey(String id);
  11. int insert(Department record);
  12. int insertSelective(Department record);
  13. Department selectByPrimaryKey(String id);
  14. int updateByPrimaryKeySelective(Department record);
  15. int updateByPrimaryKey(Department record);
  16. List<OrganizationListOut> selectSuperId(@Param("hideSign")Integer hideSign);
  17. /**
  18. * 根据组织名称查组织编号
  19. */
  20. String selectDepNoByName(String name);
  21. /**
  22. * 根据上级组织查组织编号
  23. */
  24. String selectDepNo(String id);
  25. /**
  26. /**
  27. * 查询相同上级下编号数量
  28. */
  29. int selectDepNoCount(String superId);
  30. /**
  31. * 模糊查询负责人名称
  32. */
  33. List<AdminListBo> selectName(String name);
  34. OrganizationListOut selectAllById(String id);
  35. int deleteById(String id);
  36. String selectAdminNameById(String name);
  37. String selectIdByDepNo(String depNo);
  38. /**
  39. * 查询有相同上级组织的信息
  40. * @param superId
  41. * @return
  42. */
  43. List<OrganizationListOut> selectIDNBySuperId(String superId);
  44. int updateByNumber(OrganizationListOut olo);
  45. int selectCountBySuperId(String superId);
  46. String selectIdByName(String name);
  47. String selectNameById(String id);
  48. String selectDepNoById(String id);
  49. int selectUserById(String id);
  50. /**
  51. * 查询下级集合
  52. * @param superIds
  53. * @return
  54. */
  55. List<Department> selectSubDeps(@Param("superIds")String superIds);
  56. List<depCountBo> selectBysuperId(String id);
  57. List<depCountBo> selectBysuperName(String name);
  58. /**
  59. * 查询当前集合
  60. * @return
  61. */
  62. List<Department> selectCurrentDeps(@Param("aid")String aid);
  63. /**
  64. * 查询所有部门
  65. * @return
  66. */
  67. List<Department> selectAllDeps();
  68. /**
  69. * 查询最大编号
  70. * @param abbreviation
  71. * @return
  72. */
  73. String getMaxAbbreviation(String abbreviation);
  74. List<AdminCustomerBo> getDepAll(@Param("depId")String depId,
  75. @Param("adminName")String adminName, @Param("startTime")String startTime, @Param("endTime")String endTime);
  76. List<AdminCustomerBo> AlldepCount(@Param("depIds")List<Department> depIds ,@Param("startTime")String startTime, @Param("endTime")String endTime);
  77. }