package com.gkhy.hazmat.system.service.impl;
|
|
import cn.hutool.core.date.DatePattern;
|
import cn.hutool.core.date.DateTime;
|
import cn.hutool.core.date.DateUnit;
|
import cn.hutool.core.date.DateUtil;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.gkhy.hazmat.common.api.CommonPage;
|
import com.gkhy.hazmat.common.config.IdTableNameHandler;
|
import com.gkhy.hazmat.common.domain.entity.SysUser;
|
import com.gkhy.hazmat.common.enums.HazmatStatusEnum;
|
import com.gkhy.hazmat.common.enums.UserTypeEnum;
|
import com.gkhy.hazmat.common.exception.ApiException;
|
import com.gkhy.hazmat.common.utils.PageUtils;
|
import com.gkhy.hazmat.common.utils.SecurityUtils;
|
import com.gkhy.hazmat.common.utils.StringUtils;
|
import com.gkhy.hazmat.system.domain.*;
|
import com.gkhy.hazmat.system.domain.vo.HzEntryRecordVO;
|
import com.gkhy.hazmat.system.domain.vo.HzHazmatUseVO;
|
import com.gkhy.hazmat.system.domain.vo.HzHomeDataVO;
|
import com.gkhy.hazmat.system.mapper.*;
|
import com.gkhy.hazmat.system.service.HzStatisticService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
@Service
|
public class HzStatisticServiceImpl implements HzStatisticService {
|
@Autowired
|
private HzEntryRecordMapper entryRecordMapper;
|
@Autowired
|
private HzHazmatMapper hazmatMapper;
|
@Autowired
|
private HzHazmatBasicMapper hazmatBasicMapper;
|
@Autowired
|
private HzWarehouseMapper warehouseMapper;
|
@Autowired
|
private HzWarningMapper warningMapper;
|
|
@Override
|
public List<HzEntryRecordVO> entryStatic() {
|
SysUser currentUser= SecurityUtils.getLoginUser().getUser();
|
Date currentDate=new Date();
|
DateTime endTime = DateUtil.endOfDay(currentDate);
|
DateTime startTime = DateUtil.beginOfDay(DateUtil.offsetDay(currentDate, -29));
|
String startDate= DateUtil.format(startTime, DatePattern.NORM_DATETIME_FORMAT);
|
String endDate=DateUtil.format(endTime,DatePattern.NORM_DATETIME_FORMAT);
|
List<HzEntryRecordVO> dayEntryRecordList=new ArrayList<>();
|
while (DateUtil.compare(startTime,endTime)<0){
|
String day=String.valueOf(DateUtil.dayOfMonth(startTime));
|
HzEntryRecordVO entryRecordVO=new HzEntryRecordVO();
|
entryRecordVO.setCount(0);
|
entryRecordVO.setDay(day);
|
entryRecordVO.setMonth(String.valueOf(DateUtil.month(startTime)+1));
|
dayEntryRecordList.add(entryRecordVO);
|
startTime=DateUtil.offsetDay(startTime,1);
|
}
|
List<HzEntryRecordVO> entryRecordVOList= entryRecordMapper.entryCountStatic(startDate, endDate,currentUser.getCompanyId());
|
if(!entryRecordVOList.isEmpty()) {
|
Map<String, HzEntryRecordVO> resMap = entryRecordVOList.stream().collect(Collectors.toMap(item -> item.getMonth()+"_"+item.getDay(), item -> item));
|
for (HzEntryRecordVO er : dayEntryRecordList) {
|
HzEntryRecordVO entryRecordVO= resMap.get(er.getMonth()+"_"+er.getDay());
|
if (entryRecordVO == null) {
|
continue;
|
}
|
er.setCount(entryRecordVO.getCount());
|
}
|
}
|
return dayEntryRecordList;
|
}
|
|
@Override
|
public List<HzEntryRecordVO> useEverydayStatic() {
|
SysUser currentUser= SecurityUtils.getLoginUser().getUser();
|
checkUserAllowed(currentUser);
|
Date currentDate=new Date();
|
DateTime endTime = DateUtil.endOfDay(currentDate);
|
DateTime startTime = DateUtil.beginOfDay(DateUtil.offsetDay(currentDate, -6));
|
String startDate= DateUtil.format(startTime, DatePattern.NORM_DATETIME_FORMAT);
|
String endDate=DateUtil.format(endTime,DatePattern.NORM_DATETIME_FORMAT);
|
List<HzEntryRecordVO> dayEntryRecordList=new ArrayList<>();
|
while (DateUtil.compare(startTime,endTime)<0){
|
String day=String.valueOf(DateUtil.dayOfMonth(startTime));
|
HzEntryRecordVO entryRecordVO=new HzEntryRecordVO();
|
entryRecordVO.setCount(0);
|
entryRecordVO.setDay(day);
|
dayEntryRecordList.add(entryRecordVO);
|
startTime=DateUtil.offsetDay(startTime,1);
|
}
|
//设置分表id
|
IdTableNameHandler.setCurrentId(currentUser.getCompanyId());
|
List<HzEntryRecordVO> entryRecordVOList= hazmatMapper.useCountEverydayStatic(startDate, endDate,currentUser.getCompanyId());
|
IdTableNameHandler.removeCurrentId();
|
if(!entryRecordVOList.isEmpty()) {
|
Map<String, HzEntryRecordVO> resMap = entryRecordVOList.stream().collect(Collectors.toMap(item -> item.getDay(), item -> item));
|
for (HzEntryRecordVO er : dayEntryRecordList) {
|
if (resMap.get(er.getDay()) == null) {
|
continue;
|
}
|
er.setCount(resMap.get(er.getDay()).getCount());
|
}
|
}
|
return dayEntryRecordList;
|
}
|
|
@Override
|
public List<HzHazmatUseVO> maxUseStatic() {
|
SysUser currentUser= SecurityUtils.getLoginUser().getUser();
|
checkUserAllowed(currentUser);
|
|
Date currentDate=new Date();
|
DateTime endTime = DateUtil.endOfDay(currentDate);
|
DateTime startTime = DateUtil.beginOfDay(DateUtil.offsetDay(currentDate, -6));
|
String startDate= DateUtil.format(startTime, DatePattern.NORM_DATETIME_FORMAT);
|
String endDate=DateUtil.format(endTime,DatePattern.NORM_DATETIME_FORMAT);
|
//设置分表id
|
IdTableNameHandler.setCurrentId(currentUser.getCompanyId());
|
List<HzHazmatUseVO> hazmatUseVOList= hazmatMapper.maxUseCountStatic(startDate, endDate,currentUser.getCompanyId());
|
IdTableNameHandler.removeCurrentId();
|
if(!hazmatUseVOList.isEmpty()) {
|
List<Long> basicIds = hazmatUseVOList.stream().map(HzHazmatUseVO::getBasicId).collect(Collectors.toList());
|
List<HzHazmatBasic> hzHazmatBasicList = hazmatBasicMapper.selectHazmatBasicListByIds(basicIds);
|
Map<Long, HzHazmatBasic> hazmatBasicMap = hzHazmatBasicList.stream().collect(Collectors.toMap(HzHazmatBasic::getId, item -> item));
|
for (HzHazmatUseVO hu : hazmatUseVOList) {
|
HzHazmatBasic hazmatBasic = hazmatBasicMap.get(hu.getBasicId());
|
if (hazmatBasic != null) {
|
hu.setName(hazmatBasic.getName());
|
}
|
}
|
}
|
return hazmatUseVOList;
|
}
|
|
@Override
|
public HzHomeDataVO homeDataStatistic() {
|
SysUser currentUser=SecurityUtils.getLoginUser().getUser();
|
checkUserAllowed(currentUser);
|
Long companyId=currentUser.getCompanyId();
|
Integer warehouseCount= Math.toIntExact(warehouseMapper.selectCount(Wrappers.<HzWarehouse>lambdaQuery()
|
.eq(true, HzWarehouse::getDelFlag, 0)
|
.eq(companyId!=null,HzWarehouse::getCompanyId,companyId)));
|
List<Integer> stateList=new ArrayList<>();
|
stateList.add(HazmatStatusEnum.USED.getCode());
|
stateList.add(HazmatStatusEnum.DISCARD.getCode());
|
//设置分表id
|
IdTableNameHandler.setCurrentId(currentUser.getCompanyId());
|
Integer hazmatCount= Math.toIntExact(hazmatMapper.selectCount(Wrappers.<HzHazmat>lambdaQuery()
|
.notIn(true, HzHazmat::getState, stateList)
|
.eq(companyId!=null,HzHazmat::getCompanyId,companyId)));
|
Integer usedCount= Math.toIntExact(hazmatMapper.selectCount(Wrappers.<HzHazmat>lambdaQuery()
|
.eq(true, HzHazmat::getState, HazmatStatusEnum.USED.getCode())
|
.eq(companyId!=null,HzHazmat::getCompanyId,companyId)));
|
IdTableNameHandler.removeCurrentId();
|
|
Integer warningCount= Math.toIntExact(warningMapper.selectCount(Wrappers.<HzWarning>lambdaQuery()
|
.eq(true, HzWarning::getState,0)
|
.eq(companyId!=null,HzWarning::getCompanyId,companyId)));
|
HzHomeDataVO homeDataVO=new HzHomeDataVO();
|
homeDataVO.setWarehouseCount(warehouseCount);
|
homeDataVO.setHazmatCount(hazmatCount);
|
homeDataVO.setUsedCount(usedCount);
|
homeDataVO.setWarningCount(warningCount);
|
return homeDataVO;
|
}
|
|
|
@Override
|
public CommonPage useStatic(String startTime, String endTime) {
|
SysUser currentUser= SecurityUtils.getLoginUser().getUser();
|
checkUserAllowed(currentUser);
|
|
String startDate="";
|
String endDate="";
|
if(StringUtils.isBlank(startTime)&&StringUtils.isBlank(endTime)){
|
Date currentDate=new Date();
|
startDate= DateUtil.format(DateUtil.beginOfDay(DateUtil.offsetDay(DateUtil.endOfDay(currentDate), -6)), DatePattern.NORM_DATETIME_FORMAT);
|
endDate=DateUtil.format(DateUtil.endOfDay(currentDate),DatePattern.NORM_DATETIME_FORMAT);
|
} else if (StringUtils.isBlank(startTime)&&StringUtils.isNotBlank(endTime)) {
|
startDate= DateUtil.format(DateUtil.beginOfDay(DateUtil.offsetDay(DateUtil.endOfDay(new Date(endTime)), -6)), DatePattern.NORM_DATETIME_FORMAT);
|
endDate=endTime;
|
}else if (StringUtils.isNotBlank(startTime)&&StringUtils.isBlank(endTime)){
|
startDate=startTime;
|
endDate=DateUtil.format(DateUtil.beginOfDay(DateUtil.offsetDay(DateUtil.endOfDay(new Date(endTime)), 6)), DatePattern.NORM_DATETIME_FORMAT);
|
}else{
|
startDate=startTime;
|
endDate=endTime;
|
if(DateUtil.between(new Date(endDate),new Date(startTime), DateUnit.DAY)>90){
|
throw new ApiException("只能查询90天以内数据");
|
}
|
}
|
//设置分表id
|
IdTableNameHandler.setCurrentId(currentUser.getCompanyId());
|
PageUtils.startPage();
|
List<HzHazmatUseVO> hazmatUseVOList= hazmatMapper.useCountStatic(startDate, endDate,currentUser.getCompanyId());
|
IdTableNameHandler.removeCurrentId();
|
if(!hazmatUseVOList.isEmpty()) {
|
List<Long> basicIds = hazmatUseVOList.stream().map(HzHazmatUseVO::getBasicId).collect(Collectors.toList());
|
List<HzHazmatBasic> hzHazmatBasicList = hazmatBasicMapper.selectHazmatBasicListByIds(basicIds);
|
Map<Long, HzHazmatBasic> hazmatBasicMap = hzHazmatBasicList.stream().collect(Collectors.toMap(HzHazmatBasic::getId, item -> item));
|
for (HzHazmatUseVO hu : hazmatUseVOList) {
|
HzHazmatBasic hazmatBasic = hazmatBasicMap.get(hu.getBasicId());
|
if (hazmatBasic != null) {
|
hu.setName(hazmatBasic.getName());
|
hu.setHazmatBasic(hazmatBasic);
|
}
|
}
|
}
|
return CommonPage.restPage(hazmatUseVOList);
|
}
|
|
public void checkUserAllowed(SysUser user) {
|
if (user.getUserType().equals(UserTypeEnum.SYSTEM_USER.getCode())) {
|
throw new ApiException("管理员不能操作");
|
}
|
}
|
}
|
