freebie: popout section aware nav.

[malbro]

Problem with deleted sections

Just found a problem in the code.
If you have any deleted sections in the site then the current code builds them into the menu system.

it needs an additional condition ( AND [Status]='N' ) in the function SectionList to check the value of Status.

So the code

		if($respect==true) { 
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1 ORDER BY [Catalogue Section Sequence] ASC";
		} else {
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0  ORDER BY [Catalogue Section Sequence] ASC";
		}

should be changed to

		if($respect==true) { 
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1 AND [Status]='N' ORDER BY [Catalogue Section Sequence] ASC";
		} else {
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [Status]='N' ORDER BY [Catalogue Section Sequence] ASC";
		}

[Andy Warner]

thanks!

was about to look into that one, you've saved me the effort!

got it working at www.thegamesplace.co.uk and legendgames.solis-media.co.uk though I need to tweak the css in both cases.

both v8 sites, cant recall the version numbers

no errors at all.

all fab!

[gabrielcrowe]

thanks for the fix.

at some point, i'm going to have to collate all these little tweaks y'know.

the 'include to sitemap' respecting part of this function, was so that you could build your entire main html sitemap in actinic. by setting the depth to render to, something like 999, and then supplying the respect clause in the function call, at the end.

with your fix, this part of the function now respects deleted items, w00t!

[malbro]

thanks for the fix.

at some point, i'm going to have to collate all these little tweaks y'know.

the 'include to sitemap' respecting part of this function, was so that you could build your entire main html sitemap in actinic. by setting the depth to render to, something like 999, and then supplying the respect clause in the function call, at the end.

with your fix, this part of the function now respects deleted items, w00t!

I use this in preference to Actinics own functions as i find this more flexible, although I tend to tweak the code to change the html it produces to suit the application.

[Andy Warner]

a request please Mr Crowe

Can you 'version' your cool code please!
I've played with the nav stuff to great effect but I cant remember if i've got an early or late version, or even if it matters!

anyhow, cool plugin, thanks.

[fourone]

Hello,

First of all thanks Gabe for such an awesome tutorial, it was really easy to follow (even for a newbie like me!) and it works really well.

The only thing I'm not sure how to do is give a css class to the Top Level list item that has been selected. To give you an example of what I mean, all the Top Level list items I have in my side menu have a blue background when I roll over them, when I click on one and it goes to the relevant page, how would I then style that link so it has a blue background so people are aware that is the page they are on?

I hope I have explained that ok, but please let me know if you need anymore info.

TIA for any help.

[gabrielcrowe]

if you take a closer look at the source code, of the page, you'll find that certain styles have '_selected' at the end.

example:
"li2_selected"
level 2 li selected

"a3_selected"
3rd depth link selected.

hope that helps.

[fourone]

Right under my nose and I didn't even see it! Thanks Gabe, much appreciated.

[malbro]

I recently came across a posting incorporating the ddaccordion.js script into actinic. I liked the clean operation of the script and wondered if it was possible to modify Gabes navigation system to generate the correct html code to work with the script.

The main problem is that the script needs to know when a menu item is the parent of another section, but as written Gabes navigation doesn't know about the children until it has written the menu line for the parent.

This modified version of gabes code correctly generates the correct structure for the accordion script.

 /***************************************************************
*
* MakeNav -
* @author Gabriel Crowe 12:47 01 November 2007
*
* Modified to generate a menu suitable for ddacordion.js
* 16 April 2009
*
* usage example:
* MakeNav($sectid,$recursedepth,$prestyle,$thissect)
***************************************************************/

if (!function_exists('GetParentSections')) {
function GetParentSections($connect,$sectref)
    {

        $query = "SELECT [Section Text], [nParentSectionID], [nSectionID] FROM [Catalog Section] WHERE [nSectionID] LIKE '".$sectref."'";
        $result = odbc_exec($connect, $query);
        $returnstring="";
		

        while(odbc_fetch_row($result)){
        
            $SectionText =  odbc_result($result, 1);
            $nParentSectionID = odbc_result($result, 2);
            $nSectionID = odbc_result($result, 3);
            
            if ($nSectionID!=0) {$returnstring=GetParentSections($connect,$nParentSectionID).$nSectionID."|";}

        }
        odbc_free_result($result);
        //odbc_close($connect);
    return $returnstring;
}
}

if (!function_exists('GetParentSectionsWrapper')) {
function GetParentSectionsWrapper($sectid) {
    $connect = odbc_pconnect("ActinicCatalog9","","", SQL_CUR_USE_ODBC);
    $resultage = GetParentSections($connect,$sectid);
    odbc_close_all();    
    return $resultage;
}
}

if (!function_exists('useful_odbc_num_rows')) {
function useful_odbc_num_rows($result){

   $num_rows=0;

   while($temp = odbc_fetch_into($result, &$counter))

   {
       $num_rows++;
   }

@odbc_fetch_row($result, 0);   // reset cursor

   return $num_rows;
}
}

if (!function_exists('SectionList')) {
	function SectionList($connect,$sectid,$recursedepth,$rendermode,$thispatharr,$stylecounter,$respect) {

		$recursedepth=$recursedepth-1;
		$stylecounter=$stylecounter+1;
		$result      = CheckChildren($sectid,$connect,$respect);
		$numrows     = useful_odbc_num_rows($result);

		if ($numrows!=0) {
			if($stylecounter == 2) {
				echo "<div class=\"submenu\">\n";
				echo "<ul>\n";
			}
		}
		while(odbc_fetch_row($result)){
        
			$sPageName    = odbc_result($result, 1);
			$Sectiontext  = odbc_result($result, 2);
			$nSectionID   = odbc_result($result, 3);
			/* does this section have children */
			$result2      = CheckChildren($nSectionID,$connect,$respect);
			$HasChildren  = useful_odbc_num_rows($result2);
			odbc_free_result($result2);

			$thisstyle="";
			$expandthis=false;
			foreach ($thispatharr as $value) {
				if ($value==$nSectionID) {
					$thisstyle="_selected";
					$expandthis=true;
				}
			}
			if($stylecounter == 1) {
				if ($HasChildren == 0) {
					$linkitem=" <a class=\"menuitem\" ";
				} else {
					$linkitem=" <a class=\"menuitem submenuheader\" ";
				}
			} else {
				$linkitem="<a ";
			}
			if ($thisstyle == "_selected") {
				$linkitem.=" href=\"#link#\" class=\"link".$stylecounter.$thisstyle."\">";
			} else {
				$linkitem.=" href=\"#link#\">";
			}

			if($stylecounter > 1) {
				echo "\t<li>";
			} else {
				echo "\t";
			}
			echo str_replace("#link#",$sPageName,$linkitem);
			echo trim($Sectiontext);
			echo "</a>";
			if($stylecounter > 1) {
				echo "</li>\n";
			} else {
				echo "\n";
			}
			//recurse
			if ($rendermode == 1) { $expandthis=true; }
			if ($recursedepth>=1 and $expandthis==true){
				SectionList($connect,$nSectionID,$recursedepth,$rendermode,$thispatharr,$stylecounter,$respect);
			}
		}
		if ($numrows!=0) { 
			if($stylecounter == 2) {
				echo "</ul>\n";
				echo "</div>\n";
			}
		}
		odbc_free_result($result);
	}        
}

if (!function_exists('MakeNav')) {
function MakeNav($sectid,$recursedepth,$rendermode,$thissect,$respect=true) {

    $thispath = GetParentSectionsWrapper($thissect);
    $thispatharr = explode("|",$thispath);
    //sPagetitle, sPageName, sMetaKeywords, sMetaDescription, sSectionImageFile, sSectionDescription, sSectionText
    $connect = odbc_pconnect("ActinicCatalog9","","", SQL_CUR_USE_ODBC);
        SectionList($connect,$sectid,$recursedepth,$rendermode,$thispatharr,0,$respect);
    odbc_close_all();    

    $connect = null;    
}
}



/***************************************************************
 *
 * Ref2file - Use Actinic's pwn database, to convert a prod ref, to a filename
 *
 * @param int $ref the product reference. 
 * @author Gabriel Crowe 18:04 08 September 2007
 *
 ***************************************************************/
if (!function_exists('GetSectFileName')) {
function GetSectFileName($sectref)
	{
		$connect = odbc_connect("ActinicCatalog9","","");
		$query = "SELECT [sPageName] FROM [Catalog Section] WHERE [nSectionID]=".$sectref."";
		$result = odbc_exec($connect, $query);

		while(odbc_fetch_row($result)){
			//$name = odbc_result($result, 2);
			$url = odbc_result($result, 1);  
		}
		odbc_close($connect);
			return $url;
	}
}

if (!function_exists('GetSectName')) {
function GetSectName($sectref)
	{
		$connect = odbc_connect("ActinicCatalog9","","");
		$query = "SELECT [Section Text] FROM [Catalog Section] WHERE [nSectionID]=".$sectref."";
		$result = odbc_exec($connect, $query);

		while(odbc_fetch_row($result)){
			//$name = odbc_result($result, 2);
			$SectionText = odbc_result($result, 1);  
		}
		odbc_close($connect);
			return $SectionText;
	}
}

if (!function_exists('GetProdParent')) {
function GetProdParent($prodrefs)
	{
	$prodrefs = str_replace("{","",$prodrefs);
	$prodrefs = str_replace("}","",$prodrefs);
		$connect = odbc_connect("ActinicCatalog9","","");
		$query = "SELECT [nParentSectionID] FROM [product] WHERE [Product Reference]='".$prodrefs."'";
		$result = odbc_exec($connect, $query);
		
		while(odbc_fetch_row($result)){
			$parentid = odbc_result($result, 1);
		}
		odbc_close($connect);
			return $parentid;
		}
}
			
if (!function_exists('Ref2file')) {
function Ref2file($ref) {
return GetSectFileName(GetProdParent($ref));
}	
}

/***************************************************************
 *
 * CheckChildren - Use Actinic's own database, to see if there 
 * are sub menus for this section.
 *
 * @param int $sectid  - the id of section to check. 
 * @param     $connect - the handle to the database. 
 * @param int $respect - flag to respect 'bIncludeToSiteMap' variable. 
 * 
 * @Author M Brook 16 April 2009
 * 
 * added this function to allow the check to be made more than 
 * once in the main loop, using different section id's.
 *
 ***************************************************************/
if (!function_exists('CheckChildren')) {
function CheckChildren($sectid,$connect,$respect) {
		if($respect==true) { 
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0 AND [bIncludeToSiteMap]=1  AND [Status]='N' ORDER BY [Catalogue Section Sequence] ASC";
		} else {
			$query = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$sectid." AND [bHideOnWebSite]=0  AND [Status]='N' ORDER BY [Catalogue Section Sequence] ASC";
		}
		$result  = odbc_exec($connect, $query);

return $result;
}	
}

Part of the original code is now in the new function CheckChildren so it can be called to check a section before it is entered by the main loop of the code.

This generates the menu listing required by the ddaccordion script from Dynamic Drive see my site (link in signature) for a demo.

[gabrielcrowe]

love it, nice hack. thanks for posting the code for others too.

[fourone]

Nav missing on checkout pages

Hi there,

I've got my nav working just the way I want it now on all pages apart from my checkout cart where it seems to disappear completely! It is fine on the 'view cart' page but as soon as I click the go to checkout button it disappears on the next page. Could anyone give me any pointers as to how I can get it to show up?

<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Brochure%27" > <actinic:block php="true" selectable="false"> MakeNav(0,2,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%200%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%201%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%202%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Shopping%20Cart%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Add%20To%20Cart%20Confirmation%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Receipt%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Search%27" > <actinic:block php="true" selectable="false"> MakeNav(0,2,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Search%20Results%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Bounce%20Page%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Site%20Map%27" >	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Terms%20And%20Conditions%27" >	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Section%27">
					<actinic:block if="%3cactinic%3avariable%20name%3d%22SectionLevel%22%20%2f%3e%20%3e%200">
						<actinic:block php="true" selectable="false"> MakeNav(0,2,0,<actinic:variable name="SectionID" />); </actinic:block>
					</actinic:block>
					<actinic:block if="%3cactinic%3avariable%20name%3d%22SectionLevel%22%20%2f%3e%20%3d%3d%200" >
						<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block>
					</actinic:block>
			</actinic:block>

Many thanks for the help.

[NicNac]

Hi there,

I've got my nav working just the way I want it now on all pages apart from my checkout cart where it seems to disappear completely! It is fine on the 'view cart' page but as soon as I click the go to checkout button it disappears on the next page. Could anyone give me any pointers as to how I can get it to show up?

<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Brochure%27" > <actinic:block php="true" selectable="false"> MakeNav(0,2,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%200%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%201%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%202%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Shopping%20Cart%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Add%20To%20Cart%20Confirmation%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Receipt%27" > </actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Search%27" > <actinic:block php="true" selectable="false"> MakeNav(0,2,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Search%20Results%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Bounce%20Page%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Site%20Map%27" >	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Terms%20And%20Conditions%27" >	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Section%27">
					<actinic:block if="%3cactinic%3avariable%20name%3d%22SectionLevel%22%20%2f%3e%20%3e%200">
						<actinic:block php="true" selectable="false"> MakeNav(0,2,0,<actinic:variable name="SectionID" />); </actinic:block>
					</actinic:block>
					<actinic:block if="%3cactinic%3avariable%20name%3d%22SectionLevel%22%20%2f%3e%20%3d%3d%200" >
						<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block>
					</actinic:block>
			</actinic:block>

Many thanks for the help.

If you look at the bit of the code highlighted (for the checkout pages) there is no makenav call, meaning no menu will be created on these pages.

There are 3 checkout pages listed: 0, 1 and 2. Here's how the code should look (I think) to include the nav menu on your checkout pages.

Tested and works fine on my site www.onlyzebra.com

<div class="navcontainerment">	
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Brochure%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,1,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%200%27" ><actinic:block php="true" selectable="false"> MakeNav(0,1,1,0); </actinic:block> </actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%201%27" ><actinic:block php="true" selectable="false"> MakeNav(0,1,1,0); </actinic:block> </actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Checkout%20Page%202%27" ><actinic:block php="true" selectable="false"> MakeNav(0,1,1,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Shopping%20Cart%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Add%20To%20Cart%20Confirmation%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Receipt%27" > </actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Search%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Search%20Results%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Bounce%20Page%27" > <actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Site%20Map%27" >	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Terms%20And%20Conditions%27" >	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block></actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%27Section%27">
	<actinic:block if="%3cactinic%3avariable%20name%3d%22SectionLevel%22%20%2f%3e%20%3e%200">
	<actinic:block php="true" selectable="false"> MakeNav(0,2,0,<actinic:variable name="SectionID" />); </actinic:block>
					</actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22SectionLevel%22%20%2f%3e%20%3d%3d%200" >
	<actinic:block php="true" selectable="false"> MakeNav(0,1,0,0); </actinic:block>
					</actinic:block>
			</actinic:block>
				
</div>

Edit: Just noticed your brochure page makenav function is called slightly differently to mine. I copied my brochure page call for the 3 checkout pages, you may want to do the same

[fourone]

Hey thanks NicNac. I'll give it a try and let you know how I get on.

[NicNac]

No problem fourone.

I'm still pretty new myself, so it's my best guess. As I said it works on my site though!

[malbro]

No problem fourone.

I'm still pretty new myself, so it's my best guess. As I said it works on my site though!

You are spot on, the difference between the two calls is the setting for the number of levels used in the navigation, 1 just gets the next level down, 2 goes down two levels (if they exist).