<?php
/* MC-20170605 By M.A */
/* UPDATE MC-20170618 By M.A */

session_start();
require_once('../../inc/confNetisse.php');

if(isset($_REQUEST['id_client'])){
	$id_client = intval($_REQUEST['id_client']);
	$id_conseiller = intval($_REQUEST['id_conseiller']);
	$id_agence = isset($_REQUEST['id_agence']) ? intval($_REQUEST['id_agence']) : '';
	switch($_REQUEST['type']){
		case 'pec':
		$taker = $_REQUEST['user_type'];
		$action_taker = ($taker == "conseiller") ? "id_conseiller" : "id_cc";
		$time = $_REQUEST['checked'] ? date('Y-m-d H:i:s') : '0000-00-00 00:00:00';
		$q = "UPDATE ca_pile_cc SET date_priseencharge = :date_priseencharge, ".$action_taker."=:id_conseiller WHERE id_client_cc =:id_client";
		$values = array(':date_priseencharge'=> $time, ':id_conseiller'=> $id_conseiller, ':id_client' => $id_client);
		$r = excuteQuery($q, $values);
		echo "OK";
		break;

		case 'take':
		$taker = $_REQUEST['user_type'];
		$action_taker = ($taker == "conseiller") ? "id_conseiller" : "id_cc";
		$q = "UPDATE ca_pile_cc SET date_cloture = now(), ".$action_taker."=:id_conseiller WHERE id_client_cc =:id_client";
		$values = array(':id_conseiller'=> $id_conseiller, ':id_client' => $id_client);
		$r = excuteQuery($q, $values);
		$q = "INSERT INTO ca_historique_pile_cc (id_agence, date_arrivee, date_priseencharge, date_cloture, id_action, id_cc,id_conseiller, entite, civ, nom, prenom, nfcprov, message, phone, id_motif) SELECT id_agence, date_arrivee, date_priseencharge, now(), id_action, id_cc, id_conseiller, entite, civ, nom, prenom, nfcprov, message, phone, id_motif FROM ca_pile_cc WHERE id_client_cc=:id_client";
		$values = array(':id_client' => $id_client);
		$r = excuteQuery($q, $values);
		$q = "DELETE FROM ca_pile_cc WHERE id_client_cc=:id_client";
		$values = [':id_client' => $id_client];
		$r = excuteQuery($q, $values);
		echo "OK";
		break;
	}
}