<?php
/**
 * Ce script permet d'effectuer la validation d'une opération.
 *
 * @package opencimetiere
 * @version SVN : $Id$
 */

//
require_once "../obj/utils.class.php";
$f = new utils(
    null, 
    "validation_operation", 
    _("operations")." -> "._("validation operation")
);

/**
 * Récupération du paramétrage
 */
//
$default_taille_urne = 0.1;
$taille_urne = $f->getParameter("taille_urne");
if (is_null($taille_urne)) {
    $taille_urne = $default_taille_urne;
}
//
$default_taille_cercueil = 1;
$taille_cercueil = $f->getParameter("taille_cercueil");
if (is_null($taille_cercueil)) {
    $taille_cercueil = $default_taille_cercueil;
}
//
$default_taille_reduction = 0.5;
$taille_reduction = $f->getParameter("taille_reduction");
if (is_null($taille_reduction)) {
    $taille_reduction = $default_taille_reduction;
}

/**
 * Initialisation des paramètres
 */
//
$validation = 0;
if (isset($_GET['validation'])) {
    $validation = $_GET['validation'];
}
//
$idx = 0;
if (isset($_GET['idx'])) {
    $idx = $_GET['idx'];
}
//
$categorie = 'inhumation';
if (isset($_GET['categorie'])) {
    $categorie = $_GET['categorie'];
}
//
$obj = "";
if (isset($_GET['obj'])) {
    $obj = $_GET['obj'];
}

/**
 *
 */
//
echo "<div id=\"edition\">\n";
//
$f->layout->display_start_fieldset();
//
echo _("operation");
//
$f->layout->display_stop_legend_fieldset();

/**
 *
 */
if ($validation == 0) {

    //
    echo "<form method=\"post\"";
    echo " action=\"validation_operation.php?validation=1&amp;idx=".$idx."&amp;categorie=".$categorie."&amp;obj=".$obj."\"";
    echo " name=\"f1\">\n";
    //
    $sql = "select date,numdossier, famille, operation.emplacement from ".DB_PREFIXE."operation
            inner join ".DB_PREFIXE."emplacement on emplacement.emplacement=operation.emplacement
            where operation = ".$idx;
    //
    $res = $f->db->query($sql);
    $f->isDatabaseError($res);
    //
    while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
        //
        $dossier = $row['numdossier'];
        //
        $dateoperation_fr = substr($row['date'], 8, 2)."/".substr($row['date'], 5, 2)."/".substr($row['date'], 0, 4);
        //
        echo _("operation")." "._("du")." ".$dateoperation_fr." no ".$dossier;
        echo "<br/>"._("emplacement")." ".$row['emplacement'];
        echo " ".$row['famille'];
    }
    //
    echo "<br/><br/>";
    echo "<input type=\"submit\" value=\""._('valider')." "._("operation")." ".$categorie." ".$dossier."\" />\n";
    //
    $params = array(
        "href" => "../scr/tab.php?obj=".$obj,
    );
    $f->layout->display_form_retour($params);
    //
    echo "</form>\n";

} else {

    //
    $f->db->autoCommit(false);
    //
    $sql = "select date, operation.emplacement, numdossier, famille, emplacement_transfert";
    $sql.= " from ".DB_PREFIXE."operation inner join ".DB_PREFIXE."emplacement on emplacement.emplacement = operation.emplacement ";
    $sql.= " where operation = ".$idx;
    $res =  $f->db->query($sql);
    $f->isDatabaseError($res);
    //
    while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
        //
        $dateoperation = $row['date'];
        //
        $dateoperation_fr = substr($dateoperation, 8, 2)."/".substr($dateoperation, 5, 2)."/".substr($dateoperation, 0, 4);
        $emplacement=$row['emplacement'];
        $dossier = $row['numdossier'];
        $famille=$row['famille'];
        $emplacement_transfert=$row['emplacement_transfert'];
        
    } 
    $sql = "select * from ".DB_PREFIXE."operation_defunt where operation = ".$idx;
    $res =  $f->db->query($sql);
    $f->isDatabaseError($res);
    while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
        if ($row['defunt_titre'] == "") {
            $val['titre'] = null;
        }else
            $val['titre']=$row['defunt_titre'];
        $val['nom']=$row['defunt_nom'];
        $val['prenom'] = $row['defunt_prenom'];
        $val['marital']=$row['defunt_marital'];
        if($row['defunt_datenaissance'])
            $val['datenaissance']=$row['defunt_datenaissance'];
        if($row['defunt_datedeces'])
            $val['datedeces'] = $row['defunt_datedeces'];
        $val['lieudeces'] = $row['defunt_lieudeces'];
        $val['nature'] = $row['defunt_nature'];
        $val['verrou']='Non';

        if ($categorie == 'inhumation') {
            $val['defunt']= $f->db->nextId(DB_PREFIXE.'defunt');
            $val['emplacement']=$emplacement;
            $val['dateinhumation']=$dateoperation;
            $val['exhumation']='Non';
            $val['reduction']='Non';
            if($val['nature'] == 'urne')
                $val['taille'] =$taille_urne;
            else
                $val['taille']=$taille_cercueil;
            $val['historique']= "".
               $categorie." "._("dossier")." ".$dossier." "._("du")." ".$dateoperation_fr."";
            $res1 = $f->db->autoExecute(DB_PREFIXE.'defunt', $val, DB_AUTOQUERY_INSERT);
            $f->isDatabaseError($res1);
            // recuperer identifiant defunt pour operation_defunt (clé secondaire)
            $sql = " update ".DB_PREFIXE."operation_defunt set defunt = ".$val['defunt'].
				   " where operation_defunt =".$row['operation_defunt'];
			$res2 = $f->db->query($sql);
            $f->isDatabaseError($res2);           
        }
        if ($categorie == 'reduction') {
            $sql="select historique from ".DB_PREFIXE."defunt where defunt =".$row['defunt'];
            $historique=$f->db->getOne($sql);
            $f->isDatabaseError($historique);
            $val['historique']=$historique."\n".
               $categorie." "._("dossier")." ".$dossier." "._("du")." ".$dateoperation_fr."";
            $val['defunt']=$row['defunt'];
            $val['datereduction']=$dateoperation;
            $val['reduction']='Oui';
            $val['taille']=$taille_reduction;
            $val['nature']="boite";
            $cle= " defunt = ".$row['defunt'];
            $res1 = $f->db->autoExecute(DB_PREFIXE.'defunt', $val, DB_AUTOQUERY_UPDATE, $cle);
            $f->isDatabaseError($res1);
        }
        if ($categorie == 'transfert') {
            $sql="select historique from ".DB_PREFIXE."defunt where defunt =".$row['defunt'];
            $historique=$f->db->getOne($sql);
            $f->isDatabaseError($historique);
            $val['historique']=$historique."\n".
               $categorie." "._("dossier")." ".$dossier." "._("du")." ".$dateoperation_fr." ".
                        _("emplacement")." ".$emplacement." ".$famille;
            $val['emplacement']=$emplacement_transfert;
            $cle= " defunt = ".$row['defunt'];
            $res1 = $f->db->autoExecute(DB_PREFIXE.'defunt', $val, DB_AUTOQUERY_UPDATE, $cle);
            $f->isDatabaseError($res1);
        }
        echo "<br>".$categorie." "._('defunt'). " ".$val['nom']." ".$val['marital']." ".$val['prenom'];
    }
    
    // calcul place occupees emplacement origine
    $sql = "select sum(taille) from ".DB_PREFIXE."defunt where emplacement = ".$emplacement;
    $place =  $f->db->getOne($sql);
    $f->isDatabaseError($place);
    if($place=='') $place=0;
    $sql = "update ".DB_PREFIXE."emplacement set placeoccupe=".$place.
           " where emplacement =".$emplacement;
    $res2 =  $f->db->query($sql);
    $f->isDatabaseError($res2);
    echo "<br/>"._("place occupee")." : "._("emplacement")." ".
            $emplacement." : ".$place;

    // calcul places occupees transfert
    if ($categorie == 'transfert') {
        //
        $sql = "select sum(taille) from ".DB_PREFIXE."defunt where emplacement = ".$emplacement_transfert;
        $place_transfert = $f->db->getOne($sql);
        $f->isDatabaseError($place_transfert);
        if ($place_transfert == '') {
            $place_transfert = 0;
        }
        //
        $sql = "update ".DB_PREFIXE."emplacement set placeoccupe=".$place_transfert." where emplacement =".$emplacement_transfert;
        $res4 =  $f->db->query($sql);
        $f->isDatabaseError($res4);
        echo "<br/>"._("place occupee")." "._('transfert')." "._("emplacement")." ".$emplacement_transfert." : ".$place_transfert;
    }
    // operation actif -> trt
    $sql = "update ".DB_PREFIXE."operation set etat='trt' where operation = ".$idx;
    $res3 =  $f->db->query($sql);
    $f->isDatabaseError($res3);
    //
    echo "<br/>";
    echo _("cloture")." "._("dossier")." : ".$dossier;
    //
    $f->db->commit();
    //
    echo "<br/>";
    echo "<b>"._("traitement")." "._("ok")."</b>";
    echo "<br/>";
    //
    $params = array(
        "href" => "../scr/tab.php?obj=".$obj,
    );
    $f->layout->display_form_retour($params);

}

/**
 *
 */
//
$f->layout->display_stop_fieldset();
//
echo "</div>\n";

?>