DepartmentMapper.java 3.2 KB

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