基于JAVA springboot + MYSQL +VUE的项目管理系统（含数据库），包括工时统计、原型预览、效果图管理等

package com.oaker.hours.service.impl; import com.baomidou.mybatisplus.enums.SqlLike; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.plugins.Page; import com.baomidou.mybatisplus.service.impl.ServiceImpl; import com.oaker.common.config.AppConfig; import com.oaker.common.constant.HttpStatus; import com.oaker.common.core.domain.entity.SysUser; import com.oaker.common.core.domain.model.LoginUser; import com.oaker.common.core.page.TableDataInfo; import com.oaker.common.exception.ServiceException; import com.oaker.common.utils.DateUtils; import com.oaker.common.utils.FestivalsUtil; import com.oaker.common.utils.SecurityUtils; import com.oaker.hours.doman.columns.Columns; import com.oaker.hours.doman.dto.ProjectHourStatMonthDetailDTO; import com.oaker.hours.doman.dto.ProjectSubHour; import com.oaker.hours.doman.dto.UserHourSaveDTO; import com.oaker.hours.doman.dto.UserHourUpdateDTO; import com.oaker.hours.doman.entity.*; import com.oaker.hours.doman.vo.ProjectHourStatMonthDetail; import com.oaker.hours.doman.vo.UserHourCalendarVO; import com.oaker.hours.doman.vo.UserHourDetailVO; import com.oaker.hours.doman.vo.UserHourExportVO; import com.oaker.hours.doman.vo.UserHourListVO; import com.oaker.hours.doman.vo.UserHourProjectStat; import com.oaker.hours.doman.vo.UserHourStatDetailVO; import com.oaker.hours.doman.vo.UserHourStatVO; import com.oaker.hours.doman.vo.UserProjectShortVO; import com.oaker.hours.enums.LeaveTypeEnum; import com.oaker.hours.enums.ProjectStatusEnum; import com.oaker.hours.enums.UserHourFillStatusEnum; import com.oaker.hours.mapper.MhUserHourMapper; import com.oaker.hours.service.MhHourDetailSubService; import com.oaker.hours.service.MhUserHourService; import com.oaker.system.domain.SysPost; import com.oaker.system.service.SysHolidayService; import com.oaker.system.service.impl.SysPostServiceImpl; import org.apache.commons.collections4.CollectionUtils; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.BeanUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.math.BigDecimal; import java.time.LocalDate; import java.time.temporal.ChronoUnit; import java.time.temporal.TemporalAdjusters; import java.util.ArrayList; import java.util.Collections; import java.util.Date; import java.util.List; import java.util.Map; import java.util.Objects; import java.util.Set; import java.util.stream.Collectors; import java.util.stream.Stream; import static java.util.stream.Collectors.groupingBy; import static java.util.stream.Collectors.toList; /** * @Description : * <功能详细描述> * @author: 须尽欢_____ * @Data : 2021/9/13 14:26 */ @Service public class MhUserHourServiceImpl extends ServiceImpl<MhUserHourMapper, MhUserHour> implements MhUserHourService { @Resource private SysPostServiceImpl postService; @Resource private ProjectServiceImpl projectService; @Resource private MhUserLeaveServiceImpl userLeaveService; @Resource private ProjectHourServiceImpl projectHourService; @Resource private MhHourDetailSubService mhHourDetailSubService; @Resource private MhHourDetailServiceImpl hourDetailService; @Resource private ProjectUserServiceImpl projectUserService; @Resource private MhUserHourMissServiceImpl userHourMissService; @Resource private SysHolidayService sysHolidayService; /** * 1. 写入mh_user_hour 用户工时填报表 * 2. 写入mh_hour_detail工时填报详情表 * 3. 更新mh_project_hour表中已用工时 * 4. 如果mh_user_hour_miss用户缺报记录表 有缺报记录 则执行删除 * * @param userHourSaveDTO * @return */ @Override @Transactional(rollbackFor = Exception.class) public boolean create(UserHourSaveDTO userHourSaveDTO) { Long userId = SecurityUtils.getUserId(); EntityWrapper<MhUserHour> queryWrapper = new EntityWrapper<>(); queryWrapper.eq(Columns.MhUserHour.fillDate, userHourSaveDTO.getDate()) .eq(Columns.MhUserHour.userId, userId); Integer count = baseMapper.selectCount(queryWrapper); if (count > 0) { throw new ServiceException("当前日期已经填报工时，请勿重复提交"); } List<UserHourSaveDTO.ProjectHour> projectHours = userHourSaveDTO.getProjectHours(); BigDecimal total = projectHours.stream() .map(UserHourSaveDTO.ProjectHour::getHour) .reduce(BigDecimal.ZERO, BigDecimal::add); // 工时总数判断 if (total.compareTo(new BigDecimal("24")) > 0) { throw new ServiceException("工时总数不能超过24"); } if (total.compareTo(AppConfig.WORK_TIME) > 0 && !AppConfig.OVERTIME_ALLOW) { throw new ServiceException("提交工时总数超过限定值"); } LocalDate fillDate = userHourSaveDTO.getDate(); Date createTime = new Date(); MhUserHour userHour = new MhUserHour(); userHour.setUserId(userId) .setFillDate(fillDate) .setTotalHour(total) .setCreateTime(createTime); // 1. 写入mh_user_hour 用户工时填报表 baseMapper.insert(userHour); ProjectUser projectUser; MhHourDetail mhHourDetail; // 2. 写入mh_hour_detail工时填报详情表 for (UserHourSaveDTO.ProjectHour projectHour : projectHours) { mhHourDetail = new MhHourDetail(); MhProject mhProject = projectService.selectById(projectHour.getProjectId()); EntityWrapper<ProjectUser> wrapper = new EntityWrapper<>(); wrapper.eq(Columns.ProjectUser.projectId, projectHour.getProjectId()) .and() .eq(Columns.ProjectUser.userId, userId); projectUser = projectUserService.selectOne(wrapper); mhHourDetail.setProjectId(projectHour.getProjectId()) .setUserId(userId) .setUseHour(projectHour.getHour()) .setFillDate(fillDate) .setProjectStatus(mhProject.getProjectStatus()) .setHourId(userHour.getId()) .setEveryday(projectUser.getEveryday()) .setDaily(projectHour.getDaily()) .setCreateTime(createTime); hourDetailService.insert(mhHourDetail); Long detailId =mhHourDetail.getId() ; List<ProjectSubHour> workTypeHourList = projectHour.getWorkTypeHourList(); insertDetailSub(detailId,workTypeHourList); // 3. 更新mh_project_hour表中已用工时 projectHourService.addTotalHour(projectHour.getProjectId(), projectHour.getHour()); } // 4. 如果mh_user_hour_miss用户缺报记录表 有缺报记录 则执行删除 EntityWrapper<MhUserHourMiss> wrapper = new EntityWrapper<>(); wrapper.eq(Columns.MhUserHourMiss.userId, userId) .eq(Columns.MhUserHourMiss.missDate, fillDate); MhUserHourMiss mhUserHourMiss = userHourMissService.selectOne(wrapper); if (!Objects.isNull(mhUserHourMiss)) { userHourMissService.deleteByIdAndDetail(mhUserHourMiss.getId()); } return Boolean.TRUE; } private void insertDetailSub(Long detailId,List<ProjectSubHour> workTypeHourList){ if(CollectionUtils.isEmpty(workTypeHourList)){ return; } List<MhHourDetailSub> subList = new ArrayList<>(); for(ProjectSubHour subHour:workTypeHourList){ MhHourDetailSub sub = new MhHourDetailSub(); sub.setDetailId(detailId); sub.setWorkTypeId(subHour.getWorkTypeId()); sub.setUseHour(subHour.getHour()); sub.setCreateTime(new Date()); subList.add(sub); }