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