/**
*
* @param MailingList $source
* @param Campaign $campaign
* @param string $name
* @return MailingList|null
*/
public function copy(MailingList $source, Campaign $campaign = null, $name = null)
{
$con = $this->getConnection();
$con->beginTransaction();
try {
$target = new MailingList();
$target->setStatus(MailingListTable::STATUS_DRAFT);
if ($name) {
$target->setName($name);
} else {
$target->setName($source->getName() . ' copy ' . gmdate('Y-M-d H:i'));
}
if ($campaign) {
$target->setCampaign($campaign);
}
$target->save();
$meta_ids = array();
$choice_ids = array();
foreach ($source->getMailingListMeta() as $meta_source) {
/* @var $meta_source MailingListMeta */
$meta = new MailingListMeta();
$meta->setMailingList($target);
$meta->setKind($meta_source->getKind());
$meta->setName($meta_source->getName());
$meta->setSubst($meta_source->getSubst());
$meta->save();
$meta_ids[$meta_source->getId()] = $meta->getId();
foreach ($meta_source->getMailingListMetaChoice() as $choice_source) {
/* @var $choice_source MailingListMetaChoice */
$choice = new MailingListMetaChoice();
$choice->setMailingListMeta($meta);
$choice->setChoice($choice_source->getChoice());
$choice->save();
$choice_ids[$choice_source->getId()] = $choice->getId();
}
}
foreach ($source->getContact() as $contact_source) {
/* @var $contact_source Contact */
$contact = new Contact();
$contact->setMailingList($target);
$contact->setStatus($contact_source->getStatus());
$contact->setEmail($contact_source->getEmail());
$contact->setGender($contact_source->getGender());
$contact->setFirstname($contact_source->getFirstname());
$contact->setLastname($contact_source->getLastname());
$contact->setCountry($contact_source->getCountry());
$contact->save();
foreach ($contact_source->getContactMeta() as $contact_meta_source) {
/* @var $contact_meta_source ContactMeta */
$contact_meta = new ContactMeta();
$contact_meta->setContact($contact);
$contact_meta->setValue($contact_meta_source->getValue());
$contact_meta->setMailingListMetaId($meta_ids[$contact_meta_source->getMailingListMetaId()]);
if ($contact_meta_source->getMailingListMetaChoiceId()) {
$contact_meta->setMailingListMetaChoiceId($choice_ids[$contact_meta_source->getMailingListMetaChoiceId()]);
}
$contact_meta->save();
}
}
$con->commit();
return $target;
} catch (Exception $e) {
$con->rollback();
}
return null;
}
protected function doSave($con = null)
{
parent::doSave($con);
$this->getObject()->getMailingList()->invalidateCache();
$choices_db = $this->getObject()->getMailingListMetaChoice();
$choices = $this->getObject()->getKind() == MailingListMeta::KIND_CHOICE ? $this->getValue('choices') : array();
$choices_lower = array_map('strtolower', $choices);
$done = array();
foreach ($choices_db as $choice_db) {
$lower = mb_strtolower($choice_db['choice'], 'utf-8');
$choice_key = array_search($lower, $choices_lower, true);
if ($choice_key === false) {
$choice_db->delete($con);
} else {
$done[] = $lower;
if ($choices[$choice_key] !== $choice_db['choice']) {
$choice_db['choice'] = $choices[$choice_key];
$choice_db->save($con);
}
}
}
foreach ($choices as $choice) {
if (!in_array(mb_strtolower($choice, 'utf-8'), $done, true)) {
$choice_db = new MailingListMetaChoice();
$choice_db->setMailingListMetaId($this->getObject()->getId());
$choice_db->setChoice($choice);
$choice_db->save();
}
}
}