X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fxnetgrp.php;h=47f4a8da0e845409be2c7bf8a477a4fb4b6a4972;hb=8af607ead9a244d0e83c9312c2c8a946c696d0b6;hp=de4f48cc602b80faae4966b8af020fab7e0dc616;hpb=eae1c10a6f7ce483f6bbc107e68189bcddfcafe9;p=platal.git diff --git a/modules/xnetgrp.php b/modules/xnetgrp.php index de4f48c..47f4a8d 100644 --- a/modules/xnetgrp.php +++ b/modules/xnetgrp.php @@ -29,33 +29,34 @@ class XnetGrpModule extends PLModule '%grp/asso.php' => $this->make_hook('index', AUTH_PUBLIC), '%grp/logo' => $this->make_hook('logo', AUTH_PUBLIC), '%grp/site' => $this->make_hook('site', AUTH_PUBLIC), - '%grp/edit' => $this->make_hook('edit', AUTH_MDP, 'groupadmin'), - '%grp/mail' => $this->make_hook('mail', AUTH_MDP, 'groupadmin'), - '%grp/forum' => $this->make_hook('forum', AUTH_MDP, 'groupmember'), - '%grp/annuaire' => $this->make_hook('annuaire', AUTH_MDP, 'groupannu'), - '%grp/annuaire/vcard' => $this->make_hook('vcard', AUTH_MDP, 'groupmember:groupannu'), - '%grp/annuaire/csv' => $this->make_hook('csv', AUTH_MDP, 'groupmember:groupannu'), - '%grp/directory/sync' => $this->make_hook('directory_sync', AUTH_MDP, 'groupadmin'), - '%grp/directory/unact' => $this->make_hook('non_active', AUTH_MDP, 'groupadmin'), - '%grp/trombi' => $this->make_hook('trombi', AUTH_MDP, 'groupannu'), - '%grp/geoloc' => $this->make_hook('geoloc', AUTH_MDP, 'groupannu'), - '%grp/subscribe' => $this->make_hook('subscribe', AUTH_MDP), - '%grp/subscribe/valid' => $this->make_hook('subscribe_valid', AUTH_MDP, 'groupadmin'), - '%grp/unsubscribe' => $this->make_hook('unsubscribe', AUTH_MDP, 'groupmember'), - - '%grp/change_rights' => $this->make_hook('change_rights', AUTH_MDP), - '%grp/admin/annuaire' => $this->make_hook('admin_annuaire', AUTH_MDP, 'groupadmin'), - '%grp/member' => $this->make_hook('admin_member', AUTH_MDP, 'groupadmin'), - '%grp/member/new' => $this->make_hook('admin_member_new', AUTH_MDP, 'groupadmin'), - '%grp/member/new/ajax' => $this->make_hook('admin_member_new_ajax', AUTH_MDP, 'user', NO_AUTH), - '%grp/member/del' => $this->make_hook('admin_member_del', AUTH_MDP, 'groupadmin'), - '%grp/member/suggest' => $this->make_hook('admin_member_suggest', AUTH_MDP, 'groupadmin'), + '%grp/edit' => $this->make_hook('edit', AUTH_PASSWD, 'groupadmin'), + '%grp/mail' => $this->make_hook('mail', AUTH_PASSWD, 'groupadmin'), + '%grp/forum' => $this->make_hook('forum', AUTH_PASSWD, 'groupmember'), + '%grp/former_users' => $this->make_hook('former_users', AUTH_PASSWD, 'admin'), + '%grp/annuaire' => $this->make_hook('annuaire', AUTH_PASSWD, 'groupannu'), + '%grp/annuaire/vcard' => $this->make_hook('vcard', AUTH_PASSWD, 'groupmember:groupannu'), + '%grp/annuaire/csv' => $this->make_hook('csv', AUTH_PASSWD, 'groupmember:groupannu'), + '%grp/directory/sync' => $this->make_hook('directory_sync', AUTH_PASSWD, 'groupadmin'), + '%grp/directory/unact' => $this->make_hook('non_active', AUTH_PASSWD, 'groupadmin'), + '%grp/trombi' => $this->make_hook('trombi', AUTH_PASSWD, 'groupannu'), + '%grp/geoloc' => $this->make_hook('geoloc', AUTH_PASSWD, 'groupannu'), + '%grp/subscribe' => $this->make_hook('subscribe', AUTH_PASSWD, 'groups'), + '%grp/subscribe/valid' => $this->make_hook('subscribe_valid', AUTH_PASSWD, 'groupadmin'), + '%grp/unsubscribe' => $this->make_hook('unsubscribe', AUTH_PASSWD, 'groupmember'), + + '%grp/change_rights' => $this->make_hook('change_rights', AUTH_PASSWD, 'groups'), + '%grp/admin/annuaire' => $this->make_hook('admin_annuaire', AUTH_PASSWD, 'groupadmin'), + '%grp/member' => $this->make_hook('admin_member', AUTH_PASSWD, 'groupadmin'), + '%grp/member/new' => $this->make_hook('admin_member_new', AUTH_PASSWD, 'groupadmin'), + '%grp/member/new/ajax' => $this->make_hook('admin_member_new_ajax', AUTH_PASSWD, 'groups', NO_AUTH), + '%grp/member/del' => $this->make_hook('admin_member_del', AUTH_PASSWD, 'groupadmin'), + '%grp/member/suggest' => $this->make_hook('admin_member_suggest', AUTH_PASSWD, 'groupadmin'), '%grp/rss' => $this->make_token_hook('rss', AUTH_PUBLIC), - '%grp/announce/new' => $this->make_hook('edit_announce', AUTH_MDP, 'groupadmin'), - '%grp/announce/edit' => $this->make_hook('edit_announce', AUTH_MDP, 'groupadmin'), + '%grp/announce/new' => $this->make_hook('edit_announce', AUTH_PASSWD, 'groupadmin'), + '%grp/announce/edit' => $this->make_hook('edit_announce', AUTH_PASSWD, 'groupadmin'), '%grp/announce/photo' => $this->make_hook('photo_announce', AUTH_PUBLIC), - '%grp/admin/announces' => $this->make_hook('admin_announce', AUTH_MDP, 'groupadmin'), + '%grp/admin/announces' => $this->make_hook('admin_announce', AUTH_PASSWD, 'groupadmin'), ); } @@ -119,6 +120,12 @@ class XnetGrpModule extends PLModule WHERE asso_id = {?} AND expiration >= CURRENT_DATE() AND FIND_IN_SET('public', flags)", $globals->asso('id')); + $payments = XDB::fetchAllAssoc("SELECT id, text + FROM payments + WHERE asso_id = {?} AND NOT FIND_IN_SET('old', flags) AND FIND_IN_SET('public', flags) + ORDER BY id DESC", + $globals->asso('id')); + $page->assign('payments', $payments); } if (may_update()) { $subs_valid = XDB::query("SELECT uid @@ -161,6 +168,15 @@ class XnetGrpModule extends PLModule { global $globals; $page->changeTpl('xnetgrp/edit.tpl'); + $error = false; + + if (S::admin()) { + $domains = XDB::iterator('SELECT * + FROM group_dom + ORDER BY nom'); + $page->assign('domains', $domains); + $page->assign('super', true); + } if (Post::has('submit')) { S::assert_xsrf_token(); @@ -176,17 +192,61 @@ class XnetGrpModule extends PLModule } else { $site = ""; } + + $notify_all = (Post::v('notify_all') ? true : false); + if (!$notify_all) { + $to_notify = array(); + $uf = New UserFilter(New UFC_Group($globals->asso('id'), true)); + $uids = $uf->getIds(); + foreach ($uids as $uid) { + if (Post::b('to_notify_' . $uid)) { + $to_notify[] = $uid; + } + } + if (count($to_notify) == 0) { + $notify_all = true; + $page->trigWarning("Aucun animateur n'ayant été selectionné pour recevoir les demandes d'inscriptions, tous le seront."); + } + } + $flags->addFlag('notify_all', $notify_all); + if (S::admin()) { $page->assign('super', true); if (Post::v('mail_domain') && (strstr(Post::v('mail_domain'), '.') === false)) { $page->trigError('Le domaine doit être un FQDN (aucune modification effectuée) !!!'); - return; + $error = true; } if (Post::t('nom') == '' || Post::t('diminutif') == '') { $page->trigError('Ni le nom ni le diminutif du groupe ne peuvent être vide.'); + $error = true; + } + if ($error) { + $page->assign('nom', Post::t('nom')); + $page->assign('diminutif', Post::t('diminutif')); + $page->assign('mail_domain', Post::t('mail_domain')); + $page->assign('cat', Post::v('cat')); + $page->assign('dom', Post::v('dom')); + $page->assign('ax', Post::v('ax')); + $page->assign('axDate', Post::t('axDate')); + $page->assign('site', $site); + $page->assign('resp', Post::t('resp')); + $page->assign('mail', Post::t('mail')); + $page->assign('phone', Post::t('phone')); + $page->assign('fax', Post::t('fax')); + $page->assign('address', Post::t('address')); + $page->assign('forum', Post::t('forum')); + $page->assign('inscriptible', Post::v('inscriptible')); + $page->assign('sub_url', Post::t('sub_url')); + $page->assign('unsub_url', Post::t('unsub_url')); + $page->assign('welcome_msg', Post::t('welcome_msg')); + $page->assign('pub', Post::v('pub')); + $page->assign('notif_unsub', Post::i('notif_unsub')); + $page->assign('descr', Post::t('descr')); + $page->assign('error', $error); return; } + $axDate = make_datetime(Post::v('axDate')); if (Post::t('axDate') != '') { $axDate = make_datetime(Post::v('axDate'))->format('Y-m-d'); @@ -258,16 +318,33 @@ class XnetGrpModule extends PLModule } } + XDB::execute("UPDATE group_members + SET flags = '' + WHERE asso_id = {?}", + $globals->asso('id')); + if (!$notify_all) { + XDB::execute("UPDATE group_members + SET flags = 'notify' + WHERE asso_id = {?} AND uid IN {?}", + $globals->asso('id'), $to_notify); + } + pl_redirect('../' . Post::v('diminutif', $globals->asso('diminutif')) . '/edit'); } - if (S::admin()) { - $dom = XDB::iterator('SELECT * - FROM group_dom - ORDER BY nom'); - $page->assign('dom', $dom); - $page->assign('super', true); - } + $uf = New UserFilter(New UFC_Group($globals->asso('id'), true, UFC_Group::NOTIFIED)); + $page->assign('notified', $uf->getUsers()); + $uf = New UserFilter(New UFC_Group($globals->asso('id'), true, UFC_Group::UNNOTIFIED)); + $page->assign('unnotified', $uf->getUsers()); + + $page->assign('error', $error); + $page->assign('cat', $globals->asso('cat')); + $page->assign('dom', $globals->asso('dom')); + $page->assign('ax', $globals->asso('ax')); + $page->assign('inscriptible', $globals->asso('inscriptible')); + $page->assign('pub', $globals->asso('pub')); + $page->assign('notif_unsub', $globals->asso('notif_unsub')); + $page->assign('notify_all', $globals->asso('notify_all')); } function handler_mail($page) @@ -333,11 +410,23 @@ class XnetGrpModule extends PLModule $view = new UserSet(new UFC_Group($globals->asso('id'), $admins)); $view->addMod('groupmember', 'Annuaire'); $view->addMod('trombi', 'Trombinoscope'); + $view->addMod('map', 'Planisphère'); $view->apply('annuaire', $page, $action); $page->assign('only_admin', $admins); $page->changeTpl('xnetgrp/annuaire.tpl'); } + function handler_former_users($page) + { + global $globals; + require_once 'userset.inc.php'; + + $view = new UserSet(new UFC_GroupFormerMember($globals->asso('id'))); + $view->addMod('groupmember', 'Anciens membres', true, array('noadmin' => true)); + $view->apply('former_users', $page); + $page->changeTpl('xnetgrp/former_users.tpl'); + } + function handler_trombi($page) { pl_redirect('annuaire/trombi'); @@ -362,10 +451,16 @@ class XnetGrpModule extends PLModule if (is_null($filename)) { $filename = $globals->asso('diminutif') . '.csv'; } - $users = $globals->asso()->getMembersFilter(null, new UFO_Name('directory_name'))->getUsers(); - pl_cached_content_headers('text/x-csv', 1); - $page->changeTpl('xnetgrp/annuaire-csv.tpl', NO_SKIN); - $page->assign('users', $users); + $users = $globals->asso()->getMembersFilter(null, new UFO_Name())->getUsers(); + pl_cached_content_headers('text/x-csv', 'iso-8859-1', 1); + + echo utf8_decode("Nom;Prénom;Sexe;Promotion;Commentaire\n"); + foreach ($users as $user) { + $line = $user->lastName() . ';' . $user->firstName() . ';' . ($user->isFemale() ? 'F' : 'M') + . ';' . $user->promo() . ';' . strtr($user->group_comm, ';', ','); + echo utf8_decode($line) . "\n"; + } + exit(); } function handler_directory_sync($page) @@ -380,8 +475,24 @@ class XnetGrpModule extends PLModule S::assert_xsrf_token(); $users = array_keys(Env::v('add_users')); + $former_users = XDB::fetchColumn('SELECT uid + FROM group_former_members + WHERE remember = TRUE AND uid IN {?}', + $users); + $new_users = array_diff($users, $former_users); + + foreach ($former_users as $uid) { + $user = User::getSilentWithUID($uid); + $page->trigWarning($user->fullName() . ' est un ancien membre du groupe qui ne souhaite pas y revenir.'); + } + if (count($former_users) > 1) { + $page->trigWarning('S\'ils souhaitent revenir dans le groupe, il faut qu\'ils en fassent la demande sur la page d\'accueil du groupe.'); + } elseif (count($former_users)) { + $page->trigWarning('S\'il souhaite revenir dans le groupe, il faut qu\'il en fasse la demande sur la page d\'accueil du groupe.'); + } + $data = array(); - foreach ($users as $uid) { + foreach ($new_users as $uid) { $data[] = XDB::format('({?}, {?})', $globals->asso('id'), $uid); } XDB::rawExecute('INSERT INTO group_members (asso_id, uid) @@ -530,9 +641,8 @@ class XnetGrpModule extends PLModule { global $globals; $this->removeSubscriptionRequest($user->id()); - XDB::execute("INSERT IGNORE INTO group_members (asso_id, uid) - VALUES ({?}, {?})", - $globals->asso('id'), $user->id()); + Group::subscribe($globals->asso('id'), $user->id()); + if (XDB::affectedRows() == 1) { $mailer = new PlMailer(); $mailer->addTo($user->forlifeEmail()); @@ -630,8 +740,10 @@ class XnetGrpModule extends PLModule XDB::execute("INSERT INTO group_member_sub_requests (asso_id, uid, ts, reason) VALUES ({?}, {?}, NOW(), {?})", $globals->asso('id'), S::i('uid'), Post::v('message')); - $uf = New UserFilter(New UFC_Group($globals->asso('id'), true)); - $admins = $uf->iterUsers(); + XDB::execute('DELETE FROM group_former_members + WHERE uid = {?} AND asso_id = {?}', + S::i('uid'), $globals->asso('id')); + $admins = $globals->asso()->iterToNotify(); $admin = $admins->next(); $to = $admin->bestEmail(); while ($admin = $admins->next()) { @@ -641,7 +753,7 @@ class XnetGrpModule extends PLModule $append = "\n" . "-- \n" . "Ce message a été envoyé suite à la demande d'inscription de\n" - . S::user()->fullName() . ' (X' . S::v('promo') . ")\n" + . S::user()->fullName(true) . "\n" . "Via le site www.polytechnique.net. Tu peux choisir de valider ou\n" . "de refuser sa demande d'inscription depuis la page :\n" . "http://www.polytechnique.net/" . $globals->asso("diminutif") . "/subscribe/" . S::user()->login() . "\n" @@ -780,20 +892,10 @@ class XnetGrpModule extends PLModule // + (the data) => %2B (in the url) => + (first decoding) => ' ' (second decoding) // Since there can be no spaces in emails, we can fix this with : $email = str_replace(' ', '+', $email); + $is_valid_email = isvalid_email($email); - // Finds or creates account: first cases are for users with an account. - if (!User::isForeignEmailAddress($email)) { - // Standard account - $user = User::getSilent($email); - } else if (!isvalid_email($email)) { - // email might not be a regular email but an alias or a hruid - $user = User::getSilent($email); - if (!$user) { - // need a valid email address - $page->trigError('« ' . $email . ' Â» n\'est pas une adresse email valide.'); - return; - } - } else if (Env::v('x') && Env::i('userid')) { + // X not registered to main site. + if (Env::v('x') && Env::i('userid') && $is_valid_email) { $user = User::getSilentWithUID(Env::i('userid')); if (!$user) { $page->trigError('Utilisateur invalide.'); @@ -818,46 +920,71 @@ class XnetGrpModule extends PLModule } } } else { - // User is of type xnet. There are 3 possible cases: - // * the email is not known yet: we create a new account and - // propose to send an email to the user so he can activate - // his account, - // * the email is known but the user was not contacted in order to - // activate yet: we propose to send an email to the user so he - // can activate his account, - // * the email is known and the user was already contacted or has - // an active account: nothing to be done. - list($mbox, $domain) = explode('@', strtolower($email)); - $hruid = User::makeHrid($mbox, $domain, 'ext'); - // User might already have an account (in another group for example). - $user = User::getSilent($hruid); - - // If the user has no account yet, creates new account: build names from email address. - if (empty($user)) { - $parts = explode('.', $mbox); - if (count($parts) == 1) { - $lastname = $display_name = $full_name = $directory_name = ucfirst($mbox); - $firstname = ''; - } else { - $firstname = ucfirst($parts[0]); - $lastname = ucwords(implode(' ', array_slice($parts, 1))); - $display_name = $firstname; - $full_name = "$firstname $lastname"; - $directory_name = strtoupper($lastname) . " " . $firstname; - } - XDB::execute('INSERT INTO accounts (hruid, display_name, full_name, directory_name, firstname, lastname, email, type, state) - VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, \'xnet\', \'disabled\')', - $hruid, $display_name, $full_name, $directory_name, $firstname, $lastname, $email); - $user = User::getSilent($hruid); + $user = User::getSilent($email); + + // Wrong email and no user: failure. + if (is_null($user) && (!$is_valid_email || !User::isForeignEmailAddress($email))) { + $page->trigError('« ' . $email . ' Â» n\'est pas une adresse email valide.'); + return; } - $suggest_account_activation = $this->suggest($user); + // Deals with xnet accounts. + if (is_null($user) || $user->type == 'xnet') { + // User is of type xnet. There are 3 possible cases: + // * the email is not known yet: we create a new account and + // propose to send an email to the user so he can activate + // his account, + // * the email is known but the user was not contacted in order to + // activate yet: we propose to send an email to the user so he + // can activate his account, + // * the email is known and the user was already contacted or has + // an active account: nothing to be done. + list($mbox, $domain) = explode('@', strtolower($email)); + $hruid = User::makeHrid($mbox, $domain, 'ext'); + // User might already have an account (in another group for example). + $user = User::getSilent($hruid); + + // If the user has no account yet, creates new account: build names from email address. + if (empty($user)) { + $parts = explode('.', $mbox); + if (count($parts) == 1) { + $lastname = $display_name = $full_name = $directory_name = ucfirst($mbox); + $firstname = ''; + } else { + $firstname = ucfirst($parts[0]); + $lastname = ucwords(implode(' ', array_slice($parts, 1))); + $display_name = $firstname; + $full_name = "$firstname $lastname"; + $directory_name = strtoupper($lastname) . " " . $firstname; + } + XDB::execute('INSERT INTO accounts (hruid, display_name, full_name, directory_name, firstname, lastname, email, type, state) + VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, \'xnet\', \'disabled\')', + $hruid, $display_name, $full_name, $directory_name, $firstname, $lastname, $email); + $user = User::getSilent($hruid); + } + + $suggest_account_activation = $this->suggest($user); + } } if ($user) { - XDB::execute('INSERT IGNORE INTO group_members (uid, asso_id) - VALUES ({?}, {?})', - $user->id(), $globals->asso('id')); + // First check if the user used to be in this group. + XDB::rawExecute('DELETE FROM group_former_members + WHERE remember AND DATE_SUB(NOW(), INTERVAL 1 YEAR) > unsubsciption_date'); + $former_member = XDB::fetchOneCell('SELECT remember + FROM group_former_members + WHERE uid = {?} AND asso_id = {?}', + $user->id(), $globals->asso('id')); + if ($former_member === 1) { + $page->trigError($user->fullName() . ' est un ancien membre du groupe qui ne souhaite pas y revenir. S\'il souhaite revenir dans le groupe, il faut qu\'il en fasse la demande sur la page d\'accueil du groupe.'); + return; + } elseif (!is_null($former_member) && Post::i('force_continue') == 0) { + $page->trigWarning($user->fullName() . ' est un ancien membre du groupe qui s\'est récemment désinscrit. Malgré cela, si tu penses qu\'il souhaite revenir, cliquer sur « Ajouter » l\'ajoutera bien au groupe cette fois.'); + $page->assign('force_continue', 1); + return; + } + + Group::subscribe($globals->asso('id'), $user->id()); $this->removeSubscriptionRequest($user->id()); if ($suggest_account_activation) { pl_redirect('member/suggest/' . $user->login() . '/' . $email . '/' . $globals->asso('nom')); @@ -898,11 +1025,10 @@ class XnetGrpModule extends PLModule if (Post::has('suggest')) { if (Post::t('suggest') == 'yes') { $user = S::user(); - $group = Platal::globals()->asso('nom'); - $request = new AccountReq($user, $hruid, $email, $group); + $request = new AccountReq($user, $hruid, $email, Platal::globals()->asso('nom')); $request->submit(); $page->trigSuccessRedirect('Un email va bien être envoyé à ' . $email . ' pour l\'activation de son compte.', - $group . '/member/' . $hruid); + Platal::globals()->asso('diminutif') . '/member/' . $hruid); } else { pl_redirect('member/' . $hruid); } @@ -926,10 +1052,10 @@ class XnetGrpModule extends PLModule list($lastname, $firstname) = str_replace(array('-', ' ', "'"), '%', array(Env::t('nom'), Env::t('prenom'))); $cond = new PFC_And(new PFC_Not(new UFC_Registered())); if (!empty($lastname)) { - $cond->addChild(new UFC_Name(Profile::LASTNAME, $lastname, UFC_Name::CONTAINS)); + $cond->addChild(new UFC_NameTokens($lastname, array(), false, false, Profile::LASTNAME)); } if (!empty($firstname)) { - $cond->addChild(new UFC_Name(Profile::FIRSTNAME, $firstname, UFC_Name::CONTAINS)); + $cond->addChild(new UFC_NameTokens($firstname, array(), false, false, Profile::FIRSTNAME)); } if (Env::t('promo')) { $cond->addChild(new UFC_Promo('=', UserFilter::DISPLAY, Env::t('promo'))); @@ -944,16 +1070,14 @@ class XnetGrpModule extends PLModule $page->assign('users', $users); } - function unsubscribe(PlUser $user) + function unsubscribe(PlUser $user, $remember = false) { global $globals; - XDB::execute("DELETE FROM group_members - WHERE uid = {?} AND asso_id = {?}", - $user->id(), $globals->asso('id')); + Group::unsubscribe($globals->asso('id'), $user->id(), $remember); if ($globals->asso('notif_unsub')) { $mailer = new PlMailer('xnetgrp/unsubscription-notif.mail.tpl'); - $admins = $globals->asso()->iterAdmins(); + $admins = $globals->asso()->iterToNotify(); while ($admin = $admins->next()) { $mailer->addTo($admin); } @@ -1016,7 +1140,7 @@ class XnetGrpModule extends PLModule $hasSingleGroup = ($user->groupCount() == 1); - if ($this->unsubscribe($user)) { + if ($this->unsubscribe($user, Post::b('remember'))) { $page->trigSuccess('Tu as été désinscrit du groupe avec succès.'); } else { $page->trigWarning('Tu as été désinscrit du groupe, mais des erreurs se sont produites lors des désinscriptions des alias et des listes de diffusion.'); @@ -1122,8 +1246,6 @@ class XnetGrpModule extends PLModule } // Update user info - $email_changed = (!$user->profile() && strtolower($user->forlifeEmail()) != strtolower(Post::v('email'))); - $from_email = $user->forlifeEmail(); if ($user->type == 'virtual' || ($user->type == 'xnet' && !$user->perms)) { $lastname = Post::s('lastname'); if (Post::s('type') != 'virtual') { @@ -1137,30 +1259,51 @@ class XnetGrpModule extends PLModule } XDB::query('UPDATE accounts SET full_name = {?}, directory_name = {?}, display_name = {?}, - firstname = {?}, lastname = {?}, sex = {?}, email = {?}, type = {?} + firstname = {?}, lastname = {?}, sex = {?}, type = {?} WHERE uid = {?}', $full_name, $directory_name, Post::t('display_name'), $firstname, $lastname, - (Post::t('sex') == 'male') ? 'male' : 'female', Post::t('email'), + (Post::t('sex') == 'male') ? 'male' : 'female', (Post::t('type') == 'xnet') ? 'xnet' : 'virtual', $user->id()); - } else if (!$user->perms) { + } + + // Updates email. + $new_email = strtolower(Post::t('email')); + if (!$user->perms && require_email_update($user, $new_email)) { XDB::query('UPDATE accounts SET email = {?} WHERE uid = {?}', - Post::t('email'), $user->id()); - } - if (require_email_update($user, Post::t('email'))) { + $new_email, $user->id()); $listClient = new MMList(S::user()); - $listClient->change_user_email($user->forlifeEmail(), Post::t('email')); - update_alias_user($user->forlifeEmail(), Post::t('email')); + $listClient->change_user_email($user->forlifeEmail(), $new_email); + update_alias_user($user->forlifeEmail(), $new_email); } if (XDB::affectedRows()) { $page->trigSuccess('Données de l\'utilisateur mises à jour.'); } - if (($user->type == 'xnet' && !$user->perms) && Post::b('suggest')) { - $request = new AccountReq(S::user(), $user->hruid, Post::t('email'), $globals->asso('nom')); - $request->submit(); - $page->trigSuccess('Le compte va bientôt être activé.'); + if (($user->type == 'xnet' && !$user->perms)) { + if (Post::b('suggest')) { + $request = new AccountReq(S::user(), $user->hruid, Post::t('email'), $globals->asso('nom')); + $request->submit(); + $page->trigSuccess('Le compte va bientôt être activé.'); + } + if (Post::b('again')) { + $data = XDB::fetchOneAssoc('SELECT hash, group_name, sender_name, email + FROM register_pending_xnet + WHERE uid = {?}', + $user->id()); + + $mailer = new PlMailer('xnet/account.mail.tpl'); + $mailer->addCc('validation+xnet_account@polytechnique.org'); + $mailer->setTo($data['email']); + $mailer->assign('hash', $data['hash']); + $mailer->assign('email', $data['email']); + $mailer->assign('group', $data['group_name']); + $mailer->assign('sender_name', $data['sender_name']); + $mailer->assign('again', true); + $mailer->send(); + $page->trigSuccess('Relance effectuée avec succès.'); + } } // Update group params for user @@ -1193,10 +1336,6 @@ class XnetGrpModule extends PLModule foreach (Env::v('ml1', array()) as $ml => $state) { $ask = empty($_REQUEST['ml2'][$ml]) ? 0 : 2; if ($ask == $state) { - if ($state && $email_changed) { - $mmlist->replace_email($ml, $from_email, $user->forlifeEmail()); - $page->trigSuccess("L'abonnement de {$user->fullName()} à $ml@ a été mis à jour."); - } continue; } if ($state == '1') { @@ -1207,11 +1346,7 @@ class XnetGrpModule extends PLModule $mmlist->mass_subscribe($ml, Array($user->forlifeEmail())); $page->trigSuccess("{$user->fullName()} a été abonné à $ml@."); } else { - if ($email_changed) { - $mmlist->mass_unsubscribe($ml, Array($from_email)); - } else { - $mmlist->mass_unsubscribe($ml, Array($user->forlifeEmail())); - } + $mmlist->mass_unsubscribe($ml, Array($user->forlifeEmail())); $page->trigSuccess("{$user->fullName()} a été désabonné de $ml@."); } } @@ -1221,12 +1356,10 @@ class XnetGrpModule extends PLModule require_once 'emails.inc.php'; $ask = !empty($_REQUEST['ml4'][$ml]); list($local_part, ) = explode('@', $ml); - if($state == $ask) { - if ($state && $email_changed) { - update_list_alias($user->id(), $from_email, $local_part, $globals->asso('mail_domain')); - $page->trigSuccess("L'abonnement de {$user->fullName()} à $ml a été mis à jour."); - } - } else if($ask) { + if ($ask == $state) { + continue; + } + if ($ask) { add_to_list_alias($user->id(), $local_part, $globals->asso('mail_domain')); $page->trigSuccess("{$user->fullName()} a été abonné à $ml."); } else { @@ -1234,16 +1367,37 @@ class XnetGrpModule extends PLModule $page->trigSuccess("{$user->fullName()} a été désabonné de $ml."); } } + + if ($globals->asso('has_nl')) { + $nl = NewsLetter::forGroup($globals->asso('shortname')); + // Updates group's newsletter subscription. + if (Post::i('newsletter') == 1) { + $nl->subscribe($user); + } else { + $nl->unsubscribe(null, $user->id()); + } + } } $res = XDB::rawFetchAllAssoc('SHOW COLUMNS FROM group_members LIKE \'position\''); $positions = str_replace(array('enum(', ')', '\''), '', $res[0]['Type']); + if ($globals->asso('has_nl')) { + $nl = NewsLetter::forGroup($globals->asso('shortname')); + $nl_registered = $nl->subscriptionState($user); + } else { + $nl_registered = false; + } $page->assign('user', $user); $page->assign('suggest', $this->suggest($user)); $page->assign('listes', $mmlist->get_lists($user->forlifeEmail())); $page->assign('alias', $user->emailGroupAliases($globals->asso('mail_domain'))); $page->assign('positions', explode(',', $positions)); + $page->assign('nl_registered', $nl_registered); + $page->assign('pending_xnet_account', XDB::fetchOneCell('SELECT 1 + FROM register_pending_xnet + WHERE uid = {?}', + $user->id())); } function handler_rss(PlPage $page, PlUser $user)