Tiny File Manager

Back Back Up Advanced Editor

<?php

include 'all_sql.php';
include 'sidebar.php';

<?php
    // Account Opening Request
    $request_sql = "SELECT COUNT(*) as total_request FROM `account_info` WHERE `status` IS NULL";
    $request_sql_result = $conn->query($request_sql);
    $request_row = $request_sql_result->fetch_assoc();
    $total_request_pending = $request_row['total_request'];

// Account Opened but not informed
    $open_notInform_sql = "SELECT COUNT(*) as total_opened FROM `account_info` WHERE `status` = 'Approved' AND `inform` = 'No'";
    $open_notInform_sql_result = $conn->query($open_notInform_sql);
    $open_notInform_row = $open_notInform_sql_result->fetch_assoc();
    $total_open_notInform = $open_notInform_row['total_opened'];

// Account Opened but not informed
    $completed_sql = "SELECT COUNT(*) as total_completed FROM `account_info` WHERE `inform` = 'yes'";
    $completed_sql_result = $conn->query($completed_sql);
    $completed_row = $completed_sql_result->fetch_assoc();
    $total_completed = $completed_row['total_completed'];

?>
    <h1>Dashboard Overview</h1>
    <div class="d-flex justify-content-start mb-5">
        <div class="">
            <div class="card" id="requestCard">
                <div class="card-body d-flex justify-content-around align-items-center">
                    <div class="left">
                        <p class="card-focus"><?= $total_request_pending; ?></p>
                        <p class="card-title">Account Request</p>
                        <p class="card-subtitle text-info">(Not Opened)</p>

</div>
                    <div class="right">
                        <img src="icon/request.png" alt="">
                    </div>
                </div>
            </div>
        </div>
        <div class="">
            <div class="card" id="openedCard">
                <div class="card-body d-flex justify-content-around align-items-center">
                    <div class="left">
                        <p class="card-focus"><?= $total_open_notInform; ?></p>
                        <p class="card-title">Account Opened</p>
                        <p class="card-subtitle text-primary">(Not Informed)</p>

</div>
                    <div class="right">
                        <img src="icon/add-account.png" alt="">
                    </div>
                </div>
            </div>
        </div>
        <div class="">
            <div class="card" id="completedCard">
                <div class="card-body d-flex justify-content-around align-items-center">
                    <div class="left">
                        <p class="card-focus"><?= $total_completed; ?></p>
                        <p class="card-title">Completed Account</p>
                        <p class="card-subtitle text-success">(Informed)</p>

</div>
                    <div class="right">
                        <img src="icon/completed-task.png" alt="">
                    </div>
                </div>

</div>
        </div>

</div>

<div class="user-table" id="requestTable">
        <div class="table-container">
            <h3>Account Request List</h3>
            <table id="table0" class="celled table table-hover table-striped table-bordered dt-responsive" style="width:100%">
                <thead class="">
                    <tr>
                        <th rowspan="2">Sl</th>
                        <th rowspan="2">Applicant Name</th>
                        <th rowspan="2">Father Name</th>
                        <th rowspan="2">Mother Name</th>
                        <th rowspan="2">Date Of Birth</th>
                        <th colspan="2">Verified</th>
                        <th rowspan="2">Action</th>
                    </tr>
                    <tr>
                        <th>Nid</th>
                        <th>Face</th>
                    </tr>
                </thead>
                <tbody>

<?php
                    $results = $conn->query("SELECT * FROM `account_info` WHERE `status` IS NULL ORDER BY `id` ASC");

$sl = 1;
                    while ($rows = $results->fetch_assoc()) {
                    ?>
                        <tr>
                            <td><?= $rows['id']; ?></td>
                            <td><?php echo $rows['name']; ?></td>
                            <td><?php echo $rows['father_name']; ?></td>
                            <td><?php echo $rows['mother_name']; ?></td>
                            <td><?php echo $rows['dob']; ?></td>

</td>

</tr>
                    <?php $sl++;
                    } ?>
                </tbody>
            </table>
        </div>
    </div>

<div class="user-table" id="openedTable">
        <div class="table-container">
            <h3>Account Opened List</h3>
            <table id="table1" class="celled table table-hover table-striped table-bordered dt-responsive" style="width:100%">
                <thead class="">
                    <tr>
                        <th rowspan="2">Sl</th>
                        <th rowspan="2">Applicant Name</th>
                        <th rowspan="2">Father Name</th>
                        <th rowspan="2">Mother Name</th>
                        <th rowspan="2">Date Of Birth</th>
                        <th rowspan="2">Status</th>
                        <th colspan="2">Verified</th>
                        <th rowspan="2">Action</th>
                    </tr>
                    <tr>
                        <th>Nid</th>
                        <th>Face</th>
                    </tr>
                </thead>
                <tbody>

<?php
                    $result = $conn->query("SELECT * FROM `account_info` WHERE `status` = 'Approved' AND `inform` = 'No' ORDER BY `id` ASC");

$sl = 1;
                    while ($rows = $result->fetch_assoc()) {
                    ?>
                        <tr>
                            <td><?= $sl; ?></td>
                            <td><?php echo $rows['name']; ?></td>
                            <td><?php echo $rows['father_name']; ?></td>
                            <td><?php echo $rows['mother_name']; ?></td>
                            <td><?php echo $rows['dob']; ?></td>
                            <td class="text-center"><?php echo $rows['status']; ?></td>
                            <td class="text-center"><?php echo $rows['nid_verified']; ?></td>
                            <td class="text-center"><?php echo $rows['face_verified']; ?></td>
                            
                            <td class="text-center">
                                <form action="" method="post">
                                    <input type="hidden" name="row_id" value="<?php echo $rows['id']; ?>">
                                    <input type="submit" class="btn btn-primary" value="Inform"
                                        name="inform_details_btn" id="inform_details_btn"></a>
                                </form>

</td>
                        </tr>
                    <?php $sl++;
                    } ?>
                </tbody>
            </table>
        </div>
    </div>
    <div class="user-table" id="completedTable">
        <div class="table-container">
            <h3>Account Completed List</h3>
            <table id="table2" class="celled table table-hover table-striped table-bordered dt-responsive" style="width:100%">
                <thead class="">
                    <tr>
                        <th rowspan="2">Sl</th>
                        <th rowspan="2">Applicant Name</th>
                        <th rowspan="2">Father Name</th>
                        <th rowspan="2">Mother Name</th>
                        <th rowspan="2">Date Of Birth</th>
                        <th rowspan="2">Status</th>
                        <th colspan="2">Verified</th>
                        <th rowspan="2">Informed</th>
                        <th rowspan="2">Details</th>
                    </tr>
                    <tr>
                        <th>Nid</th>
                        <th>Face</th>
                    </tr>
                </thead>
                <tbody>

<?php
                    $result = $conn->query("SELECT * FROM `account_info` WHERE `inform` = 'yes' ORDER BY `id` ASC");

$sl = 1;
                    while ($rows = $result->fetch_assoc()) {
                    ?>
                        <tr>
                            <td><?= $sl; ?></td>
                            <td><?php echo $rows['name']; ?></td>
                            <td><?php echo $rows['father_name']; ?></td>
                            <td><?php echo $rows['mother_name']; ?></td>
                            <td><?php echo $rows['dob']; ?></td>
                            <td class="text-center"><?php echo $rows['status']; ?></td>
                            <td class="text-center"><?php echo $rows['nid_verified']; ?></td>
                            <td class="text-center"><?php echo $rows['face_verified']; ?></td>
                            <td class="text-center"><?php echo $rows['inform']; ?></td>
                            <td class="text-center">
                                <form action="" method="post">
                                    <input type="hidden" name="row_id" value="<?php echo $rows['id']; ?>">
                                    <input type="submit" class="btn btn-success" value="View"
                                        name="view_details" id="view_details"></a>
                                </form>

</td>
                        </tr>
                    <?php $sl++;
                    } ?>
                </tbody>
            </table>
        </div>
    </div>

</div>
<form method="POST" action="" id="info_update" name="info_update"></form>
<div class="details-content" id="details-content">
    <div class="" id="openAction">
        <div class="table-container p-5">
            <h3 class="text-info text-center mb-5">Customer Details</h3>
            <?php
            if ($single_result->num_rows > 0) { ?>
                <div class="update-content" id="update-content">
                    <?php
                    // $index = 1;
                    while ($cus_details = $single_result->fetch_assoc()) {
                        // print_r($cus_details);
                    ?>

<div class="row">
                            <div class="col-4">
                                <p><strong>Branch :</strong> <?php echo $cus_details['branch_name'] . "(" . $cus_details['branch_id'] . ")"; ?></p>
                                <p><strong>Ac Type :</strong> <?php echo $cus_details['ac_name'] . "(" . $cus_details['ac_code'] . ")"; ?></p>
                                <p><strong>Name :</strong> <?php echo $cus_details['name']; ?></p>
                                <p><strong>Father Name :</strong> <?php echo $cus_details['father_name']; ?></p>
                                <p><strong>Mother Name :</strong> <?php echo $cus_details['mother_name']; ?></p>
                                <br>
                            </div>
                            <div class="col-4">
                                <p><strong>Date Of Birth :</strong> <?php echo $cus_details['dob']; ?></p>
                                <p><strong>Gender :</strong> <?php echo $cus_details['gender']; ?></p>
                                <p><strong>Occupation :</strong> <?php echo $cus_details['occupation']; ?></p>
                                <p><strong>Mobile :</strong> <?php echo $cus_details['mobile']; ?></p>
                                <p><strong>Email :</strong> <?php echo $cus_details['email']; ?></p>
                            </div>
                            <div class="col-4">
                                <p><strong>Nationality :</strong> <?php echo $cus_details['nationality']; ?></p>
                                <p><strong>Present Address :</strong> <?php echo $cus_details['present_address']; ?></p>
                                <p><strong>Permenant Address :</strong> <?php echo $cus_details['permanent_address']; ?></p>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-4">
                                <p><strong>Customer Image :</strong><img src="uploads/<?php echo $cus_details['picture']; ?>"
                                        class="img-fluid rounded d-block img-thumbnail" alt="customer_pic"></p>
                            </div>
                            <div class="col-4">
                                <p><strong>NID :</strong> <img src="uploads/<?php echo $cus_details['user_front']; ?>"
                                        class="img-fluid rounded d-block img-thumbnail" alt="user_front"></p>
                            </div>
                            <div class="col-4">
                                <p><strong>Signature :</strong> <img src="uploads/<?php echo $cus_details['sign']; ?>"
                                        class="img-fluid rounded  d-block img-thumbnail" alt="user_front"></p>
                            </div>
                        </div>
                        <hr style="border-color:green;opacity:0.3">

<div class="col-4">
                                <h4 class="text-primary mb-3">Nominee Information</h4>
                                <p><strong>Nominee Name :</strong> <?php echo $cus_details['nominee_name']; ?></p>
                                <p><strong>Relation :</strong> <?php echo $cus_details['relation']; ?></p>
                                <p><strong>Share :</strong> <?php echo $cus_details['share']; ?></p>
                            </div>
                            <div class="col-4">
                                <br>
                                <p><strong>Nominee NID/Passport(Front) :</strong><img src="uploads/<?php echo $cus_details['nominee_front']; ?>"
                                        class="img-fluid rounded  d-block img-thumbnail" alt="user_front"></p>
                            </div>
                            <div class="col-4">
                                <br>
                                <p><strong>Nominee NID/Passport(Back) :</strong><img src="uploads/<?php echo $cus_details['nominee_back']; ?>"
                                        class="img-fluid rounded d-block img-thumbnail" alt="user_front"></p>
                            </div>
                        </div>
                        <hr style="border-color:green;opacity:0.3">

<h4 class="text-success mb-3">Verification Process</h4>

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

<?php
                            if ($cus_details['face_verified'] == 'yes') { ?>
                                <div class="col-md-12">

<input form="info_update" type="checkbox" class="" id="face_verified" name="face_verified" value="yes"
                                        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="info_update">
                                    <label class="col-form-label text-primary fw-bold">Face Verification</label>

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

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

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

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

</div>

</div>
                    <?php } ?>

<div class="row col-md-12">
                        <div class="form-group col-5" style="margin-right: 15px;">
                            <div class="row">
                                <label for="ac_number" class="col-5"><strong>Account Number :</strong></label>
                                <input form="info_update" type="text" id="numberInput" class="form-control col-7" name="acc_number" minlength="15" maxlength="15"
                                    onkeypress="return event.key >= '0' && event.key <= '9' && this.value.length < 15;"

value="<?php if ($cus_details['ac_number']) {
                                                echo $cus_details['ac_number'];
                                            } else {
                                                echo '';
                                            } ?>">
                            </div>
                        </div>

<div class="form-group col-3">
                            <input type="submit" class="btn btn-success" name="acc_update_btn" value="UPDATE" form="info_update">
                        </div>
                    </div>

</div>
        </div>
    <?php
                    }
                } else if ($view_sql_execute->num_rows > 0) { ?>
    <div class="view-content" id="view-content">
        <?php
                    // $index = 1;
                    while ($cus_details = $view_sql_execute->fetch_assoc()) {
                        // print_r($cus_details);
        ?>

</div>
                <div class="col-4">
                    <p><strong>Date Of Birth :</strong> <?php echo $cus_details['dob']; ?></p>
                    <p><strong>Gender :</strong> <?php echo $cus_details['gender']; ?></p>
                    <p><strong>Occupation :</strong> <?php echo $cus_details['occupation']; ?></p>
                    <p><strong>Mobile :</strong> <?php echo $cus_details['mobile']; ?></p>
                    <p><strong>Email :</strong> <?php echo $cus_details['email']; ?></p>

</div>
                <div class="col-4">
                    <p><strong>Nationality :</strong> <?php echo $cus_details['nationality']; ?></p>
                    <p><strong>Present Address :</strong> <?php echo $cus_details['present_address']; ?></p>
                    <p><strong>Permenant Address :</strong> <?php echo $cus_details['permanent_address']; ?></p>
                    <p><strong>Account Number :</strong> <?php echo $cus_details['ac_number']; ?></p>

</div>
            </div>
            <div class="row">
                <div class="col-4">
                    <p><strong>Customer Image :</strong><img src="uploads/<?php echo $cus_details['picture']; ?>"
                            class="img-fluid rounded d-block img-thumbnail" alt="customer_pic"></p>
                </div>
                <div class="col-4">
                    <p><strong>NID :</strong> <img src="uploads/<?php echo $cus_details['user_front']; ?>"
                            class="img-fluid rounded d-block img-thumbnail" alt="user_front"></p>
                </div>
                <div class="col-4">
                    <p><strong>Signature :</strong> <img src="uploads/<?php echo $cus_details['sign']; ?>"
                            class="img-fluid rounded  d-block img-thumbnail" alt="user_front"></p>
                </div>
            </div>
            <hr style="border-color:green;opacity:0.3">

<div class="col-4">
                    <h4 class="text-primary">Nominee Information</h4>
                    <p><strong>Nominee Name :</strong> <?php echo $cus_details['nominee_name']; ?></p>
                    <p><strong>Relation :</strong> <?php echo $cus_details['relation']; ?></p>
                    <p><strong>Share :</strong> <?php echo $cus_details['share']; ?></p>
                </div>
                <div class="col-4">
                    <br>
                    <p><strong>Nominee NID/Passport(Front) :</strong><img src="uploads/<?php echo $cus_details['nominee_front']; ?>"
                            class="img-fluid rounded  d-block img-thumbnail" alt="user_front"></p>
                </div>
                <div class="col-4">
                    <br>
                    <p><strong>Nominee NID/Passport(Back) :</strong><img src="uploads/<?php echo $cus_details['nominee_back']; ?>"
                            class="img-fluid rounded d-block img-thumbnail" alt="user_front"></p>
                </div>
            </div>
            <hr style="border-color:green;opacity:0.3">

<button onclick="CompletedTableGoBackGoBack()" class="btn btn-primary">Go Back</button>
    </div>
<?php
                    }
                } else {
                    echo "<tr><td colspan='8'>No customer details found.</td></tr>";
                }
?>
    </div>
</div>
</div>

<?php include 'footer.php'; ?>