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