/**
* 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);
}
