JezK
Edit File: paymentManagement_new.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); ?> <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> <span></span> <input type="hidden" class="hidden fromdate" name="fromdate" value=""> <input type="hidden" class="hidden todate" name="todate" value=""> </div> </div> </form> <!--ENd calender --> <div class="row"> <div class="col-xl-6"> <!-- <a class="selectAll buttonStyle">Select All</a> <a class="unSelectAll buttonStyle">Unselect All</a> <a class="deleteAll buttonStyle">Delete All</a> --> </div> <div class="col-xl-6 d-flex justify-content-end"> <!-- <a href="#" class="btn btn-primary py-0">Export Excel</a> --> </div> </div> <div class="table-responsive"> <table id="dataTable" class="table table-striped table-borderless " style="width:100%"> <thead class="tableBackground"> <tr> <!-- <th></th> --> <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> <label class="container1"> <input type="checkbox" class="checkmark"> <span class="checkmark1"></span> </label> </td> --> <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> <!-- <span><a href="#" class="viewStyles">Delete</a></span> --> </td> </tr> <?php } ?> </tbody>