This topic is locked
[SOLVED]

 menu item-modify

3/16/2014 8:59:32 AM
PHPRunner General questions
C
chrispa author

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

Sergey Kornilov admin 3/18/2014

Instead of using

if () {
}
if () {
} else {
}


you need to use

if () {
}

else if () {
}

else {
}


Right now your else section is executed for all tables except "tbltodocompleted".

C
chrispa author 3/19/2014

ok done thanks alot
if($menuItem->getLinkType() == 'Internal')

{

global $tables_data;

$table=$menuItem->getTable();

include_once(getabspath("include/".GetTableURL($table)."_settings.php"));

$gSettings = new ProjectSettings($table, $menuItem->getPageType());
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"] . ")");

}

elseif (($table)==("tbltodocompleted"))

{

$rs=CustomQuery("select count(
) as c1 from tbltodo where visible='No'");

$data = db_fetch_array($rs);

$menuItem->setTitle($menuItem->getTitle() . " (". $data["c1"] . ")");
}

elseif (($table)==("ReportDueNext60Days"))

{

$rs=CustomQuery("select count(*) as c1 from Query1");

$data = db_fetch_array($rs);

$menuItem->setTitle($menuItem->getTitle() . " (". $data["c1"] . ")");
}
}

return true;