<?php
/**
* @brief Deletion Log Table
* @author <a href='https://www.invisioncommunity.com'>Invision Power Services, Inc.</a>
* @copyright (c) Invision Power Services, Inc.
* @license https://www.invisioncommunity.com/legal/standards/
* @package Invision Community
* @since 10 Nov 2016
*/
namespace IPS\core\DeletionLog;
/* To prevent PHP errors (extending class does not exist) revealing path */
if ( !defined( '\IPS\SUITE_UNIQUE_KEY' ) )
{
header( ( isset( $_SERVER['SERVER_PROTOCOL'] ) ? $_SERVER['SERVER_PROTOCOL'] : 'HTTP/1.0' ) . ' 403 Forbidden' );
exit;
}
/**
* Deletion Log Table
*/
class _Table extends \IPS\Helpers\Table\Table
{
/**
* @brief Title
*/
public $title = 'modcp_deleted';
/**
* Constructor
*
* @param \IPS\Http\Url Base URL
* @return void
*/
public function __construct( \IPS\Http\Url $url=NULL )
{
/* Init */
parent::__construct( $url );
}
/**
* Get rows
*
* @param array $advancedSearchValues Values from the advanced search form
* @return array
*/
public function getRows( $advancedSearchValues=NULL )
{
$this->sortBy = in_array( $this->sortBy, $this->sortOptions ) ? $this->sortBy : 'dellog_deleted_date';
$sortBy = $this->sortBy . ' ' . ( \strtolower( $this->sortDirection ) == 'asc' ? 'asc' : 'desc' );
/* Where Clause */
$where = array();
$where[] = array( "(dellog_content_permissions=? OR " . \IPS\Db::i()->findInSet( 'dellog_content_permissions', \IPS\Member::loggedIn()->groups ) . " OR " . \IPS\Db::i()->findInSet( 'dellog_content_permissions', array( 'm' . \IPS\Member::loggedIn()->member_id ) ) . ")", '*' );
/* Return only content from enabled apps */
$where[] = \IPS\Db::i()->in( 'dellog_content_class', array_values( \IPS\Content::routedClasses( TRUE, TRUE ) ) );
if ( $advancedSearchValues )
{
if ( isset( $advancedSearchValues['dellog_content_class'] ) AND $advancedSearchValues['dellog_content_class'] != 'all' )
{
$where[] = array( "dellog_content_class=?", $advancedSearchValues['dellog_content_class'] );
}
if ( isset( $advancedSearchValues['dellog_deleted_by'] ) )
{
$where[] = array( "dellog_deleted_by=?", $advancedSearchValues['dellog_deleted_by']->member_id );
}
}
$count = \IPS\Db::i()->select( 'COUNT(*)', 'core_deletion_log', $where )->first();
$this->pages = ceil( $count / $this->limit );
$it = new \IPS\Patterns\ActiveRecordIterator( \IPS\Db::i()->select( '*', 'core_deletion_log', $where, $sortBy, array( ( $this->limit * ( $this->page - 1 ) ), $this->limit ) ), 'IPS\core\DeletionLog' );
$return = array();
foreach( iterator_to_array( $it ) AS $row )
{
$return[ $row->id ] = $row;
}
return $return;
}
/**
* Return the table headers
*
* @param array|NULL $advancedSearchValues Advanced search values
* @return array
*/
public function getHeaders( $advancedSearchValues )
{
return array();
}
/**
* Multimod Actions
*
* @return array
*/
public function multimodActions()
{
return array(
'restore',
'restore_as_hidden',
'delete'
);
}
/**
* Can Moderate
*
* @return bool
*/
public function canModerate( $action=NULL )
{
return TRUE;
}
}