SaasProjectMapper.java 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. package com.persagy.person.mapper;
  2. import java.util.List;
  3. import org.apache.ibatis.annotations.Mapper;
  4. import org.apache.ibatis.annotations.Param;
  5. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  6. import com.persagy.person.pojo.dto.SaasProject;
  7. /**
  8. * 项目信息
  9. *
  10. * @version 1.0.0
  11. * @company persagy
  12. * @author zhangqiankun
  13. * @date 2021-03-13 15:29:50
  14. */
  15. @Mapper
  16. public interface SaasProjectMapper extends BaseMapper<SaasProject> {
  17. /**
  18. * 项目列表查询
  19. *
  20. * @param saasProject
  21. * @param startRow
  22. * @param size
  23. * @return
  24. */
  25. List<SaasProject> querySaasProjectList(@Param("project") SaasProject saasProject, @Param("startRow") Integer startRow, @Param("size") Integer size);
  26. /**
  27. * 分页查询时,获取总记录数
  28. *
  29. * @param saasProject
  30. * @return
  31. */
  32. Integer queryCountMoreProject(@Param("project") SaasProject saasProject);
  33. /**
  34. * 获取项目集合信息,关联查询
  35. *
  36. * @param saasProject
  37. * @param page
  38. * @param size
  39. * @return
  40. */
  41. List<SaasProject> queryMoreProjectInfo(@Param("project") SaasProject saasProject, @Param("startRow") Integer startRow, @Param("size") Integer size);
  42. /**
  43. * 查询该账户可允许访问的集团项目,权限表关联查询,默认项目名称正序排序
  44. *
  45. * @param groupCode
  46. * @param accountId
  47. * @param valid 1-可用,0-不可用
  48. * @return
  49. */
  50. List<SaasProject> queryAllowGroupProjectList(@Param("groupCode") String groupCode, @Param("accountId") String accountId, @Param("valid") Integer valid);
  51. /**
  52. * 批量插入项目信息
  53. *
  54. * @param list
  55. * @return
  56. */
  57. Integer batchInsertProjectData(@Param("projects") List<SaasProject> projects);
  58. /**
  59. * 批量更新项目所属区域
  60. *
  61. * @param saasProject
  62. * @param projectIds
  63. * @return
  64. */
  65. Integer batchUpdateProjectArea(@Param("project") SaasProject saasProject, @Param("projectIds") List<String> projectIds);
  66. /**
  67. * 查询出能够被访问的项目总数
  68. *
  69. * @param groupCode 集团编码
  70. * @param accountId 账号ID
  71. * @param areaId 底层区域ID
  72. * @return
  73. */
  74. Integer countAllowProjectNum(@Param("groupCode") String groupCode, @Param("accountId") String accountId,
  75. @Param("areaId") String areaId, @Param("valid") Integer valid);
  76. }