SysUserLinkPtlAgreementMapper.java 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. package com.ydtech.modules.admin.dao;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.ydtech.modules.admin.model.dto.SysUserLinkPtlAgreementDto;
  5. import com.ydtech.modules.admin.model.po.SysUserLinkPtlAgreement;
  6. import com.ydtech.modules.admin.model.vo.SysUserLinkPtlAgreementVo;
  7. import com.ydtech.modules.protocol.entity.po.PtlAgreement;
  8. import org.apache.ibatis.annotations.Mapper;
  9. import org.apache.ibatis.annotations.Param;
  10. import java.util.List;
  11. /**
  12. * @version
  13. * @author: hxl
  14. * @Date: 2024/4/15 14:47
  15. * @Description: 用户关联协议表Dao
  16. */
  17. @Mapper
  18. public interface SysUserLinkPtlAgreementMapper extends BaseMapper<SysUserLinkPtlAgreement> {
  19. /**
  20. * @version
  21. * @author: hxl
  22. * @Date: 2024/4/15 15:32
  23. * @Description: 分页
  24. */
  25. Page<SysUserLinkPtlAgreementDto> queryPage(@Param("page") Page<SysUserLinkPtlAgreementDto> page, @Param("vo") SysUserLinkPtlAgreementVo sysUserLinkPtlAgreementVo);
  26. /**
  27. * @version
  28. * @author: hxl
  29. * @Date: 2024/4/15 17:08
  30. * @Description: 通过用户id删除旧数据
  31. */
  32. void deleteByUserId(@Param("userId") String userId);
  33. /**
  34. * @version
  35. * @author: hxl
  36. * @Date: 2024/4/16 9:32
  37. * @Description: 通过后线人员id查询关联的协议列表
  38. */
  39. List<SysUserLinkPtlAgreementDto> findPtlAgreementListByUserId(@Param("userId") String userId);
  40. /**
  41. * @version
  42. * @author: hxl
  43. * @Date: 2024/4/19 9:56
  44. * @Description:创建后线人员绑定的协议回显
  45. */
  46. List<PtlAgreement> findAllPtlAgreementListByUserId(@Param("userId") String userId);
  47. }