public function getLoginSection() { require_once 'Sitengine/Form/Element.php'; $hiddens = array(Sitengine_Env::PARAM_TARGET => $this->_controller->getRequest()->getParam(Sitengine_Env::PARAM_TARGET)); foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('handler' => $this->_controller->getRequest()->getParam(Sitengine_Env::PARAM_HANDLER), 'hiddens' => implode('', $hiddens)); }
protected function _getFormSection() { $input = $this->_controller->getRequest()->getPost(null); ######################################################################## #### FILTER INPUT ######################################################################## $fields = array('firstname' => '', 'lastname' => '', 'email' => '', 'message' => '', 'subscribeNewsletter' => 0); $data = Sitengine_Controller_Request_Http::filterInsert(sizeof($input), $input, $fields); #Sitengine_Debug::print_r($data); $hiddens = array(); $args = array(Sitengine_Env::PARAM_ACTION => Sitengine_FormToMail_Default_Controller::ACTION_SENDMAIL); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_FormToMail_Front::ROUTE_INDEX); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'DATA' => $data); }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getBlogPackage()->getFilesTable(); $table->setTranscript($this->_controller->getPreferences()->getTranscript()); $transcripts = $table->getTranscripts(); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('id' => '', 'mdate' => '', 'sorting' => ''); foreach ($transcripts->get() as $index => $symbol) { $fieldsNormal['titleLang' . $index] = ''; $fieldsNormal['markupLang' . $index] = ''; } $fieldsOnOff = array('publish' => 1); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($transcripts); $payloads->start($this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAYLOAD_NAME)); $stored = $this->_controller->getFrontController()->getBlogPackage()->getFilesTable()->complementRow($this->_controller->getEntity()->getRow()); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); */ /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); */ $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_SHARP); $queryUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName(), Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $stored['titleLang' . $transcripts->getIndex()]; $title = $title != '' ? $title : $stored['titleLang0']; $n = 'uri'; $e = new Sitengine_Form_Element($n, preg_replace('/&/', '&', $stored['file1OriginalUri'])); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getText(60); } else { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($transcripts); $payloads->start(); $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getFrontController()->getBlogPackage()->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = !is_null($gid) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); # set some defaults... $n = 'sorting'; if (array_key_exists($n, $input)) { $data[$n] = $input[$n]; } else { $q = 'SELECT MAX(sorting) AS maxSorting FROM ' . $this->_controller->getFrontController()->getBlogPackage()->getFilesTableName(); $q .= ' WHERE '; #.Sitengine_Permiso::FIELD_OID.' = "'.$this->_controller->getPermiso()->getOrganization()->getId().'"'; $q .= ' parentId = "' . $this->_controller->getEntity()->getAncestorId() . '"'; $statement = $this->_controller->getDatabase()->prepare($q); $statement->execute(); $result = $statement->fetchAll(); $data[$n] = $result[0]['maxSorting'] + 10; } $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName()); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $type = $this->_controller->getEntity()->getAncestorType(); if ($type == Sitengine_Blog_Posts_Table::TYPE_GALLERY) { $title = $this->_controller->getTranslate()->translate('labelsViewformInsertPhotoTitle'); } else { $title = $this->_controller->getTranslate()->translate('labelsViewformInsertFileTitle'); } } #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## if ($payloads->isMain()) { /* if( (!$data['id']) || # on insert (isset($data[Sitengine_Permiso::FIELD_UID]) && $data[Sitengine_Permiso::FIELD_UID]==$this->_controller->getPermiso()->getAuth()->getId()) || # owners ok #$this->_controller->getPermiso()->getUser()->hasSupervisorRights() || # supervisors ok #$this->_controller->getPermiso()->getUser()->hasModeratorRights() # moderators ok $this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS) ) { $n = Sitengine_Permiso::FIELD_UID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $elements[$n] = $e->getSelect($users); $n = Sitengine_Permiso::FIELD_GID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $groups = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsGid')->toArray(), $groups); $elements[$n] = $e->getSelect($groups); $n = Sitengine_Permiso::FIELD_RAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_RAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); } */ $n = 'titleLang' . $transcripts->getDefaultIndex(); $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements['title'] = $e->getText(40); $n = 'publish'; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm' . $n); $elements[$n] = $e->getCheckbox($data[$n]); $n = 'sorting'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getText(5); $n = 'file1Original'; $e = new Sitengine_Form_Element($n); $e->setClass('viewFormFile'); $e->setId('viewForm' . $n); $elements[$n] = $e->getFile(40); } $n = 'titleLang' . $payloads->getTranscriptIndex(); $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements['title'] = $e->getText(40); #$n = 'markupLang'.$payloads->getTranscriptIndex(); #$elements['markup'] = $this->_makeTextarea($n, $data[$n]); $n = 'markupLang' . $payloads->getTranscriptIndex(); $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormTextarea'); $e->setId('markupTextarea'); $elements['markup'] = $e->getTextarea(40, 10); ######################################################################## #### CONTENT PAYLOAD SECTION TITLE ######################################################################## $contentSectionTitle = $this->_controller->getTranslate()->translate('labelsViewformContentSectionTitleDefault'); if (sizeof($transcripts->get()) > 1) { if (!$payloads->isMain()) { $symbol = $payloads->getTranscriptSymbol(); } else { $symbol = $transcripts->getDefaultSymbol(); } $contentSectionTitle .= ' (' . $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)) . ')'; } ######################################################################## #### PAYLOAD NAV DATA ######################################################################## $payloadNav = array(); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $query = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getMainName()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uri .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $payloadNav[$payloads->getMainName()] = array('uri' => $uri, 'label' => $this->_controller->getTranslate()->translate('labelsViewformPayloadNavTitleMain')); $count = 0; foreach ($transcripts->get() as $index => $symbol) { # skip default transcript because all fields are available in the overview if ($count) { $currentPayload = $payloads->getTranscriptNamePrefix() . '_' . $symbol; $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $query = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $currentPayload); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uri .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); if (sizeof($transcripts->get()) > 1) { $label = $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)); } else { $label = $this->_controller->getTranslate()->translate('labelsViewformContentSectionTitleDefault'); } $payloadNav[$currentPayload] = array('uri' => $uri, 'label' => $label); } $count++; } } ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('payloadName' => $payloads->getName(), 'payloadIsMain' => $payloads->isMain(), 'payloadIsDefaultTranscript' => $payloads->isDefaultTranscript(), 'queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'contentSectionTitle' => $contentSectionTitle, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'PAYLOADNAV' => $payloadNav, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Blog/Backend/Blogs/Posts/Files/Exception.php'; throw new Sitengine_Blog_Backend_Blogs_Posts_Files_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getNewsletterPackage()->getAttachmentsTable(); $filter = $table->getFilterInstance($this->_controller->getRequest(), array('find' => Sitengine_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_BY_FIND, 'reset' => Sitengine_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $sorting = $table->getSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; $settingsElements = array(); ### 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('indexViewSettingsSectionItemsPerPage'), 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_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_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_BY_FIND, $filter->getVal(Sitengine_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_BY_FIND)); $e->setId('filter' . Sitengine_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_BY_FIND); $e->setClass('filterText'); $filter->setElement(Sitengine_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_BY_FIND, $e->getText(20)); $hiddens = array(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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Newsletter_Backend_Campaigns_Attachments_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); ######################################################################## #### LISTQUERY ######################################################################## $name = $this->_controller->getFrontController()->getNewsletterPackage()->getAttachmentsTableName(); $whereClauses = array($this->_controller->getDatabase()->quoteInto('campaignId = ?', $this->_controller->getEntity()->getAncestorId()), $this->_controller->getPermiso()->getDac()->getReadAccessSql($this->_controller->getFrontController()->getNewsletterPackage()->getAuthorizedGroups(), $name, false), $filter->getSql('')); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } # count total number of records $select = $table->select()->from($table, array('COUNT(*) AS count')); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $count = $table->fetchRow($select); $pager->calculate($count->count); ######################################################################## #### LISTDATA ######################################################################## $markedRows = $this->_controller->getMarkedRows(); $list = array(); foreach ($items as $item) { $row = $table->complementRow($item); # row selector checkbox $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); $fileUrl = $row['file1OriginalUri']; $e = new Sitengine_Form_Element('fileUrl', preg_replace('/&/', '&', $fileUrl)); $e->setClass('listformText'); $row['file1OriginalElement'] = $e->getText(80); # uris $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $row['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS_SHARP); $row['uriUpdate'] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $row['isMarked'] = isset($markedRows[$row['id']]) ? $markedRows[$row['id']] : 0; $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[] = $row; } ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS_BATCH); $uriDoBatchDelete = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS_BATCH); $uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uris = array('submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate); ######################################################################## #### METHODS ######################################################################## $methods = array('doBatchDelete' => Sitengine_Env::METHOD_DELETE, 'doBatchUpdate' => Sitengine_Env::METHOD_PUT); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array(Sitengine_Env::PARAM_METHOD => '', 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); } return array('hiddens' => implode('', $hiddens), 'title' => $this->_controller->getTranslate()->translate('indexViewTitle'), 'URIS' => $uris, 'METHODS' => $methods, 'FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Newsletter/Backend/Campaigns/Attachments/Exception.php'; throw new Sitengine_Newsletter_Backend_Campaigns_Attachments_Exception('list page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getProtoPackage()->getCouldiesTable(); $table->setTranscript($this->_controller->getPreferences()->getTranscript()); $transcripts = $table->getTranscripts(); $displayPermissionSettings = false; ######################################################################## #### FILTER INPUT ######################################################################## $fields = array('id' => '', Sitengine_Permiso::FIELD_UID => '', Sitengine_Permiso::FIELD_GID => '', Sitengine_Permiso::FIELD_RAG => 1, Sitengine_Permiso::FIELD_RAW => 1, Sitengine_Permiso::FIELD_UAG => 1, Sitengine_Permiso::FIELD_UAW => 0, Sitengine_Permiso::FIELD_DAG => 1, Sitengine_Permiso::FIELD_DAW => 0, 'mdate' => '', 'type' => 'fan', 'sorting' => '', 'displayThis' => 1, 'publish' => 1, 'locked' => 0); foreach ($transcripts->get() as $index => $symbol) { $fields['titleLang' . $index] = ''; $fields['textLang' . $index] = ''; } if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($transcripts); $payloads->start($this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAYLOAD_NAME)); $stored = $this->_controller->getFrontController()->getProtoPackage()->getCouldiesTable()->complementRow($this->_controller->getEntity()->getRow()); $data = Sitengine_Controller_Request_Http::filterUpdate(sizeof($input), $input, $fields, $stored); $data = array_merge($stored, $data); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorId(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_COULDIES_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queryUpdate = $uri; $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName(), Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorId(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_COULDIES_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $stored['titleLang' . $transcripts->getIndex()]; $title = $title != '' ? $title : $stored['titleLang0']; if ($data[Sitengine_Permiso::FIELD_UID] == $this->_controller->getPermiso()->getAuth()->getId() || $this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS)) { $displayPermissionSettings = true; } } else { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($transcripts); $payloads->start(); $data = Sitengine_Controller_Request_Http::filterInsert(sizeof($input), $input, $fields); $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getFrontController()->getProtoPackage()->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = !is_null($gid) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); # set some defaults... $n = 'sorting'; if (array_key_exists($n, $input)) { $data[$n] = $input[$n]; } else { $q = 'SELECT MAX(sorting) AS maxSorting FROM ' . $this->_controller->getFrontController()->getProtoPackage()->getCouldiesTableName(); $q .= ' WHERE '; #.Sitengine_Permiso::FIELD_OID.' = "'.$this->_controller->getPermiso()->getOrganization()->getId().'"'; $q .= ' shouldyId = "' . $this->_controller->getEntity()->getAncestorId() . '"'; $statement = $this->_controller->getDatabase()->prepare($q); $statement->execute(); $result = $statement->fetchAll(); $data[$n] = $result[0]['maxSorting'] + 10; } $n = 'titleLang0'; if (array_key_exists($n, $input)) { $data[$n] = $input[$n]; } else { $data[$n] = 'Couldy Record (Language 0/Default)'; } $n = 'titleLang1'; if (array_key_exists($n, $input)) { $data[$n] = $input[$n]; } else { $data[$n] = 'Couldy Record (Language 1)'; } $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName()); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorId(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_COULDIES_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('formViewInsertTitle'); $displayPermissionSettings = true; } #Sitengine_Debug::print_r($data); $data['uidOptions'] = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $data['gidOptions'] = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsGid')->toArray(), $this->_controller->getPermiso()->getDirectory()->getAllGroups()); ######################################################################## #### CONTENT PAYLOAD SECTION TITLE ######################################################################## $contentSectionTitle = $this->_controller->getTranslate()->translate('formViewContentSectionTitleDefault'); if (sizeof($transcripts->get()) > 1) { if (!$payloads->isMain()) { $symbol = $payloads->getTranscriptSymbol(); } else { $symbol = $transcripts->getDefaultSymbol(); } $contentSectionTitle .= ' (' . $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)) . ')'; } ######################################################################## #### PAYLOAD NAV DATA ######################################################################## $payloadNav = array(); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorId(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $query = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getMainName()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_COULDIES_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uri .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $payloadNav[$payloads->getMainName()] = array('uri' => $uri, 'label' => $this->_controller->getTranslate()->translate('formViewPayloadNavTitleMain')); foreach ($transcripts->get() as $index => $symbol) { $currentPayload = $payloads->getTranscriptNamePrefix() . '_' . $symbol; $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorId(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $query = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $currentPayload); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_COULDIES_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uri .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); if (sizeof($transcripts->get()) > 1) { $label = $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)); } else { $label = $this->_controller->getTranslate()->translate('formViewContentSectionTitleDefault'); } $payloadNav[$currentPayload] = array('uri' => $uri, 'label' => $label); } } ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('displayPermissionSettings' => $displayPermissionSettings, 'queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'contentSectionTitle' => $contentSectionTitle, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'PAYLOADNAV' => $payloadNav, 'Payloads' => $payloads, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Proto/Backend/Goodies/Shouldies/Couldies/Exception.php'; throw new Sitengine_Proto_Backend_Goodies_Shouldies_Couldies_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('id' => '', 'mdate' => '', 'comment' => ''); $fieldsOnOff = array('approve' => 1); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $stored = $this->_controller->getEntity()->getRow()->toArray(); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); */ /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); */ $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_COMMENTS_SHARP); $queryUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_COMMENTS_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformUpdateTitle'); } else { $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getFrontController()->getBlogPackage()->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = !is_null($gid) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); $hiddens = array(); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_COMMENTS_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformInsertTitle'); } #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## /* if( (!$data['id']) || # on insert (isset($data[Sitengine_Permiso::FIELD_UID]) && $data[Sitengine_Permiso::FIELD_UID]==$this->_controller->getPermiso()->getAuth()->getId()) || # owners ok #$this->_controller->getPermiso()->getUser()->hasSupervisorRights() || # supervisors ok #$this->_controller->getPermiso()->getUser()->hasModeratorRights() # moderators ok $this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS) ) { $n = Sitengine_Permiso::FIELD_UID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $elements[$n] = $e->getSelect($users); $n = Sitengine_Permiso::FIELD_GID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $groups = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsGid')->toArray(), $groups); $elements[$n] = $e->getSelect($groups); $n = Sitengine_Permiso::FIELD_RAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_RAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); } */ $n = 'approve'; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm' . $n); $elements[$n] = $e->getCheckbox($data[$n]); /* $n = 'name'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm'.$n); $elements[$n] = $e->getText(40); $n = 'email'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm'.$n); $elements[$n] = $e->getText(40); */ $n = 'comment'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormTextarea'); $e->setId('viewForm' . $n); $elements[$n] = $e->getTextarea(40, 10); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Blog/Backend/Blogs/Posts/Comments/Exception.php'; throw new Sitengine_Blog_Backend_Blogs_Posts_Comments_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getBlogPackage()->getFilesTable(); $table->setTranscript($this->_controller->getPreferences()->getTranscript()); $filter = $table->getFilterInstance($this->_controller->getRequest(), array('find' => Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_FIND, 'type' => Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_TYPE, 'reset' => Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $sorting = $table->getSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; $settingsElements = array(); ### transcript element ### $transcripts = $table->getTranscripts(); $transcripts->setLanguage($this->_controller->getPreferences()->getTranscript()); if (!$transcripts->isDefault()) { $settingsIsActive = true; } # set html input element $languages = array(); foreach ($transcripts->get() as $symbol) { $languages[$symbol] = $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)); } $e = new Sitengine_Form_Element(Sitengine_Env::PARAM_TRANSCRIPT, $transcripts->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_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 ######################################################################## /* $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $values = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsFilterByUid')->toArray(), $users); $e = new Sitengine_Form_Element(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_UID, $filter->getVal(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_UID)); $e->setId('filter'.Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_UID); $e->setClass('filterSelect'); $filter->setElement(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_UID, $e->getSelect($values)); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $values = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsFilterByGid')->toArray(), $groups); $e = new Sitengine_Form_Element(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_GID, $filter->getVal(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_GID)); $e->setId('filter'.Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_GID); $e->setClass('filterSelect'); $filter->setElement(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_GID, $e->getSelect($values)); */ $e = new Sitengine_Form_Element(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_FIND, $filter->getVal(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_FIND)); $e->setId('filter' . Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_FIND); $e->setClass('filterText'); $filter->setElement(Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_BY_FIND, $e->getText(20)); $hiddens = array(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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Blog_Backend_Blogs_Posts_Files_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); ######################################################################## #### LISTQUERY ######################################################################## $name = $this->_controller->getFrontController()->getBlogPackage()->getFilesTableName(); $whereClauses = array($this->_controller->getDatabase()->quoteInto('parentId = ?', $this->_controller->getEntity()->getAncestorId()), $this->_controller->getPermiso()->getDac()->getReadAccessSql($this->_controller->getFrontController()->getBlogPackage()->getAuthorizedGroups(), $name, false), $filter->getSql('')); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } # count total number of records $select = $table->select()->from($table, array('COUNT(*) AS count')); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $count = $table->fetchRow($select); $pager->calculate($count->count); ######################################################################## #### LISTDATA ######################################################################## $markedRows = $this->_controller->getMarkedRows(); $list = array(); foreach ($items as $item) { $row = $table->complementRow($item); # row selector checkbox $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 = 'sorting'; $p = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id']; $h = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id']; $v = sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($p) : $row[$n]; $e = new Sitengine_Form_Element($p, $v); $e->setClass('listformText'); $sort = $e->getText(5); $sort .= Sitengine_Form_Element::getHidden($h, $row[$n]); $n = 'publish'; $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'); $publish = $e->getCheckbox($s); $publish .= Sitengine_Form_Element::getHidden($h, $row[$n]); # uris $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $row['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_SHARP); $uriUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $row['isMarked'] = isset($markedRows[$row['id']]) ? $markedRows[$row['id']] : 0; $row['sortingText'] = $sort; $row['publishCheckbox'] = $publish; $row['uriUpdate'] = $uriUpdate; $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[] = $row; } #Sitengine_Debug::print_r($list); ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_BATCH); $uriDoBatchDelete = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS_FILES_BATCH); $uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uris = array('submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate); ######################################################################## #### METHODS ######################################################################## $methods = array('doBatchDelete' => Sitengine_Env::METHOD_DELETE, 'doBatchUpdate' => Sitengine_Env::METHOD_PUT); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array(Sitengine_Env::PARAM_METHOD => '', 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); } $type = $this->_controller->getEntity()->getAncestorType(); if ($type == Sitengine_Blog_Posts_Table::TYPE_GALLERY) { $title = $this->_controller->getTranslate()->translate('labelsListformPhotoTitle'); } else { $title = $this->_controller->getTranslate()->translate('labelsListformFileTitle'); } return array('hiddens' => implode('', $hiddens), 'title' => $title, 'URIS' => $uris, 'METHODS' => $methods, 'FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Blog/Backend/Blogs/Posts/Files/Exception.php'; throw new Sitengine_Blog_Backend_Blogs_Posts_Files_Exception('list page error', $exception); } }
protected function _getMainSection() { try { $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getNewsletterPackage()->getCampaignsTable(); $filter = $table->getFilterInstance($this->_controller->getRequest(), array('type' => Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_BY_TYPE, 'find' => Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_BY_FIND, 'reset' => Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $sorting = $table->getSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; $settingsElements = array(); ### 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('indexViewSettingsSectionItemsPerPage'), 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_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_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_BY_FIND, $filter->getVal(Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_BY_FIND)); $e->setId('filter' . Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_BY_FIND); $e->setClass('filterText'); $filter->setElement(Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_BY_FIND, $e->getText(20)); $hiddens = array(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); } $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Newsletter_Frontend_Campaigns_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Frontend_Front::ROUTE_CAMPAIGNS); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $filterData = array('isActive' => $filter->isActive(), 'uriReset' => $uriReset, 'hiddens' => implode('', $hiddens), 'ELEMENTS' => $filter->getElements()); ######################################################################## #### SORTING ######################################################################## $queries = array(); foreach ($sorting->getOrdering() as $field => $order) { $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Frontend_Front::ROUTE_CAMPAIGNS); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); ######################################################################## #### LISTQUERY ######################################################################## $name = $this->_controller->getFrontController()->getNewsletterPackage()->getCampaignsTableName(); $whereClauses = array($this->_controller->getPermiso()->getDac()->getReadAccessSql($this->_controller->getFrontController()->getNewsletterPackage()->getAuthorizedGroups(), $name, false), $filter->getSql('')); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } # count total number of records $select = $table->select()->from($table, array('COUNT(*) AS count')); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $count = $table->fetchRow($select); $pager->calculate($count->count); ######################################################################## #### LISTDATA ######################################################################## $list = array(); foreach ($items as $item) { $row = $table->complementRow($item); #Sitengine_Debug::print_r($row); # uris $args = array(Sitengine_Env::PARAM_ID => $row['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Frontend_Front::ROUTE_CAMPAIGNS_SHARP); $row['uriUpdate'] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $list[] = $row; } ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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); } $query = array(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_Newsletter_Frontend_Front::ROUTE_CAMPAIGNS); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $query = array(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_Newsletter_Frontend_Front::ROUTE_CAMPAIGNS); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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); ######################################################################## #### COLLECT ALL DATA ######################################################################## return array('FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Newsletter/Frontend/Campaigns/Exception.php'; throw new Sitengine_Newsletter_Frontend_Campaigns_Exception('list page error', $exception); } }
protected function _getMainSection() { try { require_once 'Sitengine/Form/Element.php'; $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getPermiso()->getMembershipsTable(); $sorting = $table->getUserJoinSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; ### ipp ### $defaultIpp = 20; $valueIpp = $this->_controller->getPreferences()->getItemsPerPage(); $valueIpp = is_numeric($valueIpp) ? $valueIpp : $defaultIpp; $valueIpp = $valueIpp <= 100 && $valueIpp >= 1 ? $valueIpp : $defaultIpp; $ippValues = array('' => $this->_controller->getTranslate()->translate('indexViewSettingsSectionItemsPerPage'), 5 => 5, 10 => 10, 20 => 20, 50 => 50, 100 => 100); $hiddens = array(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), 'IPPS' => $ippValues, Sitengine_Env::PARAM_IPP => $valueIpp); ######################################################################## #### FILTER ######################################################################## $filter = $table->getUserJoinFilterInstance($this->_controller->getRequest(), array('find' => Sitengine_Permiso_Backend_Groups_Members_Controller::PARAM_FILTER_BY_FIND, 'reset' => Sitengine_Permiso_Backend_Groups_Members_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $hiddens = array(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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Permiso_Backend_Groups_Members_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $filterData = array('isActive' => $filter->isActive(), 'uriReset' => $uriReset, 'hiddens' => implode('', $hiddens), 'DATA' => $filter->getData()); ######################################################################## #### SORTING ######################################################################## $queries = array(); foreach ($sorting->getOrdering() as $field => $order) { $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## require_once 'Sitengine/Grid/Pager.php'; $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); ######################################################################## #### LISTQUERY ######################################################################## $membershipsTableName = $this->_controller->getFrontController()->getPermiso()->getMembershipsTableName(); $usersTableName = $this->_controller->getFrontController()->getPermiso()->getUsersTableName(); $whereClauses = array($this->_controller->getDatabase()->quoteInto("{$membershipsTableName}.groupId = ?", $this->_controller->getEntity()->getAncestorId()), "{$membershipsTableName}.userId = {$usersTableName}.id", $filter->getSql('')); $select = $table->select()->setIntegrityCheck(false)->from($membershipsTableName)->from($usersTableName, array('name', 'nickname', 'firstname', 'lastname'))->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } #print $select->__toString(); $items = $table->fetchAll($select); #Sitengine_Debug::print_r($items->toArray()); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->setIntegrityCheck(false)->from($membershipsTableName)->from($usersTableName, array('name', 'nickname', 'firstname', 'lastname'))->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } # count total number of records $select = $table->select()->setIntegrityCheck(false)->from($membershipsTableName, array('id'))->from($usersTableName, array('name')); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $count = $table->fetchAll($select); $pager->calculate(sizeof($count)); ######################################################################## #### LISTDATA ######################################################################## $markedRows = $this->_controller->getMarkedRows(); $list = array(); foreach ($items as $item) { $row = $table->complementRow($item); # row selector checkbox $row['rowSelectCheckbox'] = array(); if (!$row['locked']) { $name = 'SELECTROWITEM' . $row['id']; $row['rowSelectCheckbox'] = array('name' => $name, 'checked' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : 0); } $n = 'locked'; $name = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id']; $current = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id']; $row['lockedCheckbox'] = array('name' => $name, 'checked' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : $row[$n], 'current' => Sitengine_Form_Element::getHidden($current, $row[$n])); # uris $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $row['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS_SHARP); $row['uriUpdate'] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $row['isMarked'] = isset($markedRows[$row['id']]) ? $markedRows[$row['id']] : 0; $list[] = $row; } ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $pagerData = array('hiddens' => implode('', $hiddens), '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_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS_BATCH); $uriDoBatchDelete = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS_BATCH); $uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uris = array('submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate); ######################################################################## #### METHODS ######################################################################## $methods = array('doBatchDelete' => Sitengine_Env::METHOD_DELETE, 'doBatchUpdate' => Sitengine_Env::METHOD_PUT); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array(Sitengine_Env::PARAM_METHOD => '', 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); } return array('hiddens' => implode('', $hiddens), 'title' => $this->_controller->getTranslate()->translate('indexViewTitle'), 'URIS' => $uris, 'METHODS' => $methods, 'FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Permiso/Backend/Groups/Members/Exception.php'; throw new Sitengine_Permiso_Backend_Groups_Members_Exception('list page error', $exception); } }
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); } }
protected function _getMainSection() { try { $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getBlogPackage()->getCommentsTable(); $filter = $table->getFilterInstance($this->_controller->getRequest(), array('find' => Sitengine_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_BY_FIND, 'reset' => Sitengine_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $sorting = $table->getSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; $settingsElements = array(); ### 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_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_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_BY_FIND, $filter->getVal(Sitengine_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_BY_FIND)); $e->setId('filter' . Sitengine_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_BY_FIND); $e->setClass('filterText'); $filter->setElement(Sitengine_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_BY_FIND, $e->getText(20)); $hiddens = array(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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Blog_Frontend_Blogs_Posts_Comments_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); /* ######################################################################## #### QUERY ######################################################################## $table = $this->_controller->getFrontController()->getBlogPackage()->getCommentsTableName(); $whereClauses = array( "$table.approve = '1'", "$table.parentId = '".$this->_controller->getEntity()->getAncestorId()."'", $this->_controller->getPermiso()->getDac()->getReadAccessSql($this->_controller->getFrontController()->getBlogPackage()->getAuthorizedGroups(), $table, false), $filter->getSql('') ); $orderClause = $sorting->getClause(true); $items = $table->get($whereClauses, $orderClause, $valueIpp, $pager->getOffset()); if($pager->getCurrPage() > 1 && !sizeof($items)) { # current page is out of bounds - go to beginning of list $pager = new Sitengine_Grid_Pager(1, $valueIpp); $items = $table->get($whereClauses, $orderClause, $valueIpp, 0); } $pager->calculate($table->count($whereClauses)); */ ######################################################################## #### LISTQUERY ######################################################################## $name = $this->_controller->getFrontController()->getBlogPackage()->getCommentsTableName(); $usersTableName = $this->_controller->getPermiso()->getUsersTableName(); $whereClauses = array("{$name}.approve = '1'", "{$name}.uid = {$usersTableName}.id", $this->_controller->getDatabase()->quoteInto('parentId = ?', $this->_controller->getEntity()->getAncestorId()), $filter->getSql('')); $select = $table->select()->setIntegrityCheck(false)->from($table)->from($usersTableName, array('name', 'firstname', 'lastname', 'nickname'))->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } ######################################################################## #### LISTDATA ######################################################################## #$markedRows = $this->_controller->getMarkedRows(); $list = array(); foreach ($items as $item) { $row = $item->toArray(); /* # row selector checkbox $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 = 'approve'; $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'); $approve = $e->getCheckbox($s); $approve .= Sitengine_Form_Element::getHidden($h, $row[$n]); # uris $args = array( Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $row['id'] #Sitengine_Env::PARAM_PAGE => $valuePage, #Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), #Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder() ); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS_SHARP); $uriUpdate = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $row['isMarked'] = (isset($markedRows[$row['id']])) ? $markedRows[$row['id']] : 0; $row['approveCheckbox'] = $approve; $row['uriUpdate'] = $uriUpdate; */ #$row['cdate'] = $this->_controller->getViewHelper()->formatDate($row['cdate']); #$row['mdate'] = $this->_controller->getViewHelper()->formatDate($row['mdate']); $list[] = $row; } ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $query = array(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_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId() ); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS_BATCH); $uriDoBatchDelete = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $args = array( Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId() ); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS_BATCH); $uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $uris = array( 'submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate ); ######################################################################## #### METHODS ######################################################################## $methods = array( 'doBatchDelete' => Sitengine_Env::METHOD_DELETE, 'doBatchUpdate' => Sitengine_Env::METHOD_PUT ); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array( Sitengine_Env::PARAM_METHOD => '', 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); } */ return array('FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Blog/Frontend/Blogs/Posts/Comments/Exception.php'; throw new Sitengine_Blog_Frontend_Blogs_Posts_Comments_Exception('list page error', $exception); } }
public function getHiddenElements() { $hiddens = ''; require_once 'Sitengine/Form/Element.php'; foreach ($this->_params as $k => $v) { $hiddens .= Sitengine_Form_Element::getHidden($k, $v); } return $hiddens; }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('comment' => ''); $fieldsOnOff = array(); /* if($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $stored = $this->_controller->getEntity()->getData(); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated( sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored ); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); $args = array( #Sitengine_Env::PARAM_PAGE => $valuePage, #Sitengine_Env::PARAM_SORT => $valueSort, #Sitengine_Env::PARAM_ORDER => $valueOrder, Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id'] ); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS_SHARP); $queryUpdate = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $hiddens = array( Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, #Sitengine_Env::PARAM_PAGE => $valuePage, #Sitengine_Env::PARAM_SORT => $valueSort, #Sitengine_Env::PARAM_ORDER => $valueOrder, Sitengine_Env::PARAM_MDATE => $stored['mdate'] ); $args = array( Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id'] ); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformUpdateTitle'); } else { */ $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); /* $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getFrontController()->getBlogPackage()->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = (!is_null($gid)) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); */ $hiddens = array(); $args = array(Sitengine_Env::PARAM_GREATANCESTORID => $this->_controller->getEntity()->getGreatAncestorSlug(), Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_COMMENTS); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); #$title = $this->_controller->getTranslate()->translate('labelsViewformInsertTitle'); #} #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## $n = 'comment'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormTextarea'); $e->setId('viewForm' . $n); $elements[$n] = $e->getTextarea(40, 10); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Blog/Frontend/Blogs/Posts/Comments/Exception.php'; throw new Sitengine_Blog_Frontend_Blogs_Posts_Comments_Exception('form page error', $exception); } }
protected function _getMainSection() { try { require_once 'Sitengine/Form/Element.php'; $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getProtoPackage()->getGoodiesTable(); $table->setTranscript($this->_controller->getPreferences()->getTranscript()); $sorting = $table->getSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; ### transcript ### $transcripts = $table->getTranscripts(); $transcripts->setLanguage($this->_controller->getPreferences()->getTranscript()); if (!$transcripts->isDefault()) { $settingsIsActive = true; } $languages = array(); foreach ($transcripts->get() as $symbol) { $languages[$symbol] = $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)); } ### ipp ### $defaultIpp = 20; $valueIpp = $this->_controller->getPreferences()->getItemsPerPage(); $valueIpp = is_numeric($valueIpp) ? $valueIpp : $defaultIpp; $valueIpp = $valueIpp <= 100 && $valueIpp >= 1 ? $valueIpp : $defaultIpp; $ippValues = array('' => $this->_controller->getTranslate()->translate('indexViewSettingsSectionItemsPerPage'), 5 => 5, 10 => 10, 20 => 20, 50 => 50, 100 => 100); $hiddens = array(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), 'TRANSCRIPTS' => $languages, 'IPPS' => $ippValues, Sitengine_Env::PARAM_TRANSCRIPT => $transcripts->getSymbol(), Sitengine_Env::PARAM_IPP => $valueIpp); ######################################################################## #### FILTER ######################################################################## $filter = $table->getFilterInstance($this->_controller->getRequest(), array('uid' => Sitengine_Proto_Backend_Goodies_Controller::PARAM_FILTER_BY_UID, 'gid' => Sitengine_Proto_Backend_Goodies_Controller::PARAM_FILTER_BY_GID, 'type' => Sitengine_Proto_Backend_Goodies_Controller::PARAM_FILTER_BY_TYPE, 'find' => Sitengine_Proto_Backend_Goodies_Controller::PARAM_FILTER_BY_FIND, 'reset' => Sitengine_Proto_Backend_Goodies_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $types = $this->_controller->getTranslate()->translateGroup('fieldValsFilterByType')->toArray(); $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $users = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsFilterByUid')->toArray(), $users); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $groups = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsFilterByGid')->toArray(), $groups); $hiddens = array(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); } $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Proto_Backend_Goodies_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $filterData = array('isActive' => $filter->isActive(), 'uriReset' => $uriReset, 'hiddens' => implode('', $hiddens), 'DATA' => $filter->getData(), 'TYPES' => $types, 'USERS' => $users, 'GROUPS' => $groups); ######################################################################## #### SORTING ######################################################################## $queries = array(); foreach ($sorting->getOrdering() as $field => $order) { $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## require_once 'Sitengine/Grid/Pager.php'; $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); ######################################################################## #### LISTQUERY ######################################################################## $name = $this->_controller->getFrontController()->getProtoPackage()->getGoodiesTableName(); $whereClauses = array($this->_controller->getPermiso()->getDac()->getReadAccessSql($this->_controller->getFrontController()->getProtoPackage()->getAuthorizedGroups(), $name, false), $filter->getSql('')); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } # count total number of records $select = $table->select()->from($table, array('COUNT(*) AS count')); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $count = $table->fetchRow($select); $pager->calculate($count->count); ######################################################################## #### LISTDATA ######################################################################## $markedRows = $this->_controller->getMarkedRows(); $list = array(); foreach ($items as $item) { $row = $table->complementRow($item); #Sitengine_Debug::print_r($row); # row selector checkbox $row['rowSelectCheckbox'] = array(); if (!$row['locked']) { $name = 'SELECTROWITEM' . $row['id']; $row['rowSelectCheckbox'] = array('name' => $name, 'checked' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : 0); } $n = 'sorting'; $name = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id']; $current = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id']; $row['sortingText'] = array('name' => $name, 'value' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : $row[$n], 'current' => Sitengine_Form_Element::getHidden($current, $row[$n])); $n = 'displayThis'; $name = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id']; $current = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id']; $row['displayThisSelect'] = array('name' => $name, 'value' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : $row[$n], 'OPTIONS' => $this->_controller->getTranslate()->translateGroup('fieldValsDisplayThis')->toArray(), 'current' => Sitengine_Form_Element::getHidden($current, $row[$n])); $n = 'locked'; $name = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id']; $current = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id']; $row['lockedCheckbox'] = array('name' => $name, 'checked' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : $row[$n], 'current' => Sitengine_Form_Element::getHidden($current, $row[$n])); $n = 'publish'; $name = 'UPDATEROWITEM' . $n . 'ITEMID' . $row['id']; $current = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $row['id']; $row['publishCheckbox'] = array('name' => $name, 'checked' => sizeof($markedRows) && isset($markedRows[$row['id']]) ? $this->_controller->getRequest()->getPost($name) : $row[$n], 'current' => Sitengine_Form_Element::getHidden($current, $row[$n])); # uris $args = array(Sitengine_Env::PARAM_ID => $row['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHARP); $row['uriUpdate'] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $args = array(Sitengine_Env::PARAM_ANCESTORID => $row['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES); $row['uriShouldyIndex'] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $row['isMarked'] = isset($markedRows[$row['id']]) ? $markedRows[$row['id']] : 0; $row['shouldyCount'] = $this->_controller->getViewHelper()->countShouldies($row['id']); $list[] = $row; } ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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); } $query = array(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_Proto_Backend_Front::ROUTE_GOODIES); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $query = array(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_Proto_Backend_Front::ROUTE_GOODIES); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $pagerData = array('hiddens' => implode('', $hiddens), '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(); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_BATCH); $uriDoBatchDelete = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $args = array(); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_BATCH); $uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uris = array('submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate); ######################################################################## #### METHODS ######################################################################## $methods = array('doBatchDelete' => Sitengine_Env::METHOD_DELETE, 'doBatchUpdate' => Sitengine_Env::METHOD_PUT); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array(Sitengine_Env::PARAM_METHOD => '', 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); } return array('hiddens' => implode('', $hiddens), 'title' => $this->_controller->getTranslate()->translate('indexViewTitle'), 'URIS' => $uris, 'METHODS' => $methods, 'FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Proto/Backend/Goodies/Exception.php'; throw new Sitengine_Proto_Backend_Goodies_Exception('list page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getNewsletterPackage()->getAttachmentsTable(); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('id' => '', 'mdate' => '', 'title' => ''); $fieldsOnOff = array(); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $stored = $this->_controller->getFrontController()->getNewsletterPackage()->getAttachmentsTable()->complementRow($this->_controller->getEntity()->getRow()); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); */ /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); */ $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queryUpdate = $uri; $childActions = array(); $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $stored['title']; } else { $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); $hiddens = array(); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Newsletter_Backend_Front::ROUTE_CAMPAIGNS_ATTACHMENTS_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('formViewInsertTitle'); } #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## $n = 'title'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getText(40); $n = 'file1Original'; $e = new Sitengine_Form_Element($n); $e->setClass('viewFormFile'); $e->setId('viewForm' . $n); $elements[$n] = $e->getFile(40); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Newsletter/Backend/Campaigns/Attachments/Exception.php'; throw new Sitengine_Newsletter_Backend_Campaigns_Attachments_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getPermiso()->getUsersTable(); ######################################################################## #### FILTER INPUT ######################################################################## $fields = array('id' => '', 'mdate' => '', 'locked' => '', 'enabled' => 1, 'language' => '', 'timezone' => 'UTC', 'name' => '', 'nickname' => '', 'firstname' => '', 'lastname' => '', 'country' => '', 'description' => '', 'password' => '', 'newsletter' => 1); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $stored = $this->_controller->getFrontController()->getPermiso()->getUsersTable()->complementRow($this->_controller->getEntity()->getRow()); $data = Sitengine_Controller_Request_Http::filterUpdate(sizeof($input), $input, $fields, $stored); $data = array_merge($stored, $data); $args = array(Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_USERS_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queryUpdate = $uri; $childActions = array(); $args = array(Sitengine_Env::PARAM_ANCESTORID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_USERS_MEMBERSHIPS); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $childActions['membershipsIndex'] = array('uri' => $uri, 'label' => $this->_controller->getTranslate()->translate('formViewChildActionsSectionMembershipsIndex'), 'postfix' => ' (' . $this->_controller->getViewHelper()->countMemberships($stored['id']) . ')'); $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_USERS_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $stored['name'] . ' (' . $stored['firstname'] . ' ' . $stored['lastname'] . ')'; } else { $data = Sitengine_Controller_Request_Http::filterInsert(sizeof($input), $input, $fields); $hiddens = array(); $args = array(); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_USERS_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('formViewInsertTitle'); $displayPermissionSettings = true; } #Sitengine_Debug::print_r($data); $data['countryOptions'] = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsCountry')->toArray(), $this->_controller->getTranslate()->translateGroup('countries')->toArray()); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'CHILDACTIONS' => isset($childActions) ? $childActions : array(), 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Permiso/Backend/Users/Exception.php'; throw new Sitengine_Permiso_Backend_Users_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getBlogPackage()->getBlogsTable(); $table->setTranscript($this->_controller->getPreferences()->getTranscript()); $filter = $table->getFilterInstance($this->_controller->getRequest(), array('find' => Sitengine_Blog_Frontend_Blogs_Controller::PARAM_FILTER_BY_FIND, 'reset' => Sitengine_Blog_Frontend_Blogs_Controller::PARAM_FILTER_RESET), $this->_controller->getNamespace()); $sorting = $table->getSortingInstance($this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT), $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER)); ######################################################################## #### SETTINGS ######################################################################## $settingsIsActive = false; $settingsElements = array(); /* ### transcript element ### $transcripts = $table->getTranscripts(); $transcripts->setLanguage($this->_controller->getPreferences()->getLanguage()); if(!$transcripts->isDefault()) { $settingsIsActive = true; } # set html input element $languages = array(); foreach($transcripts->get() as $symbol) { $languages[$symbol] = $this->_controller->getTranslate()->translate('languages'.ucfirst($symbol)); } $e = new Sitengine_Form_Element(Sitengine_Env::PARAM_TRANSCRIPT, $transcripts->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_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_Blog_Frontend_Blogs_Controller::PARAM_FILTER_BY_FIND, $filter->getVal(Sitengine_Blog_Frontend_Blogs_Controller::PARAM_FILTER_BY_FIND)); $e->setId('filter' . Sitengine_Blog_Frontend_Blogs_Controller::PARAM_FILTER_BY_FIND); $e->setClass('filterText'); $filter->setElement(Sitengine_Blog_Frontend_Blogs_Controller::PARAM_FILTER_BY_FIND, $e->getText(20)); $hiddens = array(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); } $query = array(Sitengine_Env::PARAM_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Blog_Frontend_Blogs_Controller::PARAM_FILTER_RESET => 1); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS); $uriReset = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriReset .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $filterData = array('isActive' => $filter->isActive(), 'uriReset' => $uriReset, 'hiddens' => implode('', $hiddens), 'ELEMENTS' => $filter->getElements(), 'DATA' => $filter->getData()); ######################################################################## #### SORTING ######################################################################## $queries = array(); foreach ($sorting->getOrdering() as $field => $order) { $query = array(Sitengine_Env::PARAM_SORT => $field, Sitengine_Env::PARAM_ORDER => $order); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS); $queries[$field] = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $queries[$field] .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); } $sortingData = array('QUERIES' => $queries, 'COLUMNS' => $sorting->getColumns()); ######################################################################## #### PAGER ######################################################################## $pager = new Sitengine_Grid_Pager($valuePage, $valueIpp); ######################################################################## #### LISTQUERY ######################################################################## $name = $this->_controller->getFrontController()->getBlogPackage()->getBlogsTableName(); $whereClauses = array("{$table}.publish = '1'", $filter->getSql('')); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, $pager->getOffset()); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); # if current page is out of bounds - go to beginning of list if (!$items->count() && $pager->getCurrPage() > 1) { $pager = new Sitengine_Grid_Pager(1, $valueIpp); $select = $table->select()->order($sorting->getClause())->limit($valueIpp, 0); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $items = $table->fetchAll($select); } # count total number of records $select = $table->select()->from($table, array('COUNT(*) AS count')); foreach ($whereClauses as $clause) { if ($clause) { $select->where($clause); } } $count = $table->fetchRow($select); $pager->calculate($count->count); ######################################################################## #### LISTDATA ######################################################################## #$markedRows = $this->_controller->getMarkedRows(); $list = array(); foreach ($items as $item) { $row = $table->complementRow($item); /* # row selector checkbox $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 = 'publish'; $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'); $publish = $e->getCheckbox($s); $publish .= Sitengine_Form_Element::getHidden($h, $row[$n]); # uris $uriUpdate = $this->_makeUpdateUri($row); */ $args = array(Sitengine_Env::PARAM_ANCESTORID => $row['slug']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS); $uriPostIndex = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); /* $args = array( Sitengine_Env::PARAM_ANCESTORID => $row['id'] ); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_POSTS_NEW); $uriPostInsert = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $row['isMarked'] = (isset($markedRows[$row['id']])) ? $markedRows[$row['id']] : 0; $row['publishCheckbox'] = $publish; */ $row['postCount'] = $this->_controller->getViewHelper()->countPosts($row['id']); $row['uriPostIndex'] = $uriPostIndex; #$row['uriPostInsert'] = $uriPostInsert; #$row['uriUpdate'] = $uriUpdate; #$row['cdate'] = $this->_controller->getViewHelper()->formatDate($row['cdate']); #$row['mdate'] = $this->_controller->getViewHelper()->formatDate($row['mdate']); $list[] = $row; } ######################################################################## #### PAGER DATA ######################################################################## $hiddens = array(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); } $query = array(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_Blog_Frontend_Front::ROUTE_BLOGS); $uriPrevPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriPrevPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $query = array(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_Blog_Frontend_Front::ROUTE_BLOGS); $uriNextPage = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble(); $uriNextPage .= Sitengine_Controller_Request_Http::makeNameValueQuery($query); $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(); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_BATCH); $uriDoBatchDelete = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $args = array(); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Frontend_Front::ROUTE_BLOGS_BATCH); $uriDoBatchUpdate = $this->_controller->getRequest()->getBasePath().'/'.$route->assemble($args, true); $uris = array( 'submitDoBatchDelete' => $uriDoBatchDelete, 'submitDoBatchUpdate' => $uriDoBatchUpdate ); ######################################################################## #### METHODS ######################################################################## $methods = array( 'doBatchDelete' => Sitengine_Env::METHOD_DELETE, 'doBatchUpdate' => Sitengine_Env::METHOD_PUT ); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array( Sitengine_Env::PARAM_METHOD => '', 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); } */ return array('FILTER' => $filterData, 'SETTINGS' => $settingsData, 'SORTING' => $sortingData, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Blog/Frontend/Blogs/Exception.php'; throw new Sitengine_Blog_Frontend_Blogs_Exception('list page error', $exception); } }
protected function _getMainSection() { try { $list = array(); $markedRows = $this->_controller->getMarkedRows(); #Sitengine_Debug::print_r($markedRows); $dir = $this->_controller->getTempDir(); if (is_dir($dir)) { $dirIterator = new DirectoryIterator($dir); $date = new Zend_Date(null, Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); foreach ($dirIterator as $count => $file) { if (is_file($dir . '/' . $file->getFilename()) && !preg_match('/^(\\.|\\.\\.|\\.DS_Store)$/', $file->getFilename())) { $filename = $file->getFilename(); $id = 'item' . $count; $size = round($file->getSize() / 1024 / 1024, 1); if ($size >= 1) { $size .= 'MB'; } else { $size = round($file->getSize() / 1024, 0) . 'KB'; } $date->setTimestamp($file->getCTime()); $udate = $date->get(Zend_Date::DATE_FULL) . ' '; $udate .= $date->get(Zend_Date::TIME_FULL); $p = 'SELECTROWITEM' . $id; $s = sizeof($markedRows) && isset($markedRows[$id]) ? $this->_controller->getRequest()->getPost($p) : 0; $e = new Sitengine_Form_Element($p, 1); $e->setClass('listformCheckbox'); $checkbox = $e->getCheckbox($s); $checkbox .= Sitengine_Form_Element::getHidden('FILENAME' . $id, $filename); $n = 'type'; $p = 'UPDATEROWITEM' . $n . 'ITEMID' . $id; $h = 'UPDATEROWITEMCURRENT' . $n . 'ITEMID' . $id; $v = sizeof($markedRows) && isset($markedRows[$id]) ? $this->_controller->getRequest()->getPost($p) : Sitengine_Proto_Backend_Goodies_Shouldies_Controller::VALUE_NONESELECTED; $e = new Sitengine_Form_Element($p, $v); $e->setClass('listformSelect'); $type = $e->getSelect($this->_controller->getTranslate()->translateGroup('fieldValsType')->toArray()); $type .= Sitengine_Form_Element::getHidden($h, Sitengine_Proto_Backend_Goodies_Shouldies_Controller::VALUE_NONESELECTED); $args = array(Sitengine_Env::PARAM_CONTROLLER => 'shouldiesUploads', Sitengine_Env::PARAM_FILE => $filename); $uriDownload = $this->_controller->getFrontController()->getProtoPackage()->getDownloadHandler(); $uriDownload .= Sitengine_Controller_Request_Http::makeNameValueQuery($args); $list[] = array('id' => $id, 'name' => $filename, 'size' => $size, 'udate' => $udate, 'rowSelectCheckbox' => $checkbox, 'type' => $type, 'uriDownload' => $uriDownload, 'isMarked' => isset($markedRows[$id]) ? $markedRows[$id] : 0); } } } #Sitengine_Debug::print_r($list); ######################################################################## #### PAGER DATA ####################################################################### $pagerData = array('hiddens' => '', 'currPageInput' => '', 'currPage' => 1, 'nextPage' => 1, 'prevPage' => 1, 'numPages' => 1, 'numItems' => sizeof($list), 'firstItem' => 1, 'lastItem' => sizeof($list), 'uriPrevPage' => '', 'uriNextPage' => ''); ######################################################################## #### URIS ######################################################################## $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_UPLOAD); $uriDoBatchUnlink = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Proto_Backend_Front::ROUTE_GOODIES_SHOULDIES_ASSIGN); $uriDoBatchAssign = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $uris = array('submitDoBatchAssign' => $uriDoBatchAssign, 'submitDoBatchUnlink' => $uriDoBatchUnlink); ######################################################################## #### METHODS ######################################################################## $methods = array('doBatchUnlink' => Sitengine_Env::METHOD_DELETE, 'doBatchAssign' => Sitengine_Env::METHOD_POST); ######################################################################## #### COLLECT ALL DATA ######################################################################## $hiddens = array(Sitengine_Env::PARAM_METHOD => ''); foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('hiddens' => implode('', $hiddens), 'title' => $this->_controller->getTranslate()->translate('assignViewAssignFormTitle'), 'URIS' => $uris, 'METHODS' => $methods, 'DATA' => $list, 'PAGER' => $pagerData); } catch (Exception $exception) { require_once 'Sitengine/Proto/Backend/Goodies/Shouldies/Exception.php'; throw new Sitengine_Proto_Backend_Goodies_Shouldies_Exception('list page error', $exception); } }
protected function _getMainSection() { try { $valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $filter = $this->_controller->getViewHelper()->getSearchFilterInstance(); $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_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_SEARCH_BY_TYPE, $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE)); $e->setId('filter' . Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE); $e->setClass('filterSelect'); $filter->setElement(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE, $e->getSelect($this->_controller->getTranslate()->translateGroup('fieldValsSearchByType')->toArray())); $e = new Sitengine_Form_Element(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND, $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND)); $e->setId('filter' . Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND); $e->setClass('filterText'); $filter->setElement(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND, $e->getText(20)); $hiddens = array(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_SORT => $sorting->getActiveRule(), Sitengine_Env::PARAM_ORDER => $sorting->getActiveOrder(), Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_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()); $sortingData = array(); $pagerData = array(); $list = array(); if ($filter->isActive()) { ######################################################################## #### SORTING ######################################################################## $queries = array(); foreach ($sorting->getOrdering() as $field => $order) { $args = array(Sitengine_Env::PARAM_ACTION => $this->_controller->getRequest()->getActionName(), Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND), 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 .= ' cdate,'; $q .= ' mdate,'; $q .= ' keyword,'; $q .= ' type,'; $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 1 = 1'; #$q .= ' '.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 ######################################################################## foreach ($list as $count => $row) { # uris switch ($row['type']) { case Sitengine_Sitemap::ITEMTYPE_FILE: $updateAction = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATEFILE; break; case Sitengine_Sitemap::ITEMTYPE_PAGE: $updateAction = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATEPAGE; break; case Sitengine_Sitemap::ITEMTYPE_MASK: $updateAction = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATEMASK; break; case Sitengine_Sitemap::ITEMTYPE_LAYER: $updateAction = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATELAYER; break; case Sitengine_Sitemap::ITEMTYPE_SNIPPET: $updateAction = Sitengine_Sitemap_Backend_Controller::ACTION_UPDATESNIPPET; break; } $args = array(Sitengine_Env::PARAM_ACTION => $updateAction, 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); #$row['childCount'] = $this->_controller->getViewHelper()->countChildren($row['id']); $row['uriUpdate'] = $uriUpdate; $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_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND), Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE), 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_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND), Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE), 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_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_FIND), Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE => $filter->getVal(Sitengine_Sitemap_Backend_Controller::PARAM_SEARCH_BY_TYPE), 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); } ######################################################################## #### COLLECT ALL DATA ######################################################################## return array('title' => $this->_controller->getTranslate()->translate('labelsSearchFormTitle'), '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); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getPermiso()->getMembershipsTable(); ######################################################################## #### FILTER INPUT ######################################################################## $fields = array('id' => '', 'groupId' => '', 'locked' => 0); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $stored = $this->_controller->getFrontController()->getPermiso()->getMembershipsTable()->complementRow($this->_controller->getEntity()->getRow()); $data = Sitengine_Controller_Request_Http::filterUpdate(sizeof($input), $input, $fields, $stored); $data = array_merge($stored, $data); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS_SHARP); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $queryUpdate = $uri; $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId(), Sitengine_Env::PARAM_ID => $stored['id']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $stored['userId']; } else { $data = Sitengine_Controller_Request_Http::filterInsert(sizeof($input), $input, $fields); $hiddens = array(); $args = array(Sitengine_Env::PARAM_ANCESTORID => $this->_controller->getEntity()->getAncestorId()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Permiso_Backend_Front::ROUTE_GROUPS_MEMBERS_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('formViewInsertTitle'); } #Sitengine_Debug::print_r($data); $data['userIdOptions'] = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsUserId')->toArray(), $this->_controller->getPermiso()->getDirectory()->getAllUsers()); #unset($data['userIdOptions'][Sitengine_Permiso::UID_ROOT]); unset($data['userIdOptions'][Sitengine_Permiso::UID_GUEST]); unset($data['userIdOptions'][Sitengine_Permiso::UID_LOSTFOUND]); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Permiso/Backend/Groups/Members/Exception.php'; throw new Sitengine_Permiso_Backend_Groups_Members_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('id' => '', 'keyword' => ''); $fieldsOnOff = array('locked' => 0); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { require_once 'Sitengine/Form/Payloads.php'; $payloads = new Sitengine_Form_Payloads(); $payloads->start($this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAYLOAD_NAME)); $stored = $this->_controller->getEntity()->getData(); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); */ /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); */ $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName(), Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_ID => $stored['id'], Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_DOUPDATELAYER); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformUpdateLayerTitle'); } else { require_once 'Sitengine/Form/Payloads.php'; $payloads = new Sitengine_Form_Payloads(); $payloads->start(); $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = !is_null($gid) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName()); $args = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_DONEWLAYER); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformNewLayerTitle'); } #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## if ($payloads->isMain()) { /* if( (!$data['id']) || # on insert (isset($data[Sitengine_Permiso::FIELD_UID]) && $data[Sitengine_Permiso::FIELD_UID]==$this->_controller->getPermiso()->getAuth()->getId()) || # owners ok #$this->_controller->getPermiso()->getUser()->hasSupervisorRights() || # supervisors ok #$this->_controller->getPermiso()->getUser()->hasModeratorRights() # moderators ok $this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS) ) { $n = Sitengine_Permiso::FIELD_UID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $elements[$n] = $e->getSelect($users); $n = Sitengine_Permiso::FIELD_GID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $groups = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsGid')->toArray(), $groups); $elements[$n] = $e->getSelect($groups); $n = Sitengine_Permiso::FIELD_RAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_RAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); } */ $n = 'locked'; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm' . $n); $elements[$n] = $e->getCheckbox($data[$n]); $n = 'keyword'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getText(40); } ######################################################################## #### PAYLOAD NAV DATA ######################################################################## $payloadNav = array(); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('payloadName' => $payloads->getName(), 'payloadIsMain' => $payloads->isMain(), 'queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'PAYLOADNAV' => $payloadNav, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Sitemap/Backend/Exception.php'; throw new Sitengine_Sitemap_Backend_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); #$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); $table = $this->_controller->getFrontController()->getBlogPackage()->getBlogsTable(); $table->setTranscript($this->_controller->getPreferences()->getTranscript()); $transcripts = $table->getTranscripts(); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('id' => '', 'mdate' => '', 'slug' => ''); foreach ($transcripts->get() as $index => $symbol) { $fieldsNormal['titleLang' . $index] = ''; $fieldsNormal['markupLang' . $index] = ''; } $fieldsOnOff = array('publish' => 1); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($transcripts); $payloads->start($this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAYLOAD_NAME)); $stored = $this->_controller->getFrontController()->getBlogPackage()->getBlogsTable()->complementRow($this->_controller->getEntity()->getRow()); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); */ /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); */ $args = array(Sitengine_Env::PARAM_ID => $stored['slug']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_SHARP); $queryUpdate = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $childActions = array(); $args = array(Sitengine_Env::PARAM_ANCESTORID => $stored['slug']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_POSTS); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $childActions['postList'] = array('uri' => $uri, 'label' => $this->_controller->getTranslate()->translate('labelsChildActionsSectionPostsIndex'), 'postfix' => ' (' . $this->_controller->getViewHelper()->countPosts($stored['id']) . ')'); $hiddens = array(Sitengine_Env::PARAM_METHOD => Sitengine_Env::METHOD_PUT, Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName(), Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_ID => $stored['slug']); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_SHARP); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $stored['titleLang' . $transcripts->getIndex()]; $title = $title != '' ? $title : $stored['titleLang' . $transcripts->getDefaultIndex()]; } else { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($transcripts); $payloads->start(); $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getFrontController()->getBlogPackage()->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = !is_null($gid) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName()); $args = array(); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Blog_Backend_Front::ROUTE_BLOGS_NEW); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformInsertTitle'); } #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## if ($payloads->isMain()) { /* if( (!$data['id']) || # on insert (isset($data[Sitengine_Permiso::FIELD_UID]) && $data[Sitengine_Permiso::FIELD_UID]==$this->_controller->getPermiso()->getAuth()->getId()) || # owners ok #$this->_controller->getPermiso()->getUser()->hasSupervisorRights() || # supervisors ok #$this->_controller->getPermiso()->getUser()->hasModeratorRights() # moderators ok $this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS) ) { $n = Sitengine_Permiso::FIELD_UID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $elements[$n] = $e->getSelect($users); $n = Sitengine_Permiso::FIELD_GID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $groups = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsGid')->toArray(), $groups); $elements[$n] = $e->getSelect($groups); $n = Sitengine_Permiso::FIELD_RAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_RAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); } */ $n = 'titleLang' . $transcripts->getDefaultIndex(); $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements['title'] = $e->getText(40); $n = 'markupLang' . $payloads->getTranscriptIndex(); $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormTextarea'); $e->setId('viewForm' . $n); $elements[$n] = $e->getTextarea(40, 10); $n = 'publish'; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm' . $n); $elements[$n] = $e->getCheckbox($data[$n]); $n = 'slug'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getText(40); } ######################################################################## #### CONTENT PAYLOAD SECTION TITLE ######################################################################## $contentSectionTitle = $this->_controller->getTranslate()->translate('labelsViewformContentSectionTitleDefault'); if (sizeof($transcripts->get()) > 1) { if (!$payloads->isMain()) { $symbol = $payloads->getTranscriptSymbol(); } else { $symbol = $transcripts->getDefaultSymbol(); } $contentSectionTitle .= ' (' . $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)) . ')'; } ######################################################################## #### PAYLOAD NAV DATA ######################################################################## $payloadNav = array(); ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('payloadName' => $payloads->getName(), 'payloadIsMain' => $payloads->isMain(), 'payloadIsDefaultTranscript' => $payloads->isDefaultTranscript(), 'queryUpdate' => isset($queryUpdate) ? $queryUpdate : '', 'title' => $title, 'contentSectionTitle' => $contentSectionTitle, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'CHILDACTIONS' => isset($childActions) ? $childActions : array(), 'PAYLOADNAV' => $payloadNav, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Blog/Backend/Blogs/Exception.php'; throw new Sitengine_Blog_Backend_Blogs_Exception('form page error', $exception); } }
protected function _getMainSection() { try { $elements = array(); $input = $this->_controller->getRequest()->getPost(null); ##$valueSort = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_SORT); #$valueOrder = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_ORDER); #$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE); ######################################################################## #### FILTER INPUT ######################################################################## $fieldsNormal = array('id' => '', 'keyword' => '', 'cssFile' => '', 'xmlFile' => '', 'description' => ''); foreach ($this->_controller->getTranscripts()->get() as $index => $symbol) { $fieldsNormal['htmlLang' . $index] = ''; } $fieldsOnOff = array('locked' => 0, 'enabled' => 1); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { /* $data = $this->_controller->getEntity()->getData(); $path = $this->getThread($data['id']); print $path; $q = 'SELECT id FROM '.$this->_controller->getFrontController()->getSitemapPackage()->getTableSitemap(); $q .= ' WHERE '.Sitengine_Permiso::FIELD_OID.' = "'.$this->_controller->getPermiso()->getOrganization()->getId().'"'; $q .= ' AND ('; foreach($this->_controller->getTranscripts()->get() as $index => $symbol) { $or = ($index) ? ' OR ' : ''; $q .= $or.'htmlLang'.$index.' LIKE "%'.$path.'%"'; } $q .= ')'; Sitengine_Db_Debug::printQuery($this->_controller->getDatabase(), $q); $statement = $this->_controller->getDatabase()->prepare($q); $statement->execute(); $result = $statement->fetchAll(Zend_Db::FETCH_ASSOC); Sitengine_Debug::print_r($result); */ require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($this->_controller->getTranscripts()); $payloads->start($this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAYLOAD_NAME)); $stored = $this->_controller->getEntity()->getData(); $data = Sitengine_Controller_Request_Http::filterUpdateDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff, $stored); $data = array_merge($stored, $data); # set dates to timezone /* $name = 'cdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_FULL).' '; $data[$name] .= $date->get(Zend_Date::TIME_FULL); */ /* $name = 'mdate'; $date = new Zend_Date($stored[$name], Zend_Date::ISO_8601, $this->_controller->getLocale()); $date->setTimezone($this->_controller->getPreferences()->getTimezone()); $data[$name] = $date->get(Zend_Date::DATE_LONG).' '; $data[$name] .= $date->get(Zend_Date::TIME_LONG); */ $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName(), Sitengine_Env::PARAM_MDATE => $stored['mdate']); $args = array(Sitengine_Env::PARAM_ID => $stored['id'], Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_DOUPDATESNIPPET); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformUpdateSnippetTitle'); } else { require_once 'Sitengine/Form/TranscriptsPayloads.php'; $payloads = new Sitengine_Form_TranscriptsPayloads($this->_controller->getTranscripts()); $payloads->start(); $data = Sitengine_Controller_Request_Http::filterInsertDeprecated(sizeof($input), $input, $fieldsNormal, $fieldsOnOff); $gid = $this->_controller->getPermiso()->getDirectory()->getGroupId($this->_controller->getOwnerGroup()); $data[Sitengine_Permiso::FIELD_GID] = !is_null($gid) ? $gid : Sitengine_Permiso::GID_ADMINISTRATORS; $data[Sitengine_Permiso::FIELD_UID] = $this->_controller->getPermiso()->getAuth()->getId(); $hiddens = array(Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getName()); $args = array(Sitengine_Env::PARAM_PARENTID => $this->_controller->getEntity()->getParentId(), Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_DONEWSNIPPET); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX); $submitUri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $title = $this->_controller->getTranslate()->translate('labelsViewformNewSnippetTitle'); } #Sitengine_Debug::print_r($data); ######################################################################## #### ELEMENTS ######################################################################## if ($payloads->isMain()) { /* if( (!$data['id']) || # on insert (isset($data[Sitengine_Permiso::FIELD_UID]) && $data[Sitengine_Permiso::FIELD_UID]==$this->_controller->getPermiso()->getAuth()->getId()) || # owners ok #$this->_controller->getPermiso()->getUser()->hasSupervisorRights() || # supervisors ok #$this->_controller->getPermiso()->getUser()->hasModeratorRights() # moderators ok $this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS) ) { $n = Sitengine_Permiso::FIELD_UID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $users = $this->_controller->getPermiso()->getDirectory()->getAllUsers(); $elements[$n] = $e->getSelect($users); $n = Sitengine_Permiso::FIELD_GID; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormSelect'); $e->setId('viewForm'.$n); $groups = $this->_controller->getPermiso()->getDirectory()->getAllGroups(); $groups = array_merge($this->_controller->getTranslate()->translateGroup('fieldValsGid')->toArray(), $groups); $elements[$n] = $e->getSelect($groups); $n = Sitengine_Permiso::FIELD_RAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_RAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_UAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAG; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); $n = Sitengine_Permiso::FIELD_DAW; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); } */ $n = 'locked'; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm' . $n); $elements[$n] = $e->getCheckbox($data[$n]); /* $n = 'enabled'; $e = new Sitengine_Form_Element($n, '1'); $e->setClass('viewFormCheckbox'); $e->setId('viewForm'.$n); $elements[$n] = $e->getCheckbox($data[$n]); */ $n = 'keyword'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getText(40); $n = 'description'; $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormInput'); $e->setId('viewForm' . $n); $elements[$n] = $e->getTextarea(60, 10); } else { /* $n = 'htmlLang'.$payloads->getTranscriptIndex(); $elements['html'] = $this->_makeTextarea($n, $data[$n]); */ $n = 'htmlLang' . $payloads->getTranscriptIndex(); $e = new Sitengine_Form_Element($n, $data[$n]); $e->setClass('viewFormTextarea'); $e->setId('htmlTextarea'); $elements['html'] = $e->getTextarea(40, 10); } ######################################################################## #### CONTENT PAYLOAD SECTION TITLE ######################################################################## $contentSectionTitle = $this->_controller->getTranslate()->translate('labelsViewformContentSectionTitleDefault'); if (sizeof($this->_controller->getTranscripts()->get()) > 1) { if (!$payloads->isMain()) { $symbol = $payloads->getTranscriptSymbol(); } else { $symbol = $this->_controller->getTranscripts()->getDefaultSymbol(); } $contentSectionTitle .= ' (' . $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)) . ')'; } ######################################################################## #### PAYLOAD NAV DATA ######################################################################## $payloadNav = array(); if ($this->_inputMode == Sitengine_Env::INPUTMODE_UPDATE) { $args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_UPDATESNIPPET, Sitengine_Env::PARAM_ID => $stored['id'], Sitengine_Env::PARAM_PAYLOAD_NAME => $payloads->getMainName()); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); $payloadNav[$payloads->getMainName()] = array('uri' => $uri, 'label' => $this->_controller->getTranslate()->translate('labelsViewformPayloadNavTitleMain')); foreach ($this->_controller->getTranscripts()->get() as $index => $symbol) { $currentPayload = $payloads->getTranscriptNamePrefix() . '_' . $symbol; $args = array(Sitengine_Env::PARAM_ACTION => Sitengine_Sitemap_Backend_Controller::ACTION_UPDATESNIPPET, Sitengine_Env::PARAM_ID => $stored['id'], Sitengine_Env::PARAM_PAYLOAD_NAME => $currentPayload); $route = $this->_controller->getFrontController()->getRouter()->getRoute(Sitengine_Sitemap_Backend_Front::ROUTE_INDEX); $uri = $this->_controller->getRequest()->getBasePath() . '/' . $route->assemble($args, true); if (sizeof($this->_controller->getTranscripts()->get()) > 1) { $label = 'Inhalt (' . $this->_controller->getTranslate()->translate('languages' . ucfirst($symbol)) . ')'; } else { $label = $this->_controller->getTranslate()->translate('labelsViewformContentSectionTitleDefault'); } $payloadNav[$currentPayload] = array('uri' => $uri, 'label' => $label); } } ######################################################################## #### COLLECT ALL DATA ######################################################################## foreach ($hiddens as $k => $v) { $hiddens[$k] = Sitengine_Form_Element::getHidden($k, $v); } return array('payloadName' => $payloads->getName(), 'payloadIsMain' => $payloads->isMain(), 'payloadIsDefaultTranscript' => $payloads->isDefaultTranscript(), 'title' => $title, 'contentSectionTitle' => $contentSectionTitle, 'inputMode' => $this->_inputMode, 'hiddens' => implode('', $hiddens), 'submitUri' => $submitUri, 'ELEMENTS' => $elements, 'PAYLOADNAV' => $payloadNav, 'DATA' => $data); } catch (Exception $exception) { require_once 'Sitengine/Sitemap/Backend/Exception.php'; throw new Sitengine_Sitemap_Backend_Exception('form page error', $exception); } }