Guest User

Untitled

a guest
Oct 15th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. $criteria->addAlias("acc", AccountPeer::TABLE_NAME);
  2.  
  3. $criteria->addMultipleJoin(array(
  4. array(CustomerPeer::ID, AccountPeer::alias("acc", AccountPeer::CUSTOMER_ID)),
  5. array(AccountPeer::alias("acc", AccountPeer::BILLING_SYSTEM_ID), BillingSystemPeer::PORTAL_65),
  6. array(AccountPeer::alias("acc", AccountPeer::IS_ACTIVE), 1)),
  7. Criteria::LEFT_JOIN);
  8. $criteria->add(AccountPeer::alias("acc", AccountPeer::ID), null, Criteria::ISNULL);
  9. $criteria->setDistinct(1);
Add Comment
Please, Sign In to add comment