File "account_details.php"
Full path: /home/fsibplc/public_html/fsib/accountOpening-v2/account_details.php
File
size: 22.23 B (22.23 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?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>