public function findClientsByRia(Ria $ria) { $sql = "SELECT c.*, cp.client_account_managed as accountManaged, cp.estimated_income_tax as taxBracket\n FROM " . $this->table . " c\n LEFT JOIN " . self::TABLE_USER_PROFILE . " cp ON c.id = cp.user_id\n WHERE c.roles LIKE :roles AND cp.ria_user_id = :ria_user_id AND c.enabled = 1\n "; $parameters = array('ria_user_id' => $ria->getId(), 'roles' => '%ROLE_CLIENT%'); $result = $this->db->query($sql, $parameters); $collection = $this->bindCollection($result); foreach ($collection as $client) { $client->setRia($ria); } return $collection; }
public function txMin(\Model\WealthbotRebalancer\Ria $ria, $type = null, $val = null) { if (!is_null($val)) { $this->txMin = $val; } if (!isset($this->txMin) || is_null($this->txMin)) { $res = $this->__getRiaData($ria->getId()); $this->txMin = !is_null($type) ? $res[0]['transaction_amount_' . $type] : $res[0]['transaction_amount']; } return $this->txMin; }