Side Navagation Bar

8/17/2009 6:38 am | #1 tamyala164613

I have noticed that the side navigation list continues to grow as I enter my products. My database is huge and I don't want that list to go on forever. Is there a way to only show categories on the side navigation?

8/17/2009 7:14 am | #2 msjj000Beta Tester

Side Navigation Need

Hi WA,

Firstly - a great upgrade with the version 2 of PowerStore. The product variables were a great addition and are a help to reduce the number of products listed. I managed to get it localized and up and running for local country requirements utilizing all the same code changes from version one - keep it up!

I'd also like to utilize a cascading or collapsible/expandable side menu bar to only show categories and expand the selected category. Can you use the WA CSS menu writer to achieve this or alternatively can you assist with some php code? I've tried CSS menu writer in the past - simple to use; however it seems to muck up the predefined menu settings in place with the PowerStore. The site has grown from 7-10 categories to over 20 now and navigation the look and feel is getting messy withthe categories starting to stretch over a page.

Any advice would be great.

Thanks, Mark.

8/17/2009 10:45 am | #3 Jason ByrnesWebAssist

tamyala164613:

The side navigation menu is created in the CSSmenuWriter/intermediate.php file. You could edit lines 12 - 46:

php:

<?php do { ?>

<?php

$catParam = $row_ProductCategories['CategoryID'];

?>

<?php

$catParam_ProductMenu = "0";

if (isset($catParam)) {

  $catParam_ProductMenu = (get_magic_quotes_gpc()) ? $catParam : addslashes($catParam);

}

mysql_select_db($database_localhost, $localhost);

$query_ProductMenu = sprintf("SELECT * FROM products WHERE ProductLive <> 0 AND COALESCE((SELECT GroupingID FROM productoptions WHERE productoptions.ProductID = products.ProductID LIMIT 1), ProductID) = ProductID AND ProductCategoryID = %s", GetSQLValueString($catParam_ProductMenu, "int"));

$ProductMenu = mysql_query($query_ProductMenu, $localhost) or die(mysql_error());

$row_ProductMenu = mysql_fetch_assoc($ProductMenu);

$totalRows_ProductMenu = mysql_num_rows($ProductMenu);



$WA_localRoot = "".$WAGLOBAL_localRoot. "";

$WA_remoteRoot = "".$WAGLOBAL_remoteRoot. "";

$WA_curURL = strtolower((isset($_SERVER["PHP_SELF"]))?$_SERVER["PHP_SELF"]:"");

$assumedRoot = $WA_remoteRoot;

if ((strpos($WA_curURL,strtolower($WA_localRoot)) !== false && strpos($WA_curURL,strtolower($WA_localRoot)) == 0) && (strlen($WA_localRoot) >= strlen($WA_remoteRoot) || strpos($WA_curURL,strtolower($WA_localRoot)) === 0)) {

  $assumedRoot = $WA_localRoot;

}



?>

      <a href="<?php echo($assumedRoot); ?>Products_Results.php?Search=true&CategoryID=<?php print $row_ProductCategories['CategoryID']; ?>"><h2><?php print $row_ProductCategories['CategoryName']; ?></h2></a>

<ul >

  <?php do { ?>

      <?php if ($totalRows_ProductMenu > 0) { // Show if recordset not empty ?>

  <li><span><a href="<?php echo($assumedRoot); ?>Products_Detail.php?ProductID=<?php echo $row_ProductMenu['ProductID']; ?>"><?php print $row_ProductMenu['ProductName']; ?></a></span></li>

  <?php } // Show if recordset not empty ?>

<?php } while ($row_ProductMenu = mysql_fetch_assoc($ProductMenu)); ?></ul>

<?php

mysql_free_result($ProductMenu);

?>

<?php } while ($row_ProductCategories = mysql_fetch_assoc($ProductCategories)); ?>

to:

php:

<?php do { ?>

<?php

$WA_localRoot = "".$WAGLOBAL_localRoot. "";

$WA_remoteRoot = "".$WAGLOBAL_remoteRoot. "";

$WA_curURL = strtolower((isset($_SERVER["PHP_SELF"]))?$_SERVER["PHP_SELF"]:"");

$assumedRoot = $WA_remoteRoot;

if ((strpos($WA_curURL,strtolower($WA_localRoot)) !== false && strpos($WA_curURL,strtolower($WA_localRoot)) == 0) && (strlen($WA_localRoot) >= strlen($WA_remoteRoot) || strpos($WA_curURL,strtolower($WA_localRoot)) === 0)) {

  $assumedRoot = $WA_localRoot;

}



?>

      <a href="<?php echo($assumedRoot); ?>Products_Results.php?Search=true&CategoryID=<?php print $row_ProductCategories['CategoryID']; ?>"><h2><?php print $row_ProductCategories['CategoryName']; ?></h2></a>

<?php } while ($row_ProductCategories = mysql_fetch_assoc($ProductCategories)); ?>

in order to only show the categories.

--
uberbean:

It will require hand coding to create a collapsible or expandable menu for the product categories. unfortunately, we cannot offer support for this.

8/18/2009 5:04 pm | #5 msjj000Beta Tester

Yep - fixed - worked well

Hi,
I tried it adn it worked well - thanks Jason.
I also aligned the titles to the left hand side. centred looks better with the inventory items but when they are taken away it looks messy.
UB

8/24/2009 6:50 pm | #6 tamyala164613

Results

Originally Said By: jazzman247315378

tamyala, did you get the results you were expecting this fix? I am considering the same thing, but would like to hear from someone who has tried it.

Yes, this did work. Only the links to each category are shown. When you click the category link then the products for that category are shown.

8/25/2009 6:22 am | #7 mick106153

I tried the tweak as well and didn't like the results.
What I did instead was to play with the css to trim down the look and feel.
Still experimenting and looking forward to an accordion of some sort.

intuHorsesPowerStore/

Mick

8/29/2009 10:32 pm | #9 denise234045

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Side Navagation Bar

8/17/2009 6:38 am | #1 tamyala164613