ProjectSalaryHistoryMapper.java

package com.subsidy.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.subsidy.dto.project.TalentListDTO;
import com.subsidy.dto.salary.CommitSalaryDTO;
import com.subsidy.model.ProjectSalaryHistoryDO;
import com.subsidy.vo.labor.ProjectsVO;
import com.subsidy.vo.project.LaborProjectsVO;
import com.subsidy.vo.project.TalentListVO;
import com.subsidy.vo.project.TalentSalaryDetailVO;
import com.subsidy.vo.project.TalentSalaryVO;
import com.subsidy.vo.salary.ProjectMembersVO;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

/**
 * <p>
 * 工资单历史表 Mapper 接口
 * </p>
 *
 * @author Tuyp
 * @since 2024-07-11
 */
@Repository
public interface ProjectSalaryHistoryMapper extends BaseMapper<ProjectSalaryHistoryDO> {

    List<LaborProjectsVO> laborProjects(Long laborId,String projectName);

    IPage<TalentSalaryVO> talentSalary(IPage page, Long projectId, String userName, String salaryMonth);

    IPage<TalentListVO> talentList(IPage page,Long laborId,String userName);

    IPage<TalentSalaryDetailVO> talentSalaryDetail(IPage page,Long projectId, Long memberId, Long laborId);

    /**
     * 项目下的成员
     */
    IPage<ProjectMembersVO> projectMembers(IPage page, Long projectId, String userName,String salaryMonth);

    /**
     * 导出模板  不要工资数据
     */
    List<ProjectMembersVO> exportTemplate(Long projectMappingId);

    void commitSalary(Long id);

    void updateSalary(Long id, String salary, String salaryMark, String salaryDate, Date updateDate);

    /**
     * 查看某个项目这个月是否已经提交过
     */
    List<Long> commitMonthSalary(Long projectId,String salaryMonth,Integer commitStatus);

    void deleteSalary(String salaryMonth,Long id);

}