1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| $sql = "
SELECT JOUR, ID_TYPE, DUREE
FROM cra
inner join cra_jours on cra.id=cra_jours.id_cra
WHERE cra.ID_UTILISATEUR = '".$_SESSION['ID']."' and cra.MOIS = '".$mois."' and cra.ANNEE = '".$annee."'
ORDER BY ID_TYPE, JOUR
";
$result=dbSQL($sql) or die (mysql_error());
while ($row = mysql_fetch_assoc ($result))
{
$row2[$row['ID_TYPE']][$row['JOUR']]=$row['DUREE'];
}
$smarty->assign('list_jours', $row2);
$sql = "
SELECT ID, TYPE
FROM cra_types
ORDER BY ID
";
$result=dbSQL($sql) or die (mysql_error());
while ($row = mysql_fetch_assoc ($result))
{
$smarty->append('list_types',$row);
}
//Nombre de jours dans le mois
$smarty->assign("nb_jours_mois",date('t', mktime(0, 0, 0, $mois, 2, $annee))); |
Partager