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 {
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()->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);
########################################################################
#### 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 {
$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 {
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);
}
}
public function getGlobalNavSection(Sitengine_Translate $translate, array $queries, $current, $selectorPrefix = '')
{
$selected = '';
$items = array();
$location = 'backendHome';
$items[$queries[$location]] = '> ' . $translate->translate('labels' . ucfirst($location));
$items['separator10'] = '----------------';
$location = 'protoBackendGoodies';
$items[$queries[$location]] = '> ' . $translate->translate('labels' . ucfirst($location));
$selected = $current == 'protoBackendGoodies' ? $queries[$location] : $selected;
$n = 'globalNav';
require_once 'Sitengine/Form/Element.php';
$e = new Sitengine_Form_Element('', $selected);
$e->setScript('onchange="if(!this.options[this.selectedIndex].value.match(/^separator/)) { window.location=this.options[this.selectedIndex].value; }"');
$e->setClass($selectorPrefix . 'Select');
$e->setId($selectorPrefix . $n);
return array('ITEMS' => $items, 'menu' => $e->getSelect($items));
}
protected function _getMainSection()
{
try {
$valuePage = $this->_controller->getRequest()->get(Sitengine_Env::PARAM_PAGE);
$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 {
$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);
$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 {
$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 {
$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()->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);
$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);
$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);
}
}
