<?php  //encoding: utf-8
/*
"The contents of this file are subject to the Mozilla Public License
Version 1.1 (the "License"); you may not use this file except in
compliance with the License. You may obtain a copy of the License at
http://www.mozilla.org/MPL/

Software distributed under the License is distributed on an "AS IS"
basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
License for the specific language governing rights and limitations
under the License.

The Original Code is kalosori.

The Initial Developer of the Original Code is Pascal Guimier.
Copyright (C) Pascal Guimier. All Rights Reserved.

Alternatively, the contents of this file may be used under the terms
of the GPL license (the  "Gniu Public License"), in which case the
provisions of GPL License are applicable instead of those
above. If you wish to allow use of your version of this file only
under the terms of the GPL License and not to allow others to use
your version of this file under the MPL, indicate your decision by
deleting the provisions above and replace them with the notice and
other provisions required by the GPL License. If you do not delete
the provisions above, a recipient may use your version of this file
under either the MPL or the GPL License."
*/
/*
-script appelé  depuis un js, on lui transmet le numéro d'utilisateur
-il renvoit le résultat réussi ou non
-il détecte si le couple existe déjà
-il crée un nouvel enregistrement ou update l'existant
-il récupère les données en tableau et enregistre le tout dans un blob avec le tableau serializé zippé ou en csv zippé

*/
if (is_file("../config.php")) include_once("../config.php");
else @include_once("../includes/config.php");
@include_once("../includes/mysql.php");
@include_once("../includes/auth.php");
@include_once("../includes/fonctions.php");

$u=$config->user;
if(strstr('animateur',$u['statuts']))
{
    $m=new mysql();
    $id_utilisateur=$_REQUEST['id_utilisateurs'];
    //récupération des données de la session

	$q="select  reponses.id as qid,
	    reponses.choix,
            reponses.id_utilisateurs,
            reponses.id_engagements,
            reponses.remarques_reponses,
            reponses.action_corrective,
            reponses.resp_ac,remarque_ac,
            reponses.delais_ac,
            reponses.date_realisee_ac,
            reponses.action_ameliorative,
            reponses.remarque_aa,
            reponses.resp_aa,
            reponses.delais_aa,
            reponses.date_realisee_aa,
            reponses.id_auditeur,
            reponses.audit,
            reponses.audit_titre,
            reponses.remarque_audit,
            reponses.audit_responsable,
            reponses.audit_delais,
            reponses.suivi_audit,
            reponses.date_audit,
            reponses.date,
			engagements.importances
		from reponses INNER join
				(engagements INNER join referentiels on engagements.id_referentiels=referentiels.id)
			on reponses.id_engagements=engagements.id
		where reponses.id_utilisateurs=".$id_utilisateur." AND reponses.choix!= ''";
    $l=$m->select_str($q);
    $l=replace_ids($l, "id_engagements", "engagements");
    $l=replace_entities($l, "id_engagements");
    $l=replace_ids($l, "id_utilisateurs", "utilisateurs");
    $l=replace_ids($l, "id_auditeur", "utilisateurs");
    $l=replace_choice($l, "choix");
    $l=replace_choice($l, "audit");
    $csv=csv_gen($l);
    $session=addslashes(base64_encode($csv));
    //récupération du score
    $l=$m->select("utilisateurs","score_total","id=".$id_utilisateur);
    $score=$l[0]["score_total"];


    $datas=array(
            'id_utilisateurs'=>$id_utilisateur,
            'id_animateur'=>$u['id'],
            'date'=>date("Y-m-d H:i:s"),
            'datas'=>$session,
            'score'=>$score
    );
    if ($id_utilisateur) $m->insert("sessions", $datas);
    header("Location: ".$_SERVER["HTTP_REFERER"]);
    print $_SERVER["HTTP_REFERER"];


}else if($noadd) echo "";
 else print "Vous n'avez pas les droits d'effectuer cette opération (".$u['statuts'].")";
?>