コード例 #1
0
ファイル: actions.class.php プロジェクト: yasirgit/afids
 public function executeAjaxGetTemplate(sfWebRequest $request)
 {
     $email_template = EmailTemplatePeer::retrieveByPK($request->getParameter('id'));
     $this->forward404Unless($email_template);
     $this->forward404Unless($email_template->getPersonId() == $this->getUser()->getId());
     $values = array();
     $values['subject'] = $email_template->getSubject();
     $values['name'] = $email_template->getSenderName();
     $values['email'] = $email_template->getSenderEmail();
     $values['message'] = $email_template->getBody();
     return $this->renderText(json_encode($values));
 }
コード例 #2
0
ファイル: BasePerson.php プロジェクト: yasirgit/afids
 /**
  * Returns the number of related EmailTemplate objects.
  *
  * @param      Criteria $criteria
  * @param      boolean $distinct
  * @param      PropelPDO $con
  * @return     int Count of related EmailTemplate objects.
  * @throws     PropelException
  */
 public function countEmailTemplates(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
 {
     if ($criteria === null) {
         $criteria = new Criteria(PersonPeer::DATABASE_NAME);
     } else {
         $criteria = clone $criteria;
     }
     if ($distinct) {
         $criteria->setDistinct();
     }
     $count = null;
     if ($this->collEmailTemplates === null) {
         if ($this->isNew()) {
             $count = 0;
         } else {
             $criteria->add(EmailTemplatePeer::PERSON_ID, $this->id);
             $count = EmailTemplatePeer::doCount($criteria, $con);
         }
     } else {
         // criteria has no effect for a new object
         if (!$this->isNew()) {
             // the following code is to determine if a new query is
             // called for.  If the criteria is the same as the last
             // one, just return count of the collection.
             $criteria->add(EmailTemplatePeer::PERSON_ID, $this->id);
             if (!isset($this->lastEmailTemplateCriteria) || !$this->lastEmailTemplateCriteria->equals($criteria)) {
                 $count = EmailTemplatePeer::doCount($criteria, $con);
             } else {
                 $count = count($this->collEmailTemplates);
             }
         } else {
             $count = count($this->collEmailTemplates);
         }
     }
     return $count;
 }
コード例 #3
0
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(EmailTemplatePeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(EmailTemplatePeer::DATABASE_NAME);
         $criteria->add(EmailTemplatePeer::ID, $pks, Criteria::IN);
         $objs = EmailTemplatePeer::doSelect($criteria, $con);
     }
     return $objs;
 }
コード例 #4
0
ファイル: actions.class.php プロジェクト: yasirgit/afids
 public function executeEmailBulkQueue(sfWebRequest $request)
 {
     $subject = $request->getParameter('subject');
     $to = $request->getParameter('recipients');
     $sender_email = $request->getParameter('sender_email');
     $sender_name = $request->getParameter('sender_name');
     $message = $request->getParameter('message');
     $send_date = $request->getParameter('send_date');
     $priority = $request->getParameter('priority');
     $errors = array();
     // validate recievers
     if (empty($to)) {
         $errors['email'][0] = 'please specify email address';
     } else {
         $recievers = explode(',', $to);
         $pat = '/^([^@\\s]+)@((?:[-a-z0-9]+\\.)+[a-z]{2,})$/i';
         $full_pat = '/^([- a-z0-9]+)\\<(([^@\\s]+)@((?:[-a-z0-9]+\\.)+[a-z]{2,}))\\>$/i';
         $emails = array();
         foreach ($recievers as $reciever) {
             $reciever = trim($reciever);
             if (empty($reciever)) {
                 continue;
             }
             if (preg_match($full_pat, $reciever, $matches)) {
                 $emails[$matches[2]] = $matches[1];
             } elseif (preg_match($pat, $reciever, $matches)) {
                 $emails[$matches[0]] = '';
             } else {
                 if (!isset($errors['email'])) {
                     $errors['email'] = array();
                 }
                 $errors['email'][] = $reciever . ' is unrecognizable email';
             }
         }
     }
     // validate subject
     if (empty($subject)) {
         $errors['subject'] = 'subject required';
     }
     // validate send_date
     if (empty($send_date)) {
         $errors['send_date'] = 'Send date required';
     }
     // validate sender
     $v_email = new sfValidatorEmail(array(), array('invalid' => 'please specify email address'));
     try {
         $sender_email = $v_email->clean($sender_email);
     } catch (sfValidatorError $e) {
         $errors['sender_email'] = $e->__toString();
     }
     // attachments
     $upload_dir = sfConfig::get('sf_upload_dir') . '/' . 'bulk-email-attachments' . '/';
     $files = array();
     foreach ($request->getFiles() as $file) {
         if ($file[0]['error'] != 0) {
             continue;
         }
         if (move_uploaded_file($file[0]["tmp_name"], $upload_dir . $file[0]["name"])) {
             $files[] = array('path' => $upload_dir, 'name' => $file[0]['name']);
         } else {
             //echo '<h1>Error while uploading '.$file[0]["tmp_name"].'/'.$file[0]["name"].' to '.$upload_dir . $file[0]["name"].'</h1>';
             $error['attachment'] = 'Error while uploading ' . $file[0]["name"];
         }
     }
     // catch errors
     if ($errors) {
         $this->email_templates = EmailTemplatePeer::getByPersonId($this->getUser()->getId());
         $this->errors = $errors;
         $this->recipients = $to;
         $this->subject = $subject;
         $this->sender_email = $sender_email;
         $this->sender_name = $sender_name;
         $this->message = $message;
         $this->priority = $priority;
         $this->send_date = $send_date;
         if (!empty($error['attachment'])) {
             $this->attachement_error = $error['attachment'];
         }
         $this->setTemplate('sendBulkQueue');
         return sfView::SUCCESS;
     }
     $email_letter = new EmailLetter();
     $email_letter->setSubject($subject);
     $email_letter->setSenderEmail($sender_email);
     $email_letter->setSenderName($sender_name);
     $email_letter->setBody($message);
     $email_letter->setAttachFilePath(serialize($files));
     $email_letter->setRecipients(implode(',', array_keys($emails)));
     $email_letter->save();
     $email_queue = new EmailQueue();
     $email_queue->setPersonId($this->getUser()->getId());
     $email_queue->setLetterId($email_letter->getId());
     $email_queue->setRequestDate(date('Y-m-d H:i:s', time()));
     $email_queue->setSendDate($send_date);
     $email_queue->setPriority($priority);
     $email_queue->setSendStatus('pending');
     $email_queue->save();
     /*
         $this->getComponent('mail', 'sendBulkQueue', array(
           'subject' => $subject,
           'recievers' => $emails,
           'sender' => array($sender_email => $sender_name),
           'body' => $message,
           'files' => $files,
         ));
     */
     $this->getUser()->setFlash('success', 'Bulk email have successfully queued!');
     $this->redirect($request->getReferer());
 }
コード例 #5
0
ファイル: actions.class.php プロジェクト: yasirgit/afids
 /**
  * CODE: send_email
  */
 public function executeSendBulk(sfWebRequest $request)
 {
     $this->email_templates = EmailTemplatePeer::getByPersonId($this->getUser()->getId());
     $this->errors = array();
     $this->recipients = '';
     $this->subject = '';
     $this->sender_email = '';
     $this->sender_name = '';
     $this->message = '';
 }
コード例 #6
0
ファイル: BaseEmailTemplate.php プロジェクト: yasirgit/afids
 /**
  * Populates the object using an array.
  *
  * This is particularly useful when populating an object from one of the
  * request arrays (e.g. $_POST).  This method goes through the column
  * names, checking to see whether a matching key exists in populated
  * array. If so the setByName() method is called for that column.
  *
  * You can specify the key type of the array by additionally passing one
  * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
  * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
  * The default key type is the column's phpname (e.g. 'AuthorId')
  *
  * @param      array  $arr     An array to populate the object from.
  * @param      string $keyType The type of keys the array uses.
  * @return     void
  */
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = EmailTemplatePeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setId($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setName($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setSubject($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setSenderName($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setSenderEmail($arr[$keys[4]]);
     }
     if (array_key_exists($keys[5], $arr)) {
         $this->setBody($arr[$keys[5]]);
     }
     if (array_key_exists($keys[6], $arr)) {
         $this->setPersonId($arr[$keys[6]]);
     }
 }
コード例 #7
0
ファイル: BasePersonPeer.php プロジェクト: yasirgit/afids
 /**
  * This is a method for emulating ON DELETE CASCADE for DBs that don't support this
  * feature (like MySQL or SQLite).
  *
  * This method is not very speedy because it must perform a query first to get
  * the implicated records and then perform the deletes by calling those Peer classes.
  *
  * This method should be used within a transaction if possible.
  *
  * @param      Criteria $criteria
  * @param      PropelPDO $con
  * @return     int The number of affected rows (if supported by underlying database driver).
  */
 protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
 {
     // initialize var to track total num of affected rows
     $affectedRows = 0;
     // first find the objects that are implicated by the $criteria
     $objects = PersonPeer::doSelect($criteria, $con);
     foreach ($objects as $obj) {
         // delete related EmailTemplate objects
         $c = new Criteria(EmailTemplatePeer::DATABASE_NAME);
         $c->add(EmailTemplatePeer::PERSON_ID, $obj->getId());
         $affectedRows += EmailTemplatePeer::doDelete($c, $con);
         // delete related PasswordRequest objects
         $c = new Criteria(PasswordRequestPeer::DATABASE_NAME);
         $c->add(PasswordRequestPeer::PERSON_ID, $obj->getId());
         $affectedRows += PasswordRequestPeer::doDelete($c, $con);
         // delete related PersonRole objects
         $c = new Criteria(PersonRolePeer::DATABASE_NAME);
         $c->add(PersonRolePeer::PERSON_ID, $obj->getId());
         $affectedRows += PersonRolePeer::doDelete($c, $con);
         // delete related PersonalNote objects
         $c = new Criteria(PersonalNotePeer::DATABASE_NAME);
         $c->add(PersonalNotePeer::PERSON_ID, $obj->getId());
         $affectedRows += PersonalNotePeer::doDelete($c, $con);
     }
     return $affectedRows;
 }
コード例 #8
0
ファイル: actions.class.php プロジェクト: yasirgit/afids
 public function executeSendEmail(sfWebRequest $request)
 {
     $subject = $request->getParameter('subject');
     $to = $request->getParameter('recipients');
     $sender_email = $request->getParameter('sender_email');
     $sender_name = $request->getParameter('sender_name');
     $message = $request->getParameter('message');
     $leg_ids = $request->getParameter('leg_ids');
     $errors = array();
     // validate recievers
     if (empty($to)) {
         $errors['email'][0] = 'please specify email address';
         $this->getUser()->setFlash('error', 'Please specify email address!');
         $this->redirect($request->getReferer());
     } else {
         $recievers = explode(',', $to);
         $pat = '/^([^@\\s]+)@((?:[-a-z0-9]+\\.)+[a-z]{2,})$/i';
         $full_pat = '/^([- a-z0-9]+)\\<(([^@\\s]+)@((?:[-a-z0-9]+\\.)+[a-z]{2,}))\\>$/i';
         $emails = array();
         foreach ($recievers as $reciever) {
             $reciever = trim($reciever);
             //if (empty($reciever)) { continue; }
             if (preg_match($full_pat, $reciever, $matches)) {
                 $emails[$matches[2]] = $matches[1];
             } elseif (preg_match($pat, $reciever, $matches)) {
                 $emails[$matches[0]] = '';
             } else {
                 if (!isset($errors['email'])) {
                     $errors['email'] = array();
                 }
                 $errors['email'][] = $reciever . ' is unrecognizable email';
             }
         }
         if (count($emails) < 1) {
             $errors['email'][0] = 'Please check email address';
             $this->getUser()->setFlash('error', 'Please check email address!');
             $this->redirect($request->getReferer());
         }
     }
     //    function checkEmail($email) {
     //  if(preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])
     //  ↪*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/",
     //               $email)){
     //    list($username,$domain)=split('@',$email);
     //      if(!checkdnsrr($domain,'MX')) {
     //        return false;
     //      }
     //    return true;
     //    }
     //    return false;
     //  }
     // validate subject
     if (empty($subject)) {
         $errors['subject'] = 'subject required';
     }
     // validate sender
     $v_email = new sfValidatorEmail(array(), array('invalid' => 'please specify email address'));
     try {
         if ($sender_email) {
             $sender_email = $v_email->clean($sender_email);
         } else {
             $sender_email = sfConfig::get('app_mailer_mail', '*****@*****.**');
         }
         if (!$sender_name) {
             $sender_name = sfConfig::get('app_mailer_name', 'AngelFlight Test');
         }
     } catch (sfValidatorError $e) {
         $errors['sender_email'] = $e->__toString();
         $this->getUser()->setFlash('error', 'Please check sender email address!');
         $this->redirect($request->getReferer());
     }
     // catch errors
     if ($errors) {
         $this->mission_legs = MissionLegPeer::getByMissionLegIds($leg_ids);
         $this->email_templates = EmailTemplatePeer::getByPersonId($this->getUser()->getId());
     }
     // attachments
     $files = array();
     foreach ($request->getFiles() as $file) {
         if ($file['error'] != 0) {
             continue;
         }
         $files[] = array('path' => $file['tmp_name'], 'name' => $file['name']);
     }
     // add leg information
     if ($leg_ids) {
         $mission_legs = MissionLegPeer::getByMissionLegIds($leg_ids);
         $message .= '<hr/>' . $this->getComponent('mission', 'includedMissionsTemplate', array('mission_legs' => $mission_legs));
     }
     # TODO queue emails instead of directly sending
     $this->getComponent('mail', 'missionToPilot', array('subject' => $subject, 'recievers' => $emails, 'sender' => array($sender_email => $sender_name), 'body' => $message, 'files' => $files));
     $this->getUser()->setFlash('success', 'Bulk email have successfully queued!');
     $this->redirect($request->getReferer());
 }