/**
* Get portfolio values from db and update portfolio object
*
* @param Client $client
*/
public function loadPortfolioValues(Client $client)
{
$sql = "SELECT * FROM " . self::TABLE_CLIENT_PORTFOLIO_VALUE . " as cpv\n LEFT JOIN {$this->table} cp ON (cpv.client_portfolio_id = cp.id)\n LEFT JOIN " . self::TABLE_USER . " u ON u.id = cp.client_id\n WHERE cp.portfolio_id = :portfolio_id AND u.id = :clientId\n ORDER BY cpv.date desc LIMIT 1";
$pdo = $this->db->getPdo();
$portfolio = $client->getPortfolio();
$statement = $pdo->prepare($sql);
$statement->execute(array('portfolio_id' => $portfolio->getId(), 'clientId' => $client->getId()));
$data = $statement->fetch(\PDO::FETCH_ASSOC);
if ($data) {
$portfolio->setTotalValue(isset($data['total_value']) ? round($data['total_value'], 2) : 0);
$portfolio->setTotalInSecurities(isset($data['total_in_securities']) ? round($data['total_in_securities'], 2) : 0);
$portfolio->setTotalCashInAccounts(isset($data['total_cash_in_accounts']) ? round($data['total_cash_in_accounts'], 2) : 0);
$portfolio->setTotalCashInMoneyMarket(isset($data['total_cash_in_money_market']) ? round($data['total_cash_in_money_market'], 2) : 0);
$portfolio->setSasCash(isset($data['sas_cash']) ? round($data['sas_cash'], 2) : 0);
$portfolio->setCashBuffer(isset($data['cash_buffer']) ? round($data['cash_buffer'], 2) : 0);
$portfolio->setBillingCash(isset($data['billing_cash']) ? round($data['billing_cash'], 2) : 0);
}
}
