package com.ruoyi.staff.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.staff.mapper.StaffJoinLeaveRecordMapper; import com.ruoyi.staff.mapper.StaffOnJobMapper; import com.ruoyi.staff.pojo.StaffJoinLeaveRecord; import com.ruoyi.staff.pojo.StaffOnJob; import com.ruoyi.staff.service.IStaffJoinLeaveRecordService; import com.ruoyi.staff.service.IStaffOnJobService; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.util.List; @AllArgsConstructor @Service public class StaffOnJobServiceImpl extends ServiceImpl implements IStaffOnJobService { private StaffOnJobMapper staffOnJobMapper; private StaffJoinLeaveRecordMapper staffJoinLeaveRecordMapper; //在职员工台账分页查询 @Override public IPage staffOnJobListPage(Page page, StaffOnJob staffOnJob) { return staffOnJobMapper.staffOnJobListPage(page,staffOnJob); } //在职员工详情 @Override public List staffOnJobDetail(String staffNo) { return staffJoinLeaveRecordMapper.selectList(Wrappers.lambdaQuery() .eq(StaffJoinLeaveRecord::getStaffState,1) .eq(StaffJoinLeaveRecord::getStaffNo,staffNo)); } //在职员工导出 @Override public void staffOnJobExport(HttpServletResponse response, StaffOnJob staffOnJob) { List staffOnJobs = staffOnJobMapper.staffOnJobList(staffOnJob); ExcelUtil util = new ExcelUtil(StaffOnJob.class); util.exportExcel(response, staffOnJobs, "在职员工台账导出"); } }