/**
* {@inheritdoc}
*/
public function bindTextDomain($textDomain, $codeSet = null)
{
$this->bendTextDomains[$textDomain] = array();
$textDomainDir = bindtextdomain($textDomain, $this->directory);
$translationFileDir = $textDomainDir . DIRECTORY_SEPARATOR . StringUtils::beforeFirst(setlocale(LC_MESSAGES, '0'), '.') . DIRECTORY_SEPARATOR . 'LC_MESSAGES';
$moFilePath = $translationFileDir . DIRECTORY_SEPARATOR . $textDomain . '.mo';
$poFilePath = $translationFileDir . DIRECTORY_SEPARATOR . $textDomain . '.po';
if (file_exists($moFilePath) === true) {
$this->bendTextDomains[$textDomain]['file_path'] = $moFilePath;
$this->bendTextDomains[$textDomain]['type'] = 'mo';
} elseif (file_exists($poFilePath) === true && $this->poParserInterface instanceof PoParserInterface === true) {
$this->bendTextDomains[$textDomain]['file_path'] = $poFilePath;
$this->bendTextDomains[$textDomain]['type'] = 'po';
$this->bendTextDomains[$textDomain]['plural_expr'] = false;
$this->bendTextDomains[$textDomain]['entries'] = $this->poParserInterface->extract($poFilePath);
$this->bendTextDomains[$textDomain]['plural_expr'] = '$' . $this->defaultPluralRule . ';';
// Default plural rule
$this->bendTextDomains[$textDomain]['plurals'] = 2;
if (isset($this->bendTextDomains[$textDomain]['entries']['']) === true) {
foreach ($this->bendTextDomains[$textDomain]['entries']['']['msgstr'] as $meta) {
if (preg_match('/Plural-Forms:\\s+nplurals=(\\d+);\\s+(plural=[^;]+)/', $meta, $matches) === 0) {
continue;
}
$this->bendTextDomains[$textDomain]['plurals'] = (int) $matches[1];
$this->bendTextDomains[$textDomain]['plural_expr'] = '$' . $matches[2] . ';';
}
}
} else {
return;
}
$textDomainCodeSet = $codeSet !== null ? $codeSet : $this->defaultCodeSet;
if (bind_textdomain_codeset($textDomain, $textDomainCodeSet) === $textDomainCodeSet) {
$this->bendTextDomains[$textDomain]['code_set'] = $textDomainCodeSet;
}
}
public function testIsFloat()
{
$this->assertEquals(false, StringUtils::isFloat('foo'), 'Not a float but a string');
$this->assertEquals(false, StringUtils::isFloat('42'), 'Not a float but an int');
$this->assertEquals(true, StringUtils::isFloat('42.3'), 'A float');
}
/**
* Creates a new HttpRequest object based on the given data
* @param array $requestData Data of the HTTP request
* @return HttpRequest
*/
public static function create(array $requestData = array())
{
$defaultValues = array('REQUEST_TIME' => time(), 'SERVER_PORT' => null, 'SERVER_NAME' => null, 'QUERY_STRING' => null, 'REMOTE_ADDR' => null, 'HTTP_USER_AGENT' => null, 'HTTPS' => null, 'REQUEST_URI' => null, 'HTTP_ACCEPT_LANGUAGE' => null, 'HTTP_ACCEPT_ENCODING' => null, 'REQUEST_METHOD' => null);
$requestData = array_merge($defaultValues, $requestData);
$httpRequest = new HttpRequest();
$protocol = null;
if ($requestData['HTTPS'] !== null) {
$protocol = $requestData['HTTPS'] === 'on' ? HttpRequest::PROTOCOL_HTTPS : HttpRequest::PROTOCOL_HTTP;
}
$uri = StringUtils::startsWith($requestData['REQUEST_URI'], self::$basePath) ? StringUtils::afterFirst($requestData['REQUEST_URI'], self::$basePath) : $requestData['REQUEST_URI'];
$path = StringUtils::beforeLast($uri, '?');
$languages = array();
$langRates = array_filter(explode(',', $requestData['HTTP_ACCEPT_LANGUAGE']));
foreach ($langRates as $lr) {
list($langCode, $importance) = array_pad(preg_split('/;(?:q=)?/', $lr), 2, 1.0);
$languages[$langCode] = (double) $importance;
}
$acceptedEncoding = array_filter(array_map('trim', explode(',', $requestData['HTTP_ACCEPT_ENCODING'])));
$requestTime = new \DateTime();
$requestTime->setTimestamp($requestData['REQUEST_TIME']);
$httpRequest->setHost($requestData['SERVER_NAME']);
$httpRequest->setPath($path);
$httpRequest->setPort($requestData['SERVER_PORT']);
$httpRequest->setProtocol($protocol);
$httpRequest->setQuery($requestData['QUERY_STRING']);
$httpRequest->setURI($uri);
$httpRequest->setRequestTime($requestTime);
$httpRequest->setAcceptedEncodings($acceptedEncoding);
$httpRequest->setRequestMethod($requestData['REQUEST_METHOD']);
$httpRequest->setUserAgent($requestData['HTTP_USER_AGENT']);
$httpRequest->setAcceptedLanguages($languages);
$httpRequest->setRemoteAddress($requestData['REMOTE_ADDR']);
$headers = array();
foreach ($_SERVER as $name => $value) {
if (StringUtils::startsWith($name, 'HTTP_') === true) {
$name = str_replace(' ', '-', ucwords(strtolower(str_replace('_', ' ', substr($name, 5)))));
$headers[$name] = $value;
} elseif ($name == 'CONTENT_TYPE') {
$headers['Content-Type'] = $value;
} elseif ($name == 'CONTENT_LENGTH') {
$headers['Content-Length'] = $value;
}
}
$httpRequest->setHeaders($headers);
return $httpRequest;
}
public function replaceNode(TemplateEngine $tplEngine, ElementNode $tagNode)
{
$compareAttr = $tagNode->getAttribute('compare')->value;
$operatorAttr = $tagNode->getAttribute('operator')->value;
$againstAttr = $tagNode->getAttribute('against')->value;
$condAttr = $tagNode->getAttribute('cond')->value;
if ($condAttr === null) {
// Check required attrs
$tplEngine->checkRequiredAttrs($tagNode, array('compare', 'operator', 'against'));
if (strlen($againstAttr) === 0) {
$againstAttr = "''";
} elseif (is_int($againstAttr) === true) {
$againstAttr = intval($againstAttr);
} elseif (is_float($againstAttr) === true) {
$againstAttr = floatval($againstAttr);
} elseif (is_string($againstAttr) === true) {
if (strtolower($againstAttr) === 'null') {
//$againstAttr = 'null';
} elseif (strtolower($againstAttr) === 'true' || strtolower($againstAttr) === 'false') {
//$againstAttr = ($againstAttr === 'true')?true:false;
} elseif (StringUtils::startsWith($againstAttr, '{') && StringUtils::endsWith($againstAttr, '}')) {
$arr = substr(explode(',', $againstAttr), 1, -1);
$againstAttr = array();
foreach ($arr as $a) {
$againstAttr[] = trim($a);
}
} else {
$againstAttr = "'" . $againstAttr . "'";
}
}
$operatorStr = '==';
switch (strtolower($operatorAttr)) {
case 'gt':
$operatorStr = '>';
break;
case 'ge':
$operatorStr = '>=';
break;
case 'lt':
$operatorStr = '<';
break;
case 'le':
$operatorStr = '<=';
break;
case 'eq':
$operatorStr = '==';
break;
case 'ne':
$operatorStr = '!=';
break;
}
$phpCode = '<?php ';
$phpCode .= 'if($this->getDataFromSelector(\'' . $compareAttr . '\') ' . $operatorStr . ' ' . $againstAttr . '): ?>';
$phpCode .= $tagNode->getInnerHtml();
if ($tplEngine->isFollowedBy($tagNode, array('else', 'elseif')) === false) {
$phpCode .= '<?php endif; ?>';
}
$textNode = new TextNode($tplEngine->getDomReader());
$textNode->content = $phpCode;
$tagNode->parentNode->replaceNode($tagNode, $textNode);
$tagNode->parentNode->removeNode($tagNode);
} else {
$phpCode = '<?php ';
$phpCode .= 'if(' . preg_replace_callback('/\\${(.*?)}/i', function ($m) {
if (strlen($m[1]) === 0) {
throw new TemplateEngineException('Empty template data reference');
}
return '$this->getDataFromSelector(\'' . $m[1] . '\')';
}, $condAttr) . '): ?>';
$phpCode .= $tagNode->getInnerHtml();
if ($tplEngine->isFollowedBy($tagNode, array('else', 'elseif')) === false) {
$phpCode .= '<?php endif; ?>';
}
$textNode = new TextNode($tplEngine->getDomReader());
$textNode->content = $phpCode;
$tagNode->parentNode->replaceNode($tagNode, $textNode);
$tagNode->parentNode->removeNode($tagNode);
}
}
/**
* @return HttpResponse
* @throws CMSException
* @throws HttpException
* @throws \Exception
*/
public function restoreElementAjax()
{
list($elementType, $elementID, $elementPageID) = explode('-', $this->httpRequest->getVar('module', 'strip_tags'));
$revisionFile = $this->httpRequest->getVar('revision', 'strip_tags');
$cmsPage = $this->pageModel->getPageByID($elementPageID);
$moduleModel = new ModuleModel($this->db);
$modInstance = $moduleModel->getElementInstanceByID($elementID, $cmsPage);
try {
$this->db->setListenersMute(true);
$this->db->beginTransaction();
$revisionControl = new RevisionControl($this->db);
$revisionControl->restoreFromFile($revisionFile);
$fileNameParts = explode('.', StringUtils::afterLast($revisionFile, '/'));
$this->updateElementRevision($modInstance, $fileNameParts[2]);
$this->db->commit();
$this->db->setListenersMute(false);
} catch (\Exception $e) {
$this->db->setListenersMute(false);
$this->db->rollBack();
$this->logger->error('Could not restore element ' . $e->getMessage());
return new HttpResponse(500, 'Could not restore element: ' . $e->getMessage());
}
// RENDER ELEMENT AGAIN, SEND BACK
if ($modInstance instanceof CmsElementSettingsLoadable) {
/** @var CmsElement $modInstance */
$moduleModel->reloadSettings($modInstance, $cmsPage);
}
$referrerPath = StringUtils::beforeFirst($this->httpRequest->getVar('referrer', 'strip_tags'), '?');
$httpRequestFrontend = clone $this->httpRequest;
$httpRequestFrontend->setPath($referrerPath);
$httpRequestFrontend->setRequestMethod('GET');
$frontendController = new FrontendController($this->core, $httpRequestFrontend, $this->route);
$frontendController->deliverCMSPage();
// @TODO render and replace parent module of this one
$newModuleHtml = $modInstance->render($frontendController, $this->moduleView);
return new HttpResponse(200, $newModuleHtml);
}
/**
* @param string $selectorStr
* @param bool $returnNull
*
* @return mixed
*
* @throws TemplateEngineException
*/
protected function getSelectorValue($selectorStr, $returnNull = false)
{
$selParts = explode('.', $selectorStr);
$firstPart = array_shift($selParts);
$currentSel = $firstPart;
if ($this->dataPool->offsetExists($firstPart) === false) {
if ($returnNull === false) {
throw new TemplateEngineException('The data with offset "' . $currentSel . '" does not exist for template file ' . $this->currentTemplateFile);
}
return null;
}
$varData = $this->dataPool->offsetGet($firstPart);
foreach ($selParts as $part) {
$nextSel = $currentSel . '.' . $part;
// Try to find value in hashmap, thats faster then parse again
/*if($this->dataTable->offsetExists($nextSel)) {
$varData = $this->dataTable->offsetGet($nextSel);
continue;
}*/
if ($varData instanceof \ArrayObject === true) {
/** @var \ArrayObject $varData */
if ($varData->offsetExists($part) === false) {
throw new TemplateEngineException('Array key "' . $part . '" does not exist in ArrayObject "' . $currentSel . '"');
}
$varData = $varData->offsetGet($part);
} elseif (is_object($varData) === true) {
$args = array();
if (($argPos = strpos($part, '(')) !== false) {
$argStr = substr($part, $argPos + 1, -1);
$part = substr($part, 0, $argPos);
foreach (preg_split('/,/x', $argStr) as $no => $arg) {
if (StringUtils::startsWith($argStr, '\'') === false || StringUtils::endsWith($argStr, '\'') === false) {
$args[$no] = $this->getSelectorValue($argStr, $returnNull);
} else {
$args[$no] = substr($arg, 1, -1);
}
}
}
if (property_exists($varData, $part) === true) {
$getProperty = new \ReflectionProperty($varData, $part);
if ($getProperty->isPublic() === true) {
$varData = $varData->{$part};
} else {
$getterMethodName = null;
foreach ($this->getterMethodPrefixes as $mp) {
$getterMethodName = $mp . ucfirst($part);
if (method_exists($varData, $getterMethodName) === true) {
break;
}
$getterMethodName = null;
}
if ($getterMethodName === null) {
throw new TemplateEngineException('Could not access protected/private property "' . $part . '". Please provide a getter method');
}
$varData = call_user_func(array($varData, $getterMethodName));
}
} elseif (method_exists($varData, $part) === true) {
$varData = call_user_func_array(array($varData, $part), $args);
} else {
throw new TemplateEngineException('Don\'t know how to handle selector part "' . $part . '"');
}
} elseif (is_array($varData) === true) {
if (array_key_exists($part, $varData) === false) {
throw new TemplateEngineException('Array key "' . $part . '" does not exist in array "' . $currentSel . '"');
}
$varData = $varData[$part];
} else {
throw new TemplateEngineException('The data with offset "' . $currentSel . '" is not an object nor an array.');
}
$currentSel = $nextSel;
$this->dataTable->offsetSet($currentSel, $varData);
}
return $varData;
}
public function processRouteEdit()
{
$this->abortIfUserHasNotRights('CMS_ROUTES_EDIT');
//$coreModel = new CoreModel($this->db);
$pageModel = new PageModel($this->db);
$routeModel = new RouteModel($this->db);
$moduleModel = new ModuleModel($this->db);
$pageOptions = array();
foreach ($pageModel->getAllPages() as $p) {
$pageOptions[$p->ID] = $p->language_codeFK . ', ' . $p->title;
}
$routeOptions = array();
foreach ($routeModel->getAllRoutes() as $r) {
if ($r->ID == $this->route->getParam(0)) {
continue;
}
$routeOptions[$r->ID] = $r->pattern;
}
$moduleOptions = array();
foreach ($moduleModel->getModulesWithFrontendController() as $m) {
$routeOptions[$m->ID] = $m->ID;
}
$this->formHelper = new FormHelper(FormHelper::METHOD_POST);
$this->formHelper->addField('pattern', null, FormHelper::TYPE_STRING, true, array('missingError' => 'Please insert a pattern for this route'));
$this->formHelper->addField('page', null, FormHelper::TYPE_OPTION, false, array('invalidError' => 'Please select a valid page', 'options' => $pageOptions));
$this->formHelper->addField('robots', null, FormHelper::TYPE_STRING, false);
$this->formHelper->addField('regexp', null, FormHelper::TYPE_CHECKBOX);
$this->formHelper->addField('route_typ', null, FormHelper::TYPE_OPTION);
$this->formHelper->addField('redirect', null, FormHelper::TYPE_OPTION, false, array('invalidError' => 'Please select a valid page', 'options' => $pageOptions));
$this->formHelper->addField('module', null, FormHelper::TYPE_OPTION, false, array('invalidError' => 'Please select a valid module', 'options' => $moduleOptions));
if (!$this->formHelper->sent() || !$this->formHelper->validate()) {
return $this->getRouteEdit();
}
$patternStr = $this->formHelper->getFieldValue('pattern');
if (StringUtils::startsWith($patternStr, '/')) {
$this->formHelper->addError(null, 'The route can not start with a slash (/)');
return $this->getRouteEdit();
}
if (preg_match('@^[A-Za-z0-9\\-\\._/?#\\@&+=]+$@', $patternStr) === 0) {
$this->formHelper->addError(null, 'The route should only have alphanumeric characters and -._/?#@&+= in it');
return $this->getRouteEdit();
}
if ($patternStr === 'backend' || StringUtils::startsWith($patternStr, 'backend/') === true) {
$this->formHelper->addError(null, 'The route should not start with "backend/". This URI node is reserved by the CMS');
return $this->getRouteEdit();
}
// save settings
$routeTyp = $this->formHelper->getFieldValue('route_typ');
$stmntUpdate = $this->db->prepare("\n\t\t\tINSERT INTO route\n\t\t\t\tSET ID = ?, pattern = ?, regex = ?, page_IDFK = ?, mod_IDFK = ?, robots = ?, redirect_route_IDFK = ?\n\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\tpattern = ?, regex = ?, page_IDFK = ?, mod_IDFK = ?, robots = ?, redirect_route_IDFK = ?\n\n\t\t");
$resUpdate = $this->db->update($stmntUpdate, array($this->route->getParam(0), '/' . $patternStr, $this->formHelper->getFieldValue('regexp'), $routeTyp == 1 ? $this->formHelper->getFieldValue('page') : null, $this->formHelper->getFieldValue('module') == 0 ? null : $this->formHelper->getFieldValue('module'), $this->formHelper->getFieldValue('robots'), $routeTyp == 2 ? $this->formHelper->getFieldValue('redirect') : null, '/' . $patternStr, $this->formHelper->getFieldValue('regexp'), $routeTyp == 1 ? $this->formHelper->getFieldValue('page') : null, $this->formHelper->getFieldValue('module') == 0 ? null : $this->formHelper->getFieldValue('module'), $this->formHelper->getFieldValue('robots'), $routeTyp == 2 ? $this->formHelper->getFieldValue('redirect') : null));
RequestHandler::redirect('/backend/routes');
}
/**
* @param array $sqlParams The params for the SQL query of the renderer
*
* @return string The rendered HTML table
*
* @throws \Exception
*/
public function display(array $sqlParams = array())
{
$this->appendTableActions();
$textSearch = array();
$filterForm = false;
foreach ($this->columns as $c) {
/** @var Column $c */
if (!$c->isFilterable()) {
continue;
}
$filterForm = true;
if ($this->filtersApplied === false) {
break;
}
if ($c->getFilterable()->type === 'text') {
$keywordGroupQueryStr = null;
foreach ($this->keywords as $k) {
$compareWord = 'LIKE';
$prefix = ' OR ';
if (StringUtils::startsWith($k, '+')) {
$k = substr($k, 1);
$compareWord = 'LIKE';
$prefix = ' AND ';
} elseif (StringUtils::startsWith($k, '-')) {
$k = substr($k, 1);
$compareWord = 'NOT LIKE';
$prefix = ' AND ';
}
$keywordGroupQueryStr .= ($keywordGroupQueryStr !== null ? $prefix : null) . ($c->getSortSelector() === null ? $c->getSQLColumn() : $c->getSortSelector()) . " " . $compareWord . " ?";
$sqlParams[] = '%' . $k . '%';
}
if ($keywordGroupQueryStr === null) {
continue;
}
$textSearch[] = '(' . $keywordGroupQueryStr . ')';
}
}
$hasColumnFilter = false;
$columnFilterHtml = '<tr class="column-filters">';
$columnFilterSql = array();
foreach ($this->columns as $c) {
if ($c->getColumnFilter() === null) {
$columnFilterHtml .= '<th class="no-filter"> </th>';
continue;
}
$selection = isset($_SESSION['table'][$this->tableName]['filter'][$c->getColumnFilter()->getFilterName()]) ? $_SESSION['table'][$this->tableName]['filter'][$c->getColumnFilter()->getFilterName()] : null;
$hasColumnFilter = true;
$columnFilterHtml .= '<th>' . $c->getColumnFilter()->renderHtml($selection) . '</th>';
if (($filterSql = $c->getColumnFilter()->renderSql($c->getSortSelector() !== null ? $c->getSortSelector() : $c->getSQLColumn(), $selection)) !== null) {
$columnFilterSql[] = $filterSql;
$sqlParams = array_merge($sqlParams, (array) $selection);
}
}
if ($this->options !== null) {
$columnFilterHtml .= "\t\t<th class=\"no-filter\"> </th>\n";
}
$columnFilterHtml .= '</tr>';
$searchHtml = null;
$filterInfo = null;
if ($filterForm === true) {
$searchHtml = '<div class="table-data-search"><input type="hidden" name="table" value="' . $this->tableName . '"><input type="text" name="filter[keywords]" value="' . str_replace('"', '"', $this->keywordStr) . '" placeholder="' . $this->getText('Keywords') . '"><button type="submit">' . $this->getText('Go') . '</button></div>';
}
$whereConds = array();
if (count($textSearch) > 0) {
$whereConds[] = '(' . implode(' OR ', $textSearch) . ')';
$keywordsHtml = array();
foreach ($this->keywords as $k) {
$keywordsHtml[] = '<span class="' . $this->cssClass . '-keyword">' . $k . '</span>';
}
$filterInfo = ' (' . $this->getText('Result is filtered by keywords') . ': ' . implode(null, $keywordsHtml) . ')';
}
if ($this->filtersApplied) {
$filterInfo .= ' (<a href="?table=' . $this->tableName . '&resetfilters" class="table-reset-filters">' . $this->getText('reset filters') . '</a>)';
}
// filter
foreach ($columnFilterSql as $filterSql) {
$whereConds[] = '(' . $filterSql . ')';
}
if (count($whereConds) > 0) {
$this->sqlQuery .= ' WHERE ' . implode(' AND ', $whereConds);
}
if ($this->sortable !== null) {
$this->sqlQuery .= ' ORDER BY ' . $this->sortable['sort'];
} elseif ($this->orderBy !== null && isset($this->columns[$this->orderBy['column']]) === true) {
$this->sqlQuery .= ' ORDER BY ' . $this->columns[$this->orderBy['column']]->getSortSelector() . ' ' . $this->orderBy['sort'];
}
if (preg_match('/[\\s\\)]+FROM(?![^\\(]*\\)).*/ims', $this->sqlQuery, $fromMatches) === 0) {
throw new TableRendererException('No FROM found in query: ' . $this->sqlQuery);
}
$this->stmnt = $this->db->prepare("SELECT COUNT(*) total_records " . $fromMatches[0]);
$this->stmntLimited = $this->db->prepare($this->sqlQuery . " LIMIT ?,?");
$res = $this->db->select($this->stmnt, $sqlParams);
$entriesCount = $res[0]->total_records;
$resStart = ($this->currentPage - 1) * $this->pageLimit;
if ($resStart > $entriesCount) {
$resStart = 0;
}
$sqlParams[] = $resStart;
$sqlParams[] = $this->pageLimit;
$resLimited = $this->db->select($this->stmntLimited, $sqlParams);
$dataUriAttr = $this->ajaxUri !== null ? ' class="table-renderer-ajax" data-uri="' . $this->ajaxUri . '"' : null;
$tableHtml = '<div id="' . $this->tableName . '" ' . $dataUriAttr . '><form method="post" action="?table=' . $this->tableName . '#' . $this->tableName . '" class="' . $this->cssClass . '-filters">';
/*if($entriesCount <= 0)
return $tableHtml . $searchHtml . '<p class="' . $this->cssClass . '-info">' . $this->getText('No entries found.') . $filterInfo . '</p>';*/
if ($this->columns === null) {
$this->columns = $this->getColumnsByQuery($res);
}
$tableHtml .= $searchHtml;
// PAGINATION
$numPages = ceil($entriesCount / $this->pageLimit);
$tableHtml .= '<div class="table-pagination-wrapper">';
if ($numPages > 1) {
$tableHtml .= '<ul class="' . $this->cssClass . '-pagination">';
for ($i = 1; $i <= $numPages; ++$i) {
$active = $i == $this->currentPage ? ' class="active"' : null;
$tableHtml .= '<li><a href="?table=' . $this->tableName . '&page=' . $i . '#' . $this->tableName . '"' . $active . '>' . $i . '</a></li>';
}
$tableHtml .= '</ul>';
}
$tableHtml .= '</div>';
if ($this->displayInfo === true) {
$tableHtml .= "<p class=\"" . $this->cssClass . "-info\">" . sprintf($this->getText('There is <b>%d</b> entry.', 'There are <b>%d</b> entries.', $entriesCount), $entriesCount) . $filterInfo . "</p>\n";
}
$tableHtml .= "<table class=\"" . $this->cssClass . "\">\n\t<thead>\n\t<tr>\n";
if ($this->selectable === true) {
$tableHtml .= "\t\t<th class=\"header-selectable\"> </th>\n";
}
if ($this->reorder === true) {
$tableHtml .= "\t\t<th class=\"header-reorder\"> </th>\n";
}
foreach ($this->columns as $col) {
/** @var Column $col */
if ($col->isHidden() === true) {
continue;
}
if ($this->sortable === null && $col->isSortable()) {
$sortStr = $this->orderBy !== null && $this->orderBy['column'] == $col->getSQLColumn() && $this->orderBy['sort'] == 'ASC' ? 'DESC' : 'ASC';
$sortClass = null;
$sortFontIcon = '<i class="fa fa-sort"></i>';
if ($this->orderBy !== null && $this->orderBy['column'] == $col->getSQLColumn()) {
$sortFontIcon = '<i class="fa ' . ($this->orderBy['sort'] === 'ASC' ? 'fa-caret-up' : 'fa-caret-down') . '"></i>';
$sortClass = ' class="active-' . strtolower($this->orderBy['sort']) . '"';
}
$label = '<a href="?table=' . $this->tableName . '&sort=' . $col->getSQLColumn() . '-' . $sortStr . '#' . $this->tableName . '"' . $sortClass . '>' . $col->getLabel() . $sortFontIcon . '</a>';
} else {
$label = $col->getLabel();
}
$tableHtml .= "\t\t<th>" . $label . "</th>\n";
}
if ($this->options !== null) {
$tableHtml .= "\t\t<th> </th>\n";
}
$tableHtml .= '</tr>';
if ($hasColumnFilter) {
$tableHtml .= $columnFilterHtml;
}
$sortableClass = $this->sortable !== null ? ' class="sortable-table"' : null;
$tableHtml .= "\t</thead>\n\t<tbody" . $sortableClass . ">\n";
$optsHtml = $this->getOptsAsHtml();
$i = 0;
foreach ($resLimited as $r) {
$class = $i % 2 == 0 ? 'odd' : 'even';
$entryID = null;
if ($this->sortable !== null) {
$kcArr = array();
foreach ($this->sortable['key'] as $kc) {
$kcArr[] = $r->{$kc};
}
$entryID = 'id="sort-' . implode('-', $kcArr) . '" ';
}
$tableHtml .= "\t<tr " . $entryID . "class=\"" . $class . "\">\n";
if ($this->selectable === true) {
$tableHtml .= '<td class="selectable" style="vertical-align: middle;"><input type="checkbox" value="" name="' . $this->tableName . '[]"></td>';
}
if ($this->reorder === true) {
$tableHtml .= '<td class="reorder"><span>' . $this->getText('move') . '</span></td>';
}
foreach ($this->columns as $col) {
/** @var Column $col */
if ($col->isHidden() === true) {
continue;
}
// @TODO Generate sql query don't give it as param in constructor so we can move this code to trash
$sqlColumnIdentifier = StringUtils::afterFirst($col->getSQLColumn(), '.');
if ($sqlColumnIdentifier === '') {
$sqlColumnIdentifier = $col->getSQLColumn();
}
$value = $col->getSQLColumn() !== null ? $r->{$sqlColumnIdentifier} : null;
foreach ($col->getDecorators() as $d) {
/** @var ColumnDecorator $d */
$value = $d->modify($value, $r, $col->getSQLColumn(), $this);
}
if ($col->isFilterable() && $this->filtersApplied) {
foreach ($this->keywords as $k) {
if (StringUtils::startsWith($k, '+') || StringUtils::startsWith($k, '-')) {
$k = substr($k, 1);
}
$k = str_replace(array('/', '(', ')'), array('\\/', '\\(', '\\)'), $k);
// regex look behind if we're not in a html tag
$value = preg_replace('/(?![^<]*>)(' . $k . ')/ims', '<span class="' . $this->cssClass . '-highlighted">$1</span>', $value);
}
}
$cssClassesAttr = count($col->getCssClasses()) > 0 ? ' class="' . implode(' ', $col->getCssClasses()) . '"' : null;
$tableHtml .= "\t\t<td" . $cssClassesAttr . ">" . $value . "</td>\n";
}
$tableHtml .= $this->prepareOptLink($optsHtml, $r);
$tableHtml .= "\t</tr>\n";
++$i;
}
$tableHtml .= '</tbody></table>';
if ($this->selectable === true) {
$tableHtml .= '<p><a href="">delete</a> or <a href="">edit</a> choosen ones </p>';
}
return $tableHtml . '</form></div>';
}
/**
* @param string $selector
* @param BackendController $backendController
*
* @return mixed
*/
protected function getValues($selector, BackendController $backendController)
{
if (is_string($selector) === true) {
return StringUtils::endsWith($selector, '()') ? call_user_func(array($this, StringUtils::beforeLast($selector, '()')), $backendController) : $this->{$selector};
}
return $selector;
}
public function reorderElements(DB $db, CmsElement $movedCmsElement, $dropZoneID, array $elementOrder)
{
// Remove all from column
$colNo = (int) StringUtils::afterFirst($dropZoneID, 'column-') + 1;
$this->logger->debug('-- Reorder module in column: ' . $colNo);
$stmntRemove = $db->prepare("\n\t\t\tDELETE FROM element_column_layout_module WHERE col = ? AND page_IDFK = ? AND element_column_layout_IDFK = ?\n\t\t");
$deletedElements = $db->delete($stmntRemove, array($colNo, $this->pageID, $this->ID));
$this->logger->debug('Deleted ' . $deletedElements . ' elements');
// Remove the element itself (cause of PK crashes)
$stmntRemoveOriginal = $db->prepare("\n\t\t\tDELETE FROM element_column_layout_module WHERE element_column_layout_IDFK = ? AND page_IDFK = ? AND element_instance_IDFK = ?\n\t\t");
$deletedOriginal = $db->delete($stmntRemoveOriginal, array($this->ID, $movedCmsElement->getPageID(), $movedCmsElement->getID()));
$this->logger->debug('Deleted ' . $deletedOriginal . ' original element');
// Add the new order
$stmntInsert = $db->prepare("\n\t\t\tINSERT IGNORE INTO element_column_layout_module\n\t\t\t\tSET element_column_layout_IDFK = ?, page_IDFK = ?, col = ?, element_instance_IDFK = ?, sort = ?\n\t\t");
$stmntUpdate = $db->prepare("UPDATE cms_element_instance SET parent_mod_IDFK = ? WHERE ID = ?");
$this->logger->debug('Add those modules', array($elementOrder));
foreach ($elementOrder as $k => $e) {
$this->logger->debug('Added module: ' . $e);
$eParts = explode('-', $e);
if (isset($eParts[0]) === false) {
continue;
}
$db->update($stmntUpdate, array($this->ID, $eParts[0]));
$db->insert($stmntInsert, array($this->ID, $this->pageID, $colNo, $eParts[0], $k + 1));
}
}
public function postPageEdit($params)
{
$this->cmsController->abortIfUserHasNotRights('MOD_PAGES_EDIT');
$pageID = null;
$routeID = null;
if (isset($params[0]) === true) {
$pageID = (int) $params[0];
$routes = $this->routeModel->getRoutesByPageID($pageID);
if (count($routes) > 0) {
$routeData = array_shift($routes);
$routeID = $routeData->ID;
}
}
$coreModel = new CoreModel($this->cmsController->getDB());
$basePagesOpts = array(0 => '- no base page -');
foreach ($this->pageModel->getBasePagesForPage($pageID) as $p) {
$basePagesOpts[$p->ID] = $p->language_codeFK . ', ' . $p->title;
}
$this->formHelper = new FormHelper(FormHelper::METHOD_POST);
$this->formHelper->addField('title', null, FormHelper::TYPE_STRING, true, array('missingError' => 'Please insert a title for this page'));
$this->formHelper->addField('language', null, FormHelper::TYPE_OPTION, true, array('missingError' => 'Please select a language this page', 'invalidError' => 'Please select a valid language for this page', 'options' => $coreModel->getLanguages()));
$this->formHelper->addField('role', null, FormHelper::TYPE_OPTION, true, array('missingError' => 'Please select a role for this page', 'invalidError' => 'Please select a valid role for this page', 'options' => $this->getRoleOptions()));
$this->formHelper->addField('base_page', null, FormHelper::TYPE_OPTION, false, array('invalidError' => 'Please select a valid base page for this page', 'options' => $basePagesOpts));
$this->formHelper->addField('description', null, FormHelper::TYPE_STRING, false);
$this->formHelper->addField('inherit_rights', null, FormHelper::TYPE_CHECKBOX);
if (!$this->formHelper->sent() || !$this->formHelper->validate()) {
return $this->getPageEdit($params);
}
$pageRole = $this->formHelper->getFieldValue('role');
// Role specific form checks
if ($pageRole === 'error') {
$this->formHelper->addField('error_code', null, FormHelper::TYPE_OPTION, true, array('missingError' => 'Please select an error code for this page', 'invalidError' => 'Please select a valid error code for this page', 'options' => $this->getErrorCodeOptions()));
}
if (in_array($pageRole, array('page', 'module')) === true) {
// Route
$this->formHelper->addField('route', null, FormHelper::TYPE_STRING, true, array('missingError' => 'Please insert a title for this page'));
$this->formHelper->addField('ssl', null, FormHelper::TYPE_OPTION, true, array('missingError' => 'Please choose an SSL option', 'invalidError' => 'Please choose a valid SSL option', 'options' => $this->getSSLOptions()));
}
if ($pageRole === 'module') {
$this->formHelper->addField('module', null, FormHelper::TYPE_OPTION, true, array('missingError' => 'Please choose a module', 'invalidError' => 'Please choose a valid module', 'options' => $this->getModuleOptions()));
}
if (!$this->formHelper->validate()) {
return $this->getPageEdit($params);
}
$stmntCheckErrorCode = $this->cmsController->getDB()->prepare("\n\t\t\tSELECT ID FROM page WHERE error_code = ?\n\t\t");
$errorCode = $this->formHelper->getFieldValue('error_code');
$resCheckErrorCode = $this->cmsController->getDB()->select($stmntCheckErrorCode, array($errorCode));
if (count($resCheckErrorCode) > 0 && $resCheckErrorCode[0]->ID != $pageID) {
$this->formHelper->addError('error_code', 'There is already an error page (#' . $resCheckErrorCode[0]->ID . ') for error case ' . $errorCode);
}
if ($this->formHelper->hasErrors()) {
return $this->getPageEdit($params);
}
// save settings
$layoutIDFK = null;
if ($this->formHelper->getFieldValue('base_page') !== null) {
$stmntLayout = $this->cmsController->getDB()->prepare("SELECT layout_IDFK FROM page WHERE ID = ?");
$resLayout = $this->cmsController->getDB()->select($stmntLayout, array($this->formHelper->getFieldValue('base_page')));
if (count($resLayout) > 0) {
$layoutIDFK = $resLayout[0]->layout_IDFK;
}
}
try {
$stmntUpdate = $this->cmsController->getDB()->prepare("\n\t\t\t\tINSERT INTO page SET\n\t\t\t\t\tID = ?, title = ?, language_codeFK = ?, description = ?, base_page_IDFK = ?, layout_IDFK = ?, inhert_rights = ?, creator_IDFK = ?, created = NOW(), role = ?, error_code = ?, uniqid = ?\n\t\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\t\ttitle = ?, language_codeFK = ?, description = ?, base_page_IDFK = ?, layout_IDFK = ?, inhert_rights = ?, modifier_IDFK = ?, role = ?, error_code = ?, last_modified = NOW()\n\t\t\t");
$basePageParam = $this->formHelper->getFieldValue('base_page') != 0 ? $this->formHelper->getFieldValue('base_page') : null;
$msgKey = 'updated';
$this->cmsController->getDB()->update($stmntUpdate, array($pageID, $this->formHelper->getFieldValue('title'), $this->formHelper->getFieldValue('language'), $this->formHelper->getFieldValue('description'), $basePageParam, $layoutIDFK, $this->formHelper->getFieldValue('inherit_rights'), $this->cmsController->getAuth()->getUserID(), $this->formHelper->getFieldValue('role'), $this->formHelper->getFieldValue('error_code'), uniqid(), $this->formHelper->getFieldValue('title'), $this->formHelper->getFieldValue('language'), $this->formHelper->getFieldValue('description'), $basePageParam, $layoutIDFK, $this->formHelper->getFieldValue('inherit_rights'), $this->cmsController->getAuth()->getUserID(), $this->formHelper->getFieldValue('role'), $this->formHelper->getFieldValue('error_code')));
if ($pageID === null) {
$pageID = $this->cmsController->getDB()->lastInsertId();
$msgKey = 'created';
}
// Route things
$ssl = $this->formHelper->getFieldValue('ssl');
$sslRequired = 0;
$sslForbidden = 0;
if ($ssl === 'required') {
$sslRequired = 1;
} elseif ($ssl === 'forbidden') {
$sslForbidden = 1;
}
$modID = null;
if ($pageRole === CmsPage::ROLE_MODULE) {
$modID = $this->formHelper->getFieldValue('module');
}
if (in_array($pageRole, array(CmsPage::ROLE_STANDARD, CmsPage::ROLE_MODULE)) === true) {
$formPattern = $this->formHelper->getFieldValue('route');
if (StringUtils::startsWith($formPattern, '/') === false) {
$formPattern = '/' . $formPattern;
}
$stmntRouteUpdate = $this->cmsController->getDB()->prepare("\n\t\t\t\t\tINSERT INTO route SET\n\t\t\t\t\t\tID = ?, pattern = ?, page_IDFK = ?, ssl_required = ?, ssl_forbidden = ?, mod_IDFK = ?, regex = 0\n\t\t\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\t\t\tpattern = ?, page_IDFK = ?, ssl_required = ?, ssl_forbidden = ?, mod_IDFK = ?\n\t\t\t\t");
$this->cmsController->getDB()->update($stmntRouteUpdate, array($routeID, $formPattern, $pageID, $sslRequired, $sslForbidden, $modID, $formPattern, $pageID, $sslRequired, $sslForbidden, $modID));
}
} catch (\Exception $e) {
$this->formHelper->addError(null, $e->getMessage());
return $this->getPageEdit($params);
}
$this->setMessageKeyForNextPage($msgKey);
RequestHandler::redirect($this->baseLink . '/page/' . $pageID);
}
public function afterMutation(DB $db, PDOStatement $stmnt, array $params, $queryType)
{
$cond = null;
if (preg_match('/^\\s*(SELECT|UPDATE|DELETE\\s+FROM|INSERT\\s+INTO|INSERT\\s+IGNORE|REPLACE\\s+INTO)\\s+(.+?)\\s+(?:SET\\s+(.+))?(?:ON DUPLICATE KEY UPDATE|WHERE\\s+(.+))?$/ims', $stmnt->queryString, $mT) === false) {
throw new CMSException('Revision control could not parse sql statement: ' . $stmnt->queryString);
}
$sqlFunction = $mT[1];
$sqlTable = trim($mT[2]);
$sqlColumns = isset($mT[3]) ? $mT[3] : null;
$sqlCond = isset($mT[4]) ? $mT[4] : null;
if (in_array($sqlFunction, array('REPLACE INTO', 'INSERT INTO', 'UPDATE', 'INSERT IGNORE'))) {
$resPK = $this->getPKColumnsForTable($db, $sqlTable);
$pkArray = array();
foreach ($resPK as $pk) {
$pkArray[] = $pk . ' = ?';
}
// params
$cols = explode(',', $sqlColumns);
$colsArr = array();
$pkArr = array();
$i = 0;
foreach ($cols as $c) {
$colClean = trim(preg_replace('/=\\s*\\?/', null, $c)) . ' = ?';
$colsArr[] = $colClean;
if (in_array($colClean, $pkArray)) {
$pkArr[] = $params[$i];
}
++$i;
}
$joinedArr = array_intersect($colsArr, $pkArray);
if (count($joinedArr) <= 0) {
return;
}
$cond = implode(' AND ', $joinedArr);
} elseif (in_array($sqlFunction, array('SELECT'))) {
// ignore
return;
} else {
//var_dump($mT); exit;
$offsetParams = substr_count(StringUtils::beforeLast($stmnt->queryString, 'WHERE'), '?');
$anzParams = substr_count($sqlCond, '?');
$pkArr = array_slice($params, $offsetParams, $anzParams);
$cond = trim($sqlCond);
}
$revSql = "SELECT * FROM " . $sqlTable . " WHERE " . $cond;
try {
$stmntRev = $db->prepare($revSql);
$resRev = $db->select($stmntRev, $pkArr);
if (count($resRev) <= 0) {
return;
}
$xmlStr = "\t" . '<table name="' . $sqlTable . '" exectime="' . date('Y-m-d H:i:s') . '">' . "\n";
$xmlStr .= "\t\t" . '<records>' . "\n";
foreach ($resRev as $r) {
$xmlStr .= "\t\t\t" . '<record>' . "\n";
$xmlStr .= "\t\t\t\t" . '<fields>' . "\n";
foreach ($r as $col => $val) {
$xmlStr .= "\t\t\t\t\t" . '<field name="' . $col . '"><![CDATA[' . $val . ']]></field>' . "\n";
}
$xmlStr .= "\t\t\t\t" . '</fields>' . "\n";
$xmlStr .= "\t\t\t" . '</record>' . "\n";
}
$xmlStr .= "\t\t" . '</records>' . "\n";
$xmlStr .= "\t" . '</table>' . "\n";
if ($db->inTransaction() === true) {
$this->cachedXML .= $xmlStr;
return;
}
$this->saveOldRevision($xmlStr, $sqlTable . '.' . implode('-', $pkArr));
} catch (DBException $e) {
$this->logger->error('Problem with generated statement: ' . $e->getQueryString(), $e);
throw $e;
}
}