@owner Deutsche Gesellschaft für International Zusammenarbeit (GIZ) Gmb @copyright Copyright (C) 2015. All Rights Reserved @license GNU/GPL Version 2 or later - http://www.gnu.org/licenses/gpl-2.0.html /-------------------------------------------------------------------------------------------------------/ Cost Benefit Projection Tool. /------------------------------------------------------------------------------------------------------*/ // No direct access to this file defined('_JEXEC') or die('Restricted access'); /** * Routing class from com_costbenefitprojection * * @since 3.3 */ class CostbenefitprojectionRouter extends JComponentRouterBase { /** * Build the route for the com_costbenefitprojection component * * @param array &$query An array of URL arguments * * @return array The URL arguments to use to assemble the subsequent URL. * * @since 3.3 */ public function build(&$query) { $segments = array(); // Get a menu item based on Itemid or currently active $params = JComponentHelper::getParams('com_costbenefitprojection'); if (empty($query['Itemid'])) { $menuItem = $this->menu->getActive(); } else { $menuItem = $this->menu->getItem($query['Itemid']); } $mView = (empty($menuItem->query['view'])) ? null : $menuItem->query['view']; $mId = (empty($menuItem->query['id'])) ? null : $menuItem->query['id']; if (isset($query['view'])) { $view = $query['view']; if (empty($query['Itemid']) && !(isset($view) && isset($query['id']) && ($view === 'company' || $view === 'scaling_factor' || $view === 'intervention' || $view === 'cpanel' || $view === 'publicresults' || $view === 'createaccount' || $view === 'companyresults' || $view === 'combinedresults'))) { $segments[] = $query['view']; } unset($query['view']); } // Are we dealing with a item that is attached to a menu item? if (isset($view) && ($mView == $view) and (isset($query['id'])) and ($mId == (int) $query['id'])) { unset($query['view']); unset($query['catid']); unset($query['id']); return $segments; } if (isset($view) && isset($query['id']) && ($view === 'company' || $view === 'scaling_factor' || $view === 'intervention' || $view === 'cpanel' || $view === 'publicresults' || $view === 'createaccount' || $view === 'companyresults' || $view === 'combinedresults')) { if ($mId != (int) $query['id'] || $mView != $view) { if (($view === 'company' || $view === 'scaling_factor' || $view === 'intervention' || $view === 'cpanel' || $view === 'publicresults' || $view === 'createaccount' || $view === 'companyresults' || $view === 'combinedresults')) { $segments[] = $view; $id = explode(':', $query['id']); if (count($id) == 2) { $segments[] = $id[1]; } else { $segments[] = $id[0]; } } } unset($query['id']); } $total = count($segments); for ($i = 0; $i < $total; $i++) { $segments[$i] = str_replace(':', '-', $segments[$i]); } return $segments; } /** * Parse the segments of a URL. * * @param array &$segments The segments of the URL to parse. * * @return array The URL attributes to be used by the application. * * @since 3.3 */ public function parse(&$segments) { $count = count($segments); $vars = array(); // Handle View and Identifier switch($segments[0]) { case 'company': $vars['view'] = 'company'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } break; case 'scaling_factor': $vars['view'] = 'scaling_factor'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } break; case 'intervention': $vars['view'] = 'intervention'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } break; case 'cpanel': $vars['view'] = 'cpanel'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } elseif ($segments[$count-1]) { $id = $this->getVar('company', $segments[$count-1], 'alias', 'id'); if($id) { $vars['id'] = $id; } } break; case 'publicresults': $vars['view'] = 'publicresults'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } elseif ($segments[$count-1]) { $id = $this->getVar('country', $segments[$count-1], 'alias', 'id'); if($id) { $vars['id'] = $id; } } break; case 'createaccount': $vars['view'] = 'createaccount'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } elseif ($segments[$count-1]) { $id = $this->getVar('country', $segments[$count-1], 'alias', 'id'); if($id) { $vars['id'] = $id; } } break; case 'companyresults': $vars['view'] = 'companyresults'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } elseif ($segments[$count-1]) { $id = $this->getVar('company', $segments[$count-1], 'alias', 'id'); if($id) { $vars['id'] = $id; } } break; case 'combinedresults': $vars['view'] = 'combinedresults'; if (is_numeric($segments[$count-1])) { $vars['id'] = (int) $segments[$count-1]; } elseif ($segments[$count-1]) { $id = $this->getVar('company', $segments[$count-1], 'alias', 'id'); if($id) { $vars['id'] = $id; } } break; } return $vars; } protected function getVar($table, $where = null, $whereString = null, $what = null, $category = false, $operator = '=', $main = 'costbenefitprojection') { if(!$where || !$what || !$whereString) { return false; } // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); $query->select($db->quoteName(array($what))); if ('categories' == $table || 'category' == $table || $category) { $getTable = '#__categories'; $query->from($db->quoteName($getTable)); // we need this to target the components categories (TODO will keep an eye on this) $query->where($db->quoteName('extension') . ' LIKE '. $db->quote((string)'com_' . $main . '%')); } else { // we must check if the table exist (TODO not ideal) $tables = $db->getTableList(); $app = JFactory::getApplication(); $prefix = $app->get('dbprefix'); $check = $prefix.$main.'_'.$table; if (in_array($check, $tables)) { $getTable = '#__'.$main.'_'.$table; $query->from($db->quoteName($getTable)); } else { return false; } } if (is_numeric($where)) { return false; } elseif ($this->checkString($where)) { // we must first check if this table has the column $columns = $db->getTableColumns($getTable); if (isset($columns[$whereString])) { $query->where($db->quoteName($whereString) . ' '.$operator.' '. $db->quote((string)$where)); } else { return false; } } else { return false; } $db->setQuery($query); $db->execute(); if ($db->getNumRows()) { return $db->loadResult(); } return false; } protected function checkString($string) { if (isset($string) && is_string($string) && strlen($string) > 0) { return true; } return false; } } function CostbenefitprojectionBuildRoute(&$query) { $router = new CostbenefitprojectionRouter; return $router->build($query); } function CostbenefitprojectionParseRoute($segments) { $router = new CostbenefitprojectionRouter; return $router->parse($segments); }