<?php
// TRANSFERT
require_once("../../inc/confNetisse.php");
require("../functions.php");
// Jamais affiché 1
// Toujours affiché 0
// Selon la connexion -1

$ACTION = trim(secure($_REQUEST['action']));

switch($ACTION) {
	case 'delegationAgence':
		$MAT = trim(secure($_REQUEST['mat']));
		$CID = trim(secure(intval($_REQUEST['cid'])));
		$CN = trim(secure($_REQUEST['cn']));
		$AID = trim(secure(intval($_REQUEST['aid'])));
		$AN = trim(secure($_REQUEST['an']));
		$q = 'SELECT id_conseiller, nom, prenom FROM ca_conseillers WHERE supp=:supp AND id_agence != :id_agence AND id_agence NOT IN (SELECT id_agence FROM ca_conseiller_agence WHERE id_conseiller = :id_conseiller) ORDER BY nom_agence ASC';
		$v = array(':supp' => 0, ':id_agence' => $AID, ':id_conseiller' => $CID);
		$lastActiveSecWhere = ($GLOBALS["BO_CONF"]["MOBILITY"])?"AND (temporaire=:temporaire1 OR (temporaire = :temporaire2 AND TIMESTAMPDIFF(SECOND,ca.last_active,now()) <=15))":"";
		$q = 'SELECT ca.id_conseiller, c.nom, c.prenom
		FROM ca_conseiller_agence ca
		LEFT JOIN ca_conseillers c ON c.id_conseiller = ca.id_conseiller
		LEFT JOIN ca_conseiller_profils p ON p.id_conseiller = ca.id_conseiller
		WHERE c.supp=:supp
		AND c.inactif=:inactif
		AND ca.id_agence=:id_agence AND ca.delegue != :delegue AND (p.id_profil IS NULL OR p.id_profil != :id_profil) '.$lastActiveSecWhere.'
		ORDER BY nom ASC';
		$v = array(':supp' => 0, ':inactif' => 0, ':id_agence' => $AID, ':delegue' => 1, ':id_profil' => 6, ':temporaire1' => 0 , ':temporaire2' => 1);
		
		// echo "<li>$q</li>";
		$stmt = excuteQuery($q, $v);
		$r = $stmt['stmt'];
		$JSON = "<table align='center'><tr><td>Déléguant : ".$CN." (".$MAT.")</td></tr><tr><td>Agence concernée : ".$AN."</td></tr><tr><td colspan='2'><div id='delegation-container'><br/><br/>Liste des conseillers possibles :<br/><select name='did' id='did'>";
		$first = false;
		while($o=$r->fetchObject()) {
			if(!$first) $first = $o->id_agence;
			$JSON .= '<option value="'.$o->id_conseiller.'">'.$o->nom.' '.$o->prenom.'</option>';
		}
		$JSON .= "</select>";
		$JSON .= "</div></td></tr><tr><td colspan='2'><br/><input type='button' value='Valider' id='move-dlg-btn' onclick='delegationGo(\"".$MAT."\",".$AID.", ".$CID.", \"".$CN."\", document.getElementById(\"did\").value)'/></td></tr></table><br/><br/>";
		echo json_encode(array('html' => $JSON));
		break;

	case 'delegation':
		$MAT = trim(secure($_REQUEST['mat']));
		$AID = trim(secure(intval($_REQUEST['aid'])));
		$CID = trim(secure(intval($_REQUEST['cid'])));
		$CN  = trim(secure($_REQUEST['cn']));
		$DID = trim(secure(intval($_REQUEST['did'])));
		
		$q = 'UPDATE ca_conseiller_agence SET delegue = :delegue WHERE id_agence = :id_agence AND id_conseiller=:id_conseiller';
		$v = array(':delegue'=>1,':id_agence' => $AID, ':id_conseiller' => $DID);
		$r = excuteQuery($q, $v);
		$q = 'SELECT id_delegation FROM ca_delegations WHERE id_agence = :id_agence AND id_conseiller=:id_conseiller';
		$v = array(':id_agence' => $AID, ':id_conseiller' => $DID);
		$r = excuteQuery($q, $v);
		$nb = $r['stmt'] ? $r['stmt']->rowCount() : 0;
		if($nb){
			$q = 'UPDATE ca_delegations SET supp=NULL WHERE id_agence = :id_agence AND id_conseiller=:id_conseiller';
			$v = array(':id_agence' => $AID, ':id_conseiller' => $DID);
		}
		else{
			$q = 'INSERT INTO ca_delegations (id_agence, id_da, id_conseiller, date_delegation) VALUES (:id_agence,:id_da,:id_conseiller,now())';
			$v = array(':id_agence' => $AID, ':id_da' => $CID, ':id_conseiller' => $DID);
		}
		$r = excuteQuery($q, $v);
		echo json_encode(array('mat' => $MAT, 'nom' => $CN,'aid' => $AID, 'html' => "reload"));
		break;

	case 'suppConfirmation':
		$MAT = trim(secure($_REQUEST['mat']));
		$CID = trim(secure(intval($_REQUEST['cid'])));
		$CN = trim(secure($_REQUEST['cn']));
		$AID = trim(secure(intval($_REQUEST['aid'])));
		$AN = trim(secure($_REQUEST['an']));

		$JSON = "<table align='center'><tr><td>Délégué : ".$CN." (".$MAT.")</td></tr><tr><td>Agence actuelle : ".$AN."</td></tr><tr><td colspan='2'><br/><br/>Confirmez la suppression de cette délégation :<br/><br/><input type='button' value='Supprimer' id='delete-dlg-btn' onclick='suppressionGo(\"".$MAT."\", ".$AID.", ".$CID.", \"".$CN."\")'/></td></tr></table><br/><br/>";
		echo json_encode(array('html' => $JSON));
		break;

	case 'suppConfirmee':
		$MAT = trim(secure($_REQUEST['mat']));
		$AID = trim(secure(intval($_REQUEST['aid'])));
		$CID = trim(secure(intval($_REQUEST['cid'])));
		$CN = trim(secure($_REQUEST['cn']));
		$q = "UPDATE ca_conseiller_agence SET delegue = :delegue WHERE id_agence = :id_agence AND id_conseiller= :id_conseiller";
		$v = array(':delegue'=>0,':id_agence' => $AID, ':id_conseiller' => $CID);
		$r = excuteQuery($q, $v);
		$q = 'UPDATE ca_delegations SET supp=now() WHERE id_agence = :id_agence AND id_conseiller= :id_conseiller';
		$v = array(':id_agence' => $AID, ':id_conseiller' => $CID);
		$r = excuteQuery($q, $v);
		echo json_encode(array('mat' => $MAT, 'nom' => $CN,'aid' => $AID, 'html' => "reload"));
		break;
}
?>