Прайс-лист - страница 7 - [VM1] Модификации и хаки

$dbc2->query($query);
				while ($dbc2->next_record()) {
					$category_id = $dbc2->f("category_id");
					$category_name = $dbc->f("category_name") . " - " . $dbc1->f("category_name") . " - " . $dbc2->f("category_name");
					show_category($category_id,$category_name,$mode,$displaymanuf);
}

$dbc2->query($query);
				while ($dbc2->next_record()) {
					$category_id = $dbc2->f("category_id");
					$category_name = $dbc->f("category_name") . " - " . $dbc1->f("category_name") . " - " . $dbc2->f("category_name");
					show_category($category_id,$category_name,$mode,$displaymanuf);

					$query  = "SELECT * FROM #__{vm}_category, #__{vm}_category_xref ";
					$query .= "WHERE #__{vm}_category.category_publish='Y' AND ";
					$query .= "(#__{vm}_category_xref.category_parent_id='" . $category_id . "') AND ";
					$query .= "#__{vm}_category.category_id=#__{vm}_category_xref.category_child_id ";
					$query .= "ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC";
					$dbc3->query($query);
					while ($dbc3->next_record()) {
						$category_id = $dbc3->f("category_id");
						$category_name = $dbc->f("category_name") . " - " . $dbc1->f("category_name") . " - " . $dbc2->f("category_name"). " - " . $dbc3->f("category_name");
						show_category($category_id,$category_name,$mode,$displaymanuf);
}
}

<?php
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
/**
* This is the price-list file!
*
* @version $Id: shop.browse.php 743 2007-03-02 10:08:37Z MURAT $
* @package VirtueMart
* @subpackage html
* @copyright Copyright (C) 2004-2005 Soeren Eberhardt. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* VirtueMart is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.
*
* http://virtuemart.net
*/
mm_showMyFileName( __FILE__ );
require_once (CLASSPATH."ps_product.php");
$ps_product = new ps_product;

global $mainframe, $pageNav,$VM_LANG;
require_once( $mosConfig_absolute_path . '/administrator/includes/pageNavigation.php' );
$mainframe->SetPageTitle('Прайс-лист');

function kram($category_id,$category_name) {
$db = new ps_DB;
 global $Itemid,$VM_LANG,$ps_product;
//$pageNav = new mosPageNav( $total, $limitstart, $limit );
	$query  = "SELECT * FROM #__{vm}_product p INNER JOIN #__{vm}_product_category_xref x ";
	$query .= "ON (p.product_id=x.product_id) WHERE x.category_id=" . $category_id;
	$query .= " AND p.product_publish='Y' ORDER BY p.product_sku";

    $db->query($query);

echo '<tr><th align="center" valign="top" bgcolor="#F5F5F5" colspan="7"> '.$VM_LANG->_PHPSHOP_CATEGORY_FORM_NAME.': <a href="index.php?page=shop.browse&amp;category_id='.$category_id.'&amp;option=com_virtuemart&amp;Itemid='.$Itemid.'">'.$category_name.'</a></th></tr>';
$kol = 1;



while( $db->next_record()) { ?>

   <tr>
      <td align="left" valign="top" bgcolor="#F5F5F5">
	  <?php echo $kol; ?>
      </td>
      <td align="left" valign="top" bgcolor="#F5F5F5">
	  <?php echo $db->f("product_sku"); ?>
      </td>
      <td align="left" valign="top" bgcolor="#F5F5F5">
	  <a href="<?php echo "index.php?page=shop.product_details&amp;product_id=" . $db->f("product_id") . "&amp;option=com_virtuemart&amp;Itemid=1"; ?>"><?php echo $db->f("product_name"); ?></a>
      </td>

	  <td align="left" valign="top" bgcolor="#F5F5F5">
	  <?php $product_desc = $db->f("product_s_desc");
	  if (empty($product_desc)) {
	  echo _CMN_NO;
	  } else {
	  echo $db->f("product_s_desc");
	  } ?>
      </td>

      <td align="left" valign="top" bgcolor="#F5F5F5">
	  <?php echo $product_price = $ps_product->show_price($db->f("product_id")); ?>
      </td>
   </tr>
<?php

$kol++;
}
if($kol==1) {
    
echo '<tr><td align="left" valign="top" bgcolor="#F5F5F5" colspan="7">'._EMPTY_CATEGORY.'</td>';
}
echo '<tr><td  colspan="7"><br /></td></tr>';
//echo $pageNav->getListFooter();
}
	
	$dbk = new ps_DB;
	
	$query  = "SELECT * FROM #__{vm}_category, #__{vm}_category_xref ";
	$query .= "WHERE #__{vm}_category.category_publish='Y' AND ";
	$query .= "(#__{vm}_category_xref.category_parent_id<>'' OR #__{vm}_category_xref.category_parent_id<>'0') AND ";
//	$query .= "(#__{vm}_category_xref.category_parent_id='' OR #__{vm}_category_xref.category_parent_id='0') AND ";
        $query .= "#__{vm}_category.category_id=#__{vm}_category_xref.category_child_id ";
	$query .= "ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC";
	
	$dbk->query($query);
			
?>
<h3>Прайс-лист</h3>
<table width="100%" border="0" cellspacing="2" cellpadding="4">
   <tr>
      <th align="left" valign="top" bgcolor="#e0e0e0">№</th>
      <th align="left" valign="top" bgcolor="#e0e0e0"><?php  echo $VM_LANG->_PHPSHOP_PRODUCT_FORM_SKU;?></th>
      <th align="left" valign="top" bgcolor="#e0e0e0"><?php  echo $VM_LANG->_PHPSHOP_PRODUCT_FORM_NAME;?></th>
	  <th align="left" valign="top" bgcolor="#e0e0e0"><?php echo $VM_LANG->_PHPSHOP_PRODUCT_FORM_DESCRIPTION;?></th>
      <th align="left" valign="top" bgcolor="#e0e0e0"><?php  echo $VM_LANG->_PHPSHOP_PRICE_LIST_PRICE;?></th>
   </tr>
<?php
	while ($dbk->next_record()) {
		$category_id = $dbk->f("category_id");
		$category_name = $dbk->f("category_name");
	    kram($category_id,$category_name);
	}
	echo '</table>';