public function findVSPForTradeData(TradeData $tradeData)
{
$sql = "\n SELECT 'VSP' as purchase, DATE_FORMAT(l.date,'%m%d%Y') as purchase_date, rq.quantity\n FROM rebalancer_queue rq\n LEFT JOIN lots l ON l.id = rq.lot_id\n LEFT JOIN rebalancer_actions ra On ra.id = rq.rebalancer_action_id\n WHERE rq.system_client_account_id = :accountId AND rq.security_id = :securityId\n ";
$connection = $this->getEntityManager()->getConnection();
$stmt = $connection->prepare($sql);
// $stmt->bindValue('jobId', $tradeData->getJobId());
$stmt->bindValue('accountId', $tradeData->getAccountId());
$stmt->bindValue('securityId', $tradeData->getSecurityId());
$stmt->execute();
return $stmt->fetchAll();
}
