Is it possible to make a data union in symfony? I have query 1 and query 2 how can I make a data union?
QUERY 1 $c = new Criteria(); $start_date= $this->date.' 12:00:00 AM '; $end_date= $this->endDate.' 11:59:59 PM'; $userid = $this->getLoggedInUser()->getID(); $c1 = $c->getNewCriterion(TransactionPeer::CREATED_AT, $start_date,Criteria::GREATER_EQUAL); $c2 = $c->getNewCriterion(TransactionPeer::CREATED_AT, $end_date,Criteria::LESS_EQUAL); $c3 = $c->getNewCriterion(TransactionPeer::REMARKS, "%cancel%", Criteria::LIKE); $c1->addAnd($c2); $c->add($c1); $c->add(TransactionPeer::USER_ID, $userid); $c->addJoin(TransactionPeer::ACCOUNT_ID, AccountPeer::ID, Criteria::JOIN); $c->addJoin(TransactionPeer::ID, TicketPeer::TRANSACTION_ID, Criteria::JOIN); $c->add(TicketPeer::END_TIMESTAMP, null, Criteria::ISNOTNULL); $c->add(TicketPeer::TYPE, 'Sales'); $c->add(TicketPeer::CANCEL, '1', Criteria::EQUAL); $this->transaction = TransactionPeer::doSelect($c); $c->addAscendingOrderByColumn(TransactionPeer::CREATED_AT); QUERY 2 $d = new Criteria(); $start_date= $this->date.' 12:00:00 AM '; $end_date= $this->endDate.' 11:59:59 PM'; $userid = $this->getLoggedInUser()->getID(); $d1 = $c->getNewCriterion(TransactionPeer::CREATED_AT, $start_date,Criteria::GREATER_EQUAL); $d2 = $c->getNewCriterion(TransactionPeer::CREATED_AT, $end_date,Criteria::LESS_EQUAL); $d3 = $c->getNewCriterion(TransactionPeer::REMARKS, "%cancel%", Criteria::LIKE); $d2->addAnd ($d3); $d1->addAnd($d2); $d->add($d1); $d->add(TransactionPeer::USER_ID, $userid); $d->addJoin(TransactionPeer::ACCOUNT_ID, AccountPeer::ID, Criteria::JOIN); $d->addJoin(TransactionPeer::ID, TicketPeer::TRANSACTION_ID, Criteria::JOIN); $d->add(TicketPeer::END_TIMESTAMP, null, Criteria::ISNOTNULL); $d->add(TicketPeer::TYPE, 'Sales'); $this->transaction = TransactionPeer::doSelect($d); $c->addAscendingOrderByColumn(TransactionPeer::CREATED_AT); -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en