java-insagent-pc/src/main/java/com/ydtech/modules/admin/dao/SysUserLinkPtlAgreementMapper.java

package com.ydtech.modules.admin.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ydtech.modules.admin.model.dto.SysUserLinkPtlAgreementDto;
import com.ydtech.modules.admin.model.dto.SysUserLinkPtlAgreementQueryDto;
import com.ydtech.modules.admin.model.po.SysUserLinkPtlAgreement;
import com.ydtech.modules.admin.model.vo.SysUserLinkPtlAgreementVo;
import com.ydtech.modules.protocol.entity.po.PtlAgreement;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 *  @version
 *  @author: hxl
 *  @Date: 2024/4/15 14:47
 *  @Description: 用户关联协议表Dao
 */
@Mapper
public interface SysUserLinkPtlAgreementMapper extends BaseMapper<SysUserLinkPtlAgreement> {

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/15 15:32
     *  @Description: 分页
     */
    Page<SysUserLinkPtlAgreementDto> queryPage(@Param("page") Page<SysUserLinkPtlAgreementDto> page, @Param("vo") SysUserLinkPtlAgreementVo sysUserLinkPtlAgreementVo, @Param("ids") List<String> ids);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/15 17:08
     *  @Description: 通过用户id删除旧数据
     */
    void deleteByUserId(@Param("userId") String userId);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/16 9:32
     *  @Description: 通过后线人员id查询关联的协议列表
     */
    List<SysUserLinkPtlAgreementDto> findPtlAgreementListByUserId(@Param("userId") String userId);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/19 9:56
     *  @Description:创建后线人员绑定的协议回显
     */
    List<PtlAgreement> findAllPtlAgreementListByUserId(@Param("userId") String userId);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/2 14:53
     *  @Description:  查询后现人员绑定的协议
     */
    Page<PtlAgreement> findPtlAgreementListByUserIdPage(@Param("page") Page<PtlAgreement> page, @Param("vo") SysUserLinkPtlAgreementQueryDto sysUserLinkPtlAgreementQueryDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/8/14 11:55
     *  @Description:  通过用户id查询关联的协议
     */
    List<Long> findAgreeIdsByUserId(@Param("userId") String userId);
}