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

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

$DATA = "";
$multilang = (isset($BORNE_CONF["LANGUAGES"]) && count($BORNE_CONF["LANGUAGES"])>1) ? true : false;
$visibility = (isset($GLOBALS["BO_CONF"]["CONSEILLER"]["fonction"]["manage_visibility"]) && $GLOBALS["BO_CONF"]["CONSEILLER"]["fonction"]["manage_visibility"]) ? true : false;

$visibilityCol = $visibility ? ", is_visible" : "";

$q = "SELECT f.id_fonction, f.libelle".$visibilityCol." FROM ca_fonctions f WHERE supp=:supp";
$values = array(':supp' => 0);
$result = excuteQuery($q, $values);
// print $q;
$r = $result['stmt'];
$nb = 0;
if($r){
$nb = $r->rowCount();
while($o = $r->fetchObject()) {
	$DATA .= '<tr><td>'.stripslashes($o->libelle).'</td>';
	$lnk = "?fid=".$o->id_fonction;
	if($visibility){
		$DATA .= "<td>".($o->is_visible ? "Affiché" : "Masqué")."</td>";
	}
	if ($_SESSION['profil'] > 50){
		if($multilang){
			$DATA .= "<td>";
			foreach($BORNE_CONF["LANGUAGES"] as $lang){
				$DATA .= $o->id_lang. "<a href='fonctionUpd.php".$lnk."&lang=".strtolower($lang)."' width='30%' ><img src='/assets/img/icons/borne/langs/".strtolower($lang).".png' alt='".$lang."' title='".$lang."' height='20'/></a>&nbsp;";
			}
			$DATA .= "</td>";
		}
		else{
			$DATA .= "<td><a href='fonctionUpd.php".$lnk."' >Editer</a></td>";
		}
	}
	$DATA .= "</tr>";
}
}
?>

<html>

<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title><?php echo $PROJECT_TITLE;?> : Liste des intitulés du poste</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 intitulés du poste <?php if($AID >0){ echo "de l'agence ".$AGENCE;} ?>
	</div>
	<div>
		<?php if(in_array("add_all_agences",$_SESSION['permissions'])) { ?>
		<a href='fonctionNew.php' class='formNav2'><i class="fa fa-plus-circle" style="color:#ED1B2F;font-size:150%"></i> <span style="color:#ED1B2F;">Cr&#233;er un nouveau intitulé du poste</span></a><br/><br/>
		<?php } ?>
	</div>
	<div id="list">
		<table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable">
			<thead>
			<tr>
				<td>Libellé</td>			
				<?php if($visibility){?><td>Affichage borne</td><?php } ?>
				<?php if ($_SESSION['profil'] > 50) {?><td>Actions</td><?php } ?>	
			</tr>
			</thead>
			<tbody>
				<?php
					echo $DATA;
				?>
		</tbody>

		</table>

		<br/>

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

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


</body>

</html>