.-.-.-.-.-

<?php
$title = "Bank Report";
include 'header.php';
?>

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Bank Report</h4>
                <ol class="breadcrumb">
                      <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Income</a></li>
                    <li class="breadcrumb-item active">Bank Report</li>
                </ol>

</div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <form class="form-inline" id="search-form" action="">
                        <div class="form-group " >
                            <label class="form-control" for="login_id"> UserId: </label>
                            <input type="text" class="form-control" id="login_id" placeholder="Enter login id" name="login_id">
                        </div>
                        <div class="form-group " >
                            <label class="form-control " > From Date: </label>
                            <input type="text" class="form-control datepicker"  placeholder="From date" name="from_date" autocomplete="off">
                        </div>&nbsp;
                        <div class="form-group">
                            <label class="form-control "> To date: </label>
                            <input type="text" class="form-control datepicker"  placeholder="To date" name="to_date" autocomplete="off" >
                        </div>
                     
                        
                        <select name="hold_payment" id="hold_payment" class="form-control">
                            <option value="">All Payment User</option>
                            <option value="0">Active Payment</option>
                            <option value="1">Hold Payment</option>
                            
                        </select>
                        
                        <select name="status" id="hold_payment" class="form-control">
                            <option value="">All Status User</option>
                            <option value="0">Active User</option>
                            <option value="1">Blocked User</option>
                            
                        </select>&nbsp;&nbsp;
                             <select name="income_type" id="income_type" class="form-control">
                            <option value="">All income</option>
                            <option value="1">Referral Income</option>
                                 <option value="2">Binary Pair Income</option>
                            <option value="3">Binary Matching Income</option>
                                <option value="5">Income on Incomee</option>
                            <option value="7">Daily Growth Income</option>
                            
                        </select>&nbsp;&nbsp;

<button type="submit" class="btn btn-primary" id="submit">Search</button><br><br><br>
                    </form>

<table class="table mb-0 table-striped table-bordered " id="datatable-ajax-page">
                        <thead>
                            <tr>
                                <th>Debit Ac No</th>
                                <th>Beneficiary Ac No</th>
                                <th>Beneficiary Name</th>
                                <th>Amt</th>
                                <th>Pay Mod</th>
                                <th>Date</th>
                                <th>IFSC</th>
                                <th>Payable Location</th>
                                <th>Print Location</th>
                                <th>Bene Mobile No</th>
                                <th>Bene Email ID</th>
                                <th>Bene add1</th>
                                <th>Bene add2</th>
                                <th>Bene add3</th>
                                <th>Bene add4</th>
                                <th>Add Details 1</th>
                                <th>Add Details 2</th>
                                <th>Add Details 3</th>
                                <th>Add Details 4</th>
                                <th>Add Details 5</th>
                                <th>Remarks</th>
                            </tr>
                        </thead>
                        <tbody>

</tbody>
                    </table>
                    <?php //echo $pager->renderFullNav();       ?>  
                </div>
            </div>
        </div> 
    </div>
    
</div>
<script>
    var start;
    $(document).ready(function () {
        var table = $('#datatable-ajax-page').DataTable({
            "ajax": {
                url: "./report/bank_report_JSON.php",
                type: "GET",
                data: function (d) {
                    var formData = $("#search-form").serializeArray();
                    $.each(formData, function (i, field) {
                        d[field.name] = field.value;
                    });
                },
            },
            "processing": true,
            "serverSide": true,
            "pageLength": 500,
            "lengthMenu": [[50, 100, 500, -1], ["50", "100", "500", "All"]],
            "dom": 'B<"top">rt<"bottom"lp><"clear">',
            buttons: [
                'excel', 'csv', 'pdf', 'print'
            ],
            "columns": [
                {"data": "debit_ac_number"},
                {"data": "beneficiary_ac_no"},
                {"data": "beneficiary_name"},
                {"data": "amt"},
                {"data": "pay_mod"},
                {"data": "date"},
                {"data": "ifsc"},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "user_id", "render": function (data, type, full, meta) {
                        return "";
                    }},
                {"data": "login_id"},
            ],
            "initComplete": function (settings, json) {
                $("#net_total").text(json.net_total);
            }
        }
        );
        table.on('xhr', function () {
            start = table.ajax.json().start;

});
        $("#search-form").submit(function (e) {
            //table.ajax.data({fromDate: $("#fromDate").val(), toDate: $("#toDate").val(), entityId: $("#customerId").val()});
            table.ajax.reload();
            e.preventDefault();
        });
    });

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

/home2/wtmwscom/public_html/themes1582.wtmwebshop.com/./../admin/bank_report.php