1 |
<?php |
<?php |
2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 10/02/2011 20:39 |
//gen openMairie le 10/02/2011 20:39 |
4 |
|
|
5 |
require_once ("../gen/obj/dossier.class.php"); |
require_once ("../gen/obj/dossier.class.php"); |
6 |
|
|
7 |
class dossier extends dossier_gen { |
class dossier extends dossier_gen { |
15 |
var $auto_servitude_point; |
var $auto_servitude_point; |
16 |
var $auto_parcelle; |
var $auto_parcelle; |
17 |
var $auto_parcelle_lot; |
var $auto_parcelle_lot; |
18 |
|
var $aff_depot = "collapsible"; |
19 |
|
var $aff_travaux = "collapsible"; |
20 |
|
var $aff_instruction = "collapsible"; |
21 |
|
var $aff_demandeur = "startClosed"; |
22 |
|
var $aff_delegataire = "startClosed"; |
23 |
|
var $aff_terrain = "startClosed"; |
24 |
|
var $aff_localisation = "collapsible"; |
25 |
|
var $aff_description = "startClosed"; |
26 |
|
var $aff_amenagement = "startClosed"; |
27 |
|
|
28 |
|
function dossier($id,&$db,$DEBUG) { |
29 |
|
$this->constructeur($id,$db,$DEBUG); |
30 |
|
} // fin constructeur |
31 |
|
|
32 |
|
function setValFAjout($val = array()) { |
33 |
|
// Cle primaire |
34 |
|
$lettre=$this->f->collectivite["lettre"]; |
35 |
|
$numero_unique = $this->f->collectivite["numero_unique"]; |
36 |
|
if($numero_unique==1){ |
37 |
|
// numero unique (voir dyn/var.inc) |
38 |
|
$temp=$this->$db->nextId(DB_PREFIXE.$this->table); |
39 |
|
}else{ |
40 |
|
// numero suivant nature |
41 |
|
$temp=$this->db->nextId(DB_PREFIXE."dossier_".$val['nature']); |
42 |
|
} |
43 |
|
$temp=str_pad($temp,4,"0", STR_PAD_LEFT); |
44 |
|
$this->valF['dossier'] = $this->valF['nature'].$this->valF['annee']. |
45 |
|
$lettre.$temp; |
46 |
|
} |
47 |
|
|
48 |
function setvalF($val){ |
function setvalF($val){ |
49 |
parent::setvalF($val); |
parent::setvalF($val); |
|
// cles secondaires numerique (contrainte integrite pgsql) |
|
|
if(!is_numeric($val['instructeur'])) $this->valF['instructeur']= null; |
|
|
if(!is_numeric($val['architecte'])) $this->valF['architecte']= null; |
|
|
if(!is_numeric($val['travaux'])) $this->valF['travaux']= null; |
|
|
if(!is_numeric($val['demandeur_categorie'])) $this->valF['demandeur_categorie']= null; |
|
|
// cle secondaire alpha vide (contrainte integrite pgsql) |
|
|
if($val['demandeur_civilite']=='') $this->valF['demandeur_civilite']= null; |
|
|
if($val['delegataire_civilite']=='') $this->valF['delegataire_civilite']= null; |
|
|
// zone numerique non valorisée a 0 |
|
|
if(!is_numeric($val['delai'])) unset ($this->valF['delai']); |
|
|
if(!is_numeric($val['terrain_surface'])) unset ($this->valF['terrain_surface']); |
|
|
if(!is_numeric($val['batiment_nombre'])) unset ($this->valF['batiment_nombre']); |
|
|
if(!is_numeric($val['logement_nombre'])) unset ($this->valF['logement_nombre']); |
|
|
if(!is_numeric($val['shon'])) unset ($this->valF['shon']); |
|
|
if(!is_numeric($val['shob'])) unset ($this->valF['shob']); |
|
|
if(!is_numeric($val['lot'])) unset ($this->valF['lot']); |
|
|
if(!is_numeric($val['hauteur'])) unset ($this->valF['hauteur']); |
|
|
if(!is_numeric($val['piece_nombre'])) unset ($this->valF['piece_nombre']); |
|
|
if(!is_numeric($val['parcelle_lot'])) unset ($this->valF['parcelle_lot']); |
|
50 |
// enlever les valeurs a ne pas saisir -> recherche en trigger ajouter et modifier |
// enlever les valeurs a ne pas saisir -> recherche en trigger ajouter et modifier |
51 |
// $sig = 1 |
// $sig = 1 |
52 |
unset ($this->valF['geom']); |
unset ($this->valF['geom']); |
53 |
|
unset ($this->valF['geom1']); |
54 |
// valeurs hiddenstatic (calcule) |
// valeurs hiddenstatic (calcule) |
55 |
if($this->maj==1){ |
if($this->maj==1){ |
56 |
// par defaut |
// par defaut |
59 |
unset ($this->valF['accord_tacite']); |
unset ($this->valF['accord_tacite']); |
60 |
unset ($this->valF['types']); |
unset ($this->valF['types']); |
61 |
} |
} |
62 |
unset ($this->valF['avis']); // avis + libelle avis |
unset ($this->valF['avis_decision']); // avis + libelle avis |
63 |
unset ($this->valF['terrain_surface_calcul']); |
unset ($this->valF['terrain_surface_calcul']); |
64 |
unset ($this->valF['shon_calcul']); |
unset ($this->valF['shon_calcul']); |
65 |
unset ($this->valF['parcelle_archive']); |
unset ($this->valF['parcelle_archive']); |
70 |
unset ($this->valF['date_validite']); |
unset ($this->valF['date_validite']); |
71 |
unset ($this->valF['date_chantier']); |
unset ($this->valF['date_chantier']); |
72 |
unset ($this->valF['date_achevement']); |
unset ($this->valF['date_achevement']); |
73 |
unset ($this->valF['date_conformite']); |
unset ($this->valF['date_conformite']); |
|
} |
|
|
|
|
|
// specifique |
|
|
function setId($db){ |
|
|
// id automatique nextid |
|
|
// departement 13 |
|
|
// ville 004 |
|
|
// nature 2 caracteres |
|
|
// lettre R arles F vitrolles |
|
|
// numero sur 6 caracteres |
|
|
if (file_exists ("../dyn/var.inc")) |
|
|
include ("../dyn/var.inc"); |
|
|
if($numero_unique==1){ |
|
|
// numero unique (voir dyn/var.inc) |
|
|
$temp=$db->nextId(DB_PREFIXE.$this->table); |
|
|
}else{ |
|
|
// numero suivant nature |
|
|
$temp=$db->nextId(DB_PREFIXE."dossier_".$this->nature); |
|
|
} |
|
|
$temp=str_pad($temp,4,"0", STR_PAD_LEFT); |
|
|
$this->valF['dossier'] = $this->valF['nature'].$this->valF['annee']. |
|
|
$lettre.$temp; |
|
|
} |
|
|
|
|
|
// fonction a surcharger car utilisation d un nextID alpha |
|
|
function verifierAjout(){ |
|
74 |
} |
} |
75 |
|
|
76 |
function verifier($val,&$db,$DEBUG){ |
function verifier($val,&$db,$DEBUG){ |
77 |
$this->correct=True; |
parent::verifier($val,$db,$DEBUG); |
|
// obligatoire |
|
|
if($val['date_depot']==""){ |
|
|
// $this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
|
|
//}else{ |
|
|
$this->correct=false; |
|
|
$this->addToMessage("<br>date_depot obligatoire"); |
|
|
} |
|
78 |
if($val['parcelle']!="" and $val['sig']!='Oui'){ |
if($val['parcelle']!="" and $val['sig']!='Oui'){ |
79 |
if (!preg_match('/^[A-Z]{2}[0-9]{4}$/', $val['parcelle'])){ |
if (!preg_match('/^[A-Z0-9]{1}[A-Z]{1}[0-9]{4}$/', $val['parcelle'])){ |
80 |
$this->correct=false; |
$this->correct=false; |
81 |
$this->addToMessage("<br>format parcelle AANNNN"); |
$this->addToMessage("<br>format parcelle AANNNN"); |
82 |
} |
} |
200 |
|
|
201 |
|
|
202 |
function setType(&$form,$maj) { |
function setType(&$form,$maj) { |
203 |
//parent::setType($form,$maj); |
parent::setType($form,$maj); |
204 |
if ($maj < 2) { //ajouter et modifier |
if ($maj < 2) { //ajouter et modifier |
205 |
// cache |
// cache |
206 |
if($maj==0) $form->setType('dossier', 'hidden'); |
if($maj==0) $form->setType('dossier', 'hidden'); |
207 |
$form->setType('annee', 'hidden'); |
$form->setType('annee', 'hidden'); |
208 |
$form->setType('nature', 'hidden'); |
$form->setType('nature', 'select'); |
209 |
$form->setType('parcelle_archive','hidden'); |
$form->setType('parcelle_archive','hidden'); |
210 |
$form->setType('parcelle_lot_archive','hidden'); |
$form->setType('parcelle_lot_archive','hidden'); |
211 |
$form->setType('objet_dossier','hidden'); // PC |
$form->setType('objet_dossier','hidden'); // PC |
212 |
$form->setType('amenagement','hidden'); // PC |
$form->setType('amenagement','hidden'); // PC |
213 |
$form->setType('parcelle_lot','hidden'); // PC |
$form->setType('parcelle_lot','hidden'); // PC |
214 |
$form->setType('parcelle_lot_lotissement','hidden'); // PC |
$form->setType('parcelle_lot_lotissement','hidden'); // PC |
|
$form->setType('geom', 'hidden'); |
|
|
$form->setType('servitude', 'hiddenstatic'); |
|
|
$form->setType('description', 'textarea'); |
|
|
|
|
|
// date |
|
|
$form->setType('date_depot','date'); |
|
|
$form->setType('date_demande','date'); |
|
215 |
|
|
216 |
|
$form->setType('geom1', 'hidden'); |
217 |
|
$form->setType('geom', 'geom'); |
218 |
|
$form->setType('servitude', 'hiddenstatic'); |
219 |
|
|
220 |
//select |
//select |
221 |
$form->setType('travaux','select'); |
$form->setType('terrain_numero_complement','select'); |
|
$form->setType('instructeur','select'); |
|
|
$form->setType('terrain_numero_complement','select'); |
|
|
$form->setType('delegataire_civilite','select'); |
|
|
$form->setType('demandeur_civilite','select'); |
|
|
$form->setType('demandeur_categorie','select'); |
|
|
|
|
222 |
|
|
223 |
// combo |
// combo |
224 |
$form->setType('rivoli','comboD'); |
$form->setType('rivoli','comboD'); |
230 |
// hiddenstatic |
// hiddenstatic |
231 |
if($maj==1) $form->setType('dossier', 'hiddenstatic'); |
if($maj==1) $form->setType('dossier', 'hiddenstatic'); |
232 |
$form->setType('etat','hiddenstatic'); |
$form->setType('etat','hiddenstatic'); |
233 |
$form->setType('avis','hiddenstatic'); |
$form->setType('avis_decision','hiddenstatic'); |
234 |
$form->setType('delai','hiddenstatic'); |
$form->setType('delai','hiddenstatic'); |
235 |
$form->setType('terrain_surface_calcul','hiddenstatic'); |
$form->setType('terrain_surface_calcul','hiddenstatic'); |
236 |
$form->setType('shon_calcul','hiddenstatic'); |
$form->setType('shon_calcul','hiddenstatic'); |
276 |
$form->setType('temp3',$temp3_type); |
$form->setType('temp3',$temp3_type); |
277 |
$form->setType('temp4',$temp4_type); |
$form->setType('temp4',$temp4_type); |
278 |
$form->setType('temp5',$temp5_type); |
$form->setType('temp5',$temp5_type); |
279 |
}else{ // supprimer |
} |
280 |
$form->setType('dossier', 'hiddenstatic'); |
if($maj == 3) { |
281 |
$form->setType('sig', 'hiddenstatic'); |
$form->setType('annee', 'hidden'); |
282 |
|
$form->setType('nature', 'selectstatic'); |
283 |
|
$form->setType('temp1','hidden'); |
284 |
|
$form->setType('temp2','hidden'); |
285 |
|
$form->setType('temp3','hidden'); |
286 |
|
$form->setType('temp4','hidden'); |
287 |
|
$form->setType('temp5','hidden'); |
288 |
|
$form->setType('parcelle_archive','hidden'); |
289 |
|
$form->setType('parcelle_lot_archive','hidden'); |
290 |
|
$form->setType('geom1','hidden'); |
291 |
|
$form->setType('geom','hidden'); |
292 |
|
} |
293 |
|
if($this->f->getParameter('afficher_division')==='true') { |
294 |
|
$form->setType('division','hiddenstatic'); |
295 |
|
} else { |
296 |
|
$form->setType('division','hidden'); |
297 |
} |
} |
298 |
} |
} |
299 |
|
|
301 |
$this->maj=$maj; |
$this->maj=$maj; |
302 |
if ($validation==0) { |
if ($validation==0) { |
303 |
if ($maj == 0){ |
if ($maj == 0){ |
304 |
include ("../dyn/var.inc"); |
//$dossier_cp = $this->f->collectivite["cp"]; |
305 |
$form->setVal('nature', $this->nature); |
//$dossier_ville = $this->f->collectivite["ville"]; |
306 |
|
//$form->setVal('nature', $this->nature); |
307 |
|
|
308 |
$form->setVal('annee', date('y')); |
$form->setVal('annee', date('y')); |
309 |
$form->setVal('date_demande', date('Y-m-d')); |
$form->setVal('date_demande', date('Y-m-d')); |
310 |
$form->setVal('date_depot', date('Y-m-d')); |
$form->setVal('date_depot', date('Y-m-d')); |
311 |
|
|
312 |
$form->setVal('demandeur_cp', $dossier_cp); |
//$form->setVal('demandeur_cp', $dossier_cp); |
313 |
$form->setVal('demandeur_ville', $dossier_ville); |
//$form->setVal('demandeur_ville', $dossier_ville); |
314 |
|
|
315 |
$form->setVal('delegataire_cp', $dossier_cp); |
//$form->setVal('delegataire_cp', $dossier_cp); |
316 |
$form->setVal('delegataire_ville', $dossier_ville); |
//$form->setVal('delegataire_ville', $dossier_ville); |
317 |
|
|
318 |
$form->setVal('terrain_cp', $dossier_cp); |
//$form->setVal('terrain_cp', $dossier_cp); |
319 |
$form->setVal('terrain_ville', $dossier_ville); |
//$form->setVal('terrain_ville', $dossier_ville); |
320 |
|
|
321 |
$form->setVal('accord_tacite', 'Non'); |
$form->setVal('accord_tacite', 'Non'); |
322 |
$form->setVal('etat', 'initialiser'); |
$form->setVal('etat', 'initialiser'); |
323 |
$form->setVal('types', 'Initial'); |
$form->setVal('types', 'Initial'); |
324 |
} |
} |
325 |
} |
} |
326 |
} |
} |
327 |
|
|
328 |
function setSelect(&$form, $maj,&$db,$debug) { |
function setSelect(&$form, $maj,&$db,$debug) { |
329 |
|
parent::setSelect($form, $maj,$db,$debug); |
330 |
//optimisation sur table importante parcelle -> pas d appel methode parent |
//optimisation sur table importante parcelle -> pas d appel methode parent |
331 |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
332 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
353 |
} |
} |
354 |
$form->setSelect("travaux",$contenu); |
$form->setSelect("travaux",$contenu); |
355 |
|
|
|
//// instructeur |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_instructeur); |
|
|
if (database::isError($res)) die($res->getMessage().$sql_instructeur); |
|
|
$this->addToLog(" la requete ".$sql_instructeur." est executee", VERBOSE_MODE); |
|
|
$contenu[0][0]=""; |
|
|
$contenu[1][0]=_('choisir')." "._('instructeur'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect("instructeur",$contenu); |
|
|
|
|
|
// demandeur et delegataire civilite |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_civilite); |
|
|
if (database::isError($res)) die($res->getMessage().$sql_); |
|
|
$this->addToLog(" la requete ".$sql_civilite." est executee", VERBOSE_MODE); |
|
|
$contenu[0][0]=""; |
|
|
$contenu[1][0]=_('choisir')." "._('civilite'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect("demandeur_civilite",$contenu); |
|
|
$form->setSelect("delegataire_civilite",$contenu); |
|
|
|
|
|
// demandeur categorie |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_categorie_demandeur); |
|
|
if (database::isError($res)) die($res->getMessage().$sql_categorie_demandeur); |
|
|
$this->addToLog(" la requete ".$sql_categorie_demandeur." est executee", VERBOSE_MODE); |
|
|
$contenu[0][0]=""; |
|
|
$contenu[1][0]=_('choisir')." "._('categorie'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect("demandeur_categorie",$contenu); |
|
|
|
|
|
// pos |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_pos); |
|
|
if (database::isError($res)) die($res->getMessage().$sql_pos); |
|
|
$this->addToLog(" la requete ".$sql_pos." est executee", VERBOSE_MODE); |
|
|
$contenu[0][0]=""; |
|
|
$contenu[1][0]=_('choisir')." "._('pos'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect("pos",$contenu); |
|
|
|
|
356 |
// code et libelle voie |
// code et libelle voie |
357 |
$contenu=""; |
$contenu=""; |
358 |
$contenu[0][0]="rivoli";// table |
$contenu[0][0]="rivoli";// table |
397 |
$contenu=array(); |
$contenu=array(); |
398 |
$contenu[0]=array('Non','Oui'); |
$contenu[0]=array('Non','Oui'); |
399 |
$contenu[1]=array('Non','Oui'); |
$contenu[1]=array('Non','Oui'); |
|
$form->setSelect("etat",$contenu); |
|
400 |
$form->setSelect("accord_tacite",$contenu); |
$form->setSelect("accord_tacite",$contenu); |
401 |
// terrain_numero_complement |
// terrain_numero_complement |
402 |
$contenu=array(); |
$contenu=array(); |
403 |
$contenu[0]=array('','bis','ter','quater'); |
$contenu[0]=array('','bis','ter','quater'); |
404 |
$contenu[1]=array('','bis','ter','quater'); |
$contenu[1]=array('','bis','ter','quater'); |
405 |
$form->setSelect("terrain_numero_complement",$contenu); |
$form->setSelect("terrain_numero_complement",$contenu); |
406 |
|
// geom *** a voir |
407 |
|
if($maj==1){ //modification |
408 |
|
$contenu=array(); |
409 |
|
$contenu[0]=array("dossier",$this->getParameter("idx")); |
410 |
|
$form->setSelect('geom',$contenu); |
411 |
|
} |
412 |
|
|
413 |
|
} |
414 |
|
if($this->f->getParameter('afficher_division')==='true') { |
415 |
|
// instructeur |
416 |
|
$this->init_select($form, $db, $maj, $debug, "instructeur", |
417 |
|
$sql_instructeur_div, $sql_instructeur_div_by_id, false); |
418 |
} |
} |
419 |
} |
} |
420 |
|
|
421 |
|
function setLib(&$form,$maj) { |
422 |
|
parent::setLib($form,$maj); |
423 |
|
$form->setLib('geom',''); |
424 |
|
} |
425 |
|
|
426 |
function setGroupe(&$form,$maj){ |
function setGroupe(&$form,$maj){ |
427 |
If ($maj==0){ |
If ($maj==0){ |
428 |
$form->setGroupe('date_demande','D'); |
$form->setGroupe('date_demande','D'); |
429 |
$form->setGroupe('date_depot','G'); |
$form->setGroupe('date_depot','G'); |
430 |
$form->setGroupe('instructeur','F'); |
$form->setGroupe('division','F'); |
431 |
}else{ |
}else{ |
432 |
$form->setGroupe('dossier','D'); |
$form->setGroupe('dossier','D'); |
433 |
$form->setGroupe('nature','G'); |
$form->setGroupe('nature','G'); |
434 |
$form->setGroupe('annee','G'); |
$form->setGroupe('annee','G'); |
435 |
$form->setGroupe('date_demande','G'); |
$form->setGroupe('date_demande','G'); |
436 |
$form->setGroupe('date_depot','G'); |
$form->setGroupe('date_depot','G'); |
437 |
$form->setGroupe('instructeur','F'); |
$form->setGroupe('division','F'); |
438 |
} |
} |
439 |
$form->setGroupe('demandeur_categorie','D'); |
$form->setGroupe('demandeur_categorie','D'); |
440 |
$form->setGroupe('demandeur_civilite','G'); |
$form->setGroupe('demandeur_civilite','G'); |
498 |
$form->setGroupe('etat','F'); |
$form->setGroupe('etat','F'); |
499 |
|
|
500 |
$form->setGroupe('date_decision','D'); |
$form->setGroupe('date_decision','D'); |
501 |
$form->setGroupe('avis','G'); |
$form->setGroupe('avis_decision','G'); |
502 |
$form->setGroupe('date_validite','G'); |
$form->setGroupe('date_validite','G'); |
503 |
$form->setGroupe('types','F'); |
$form->setGroupe('types','F'); |
504 |
|
|
509 |
// localisation |
// localisation |
510 |
$form->setGroupe('parcelle','D'); |
$form->setGroupe('parcelle','D'); |
511 |
$form->setGroupe('pos','G'); |
$form->setGroupe('pos','G'); |
512 |
$form->setGroupe('sig','F'); |
if($maj==1){ |
513 |
|
$form->setGroupe('sig','G'); |
514 |
|
$form->setGroupe('geom','F'); |
515 |
|
}else { |
516 |
|
$form->setGroupe('sig','F'); |
517 |
|
} |
518 |
|
if($maj==1){ |
519 |
|
$form->setGroupe('sig','G'); |
520 |
|
$form->setGroupe('geom','F'); |
521 |
|
} |
522 |
|
|
523 |
// description |
// description |
524 |
$form->setGroupe('batiment_nombre','D'); |
$form->setGroupe('batiment_nombre','D'); |
525 |
$form->setGroupe('logement_nombre','G'); |
$form->setGroupe('logement_nombre','G'); |
561 |
$form->setRegroupe('date_demande','G',''); |
$form->setRegroupe('date_demande','G',''); |
562 |
} |
} |
563 |
$form->setRegroupe('date_depot','G',''); |
$form->setRegroupe('date_depot','G',''); |
564 |
$form->setRegroupe('instructeur','F',''); |
$form->setRegroupe('division','F',''); |
565 |
|
|
566 |
// travaux |
// travaux |
567 |
$form->setRegroupe('architecte','D',_('Architecte')." / "._("Travaux"), $this->aff_travaux); |
$form->setRegroupe('architecte','D',_('Architecte')." / "._("Travaux"), $this->aff_travaux); |
578 |
$form->setRegroupe('accord_tacite','G',''); |
$form->setRegroupe('accord_tacite','G',''); |
579 |
$form->setRegroupe('etat','G',''); |
$form->setRegroupe('etat','G',''); |
580 |
$form->setRegroupe('date_decision','G',''); |
$form->setRegroupe('date_decision','G',''); |
581 |
$form->setRegroupe('avis','G',''); |
$form->setRegroupe('avis_decision','G',''); |
582 |
$form->setRegroupe('date_validite','G',''); |
$form->setRegroupe('date_validite','G',''); |
583 |
$form->setRegroupe('types','G',''); |
$form->setRegroupe('types','G',''); |
584 |
$form->setRegroupe('date_chantier','G',''); |
$form->setRegroupe('date_chantier','G',''); |
625 |
$form->setRegroupe('parcelle','D',_('localisation'), $this->aff_localisation); |
$form->setRegroupe('parcelle','D',_('localisation'), $this->aff_localisation); |
626 |
$form->setRegroupe('pos','G',''); |
$form->setRegroupe('pos','G',''); |
627 |
$form->setRegroupe('sig','F',''); |
$form->setRegroupe('sig','F',''); |
628 |
|
if($maj==1){ |
629 |
|
$form->setRegroupe('sig','G',''); |
630 |
|
$form->setRegroupe('geom','F',''); |
631 |
|
} |
632 |
|
|
633 |
// description |
// description |
634 |
$form->setRegroupe('batiment_nombre','D',_('statistique'), $this->aff_description); |
$form->setRegroupe('batiment_nombre','D',_('statistique'), $this->aff_description); |
647 |
$form->setRegroupe('amenagement','D',_('Amenagement'), $this->aff_amenagement); |
$form->setRegroupe('amenagement','D',_('Amenagement'), $this->aff_amenagement); |
648 |
$form->setRegroupe('parcelle_lot','G',''); |
$form->setRegroupe('parcelle_lot','G',''); |
649 |
$form->setRegroupe('parcelle_lot_lotissement','F',''); |
$form->setRegroupe('parcelle_lot_lotissement','F',''); |
|
|
|
|
|
|
|
// temp |
|
650 |
} |
} |
651 |
|
|
|
|
|
|
|
|
652 |
/* ============================================================= |
/* ============================================================= |
653 |
* fonction trigger relative a la connexion SIG |
* fonction trigger relative a la connexion SIG |
654 |
* $sig = 1 dans dyn/var.inc |
* $sig = 1 dans dyn/var.inc |
660 |
$id=$this->valF['dossier']; // id n est pas valorise en ajout |
$id=$this->valF['dossier']; // id n est pas valorise en ajout |
661 |
if($this->sig==1 and $val['sig']!='Oui'){ |
if($this->sig==1 and $val['sig']!='Oui'){ |
662 |
if($val['parcelle']!=''or $val['parcelle_lot']!='') |
if($val['parcelle']!=''or $val['parcelle_lot']!='') |
663 |
$this->sig_interne($id,&$db,$val,$DEBUG); |
$this->sig_interne($id,$db,$val,$DEBUG); |
664 |
else |
else |
665 |
$this->addToMessage("<br>"._("Parcelle non renseignee dans dossier")." ".$id." <br>"); |
$this->addToMessage("<br>"._("Parcelle non renseignee dans dossier")." ".$id." <br>"); |
666 |
} |
} |
672 |
if(($this->sig==1 and $val['sig']!='Oui' and ($val['parcelle']!=$val['parcelle_archive']) |
if(($this->sig==1 and $val['sig']!='Oui' and ($val['parcelle']!=$val['parcelle_archive']) |
673 |
or $val['parcelle_lot']!=$val['parcelle_lot_archive'])){ // parcelle_lot_archive |
or $val['parcelle_lot']!=$val['parcelle_lot_archive'])){ // parcelle_lot_archive |
674 |
if($val['parcelle']!='' or $val['parcelle_lot']!='') |
if($val['parcelle']!='' or $val['parcelle_lot']!='') |
675 |
$this->sig_interne($this->valF['dossier'],&$db,$val,$DEBUG); |
$this->sig_interne($this->valF['dossier'],$db,$val,$DEBUG); |
676 |
else{ |
else{ |
677 |
if($this->maj ==1){ // en maj mettre a null la geometrie si parcelle changée inexistante |
if($this->maj ==1){ // en maj mettre a null la geometrie si parcelle changée inexistante |
678 |
$sql ="update ".DB_PREFIXE."dossier set geom = null, servitude = '', pos= '' where dossier ='".$id."'"; |
$sql ="update ".DB_PREFIXE."dossier set geom = null, servitude = '', pos= '' where dossier ='".$id."'"; |