JezK

Edit File: payments(22-04-2020).php

<?php
include("header.php");

$fromdate = isset($_REQUEST['fromdate']) ? $_REQUEST['fromdate'] : '';
$todate = isset($_REQUEST['todate']) ? $_REQUEST['todate'] : '';
$paymentHis = $users->userspaymentHistory('', '', $_SESSION['id'], $fromdate, $todate);
// print_r($paymentHis)
?>
<style>
    div.dataTables_wrapper div.dataTables_filter {
        position: absolute;
        top: 154px;
        display: none;
    }
</style>
<section class="section-padding">
    <div class="container">
        
        <ul class="nav nav-tabs border-0" role="tablist" id="myTab">
            <li class="nav-item">
                <a class="nav-link active anc-Color" data-toggle="tab" href="#payment-h">Payment History</a>
            </li>
            
        </ul>
        
        <div class="tab-content  bg-white my-3">
            <div id="payment-h" class="container tab-pane active"><br>
                <div class="container pb-3">
                    <div class="row">
                        <div class="col-xl-6 col-sm-6 col-md-8 videoConf mt-2">
                            <form action='' method='GET' id="transactions">
                                <label class="payment-l">Select Date Range</label>
                                <div id="reportrange" class=" formField-control" style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc;">
                                    <i class=" float-right "><img src="img/calenderdark.png"></i>
                                    <span></span>
                                    <input type="hidden" class="hidden fromdate" name="fromdate" value="">
                                    <input type="hidden" class="hidden todate" name="todate" value="">
                                </div>
                            </form>
                        </div>
                        <form action="transactionExport.php" method="POST" id="exportdata" name="exportdata" onsubmit="return exporttransactions()">
                            <div class="col-xl-12 col-sm-6 col-md-8 videoConf mt-2 ">
                                <label class="payment-l invisible">payments</label>
                                <input type="submit" class="btn btn-primary btn-sm w-100" value="Export data" />
                            </div>
                            <input type="hidden" name="Export">
                            <input type="hidden" id="tfromdate" name="tfromdate" value="">
                            <input type="hidden" id="ttodate" name="ttodate" value="">

</form>

</div>
                    <hr>
                    <div id="">
                        
                        <div class="">
                            <table id="dataTable" class="table table-striped table-borderless" style="width:100%">
                                <thead class="tableBackground">
                                    <tr>
                                        
                                        <th>DATE</th>
                                        <th>PAYMENT TO</th>
                                        <th>AMOUNT</th>
                                    </tr>
                                </thead>
                                <tbody id="paymentcontainer">
                                    <?php if (count($paymentHis) > 0) {
                                        foreach ($paymentHis as $k => $v) {
                                            $paymentto = ($v['business_name'] != '' ? $v['business_name'] : ($v['professional_name'] != '' ? $v['professional_name'] : ' NA')); ?>
                                            <tr>
                                                <td><?php echo date('F jS Y', strtotime($v['date'])); ?></td>
                                                <td>Payment to <?php echo $paymentto; ?></td>
                                                <td><?php echo $v['amount']; ?></td>
                                            </tr>
                                        <?php }
                                } ?>
                                </tbody>
                            </table>
                        </div>

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

</div>
    </div>
</section>
<input type="hidden" class="hidden " name="" id="hiddenval" value="0">

<?php include("footer.php"); ?>

$(document).ready(function() {

var url = window.location.href;

function getParameterByName(name, href) {
            name = name.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");
            var regexS = "[\\?&]" + name + "=([^&#]*)";
            var regex = new RegExp(regexS);
            var results = regex.exec(href);
            /* if( results == null )
                return "";
            else */
            return decodeURIComponent(results[1].replace(/\+/g, " "));
        }

var from = getParameterByName("fromdate", url);
        var to = getParameterByName("todate", url);
        var x1 = moment(from).format('DD MMMM, YYYY ');
        var y1 = moment(to).format('DD MMMM, YYYY');

// alert(x1);
        $('#reportrange span').html(x1 + ' - ' + y1);

});
</script>