Quote:
|
Originally Posted by Vetrivel
Hi,
How to display the manufacturers products count in side menu . 
like this..
-------------------
manufacturers
-------------------
manufacturer one ( 25)
manufacturer two( 10)
.
.
...............................
Thanks in Advance.  |
Try to do so:
1. Back up files:
- modules/Manufacturers/customer_manufacturers.php;
- skin1/modules/Manufacturers/menu_manufacturers.tpl.
2. Edit file "modules/Manufacturers/customer_manufacturers.php",
Add the end of the file the following lines
PHP Code:
if($active_modules["Manufacturers"])
{
$sql = "select manufacturerid, count(productid) as countpr from ".$sql_tbl[products]." WHERE (forsale='Y') GROUP BY manufacturerid";
$result = func_query($sql);
$result2=array();
foreach ($result as $ind => $one)
{
$result2[$one[manufacturerid]]=$one[countpr];
}
$smarty->assign("mstats", $result2);
unset($result ,$result2);
}
3. Edit file "skin1/modules/Manufacturers/menu_manufacturers.tpl",
replace the contents of the file the following code
PHP Code:
{* $Id: menu_manufacturers.tpl,v 1.5 2005/11/17 06:55:47 max Exp $ *}
{if $manufacturers_menu ne ''}
{capture name=menu}
{section name=mid loop=$manufacturers_menu}
{assign var=number value=$manufacturers_menu[mid].manufacturerid}
<a href="manufacturers.php?manufacturerid={$manufacturers_menu[mid].manufacturerid}" class="VertMenuItems">{$manufacturers_menu[mid].manufacturer} ({if $mstats[$number] ne ""}{$mstats[$number]}{else}0{/if})</a>
<br />
{/section}
{if $show_other_manufacturers}
<br />
{assign var=number value=$manufacturers_menu[mid].manufacturerid}
<a href="manufacturers.php" class="VertMenuItems">{$lng.lbl_other_manufacturers} ({if $mstats[$number] ne ""}{$mstats[$number]}{else}0{/if})</a><br />
{/if}
{/capture}
{include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title=$lng.lbl_manufacturers menu_content=$smarty.capture.menu}
<br />
{/if}