0337d704 |
1 | <?php |
2 | require 'xnet.inc.php'; |
3 | |
4 | new_page('xnet/plan.tpl', AUTH_PUBLIC); |
5 | $page->setType('plan'); |
6 | |
7 | $res = $globals->xdb->iterator( |
8 | 'SELECT dom.id, dom.nom as domnom, asso.diminutif, asso.nom |
9 | FROM groupex.dom |
10 | INNER JOIN groupex.asso ON dom.id = asso.dom |
11 | WHERE FIND_IN_SET("GroupesX", dom.cat) AND FIND_IN_SET("GroupesX", asso.cat) |
12 | ORDER BY dom.nom, asso.nom'); |
13 | $groupesx = array(); |
14 | while ($tmp = $res->next()) { $groupesx[$tmp['id']][] = $tmp; } |
15 | $page->assign('groupesx', $groupesx); |
16 | |
17 | $res = $globals->xdb->iterator( |
18 | 'SELECT dom.id, dom.nom as domnom, asso.diminutif, asso.nom |
19 | FROM groupex.dom |
20 | INNER JOIN groupex.asso ON dom.id = asso.dom |
21 | WHERE FIND_IN_SET("Binets", dom.cat) AND FIND_IN_SET("Binets", asso.cat) |
22 | ORDER BY dom.nom, asso.nom'); |
23 | $binets = array(); |
24 | while ($tmp = $res->next()) { $binets[$tmp['id']][] = $tmp; } |
25 | $page->assign('binets', $binets); |
26 | |
27 | $res = $globals->xdb->iterator( |
28 | 'SELECT asso.diminutif, asso.nom |
29 | FROM groupex.asso |
30 | WHERE cat LIKE "%Promotions%" |
31 | ORDER BY diminutif'); |
32 | $page->assign('promos', $res); |
33 | |
34 | $res = $globals->xdb->iterator( |
35 | 'SELECT asso.diminutif, asso.nom |
36 | FROM groupex.asso |
37 | WHERE FIND_IN_SET("Institutions", cat) |
38 | ORDER BY diminutif'); |
39 | $page->assign('inst', $res); |
40 | |
41 | $page->run(); |
42 | ?> |