<?php
session_start();
if(!isset($_SESSION['auth'])) {
	header("location:index.php");
}

require_once("../inc/confNetisse.php");
$values = array(':enabled' => 1, ':supp1' => 0, ':supp2' => 0, ':inactif' => 0, ':supp3' => 0);
$FILTER = $activityQ = "";
if (!in_array("view_all_agences",$_SESSION['permissions']) ) {
	if($_SESSION['agences']){
		// $FILTER = "AND ca_agences.id_agence IN (:id_agence) ";
		// $values[':id_agence'] = $_SESSION['agences'];
		$FILTER = "AND ca_agences.id_agence IN (".implode(',',$_SESSION['agences']).") ";
	}else{
		$FILTER = "AND ca_agences.id_agence IS NULL ";
	}
}
if(isset($_REQUEST["gid"])){
	$FILTER = "AND ca_agences.id_grappe =:id_grappe";
	$values[':id_grappe'] = intval($_REQUEST["gid"]);
}
if(isset($_REQUEST["sid"])){
	$HIERARCHY = (isset($GLOBALS["BO_CONF"]["HIERARCHICAL"]) && $GLOBALS["BO_CONF"]["HIERARCHICAL"]["ENABLED"])?true:false;
	$agcParent = $HIERARCHY?$GLOBALS["BO_CONF"]["HIERARCHICAL"]["HIERARCHY"][count($GLOBALS["BO_CONF"]["HIERARCHICAL"]["HIERARCHY"])-2]:"secteur";
	if($agcParent == "secteur"){
		$FILTER = "AND ca_agences.id_secteur = :id_secteur";
		$values[':id_secteur'] = intval($_REQUEST["sid"]);
	}
	else{
		$FILTER = "AND ca_agences.id_".$agcParent." IN (SELECT id_".$agcParent." FROM ca_".$agcParent."s WHERE id_secteur = :id_secteur AND supp IS NULL) ";
		$values[':id_secteur'] = intval($_REQUEST["sid"]);
	}
}

if(isset($_REQUEST["apid"])){
	$FILTER = "AND ca_agences.id_agence_principale = :id_agence_principale";
	$values[':id_agence_principale'] = intval($_REQUEST["apid"]);

}
if($_SESSION['profil'] != 100 && $_SESSION["user"] == "admin"){
    $FILTER = "AND ca_agences.id_agence IN (SELECT l.id_agence FROM ca_links l WHERE l.id_admin = :id_admin)" ;
	$values[':id_admin'] = intval($_SESSION["id"]);
}
if($_SESSION["user"] != "admin"){
	if($GLOBALS["BO_CONF"]["ONLY_AGENCY_FROM_PILE"] && $_SESSION["agence"]){
		$FILTER = "AND ca_agences.id_agence = :id_agence" ;
		$values[':id_agence'] = intval($_SESSION["agence"]);
	}else{
		$LISTEAGENCES = array();
		$q_agc_origine = "SELECT id_agence FROM ca_conseillers WHERE id_conseiller = :id_conseiller AND supp = 0 ORDER BY id_conseiller ASC";
	    $v_agc_origine = array(':id_conseiller' => $_SESSION['id']);
	    $result_agc_origine = excuteQuery($q_agc_origine, $v_agc_origine);
	    $r_agc_origine = $result_agc_origine['stmt'];
	    $agc_origine = $r_agc_origine->fetchObject()->id_agence;
	    if(!in_array($agc_origine, $LISTEAGENCES)){
	        $LISTEAGENCES[] = $agc_origine;
	    }
	    $LISTEAGENCES[] = $_SESSION['agence'];
	    $LISTEAGENCES = implode(',', $LISTEAGENCES);
		$FILTER = "AND ca_agences.id_agence IN (".$LISTEAGENCES.")" ;
		//$values[':id_conseiller'] = intval($_SESSION["id"]);
	}
	
}
$typeSelect = $typeJoin;
if($GLOBALS["BO_CONF"]["AGENCE"]["MULTIPLE_TYPES"]){
	$typeSelect = ", t.nom as type";
	$typeJoin = " LEFT JOIN ca_types t ON t.type = ca_agences.type_agence";
}
$DATA = "";
if($GLOBALS["BO_CONF"]["GUICHETS"]){
$guichet_req = "(
	SELECT COUNT(g.id_guichet)
	FROM ca_guichet_agence ga
	INNER JOIN ca_guichets g ON g.id_guichet = ga.id_guichet
	WHERE g.enabled=1 AND ga.id_agence = ca_agences.id_agence AND ga.supp IS NULL
) AS nbGuichets,";
}else{
	$guichet_req = "";
}

$eds_req = $GLOBALS["BO_CONF"]["SHOW_EDS"] ? "ca_agences.eds, " : "";
$siege_req = isset($GLOBALS["BO_CONF"]["AGENCE"]["SIEGE"]) && $GLOBALS["BO_CONF"]["AGENCE"]["SIEGE"] ? 'ca_agences.siege, ' : '';
$q = "
SELECT ca_agences.id_agence, ca_entites.id_entite, ca_agences.code_agence, ca_agences.type_agence".$typeSelect.", 
ca_agences.nom_agence,".$eds_req.$siege_req." ca_agences.logo, ca_agences.is_active, DATE_FORMAT(ca_agences.date_creation, '%Y-%m-%d') as date_creation,
(SELECT COUNT(id_conseiller) FROM ca_conseillers WHERE id_agence = ca_agences.id_agence AND supp=0) AS nbConseillers,
(SELECT COUNT(id_entite) FROM ca_entites WHERE id_agence = ca_agences.id_agence AND supp=0 AND enabled=1) AS nbEntites,
".$guichet_req."
(
	SELECT COUNT(m.id_motif)
	FROM ca_motif_agence ma
	INNER JOIN ca_motifs m ON m.id_motif = ma.id_motif
	WHERE m.enabled=:enabled AND ma.id_agence = ca_agences.id_agence AND ma.supp IS NULL
) AS nbMotifs, (SELECT COUNT(o.id_orientation) FROM ca_orientations o LEFT JOIN ca_entites e ON e.id_entite = o.id_entite WHERE o.supp=:supp1 AND e.supp = :supp2 AND o.id_agence=ca_agences.id_agence) AS nbOrientations
FROM ca_agences
LEFT JOIN ca_entites ON ca_entites.id_agence = ca_agences.id_agence".$typeJoin."
WHERE ca_agences.inactif=:inactif AND ca_agences.supp=:supp3 ".$FILTER."
GROUP BY ca_agences.id_agence
ORDER BY nom_agence ASC";
	//print $q;
$result = excuteQuery($q, $values);
$r = $result['stmt'];
while($o = $r->fetchObject()) {
			$PATH = "";
			if($CAISSENAME == 'cafc'){
				if ($o->code_agence == "00515_zj0nSAp") $PATH = "cusenier/";
			}
			if($o->siege && $o->siege == 1 && (isset($GLOBALS["BO_CONF"]["AGENCE"]["SIEGE"]) && $GLOBALS["BO_CONF"]["AGENCE"]["SIEGE"])){
				$PATH = "siege/";
			}
			$redLine = ($GLOBALS["BO_CONF"]["MOTIFS"] && $o->nbMotifs == 0) ? "red_line" : "";
			$logo = $o->logo ? $o->logo : "/assets/img/logo.png";
			$defaultMat = (isset($GLOBALS["BO_CONF"]["DEFAULT_PILE_MATRICULE"]) && $GLOBALS["BO_CONF"]["DEFAULT_PILE_MATRICULE"]) ? ('&MAT='.$GLOBALS["BO_CONF"]["DEFAULT_PILE_MATRICULE"]) : '';
			$DATA .= "<tr class='".$redLine."'>\r\n<td><img src='".$SERVER.$logo."' height='20'/></td>
			\r\n<td>".$o->nom_agence."</td>";
			$DATA .= $GLOBALS["BO_CONF"]["SHOW_EDS"]?"\r\n<td>".$o->eds."</td>":"";
			$DATA .= "\r\n<td><a class='url' target='_blank' href='".$SERVER.$PATH."bornes/?IDA=".$o->code_agence."'>Ouvrir</a></td>
			\r\n<td><a class='url' target='_blank' href='".$SERVER.$PATH."pile/?IDA=".$o->code_agence.$defaultMat."'>Ouvrir</a></td>";
			$DATA .= $GLOBALS["BO_CONF"]["PILETV"]?"\r\n<td><a class='url' target='_blank' href='".$SERVER."pile/pileTV.php?IDA=".$o->code_agence."'>Ouvrir</a></td>":"";
			$DATA .= $GLOBALS["BO_CONF"]["PILETVC"]?"\r\n<td><a class='url' target='_blank' href='".$SERVER."pile/pileTVC.php?IDA=".$o->code_agence."'>Ouvrir</a></td>":"";
			$DATA .= $GLOBALS["BO_CONF"]["MEETING"]?"\r\n<td><a class='url' target='_blank' href='".$SERVER."pile/pileR.php?IDA=".$o->code_agence."'>Ouvrir</a></td>":"";

			$DATA .= "\r\n<td>";
			if ($o->is_active) {
				$DATA .= "<span>Active</span><div class='agency-status-preview green' data-id='".$o->id_agence."' data-tostatus='0'></div>";
			} else {
				$DATA .= "<span>Inactive</span><div class='agency-status-preview red' data-id='".$o->id_agence."' data-tostatus='1'></div>";
			}
			$DATA .= "</td>";

			if($GLOBALS["BO_CONF"]["ENTITIES"]){
				$DATA .= "\r\n<td class=''><a href='entList.php?aid=".$o->id_agence."'>G&#233;rer (".$o->nbEntites.")</a></td>\r\n";
				// $DATA .= "<td class=''><a href='orientationList.php?aid=".$o->id_agence."'>G&#233;rer (".$o->nbOrientations.")</a></td>";
			}
			else{
				$DATA .= "\r\n<td><a href='entUpd.php?aid=".$o->id_agence."&eid=".$o->id_entite."'>Orientations</a></td>";
			}
			if($GLOBALS["BO_CONF"]["MOTIFS"]){
				$DATA .= "\r\n<td><a href='motifList.php?aid=".$o->id_agence."'>G&#233;rer (".$o->nbMotifs.")</a></td>";
			}
			if($GLOBALS["BO_CONF"]["GUICHETS"]){
				$DATA .= "\r\n<td><a href='guichetList.php?aid=".$o->id_agence."'>G&#233;rer (".$o->nbGuichets.")</a></td>";
			}
			if($GLOBALS["BO_CONF"]["AGENCE"]["MULTIPLE_TYPES"]){
				$DATA .= "\r\n<td>".$o->type."</td>";
			}
			if(in_array("view_all_agents",$_SESSION['permissions']) || (in_array("view_agence_agents",$_SESSION['permissions']) && in_array($o->id_agence,$_SESSION['agences']))){
				$DATA .= "\r\n<td class=''><a href='cnsList.php?aid=".$o->id_agence."'>G&#233;rer (".$o->nbConseillers.")</a></td>\r\n";
			}
			else{
				$DATA .= "\r\n<td><a href='#' style='color:grey' >G&#233;rer (".$o->nbConseillers.")</a></td>\r\n";
			}
			if(in_array("edit_all_agences",$_SESSION['permissions']) || (in_array("edit_own_agence",$_SESSION['permissions']) && in_array($o->id_agence,$_SESSION['agences']))){
				$DATA .= "\r\n<td><a href='agcUpd.php?aid=".$o->id_agence."' >Editer</a></td>";
			}
			else{
				$disable = "style='pointer-events: none;cursor: default;color:#ccc;'";
				$DATA .= "<td><a ".$disable." href='#' style='color:grey' >Editer</a></td>\r\n";
			}
			$DATA .= "</tr>\r\n";
}
?>

<html>

<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title><?php echo $PROJECT_TITLE;?> : Liste des agences</title>
	<link rel="stylesheet" href="css/font-awesome.min.css" />
	<link rel="stylesheet" type="text/css" href="css/cadif.css" />
	<link rel="stylesheet" type="text/css" href="css/dashboard.css" />
	<link rel="stylesheet" type="text/css" href="css/cans/jquery-ui-1.8.17.custom.css" />
	<!--<link rel="stylesheet" type="text/css" href="css/tableTools_jui.css" />-->
	<link rel="stylesheet" type="text/css" href="css/datatable_jui.css" />

	<script type="text/javascript" src="js/jquery-1.7.2.min.js"></script>
	<script type="text/javascript" src="js/jquery-ui-1.8.22.custom.min.js"></script>
	<script type="text/javascript" src="js/jquery.dataTables.js"></script>
	<script type="text/javascript" src="js/netisse.js"></script>

	<script type="text/javascript">
	$(document).ready( function () {

		oTable = $('#AdminsDataTable').dataTable( {
			"bJQueryUI": true,
			"sPaginationType": "full_numbers",
			"sDom": '<"H"Tfr>t<"F"ip>',
			"iDisplayLength": 30,
			"oTableTools": {
				"sSwfPath": "./swf/copy_csv_xls_pdf.swf",
				"aButtons": [{"sExtends":    "xls","sButtonText": "Excel"},{"sExtends":    "pdf","sButtonText": "PDF"}]
			},
			"oLanguage": {
				"sProcessing":     "Traitement en cours...",
			    "sLengthMenu":     "Afficher _MENU_ &eacute;l&eacute;ments",
			    "sZeroRecords":    "Aucun &eacute;l&eacute;ment &agrave; afficher",
			    "sInfo":           "Affichage : _START_ &agrave; _END_ sur _TOTAL_ &eacute;l&eacute;ments",
			    "sInfoEmpty":      "Affichage de l'&eacute;lement 0 &agrave; 0 sur 0 &eacute;l&eacute;ments",
			    "sInfoFiltered":   "(filtr&eacute; de _MAX_ &eacute;l&eacute;ments au total)",
			    "sInfoPostFix":    "",
			    "sSearch":         "Rechercher&nbsp;/&nbsp;Filtrer&nbsp;:",
			    "sLoadingRecords": "T&#233;l&#233;chargement...",
			    "sUrl":            "",
			    "oPaginate": {
			        "sFirst":    "Premier",
			        "sPrevious": "Pr&eacute;c&eacute;dent",
			        "sNext":     "Suivant",
			        "sLast":     "Dernier"
			    }
			}


		});

	});
	</script>
</head>


<body>

<div id="globalLong">

	<div id="home">
		<div id="logo"><a href="dashboard.php"><img src="<?php echo $SERVER; ?>assets/img/logo.png" height="110" border="0"/></a></div>
		<div id="username">
			<b><?php echo isset($_SESSION["nom"]) ? $_SESSION["nom"] : $_SESSION["matricule"];?></b> &nbsp; | &nbsp; <a href="close.php" class="link" title="Fermer et clore votre session">D&#233;connexion</a>
			<br/>
		</div>
	</div>
	<div id="panels">
	  <?php include "menu.php";?>
	  <div class="main-content">
		<div id="title">
			Liste des agences
		</div>
		<div>
			<?php if (in_array("add_all_agences",$_SESSION['permissions']) || in_array("add_own_agence",$_SESSION['permissions'])) { ?>
			<a href='agcNew.php' class='formNav2'><i class="fa fa-plus-circle" style="color:#ED1B2F;font-size:150%"></i> <span style="color:#ED1B2F;">Cr&#233;er une nouvelle agence</span></a><br/><br/>
			<?php } ?>
		</div>
		<div id="list">
			<table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable">
				<thead>
				<tr>
					<td>Logo</td>
					<td>Agence</td>
					<?php
					if($GLOBALS["BO_CONF"]["SHOW_EDS"]){
					?>
					<td>EDS</td>
					<?php
					}
					?>
					<td>Borne</td>
					<td>Pile</td>
					<?php
					if($GLOBALS["BO_CONF"]["PILETV"]){
					?>
					<td>Pile TV</td>
					<?php
					}
					if($GLOBALS["BO_CONF"]["PILETVC"]){
					?>
					<td>Pile TV Clients</td>
					<?php
					}
					if($GLOBALS["BO_CONF"]["MEETING"]){
					?>
					<td>Pile Invitation</td>
					<?php
					}
					?>
					<td>Statut</td>
					<?php if($GLOBALS["BO_CONF"]["ENTITIES"]){
					?>
					<td>Entités</td>
					<!-- <td>Orientations</td> -->
					<?php
					}
					else{
					?>
					<td>Orientations</td>
					<?php
					}
					if($GLOBALS["BO_CONF"]["MOTIFS"]){
					?>
					<td>Motifs</td>
					<?php
					}
					if($GLOBALS["BO_CONF"]["GUICHETS"]){
						?>
						<td>Guichets</td>
						<?php
						}
					if($GLOBALS["BO_CONF"]["AGENCE"]["MULTIPLE_TYPES"]){
					?>
					<td>Type</td>
					<?php
					}
					?>
					<td>Conseillers</td>
					<td>Action</td>
				</tr>
				</thead>
				<tbody>
					<?php
						echo $DATA;
					?>
			</tbody>

			</table>

			<br/>

		</div>
	  </div>
	</div>
</div>

<?php include 'footer.php';?>


</body>

</html>