/**
* 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;
}
