USER_ID, $blnTotal=true);
print_rr($arrIFA_AUM, $Debug); //vd($dblHOUSE_AUM);
$dblHOUSE_AUM = $arrIFA_AUM[0];
$pdo = $SA->query("SELECT * FROM web_ifa_advisor ORDER BY FirstName, Surname", $Debug);
$pdo->execute();
$rstTeam = $pdo->fetchAll();
$total_rows = count($rstTeam);
$total_pages = ceil($total_rows / $no_of_records_per_page);
$pdo = $SA->query("SELECT * FROM web_ifa_advisor ORDER BY FirstName, Surname LIMIT $offset, $no_of_records_per_page", $Debug);
$pdo->execute();
$rstTeam = $pdo->fetchAll();
//post / output
$trAdvisor = "";
foreach ($rstTeam as $row)
{//print_rr($row);
//ini
$IFAAdvisorID = $row['ID'];
$strAdvisor = $row['FirstName'] ." ". $row['Surname'];
$Assets_under_management =
$WeightInPortfolio = 0;
//proc
@$WeightInPortfolio = $arrIFA_AUM[$IFAAdvisorID] / $dblHOUSE_AUM * 100;
//out
$trAdvisor .= "
| $strAdvisor |
R ". number_format($arrIFA_AUM[$IFAAdvisorID],2) ." |
". number_format($WeightInPortfolio,2) ."% |
|
|
|
";
}
//Pagination
$PrevClass = ($pageno <= 1) ? 'disabled' : '';
$PrevLink = "index.php?page=advisors";
if($pageno <= 1){
$PrevLink .= "#";
}else{
$PrevLink .= "&pageno=".($pageno - 1);
}
$NextClass = ($pageno >= $total_pages) ? "disabled" : "" ;
$NextLink = "index.php?page=advisors";
if($pageno >= $total_pages){
$NextLink .= '#';
} else{
$NextLink .= '&pageno='.($pageno + 1);
}
//post / output
echo "
| Advisor Name |
Portfolio in R |
Portfolio in % |
|
|
|
| No search result could be found, for your search |
$trAdvisor
| R ". number_format($dblHOUSE_AUM,2) ." |
|
|
|
|
";
?>