This topic is locked

Menu Badges - Counting Records Only for current logged user and display in Menu Badges

7/21/2018 7:45:36 AM
PHPRunner General questions
M
maaroufkamel author

Dears , Thanks for PHPrunner team first
I need help in how to show counting in badges regarding the user login
or when user login counting his only records and showing in the Menu title like (My Orders)
i do this code in Menu Item Modify Events


$title = $menuItem->getTitle();

if ($title=="Todays Sales Orders") {

$count = DBLookup("select count(*) from SO_Main where (DateDiff(dd, [Date], GETDATE())=0)") and $_SESSION['UserID'];

$title.="<span class='badge badge-blue'>".$count."</span>";

$menuItem->setTitle($title);

}

return true;
and it's working for all logged users even a user have no order today i need to show his orders only when he logged in menu badges
Thanks.,