Дочерние товары таблицей - [VM2&3] Модификации и хаки

                foreach($options as $arr): if ( $arr['value'] === JRoute::_('index.php?option=com_virtuemart&view=productdetails&virtuemart_category_id='.$virtuemart_category_id. '&virtuemart_product_id='.$selected)) continue; $res[]= '<tr><td><a class="modal" href='.JRoute::_('').$arr['tovarmodimage'].'><img class="product-image" src='.JRoute::_('').$arr['tovarimage'].'></a></td>

	public function getUncategorizedChildren ($withParent) {
		if (empty($this->_uncategorizedChildren)) {
	$q = 'SELECT `product_parent_id` FROM `#__virtuemart_products` WHERE `virtuemart_product_id` = "' . $this->_id . '" ';
			$this->_db->setQuery ($q);
			$product_parent_id = $this->_db->loadResult();
			//Todo add check for shoppergroup depended product display
			$q = 'SELECT * FROM `#__virtuemart_products` as p
				LEFT JOIN `#__virtuemart_products_' . VMLANG . '` as pl
				USING (`virtuemart_product_id`)
				LEFT JOIN `#__virtuemart_product_categories` as pc
				USING (`virtuemart_product_id`) ';

public function getUncategorizedChildren ($withParent) {
 
    $q = 'SELECT * FROM `#__virtuemart_products` as p
      LEFT JOIN `#__virtuemart_products_'.VMLANG.'` as pl
      USING (`virtuemart_product_id`)
            LEFT JOIN `#__virtuemart_product_medias`
      USING (`virtuemart_product_id`)
            LEFT JOIN `#__virtuemart_medias`
            USING (`virtuemart_media_id`)
            LEFT JOIN `#__virtuemart_product_prices`
      USING (`virtuemart_product_id`)';
 
    $q .= ' WHERE `ordering`="1" AND `product_parent_id` = "'.$this->_id.'"  
OR `virtuemart_product_id` = "'.$this->_id.'" ';

case 'A':

					$options = array();
                $session = JFactory::getSession();
                $virtuemart_category_id =
                $session->get('vmlastvisitedcategoryid', 0, 'vm');
                $productModel = VmModel::getModel('product');
                $selected = JRequest::getInt('virtuemart_product_id');
                $uncatChildren = $productModel->getUncategorizedChildren($withParent);
                foreach($uncatChildren as $k =>$child ){
                $options[] = array( 'value' => JRoute::_
                ('index.php?option=com_virtuemart&view=productdetails&virtuemart_category_id=
                '.$virtuemart_category_id.'&virtuemart_product_id='.$child['virtuemart_product_id']),
                'id'=>$child['virtuemart_product_id'],
                'text' =>$child['product_name'],'tovarimage' =>$child['file_url_thumb'],'articul' =>$child['product_sku'],
				'volume' =>$child['product_weight'],
                'tovarmodimage' =>$child['file_url'], 'tovarprice' =>$child['product_price'] );}
                //var_dump($options);  
                $res=array();
                $table='<div style="padding: 10px 0;"><table width="100%" class="zebra">
                <tr>
				<!--<th>'. JText::_ ('COM_VIRTUEMART_PRODUCT_IMAGE').'</th>
                <th width="30%">'. JText::_ ('COM_VIRTUEMART_CART_NAME').'</th>-->
				<th width="20%">'. JText::_ ('COM_VIRTUEMART_PRODUCT_SKU').'</th><th>'. JText::_ ('COM_VIRTUEMART_PRODUCT_VOLUME').'</th><th>'. JText::_ ('COM_VIRTUEMART_PRODUCT_PRICE').'</th><th>'. JText::_ ('COM_VIRTUEMART_CART_ADD_TO_BUY').'</th></tr>';

                foreach($options as $arr):
                if ( $arr['value'] === JRoute::_('index.php?option=com_virtuemart&view=productdetails&virtuemart_category_id='.$virtuemart_category_id.
                '&virtuemart_product_id='.$withParent)) continue;
                $res[]= '<tr>
				<!--<td><a class="modal" href="'.JRoute::_('').$arr['tovarmodimage'].'"><img class="product-image" src="'.$arr['tovarimage'].'"></a></td>
				<td>'.$arr['text'].'</td>-->
				<td>'.$arr['articul'].'</td><td>'.round($arr['volume'],0).' ml</td>
				<td>'.$currency->priceDisplay((float)$arr['tovarprice']).'</td>
                <td><form method="post" class="product js-recalculate" action="index.php" >
                <span class="quantity-box">
                <input type="text" class="quantity-input js-recalculate" name="quantity[]" value="1" /></span>
                <!--<span class="quantity-controls js-recalculate">
                <input type="button" class="quantity-controls quantity-plus" />
                <input type="button" class="quantity-controls quantity-minus" /></span>-->
                <span class="addtocart-button"><input type="submit" name="addtocart"
                class="addtocart-button" value="'. JText::_ ('COM_VIRTUEMART_CART_ADD_TO').'" /></span>
                <input class="pname" type="hidden" value='.$arr['text'].'>
                <input type="hidden" value="com_virtuemart" name="option">
                <input type="hidden" value="cart" name="view">
                <noscript><input type="hidden" name="task" value="add" /></noscript>
                <input type="hidden" value='.$arr['id'].' name="virtuemart_product_id[]">
                <input type="hidden" value="0" name="virtuemart_category_id[]"></form></td></tr>';
                endforeach;
                $str = implode($res);
                return $table.''.$str.'</table>';
					break;

<th>'. JText::_ ('COM_VIRTUEMART_PRODUCT_VOLUME').'</th>

<td>'.round($arr['volume'],0).' ml</td>

public function getUncategorizedChildren ($withParent) {
      if (empty($this->_uncategorizedChildren)) {

    $q = 'SELECT * FROM `#__virtuemart_products` as p
      LEFT JOIN `#__virtuemart_products_'.VMLANG.'` as pl
      USING (`virtuemart_product_id`)
            LEFT JOIN `#__virtuemart_product_medias`
      USING (`virtuemart_product_id`)
            LEFT JOIN `#__virtuemart_medias`
            USING (`virtuemart_media_id`)
            LEFT JOIN `#__virtuemart_product_prices`
      USING (`virtuemart_product_id`)';
 
         if ($withParent) {    $q .= ' WHERE `ordering`="1" AND `product_parent_id` = "'.$this->_id.'"';    }
                  else {   $q .= ' WHERE `product_parent_id` = "' . $this->_id . '" ';   }

         $app = JFactory::getApplication ();
         if ($app->isSite () && !VmConfig::get ('use_as_catalog', 0) && VmConfig::get ('stockhandle', 'none') == 'disableit') {
            $q .= ' AND p.`product_in_stock`>"0" ';         }

         if ($app->isSite ()) {   $q .= ' AND p.`published`="1"';   }

         $q .= ' GROUP BY `virtuemart_product_id` ORDER BY ordering DESC';
         $this->_db->setQuery ($q);
         $this->_uncategorizedChildren = $this->_db->loadAssocList ();
         $err = $this->_db->getErrorMsg ();
         if (!empty($err)) {
            vmError ('getUncategorizedChildren sql error ' . $err, 'getUncategorizedChildren sql error');
            vmdebug ('getUncategorizedChildren ' . $err);
            return FALSE;
         }
      }
      return $this->_uncategorizedChildren;
   }