Subversion Repositories Applications.gtt

Rev

Rev 130 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 130 Rev 170
Line 59... Line 59...
59 
	/*** Aggregations : */
 59 
	/*** Aggregations : */
Line 60... Line 60...
60 
 
 60 
 
61 
	/*** Constructeur : */
 61 
	/*** Constructeur : */
62 
	public function __construct($cmd = null, $parametres = null)
 62 
	public function __construct($cmd = null, $parametres = null)
63 
	{
 63 
	{
64 
		$this->dao_table_nom = 'gestion_projet_categorie';
 64 
		$this->dao_table_nom = GTT_BDD_PREFIXE . 'gestion_projet_categorie';
65 
		$this->dao_correspondance = array(
 65 
		$this->dao_correspondance = array(
66 
			'gpc_id_categorie'	=> 'id_categorie',
 66 
			'gpc_id_categorie'	=> 'id_categorie',
67 
			'gpc_libelle'	=> 'libelle',
 67 
			'gpc_libelle'	=> 'libelle',
Line 114... Line 114...
114 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
 114 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
115 
	{
 115 
	{
116 
		switch ($cmd) {
 116 
		switch ($cmd) {
117 
			case ProjetCategorie::GPC_TOUS:
 117 
			case ProjetCategorie::GPC_TOUS:
118 
				$requete = 	'SELECT * '.
 118 
				$requete = 	'SELECT * '.
119 
							'FROM gestion_projet_categorie '.
 119 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet_categorie '.
120 
							'ORDER BY gpc_libelle';
 120 
							'ORDER BY gpc_libelle';
121 
				break;
 121 
				break;
122 
			case ProjetCategorie::GPC_ID:
 122 
			case ProjetCategorie::GPC_ID:
123 
				$requete = 	'SELECT * '.
 123 
				$requete = 	'SELECT * '.
124 
							'FROM gestion_projet_categorie '.
 124 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet_categorie '.
125 
							'WHERE gpc_id_categorie = #0 ';
 125 
							'WHERE gpc_id_categorie = #0 ';
126 
				break;
 126 
				break;
127 
			case ProjetCategorie::GPC_ID_MAX:
 127 
			case ProjetCategorie::GPC_ID_MAX:
128 
				$requete =	'SELECT MAX(gpc_id_categorie) AS gpc_id_categorie '.
 128 
				$requete =	'SELECT MAX(gpc_id_categorie) AS gpc_id_categorie '.
129 
							'FROM gestion_projet_categorie ';
 129 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet_categorie ';
130 
				break;
 130 
				break;
131 
			case ProjetCategorie::GPC_LIBELLE:
 131 
			case ProjetCategorie::GPC_LIBELLE:
132 
				$requete =	'SELECT * '.
 132 
				$requete =	'SELECT * '.
133 
							'FROM gestion_projet_categorie '.
 133 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet_categorie '.
134 
							'WHERE gpc_libelle = "#0" ';
 134 
							'WHERE gpc_libelle = "#0" ';
135 
				break;
 135 
				break;
136 
			default :
 136 
			default :
137 
				$message = 'Commande '.$cmd.'inconnue!';
 137 
				$message = 'Commande '.$cmd.'inconnue!';
138 
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);
 138 
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);