JezK

Edit File: consultationHistory.php

<?php
include("header.php");
$aboutVideoSession =  $videocon->getAboutVideoSession();

?>
<style>
    div.dataTables_wrapper div.dataTables_filter {
        position: absolute;
        top: 131px;
        left: 416px;
    }

#dataTable_filter .form-control {
        width: 421px;
        height: 32px;
    }

@media screen and (max-width: 768px) and (min-width: 360px) {
        #dataTable_filter .getserchfieldval {
            width: 327px;
        }

div.dataTables_wrapper div.dataTables_filter {
            position: absolute;
            top: 190px;
            left: 17px;
        }
        .exdata{
            padding-top:45px !important; 
        }
    }
</style>
<section class="section-padding">
    <div class="container bg-white">
        <div class="row pt-3">
            <div class="col-12 col-sm-12 col-md-4 col-lg-4">
            </div>
            <div class="col-12 col-sm-12 col-md-5 col-lg-5">
                <label class="d-flex m-0 align-items-center fieldName">Search</label>
            </div>
            <div class="col-12 col-sm-12 col-md-3 col-lg-3  align-items-center exdata " style="padding-top:18px;">
                &nbsp;&nbsp;&nbsp;&nbsp;
            </div>
        </div>
        <div class="table-responsive mt-3">
            <table id="dataTable" class="table table-striped table-borderless " style="width:100%">
                <thead class="tableBackground">
                    <tr>
                        <th class="border-right-sm">S.No</th>
                        <th class="border-right-sm">USERNAME</th>
                        <th class="border-right-sm">SLOT DATE</th>
                        <th class="border-right-sm">SLOT TIMES</th>
                        <th class="border-right-sm">ORDER/INVOICE ID</th>
                        <th class="border-right-sm">ABOUT SESSION</th>
                        <th class="border-right-sm">DATE</th>
                        <th class="border-0">ACTION</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if (is_array($aboutVideoSession) && count($aboutVideoSession)>0) {
                        $i = 0;
                        foreach ($aboutVideoSession as $k => $v) {
                          $i++;  
                            ?>
                            <tr>
                                <td><?php echo $i ?>.</td>
                                <td><?php echo $v['fullname']; ?></td>
                                <td><?php echo $v['slot_date']; ?></td>
                                <td><?php echo $v['completed_timeslots']; ?></td>
                                <td><?php echo "KRKKD" . $v['id']; ?></td>
                                <td><?php echo $v['about_session'] ?></td>
                                <td> <?php echo date("Y-m-d",strtotime($v['date'])); ?></td>
                                <td class="px-0 pl-3">
                                    <a href="consultationHistoryView.php?aid=<?php echo $videocon->encrypt_decrypt('encrypt',$v['acid']); ?>" class="viewStyles">View</a>
                                    
                                </td>
                            </tr>
                        <?php }
                } ?>
                </tbody>
            </table>
        </div>
    </div>
</section>
<?php include("footer.php"); ?>

<script>
    /* $(document).on('change','#date',function(){
    alert('Change Happened');
}); */

$('#fromDateRange').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');
        $('#transactions').submit();
    });

$(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);
        $('#fromDateRange span').html(x1 + ' - ' + y1);

});

function exporttransactions() {
        $('#tfromdate').val('<?php echo isset($_REQUEST['fromdate']) ? $_REQUEST['fromdate'] : ""; ?>')
        $('#ttodate').val('<?php echo isset($_REQUEST['todate']) ? $_REQUEST['todate'] : ""; ?>')
        $('#tsearch').val($('.getserchfieldval').val());
        $("#exportdata").submit();
        return false;
    }
</script>