X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fnotifs.inc.php;h=4daeaf63d32f59d6f9ab87b8fabde947940992db;hb=4d2d6d18a318843e76a3a3ecb50446770ac9f788;hp=43cfe17d064703da0743f73bda453848f3a80253;hpb=612a2d8ae13ee29edb3279132877b63db18a5da5;p=platal.git diff --git a/include/notifs.inc.php b/include/notifs.inc.php index 43cfe17..4daeaf6 100644 --- a/include/notifs.inc.php +++ b/include/notifs.inc.php @@ -39,9 +39,13 @@ function register_watch_op($uid, $cid, $date='', $info='') if (empty($date)) { $date = date('Y-m-d'); }; - XDB::execute('REPLACE INTO watch_ops (uid,cid,known,date,info) VALUES({?},{?},NOW(),{?},{?})', - $uid, $cid, $date, $info); + XDB::execute('REPLACE INTO watch_ops (uid,cid,known,date,info) + VALUES ({?}, {?}, NOW(), {?}, {?})', + $uid, $cid, $date, $info); if($cid == WATCH_FICHE) { + if ($info) { + register_profile_update($uid, $info); + } XDB::execute('UPDATE auth_user_md5 SET DATE=NOW() WHERE user_id={?}', $uid); } elseif($cid == WATCH_INSCR) { XDB::execute('REPLACE INTO contacts (uid,contact) @@ -64,11 +68,11 @@ function _select_notifs_base($table, $mail, $where) ), 'watch_promo' => Array('wfield' => 'promo', 'ufield' => 'promo', 'need_contact' => true, 'freq_sql' => ' AND ( wc.type = "basic" OR wc.type="near" AND (u.promo <= v.promo_sortie-2 AND u.promo_sortie >= v.promo+2) )', - 'contact_sql' => 'NOT (c.contact IS NULL)' + 'contact_sql' => 'IF(c.contact IS NULL, 0, 1)' ), - 'watch_nonins' => Array('wfield' => 'ni_id', 'ufield' => 'user_id', 'need_contact' => false, + 'watch_nonins' => Array('wfield' => 'ni_id', 'ufield' => 'user_id', 'need_contact' => true, 'freq_sql' => '', - 'contact_sql' => '0' + 'contact_sql' => 'IF(c.contact IS NULL, 0, 1)' ) ); @@ -132,7 +136,7 @@ function select_notifs($mail, $uid=null, $last=null, $iterator=true) // }}} // {{{ function getNbNotifs -function getNbNotifs() +function getNbNotifs() { if (!S::has('uid')) { return 0; @@ -153,9 +157,54 @@ function getNbNotifs() } // }}} +// {{{ + +global $prf_desc; +$prf_desc = array('nom' => 'Son patronyme', + 'freetext' => 'Le texte libre', + 'mobile' => 'Son numéro de téléphone portable', + 'nationalite' => 'Sa nationalité', + 'nick' => 'Son surnom', + 'web' => 'L\'adresse de son site web', + 'appli1' => 'Son école d\'application', + 'appli2' => 'Son école de post-application', + 'addresses' => 'Ses adresses', + 'section' => 'Sa section sportive', + 'binets' => 'La liste de ses binets', + 'medals' => 'Ses décorations', + 'cv' => 'Son Curriculum Vitae', + 'jobs' => 'Ses informations professionnelles', + 'photo' => 'Sa photographie'); + +function get_profile_change_details($event, $limit) { + global $prf_desc; + $res = XDB::iterRow("SELECT field + FROM watch_profile + WHERE uid = {?} AND ts > {?} + ORDER BY ts DESC", + $event['uid'], $limit); + if ($res->total() > 0) { + $data = array(); + while (list($field) = $res->next()) { + $data[] .= $prf_desc[$field]; + } + return '