<?php

header("Cache-Control: no-cache, must-revalidate");


include 'dbconnect.php';



if ($_GET['id']) {
    $id = $_GET['id'];
}

$date_time = date('d/m/y h:m:s a');
//echo $date_time ;
// echo "hello";
// die();

$select_sql = "SELECT  branch.branch_name,branch.branch_id, account_type.name as  'ac_name',account_type.code as 'ac_code', account_info.`name`,
`father_name`, `mother_name`, `dob`, `occupation`, `mobile`, `email`, `nationality`, `present_address`,
 `permanent_address`, `gender`, `nominee_name`, `relation`, `share`, `picture`,
 `user_front`, `user_back`, `nominee_front`, `nominee_back`, `status`, `ac_number`, `sign`,`nid_verified`,`face_verified` FROM `account_info` INNER JOIN branch ON account_info.branch = branch.branch_id INNER JOIN account_type on ac_type = account_type.code WHERE account_info.id=$id";


$result = $conn->query($select_sql);


if (isset($_POST['acc_update_btn'])) {
    $acc_no = $conn->real_escape_string(trim($_POST['acc_number']));
    $cust_informed = $conn->real_escape_string(trim($_POST['cust_informed']));
    $nid_verified = $conn->real_escape_string(trim($_POST['nid_verified']));
    $face_verified = $conn->real_escape_string(trim($_POST['face_verified']));





    if (!empty($nid_verified) && !empty($face_verified)) {
        if (empty($acc_no) && empty($cust_informed)) {
            $update_sql = "update account_info set nid_verified='$nid_verified',face_verified='$face_verified' where id=$id";
            echo '<script>alert("Nid and Face Verified!!!");</script>';
        } else if (!empty($acc_no) && empty($cust_informed)) {
            $update_sql = "update account_info set status = 'Approved', ac_number='$acc_no',nid_verified='$nid_verified',face_verified='$face_verified' where id=$id";
            echo '<script>alert("Account Created!!!");</script>';
        } else if (empty($acc_no) && !empty($cust_informed)) {
            echo '<script>alert("First Open Account. Then Inform customer")</script>';
        } else if (!empty($acc_no) && !empty($cust_informed)) {
            $update_sql = "update account_info set status = 'Approved', ac_number='$acc_no', inform = '$cust_informed',nid_verified='$nid_verified',face_verified='$face_verified' where id=$id";

            echo '<script>alert("Account Created and Customer Informed!!!");</script>';
        } else {

            echo '<script>alert("Nothing")</script>';
        }


        // if (empty($cust_informed)) {

        //     $update_sql = "update account_info set status = 'Approved', ac_number='$acc_no',nid_verified='$nid_verified',face_verified='$face_verified' where id=$id";

        //     $updated_log_sql = "INSERT INTO activity_log_tbl(app_id,acc_open_id,acc_open_time) VALUES('$id','$user_id','$date_time')";
        //     $updated_log_sql_result = $conn->query($updated_log_sql);
        // } else {
        // }
    } else if (!empty($nid_verified) && empty($face_verified)) {
        $update_sql = "update account_info set nid_verified='$nid_verified' where id=$id";
        echo '<script>alert("Nid Verified!!!");</script>';
    } else if (empty($nid_verified) && !empty($face_verified)) {
        $update_sql = "update account_info set face_verified='$face_verified' where id=$id";
        echo '<script>alert("Face Verified!!!");</script>';
    } else {
        echo '<script>alert("Please verify NID and Face verification first to update")</script>';
    }





    // $data_fetch_sql = "select * from activity_log_tbl where  app_id=$id";

    // $fetch_result = $conn->query($data_fetch_sql);
    // $row_count = $fetch_result->num_rows;






    // echo $update_sql;
    //die();
    $update_result = $conn->query($update_sql);
    $updated_row = $conn->affected_rows;



    // if (!empty($cust_informed)) {
    //     if ($row_count > 0) {
    //         $updated_informed_log = "UPDATE activity_log_tbl set informed_id='$user_id',informed_time= '$date_time' where app_id = '$id'";
    //         $updated_informed_log_result = $conn->query($updated_informed_log);
    //     }
    // }



    if ($updated_row > 0) {
        echo '<script>alert("Information Updated Successfully!!!");</script>';
        echo '<script>window.top.location="account_show.php";</script>';
    }
}

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Account Details</title>
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- Font Awesome Icons -->
    <link rel="stylesheet" href="css/fontawesome-free-6.6.0-web/css/all.min.css">
    <link rel="stylesheet" href="css/style.css">

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet">

    <style>
        .account_details {
            /*width: 800px;*/

            margin: 0 auto;
            /*border: 1px solid;*/
            /*border-radius: 5px;*/
        }
    </style>

</head>

<body>

    <div class="card-container p-5">
        <div class="card">
            <div class="card-header text-center">Details</div>
            <div class="card-body p-5">

                <form action="" method="post" id="account_details" name="account_details"></form>
                <div class="container p-2">
                    <?php
                    while ($rows = $result->fetch_assoc()) {
                    ?>
                        <div class="account_details bg-white mt-2 p-2">

                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">A/C Open Branch</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['branch_name'] . " (" . $rows['branch_id'] . ")"; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">A/C Type</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo "(" . $rows['ac_code'] . ") " . $rows['ac_name']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Applicant Name</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['name']; ?>" readonly>
                                </div>

                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Gender</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['gender']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Father Name</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['father_name']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Mother Name</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['mother_name']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Date of Birth</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['dob']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Occupation</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['occupation']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Mobile</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['mobile']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Email</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['email']; ?>" readonly>
                                </div>
                            </div>

                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Nationality</label>
                                </div>
                                <div class="col-md-6">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['nationality']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Present Address</label>
                                </div>
                                <div class="col-md-6">

                                    <textarea class="form-control" id="" name="" row="2"
                                        readonly><?php echo htmlspecialchars($rows['present_address']); ?></textarea>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Permanent Address</label>
                                </div>
                                <div class="col-md-6">

                                    <textarea class="form-control" id="" name="" row="2"
                                        readonly><?php echo htmlspecialchars($rows['permanent_address']); ?></textarea>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-3 text-primary fw-bold">
                                    <label class="col-form-label">Photo ID (NID/Passport)</label>
                                </div>
                                <div class="col-md-4">

                                    <img src="uploads/<?php echo $rows['user_front']; ?>"
                                        class="img-fluid rounded mx-auto d-block img-thumbnail" alt="user_front">
                                </div>
                                <div class="col-md-4">

                                    <img src="uploads/<?php echo $rows['user_back']; ?>"
                                        class="img-fluid rounded mx-auto d-block img-thumbnail" alt="user_back">
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-3 text-primary fw-bold">
                                    <label class="col-form-label">Customer photo</label>
                                </div>
                                <div class="col-md-7">

                                    <img src="uploads/<?php echo $rows['picture']; ?>"
                                        class="img-fluid rounded mx-auto d-block img-thumbnail" alt="customer_pic">
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-6 text-primary fw-bold">
                                    <span>Nominee :</span>
                                    <label class="col-form-label float-md-end"> Name:</label>
                                </div>
                                <div class="col-md-4">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['nominee_name']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-6 text-primary fw-bold">
                                    <label class="col-form-label float-md-end">Relation</label>
                                </div>
                                <div class="col-md-4">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['relation']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-6 text-primary fw-bold ">
                                    <label class="col-form-label float-md-end">Share</label>
                                </div>
                                <div class="col-md-4">
                                    <input type="text" id="" class="form-control" placeholder=""
                                        value="<?php echo $rows['share']; ?>" readonly>
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-3 text-primary fw-bold ">
                                    <label class="col-form-label ">Nominee PhotoID</label>
                                </div>
                                <div class="col-md-4">
                                    <img src="uploads/<?php echo $rows['nominee_front']; ?>"
                                        class="img-fluid rounded mx-auto d-block img-thumbnail" alt="nominee_id_front">
                                </div>
                                <div class="col-md-4">
                                    <img src="uploads/<?php echo $rows['nominee_back']; ?>"
                                        class="img-fluid rounded mx-auto d-block img-thumbnail" alt="nominee_id_back">
                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2">
                                <div class="col-md-3 text-primary fw-bold">
                                    <label class="col-form-label">Signature</label>
                                </div>
                                <div class="col-md-7">

                                    <img src="uploads/<?php echo $rows['sign']; ?>"
                                        class="img-fluid rounded mx-auto d-block img-thumbnail" alt="sign">
                                </div>
                            </div>

                            <div class="row d-flex mb-1 p-2">
                                <?php if($rows['face_verified'] == 'yes'){ ?>
                                <div class="col-md-12">

                                    <input type="checkbox" class="" id="face_verified" name="face_verified" value="yes"
                                        form="account_details" onclick="return false;" checked>
                                    <label class="col-form-label text-primary fw-bold">Face Verification</label>

                                </div>
                            <?php } else { ?>
                                <div class="col-md-12">

                                        <input type="checkbox" class="" id="face_verified" name="face_verified" value="yes"
                                            form="account_details" >
                                        <label class="col-form-label text-primary fw-bold">Face Verification</label>

                                </div>
                            <?php } ?>
                            <?php if($rows['nid_verified'] == 'yes'){ ?>
                                <div class="col-md-12">

                                    <input type="checkbox" class="" id="nid_verified" name="nid_verified" value="yes"
                                        form="account_details" onclick="return false;" checked>
                                    <label class="col-form-label text-primary fw-bold">NID Verification</label>

                                </div>
                            <?php } else { ?>

                            <div class="col-md-12">

                                    <input type="checkbox" class="" id="nid_verified" name="nid_verified" value="yes"
                                        form="account_details">
                                    <label class="col-form-label text-primary fw-bold">NID Verification</label>

                                </div>

                            </div>

                         <?php } ?>
                            <div class="row d-flex mb-1 p-2" id="ac_div">
                                <div class="col-md-4 text-primary fw-bold">
                                    <label class="col-form-label">Account Number</label>
                                </div>
                                <div class="col-md-6">

                                    <input type="text" id="numberInput" class="form-control" name="acc_number"
                                        minlength="15" maxlength="15"
                                        onkeypress="return event.key >= '0' && event.key <= '9' && this.value.length < 15;"
                                        form="account_details"
                                        value="<?php if ($rows['ac_number']) {
                                                    echo $rows['ac_number'];
                                                } else {
                                                    echo '';
                                                } ?>">


                                </div>
                            </div>
                            <div class="row d-flex mb-1 p-2" id="inform_div">

                                <div class="col-md-12">

                                    <input type="checkbox" class="" id="cust_informed" name="cust_informed" value="yes"
                                        form="account_details">
                                    <label class="col-form-label text-primary fw-bold">Informed to cutomer</label>

                                </div>

                            </div>



                            <div class="row d-flex mb-1 p-1 justify-content-end">

                                <div class="col-md-3">
                                    <input type="submit" class="btn btn-success" form="account_details"
                                        name="acc_update_btn">
                                </div>

                            </div>

                        </div>
                    <?php } ?>
                </div>

            </div>
        </div>
    </div>


    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://code.jquery.com/jquery-3.7.1.js"></script>



</body>

</html>