<?php

// In : utf8
// Out : utf8

// Liste des communes par utilisateur

Class InventoryLocationList extends DBAccessor {


	var $config;
	
	function InventoryLocationList($config) {

		$this->config=$config;
	}
	

	function getElement($uid){
		
		
			// Controle detournement utilisateur 
		    session_start();
		 	if (($_SESSION['user']!="") && $_SESSION['user']['name']!=$uid[0]) {    	  
		 		print "Acces interdit";
		 		return;
	     	}
	     	
	     	
			// uid[0] : utilisateur obligatoire
			// uid[1] : si absent : valeur 'all' (departement)
			// uid[2] : si absent : valeur 'all' (commune)
			// uid[3] : si absent : valeur 'all' (lieudit)
			
			$DB=$this->connectDB($this->config,'database_cel');
			
			$select="";
			 
			if (!isset($uid[1]) || $uid[1]=="" || $uid[1]=="all" ) {
				$uid[1]="all";
				$query_id_location="";
				$select="id_location";
			}
			else {
				$query_id_location=" AND id_location='".$DB->escapeSimple($uid[1])."' ";
			}
			
			
			if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all" ) {
				$uid[2]="all";
				$query_location="";
				if ($select=="")
					$select="location";
			}
			else {
				$query_location=" AND location='".$DB->escapeSimple($uid[2])."' ";
			}
			
			
			if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all") {
				$uid[3]="all";
				$query_lieudit="";
				if ($select=="")
					$select="lieudit";
			}
			else {
				$query_lieudit=" AND lieudit='".$DB->escapeSimple($uid[3])."' ";
			}
			

			$value=array();
	     	

	    	$query="SELECT DISTINCT ".
	    			$select. " AS id" .
	           		" FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " .
	           		$query_id_location.	
	           		$query_location.	
	           		$query_lieudit.	
	           		" ORDER BY ".$select;
	           		
		    $res =& $DB->query($query);
		    
	        if (DB::isError($res)) {
    	        die($res->getMessage());
        	}
        	
        	
            while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) {
                $value[]=array($row['id']);
                
    	    }
		
			$json = new Services_JSON();
			$output = $json->encode($value);
			print($output);
			
			return true;	


	}
	

}


/* +--Fin du code ---------------------------------------------------------------------------------------+
* $Log$
* Revision 1.6  2008-01-30 08:57:28  ddelon
* fin mise en place mygwt
*
* Revision 1.5  2007-05-22 12:54:09  ddelon
* Securisation acces utilisateur
*
*
* 
*/
 
?>