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

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

$filter = $specificTitle = "";
if(isset($_REQUEST['pid'])){
	$filter = " AND g.id_pole=".intval($_REQUEST['pid']);
}
$DATA = "";
$q = "SELECT g.id_grappe, g.nom_grappe, p.nom_pole,(SELECT count(id_agence) FROM ca_agences WHERE id_parent = g.id_grappe) as nbAgences
FROM ca_grappes g
LEFT JOIN ca_poles p ON p.id_pole = g.id_pole
WHERE g.supp IS NULL".$filter." ORDER BY g.nom_grappe ASC";
// echo $q;
$r = excuteQuery($q);
if (!$r['status']) 
        wts_die (var_dump($r['stmt']->errorInfo()));
while($o = $r['stmt']->fetch(PDO::FETCH_OBJ)) {
	$DATA .= "<tr>\r\n<td>".$o->nom_grappe."</td>\r\n<td>".$o->nom_pole."</td>\r\n<td><a href='agcList.php?gid=".$o->id_grappe."'>Gérer(".$o->nbAgences.")</a></td>";
	$DATA .= "\r\n<td><a href='grappeUpd.php?gid=".$o->id_grappe."' >Editer</a></td>";

	if($filter){
		$specificTitle = " du pôle : <span class='agcTitle'>".$o->nom_pole."</span>";
	}
}

?>

<html>

<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title><?php echo $PROJECT_TITLE;?> : Liste des grappes</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">
	$(document).ready( function () {

		oTable = $('#AdminsDataTable').dataTable( {
			"bJQueryUI": true,
			"sPaginationType": "full_numbers",
			"sDom": '<"H"Tfr>t<"F"ip>',

			"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="global">
		<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 grappes<?php echo $specificTitle;?>
				</div>
				<div>
					<?php if(in_array("add_all_agences",$_SESSION['permissions'])) { ?>
						<a href='grappeNew.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 grappe</span></a><br/><br/>
					<?php } ?>
				</div>
				<div id="list">
					<table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable">
						<thead>
							<tr>
								<td>Nom</td>
								<td>Pôle</td>
								<td>Agences</td>
								<td>Actions</td>
							</tr>
						</thead>
						<tbody>
							<?php
							echo $DATA;
							?>
						</tbody>

					</table>

					<br/>

				</div>

			</div>

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


		</body>

		</html>