protected function execute($arguments = array(), $options = array())
 {
     $context = sfContext::createInstance($this->configuration);
     $i18n = $context->getI18N();
     // initialize the database connection
     $databaseManager = new sfDatabaseManager($this->configuration);
     $connection = $databaseManager->getDatabase($options['connection'])->getConnection();
     $petition_text_by_lang = array();
     $table = PetitionSigningTable::getInstance();
     $con = $table->getConnection();
     $con->beginTransaction();
     try {
         $petition_signing = $table->createQuery('ps')->addFrom('ps.PetitionSigningWave psw')->where('ps.wave_cron > 0')->andWhere('DATE_SUB(NOW(),INTERVAL 2 MINUTE) > ps.updated_at')->andWhere('psw.status = ?', PetitionSigning::STATUS_VERIFIED)->orderBy('ps.created_at DESC')->fetchOne();
         if (empty($petition_signing)) {
             echo "nothing pending. (stop)";
             $connection->rollback();
             return;
         }
         /* @var $petition_signing PetitionSigning */
         $petition = $petition_signing->getPetition();
         /* @var $petition Petition */
         $is_pledge = $petition->getKind() == Petition::KIND_PLEDGE;
         $waves_verified = array();
         foreach ($petition_signing->getPetitionSigningWave() as $wave) {
             if ($wave->getStatus() == PetitionSigning::STATUS_VERIFIED) {
                 $waves_verified[] = $wave->getWave();
                 $wave->setStatus(PetitionSigning::STATUS_SENT);
             }
         }
         $contacts = ContactTable::getInstance()->createQuery('c')->addFrom('c.PetitionSigningContact psc')->where('psc.petition_signing_id = ?', $petition_signing->getId())->andWhereIn('psc.wave', $waves_verified)->addFrom('c.ContactMeta cm')->addFrom('cm.MailingListMetaChoice mlmc')->fetchArray();
         $subst_fields = $petition_signing->getPetition()->getGeoSubstFields();
         $i = 0;
         foreach ($contacts as $contact) {
             $subst = $petition_signing->getSubst();
             foreach ($subst_fields as $pattern => $subst_field) {
                 switch ($subst_field['type']) {
                     case 'fix':
                         $subst[$pattern] = $contact[$subst_field['id']];
                         break;
                     case 'free':
                         $subst[$pattern] = '';
                         foreach ($contact['ContactMeta'] as $cm) {
                             if ($cm['mailing_list_meta_id'] == $subst_field['id']) {
                                 $subst[$pattern] = $cm['value'];
                             }
                         }
                         break;
                     case 'choice':
                         $subst[$pattern] = '';
                         foreach ($contact['ContactMeta'] as $cm) {
                             if ($cm['mailing_list_meta_id'] == $subst_field['id']) {
                                 $subst[$pattern] = $cm['MailingListMetaChoice']['choice'];
                             }
                         }
                         break;
                 }
             }
             $wave = $petition_signing->getWave($contact['PetitionSigningContact'][0]['wave']);
             $wave_lang_id = $wave->getLanguageId();
             if ($wave_lang_id) {
                 $i18n->setCulture($wave_lang_id);
             }
             if ($contact['gender'] == Contact::GENDER_FEMALE) {
                 $personal_salutation = $i18n->__('Dear Madam %F %L,', array('%F' => $contact['firstname'], '%L' => $contact['lastname']));
             } elseif ($contact['gender'] == Contact::GENDER_MALE) {
                 $personal_salutation = $i18n->__('Dear Sir %F %L,', array('%F' => $contact['firstname'], '%L' => $contact['lastname']));
             } else {
                 $personal_salutation = $i18n->__('Dear Sir/Madam %F %L,', array('%F' => $contact['firstname'], '%L' => $contact['lastname']));
             }
             $personal_salutation .= "\n\n";
             $subst[PetitionTable::KEYWORD_PERSONAL_SALUTATION] = $personal_salutation;
             if ($wave) {
                 if ($is_pledge) {
                     $petition_contact = PetitionContactTable::getInstance()->findOneByPetitionIdAndContactId($petition->getId(), $contact['id']);
                     if (!$petition_contact) {
                         $petition_contact = new PetitionContact();
                         $petition_contact->setPetitionId($petition->getId());
                         $petition_contact->setContactId($contact['id']);
                         $new_secret = '';
                         while (strlen($new_secret) < 15) {
                             $new_secret .= strtoupper(strtr(base_convert(mt_rand(), 10, 36), array('0' => '', 'o' => '')));
                         }
                         $petition_contact->setSecret(substr($new_secret, 0, 15));
                         $petition_contact->save();
                     }
                     $secret = $petition_contact->getSecret();
                     $subst['#PLEDGE-URL#'] = $this->getRouting()->generate('pledge_contact', array('petition_id' => $petition->getId(), 'contact_id' => $contact['id'], 'secret' => $secret), true);
                 }
                 if (array_key_exists($contact['language_id'], $petition_text_by_lang)) {
                     $petition_text = $petition_text_by_lang[$contact['language_id']];
                 } else {
                     $petition_text = PetitionTextTable::getInstance()->fetchByPetitionAndPrefLang($petition, $contact['language_id'], Doctrine_Core::HYDRATE_ARRAY);
                     $petition_text_by_lang[$contact['language_id']] = $petition_text;
                 }
                 if ($petition->getKind() == Petition::KIND_PLEDGE) {
                     if ($petition_text) {
                         $subject = $petition_text['email_subject'];
                         $body = $petition_text['email_body'];
                     } else {
                         $subject = $body = '';
                     }
                 } else {
                     $subject = $wave->getField(Petition::FIELD_EMAIL_SUBJECT);
                     $body = $wave->getField(Petition::FIELD_EMAIL_BODY);
                 }
                 if ($petition_text) {
                     UtilMail::appendMissingKeywords($body, $petition_text['email_body'], PetitionSigningTable::$KEYWORDS);
                 }
                 $i++;
                 try {
                     /* Email to target  */
                     UtilMail::send(null, $wave->getEmailContact($petition->getFromEmail(), true), array($contact['email'] => $contact['firstname'] . ' ' . $contact['lastname']), $subject, $body, null, $subst, null, $wave->getEmailContact());
                     /* email problem */
                 } catch (Swift_RfcComplianceException $e) {
                     // ignore invalid emails
                 }
             }
         }
         $id = $petition_signing->getId();
         $waves_sent = implode(',', $waves_verified);
         $petition_signing->setWaveSent($petition_signing->getWaveCron());
         $petition_signing->setWaveCron(0);
         $petition_signing->save();
         echo "{$i} mails sent. [{$id}:{$waves_sent}] (continue)";
         $con->commit();
     } catch (Exception $e) {
         $con->rollback();
         print $e;
         echo 'exception in transaction. (stop)';
     }
 }