<?php
/*
MC : 31/05/2017 by M.S
 * @desc : Màj status Pile
 *  */
session_start();
require_once('../../inc/confNetisse.php');

if(isset($_SESSION['auth']) && isset($_REQUEST['id_conseiller']) && $GLOBALS["NOTIF_CONF"]["EDITNOTIFSTATUS"]){
	$q = "SELECT id_conseiller FROM ca_conseiller_agence WHERE id_agence=:id_agence AND id_conseiller=:id_conseiller";
	$values = array(':id_agence' => intval($_REQUEST['id_agence']), ':id_conseiller' => intval($_REQUEST['id_conseiller']));
    $result = excuteQuery($q, $values);
    $res=$result['stmt'];
	$nb = $res->rowCount();

	if($nb>0){
		$q = "UPDATE ca_conseiller_agence SET status=:status WHERE id_agence=:id_agence AND id_conseiller=:id_conseiller";
		$values = array(':status' => intval($_REQUEST['status']),':id_agence' => intval($_REQUEST['id_agence']), ':id_conseiller' => intval($_REQUEST['id_conseiller']));
	}
	else {
		$q = "INSERT INTO ca_conseiller_agence (id_agence,id_conseiller,status) VALUES (:id_agence,:id_conseiller,:status)";
		$values = array(':id_agence' => intval($_REQUEST['id_agence']), ':id_conseiller' => intval($_REQUEST['id_conseiller']),':status' => intval($_REQUEST['status']));
	}
	$result = excuteQuery($q, $values);
}
?>