Дочерние товары таблицей - страница 2 - [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='.$withParent)) continue;

$res[]= '<tr><td><a class="modal" href="'.$arr['tovarmodimage'].'"><img class="product-image" src="'.$arr['tovarimage'].'"></a></td>
<td><a href='.$arr['value'].'>'.$arr['text'].'</a></td><td>'.$arr['articul'].'</td>...

if (!empty($child->product_parent_id)){$is_child=1;}
else{$is_child=0;}

if($is_child==1){	$_products[$productKey]->customfields = $parentProduct->customfields;}

if ($withParent <> $this->_id ){//добыча настраиваемых полей для дочернего товара
	$q.= ' WHERE (`product_parent_id` = "'.$this->_id.'" OR virtuemart_product_id="'.$this->_id.'" )AND `virtuemart_product_id` <> "'.$withParent.'"';
}
else{//добыча настраиваемых полей для родительского товара
	$q.= ' WHERE `product_parent_id` = "'.$this->_id.'"';
}

$res[]= '<tr><td><a class="modal" href='.JRoute::_('index.php?option=com_virtuemart').$arr['tovarmodimage'].'>
<img class="product-image" src='.JRoute::_('index.php?option=com_virtuemart').$arr['tovarimage'].'></a>
 
</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_prices`
			USING (`virtuemart_product_id`) ';

			$q .= ' WHERE `product_parent_id` = "'.$this->_id.'" OR `virtuemart_product_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 p.pordering ASC';
			$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;
	}

$options = array();

$session = JFactory::getSession ();
$virtuemart_category_id = $session->get ('vmlastvisitedcategoryid', 0, 'vm');

$productModel = VmModel::getModel ('product');
$productModel->setId($product->virtuemart_product_id);

VirtueMartModelCustomfields::bindParameterableByFieldType($customfield);
$selected = JRequest::getVar ('virtuemart_product_id',0);

if(is_array($selected) ) {
	$selected = $selected[0];
}
$selected = (int) $selected;

$html = '';
$uncatChildren = $productModel->getUncategorizedChildren ($customfield->withParent);

if(empty($uncatChildren)){
	return $html;
break;
}

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'],
	'tovarmodimage' =>$child['file_url'], 'tovarprice' =>$child['product_price'] );}
	
	$res=array();
						
	$table='<div class="tabletov"><table width="100%">
	<tr><th width="30%">Название</th><th>Цена</th><th>Купить</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='.$selected)) continue;
		
		$res[]= '
			<tr>
				<td><a href='.$arr['value'].'>'.$arr['text'].'</a></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="0" />
						</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="Добавить в корзину" />
						</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>';
							
		}

		$str = implode($res);
		$html = $table.''.$str.'</table></div>';
		return $html;

$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 (`product_parent_id` = "'.$this->_id.'" AND (pc.`virtuemart_category_id`) IS NULL  ) OR (`virtuemart_product_id` = "'.$this->_id.'" ) ';
			if ($withParent <> $this->_id ){//добыча настраиваемых полей для дочернего товара
	$q.= ' WHERE (`product_parent_id` = "'.$this->_id.'" OR virtuemart_product_id="'.$this->_id.'" )AND `virtuemart_product_id` <> "'.$withParent.'"';
}
else{//добыча настраиваемых полей для родительского товара
	$q.= ' WHERE `product_parent_id` = "'.$this->_id.'"';
}

case 'A':
$options = array();
$session = JFactory::getSession();
$virtuemart_category_id = 
  $session->get('vmlastvisitedcategoryid', 0, 'vm');
$productModel = VmModel::getModel('product');
$withParent = 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'],'articul' =>$child['product_sku'],'volume' =>$child['product_weight'],
'tovarprice' =>$child['product_price'] );}
 
 $res=array();
 $table='<div class="tabletov"><table style="border: 1px solid #cccccc; "border="1">
 <tr>
 <th>Название</th>
 <th>Мощность</th>
  <th>Цена</th>
  <th>Купить</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 href='.$arr['value'].'>'.$arr['text'].'</a></td>
<td>'.round($arr['volume']).' кВт.</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">
<button class="quantity-controls quantity-plus" type="button" />
<i class="icon-angle-up"></i>
</button>
<button class="quantity-controls quantity-minus" type="button" />
<i class="icon-angle-down"></i>
</button>
</span>
<span class="addtocart-button"><input type="submit" name="addtocart"  
class="addtocart-button" value="В корзину" /></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 '<br>'.$table.''.$str.'</table></div>';
break;

<?php $custom_title = null;
if (!empty($product->customfields)) {
foreach ($product->customfields as $field) {
if ($field->is_hidden )
continue;
if ($field->display) { ?>
<span class="product-pole-display"><?php echo $field->display ?></span>
<?php } ?> <?php } ?> <?php }  ?>