Examples with StockMoveLine com.axelor.apps.stock.db.StockMoveLine used on opensource projects

Example 46 with StockMoveLine

use of com.axelor.apps.stock.db.StockMoveLine in project axelor-open-suite by axelor.

the class MrpServiceProductionImpl method computeQtyLeftToConsume.

protected BigDecimal computeQtyLeftToConsume(List<StockMoveLine> consumedStockMoveLineList, ProdProduct prodProduct) {
    BigDecimal qtyToConsume = prodProduct.getQty();
    BigDecimal consumedQty = consumedStockMoveLineList.stream().filter(stockMoveLine -> stockMoveLine.getStockMove().getStatusSelect() == StockMoveRepository.STATUS_REALIZED && stockMoveLine.getProduct().equals(prodProduct.getProduct())).map(StockMoveLine::getQty).reduce(BigDecimal::add).orElse(BigDecimal.ZERO);
    return qtyToConsume.subtract(consumedQty);
}

Example 47 with StockMoveLine

use of com.axelor.apps.stock.db.StockMoveLine in project axelor-open-suite by axelor.

the class ProductionProductStockLocationServiceImpl method getBuildingQty.

protected BigDecimal getBuildingQty(Product product, Company company, StockLocation stockLocation) throws AxelorException {
    if (product == null || product.getUnit() == null) {
        return BigDecimal.ZERO;
    }
    Long companyId = 0L;
    Long stockLocationId = 0L;
    if (company != null) {
        companyId = company.getId();
        if (stockLocation != null) {
            stockLocationId = stockLocation.getId();
        }
    }
    String query = manufOrderService.getBuildingQtyForAProduct(product.getId(), companyId, stockLocationId);
    List<StockMoveLine> stockMoveLineList = stockMoveLineRepository.all().filter(query).fetch();
    BigDecimal sumBuildingQty = BigDecimal.ZERO;
    if (!stockMoveLineList.isEmpty()) {
        Unit unitConversion = product.getUnit();
        for (StockMoveLine stockMoveLine : stockMoveLineList) {
            BigDecimal productBuildingQty = stockMoveLine.getRealQty();
            unitConversionService.convert(stockMoveLine.getUnit(), unitConversion, productBuildingQty, productBuildingQty.scale(), product);
            sumBuildingQty = sumBuildingQty.add(productBuildingQty);
        }
    }
    return sumBuildingQty;
}

Example 48 with StockMoveLine

use of com.axelor.apps.stock.db.StockMoveLine in project axelor-open-suite by axelor.

the class DeclarationOfExchangesExporterGoods method exportToCSV.

@Override
public String exportToCSV() throws AxelorException {
    Path path = getFilePath();
    Period period = declarationOfExchanges.getPeriod();
    List<StockMoveLine> stockMoveLines = Beans.get(StockMoveLineRepository.class).findForDeclarationOfExchanges(period.getFromDate(), period.getToDate(), declarationOfExchanges.getProductTypeSelect(), declarationOfExchanges.getStockMoveTypeSelect(), declarationOfExchanges.getCountry(), declarationOfExchanges.getCompany()).fetch();
    List<String[]> dataList = new ArrayList<>(stockMoveLines.size());
    int lineNum = 1;
    for (StockMoveLine stockMoveLine : stockMoveLines) {
        String[] data = exportLineToCsv(stockMoveLine, lineNum);
        if (data != null && data.length != 0) {
            dataList.add(data);
            lineNum++;
        }
    }
    try {
        MoreFiles.createParentDirectories(path);
        CsvTool.csvWriter(path.getParent().toString(), path.getFileName().toString(), ';', getTranslatedHeaders(), dataList);
    } catch (IOException e) {
        throw new AxelorException(e, TraceBackRepository.CATEGORY_CONFIGURATION_ERROR, e.getLocalizedMessage());
    }
    return attach(path.toString());
}

Example 49 with StockMoveLine

use of com.axelor.apps.stock.db.StockMoveLine in project axelor-open-suite by axelor.

the class StockMoveLineServiceSupplychainImpl method createStockMoveLine.

@Override
public StockMoveLine createStockMoveLine(Product product, String productName, String description, BigDecimal quantity, BigDecimal requestedReservedQty, BigDecimal unitPrice, BigDecimal companyUnitPriceUntaxed, BigDecimal companyPurchasePrice, Unit unit, StockMove stockMove, int type, boolean taxed, BigDecimal taxRate, SaleOrderLine saleOrderLine, PurchaseOrderLine purchaseOrderLine) throws AxelorException {
    if (product != null) {
        StockMoveLine stockMoveLine = generateStockMoveLineConvertingUnitPrice(product, productName, description, quantity, unitPrice, companyUnitPriceUntaxed, companyPurchasePrice, unit, stockMove, taxed, taxRate);
        stockMoveLine.setRequestedReservedQty(requestedReservedQty);
        stockMoveLine.setIsQtyRequested(requestedReservedQty != null && requestedReservedQty.signum() > 0);
        stockMoveLine.setSaleOrderLine(saleOrderLine);
        stockMoveLine.setPurchaseOrderLine(purchaseOrderLine);
        TrackingNumberConfiguration trackingNumberConfiguration = product.getTrackingNumberConfiguration();
        return assignOrGenerateTrackingNumber(stockMoveLine, stockMove, product, trackingNumberConfiguration, type);
    } else {
        return this.createStockMoveLine(product, productName, description, quantity, BigDecimal.ZERO, BigDecimal.ZERO, companyUnitPriceUntaxed, BigDecimal.ZERO, unit, stockMove, null);
    }
}

Example 50 with StockMoveLine

use of com.axelor.apps.stock.db.StockMoveLine in project axelor-open-suite by axelor.

the class StockLocationLineReservationServiceImpl method deallocateAll.

@Override
@Transactional(rollbackOn = { Exception.class })
public void deallocateAll(StockLocationLine stockLocationLine) throws AxelorException {
    List<StockMoveLine> stockMoveLineList = Beans.get(StockMoveLineRepository.class).all().filter("self.product = :product " + "AND self.stockMove.fromStockLocation = :stockLocation " + "AND self.stockMove.statusSelect = :planned " + "AND (self.stockMove.availabilityRequest IS FALSE " + "OR self.stockMove.availabilityRequest IS NULL) " + "AND self.reservedQty > 0").bind("product", stockLocationLine.getProduct()).bind("stockLocation", stockLocationLine.getStockLocation()).bind("planned", StockMoveRepository.STATUS_PLANNED).fetch();
    for (StockMoveLine stockMoveLine : stockMoveLineList) {
        stockMoveLine.setReservedQty(BigDecimal.ZERO);
        SaleOrderLine saleOrderLine = stockMoveLine.getSaleOrderLine();
        if (saleOrderLine != null) {
            saleOrderLine.setReservedQty(BigDecimal.ZERO);
        }
    }
    Beans.get(ReservedQtyService.class).updateReservedQty(stockLocationLine);
}