WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/InventoryDateList.php


<?php
 
// in : utf8
// out : utf8
 
// Liste les date de releves par utilisateur
 
 
Class InventoryDateList extends DBAccessor {
 
 
	var $config;
	
	function InventoryDateList($config) {
 
		$this->config=$config;
	}
	
 
	function getElement($uid){
		
 
			// uid[0] : utilisateur obligatoire
			// uid[1] : si absent : valeur 'all' (annee)
			// uid[2] : si absent : valeur 'all' (mois)
			// uid[3] : si absent : valeur 'all' (jour)
 
		   // Controle detournement utilisateur 
		    session_start();
		    
		 	$this->controleUtilisateur($uid[0]);
		
			$DB=$this->connectDB($this->config,'database_cel');
			
			$select = "date_observation" ;
			 
			if (!isset($uid[1]) || $uid[1]=="" || $uid[1]=="all" ) {
				$uid[1]="all";
				if ($select=="") $select="year(date_observation) ";
			}
			else {
				$query_year=" AND year(date_observation)='".$DB->escapeSimple($uid[1])."' ";
			}
			
			
			if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all" ) {
				$uid[2]="all";
				if ($select=="") $select="month(date_observation) ";
			}
			else {
				$query_month=" AND month(date_observation)='".$DB->escapeSimple($uid[2])."' ";
			}
 
			if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all" ) {
				$uid[3]="all";
				if ($select=="") $select="day(date_observation) ";
			}
			else {
				$query_day=" AND day(date_observation)='".$DB->escapeSimple($uid[3])."' ";
			}
			
		
			$value=array();
	
		
		
		   	$query="SELECT DISTINCT ".
	    			$select. " AS id" .
	           		" FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " .
	            	$query_year.
	            	$query_month.
	            	$query_day.
	           		" 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']);
    	    }
 
		
			$output = json_encode($value);
			print($output);
			
			return true;	
 
 
	}
	
 
 
}
 
 
/* +--Fin du code ---------------------------------------------------------------------------------------+
* $Log$
* Revision 1.4  2008-01-30 08:57:28  ddelon
* fin mise en place mygwt
*
* Revision 1.3  2007-05-22 12:54:09  ddelon
* Securisation acces utilisateur
*
*
* 
*/
 
 
 
?>

Rev 416	Rev 423
1	`<?php`	1	`<?php`
2		2
3	`// in : utf8`	3	`// in : utf8`
4	`// out : utf8`	4	`// out : utf8`
5		5
6	`// Liste les date de releves par utilisateur`	6	`// Liste les date de releves par utilisateur`
7		7
8		8
9	`Class InventoryDateList extends DBAccessor {`	9	`Class InventoryDateList extends DBAccessor {`
10		10
11		11
12	`var $config;`	12	`var $config;`
13		13
14	`function InventoryDateList($config) {`	14	`function InventoryDateList($config) {`
15		15
16	`$this->config=$config;`	16	`$this->config=$config;`
17	`}`	17	`}`
18		18
19		19
20	`function getElement($uid){`	20	`function getElement($uid){`
21		21
22		22
23	`// uid[0] : utilisateur obligatoire`	23	`// uid[0] : utilisateur obligatoire`
24	`// uid[1] : si absent : valeur 'all' (annee)`	24	`// uid[1] : si absent : valeur 'all' (annee)`
25	`// uid[2] : si absent : valeur 'all' (mois)`	25	`// uid[2] : si absent : valeur 'all' (mois)`
26	`// uid[3] : si absent : valeur 'all' (jour)`	26	`// uid[3] : si absent : valeur 'all' (jour)`
27		27
28	`// Controle detournement utilisateur`	28	`// Controle detournement utilisateur`
29	`session_start();`	29	`session_start();`
30		30
31	`$this->controleUtilisateur($uid[0]);`	31	`$this->controleUtilisateur($uid[0]);`
32		32
33	`$DB=$this->connectDB($this->config,'database_cel');`	33	`$DB=$this->connectDB($this->config,'database_cel');`
34		34
35	`$select = "date_observation" ;`	35	`$select = "date_observation" ;`
36		36
37	`if (!isset($uid[1]) \|\| $uid[1]=="" \|\| $uid[1]=="all" ) {`	37	`if (!isset($uid[1]) \|\| $uid[1]=="" \|\| $uid[1]=="all" ) {`
38	`$uid[1]="all";`	38	`$uid[1]="all";`
39	`if ($select=="") $select="year(date_observation) ";`	39	`if ($select=="") $select="year(date_observation) ";`
40	`}`	40	`}`
41	`else {`	41	`else {`
42	`$query_year=" AND year(date_observation)='".$DB->escapeSimple($uid[1])."' ";`	42	`$query_year=" AND year(date_observation)='".$DB->escapeSimple($uid[1])."' ";`
43	`}`	43	`}`
44		44
45		45
46	`if (!isset($uid[2]) \|\| $uid[2]=="" \|\| $uid[2]=="all" ) {`	46	`if (!isset($uid[2]) \|\| $uid[2]=="" \|\| $uid[2]=="all" ) {`
47	`$uid[2]="all";`	47	`$uid[2]="all";`
48	`if ($select=="") $select="month(date_observation) ";`	48	`if ($select=="") $select="month(date_observation) ";`
49	`}`	49	`}`
50	`else {`	50	`else {`
51	`$query_month=" AND month(date_observation)='".$DB->escapeSimple($uid[2])."' ";`	51	`$query_month=" AND month(date_observation)='".$DB->escapeSimple($uid[2])."' ";`
52	`}`	52	`}`
53		53
54	`if (!isset($uid[3]) \|\| $uid[3]=="" \|\| $uid[3]=="all" ) {`	54	`if (!isset($uid[3]) \|\| $uid[3]=="" \|\| $uid[3]=="all" ) {`
55	`$uid[3]="all";`	55	`$uid[3]="all";`
56	`if ($select=="") $select="day(date_observation) ";`	56	`if ($select=="") $select="day(date_observation) ";`
57	`}`	57	`}`
58	`else {`	58	`else {`
59	`$query_day=" AND day(date_observation)='".$DB->escapeSimple($uid[3])."' ";`	59	`$query_day=" AND day(date_observation)='".$DB->escapeSimple($uid[3])."' ";`
60	`}`	60	`}`
61		61
62		62
63	`$value=array();`	63	`$value=array();`
64		64
65		65
66		66
67	`$query="SELECT DISTINCT ".`	67	`$query="SELECT DISTINCT ".`
68	`$select. " AS id" .`	68	`$select. " AS id" .`
69	`" FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " .`	69	`" FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " .`
70	`$query_year.`	70	`$query_year.`
71	`$query_month.`	71	`$query_month.`
72	`$query_day.`	72	`$query_day.`
73	`" ORDER BY ".$select;`	73	`" ORDER BY ".$select;`
74		74
75		75
76	`$res =& $DB->query($query);`	76	`$res =& $DB->query($query);`
77		77
78	`if (DB::isError($res)) {`	78	`if (DB::isError($res)) {`
79	`die($res->getMessage());`	79	`die($res->getMessage());`
80	`}`	80	`}`
81	`while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) {`	81	`while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) {`
82	`$value[]=array($row['id']);`	82	`$value[]=array($row['id']);`
83	`}`	83	`}`
84		-
85	`$json = new Services_JSON();`	84
86	`$output = $json->encode($value);`	85	`$output = json_encode($value);`
87	`print($output);`	86	`print($output);`
88		87
89	`return true;`	88	`return true;`
90		89
91		90
92	`}`	91	`}`
93		92
94		93
95		94
96	`}`	95	`}`
97		96
98		97
99	`/* +--Fin du code ---------------------------------------------------------------------------------------+`	98	`/* +--Fin du code ---------------------------------------------------------------------------------------+`
100	`* $Log$`	99	`* $Log$`
101	`* Revision 1.4 2008-01-30 08:57:28 ddelon`	100	`* Revision 1.4 2008-01-30 08:57:28 ddelon`
102	`* fin mise en place mygwt`	101	`* fin mise en place mygwt`
103	`*`	102	`*`
104	`* Revision 1.3 2007-05-22 12:54:09 ddelon`	103	`* Revision 1.3 2007-05-22 12:54:09 ddelon`
105	`* Securisation acces utilisateur`	104	`* Securisation acces utilisateur`
106	`*`	105	`*`
107	`*`	106	`*`
108	`*`	107	`*`
109	`*/`	108	`*/`
110		109
111		110
112		111
113	`?>`	112	`?>`

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/InventoryDateList.php – Rev 416 → 423