EVOLUTION-NINJA

Edit File: report_demography.php

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

<div class="row pt-5">
        <div class="col-sm-3">
            <label><b>From Date:</b></label>
            <input type="date"   class="form-control from_date"  name="from_date" value="<?php echo session()->get('from_date'); ?>" >
        </div>
        <div class="col-sm-3">
            <label><b>To Date:</b></label>
            <input type="date"   class="form-control to_date"  name="to_date"  value="<?php echo session()->get('to_date'); ?>">
        </div>
        <div class="col-sm-6" style="margin-top: 30px;">
            <button type="button" class="btn btn-primary" >Apply</button>
        </div>
    </div>
    <div class="row mt-4" id="mobile-div">
        <div class="col-sm-8">
            
        </div>
        
        <div class="col-sm-4">   
            <button type="button" id="btnExport" class="btn-excel" onclick="usermanagement_excel()">Export to Excel</button>        
        </div>
    </div>
    <div id="jaytab3" style="margin-top:6%;" >

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

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

</div>

$(document).ready(function(){

var conf_id = $('#conf_id').val();

jQuery("#list3").jqGrid({

url:'<?php echo site_url('demography-data');?>',
            datatype: "json",

colNames:['Doctor id','Weight','Age'],

colModel:[
                {name:'dr_id',index:'dr_id', width:50, editable:false},
                {name:'weight_kg',index:'weight_kg', width:50, editable:false},
                {name:'age',index:'age', width:50, editable:false}
                // {name:'role_id',index:'role_id', width:140, editable:false}
            ],

rowNum:20,
            rowList:[20,30,50,100,200,300],
            rownumbers: true,
            pager: '#pager3', 
            sortname:'id', 
            autowidth: true,
            height: '100%',
            // width: '100%',
            viewrecords: true, 
            loadonce:true,
            gridview: true,
            sortorder:"desc", 
            shrinkToFit: true,
            caption:"Report Analysis",
            
            subGrid: false,

subGridRowExpanded: function(subgrid_id, row_id) {
                var subgrid_table_id;
                swan_id=row_id;

subgrid_table_id = subgrid_id+"_t";
                jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");

jQuery("#"+subgrid_table_id).jqGrid({

url:"<?php echo site_url('show-row-details');?>?id="+swan_id,
                    type : "GET", 
                    datatype: "json", 
                    colNames:['Sl','e-mail','Mobile','City','Country'],
                    colModel:[

{name:'id',index:'id',hidden:true, width:50, editable:false},
                    {name:'email',index:'email', width:150, editable:false},
                    {name:'mobile',index:'mobile', width:120, editable:false},                              
                    
                    {name:'city',index:'city', width:150, editable:false},                              
                    {name:'contry',index:'contry', width:150, editable:false}
                    // {name:'purpose',index:'purpose', width:150, editable:false}

height: 'auto',
                    autowidth: true,
                    shrinkToFit: true,
                    rowNum:20,
                    sortname: 'num',
                    sortorder: "asc",
                    pager:subgrid_table_id,
                    loadonce: true,
                    footerrow: true,
                    userDataOnFooter: true,

});

}

});

$("#list3").jqGrid("setLabel", "rn", "SL");
        $("#list3").jqGrid('filterToolbar',{stringResult: true,searchOperators : true}); //for multisearch code,remove if not required

$("#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 }
        );
    });

function fun_excel(){

$.ajax({
            url:'<?php echo site_url('demography-data');?>',
            type:"GET",
        
            success:function(response) {
                // response = jQuery.parseJSON(response);
                console.log(response[0]);
                $('.user_excel').empty();

var con = '';

con +='<thead><tr><th>Doctor id</th><th>Weight</th><th>Age</th></tr></thead>';
                $.each(response, function( key, value ) {   
                    con += '<tr>';                
                    con += '<td>'+value.dr_id+'</td>';
                    con += '<td>'+value.weight_kg+'</td>';
                    con += '<td>'+value.age+'</td>';
                    con += '</tr>';
                });

$('.user_excel').append(con);   
            }
        }); 
    }

fun_excel();

</script>

function usermanagement_excel(){

$(".user_excel").table2excel({

exclude: ".noExl",
            name: "Excel Document Name",
            filename: "Report Analysis",
            fileext: ".xls",
            exclude_img: true,
            exclude_links: true,
            exclude_inputs: true
        });

}
</script>

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