/** * Retrieve a single object by pkey and type * * @param int $type the type. * @param int $pk the primary key. * @param PropelPDO $con the connection to use * @return EventNotificationTemplate */ public static function retrieveTypeByPK($type, $pk, PropelPDO $con = null) { if (null !== ($obj = EventNotificationTemplatePeer::getInstanceFromPool((string) $pk))) { if ($obj->getType() != $type) { return null; } return $obj; } $criteria = new Criteria(EventNotificationTemplatePeer::DATABASE_NAME); $criteria->add(EventNotificationTemplatePeer::ID, $pk); $criteria->add(EventNotificationTemplatePeer::TYPE, $type); return EventNotificationTemplatePeer::doSelectOne($criteria, $con); }
/** * Retrieve event notification templates according to systemName * @param string $systemName * @param int $excludeId * @param array<int> $partnerIds * @param PropelPDO $con * @return EventNotificationTemplate */ public static function retrieveBySystemName($systemName, $excludeId = null, $partnerIds = null, PropelPDO $con = null) { $criteria = new Criteria(EventNotificationTemplatePeer::DATABASE_NAME); $criteria->add(EventNotificationTemplatePeer::STATUS, EventNotificationTemplateStatus::ACTIVE); $criteria->add(EventNotificationTemplatePeer::SYSTEM_NAME, $systemName); if ($excludeId) { $criteria->add(EventNotificationTemplatePeer::ID, $excludeId, Criteria::NOT_EQUAL); } // use the partner ids list if given if (!$partnerIds) { $partnerIds = array(kCurrentContext::getCurrentPartnerId()); } $criteria->add(EventNotificationTemplatePeer::PARTNER_ID, $partnerIds, Criteria::IN); $criteria->addDescendingOrderByColumn(EventNotificationTemplatePeer::PARTNER_ID); return EventNotificationTemplatePeer::doSelectOne($criteria); }