Ejemplo n.º 1
0
function process_mail_queue($mysqli)
{
    $sql = " select * from sc_mail_queue where flag = 0 order by id limit 50";
    $map = array();
    $rows = MySQL\Helper::fetchRows($mysqli, $sql);
    foreach ($rows as $row) {
        $email = $row["email"];
        $source = $row["source"];
        settype($source, "integer");
        $khash = md5($email . $source);
        $name = $row["name"];
        if (!in_array($khash, $map)) {
            // send mail
            // assume error
            $code = 1;
            switch ($source) {
                case AppConstants::RESET_PASSWORD_MAIL:
                    $code = WebMail::sendResetPassword($name, $email, $row["token"]);
                    \com\indigloo\sc\mysql\Mail::toggle($email);
                    array_push($map, $khash);
                    break;
                case AppConstants::NEW_ACCOUNT_MAIL:
                    $code = WebMail::newAccountMail($name, $email);
                    break;
            }
            if ($code > 0) {
                $message = sprintf("code %s - error sending mail. aborting!", $code);
                throw new Exception($message);
            }
            //mail went
            \com\indigloo\sc\mysql\Mail::toggle($email);
            array_push($map, $khash);
        }
    }
    //:loop
    //delete old mails in queue
    $sql2 = " delete from sc_mail_queue where flag = 1 and created_on < (now() - interval 1 DAY)";
    MySQL\Helper::executeSQL($mysqli, $sql2);
}
Ejemplo n.º 2
0
Archivo: Activity.php Proyecto: rjha/sc
 function sendMail($row, $feed)
 {
     // determine if we want to send mail for this feed
     // #1 - who is the target for this mail?
     // the guy who is the "owner", e.g when I create a post
     // and you LIKE it, I should get a notification.
     // so "owner of entity" is the target of our mails.
     // if X created a post and Y liked it then X gets a mail
     // if Z likes the same post then also only X gets a mail
     // Y will not receive a mail.
     $verb = $row["verb"];
     $ownerId = $row["owner_id"];
     if ($verb == AppConstants::FOLLOW_VERB) {
         //mail target is the guy you are following
         $ownerId = $row["object_id"];
     }
     // #2 : I am not interested in receiving mails where
     // I am the subject or doer of deed!
     if (!empty($ownerId) && $ownerId != $row["subject_id"]) {
         // #3 - get my preference for this feed
         $preferenceDao = new \com\indigloo\sc\dao\Preference();
         $preferenceObj = $preferenceDao->get($ownerId);
         $flag = $this->getMailflag($preferenceObj, $verb);
         if ($flag) {
             $activityHtml = new \com\indigloo\sc\html\Activity();
             $emailData = $activityHtml->getEmailData($feed);
             if (empty($emailData)) {
                 $message = sprintf("ACTIVITY_ERROR : getting email data :id %d ", $row["id"]);
                 throw new \Exception($message);
             }
             $text = $emailData["text"];
             $html = $emailData["html"];
             $userDao = new \com\indigloo\sc\dao\User();
             $row = $userDao->getOnLoginId($ownerId);
             $name = $row["name"];
             $email = $row["email"];
             if (!empty($email)) {
                 $code = WebMail::sendActivityMail($name, $email, $text, $html);
                 if ($code > 0) {
                     $message = sprintf("ACTIVITY_ERROR : sending mail : id %d ", $row["id"]);
                     throw new \Exception($message);
                 }
             }
         }
         //condition:mail_flag
     }
     //condition:owner
 }