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);
  }
Exemple #2
0
<?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");