Проблема с mod_vm_multidisplay

При отображении Show random products модуль выводит всего 2 продукта, по одному на строку, не учитывая настройки (кол-во столбцов на кол-во строк) в админке, подскажите кто сталкивался с проблемой как её решить.

Полный код модуля.

Код

<?php
if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );
/**
 * All-in-one module for VirtueMart
 * includes:
 * Latest Products Manager
 * Top Ten Products Manager
 * Special Products Manager
 * (All Modules originally designed by Mr PHP)
 * Modified by Jason Lim (Eko Solution)
 * Original version $Id: mod_virtuemart_allinone.php 1232 2008-02-09 15:53:22Z soeren_nb $
 * @package VirtueMart
 * @subpackage modules
 *
 * Conversion to Mambo and the rest:
 * 	@copyright (C) 2004-2008 soeren
 *
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
 * VirtueMart is Free Software.
 * VirtueMart comes with absolute no warranty.
 *
 * www.virtuemart.net
 */

// retrieve parameters
$show_new = $params->get( 'show_new', 0 );
$show_topten = $params->get( 'show_topten', 0 );
$show_special = $params->get( 'show_special', 0 );
$show_random = $params->get( 'show_random', 0 );
$show_price = (bool)$params->get( 'show_price', 1 ); // Display the Product Price?
$show_addtocart = (bool)$params->get( 'show_addtocart', 1 ); // Display the "Add-to-Cart" Link?
$max_items = $params->get( 'max_items', 5 );//no of items to display
$display_style = $params->get( 'display_style', "horizontal" ); // Display Style
$topten_tabname = $params->get( 'topten_tabname', "Most Popular Products" );
$featured_tabname = $params->get( 'featured_tabname', "Featured Products" );
$random_tabname = $params->get( 'random_tabname', "Random Products" );
$new_tabname = $params->get( 'new_tabname', "New Arrival" );
$products_per_row = $params->get( 'products_per_row', 5 );
  
$count_mods = $show_new + $show_topten + $show_special + $show_random;
$max_mods = $count_mods;

// check if parameters are given
// if no, give default values
if ($count_mods == 0) { 
    $max_mods = $count_mods = 3;
    $show_new = '1';
    $show_topten = '1';
    $show_special = '1';
}

// Load the VirtueMart main parse code
if( file_exists(dirname(__FILE__).'/../../components/com_virtuemart/virtuemart_parser.php' )) {
	require_once( dirname(__FILE__).'/../../components/com_virtuemart/virtuemart_parser.php' );
} else {
	require_once( dirname(__FILE__).'/../components/com_virtuemart/virtuemart_parser.php' );
}

global $VM_LANG, $vm_mainframe, $vm_discount, $is_persent;

$tabs = new vmTabPanel(false,true,uniqid('all_in_one'));
function get_discount_ID($product_id) {
	$db = new ps_DB;
	if( !empty( $product_id )) {
		$q  = 'SELECT product_discount_id FROM #__{vm}_product WHERE product_id=' . (int)$product_id;
		$db->setQuery($q); $db->query(); 
	}
	$discount_params = $db->record;
	return $discount_ID = $discount_params[0]->product_discount_id;
}


function get_discount($discount_ID) {
	$db = new ps_DB;
	if( !empty( $discount_ID )) {
		$is_percent = 'SELECT is_percent FROM #__{vm}_product_discount WHERE discount_id=' . (int)$discount_ID;
		$db->setQuery($is_percent);
		$db->query();
		$is_percent_params = $db->record;
		$is_percent = $is_percent_params[0]->is_percent;
		$q  = 'SELECT amount FROM #__{vm}_product_discount WHERE discount_id=' . (int)$discount_ID;
		$db->setQuery($q); 
		$db->query(); 
		
	}
	$prod_params = $db->record;
	$prod_discount = $prod_params[0]->amount;
	if ($is_percent) {
		if ($prod_discount) {$prod_discount = round($prod_discount);
			return $prod_discount."%";
		} else return false;
	} else {
		if ($prod_discount) {$prod_discount = round($prod_discount);
			return $prod_discount.$GLOBALS[CURRENCY_DISPLAY]->symbol;
		} else return false;
	}
//	
}

// In Joomla! 1.0 and Mambo we need to print the style and script declarations when option != com_virtuemart (called from a module)
$print = !vmIsJoomla('1.5', '>=');
$vm_mainframe->render($print);
 
$paneid = uniqid('all_in_one');
$tabs->startPane($paneid);

if ($show_special == '1') { 
	//////////////////////////////
	// Featured / Special products
	//
	$tabs->startTab($featured_tabname, 'featured_'.$paneid);        
  require_once ( CLASSPATH. 'ps_product.php');
  $ps_product = new ps_product;
        
  $db=new ps_DB;
                
  $q  = "SELECT * FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE ";
  $q .= "(#__{vm}_product.product_parent_id='' OR #__{vm}_product.product_parent_id='0') ";
  $q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id ";
  $q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id ";
  $q .= "AND #__{vm}_product.product_publish='Y' ";
  $q .= "AND #__{vm}_product.product_special='Y' ";
  $q .= "ORDER BY product_name DESC ";
  $q .= "LIMIT $max_items ";
  $db->query($q);
  
  if( $db->num_rows() > 0 ){
  ?>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">       
  <?php
        $i = 0;
        while($db->next_record() ){
			print_r ($db->record[$i]->product_id);
			echo $vm_discount = get_discount(get_discount_ID($db->record[$i]->product_id));
			if ($i%2)
				$sectioncolor = "sectiontableentry2";
			else
				$sectioncolor = "sectiontableentry1";
              
			if( $display_style == "vertical" ) {
				?>
				<tr align="center" class="<?php echo $sectioncolor ?>">
					<td><?php $ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart); ?><br /></td>
				</tr>
				<?php
			}
			elseif( $display_style== "horizontal" ) {
				if( $i == 0 )
					echo "<tr>\n";
				echo "<td align=\"center\">";
				$ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart);
				echo "<div class=\"discount\">". $vm_discount ."</div>";
				echo "</td>\n";
				if( ($i+1) == $max_items )
					echo "</tr>\n";
			}
			elseif( $display_style== "table" ) {
				if( $i == 0 )
					echo "<tr>\n";
				echo "<td align=\"center\">";
				$ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart);
				echo "<div class=\"discount\">". $vm_discount ."</div>";
				echo "</td>\n";
				if ( ($i+1) % $products_per_row == 0)
					echo "</tr><tr>\n";
				if( ($i+1) == $max_items )
					echo "</tr>\n";
			}
			$i++;
        }
  ?>
  </table>
  <?php
  }
	$tabs->endTab(); 
  }

if ($show_new == '1') { 
    //////////////////////////////
    // Latest Products
    //
    $tabs->startTab($new_tabname, 'new_'.$paneid);

    require_once ( CLASSPATH. 'ps_product.php');
    $ps_product = new ps_product;
        
    $db=new ps_DB;

    $q  = "SELECT * FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE ";
    $q .= "product_parent_id=''";
    $q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id ";
    $q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id ";
    $q .= "AND #__{vm}_product.product_publish='Y' ";
    $q .= "ORDER BY #__{vm}_product.product_id DESC ";
    $q .= "LIMIT $max_items ";
    $db->query($q);

  if( $db->num_rows() > 0 ){
  ?>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">       
  <?php
        $i = 0;
        while($db->next_record() ){
			$vm_discount = get_discount(get_discount_ID($db->record[$i]->product_id));
			if ($i%2)
				$sectioncolor = "sectiontableentry2";
			else
				$sectioncolor = "sectiontableentry1";
              
			if( $display_style == "vertical" ) {
				?>
				<tr align="center" class="<?php echo $sectioncolor ?>">
					<td><?php $ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart); ?><br />
                    <div class="discount"><?php echo $vm_discount ?></div>
                    </td>
				</tr>
				<?php
			}
			elseif( $display_style== "horizontal" ) {
				if( $i == 0 )
					echo "<tr>\n";
				echo "<td align=\"center\">";
				$ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart);
				echo "<div class=\"discount\">". $vm_discount ."</div>";
				echo "</td>\n";
				if( ($i+1) == $max_items )
					echo "</tr>\n";
			}
			elseif( $display_style== "table" ) {
				if( $i == 0 )
					echo "<tr>\n";
				echo "<td align=\"center\">";
				$ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart);
				echo "<div class=\"discount\">". $vm_discount ."</div>";
				echo "</td>\n";
				if ( ($i+1) % $products_per_row == 0)
					echo "</tr><tr>\n";
				if( ($i+1) == $max_items )
					echo "</tr>\n";
			}
			$i++;
        }
  ?>
  </table>
  <?php
  }

	$tabs->endTab();
  }

if ($show_topten == '1') { 
      //////////////////////////////
      // Top Ten
      //
  $tabs->startTab($topten_tabname, 'top_'.$paneid);
      
  require_once(CLASSPATH.'ps_product.php');
  $ps_product = new ps_product;
  
  require_once(CLASSPATH.'ps_product_attribute.php');
  $ps_product_attribute = new ps_product_attribute;
  
  require_once(CLASSPATH.'ps_product_category.php');
  $ps_product_category = new ps_product_category;

  ?>
  
  <!--Top 10-->
  <?php
    $list  = "SELECT * FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE ";
		$q = "#__{vm}_product.product_publish='Y' AND ";
		$q .= "#__{vm}_product_category_xref.product_id = #__{vm}_product.product_id AND ";
		$q .= "#__{vm}_product_category_xref.category_id = #__{vm}_category.category_id AND ";
    $q .= "#__{vm}_product.product_sales>0 ";
    $q .= "ORDER BY #__{vm}_product.product_sales DESC";
    $list .= $q . " LIMIT 0, $max_items "; 

    global $sess;
    $db = new ps_DB;
    $db->query($list);
    
  if( $db->num_rows() > 0 ){
  ?>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">       
  <?php
        $i = 0;
        while($db->next_record() ){
			$vm_discount = get_discount(get_discount_ID($db->record[$i]->product_id));
			if ($i%2)
				$sectioncolor = "sectiontableentry2";
			else
				$sectioncolor = "sectiontableentry1";
              
			if( $display_style == "vertical" ) {
				?>
				<tr align="center" class="<?php echo $sectioncolor ?>">
					<td>
						<?php $ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart); ?>
                        <div class="discount"><?php echo $vm_discount ?></div>
                    </td>
				</tr>
				<?php
			}
			elseif( $display_style== "horizontal" ) {
				if( $i == 0 )
					echo "<tr>\n";
				echo "<td align=\"center\">";
				$ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart);
				echo "<div class=\"discount\">". $vm_discount ."</div>";
				echo "</td>\n";
				if( ($i+1) == $max_items )
					echo "</tr>\n";
			}
			elseif( $display_style== "table" ) {
				if( $i == 0 )
					echo "<tr>\n";
				echo "<td align=\"center\">";
				$ps_product->show_snapshot($db->f("product_sku"), $show_price, $show_addtocart);
				echo "<div class=\"discount\">". $vm_discount ."</div>";
				echo "</td>\n";
				if ( ($i+1) % $products_per_row == 0)
					echo "</tr><tr>\n";
				if( ($i+1) == $max_items )
					echo "</tr>\n";
			}
			$i++;
        }
  ?>
  </table>
  <?php
  }
  ?>
  <!--Top 10 End-->
  <?php
	$tabs->endTab(); 
  }

if ($show_random == '1') { 
	////////////////////////////
    // Random products
    //
    $tabs->startTab($random_tabname, 'random_'.$paneid );
	?>
	<table cellspacing="0" cellpadding="1" width="100%" class="modtableborder">

	<?php
    require_once ( CLASSPATH. 'ps_product.php');
    $ps_product = new ps_product;
        
    $db=new ps_DB;
    
    $max_items=2; //maximum number of items to display

    $q  = "SELECT DISTINCT product_sku FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE ";
    $q .= "product_parent_id=''";
    $q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id ";
    $q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id ";
    $q .= "AND #__{vm}_product.product_publish='Y' ";
    $q .= "ORDER BY product_name DESC";
    $db->query($q);
    
    $i=0;
    while($db->next_record()){
        $prodlist[$i]=$db->f("product_sku");
		$vm_discount[$i] = get_discount(get_discount_ID($db->record[$i]->product_id));
        $i++;
    }
    
    if($db->num_rows()!=0){ ?>
          
            <tr align="center">
              <td>
                <br><?php
    
        srand ((double) microtime() * 10000000);
        if (sizeof($prodlist)>1)
            $rand_prods = array_rand ($prodlist, $max_items);
        else
            $rand_prods = rand (4545.3545, $max_items);
            
        if($max_items==1){
          $ps_product->show_snapshot($prodlist[$rand_prods], $show_price, $show_addtocart);
          print "<br /><br />";
        }
        else{
          for($i=0; $i<$max_items; $i++){
            $ps_product->show_snapshot($prodlist[$rand_prods[$i]], $show_price, $show_addtocart);
			echo "<div class=\"discount\">". $vm_discount[$i] ."</div>";
            print "<br /><br />";
          }
        }
              ?>
              </td>
            </tr>          
          <?php
      } ?>    
    </table>
 <?php
 	$tabs->endTab();
 }
 $tabs->endPane();
 
 ?>

Часть отвечающая за рандомный вывод продуктов.

Код

	////////////////////////////
    // Random products
    //
    $tabs->startTab($random_tabname, 'random_'.$paneid );
	?>
	<table cellspacing="0" cellpadding="1" width="100%" class="modtableborder">

	<?php
    require_once ( CLASSPATH. 'ps_product.php');
    $ps_product = new ps_product;
        
    $db=new ps_DB;
    
    $max_items=2; //maximum number of items to display

    $q  = "SELECT DISTINCT product_sku FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE ";
    $q .= "product_parent_id=''";
    $q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id ";
    $q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id ";
    $q .= "AND #__{vm}_product.product_publish='Y' ";
    $q .= "ORDER BY product_name DESC";
    $db->query($q);
    
    $i=0;
    while($db->next_record()){
        $prodlist[$i]=$db->f("product_sku");
		$vm_discount[$i] = get_discount(get_discount_ID($db->record[$i]->product_id));
        $i++;
    }
    
    if($db->num_rows()!=0){ ?>
          
            <tr align="center">
              <td>
                <br><?php
    
        srand ((double) microtime() * 10000000);
        if (sizeof($prodlist)>1)
            $rand_prods = array_rand ($prodlist, $max_items);
        else
            $rand_prods = rand (4545.3545, $max_items);
            
        if($max_items==1){
          $ps_product->show_snapshot($prodlist[$rand_prods], $show_price, $show_addtocart);
          print "<br /><br />";
        }
        else{
          for($i=0; $i<$max_items; $i++){
            $ps_product->show_snapshot($prodlist[$rand_prods[$i]], $show_price, $show_addtocart);
			echo "<div class=\"discount\">". $vm_discount[$i] ."</div>";
            print "<br /><br />";
          }
        }
              ?>
              </td>
            </tr>          
          <?php
      } ?>    
    </table>

Проблема с отображением карточки товара VM 1.15 Автор Dimitriu	Ответов: 11 Просмотров: 2163	17.04.2013, 14:15:26 от niggatub
Проблема с корзиной товаров Автор Joury	Ответов: 2 Просмотров: 1455	07.04.2013, 04:12:31 от Joury
Проблема с отображением корзины Автор HawkStyle	Ответов: 0 Просмотров: 1227	19.12.2012, 16:30:24 от HawkStyle
Проблема с страницами производителей Автор lightoffice	Ответов: 3 Просмотров: 1452	03.08.2012, 17:20:05 от lightoffice
Проблема с шаблоном Автор AxMuziakar	Ответов: 3 Просмотров: 1639	02.06.2012, 17:15:33 от Efanych

Проблема с mod_vm_multidisplay - [VM1] Дизайн, оформление

Новости Joomla

Новогодние скидки от Nevigen.com

Astroid обновился до версии 3.3.7!

Как тестировать Joomla PHP-разработчику? Компонент Patch tester.

skysky

Проблема с mod_vm_multidisplay

vitaliy1980`

Re: Проблема с mod_vm_multidisplay

Похожие темы