public function setUp()
{
$connection = WealthbotMySqlSqliteConnection::getInstance();
$sql = "SELECT * FROM " . BaseRepository::TABLE_SYSTEM_ACCOUNT . " ORDER BY id ASC LIMIT 1";
$result = $connection->query($sql);
$this->account = new Account();
$this->account->loadFromArray($result[0]);
$this->repository = new DistributionRepository();
$this->businessCalendar = new BusinessCalendar();
}
public function findAccountById($accountId)
{
$sql = "SELECT a.*, IFNULL(SUM(bi.feeBilled), 0) as billing_cash\n FROM " . self::TABLE_SYSTEM_ACCOUNT . " a\n LEFT JOIN " . self::TABLE_BILL_ITEM . " bi ON (bi.system_account_id = a.id AND bi.status = :status)\n WHERE a.id = :accountId\n GROUP BY a.id";
$parameters = array('accountId' => $accountId, 'status' => self::STATUS_BILL_APPROVED);
$result = $this->db->query($sql, $parameters);
if (!isset($result[0])) {
return null;
}
$account = new Account();
$account->loadFromArray($result[0]);
return $account;
}
public function setUp()
{
$data = array('id' => 1, 'type' => Account::TYPE_PERSONAL_INVESTMENT, 'status' => Account::STATUS_INIT_REBALANCE, 'isFirstTime' => true, 'isActiveEmployer' => true, 'isReadyToRebalance' => true, 'scheduledDistribution' => 15000, 'oneTimeDistribution' => 3450, 'cashBuffer' => 2300, 'sasCash' => 3000, 'billingCash' => 3400, 'totalCash' => 30000, 'cashForBuy' => 200, 'client' => array('id' => 28), 'securities' => array(array('id' => 1), array('id' => 2)));
$this->account = $this->getMockBuilder('Model\\WealthbotRebalancer\\Account')->disableOriginalConstructor()->setMethods(null)->getMock();
$this->account->loadFromArray($data);
}
