/**
  *
  * @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();
     $metas = $this->getObject()->getMailingList()->getMailingListMeta();
     // TODO: optimize
     $contact_metas = $this->getObject()->getContactMeta();
     foreach ($metas as $meta) {
         /* @var $meta MailingListMeta */
         $value = $this->getValue('meta_' . $meta['id']);
         if ($meta['kind'] == MailingListMeta::KIND_CHOICE && $meta->getMulti()) {
             if (!is_array($value)) {
                 $value = array();
             }
             $keep_multis = array();
             foreach ($contact_metas as $cc) {
                 if ($cc['mailing_list_meta_id'] === $meta['id']) {
                     /* @var $cc ContactMeta */
                     if (in_array($cc->getMailingListMetaChoiceId(), $value)) {
                         $keep_multis[] = $cc->getMailingListMetaChoiceId();
                         // keep
                     } else {
                         $cc->delete($con);
                         // delete
                     }
                 }
             }
             foreach ($value as $value_i) {
                 if (!in_array($value_i, $keep_multis)) {
                     $contact_meta = new ContactMeta();
                     // create
                     $contact_meta->setMailingListMetaId($meta['id']);
                     $contact_meta->setContactId($this->getObject()->getId());
                     $contact_meta->setMailingListMetaChoiceId($value_i);
                     $contact_meta->save($con);
                 }
             }
         } else {
             $contact_meta = null;
             foreach ($contact_metas as $cc) {
                 if ($cc['mailing_list_meta_id'] === $meta['id']) {
                     $contact_meta = $cc;
                     break;
                 }
             }
             if ($contact_meta === null) {
                 $contact_meta = new ContactMeta();
                 $contact_meta->setMailingListMetaId($meta['id']);
                 $contact_meta->setContactId($this->getObject()->getId());
             }
             switch ($meta['kind']) {
                 case MailingListMeta::KIND_CHOICE:
                     $contact_meta->setMailingListMetaChoiceId($value);
                     break;
                 case MailingListMeta::KIND_FREE:
                     $contact_meta->setValue($value);
                     break;
             }
             $contact_meta->save($con);
         }
     }
 }