Subversion Repositories eFlore/Applications.cel

Rev

Rev 1165 | Rev 1339 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1165 Rev 1172
Line 182... Line 182...
182
	}
182
	}
Line 183... Line 183...
183
 
183
 
Line 184... Line 184...
184
	private $nb_obs = 0;
184
	private $nb_obs = 0;
185
 
185
 
186
	private function compterObservations($params) {
186
	private function compterObservations($params) {
187
		$requete =  'SELECT COUNT(*) AS nb '.
187
		$requete =  'SELECT COUNT(*) as nb '.
188
					'FROM cel_inventory AS i '.
188
					'FROM cel_inventory AS i '.
189
                    '   LEFT JOIN locations AS l '.
189
                    '   LEFT JOIN locations AS l '.
190
                    '       ON (l.name = i.location AND l.code = i.id_location) '.
190
                    '       ON (l.name = i.location AND l.code = i.id_location) '.
191
                    "WHERE transmission = '1' ".
191
                    "WHERE transmission = '1' ".
192
					" AND ".
192
					" AND (".
193
					"(".$this->construireWhereRectangleStationOR()." OR ".
193
					$this->construireWhereRectangleStationOR()." OR ".
194
					$this->construireWhereRectangleCommuneOR().
194
					$this->construireWhereRectangleCommuneOR().") ".
195
					$this->construireWhereDept().
195
					$this->construireWhereDept().
196
                    $this->construireWhereCommune().
196
                    $this->construireWhereCommune().
197
                    $this->construireWhereUtilisateur().
197
                    $this->construireWhereUtilisateur().
Line 1239... Line 1239...
1239
				$commentaire_infos = array('observation', $commentaire);
1239
				$commentaire_infos = array('observation', $commentaire);
1240
			}
1240
			}
1241
		}
1241
		}
1242
		return $commentaire_infos;
1242
		return $commentaire_infos;
1243
	}
1243
	}
1244
}
-
 
1245
1244
}
-
 
1245
?>
-
 
1246
1246
1247