'"; $sql_avis= "select avis,(avis||' '||libelle) from ".DB_PREFIXE."avis order by libelle"; $sql_avis_by_id = "SELECT avis.avis, (avis||' '||libelle) FROM ".DB_PREFIXE."avis WHERE avis = ''"; $sql_travaux= "select travaux, substring(libelle,1,50) as lib from ".DB_PREFIXE."travaux where TRUE"; $sql_travaux_by_id = "SELECT travaux.travaux, substring(libelle,1,50) as lib FROM ".DB_PREFIXE."travaux WHERE travaux = "; $sql_evenement= "select evenement,(evenement||' '||libelle) from ".DB_PREFIXE."evenement order by libelle"; $sql_evenement_by_id = "SELECT nature.nature, (evenement||' '||libelle) FROM ".DB_PREFIXE."nature WHERE nature = ''"; $sql_instructeur= "select om_utilisateur,nom from ".DB_PREFIXE."om_utilisateur where instructeur = 'Oui' order by nom"; $sql_architecte= "select architecte,(nom||' '||prenom) from ".DB_PREFIXE."architecte order by nom"; $sql_architecte_by_id = "SELECT architecte.architecte, (nom||' '||prenom) FROM ".DB_PREFIXE."architecte WHERE architecte = "; $sql_civilite= "select civilite,civilite from ".DB_PREFIXE."civilite order by civilite"; $sql_categorie_demandeur= "select categorie_demandeur,libelle as lib from ".DB_PREFIXE."categorie_demandeur order by categorie_demandeur"; $sql_categorie_demandeur_by_id = "SELECT categorie_demandeur.categorie_demandeur, categorie_demandeur.libelle FROM ".DB_PREFIXE."categorie_demandeur WHERE categorie_demandeur = "; $sql_amenagement = "select dossier,(dossier||' '||substring(demandeur_nom,1,30)) from ".DB_PREFIXE."dossier where nature ='PA' order by dossier"; $sql_amenagement_by_id = "select dossier,(dossier||' '||substring(demandeur_nom,1,30)) from ".DB_PREFIXE."dossier where pos = ''"; $sql_pos= "select pos,(pos||' '||libelle) from ".DB_PREFIXE."pos order by libelle"; $sql_pos_by_id = "SELECT pos.pos, (pos||' '||libelle) FROM ".DB_PREFIXE."pos WHERE pos = ''"; if($_GET['obj'] == "PC" or $_GET['obj'] == "DP" or $_GET['obj'] == "PD" or $_GET['obj'] == "PA") { $portlet_actions['pdfetat'] = array('lien' => '../pdf/pdfetat.php?idx=', 'id' => '&obj=dossier', 'lib' => ""._("Edition")."", 'ordre' => 30,); $portlet_actions['dossier'] = array('lien' => '../app/dossier.php?id=', 'id' => '&menu=2', 'lib' => " "._("Dossier"), 'ordre' => 40,); $portlet_actions['sig'] = array('lien' => '../scr/tab_sig.php?idx=', 'id' => '&obj=dossier', 'lib' => ""._("Sig")."", 'ordre' => 50,); } ?>