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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
