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 59 60 61 62 63 64
| function bddtoarray($agence,$activite,$lundi,$dimanche) {
require('config.php');
setlocale(LC_TIME, 'fr','fr_FR','fr_FR@euro','fr_FR.utf8','fr-FR','fra');
date_default_timezone_set('Europe/Paris');
$lundi = $lundi->format('Y-d-m');
$dimanche = $dimanche->format('Y-d-m');
$query = "SELECT
TA.idTaches AS Taches,
TA.idTypeTache AS TypeT,
TA.DateDebut AS Debut,
TA.DateFin AS Fin,
TA.Rouge AS R,
TA.Vert AS G,
TA.Bleu AS B,
TA.LibelleClient AS Client,
TA.AdresseChantier AS Chantier,
TA.Observation AS Note,
TA.NumFacture AS Fact,
PE.Nom AS Nom,
PE.Prenom AS Prenom,
PE.idPersonne as UserId,
PE.Ordre as Ordre
FROM bdd.Taches TA
INNER JOIN bdd.PersonneFacturation PF
ON PF.idTaches=TA.idTaches
INNER JOIN bdd.Personne PE
ON PF.idPersonnel = PE.idPersonne
WHERE PE.idAgence = '$agence'
AND PE.idTypeActivite = '$activite'
AND PE.DateSortie IS NULL
AND PE.Indisponible = '1'
AND (('$lundi 08:30:00' BETWEEN TA.DateDebut AND TA.DateFin AND NOT TA.DateDebut BETWEEN '$lundi 00:00:00' AND '$dimanche 23:59:59') OR TA.DateDebut BETWEEN '$lundi 00:00:00' AND '$dimanche 23:59:59')
ORDER BY Ordre,Debut ASC
";
$result = sqlsrv_query($conn,$query, array(), array( "Scrollable" => 'static' ));
while( $row = sqlsrv_fetch_array( $result) ) {
$Taches[] = $row["Taches"];
$TypeT[] = $row["TypeT"];
$Debut[] = $row["Debut"];
$Fin[] = $row["Fin"];
$Red[] = $row["R"];
$Green[] = $row["G"];
$Blue[] = $row["B"];
$Client[] = $row["Client"];
$Chantier[] = $row["Chantier"];
$Note[] = $row["Note"];
$Fact[] = $row["Fact"];
$Nom[] = $row["Nom"];
$Prenom[] = $row["Prenom"];
$UserId[] = $row["UserId"];
$Ordre[] = $row["Ordre"];
}
sqlsrv_free_stmt($result);
if(!isset($Taches)) { $ListeTaches = NULL; }
else {
global $ListeTaches;
$ListeTaches = ["Taches"=>$Taches,"TypeT"=>$TypeT,"Debut"=>$Debut,"Fin"=>$Fin, "R"=>$Red, "G"=>$Green, "B"=>$Blue, "Client"=>$Client, "Chantier"=>$Chantier, "Note"=>$Note, "Fact"=>$Fact, "Nom"=>$Nom, "Prenom"=>$Prenom, "UserId"=>$UserId, "Ordre"=>$Ordre];
}
return $ListeTaches;
} |
Partager