static public function getHistory() { $allTimes = SecurityCollection::getDates(); if(loggedAdmin()) //if it is admin $id_client= mysql_real_escape_string($_GET['userid']); elseif(isset($_SESSION['login'])) $id_client= mysql_real_escape_string($_SESSION['login']); else die('unauthorized access!'); //$id_client = mysql_real_escape_string($_GET['userid']); $condition = " s.id_client = '$id_client' AND"; // var_dump($allTimes); $rows=array(); foreach($allTimes as $key=>$thisTime): $query = " SELECT s.id, i.fund_name iname, s.quantity, ca.name custody, s.created_at, i.ISIN code FROM security s, fund i, custody_ac ca "; $query.= " WHERE $condition i.id = s.id_isin AND ca.id = s.id_custody AND s.created_at = (SELECT MAX(created_at) FROM security ss WHERE ss.id_client = s.id_client AND ss.id_custody = s.id_custody AND ss.id_isin = s.id_isin AND ss.created_at < '".$thisTime['created_at']."') "; // echo "$query<br/><br/>"; $qres = mysql_query($query) or die('could not execute query'.$query); while($x = mysql_fetch_assoc($qres)) $rows[$key][] = $x; endforeach; //var_dump($rows); //echo'<hr/><hr/>'; /*if(1==0) foreach($rows as $row): echo'<hr/><hr/>'; var_dump($row); echo'<hr/><hr/>'; endforeach;*/ return($rows); }
<?php include('../config.php'); include('../functions.php'); include('../classes/transactioncollection.class.php'); include('../classes/clientcollection.class.php'); include('../classes/isincollection.class.php'); include('../classes/securitycollection.class.php'); include('../classes/custodycollection.class.php'); loginAdmin(); if(!loggedAdmin()) header('location: index.php'); $transaction = new TransactionCollection(); $clients = ClientCollection::getClients(); $isins = IsinCollection::getIsins(); $collection = new SecurityCollection(); $isinCollection = new IsinCollection; $accounts = CustodyCollection::getAccountsForClientByTransactionId(mysql_real_escape_string($_GET['id'])); if(exist($_POST['button'])) { $result = TransactionCollection::updateTransaction(); } else { TransactionCollection::loadTransaction(); $result = array(); } include("$templates/menu.php");