Examples with I_MD_Stock de.metas.material.cockpit.model.I_MD_Stock used on opensource projects

Example 1 with I_MD_Stock

use of de.metas.material.cockpit.model.I_MD_Stock in project metasfresh-webui-api by metasfresh.

the class MaterialCockpitRowFactory method addStockRowsToResult.

private void addStockRowsToResult(@NonNull final CreateRowsRequest request, @NonNull final DimensionSpec dimensionSpec, @NonNull final Map<MainRowBucketId, MainRowWithSubRows> result) {
    for (final I_MD_Stock stockRecord : request.getStockRecords()) {
        final MainRowBucketId mainRowBucketId = MainRowBucketId.createInstanceForStockRecord(stockRecord, request.getDate());
        final MainRowWithSubRows mainRowBucket = result.computeIfAbsent(mainRowBucketId, key -> MainRowWithSubRows.create(key));
        mainRowBucket.addStockRecord(stockRecord, dimensionSpec);
    }
}

Example 2 with I_MD_Stock

use of de.metas.material.cockpit.model.I_MD_Stock in project metasfresh-webui-api by metasfresh.

the class MaterialCockpitRowFactoryTest method createRows_contains_attribute_groups.

/**
 * Verifies that the {@link I_MD_Cockpit} and {@link I_MD_Stock} data rows are correctly applied to {@link MaterialCockpitRow}s based on the given dimension spec.
 * In this test, we have a dimension spec with tree groups, on of them is empty.
 */
@Test
public void createRows_contains_attribute_groups() {
    final I_M_AttributeSetInstance asi1 = newInstance(I_M_AttributeSetInstance.class);
    save(asi1);
    final IAttributeSetInstanceBL attributeSetInstanceBL = Services.get(IAttributeSetInstanceBL.class);
    attributeSetInstanceBL.getCreateAttributeInstance(asi1, attr1_value1);
    attributeSetInstanceBL.getCreateAttributeInstance(asi1, attr2_value1);
    final AttributesKey attributesKeyWithAttr1_and_attr2 = AttributesKeys.createAttributesKeyFromASIAllAttributeValues(asi1.getM_AttributeSetInstance_ID()).get();
    final I_MD_Cockpit cockpitRecordWithAttributes = newInstance(I_MD_Cockpit.class);
    cockpitRecordWithAttributes.setM_Product(product);
    cockpitRecordWithAttributes.setDateGeneral(SystemTime.asTimestamp());
    cockpitRecordWithAttributes.setAttributesKey(attributesKeyWithAttr1_and_attr2.getAsString());
    cockpitRecordWithAttributes.setQtyReserved_Purchase(TEN);
    save(cockpitRecordWithAttributes);
    final AttributesKey attributesKey2 = AttributesKey.NONE;
    final I_MD_Cockpit cockpitRecordWithEmptyAttributesKey = newInstance(I_MD_Cockpit.class);
    cockpitRecordWithEmptyAttributesKey.setM_Product(product);
    cockpitRecordWithEmptyAttributesKey.setDateGeneral(SystemTime.asTimestamp());
    cockpitRecordWithEmptyAttributesKey.setAttributesKey(attributesKey2.getAsString());
    cockpitRecordWithEmptyAttributesKey.setQtyReserved_Purchase(ONE);
    save(cockpitRecordWithEmptyAttributesKey);
    final I_M_Warehouse warehouseWithPlant = createWarehousewithPlant("plantName");
    final I_MD_Stock stockRecordWithAttributes = newInstance(I_MD_Stock.class);
    stockRecordWithAttributes.setM_Product(product);
    stockRecordWithAttributes.setAttributesKey(attributesKeyWithAttr1_and_attr2.getAsString());
    stockRecordWithAttributes.setM_Warehouse(warehouseWithPlant);
    stockRecordWithAttributes.setQtyOnHand(ELEVEN);
    save(stockRecordWithAttributes);
    final I_MD_Stock stockRecordWithEmptyAttributesKey = newInstance(I_MD_Stock.class);
    stockRecordWithEmptyAttributesKey.setM_Product(product);
    stockRecordWithEmptyAttributesKey.setAttributesKey(attributesKey2.getAsString());
    stockRecordWithEmptyAttributesKey.setM_Warehouse(warehouseWithPlant);
    stockRecordWithEmptyAttributesKey.setQtyOnHand(TWELVE);
    save(stockRecordWithEmptyAttributesKey);
    final Timestamp today = TimeUtil.getDay(SystemTime.asTimestamp());
    final CreateRowsRequest request = CreateRowsRequest.builder().date(today).productsToListEvenIfEmpty(ImmutableList.of()).cockpitRecords(ImmutableList.of(cockpitRecordWithAttributes, cockpitRecordWithEmptyAttributesKey)).stockRecords(ImmutableList.of(stockRecordWithAttributes, stockRecordWithEmptyAttributesKey)).build();
    // invoke method under test
    final List<MaterialCockpitRow> result = materialCockpitRowFactory.createRows(request);
    assertThat(result).hasSize(1);
    final MaterialCockpitRow mainRow = result.get(0);
    assertThat(mainRow.getQtyOnHandStock()).isEqualByComparingTo(ELEVEN.add(TWELVE));
    assertThat(mainRow.getQtyReservedPurchase()).isEqualByComparingTo(TEN.add(ONE));
    final List<MaterialCockpitRow> includedRows = mainRow.getIncludedRows();
    // there shall be 4 rows:
    // 2: the cockpitRecordWithAttributes and stockRecordWithAttributes are added to the matching non-empty groups of the dimension spec
    // 1: the cockpit and stock record with the empty attributesKey is added to the empty dimension spec group
    // 1: both stock records are added to a counting record
    assertThat(includedRows).hasSize(4);
    final MaterialCockpitRow emptyGroupRow = extractRowWithDimensionSpecGroup(includedRows, dimensionspecGroup_empty);
    assertThat(emptyGroupRow.getQtyOnHandStock()).isEqualByComparingTo(TWELVE);
    assertThat(emptyGroupRow.getQtyReservedPurchase()).isEqualByComparingTo(ONE);
    final MaterialCockpitRow attr1GroupRow = extractRowWithDimensionSpecGroup(includedRows, dimensionspecGroup_attr1_value1);
    assertThat(attr1GroupRow.getQtyOnHandStock()).isEqualByComparingTo(ELEVEN);
    assertThat(attr1GroupRow.getQtyReservedPurchase()).isEqualByComparingTo(TEN);
    final MaterialCockpitRow attr2GroupRow = extractRowWithDimensionSpecGroup(includedRows, dimensionspecGroup_attr2_value1);
    assertThat(attr2GroupRow.getQtyOnHandStock()).isEqualByComparingTo(ELEVEN);
    assertThat(attr2GroupRow.getQtyReservedPurchase()).isEqualByComparingTo(TEN);
    final MaterialCockpitRow countingRow = extractSingleCountingRow(includedRows);
    assertThat(countingRow.getQtyOnHandStock()).isEqualByComparingTo(ELEVEN.add(TWELVE));
    assertThat(countingRow.getProductCategoryOrSubRowName()).isEqualTo("plantName");
}

Example 3 with I_MD_Stock

use of de.metas.material.cockpit.model.I_MD_Stock in project metasfresh-webui-api by metasfresh.

the class MaterialCockpitRowRepository method retrieveRows.

private List<MaterialCockpitRow> retrieveRows(@NonNull final List<DocumentFilter> filters) {
    final Date date = materialCockpitFilters.getFilterByDate(filters);
    if (date == null) {
        return ImmutableList.of();
    }
    final List<I_MD_Cockpit> cockpitRecords = materialCockpitFilters.createQuery(filters).list();
    final List<I_MD_Stock> stockRecords = StockFilters.createStockQueryFor(filters).list();
    final CreateRowsRequest request = CreateRowsRequest.builder().date(TimeUtil.asTimestamp(date)).productsToListEvenIfEmpty(retrieveRelevantProducts(filters)).cockpitRecords(cockpitRecords).stockRecords(stockRecords).build();
    return materialCockpitRowFactory.createRows(request);
}

Example 4 with I_MD_Stock

use of de.metas.material.cockpit.model.I_MD_Stock in project metasfresh-webui-api by metasfresh.

the class StockFilters method createStockQueryFor.

public static IQuery<I_MD_Stock> createStockQueryFor(@NonNull final List<DocumentFilter> filters) {
    final IQueryBL queryBL = Services.get(IQueryBL.class);
    final IQueryBuilder<I_MD_Stock> queryBuilder = queryBL.createQueryBuilder(I_MD_Stock.class).addOnlyActiveRecordsFilter();
    boolean anyRestrictionAdded = false;
    if (augmentQueryBuilder(queryBuilder, ProductFilterUtil.extractProductFilterVO(filters))) {
        anyRestrictionAdded = true;
    }
    if (anyRestrictionAdded) {
        return queryBuilder.create();
    } else {
        // avoid memory problems in case the filters are accidentally empty
        return queryBuilder.filter(ConstantQueryFilter.of(false)).create();
    }
}