| 818 |
$db->affectedRows()." "._('enregistrement'). |
$db->affectedRows()." "._('enregistrement'). |
| 819 |
" "._('mis_a_jour')."]" ; |
" "._('mis_a_jour')."]" ; |
| 820 |
} |
} |
| 821 |
|
|
| 822 |
|
// Envoi des infos au |
| 823 |
|
if ($this->valF['date_retour_signature'] != $this->getVal('date_retour_signature')) { |
| 824 |
|
$msgenque = new MessageEnqueuer(); |
| 825 |
|
$sqlArrete = "SELECT instruction.signataire_arrete as \"ws_DA_In_Signataire\", |
| 826 |
|
signataire_arrete.nom as \"ws_DA_In_Sign_Nom\", |
| 827 |
|
signataire_arrete.prenom as \"ws_DA_In_Sign_Prenom\", |
| 828 |
|
signataire_arrete.qualite as \"ws_DA_In_Sign_Qualite\", |
| 829 |
|
instruction.date_evenement as \"ws_DA_In_Dte_Redac\", |
| 830 |
|
'' as \"ws_DA_In_lieu_Redac\", |
| 831 |
|
instruction.dossier as \"ws_DA_In_N_Doss_DAS\", |
| 832 |
|
'' as \"ws_DA_In_Sigle\", |
| 833 |
|
instruction.etat as \"ws_DA_In_Decision\", |
| 834 |
|
dossier.date_depot as \"ws_DA_In_Dte_Depot_Dem\", |
| 835 |
|
dossier.terrain_numero as \"ws_DA_In_N_Voie\", |
| 836 |
|
'' as \"ws_DA_In_Type_Voie\", |
| 837 |
|
dossier.complement as \"ws_DA_In_Adresse1\", |
| 838 |
|
dossier.terrain_adresse_lieu_dit as \"ws_DA_In_Adresse2\", |
| 839 |
|
dossier.terrain_adresse_code_postal as \"ws_DA_In_CP\", |
| 840 |
|
dossier.terrain_adresse_localite as \"ws_DA_In_Ville\", |
| 841 |
|
dossier.terrain_references_cadastrales as \"ws_DA_In_Nb_Parcelle\", |
| 842 |
|
'' as \"ws_DA_In_Detail_Parcelle\", |
| 843 |
|
travaux.libelle as \"ws_DA_In_Nature_Trvx\", |
| 844 |
|
'' as \"ws_DA_In_Destination_Trvx\", |
| 845 |
|
dossier_autorisation_type_detaille.code as \"ws_DA_In_Type_Dos_Autoris\", |
| 846 |
|
COALESCE(particulier_nom,personne_morale_raison_sociale) as \"ws_DA_In_Nom_Petition\", |
| 847 |
|
COALESCE(particulier_prenom, personne_morale_denomination) as \"ws_DA_In_Prenom_Petition\", |
| 848 |
|
'' as \"ws_DA_In_Piece_GED\", |
| 849 |
|
instruction.date_retour_signature as \"ws_DA_In_Dte_Signature\" |
| 850 |
|
FROM ".DB_PREFIXE."instruction |
| 851 |
|
JOIN ".DB_PREFIXE."signataire_arrete ON |
| 852 |
|
instruction.signataire_arrete = signataire_arrete.signataire_arrete |
| 853 |
|
JOIN ".DB_PREFIXE."dossier ON |
| 854 |
|
instruction.dossier = dossier.dossier |
| 855 |
|
JOIN ".DB_PREFIXE."lien_dossier_demandeur ON |
| 856 |
|
lien_dossier_demandeur.dossier = dossier.dossier |
| 857 |
|
JOIN ".DB_PREFIXE."demandeur ON |
| 858 |
|
lien_dossier_demandeur.demandeur = demandeur.demandeur |
| 859 |
|
JOIN ".DB_PREFIXE."dossier_instruction_type ON |
| 860 |
|
dossier.dossier_instruction_type = dossier_instruction_type.dossier_instruction_type |
| 861 |
|
JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille ON |
| 862 |
|
dossier_instruction_type.dossier_autorisation_type_detaille = |
| 863 |
|
dossier_autorisation_type_detaille.dossier_autorisation_type_detaille |
| 864 |
|
LEFT JOIN ".DB_PREFIXE."travaux ON |
| 865 |
|
dossier.travaux = travaux.travaux |
| 866 |
|
WHERE instruction.instruction = ".$this->valF['instruction']; |
| 867 |
|
$resArrete = $this->db->query($sqlArrete); |
| 868 |
|
$this->f->addToLog("triggerModifierApres(): db->query(\"".$sqlArrete."\");", VERBOSE_MODE); |
| 869 |
|
$this->f->isDatabaseError(); |
| 870 |
|
|
| 871 |
|
$rowArrete = $resArrete->fetchRow(DB_FETCHMODE_ASSOC); |
| 872 |
|
$msgenque->setArreteInfo($rowArrete); |
| 873 |
|
$msgenque->enqueueMessage($msgenque::$ARRETE_ENVOI); |
| 874 |
|
} |
| 875 |
} |
} |
| 876 |
|
|
| 877 |
|
|
Parent Directory
| 
Revision Log
| 
Patch