package com.jsh.erp.service.impl; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.jsh.erp.constants.BusinessConstants; import com.jsh.erp.constants.ExceptionConstants; import com.jsh.erp.datasource.entities.Material; import com.jsh.erp.datasource.entities.Unit; import com.jsh.erp.datasource.entities.UnitExample; import com.jsh.erp.datasource.entities.User; import com.jsh.erp.datasource.mappers.MaterialMapperEx; import com.jsh.erp.datasource.mappers.UnitMapper; import com.jsh.erp.datasource.mappers.UnitMapperEx; import com.jsh.erp.datasource.vo.UnitListVo; import com.jsh.erp.exception.BusinessRunTimeException; import com.jsh.erp.exception.JshException; import com.jsh.erp.service.LogService; import com.jsh.erp.service.UnitService; import com.jsh.erp.service.UserService; import com.jsh.erp.utils.PageUtils; import com.jsh.erp.utils.StringUtil; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.context.request.RequestContextHolder; import org.springframework.web.context.request.ServletRequestAttributes; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.List; @Service public class UnitServiceImpl extends ServiceImpl implements UnitService { private Logger logger = LoggerFactory.getLogger(UnitServiceImpl.class); @Resource private UnitMapper unitMapper; @Resource private UnitMapperEx unitMapperEx; @Resource private UserService userService; @Resource private LogService logService; @Resource private MaterialMapperEx materialMapperEx; @Override public Unit getUnit(long id) { Unit result=null; try{ result=unitMapper.selectByPrimaryKey(id); }catch(Exception e){ JshException.readFail(logger, e); } return result; } @Override public List getUnitListByIds(String ids) { List idList = StringUtil.strToLongList(ids); List list = new ArrayList<>(); try{ UnitExample example = new UnitExample(); example.createCriteria().andIdIn(idList); list = unitMapper.selectByExample(example); }catch(Exception e){ JshException.readFail(logger, e); } return list; } /** * 所有单位集合 */ @Override public List unitList() { UnitExample example = new UnitExample(); example.createCriteria().andEnabledEqualTo(true).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED); List list = null; try{ list = unitMapper.selectByExample(example); }catch(Exception e){ JshException.readFail(logger, e); } return list; } @Override public List select(String name)throws Exception { List list=null; try{ PageUtils.startPage(); list=unitMapperEx.selectByConditionUnit(name); }catch(Exception e){ JshException.readFail(logger, e); } return list; } /** * 新增单位 * @param unit 单位 */ @Override public int insertUnit(Unit unit, HttpServletRequest request)throws Exception { int result=0; try{ unit.setEnabled(true); result=unitMapper.insertSelective(unit); logService.insertLog("多单位", new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_ADD).append(unit.getName()).toString(), request); }catch(Exception e){ JshException.writeFail(logger, e); } return result; } /** * 修改单位 * @param unit 单位 */ @Override public int updateUnit(Unit unit, HttpServletRequest request) { int result=0; try{ result = unitMapper.updateByPrimaryKeySelective(unit); logService.insertLog("多单位", new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_EDIT).append(unit.getName()).toString(), request); }catch(Exception e){ JshException.writeFail(logger, e); } return result; } /** * 根据单位信息生成名称的格式 * @param unit */ private void parseNameByUnit(Unit unit) { String unitName = unit.getBasicUnit() + "/" + "(" + unit.getOtherUnit() + "=" + unit.getRatio().toString() + unit.getBasicUnit() + ")"; if(StringUtil.isNotEmpty(unit.getOtherUnitTwo()) && unit.getRatioTwo()!=null) { unitName += "/" + "(" + unit.getOtherUnitTwo() + "=" + unit.getRatioTwo().toString() + unit.getBasicUnit() + ")"; if(StringUtil.isNotEmpty(unit.getOtherUnitThree()) && unit.getRatioThree()!=null) { unitName += "/" + "(" + unit.getOtherUnitThree() + "=" + unit.getRatioThree().toString() + unit.getBasicUnit() + ")"; } } unit.setName(unitName); } /** * 删除单位 * @param id 单位id * @param request */ @Override public int deleteUnit(Long id, HttpServletRequest request) { return batchDeleteUnitByIds(id.toString()); } /** * 批量删除单位 * @param ids 单位id字符集 * @param request */ @Override public int batchDeleteUnit(String ids, HttpServletRequest request){ return batchDeleteUnitByIds(ids); } /** * 检查单位名称是否存在 * @param name 单位名称 * @return 单位数量 */ @Override public int checkIsNameExist(String name) { UnitExample example = new UnitExample(); example.createCriteria().andNameEqualTo(name.replaceAll(" ", "")).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED); List list = null; try{ list = unitMapper.selectByExample(example); }catch(Exception e){ JshException.readFail(logger, e); } return list == null ? 0 : list.size(); } /** * 根据条件查询单位id * @param basicUnit * @param otherUnit * @param ratio * @return */ @Override public Long getUnitIdByParam(String basicUnit, String otherUnit, BigDecimal ratio){ Long unitId = null; UnitExample example = new UnitExample(); example.createCriteria().andBasicUnitEqualTo(basicUnit).andOtherUnitEqualTo(otherUnit).andRatioEqualTo(ratio) .andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED); List list = unitMapper.selectByExample(example); if(list!=null && list.size()>0) { unitId = list.get(0).getId(); } return unitId; } /** * 根据多单位的比例进行库存换算(保留两位小数) * @param stock * @param unitInfo * @param materialUnit * @return */ @Override public BigDecimal parseStockByUnit(BigDecimal stock, Unit unitInfo, String materialUnit) { if(materialUnit.equals(unitInfo.getOtherUnit()) && unitInfo.getRatio()!=null && unitInfo.getRatio().compareTo(BigDecimal.ZERO)!=0) { stock = stock.divide(unitInfo.getRatio(),2,BigDecimal.ROUND_HALF_UP); } if(materialUnit.equals(unitInfo.getOtherUnitTwo()) && unitInfo.getRatioTwo()!=null && unitInfo.getRatioTwo().compareTo(BigDecimal.ZERO)!=0) { stock = stock.divide(unitInfo.getRatioTwo(),2,BigDecimal.ROUND_HALF_UP); } if(materialUnit.equals(unitInfo.getOtherUnitThree()) && unitInfo.getRatioThree()!=null && unitInfo.getRatioThree().compareTo(BigDecimal.ZERO)!=0) { stock = stock.divide(unitInfo.getRatioThree(),2,BigDecimal.ROUND_HALF_UP); } return stock; } /** * 根据多单位的比例进行单价换算(保留两位小数),变大 * @param unitPrice * @param unitInfo * @param materialUnit * @return */ @Override public BigDecimal parseUnitPriceByUnit(BigDecimal unitPrice, Unit unitInfo, String materialUnit) { if (materialUnit.equals(unitInfo.getOtherUnit()) && unitInfo.getRatio() != null && unitInfo.getRatio().compareTo(BigDecimal.ZERO) != 0) { unitPrice = unitPrice.multiply(unitInfo.getRatio()); } if (materialUnit.equals(unitInfo.getOtherUnitTwo()) && unitInfo.getRatioTwo() != null && unitInfo.getRatioTwo().compareTo(BigDecimal.ZERO) != 0) { unitPrice = unitPrice.multiply(unitInfo.getRatioTwo()); } if (materialUnit.equals(unitInfo.getOtherUnitThree()) && unitInfo.getRatioThree() != null && unitInfo.getRatioThree().compareTo(BigDecimal.ZERO) != 0) { unitPrice = unitPrice.multiply(unitInfo.getRatioThree()); } return unitPrice; } /** * 根据多单位的比例进行总金额换算(保留两位小数),变小 * @param allPrice * @param unitInfo * @param materialUnit * @return */ @Override public BigDecimal parseAllPriceByUnit(BigDecimal allPrice, Unit unitInfo, String materialUnit) { if (materialUnit.equals(unitInfo.getOtherUnit()) && unitInfo.getRatio() != null && unitInfo.getRatio().compareTo(BigDecimal.ZERO) != 0) { allPrice = allPrice.divide(unitInfo.getRatio(), 2, BigDecimal.ROUND_HALF_UP); } if (materialUnit.equals(unitInfo.getOtherUnitTwo()) && unitInfo.getRatioTwo() != null && unitInfo.getRatioTwo().compareTo(BigDecimal.ZERO) != 0) { allPrice = allPrice.divide(unitInfo.getRatioTwo(), 2, BigDecimal.ROUND_HALF_UP); } if (materialUnit.equals(unitInfo.getOtherUnitThree()) && unitInfo.getRatioThree() != null && unitInfo.getRatioThree().compareTo(BigDecimal.ZERO) != 0) { allPrice = allPrice.divide(unitInfo.getRatioThree(), 2, BigDecimal.ROUND_HALF_UP); } return allPrice; } /** * 批量设置状态 * @param status 状态 * @param ids 单位id */ @Override public int batchSetStatus(Boolean status, String ids){ logService.insertLog("多单位", new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_ENABLED).toString(), ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest()); List unitIds = StringUtil.strToLongList(ids); Unit unit = new Unit(); unit.setEnabled(status); UnitExample example = new UnitExample(); example.createCriteria().andIdIn(unitIds); int result=0; try{ result = unitMapper.updateByExampleSelective(unit, example); }catch(Exception e){ JshException.writeFail(logger, e); } return result; } /** * 根据单位id获取单位值集合 * @param id 单位id */ @Override public List getUnitListByID(Long id){ Unit unit = unitMapper.selectByPrimaryKey(id); List list = new ArrayList(); UnitListVo unitListVo = new UnitListVo().setName(unit.getBasicUnit()).setRatio(new BigDecimal("1")); list.add(unitListVo); if (unit.getOtherUnit() != null){ UnitListVo vo = new UnitListVo().setName(unit.getOtherUnit()).setRatio(unit.getRatio()); list.add(vo); } if (unit.getOtherUnitTwo() != null){ UnitListVo vo = new UnitListVo().setName(unit.getOtherUnitTwo()).setRatio(unit.getRatioTwo()); list.add(vo); } if (unit.getOtherUnitThree() != null){ UnitListVo vo = new UnitListVo().setName(unit.getOtherUnitThree()).setRatio(unit.getRatioThree()); list.add(vo); } return list; } /** * 批量删除多单位 * @param ids * @return * @throws Exception */ private int batchDeleteUnitByIds(String ids) { int result=0; String [] idArray = ids.split(","); //校验产品表 jsh_material // List materialList = null; // try{ // materialList = materialMapperEx.getMaterialListByUnitIds(idArray); // }catch(Exception e){ // JshException.readFail(logger, e); // } // if(materialList!=null&&materialList.size()>0){ // logger.error("异常码[{}],异常提示[{}],参数,UnitIds[{}]", // ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,ExceptionConstants.DELETE_FORCE_CONFIRM_MSG,ids); // throw new BusinessRunTimeException(ExceptionConstants.DELETE_FORCE_CONFIRM_CODE, // ExceptionConstants.DELETE_FORCE_CONFIRM_MSG); // } //记录日志 StringBuffer sb = new StringBuffer(); sb.append(BusinessConstants.LOG_OPERATION_TYPE_DELETE); List list = getUnitListByIds(ids); for(Unit unit: list){ sb.append("[").append(unit.getName()).append("]"); } logService.insertLog("多单位", sb.toString(), ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest()); User userInfo = userService.getCurrentUser(); //校验通过执行删除操作 try{ result = unitMapperEx.batchDeleteUnitByIds(new Date(),userInfo == null ? null : userInfo.getId(),idArray); }catch(Exception e){ JshException.writeFail(logger, e); } return result; } }