<?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; } }