/** * Load data fixtures with the passed EntityManager * * @param \Doctrine\Common\Persistence\ObjectManager $manager */ function load(ObjectManager $manager) { /** @var Security $securityRWX */ $securityRWX = $this->getReference('security-RWX'); /** @var Security $securityVCIT */ $securityVCIT = $this->getReference('security-VCIT'); /** @var Security $securityBND */ $securityBND = $this->getReference('security-BND'); /** @var SystemAccount $account916985328 */ $account916985328 = $this->getReference('system-account'); /** @var SystemAccount $account480888811 */ $account480888811 = $this->getReference('system-account-480888811'); /** @var SystemAccount $account122223334 */ $account122223334 = $this->getReference('system-account-122223334'); /** @var SystemAccount $account744888385 */ $account744888385 = $this->getReference('system-account-744888385'); /** @var Lot $lot0 */ $lot0 = $this->getReference('lot-0'); /** @var Lot $lot1 */ $lot1 = $this->getReference('lot-1'); $rebalancerAction = $this->getReference('miles-rebalancer-action'); $rebalancerQueue1 = new RebalancerQueue(); $rebalancerQueue1->setRebalancerAction($rebalancerAction); $rebalancerQueue1->setAmount(0); $rebalancerQueue1->setQuantity(36); $rebalancerQueue1->setStatus(RebalancerQueue::STATUS_SELL); $rebalancerQueue1->setLot($lot0); $rebalancerQueue1->setSecurity($securityRWX); $rebalancerQueue1->setSystemClientAccount($account916985328); $manager->persist($rebalancerQueue1); $rebalancerQueue2 = new RebalancerQueue(); $rebalancerQueue2->setRebalancerAction($rebalancerAction); $rebalancerQueue2->setAmount(0); $rebalancerQueue2->setQuantity(12); $rebalancerQueue2->setStatus(RebalancerQueue::STATUS_BUY); $rebalancerQueue2->setSecurity($securityVCIT); $rebalancerQueue2->setSystemClientAccount($account480888811); $manager->persist($rebalancerQueue2); $rebalancerQueue3 = new RebalancerQueue(); $rebalancerQueue3->setRebalancerAction($rebalancerAction); $rebalancerQueue3->setAmount(0); $rebalancerQueue3->setQuantity(1); $rebalancerQueue3->setStatus(RebalancerQueue::STATUS_BUY); $rebalancerQueue3->setSystemClientAccount($account122223334); $rebalancerQueue3->setSecurity($securityBND); $manager->persist($rebalancerQueue3); $rebalancerQueue4 = new RebalancerQueue(); $rebalancerQueue4->setRebalancerAction($rebalancerAction); $rebalancerQueue4->setAmount(0); $rebalancerQueue4->setQuantity(20); $rebalancerQueue4->setStatus(RebalancerQueue::STATUS_SELL); $rebalancerQueue4->setLot($lot1); $rebalancerQueue4->setSecurity($securityRWX); $rebalancerQueue4->setSystemClientAccount($account916985328); $manager->persist($rebalancerQueue4); $manager->flush(); }
public function findOneByRebalancerQueue(RebalancerQueue $rebalancerQueue) { $qb = $this->createQueryBuilder('st')->leftJoin('st.securityAssignment', 'sa')->leftJoin('sa.model', 'm')->where('sa.security = :security')->andWhere('m.owner = :owner')->setParameters(array('security' => $rebalancerQueue->getSecurity(), 'owner' => $rebalancerQueue->getRebalancerAction()->getJob()->getUser()))->setMaxResults(1); return $qb->getQuery()->getOneOrNullResult(); }
public function findRelatedSellTrades(RebalancerQueue $rebalancerQueue) { $qb = $this->createQueryBuilder('rq')->where('rq.systemClientAccount = :systemClientAccount')->andWhere('rq.subclass = :subclass')->andWhere('rq.security = :security')->andWhere('rq.rebalancerAction = :rebalancerAction')->setParameters(array('subclass' => $rebalancerQueue->getSubclass(), 'security' => $rebalancerQueue->getSecurity(), 'systemClientAccount' => $rebalancerQueue->getSystemClientAccount(), 'rebalancerAction' => $rebalancerQueue->getRebalancerAction())); return $qb->getQuery()->getResult(); }