'Audi', 'model' => 'A4'], ['brand' => 'Audi', 'model' => 'A6'], ['brand' => 'BMW', 'model' => 'Seria 5'], ['brand' => 'BMW', 'model' => 'X3'], ['brand' => 'Dacia', 'model' => 'Duster'], ['brand' => 'Dacia', 'model' => 'Logan'], ['brand' => 'Ford', 'model' => 'Focus'], ['brand' => 'Ford', 'model' => 'Mondeo'], ['brand' => 'Hyundai', 'model' => 'Santa Fe'], ['brand' => 'Hyundai', 'model' => 'Tucson'], ['brand' => 'Kia', 'model' => 'Sportage'], ['brand' => 'Nissan', 'model' => 'Navara'], ['brand' => 'Opel', 'model' => 'Astra'], ['brand' => 'Opel', 'model' => 'Corsa'], ['brand' => 'Renault', 'model' => 'Captur'], ['brand' => 'Renault', 'model' => 'Clio'], ['brand' => 'Renault', 'model' => 'Megane'], ['brand' => 'Renault', 'model' => 'Scenic'], ['brand' => 'Seat', 'model' => 'Ibiza'], ['brand' => 'Skoda', 'model' => 'Fabia'], ['brand' => 'Skoda', 'model' => 'Octavia'], ['brand' => 'Skoda', 'model' => 'Superb'], ['brand' => 'Suzuki', 'model' => 'Vitara'], ['brand' => 'Toyota', 'model' => 'Corolla'], ['brand' => 'Toyota', 'model' => 'Rav4'], ['brand' => 'Volkswagen', 'model' => 'Golf'], ['brand' => 'Volkswagen', 'model' => 'Passat'], ['brand' => 'Volvo', 'model' => 'XC40'], ['brand' => 'Volvo', 'model' => 'XC60'], ]; private $resource; private $storeManager; private $urlFinder; private $seoUrlHelper; private $logger; private $connection; private $baseUrl; private $catUrlPath; private $statusAttrId; public function __construct( ResourceConnection $resource, StoreManagerInterface $storeManager, UrlFinderInterface $urlFinder, SeoUrlHelper $seoUrlHelper, LoggerInterface $logger ) { $this->resource = $resource; $this->storeManager = $storeManager; $this->urlFinder = $urlFinder; $this->seoUrlHelper = $seoUrlHelper; $this->logger = $logger; } public function execute() { $this->logger->info('RefreshGreenValleyPages: start'); $this->connection = $this->resource->getConnection(); $pageTable = $this->resource->getTableName('amasty_amshopby_page'); $this->statusAttrId = (int)$this->connection->fetchOne( "SELECT attribute_id FROM " . $this->resource->getTableName('eav_attribute') . " WHERE attribute_code = 'status' AND entity_type_id = 4" ); /** @var \Magento\Store\Model\Store $store */ $store = $this->storeManager->getStore(1); $storeId = $store->getId(); $this->storeManager->setCurrentStore($storeId); $this->baseUrl = rtrim($store->getBaseUrl(UrlInterface::URL_TYPE_WEB), '/'); $rewrite = $this->urlFinder->findOneByData([ UrlRewrite::ENTITY_TYPE => 'category', UrlRewrite::ENTITY_ID => self::CATEGORY_ID, UrlRewrite::STORE_ID => $storeId, UrlRewrite::REDIRECT_TYPE => 0, ]); $this->catUrlPath = $rewrite ? str_replace('.html', '', $rewrite->getRequestPath()) : 'bare-transversale'; // Construieste URL map-urile filtrând doar branduri/modele cu produse active $brandUrlMap = $this->buildBrandUrlMap(); $modelUrlMap = $this->buildModelUrlMap(); $faqHtml = $this->getFaqHtml(); $updated = 0; $skipped = 0; // Itereaza toate brandurile cu produse active in categorie $brands = $this->getActiveBrands(); foreach ($brands as $brand) { $brandId = $brand['option_id']; $brandName = $brand['brand_name']; $conditions = json_encode([ json_encode(['filter' => (string)self::BRAND_ATTR_ID, 'value' => (string)$brandId]) ]); $pageId = $this->connection->fetchOne( $this->connection->select() ->from($pageTable, 'page_id') ->where('conditions = ?', $conditions) ->where('FIND_IN_SET(?, categories)', self::CATEGORY_ID) ); if (!$pageId) { $skipped++; continue; } $description = $this->buildDescription($brandName, $brandUrlMap, $modelUrlMap, $faqHtml); $this->connection->update( $pageTable, ['description' => $description], ['page_id = ?' => $pageId] ); $updated++; } $this->logger->info("RefreshGreenValleyPages: done. Updated=$updated Skipped=$skipped"); } private function getActiveBrands() { return $this->connection->fetchAll( $this->connection->select() ->from(['pei' => $this->resource->getTableName('catalog_product_entity_varchar')], []) ->joinInner( ['eaov' => $this->resource->getTableName('eav_attribute_option_value')], 'eaov.option_id = pei.value AND eaov.store_id = 0', ['option_id' => 'pei.value', 'brand_name' => 'eaov.value'] ) ->joinInner( ['ccp' => $this->resource->getTableName('catalog_category_product')], 'ccp.product_id = pei.entity_id', [] ) ->joinInner( ['cpe_status' => $this->resource->getTableName('catalog_product_entity_int')], 'cpe_status.entity_id = pei.entity_id AND cpe_status.attribute_id = ' . $this->statusAttrId . ' AND cpe_status.store_id = 0 AND cpe_status.value = 1', [] ) ->where('pei.attribute_id = ?', self::BRAND_ATTR_ID) ->where('ccp.category_id = ?', self::CATEGORY_ID) ->group('pei.value') ->order('eaov.value ASC') ); } private function hasActiveProducts($brandOptionId, $modelOptionId = null) { $select = $this->connection->select() ->from(['pei_b' => $this->resource->getTableName('catalog_product_entity_varchar')], ['COUNT(DISTINCT pei_b.entity_id)']) ->joinInner( ['ccp' => $this->resource->getTableName('catalog_category_product')], 'ccp.product_id = pei_b.entity_id', [] ) ->joinInner( ['cpe_status' => $this->resource->getTableName('catalog_product_entity_int')], 'cpe_status.entity_id = pei_b.entity_id AND cpe_status.attribute_id = ' . $this->statusAttrId . ' AND cpe_status.store_id = 0 AND cpe_status.value = 1', [] ) ->where('pei_b.attribute_id = ?', self::BRAND_ATTR_ID) ->where('pei_b.value = ?', $brandOptionId) ->where('ccp.category_id = ?', self::CATEGORY_ID); if ($modelOptionId !== null) { $select->joinInner( ['pei_m' => $this->resource->getTableName('catalog_product_entity_varchar')], 'pei_m.entity_id = pei_b.entity_id AND pei_m.attribute_id = ' . self::MODEL_ATTR_ID . ' AND pei_m.value = ' . (int)$modelOptionId, [] ); } return (int)$this->connection->fetchOne($select) > 0; } private function getOptionIdByLabel($attrId, $label) { return $this->connection->fetchOne( $this->connection->select() ->from(['eaov' => $this->resource->getTableName('eav_attribute_option_value')], ['eaov.option_id']) ->joinInner( ['eao' => $this->resource->getTableName('eav_attribute_option')], 'eao.option_id = eaov.option_id AND eao.attribute_id = ' . (int)$attrId, [] ) ->where('eaov.store_id = 0') ->where('eaov.value = ?', $label) ->limit(1) ) ?: null; } private function buildBrandUrlMap() { $map = []; foreach (self::POPULAR_BRANDS as $brandName) { $optionId = $this->getOptionIdByLabel(self::BRAND_ATTR_ID, $brandName); if (!$optionId || !$this->hasActiveProducts($optionId)) { continue; // brand fara produse active — skip } $rawUrl = $this->baseUrl . '/' . $this->catUrlPath . '/?' . self::BRAND_CODE . '=' . $optionId; $map[$brandName] = $this->seoUrlHelper->seofyUrl($rawUrl, self::CATEGORY_ID, true) . '.html'; } return $map; } private function buildModelUrlMap() { $map = []; foreach (self::POPULAR_MODELS as $item) { $brandOptionId = $this->getOptionIdByLabel(self::BRAND_ATTR_ID, $item['brand']); $modelOptionId = $this->getOptionIdByLabel(self::MODEL_ATTR_ID, $item['model']); if (!$brandOptionId || !$modelOptionId || !$this->hasActiveProducts($brandOptionId, $modelOptionId)) { continue; // combinatie fara produse active — skip } $key = $item['brand'] . '|' . $item['model']; $rawUrl = $this->baseUrl . '/' . $this->catUrlPath . '/?' . self::BRAND_CODE . '=' . $brandOptionId . '&' . self::MODEL_CODE . '=' . $modelOptionId; $map[$key] = $this->seoUrlHelper->seofyUrl($rawUrl, self::CATEGORY_ID, true) . '.html'; } return $map; } private function buildDescription($brandName, array $brandUrlMap, array $modelUrlMap, $faqHtml) { $currentBrandLower = strtolower($brandName); $brandsHtml = ''; foreach (self::POPULAR_BRANDS as $b) { if (strtolower($b) === $currentBrandLower) continue; if (!isset($brandUrlMap[$b])) continue; // nu are produse active $url = htmlspecialchars($brandUrlMap[$b]); $brandsHtml .= '' . $b . ' '; } $modelsHtml = ''; foreach (self::POPULAR_MODELS as $item) { if (strtolower($item['brand']) === $currentBrandLower) continue; $key = $item['brand'] . '|' . $item['model']; if (!isset($modelUrlMap[$key])) continue; // nu are produse active $url = htmlspecialchars($modelUrlMap[$key]); $modelsHtml .= '' . '
' . $item['brand'] . '
' . '
' . $item['model'] . '
' . ''; } $css = ''; return $css . '

Alte mărci populare

' . $brandsHtml . '

Modele populare de la alte mărci

' . $modelsHtml . '
' . $faqHtml; } private function getFaqHtml() { return '

Intrebari frecvente

Aveti transport gratuit?

Nu. Taxele de transport variaza in functie de categoria produselor si sunt cuprinse intre 20 si 49 lei.

Exista campanii de reduceri?

Da, derulam frecvent campanii de reduceri pentru diverse categorii de produse. Reducerile aplicate variaza, acestea putand ajunge pana la 40-50%. Urmareste site-ul nostru pentru a fi la curent cu ofertele.

Care este politica de retur si cat dureaza rambursarea banilor?

Returul produselor se poate efectua in termen de 14 zile de la primirea acestora, indiferent de motivul returnarii. Viramentul bancar pentru contravaloarea produselor trimise si acceptate la retur se efectueaza in termen de maximum 14 zile de la momentul notificarii cu privire la decizia returnarii produselor, daca produsele sunt trimise inapoi inainte de expirarea perioadei de 14 zile. Mai multe detalii cu privire la politica de retur se regasesc aici: Retur

Cum pot solicita un retur?

Pentru a solicita un retur, completeaza formularul disponibil pe site: Retur

Ce metode de plata sunt disponibile?

Poti plati ramburs la curier, online cu cardul, in 3 rate fara dobanda (cu card de cumparaturi eligibil) sau prin ordin de plata pe baza unei facturi proforme. La selectarea platii online cu cardul, procesatorul de plati va permite inclusiv plata prin Apple Pay sau Google Pay.

Pot plati in rate?

Da, poti plati in 3 rate fara dobanda, daca folosesti un card de cumparaturi eligibil (Card Avantaj - Credit Europe Bank; Card StarBT - Banca Transilvania; Bonus Card - Garanti Bank; Card Cumparaturi - Alpha Bank; Card BRD Finance).

Cum imi pot urmari coletul?

Dupa finalizarea comenzii vei primi un email cu nr de AWB al coletului si firma de curierat prin care a fost expediat coletul.

Cat dureaza livrarea?

De regula, livrarea se face in 1-3 zile lucratoare, in functie de adresa de destinatie. Pentru anumite categorii de produse (precum carligele de remorcare marca Aragon), livrarea se poate prelungi pana la 7-9 zile lucratoare.

Cum sunt protejate datele mele personale?

Protejam datele tale personale conform Regulamentului (UE) 2016/679 (GDPR). Nu transmitem (prin vanzare sau inchiriere) catre terte parti informatiile cu caracter personal. Ai dreptul de a solicita oricand stergerea informatiilor cu caracter personal existente in baza noastra de date. Poti consulta politica noastra completa de confidentialitate aici: Politica de confidentialitate

'; } }