Benvenuta/o
Di seguito puoi visualizzare i tuoi ordini
| Ordine |
Servizio |
Numero di Ticket |
Scadenza |
Da prenotare |
connect_error) {
die("Connessione al database fallita: " . $conn->connect_error);
}
$idorderbook = $document['idorderbook'];
$totalTickets = $document['nticket'];
$expireon = $document['expireon'];
$idservice = $document['idservice'];
$servicename = $document['servicename'];
// Verifica se l'ordine è scaduto
$currentDate = date("Y-m-d");
$isExpired = $expireon && $expireon < $currentDate;
// Data e ora attuali
$currentDateTime = date("Y-m-d H:i:s");
// Query per contare i record per questo ordine, escludendo status = 'cancelled'
$query = "SELECT COUNT(*) AS total,
SUM(CASE WHEN serviceschedule.dateschedule <= ? AND bookingclass.status = 'booked' AND bookingclass.lostlesson = 'N' THEN 1 ELSE 0 END) AS passed,
SUM(CASE WHEN serviceschedule.dateschedule > ? AND bookingclass.status = 'booked' AND bookingclass.lostlesson = 'N' THEN 1 ELSE 0 END) AS future,
SUM(CASE WHEN bookingclass.lostlesson = 'Y' AND bookingclass.status != 'cancelled' THEN 1 ELSE 0 END) AS lost,
SUM(CASE WHEN bookingclass.status = 'pending' THEN 1 ELSE 0 END) AS pending
FROM bookingclass
LEFT JOIN serviceschedule ON bookingclass.idserviceschedule = serviceschedule.idserviceschedule
WHERE bookingclass.iduser = ? AND bookingclass.idorder = ? AND bookingclass.status != 'cancelled'";
$stmt = $conn->prepare($query);
$stmt->bind_param("ssii", $currentDateTime, $currentDateTime, $iduserlogin, $idorderbook);
$stmt->execute();
$result = $stmt->get_result();
if ($result) {
$row = $result->fetch_assoc();
$passedRecords = $row['passed'];
$futureRecords = $row['future'];
$lost = $row['lost'];
$pending = $row['pending'];
} else {
$passedRecords = 0;
$futureRecords = 0;
$lost = 0;
$pending = 0;
}
$toprogram = $totalTickets - $passedRecords - $futureRecords - $pending - $lost;
$stmt->close();
$conn->close();
?>
|
|
|
|
|