X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fmassmailer.inc.php;h=269a570f5c2893892008d3b6a88df33ece0307d7;hb=c4b6b1f4989e57e80aa721028d8255a3800442f9;hp=a1d49f36aa6246b457f65fdacc3242cd3f7ffba7;hpb=1610f13adfdd3cadd5fba359973b8e04afc1e527;p=platal.git diff --git a/include/massmailer.inc.php b/include/massmailer.inc.php index a1d49f3..269a570 100644 --- a/include/massmailer.inc.php +++ b/include/massmailer.inc.php @@ -1,6 +1,6 @@ _title_mail : $this->_title; } - public function head($prenom = null, $nom = null, $sexe = null, $type = 'text') + public function head($user = null, $type = 'text') { - if (is_null($prenom)) { + if (is_null($user)) { return $this->_head; } else { $head = $this->_head; - $head = str_replace('', $sexe ? 'Chère' : 'Cher', $head); - $head = str_replace('', $prenom, $head); - $head = str_replace('', $nom, $head); + $head = str_replace('', $user->isFemale() ? 'Chère' : 'Cher', $head); + $head = str_replace('', $user->displayName(), $head); + $head = str_replace('', '', $head); return format_text($head, $type, 2, 64); } } @@ -127,26 +134,22 @@ abstract class MassMailer } } - public function toText(&$page, $prenom, $nom, $sexe) + public function toText(&$page, $user) { $this->css($page); $page->assign('is_mail', false); $page->assign('mail_part', 'text'); - $page->assign('prenom', $prenom); - $page->assign('nom', $nom); - $page->assign('sexe', $sexe); + $page->assign('user', $user); $this->assignData($page); } - public function toHtml(&$page, $prenom, $nom, $sexe) + public function toHtml(&$page, $user) { $this->css($page); $page->assign('prefix', $this->_prefix . '/' . $this->id()); $page->assign('is_mail', false); $page->assign('mail_part', 'html'); - $page->assign('prenom', $prenom); - $page->assign('nom', $nom); - $page->assign('sexe', $sexe); + $page->assign('user', $user); $this->assignData($page); } @@ -157,72 +160,61 @@ abstract class MassMailer return $hash; } - public function sendTo($prenom, $nom, $login, $sexe, $html, $hash = 0) + public function sendTo($user, $hash = null) { - global $globals; - $alias = $login; - if (strpos($login, '@') === false) { - $login = "$login@{$globals->mail->domain}"; + if (is_null($hash)) { + $hash = XDB::fetchOneCell("SELECT hash + FROM {$this->_subscriptionTable} + WHERE uid = {?}", $user->id()); } - require_once('user.func.inc.php'); - $forlife = get_user_forlife($login, '_silent_user_callback'); - if ($forlife) { - $alias = $forlife; - } - if (strpos($alias, '@') === false && (is_null($hash) || $hash == 0)) { - - $hash = $this->createHash(array($prenom, $nom, $login, $sexe, $html, rand(), "X.org rulez")); - XDB::query("UPDATE {$this->_subscriptionTable} as ni - INNER JOIN aliases AS a ON (ni.user_id = a.id) - SET ni.hash = {?} - WHERE ni.user_id != 0 AND a.alias = {?}", - $hash, $alias); + if (is_null($hash)) { + $hash = $this->createHash(array($user->displayName(), $user->fullName(), + $user->isFemale(), $user->isEmailFormatHtml(), + rand(), "X.org rulez")); + XDB::execute("UPDATE {$this->_subscriptionTable} as ni + SET ni.hash = {?} + WHERE ni.uid = {?}", + $hash, $user->id()); } $mailer = new PlMailer($this->_tpl); $this->assignData($mailer); $mailer->assign('is_mail', true); - $mailer->assign('prenom', $prenom); - $mailer->assign('nom', $nom); - $mailer->assign('sexe', $sexe); + $mailer->assign('user', $user); $mailer->assign('prefix', null); $mailer->assign('hash', $hash); - $mailer->assign('email', $login); - $mailer->assign('alias', $alias); - $mailer->addTo("\"$prenom $nom\" <$login>"); - $mailer->send($html); + $mailer->addTo('"' . $user->fullName() . '" <' . $user->bestEmail() . '>'); + $mailer->send($user->isEmailFormatHtml()); } protected function getAllRecipients() { global $globals; - return "SELECT u.user_id, CONCAT(a.alias, '@{$globals->mail->domain}'), - u.prenom, IF(u.nom_usage='', u.nom, u.nom_usage), - FIND_IN_SET('femme', u.flags), - q.core_mail_fmt AS pref, ni.hash AS hash + return "SELECT a.uid FROM {$this->_subscriptionTable} AS ni - INNER JOIN auth_user_md5 AS u USING(user_id) - INNER JOIN auth_user_quick AS q ON(q.user_id = u.user_id) - INNER JOIN aliases AS a ON(u.user_id=a.id AND FIND_IN_SET('bestalias',a.flags)) - LEFT JOIN emails AS e ON(e.uid=u.user_id AND e.flags='active') + INNER JOIN accounts AS a ON (ni.uid = a.uid) + LEFT JOIN email_options AS eo ON (eo.uid = a.uid) + LEFT JOIN emails AS e ON (e.uid = a.uid AND e.flags='active') WHERE ni.last < {?} AND ({$this->subscriptionWhere()}) AND - (e.email IS NOT NULL OR FIND_IN_SET('googleapps', u.mail_storage)) - GROUP BY u.user_id"; + (e.email IS NOT NULL OR FIND_IN_SET('googleapps', eo.storage)) + GROUP BY a.uid"; } public function sendToAll() { $this->setSent(); - $query = $this->getAllRecipients() . " LIMIT {?}"; + $query = XDB::format($this->getAllRecipients(), $this->_id) . ' LIMIT 60'; + $emailsCount = 0; + while (true) { - $res = XDB::iterRow($query, $this->_id, 60); - if (!$res->total()) { - return; + $users = User::getBulkUsersWithUIDs(XDB::fetchColumn($query)); + if (count($users) == 0) { + return $emailsCount; } - $sent = array(); - while (list($uid, $bestalias, $prenom, $nom, $sexe, $fmt, $hash) = $res->next()) { - $sent[] = "(user_id='$uid'" . (!$uid ? " AND email='$bestalias')": ')'); - $this->sendTo($prenom, $nom, $bestalias, $sexe, $fmt=='html', $hash); + foreach ($users as $user) { + $sent[] = XDB::format('uid = {?}', $user->id()); + $this->sendTo($user, $hash); + ++$emailsCount; } XDB::execute("UPDATE {$this->_subscriptionTable} SET last = {?} @@ -230,6 +222,7 @@ abstract class MassMailer sleep(60); } + return $emailsCount; } abstract protected function assignData(&$smarty);