sql/pgsql/instruction.form.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:34 
include('../gen/sql/pgsql/instruction.form.inc.php');
$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
$champs=array("instruction",
              "destinataire",
              "instruction.evenement",
              "libelle",
              "datecourrier",
              "instruction.lettretype",
              "complement",
              "'' as bible_auto",
              "'' as bible",
              "complement2",
              "'' as bible2",
              "complement3",
              "'' as bible3",
              "complement4",
              "'' as bible4",
              "complement5",
              "'' as bible5",
              "complement6",
              "'' as bible6",
              "complement7",
              "'' as bible7",
              "complement8",
              "'' as bible8",
              "complement9",
              "'' as bible9",
              "complement10",
              "'' as bible10",
              "complement11",
              "'' as bible11",
              "dossier",
              "instruction.action",
              "instruction.delai",
              "instruction.etat",
              "instruction.accord_tacite",
              "instruction.delai_notification",
              "instruction.avis",
              "archive_delai",
              "archive_accord_tacite",
              "archive_etat",
              "archive_avis",
              "archive_date_complet",
              "archive_date_rejet",
              "archive_date_limite",
              "archive_date_notification_delai",
              "archive_date_decision",
              "archive_date_validite",
              "archive_date_achevement",
              "archive_date_conformite",
              "archive_date_chantier",
              );
$sql_transition = "select evenement,(libelle||' ['||evenement.action||']') as lib
      from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.action = transition.action";

?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:34
4			include('../gen/sql/pgsql/instruction.form.inc.php');
5	fraynaud	242	$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
6	fraynaud	20	$champs=array("instruction",
7			"destinataire",
8			"instruction.evenement",
9			"libelle",
10			"datecourrier",
11			"instruction.lettretype",
12			"complement",
13			"'' as bible_auto",
14			"'' as bible",
15			"complement2",
16			"'' as bible2",
17			"complement3",
18			"'' as bible3",
19			"complement4",
20			"'' as bible4",
21			"complement5",
22			"'' as bible5",
23			"complement6",
24			"'' as bible6",
25			"complement7",
26			"'' as bible7",
27			"complement8",
28			"'' as bible8",
29			"complement9",
30			"'' as bible9",
31			"complement10",
32			"'' as bible10",
33			"complement11",
34			"'' as bible11",
35			"dossier",
36			"instruction.action",
37			"instruction.delai",
38			"instruction.etat",
39			"instruction.accord_tacite",
40			"instruction.delai_notification",
41			"instruction.avis",
42			"archive_delai",
43			"archive_accord_tacite",
44			"archive_etat",
45			"archive_avis",
46			"archive_date_complet",
47			"archive_date_rejet",
48			"archive_date_limite",
49			"archive_date_notification_delai",
50			"archive_date_decision",
51			"archive_date_validite",
52			"archive_date_achevement",
53			"archive_date_conformite",
54			"archive_date_chantier",
55			);
56	fraynaud	47	$sql_transition = "select evenement,(libelle\|\|' ['\|\|evenement.action\|\|']') as lib
57	fraynaud	242	from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.action = transition.action";
58	fraynaud	46
59	fraynaud	3	?>