WebSVN – Applications.gtt – Path Comparison – / – /trunk/ Rev 140 and /trunk/ Rev 141

Compare Revisions

This comparison shows the changes necessary to convert path

→ /trunk/ @ 140

→ /trunk/ @ 141

↔ Reverse comparison
Compare Path: Rev

With Path: Rev

Ignore whitespace Rev 140 → Rev 141

 /trunk/bibliotheque/metier/Projet.class.php
 ,8 → 202,8
                 switch ($cmd) {
                         case Projet::GP_TOUS:
                                 $requete =      'SELECT * '.
-                                                        'FROM gestion_projet '.
-                                                        'ORDER BY gp_nom ASC';
+                                                        'FROM gestion_projet LEFT JOIN gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '.
+                                                        'ORDER BY gpc_libelle, gp_nom ASC';
                                 break;
                         case Projet::GP_ID:
                                 $requete =      'SELECT * '.
 ,9 → 221,9
                                 break;
                         case Projet::GP_ID_LIST:
                                 $requete =      'SELECT * '.
-                                                        'FROM gestion_projet '.
+                                                        'FROM gestion_projet LEFT JOIN gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '.
                                                         'WHERE gp_id_projet IN (#0) '.
-                                                        'ORDER BY gp_nom';
+                                                        'ORDER BY gpc_libelle, gp_nom ASC';
                                 break;
                         case Projet::GP_CE_CATEGORIE:
                                 $requete =      'SELECT * '.

Subversion Repositories Applications.gtt

Compare Revisions

Ignore whitespace Rev 140 → Rev 141