public function modificationsAction() { $id = $this->_request->getParam('id'); $select = $this->_subproductsModelMapper->getDbTable()->select()->where('deleted != ?', 1)->order('order ASC'); $jsonData = array('parentId' => $id, 'columns' => array(), 'rows' => array()); $modifications = $this->_modelMapper->findSubproductsRel($id, $select, true); if (!empty($modifications)) { $selectSubproductParams = $this->_subproductsParamsMapper->getDbTable()->select()->order('order ASC'); $subproductProperty = $this->_modelMapper->findSubproductParams($id, $selectSubproductParams, true); $jsonData['columns'] = $subproductProperty; $modificationsTableValues = array(); foreach ($modifications as $modification) { $modificationPropertyValues = $this->_subproductsModelMapper->findSubProductParamValue($modification['id']); $values['item'] = $modification; $values['values'] = array(); foreach ($modificationPropertyValues as $modificationPropertyValue) { $values['values'][] = $modificationPropertyValue->getOptions(); } $modificationsTableValues[] = $values; } $jsonData['rows'] = $modificationsTableValues; //Zend_Debug::dump($jsonData); } $this->_helper->json->sendJson($jsonData); }
/** * @param $id_product * @return Catalog_Model_Subproducts[]|null */ private function _getProductModifications($id_product) { $cache = Zend_Registry::get('cache'); $cacheName = 'productModifications_' . $id_product; if (!($modifications = $cache->load($cacheName))) { ini_set('max_execution_time', 900); $modifications = $this->_modelProductsMapper->findSubproductsRel($id_product); $cache->save($modifications, $cacheName, array('api', 'Catalog', 'productModifications')); } return $modifications; }
/** * @param SimpleXMLElement $element * @param Catalog_Model_Products $product */ public function addModificationTableXml(SimpleXMLElement $element, Catalog_Model_Products $product) { $selectModification = $this->_subproductsModelMapper->getDbTable()->select()->order('order ASC'); $cache = Zend_Cache::factory('Core', 'File', array('lifetime' => 3600 * 24 * 2, 'automatic_serialization' => true), array('cache_dir' => '../cache/modifications/')); if (!($modifications = $cache->load('modifications' . $product->getId()))) { $modifications = $this->_productsModelMapper->findSubproductsRel($product->getId(), $selectModification); $cache->save($modifications, 'modifications' . $product->getId(), array('modificationsTable')); } if ($modifications && !empty($modifications)) { $selectSubproductParams = $this->_subproductsParamsMapper->getDbTable()->select()->order('order ASC'); $subproductProperty = $this->_productsModelMapper->findSubproductParams($product->getId(), $selectSubproductParams); foreach ($modifications as $modification) { /* @var $modification Catalog_Model_Subproducts */ $row = $element->addChild('tr'); $row->addAttribute('id', $modification->getId()); $row->addChild('td', $modification->getSku())->addAttribute('title', 'Наименование'); foreach ($subproductProperty as $property) { /* @var $property Catalog_Model_SubproductParams */ $row->addChild('td', $this->_getModificationParamValue($modification->getId(), $property->getId()))->addAttribute('title', $property->getName()); } } } }
/** * @param Catalog_Model_Products $product * @param bool $toWin * @return array */ public function productModificationTableValues(Catalog_Model_Products $product, $toWin = false) { $productMapper = new Catalog_Model_Mapper_Products(); $subproducts = new Catalog_Model_Mapper_Subproducts(); $select = $subproducts->getDbTable()->select()->order('order ASC'); $modifications = $productMapper->findSubproductsRel($product->getId(), $select); $modificationsTableValues = array(); if (!empty($modifications)) { $modificationsTableValues['headTable'] = $this->productModificationTableTitle($product, $toWin); foreach ($modifications as $modification) { $modificationPropertyValues = $subproducts->findSubProductParamValue($modification->getId()); $values = array(); $values[] = $modification->getSku(); foreach ($modificationPropertyValues as $modificationPropertyValue) { $values[] = !$toWin ? $modificationPropertyValue->getValue() : $this->_toWindow($modificationPropertyValue->getValue()); } $modificationsTableValues[] = $values; } } return $modificationsTableValues; }
public function printAction() { $fullPath = $this->getFullPath(); $products = new Catalog_Model_Mapper_Products(); $product = new Catalog_Model_Products(); $product = $products->findByFulPath($fullPath, $product); if (is_null($product)) { throw new Zend_Controller_Action_Exception("Страница не найдена", 404); } $subproducts = new Catalog_Model_Mapper_Subproducts(); $select = $subproducts->getDbTable()->select()->where('deleted != ?', 1)->order('order ASC'); $modifications = $products->findSubproductsRel($product->getId(), $select); $tableModifications = array(); $headTable = array(); if (!empty($modifications)) { $subproductParams = new Catalog_Model_Mapper_SubproductParams(); $select = $subproductParams->getDbTable()->select()->order('order ASC'); $subproductProperty = $products->findSubproductParams($product->getId(), $select); $headTable[] = 'Название'; foreach ($subproductProperty as $property) { $headTable[] = $property->name; } $tableModifications = $this->modificationsTableValues($modifications); array_unshift($tableModifications, $headTable); } //print_r(count(array_shift($tableModifications))-1); $pdf = new Catalog_Model_PrintPdf(); // set document information $pdf->SetAuthor('Альфа Гидро'); $pdf->SetTitle($this->transformSku($product->getSku()) . '. ' . $product->getName()); $pdf->SetSubject($this->transformSku($product->getSku()) . '. ' . $product->getName()); $pdf->SetKeywords($this->transformSku($product->getSku()) . ', ' . $product->getName()); $pdf->SetFont('', '', 12, '', true); $pdf->setProduct($product); // Add a page $pdf->AddPage(); $pdf->showImages()->showProperty()->showDescription()->showModificatonTable($tableModifications); $pdf->Output(); $this->getResponse()->setHeader('Content-Type', 'application/pdf'); $this->_helper->layout()->disableLayout(); }