";
echo "| " . date("d/m/Y", strtotime($row["date"])) . " | ";
echo "" . date("H:i", strtotime($row["time"])) . " | ";
echo "" . $row["type"] . " | ";
echo "" . $row["note"] . " | ";
if ($row["in_transfer"] == 0) {
echo "NO | ";
} else {
echo "SI | ";
}
echo "" . $row["transfer_location"] . " | ";
if ($user == "all") {
$sql_user = "SELECT * FROM users WHERE id = " . $row["user_id"] . "";
$result_user = mysqli_query($con, $sql_user);
$user_data = mysqli_fetch_assoc($result_user);
echo "" . $user_data["name"] . " " . $user_data["surname"] . " | ";
}
echo "";
}
} else if ($source == "permessi") {
if ($user == "all") {
$sql = "SELECT * FROM permissions WHERE start_date BETWEEN '$start_date' AND '$end_date'";
} else {
$sql = "SELECT * FROM permissions WHERE user_id = " . $user . " AND start_date BETWEEN '$start_date' AND '$end_date'";
}
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_assoc($result)) {
$sql_justifications = "SELECT * FROM justifications WHERE id=" . $row["justification_id"] . "";
$result_justifications = mysqli_query($con, $sql_justifications);
$justification = mysqli_fetch_assoc($result_justifications);
$sql_status = "SELECT * FROM requests_status WHERE id=" . $row["status_id"] . "";
$result_status = mysqli_query($con, $sql_status);
$justification_status = mysqli_fetch_assoc($result_status);
echo "";
echo "| " . date("d/m/Y", strtotime($row["start_date"])) . " | ";
echo "" . date("d/m/Y", strtotime($row["end_date"])) . " | ";
echo "" . date("H:i", strtotime($row["start_time"])) . " | ";
echo "" . date("H:i", strtotime($row["end_time"])) . " | ";
echo "" . $justification["name"] . " | ";
if ($row["full_day"] == 1) {
echo "SI | ";
} else {
echo "NO | ";
}
if ($row["status_id"] == 1) {
echo "" . $justification_status["name"] . " | ";
} else if ($row["status_id"] == 2) {
echo "" . $justification_status["name"] . " | ";
} else if ($row["status_id"] == 3) {
echo "" . $justification_status["name"] . " | ";
}
if ($user == "all") {
$sql_user = "SELECT * FROM users WHERE id = " . $row["user_id"] . "";
$result_user = mysqli_query($con, $sql_user);
$user_data = mysqli_fetch_assoc($result_user);
echo "" . $user_data["name"] . " " . $user_data["surname"] . " | ";
}
echo "
";
}
} else if ($source == "trasferte") {
if ($user == "all") {
$sql = "SELECT * FROM transfers WHERE start_date BETWEEN '$start_date' AND '$end_date'";
} else {
$sql = "SELECT * FROM transfers WHERE user_id = " . $user . " AND start_date BETWEEN '$start_date' AND '$end_date'";
}
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_assoc($result)) {
$sql_status = "SELECT * FROM requests_status WHERE id=" . $row["status_id"] . "";
$result_status = mysqli_query($con, $sql_status);
$status = mysqli_fetch_assoc($result_status);
echo "";
echo "| " . date("d/m/Y", strtotime($row["start_date"])) . " | ";
echo "" . date("d/m/Y", strtotime($row["end_date"])) . " | ";
echo "" . $row["location"] . " | ";
echo "" . $row["destination"] . " | ";
if ($row["status_id"] == 1) {
echo "" . $status["name"] . " | ";
} else if ($row["status_id"] == 2) {
echo "" . $status["name"] . " | ";
} else if ($row["status_id"] == 3) {
echo "" . $status["name"] . " | ";
}
if ($user == "all") {
$sql_user = "SELECT * FROM users WHERE id = " . $row["user_id"] . "";
$result_user = mysqli_query($con, $sql_user);
$user_data = mysqli_fetch_assoc($result_user);
echo "" . $user_data["name"] . " " . $user_data["surname"] . " | ";
}
echo "
";
}
}
?>