hi on menu item-modify i use:
if($menuItem->getLinkType() == 'Internal')
{
global $tables_data;
$table=$menuItem->getTable();
include_once(getabspath("include/".GetTableURL($table)."_settings.php"));
$gSettings = new ProjectSettings($table, $menuItem->getPageType());
$table = $gSettings->GetOriginalTableName();
if (($table)==("tbltodo"))
{
$rs=CustomQuery("select count() as c1 from tbltodo where visible='Yes'" );
$data = db_fetch_array($rs);
$menuItem->setTitle($menuItem->getTitle() . " (". $data["c1"] . ")");
}
if (($table)==("tbltodocompleted"))
{
$rs=CustomQuery("select count() as c1 from tbltodo");
$data = db_fetch_array($rs);
$menuItem->setTitle($menuItem->getTitle() . " (". $data["c1"] . ")");
}
else
{
$rs=CustomQuery("select count(*) as c from " . AddTableWrappers($table));
$data = db_fetch_array($rs);
$menuItem->setTitle($menuItem->getTitle() . " (". $data["c"] . ")");
}
}
return true;
tbltodocompleted is a custom view of tbltodo
i get following results
TODO List - ACTIVE (0) (2)
TODO List - COMPLETED (0) (2)
Report Due Next60Days (0)
how can i get correctly ? i.e.
TODO List - ACTIVE (0)
TODO List - COMPLETED (2)
Report Due Next60Days (0)
i use phprunner 7.1 thanks