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

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

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

trunk/sql/pgsql/instruction.form.inc revision 20 by fraynaud, Mon Jul 18 15:27:17 2011 UTC trunk/sql/pgsql/instruction.form.inc.php revision 1127 by vpihour, Thu Dec 27 15:07:37 2012 UTC
# Line 2  Line 2 
2  //$Id$  //$Id$
3  //gen openMairie le 10/02/2011 20:34  //gen openMairie le 10/02/2011 20:34
4  include('../gen/sql/pgsql/instruction.form.inc.php');  include('../gen/sql/pgsql/instruction.form.inc.php');
5  $tableSelect="instruction inner join evenement on instruction.evenement=evenement.evenement";  $tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
6  $champs=array("instruction",  $champs=array("instruction",
7                "destinataire",                "destinataire",
8                "instruction.evenement",                "instruction.evenement",
9                "libelle",                "libelle",
10                "datecourrier",                "date_evenement",
11                "instruction.lettretype",                "instruction.lettretype",
12                "complement",                "complement",
13                "'' as bible_auto",                "'' as bible_auto",
# Line 38  $champs=array("instruction", Line 38  $champs=array("instruction",
38                "instruction.etat",                "instruction.etat",
39                "instruction.accord_tacite",                "instruction.accord_tacite",
40                "instruction.delai_notification",                "instruction.delai_notification",
41                "instruction.avis",                "instruction.avis_decision",
42                "archive_delai",                "archive_delai",
43                "archive_accord_tacite",                "archive_accord_tacite",
44                "archive_etat",                "archive_etat",
# Line 52  $champs=array("instruction", Line 52  $champs=array("instruction",
52                "archive_date_achevement",                "archive_date_achevement",
53                "archive_date_conformite",                "archive_date_conformite",
54                "archive_date_chantier",                "archive_date_chantier",
55                      "complement12",
56                      "complement13",
57                      "complement14",
58                      "complement15"
59                );                );
60  $sql_transition = "select evenement,(libelle||' ['||evenement.action||']') as lib  $sql_transition = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib
61        from evenement inner join transition on evenement.action = transition.action";        from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement";
62          
63          
64    $sql_transition_by_id = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib
65          from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
66              where evenement=<idx>";
67    
68    $portlet_actions['pdfetat'] =
69           array('lien' => "../app/pdflettretype_instruction.php?idx=",
70                  'id' => '&obj=dossier',
71                  'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"".
72                            _("Edition")."\">"._("Edition")."</span>",
73                  'ordre' => 30,
74                  'ajax' => false);
75  ?>  ?>
Legend:
Removed from v.20  
changed lines
  Added in v.1127
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26