/[openfoncier]/trunk/sql/pgsql/consultation.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/consultation.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 958 by fmichon, Mon Dec 3 02:13:41 2012 UTC revision 1167 by fmichon, Tue Jan 8 08:38:53 2013 UTC
# Line 67  if ($retourformulaire == 'dossier' Line 67  if ($retourformulaire == 'dossier'
67          'service.libelle as "'._("service").'"',          'service.libelle as "'._("service").'"',
68          $case_type_consultation.' as "'._("type_consultation").'"',          $case_type_consultation.' as "'._("type_consultation").'"',
69          'avis_consultation.libelle as "'._("avis_consultation").'"',          'avis_consultation.libelle as "'._("avis_consultation").'"',
70          "case consultation.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",          "case when consultation.avis_consultation is null then ''
71                  else case consultation.lu
72                           when 't' then 'Oui'
73                           else 'Non'
74                       end
75             end as \""._("lu")."\"",
76      );      );
77      // Filtre dur les données du dossier      // Filtre dur les données du dossier
78      $selection=" WHERE (consultation.dossier ='".$idx."')";      $selection=" WHERE (consultation.dossier ='".$idx."')";
Legend:
Removed from v.958  
changed lines
  Added in v.1167
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26