public function testLoadFromArray()
{
$this->assertEquals(10, $this->rebalancerAction->getId());
$this->assertEquals(13, $this->rebalancerAction->getAccountId());
$this->assertEquals(123, $this->rebalancerAction->getJob()->getId());
$this->assertEquals(214, $this->rebalancerAction->getPortfolioId());
$this->assertEquals(147, $this->rebalancerAction->getClient()->getId());
}
/**
* @param RebalancerAction $rebalancerAction
* @return Client
*/
public function getClientByRebalancerAction(RebalancerAction $rebalancerAction)
{
$sql = "SELECT c.*, up.client_account_managed as accountManaged, up.estimated_income_tax as taxBracket FROM " . $this->table . " c\n LEFT JOIN " . self::TABLE_CLIENT_PORTFOLIO . " cp ON cp.client_id = c.id\n LEFT JOIN " . self::TABLE_CLIENT_PORTFOLIO_VALUE . " cpv ON cpv.client_portfolio_id = cp.id\n LEFT JOIN " . self::TABLE_REBALANCER_ACTION . " ra ON ra.client_portfolio_value_id = cpv.id\n LEFT JOIN " . self::TABLE_USER_PROFILE . " up ON c.id = up.user_id\n WHERE ra.id = :rebalancerActionId AND cp.is_active = 1 AND c.roles LIKE :roles;\n ";
$parameters = array('rebalancerActionId' => $rebalancerAction->getId(), 'roles' => '%ROLE_CLIENT%');
$result = $this->db->queryOne($sql, $parameters);
$client = $this->bindObject($result);
$rebalancerAction->setClient($client);
return $client;
}
public function saveStatus(RebalancerAction $rebalancerAction)
{
$sql = "UPDATE " . self::TABLE_REBALANCER_ACTION . " SET status = :status\n WHERE id = :id";
$parameters = array('id' => $rebalancerAction->getId(), 'status' => $rebalancerAction->getStatus());
$this->db->query($sql, $parameters);
}
