Phoca Forum

Code: Select all

<?php
/*
 * @package Joomla 1.5
 * @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
 *
 * @component Phoca Gallery
 * @copyright Copyright (C) Jan Pavelka www.phoca.cz
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
 * Revised by Joe "Moto' Motacek for VirtueMart 2 RC
 */
defined( '_JEXEC' ) or die( 'Restricted access' );

class PhocaGalleryVirtueMart
{
	function getVmLink($id, &$errorMsg) {
	
		$dbO =& JFactory::getDBO();

		if (is_file( JPATH_ADMINISTRATOR.DS.'components'.DS.'com_virtuemart'.DS.'helpers'.DS.'config.php')) {
			//echo is_file( JPATH_ADMINISTRATOR.DS.'components'.DS.'com_virtuemart'.DS.'helpers'.DS.'config.php');
			require_once( JPATH_ADMINISTRATOR.DS.'components'.DS.'com_virtuemart'.DS.'helpers'.DS.'config.php' );
		} else {
			$errorMsg = 'VirtueMart Cfg Not Found';
			echo $errorMsg . "</br>";
			return false;
		}
		
		
		if (VM_TABLEPREFIX && FLYPAGE) {     //IDK what this is looking at to be honest :( - Moto
			$vmPrefixC 		= 'virtuemart';  //why would this not be "virtuemart"  I don't think this is a setting you can change during install 
			//plus thisisn't working as a variable in the queries for some reason, I'm no php and mySQL expert though
			
			//$flyPageC		= FLYPAGE;       //Needs to be redone at some point (Changed to VIEW)
			
			//New Database call to find stock of current item
			$stockQuery = 'SELECT product_in_stock FROM  #__'.$vmPrefixC.'_products WHERE virtuemart_product_id =' . (int) $id;
			$dbO->setQuery($stockQuery);
			$result = $dbO->loadObject();
			if (isset($result->product_in_stock)){
				$checkStockC = (int) $result->product_in_stock;
			}
			else {
				$errorMsg = "Could not find product stock";
				echo $errorMsg . "</br>";
				return false;
			}
			
			//New Database call to find we show out of stock products
			$stockQuery = 'SELECT config FROM  #__'.$vmPrefixC.'_configs WHERE virtuemart_config_id = 1';
			$dbO->setQuery($stockQuery);
			$result = $dbO->loadObject();
			if (isset($result->config)){
				//Crappy thing about the config info in the virtuemart database is it's all stored in base64 encrypted values all in the same string so this is going to look stupid
				$OStemp = (string) $result->config;
				$startPOS = strpos($OStemp, 'show_out_of_stock_products');
				$endPOS = strpos($OStemp, '|', $startPOS);
				$endPOS = $endPOS - $startPOS;
				$OStemp = substr($OStemp, $startPOS, $endPOS);
				$OStemp = parse_str($OStemp);
				if($show_out_of_stock_products == "czoxOiIxIjs="){//Means yes
					$showOutStockC = 1;
				}
				else if ($show_out_of_stock_products == "czoxOiIwIjs="){//Means no
					$showOutStockC = 0;
				}
				else{
					$errorMsg = "Could not find cofiguration variable";
					echo $errorMsg . "</br>";
					return false;	
				}
			}
			else {
				$errorMsg = "Could not find configuration variable";
				echo $errorMsg . "</br>";
				return false;
			}
		} 
		else {
			$errorMsg = 'VirtueMart Constants Not Found';
			echo $errorMsg . "</br>";
			return false;
		}

		if( $checkStockC && $showOutStockC != "1") {
		    $checkStockSql = " AND product_in_stock > 0";
	    } 
		else {
			$checkStockSql = '';
		}
		
		// We check publish and if the product is published
		$query = 'SELECT published FROM  #__'.$vmPrefixC.'_products WHERE virtuemart_product_id =' . (int) $id . $checkStockSql;
		$dbO->setQuery($query);
		$publish = $dbO->loadObject();
		
		if (isset($publish->published) && $publish->published == '1') {
			$query = 'SELECT virtuemart_category_id FROM #__'.$vmPrefixC.'_product_categories WHERE virtuemart_product_id = '.(int) $id;
			$dbO->setQuery($query);
			$categoryId = $dbO->loadObject();
		
			if (isset($categoryId->virtuemart_category_id)) {
				
				$itemId		= PhocaGalleryVirtueMart::_getVmItemid(); //Not sure why this is here or what it's really trying to do yet since i'm not using the virtuemart menu 
				
				//the way that I understand MVC the defualt for the productdetail view is set else where so...
				//aslong as we always want the product details we don't need to figure out which flypage our view to use since...
				//the system will automatically use the one that the user selects in the virtuemart settings.
				//That's why I removed the _getFlyPage function no longer necessary
				$vmLink 	= 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $id . '&virtuemart_category_id/' . (int) $categoryId->virtuemart_category_id . '/' . $itemId;
				return $vmLink;
			} 
			else {
				$errorMsg = 'VirtueMart Category Not Found';
				return false;
			}
		
		} 
		else {
			$errorMsg = 'VirtueMart Product Not Found';
			echo $errorMsg . "</br>";
			return false;
		}
	}
	
	function _getVmItemid() {
		// Set Itemid id, exists this link in Menu?
		// I'm not using the VM Meun so I'm probably not going ot fix this :P - Moto
		$menu 	= &JSite::getMenu();
		$itemVM	= $menu->getItems('link', 'index.php?option=com_virtuemart');
		

		if(isset($itemVM[0])) {
			$itemId = $itemVM[0]->id;
		} else {
			$itemId = 0;
		}
	
		return $itemId;
	}
}