sqlitetogrid.class.php

架設ROSE私服必備之物 ROSE數據庫

<?php
// +------------------------------------------------------------------------+
// | SQLiteToGrid                                                           |
// +------------------------------------------------------------------------+
// | Copyright (c) 2000-2003 Fr閐閞ic HENNINOT                              |        				   
// | Email         [e-mail]                                    |
// | Licence       This code is released under GPL                          |
// +------------------------------------------------------------------------+

/**
 * PHP4 Grid Presentation Data with more feature.
 * @package SQLiteManager
 * @author Fr閐閞ic HENNINOT <[e-mail]>
 * @version $Id: SQLiteToGrid.class.php,v 1.41 2006/04/14 15:16:52 freddy78 Exp $ $Revision: 1.41 $
 */

class SQLiteToGrid {
	
	/**
	* Resource connection
	* 
	* @access private
	* @var resource
	*/
	var $SQLiteConnId;
	
	/**
	* Original SQL Query
	*
    * @access private
	* @var string
	*/
	var $query;

	/**
	* Count SQL Query
	*
    * @access private
	* @var string
	*/
	var $queryCount;

	/**
	* SQL expression extract : between 'SELECT' and 'FROM'
	*
    * @access private
	* @var string
	*/
	var $listChamp;

	/**
	* Default sort order
	*
    * @access private
	* @var string
	*/
	var $queryOrderDefault;

	/**
	* Nombre d'enregistrement
	*
	* @access private
	* @var int
	*/
	var $nbRecordQuery;
	
	/**
	* SQL expression sort var
	*
    * @access private
	* @var string
	*/
	var $order;

	/**
	* SQL Init Sort column
	* @access private
	* @var int
	*/
	var $orderInit;
	
	/**
	* Number of record per page
	*
    * @access private
	* @var string
	*/
	var $recordPerPage;		
	
	/**
	* Veritable requ阾e execut閑
	*
	* @access private
	* @var string
	*/
	var $realQuery;	

	/**
    * @access private
	* @var array
	* Column title label
	*/
	var $title;	
	
	/**
	* Identification table, to view many table in one page
	* 
	* @access private
	* @var string
	*/
	var $tabId;
	
	/**
	* boolean array for Enable/Disable sort column
	*
    * @access private
	* @var array
	*/
	var $sort;
	
	/**
 	* Column title style.
	* true : button for sort column
	* false : hyperlink for sort column
	*
	* @access private
	* @var bool
	*/
	var $buttonStyle=true;
	
	/**
	* Add var to hyperlink.
	* Allow full domain
	* example : 
	* index.php?action=module&module=user
	* ?action=module
	*
    * @access private
	* @var string
	*/
	var $getVar;
	
	/**
	* data to print
	*
	* @access private
	* @var array
	*/
	var $data;
	
	/**
	* tableau des styles 'CSS'.
	* if empty, automatic value for TD, TABLE and BUTTON
	*
    * @access private
	* @var array
	*/	
	var $style;
	
	/**
	* Alignement of the column result, without title
	*
    * @access private
	* @var array
	*/
	var $align;
	
	/**
	* Formatage d'affichage de la colonne. Le resultat des autres colonne peuvent 阾re utilis