/**
* @return void
*/
protected function setTestData()
{
$productAbstract = SpyProductAbstractQuery::create()->filterBySku('test')->findOne();
if ($productAbstract === null) {
$productAbstract = new SpyProductAbstract();
$productAbstract->setSku('test');
}
$productAbstract->setAttributes('{}')->save();
$product = SpyProductQuery::create()->filterBySku('test2')->findOne();
if ($product === null) {
$product = new SpyProduct();
$product->setSku('test2');
}
$product->setFkProductAbstract($productAbstract->getIdProductAbstract())->setAttributes('{}')->save();
$stockType1 = SpyStockQuery::create()->filterByName('warehouse1')->findOneOrCreate();
$stockType1->setName('warehouse1')->save();
$stockType2 = SpyStockQuery::create()->filterByName('warehouse2')->findOneOrCreate();
$stockType2->setName('warehouse2')->save();
$stockProduct1 = SpyStockProductQuery::create()->filterByFkStock($stockType1->getIdStock())->filterByFkProduct($product->getIdProduct())->findOneOrCreate();
$stockProduct1->setFkStock($stockType1->getIdStock())->setQuantity(10)->setFkProduct($product->getIdProduct())->save();
$stockProduct2 = SpyStockProductQuery::create()->filterByFkStock($stockType2->getIdStock())->filterByFkProduct($product->getIdProduct())->findOneOrCreate();
$stockProduct2->setFkStock($stockType2->getIdStock())->setQuantity(20)->setFkProduct($product->getIdProduct())->save();
}
/**
* @return array
*/
public static function loadFixtures()
{
$ids = [];
$dbConnection = Propel::getConnection();
$taxRateEntity = new SpyTaxRate();
$taxRateEntity->setRate(10)->setName('Foo');
$taxRateEntity->save();
$ids['idTaxRate1'] = $taxRateEntity->getIdTaxRate();
$taxRateEntity = new SpyTaxRate();
$taxRateEntity->setRate(5)->setName('Bar');
$taxRateEntity->save();
$ids['idTaxRate2'] = $taxRateEntity->getIdTaxRate();
$taxSetEntity = new SpyTaxSet();
$taxSetEntity->setName('Baz');
$taxSetEntity->save();
$ids['idTaxSet'] = $taxSetEntity->getIdTaxSet();
$taxSetTaxEntity = new SpyTaxSetTax();
$taxSetTaxEntity->setFkTaxSet($ids['idTaxSet'])->setFkTaxRate($ids['idTaxRate1']);
$taxSetTaxEntity->save();
$taxSetTaxEntity = new SpyTaxSetTax();
$taxSetTaxEntity->setFkTaxSet($ids['idTaxSet'])->setFkTaxRate($ids['idTaxRate2']);
$taxSetTaxEntity->save();
$productAbstractEntity = new SpyProductAbstract();
$productAbstractEntity->setSku('ABC123')->setFkTaxSet($ids['idTaxSet'])->setAttributes('{}');
$productAbstractEntity->save();
$ids['idProductAbstract'] = $productAbstractEntity->getIdProductAbstract();
$productEntity = new SpyProduct();
$productEntity->setSku('DEF456')->setFkProductAbstract($ids['idProductAbstract'])->setAttributes('{}');
$productEntity->save();
$ids['idProductConcrete'] = $productEntity->getIdProduct();
$productOptionTypeEntity = new SpyProductOptionType();
$productOptionTypeEntity->save();
$ids['idTypeColor'] = $productOptionTypeEntity->getIdProductOptionType();
$productOptionTypeEntity = new SpyProductOptionType();
$productOptionTypeEntity->setFkTaxSet($ids['idTaxSet']);
$productOptionTypeEntity->save();
$ids['idTypeSize'] = $productOptionTypeEntity->getIdProductOptionType();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeColor']);
$productOptionValueEntity->save();
$ids['idValueRed'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeColor']);
$productOptionValueEntity->save();
$ids['idValueBlue'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeColor']);
$productOptionValueEntity->save();
$ids['idValueGreen'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeColor']);
$productOptionValueEntity->save();
$ids['idValueYellow'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValuePriceEntity = new SpyProductOptionValuePrice();
$productOptionValuePriceEntity->setPrice(199);
$productOptionValuePriceEntity->save();
$ids['idPriceLarge'] = $productOptionValuePriceEntity->getIdProductOptionValuePrice();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeSize'])->setFkProductOptionValuePrice($ids['idPriceLarge']);
$productOptionValueEntity->save();
$ids['idValueLarge'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeSize']);
$productOptionValueEntity->save();
$ids['idValueSmall'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeSize']);
$productOptionValueEntity->save();
$ids['idValueMedium'] = $productOptionValueEntity->getIdProductOptionValue();
$productOptionValueEntity = new SpyProductOptionValue();
$productOptionValueEntity->setFkProductOptionType($ids['idTypeSize']);
$productOptionValueEntity->save();
$ids['idValueXSmall'] = $productOptionValueEntity->getIdProductOptionValue();
$localeEntity = new SpyLocale();
$localeEntity->setLocaleName('xx_XX');
$localeEntity->save();
$ids['idLocale'] = $localeEntity->getIdLocale();
$productOptionTypeTranslationEntity = new SpyProductOptionTypeTranslation();
$productOptionTypeTranslationEntity->setName('Size')->setFkLocale($ids['idLocale'])->setFkProductOptionType($ids['idTypeSize']);
$productOptionTypeTranslationEntity->save();
$productOptionTypeTranslationEntity = new SpyProductOptionTypeTranslation();
$productOptionTypeTranslationEntity->setName('Color')->setFkLocale($ids['idLocale'])->setFkProductOptionType($ids['idTypeColor']);
$productOptionTypeTranslationEntity->save();
$data = ['Blue' => $ids['idValueBlue'], 'Red' => $ids['idValueRed'], 'Yellow' => $ids['idValueYellow'], 'Green' => $ids['idValueGreen'], 'Large' => $ids['idValueLarge'], 'Medium' => $ids['idValueMedium'], 'Small' => $ids['idValueSmall'], 'Extra' => $ids['idValueXSmall']];
foreach ($data as $name => $fkProductOptionValue) {
$productOptionValueTranslationEntity = new SpyProductOptionValueTranslation();
$productOptionValueTranslationEntity->setName($name)->setFkLocale($ids['idLocale'])->setFkProductOptionValue($fkProductOptionValue);
$productOptionValueTranslationEntity->save();
}
$productOptionTypeUsageEntity = new SpyProductOptionTypeUsage();
$productOptionTypeUsageEntity->setIsOptional(0)->setSequence(1)->setFkProduct($ids['idProductConcrete'])->setFkProductOptionType($ids['idTypeColor']);
$productOptionTypeUsageEntity->save();
$ids['idUsageColor'] = $productOptionTypeUsageEntity->getIdProductOptionTypeUsage();
$productOptionTypeUsageEntity = new SpyProductOptionTypeUsage();
$productOptionTypeUsageEntity->setIsOptional(0)->setSequence(1)->setFkProduct($ids['idProductConcrete'])->setFkProductOptionType($ids['idTypeSize']);
$productOptionTypeUsageEntity->save();
$ids['idUsageSize'] = $productOptionTypeUsageEntity->getIdProductOptionTypeUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(1)->setFkProductOptionValue($ids['idValueBlue'])->setFkProductOptionTypeUsage($ids['idUsageColor']);
$productOptionValueUsageEntity->save();
$ids['idUsageBlue'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(2)->setFkProductOptionValue($ids['idValueRed'])->setFkProductOptionTypeUsage($ids['idUsageColor']);
$productOptionValueUsageEntity->save();
$ids['idUsageRed'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(3)->setFkProductOptionValue($ids['idValueYellow'])->setFkProductOptionTypeUsage($ids['idUsageColor']);
$productOptionValueUsageEntity->save();
$ids['idUsageYellow'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(4)->setFkProductOptionValue($ids['idValueGreen'])->setFkProductOptionTypeUsage($ids['idUsageColor']);
$productOptionValueUsageEntity->save();
$ids['idUsageGreen'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(1)->setFkProductOptionValue($ids['idValueLarge'])->setFkProductOptionTypeUsage($ids['idUsageSize']);
$productOptionValueUsageEntity->save();
$ids['idUsageLarge'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(2)->setFkProductOptionValue($ids['idValueMedium'])->setFkProductOptionTypeUsage($ids['idUsageSize']);
$productOptionValueUsageEntity->save();
$ids['idUsageMedium'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(3)->setFkProductOptionValue($ids['idValueSmall'])->setFkProductOptionTypeUsage($ids['idUsageSize']);
$productOptionValueUsageEntity->save();
$ids['idUsageSmall'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionValueUsageEntity = new SpyProductOptionValueUsage();
$productOptionValueUsageEntity->setSequence(4)->setFkProductOptionValue($ids['idValueXSmall'])->setFkProductOptionTypeUsage($ids['idUsageSize']);
$productOptionValueUsageEntity->save();
$ids['idUsageXSmall'] = $productOptionValueUsageEntity->getIdProductOptionValueUsage();
$productOptionTypeUsageExclusionEntity = new SpyProductOptionTypeUsageExclusion();
$productOptionTypeUsageExclusionEntity->setFkProductOptionTypeUsageA($ids['idUsageColor'])->setFkProductOptionTypeUsageB($ids['idUsageSize']);
$productOptionTypeUsageExclusionEntity->save();
$productOptionValueUsageConstraintEntity = new SpyProductOptionValueUsageConstraint();
$productOptionValueUsageConstraintEntity->setFkProductOptionValueUsageA($ids['idUsageBlue'])->setFkProductOptionValueUsageB($ids['idUsageSmall'])->setOperator('NOT');
$productOptionValueUsageConstraintEntity->save();
$productOptionValueUsageConstraintEntity = new SpyProductOptionValueUsageConstraint();
$productOptionValueUsageConstraintEntity->setFkProductOptionValueUsageA($ids['idUsageRed'])->setFkProductOptionValueUsageB($ids['idUsageMedium'])->setOperator('ALWAYS');
$productOptionValueUsageConstraintEntity->save();
$productOptionValueUsageConstraintEntity = new SpyProductOptionValueUsageConstraint();
$productOptionValueUsageConstraintEntity->setFkProductOptionValueUsageA($ids['idUsageGreen'])->setFkProductOptionValueUsageB($ids['idUsageSmall'])->setOperator('ALLOW');
$productOptionValueUsageConstraintEntity->save();
$productOptionValueUsageConstraintEntity = new SpyProductOptionValueUsageConstraint();
$productOptionValueUsageConstraintEntity->setFkProductOptionValueUsageA($ids['idUsageGreen'])->setFkProductOptionValueUsageB($ids['idUsageLarge'])->setOperator('ALLOW');
$productOptionValueUsageConstraintEntity->save();
$productOptionConfigurationPresetEntity = new SpyProductOptionConfigurationPreset();
$productOptionConfigurationPresetEntity->setIsDefault(true)->setSequence(1)->setFkProduct($ids['idProductConcrete']);
$productOptionConfigurationPresetEntity->save();
$ids['idConfigPresetA'] = $productOptionConfigurationPresetEntity->getIdProductOptionConfigurationPreset();
$productOptionConfigurationPresetEntity = new SpyProductOptionConfigurationPreset();
$productOptionConfigurationPresetEntity->setIsDefault(false)->setSequence(2)->setFkProduct($ids['idProductConcrete']);
$productOptionConfigurationPresetEntity->save();
$ids['idConfigPresetB'] = $productOptionConfigurationPresetEntity->getIdProductOptionConfigurationPreset();
$data = [$ids['idUsageRed'] => $ids['idConfigPresetA'], $ids['idUsageMedium'] => $ids['idConfigPresetA'], $ids['idUsageGreen'] => $ids['idConfigPresetB'], $ids['idUsageLarge'] => $ids['idConfigPresetB']];
foreach ($data as $fkProductOptionValueUsage => $fkProductOptionConfigurationPreset) {
$productOptionConfigurationPresetValueEntity = new SpyProductOptionConfigurationPresetValue();
$productOptionConfigurationPresetValueEntity->setFkProductOptionConfigurationPreset($fkProductOptionConfigurationPreset)->setFkProductOptionValueUsage($fkProductOptionValueUsage);
$productOptionConfigurationPresetValueEntity->save();
}
return $ids;
}
/**
* @api
*
* @todo refactor queries from below
*
* @param \Orm\Zed\Product\Persistence\SpyProductAbstract $productAbstract
*
* @return \Orm\Zed\Product\Persistence\SpyProductQuery
*/
public function queryProductConcreteByProductAbstract(SpyProductAbstract $productAbstract)
{
return $this->getFactory()->createProductQuery()->filterByFkProductAbstract($productAbstract->getIdProductAbstract());
}
/**
* @return void
*/
private function loadFixtures()
{
$rate1 = new SpyTaxRate();
$rate1->setName('Rate1')->setRate(10)->save();
$this->taxRateIds[] = $rate1->getIdTaxRate();
$rate2 = new SpyTaxRate();
$rate2->setName('Rate2')->setRate(5)->save();
$this->taxRateIds[] = $rate2->getIdTaxRate();
$taxSet = new SpyTaxSet();
$taxSet->setName('Set1')->addSpyTaxRate($rate1)->addSpyTaxRate($rate2)->save();
$this->taxSetId = $taxSet->getIdTaxSet();
$product1 = new SpyProductAbstract();
$product1->setSku('Product1')->setSpyTaxSet($taxSet)->setAttributes('{}')->save();
$this->productAbstractIds[] = $product1->getIdProductAbstract();
$product2 = new SpyProductAbstract();
$product2->setSku('Product2')->setSpyTaxSet($taxSet)->setAttributes('{}')->save();
$this->productAbstractIds[] = $product2->getIdProductAbstract();
}
/**
* @param \Orm\Zed\Product\Persistence\SpyProductAbstract $productAbstract
* @param int $idLocale
*
* @return array
*/
protected function getProductCategories(SpyProductAbstract $productAbstract, $idLocale)
{
$productCategoryEntityList = $this->getFactory()->getProductCategoryQueryContainer()->queryLocalizedProductCategoryMappingByIdProduct($productAbstract->getIdProductAbstract())->find();
$categories = [];
foreach ($productCategoryEntityList as $productCategoryEntity) {
$categories[] = [self::COL_ID_PRODUCT_CATEGORY => $productCategoryEntity->getIdProductCategory(), self::COL_CATEGORY_NAME => $productCategoryEntity->getSpyCategory()->getLocalisedAttributes($idLocale)->getFirst()->getName()];
}
return $categories;
}
