bonjour à toutes et à tous !
J'ai un petit soucis avec une des mes pages :)
j'ai telechargé un calendrier sur internet qui remplit un de mes champs texte au format : JJ/MM/AAAA
Et je souhaiterais que sur le clic (quand un utilisateur choisit une date) celà stock le contenu dans ma variable $datefin_BDD et pour finir que celà rafraichisse ma page tout en preservant les variables $datedeb_BDD et $datefin_BDD.
Car j'utilise ces deux variables dans une requete.
Voici mon code :
[code]
<style type="text/css">
.ds_box {
background-color: #FFF;
border: 1px solid #000;
position: absolute;
z-index: 32767;
}
.ds_tbl {
background-color: #FFF;
}
.ds_head {
background-color: #333;
color: #FFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 13px;
font-weight: bold;
text-align: center;
letter-spacing: 2px;
}
.ds_subhead {
background-color: #CCC;
color: #000;
font-size: 12px;
font-weight: bold;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
width: 32px;
}
.ds_cell {
background-color: #EEE;
color: #000;
font-size: 13px;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
padding: 5px;
cursor: pointer;
}
.ds_cell:hover {
background-color: #F3F3F3;
} /* This hover code won't work for IE */
</style>
<table class="ds_box" cellpadding="0" cellspacing="0" id="ds_conclass" style="display: none;">
<tr><td id="ds_calclass">
</td></tr>
</table>
<script type="text/javascript">
// <!-- <![CDATA[
// Project: Dynamic Date Selector (DtTvB) - 2006-03-16
// Script featured on JavaScript Kit- http://www.javascriptkit.com
// Code begin...
// Set the initial date.
var ds_i_date = new Date();
ds_c_month = ds_i_date.getMonth() + 1;
ds_c_year = ds_i_date.getFullYear();
// Get Element By Id
function ds_getel(id) {
return document.getElementById(id);
}
// Get the left and the top of the element.
function ds_getleft(el) {
var tmp = el.offsetLeft;
el = el.offsetParent
while(el) {
tmp += el.offsetLeft;
el = el.offsetParent;
}
return tmp;
}
function ds_gettop(el) {
var tmp = el.offsetTop;
el = el.offsetParent
while(el) {
tmp += el.offsetTop;
el = el.offsetParent;
}
return tmp;
}
// Output Element
var ds_oe = ds_getel('ds_calclass');
// Container
var ds_ce = ds_getel('ds_conclass');
// Output Buffering
var ds_ob = '';
function ds_ob_clean() {
ds_ob = '';
}
function ds_ob_flush() {
ds_oe.innerHTML = ds_ob;
ds_ob_clean();
}
function ds_echo(t) {
ds_ob += t;
}
var ds_element; // Text Element...
var ds_monthnames = [
'Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin',
'Juillet', 'Aout', 'Septembre', 'Octobre', 'Novembre', 'Décembre'
]; // You can translate it for your language.
var ds_daynames = [
'Dim', 'Lun', 'Mar', 'Me', 'Jeu', 'Ven', 'Sam'
]; // You can translate it for your language.
// Calendar template
function ds_template_main_above(t) {
return '<table cellpadding="3" cellspacing="1" class="ds_tbl">'
+ '<tr>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_py();"><<</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_pm();"><</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_hi();" colspan="3">[Fermer]</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_nm();">></td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_ny();">>></td>'
+ '</tr>'
+ '<tr>'
+ '<td colspan="7" class="ds_head">' + t + '</td>'
+ '</tr>'
+ '<tr>';
}
function ds_template_day_row(t) {
return '<td class="ds_subhead">' + t + '</td>';
// Define width in CSS, XHTML 1.0 Strict doesn't have width property for it.
}
function ds_template_new_week() {
return '</tr><tr>';
}
function ds_template_blank_cell(colspan) {
return '<td colspan="' + colspan + '"></td>'
}
function ds_template_day(d, m, y) {
return '<td class="ds_cell" onclick="ds_onclick(' + d + ',' + m + ',' + y + ')">' + d + '</td>';
// Define width the day row.
}
function ds_template_main_below() {
return '</tr>'
+ '</table>';
}
// This one draws calendar...
function ds_draw_calendar(m, y) {
// First clean the output buffer.
ds_ob_clean();
// Here we go, do the header
ds_echo (ds_template_main_above(ds_monthnames[m - 1] + ' ' + y));
for (i = 0; i < 7; i ++) {
ds_echo (ds_template_day_row(ds_daynames[i]));
}
// Make a date object.
var ds_dc_date = new Date();
ds_dc_date.setMonth(m - 1);
ds_dc_date.setFullYear(y);
ds_dc_date.setDate(1);
if (m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10 || m == 12) {
days = 31;
} else if (m == 4 || m == 6 || m == 9 || m == 11) {
days = 30;
} else {
days = (y % 4 == 0) ? 29 : 28;
}
var first_day = ds_dc_date.getDay();
var first_loop = 1;
// Start the first week
ds_echo (ds_template_new_week());
// If sunday is not the first day of the month, make a blank cell...
if (first_day != 0) {
ds_echo (ds_template_blank_cell(first_day));
}
var j = first_day;
for (i = 0; i < days; i ++) {
// Today is sunday, make a new week.
// If this sunday is the first day of the month,
// we've made a new row for you already.
if (j == 0 && !first_loop) {
// New week!!
ds_echo (ds_template_new_week());
}
// Make a row of that day!
ds_echo (ds_template_day(i + 1, m, y));
// This is not first loop anymore...
first_loop = 0;
// What is the next day?
j ++;
j %= 7;
}
// Do the footer
ds_echo (ds_template_main_below());
// And let's display..
ds_ob_flush();
// Scroll it into view.
ds_ce.scrollIntoView();
}
// A function to show the calendar.
// When user click on the date, it will set the content of t.
function ds_sh(t) {
// Set the element to set...
ds_element = t;
// Make a new date, and set the current month and year.
var ds_sh_date = new Date();
ds_c_month = ds_sh_date.getMonth() + 1;
ds_c_year = ds_sh_date.getFullYear();
// Draw the calendar
ds_draw_calendar(ds_c_month, ds_c_year);
// To change the position properly, we must show it first.
ds_ce.style.display = '';
// Move the calendar container!
the_left = ds_getleft(t);
the_top = ds_gettop(t) + t.offsetHeight;
ds_ce.style.left = the_left + 'px';
ds_ce.style.top = the_top + 'px';
// Scroll it into view.
ds_ce.scrollIntoView();
}
// Hide the calendar.
function ds_hi() {
ds_ce.style.display = 'none';
}
// Moves to the next month...
function ds_nm() {
// Increase the current month.
ds_c_month ++;
// We have passed December, let's go to the next year.
// Increase the current year, and set the current month to January.
if (ds_c_month > 12) {
ds_c_month = 1;
ds_c_year++;
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Moves to the previous month...
function ds_pm() {
ds_c_month = ds_c_month - 1; // Can't use dash-dash here, it will make the page invalid.
// We have passed January, let's go back to the previous year.
// Decrease the current year, and set the current month to December.
if (ds_c_month < 1) {
ds_c_month = 12;
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Moves to the next year...
function ds_ny() {
// Increase the current year.
ds_c_year++;
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Moves to the previous year...
function ds_py() {
// Decrease the current year.
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Format the date to output.
function ds_format_date(d, m, y) {
// 2 digits month.
m2 = '00' + m;
m2 = m2.substr(m2.length - 2);
// 2 digits day.
d2 = '00' + d;
d2 = d2.substr(d2.length - 2);
// YYYY-MM-DD
// return y + '-' + m2 + '-' + d2;
return d2 + '/' + m2 + '/' + y;
}
// When the user clicks the day.
function ds_onclick(d, m, y) {
// Hide the calendar.
ds_hi();
// Set the value of it, if we can.
if (typeof(ds_element.value) != 'undefined') {
ds_element.value = ds_format_date(d, m, y);
// Maybe we want to set the HTML in it.
} else if (typeof(ds_element.innerHTML) != 'undefined') {
ds_element.innerHTML = ds_format_date(d, m, y);
// I don't know how should we display it, just alert it to user.
} else {
alert (ds_format_date(d, m, y));
}
}
// And here is the end.
// ]]> -->
</script>
<?php
#################################################
# #
# PHASE DE RESERVATION #
# DE MATERIEL #
# #
#################################################
include ('../connect/connexion.php');
$c_jour = $_GET['c_jour'];
$c_mois = $_GET['c_mois'];
$c_annee = $_GET['c_annee'];
if($c_jour<10) {$c_jour = "0".$c_jour;}
if($c_mois<10) {$c_mois = "0".$c_mois;}
if($c_annee<10) {$c_annee = "0".$c_annee;}
// Date au format JJ/MM/AAAA pour l'utilisateur
$datedebut = "$c_jour/$c_mois/$c_annee";
// Dates-+ au format de la BDD
$datedeb_BDD = "$c_annee$c_mois$c_jour";
$datefin_BDD = "$c_annee$c_mois$c_jour";
$connexion = mysql_connect($serveur,$user,$pass);
mysql_select_db($base,$connexion);
// Requete qui affiche les materiels qui ne sont pas empruntes
$reqDispo = "SELECT MATERIEL.NUM_MAT, MATERIEL.DESC_MAT, TYPE.LIB_TYPE
FROM MATERIEL, TYPE
WHERE MATERIEL.DISPO_MAT = 1
AND MATERIEL.NUM_TYPE = TYPE.NUM_TYPE
AND MATERIEL.NUM_MAT NOT IN (
SELECT MATERIEL.NUM_MAT
FROM PRET, EMPRUNT, MATERIEL
WHERE PRET.DATEDEB_PRET <='$datedeb_BDD' AND PRET.DATEFIN_PRET >='$datefin_BDD'
AND PRET.NUM_PRET = EMPRUNT.NUM_PRET
AND EMPRUNT.NUM_MAT = MATERIEL.NUM_MAT
AND MATERIEL.DISPO_MAT = 1
)
ORDER BY TYPE.LIB_TYPE";
$reqTypes = "SELECT * FROM TYPE, MATERIEL WHERE TYPE.num_type = MATERIEL.num_type GROUP BY TYPE.num_type";
/*$resTypes = mysql_query($reqTypes,$connexion);
$i = 0;
while ($rowTypes = mysql_fetch_array($resTypes))
{
TYPOK[$i] = ($TABTYP = array("$rowTypes[1]", "0"(array)));
$i++;
}
*/
if($datedebut != "0/0/0" && $datefin != "0/0/0")
{
?>
<form id="reservation" name="reservation" method="post" action="demande_pret.php?send=1" >
<p>Date de début :
<input name="datedeb" type="text" id="datedeb" title="Date de début"readonly value="<? echo $datedebut;?>" />
</p>
<p>Date de fin : <input onclick="ds_sh(this);" name="date2" readonly="readonly" style="cursor: text" value="<? echo $datedebut;?>"/>
<p>Matériel(s) demandé(s) : </p>
<p><?
$resP = mysql_query($reqDispo, $connexion) or die ('erreur sur '.$reqDispo.'<br/>'.mysql_error());
$types_OK = array();
while ($rowP = mysql_fetch_array($resP) )
{
$types_OK[] = $rowP['LIB_TYPE'];
}
$resT = mysql_query($reqTypes, $connexion) or die ('erreur sur '.$reqTypes.'<br/>'.mysql_error());
while($rowT = mysql_fetch_array($resT))
{
?>
<input type="checkbox" name="<?php echo $rowT["num_type"];?>" value="checkbox"
<?php
if(!in_array($rowT['lib_type'], $types_OK))
{
$mess_indispo = "Materiel indisponible pour cette date";
?>
disabled="disabled"
<?php
}
?>
/>
<?php
echo $rowT["lib_type"];
?>
<p>
<?php
echo $mess_indispo;
$mess_indispo = "";
?>
</p>
<?php
}
//////////////////////////////////////////////////////////////////
// // DEBUT GESTION DES CHECKBOX // //
//////////////////////////////////////////////////////////////////
/*
$resP = mysql_query($reqDispo, $connexion) or die ('erreur sur '.$reqDispo.'<br/>'.mysql_error());
$types_OK = array();
while ($rowP = mysql_fetch_array($resP))
{
$types_OK[] = $rowP['lib_type'];
}
$resT = mysql_query($reqTypes, $connexion) or die ('erreur sur '.$reqTypes.'<br/>'.mysql_error());
while($rowT = mysql_fetch_array($resT))
{
if($rowT['lib_type'] == $rowP['lib_type'])
{
$check = 'disabled="false"';
}
else
{
$check = 'disabled="true"';
}
echo '<input type="checkbox" title="Cochez cette case pour choisir ce materiel" name="'.$rowT["num_type"].'" value="checkbox"';
echo (in_array($rowT['lib_type'], $types_OK))?'':' disabled="disabled" '; // $check
echo '/>'.$rowT["lib_type"].'<br /><br />';
}
*/
//////////////////////////////////////////////////////////////////
// FIN GESTION DES CHECKBOX //
//////////////////////////////////////////////////////////////////
?></p>
<p>Motif :</p>
<p>
<textarea name="motif" cols="30" rows="5" id="motif" title="Entrez ici le motif complet de votre demande"></textarea>
</p>
<p>Nom et prénom :
<input type="text" name="nomprenom_emp" value="azerty" readonly/>
</p>
<p>Mail :
<input type="text" name="add_emp" value="
[email protected]" readonly/>
</p>
<p>
<input type="submit" name="Submit" value="Envoyer" title="Enregistrer votre demande"/>
</p>
</form>
<?
}
?>
<?php
if (isset($_GET['send']))
{
// Recup les données saisies
$datedeb = $_POST['datedeb'];
$datefin = $_POST['datefin'];
$motif = $_POST['motif'];
$datedebannee = substr($datedeb,6,4);
$datedebmois = substr($datedeb,3,2);
$datedebjour = substr($datedeb,0,2);
$datedeb = "$datedebannee$datedebmois$datedebjour";
$datefinannee = substr($datefin,6,4);
$datefinmois = substr($datefin,3,2);
$datefinjour = substr($datefin,0,2);
$datefin = "$datefinannee$datefinmois$datefinjour";
if ($datefin < $datedeb)
{
echo "Attention ! La date de fin ne peut pas être anterieure à la date de début !";
}
else
{
echo "Merci ! Votre commande a été enregistrée !";
}
}
?>
<br /><a href="">retour</a>[/code]
Merci beaucoup par avance !!!
Cordialement ,
Emmanuel
