0x1998 - MANAGER

Edit File: aj_export.php

changeDispo()

});
 
function changeDispo ()
{
var month=document.getElementById('don[1]').value;
var year=document.getElementById('don[2]').value;
var categorie=document.getElementById('don[4]').value;

$.post( 'garde_do.php', {action:'chercheGel',current_month:month,current_year:year,categorie:categorie}, function(html) {
		if (html==0 || html=='N')
		{
		document.getElementById('geler').value='Geler';
		document.getElementById('type').value='Y';
		$('#geler').removeClass('btn-success').addClass('btn-danger');
		}
		else if (html=='Y')
		{
		document.getElementById('geler').value='Dégeler';
		document.getElementById('type').value='N';
		$('#geler').removeClass('btn-danger').addClass('btn-success');	
		}

} );

} 
 </script>
<?php
include "config/garde.php";

// on cherche la liste des skill autorisées pour les dispos
	$result=mysqli_query($link,"select list_skill_id, list_skill_denom from list_skill where list_skill_dispo='Y' order by list_skill_id");
	while ($row=mysqli_fetch_array($result))
	{
	$items_dispo[$row[0]]=$row[1];	
	}
//-----------------------
// on cherche la liste des skill autorisées pour les activite
	$result=mysqli_query($link,"select list_skill_id, list_skill_denom from list_skill where list_skill_activite='Y' order by list_skill_id");
	while ($row=mysqli_fetch_array($result))
	{
	$items_activite[$row[0]]=$row[1];	
	}
//-----------------------
$items_month=array(1=>"Janvier", 2=>"Février", 3=>"Mars", 4=>"Avril", 5=>"Mai", 6=>"Juin", 7=>"Juillet", 8=>"Août", 9=>"Septembre", 10=>"Octobre", 11=>"Novembre", 12=>"Décembre");
//-------------------------

$date = date("Y");
$date2=$date+1;
// Export des dispos-----//
echo "
<form class=\"form-horizontal\" role=\"form\" method=\"post\" id=\"dispo\" name=\"don\" >
<div class=\"form-group\">
	<label for=\"current_month\" class=\"col-sm-2 control-label\">Export des dispos</label>
	<div class=\"col-sm-2\">
	<select size=\"1\" class=\"form-control\" id=\"don[1]\" name=\"current_month\" title=\"Mois\" onchange=\"changeDispo()\" >";
		foreach ($items_month as $key=>$value)
		{
			echo" <option value=\"".$key."\">".$value."</option>";
		}
echo "</select>
	  </div>
	  <div class=\"col-sm-2\">
	<select size=\"1\" class=\"form-control\" id=\"don[2]\" name=\"current_year\" title=\"Année\" onchange=\"changeDispo()\" >";	  
		for ($dd=2009;$dd<=$date2;$dd++)
			{
			echo "<option ";
			if ($dd==$date) echo "selected=\"selected\" ";
			echo "value=\"".$dd."\">".$dd."</option>";
			}
echo "</select>	
	  </div>
	  <div class=\"col-sm-2\">
	  <select size=\"1\" class=\"form-control\" id=\"don[4]\" name=\"categorie\" title=\"Catégorie\" onchange=\"changeDispo()\" >";
		foreach($items_dispo as $key => $value)
		{
		echo "<option value=\"".$key."\">".$value."</option>";
		}
echo"</select>
	  </div>
	  <div class=\"col-sm-2\">
	  <input type=\"button\" onclick=\"Export('dispo')\" class=\"btn btn-primary\" value=\"Exporter\" />
	  </div>
	  <div class=\"col-sm-2\">
	  <input type=\"hidden\" name=\"action\" value=\"geler_dispo\" />
	  <input type=\"hidden\" id=\"type\" name=\"type\" value=\"\" />
	  <input type=\"button\" onclick=\"Geler('dispo')\" id=\"geler\" class=\"btn btn-success\" value=\"Geler\" />
	  </div>	  
	  
</div> </form>"; // fin du 1er form group

// Export des Activités-----//
echo "
<form class=\"form-horizontal\" role=\"form\" method=\"post\" id=\"activite\" name=\"don\" >
<div class=\"form-group\">
	<label for=\"current_month\" class=\"col-sm-2 control-label\">Export des activites</label>
	<div class=\"col-sm-2\">
	<select size=\"1\" class=\"form-control\" id=\"don[3]\" name=\"current_month\" title=\"Mois\" >";
		foreach ($items_month as $key=>$value)
		{
			echo" <option value=\"".$key."\">".$value."</option>";
		}
echo "</select>
	  </div>
	  <div class=\"col-sm-2\">
	<select size=\"1\" class=\"form-control\" id=\"don[3]\" name=\"current_year\" title=\"Année\" >";	  
		for ($dd=2009;$dd<=$date2;$dd++)
			{
			echo "<option ";
			if ($dd==$date) echo "selected=\"selected\" ";
			echo "value=\"".$dd."\">".$dd."</option>";
			}
echo "</select>	
	  </div>
	  <div class=\"col-sm-2\">
	  <select size=\"1\" class=\"form-control\" id=\"don[3]\" name=\"categorie\" title=\"Catégorie\" >";
		foreach($items_activite as $key => $value)
		{
		echo "<option value=\"".$key."\">".$value."</option>";
		}
echo"</select>
	  </div>
	  <div class=\"col-sm-2\">
	  <input type=\"button\" onclick=\"Export('activite')\" class=\"btn btn-primary\" value=\"Exporter\" />
	  </div>
</div> </form>"; // fin du 2er form group