MemberMapper.java

package com.subsidy.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.subsidy.model.DepartmentDictDO;
import com.subsidy.model.MemberDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.subsidy.vo.member.GetAllVO;
import com.subsidy.vo.member.ManageMemberVO;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * 学生表 Mapper 接口
 * </p>
 *
 * @author Tuyp
 * @since 2024-01-11
 */
@Repository
public interface MemberMapper extends BaseMapper<MemberDO> {

    /**
     * 查询部门所有的学生  分页
     */
    IPage<GetAllVO> getMembers(IPage iPage, Long departmentId, String userName, String status, String startDate, String endDate);

    /**
     * 查询某公司所有的学生 公司不传就是查平台所有学生
     */
    IPage<ManageMemberVO> manageMember(IPage iPage, Long companyId, String userName, String startDate, String endDate);

    /**
     * 查询某个部门的员工  不分页
     */
    List<MemberDO> getMemberWithoutPage(Long departmentId, String userName, String status, String startDate, String endDate);

    /**
     * 查询某公司的学生
     */
    IPage<GetAllVO> getCompanyMember(IPage iPage,Long companyId,String userName,String status,String startDate,String endDate);

    /**
     * 查询学生所在部门
     */
    List<DepartmentDictDO> getDepartments(Long memberId);

}