61 lines
1.3 KiB
PHP
61 lines
1.3 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Subclass for performing query and update operations on the 'st_newsletter_user' table.
|
|
*
|
|
* @package stNewsletterPlugin
|
|
* @subpackage libs
|
|
*/
|
|
class NewsletterUserPeer extends BaseNewsletterUserPeer
|
|
{
|
|
public static function retrieveByEmail($email)
|
|
{
|
|
$c = new Criteria();
|
|
|
|
$c->add(self::EMAIL, $email);
|
|
|
|
return self::doSelectOne($c);
|
|
}
|
|
|
|
public static function retrieveByHash($hash)
|
|
{
|
|
$c = new Criteria();
|
|
|
|
$c->add(self::HASH, $hash);
|
|
|
|
return self::doSelectOne($c);
|
|
}
|
|
|
|
public static function getAssignedById($id)
|
|
{
|
|
$c = new Criteria();
|
|
|
|
$c->addSelectColumn(NewsletterUserHasNewsletterGroupPeer::NEWSLETTER_GROUP_ID);
|
|
|
|
$c->add(NewsletterUserHasNewsletterGroupPeer::NEWSLETTER_USER_ID, $id);
|
|
|
|
NewsletterUserHasNewsletterGroupPeer::setHydrateMethod(array('NewsletterUserPeer', 'hydrateAssigned'));
|
|
|
|
$ret = NewsletterUserHasNewsletterGroupPeer::doSelect($c);
|
|
|
|
NewsletterUserHasNewsletterGroupPeer::setHydrateMethod(null);
|
|
|
|
return $ret;
|
|
}
|
|
|
|
public static function hydrateAssigned(ResultSet $rs)
|
|
{
|
|
$results = array();
|
|
|
|
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
|
|
|
|
while($rs->next())
|
|
{
|
|
$results[$rs->getInt('NEWSLETTER_GROUP_ID')] = true;
|
|
}
|
|
|
|
return $results;
|
|
}
|
|
|
|
}
|