Database_Query_Error making GET request to /offerte-aanvragen

mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY sort_order ASC' at line 3] in EXECUTE("SELECT * FROM cms_pages WHERE id > 0 AND cms_language_id = 1ORDER BY sort_order ASC")

Stacktrace ▶

• Database_ADO_MYSQL->Execute [/home/users/toyowftp/lib/Framework/Database/ADO/mysql.php, line 28]
  ▶ Args

  Arg	Name	Value
  0		'SELECT *                 FROM cms_pages                 WHERE id > 0 AND cms_language_id = 1ORDER BY sort_order ASC'

  ▶ Src
  23. class Database_ADO_MYSQL extends adodb_mysql
  24. {
  25.     public function getRows($sql)
  26.     {
  27.         return $this->Execute($sql);    
  28.     }
  29.     
  30.     public function Execute($sql, $inputarr = NULL)
  31.     {
  32.         try
  33.         {
• Database_ADO_MYSQL->getRows [/home/users/toyowftp/app/Model/Pages.php, line 111]
  ▶ Args

  Arg	Name	Value
  0		'SELECT *                 FROM cms_pages                 WHERE id > 0 AND cms_language_id = 1ORDER BY sort_order ASC'

  ▶ Src
  76.     public function getPages($parent_id = null, $sort = "ASC", $visible = null, $language = null, $cms_menu_id = null)
  77.     {
  78.         $pageGroups = new Model_PageGroups();
  79.        $page_arr = array();
  81.         $sql = "SELECT *
  82.                 FROM cms_pages
  83.                 WHERE id > 0";
  85.         if ($language)
  86.             $sql .= " AND cms_language_id = " . $language;
  87.         else
  88.               $sql .= " AND cms_language_id = " . $this->language->getId();
  90.         if ($cms_menu_id)
  91.             $sql .= " AND cms_menu_id = " . $cms_menu_id;
  93.         if(isset($parent_id))
  94.         {
  95.             $id = 'is null';
  97.             if ($parent_id !== NULL && $parent_id != 0)
  98.             {
  99.               $id = '= ' . $parent_id;
  100.             }
  102.           $sql .= " AND cms_parent_page_id = " . $parent_id . " ";
  103.         }
  105.         if ($visible !== null)
  106.             $sql .= "AND visible = " . $visible . " ";
  108.         $sql .= "ORDER BY sort_order " . $sort;
  110.         foreach($this->db->getRows($sql) as $row)
  111.         {
  112.             $page = new Model_Page($row['id']);
  114.             if ($visible == 1)
  115.             {
  116.                 //$groups = $pageGroups->getPageGroups($row['id']);
• Model_Pages->getPages [/home/users/toyowftp/app/Model/frontController.php, line 59]
  ▶ Args

  Arg	Name	Value
  0		NULL

  ▶ Src
  36.    public function __buildpage($slug = null)
  37.    {       
  38.        $menus = new Model_Menus();
  39.     $menu = $menus->getDefaultMenu();
  41.        $pages = new Model_Pages();
  42.        $this->data['pages'] = $pages->getTree(0, "ASC", 1, null, $menu->getId());
  43.        
  44.         if ($slug !== null)
  45.        {
  46.            $page = new Model_Page($slug);    
  47.        }
  48.        else
  49.        {
  50.            $page = new Model_Page($this->data['controller']);
  51.        }
  52.        $this->data['page'] = $page;
  53.        
  54.        // subpages
  55.        if ($page->getCmsParentPageId())
  56.            $subpages = $pages->getPages($page->getCmsParentPageId());
  57.        else
  58.            $subpages = $pages->getPages($page->getId());
  59.        $this->data['subpages'] = $subpages;
  60.        
  61.        // parent
  62.        if ($page->getCmsParentPageId())
  63.            $this->data['parent'] = new Model_Page($page->getCmsParentPageId());
  64.        
• Model_frontController->__buildpage [/home/users/toyowftp/app/controllers/frontControllers/indexController.php, line 524]
  ▶ Args

  Arg	Name	Value
  0		'offerte-aanvragen'

  ▶ Src
  57.     public function __default($params)
  58.     {
  59.         $slug = $this->data['controller'];
  60.         if ($slug == "index")
  61.             $slug = "home";
  63.         $action = $this->data['action'];
  64.         if ($action == "__default")
  65.             $action = "";
  67.         // nieuwsbrief
  68.         if (isset($_POST['action']) && ($_POST['action'] == 'subscribe' || $_POST['action'] == 'unsubscribe'))
  69.         {
  70.             $newsletters = new Newsletters();
  72.             // inschrijven
  73.             if ($_POST['action'] == 'subscribe')
  74.             {
  75.                 if (empty($_POST['achternaam']) || !Filter::isEmail($_POST['email']) || empty($_POST['titel']))
  76.                 {
  77.                     $this->data['error'] = 'U heeft niet alle velden correct ingevuld';
  78.                 }
  80.                 elseif ($newsletters->getSubscription($_POST['email']))
  81.                 {
  82.                     $this->data['error'] = 'Opgegeven e-mailadres staat al ingeschreven';
  83.                 }
  85.                 else
  86.                 {
  87.                     $date = date("Y") . "-" . date("m") . "-" . date("d"). " " . date("H") . ":" . date("i") . ":" . date("s");
  88.                     $POST = new Filter_Input($_POST, false);
  89.                     $subscription = new Subscription($_POST['email']);
  90.                     $subscription->setTitel($POST->getRaw('titel'));
  91.                     $subscription->setTussenvoegsel($POST->getRaw('tussenvoegsel'));
  92.                     $subscription->setAchternaam($POST->getRaw('achternaam'));
  93.                     $subscription->setEmail($POST->getRaw('email'));
  94.                     $subscription->setSubscribeDate($date);
  95.                     $subscription->setUnsubscribeDate(NULL);
  96.                     $subscription->setModNewsletterGroupId(1);
  97.                     $subscription->setExport(0);
  98.                     $subscription->save();
  99.                     $this->data['send'] = true;
  100.                 }
  101.             }
  103.             // uitschrijven
  104.             else
  105.             {
  106.                 if (!Filter::isEmail($_POST['email2']))
  107.                 {
  108.                     $this->data['error2'] = 'U heeft geen geldig e-mailadres opgegeven';
  109.                 }
  111.                 /*
  112.                 elseif (!$newsletters->getSubscription($_POST['email2']))
  113.                 {
  114.                     $this->data['error2'] = 'Opgegeven e-mailadres staat niet ingeschreven';
  115.                 }*/
  117.                 else
  118.                 {
  119.                     $date = date("Y") . "-" . date("m") . "-" . date("d"). " " . date("H") . ":" . date("i") . ":" . date("s");
  120.                     $subscription = new Subscription($_POST['email2']);
  121.                     if (!$subscription->getUnsubscribeDate())
  122.                     {
  123.                         $subscription->setEmail($_POST['email2']);
  124.                         if ($subscription->getId() == 0)
  125.                         {
  126.                             $subscription->setSubscribeDate(NULL);
  127.                         }
  128.                         $subscription->setUnsubscribeDate($date);
  129.                         $subscription->setExport(0);
  130.                         $subscription->save();
  131.                     }
  132.                     $this->data['send'] = true;
  133.                 }
  134.             }
  135.             $this->data['fields'] = $_POST;
  136.         }
  138.         switch ($slug)
  139.         {
  141.             case "occasions":
  142.                 if (!empty($action) && !is_numeric($action))
  143.                     $this->_redirect('/occasions', true);
  144.                 break;
  146.             case "nieuwsbrief":
  147.             case "nieuws":                
  148.                 if (!empty($action)) {
  149.                     if ($action == 'uitschrijven') {
  150.                         if (isset($_GET['email']) && Filter::isEmail($_GET['email'])) {
  151.                             $newsletters = new Newsletters();
  152.                             $date = date("Y") . "-" . date("m") . "-" . date("d"). " " . date("H") . ":" . date("i") . ":" . date("s");
  153.                             $subscription = new Subscription($_GET['email']);
  154.                             if ($subscription->getId() > 0 && !$subscription->getUnsubscribeDate())
  155.                             {
  156.                                 $subscription->setUnsubscribeDate($date);
  157.                                 $subscription->setExport(0);
  158.                                 $subscription->save();
  159.                             }
  160.                             $this->data['send'] = true;
  161.                         }
  162.                     } else {
  163.                         $newsletter = new Newsletter($action);
  164.                         if ($newsletter->getId() > 0)
  165.                             $this->data['newsletter'] = $newsletter;
  166.                     }
  167.                 }
  168.                 break;
  169.                 
  170.             case "offerte-aanvragen":
  171.             case "wat-is-mijn-auto-waard":
  172.                 
  173.                 if (count($_POST) > 0)
  174.                 {
  175.                     $POST = new Filter_Input($_POST, false);
  176.                     $validator = Validator::singleton();
  177.                     $errors = array();
  178.                     
  179.                     $vars = array();
  180.                     
  181.                     // interesse in
  182.                     $vars['type'] = $POST->getRaw('type');
  183.                     $vars['kenteken'] = $POST->getRaw('kenteken');
  184.                     $vars['merk'] = $POST->getRaw('merk');
  185.                     
  186.                     if ($vars['type'] == 'Nieuw' || strtolower($vars['merk']) == 'toyota')
  187.                     {
  188.                         $vars['model'] = $POST->getRaw('model');
  189.                         $vars['kenteken'] = '';
  190.                     }
  191.                     else $vars['model'] = $POST->getRaw('model2');
  192.                         
  193.                     if (empty($vars['model']))
  194.                         $errors['model'] = true;
  195.                     
  196.                     $vars['uitvoering'] = $POST->getRaw('uitvoering');
  197.                     $vars['brandstof'] = $POST->getRaw('brandstof');
  198.                     
  199.                     // inruilauto                    
  200.                     $vars['auto'] = $POST->getRaw('auto');
  201.                     if (empty($vars['auto']['inruilen']))
  202.                     {
  203.                         $errors['auto']['inruilen'] = true;
  204.                     }
  205.                     elseif ($vars['auto']['inruilen'] == 'Ja')
  206.                     {
  207.                         foreach ($vars['auto'] as $key => $value)
  208.                         {
  209.                             if ($key != "uitvoering" && $key != "bijzonderheden" && empty($vars['auto'][$key]))
  210.                                 $errors['auto'][$key] = true;
  211.                         }                    
  212.                         if (!isset($vars['auto']['brandstof']))
  213.                             $errors['auto']['brandstof'] = true;
  214.                     }
  215.                         
  216.                     // gegevens
  217.                     $vars['aanhef'] = $POST->getRaw('aanhef');
  218.                     $vars['naam'] = $POST->getRaw('naam');
  219.                     $vars['telefoon'] = $POST->getRaw('telefoon');
  220.                     $vars['email'] = $POST->getRaw('email');
  221.                     $vars['telefoon'] = $POST->getRaw('telefoon');
  222.                     $vars['postcode'] = $POST->getRaw('postcode');
  223.                     $vars['huisnummer'] = $POST->getRaw('huisnummer');
  224.                     $vars['woonplaats'] = $POST->getRaw('woonplaats');
  225.                     $vars['opmerking'] = $POST->getRaw('opmerking');
  226.                     $vars['nieuwsbrief'] = $POST->getInt('nieuwsbrief');
  227.                     $vars['kopie'] = $POST->getInt('kopie');                    
  228.                     
  229.                     if ($validator->validate() && count($errors) == 0)
  230.                     {
  231.                         // aanmelden nieuwsbrief   
  232.                         if ($vars['nieuwsbrief'] == 1)
  233.                         {
  234.                             $date = date("Y") . "-" . date("m") . "-" . date("d"). " " . date("H") . ":" . date("i") . ":" . date("s");
  235.                             $titel = "de heer";
  236.                             if ($vars['aanhef'] == 'Mevr.')
  237.                                 $titel = "mevrouw";
  238.                                 
  239.                             $subscription = new Subscription($vars['email']);
  240.                             $subscription->setTitel($titel);
  241.                             $subscription->setTussenvoegsel('');
  242.                             $subscription->setAchternaam($vars['naam']);
  243.                             $subscription->setEmail($vars['email']);
  244.                             $subscription->setSubscribeDate($date);
  245.                             $subscription->setUnsubscribeDate(NULL);
  246.                             $subscription->setModNewsletterGroupId(1);
  247.                             $subscription->setExport(0);
  248.                             $subscription->save();                            
  249.                         }
  250.                         
  251.                         ob_start();
  252.                         $settings  = Model_Settings::load();
  253.                         $presenter = new Presenter_Smarty($this);
  255.                         // vars
  256.                         $vars['title'] = "Offerte aanvraag";
  257.                         $vars['tplFile'] = "scp_mail_offerte.tpl";
  259.                         // headers
  260.                         $header  = "MIME-Version: 1.0\n";
  261.                         $header .= "Content-type: text/html; charset=iso-8859-1\n";
  262.                         $header .= "From: Toyota Botman <info@toyota-botman.nl>\n";
  264.                         // mail naar toyota
  265.                         $html = $presenter->render("pag_mail_html.tpl", $vars);
  267.                         mail('info@toyota-botman.nl', $vars['title'], $html, $header);
  269.                         // mail naar klant
  270.                         if ($vars['kopie'] == 1)
  271.                         {
  272.                             $vars['klant'] = true;
  273.                             $html = $presenter->render("pag_empty.tpl", $vars);
  274.                             mail($vars['email'], $vars['title'], $html, $header);
  275.                         }                        
  277.                         $this->_redirect('/offerte-aanvragen/verstuurd', true);
  279.                         ob_end_flush();                        
  280.                         
  281.                     }
  282.                     $this->data['vars'] = $vars;     
  283.                     $this->data['errors'] = $errors;            
  284.                 }
  285.                 
  286.                 $this->data['modellen'] = array('iQ','Aygo','Yaris','Urban Cruiser','Auris','Corolla','Verso','Avensis','RAV4','Prius','Land Cruiser');
  287.                 
  288.                 break;
  290.             case "werkplaatsafspraak":
  292.                 $appointments = new Appointments();
  293.                 $this->data['days'] = $appointments;
  294.                 $this->data['start'] = time() + (14 * 24 * 60 * 60);
  296.                 if ($action == 'verstuurd')
  297.                 {
  298.                     unset($this->session->aid);
  299.                 }
  300.                 else
  301.                 {
  302.                     if ($this->session->aid) $appointment = new Appointment($this->session->aid);
  303.                     else
  304.                     {
  305.                         $appointment = new Appointment();
  306.                         $appointment->setVestiging('Zwaag');
  307.                         $appointment->save();
  308.                         $this->session->aid = $appointment->getId();
  309.                     }
  310.                 }
  312.                 if (count($_POST) > 0)
  313.                 {
  314.                     $POST       = new Filter_Input($_POST, false);
  315.                     $validator  = Validator::singleton();
  316.                     $error      = array();
  318.                     $appointment->setAanhef($POST->getRaw('aanhef'));
  319.                     $appointment->setNaam($POST->getRaw('naam'));
  320.                     $appointment->setTelefoon($POST->getRaw('telefoon'));
  321.                     $appointment->setEmail($POST->getRaw('email'));
  322.                     $appointment->setHuisnummer($POST->getRaw('huisnummer'));
  323.                     $appointment->setPostcode($POST->getRaw('postcode'));
  324.                     $appointment->setVestiging($POST->getRaw('vestiging'));
  325.                     $appointment->setWachten($POST->getRaw('wachten'));
  326.                     $appointment->setTijdstip($POST->getRaw('tijdstip'));
  327.                     $appointment->setKenteken($POST->getRaw('kenteken'));
  328.                     $appointment->setKilometerstand($POST->getRaw('kilometerstand'));
  329.                     $appointment->setBeurt($POST->getRaw('beurt'));
  330.                     $appointment->setBijzonderheden($POST->getRaw('bijzonderheden'));
  331.                     $appointment->setVervoer($POST->getRaw('vervoer'));
  332.                     $appointment->setFiets($POST->getRaw('fiets'));
  334.                     // voorkeursdatum
  335.                     $datum = $POST->getRaw('datum');
  336.                     if ($datum == '- Selecteer een vestiging -' || $datum == '- Selecteer een voorkeursdatum -')
  337.                     {
  338.                         $appointment->setDatum('');
  339.                         $error['datum'] = true;
  340.                     }
  341.                     else if (!empty($datum))
  342.                     {
  343.                         list($day, $month, $year) = explode("-", $POST->getRaw('datum'));
  344.                         $appointment->setDatum($year . "-" . $month . "-" . $day);
  345.                     }
  347.                     if ($action == 'stap2')
  348.                     {
  349.                         // vervoer
  350.                         $vv = $POST->getRaw('vv');
  351.                         if ($vv == 'Nee')
  352.                             $appointment->setVervoer('Nee');
  353.                         elseif (!empty($vv) && $appointment->getVervoer() == '')
  354.                         {
  355.                             $appointment->setVervoer('Ja');
  356.                             $error['vervoer'] = true;
  357.                         }
  359.                         // beurt
  360.                         $beurt = $POST->getRaw('beurt2');
  361.                         if ($appointment->getBeurt() == 'Anders')
  362.                         {
  363.                             if (empty($beurt))
  364.                                 $error['beurt'] = true;
  365.                             else
  366.                                 $appointment->setBeurt($beurt);
  367.                         }
  368.                     }
  369.                     else if (empty($action))
  370.                     {
  371.                         if ($appointment->getWachten() == 'Ja')
  372.                         {
  373.                             if ($appointment->getTijdstip() == '')
  374.                             {
  375.                                 $error['tijdstip'] = true;
  376.                             }
  377.                         }
  378.                         else
  379.                         {
  380.                             $appointment->setTijdstip('');
  381.                         }
  382.                     }
  384.                     $appointment->save();
  385.                     $this->data['error'] = $error;
  387.                     // stap terug of verder?
  388.                     $terug = $POST->getInt('terug');
  389.                     if ($terug == 1)
  390.                         $this->_redirect('/werkplaatsafspraak', true);
  392.                     if ($validator->validate() && count($error) == 0)
  393.                     {
  394.                         if ($action == 'stap2')
  395.                         {
  396.                             $appointment->setCompleet(1);
  397.                             $appointment->save();
  399.                             ob_start();
  400.                             $settings  = Model_Settings::load();
  401.                             $presenter = new Presenter_Smarty($this);
  403.                             // vars
  404.                             $vars = array();
  405.                             $vars['appointment']    = $appointment;
  406.                             $vars['title']          = "Werkplaatsafspraak";
  407.                             $vars['tplFile']        = "scp_mail_afspraak.tpl";
  409.                             // headers
  410.                             $header  = "MIME-Version: 1.0\n";
  411.                             $header .= "Content-type: text/html; charset=iso-8859-1\n";
  412.                             $header .= "From: Toyota Botman <info@toyota-botman.nl>\n";
  414.                             // mail naar toyota
  415.                             $html = $presenter->render("pag_mail_html.tpl", $vars);
  417.                             if ($appointment->getVestiging() == 'Medemblik')
  418.                             {
  419.                                 mail('i.houniet@toyota-botman.nl', $vars['title'], $html, $header);
  420.                                 mail('r.blokland@toyota-botman.nl', $vars['title'], $html, $header);
  421.                             }
  422.                             else if  ($appointment->getVestiging() == 'Zwaag')
  423.                             {
  424.                                 mail('j.dekkers@toyota-botman.nl', $vars['title'], $html, $header);
  425.                             }
  427.                             // mail naar klant
  428.                             $vars['klant'] = true;
  429.                             $vars['tplFile'] = "scp_mail_werkplaatsafspraak.tpl";
  430.                             $html = $presenter->render("pag_empty.tpl", $vars);
  431.                             mail($appointment->getEmail(), $vars['title'], $html, $header);
  433.                             $this->_redirect('/werkplaatsafspraak/verstuurd', true);
  435.                             ob_end_flush();
  436.                         }
  437.                         else
  438.                         {
  439.                             $this->_redirect('/werkplaatsafspraak/stap2', true);
  440.                         }
  441.                     }
  442.                 }
  444.                 if (isset($appointment))
  445.                     $this->data['appointment'] = $appointment;
  447.                 $this->data['onderhoudsbeurten'] = array('Kleine onderhoudsbeurt','Kleine onderhoudsbeurt inclusief APK', 'Grote onderhoudsbeurt', 'Grote onderhoudsbeurt inclusief APK', 'APK');
  449.                 break;
  451.             case "contact":
  453.                 if (count($_POST) > 0)
  454.                 {
  455.                     $POST = new Filter_Input($_POST, false);
  456.                     $validator = Validator::singleton();
  458.                     $this->data["message"] = $_POST;
  460.                     if ($validator->validate())
  461.                     {
  462.                         // mails versturen
  463.                         ob_start();
  465.                         $settings  = Model_Settings::load();
  467.                         $presenter = new Presenter_Smarty($this);
  469.                         // vars
  470.                         $vars = array();
  471.                           $vars['message']     = $_POST;
  472.                           $vars['title']     = "Reactie vanaf website";
  473.                           $vars['tplFile']    = "scp_mail_form.tpl";
  475.                           $html = $presenter->render("pag_mail_html.tpl", $vars);
  477.                        // headers
  478.                         $header  = "MIME-Version: 1.0\n";
  479.                         $header .= "Content-type: text/html; charset=iso-8859-1\n";
  480.                         $header .= "From: Toyota Botman <info@toyota-botman.nl>\n";
  482.                         // mail versturen
  483.                         mail($settings->bedrijf->email, $vars['title'], $html, $header);
  485.                        $kopie = $POST->getInt('kopie');
  486.                        if ($kopie == 1)
  487.                        {
  488.                            $vars['title'] = "Uw reactie op www.toyota-botman.nl";
  489.                             mail($POST->getRaw('email'), $vars['title'], $html, $header);
  490.                        }
  492.                        $this->_redirect('/contact/send', true);
  493.                        ob_end_flush();
  494.                     }
  495.                 }
  497.                 if (isset($action) && $action == "send")
  498.                     $this->data["send"] = true;
  500.                 break;
  502.             default:
  504.                 if (!in_array($slug, $this->pages))
  505.                     $this->_redirect('/', true);
  506.                 elseif ($slug == "home")
  507.                     $this->tplFile = 'scp_home.tpl';
  509.                 break;
  510.         }
  512.         $this->data["action"]        = $action;
  513.         $this->data["pageTitle"]     = $this->pageTitle;
  514.         $this->data["bloks"]            = new Blocks();
  515.         $this->data["actions"]        = new Actions();
  516.         $this->data["occasions"]    = new Occasions();
  517.         $this->data["newsletters"]    = new Newsletters();
  518.         $this->data['photoalbums'] = new Photoalbums;
  519.         $this->data['felicitaties'] = new Felicitaties();
  520.         $this->data['sponsors']     = new Sponsors();
  521.         $this->data['medialib']     = new Model_MediaLibrary();
  523.         parent::__buildpage($slug);
  525.     }
  527. }
  528. ?>
• indexController->__default [/home/users/toyowftp/lib/Framework/Controller/Front.php, line 276]
  ▶ Args

  Arg	Name	Value
  0		array ( )

  ▶ Src
  85.     public function dispatch()
  86.     {
  87.         
  88.         /**
  89.          * Haal de request uri op
  90.          */
  91.         $path = $_SERVER['REQUEST_URI'];
  93.         
  94.         /**
  95.          * Strip de base request uri van de base uri
  96.          */        
  97.         if(substr($this->config->base->uri, 0, 7) == "http://")
  98.         {
  99.             $url = substr($this->config->base->uri, 7);
  100.             if (substr($this->config->base->uri, -5) == "fuse/")
  101.                 $url = strstr($url, "/");
  102.         }
  103.         
  104.         
  105.         /**
  106.          * Extract het path van de request_uri zodat alleen de parameters overblijven
  107.          * 
  108.          * www.diffuse.nl/controller-name/action-name/key/value/key/value
  109.          */
  110.         if(strlen($url) > 0)
  111.         {
  112.             if(strstr($path, $url))
  113.             {
  114.                 $path = str_replace($url, "", $path);    
  115.             }
  116.         }
  117.         
  119.         /**
  120.          * Verwijder alles wat achter het ? staat. Dit wordt opgevangen
  121.          * in de $_GET
  122.          */
  123.         if (strstr($path, '?')) 
  124.         {
  125.             $path = substr($path, 0, strpos($path, '?'));
  126.         }
  127.         $path = explode('/', trim($path, '/'));
  129.                 
  130.         /**
  131.          * De controller is altijd het eerste stuk van de URI, en de 
  132.          * actie altijd het tweede stuk
  133.          *
  134.          * www.diffuse.nl/controller-name/action-name/
  135.          */
  136.         $a = 2;
  137.         $language = '';
  138.         $controller = $path[0];
  139.         $action = isset($path[1]) ? $path[1] : null;
  140.         if (strlen($controller) == 2)
  141.         {
  142.             $a = 3;
  143.             $language = $path[0];
  144.             $controller = isset($path[1]) ? $path[1] : null;
  145.             $action = isset($path[2]) ? $path[2] : null;
  146.         }
  147.     
  148.     
  149.         /**
  150.          * Als er geen controller is opgegeven wordt indexController::__default() gebruikt
  151.          */ 
  152.         if (!strlen($controller)) 
  153.         {
  154.            $controller     = 'index';
  155.            $action         = '__default';
  156.         }
  157.         
  158.         
  159.         /**
  160.          * Als er geen actie is opgegeven wordt standaard __default gebruikt
  161.          */ 
  162.         if(!strlen($action))
  163.         {
  164.             $action     = '__default';
  165.         }
  166.         
  167.         /**
  168.          * Alle optionele parameters achter de actie worden 
  169.          * opgeslagen in een array met key/value pairs:
  170.          * 
  171.          * www.diffuse.nl/controller-name/action-name/key/value/key2/value2
  172.          * 
  173.          * $params = array(
  174.          *                 ['key']     => ['value']
  175.          *                 ['key2']    => ['value']
  176.          *             );
  177.          * 
  178.          */
  179.         $params = array();
  180.         for ($i=$a; $i<sizeof($path); $i=$i+2) 
  181.         {
  182.             $params[$path[$i]] = isset($path[$i+1]) ? $path[$i+1] : null;
  183.         }
  185.     
  186.         /**
  187.          * Als $need_login op true staat en ik ben nog niet ingelogd redirect dan naar
  188.          * /user/login
  189.          */
  190.         if($this->need_login == true)
  191.         {
  192.             if($this->user->getId() == 0 || $this->session->valid_script != $_SERVER['SCRIPT_FILENAME'])
  193.             {
  194.                 $controller = 'user';
  195.                 $action        = 'login';    
  196.                  
  197.                 $params['redirect'] = implode("/", $path);
  198.             }
  199.         }
  200.         
  201.         if(isset($controller))
  202.         {
  203.             /**
  204.              * De controller klasse wordt opgebouwd uit de naam + Controller
  205.              * menu => menuController
  206.              */
  207.             $class        = $controller."Controller";
  208.                 
  209.             /**
  210.              * Kijk of de controller aanwezig is in de frontControllers map of 
  211.              * in de module map
  212.              */            
  213.             $controllerFile     = $this->config->path->controllers . $this->config->site->name  . 'Controllers/'. $controller.'Controller.php';
  214.             $moduleFile         = $this->config->path->modules . $controller . '/controllers/' . $this->config->site->name . 'Controllers/' . $controller.'Controller.php';
  215.             
  216.             if (file_exists($controllerFile)) 
  217.             {
  218.                 $classFile = $controllerFile;
  219.             }
  220.             elseif(file_exists($moduleFile))
  221.             {
  222.                 $classFile = $moduleFile;
  223.             }
  224.             else
  225.             {
  226.                 $class = 'indexController';
  227.                 $controllerFile = $this->config->path->controllers . $this->config->site->name  . 'Controllers/indexController.php';
  228.                 $classFile = $controllerFile;
  229.             }
  230.     
  231.             /**
  232.              * Laad de controller file
  233.              */
  234.             Framework::loadFile($classFile);
  235.             
  236.             if (class_exists($class)) 
  237.             {
  238.                 /**
  239.                  * Maak een nieuwe instantie aan van de klasse 
  240.                  */
  241.                 try 
  242.                 {
  243.                     $instance = new $class();
  244.                   
  245.                   /**
  246.                    * Zet de action in de data variabele
  247.                    */                    
  248.                   $instance->setData('controller', $controller);
  249.                   $instance->setData('action', $action);
  250.                 
  251.                     try 
  252.                     {    
  253.                         /**
  254.                          * Kijk of de aangeroepen actie bestaat
  255.                          */
  256.                         if(!method_exists($instance, $action))
  257.                         {
  258.                             /**
  259.                              * Als de actie niet bestaat redirect dan naar __default.
  260.                              */
  261.                             $action = "__default";
  262.                         }                  
  263.                         
  264.                         /**
  265.                          * Kijk of de actie aangeroepen kan worden (en dus public is)
  266.                          */
  267.                         if(!in_array($action, get_class_methods($instance)))
  268.                         {
  269.                             throw new Error("Method not callable");
  270.                         }
  271.                                
  272.                         /**
  273.                              * Roep de functie aan en stuur de parameters mee
  274.                              */
  275.                         $result = $instance->$action($params);     
  276.                         
  277.                     }     
  278.                     catch (Database_Query_Error $error)
  279.                     {
  280.                         $error->viewException();
  281.                         die();
• Controller_Front->dispatch [/home/users/toyowftp/toyota-botman.nl/index.php, line 32]
  ▶ Src
  27. }
  29. $controller = Controller_Front::singleton($config)
  30.             ->setLogin(false)
  31.             ->dispatch();
  33. if ($config->debug)
  34. {
  35.     $bench->stopBenchmark("Laatste");
  36. }

Request ▶

Response ▶