. */ /** * PageTree generator * * @category WbACP * @package WbACP_Pages * @author Werner v.d.Decken * @copyright Werner v.d.Decken * @license http://www.gnu.org/licenses/gpl.html GPL License * @version 1.0.0 * @revision $Revision: 2070 $ * @link $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/admin/pages/PageTree.php $ * @lastmodified $Date: 2014-01-03 02:21:42 +0100 (Fri, 03 Jan 2014) $ * @since file added on 2012-12-21 */ class a_pages_PageTree { /** @var object instance of the application object */ protected $_oApp = null; /** @var object instance of the database object */ protected $_oDb = null; /** @var object instance holds several values from the application global scope */ protected $_oReg = null; /** @var object instance holds all of the translations */ protected $_oTrans = null; /** @var string full HTML formattet list of pages */ protected $_sOutput = ''; /** @var integer number of all reachable pages */ protected $_iPagesTotal = 0; /** @var integer number of all writeable pages */ protected $_iPagesWriteable = 0; /** @var integer index for toggle background color of the list */ protected $_iLineColor = 0; /** @var array entries to build a select list for parents */ protected $_aParentList = array(); /** @var integer count all executed database requests passing all iterations. */ protected $_queries = 0; /** * constructor used to import some application constants and objects */ public function __construct() { // import global vars and objects $this->_oApp = $GLOBALS['admin']; $this->_oDb = WbDatabase::getInstance(); $this->_oReg = WbAdaptor::getInstance(); $this->_oTrans = Translate::getInstance(); } /** * parse the page tree and return * @param int use page-ID as root of the generated page tree. (default: 0) * @return type */ public function parseTree($iTreeRoot = 0) { return $this->_createTree($iTreeRoot); } /** * parse the page tree and print it out * @param int use page-ID as root of the generated page tree. (default: 0) */ public function displayTree($iTreeRoot = 0) { echo $this->parseTree($iTreeRoot); } /** * total number of found pages which are visible for actual user * @return integer */ public function getTotalPages() { return $this->_iPagesTotal; } /** * number of found pages which are writable for actual user * @return integer */ public function getWriteablePages() { return $this->_iPagesWriteable; } /** * a list with all possible parent pages * @return array */ public function getParentList($iTreeRoot = 0) { if(!$this->_sOutput) { $this->parseTree($iTreeRoot); } return $this->_aParentList; } /** * create a page tree as a well formatted, unordered list * @param int use page-ID as root of the generated page tree. (default: 0) * @return string the whoole list */ protected function _createTree($iTreeRoot = 0) { // compose the complete list $sOutput = '' // build the head . $this->_Tabs(0 , true).'

'.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(0).''.PHP_EOL . $this->_Tabs(0).''.PHP_EOL . $this->_Tabs(0).''.PHP_EOL . $this->_Tabs(0).''.PHP_EOL . $this->_Tabs(-1).''.PHP_EOL . $this->_Tabs(-1).''.PHP_EOL . $this->_Tabs(-1).'

'.PHP_EOL.'	'.$this->_oTrans->TEXT_VISIBILITY. ' / '.$this->_oTrans->TEXT_MENU_TITLE.':	'.$this->_oTrans->TEXT_PAGE_TITLE. '	PID	'.$this->_oTrans->TEXT_ACTIONS. ':

'.PHP_EOL // generate the page lines . $this->_IterateTree($iTreeRoot) // build the footer . $this->_Tabs(-1).'

'.PHP_EOL; ; $this->_sOutput = $sOutput; return $sOutput; } /** * Create a string of multiple TABs to prettify the HTML-output * ingrease the number of TABs with a positive and degrease with an negative Value. * '0' means: do not change the value. Or set an absolute number using $bRelative=false * @staticvar int $iTabLevel * @param integer $iTabsDiv number of TABs to add/sub * @param bool $bRelative false if should be set to absolute value * @return string */ protected function _Tabs($iTabsDiv = 0, $bRelative = true) { static $iTabLevel = 0; $iTabLevel = ($bRelative ? $iTabLevel + $iTabsDiv : $iTabsDiv); $iTabLevel += ($iTabLevel < 0 ? 0 - $iTabLevel : $iTabsDiv); return str_repeat("\t", $iTabLevel); } /** * compose the needed SQL statement * @param integer $iParentKey * @return string SQL statement */ protected function _makeSql($iParentKey = 0) { $iParentKey = intval($iParentKey); $sql = 'SELECT ( SELECT COUNT(*) ' . 'FROM `'.$this->_oDb->TablePrefix.'pages` `x` ' . 'WHERE x.`parent`=p.`page_id`' . ') `children`, ' . 's.`module`, MAX(s.`publ_start` + s.`publ_end`) published, p.`link`, ' . '(SELECT MAX(`position`) FROM `'.$this->_oDb->TablePrefix.'pages` ' . 'WHERE `parent`='.$iParentKey.') max_position, ' . '0 min_position, ' . 'p.`position`, ' . 'p.`page_id`, p.`parent`, p.`level`, p.`language`, p.`admin_groups`, ' . 'p.`admin_users`, p.`viewing_groups`, p.`viewing_users`, p.`visibility`, ' . 'p.`menu_title`, p.`page_title`, p.`page_trail`, ' . 'GROUP_CONCAT(CAST(CONCAT(s.`section_id`, \' - \', s.`module`) AS CHAR) ORDER BY s.`position` SEPARATOR \'\n\') `section_list` ' . 'FROM `'.$this->_oDb->TablePrefix.'pages` p ' . 'INNER JOIN `'.$this->_oDb->TablePrefix.'sections` s ' . 'ON p.`page_id`=s.`page_id` ' . 'WHERE `parent`='.$iParentKey.' ' . (($this->_oReg->PageTrash != 'inline') ? 'AND `visibility`!=\'deleted\' ' : '') . 'GROUP BY p.`page_id` ' . 'ORDER BY p.`position` ASC'; return $sql; } /** * iterate through all nodes which having subnodes * @param integer start iteration from this parent page ( 0 = root) * @return string all of the item lines */ protected function _IterateTree($iParent = 0) { $sOutput = ''; // Get page list from database if(($oPages = $this->_oDb->query($this->_makeSql($iParent)))) { $this->_queries++; // output block-header $sOutput .= $this->_Tabs(0).'

fetchRow(MYSQL_ASSOC)) { // iterate through the current branch if($this->_oReg->PageLevelLimit && ($aPage['level'] > $this->_oReg->PageLevelLimit)) { return ''; } $aPage['min_position'] = ($aPage['position'] < $iMinPosition ? $aPage['position'] : $iMinPosition); $this->_iLineColor = $this->_iPagesTotal++ % 2; $aPage['iswriteable'] = false; if( $this->_oApp->ami_group_member($aPage['admin_users']) || $this->_oApp->is_group_match($this->_oApp->get_groups_id(), $aPage['admin_groups'])) { if(($aPage['visibility'] == 'deleted' && $this->_oReg->PageTrash == 'inline') || ($aPage['visibility'] != 'deleted')) { $aPage['iswriteable'] = true; $this->_iPagesWriteable++; } } else { if($aPage['visibility'] == 'private') { continue; } } // add this item to the secondary list of parents $this->_addToParentList($aPage); $sOutput .= $this->_createListItem($aPage); } $sOutput .= $this->_Tabs(-1).''.PHP_EOL; } return $sOutput; } /** * formating the given page object for output * @param type $aPage * @return string */ protected function _createListItem($aPage) { // output the current item // --- HEADER ------------------------------------------------------------------------ $sOutput = $this->_Tabs(0).'

'.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(1).''.PHP_EOL . $this->_Tabs(1).''.PHP_EOL; // --- TAB 1 --- (expand/collapse) --------------------------------------------------- $sOutput .= $this->_Tabs(1).''.PHP_EOL; // --- TAB 2 --- (menu title) -------------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 3 --- (page title) -------------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 4 --- (page ID) ----------------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 5 --- (show this page in new window) -------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 6 --- (edit settings) ----------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 7 --- (edit sections) ----------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 8 --- (move up) ----------------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 9 --- (move down) --------------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 10 --- (delete page) ------------------------------------------------------ $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 11 --- (add child page) --------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- TAB 12 --- (show language) ---------------------------------------------------- $sOutput .= $this->_Tabs(0).''.PHP_EOL; // --- FOOTER ------------------------------------------------------------------------ $sOutput .= $this->_Tabs(-1).''.PHP_EOL . $this->_Tabs(-1).''.PHP_EOL . $this->_Tabs(-1).'

'; if((bool)$aPage['children']) { $sOutput .= '' . '

'; }else { $sOutput .= ' '; } $sOutput .= '

'; if($this->_oApp->get_permission('pages_modify') && $aPage['iswriteable']) { $sOutput .= ''; } $sIcon = $this->_oReg->ThemeRel.'images/'.$aPage['visibility'].'_16.png'; if(!is_readable(rtrim($this->_oReg->DocumentRoot, '/').$sIcon)) { $sIcon = $this->_oReg->ThemeRel.'images/public_16.png'; } $sOutput .= ' $'.$this->_oTrans->TEXT_VISIBILITY.': ' . $this->_oTrans->{'TEXT_'.strtoupper($aPage['visibility'])} .'$ '; if($this->_oApp->get_permission('pages_modify') && $aPage['iswriteable']) { $sOutput .= ''.$aPage['menu_title'].''; }else { $sOutput .= ''.$aPage['menu_title'].''; } $sOutput .= '

'.$aPage['page_title'].'

'.$aPage['page_id'].'

'; if($aPage['visibility'] != 'deleted' && $aPage['visibility'] != 'none') { $sPageLink = $this->_oReg->AppRel.preg_replace( '/^'.preg_quote($this->_oReg->AppUrl, '/').'/siU', '', $this->_oApp->page_link($aPage['link']) ); $sOutput .= '

'; }else { $sOutput .= '

'; } $sOutput .= '

'; if($aPage['visibility'] != 'deleted') { if($this->_oApp->get_permission('pages_settings') && $aPage['iswriteable']) { $sOutput .= '' . ' '
. $this->_oTrans->TEXT_SETTINGS.'

'; } }else { $sOutput .= '

'; } $sOutput .= '

'; if( $this->_oReg->ManageSections && $this->_oApp->get_permission('pages_add') && $aPage['iswriteable'] ) { $file = $this->_oApp->page_is_active($aPage) ? "clock_16.png" : "clock_red_16.png"; $file = ($aPage['published'] && $aPage['module'] != 'menu_link') ? $file : 'noclock_16.png'; $sOutput .= '' . ' '
. $this->_oTrans->HEADING_MANAGE_SECTIONS.

'
. $this->_oTrans->HEADING_MANAGE_SECTIONS.

'; }else { $sOutput .= '

'; } $sOutput .= '

'; if($aPage['position'] > $aPage['min_position']) { if($aPage['visibility'] != 'deleted') { if($this->_oApp->get_permission('pages_settings') && $aPage['iswriteable']) { $sOutput .= '

'; } } } $sOutput .= '

'; if($aPage['position'] < $aPage['max_position']) { if($aPage['visibility'] != 'deleted') { if($this->_oApp->get_permission('pages_settings') && $aPage['iswriteable']) { $sOutput .= '

'; } } } $sOutput .= '

'; if($this->_oApp->get_permission('pages_delete') && $aPage['iswriteable']) { $sOutput .= '

'; }else { $sOutput .= '

'; } $sOutput .= '

'; if( $this->_oApp->get_permission('pages_add') && $aPage['iswriteable'] && ($aPage['visibility'] != 'deleted') && $aPage['level'] < ($this->_oReg->PageLevelLimit - 1) ) { $sOutput .= '

'.$this->_oTrans->HEADING_ADD_CHILD_PAGE.'

'; }else { $sOutput .= ' '; } $sOutput .= '

'.$aPage['language'].'

'.PHP_EOL; // if there children, iterate through this children now if((bool)$aPage['children']) { $sOutput .= $this->_IterateTree($aPage['page_id']); } $sOutput .= $this->_Tabs(-1).'

'.PHP_EOL; return $sOutput; } // end of method _createListItem /** * build a list of possible parent pages * @param array $aPage */ protected function _addToParentList(array $aPage) { if( ($aPage['level'] < ($this->_oReg->PageLevelLimit - 1)) && $aPage['iswriteable'] && ($aPage['visibility'] != 'deleted') && $this->_oApp->get_permission('pages_add') ) { $aPage['disabled'] = ($aPage['iswriteable'] ? 0 : 1); $this->_aParentList[] = $aPage; } } } // end of class PageTree