public function save(Product $product) { $flattened = $this->_flatten($product->getDetails()); $this->_transaction->add("\n\t\t\tDELETE FROM\n\t\t\t\tproduct_detail\n\t\t\tWHERE\n\t\t\t\tproduct_id = :productID?i\n\t\t", ['productID' => $product->id]); foreach ($flattened as $detail) { $this->_transaction->add(' INSERT INTO product_detail ( product_id, name, value, value_int, locale ) VALUES ( :productID?i, :name?s, :value?s, :value?i, :locale?s ) ', array_merge($detail, ['productID' => $product->id])); } if (!$this->_transOverridden) { $this->_transaction->commit(); } }
/** * @param string | array $data Product data submitted by form * @throws TransformationFailedException Exception thrown if invalid type given * * @return Product Returns instance of Product object */ public function reverseTransform($data) { $product = new Product($this->_locale, $this->_priceTypes, $this->_defaultCurrency, $this->_taxStrategy); $product->setName($data['name'])->setDisplayName($data['name'])->setBrand($data['brand'])->setCategory($data['category'])->setDescription($data['description'])->setType($this->_productTypes->get($data['type'])); // setting prices foreach ($data['prices']['currencies'] as $currency => $typePrices) { foreach ($typePrices as $type => $price) { $product->setPrice($type, $currency, $price); } } // create the unit if (!empty($data['units'])) { foreach ($data['units'] as $unitData) { $unit = new Unit($this->_locale, $this->_priceTypes, $this->_defaultCurrency); $unit->setProduct($product); $unit->setSKU($unitData['sku']); $unit->setStockForLocation($unitData['stock'], $this->_defaultLocation); $unit->setVisible(true); $unit->revisionID = 1; foreach ($unitData['variants'] as $option) { $unit->setOption($option['key'], $option['value']); } $product->addUnit($unit); } } return $product; }
/** * Get the tax rate for an item to an address. If address is null, * a default address should be used. * * @param Product $product The product to calulate tax for * @param Address $address The address delvered to * @return Collection The tax rates to be applied * @throws AddressNotSetException If no address given or default address set */ public function getProductTaxRates(Product $product, Address $address = null) { if ($address === null) { $address = $this->_defaultAddress; } if (!$address) { throw new \LogicException('No address given and no default address set. Either provide an address or ensure a default address is set on the loader.'); } return $this->_taxResolver->getTaxRates($product->getType()->getName(), $address); }
/** * Save data to product export table, create new row if not exists * * @throws \LogicException * * @return Edit */ protected function _saveProductExport() { if (!$this->_product) { throw new \LogicException('Cannot edit product export info as no product is set'); } $this->_trans->add("\n\t\t\tINSERT INTO\n\t\t\t\tproduct_export\n\t\t\t\t(\n\t\t\t\t\tproduct_id,\n\t\t\t\t\tlocale,\n\t\t\t\t\texport_value,\n\t\t\t\t\texport_description,\n\t\t\t\t\texport_manufacture_country_id,\n\t\t\t\t\texport_code\n\t\t\t\t)\n\t\t\tVALUES\n\t\t\t\t(\n\t\t\t\t\t:productID?i,\n\t\t\t\t\t:locale?sn,\n\t\t\t\t\t:exportValue?fn,\n\t\t\t\t\t:exportDescription?sn,\n\t\t\t\t\t:exportCountryID?s,\n\t\t\t\t\t:exportCode?sn\n\t\t\t\t)\n\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\texport_value\t\t\t\t\t= :exportValue?fn,\n\t\t\t\texport_description\t\t\t\t= :exportDescription?sn,\n\t\t\t\texport_manufacture_country_id\t= :exportCountryID?s,\n\t\t\t\texport_code = :exportCode?sn\n\t\t", ['productID' => $this->_product->id, 'locale' => $this->_locale->getID(), 'exportValue' => $this->_product->exportValue, 'exportDescription' => $this->_product->exportDescription, 'exportCountryID' => $this->_product->exportManufactureCountryID, 'exportCode' => $this->_product->getExportCode()]); return $this; }
private function _setPrices(array $row) { $default = null; foreach ($this->_priceTypes as $type) { $price = $this->_getPriceObject($type, $row, $default); if (null === $default && $type === 'retail') { $default = $price; } $this->_product->getPrices()->add($price); } }
public function build(Product\Product $product) { $this->setName('product-details-edit')->setAction($this->_container['routing.generator']->generate('ms.commerce.product.edit.attributes.action', ['productID' => $product->id]))->setMethod('post'); $this->add('name', 'text', $this->_trans('ms.commerce.product.attributes.name.label'), ['data' => $product->name, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.name.help']])->val()->maxLength(255); $this->add('display_name', 'text', $this->_trans('ms.commerce.product.attributes.display-name.label'), ['data' => $product->displayName, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.display-name.help']])->val()->optional()->maxLength(255); $this->add('sort_name', 'text', $this->_trans('ms.commerce.product.attributes.sort-name.label'), ['data' => $product->sortName, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.sort-name.help']])->val()->optional()->maxLength(255); $this->add('category', 'datalist', $this->_trans('ms.commerce.product.attributes.category.label'), ['choices' => $this->_getCategories(), 'data' => $product->category, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.category.help']]); $this->add('brand', 'datalist', $this->_trans('ms.commerce.product.attributes.brand.label'), ['data' => $product->brand, 'choices' => $this->_getBrands(), 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.brand.help']])->val()->maxLength(255)->optional(); $this->add('description', 'textarea', $this->_trans('ms.commerce.product.attributes.description.label'), ['data' => $product->description, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.description.help']])->val()->optional(); $this->add('short_description', 'textarea', $this->_trans('ms.commerce.product.attributes.short-description.label'), ['data' => $product->shortDescription, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.short-description.help']])->val()->optional(); $this->add('export_description', 'textarea', $this->_trans('ms.commerce.product.attributes.export-description.label'), ['data' => $product->exportDescription, 'attr' => ['data-help-key' => 'ms.commerce.product.attributes.export-description.help']])->val()->optional(); $this->add('export_code', 'text', $this->_container['translator']->trans('ms.commerce.product.details.export-code.label'), ['data' => $product->getExportCode(), 'attr' => ['data-help-key' => 'ms.commerce.product.details.export-code.help']])->val()->optional(); $this->add('supplier_ref', 'text', $this->_trans('ms.commerce.product.details.supplier-ref.label'), ['data' => $product->supplierRef, 'attr' => ['data-help-key' => 'ms.commerce.product.details.supplier-ref.help']])->val()->maxLength(255)->optional(); $this->add('weight_grams', 'number', $this->_trans('ms.commerce.product.details.weight-grams.label'), ['data' => $product->weight, 'attr' => ['data-help-key' => 'ms.commerce.product.details.weight-grams.help']])->val()->number()->optional(); $this->add('tags', 'textarea', $this->_trans('ms.commerce.product.details.tags.label'), ['data' => implode(', ', $product->tags), 'attr' => ['data-help-key' => 'ms.commerce.product.details.tags.help']])->val()->optional(); $this->add('notes', 'textarea', $this->_trans('ms.commerce.product.details.notes.label'), ['data' => $product->notes, 'attr' => ['data-help-key' => 'ms.commerce.product.details.notes.help']])->val()->optional(); $this->add('export_manufacture_country_id', 'choice', $this->_container['translator']->trans('ms.commerce.product.details.export-manufacture-country.label'), ['data' => $product->exportManufactureCountryID, 'choices' => $this->_container['country.list']->all(), 'attr' => ['data-help-key' => 'ms.commerce.product.details.export-manufacture-country.help']]); $typeChoices = []; foreach ($this->_container['product.types'] as $type) { $typeChoices[$type->getName()] = $type->getDisplayName(); } $this->add('product_type', 'choice', $this->_container['translator']->trans('ms.commerce.product.details.product-type.label'), ['data' => $product->type->getName(), 'choices' => $typeChoices, 'attr' => ['data-help-key' => 'ms.commerce.product.details.product-type.help']]); return $this; }
public function create(Product $product) { $result = $this->_query->run('INSERT INTO product SET product.type = :type?s, product.name = :name?s, product.weight_grams = :weight?i, product.tax_rate = :tax_rate?f, product.tax_strategy = :tax_strat?s, product.supplier_ref = :supplier?s, product.created_at = :created_at?d, product.created_by = :created_by?i, product.brand = :brand?s, product.category = :category?s ', ['type' => $product->type->getName(), 'name' => $product->name, 'weight' => $product->weight, 'tax_rate' => $product->taxRate, 'tax_strat' => $this->_defaultTaxStrategy->getName(), 'supplier' => $product->supplierRef, 'created_at' => $product->authorship->createdAt(), 'created_by' => $product->authorship->createdBy()->id, 'brand' => $product->getBrand(), 'category' => $product->getCategory()]); $productID = $result->id(); $info = $this->_query->run('INSERT INTO product_info SET product_id = :id?i, locale = :locale?s, display_name = :displayName?s, sort_name = :sortName?s, description = :description?s, short_description = :shortDesc?s', ['id' => $productID, 'locale' => $this->_locale->getID(), 'displayName' => $product->displayName, 'sortName' => $product->sortName, 'description' => $product->description, 'shortDesc' => $product->shortDescription]); $queryAppend = []; $queryVars = []; foreach ($this->_priceTypes as $type) { foreach ($this->_currencyIDs as $currency) { $price = $product->getPrices()->exists($type) ? $product->getPrice($type, $currency) : 0; $queryAppend[] = "(?i, ?s, ?f, ?s, ?s)"; $vars = [$productID, $type, $price, $currency, $this->_locale->getId()]; $queryVars = array_merge($queryVars, $vars); } } $defaultPrices = $this->_query->run('INSERT INTO product_price (product_id, type, price, currency_id, locale) VALUES ' . implode(', ', $queryAppend), $queryVars); $product->id = $productID; return $product; }
protected function _getProductDetailsForm() { return $this->get('field.form')->generate($this->_product->getDetails(), ['action' => $this->generateUrl('ms.commerce.product.edit.details.action', ['productID' => $this->_product->id])]); }
protected function _getDefaultValues(Product $product) { $defaultValues = $product->getDetails()->flatten(); $defaultValues['title'] = !empty($defaultValues['title']) ? $defaultValues['title'] : $product->name; return $defaultValues; }
public function getProductDisplayName(Product $product) { $name = $product->displayName ?: $product->name; return $product->getDetails()->author ? $product->getDetails()->author . ' - ' . $name : $name; }
private function _getUnits(Product $product, array $options) { $units = []; $locations = $this->get('stock.locations'); foreach ($product->getVisibleUnits() as $unit) { // Skip units that don't meet the options criteria, if set if ($options && $options !== array_intersect_assoc($options, $unit->options)) { continue; } if (1 > $unit->getStockForLocation($locations->getRoleLocation($locations::SELL_ROLE))) { $this->_outOfStock[(int) $unit->id] = $unit->id; } $units[$unit->id] = $unit; } return $units; }
public function getTaxRates() { $this->_load('taxes'); return parent::getTaxRates(); }
protected function _getAvailableUnits(Product $product, array $options = []) { $key = md5(serialize(array($product->id, $options))); if (!array_key_exists($key, $this->_availableUnits)) { $this->_availableUnits[$key] = []; foreach ($product->getVisibleUnits() as $unit) { // Skip units that don't meet the options criteria, if set if ($options && $options !== array_intersect_assoc($options, $unit->options)) { continue; } $this->_availableUnits[$key][$unit->id] = $unit; } } return $this->_availableUnits[$key]; }