/** * action index * * @return void */ public function indexAction() { $allConfigs = \Sng\Recordsmanager\Utility\Config::getAllConfigs(2); if (empty($allConfigs)) { return null; } $this->currentConfig = $allConfigs[0]; $this->setCurrentConfig(); $this->buildCalendar(); $query = $this->buildQuery(); $query->setCheckPids(false); $query->setConfig($this->currentConfig); $query->setExportMode(true); $query->execQuery(); $this->exportRecords($query); $this->view->assign('moreThanSeven', version_compare(TYPO3_version, '7.0.0', '>=')); $this->view->assign('currentconfig', $this->currentConfig); $this->view->assign('arguments', $this->request->getArguments()); $this->view->assign('menuitems', $allConfigs); if ($query->getNbRows() > 0) { $this->view->assign('headers', $query->getHeaders()); $this->view->assign('rows', $query->getRows()); $this->view->assign('exportmodes', $this->getExportUrls()); } }
/** * action index * * @return void */ public function indexAction() { $allConfigs = \Sng\Recordsmanager\Utility\Config::getAllConfigs(1); if (empty($allConfigs)) { return null; } $this->currentConfig = $allConfigs[0]; $this->setCurrentConfig(); $arguments = $this->request->getArguments(); $temp_sys_page = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('TYPO3\\CMS\\Frontend\\Page\\PageRepository'); $addWhere = ' AND ' . $GLOBALS['BE_USER']->getPagePermsClause(1) . ' '; $pids = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('count(' . $this->currentConfig['sqltable'] . '.pid) as "nbrecords",' . $this->currentConfig['sqltable'] . '.pid,pages.title', $this->currentConfig['sqltable'] . ',pages', 'pages.uid=' . $this->currentConfig['sqltable'] . '.pid AND ' . $this->currentConfig['sqltable'] . '.deleted=0 ' . $addWhere . 'GROUP BY ' . $this->currentConfig['sqltable'] . '.pid '); $content = ''; $pidsFind = array(); $pidsAdmin = array(); // All find PIDs if (count($pids) > 0) { foreach ($pids as $pid) { $rootline = $temp_sys_page->getRootLine($pid['pid']); $path = $temp_sys_page->getPathFromRootline($rootline, 30); $pidsFind[] = array('pid' => $pid['pid'], 'path' => $path, 'nbrecords' => $pid['nbrecords']); } } // Admin specified PIDs if ($this->currentConfig['insertdefaultpid'] != '') { $pids = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('pages.uid,pages.title', 'pages', 'pages.deleted=0 AND pages.uid IN (' . $this->currentConfig['insertdefaultpid'] . ')' . $addWhere); if (count($pids) > 0) { foreach ($pids as $pid) { $nb = count($GLOBALS['TYPO3_DB']->exec_SELECTgetRows('uid', $this->currentConfig['sqltable'] . '', 'pid=' . $pid['uid'] . ' AND deleted=0 ')); $rootline = $temp_sys_page->getRootLine($pid['uid']); $path = $temp_sys_page->getPathFromRootline($rootline, 30); $pidsAdmin[] = array('pid' => $pid['uid'], 'path' => $path, 'nbrecords' => $nb); } } } $this->view->assign('pidsfind', $pidsFind); $this->view->assign('pidsadmin', $pidsAdmin); $this->view->assign('currentconfig', $this->currentConfig); $this->view->assign('arguments', $arguments); $this->view->assign('menuitems', $allConfigs); $this->view->assign('returnurl', $this->getReturnUrl()); // redirect to tce form if (!empty($arguments['create'])) { $this->redirectToForm($arguments['create']); } }
/** * action index * * @return void */ public function indexAction() { $allConfigs = \Sng\Recordsmanager\Utility\Config::getAllConfigs(0); if (empty($allConfigs)) { return null; } $this->currentConfig = $allConfigs[0]; $this->setCurrentConfig(); $query = $this->buildQuery(); $query->execQuery(); $this->view->assign('headers', $query->getHeaders()); $this->view->assign('rows', $query->getRows()); $this->view->assign('currentconfig', $this->currentConfig); $this->view->assign('arguments', $this->request->getArguments()); $this->view->assign('menuitems', $allConfigs); $this->view->assign('returnurl', rawurlencode($this->getReturnUrl())); $this->view->assign('deleteurl', $this->getDeleteUrl()); $this->view->assign('baseediturl', $this->getBaseEditUrl()); $this->view->assign('disableFields', implode(',', \tx_recordsmanager_flexfill::getDiffFieldsFromTable($this->currentConfig['sqltable'], $this->currentConfig['sqlfieldsinsert']))); }