public boolean checkIfCustomTranslationIsUnique(
      final DataDefinition customTranslationDD, final Entity customTranslation) {
    String pluginIdentifier = customTranslation.getStringField(PLUGIN_IDENTIFIER);
    String locale = customTranslation.getStringField(LOCALE);
    String key = customTranslation.getStringField(KEY);

    SearchCriteriaBuilder searchCriteriaBuilder =
        customTranslationDD
            .find()
            .add(SearchRestrictions.eq(PLUGIN_IDENTIFIER, pluginIdentifier))
            .add(SearchRestrictions.eq(LOCALE, locale))
            .add(SearchRestrictions.eq(KEY, key));

    if (customTranslation.getId() != null) {
      searchCriteriaBuilder.add(SearchRestrictions.ne("id", customTranslation.getId()));
    }

    SearchResult searchResult = searchCriteriaBuilder.list();

    if (!searchResult.getEntities().isEmpty()) {
      customTranslation.addError(
          customTranslationDD.getField(KEY),
          "customTranslation.customTranslation.error.customTranslationIsntUnique");

      return false;
    }

    return true;
  }
  public void checkIfExistsFinalRecord(final StateChangeContext stateChangeContext) {
    final Entity productionTracking = stateChangeContext.getOwner();
    final Entity order = productionTracking.getBelongsToField(ProductionTrackingFields.ORDER);
    final String typeOfProductionRecording =
        order.getStringField(OrderFieldsPC.TYPE_OF_PRODUCTION_RECORDING);

    final SearchCriteriaBuilder searchBuilder = productionTracking.getDataDefinition().find();
    searchBuilder.add(
        SearchRestrictions.eq(
            ProductionTrackingFields.STATE, ProductionTrackingStateStringValues.ACCEPTED));
    searchBuilder.add(SearchRestrictions.belongsTo(ProductionTrackingFields.ORDER, order));
    searchBuilder.add(SearchRestrictions.eq(ProductionTrackingFields.LAST_TRACKING, true));

    if (productionCountingService.isTypeOfProductionRecordingForEach(typeOfProductionRecording)) {
      searchBuilder.add(
          SearchRestrictions.belongsTo(
              ProductionTrackingFields.TECHNOLOGY_OPERATION_COMPONENT,
              productionTracking.getBelongsToField(
                  ProductionTrackingFields.TECHNOLOGY_OPERATION_COMPONENT)));
    }

    if (searchBuilder.list().getTotalNumberOfEntities() != 0) {
      stateChangeContext.addValidationError(
          "productionCounting.productionTracking.messages.error.finalExists");
    }
  }
예제 #3
0
    public void autompleteSearch(final String[] args) {
      if ((belongsToFieldDefinition == null || belongsToEntityId != null)) {
        SearchCriteriaBuilder searchCriteriaBuilder = getDataDefinition().find();

        if (StringUtils.hasText(currentCode)) {
          searchCriteriaBuilder.add(
              SearchRestrictions.ilike(fieldCode, currentCode, SearchMatchMode.ANYWHERE));
        }

        if (belongsToFieldDefinition != null
            && belongsToEntityId != null
            && belongsToFieldDefinition.getType() instanceof BelongsToType) {
          BelongsToType type = (BelongsToType) belongsToFieldDefinition.getType();
          searchCriteriaBuilder.add(
              SearchRestrictions.belongsTo(
                  belongsToFieldDefinition.getName(),
                  type.getDataDefinition().get(belongsToEntityId)));
        }

        if (getDataDefinition().isActivable()) {
          if (oldSelectedEntityId == null) {
            searchCriteriaBuilder.add(SearchRestrictions.eq("active", true));
          } else {
            searchCriteriaBuilder.add(
                SearchRestrictions.or(
                    SearchRestrictions.eq("active", true),
                    SearchRestrictions.idEq(oldSelectedEntityId)));
          }
        }

        searchCriteriaBuilder.addOrder(SearchOrders.asc(fieldCode));

        if (criteriaModifier != null) {
          criteriaModifier.modifyCriteria(searchCriteriaBuilder, criteriaModifierParameter);
        }

        SearchResult results = searchCriteriaBuilder.list();

        autocompleteEntitiesNumber = results.getTotalNumberOfEntities();

        if (results.getTotalNumberOfEntities() > 25) {
          autocompleteMatches = new LinkedList<Entity>();
        } else {
          autocompleteMatches = results.getEntities();
        }
      } else {
        autocompleteMatches = new LinkedList<Entity>();
      }

      autocompleteCode = currentCode;
      requestRender();
    }
 public Entity findDictionaryItemByTechnicalCode(final String technicalCode) {
   return dataDefinitionService
       .get("qcadooModel", "dictionaryItem")
       .find()
       .add(SearchRestrictions.eq(TECHNICAL_CODE, technicalCode))
       .uniqueResult();
 }
 protected Entity findDictionaryItemByName(final String name) {
   return dataDefinitionService
       .get("qcadooModel", "dictionaryItem")
       .find()
       .add(SearchRestrictions.eq(NAME, name))
       .uniqueResult();
 }
예제 #6
0
 private Entity findAddressTypeDictionary() {
   return getDictionaryDD()
       .find()
       .add(SearchRestrictions.eq(DictionaryFields.NAME, L_ADDRESS_TYPE))
       .setMaxResults(1)
       .uniqueResult();
 }
예제 #7
0
  public Entity getDefaultTechnology(final Entity product) {
    SearchResult searchResult =
        getTechnologyDD()
            .find()
            .setMaxResults(1)
            .add(SearchRestrictions.eq(TechnologyFields.MASTER, true))
            .add(SearchRestrictions.eq("active", true))
            .add(SearchRestrictions.belongsTo(TechnologyFields.PRODUCT, product))
            .list();

    if (searchResult.getTotalNumberOfEntities() == 1) {
      return searchResult.getEntities().get(0);
    } else {
      return null;
    }
  }
  @Test
  public void shouldReturnFalseWhenEntityWithGivenProductAndCompanyDoesExistsInDB()
      throws Exception {
    // given
    SearchCriterion criterion1 =
        SearchRestrictions.eq(CATALOG_NUMBER, entity.getStringField(CATALOG_NUMBER));
    SearchCriterion criterion2 =
        SearchRestrictions.belongsTo(PRODUCT, entity.getBelongsToField(PRODUCT));

    given(entity.getId()).willReturn(null);
    given(criteria.add(criterion1)).willReturn(criteria);
    given(criteria.add(criterion2)).willReturn(criteria);
    given(criteria.list()).willReturn(searchResult);
    given(searchResult.getEntities()).willReturn(productCatalogNumbers);
    given(productCatalogNumbers.isEmpty()).willReturn(false);
    // when
    boolean result =
        productCatalogNumbersHooks.checkIfExistsCatalogNumberWithProductAndCompany(
            dataDefinition, entity);
    // then
    Assert.assertFalse(result);
    Mockito.verify(entity)
        .addGlobalError(
            "productCatalogNumbers.productCatalogNumber.validationError.alreadyExistsProductForCompany");
  }
예제 #9
0
 private Entity getCompany(final String number) {
   return dataDefinitionService
       .get(SamplesConstants.BASIC_PLUGIN_IDENTIFIER, SamplesConstants.BASIC_MODEL_COMPANY)
       .find()
       .add(SearchRestrictions.eq("number", number))
       .uniqueResult();
 }
예제 #10
0
 private Entity findMainAddressTypeDictionaryItem(final Entity addressType) {
   return getDictionaryItemDD()
       .find()
       .add(SearchRestrictions.belongsTo(DictionaryItemFields.DICTIONARY, addressType))
       .add(SearchRestrictions.eq(DictionaryItemFields.TECHNICAL_CODE, L_MAIN))
       .setMaxResults(1)
       .uniqueResult();
 }
예제 #11
0
 private Entity findMainAddress(final Entity company, final String addressType) {
   return getAddressDD()
       .find()
       .add(SearchRestrictions.belongsTo(AddressFields.COMPANY, company))
       .add(SearchRestrictions.eq(AddressFields.ADDRESS_TYPE, addressType))
       .setMaxResults(1)
       .uniqueResult();
 }
예제 #12
0
 @Override
 public void addRestriction(final SearchCriteriaBuilder searchBuilder) {
   searchBuilder
       .add(SearchRestrictions.isNull(PARENT))
       .add(
           SearchRestrictions.eq(
               ProductFields.ENTITY_TYPE,
               ProductFamilyElementType.PRODUCTS_FAMILY.getStringValue()));
 }
예제 #13
0
  protected void addParameters(final Map<String, String> values) {
    LOG.info("Adding parameters");
    Entity params = parameterService.getParameter();

    Entity currency =
        dataDefinitionService
            .get(SamplesConstants.BASIC_PLUGIN_IDENTIFIER, SamplesConstants.BASIC_MODEL_CURRENCY)
            .find()
            .add(SearchRestrictions.eq("alphabeticCode", values.get("code")))
            .uniqueResult();

    params.setField("currency", currency);
    params.setField("unit", values.get("unit"));
    params.setField("company", getCompany(values.get("owner")));

    if (isEnabledOrEnabling("productionCounting")) {
      params.setField("registerQuantityInProduct", true);
      params.setField("registerQuantityOutProduct", true);
      params.setField("registerProductionTime", true);
      params.setField("justOne", false);
      params.setField("allowToClose", false);
      params.setField("autoCloseOrder", false);
    }

    if (isEnabledOrEnabling("qualityControls")) {
      params.setField("checkDoneOrderForQuality", false);
      params.setField("autoGenerateQualityControl", false);
    }

    if (isEnabledOrEnabling("genealogies")) {
      params.setField("batchForDoneOrder", "01none");
    }

    if (isEnabledOrEnabling("advancedGenealogy")) {
      params.setField("batchNumberUniqueness", "01globally");
    }

    if (isEnabledOrEnabling("advancedGenealogyForOrders")) {
      params.setField("trackingRecordForOrderTreatment", "01duringProduction");
      params.setField("batchNumberRequiredInputProducts", false);
    }

    if (isEnabledOrEnabling("materialRequirements")) {
      params.setField("inputProductsRequiredForType", "01startOrder");
    }

    if (isEnabledOrEnabling("materialFlowResources")) {
      params.setField("changeDateWhenTransferToWarehouseType", "01never");
    }

    params.getDataDefinition().save(params);
  }
 public Entity getExistingOrder(final ParsedOrder order) {
   SearchCriteriaBuilder ordersBuilder =
       dataDefinitionService
           .get(SfcSimpleConstants.PLUGIN_IDENTIFIER, SfcSimpleConstants.MODEL_IMPORTED_ORDER)
           .find()
           .add(SearchRestrictions.eq(FIELD_NUMBER, order.getField(FIELD_NUMBER)))
           .setMaxResults(1);
   SearchResult existingOrders = ordersBuilder.list();
   if (existingOrders.getTotalNumberOfEntities() > 0) {
     return existingOrders.getEntities().get(0);
   }
   return null;
 }
 public Entity getExistingProduct(final ParsedProduct productEntity) {
   SearchCriteriaBuilder productBuilder =
       dataDefinitionService
           .get(SfcSimpleConstants.PLUGIN_IDENTIFIER, SfcSimpleConstants.MODEL_IMPORTED_PRODUCT)
           .find()
           .add(
               SearchRestrictions.eq(
                   FIELD_IDENTIFICATION_CODE, productEntity.getIdentificationCode()))
           .setMaxResults(1);
   SearchResult existingProducts = productBuilder.list();
   if (existingProducts.getTotalNumberOfEntities() > 0) {
     return existingProducts.getEntities().get(0);
   }
   return null;
 }
예제 #16
0
 private Entity getDefaultTechnologyForProduct(final Entity product) {
   if (product == null) {
     return null;
   }
   List<Entity> technologies =
       dataDefinitionService
           .get(L_TECHNOLOGIES_PLUGIN_IDENTIFIER, L_TECHNOLOGY_MODEL_TECHNOLOGY)
           .find()
           .add(SearchRestrictions.belongsTo(L_BASIC_MODEL_PRODUCT, product))
           .add(SearchRestrictions.eq("master", true))
           .setMaxResults(1)
           .list()
           .getEntities();
   if (technologies.isEmpty()) {
     return null;
   }
   return technologies.get(0);
 }
  @Test
  public void shouldReturnTrueWhenEntityWithGivenNumberAndCompanyDoesnotExistsInDB()
      throws Exception {
    // given
    SearchCriterion criterion1 =
        SearchRestrictions.eq(CATALOG_NUMBER, entity.getStringField(CATALOG_NUMBER));
    SearchCriterion criterion2 =
        SearchRestrictions.belongsTo(ProductCatalogNumberFields.COMPANY, company);

    given(entity.getId()).willReturn(null);
    given(criteria.add(criterion1)).willReturn(criteria);
    given(criteria.add(criterion2)).willReturn(criteria);
    given(criteria.list()).willReturn(searchResult);
    given(searchResult.getEntities()).willReturn(productCatalogNumbers);
    given(productCatalogNumbers.isEmpty()).willReturn(true);
    // when
    boolean result =
        productCatalogNumbersHooks.checkIfExistsCatalogNumberWithNumberAndCompany(
            dataDefinition, entity);
    // then
    Assert.assertTrue(result);
  }
예제 #18
0
  private void generateAndAddUser() {
    Entity user = dataDefinitionService.get("qcadooSecurity", "user").create();

    user.setField("userName", generateString(CHARS_ONLY, RANDOM.nextInt(4) + 3));
    user.setField("email", generateRandomEmail());
    user.setField("firstname", generateString(CHARS_ONLY, RANDOM.nextInt(4) + 3));
    user.setField("lastname", generateString(CHARS_ONLY, RANDOM.nextInt(4) + 3));

    Entity group =
        dataDefinitionService
            .get("qcadooSecurity", "group")
            .find()
            .add(SearchRestrictions.eq(L_NAME, "Admin"))
            .setMaxResults(1)
            .uniqueResult();
    user.setField("group", group);

    user.setField("password", "123");
    user.setField("passwordConfirmation", "123");
    user.setField("enabled", true);

    dataDefinitionService.get("qcadooSecurity", "user").save(user);
  }
예제 #19
0
  private List<Entity> getResourcesForLocationAndProductFEFO(
      final Entity warehouse,
      final Entity product,
      final Entity additionalCode,
      final Entity position) {
    List<Entity> resources = Lists.newArrayList();

    if (additionalCode != null) {
      SearchCriteriaBuilder scb =
          getSearchCriteriaForResourceForProductAndWarehouse(product, warehouse);

      if (!StringUtils.isEmpty(product.getStringField(ProductFields.ADDITIONAL_UNIT))) {
        scb.add(
            SearchRestrictions.eq(
                PositionFields.CONVERSION, position.getDecimalField(PositionFields.CONVERSION)));
      } else {
        scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, BigDecimal.ONE));
      }

      resources =
          scb.add(SearchRestrictions.belongsTo(ResourceFields.ADDITIONAL_CODE, additionalCode))
              .addOrder(SearchOrders.asc(ResourceFields.EXPIRATION_DATE))
              .list()
              .getEntities();

      scb = getSearchCriteriaForResourceForProductAndWarehouse(product, warehouse);

      if (!StringUtils.isEmpty(product.getStringField(ProductFields.ADDITIONAL_UNIT))) {
        scb.add(
            SearchRestrictions.eq(
                PositionFields.CONVERSION, position.getDecimalField(PositionFields.CONVERSION)));
      } else {
        scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, BigDecimal.ONE));
      }

      resources.addAll(
          scb.add(
                  SearchRestrictions.or(
                      SearchRestrictions.isNull(ResourceFields.ADDITIONAL_CODE),
                      SearchRestrictions.ne("additionalCode.id", additionalCode.getId())))
              .addOrder(SearchOrders.asc(ResourceFields.EXPIRATION_DATE))
              .list()
              .getEntities());
    }

    if (resources.isEmpty()) {
      SearchCriteriaBuilder scb =
          getSearchCriteriaForResourceForProductAndWarehouse(product, warehouse);

      if (!StringUtils.isEmpty(product.getStringField(ProductFields.ADDITIONAL_UNIT))) {
        scb.add(
            SearchRestrictions.eq(
                PositionFields.CONVERSION, position.getDecimalField(PositionFields.CONVERSION)));
      } else {
        scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, BigDecimal.ONE));
      }

      resources =
          scb.addOrder(SearchOrders.asc(ResourceFields.EXPIRATION_DATE)).list().getEntities();
    }

    return resources;
  }
예제 #20
0
  public Multimap<Long, BigDecimal> getQuantitiesInWarehouse(
      final Entity warehouse, Multimap<Entity, Entity> productsAndPositions) {
    Multimap<Long, BigDecimal> result = ArrayListMultimap.create();

    String algorithm = warehouse.getStringField(LocationFieldsMFR.ALGORITHM);

    for (Map.Entry<Entity, Entity> productAndPosition : productsAndPositions.entries()) {
      Entity resource = productAndPosition.getValue().getBelongsToField(PositionFields.RESOURCE);

      if (algorithm.equalsIgnoreCase(WarehouseAlgorithm.MANUAL.getStringValue())
          && resource != null) {
        result.put(
            productAndPosition.getKey().getId(),
            resource.getDecimalField(ResourceFields.AVAILABLE_QUANTITY));
      } else {
        Entity additionalCode =
            productAndPosition.getValue().getBelongsToField(PositionFields.ADDITIONAL_CODE);
        BigDecimal conversion =
            productAndPosition.getValue().getDecimalField(PositionFields.CONVERSION);
        Entity reservation =
            reservationsService.getReservationForPosition(productAndPosition.getValue());
        List<Entity> resources = Lists.newArrayList();

        if (additionalCode != null) {
          SearchCriteriaBuilder scb =
              getSearchCriteriaForResourceForProductAndWarehouse(
                  productAndPosition.getKey(), warehouse);

          if (!StringUtils.isEmpty(
              productAndPosition.getKey().getStringField(ProductFields.ADDITIONAL_UNIT))) {
            scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, conversion));
          } else {
            scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, BigDecimal.ONE));
          }

          resources =
              scb.add(SearchRestrictions.belongsTo(ResourceFields.ADDITIONAL_CODE, additionalCode))
                  .list()
                  .getEntities();

          scb =
              getSearchCriteriaForResourceForProductAndWarehouse(
                  productAndPosition.getKey(), warehouse);

          if (!StringUtils.isEmpty(
              productAndPosition.getKey().getStringField(ProductFields.ADDITIONAL_UNIT))) {
            scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, conversion));
          } else {
            scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, BigDecimal.ONE));
          }

          resources.addAll(
              scb.add(
                      SearchRestrictions.or(
                          SearchRestrictions.isNull(ResourceFields.ADDITIONAL_CODE),
                          SearchRestrictions.ne("additionalCode.id", additionalCode.getId())))
                  .list()
                  .getEntities());
        }

        if (resources.isEmpty()) {
          SearchCriteriaBuilder scb =
              getSearchCriteriaForResourceForProductAndWarehouse(
                  productAndPosition.getKey(), warehouse);

          if (!StringUtils.isEmpty(
              productAndPosition.getKey().getStringField(ProductFields.ADDITIONAL_UNIT))) {
            scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, conversion));
          } else {
            scb.add(SearchRestrictions.eq(ResourceFields.CONVERSION, BigDecimal.ONE));
          }

          resources = scb.list().getEntities();
        }

        BigDecimal reservedQuantity = BigDecimal.ZERO;
        if (reservation != null) {
          reservedQuantity = reservation.getDecimalField(ReservationFields.QUANTITY);
        }
        if (result.containsKey(productAndPosition.getKey().getId())) {
          BigDecimal currentQuantity =
              result
                  .get(productAndPosition.getKey().getId())
                  .stream()
                  .reduce(reservedQuantity, BigDecimal::add);

          result.put(
              productAndPosition.getKey().getId(),
              (resources
                      .stream()
                      .map(res -> res.getDecimalField(ResourceFields.AVAILABLE_QUANTITY))
                      .reduce(BigDecimal.ZERO, BigDecimal::add))
                  .add(currentQuantity));
        } else {
          result.put(
              productAndPosition.getKey().getId(),
              resources
                  .stream()
                  .map(res -> res.getDecimalField(ResourceFields.AVAILABLE_QUANTITY))
                  .reduce(reservedQuantity, BigDecimal::add));
        }
      }
    }

    return result;
  }