Пример #1
0
 /**
  * @return bool
  */
 public function isShortTerm()
 {
     $today = new \DateTime();
     if ($this->getInitial()) {
         $difference = $today->diff($this->initial->getDate());
     } else {
         $difference = $today->diff($this->getDate());
     }
     return $difference->d <= 365;
 }
Пример #2
0
 /**
  * Load data fixtures with the passed EntityManager
  *
  * @param \Doctrine\Common\Persistence\ObjectManager $manager
  */
 function load(ObjectManager $manager)
 {
     /** @var Transaction[] $transactions */
     $transactions = $manager->getRepository('WealthbotAdminBundle:Transaction')->findBy(array(), array('id' => 'ASC'));
     $this->lots = array();
     foreach ($transactions as $transaction) {
         $date = $transaction->getTxDate();
         if ($transaction->getTransactionType()->getName() == 'BUY') {
             if ($transaction->getSecurity()->getSymbol() == 'IDA12') {
                 //FOR MONEY (MF)
                 $oldLot = $this->findLot($date, $transaction->getSecurity(), $transaction->getAccount(), 0, self::FINDLOT_MF);
                 if (!$oldLot) {
                     $lot = new Lot();
                     $lot->setSecurity($transaction->getSecurity());
                     $lot->setClientSystemAccount($transaction->getAccount());
                     $lot->setPosition(null);
                     $lot->setStatus(Lot::LOT_INITIAL);
                     $lot->setWashSale(false);
                     $lot->setCostBasisKnown(false);
                     $lot->setCostBasis($transaction->getNetAmount());
                     $lot->setQuantity($transaction->getNetAmount());
                     $lot->setAmount($transaction->getNetAmount());
                     $lot->setDate($date);
                     $transaction->setLot($lot);
                     $manager->persist($lot);
                     $this->lots[] = $lot;
                 } else {
                     if ($oldLot->getDate()->format('Y-m-d') == $date->format('Y-m-d')) {
                         $amount = $oldLot->getAmount() + $transaction->getNetAmount();
                         $oldLot->setAmount($amount);
                         $oldLot->setQuantity($amount);
                         $oldLot->setCostBasis($amount);
                         $transaction->setLot($oldLot);
                     } else {
                         $amount = $oldLot->getAmount() + $transaction->getNetAmount();
                         $lot = new Lot();
                         $lot->setSecurity($transaction->getSecurity());
                         $lot->setClientSystemAccount($transaction->getAccount());
                         $lot->setPosition(null);
                         $lot->setStatus(Lot::LOT_IS_OPEN);
                         $lot->setWashSale(false);
                         $lot->setCostBasisKnown(false);
                         $lot->setAmount($amount);
                         $lot->setQuantity($amount);
                         $lot->setCostBasis($amount);
                         $lot->setDate($date);
                         $transaction->setLot($lot);
                         $manager->persist($lot);
                         $this->lots[] = $lot;
                     }
                 }
             } else {
                 //FOR SHARES
                 $lot = new Lot();
                 $lot->setSecurity($transaction->getSecurity());
                 $lot->setClientSystemAccount($transaction->getAccount());
                 $lot->setPosition(null);
                 $lot->setStatus(Lot::LOT_INITIAL);
                 $lot->setWashSale(false);
                 $lot->setCostBasisKnown(true);
                 $lot->setCostBasis($transaction->getGrossAmount());
                 $lot->setQuantity($transaction->getQty());
                 $lot->setAmount($transaction->getNetAmount());
                 $lot->setDate($date);
                 $transaction->setLot($lot);
                 $manager->persist($lot);
                 $this->lots[] = $lot;
             }
         }
         //----------
         if ($transaction->getTransactionType()->getName() == 'SELL') {
             if ($transaction->getSecurity()->getSymbol() == 'IDA12') {
                 //FOR MONEY (MF)
                 $oldLot = $this->findLot($date, $transaction->getSecurity(), $transaction->getAccount(), 0, self::FINDLOT_MF);
                 if (!$oldLot) {
                     throw new \Exception('Error, can\'t find previous MF before SALE trn');
                 } else {
                     if ($oldLot->getDate()->format('Y-m-d') == $date->format('Y-m-d')) {
                         $amount = $oldLot->getAmount() - $transaction->getNetAmount();
                         $oldLot->setAmount($amount);
                         $oldLot->setQuantity($amount);
                         $oldLot->setCostBasis($amount);
                         $transaction->setLot($oldLot);
                     } else {
                         $amount = $oldLot->getAmount() - $transaction->getNetAmount();
                         $lot = new Lot();
                         $lot->setSecurity($transaction->getSecurity());
                         $lot->setClientSystemAccount($transaction->getAccount());
                         $lot->setPosition(null);
                         $lot->setStatus(Lot::LOT_IS_OPEN);
                         $lot->setWashSale(false);
                         $lot->setCostBasisKnown(false);
                         $lot->setAmount($amount);
                         $lot->setQuantity($amount);
                         $lot->setCostBasis($amount);
                         $lot->setDate($date);
                         $transaction->setLot($lot);
                         $manager->persist($lot);
                         $this->lots[] = $lot;
                     }
                 }
             } else {
                 //FOR SHARES
                 $initLot = $this->findLot($date, $transaction->getSecurity(), $transaction->getAccount(), $transaction->getQty(), self::FINDLOT_INITIAL);
                 if ($initLot) {
                     $gain = $transaction->getNetAmount() - $initLot->getAmount();
                     $lot = new Lot();
                     $lot->setSecurity($transaction->getSecurity());
                     $lot->setClientSystemAccount($transaction->getAccount());
                     $lot->setPosition(null);
                     $lot->setStatus(Lot::LOT_CLOSED);
                     $lot->setWashSale(false);
                     $lot->setCostBasisKnown(false);
                     $lot->setAmount($transaction->getNetAmount());
                     $lot->setQuantity($transaction->getQty());
                     $lot->setCostBasis($transaction->getGrossAmount());
                     $lot->setInitial($initLot);
                     $lot->setDate($date);
                     $lot->setRealizedGain($gain);
                     $initLot->setWasClosed(true);
                     $transaction->setLot($lot);
                     $manager->persist($lot);
                     $this->lots[] = $lot;
                 } else {
                     throw new \Exception('Not found opened LOT for trn.');
                 }
             }
         }
     }
     /** @var SecurityRepository $securityRepo */
     $securityRepo = $manager->getRepository('WealthbotAdminBundle:Security');
     //FOR MUNI
     $date = new \DateTime();
     $lot = new Lot();
     $lot->setSecurity($securityRepo->findOneBySymbol('VTI'));
     $lot->setClientSystemAccount($this->getReference('system-account-214888609'));
     $lot->setPosition(null);
     $lot->setStatus(Lot::LOT_INITIAL);
     $lot->setWashSale(false);
     $lot->setCostBasisKnown(false);
     $lot->setAmount(1000);
     $lot->setQuantity(100);
     $lot->setCostBasis(800);
     $lot->setInitial(null);
     $lot->setDate($date->modify('-2 months'));
     $lot->setRealizedGain(0);
     $manager->persist($lot);
     $manager->flush();
     $dates = array();
     $accounts = array();
     //next we have to create additional lots for every LOT DAY.
     /** @var Lot[] $lots */
     $lots = $manager->getRepository('WealthbotClientBundle:Lot')->findAll();
     $lots[0]->setWasRebalancerDiff(1);
     foreach ($lots as $lot) {
         $date = $lot->getDate()->format('Y-m-d');
         if (!in_array($date, $dates)) {
             $dates[] = $date;
         }
         $accountId = $lot->getClientSystemAccount()->getId();
         if (!in_array($accountId, $accounts)) {
             $accounts[] = $accountId;
         }
     }
     foreach ($dates as $date) {
         $dateTime = new \DateTime($date);
         /** @var Lot[] $openLots */
         $openLots = $manager->getRepository('WealthbotClientBundle:Lot')->getOpenedOnDate($dateTime);
         foreach ($openLots as $lot) {
             if ($lot->getDate()->format('Y-m-d') != $dateTime->format('Y-m-d')) {
                 $cloneLot = new Lot();
                 $cloneLot->setSecurity($lot->getSecurity());
                 $cloneLot->setClientSystemAccount($lot->getClientSystemAccount());
                 $cloneLot->setPosition(null);
                 $cloneLot->setStatus(Lot::LOT_IS_OPEN);
                 $cloneLot->setWashSale(false);
                 $cloneLot->setCostBasisKnown($lot->isCostBasisKnown());
                 $cloneLot->setAmount($lot->getAmount());
                 $cloneLot->setQuantity($lot->getQuantity());
                 $cloneLot->setCostBasis($lot->getCostBasis());
                 $cloneLot->setInitial($lot);
                 $cloneLot->setDate($dateTime);
                 $manager->persist($cloneLot);
                 $this->lots[] = $cloneLot;
             }
         }
     }
     foreach ($this->lots as $key => $lot) {
         $this->setReference('lot-' . $key, $lot);
     }
     $manager->flush();
 }