Way to put item count on menu item, before going to grid

[twwtc]

Is there a way to have the item count on menu items?

Such as:

Tractors (30)
Combines (3)
Tandems (8)

Once a menu item is selected, I do have the count at the top of the grid page. Just don't know how to get it to the menu page.

Thanks
Tony

[frankbicknell]

Re: Way to put item count on menu item, before going to grid

I think you would have to query the tables and get the record count in the a5w page then display the results on the page.

[rogerrabbit222]

Re: Way to put item count on menu item, before going to grid

the best way would be to introduce lines of xbasic code during the initialization of the Menu Items. The xbasic code will have the code to do a record count for that item list.

[rogerrabbit222]

Re: Way to put item count on menu item, before going to grid

Here is what you can do.

When you create your Menu item on the Navigation component eg. Item 1, Item 2 etc. In the TEXT property of the item type in something like

Item 1(_cnt1_)

.

The

_cnt1_

is a place holder for holding the record count for Item 1. Follow the same for the other Items as well and put placeholders like

_cnt1_,_cnt2_,cnt3_

,etc.

Insert this NAVIGATION COMPONENT into an A5W page.

Add a few xbasic script on the top of the page to calculate the record count for each item. Remember that the SQL that you use here MUST be SAME as the one being used by the corresponding Grid component; else there will be difference in the record count.

<%a5

dim conn as SQL::Connection	
dim rs as SQL::ResultSet
dim connString as c
connString = "::name::archon"	'AlphaDAO CONNECTION STRING NAME
conn.Open(connString)
dim sqlStr as c

'****get record count**********
sqlStr = "SELECT COUNT(MATLTRACK_ID) as RecCnt FROM MATLTRACK" ' REPLACE THIS QUERY AS PER YOUR REQUIREMENT
conn.Execute(sqlStr)
rs = conn.ResultSet
dim item1Cnt as c	
item1Cnt = rs.data("RecCnt")
'****end block**********


%>

In this A5W page search for the text,

?x_menuNav1.Output.Body.navsysTBV

. This line is inserted by Alpha Five framework and is used to generate the corresponding HTML line of code for the Navigation Control.

Replace it with this:

dim customNav as C
customNav =  x_menuNav1.Output.Body.navsysTBV 
customNav = stritran(customNav,"_cnt1_",item1Cnt)   

'REPEAT STEPS FOR ALL OTHER ITEMS IN MENU

? customNav

What happens is that the STRITRAN function will replace the place holder _cnt1_ with the value stored in item1Cnt. We captured the values of item1Cnt just at thee beginning of the page load.

I have attached the NavControl that I created and the A5W page for the solution. You can try using them.

This worked for me. Let me know how is goes for you.

[cptutrecht]

Re: Way to put item count on menu item, before going to grid

Hi, i read this with great interest. Navigation component does not support localisation tags until now (<a5:r></a5:r>.

Could i use this technique to create localisation on menu-items.

Would it mean filling it with only a placeholder _menutext1_ etc? and fill it with the value of a session variable with multiple items per language?

[rogerrabbit222]

Re: Way to put item count on menu item, before going to grid

If your objective is to alter the TEXT value on the Menu Item with some Calculated values or Session Values, then this solution of mine should sort out your problem.

[cptutrecht]

Re: Way to put item count on menu item, before going to grid

Great, thanks very much, ik will give it a try. It saves me tons of duplicate a5w pages (each for every menuitem per language).

I'm only afraid that i will lose the highlighting of the active menu-item, i will see....

[rogerrabbit222]

Re: Way to put item count on menu item, before going to grid

Great, thanks very much, ik will give it a try. It saves me tons of duplicate a5w pages (each for every menuitem per language).

I'm only afraid that i will lose the highlighting of the active menu-item, i will see....

No worry mate! The highlighting of the active menu-item still stays. All you change is the Text value being rendered on the HTML. The other attributes of keeping the menu-item active , or hover over,etc remains.

[cptutrecht]

Re: Way to put item count on menu item, before going to grid

Great, really worth the effort of rebuilding my own localization solution for navigation components and almost as efficient as Alpha on solution with language tags!

[frankbicknell]

Re: Way to put item count on menu item, before going to grid

Very neat KayBee. Now if I can just figure out a use for myself.

[twwtc]

Re: Way to put item count on menu item, before going to grid

Kaybee,

Can the same be done using text, with hyperlinks. At this time I am not using the Navigation Component.
Also, I am using Alpha database files.
Thanks
Tony

[rogerrabbit222]

Re: Way to put item count on menu item, before going to grid

Yes! Most certainly!

As a matter of fact, its old school xbasic & html coding.

[twwtc]

Re: Way to put item count on menu item, before going to grid

KayBee
If you have time to show me the xbasic and html code, and where to put it, I would really appreciate it. Very unexperienced at both xbasic and html, to say the least.
I have a simple table on a a5w page that users can click on a category, that takes them to list for that category, more details.
Data is coming from an Alpha Five DBF.
Thanks
Tony

[Atta]

Re: Way to put item count on menu item, before going to grid

I dont know if you are using SQL but create a view, and than link the view to the other table.
This way you can use the view anywhere.

[twwtc]

Re: Way to put item count on menu item, before going to grid

No, I'm not using SQL.
Thanks