Search in sources :

Example 1 with I_MD_Cockpit

use of de.metas.material.cockpit.model.I_MD_Cockpit 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");
}
Also used : AttributesKey(de.metas.material.event.commons.AttributesKey) IAttributeSetInstanceBL(org.adempiere.mm.attributes.api.IAttributeSetInstanceBL) I_MD_Stock(de.metas.material.cockpit.model.I_MD_Stock) I_M_AttributeSetInstance(org.compiere.model.I_M_AttributeSetInstance) CreateRowsRequest(de.metas.ui.web.material.cockpit.rowfactory.MaterialCockpitRowFactory.CreateRowsRequest) Timestamp(java.sql.Timestamp) I_MD_Cockpit(de.metas.material.cockpit.model.I_MD_Cockpit) I_M_Warehouse(de.metas.handlingunits.model.I_M_Warehouse) MaterialCockpitRow(de.metas.ui.web.material.cockpit.MaterialCockpitRow) Test(org.junit.Test)

Example 2 with I_MD_Cockpit

use of de.metas.material.cockpit.model.I_MD_Cockpit 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);
}
Also used : I_MD_Stock(de.metas.material.cockpit.model.I_MD_Stock) CreateRowsRequest(de.metas.ui.web.material.cockpit.rowfactory.MaterialCockpitRowFactory.CreateRowsRequest) Date(java.util.Date) I_MD_Cockpit(de.metas.material.cockpit.model.I_MD_Cockpit)

Example 3 with I_MD_Cockpit

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

the class MaterialCockpitFiltersTest method createQuery_when_emptyFilters_then_retrieve_nothing.

@Test
public void createQuery_when_emptyFilters_then_retrieve_nothing() {
    final I_X_MRP_ProductInfo_Detail_MV record = newInstance(I_X_MRP_ProductInfo_Detail_MV.class);
    save(record);
    final IQuery<I_MD_Cockpit> query = new MaterialCockpitFilters().createQuery(ImmutableList.of());
    assertThat(query).isNotNull();
    assertThat(query.list()).isEmpty();
}
Also used : MaterialCockpitFilters(de.metas.ui.web.material.cockpit.filters.MaterialCockpitFilters) I_MD_Cockpit(de.metas.material.cockpit.model.I_MD_Cockpit) I_X_MRP_ProductInfo_Detail_MV(de.metas.fresh.model.I_X_MRP_ProductInfo_Detail_MV) Test(org.junit.Test)

Example 4 with I_MD_Cockpit

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

the class MaterialCockpitRowFactory method addCockpitRowsToResult.

private void addCockpitRowsToResult(@NonNull final CreateRowsRequest request, @NonNull final DimensionSpec dimensionSpec, @NonNull final Map<MainRowBucketId, MainRowWithSubRows> result) {
    for (final I_MD_Cockpit cockpitRecord : request.getCockpitRecords()) {
        final MainRowBucketId mainRowBucketId = MainRowBucketId.createInstanceForCockpitRecord(cockpitRecord);
        final MainRowWithSubRows mainRowBucket = result.computeIfAbsent(mainRowBucketId, key -> MainRowWithSubRows.create(key));
        mainRowBucket.addCockpitRecord(cockpitRecord, dimensionSpec);
    }
}
Also used : I_MD_Cockpit(de.metas.material.cockpit.model.I_MD_Cockpit)

Example 5 with I_MD_Cockpit

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

the class MaterialCockpitFilters method createInitialQueryBuilder.

private IQueryBuilder<I_MD_Cockpit> createInitialQueryBuilder() {
    final IQueryBL queryBL = Services.get(IQueryBL.class);
    final IQueryBuilder<I_MD_Cockpit> queryBuilder = queryBL.createQueryBuilder(I_MD_Cockpit.class).addOnlyActiveRecordsFilter();
    return queryBuilder;
}
Also used : IQueryBL(org.adempiere.ad.dao.IQueryBL) I_MD_Cockpit(de.metas.material.cockpit.model.I_MD_Cockpit)

Aggregations

I_MD_Cockpit (de.metas.material.cockpit.model.I_MD_Cockpit)5 I_MD_Stock (de.metas.material.cockpit.model.I_MD_Stock)2 CreateRowsRequest (de.metas.ui.web.material.cockpit.rowfactory.MaterialCockpitRowFactory.CreateRowsRequest)2 Test (org.junit.Test)2 I_X_MRP_ProductInfo_Detail_MV (de.metas.fresh.model.I_X_MRP_ProductInfo_Detail_MV)1 I_M_Warehouse (de.metas.handlingunits.model.I_M_Warehouse)1 AttributesKey (de.metas.material.event.commons.AttributesKey)1 MaterialCockpitRow (de.metas.ui.web.material.cockpit.MaterialCockpitRow)1 MaterialCockpitFilters (de.metas.ui.web.material.cockpit.filters.MaterialCockpitFilters)1 Timestamp (java.sql.Timestamp)1 Date (java.util.Date)1 IQueryBL (org.adempiere.ad.dao.IQueryBL)1 IAttributeSetInstanceBL (org.adempiere.mm.attributes.api.IAttributeSetInstanceBL)1 I_M_AttributeSetInstance (org.compiere.model.I_M_AttributeSetInstance)1