X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=include%2Fmarketing.inc.php;h=f6dd15def134c73ca8ca9ddf08e5fa202057507c;hb=59887c4a8a1f014c1f4107c43deda0d1be994f5d;hp=d615c926fbabb9f56e41515b9293c145bc49f52b;hpb=5ddeb07cc787dd1dc3630a31f1528f5cc7c4d9b9;p=platal.git diff --git a/include/marketing.inc.php b/include/marketing.inc.php index d615c92..f6dd15d 100644 --- a/include/marketing.inc.php +++ b/include/marketing.inc.php @@ -1,6 +1,6 @@ array(class name, require data) + 'annuaire' => array('AnnuaireMarketing', false), + 'groupe' => array('GroupMarketing', true), + 'liste' => array('ListMarketing', true), + ); -// {{{ function mark_from_mail + private $engine; + public $sender_mail; + public $user; -function mark_from_mail($uid, $email) { - $res = XDB::query( - "SELECT u.nom, u.prenom, a.alias - FROM register_marketing AS r - INNER JOIN auth_user_md5 AS u ON (r.sender = u.user_id) - INNER JOIN aliases AS a ON (a.id = r.sender AND a.type='a_vie') - WHERE r.uid = {?} AND r.email = {?}", - $uid, $email); - $sender = $res->fetchOneAssoc(); - return "\"".$sender['prenom']." ".$sender['nom']."\" <".$sender['alias']."@polytechnique.org>"; -} + private $type; + private $data; + private $from; + private $sender; + + private $hash = ''; + + public function __construct($uid, $email, $type, $data, $from, $sender = null) + { + $this->user = $this->getUser($uid, $email); + $this->sender_mail = $this->getFrom($from, $sender); + $this->engine =& $this->getEngine($type, $data, $from == 'user' ? $sender : null); + + $this->type = $type; + $this->data = $data; + $this->from = $from; + $this->sender = $sender; + } + + private function getUser($uid, $email) + { + require_once("xorg.misc.inc.php"); + $res = XDB::query("SELECT FIND_IN_SET('femme', flags) AS sexe, nom, prenom, promo + FROM auth_user_md5 + WHERE user_id = {?}", $uid); + if ($res->numRows() == 0) { + return null; + } + $user = $res->fetchOneAssoc(); + $user['id'] = $uid; + $user['forlife'] = make_forlife($user['prenom'], $user['nom'], $user['promo']); + $user['mail'] = $email; + $user['to'] = '"' . $user['prenom'] . ' ' . $user['nom'] . '" <' . $email . '>'; + return $user; + } + + private function getFrom($from, $sender) + { + global $globals; + + if ($from == 'staff') { + return '"L\'équipe de Polytechnique.org" mail->domain . '>'; + } else { + $res = XDB::query("SELECT u.nom, u.prenom, a.alias + FROM auth_user_md5 AS u + INNER JOIN aliases AS a ON (a.id = u.user_id AND FIND_IN_SET('bestalias', a.flags)) + WHERE u.user_id = {?}", $sender); + if (!$res->numRows()) { + return '"L\'équipe de Polytechnique.org" mail->domain . '>'; + } + $sender = $res->fetchOneAssoc(); + return '"' . $sender['prenom'] . ' ' . $sender['nom'] . '" <' . $sender['alias'] . '@' . $globals->mail->domain . '>'; + } + } + + private function &getEngine($type, $data, $from) + { + $class = $type . 'Marketing'; + if (!class_exists($class, false)) { + $class= 'DefaultMarketing'; + } + $engine = new $class($data, $from); + if (!$engine instanceof MarketingEngine) { + $engine = null; + } + return $engine; + } + + public function getTitle() + { + return $this->engine->getTitle(); + } + + public function getText() + { + return $this->engine->getText($this->user); + } + + public function send($title = null, $text = null) + { + $this->hash = rand_url_id(12); + if (!$title) { + $title = $this->engine->getTitle(); + } + if (!$text) { + $text = $this->engine->getText($this->user); + } + $sender = substr($this->sender_mail, 1, strpos($this->sender_mail, '"', 2)-1); + $text = str_replace(array("%%hash%%", "%%sender%%"), + array($this->hash, $this->sender_mail), + $text); + $mailer = new PlMailer(); + $mailer->setFrom($this->sender_mail); + $mailer->addTo($this->user['mail']); + $mailer->setSubject($title); + $mailer->setTxtBody($text); + $mailer->send(); + $this->incr(); + } + + public function add($valid = true) + { + XDB::execute('INSERT IGNORE INTO register_marketing + (uid, sender, email, date, last, nb, type, hash, message, message_data) + VALUES ({?}, {?}, {?}, NOW(), 0, 0, {?}, {?}, {?}, {?})', + $this->user['id'], $this->sender, $this->user['mail'], $this->from, $this->hash, + $this->type, $this->data); + $this->engine->process($this->user); + if ($valid) { + require_once 'validations.inc.php'; + $valid = new MarkReq($this->sender, $this->user['id'], $this->user['mail'], + $this->from == 'user', $this->type, $this->data); + $valid->submit(); + } + return true; + } + + private function incr() + { + XDB::execute('UPDATE register_marketing + SET nb=nb+1, hash={?}, last=NOW() + WHERE uid={?} AND email={?}', + $this->hash, $this->user['id'], $this->user['mail']); + } + + static public function getEngineList($exclude_data = true) + { + $array = array(); + foreach (Marketing::$engines as $e => $d) { + if (!$d[1] || !$exclude_data) { + $array[] = $e; + } + } + return $array; + } + + static public function get($uid, $email, $recentOnly = false) + { + $res = XDB::query("SELECT uid, email, message, message_data, type, sender + FROM register_marketing + WHERE uid = {?} + AND email = {?}".( + $recentOnly ? ' AND DATEDIFF(NOW(), last) < 30' : ''), $uid, $email); + + if ($res->numRows() == 0) { + return null; + } + list ($uid, $email, $type, $data, $from, $sender) = $res->fetchOneRow(); + return new Marketing($uid, $email, $type, $data, $from, $sender); + } + + static public function clear($uid, $email = null) + { + if (!$email) { + XDB::execute("DELETE FROM register_marketing WHERE uid = {?}", $uid); + } else { + XDB::execute("DELETE FROM register_marketing WHERE uid = {?} AND email = {?}", $uid, $email); + } + } -// }}} -// {{{ function mark_text_mail + static public function relance($uid, $nbx = -1) + { + global $globals; -function mark_text_mail($uid, $email) + if ($nbx < 0) { + $res = XDB::query("SELECT COUNT(*) FROM auth_user_md5 WHERE deces=0"); + $nbx = $res->fetchOneCell(); + } + + $res = XDB::query("SELECT r.date, u.promo, u.nom, u.prenom, r.email, r.bestalias + FROM register_pending AS r + INNER JOIN auth_user_md5 AS u ON u.user_id = r.uid + WHERE hash!='INSCRIT' AND uid={?} AND TO_DAYS(relance) < TO_DAYS(NOW())", $uid); + if (!list($date, $promo, $nom, $prenom, $email, $alias) = $res->fetchOneRow()) { + return false; + } + + require_once('secure_hash.inc.php'); + $hash = rand_url_id(12); + $pass = rand_pass(); + $pass_encrypted = hash_encrypt($pass); + $fdate = strftime('%d %B %Y', strtotime($date)); + + $mymail = new PlMailer('marketing/relance.mail.tpl'); + $mymail->assign('nbdix', $nbx); + $mymail->assign('fdate', $fdate); + $mymail->assign('lusername', $alias); + $mymail->assign('nveau_pass', $pass); + $mymail->assign('baseurl', $globals->baseurl); + $mymail->assign('lins_id', $hash); + $mymail->assign('lemail', $email); + $mymail->assign('subj', $alias.'@'.$globals->mail->domain); + $mymail->send(); + XDB::execute('UPDATE register_pending + SET hash={?}, password={?}, relance=NOW() + WHERE uid={?}', $hash, $pass_encrypted, $uid); + return "$prenom $nom ($promo)"; + } +} + +interface MarketingEngine { - global $globals; - $title = "Annuaire en ligne des Polytechniciens"; - - $res = XDB::query("SELECT COUNT(*) FROM auth_user_md5 WHERE perms IN ('admin', 'user') and deces = 0"); - $num_users = $res->fetchOneCell(); - - $res = XDB::query("SELECT flags, nom, prenom, promo FROM auth_user_md5 WHERE user_id = {?}", $uid); - $u = $res->fetchOneAssoc(); - - $mailorg = make_forlife($u['prenom'],$u['nom'],$u['promo']); - - $to = "\"".$u['prenom']." ".$u['nom']."\" <".$email.">"; - - $titre = "Annuaire en ligne des Polytechniciens"; - $text = " ".($u['flags']?"Chère":"Cher")." camarade,\n\n"; - $text .= " Ta fiche n'est pas à jour dans l'annuaire des Polytechniciens sur Internet. Pour la mettre à jour, il te suffit de visiter cette page ou de copier cette adresse dans la barre de ton navigateur :\n\n"; - $text .= "==========================================================\n"; - $text .= $globals->baseurl."/register/%%hash%%\n"; - $text .= "==========================================================\n\n"; - $text .= "Il ne te faut que 5 minutes sur http://www.polytechnique.org/ pour rejoindre les $num_users camarades branchés grâce au système de reroutage de l'X et qui permet de joindre un camarade en connaissant seulement son nom et son prénom... et de bénéficier pour la vie d'une adresse prestigieuse $mailorg@polytechnique.org et son alias discret $mailorg@m4x.org (m4x = mail for X).\n\n"; - $text .= "Pas de nouvelle boîte aux lettres à relever, il suffit de la rerouter vers ton adresse personnelle et/ou professionnelle que tu indiques et que tu peux changer tous les jours si tu veux sans imposer à tes correspondants de modifier leur carnet d'adresses...\n\n"; - $text .= "De plus, le site web offre les services d'annuaire (recherche multi-critères), de forums, de mailing-lists. Ce portail est géré par une dizaine de jeunes camarades, avec le soutien et les conseils de nombreux X de toutes promotions, incluant notamment des camarades de la Kès des élèves de l'X et d'autres de l'AX. Les serveurs sont hébergés au sein même de l'Ecole polytechnique, sur une connexion rapide, et les services évoluent en fonction des besoins exprimés par la communauté sur Internet.\n\n"; - $text .="N'hésite pas à transmettre ce message à tes camarades ou à nous écrire, nous proposer toute amélioration ou suggestion pour les versions prochaines du site.\n\n"; - $text .= "A bientôt sur http://www.polytechnique.org !\n"; - $text .= "Bien à toi,\n"; - $text .= "%%sender%%\n\n"; - $text .= "--\n"; - $text .= "Polytechnique.org\n"; - $text .= "\"Le portail des élèves & anciens élèves de l'X\"\n"; - $text .= "http://www.polytechnique.org/\n"; - $text .= "http://www.polytechnique.net/\n"; - return array($to, $title, $text); + public function __construct($data, $from); + public function getTitle(); + public function getText(array $user); + public function process(array $user); } -// }}} -// {{{ function mark_send_mail() -function mark_send_mail($uid, $email, $perso, $to='', $title='', $text='') +// +class AnnuaireMarketing implements MarketingEngine { - $hash = rand_url_id(12); - XDB::execute('UPDATE register_marketing SET nb=nb+1,hash={?},last=NOW() WHERE uid={?} AND email={?}', $hash, $uid, $email); - - if ($to == '') - list($to, $title, $text) = mark_text_mail($uid, $email); - - if ($perso == 'staff') - $from = "\"Equipe Polytechnique.org\" "; - else - $from = mark_from_mail($uid, $email); - - $sender = substr($from, 1, strpos($from, '"', 2)-1); - $text = str_replace(array("%%hash%%", "%%sender%%"), array($hash, $sender), $text); - - $mailer = new PlMailer(); - $mailer->setFrom($from); - $mailer->addTo($to); - $mailer->setSubject($title); - $mailer->setTxtBody(wordwrap($text, 80)); - $mailer->send(); + protected $titre; + protected $intro; + protected $signature; + + public function __construct($data, $from) + { + $this->titre = "Rejoins la communauté polytechnicienne sur Internet"; + $this->intro = " Tu n'as pas de fiche dans l'annuaire des polytechniciens sur Internet. " + . "Pour y figurer, il te suffit de visiter cette page ou de copier cette adresse " + . "dans la barre de ton navigateur :"; + if ($from === null) { + $this->signature = "L'équipe de Polytechnique.org,\n" + . "Le portail des élèves & anciens élèves de l'École polytechnique"; + } else { + $this->signature = "%%sender%%"; + } + } + + public function getTitle() + { + return $this->titre; + } + + private function getIntro() + { + return $this->intro; + } + + public function getSignature() + { + return $this->signature; + } + + protected function prepareText(PlatalPage &$page, array $user) + { + $page->assign('intro', $this->getIntro()); + $page->assign('u', $user); + $page->assign('sign', $this->getSignature()); + $res = XDB::query("SELECT COUNT(*) FROM auth_user_md5 WHERE perms IN ('user', 'admin') AND deces = 0"); + $page->assign('num_users', $res->fetchOneCell()); + } + + public function getText(array $user) + { + $page = new XorgPage('marketing/marketing.mail.tpl', NO_SKIN); + $this->prepareText($page, $user); + return $page->raw(); + } + + public function process(array $user) + { + } } -// }}} -// {{{ function relance +class ListMarketing extends AnnuaireMarketing +{ + private $name; + private $domain; + public function __construct($data, $from) + { + list($this->name, $this->domain) = explode('@', $data); + $res = XDB::query("SELECT prenom, IF (nom_usage != '', nom_usage, nom) + FROM auth_user_md5 + WHERE user_id = {?} AND user_id != 0", $from ? $from : 0); + if ($res->numRows()) { + list($prenom, $nom) = $res->fetchOneRow(); + $from = "$prenom $nom"; + } else { + $from = "Je"; + } + $this->titre = "Un camarade solicite ton inscription à $data"; + $this->intro = "Polytechnique.org, l'annuaire des polytechniciens sur internet, " + . "fournit de nombreux services aux groupes X, ainsi que des listes " + . "de diffusion pour les X en faisant la demande.\n\n" + . "$from solicite ton inscription à la liste <$data>. " + . "Cependant, seuls les X inscrits sur Polytechnique.org peuvent " + . "profiter de l'ensemble de nos services, c'est pourquoi nous te " + . "proposons auparavant de t'inscrire sur notre site. Pour cela, il " + . "te suffit de visiter cette page ou de copier cette adresse dans " + . "la barre de ton navigateur :"; + } -function relance($uid, $nbx = -1) + public function process(array $user) + { + return XDB::execute("REPLACE INTO register_subs (uid, type, sub, domain) + VALUES ({?}, 'list', {?}, {?})", + $user['id'], $this->name, $this->domain); + } +} + +class GroupMarketing extends AnnuaireMarketing { - global $globals; - - if ($nbx < 0) { - $res = XDB::query("SELECT COUNT(*) FROM auth_user_md5 WHERE deces=0"); - $nbx = $res->fetchOneCell(); - } - - $res = XDB::query( - "SELECT r.date, u.promo, u.nom, u.prenom, r.email, r.bestalias - FROM register_pending AS r - INNER JOIN auth_user_md5 AS u ON u.user_id = r.uid - WHERE hash!='INSCRIT' AND uid={?} AND TO_DAYS(relance) < TO_DAYS(NOW())", $uid); - if (!list($date, $promo, $nom, $prenom, $email, $alias) = $res->fetchOneRow()) { - return false; - } - - require_once('secure_hash.inc.php'); - - $hash = rand_url_id(12); - $pass = rand_pass(); - $pass_encrypted = hash_encrypt($pass); - $fdate = strftime('%d %B %Y', strtotime($date)); - - $mymail = new PlMailer('marketing/mail.relance.tpl'); - $mymail->assign('nbdix', $nbx); - $mymail->assign('fdate', $fdate); - $mymail->assign('lusername', $alias); - $mymail->assign('nveau_pass', $pass); - $mymail->assign('baseurl', $globals->baseurl); - $mymail->assign('lins_id', $hash); - $mymail->assign('lemail', $email); - $mymail->assign('subj', $alias.'@'.$globals->mail->domain); - $mymail->send(); - XDB::execute('UPDATE register_pending SET hash={?}, password={?}, relance=NOW() WHERE uid={?}', $hash, $pass_encrypted, $uid); - - return "$prenom $nom ($promo)"; + private $group; + public function __construct($data, $from) + { + $this->group = $data; + $res = XDB::query("SELECT prenom, IF (nom_usage != '', nom_usage, nom) + FROM auth_user_md5 + WHERE user_id = {?} AND user_id != 0", $from ? $from : 0); + if ($res->numRows()) { + list($prenom, $nom) = $res->fetchOneRow(); + $from = "$prenom $nom vient"; + } else { + $from = "Je viens"; + } + $this->titre = "Profite de ton inscription au groupe \"$data\" pour découvrir Polytechnique.org"; + $this->intro = "Polytechnique.org, l'annuaire des polytechniciens sur internet, fournit " + . "de nombreux services aux groupes X ( listes de diffusion, paiement en " + . "ligne, sites internet...), en particulier pour le groupe \"$data\"\n\n" + . "$from de t'inscrire dans l'annuaire du groupe \"$data\". " + . "Cependant, seuls les X inscrits sur Polytechnique.org peuvent profiter " + . "de l'ensemble de nos services, c'est pourquoi nous te proposons de " + . "t'inscrire sur notre site . Pour cela, il te suffit de visiter cette page " + . "ou de copier cette adresse dans la barre de ton navigateur :"; + } + + public function process(array $user) + { + return XDB::execute("REPLACE INTO register_subs (uid, type, sub, domain) + VALUES ({?}, 'group', {?}, '')", + $user['id'], $this->group); + } } -// }}} +/// Make AnnuaireMarketing to be the default message +class DefaultMarketing extends AnnuaireMarketing +{ +} -// vim:set et sw=4 sts=4 sws=4: +// vim:set et sw=4 sts=4 sws=4 enc=utf-8: ?>