<?php
// CLASS [->CLASS_NAME<-]
// Last Update: [->CREATION_DATE<-] by Franco Milazzo

class [->CLASS_NAME<-] {

 	// DATABASE CONNECTION PROTECTED VARIABLES
  protected $m_db;                    // DB Connection
  protected $m_statement;             // Query statement
	protected $m_dataset;               // Query result dataset
  protected $m_sql;                   // SQL string with parameters
  protected $m_args;                  // Arguments for SQl strings (Array)    

  // CLASS PRIVATE VARIABLES
	
	private $m_[->DB_TABLE_KEY_ID<-];
			
	public $m_[->BASE_NAME<-]_list;

	public  function __construct(C_Database $m_db){
		$this->m_db = $m_db;
		$this->m_[->DB_TABLE_KEY_ID<-] = '';
	}
	
	public function load_data(){
	}

	///////////////////
  // SET FUNCTIONS //
  ///////////////////	
	
	public function set_[->DB_TABLE_KEY_ID<-]($m_[->DB_TABLE_KEY_ID<-]){
		$this->m_[->DB_TABLE_KEY_ID<-] = $m_[->DB_TABLE_KEY_ID<-];
	} 

	///////////////////
  // GET FUNCTIONS //
  ///////////////////
				
	public function get_[->DB_TABLE_KEY_ID<-](){
		return $this->m_[->DB_TABLE_KEY_ID<-];
	}

	/////////////////////
	// CLASS FUNCTIONS //
	/////////////////////
		
	public function load_[->BASE_NAME<-](){
		unset($this->m_[->BASE_NAME<-]_list);
		
		$this->m_sql = "SELECT [->DB_TABLE_KEY_ID<-] FROM [->DB_TABLE_NAME<-] ORDER BY [->DB_TABLE_KEY_ID<-] ASC";
    $this->m_statement = $this->m_db->run($this->m_sql);
    
		while ($m_[->BASE_NAME<-]_item = $this->m_statement->fetch()) {
			$m_[->DB_TABLE_KEY_ID<-]		= $m_[->BASE_NAME<-]_item['[->DB_TABLE_KEY_ID<-]'];

			$m_[->BASE_NAME<-]			 	= new C_[->BASE_NAME<-]Item($this->m_db);
			$m_[->BASE_NAME<-]->set_[->DB_TABLE_KEY_ID<-]($m_[->DB_TABLE_KEY_ID<-]);
			$m_[->BASE_NAME<-]->load_data();
			
			$this->m_[->BASE_NAME<-]_list[] = $m_[->BASE_NAME<-];
			
			$m_[->BASE_NAME<-] = null;
		}
	} 
	
	public function __destruct(){
	}
		
}
?>