htdocs.net/plan.php

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