getActivatedNotification.php

<?php

include ('../../inc/confNetisse.php');

$profilesJoin = ($GLOBALS["BO_CONF"]["CONSEILLER"]["multiple_profiles"])?'LEFT JOIN ca_conseiller_agence ca ON ca.id_conseiller = c.id_conseiller':'';
$lastActiveColumn = ($GLOBALS["BO_CONF"]["MOBILITY"])?", last_active":"";
$lastActiveSecColumn = ($GLOBALS["BO_CONF"]["MOBILITY"])?", TIME_TO_SEC(TIMEDIFF(now(),last_active)) last_active_sec":"";
$whereActivity = ($GLOBALS["BO_CONF"]["MOBILITY"])?' AND TIME_TO_SEC(TIMEDIFF(now(),last_active))<300':'';
$q = '
	SELECT count(c.id_conseiller) nb
	FROM ca_conseillers c
	'.$profilsJoin.'
	WHERE (c.id_agence= :id_agence1 OR ca.id_agence = :id_agence2)
		AND c.receive_notifications=1 AND c.supp=0 '.$whereActivity.' AND photo != "../photos/incognito.jpg"';
$values = array(':id_agence1' => intval($_REQUEST['id_agence']), ':id_agence2' => intval($_REQUEST['id_agence']));
$result = excuteQuery($qy, $values);
$r = $result['stmt'];
if ($r) {
	$o = $r->fetchObject();
	echo $o->nb;
}
else{
	echo "0";
}

?>