<?php
/**
 * Ce script a pour objet de recuperer l'info passée en paramètre : soit la nature (nouveau dossier,
 * dossier existant), soit le code du type de la demande
 *
 * @package openfoncier
 * @version SVN : $Id$
 */

require_once "../obj/utils.class.php";

$f = new utils("nohtml");
$f->isAccredited(array("demande","demande_modifier","demande_ajouter"), "OR");
$f->disableLog();

// Donnees
$id_demande_type = ($f->get_submitted_get_value("iddemandetype") != null) ? $f->get_submitted_get_value("iddemandetype") : "";
$info = ($f->get_submitted_get_value("info") != null) ? $f->get_submitted_get_value("info") : "";


if($id_demande_type != "" AND $info != "") {
    if($info == "nature") {
        $sql = "SELECT demande_nature.code FROM ".DB_PREFIXE."demande_nature
            INNER JOIN ".DB_PREFIXE."demande_type
                ON demande_type.demande_nature=demande_nature.demande_nature
            WHERE demande_type.demande_type=".$id_demande_type;
        $nature = $f->db->getOne($sql);
        $f->addToLog("app/getDemandeInfo.php : db->getOne(\"".$sql."\")", VERBOSE_MODE);
        $f->isDatabaseError($nature);
        echo $nature;
    }
    if($info == "contraintes") {
        $sql = "SELECT demande_type.contraintes FROM ".DB_PREFIXE."demande_type
            WHERE demande_type.demande_type=".$id_demande_type;
        $type = $f->db->getOne($sql);
        $f->addToLog("app/getDemandeInfo.php : db->getOne(\"".$sql."\")", VERBOSE_MODE);
        $f->isDatabaseError($type);
        echo $type;
    }
}

?>