X-Cart forums - manufacturers products count...

Quote:

Originally Posted by Vetrivel

Hi,
How to display the manufacturers products count in side menu .:roll::roll:
like this..
-------------------
manufacturers
-------------------
manufacturer one (25)
manufacturer two(10)
.
.
...............................

Thanks in Advance.8)

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}