From d346846239a8a39246c464dc634f5fd72add99ab Mon Sep 17 00:00:00 2001 From: maven <2163098428@qq.com> Date: 星期二, 26 八月 2025 15:22:15 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/pim-jlmy' into pim-jlmy --- main-business/src/main/java/com/ruoyi/business/service/impl/StaffOnJobServiceImpl.java | 71 +++++++++++++++++++++++++++++++++++ 1 files changed, 71 insertions(+), 0 deletions(-) diff --git a/main-business/src/main/java/com/ruoyi/business/service/impl/StaffOnJobServiceImpl.java b/main-business/src/main/java/com/ruoyi/business/service/impl/StaffOnJobServiceImpl.java new file mode 100644 index 0000000..9a0b4cd --- /dev/null +++ b/main-business/src/main/java/com/ruoyi/business/service/impl/StaffOnJobServiceImpl.java @@ -0,0 +1,71 @@ +package com.ruoyi.business.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.business.entity.StaffJoinLeaveRecord; +import com.ruoyi.business.entity.StaffOnJob; +import com.ruoyi.business.mapper.StaffJoinLeaveRecordMapper; +import com.ruoyi.business.mapper.StaffOnJobMapper; +import com.ruoyi.business.service.IStaffOnJobService; +import com.ruoyi.common.utils.poi.ExcelUtil; + +import jakarta.servlet.http.HttpServletResponse; +import lombok.AllArgsConstructor; +import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; + +import java.util.List; + +@AllArgsConstructor +@Service +public class StaffOnJobServiceImpl extends ServiceImpl<StaffOnJobMapper, StaffOnJob> implements IStaffOnJobService { + + + private StaffOnJobMapper staffOnJobMapper; + + private StaffJoinLeaveRecordMapper staffJoinLeaveRecordMapper; + + //鍦ㄨ亴鍛樺伐鍙拌处鍒嗛〉鏌ヨ + @Override + public IPage<StaffOnJob> staffOnJobListPage(Page page, StaffOnJob staffOnJob) { + return staffOnJobMapper.staffOnJobListPage(page,staffOnJob); + } + + //鍦ㄨ亴鍛樺伐璇︽儏 + @Override + public List<StaffJoinLeaveRecord> staffOnJobDetail(String staffNo) { + return staffJoinLeaveRecordMapper.selectList(Wrappers.<StaffJoinLeaveRecord>lambdaQuery() + .eq(StaffJoinLeaveRecord::getStaffState,1) + .eq(StaffJoinLeaveRecord::getStaffNo,staffNo)); + } + + //鍦ㄨ亴鍛樺伐瀵煎嚭 + @Override + public void staffOnJobExport(HttpServletResponse response, StaffOnJob staffOnJob) { + List<StaffOnJob> staffOnJobs = staffOnJobMapper.staffOnJobList(staffOnJob); + ExcelUtil<StaffOnJob> util = new ExcelUtil<StaffOnJob>(StaffOnJob.class); + util.exportExcel(response, staffOnJobs, "鍦ㄨ亴鍛樺伐鍙拌处瀵煎嚭"); + } + + @Override + public List<StaffJoinLeaveRecord> staffOnJobList() { + return staffJoinLeaveRecordMapper.staffOnJobList(); + } + + @Override + public Boolean importData(MultipartFile file) { + try { + ExcelUtil<StaffOnJob> util = new ExcelUtil<>(StaffOnJob.class); + List<StaffOnJob> staffOnJobs = util.importExcel(file.getInputStream()); + return saveOrUpdateBatch(staffOnJobs); + } catch (Exception e) { + e.printStackTrace(); + return false; + } + } + + +} -- Gitblit v1.9.3