| 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 | ?> |