毕业设计，基于SpringBoot+Vue+MySql开发的前后端分离的美术馆人事管理系统，内含Java完整源代码，数据库脚本

package io.github.sliverkiss.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.StringUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import io.github.sliverkiss.constants.UserContants; import io.github.sliverkiss.controller.DTO.EmployeeQueryDTO; import io.github.sliverkiss.dao.*; import io.github.sliverkiss.dao.RBAC.UserDao; import io.github.sliverkiss.domain.ResponseResult; import io.github.sliverkiss.domain.entity.*; import io.github.sliverkiss.domain.entity.RBAC.User; import io.github.sliverkiss.domain.entity.assess.AssessApproval; import io.github.sliverkiss.domain.entity.assess.AssessDeclare; import io.github.sliverkiss.domain.entity.assess.AssessStaff; import io.github.sliverkiss.domain.vo.ContractVo; import io.github.sliverkiss.domain.vo.EmployeeVo; import io.github.sliverkiss.enums.AppHttpCodeEnum; import io.github.sliverkiss.exception.SystemException; import io.github.sliverkiss.service.EmployeeService; import io.github.sliverkiss.utils.BeanCopyUtils; import io.github.sliverkiss.utils.DateUtil; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import xin.altitude.cms.common.util.EntityUtils; import javax.annotation.Resource; import java.util.List; import java.util.Map; import java.util.Optional; import java.util.Set; import java.util.stream.Collectors; import static io.github.sliverkiss.utils.CheckUtil.checkInt; import static io.github.sliverkiss.utils.CheckUtil.checkStr; /** * 员工表(Employee)表服务实现类 * * @author tistzach * @since 2023-07-05 11:45:06 */ @Service("employeeService") @Slf4j public class EmployeeServiceImpl extends ServiceImpl<EmployeeDao, Employee> implements EmployeeService { @Autowired private EmployeeDao employeeDao; @Resource private PersonalDao personalDao; @Resource private DepartmentDao departmentDao; @Autowired private UserDao userDao; @Autowired private SalaryDao salaryDao; @Autowired private RenewalDao renewalDao; @Autowired private TransferDao transferDao; @Autowired private ReinstatementDao reinstatementDao; @Autowired private ResignationDao resignationDao; @Autowired private AssessStaffDao staffDao; @Autowired private AssessDeclareDao declareDao; @Autowired private TrainningRecordDao recordDao; @Autowired private AssessApprovalDao approvalDao; /** * 员工检索，实现员工信息的多方位检索，包活员工编号、入职日期、部门、岗位和姓名检索 * * @return {@link ResponseResult} */ @Override public ResponseResult selectEmployeePage(EmployeeQueryDTO employeeQueryDTO) { // 数据校验 Integer currentPage = employeeQueryDTO.getCurrentPage (); Integer pageSize = employeeQueryDTO.getPageSize (); String name = employeeQueryDTO.getName (); String employeeId = employeeQueryDTO.getEmployeeId (); Integer departmentId = employeeQueryDTO.getDepartmentId (); String post = employeeQueryDTO.getPost (); String hireDate = employeeQueryDTO.getHireDate (); Integer userId = employeeQueryDTO.getUserId (); Integer role = employeeQueryDTO.getUserRole (); if (currentPage == null || pageSize <= 0 || pageSize == null || pageSize < 1) { throw new SystemException ( AppHttpCodeEnum.SYSTEM_ERROR ); } Page<Employee> page = new Page<> ( currentPage, pageSize ); // 如果员工名不为空，则按姓名模糊查询 List<Integer> personalIds = personalDao.selectList ( Wrappers.lambdaQuery ( Personal.class ) .like ( StringUtils.isNotBlank ( name ), Personal::getName, name ) ) .stream ().map ( Personal::getId ).collect ( Collectors.toList () ); // 获取查询到的部门信息 List<Department> departmentList = departmentDao .selectList ( Wrappers.lambdaQuery ( Department.class ) .in ( Department::getId, departmentId ) ); // 数据校检,防止产生报错 if (checkStr ( name, personalIds ) || checkInt ( departmentId, departmentList )) { return ResponseResult.errorResult ( AppHttpCodeEnum.FIND_NOT_FOUND ); } else { // 如果 员工编号不为空，则按员工编号模糊查询 try { LambdaQueryWrapper<Employee> employeeWrapper = Wrappers.lambdaQuery ( Employee.class ) .like ( StringUtils.isNotBlank ( employeeId ), Employee::getId, employeeId ) .like ( StringUtils.isNotBlank ( post ), Employee::getPost, post ) .in ( personalIds.size () > 0, Employee::getPersonalId, personalIds ) .eq ( departmentList.size () > 0, Employee::getDepartmentId, departmentId ) .like ( StringUtils.isNotBlank ( hireDate ), Employee::getId, hireDate ); // 判断用户角色，筛选信息 if (role.equals ( UserContants.ROLE_USER )) { User user = userDao.selectById ( userId ); Employee employee = this.getById ( user.getEmployeeId () ); if (employee == null) { throw new SystemException ( AppHttpCodeEnum.FIND_NOT_FOUND ); } employeeWrapper.eq ( Employee::getId, employee.getId () ); } // 将 条件查询结果用page包装起来 Page<Employee> employeePage = this.page ( page, employeeWrapper ); IPage<EmployeeVo> employeeVoIPage = EntityUtils.toPage ( employeePage, EmployeeVo::new ); // 分页模糊查询 // 注入personal属性 this.employeeInnerJoinPersonal ( employeeVoIPage ); // 注入department属性 this.employeeInnerJoinDepartment ( employeeVoIPage ); return ResponseResult.okResult ( employeeVoIPage ); } catch (SystemException e) { throw new SystemException ( AppHttpCodeEnum.FIND_NOT_FOUND ); } } } /** * 员工工作表连接员工信息表查询 * * @param employeeVoIPage 员工资料视图 */ public void employeeInnerJoinPersonal(IPage<EmployeeVo> employeeVoIPage) { List<Integer> personalIds = EntityUtils.toList ( employeeVoIPage.getRecords (), EmployeeVo::getPersonalId ); if (personalIds.size () > 0) { LambdaQueryWrapper<Personal> wrapper = Wrappers.lambdaQuery ( Personal.class ).in ( Personal::getId, personalIds ); List<Personal> personalList = personalDao.selectList ( wrapper ); Map<Integer, Personal> map = EntityUtils.toMap ( personalList, Personal::getId, e -> e ); // 将employee填入employeeVo employeeVoIPage.getRecords ().forEach ( employeeVo -> { Personal personal = map.get ( employeeVo.getPersonalId () ); Optional.ofNullable ( personal ).ifPresent ( e -> employeeVo.addPersonalInfo ( personal ) ); } ); } } /** * 员工工作表连接部门表查询 * * @param employeeVoIPage 员工资料视图 */ public void employeeInnerJoinDepartment(IPage<EmployeeVo> employeeVoIPage) { Set<Integer> departmentIds = EntityUtils.toSet ( employeeVoIPage.getRecords (), EmployeeVo::getDepartmentId ); if (departmentIds.size () > 0) { // 将部门名称填入employeeVo