private Optional<Entity> getGenerateingMRC() { SearchCriteriaBuilder searchCriteriaBuilder = dataDefinitionService.get(OrderSuppliesConstants.PLUGIN_IDENTIFIER, OrderSuppliesConstants.MODEL_MATERIAL_REQUIREMENT_COVERAGE).find(); searchCriteriaBuilder.add(SearchRestrictions.eq("orderGenerationInProgress", true)); List<Entity> entities = searchCriteriaBuilder.list().getEntities(); if (entities.isEmpty()) { return Optional.absent(); } else { return Optional.of(entities.get(0)); } }
@Override public List<ShiftHour> getHoursForAllShifts(final Date dateFrom, final Date dateTo) { List<Entity> shifts = dataDefinitionService.get(BasicConstants.PLUGIN_IDENTIFIER, BasicConstants.MODEL_SHIFT).find() .list().getEntities(); List<ShiftHour> hours = Lists.newArrayList(); for (Entity shift : shifts) { hours.addAll(getHoursForShift(shift, dateFrom, dateTo)); } hours.sort(new ShiftHoursComparator()); return mergeOverlappedHours(hours); }
/** * Deleting coverageProductSelected */ private void deleteSelected() { coverageProductSelectedDataDefinition.find().list().getEntities().forEach(entity -> { coverageProductSelectedDataDefinition.delete(entity.getId()); }); }
private Collection<Long> getContextIds() { DataDefinition dataDef = getDataDefinition(); SearchCriteriaBuilder scb = dataDef.find(); scb.setProjection(SearchProjections.alias(SearchProjections.id(), "id")); List<Long> ids = Lists.newLinkedList(); for (Entity idProjection : scb.list().getEntities()) { ids.add((Long) idProjection.getField("id")); } return ids; }
@Override public List<Entity> getColumnsForCoverages() { return getColumnForCoveragesDD().find().addOrder(SearchOrders.asc(ColumnForCoveragesFields.SUCCESSION)).list() .getEntities(); }
public List<Entity> findRegistryEntries(Entity order) { return dataDefinitionService .get(OrderSuppliesConstants.PLUGIN_IDENTIFIER, OrderSuppliesConstants.MODEL_COVERAGE_REGISTER).find() .add(SearchRestrictions.belongsTo(CoverageRegisterFields.ORDER, order)).list().getEntities(); }
private boolean areSubcontracedOperations(final Entity order) { Entity technology = order.getBelongsToField(OrderFields.TECHNOLOGY); SearchResult searchResult = dataDefinitionService .get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY_OPERATION_COMPONENT).find() .add(SearchRestrictions.belongsTo(TechnologyOperationComponentFields.TECHNOLOGY, technology)) .add(SearchRestrictions.eq(TechnologyOperationComponentFieldsTS.IS_SUBCONTRACTING, true)).list(); return !searchResult.getEntities().isEmpty(); }
@Override public List<Entity> getShiftsWorkingAtDate(final Date date) { return dataDefinitionService.get(BasicConstants.PLUGIN_IDENTIFIER, BasicConstants.MODEL_SHIFT).find() .add(SearchRestrictions.eq(getDayOfWeekName(date) + WORKING_LITERAL, true)).list().getEntities(); }
private List<Entity> getCoverageProductsForOrder(final Entity order) { SearchCriteriaBuilder scb = dataDefinitionService.get(OrderSuppliesConstants.PLUGIN_IDENTIFIER, OrderSuppliesConstants.MODEL_COVERAGE_PRODUCT).find(); scb.add(SearchRestrictions.belongsTo(CoverageProductFields.ORDER, OrdersConstants.PLUGIN_IDENTIFIER, OrdersConstants.MODEL_ORDER, order.getId())); return scb.list().getEntities(); }
public List<Entity> findRegistryEntries(Entity order, Entity product) { return dataDefinitionService .get(OrderSuppliesConstants.PLUGIN_IDENTIFIER, OrderSuppliesConstants.MODEL_COVERAGE_REGISTER).find() .add(SearchRestrictions.belongsTo(CoverageRegisterFields.ORDER, order)) .add(SearchRestrictions.belongsTo(CoverageRegisterFields.PRODUCT, product)).list().getEntities(); }
@Override public boolean isMergedByTocId(Long tocId) { return mergesProductInDD().find() .add(SearchRestrictions.eq(TechnologyOperationComponentMergeProductFields.MERGED_OPERATION_COMPONENT + ".id", tocId)) .add(SearchRestrictions.lt(TechnologyOperationComponentMergeProductFields.QUANTITY_CHANGE, BigDecimal.ZERO)) .list() .getTotalNumberOfEntities() > 0; }
private boolean checkIfProductIsProduced(final Entity order, final Entity product) { return (order .getHasManyField(OrderFieldsBPC.PRODUCTION_COUNTING_QUANTITIES) .find() .add(SearchRestrictions.belongsTo(ProductionCountingQuantityFields.PRODUCT, product)) .add(SearchRestrictions.eq(ProductionCountingQuantityFields.ROLE, ProductionCountingQuantityRole.PRODUCED.getStringValue())).list().getTotalNumberOfEntities() > 0); }
public List<Entity> getProductsToIssue() { return getProductToIssueDD() .find() .createAlias(ProductsToIssueFields.PRODUCT, PRODUCT_ALIAS, JoinType.LEFT) .createAlias(ProductsToIssueFields.WAREHOUSE_ISSUE, WAREHOUSE_ISSUE_ALIAS, JoinType.LEFT) .add(SearchRestrictions.in( getStateField(), Lists.newArrayList(WarehouseIssueState.DRAFT.getStringValue(), WarehouseIssueState.IN_PROGRESS.getStringValue()))) .add(SearchRestrictions.isNotNull(getExternalNumberField())).list().getEntities(); }
private List<Entity> getCoverageProductLoggingCovereges(final Entity coverageProduct, final Date farthestCoverageDate) { return coverageProduct .getHasManyField(CoverageProductFields.COVERAGE_PRODUCT_LOGGINGS) .find() .add(SearchRestrictions.eq(CoverageProductLoggingFields.EVENT_TYPE, CoverageProductLoggingEventType.DELIVERY.getStringValue())) .add(SearchRestrictions.gt(CoverageProductLoggingFields.DATE, farthestCoverageDate)) .addOrder(SearchOrders.asc(CoverageProductLoggingFields.DATE)).list().getEntities(); }
@Override public List<Entity> findMergedToByOperationComponentId(Long operationComponentId) { Entity operationComponent = dataDefinitionService.get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY_OPERATION_COMPONENT).get(operationComponentId); return mergesProductInDD().find() .add(SearchRestrictions.and( SearchRestrictions.belongsTo(TechnologyOperationComponentMergeProductFields.OPERATION_COMPONENT, operationComponent), SearchRestrictions.not( SearchRestrictions.belongsTo(TechnologyOperationComponentMergeProductFields.MERGED_OPERATION_COMPONENT, operationComponent) ))) .list().getEntities(); }
private List<Entity> getTransferTemplates(final Entity locationFrom, final Entity locationTo) { return dataDefinitionService .get(MaterialFlowMultitransfersConstants.PLUGIN_IDENTIFIER, MaterialFlowMultitransfersConstants.MODEL_TRANSFER_TEMPLATE).find().createAlias(PRODUCT, PRODUCT) .add(SearchRestrictions.belongsTo(LOCATION_FROM, locationFrom)) .add(SearchRestrictions.belongsTo(LOCATION_TO, locationTo)).addOrder(SearchOrders.asc(PRODUCT + "." + NAME)) .list().getEntities(); }
private List<Entity> getDraftsOrdersFromDB() { return dataDefinitionService .get(OrdersConstants.PLUGIN_IDENTIFIER, OrdersConstants.MODEL_ORDER) .find() .add(SearchRestrictions.isNotNull(OrderFieldsPC.TYPE_OF_PRODUCTION_RECORDING)) .add(SearchRestrictions.isNotNull(OrderFields.TECHNOLOGY)) .add(SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.PENDING)) .add(SearchRestrictions.eq(OrderFields.ACTIVE, true)).list().getEntities(); } }
private List<Entity> getCoverageProductLoggingDemands(final Entity coverageProduct, final Date farthestCoverageDate) { return coverageProduct .getHasManyField(CoverageProductFields.COVERAGE_PRODUCT_LOGGINGS) .find() .add(SearchRestrictions.or(SearchRestrictions.eq(CoverageProductLoggingFields.EVENT_TYPE, CoverageProductLoggingEventType.ORDER_INPUT.getStringValue()), SearchRestrictions.eq(CoverageProductLoggingFields.EVENT_TYPE, CoverageProductLoggingEventType.OPERATION_INPUT.getStringValue()))) .add(SearchRestrictions.gt(CoverageProductLoggingFields.DATE, farthestCoverageDate)) .addOrder(SearchOrders.asc(CoverageProductLoggingFields.DATE)).list().getEntities(); }
private List<Entity> getOrdersFromDB() { return dataDefinitionService .get(OrdersConstants.PLUGIN_IDENTIFIER, OrdersConstants.MODEL_ORDER) .find() .add(SearchRestrictions.isNotNull(OrderFieldsPC.TYPE_OF_PRODUCTION_RECORDING)) .add(SearchRestrictions.isNotNull(OrderFields.TECHNOLOGY)) .add(SearchRestrictions.or(SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.PENDING), SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.ACCEPTED), SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.IN_PROGRESS), SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.INTERRUPTED))) .add(SearchRestrictions.eq(OrderFields.ACTIVE, true)).list().getEntities(); }
private List<Entity> getOrdersFromDB(final Date coverageToDate) { return dataDefinitionService .get(OrdersConstants.PLUGIN_IDENTIFIER, OrdersConstants.MODEL_ORDER) .find() .add(SearchRestrictions.le(OrderFields.START_DATE, coverageToDate)) .add(SearchRestrictions.isNotNull(OrderFieldsPC.TYPE_OF_PRODUCTION_RECORDING)) .add(SearchRestrictions.isNotNull(OrderFields.TECHNOLOGY)) .add(SearchRestrictions.or(SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.PENDING), SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.ACCEPTED), SearchRestrictions.eq(OrderFields.STATE, OrderStateStringValues.INTERRUPTED))) .add(SearchRestrictions.eq(OrderFields.ACTIVE, true)).list().getEntities(); }