sql/pgsql/instruction.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:34 
include('../gen/sql/pgsql/instruction.inc.php');
// =======================================================
// href special edition instruction
// =======================================================
$table="instruction inner join evenement on instruction.evenement=evenement.evenement";
$champAffiche=array("instruction as no",
                    "instruction.lettretype",
                    "libelle",
                    "to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",
                    "instruction.etat"
                    );
$champRecherche=array("libelle");
$tri= " order by instruction ";
if(isset($idx)){
    $selection=" where dossier ='".$idx."'";
}else{
   $selection="";
}   
//if(isset($objsf) and isset($idx)){
    $href[3]['lien'] = "../pdf/pdflettretype_instruction.php?idx=";
    $href[3]['id']= "";
    $href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
//}else
//    $href=array();
?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:34
4			include('../gen/sql/pgsql/instruction.inc.php');
5	fraynaud	20	// =======================================================
6			// href special edition instruction
7			// =======================================================
8			$table="instruction inner join evenement on instruction.evenement=evenement.evenement";
9			$champAffiche=array("instruction as no",
10			"instruction.lettretype",
11			"libelle",
12			"to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",
13			"instruction.etat"
14			);
15			$champRecherche=array("libelle");
16			$tri= " order by instruction ";
17			if(isset($idx)){
18			$selection=" where dossier ='".$idx."'";
19			}else{
20			$selection="";
21			}
22			//if(isset($objsf) and isset($idx)){
23			$href[3]['lien'] = "../pdf/pdflettretype_instruction.php?idx=";
24			$href[3]['id']= "";
25			$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
26			//}else
27			// $href=array();
28	fraynaud	3	?>