<?php
session_start();
include("includes/config.php");
include('phpqrcode/qrlib.php'); // Include the phpqrcode library

// Function to get the next sequential family_id
function getNextFamilyId($conn) {
    $query = "SELECT MAX(family_id) AS max_id FROM families";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);
    $max_id = $row['max_id'];

    // Start from 1001 if no family_id exists; otherwise increment the max family_id
    return $max_id ? $max_id + 1 : 1001;
}

// function generateQRCode($family_id, $own_name, $ownerGender, $own_fname, $wife_name, $child1, $child1Gender, $child2, $child2Gender, $child3, $child3Gender, $fm1, $fm1Gender, $fm2, $fm2Gender, $phone, $h_no, $visit, $visit_date , $register_date) {
   
//     $details = "Family ID: $family_id\nOwner Name: $own_name\nOwner's Gender: $ownerGender\nOwner's Father Name: $own_fname\nWife Name: $wife_name\nChild 1: $child1\nChild1's Gender: $child1Gender\nChild 2: $child2\nChild2's Gender: $child2Gender\nChild 3: $child3\nChild3's Gender: $child3Gender\nFamily Member1: $fm1\nFamily Member1's Gender: $fm1Gender\nFamily Member2: $fm2\nFamily Member2's Gender: $fm2Gender\nphone: $phone\nHouse No.: $h_no\nVisit Time: $visit\nVisit Date: $visit_date\nRegister Date: $register_date";
//     $filePath = 'qrcodes/' . $family_id . '_qrcode.png';
//     QRcode::png($details, $filePath, QR_ECLEVEL_L, 30);
//     return $filePath;
// }

if (isset($_POST['add_family'])) {
    $family_id = getNextFamilyId($conn); // Get the next sequential family_id

    $own_name = $_POST['own_name'];
    $own_age = $_POST['own_age'];

    $ownerGender = $_POST['ownerGender'];
    $own_fname = $_POST['own_fname'];
    $own_fage = $_POST['own_fage'];

    $wife_name = $_POST['wife_name'];
    $wife_age = $_POST['wife_age'];

    $child1 = $_POST['child1'];
    $child1age = $_POST['child1age'];

    $child1Gender = $_POST['child1Gender'];
    $rchild1 = $_POST['rchild1'];
    
    $child2 = $_POST['child2'];
    $child2age = $_POST['child2age'];

    $child2Gender = $_POST['child2Gender'];
    $rchild2 = $_POST['rchild2'];

    $child3 = $_POST['child3'];
    $child3age = $_POST['child3age'];

    $child3Gender = $_POST['child3Gender'];
    $rchild3 = $_POST['rchild3'];

    $fm1 = $_POST['fm1'];
    $fm1age = $_POST['fm1age'];

    $fm1Gender = $_POST['fm1Gender'];
    $rfm1 = $_POST['rfm1'];

    $fm2 = $_POST['fm2'];
    $fm2age = $_POST['fm2age'];

    $fm2Gender = $_POST['fm2Gender'];
    $rfm2 = $_POST['rfm2'];
    $phone = $_POST['phone'];
    $h_no = $_POST['h_no'];
    $visit = $_POST['visit'];
    $visit_date = $_POST['visit_date'];
    $register_date = $_POST['register_date'];
    $expire_date = $_POST['expire_date'];


    // Generate the QR code and get the file path

    // $qrCodePath = generateQRCode($family_id, $own_name, $ownerGender, $own_fname, $wife_name, $child1, $child1Gender, $child2, $child2Gender, $child3, $child3Gender, $fm1, $fm1Gender, $fm2, $fm2Gender, $phone, $h_no, $visit, $visit_date, $register_date);


    // Insert family details along with the QR code path and generated family_id into the database
    $query = "INSERT INTO families (family_id, own_name, own_age, ownerGender, own_fname, own_fage, wife_name, wife_age, child1, child1age, child1Gender, rchild1,  child2, child2age, child2Gender, rchild2, child3, child3age , child3Gender, rchild3, fm1, fm1age , fm1Gender, rfm1, fm2, fm2age , fm2Gender, rfm2, phone, h_no, visit, visit_date, register_date, expire_date) VALUES ('$family_id', '$own_name', '$own_age', '$ownerGender', '$own_fname', '$own_fage', '$wife_name', '$wife_age', '$child1', '$child1age', '$child1Gender', '$rchild1', '$child2', '$child2age', '$child2Gender', '$rchild2', '$child3', '$child3age', '$child3Gender', '$rchild3', '$fm1', '$fm1age', '$fm1Gender', '$rfm1', '$fm2', '$fm2age', '$fm2Gender', '$rfm2', '$phone', '$h_no', '$visit', '$visit_date', '$register_date', '$expire_date')";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Data Uploaded Successfully";
        echo "<script>window.location.href='view-family.php';</script>";
        exit;
    } else {
        $_SESSION['status'] = "Data Not Uploaded Successfully";
        header('Location: family.php');
        exit;
    }
}





/// Update family details with QR code generation
if (isset($_POST['update_family'])) {
    $id = $_POST['id'];
    
    $family_id = $_POST['family_id'];
    $own_name = $_POST['own_name'];
    $own_age = $_POST['own_age'];
    $ownerGender = $_POST['ownerGender'];
    $own_fname = $_POST['own_fname'];
    $own_fage = $_POST['own_fage'];
    $wife_name = $_POST['wife_name'];
    $wife_age = $_POST['wife_age'];
    $child1 = $_POST['child1'];
    $child1age = $_POST['child1age'];
    $child1Gender = $_POST['child1Gender'];

    $rchild1 = $_POST['rchild1'];
    $child2 = $_POST['child2'];
    $child2age = $_POST['child2age'];
    $child2Gender = $_POST['child2Gender'];
    $rchild2 = $_POST['rchild2'];
    $child3 = $_POST['child3'];
    $child3age = $_POST['child3age'];
    $child3Gender = $_POST['child3Gender'];
    $rchild3 = $_POST['rchild3'];

    $fm1 = $_POST['fm1'];
    $fm1age = $_POST['fm1age'];
    $fm1Gender = $_POST['fm1Gender'];
    $rfm1 = $_POST['rfm1'];
    $fm2 = $_POST['fm2'];
    $fm2age = $_POST['fm2age'];
    $fm2Gender = $_POST['fm2Gender'];
    $rfm2 = $_POST['rfm2'];
    $phone = $_POST['phone'];
    $h_no = $_POST['h_no'];
    $visit = $_POST['visit'];
    $visit_date = $_POST['visit_date'];
    // $register_date = $_POST['register_date'];
    // $register_date = $_POST['register_date'];

    
    // $oldQRCodeQuery = "SELECT qr_code_path FROM families WHERE id='$id'";
    // $oldQRCodeResult = mysqli_query($conn, $oldQRCodeQuery);
    // if ($oldQRCodeRow = mysqli_fetch_assoc($oldQRCodeResult)) {
    //     $oldQRCodePath = $oldQRCodeRow['qr_code_path'];
    //     if (file_exists($oldQRCodePath)) {
    //         unlink($oldQRCodePath); 
    //     }
    // }

    // Generate the new QR code and get the file path
    // $qrCodePath = generateQRCode($family_id, $own_name, $wife_name, $child1, $child2, $phone, $h_no, $visit);


    // $qrCodePath = generateQRCode($family_id, $own_name, $own_fname, $wife_name, $child1, $child2, $child3, $fm1, $fm2, $phone, $h_no, $visit, $visit_date, $register_date);

    // Update family details along with the new QR code path



    
 

    $query = "UPDATE families SET 
                own_name='$own_name',
                own_age='$own_age',
                 ownerGender='$ownerGender',
                own_fname='$own_fname',
                own_fage='$own_fage',
                wife_name='$wife_name',
                wife_age='$wife_age',

                child1='$child1',
                child1age='$child1age',
                child1Gender='$child1Gender',
                rchild1='$rchild1',
                child2='$child2',
                child2age='$child2age',
                child2Gender='$child2Gender',
                rchild2='$rchild2',
                child3='$child3',
                child3age='$child3age',
                child3Gender='$child3Gender',
                rchild3='$rchild3',

                fm1='$fm1',
                fm1age='$fm1age',
                fm1Gender='$fm1Gender',
                rfm1='$rfm1',

                fm2='$fm2',
                fm2age='$fm2age',
                fm2Gender='$fm2Gender',
                rfm2='$rfm2',

                phone='$phone',
                h_no='$h_no',
                visit='$visit',
                visit_date='$visit_date'

                -- register_date='$register_date',
                -- qr_code_path='$qrCodePath'
              WHERE id='$id'";


    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Updated Successfully";
        echo "<script>window.location.href='view-family.php';</script>";
    } else {
        $_SESSION['status'] = "Data Not Updated Successfully";
        echo "<script>window.location.href='view-family.php';</script>";
    }
}

// Delete family details
if (isset($_POST['delete_family'])) {
    $id = $_POST['delete_id'];
    $query = "DELETE FROM families WHERE id='$id'";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Deleted Successfully";
        echo "<script>window.location.href='view-family.php';</script>";
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
        echo "<script>window.location.href='view-family.php';</script>";
    }
}
?>