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

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

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

trunk/sql/pgsql/instruction.inc revision 116 by fraynaud, Fri Sep 2 08:43:32 2011 UTC trunk/sql/pgsql/instruction.inc.php revision 312 by atreal, Wed Mar 28 17:19:49 2012 UTC
# Line 5  include('../gen/sql/pgsql/instruction.in Line 5  include('../gen/sql/pgsql/instruction.in
5  // =======================================================  // =======================================================
6  // href special edition instruction  // href special edition instruction
7  // =======================================================  // =======================================================
8  $table="instruction inner join evenement on instruction.evenement=evenement.evenement";  $table=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
9  $champAffiche=array("instruction as no",  $champAffiche=array("instruction as no",
10                      "instruction.lettretype",                      "instruction.lettretype",
11                      "libelle",                      "libelle",
12                      "to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",                      "to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",
13                      "instruction.etat"                      "instruction.etat",
14                        "dossier"
15                      );                      );
16  $champRecherche=array("libelle");  $champRecherche=array("libelle");
17  $tri= " order by instruction ";  $tri= " order by instruction ";
18  if(isset($idx)){  if(isset($idx)){
19      $selection=" where dossier ='".$idx."'";      $selection=" where dossier like '".$idx."'";
20  }else{  }else{
21     $selection="";     $selection="";
22  }    }  
Legend:
Removed from v.116  
changed lines
  Added in v.312
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26