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();
}
