Esempio n. 1
0
 protected static function getDbConnection()
 {
     if (self::$_connection === null) {
         self::$_connection = self::getDbResource()->getConnection('core_read');
     }
     return self::$_connection;
 }
Esempio n. 2
0
 public function clearCacheAction()
 {
     $tableName = Vikont_Fitment_Helper_Db::getDbResource()->getTableName('core/config_data');
     $sql = 'DELETE FROM ' . $tableName . ' WHERE path LIKE "fitment/cache/%"';
     Vikont_Fitment_Helper_Db::executeQuery($sql);
     die;
 }
Esempio n. 3
0
 public function detectSimpleProduct($ariProductId, $ariActivityId, $fitmentId = null)
 {
     /*
     		$skuInfo = Mage::helper('fitment/api')
     				->preventErrorReporting()
     				->request('fitmentnotes',
     						array(
     							'productID' => $ariProductId,
     							'fitmentID' => $fitmentId,
     						)
     					);/**/
     $skuInfo = Mage::helper('fitment/api')->request('skuinfo', array('activityId' => $ariActivityId, 'productId' => $ariProductId), array('fitmentId' => $fitmentId));
     Mage::register('skuInfo', $skuInfo);
     if (!count($skuInfo)) {
         Mage::log(sprintf('ERROR: Unable to find product: SKU info is empty: ARI activity=%d, ARI product=%d,  fitment=%d', $ariActivityId, $ariProductId, $fitmentId));
         //			Mage::log(sprintf('ERROR: Unable to find product: SKU info is empty: ARI product=%d,  fitment=%d',
         //					$ariProductId, $fitmentId));
         return null;
     }
     $skus = array();
     foreach ($skuInfo as $skuInfoItem) {
         $skus[] = $skuInfoItem['Id'];
         //			$skus[] = $skuInfoItem['SkuId'];
     }
     $productId = Vikont_Fitment_Helper_Db::getTableValue(Vikont_Fitment_Helper_Db::getTableName('catalog/product'), 'entity_id', 'type_id="simple" AND sku IN ("' . implode('","', $skus) . '")');
     if (!$productId) {
         //			Mage::log(sprintf('ERROR: Unable to find a product: ARI product=%d, fitment=%d, ARI product SKU=%d', $ariProductId, $fitmentId, implode(', ', $skus)));
         Mage::log(sprintf('ERROR: Unable to find a product: ARI activity=%d, ARI product=%d, fitment=%d, ARI product SKU=%d', $ariActivityId, $ariProductId, $fitmentId, implode(', ', $skus)));
     }
     return $productId;
 }
Esempio n. 4
0
 public function viewAction()
 {
     $skuId = $this->getRequest()->getParam('sku');
     if (!$skuId) {
         $this->_redirectReferer();
     }
     try {
         $productId = Vikont_Fitment_Helper_Db::getTableValue(Vikont_Fitment_Helper_Db::getTableName('catalog/product'), 'entity_id', 'type_id="' . Mage_Catalog_Model_Product_Type::TYPE_SIMPLE . '" AND sku="' . addslashes($skuId) . '"');
         $product = Mage::getModel('catalog/product')->load($productId);
         if ($product->getId()) {
             $url = $product->getProductUrl();
             if ($product->getTypeId() == Mage_Catalog_Model_Product_Type::TYPE_SIMPLE) {
                 $params = $this->getRequest()->getParams();
                 unset($params['sku']);
                 $params['from'] = 'fitment';
                 $url .= '?' . http_build_query($params);
             }
             $this->getResponse()->setRedirect($url);
             return;
         }
     } catch (Exception $e) {
         Mage::logException($e);
     }
     $this->_redirectReferer();
 }