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,
33 (e.uid IS NULL AND FIND_IN_SET("googleapps", u.mail_storage) = 0)
34 FROM auth_user_md5 AS u
35 INNER JOIN aliases AS a ON u.user_id = a.id
36 LEFT JOIN emails AS e ON (e.flags = "active" AND e.uid = u.user_id)
38 GROUP BY u.user_id', $m);
39 if(list($prenom, $nom, $promo, $broken) = $res->fetchOneRow()) {
40 $key = $tri_promo ?
$promo : strtoupper($nom{0});
41 $membres[$key][$nom.$m] = Array('n' => "$prenom $nom", 'l' => $m, 'p' => (!$tri_promo ?
$promo : null
), 'b' => $broken);
43 $membres[0][] = Array('l' => $mem, 'b' => $broken);
46 $res = XDB
::query('SELECT m2.uid,
47 IF(m2.origine="X", u.prenom, m1.prenom) AS prenom,
48 IF(m2.origine="X", u.nom, m1.nom) AS nom,
49 IF(m2.origine="X", u.promo, "non-X") AS promo,
51 FROM groupex.membres AS m1
52 LEFT JOIN groupex.membres AS m2 ON(m1.email=m2.email AND m2.asso_id={?})
53 LEFT JOIN auth_user_md5 AS u ON(m2.origine = "X" AND m2.uid = u.user_id)
54 WHERE m1.email={?}', $globals->asso('id'), $mem);
55 if (list($uid, $prenom, $nom, $promo) = $res->fetchOneRow()) {
56 $key = $tri_promo ?
($promo != 'non-X' ?
$promo : 0) : strtoupper(@$nom{0});
60 $membres[$key][$nom.$m] = Array('n' => "$prenom $nom", 'l' => $mem, 'x' => $uid, 'p' => $promo);
62 $membres[0][] = Array('l' => $mem, 'p' => (!$tri_promo ?
'non-X' : null
));
68 foreach($membres as $key=>$val) ksort($membres[$key]);
73 // {{{ function list_sort_members
75 function list_sort_members(&$members, $tri_promo = true
) {
76 $member_list = array_map(create_function('$arr', 'return $arr[1];'), $members);
77 return list_sort_owners($member_list, $tri_promo);
81 // {{{ function list_header_decode
83 function _list_header_decode($charset, $c, $str) {
84 $s = ($c == 'Q' ||
$c == 'q') ?
quoted_printable_decode($str) : base64_decode($str);
85 $s = iconv($charset, 'UTF-8', $s);
86 return str_replace('_', ' ', $s);
89 function list_header_decode($value) {
91 return "[pas de sujet]";
93 $val = preg_replace('/(=\?[^?]*\?[BQbq]\?[^?]*\?=) (=\?[^?]*\?[BQbq]\?[^?]*\?=)/', '\1\2', $value);
94 return preg_replace('/=\?([^?]*)\?([BQbq])\?([^?]*)\?=/e', '_list_header_decode("\1", "\2", "\3")', $val);
98 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: