EVOLUTION-NINJA

Edit File: subscription-payment.php

<?php
    echo view('includes/admin-header', $user_management, $org);    
	$role_id = session()->get('role_id');

<div class="col-sm-10" style="padding:3%;">
        
           <div class="row" id="mobile-div">
               <div class="col-sm-4">
                    <h4 class="user-tag">Subscription Payment List</h4>
                    
               </div>
               <div class="col-sm-4">
                
                </div>
               <div class="col-sm-4">
                    <button type="button" id="btnExport" class="btn-excel" onclick="usermanagement_excel()">Export to Excel</button>

</div>
           </div>
           <div class="row">
                <div class="col-sm-8"></div>
                <div class="col-sm-4">
                <a href="<?php echo base_url('user-management');?>"><button type="button"  class="btn-excel mt-4 ">Back</button></a>
                </div>

</div>

<div class="grid_div"></div>
      
                    <div id="list2" >
                    
                        
                        <table id="list3" >

</table>
			            <div style="display:none;">

</div>
  
                    </div>
                <div id="pager3"></div>
            </div>
        </div>
    </div>

<div class="modal fade editDisease" >
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
            <div class="modal-header" style="background-color:#439bc1;padding:10px;">
                <h2 class="modal-title" id="exampleModalLabel" style="color:white;font-size:18px;font-weight: 600;">Role</h2>
                <button type="button" class="close" id="clos" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
                </button>
            </div>
          
            </div>
        </div>
    </div>

$("#list3").jqGrid('navGrid','#pager3',
                {edit:false,add:false,del:false,search:true,refresh:true},
                { },
                { },
                { }, 
                {
                sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
                closeOnEscape: true, 
                multipleSearch: true, 
                closeAfterSearch: true }
            );
            $("#start_date, #end_date").datepicker({
                dateFormat: 'yy-mm-dd',
                changeMonth: true,
                changeYear: true,
            });
            $("#apply_filters").click(function() {
                var startDate = $("#start_date").val();
                var endDate = $("#end_date").val();
                $("#list3").jqGrid('setGridParam', {
                    postData: { start_date: startDate, end_date: endDate },
                    page: 1
                }).trigger('reloadGrid');
            });
        });

$("#apply_filters").click(function () {
    fun_excel(); 
});

</script>
     <script type="text/javascript">
        function usermanagement_excel(){
            $(".user_excel").table2excel({
                exclude: ".noExl",
                name: "Excel Document Name",
                filename: "Subscription Payment List",
                fileext: ".xls",
                exclude_img: true,
                exclude_links: true,
                exclude_inputs: true
            });

}
    </script>

<?php
    echo view('includes/admin-footer');    
?>