Cherry Picker и подкатегории VirtueMart - [VM1] Модификации и хаки

public function apprehendPTID($custom_ptid=0){
		$ptid=0;
		$db=& JFactory::getDBO();
		//if(chpconf::option('custom_ptid')){
		//if($custom_ptid){
			//$ptid=chpconf::option('custom_ptid');
			//$ptid=$custom_ptid;
		//}else{
			$url_ptid=JRequest::getVar('product_type_id','');
			if ( empty($url_ptid) ) {  // if product_type_id in a link - we do not make query
				$category_id=JRequest::getVar('category_id','');
				if (!empty($category_id)){
					$q = "SELECT pptx.`product_type_id`".
						 " FROM (`#__vm_product_product_type_xref` as pptx, `#__vm_product` as p)".
						 " LEFT JOIN `#__vm_product_type` as orderid".
						 " ON pptx.`product_type_id`=orderid.`product_type_id`".
						 " LEFT JOIN `#__vm_product_category_xref` as pcx ".
						 " ON pptx.`product_id`=pcx.`product_id`".
						 " WHERE pcx.`category_id`='$category_id'".
						 " AND p.`product_id`=pcx.`product_id`".
						 " AND p.`product_publish`='Y'";
						
						
					
					if( CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != "1") {
						$q .= ' AND p.`product_in_stock` > 0';
					}
					$q.= " ORDER BY orderid.`product_type_list_order` ASC";
					$q.= " LIMIT 0 , 1";
					$db->setQuery($q);
					$ptid=$db->loadResult();
				} else{
			$ptid=$custom_ptid;	
			}	
			}else{
				$ptid=$url_ptid;
			//$ptid=$custom_ptid;	
			}
		//}
		// set the ptid for further use
		$this->_ptid=$ptid;
	}

public function apprehendBaseQuery(){
		$category_id=JRequest::getInt('category_id','');
		$manufacturer_id=JRequest::getVar('manufacturer_id','');
		
		//$columns="pt.`product_id`, `category_id`";
		//$columns="pt.`product_id`";
		$joins="LEFT JOIN `#__vm_product` as p ON pt.`product_id`=p.`product_id`";
		$where="AND p.`product_publish`='Y'";
		
		$lp=(chpconf::option('include_tax'))? $this->low_price/chpconf::option('tax') : $this->low_price;
		$hp=(chpconf::option('include_tax'))? $this->high_price/chpconf::option('tax') : $this->high_price;
		if($lp || $hp){
			$joins.= " LEFT JOIN `#__vm_product_price` as pr ON p.`product_id`=pr.`product_id`";
		}
		if($manufacturer_id){
			$joins.=" LEFT JOIN `#__vm_product_mf_xref` as pm ON pm.`product_id`=p.`product_id`";
			$where.=" AND pm.`manufacturer_id`=$manufacturer_id";
		}
		
		//if($category_id && !chpconf::option('custom_ptid')){ // becuase we use custom PTI in some category - we don't want wrong category_id to be added
if($category_id){
if($category_id='АЙДИ РОДИТЕЛЬСКОЙ КАТЕГОРИИ'){
$tables="`#__vm_product_type_АЙДИФИЛЬТРА` as pt, `#__vm_product_category_xref` as pcx";
$where="pt.`product_id`=pcx.`product_id` ".$where;
}elseif($category_id='АЙДИ РОДИТЕЛЬСКОЙ КАТЕГОРИИ'){
$tables="`#__vm_product_type_АЙДИФИЛЬТРА` as pt, `#__vm_product_category_xref` as pcx";
$where="pt.`product_id`=pcx.`product_id` ".$where;
}else{
			$tables="`#__vm_product_type_{$this->ptid()}` as pt";
			$joins="LEFT JOIN `#__vm_product_category_xref` as pcx ON pt.`product_id`=pcx.`product_id` ".$joins;
			//$where="pcx.`category_id`=$category_id ".$where;
			// uncomment this, comment above 1 line--for search with Child Products
			$where="(pcx.`category_id`=$category_id OR `product_parent_id`<>0) ".$where;
		}}else{
			$tables="`#__vm_product_type_{$this->ptid()}` as pt, `#__vm_product_category_xref` as pcx";
			$where="pt.`product_id`=pcx.`product_id` ".$where;
			// uncomment this, comment above 2 lines--for search with Child Products
			//$tables="`#__vm_product_type_{$this->ptid()}` as pt";
			//$where="1 ".$where;
		}
		
		if($lp && !$hp){
			$where.=" AND `product_price`>=".$lp;
		}
		elseif(!$lp && $hp){
			$where.=" AND `product_price`<=".$hp;
		}
		elseif($lp && $hp && ($hp>$lp)){
			$where.=" AND `product_price` BETWEEN ".$lp." AND ".$hp;
		}
		
		//if(CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != "1"){
		//	$where.= " AND p.`product_in_stock`>0";
		//}
		
		//$query="SELECT $columns FROM ($tables) $joins WHERE $where";
		$query="SELECT COUNT(*) FROM ($tables) $joins WHERE $where";
		$this->_basequery=$query;
		//echo $query;
	}