<?php
include 'config/db.php';

$building = $_POST['building'];
if (empty($building)) {
    
    exit;
}
$pt1 = intval($_POST['pt1']);
$pt2 = intval($_POST['pt2']);
$pt3 = intval($_POST['pt3']);
$pt4 = intval($_POST['pt4']);
$pt5 = intval($_POST['pt5']);
$admit = intval($_POST['admit']);
$refer = intval($_POST['refer']);
$dead = intval($_POST['dead']);
$homeward = intval($_POST['homeward']);
$viproom = intval($_POST['viproom']);

if (
    $pt1 === 0 && $pt2 === 0 && $pt3 === 0 && $pt4 === 0 && $pt5 === 0 &&
    $admit === 0 && $refer === 0 && $dead === 0 && $homeward === 0 && $viproom === 0
) {
    echo "Please enter at least one value";
    exit;
}
$total = $pt1 + $pt2 + $pt3 + $pt4 + $pt5;

$sql = "INSERT INTO patient_count (building, pt1, pt2, pt3, pt4, pt5, total, admit, refer, dead, homeward, viproom, create_at)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())";

$stmt = $conn->prepare($sql);
$stmt->bind_param("siiiiiiiiiii", $building, $pt1, $pt2, $pt3, $pt4, $pt5, $total, $admit, $refer, $dead, $homeward, $viproom);

if ($stmt->execute()) {
    echo "Data saved successfully!";
} else {
    echo "Error: " . $stmt->error;
}
$stmt->close();
$conn->close();
?>