CompanyMemberMappingMapper.java

package com.subsidy.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.subsidy.model.CompanyMemberMappingDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.subsidy.model.MemberDO;
import com.subsidy.vo.company.MemberCompanyVO;
import com.subsidy.vo.member.AttendMembersVO;
import com.subsidy.vo.member.DepartMembersVO;
import com.subsidy.vo.member.MemberAttendInfoVO;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * 公司人员映射表 Mapper 接口
 * </p>
 *
 * @author Tuyp
 * @since 2024-01-11
 */
@Repository
public interface CompanyMemberMappingMapper extends BaseMapper<CompanyMemberMappingDO> {

    /**
     * 查询某个人带过公司的记录
     */
    List<MemberCompanyVO> memberCompanys(Long memberId);

    /**
     * 查看某个公司的离职记录
     */
    IPage<DepartMembersVO> departMembers(IPage iPage, Long companyId, String userName);

    /**
     * 某公司参加过培训的学生名单
     */
    IPage<AttendMembersVO> attendMembers(IPage iPage, Long companyId, Long departmentId, String userName);

    /**
     * 某个学员参加过某个公司的所有培训
     */
    List<MemberAttendInfoVO> memberAttendInfo(Long memberId, Long companyId);

    /**
     * 查看某个公司accountName的人
     */
    List<MemberDO> companyAccountMembers(Long companyId, String accountName);
}