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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
|
$sql = "SELECT C.id_contrat, C.C_quotite_contrat, C.C_date_debut_contrat, C.C_date_fin_contrat, C.id_type_contrat, U.id_user, U.U_nom, U.U_prenom, T.libelle_poste
FROM gl_contrat C, gl_users U, th_poste T
WHERE C.id_user=U.id_user
AND C.id_poste = T.id_poste
AND U.U_actif = 1
AND C.C_actif = 1
AND (id_type_contrat = 2 OR id_type_contrat = 1 OR id_type_contrat = 3)
AND C.C_date_debut_contrat <= CURDATE()
AND (C.C_date_fin_contrat >= CURDATE() OR id_type_contrat = 2 OR id_type_contrat = 3)
GROUP BY C.id_user";
$titre = "Contrats actifs";
$si_vide="Aucun contrat n'est actif";
}
$stmt = $conn->query($sql);
$res = $stmt->fetchAll();
$count = count($res);
$stmt->closeCursor();
if ($count!=0){
foreach($res as $tab){
if($tab['id_type_contrat']==2){
$datefini="CDI";
$color2 = "";
$color = "";
}elseif($tab['id_type_contrat']==3){
$datefini="Titulaire";
$color2 = "";
$color = "";
}elseif($tab['C_date_fin_contrat'] < $date2 AND $tab['C_date_fin_contrat'] > $today){
$datefini=date_mysql_to_normal($tab['C_date_fin_contrat']);
$color = "<font color='red'>";
$color2 = "</font>";
}
else{
$datefini=date_mysql_to_normal($tab['C_date_fin_contrat']);
$color2 = "";
$color = "";
}
$datedebut = date_mysql_to_normal($tab['C_date_debut_contrat']);
if($tab['C_date_fin_contrat'] > $datemoins OR $tab['id_type_contrat']==2 OR $tab['id_type_contrat']==3 OR $tab['id_type_contrat']==1){
$message2 .= "<tr onclick=\"document.location='../core/appel.php?pg=contrat&id=".$tab['id_user']."'\" $couleur >
<td><span class='importantlink' >$color".$tab['U_nom'].' '.$tab['U_prenom']."</span>$color2</td>
<td>$color".$tab['libelle_poste']."$color2</td>
<td>$color".$tab['C_quotite_contrat']." % $color2</td>
<td>$color".$datedebut."$color2</td>
<td>$color".$datefini."$color2</td>
</tr>";
}
}
} |
Partager