/** * Get a list of strings * * @return string */ public function getStrings() { NenoLog::log('Method getStrings of NenoControllerStrings called', 3); $input = JFactory::getApplication()->input; $filterJson = $input->getString('jsonGroupsElements'); $filterArray = json_decode($filterJson); $filterGroups = array(); $filterElements = array(); $filterField = array(); $filterFile = array(); $filterMethods = array(); $filterStatus = array(); $outputLayout = strtolower($input->getString('outputLayout')); $filterSearch = strtolower($input->get('filter_search', '', 'RAW')); $app = JFactory::getApplication(); NenoLog::log('Processing filtered json data for NenoControllerStrings::getStrings', 3); foreach ($filterArray as $filterItem) { if (NenoHelper::startsWith($filterItem, 'group-') !== false) { $filterGroups[] = str_replace('group-', '', $filterItem); } elseif (NenoHelper::startsWith($filterItem, 'table-') !== false) { $filterElements[] = str_replace('table-', '', $filterItem); } elseif (NenoHelper::startsWith($filterItem, 'field-') !== false) { $filterField[] = str_replace('field-', '', $filterItem); } elseif (NenoHelper::startsWith($filterItem, 'file-') !== false) { $filterFile[] = str_replace('file-', '', $filterItem); } } // Set filters into the request. $input->set('group', $filterGroups); $input->set('table', $filterElements); $input->set('field', $filterField); $input->set('file', $filterFile); $input->set('list', array('limit' => $input->get('limit'), 'start' => $input->get('limitStart'))); $input->set('limitstart', $input->get('limitStart')); $filterJson = $input->getString('jsonMethod'); $filterArray = json_decode($filterJson); foreach ($filterArray as $filterItem) { $filterMethods[] = str_replace('method-', '', $filterItem); } $input->set('type', $filterMethods); $filterJson = $input->getString('jsonStatus'); $filterArray = json_decode($filterJson); foreach ($filterArray as $filterItem) { $filterStatus[] = (int) str_replace('status-', '', $filterItem); } $input->set('status', $filterStatus); $input->set('filter_search', $filterSearch); $app->setUserState('limit', $input->getInt('limit', 20)); $app->setUserState('limitStart', $input->getInt('limitStart', 0)); /* @var $stringsModel NenoModelStrings */ $stringsModel = $this->getModel(); $translations = $stringsModel->getItems(); $displayData = new stdClass(); $displayData->translations = $translations; $displayData->state = $stringsModel->getState(); $displayData->pagination = $stringsModel->getPagination(); echo JLayoutHelper::render($outputLayout, $displayData, JPATH_NENO_LAYOUTS); JFactory::getApplication()->close(); }
/** * Get the type of the SQL query * * @param string $sql SQL Query * * @return int * * @see constants */ protected function getQueryType($sql) { $sql = trim(strtolower($sql)); $queryType = self::OTHER_QUERY; if (NenoHelper::startsWith($sql, 'insert')) { $queryType = self::INSERT_QUERY; } elseif (NenoHelper::startsWith($sql, 'delete')) { $queryType = self::DELETE_QUERY; } elseif (NenoHelper::startsWith($sql, 'replace')) { $queryType = self::REPLACE_QUERY; } elseif (NenoHelper::startsWith($sql, 'update')) { $queryType = self::UPDATE_QUERY; } elseif (NenoHelper::startsWith($sql, 'select')) { $queryType = self::SELECT_QUERY; } return $queryType; }