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	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:34
4	include('../gen/sql/pgsql/instruction.form.inc.php');
5	$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
6	$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	$sql_transition = "select evenement,(libelle\|\|' ['\|\|evenement.action\|\|']') as lib
57	from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.action = transition.action";
58
59	?>