<?php

require_once("../../inc/confNetisse.php");

$TYPE = $_REQUEST["type"];
$DATA = "";
switch($TYPE){
	case 'motif':
		$IDS = str_replace('|',',',$_REQUEST["ids"]);
		$MID = $_REQUEST["mid"];
		$q = "SELECT count(1) nb FROM `ca_motif_agence` me LEFT JOIN ca_motifs m ON m.id_motif = me.id_motif WHERE id_agence IN (".$IDS.") AND me.supp is null AND m.enabled = :enabled";
		$v = array(':enabled' => 1);
		$stmt = excuteQuery($q, $v);
		$r = $stmt['stmt'];
		$n = $r->rowCount();
		if ($n > 0)
		{
			$o = $r->fetchObject();
			$DATA = $o->nb;
		}
		else{
			$DATA =0;
		}
	break;
	case 'agenceMotifs':
		$AID = intval($_REQUEST["aid"]);
		$q = "SELECT count(1) nb FROM `ca_motif_agnece` ma LEFT JOIN ca_motifs m ON m.id_motif = ma.id_motif WHERE ma.id_agence = ? AND ma.supp is null AND m.enabled = :enabled";
		$v = array(':enabled' => 1);
		$stmt = excuteQuery($q, $v);
		$r = $stmt['stmt'];
		$n = $r->rowCount();
		if ($n > 0)
		{
			$o = $r->fetchObject();
			$DATA = $o->nb;
		}
		else{
			$DATA =0;
		}
	break;
}
echo $DATA;
?>