2. PHPRunner General questions
  3. [SOLVED] Use ModifyMenu to add record count for 1 menuitem
This topic is locked
[SOLVED]

Use ModifyMenu to add record count for 1 menuitem

 		10/27/2024 6:33:11 PM
PHPRunner General questions
A
 asawyer13 authorDevClub member

I know we're supposed to use ModifyMenu now but not quite understanding how to add a record count to one menu item.

The ID is 24

$rs=DB::Query("select count(1) as c FROM vw_checkout where IsMonitor = 1"]);

$data = $rs->fetchAssoc();
$menuItem->getItem(24);
$menuItem->setTitle($menuItem->getTitle() . " (". $data["c"] . ")");

I'm probably doing something stupid, but can't quite figure it out.

Thanks
Alan
Davor GeciDevClub member 10/29/2024

Hello Alan,

try with this code in ModifyMenu event:

if( $menu->name() == "main" ) {
$rs=DB::Query("select count(1) as c FROM vw_checkout where IsMonitor = 1");

$data = $rs->fetchAssoc();
$item = $menu->getItem(24);
if ($item) {
$item->setTitle($item->getTitle() . " (" . $data["c"] . ")");
}
}

Hope it helps,
Davor
A
 		asawyer13 authorDevClub member 10/29/2024

Worked perfectly. Adding that to my arsenal of PHPR knowledge.

Thankis
Alan