2 /***************************************************************************
3 * Copyright (C) 2003-2008 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 // {{{ function list_sort_owners
24 function list_sort_owners(&$members, $tri_promo = true
) {
29 foreach($members as $mem) {
30 list($m, $dom) = explode('@',$mem);
31 if ($dom == $globals->mail
->domain ||
$dom == $globals->mail
->domain2
) {
32 $res = XDB
::query('SELECT prenom, IF(nom_usage="", nom, nom_usage), promo, e.uid IS NULL
33 FROM auth_user_md5 AS u
34 INNER JOIN aliases AS a ON u.user_id = a.id
35 LEFT JOIN emails AS e ON ( e.flags = \'active\' AND e.uid = u.user_id)
37 GROUP BY u.user_id', $m);
38 if(list($prenom, $nom, $promo, $broken) = $res->fetchOneRow()) {
39 $key = $tri_promo ?
$promo : strtoupper($nom{0});
40 $membres[$key][$nom.$m] = Array('n' => "$prenom $nom", 'l' => $m, 'p' => (!$tri_promo ?
$promo : null
), 'b' => $broken);
42 $membres[0][] = Array('l' => $mem, 'b' => $broken);
45 $res = XDB
::query('SELECT m2.uid,
46 IF(m2.origine="X", u.prenom, m1.prenom) AS prenom,
47 IF(m2.origine="X", u.nom, m1.nom) AS nom,
48 IF(m2.origine="X", u.promo, "non-X") AS promo,
50 FROM groupex.membres AS m1
51 LEFT JOIN groupex.membres AS m2 ON(m1.email=m2.email AND m2.asso_id={?})
52 LEFT JOIN auth_user_md5 AS u ON(m2.origine = "X" AND m2.uid = u.user_id)
53 WHERE m1.email={?}', $globals->asso('id'), $mem);
54 if (list($uid, $prenom, $nom, $promo) = $res->fetchOneRow()) {
55 $key = $tri_promo ?
($promo != 'non-X' ?
$promo : 0) : strtoupper($nom{0});
59 $membres[$key][$nom.$m] = Array('n' => "$prenom $nom", 'l' => $mem, 'x' => $uid, 'p' => $promo);
61 $membres[0][] = Array('l' => $mem, 'p' => (!$tri_promo ?
'non-X' : null
));
67 foreach($membres as $key=>$val) ksort($membres[$key]);
72 // {{{ function list_sort_members
74 function list_sort_members(&$members, $tri_promo = true
) {
75 $member_list = array_map(create_function('$arr', 'return $arr[1];'), $members);
76 return list_sort_owners($member_list, $tri_promo);
80 // {{{ function list_header_decode
82 function _list_header_decode($charset, $c, $str) {
83 $s = ($c == 'Q' ||
$c == 'q') ?
quoted_printable_decode($str) : base64_decode($str);
84 $s = iconv($charset, 'UTF-8', $s);
85 return str_replace('_', ' ', $s);
88 function list_header_decode($value) {
90 return "[pas de sujet]";
92 $val = preg_replace('/(=\?[^?]*\?[BQbq]\?[^?]*\?=) (=\?[^?]*\?[BQbq]\?[^?]*\?=)/', '\1\2', $value);
93 return preg_replace('/=\?([^?]*)\?([BQbq])\?([^?]*)\?=/e', '_list_header_decode("\1", "\2", "\3")', $val);
97 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: