limit.php

一款可以和GOOGLE媲美的开源统计系统,运用AJAX.功能强大. 无色提示:按照需要PHP5.1以上和MySQL数据库支持。

<?php
/**
 * Piwik - Open source web analytics
 * 
 * @link http://piwik.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html Gpl v3 or later
 * @version $Id: Limit.php 503 2008-06-01 19:16:56Z matt $
 * 
 * @package Piwik_DataTable
 */

/**
 * Delete all rows from the table that are not in the offset,offset+limit range
 * 
 * @package Piwik_DataTable
 * @subpackage Piwik_DataTable_Filter 
 */

class Piwik_DataTable_Filter_Limit extends Piwik_DataTable_Filter
{	
	/**
	 * Filter constructor.
	 * 
	 * @param Piwik_DataTable $table
	 * @param int $offset Starting row (indexed from 0)
	 * @param int $limit Number of rows to keep (specify -1 to keep all rows)
	 */
	public function __construct( $table, $offset, $limit = null )
	{
		parent::__construct($table);
		$this->offset = $offset;
		
		if(is_null($limit))
		{
			$limit = -1;
		}
		$this->limit = $limit;
		$this->filter();
	}	
	
	protected function filter()
	{
		$table = $this->table;
		$rowsCount = $table->getRowsCount();
		
		// we delete from 0 to offset
		if($this->offset > 0) 
		{
			$table->deleteRowsOffset( 0, $this->offset );
		}
		// at this point the array has offset less elements. We delete from limit to the end
		if( $this->limit >= 0 )
		{
			$table->deleteRowsOffset( $this->limit );
		}
	}
}