[opencimetiere-Commits] r688 - trunk/sql/pgsql

[fmi...@adullact.net]

Author: fmichon
Date: 2018-03-16 08:51:55 +0100 (Fri, 16 Mar 2018)
New Revision: 688

Added:
trunk/sql/pgsql/defunt.reqmo.inc.php
Removed:
trunk/sql/pgsql/tri_defunt.reqmo.inc.php
Log:
* Renommage de la reqmo.


Copied: trunk/sql/pgsql/defunt.reqmo.inc.php (from rev 687, trunk/sql/pgsql/tri_defunt.reqmo.inc.php)
===================================================================
--- trunk/sql/pgsql/defunt.reqmo.inc.php (rev 0)
+++ trunk/sql/pgsql/defunt.reqmo.inc.php 2018-03-16 07:51:55 UTC (rev 688)
@@ -0,0 +1,38 @@
+<?php
+// Libellé de la requête
+$reqmo['libelle']=_("Liste des défunts trié par libellé du cimetière, nom et prénom du défunt");
+
+$reqmo['reqmo_libelle']=_('tri_defunt');
+
+// Requête à effectuer
+$reqmo['sql'] = "
+SELECT
+ cimetiere.cimetierelib,
+ CONCAT_WS(' ', titre_de_civilite.libelle, defunt.nom, defunt.marital, defunt.prenom) as defunt,
+ CONCAT_WS(' ', zone_type.libelle, zone.zonelib, emplacement.complement, voie_type.libelle, voie.voielib) as adresse,
+ emplacement.numero,
+ emplacement.nature,
+ emplacement.famille
+FROM
+ opencimetiere.defunt,
+ opencimetiere.emplacement,
+ opencimetiere.cimetiere,
+ opencimetiere.titre_de_civilite,
+ opencimetiere.voie,
+ opencimetiere.zone,
+ opencimetiere.voie_type,
+ opencimetiere.zone_type
+WHERE
+ defunt.titre = titre_de_civilite.titre_de_civilite AND
+ defunt.emplacement = emplacement.emplacement AND
+ emplacement.voie = voie.voie AND
+ voie.voietype = voie_type.voie_type AND
+ voie.zone = zone.zone AND
+ zone.zonetype = zone_type.zone_type AND
+ zone.cimetiere = cimetiere.cimetiere
+ORDER BY
+ cimetiere.cimetierelib,
+ defunt.nom,
+ defunt.prenom
+";
+?>
\ No newline at end of file

Deleted: trunk/sql/pgsql/tri_defunt.reqmo.inc.php
===================================================================
--- trunk/sql/pgsql/tri_defunt.reqmo.inc.php 2018-03-06 15:35:42 UTC (rev 687)
+++ trunk/sql/pgsql/tri_defunt.reqmo.inc.php 2018-03-16 07:51:55 UTC (rev 688)
@@ -1,38 +0,0 @@
-<?php
-// Libellé de la requête
-$reqmo['libelle']=_("Liste des défunts trié par libellé du cimetière, nom et prénom du défunt");
-
-$reqmo['reqmo_libelle']=_('tri_defunt');
-
-// Requête à effectuer
-$reqmo['sql'] = "
-SELECT
- cimetiere.cimetierelib,
- CONCAT_WS(' ', titre_de_civilite.libelle, defunt.nom, defunt.marital, defunt.prenom) as defunt,
- CONCAT_WS(' ', zone_type.libelle, zone.zonelib, emplacement.complement, voie_type.libelle, voie.voielib) as adresse,
- emplacement.numero,
- emplacement.nature,
- emplacement.famille
-FROM
- opencimetiere.defunt,
- opencimetiere.emplacement,
- opencimetiere.cimetiere,
- opencimetiere.titre_de_civilite,
- opencimetiere.voie,
- opencimetiere.zone,
- opencimetiere.voie_type,
- opencimetiere.zone_type
-WHERE
- defunt.titre = titre_de_civilite.titre_de_civilite AND
- defunt.emplacement = emplacement.emplacement AND
- emplacement.voie = voie.voie AND
- voie.voietype = voie_type.voie_type AND
- voie.zone = zone.zone AND
- zone.zonetype = zone_type.zone_type AND
- zone.cimetiere = cimetiere.cimetiere
-ORDER BY
- cimetiere.cimetierelib,
- defunt.nom,
- defunt.prenom
-";
-?>
\ No newline at end of file