/**
* Load data fixtures with the passed EntityManager
*
* @param \Doctrine\Common\Persistence\ObjectManager $manager
*/
function load(ObjectManager $manager)
{
$repository = $manager->getRepository('WealthbotClientBundle:ClientPortfolio');
$clientPortfolios = $repository->findAll();
$years = array(2012, 2013);
// $mo = 13;
mt_srand(0);
foreach ($years as $yr) {
$mo = $yr === 2012 ? 13 : (int) date('m');
for ($m = 1; $m < $mo; $m++) {
/** @var ClientPortfolio $clientPortfolio */
foreach ($clientPortfolios as $cp => $clientPortfolio) {
$portfolioValue = new ClientPortfolioValue();
$portfolioValue->setClientPortfolio($clientPortfolio);
$pdate = new \DateTime();
$pdate->setDate($yr, $m, 1);
if ('*****@*****.**' == $clientPortfolio->getClient()->getEmail()) {
$securities = 758379;
$money_market = 881586;
$accounts = 685475;
$sasCash = 3000;
$cashBuffer = 7000;
$billingCash = 10000;
} else {
$securities = mt_rand(0, 1000000);
$money_market = mt_rand(0, 1000000);
$accounts = mt_rand(0, 1000000);
$sasCash = 0;
$cashBuffer = 0;
$billingCash = 0;
}
$total = $securities + $money_market + $accounts;
$portfolioValue->setTotalCashInMoneyMarket($money_market);
$portfolioValue->setTotalInSecurities($securities);
$portfolioValue->setTotalCashInAccounts($accounts);
$portfolioValue->setTotalValue($total);
$portfolioValue->setSasCash($sasCash);
$portfolioValue->setCashBuffer($cashBuffer);
$portfolioValue->setBillingCash($billingCash);
$portfolioValue->setDate($pdate);
$portfolioValue->setModelDeviation(4);
$portfolioValue->setRequiredCash(mt_rand(1000, 300000));
$portfolioValue->setInvestableCash(mt_rand(1000, 30000));
$manager->persist($portfolioValue);
}
}
}
$manager->flush();
}
/**
* @see Command
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$em = $this->getContainer()->get('doctrine')->getEntityManager();
$em->getConnection()->getConfiguration()->setSQLLogger(null);
$accountNumber = $input->getArgument('accountNumber');
$systemAccount = $em->getRepository('WealthbotClientBundle:SystemAccount')->findOneBy(array('account_number' => $accountNumber));
if ($systemAccount == null) {
throw new EntityNotFoundException("System client account by account number [{$accountNumber}] not found.");
}
$portfolio = $em->getRepository('WealthbotClientBundle:ClientPortfolio')->findOneByClient($systemAccount->getClient());
if ($portfolio == null) {
$clientId = $systemAccount->getClient()->getId();
throw new EntityNotFoundException("Client portfolio by client id [{$clientId}] not found.");
}
$i = 0;
mt_srand(0);
foreach (array(2013, 2014) as $yr) {
$mo = $yr === 2013 ? 13 : (int) date('m');
for ($m = 1; $m < $mo; $m++) {
$pdate = \DateTime::createFromFormat('m-d-Y', "{$m}-01-{$yr}");
$securities = mt_rand(0, 1000000);
$money_market = mt_rand(0, 1000000);
$accounts = mt_rand(0, 1000000);
$total = $securities + $money_market + $accounts;
$sql = "SELECT * FROM client_portfolio_values cpv WHERE DATE(cpv.date) = DATE(:createdAt) AND cpv.client_portfolio_id = :clientPortfolioId LIMIT 1";
$stmt = $em->getConnection()->prepare($sql);
$stmt->bindValue('createdAt', $pdate->format('Y-m-d'));
$stmt->bindValue('clientPortfolioId', $portfolio->getId());
$stmt->execute();
if ((bool) $stmt->fetchColumn() == false) {
$portfolioValue = new ClientPortfolioValue();
$portfolioValue->setClientPortfolio($portfolio);
$portfolioValue->setTotalCashInMoneyMarket($money_market);
$portfolioValue->setTotalInSecurities($securities);
$portfolioValue->setTotalCashInAccounts($accounts);
$portfolioValue->setTotalValue($total);
$portfolioValue->setSasCash(0);
$portfolioValue->setCashBuffer(0);
$portfolioValue->setBillingCash(0);
$portfolioValue->setDate($pdate);
$portfolioValue->setModelDeviation(4);
$portfolioValue->setRequiredCash(mt_rand(1000, 300000));
$portfolioValue->setInvestableCash(mt_rand(1000, 30000));
$em->persist($portfolioValue);
$i++;
}
}
}
$em->flush();
$output->writeln("Client portfolio value [{$i}] has been loaded.");
$output->writeln("Success!");
}
public function findLatestClientAccountValuesByPortfolioValue(ClientPortfolioValue $clientPortfolioValue)
{
$qb = $this->findLatestValuesForClientsQuery(array($clientPortfolioValue->getClientPortfolio()));
return $qb->getQuery()->getResult();
}
