/**
* Exclude object from result
*
* @param Newsletter $newsletter Object to remove from the list of results
*
* @return NewsletterQuery The current query, for fluid interface
*/
public function prune($newsletter = null)
{
if ($newsletter) {
$this->addUsingAlias(NewsletterPeer::ID, $newsletter->getId(), Criteria::NOT_EQUAL);
}
return $this;
}
/**
* Declares an association between this object and a Newsletter object.
*
* @param Newsletter $v
* @return NewsletterMailing The current object (for fluent API support)
* @throws PropelException
*/
public function setNewsletter(Newsletter $v = null)
{
if ($v === null) {
$this->setNewsletterId(NULL);
} else {
$this->setNewsletterId($v->getId());
}
$this->aNewsletter = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Newsletter object, it will not be re-added.
if ($v !== null) {
$v->addNewsletterMailing($this);
}
return $this;
}
public function duplicateNewsletter($iOriginalId)
{
$oNewsletter = NewsletterQuery::create()->findPk($iOriginalId);
if ($oNewsletter) {
$oNewNewsletter = new Newsletter();
$oNewNewsletter->setSubject('[Copy] ' . $oNewsletter->getSubject());
$oNewNewsletter->setNewsletterBody($oNewsletter->getNewsletterBody());
$oNewNewsletter->setLanguageId($oNewsletter->getLanguageId());
$oNewNewsletter->setIsHtml($oNewsletter->getIsHtml());
$oNewNewsletter->setTemplateName($oNewsletter->getTemplateName());
$oNewNewsletter->save();
return $oNewNewsletter->getId();
}
}
/**
* Adds an object to the instance pool.
*
* Propel keeps cached copies of objects in an instance pool when they are retrieved
* from the database. In some cases -- especially when you override doSelect*()
* methods in your stub classes -- you may need to explicitly add objects
* to the cache in order to ensure that the same objects are always returned by doSelect*()
* and retrieveByPK*() calls.
*
* @param Newsletter $obj A Newsletter object.
* @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
*/
public static function addInstanceToPool($obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getId();
}
// if key === null
NewsletterPeer::$instances[$key] = $obj;
}
}
public static function createSubscriber(Newsletter $newsletter, ArrayObject $subscriber = null)
{
global $wpdb;
if (null == $subscriber) {
$subscriber = array('name' => self::randomString("name"), 'email' => self::randomString("user") . '@' . self::randomString("domain") . '.com', 'nid' => $newsletter->getId(), 'date' => time(), 'active' => 1, 'confirmed' => 1, 'hash' => self::randomString(self::randomString()));
}
$createSubscriberQuery = sprintf("INSERT INTO %swpr_subscribers (`nid`,`name`, `email`, `date`, `active`, `confirmed`, `hash` ) VALUES (%d, '%s', '%s','%s','%s','%s','%s');", $wpdb->prefix, $subscriber['nid'], $subscriber['name'], $subscriber['email'], $subscriber['date'], $subscriber['active'], $subscriber['confirmed'], $subscriber['hash']);
$wpdb->query($createSubscriberQuery);
$subscriberId = $wpdb->insert_id;
return new Subscriber($subscriberId);
}
public function remove(Newsletter $news)
{
// Supprime le mail
$this->db->Sql("DELETE FROM newsletter WHERE id_newsletter =:id", array('id' => $news->getId()));
}
/**
* Filter the query by a related Newsletter object
*
* @param Newsletter|PropelObjectCollection $newsletter The related object(s) to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return NewsletterMailingQuery The current query, for fluid interface
* @throws PropelException - if the provided filter is invalid.
*/
public function filterByNewsletter($newsletter, $comparison = null)
{
if ($newsletter instanceof Newsletter) {
return $this->addUsingAlias(NewsletterMailingPeer::NEWSLETTER_ID, $newsletter->getId(), $comparison);
} elseif ($newsletter instanceof PropelObjectCollection) {
if (null === $comparison) {
$comparison = Criteria::IN;
}
return $this->addUsingAlias(NewsletterMailingPeer::NEWSLETTER_ID, $newsletter->toKeyValue('PrimaryKey', 'Id'), $comparison);
} else {
throw new PropelException('filterByNewsletter() only accepts arguments of type Newsletter or PropelCollection');
}
}
