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); }