public function getGlobalNavSection(Sitengine_Translate $translate, array $queries, $current, $selectorPrefix = '')
{
$selected = '';
$items = array();
$location = 'backendHome';
$items[$queries[$location]] = '> ' . $translate->translate('labels' . ucfirst($location));
$items['separator10'] = '----------------';
$location = 'protoBackendGoodies';
$items[$queries[$location]] = '> ' . $translate->translate('labels' . ucfirst($location));
$selected = $current == 'protoBackendGoodies' ? $queries[$location] : $selected;
$n = 'globalNav';
require_once 'Sitengine/Form/Element.php';
$e = new Sitengine_Form_Element('', $selected);
$e->setScript('onchange="if(!this.options[this.selectedIndex].value.match(/^separator/)) { window.location=this.options[this.selectedIndex].value; }"');
$e->setClass($selectorPrefix . 'Select');
$e->setId($selectorPrefix . $n);
return array('ITEMS' => $items, 'menu' => $e->getSelect($items));
}
protected function _getMainSection()
{
try {
$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE);
$filter = $this->_controller->getViewHelper()->getListFilterInstance();
$sorting = $this->_controller->getViewHelper()->getSortingInstance();
########################################################################
#### SETTINGS
########################################################################
$settingsIsActive = false;
$settingsElements = array();
### transcript element ###
$transcripts = $this->_controller->getTranscripts();
$transcripts->setLanguage($this->_controller->getPreferences()->getTranscript());
if (!$transcripts->isDefault()) {
$settingsIsActive = true;
}
# set html input element
$languages = array();
foreach ($this->_controller->getTranscripts()->get() as $symbol) {
$languages[$symbol] = $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol));
}
$e = new Sitengine_Form_Element(Sitengine_Env::PARAM_TRANSCRIPT, $this->_controller->getTranscripts()->getSymbol());
$e->setId('settings' . Sitengine_Env::PARAM_TRANSCRIPT);
$e->setClass('settingsSelect');
$settingsElements[Sitengine_Env::PARAM_TRANSCRIPT] = $e->getSelect($languages);
### ipp element ###
$defaultIpp = 20;
$valueIpp = $this->_controller->getPreferences()->getItemsPerPage();
$valueIpp = is_numeric($valueIpp) ? $valueIpp : $defaultIpp;
$valueIpp = $valueIpp <= 100 && $valueIpp >= 1 ? $valueIpp : $defaultIpp;
# set html input element
$ippValues = array('' => $this->_controller->getTranslate()->translate('labelsSettingsSectionItemsPerPage'), 5 => 5, 10 => 10, 20 => 20, 50 => 50, 100 => 100);
$e = new Sitengine_Form_Element(Sitengine_Env::PARAM_IPP, $valueIpp);
$e->setId('settings' . Sitengine_Env::PARAM_IPP);
$e->setClass('settingsSelect');
$settingsElements[Sitengine_Env::PARAM_IPP] = $e->getSelect($ippValues);
$hiddens = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder());
foreach ($hiddens as $k => $v) {
$hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v);
}
$settingsData = array('isActive' => $settingsIsActive, 'hiddens' => implode('', $hiddens), 'ELEMENTS' => $settingsElements);
########################################################################
#### FILTER
########################################################################
$e = new Sitengine_Form_Element(Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_TYPE, $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_TYPE));
$e->setId('filter' . Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_TYPE);
$e->setClass('filterSelect');
$filter->setElement(Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_TYPE, $e->getSelect($this->_controller->getTranslate()->translateGroup('fieldValsFilterByType')->toArray()));
$e = new Sitengine_Form_Element(Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_FIND, $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_FIND));
$e->setId('filter' . Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_FIND);
$e->setClass('filterText');
$filter->setElement(Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_BY_FIND, $e->getText(20));
$hiddens = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder());
foreach ($hiddens as $k => $v) {
$hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v);
}
$args = array(Sitengine_Env::PARAM_ACTION => $this->_controller->getRequest()->getActionName(), Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Sitemap_Backend_Controller::PARAM_FILTER_RESET => 1);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$filterData = array('isActive' => $filter->isActive(), 'uriReset' => $uriReset, 'hiddens' => implode('', $hiddens), 'ELEMENTS' => $filter->getElements());
########################################################################
#### SORTING
########################################################################
$queries = array();
foreach ($sorting->getOrdering() as $field => $order) {
$args = array(Sitengine_Env::PARAM_ACTION => $this->_controller->getRequest()->getActionName(), Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
}
$sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns());
########################################################################
#### PAGER
########################################################################
$pager = new Sitengine_Grid_Pager($valuePage, $valueIpp);
########################################################################
#### LISTQUERY
########################################################################
$q = 'SELECT';
$q .= ' id,';
$q .= ' locked,';
#$q .= ' enabled,';
$q .= ' cdate,';
$q .= ' mdate,';
$q .= ' keyword,';
$q .= ' type,';
$q .= ' file1OriginalName,';
$q .= ' file1OriginalSource,';
$q .= ' file1ThumbnailName,';
$q .= ' file1ThumbnailWidth,';
$q .= ' file1ThumbnailHeight,';
$q .= ' file1ThumbnailMime,';
$q .= ' file1ThumbnailSize,';
$q .= ' IF(htmlLang' . $this->_controller->getTranscripts()->getIndex() . '="", htmlLang' . $this->_controller->getTranscripts()->getDefaultIndex() . ', htmlLang' . $this->_controller->getTranscripts()->getIndex() . ') AS html,';
$q .= ' IF(htmlLang' . $this->_controller->getTranscripts()->getIndex() . '="", 1, 0) AS transcriptMissing';
$q .= ' FROM';
$q .= ' ' . $this->_controller->getFrontController()->getSitemapPackage()->getTableSitemap();
$q .= ' WHERE';
$q .= ' pid = "' . $this->_controller->getEntity()->getParentId() . '"';
#$q .= ' AND '.Sitengine_Permiso::FIELD_OID.' = "'.$this->_controller->getPermiso()->getOrganization()->getId().'"';
$q .= $filter->getSql();
$q .= $this->_controller->getPermiso()->getDac()->getReadAccessSql($this->_controller->getAuthorizedGroups());
$q .= $sorting->getClause(true);
$sql = $this->_controller->getDatabase()->limit($q, $valueIpp, $pager->getOffset());
$statement = $this->_controller->getDatabase()->prepare($sql);
$statement->execute();
$list = $statement->fetchAll();
if ($pager->getCurrPage() > 1 && !sizeof($list)) {
# current page is out of bounds - go to beginning of list
$pager = new Sitengine_Grid_Pager(1, $valueIpp);
$sql = $this->_controller->getDatabase()->limit($q, $valueIpp, 0);
$statement = $this->_controller->getDatabase()->prepare($sql);
$statement->execute();
$list = $statement->fetchAll();
}
#print $sql;
#Sitengine_Debug::print_r($list);
# count full result
$q = preg_replace('/SELECT .* FROM/', 'SELECT COUNT(*) AS count FROM', $q);
$q = preg_replace('/ORDER BY .*/', '', $q);
$statement = $this->_controller->getDatabase()->prepare($q);
$statement->execute();
$result = $statement->fetchAll();
$pager->calculate($result[0]['count']);
########################################################################
#### LISTDATA
########################################################################
$markedRows = $this->_controller->getMarkedRows();
foreach ($list as $count => $row) {
# row selector checkbox
if ($row['locked']) {
$row['rowSelectCheckbox'] = ' ';
} else {
$p = 'SELECTROWITEM' . $row['id'];
$s = sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($p) : 0;
$e = new Sitengine_Form_Element($p, 1);
$e->setClass('listformCheckbox');
$row['rowSelectCheckbox'] = $e->getCheckbox($s);
}
$n = 'locked';
$p = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id'];
$h = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id'];
$s = sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($p) : $row[$n];
$e = new Sitengine_Form_Element($p, 1);
$e->setClass('listformCheckbox');
$locked = $e->getCheckbox($s);
$locked .= Sitengine_Form_Element::getHidden($h, $row[$n]);
/*
if($row['type']==Sitengine_Sitemap::ITEMTYPE_LAYER) { $enabled = ' '; }
else {
$n = 'enabled';
$p = 'UPDATEROWITEM'.$n.'ITEMID'.$row['id'];
$h = 'UPDATEROWITEMCURRENT'.$n.'ITEMID'.$row['id'];
$s = (sizeof($markedRows) && isset($markedRows[$row['id']])) ? $this->_controller->getRequest()->getPost($p) : $row[$n];
$e = new Sitengine_Form_Element($p, 1);
$e->setClass('listformCheckbox');
$enabled = $e->getCheckbox($s);
$enabled .= Sitengine_Form_Element::getHidden($h, $row[$n]);
}
*/
$row['childCount'] = 0;
$row['fileCount'] = 0;
$row['indexAction'] = '';
# uris
switch ($row['type']) {
case Sitengine_Sitemap::ITEMTYPE_FILE:
$updateDirective = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATEFILE;
break;
case Sitengine_Sitemap::ITEMTYPE_PAGE:
$updateDirective = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATEPAGE;
break;
case Sitengine_Sitemap::ITEMTYPE_MASK:
$updateDirective = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATEMASK;
break;
case Sitengine_Sitemap::ITEMTYPE_LAYER:
$updateDirective = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATELAYER;
break;
case Sitengine_Sitemap::ITEMTYPE_SNIPPET:
$updateDirective = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATESNIPPET;
break;
}
$args = array(Sitengine_Env::PARAM_ACTION => $updateDirective, Sitengine_Env::PARAM_ID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_INDEX, Sitengine_Env::PARAM_PARENTID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriChildIndex = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_NEWPAGE, Sitengine_Env::PARAM_PARENTID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriChildNewPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_NEWFILE, Sitengine_Env::PARAM_PARENTID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriChildNewFile = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_NEWMASK, Sitengine_Env::PARAM_PARENTID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriChildNewMask = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_NEWLAYER, Sitengine_Env::PARAM_PARENTID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriChildNewLayer = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_NEWSNIPPET, Sitengine_Env::PARAM_PARENTID => $row['id']);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriChildNewSnippet = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
if ($row['type'] == Sitengine_Sitemap::ITEMTYPE_PAGE || $row['type'] == Sitengine_Sitemap::ITEMTYPE_MASK) {
$row['childCount'] = $this->_controller->getViewHelper()->countChildren($row['id']);
$indexActions = array('' => $this->_controller->getTranslate()->translate('labelsListformElementActionTitleFiles') . ' (' . $row['childCount'] . ')', $uriUpdate => $this->_controller->getTranslate()->translate('labelsListformElementActionUpdate'), $uriChildIndex => $this->_controller->getTranslate()->translate('labelsListformElementActionChildIndex'), $uriChildNewFile => $this->_controller->getTranslate()->translate('labelsListformElementActionNewFile'), $uriChildNewSnippet => $this->_controller->getTranslate()->translate('labelsListformElementActionNewSnippet'));
$e = new Sitengine_Form_Element('functions_' . $row['id'], '');
$e->setScript('onchange="window.location=this.options[this.selectedIndex].value;"');
$e->setClass('listformSelect');
$e->setId('listform' . $n);
$row['indexAction'] = $e->getSelect($indexActions);
} else {
if ($row['type'] == Sitengine_Sitemap::ITEMTYPE_LAYER) {
$row['childCount'] = $this->_controller->getViewHelper()->countChildren($row['id']);
$indexActions = array('' => $this->_controller->getTranslate()->translate('labelsListformElementActionTitle') . ' (' . $row['childCount'] . ')', $uriUpdate => $this->_controller->getTranslate()->translate('labelsListformElementActionUpdate'), $uriChildIndex => $this->_controller->getTranslate()->translate('labelsListformElementActionChildIndex'), $uriChildNewLayer => $this->_controller->getTranslate()->translate('labelsListformElementActionNewLayer'), $uriChildNewPage => $this->_controller->getTranslate()->translate('labelsListformElementActionNewPage'), $uriChildNewSnippet => $this->_controller->getTranslate()->translate('labelsListformElementActionNewSnippet'), $uriChildNewFile => $this->_controller->getTranslate()->translate('labelsListformElementActionNewFile'));
$e = new Sitengine_Form_Element('functions_' . $row['id'], '');
$e->setScript('onchange="window.location=this.options[this.selectedIndex].value;"');
$e->setClass('listformSelect');
$e->setId('listform' . $n);
$row['indexAction'] = $e->getSelect($indexActions);
}
}
$row['isMarked'] = isset($markedRows[$row['id']]) ? $markedRows[$row['id']] : 0;
$row['lockedCheckbox'] = $locked;
#$row['enabledCheckbox'] = $enabled;
$row['uriUpdate'] = $uriUpdate;
$row['uriChildIndex'] = $uriChildIndex;
$name = 'cdate';
$date = new Zend_Date($row[$name], Zend_Date::ISO_8601, $this->_controller->getLocale());
$date->setTimezone($this->_controller->getPreferences()->getTimezone());
$row[$name] = $date->get(Zend_Date::DATE_LONG, $this->_controller->getLocale()) . ' ';
$row[$name] .= $date->get(Zend_Date::TIME_LONG, $this->_controller->getLocale());
$list[$count] = $row;
}
########################################################################
#### PAGER DATA
########################################################################
$hiddens = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder());
foreach ($hiddens as $k => $v) {
$hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v);
}
$args = array(Sitengine_Env::PARAM_ACTION => $this->_controller->getRequest()->getActionName(), Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Env::PARAM_PAGE => $pager->getPrevPage());
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_ACTION => $this->_controller->getRequest()->getActionName(), Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Env::PARAM_PAGE => $pager->getNextPage());
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$currPageInput = new Sitengine_Form_Element(Sitengine_Env::PARAM_PAGE, $pager->getCurrPage());
$currPageInput->setClass('pagerInput');
$pagerData = array('hiddens' => implode('', $hiddens), 'currPageInput' => $currPageInput->getText(2), 'currPage' => $pager->getCurrPage(), 'nextPage' => $pager->getNextPage(), 'prevPage' => $pager->getPrevPage(), 'numPages' => $pager->getNumPages(), 'numItems' => $pager->getNumItems(), 'firstItem' => $pager->getFirstItem(), 'lastItem' => $pager->getLastItem(), 'uriPrevPage' => $uriPrevPage, 'uriNextPage' => $uriNextPage);
########################################################################
#### URIS
########################################################################
$args = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_DOBATCHDELETE);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriDoBatchDelete = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$args = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_DOBATCHUPDATE);
$route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX);
$uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true);
$uris = array('submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate);
########################################################################
#### COLLECT ALL DATA
########################################################################
$hiddens = array(Sitengine_Env::PARAM_PAGE => $valuePage, Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder());
foreach ($hiddens as $k => $v) {
$hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v);
}
$formTitle = $this->_controller->getEntity()->isRootLevel() ? 'listformRootTitle' : 'listformTitle';
return array('hiddens' => implode('', $hiddens), 'title' => $this->_controller->getTranslate()->translate('labels' . ucfirst($formTitle)), 'URIS' => $uris, 'FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData);
} catch (Exception $exception) {
require_once 'Sitengine/Sitemap/Backend/Exception.php';
throw new Sitengine_Sitemap_Backend_Exception('list page error', $exception);
}
}
