Subversion Repositories Applications.gtt

Rev

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

Rev 136 Rev 141
Line 200... Line 200...
200 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
 200 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
201 
	{
 201 
	{
202 
		switch ($cmd) {
 202 
		switch ($cmd) {
203 
			case Projet::GP_TOUS:
 203 
			case Projet::GP_TOUS:
204 
				$requete =	'SELECT * '.
 204 
				$requete =	'SELECT * '.
205 
							'FROM gestion_projet '.
 205 
							'FROM gestion_projet LEFT JOIN gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '.
206 
							'ORDER BY gp_nom ASC';
 206 
							'ORDER BY gpc_libelle, gp_nom ASC';
207 
				break;
 207 
				break;
208 
			case Projet::GP_ID:
 208 
			case Projet::GP_ID:
209 
				$requete = 	'SELECT * '.
 209 
				$requete = 	'SELECT * '.
210 
							'FROM gestion_projet '.
 210 
							'FROM gestion_projet '.
211 
							'WHERE gp_id_projet =  #0 ';
 211 
							'WHERE gp_id_projet =  #0 ';
Line 219... Line 219...
219 
				$requete =	'SELECT MAX(gp_id_projet) AS gp_id_projet '.
 219 
				$requete =	'SELECT MAX(gp_id_projet) AS gp_id_projet '.
220 
							'FROM gestion_projet ';
 220 
							'FROM gestion_projet ';
221 
				break;
 221 
				break;
222 
			case Projet::GP_ID_LIST:
 222 
			case Projet::GP_ID_LIST:
223 
				$requete =	'SELECT * '.
 223 
				$requete =	'SELECT * '.
224 
							'FROM gestion_projet '.
 224 
							'FROM gestion_projet LEFT JOIN gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '.
225 
							'WHERE gp_id_projet IN (#0) '.
 225 
							'WHERE gp_id_projet IN (#0) '.
226 
							'ORDER BY gp_nom';
 226 
							'ORDER BY gpc_libelle, gp_nom ASC';
227 
				break;
 227 
				break;
228 
			case Projet::GP_CE_CATEGORIE:
 228 
			case Projet::GP_CE_CATEGORIE:
229 
				$requete =	'SELECT * '.
 229 
				$requete =	'SELECT * '.
230 
							'FROM gestion_projet '.
 230 
							'FROM gestion_projet '.
231 
							'WHERE gp_ce_categorie = #0 ';
 231 
							'WHERE gp_ce_categorie = #0 ';