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


include 'dbconnect.php';

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

$select_sql = "SELECT  branch.branch_name, account_type.name as  'ac_name', 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` 
 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);
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Details Show</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>
    /*.container {*/
    /*    width: 850px;*/
    /*    margin-left: 0;*/
    /*}*/
    </style>
</head>

<body>
    
    <div class="card-container p-5">
        <img src="images/fslogo.jpeg" alt="fsib_logo" class="mx-auto d-block mb-3" width = "550" height="90">
        <div class="card">
            <div class="card-header text-center">Details Show</div>
            
            <div class="card-body p-5">
                
    <!--<div class="container p-2" style="">-->
    <!--    <img src="images/fsib_logo.png" alt="fsib_logo" class="w-100 mb-1" height="120">-->
    <!--    <div class="card">-->
    <!--        <div class="card-header text-center alert-primary fw-bold">Details Show</div>-->
    <!--        <div class="card-body">-->
                <?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">
                            A/C Open Branch
                        </div>
                        <div class="col-md-6">
                            <?php echo $rows['branch_name']; ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">

                        <div class="col-md-4 text-primary fw-bold">
                            A/C Type
                        </div>
                        <div class="col-md-6">
                            <?php echo $rows['ac_name']; ?>
                        </div>
                    </div>
                     <div class="row d-flex mb-1 p-2">

                        <div class="col-md-4 text-primary fw-bold">
                            Applicant Name
                        </div>
                        <div class="col-md-6">
                            <?php echo $rows['name']; ?>
                        </div>
                        
                    </div>
                    <div class="row d-flex mb-1 p-2">

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

                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Nationality
                        </div>
                        <div class="col-md-6">
                            <?php echo $rows['nationality']; ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Present Address
                        </div>
                        <div class="col-md-6">
                            <?php echo htmlspecialchars($rows['present_address']); ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Permanent Address
                        </div>
                        <div class="col-md-6">
                            <?php echo htmlspecialchars($rows['permanent_address']); ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Photo ID (NID/Passport)
                        </div>
                        <div class="col-md-6">

                            <img src="uploads/<?php echo $rows['user_front']; ?>"
                                class="w-75" alt="user_front" height="160">
                        </div>

                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Customer photo
                        </div>
                        <div class="col-md-6">

                            <img src="uploads/<?php echo $rows['picture']; ?>"
                                class="img-fluid w-50 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>
                            <span class=" float-md-end"> Name:</span>
                        </div>
                        <div class="col-md-4">
                            <?php echo $rows['nominee_name']; ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-6 text-primary fw-bold">
                            <span class=" float-md-end">Relation:</span>
                        </div>
                        <div class="col-md-4">
                            <?php echo $rows['relation']; ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-6 text-primary fw-bold ">
                            <span class="float-md-end">Share:</span>
                        </div>
                        <div class="col-md-4">
                            <?php echo $rows['share']; ?>
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold ">
                            Nominee PhotoID
                        </div>
                        <div class="col-md-6">
                            <img src="uploads/<?php echo $rows['nominee_front']; ?>"
                                class="img-fluid w-50 img-thumbnail" alt="nominee_id_front">
                        </div>

                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Signature
                        </div>
                        <div class="col-md-6">

                            <img src="uploads/<?php echo $rows['sign']; ?>"
                                class="w-75" alt="sign" height="160">
                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 text-primary fw-bold">
                            Account Number
                        </div>
                        <div class="col-md-6 fw-bold">
                        <?php if($rows['ac_number']){echo $rows['ac_number'];}?>

                        </div>
                    </div>
                    <div class="row d-flex mb-1 p-2">
                        <div class="col-md-4 ">

                        </div>
                        <div class="col-md-6">

                            <input type="checkbox" class="" onclick="return false;" id="cust_informed" name="cust_informed" value="yes"
                                form="" checked>
                            <label class="col-form-label text-success fw-bold">Informed to customer</label>

                        </div>
                    </div>



                </div>
                <?php } ?>

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


    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"></script>
</body>

</html>