dbquerydescriptor.php

AJAX GRID 类及例子 使用 环境 PHP + MYSQL AJAX GRID

<?php

/**
 * Autor: Martin Bascal
 * Created on: 18/09/2007
 * Description:
 *    
 *    Describes a Data Base Query.
 *    
 */

class DBQueryDescriptor{
	
	// Join types
	public static $MAIN_TABLE = "MAIN TABLE";
	public static $INNER_JOIN = "INNER JOIN";
	public static $LEFT_JOIN = "LEFT JOIN";
	public static $RIGHT_JOIN = "RIGHT JOIN";
	
	private $_tableName;
	private $_columnsNames;
	private $_joinType;
	private $_joinCondition;
	
//	/**
//	 * Actualiza el nombre de tabla.
//	 *
//	 * @param String $tableName nuevo nombre
//	 */
//	function setTableName($tableName){
//		$this->_tableName = $tableName;
//	}
//	
//	
//	/**
//	 * Actualiza los nmbres de columnas.
//	 *
//	 * @param array $columnName nuevos nombres
//	 */
//	function setColumnsNames($columnsNames){
//		$this->_columnsNames = $columnName;
//	}
//	
//	
//	/**
//	 * Actualiza el tipo de JOIN.
//	 *
//	 * @param String $join nuevo JOIN
//	 */
//	function setJoinType($join){
//		$this->_joinType = $join;
//	}
//	
//	/**
//	 * Obtiene el tipo de JOIN
//	 *
//	 * @return String
//	 */
//	function getJoinType(){
//		return $this->_joinType;
//	}

	/**
	 * Obtiene los nombres de columnas.
	 *
	 * @return array
	 */
	function getColumnsNames(){
		return $this->_columnsNames;
	}
	
	/**
	 * Obtiene el nombre de tabla.
	 *
	 * @return String
	 */
	function getTableName(){
		return $this->_tableName;
	}

	/**
	 * Retorna una concatenaci贸n de <nombre_tabla>.<nombre_campo>
	 * 
	 * @return String
	 */
	function getFieldsForSelect(){
		$tableName = $this->_tableName;
		$ret = "";
		foreach($this->_columnsNames as $col){
			$ret .= "{$tableName}.{$col} AS {$tableName}_{$col},\n";
		}
		return $ret;
	}
	
	/**
	 * Obtiene un string que representa un FROM o JOIN.
	 * 
	 * @return String
	 */
	function getFromOrJoin(){
		if($this->_joinType == DBQueryDescriptor::$MAIN_TABLE){
			$ret = "FROM {$this->_tableName}\n";
		}
		else{
			$ret = "{$this->_joinType} {$this->_tableName} ON {$this->_joinCondition}\n";
		}
		return $ret;
	}
	
	function getDefaultSortBy(){
		return "{$this->_tableName}.{$this->_columnsNames[0]}";
	}
	
	/**
	 * Constructor
	 *
	 * @param String $tableName nombre de tabla
	 * @param array $columnsNames nombres de campos
	 * @param String $joinType se debe usar una de las constantes, por defaul toma MAIN_TABLE
	 */
	function __construct($tableName,$columnsNames,$joinType = "MAIN TABLE",$joinCondition = NULL){
		$this->_tableName = $tableName;
		$this->_columnsNames = $columnsNames;
		$this->_joinType = $joinType;
		$this->_joinCondition = $joinCondition;
	}
}
?>