@Override
@Cached(cacheName = I_AD_Message.Table_Name + "#by#" + I_AD_Message.COLUMNNAME_Value)
public I_AD_Message retrieveByValue(@CacheCtx final Properties ctx, final String value) {
final IQueryBuilder<I_AD_Message> queryBuilder =
Services.get(IQueryBL.class)
.createQueryBuilder(I_AD_Message.class)
.setContext(ctx, ITrx.TRXNAME_None);
final ICompositeQueryFilter<I_AD_Message> filters = queryBuilder.getFilters();
filters.addEqualsFilter(I_AD_Message.COLUMNNAME_Value, value);
filters.addOnlyActiveRecordsFilter();
return queryBuilder.create().firstOnly(I_AD_Message.class);
}
private IQueryFilter<I_PP_MRP> createQueryFilter() {
final IContextAware contextProvider = getContextProviderToUse();
final ICompositeQueryFilter<I_PP_MRP> filters =
queryBL.createCompositeQueryFilter(I_PP_MRP.class);
//
// Filter only Active records
final boolean onlyActiveRecords = isOnlyActiveRecords();
if (onlyActiveRecords) {
filters.addOnlyActiveRecordsFilter();
}
//
// Filter by AD_Client_ID
final int adClientId = getAD_Client_ID_ToUse();
if (adClientId >= 0) {
filters.addEqualsFilter(I_PP_MRP.COLUMNNAME_AD_Client_ID, adClientId);
}
//
// Filter by AD_Org_ID
final int adOrgId = getAD_Org_ID_ToUse();
if (adOrgId >= 0) {
filters.addEqualsFilter(I_PP_MRP.COLUMNNAME_AD_Org_ID, adOrgId);
}
//
// Filter by M_Warehouse_ID
final int warehouseId = getM_Warehouse_ID_ToUse();
if (warehouseId > 0) {
filters.addEqualsFilter(I_PP_MRP.COLUMNNAME_M_Warehouse_ID, warehouseId);
}
//
// Filter by Plant (only those lines which have our plant ID or don't have the plant ID set at
// all)
// AIM: Clear separation on plant level (06594)
final Set<Integer> plantIds = getPP_Plant_IDs_ToUse();
if (plantIds != null && !plantIds.isEmpty()) {
filters.addInArrayFilter(I_PP_MRP.COLUMNNAME_S_Resource_ID, plantIds);
}
//
// Filter by M_Product_ID
final int productId = getM_Product_ID_ToUse();
if (productId > 0) {
filters.addEqualsFilter(I_PP_MRP.COLUMNNAME_M_Product_ID, productId);
}
//
// Filter by Product's Low Level Code (LLC)
final int productLLC = getLowLevelCode();
if (productLLC >= 0) {
final IQuery<I_M_Product> productQuery =
queryBL
.createQueryBuilder(I_M_Product.class)
.setContext(contextProvider)
.filter(
new EqualsQueryFilter<I_M_Product>(I_M_Product.COLUMNNAME_LowLevel, productLLC))
.create();
filters.addInSubQueryFilter(
I_PP_MRP.COLUMNNAME_M_Product_ID, I_M_Product.COLUMNNAME_M_Product_ID, productQuery);
}
//
// Filter by TypeMRP
final String typeMRP = getTypeMRP();
if (!Check.isEmpty(typeMRP, true)) {
filters.addEqualsFilter(I_PP_MRP.COLUMNNAME_TypeMRP, typeMRP);
}
//
// Filter by MRPFirmType (i.e. DocStatus)
final MRPFirmType mrpFirmType = getMRPFirmType();
if (mrpFirmType != null) {
final List<String> docStatuses = mrpFirmType.getDocStatuses();
filters.addInArrayFilter(I_PP_MRP.COLUMNNAME_DocStatus, docStatuses);
}
//
// Filter by OrderType (i.e. similar with DocBaseType)
final Set<String> orderTypes = getOrderTypes();
if (!Check.isEmpty(orderTypes)) {
filters.addInArrayFilter(I_PP_MRP.COLUMNNAME_OrderType, orderTypes);
}
//
// Filter by DatePromised
final Date datePromisedMax = getDatePromisedMax();
if (datePromisedMax != null) {
filters.addCompareFilter(
I_PP_MRP.COLUMNNAME_DatePromised, Operator.LessOrEqual, datePromisedMax);
}
//
// Filter Non Zero Qty
final boolean qtyNotZero = isQtyNotZero();
if (qtyNotZero) {
filters.addNotEqualsFilter(I_PP_MRP.COLUMNNAME_Qty, BigDecimal.ZERO);
}
//
// Filter by IsAvailable flag
final Boolean mrpAvailable = getMRPAvailable();
if (mrpAvailable != null) {
filters.addEqualsFilter(I_PP_MRP.COLUMNNAME_IsAvailable, mrpAvailable);
}
//
// Filter by Referenced Model
// i.e. Only those MRP records which are referencing our model
final Object referencedModel = getReferencedModel();
if (referencedModel != null) {
final String modelTableName = InterfaceWrapperHelper.getModelTableName(referencedModel);
final String modelKeyColumnName = modelTableName + "_ID";
final int modelId = InterfaceWrapperHelper.getId(referencedModel);
filters.addEqualsFilter(modelKeyColumnName, modelId);
}
//
// Filter only those MRP lines where PP_Product_BOMLine_ID is not set
if (_ppOrderBOMLine_Null) {
filters.addEqualsFilter(I_PP_MRP.COLUMN_PP_Order_BOMLine_ID, null);
}
//
// Filter by specific PP_MRP_IDs
final Set<Integer> mrpIds = getOnlyPP_MRP_IDs();
if (mrpIds != null && !mrpIds.isEmpty()) {
filters.addInArrayFilter(I_PP_MRP.COLUMNNAME_PP_MRP_ID, mrpIds);
}
//
// Filter by enforced MRP demand, i.e.
// * accept only MRP demand records which have the enforced MRP Demand ID
// * or accept only MRP supply records which are allocated to the enforced MRP Demand ID
if (_enforced_PP_MRP_Demand_ID > 0) {
final ICompositeQueryFilter<I_PP_MRP> filterMRPDemands =
queryBL
.createCompositeQueryFilter(I_PP_MRP.class)
.setJoinAnd()
.addEqualsFilter(I_PP_MRP.COLUMNNAME_TypeMRP, X_PP_MRP.TYPEMRP_Demand)
.addEqualsFilter(I_PP_MRP.COLUMNNAME_PP_MRP_ID, _enforced_PP_MRP_Demand_ID);
final IQuery<I_PP_MRP_Alloc> mrpSuppliesSubQuery =
queryBL
.createQueryBuilder(I_PP_MRP.class)
.setContext(contextProvider)
.filter(filterMRPDemands)
.andCollectChildren(I_PP_MRP_Alloc.COLUMN_PP_MRP_Demand_ID, I_PP_MRP_Alloc.class)
.create();
final ICompositeQueryFilter<I_PP_MRP> filterMRPSupplies =
queryBL
.createCompositeQueryFilter(I_PP_MRP.class)
.setJoinAnd()
.addEqualsFilter(I_PP_MRP.COLUMNNAME_TypeMRP, X_PP_MRP.TYPEMRP_Supply)
.addInSubQueryFilter(
I_PP_MRP.COLUMN_PP_MRP_ID,
I_PP_MRP_Alloc.COLUMN_PP_MRP_Supply_ID,
mrpSuppliesSubQuery);
final ICompositeQueryFilter<I_PP_MRP> filterEnforcedMRPDemand =
queryBL
.createCompositeQueryFilter(I_PP_MRP.class)
.setJoinOr()
.addFilter(filterMRPDemands)
.addFilter(filterMRPSupplies);
filters.addFilter(filterEnforcedMRPDemand);
}
//
// Apply MRP_Exclude filters
if (_skipIfMRPExcluded) {
final IQueryFilter<I_PP_MRP> skipIfMRPExcludedFilters = createQueryFilter_MRP_Exclude();
filters.addFilter(skipIfMRPExcludedFilters);
}
//
// Return built filters
return filters;
}
