package org.jeecg.modules.mdc.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import org.apache.commons.lang.StringUtils;
|
import org.apache.shiro.SecurityUtils;
|
import org.jeecg.common.system.vo.LoginUser;
|
import org.jeecg.modules.mdc.entity.MdcPartProcessInfo;
|
import org.jeecg.modules.mdc.mapper.MdcPartProcessInfoMapper;
|
import org.jeecg.modules.mdc.service.IMdcEquipmentService;
|
import org.jeecg.modules.mdc.service.IMdcPartProcessInfoService;
|
import org.jeecg.modules.mdc.vo.MdcPartProcessInfoVo;
|
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
|
import org.jeecgframework.poi.excel.entity.ExportParams;
|
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.servlet.ModelAndView;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import java.util.ArrayList;
|
import java.util.Collections;
|
import java.util.List;
|
|
/**
|
* @Description: 零件加工数据表
|
* @Author: lius
|
* @Date: 2024-12-11
|
*/
|
@Service
|
public class MdcPartProcessInfoServiceImpl extends ServiceImpl<MdcPartProcessInfoMapper, MdcPartProcessInfo> implements IMdcPartProcessInfoService {
|
|
@Resource
|
private IMdcEquipmentService mdcEquipmentService;
|
|
/**
|
* 分页查询
|
*
|
* @param userId
|
* @param page
|
* @param mdcPartProcessInfo
|
* @param req
|
* @return
|
*/
|
@Override
|
public IPage<MdcPartProcessInfo> pageList(String userId, Page<MdcPartProcessInfo> page, MdcPartProcessInfoVo mdcPartProcessInfo, HttpServletRequest req) {
|
List<String> equipmentIds = new ArrayList<>();
|
if (StringUtils.isNotEmpty(mdcPartProcessInfo.getParentId()) && StringUtils.isEmpty(mdcPartProcessInfo.getEquipmentId())) {
|
if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
|
//部门层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, mdcPartProcessInfo.getParentId());
|
} else {
|
//产线层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, mdcPartProcessInfo.getParentId());
|
}
|
} else if (StringUtils.isNotEmpty(mdcPartProcessInfo.getEquipmentId())) {
|
//单台设备信息
|
mdcPartProcessInfo.setEquipmentIdList(Collections.singletonList(mdcPartProcessInfo.getEquipmentId()));
|
} else {
|
//查询用户拥有的所有设备信息
|
if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
|
//部门层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null);
|
} else {
|
//产线层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null);
|
}
|
}
|
|
if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
|
mdcPartProcessInfo.setEquipmentIdList(equipmentIds);
|
}
|
|
if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
|
return null;
|
}
|
return this.baseMapper.pageList(page, mdcPartProcessInfo);
|
}
|
|
@Override
|
public boolean addPartProcess(MdcPartProcessInfoVo mdcPartProcessInfo) {
|
String[] equipmentIdList = mdcPartProcessInfo.getEquipmentIds().split(",");
|
List<MdcPartProcessInfo> partProcessInfoList = new ArrayList<>();
|
for (String equipmentId : equipmentIdList) {
|
MdcPartProcessInfo mppi = new MdcPartProcessInfo();
|
BeanUtils.copyProperties(mdcPartProcessInfo, mppi);
|
mppi.setEquipmentId(equipmentId);
|
partProcessInfoList.add(mppi);
|
}
|
this.saveBatch(partProcessInfoList);
|
return true;
|
}
|
|
@Override
|
public ModelAndView exportXls(String userId, MdcPartProcessInfoVo mdcPartProcessInfo) {
|
LambdaQueryWrapper<MdcPartProcessInfo> queryWrapper = new LambdaQueryWrapper<>();
|
List<String> equipmentIds = new ArrayList<>();
|
if (StringUtils.isNotEmpty(mdcPartProcessInfo.getParentId()) && StringUtils.isEmpty(mdcPartProcessInfo.getEquipmentId())) {
|
if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
|
//部门层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, mdcPartProcessInfo.getParentId());
|
} else {
|
//产线层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, mdcPartProcessInfo.getParentId());
|
}
|
} else if (StringUtils.isNotEmpty(mdcPartProcessInfo.getEquipmentId())) {
|
//单台设备信息
|
mdcPartProcessInfo.setEquipmentIdList(Collections.singletonList(mdcPartProcessInfo.getEquipmentId()));
|
} else {
|
//查询用户拥有的所有设备信息
|
if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
|
//部门层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null);
|
} else {
|
//产线层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null);
|
}
|
}
|
|
if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
|
mdcPartProcessInfo.setEquipmentIdList(equipmentIds);
|
}
|
|
if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
|
return null;
|
} else {
|
queryWrapper.in(MdcPartProcessInfo::getEquipmentId, mdcPartProcessInfo.getEquipmentIdList());
|
}
|
if (StringUtils.isNotEmpty(mdcPartProcessInfo.getEquipmentId())) {
|
queryWrapper.eq(MdcPartProcessInfo::getEquipmentId, mdcPartProcessInfo.getEquipmentId());
|
}
|
if (StringUtils.isNotEmpty(mdcPartProcessInfo.getPartId())) {
|
queryWrapper.eq(MdcPartProcessInfo::getPartId, mdcPartProcessInfo.getPartId());
|
}
|
if (StringUtils.isNotEmpty(mdcPartProcessInfo.getStartTime()) && StringUtils.isNotEmpty(mdcPartProcessInfo.getEndTime())) {
|
queryWrapper.between(MdcPartProcessInfo::getTheDate, mdcPartProcessInfo.getStartTime(), mdcPartProcessInfo.getEndTime());
|
}
|
queryWrapper.orderByDesc(MdcPartProcessInfo::getTheDate).orderByDesc(MdcPartProcessInfo::getEquipmentId);
|
ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
|
List<MdcPartProcessInfo> mdcPartProcessInfos = this.baseMapper.selectList(queryWrapper);
|
// 导出文件名称
|
mv.addObject(NormalExcelConstants.FILE_NAME, "零件加工数据列表");
|
mv.addObject(NormalExcelConstants.CLASS, MdcPartProcessInfo.class);
|
LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
|
mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("零件加工数据列表数据", "导出人:" + user.getRealname(), "零件加工数据"));
|
//update-end---author:wangshuai ---date:20211227 for：[JTC-116]导出人写死了------------
|
mv.addObject(NormalExcelConstants.DATA_LIST, mdcPartProcessInfos);
|
return mv;
|
}
|
|
/**
|
* 查询设备某天总加工时间
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
@Override
|
public Integer selectTotalProcessLong(String equipmentId, String validDate) {
|
Integer totalProcessLong = this.baseMapper.selectTotalProcessLong(equipmentId, validDate);
|
if (totalProcessLong == null) {
|
return 0;
|
} else {
|
return totalProcessLong;
|
}
|
}
|
|
/**
|
* 查询设备某天总加工数量
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
@Override
|
public Integer selectTotalProcessCount(String equipmentId, String validDate) {
|
Integer totalProcessCount = this.baseMapper.selectTotalProcessCount(equipmentId, validDate);
|
if (totalProcessCount == null) {
|
return 0;
|
} else {
|
return totalProcessCount;
|
}
|
}
|
|
/**
|
* 查询设备某天总加工合格数量
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
@Override
|
public Integer selectTotalPassCount(String equipmentId, String validDate) {
|
Integer totalPassCount = this.baseMapper.selectTotalPassCount(equipmentId, validDate);
|
if (totalPassCount == null) {
|
return 0;
|
} else {
|
return totalPassCount;
|
}
|
}
|
}
|
