29 |
$this->constructeur($id,$db,$debug); |
$this->constructeur($id,$db,$debug); |
30 |
}// fin constructeur |
}// fin constructeur |
31 |
|
|
|
function setvalF($val){ |
|
|
$this->valF['instruction'] = $val['instruction']; |
|
|
$this->valF['destinataire'] = $val['destinataire']; |
|
|
$this->valF['lettretype'] = $val['lettretype']; |
|
|
$this->valF['dossier'] = $val['dossier']; |
|
|
if($val['datecourrier']!="") |
|
|
$this->valF['datecourrier'] = $this->dateDB($val['datecourrier']); |
|
|
$this->valF['complement'] = $val['complement']; |
|
|
$this->valF['complement2'] = $val['complement2']; |
|
|
$this->valF['evenement'] = $val['evenement']; |
|
|
$this->valF['delai'] = $val['delai']; // necessaire pour maj datecourrier |
|
|
} |
|
|
|
|
|
|
|
32 |
function cleSecondaire($id,&$db,$val,$DEBUG) { |
function cleSecondaire($id,&$db,$val,$DEBUG) { |
33 |
parent::cleSecondaire($id,$db,$val,$DEBUG); |
parent::cleSecondaire($id,$db,$val,$DEBUG); |
34 |
// controle suppression cle secondaire [secondary key delete control] |
// controle suppression cle secondaire [secondary key delete control] |
49 |
} |
} |
50 |
} |
} |
51 |
|
|
|
function verifier($val,&$db,$DEBUG){ |
|
|
$this->correct=True; |
|
|
$imgv=""; |
|
|
$f=" ! "; |
|
|
$imgv="<img src='../app/img/punaise.png' style='vertical-align:middle' hspace='2' border='0'>"; |
|
|
// obligatoire |
|
|
if ($this->valF['destinataire']==""){ |
|
|
$this->correct=false; |
|
|
$this->msg= $this->msg.$imgv." "._('instruction')." ". |
|
|
_('obligatoire').$f; |
|
|
} |
|
|
if ($val['datecourrier']==""){ |
|
|
$this->correct=false; |
|
|
$this->msg= $this->msg.$imgv." "._('datecourrier')." ". |
|
|
_('obligatoire').$f; |
|
|
} |
|
|
if ($val['evenement']==""){ |
|
|
$this->correct=false; |
|
|
$this->msg= $this->msg.$imgv." "._('evenement')." ". |
|
|
_('obligatoire').$f; |
|
|
} |
|
|
}//verifier |
|
|
|
|
52 |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire){ |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire){ |
53 |
if ($validation==0) { |
if ($validation==0 and $maj<2) { |
54 |
if ($maj == 0){ |
if ($maj == 0){ |
55 |
$form->setVal("destinataire", $idxformulaire); |
$form->setVal("destinataire", $idxformulaire); |
56 |
$form->setVal("dossier", $idxformulaire); |
$form->setVal("dossier", $idxformulaire); |
65 |
} |
} |
66 |
|
|
67 |
function setType(&$form,$maj) { |
function setType(&$form,$maj) { |
68 |
if ($maj < 2) { //ajouter et modifier |
parent::setType($form,$maj); |
69 |
$form->setType('destinataire', 'hidden'); |
if ($maj < 2) { //ajouter et modifier |
70 |
$form->setType('lettretype', 'hiddenstatic'); |
$form->setType('destinataire', 'hidden'); |
71 |
$form->setType('complement', 'textarea'); |
$form->setType('lettretype', 'hiddenstatic'); |
72 |
$form->setType('complement2', 'textarea'); |
$form->setType('complement', 'textarea'); |
73 |
|
$form->setType('complement2', 'textarea'); |
74 |
|
$form->setType('bible_auto', 'httpclick'); |
75 |
|
$form->setType('bible', 'httpclick'); |
76 |
|
$form->setType('bible2', 'httpclick'); |
77 |
|
$form->setType('dossier', 'hiddenstatic'); |
78 |
|
$form->setType('libelle', 'hiddenstatic'); |
79 |
|
if($maj==0){ // add |
80 |
|
$form->setType('instruction', 'hiddenstatic'); |
81 |
|
$form->setType('evenement', 'select'); |
82 |
|
$form->setType('datecourrier', 'date2'); |
83 |
|
}else{ // modify |
84 |
|
$form->setType('instruction', 'hiddenstatic'); |
85 |
|
$form->setType('evenement', 'hiddenstatic'); |
86 |
|
//$form->setType('datecourrier', 'hiddenstaticdate'); |
87 |
|
$form->setType('datecourrier', 'date2'); |
88 |
|
// necessaire pour calcul de date en modification |
89 |
|
$form->setType('delai', 'hiddenstatic'); |
90 |
|
} |
91 |
|
}else{ // supprimer [delete] |
92 |
|
$form->setType('instruction', 'hiddenstatic'); |
93 |
|
$form->setType('dossier', 'hiddenstatic'); |
94 |
|
$form->setType('archive_delai', 'hiddenstatic'); |
95 |
|
$form->setType('archive_etat', 'hiddenstatic'); |
96 |
|
$form->setType('archive_accord_tacite', 'hiddenstatic'); |
97 |
|
$form->setType('archive_avis', 'hiddenstatic'); |
98 |
|
$form->setType('archive_date_complet', 'hiddenstatic'); |
99 |
|
$form->setType('archive_date_rejet', 'hiddenstatic'); |
100 |
|
$form->setType('archive_date_limite', 'hiddenstatic'); |
101 |
|
$form->setType('archive_date_notification_delai', 'hiddenstatic'); |
102 |
|
$form->setType('archive_date_decision', 'hiddenstatic'); |
103 |
|
$form->setType('archive_date_validite', 'hiddenstatic'); |
104 |
|
$form->setType('archive_date_achevement', 'hiddenstatic'); |
105 |
|
} |
106 |
$form->setType('complement3', 'hidden'); |
$form->setType('complement3', 'hidden'); |
107 |
|
$form->setType('bible_auto', 'hidden'); |
108 |
|
$form->setType('bible', 'hidden'); |
109 |
|
$form->setType('bible2', 'hidden'); |
110 |
$form->setType('bible3', 'hidden'); |
$form->setType('bible3', 'hidden'); |
111 |
$form->setType('complement4', 'hidden'); |
$form->setType('complement4', 'hidden'); |
112 |
$form->setType('bible4', 'hidden'); |
$form->setType('bible4', 'hidden'); |
132 |
$form->setType('bible14', 'hidden'); |
$form->setType('bible14', 'hidden'); |
133 |
$form->setType('complement15', 'hidden'); |
$form->setType('complement15', 'hidden'); |
134 |
$form->setType('bible15', 'hidden'); |
$form->setType('bible15', 'hidden'); |
|
$form->setType('bible_auto', 'httpclick'); |
|
|
$form->setType('bible', 'httpclick'); |
|
|
$form->setType('bible2', 'httpclick'); |
|
|
$form->setType('dossier', 'hiddenstatic'); |
|
135 |
$form->setType('delai', 'hidden'); |
$form->setType('delai', 'hidden'); |
136 |
$form->setType('etat', 'hidden'); |
$form->setType('etat', 'hidden'); |
137 |
$form->setType('accord_tacite', 'hidden'); |
$form->setType('accord_tacite', 'hidden'); |
150 |
$form->setType('archive_date_validite', 'hidden'); |
$form->setType('archive_date_validite', 'hidden'); |
151 |
$form->setType('archive_date_achevement', 'hidden'); |
$form->setType('archive_date_achevement', 'hidden'); |
152 |
$form->setType('archive_date_conformite', 'hidden'); |
$form->setType('archive_date_conformite', 'hidden'); |
153 |
$form->setType('archive_date_chantier', 'hidden'); |
$form->setType('archive_date_chantier', 'hidden'); |
|
$form->setType('libelle', 'hiddenstatic'); |
|
|
if($maj==0){ // add |
|
|
$form->setType('instruction', 'hiddenstatic'); |
|
|
$form->setType('evenement', 'select'); |
|
|
$form->setType('datecourrier', 'date2'); |
|
|
}else{ // modify |
|
|
$form->setType('instruction', 'hiddenstatic'); |
|
|
$form->setType('evenement', 'hiddenstatic'); |
|
|
//$form->setType('datecourrier', 'hiddenstaticdate'); |
|
|
$form->setType('datecourrier', 'date2'); |
|
|
// necessaire pour calcul de date en modification |
|
|
$form->setType('delai', 'hiddenstatic'); |
|
|
} |
|
|
}else{ // supprimer [delete] |
|
|
$form->setType('instruction', 'hiddenstatic'); |
|
|
$form->setType('dossier', 'hiddenstatic'); |
|
|
$form->setType('archive_delai', 'hiddenstatic'); |
|
|
$form->setType('archive_etat', 'hiddenstatic'); |
|
|
$form->setType('archive_accord_tacite', 'hiddenstatic'); |
|
|
$form->setType('archive_avis', 'hiddenstatic'); |
|
|
$form->setType('archive_date_complet', 'hiddenstatic'); |
|
|
$form->setType('archive_date_rejet', 'hiddenstatic'); |
|
|
$form->setType('archive_date_limite', 'hiddenstatic'); |
|
|
$form->setType('archive_date_notification_delai', 'hiddenstatic'); |
|
|
$form->setType('archive_date_decision', 'hiddenstatic'); |
|
|
$form->setType('archive_date_validite', 'hiddenstatic'); |
|
|
$form->setType('archive_date_achevement', 'hiddenstatic'); |
|
|
} |
|
154 |
} |
} |
|
|
|
|
function setTaille(&$form,$maj){ |
|
|
$form->setTaille('complement', 120); |
|
|
$form->setTaille('complement2', 120); |
|
|
$form->setTaille('datecourrier', 12); |
|
|
} |
|
|
|
|
|
function setMax(&$form,$maj){ |
|
|
$form->setMax('complement',12 ); |
|
|
$form->setMax('complement2',12 ); |
|
|
} |
|
|
|
|
155 |
|
|
156 |
function setSelect(&$form, $maj,&$db,$DEBUG) { |
function setSelect(&$form, $maj,&$db,$DEBUG) { |
157 |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
158 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
159 |
if($maj<2){ |
|
160 |
// *** evenement *** |
// *** evenement *** |
161 |
$contenu=array(); |
$contenu=array(); |
162 |
// etat du dossier |
// etat du dossier |
163 |
$sql="select etat from ".DB_PREFIXE."dossier where dossier ='". |
$sql="select etat from ".DB_PREFIXE."dossier where dossier ='". |
164 |
$this->idxformulaire."'"; |
$this->idxformulaire."'"; |
165 |
$etat_dossier = $db->getOne($sql); |
$etat_dossier = $db->getOne($sql); |
166 |
$nature_dossier= substr($this->idxformulaire,0,2); |
$nature_dossier= substr($this->idxformulaire,0,2); |
167 |
// recherche des evenement de transition |
// recherche des evenement de transition |
168 |
$sql= $sql_transition." where transition.etat ='".$etat_dossier."' and (evenement.nature ='". |
$sql= $sql_transition." where transition.etat ='".$etat_dossier."' and (evenement.nature ='". |
169 |
$nature_dossier."' or (nature ='T' and nature !='CU')) order by evenement.action"; |
$nature_dossier."' or (nature ='T' and nature !='CU')) order by evenement.action"; |
170 |
|
|
171 |
// *** attention en dur le CU |
// *** attention en dur le CU |
172 |
|
|
173 |
|
|
174 |
$res = $db->query($sql); |
$res = $db->query($sql); |
175 |
if (database::isError($res)) |
if (database::isError($res)) |
176 |
die($res->getMessage()); |
die($res->getMessage()); |
177 |
$contenu[0][0]=""; |
$contenu[0][0]=""; |
178 |
$contenu[1][0]=_('choisir')." "._('evenement'); |
$contenu[1][0]=_('choisir')." "._('evenement'); |
179 |
$k=1; |
$k=1; |
180 |
while ($row=& $res->fetchRow()){ |
while ($row=& $res->fetchRow()){ |
181 |
if($maj==0){ // ajouter |
if($maj==0){ // ajouter |
182 |
$contenu[0][$k]=$row[0]; |
$contenu[0][$k]=$row[0]; |
183 |
$contenu[1][$k]=$row[1]; |
$contenu[1][$k]=$row[1]; |
184 |
$k++; |
$k++; |
185 |
}else{ |
}else{ |
186 |
// select hiddenstatic |
// select hiddenstatic |
187 |
$contenu[0][$k]=$row[0]; |
$contenu[0][$k]=$row[0]; |
188 |
$contenu[1][$k]=$row[1]; |
$contenu[1][$k]=$row[1]; |
189 |
$k++; |
$k++; |
|
} |
|
190 |
} |
} |
|
$form->setSelect("evenement",$contenu); |
|
|
// lien bible_auto [link] |
|
|
$contenu=array(); |
|
|
$contenu[0]=" automatique "; |
|
|
$form->setSelect("bible_auto",$contenu); |
|
|
// lien bible1 |
|
|
$contenu=array(); |
|
|
$contenu[0]=" Bible "; |
|
|
$form->setSelect("bible",$contenu); |
|
|
// lien bible2 |
|
|
$contenu=array(); |
|
|
$contenu[0]=" Bible "; |
|
|
$form->setSelect("bible2",$contenu); |
|
191 |
} |
} |
192 |
|
$form->setSelect("evenement",$contenu); |
193 |
|
// lien bible_auto [link] |
194 |
|
$contenu=array(); |
195 |
|
$contenu[0]=" automatique "; |
196 |
|
$form->setSelect("bible_auto",$contenu); |
197 |
|
// lien bible1 |
198 |
|
$contenu=array(); |
199 |
|
$contenu[0]=" Bible "; |
200 |
|
$form->setSelect("bible",$contenu); |
201 |
|
// lien bible2 |
202 |
|
$contenu=array(); |
203 |
|
$contenu[0]=" Bible "; |
204 |
|
$form->setSelect("bible2",$contenu); |
205 |
} // function select |
} // function select |
206 |
|
|
207 |
function setGroupe(&$form,$maj){ |
function setGroupe(&$form,$maj){ |
233 |
$form->setLib('datecourrier',_(" du ")); |
$form->setLib('datecourrier',_(" du ")); |
234 |
} |
} |
235 |
|
|
|
function setOnchange(&$form,$maj){ |
|
|
$form->setOnchange("datecourrier","fdate(this)"); |
|
|
} |
|
|
|
|
236 |
// ================================================================== |
// ================================================================== |
237 |
// trigger avant modification données [trigger before modify data] |
// trigger avant modification données [trigger before modify data] |
238 |
// ================================================================== |
// ================================================================== |