david
790d6f170a
git-svn-id: https://192.168.0.254/svn/Proyectos.MatritumCantat_Web/trunk@2 8e3496fd-7892-4c45-be36-0ff06e9dacc6
318 lines
8.6 KiB
PHP
318 lines
8.6 KiB
PHP
<?php
|
|
/**
|
|
* @version $Id: admin.trash.php 10002 2008-02-08 10:56:57Z willebil $
|
|
* @package Joomla
|
|
* @subpackage Trash
|
|
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
|
|
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL, see LICENSE.php
|
|
* Joomla! is free software. This version may have been modified pursuant
|
|
* to the GNU General Public License, and as distributed it includes or
|
|
* is derivative of works licensed under the GNU General Public License or
|
|
* other free or open source software licenses.
|
|
* See COPYRIGHT.php for copyright notices and details.
|
|
*/
|
|
|
|
// no direct access
|
|
defined( '_VALID_MOS' ) or die( 'Restricted access' );
|
|
|
|
// ensure user has access to this function
|
|
if (!($acl->acl_check( 'administration', 'manage', 'users', $my->usertype, 'components', 'com_trash' ))) {
|
|
mosRedirect( 'index2.php', _NOT_AUTH );
|
|
}
|
|
|
|
require_once( $mainframe->getPath( 'admin_html' ) );
|
|
require_once( $mainframe->getPath( 'class', 'com_frontpage' ) );
|
|
|
|
$mid = josGetArrayInts( 'mid' );
|
|
$cid = josGetArrayInts( 'cid' );
|
|
|
|
switch ($task) {
|
|
case 'deleteconfirm':
|
|
viewdeleteTrash( $cid, $mid, $option );
|
|
break;
|
|
|
|
case 'delete':
|
|
deleteTrash( $cid, $option );
|
|
break;
|
|
|
|
case 'restoreconfirm':
|
|
viewrestoreTrash( $cid, $mid, $option );
|
|
break;
|
|
|
|
case 'restore':
|
|
restoreTrash( $cid, $option );
|
|
break;
|
|
|
|
default:
|
|
viewTrash( $option );
|
|
break;
|
|
}
|
|
|
|
|
|
/**
|
|
* 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 );
|
|
}
|
|
|
|
|
|
/**
|
|
* Compiles a list of the items you have selected to permanently delte
|
|
*/
|
|
function viewdeleteTrash( $cid, $mid, $option ) {
|
|
global $database;
|
|
|
|
if (!in_array( 0, $cid )) {
|
|
// Content Items query
|
|
mosArrayToInts( $cid );
|
|
$cids = 'a.id=' . implode( ' OR a.id=', $cid );
|
|
$query = "SELECT a.title AS name"
|
|
. "\n FROM #__content AS a"
|
|
. "\n WHERE ( $cids )"
|
|
. "\n ORDER BY a.title"
|
|
;
|
|
$database->setQuery( $query );
|
|
$items = $database->loadObjectList();
|
|
$id = $cid;
|
|
$type = 'content';
|
|
} else if (!in_array( 0, $mid )) {
|
|
// Content Items query
|
|
mosArrayToInts( $mid );
|
|
$mids = 'a.id=' . implode( ' OR a.id=', $mid );
|
|
$query = "SELECT a.name"
|
|
. "\n FROM #__menu AS a"
|
|
. "\n WHERE ( $mids )"
|
|
. "\n ORDER BY a.name"
|
|
;
|
|
$database->setQuery( $query );
|
|
$items = $database->loadObjectList();
|
|
$id = $mid;
|
|
$type = 'menu';
|
|
}
|
|
|
|
HTML_trash::showDelete( $option, $id, $items, $type );
|
|
}
|
|
|
|
|
|
/**
|
|
* Permanently deletes the selected list of trash items
|
|
*/
|
|
function deleteTrash( $cid, $option ) {
|
|
global $database;
|
|
|
|
josSpoofCheck();
|
|
|
|
$type = mosGetParam( $_POST, 'type', array(0) );
|
|
|
|
$total = count( $cid );
|
|
|
|
if ( $type == 'content' ) {
|
|
$obj = new mosContent( $database );
|
|
$fp = new mosFrontPage( $database );
|
|
foreach ( $cid as $id ) {
|
|
$id = intval( $id );
|
|
$obj->delete( $id );
|
|
$fp->delete( $id );
|
|
}
|
|
} else if ( $type == 'menu' ) {
|
|
$obj = new mosMenu( $database );
|
|
foreach ( $cid as $id ) {
|
|
$id = intval( $id );
|
|
$obj->delete( $id );
|
|
}
|
|
}
|
|
|
|
$msg = $total. " Item(s) successfully Deleted";
|
|
mosRedirect( "index2.php?option=$option&mosmsg=". $msg ."" );
|
|
}
|
|
|
|
|
|
/**
|
|
* Compiles a list of the items you have selected to permanently delte
|
|
*/
|
|
function viewrestoreTrash( $cid, $mid, $option ) {
|
|
global $database;
|
|
|
|
if (!in_array( 0, $cid )) {
|
|
// Content Items query
|
|
mosArrayToInts( $cid );
|
|
$cids = 'a.id=' . implode( ' OR a.id=', $cid );
|
|
$query = "SELECT a.title AS name"
|
|
. "\n FROM #__content AS a"
|
|
. "\n WHERE ( $cids )"
|
|
. "\n ORDER BY a.title"
|
|
;
|
|
$database->setQuery( $query );
|
|
$items = $database->loadObjectList();
|
|
$id = $cid;
|
|
$type = "content";
|
|
} else if (!in_array( 0, $mid )) {
|
|
// Content Items query
|
|
mosArrayToInts( $mid );
|
|
$mids = 'a.id=' . implode( ' OR a.id=', $mid );
|
|
$query = "SELECT a.name"
|
|
. "\n FROM #__menu AS a"
|
|
. "\n WHERE ( $mids )"
|
|
. "\n ORDER BY a.name"
|
|
;
|
|
$database->setQuery( $query );
|
|
$items = $database->loadObjectList();
|
|
$id = $mid;
|
|
$type = "menu";
|
|
}
|
|
|
|
HTML_trash::showRestore( $option, $id, $items, $type );
|
|
}
|
|
|
|
|
|
/**
|
|
* Restores items selected to normal - restores to an unpublished state
|
|
*/
|
|
function restoreTrash( $cid, $option ) {
|
|
global $database;
|
|
|
|
josSpoofCheck();
|
|
|
|
$type = mosGetParam( $_POST, 'type', array(0) );
|
|
|
|
$total = count( $cid );
|
|
|
|
// restores to an unpublished state
|
|
$state = 0;
|
|
$ordering = 9999;
|
|
|
|
if ( $type == 'content' ) {
|
|
// query to restore content items
|
|
mosArrayToInts( $cid );
|
|
$cids = 'id=' . implode( ' OR id=', $cid );
|
|
$query = "UPDATE #__content"
|
|
. "\n SET state = " . (int) $state . ", ordering = " . (int) $ordering
|
|
. "\n WHERE ( $cids )"
|
|
;
|
|
$database->setQuery( $query );
|
|
if ( !$database->query() ) {
|
|
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
|
|
exit();
|
|
}
|
|
} else if ( $type == 'menu' ) {
|
|
sort( $cid );
|
|
|
|
foreach ( $cid as $id ) {
|
|
$check = 1;
|
|
$row = new mosMenu( $database );
|
|
$row->load( $id );
|
|
|
|
// check if menu item is a child item
|
|
if ( $row->parent != 0 ) {
|
|
$query = "SELECT id"
|
|
. "\n FROM #__menu"
|
|
. "\n WHERE id = " . (int) $row->parent
|
|
. "\n AND ( published = 0 OR published = 1 )"
|
|
;
|
|
$database->setQuery( $query );
|
|
$check = $database->loadResult();
|
|
|
|
if ( !$check ) {
|
|
// if menu items parent is not found that are published/unpublished make it a root menu item
|
|
$query = "UPDATE #__menu"
|
|
. "\n SET parent = 0, published = " . (int) $state . ", ordering = 9999"
|
|
. "\n WHERE id = " . (int) $id
|
|
;
|
|
}
|
|
}
|
|
|
|
if ( $check ) {
|
|
// query to restore menu items
|
|
$query = "UPDATE #__menu"
|
|
. "\n SET published = " . (int) $state . ", ordering = 9999"
|
|
. "\n WHERE id = " . (int) $id
|
|
;
|
|
}
|
|
|
|
$database->setQuery( $query );
|
|
if ( !$database->query() ) {
|
|
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
|
|
exit();
|
|
}
|
|
}
|
|
}
|
|
|
|
$msg = $total. " Item(s) successfully Restored";
|
|
mosRedirect( "index2.php?option=$option&mosmsg=". $msg ."" );
|
|
}
|
|
?>
|