<?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>