package doumeemes.service.business.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import doumeemes.core.model.ApiResponse;
|
import doumeemes.core.model.LoginUserInfo;
|
import doumeemes.core.model.PageData;
|
import doumeemes.core.model.PageWrap;
|
import doumeemes.core.utils.Constants;
|
import doumeemes.core.utils.DateUtil;
|
import doumeemes.core.utils.Utils;
|
import doumeemes.core.utils.redis.RedisUtil;
|
import doumeemes.dao.business.MaterialMapper;
|
import doumeemes.dao.business.model.*;
|
import doumeemes.dao.ext.MaterialDistributeExtMapper;
|
import doumeemes.service.business.BarcodeParamService;
|
import doumeemes.service.business.MaterialService;
|
import org.apache.commons.lang3.StringUtils;
|
import org.apache.shiro.SecurityUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.redis.core.RedisTemplate;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.util.CollectionUtils;
|
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* 物料基本信息表Service实现
|
* @author 江蹄蹄
|
* @date 2022/04/20 09:34
|
*/
|
@Service
|
public class MaterialServiceImpl implements MaterialService {
|
|
@Autowired
|
private MaterialMapper materialMapper;
|
|
@Autowired
|
private MaterialDistributeServiceImpl materialDistributeService;
|
|
|
@Autowired
|
private RedisTemplate<String, Object> redisTemplate;
|
|
@Autowired
|
private MaterialDistributeExtMapper materialDistributeExtMapper;
|
@Autowired
|
private BomServiceImpl bomServiceimpl;
|
|
@Autowired
|
private BomDetailServiceImpl bomDetailServiceimpl;
|
|
|
@Autowired
|
private BarcodeParamService barcodeParamService;
|
|
|
@Override
|
public Integer create(Material material) {
|
|
LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
material.setDeleted(Constants.ZERO);
|
material.setRootDepartId(user.getRootDepartment().getId());
|
material.setCreateTime(new Date());
|
material.setCreateUser(user.getId());
|
if(StringUtils.isBlank(material.getCode())){
|
material.setCode(this.getNextCode(user.getCompany().getId()));
|
}
|
|
Material findMi=new Material();
|
findMi.setDeleted(Constants.ZERO);
|
findMi.setRootDepartId(user.getRootDepartment().getId());
|
findMi.setCode(material.getCode());
|
List<Material> list=this.findList(findMi);
|
if(list.size()>0){
|
return -1;//主组织内编码不能重复
|
}
|
|
|
//获取二维码规则
|
BarcodeParam queryparam=new BarcodeParam();
|
queryparam.setDepartId(user.getCurComDepartment().getId());
|
queryparam.setRootDepartId(user.getRootDepartment().getId());
|
queryparam.setType(Constants.BARCODEPARAM_TYPE.material);
|
BarcodeParam barcodeParam =barcodeParamService.findOne(queryparam);
|
|
if(barcodeParam!=null){
|
material.setQrcodeId(barcodeParam.getId()+"");
|
}
|
|
|
Material findMi1=new Material();
|
findMi1.setDeleted(Constants.ZERO);
|
findMi1.setRootDepartId(user.getRootDepartment().getId());
|
findMi1.setName(material.getName());
|
List<Material> list1=this.findList(findMi1);
|
if(list1.size()>0){
|
return -2;//主组织内名称不能重复
|
}
|
material.setStatus(Constants.ONE);
|
material.setUnionName(material.getName()+material.getAttr());
|
material.setValidTime(new Date());
|
|
Integer maid= materialMapper.insert(material);
|
|
materialDistributeService.insert(material.getId()+"",user.getRootDepartment().getId()+"");
|
return material.getId();
|
}
|
|
public synchronized String getNextCode(Integer comId ){
|
String prefix = "WL-" + DateUtil.getDate(new Date(),"yyyyMMdd") +"-";
|
Integer countNum = RedisUtil.getObject(redisTemplate,Constants.RedisKeys.COM_MATERIAL_CHECK_KEY+comId,Integer.class);
|
countNum = Constants.formatIntegerNum(countNum)+1;
|
//更新缓存
|
RedisUtil.addObject(redisTemplate,Constants.RedisKeys.COM_MATERIAL_CHECK_KEY+comId,countNum);
|
String nextIndex =Integer.toString( countNum );
|
return prefix + StringUtils.leftPad(nextIndex,4,"0");
|
}
|
|
@Override
|
public void deleteById(Integer id) {
|
materialMapper.deleteById(id);
|
}
|
|
@Override
|
public void delete(Material material) {
|
UpdateWrapper<Material> deleteWrapper = new UpdateWrapper<>(material);
|
materialMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<Integer> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
materialMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public Integer updateById(Material material) {
|
LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
|
|
Material findMi=new Material();
|
findMi.setDeleted(Constants.ZERO);
|
findMi.setRootDepartId(user.getRootDepartment().getId());
|
findMi.setCode(material.getCode());
|
List<Material> list=this.findList(findMi);
|
if(list.size()>0){
|
if(!Constants.equalsInteger(list.get(0).getId(),material.getId())){
|
return -1;//主组织内编码不能重复
|
}
|
}
|
|
Material findMi1=new Material();
|
findMi1.setDeleted(Constants.ZERO);
|
findMi1.setRootDepartId(user.getRootDepartment().getId());
|
findMi1.setName(material.getName());
|
List<Material> list1=this.findList(findMi1);
|
if(list1.size()>0){
|
if(!Constants.equalsInteger(list1.get(0).getId(),material.getId())){
|
return -2;//主组织内名称不能重复
|
}
|
|
}
|
|
Material find=this.findById(material.getId());
|
find.setUpdateTime(new Date());
|
find.setUpdateUser(user.getId());
|
find.setUnionName(material.getName()+material.getAttr());
|
find.setName(material.getName());
|
find.setCode(material.getCode());
|
find.setFormation(material.getFormation());
|
find.setCateUnionId(material.getCateUnionId());
|
find.setAttr(material.getAttr());
|
find.setUnitId(material.getUnitId());
|
find.setDeleted(material.getDeleted());
|
|
|
|
|
|
MaterialDistribute findmd=new MaterialDistribute();
|
findmd.setDeleted(Constants.ZERO);
|
findmd.setRootDepartId(user.getRootDepartment().getId());
|
findmd.setMaterialId(find.getId());
|
List<MaterialDistribute> findList= materialDistributeService.findList(findmd);
|
if(findList.size()>0){
|
for(int d=0;d<findList.size();d++){
|
MaterialDistribute md=findList.get(d);
|
md.setRootDepartId(user.getRootDepartment().getId());
|
md.setUpdateTime(new Date());
|
md.setUpdateUser(user.getId());
|
md.setAttr(find.getAttr());
|
md.setUnionName(find.getUnionName());
|
md.setUnitId(find.getUnitId());
|
md.setCateUnionId(find.getCateUnionId());
|
md.setFormation(find.getFormation());
|
materialDistributeService.updateById(md);
|
}
|
}
|
return materialMapper.updateById(find);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<Material> materials) {
|
if (CollectionUtils.isEmpty(materials)) {
|
return;
|
}
|
for (Material material: materials) {
|
this.updateById(material);
|
}
|
}
|
|
@Override
|
public Material findById(Integer id) {
|
Material material= materialMapper.selectById(id);
|
return material;
|
}
|
|
@Override
|
public Material findOne(Material material) {
|
QueryWrapper<Material> wrapper = new QueryWrapper<>(material);
|
return materialMapper.selectOne(wrapper);
|
}
|
|
@Override
|
public List<Material> findList(Material material) {
|
QueryWrapper<Material> wrapper = new QueryWrapper<>(material);
|
return materialMapper.selectList(wrapper);
|
}
|
|
@Override
|
public PageData<Material> findPage(PageWrap<Material> pageWrap) {
|
IPage<Material> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
QueryWrapper<Material> queryWrapper = new QueryWrapper<>();
|
Utils.MP.blankToNull(pageWrap.getModel());
|
if (pageWrap.getModel().getId() != null) {
|
queryWrapper.lambda().eq(Material::getId, pageWrap.getModel().getId());
|
}
|
if (pageWrap.getModel().getDeleted() != null) {
|
queryWrapper.lambda().eq(Material::getDeleted, pageWrap.getModel().getDeleted());
|
}
|
if (pageWrap.getModel().getCreateUser() != null) {
|
queryWrapper.lambda().eq(Material::getCreateUser, pageWrap.getModel().getCreateUser());
|
}
|
if (pageWrap.getModel().getCreateTime() != null) {
|
queryWrapper.lambda().ge(Material::getCreateTime, Utils.Date.getStart(pageWrap.getModel().getCreateTime()));
|
queryWrapper.lambda().le(Material::getCreateTime, Utils.Date.getEnd(pageWrap.getModel().getCreateTime()));
|
}
|
if (pageWrap.getModel().getUpdateUser() != null) {
|
queryWrapper.lambda().eq(Material::getUpdateUser, pageWrap.getModel().getUpdateUser());
|
}
|
if (pageWrap.getModel().getUpdateTime() != null) {
|
queryWrapper.lambda().ge(Material::getUpdateTime, Utils.Date.getStart(pageWrap.getModel().getUpdateTime()));
|
queryWrapper.lambda().le(Material::getUpdateTime, Utils.Date.getEnd(pageWrap.getModel().getUpdateTime()));
|
}
|
if (pageWrap.getModel().getRemark() != null) {
|
queryWrapper.lambda().eq(Material::getRemark, pageWrap.getModel().getRemark());
|
}
|
if (pageWrap.getModel().getRootDepartId() != null) {
|
queryWrapper.lambda().eq(Material::getRootDepartId, pageWrap.getModel().getRootDepartId());
|
}
|
if (pageWrap.getModel().getName() != null) {
|
queryWrapper.lambda().eq(Material::getName, pageWrap.getModel().getName());
|
}
|
if (pageWrap.getModel().getCode() != null) {
|
queryWrapper.lambda().eq(Material::getCode, pageWrap.getModel().getCode());
|
}
|
if (pageWrap.getModel().getAttr() != null) {
|
queryWrapper.lambda().eq(Material::getAttr, pageWrap.getModel().getAttr());
|
}
|
if (pageWrap.getModel().getUnionName() != null) {
|
queryWrapper.lambda().eq(Material::getUnionName, pageWrap.getModel().getUnionName());
|
}
|
if (pageWrap.getModel().getUnitId() != null) {
|
queryWrapper.lambda().eq(Material::getUnitId, pageWrap.getModel().getUnitId());
|
}
|
if (pageWrap.getModel().getCateUnionId() != null) {
|
queryWrapper.lambda().eq(Material::getCateUnionId, pageWrap.getModel().getCateUnionId());
|
}
|
if (pageWrap.getModel().getFormation() != null) {
|
queryWrapper.lambda().eq(Material::getFormation, pageWrap.getModel().getFormation());
|
}
|
if (pageWrap.getModel().getQrcodeId() != null) {
|
queryWrapper.lambda().eq(Material::getQrcodeId, pageWrap.getModel().getQrcodeId());
|
}
|
if (pageWrap.getModel().getStatus() != null) {
|
queryWrapper.lambda().eq(Material::getStatus, pageWrap.getModel().getStatus());
|
}
|
if (pageWrap.getModel().getValidTime() != null) {
|
queryWrapper.lambda().ge(Material::getValidTime, Utils.Date.getStart(pageWrap.getModel().getValidTime()));
|
queryWrapper.lambda().le(Material::getValidTime, Utils.Date.getEnd(pageWrap.getModel().getValidTime()));
|
}
|
if (pageWrap.getModel().getInvalidTime() != null) {
|
queryWrapper.lambda().ge(Material::getInvalidTime, Utils.Date.getStart(pageWrap.getModel().getInvalidTime()));
|
queryWrapper.lambda().le(Material::getInvalidTime, Utils.Date.getEnd(pageWrap.getModel().getInvalidTime()));
|
}
|
if (pageWrap.getModel().getCheckWay() != null) {
|
queryWrapper.lambda().eq(Material::getCheckWay, pageWrap.getModel().getCheckWay());
|
}
|
if (pageWrap.getModel().getQualityRequire() != null) {
|
queryWrapper.lambda().eq(Material::getQualityRequire, pageWrap.getModel().getQualityRequire());
|
}
|
if (pageWrap.getModel().getCheckNote() != null) {
|
queryWrapper.lambda().eq(Material::getCheckNote, pageWrap.getModel().getCheckNote());
|
}
|
for(PageWrap.SortData sortData: pageWrap.getSorts()) {
|
if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
|
queryWrapper.orderByDesc(sortData.getProperty());
|
} else {
|
queryWrapper.orderByAsc(sortData.getProperty());
|
}
|
}
|
return PageData.from(materialMapper.selectPage(page, queryWrapper));
|
}
|
|
@Override
|
public long count(Material material) {
|
QueryWrapper<Material> wrapper = new QueryWrapper<>(material);
|
return materialMapper.selectCount(wrapper);
|
}
|
|
|
@Override
|
@Transactional
|
public ApiResponse updateMateriaStatus(String ids, String status) {
|
LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
String [] str=ids.split(",");
|
for(String id:str){
|
Material material=this.findById(Integer.valueOf(id));
|
if(material.getStatus()==0){
|
return ApiResponse.failed(material.getCode()+"已经失效，操作失败");
|
}
|
material.setInvalidTime(new Date());
|
material.setStatus(Constants.ZERO);
|
|
|
MaterialDistribute materialDistribute=new MaterialDistribute();
|
materialDistribute.setRootDepartId(user.getRootDepartment().getId());
|
materialDistribute.setMaterialId(Integer.valueOf(id));
|
materialDistribute.setDeleted(Constants.ZERO);
|
List<MaterialDistribute> findmdList= materialDistributeService.findList(materialDistribute);
|
|
|
if(findmdList.size()>0){
|
for(int i=0;i<findmdList.size();i++){
|
MaterialDistribute md=findmdList.get(i);
|
|
if(md.getStatus()==1){
|
md.setInvalidTime(new Date());
|
md.setStatus(Constants.ZERO);
|
}
|
if(material.getStatus()==0){
|
//查询BOM是否关联物料已关联不允许失效
|
BomDetail bomDetail=new BomDetail();
|
bomDetail.setDeleted(Constants.ZERO);
|
bomDetail.setMaterialId(md.getMaterialId());
|
List<BomDetail> bdList= bomDetailServiceimpl.findList(bomDetail);
|
Bom bom=new Bom();
|
bom.setStatus(1);
|
bom.setDeleted(Constants.ZERO);
|
bom.setMaterialId(md.getMaterialId());
|
List<Bom> blist= bomServiceimpl.findList(bom);
|
if(bdList.size()>0||blist.size()>0){
|
return ApiResponse.failed("已关联BOM不允许失效");
|
}
|
}
|
|
}
|
}
|
materialDistributeService.updateByIdInBatch(findmdList);
|
this.updateById(material);
|
}
|
return ApiResponse.success(null);
|
}
|
}
|
