/[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 1227 by vpihour, Wed Jan 16 11:17:06 2013 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        LEFT JOIN ".DB_PREFIXE."signataire_arrete
10            ON instruction.signataire_arrete=signataire_arrete.signataire_arrete";
11  $champAffiche=array("instruction as no",  $champAffiche=array("instruction as no",
12                      "instruction.lettretype",                      "instruction.lettretype",
13                        "signataire_arrete.nom as \""._("signataire_arrete")."\"",
14                      "libelle",                      "libelle",
15                      "to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",                      "to_char(date_evenement ,'DD/MM/YYYY') as date_evenement",
16                      "instruction.etat"                      "instruction.etat",
17                        "dossier"
18                      );                      );
19  $champRecherche=array("libelle");  $champRecherche=array("libelle");
20  $tri= " order by instruction ";  $tri= " order by instruction ";
21  if(isset($idx)){  if(isset($idx)){
22      $selection=" where dossier ='".$idx."'";      $selection=" where dossier like '".$idx."'";
23  }else{  }else{
24     $selection="";     $selection="";
25  }    }  
 //if(isset($objsf) and isset($idx)){  
     $href[3]['lien'] = "../app/pdflettretype_instruction.php?idx=";  
     $href[3]['id']= "";  
     $href[3]['lib']=  "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".  
                         _("Edition")."\">"._("Edition")."</span>";  
 //    $href=array();  
26  ?>  ?>
Legend:
Removed from v.116  
changed lines
  Added in v.1227
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26