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