Merge branch 'platal-0.9.15'
[platal.git] / modules / lists / lists.inc.php
CommitLineData
0337d704 1<?php
2/***************************************************************************
179afa7f 3 * Copyright (C) 2003-2008 Polytechnique.org *
0337d704 4 * http://opensource.polytechnique.org/ *
5 * *
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. *
10 * *
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. *
15 * *
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 *
18 * Foundation, Inc., *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
21
0337d704 22// {{{ function list_sort_owners
23
24function list_sort_owners(&$members, $tri_promo = true) {
25 global $globals;
26
27 $membres = Array();
42a50827 28
0337d704 29 foreach($members as $mem) {
575dd9be 30 list($m, $dom) = explode('@',$mem);
0337d704 31 if ($dom == $globals->mail->domain || $dom == $globals->mail->domain2) {
ce835419
FB
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)
36 WHERE a.alias = {?}
37 GROUP BY u.user_id', $m);
38 if(list($prenom, $nom, $promo, $broken) = $res->fetchOneRow()) {
0337d704 39 $key = $tri_promo ? $promo : strtoupper($nom{0});
ce835419 40 $membres[$key][$nom.$m] = Array('n' => "$prenom $nom", 'l' => $m, 'p' => (!$tri_promo ? $promo : null), 'b' => $broken);
0337d704 41 } else {
ce835419 42 $membres[0][] = Array('l' => $mem, 'b' => $broken);
0337d704 43 }
44 } else {
dc2073c3 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,
ce835419
FB
48 IF(m2.origine="X", u.promo, "non-X") AS promo,
49 0
8040946c 50 FROM groupex.membres AS m1
51 LEFT JOIN groupex.membres AS m2 ON(m1.email=m2.email AND m2.asso_id={?})
dc2073c3 52 LEFT JOIN auth_user_md5 AS u ON(m2.origine = "X" AND m2.uid = u.user_id)
8040946c 53 WHERE m1.email={?}', $globals->asso('id'), $mem);
dc2073c3 54 if (list($uid, $prenom, $nom, $promo) = $res->fetchOneRow()) {
55 $key = $tri_promo ? ($promo != 'non-X' ? $promo : 0) : strtoupper($nom{0});
56 if ($tri_promo) {
57 $promo = null;
58 }
59 $membres[$key][$nom.$m] = Array('n' => "$prenom $nom", 'l' => $mem, 'x' => $uid, 'p' => $promo);
0337d704 60 } else {
30fc8ee7 61 $membres[0][] = Array('l' => $mem, 'p' => (!$tri_promo ? 'non-X' : null));
0337d704 62 }
63 }
64 }
42a50827 65
0337d704 66 ksort($membres);
67 foreach($membres as $key=>$val) ksort($membres[$key]);
68 return $membres;
69}
70
71// }}}
72// {{{ function list_sort_members
73
74function list_sort_members(&$members, $tri_promo = true) {
89460d9c 75 $member_list = array_map(create_function('$arr', 'return $arr[1];'), $members);
76 return list_sort_owners($member_list, $tri_promo);
0337d704 77}
78
79// }}}
0cc4c07d 80// {{{ function list_header_decode
81
82function _list_header_decode($charset, $c, $str) {
83 $s = ($c == 'Q' || $c == 'q') ? quoted_printable_decode($str) : base64_decode($str);
493b6abe 84 $s = iconv($charset, 'UTF-8', $s);
0cc4c07d 85 return str_replace('_', ' ', $s);
86}
87
88function list_header_decode($value) {
5fb22b39 89 if (!$value) {
90 return "[pas de sujet]";
91 }
0cc4c07d 92 $val = preg_replace('/(=\?[^?]*\?[BQbq]\?[^?]*\?=) (=\?[^?]*\?[BQbq]\?[^?]*\?=)/', '\1\2', $value);
93 return preg_replace('/=\?([^?]*)\?([BQbq])\?([^?]*)\?=/e', '_list_header_decode("\1", "\2", "\3")', $val);
94}
95
96// }}}
a7de4ef7 97// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
0337d704 98?>