.-.-.-.-.-

<?php
$title = "Bank Receipt Report";
include 'header.php';
$param = '';
$param .= isset($_GET['login_id']) && $_GET['login_id'] != '' ? "&amp;login_id=" . $_GET['login_id'] : '';
$param .= isset($_GET['from_date']) && $_GET['from_date'] != '' ? "&amp;from_date=" . $_GET['from_date'] : '';
$param .= isset($_GET['to_date']) && $_GET['to_date'] != '' ? "&amp;to_date=" . $_GET['to_date'] : '';
$query = "SELECT a.`id` AS id, a.`uid` AS uid, a.`amount` AS amount, a.`payment_type` AS payment_type, a.`file_name` AS file_name, a.`file_path` AS file_path, a.`remark` AS remark, a.`datetime` AS datetime, a.`status` AS status, "
        . "a.`payment_mode` AS payment_mode,a.`bank_name` AS bank_name, a.`bank_branch` AS bank_branch, a.`ifsc` AS ifsc,a.`mobile` AS mobile, a.`payment_datetime` AS payment_datetime, a.`transaction_number` AS transaction_number, "
        . "b.name as name, b.login_id as login_id FROM `bank_receipt` a INNER JOIN user b ON a.uid = b.uid WHERE a.uid !=0 ";
$query .= isset($_GET['login_id']) && $_GET['login_id'] != '' ? " AND b.login_id = '" . $_GET['login_id'] . "'" : '';
$query .= isset($_GET['from_date']) && $_GET['from_date'] != '' && isset($_GET['to_date']) && $_GET['to_date'] != '' ? " AND (date(a.datetime) BETWEEN '" . $_GET['from_date'] . "' AND '" . $_GET['to_date'] . "')" : '';
$query != " ORDER BY a.`datetime`DESC";
?>
<div class="container-fluid" >
    <?php echo getMessage(); ?>
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Bank Receipt Report</h4>
               <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Support</a></li>
                    <li class="breadcrumb-item active">Bank Receipt Report</li>
                </ol>
            </div>
        </div>
   
    <div class="row">
        <div>
            <div class="card m-b-20">
                <div class="card-body">

<table class="table table-striped table-bordered mb-0 " id="datatable-ajax-page">
                        <thead>
                            <tr>
                                <th>S. No.</th>
                                <th>Name</th>
                                <th>Amount</th>
                                <th>Payment for</th>
                                
                                <th>Date</th>
                                <th>Receipt</th>
                                <th>Payment Mode</th>
                                <th>Bank Name</th>
                                
                                <th>IFSC</th>
                                <th>Mobile No</th>
                                <th>Payment Date</th>
                                <th>Transaction #</th>
                                <th>Pin Package</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>

</tbody>

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

</div>

</div>
     </div>

/home2/wtmwscom/public_html/DOCS/../admin/bank_receipt_report.php