<?php
session_start();

require_once "php/inc_fonctions.php";
require_once "php/inc_fx_panier.php";

global $objDatabase;
$arrParam = $_REQUEST;
$arrRetour = array(
    'state' => 'error'
);

if (isset($arrParam['panier'])) {
    $strDirname = isset($arrParam['no_panier']) ? trim($arrParam['no_panier']) : '';
    $strFile = isset($arrParam['file']) ? trim($arrParam['file']) : '';
    $intQuestion = isset($arrParam['id']) ? trim($arrParam['id']) : '';

    if (trim($arrParam['panier']) == 'true') { // si on efface un fichier en mode panier: effacer du serveur
        if (trim($strDirname) != '' && trim($strFile) != '') {
            $sqlUpdate = "UPDATE inscriptions_panier_questions SET que_choix_fr = '', que_choix_en = '' WHERE pqu_id = " . intval($intQuestion);
            $qryUpdate = $objDatabase->fxQuery($sqlUpdate);

            if ($qryUpdate !== false) {
                unlink('upload/temp/' . $strDirname . "/" . $strFile);

                $arrRetour['state'] = 'success';
            }
        }
    } else { // si on efface un fichier en mode client ou promoteur: en garder une trace dans la bdd
        $sqlInsert = "INSERT INTO modifications_fichiers_panier SET mfp_old_file = '" . $objDatabase->fxEscape($strFile) . "', no_panier = '" . $objDatabase->fxEscape($strDirname) . "', com_id = " . intval($_SESSION['com_info']['com_id']) . ", mfp_date = '" . fxGetDateTime() . "'";
        $qryInsert = $objDatabase->fxQuery($sqlInsert);

        $sqlUpdate = "UPDATE resultats_questions SET que_choix_fr = '', que_choix_en = '' WHERE pqu_id = " . intval($intQuestion);
        $qryUpdate = $objDatabase->fxQuery($sqlUpdate);

        if ($qryInsert !== false && $qryUpdate !== false) {
            $arrRetour['state'] = 'success';
        }
    }
}

echo json_encode($arrRetour);