JezK

Edit File: paymentManagement.php

<?php 
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include("header.php");
$fromdate = isset($_REQUEST['fromdate'])?$_REQUEST['fromdate']:'';
$todate = isset($_REQUEST['todate'])?$_REQUEST['todate']:'';
$payments  = $videocon->payments('',$fromdate,$todate);
//  print_r($payments);exit;
?>
<style>
    div.dataTables_wrapper div.dataTables_filter {
        position: absolute;
        top: 132px;
    }
</style>
<section class="section-padding">
    <div class="container m-3 bg-white">
        <div class="">
        <form action ='' method='GET' id="payments">
            <div class="calender-Right pt-4 mb-2">
                <label class="fieldName mt-2 mr-2">Select Date Range</label>
                <div id="reportrange1" class="col-xl-5 col-md-6 col-lg-8 formField-control" style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc;">
                    <i class=" float-right "><img src="img/calenderdark.png"></i>&nbsp;
                    <span></span>
                    <input type="hidden" class="hidden fromdate"  name="fromdate" value="">
                    <input type="hidden" class="hidden todate"  name="todate" value="">
                </div>
            </div>
        </form>
        
        <div class="row">
            <div class="col-xl-6">
                
            </div>
            <div class="col-xl-6 d-flex justify-content-end">
                
            </div>
        </div>
        <div class="table-responsive">
            <table id="dataTable" class="table table-striped table-borderless " style="width:100%">
                <thead class="tableBackground">
                    <tr>
                        
                        <th>S.No</th>
                        <th>INVOICE NO.</th>
                        <th>TRANSACTION NO.</th>
                        <th>PAID TO</th>
                        <th>PAID BY</th>
                        <th>ACTION</th>
                    </tr>
                </thead>
                <tbody>
                <?php $i=0;
                    foreach($payments as $k=>$v){
                        $i++;
                ?>
                    <tr>
                        
                        <td><?php echo $i?>.</td>
                        <td><?php echo "KRKKD".$v['id'];?></td>
                        <td><?php echo $v['transaction_id'];?></td>
                        <td><?php if(isset($v['business_name']) && $v['business_name'] !=""){ echo $v['business_name'];}else if(isset($v['professional_name']) && $v['professional_name'] !=""){echo $v['professional_name'];}?></td>
                        <td><?php echo $v['fullname'];?></td>
                        <td>
                            <span><a href="paymentView.php?bid=<?php echo $videocon->encrypt_decrypt('encrypt',$v['id']);?>" class="viewStyles">View</a></span>&nbsp;
                            
                        </td>
                    </tr>
                <?php 
                 }
                ?>
                </tbody>
            </table>
        </div>
    </div>
</div>
</section>

<div class="container">
    
    <div class="modal" id="myModal">
        <div class="modal-dialog">
            <div class="modal-content">
          
            <div class="modal-header border-0">
                <button type="button" class="close px-2 pt-2 pb-0" data-dismiss="modal">&times;</button>
            </div>
          
            <div class="modal-body mx-4">
                <h5 class="modal-title style-login mb-3">Block Business</h5>
            
                <form action="" method="POST">
                    <div class="mt-3 mb-2 d-flex">
                        <h6 class="text-yellow mr-auto mb-0"><small class="font-600">Enable the Business</small></h6>
                        <div class="radio-buttons-container d-flex">
                            <div class="custom-control custom-radio d-flex pr-3">
                                <input type="radio" class="custom-control-input" id="influencer" value="1" name="userType">
                                <label for="influencer" class="custom-control-label cutomRadio d-flex">
                                    <span class="align-self-center pl-2">Automatic</span>
                                </label>
                            </div>
                            <div class="custom-control custom-radio d-flex">
                                <input type="radio" class="custom-control-input" id="fan" value="2" name="userType">
                                <label for="fan" class="custom-control-label cutomRadio d-flex">
                                    <span class="align-self-center pl-2">Manually</span>
                                </label>
                            </div>
                        </div>
                    </div>
                    <div class="pt-2 mb-2">
                        <label class="fieldName mt-2 mr-2">Select Date Range</label>
                        <div id="singleDate" class="formField-control" style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc;">
                            <i class="fa fa-calendar float-right pt-1"></i>&nbsp;
                            <span></span>
                        </div>
                    </div>
                    <div class="d-flex justify-content-end">
                        <button class="btn cancelBtn">Cancel</button>&nbsp;&nbsp;
                        <button class="btn btn-primary">Block</button>
                    </div>
                </form>
            
            </div>
      </div>
    </div>
</div>
<?php include("footer.php");?>

<script>
    $(function() {

var start = moment().subtract(1, 'days');
        var end = moment();

function cb(start, end) {
            $('.fromdate').val(start.format('YYYY-MM-DD'));
            $('.todate').val(end.format('YYYY-MM-DD'));
            $('#reportrange1 span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
        }

$('#reportrange1').daterangepicker({
            startDate: start,
            endDate: end,
            ranges: {
        
            'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
            }
        }, cb);

cb(start, end);

});
    ///// date submission ////////
    $('#reportrange1').on('apply.daterangepicker', function(ev, picker) {

// alert(picker.startDate.format('DD-MM-YYYY')+' To '+picker.endDate.format('DD-MM-YYYY'));

var fromdate = picker.startDate.format('YYYY-MM-DD');
        var todate =picker.endDate.format('YYYY-MM-DD');
        $('#payments').submit();
    });
    ////// reload ////////
    $(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);
        $('#reportrange1 span').html(x1 + ' - ' + y1);

});
</script>