private\pages\Controller.php line 9

  1. <?php
  3. use App\Objects\Diaporama;
  4. use Klio\KlioBundle\Database\DB;
  5. use Klio\KlioBundle\Symfony\Controller;
  7. class PrivateController
  8. {
  9.     public function render(Controller $ROUTE)
  10.     {
  11.         $DB = new DB();
  12.         $page = $DB->query("
  13.         SELECT *
  14.         FROM 
  15.             pages7 
  16.         LEFT JOIN 
  17.             files ON files__table_id = pages7__id
  18.         WHERE 
  19.             pages7__url like :url
  20.         ORDER BY 
  21.             pages7__node_position,pages7__num
  22.         ", array('url' => __PATH__), "row");
  24.         if ($page) {
  25.             $TWIG['title'] = $page['pages7__titre'];
  26.             $TWIG['ariane'] = "<a href='/'>Accueil</a> / " . $page['pages7__titre'];
  27.             $TWIG['page_subtitle'] = $page['pages7__sous_titre'];
  29.             $TWIG['page_photo'] =  $page['files__hash'];
  31.             $TWIG['page_title'] = $page['pages7__titre'];
  33.             $page_content = $page['pages7__html'];
  35.             $diapos = new Diaporama($page_content, 'https://2023.vacaf.org');
  36.             $page_content = $diapos->getHtml();
  38.             $TWIG['page_content'] = '<div>' . $page_content . '</div>';
  40.             $TWIG['subpages'] = [];
  41.             $subpages = $DB->query("
  42.                 SELECT * 
  43.                 FROM 
  44.                     pages7
  45.                 LEFT JOIN 
  46.                     files ON files__table_id = pages7__id
  47.                 WHERE 
  48.                     pages7__node_parent = :parent
  49.                 ORDER BY 
  50.                     pages7__node_position,pages7__num
  51.                 ", array('parent' => $page['pages7__id']));
  52.             $page2 = $page;
  53.             while ($page2 = $DB->fetch($subpages)) {
  54.                 $TWIG['subpages'][$page2['pages7__id']]['id'] = $page2['pages7__id'];
  55.                 $TWIG['subpages'][$page2['pages7__id']]['title'] = $page2['pages7__titre'];
  56.                 $TWIG['subpages'][$page2['pages7__id']]['subtitle'] = $page2['pages7__sous_titre'];
  58.                 $page_content = $page2['pages7__html'];
  59.                 $diapos = new Diaporama($page_content, 'https://2025.vacaf.org');
  60.                 $page_content = $diapos->getHtml();
  61.                 $TWIG['subpages'][$page2['pages7__id']]['content'] =  $page_content;
  63.                 $TWIG['subpages'][$page2['pages7__id']]['photos'][] = $page2['files__num'];
  64.             }
  65.             $ROUTE->setTemplate('/_page.twig');
  66.             $ROUTE->addTwig($TWIG);
  67.         } else {
  68.             $ROUTE->setRouteFound(false);
  69.         }
  70.     }
  71. }