/** * Compiles a list of trash items */ function viewTrash($option) { global $database, $mainframe, $mosConfig_list_limit; require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php'; $limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit); $limitstart = $mainframe->getUserStateFromRequest("view{" . $option . "}limitstart", 'limitstart', 0); // get the total number of content $query = "SELECT count(*)" . "\n FROM #__content AS c" . "\n LEFT JOIN #__categories AS cc ON cc.id = c.catid" . "\n LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope='content'" . "\n WHERE c.state = '-2'"; $database->setQuery($query); $total_content = $database->loadResult(); $pageNav_content = new mosPageNav($total_content, $limitstart, $limit); // Query content items $query = "SELECT c.*, g.name AS groupname, cc.name AS catname, s.name AS sectname" . "\n FROM #__content AS c" . "\n LEFT JOIN #__categories AS cc ON cc.id = c.catid" . "\n LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope='content'" . "\n INNER JOIN #__groups AS g ON g.id = c.access" . "\n LEFT JOIN #__users AS u ON u.id = c.checked_out" . "\n WHERE c.state = '-2'" . "\n ORDER BY s.name, cc.name, c.title" . "\n LIMIT " . $pageNav_content->limitstart . ", " . $pageNav_content->limit . ""; $database->setQuery($query); $contents = $database->loadObjectList(); $query = "SELECT count(*)" . "\n FROM #__menu AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n WHERE m.published = -2"; $database->setQuery($query); $total_menu = $database->loadResult(); //$total_menu = count( $total_menu ); $pageNav_menu = new mosPageNav($total_menu, $limitstart, $limit); // Query menu items $query = "SELECT m.*" . "\n FROM #__menu AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n WHERE m.published = -2" . "\n ORDER BY m.menutype, m.ordering, m.ordering, m.name" . "\n LIMIT " . $pageNav_menu->limitstart . ", " . $pageNav_menu->limit . ""; $database->setQuery($query); $menus = $database->loadObjectList(); for ($i = 0; $i < $total_content; $i++) { if ($contents[$i]->sectionid == 0 && $contents[$i]->catid == 0) { $contents[$i]->sectname = 'Typed Content'; } } HTML_trash::showList($option, $contents, $menus, $pageNav_content, $pageNav_menu); }
/** * Compiles a list of trash items */ function viewTrash($option) { global $database, $mainframe, $mosConfig_list_limit; $catid = $mainframe->getUserStateFromRequest("catid{$option}", 'catid', 'content'); $limit = intval($mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit)); $limitstart = intval($mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0)); require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php'; if ($catid == "content") { // get the total number of content $query = "SELECT count(*)" . "\n FROM #__content AS c" . "\n LEFT JOIN #__categories AS cc ON cc.id = c.catid" . "\n LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope = 'content'" . "\n WHERE c.state = -2"; $database->setQuery($query); $total = $database->loadResult(); $pageNav = new mosPageNav($total, $limitstart, $limit); // Query content items $query = "SELECT c.*, g.name AS groupname, cc.name AS catname, s.name AS sectname" . "\n FROM #__content AS c" . "\n LEFT JOIN #__categories AS cc ON cc.id = c.catid" . "\n LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope='content'" . "\n INNER JOIN #__groups AS g ON g.id = c.access" . "\n LEFT JOIN #__users AS u ON u.id = c.checked_out" . "\n WHERE c.state = -2" . "\n ORDER BY s.name, cc.name, c.title"; $database->setQuery($query, $pageNav->limitstart, $pageNav->limit); $content = $database->loadObjectList(); $num = $total; if ($limit < $total) { $num = $limit; } for ($i = 0; $i < $num - 1; $i++) { if ($content[$i]->sectionid == 0 && $content[$i]->catid == 0) { $content[$i]->sectname = 'Static Content'; } } } else { // get the total number of menu $query = "SELECT count(*)" . "\n FROM #__menu AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n WHERE m.published = -2"; $database->setQuery($query); $total = $database->loadResult(); $pageNav = new mosPageNav($total, $limitstart, $limit); // Query menu items $query = "SELECT m.name AS title, m.menutype AS sectname, m.type AS catname, m.id AS id" . "\n FROM #__menu AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n WHERE m.published = -2" . "\n ORDER BY m.menutype, m.ordering, m.ordering, m.name"; $database->setQuery($query, $pageNav->limitstart, $pageNav->limit); $content = $database->loadObjectList(); } // Build the select list $listselect = array(); $listselect[] = mosHTML::makeOption('content', 'Content Items'); $listselect[] = mosHTML::makeOption('menu', 'Menu Items'); $selected = "all"; $list = mosHTML::selectList($listselect, 'catid', 'class="inputbox" size="1" ' . 'onchange="document.adminForm.submit();"', 'value', 'text', $catid); HTML_trash::showList($option, $content, $pageNav, $list, $catid); }