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");
}
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);
}
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();
}
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);
}
}
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;
}
Aggregations