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); } }