',
CASE WHEN co_projet_desc = '' THEN
NULL
ELSE
TRIM(co_projet_desc)
END,
CASE WHEN ope_proj_desc = '' THEN
NULL
ELSE
TRIM(ope_proj_desc)
END,
CASE WHEN am_projet_desc = '' THEN
NULL
ELSE
TRIM(am_projet_desc)
END,
CASE WHEN dm_projet_desc = '' THEN
NULL
ELSE
TRIM(dm_projet_desc)
END
) as \"description_projet\"",
"donnees_techniques.su_tot_shon_tot||' m²' as \"surface_total_projet\"",
"REGEXP_REPLACE(CONCAT(
CASE
WHEN donnees_techniques.su_cstr_shon1 IS NULL
THEN ''
ELSE CONCAT('Habitation - ', donnees_techniques.su_cstr_shon1, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon2 IS NULL
THEN ''
ELSE CONCAT('Hébergement hôtelier - ', donnees_techniques.su_cstr_shon2, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon3 IS NULL
THEN ''
ELSE CONCAT('Bureaux - ', donnees_techniques.su_cstr_shon3, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon4 IS NULL
THEN ''
ELSE CONCAT('Commerce - ', donnees_techniques.su_cstr_shon4, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon5 IS NULL
THEN ''
ELSE CONCAT('Artisanat - ', donnees_techniques.su_cstr_shon5, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon6 IS NULL
THEN ''
ELSE CONCAT('Industrie - ', donnees_techniques.su_cstr_shon6, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon7 IS NULL
THEN ''
ELSE CONCAT('Exploitation agricole ou forestière - ', donnees_techniques.su_cstr_shon7, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon8 IS NULL
THEN ''
ELSE CONCAT('Entrepôt - ', donnees_techniques.su_cstr_shon8, ' m²
')
END,
CASE
WHEN donnees_techniques.su_cstr_shon9 IS NULL
THEN ''
ELSE CONCAT('Service public ou d''intérêt collectif - ', donnees_techniques.su_cstr_shon9, ' m²')
END
), '
$', '') as \"surface\"",
"donnees_techniques.co_tot_ind_nb as \"nombre_logement_crees_individuel\"",
"donnees_techniques.co_tot_coll_nb as \"nombre_logement_crees_collectif\"",
"donnees_techniques.co_statio_apr_nb as \"nombre_places_parking\"",
// Fermeture fieldset "Principales caractéristiques du projet"
"consultation.service",
);
$sql_service="SELECT service.service, service.abrege||' '||service.libelle
FROM ".DB_PREFIXE."service
WHERE ((service.om_validite_debut IS NULL AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE))
OR (service.om_validite_debut <= CURRENT_DATE AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)))
ORDER BY service.abrege, service.libelle";
$sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = ";
$sql_autorite_competente="SELECT autorite_competente.autorite_competente,
autorite_competente.libelle
FROM ".DB_PREFIXE."autorite_competente
ORDER BY autorite_competente.libelle";
$sql_autorite_competente_by_id = "SELECT autorite_competente.autorite_competente,
autorite_competente.libelle
FROM ".DB_PREFIXE."autorite_competente
WHERE autorite_competente.autorite_competente = ";
?>