EVOLUTION-NINJA

Edit File: excel.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-3">
                    <h4 class="user-tag">Spinal Report</h4>
               </div>
             
               
               <div class="col-sm-4">
              
                
                    <button type="button" id="btnExport" class="btn-excel" onclick="usermanagement_excel()">Export to Excel</button>

</div>
           </div>

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

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

$(document).ready(function(){
        //     var pickup_date   = '1';
        //     var sales_person  = '1';
        //     var lastSelection = "";

jQuery("#list3").jqGrid({

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

colNames:['patient_id','lignocaine','lignocaine_per','lignocaine_ml','lignocaine_mg','ropivacaine','ropivacaine_per','ropivacaine_ml','ropivacaine_mg','bupivacaine','bupivacaine_per','bupivacaine_ml','bupivacaine_mg','prilocaine','prilocaine_per','prilocaine_ml','prilocaine_mg','chloroprocaine','chloroprocaine_per','chloroprocaine_ml','chloroprocaine_mg','other','other_name','other_per','other_ml','other_mg'],

colModel:[

{name:'patient_id',index:'id',hidden:false, width:50, editable:false},

{name:'lignocaine',index:'lignocaine',hidden:false, width:50, editable:false},
                    {name:'lignocaine_per',index:'lignocaine_per',hidden:false, width:50, editable:false},
                    {name:'lignocaine_ml',index:'lignocaine_ml',hidden:false, width:50, editable:false},
                    {name:'lignocaine_mg',index:'lignocaine_mg',hidden:false, width:50, editable:false},

{name:'ropivacaine',index:'ropivacaine',hidden:false, width:50, editable:false},
                    {name:'ropivacaine_per',index:'ropivacaine_per',hidden:false, width:50, editable:false},
                    {name:'ropivacaine_ml',index:'ropivacaine_ml',hidden:false, width:50, editable:false},
                    {name:'ropivacaine_mg',index:'ropivacaine_mg',hidden:false, width:50, editable:false},

{name:'bupivacaine',index:'bupivacaine',hidden:false, width:50, editable:false},
                    {name:'bupivacaine_per',index:'bupivacaine_per',hidden:false, width:50, editable:false},
                    {name:'bupivacaine_ml',index:'bupivacaine_ml',hidden:false, width:50, editable:false},
                    {name:'bupivacaine_mg',index:'bupivacaine_mg',hidden:false, width:50, editable:false},

{name:'prilocaine',index:'prilocaine',hidden:false, width:50, editable:false},
                    {name:'prilocaine_per',index:'prilocaine_per',hidden:false, width:50, editable:false},
                    {name:'prilocaine_ml',index:'prilocaine_ml',hidden:false, width:50, editable:false},
                    {name:'prilocaine_mg',index:'prilocaine_mg',hidden:false, width:50, editable:false},

{name:'chloroprocaine',index:'chloroprocaine',hidden:false, width:50, editable:false},
                    {name:'chloroprocaine_per',index:'chloroprocaine_per',hidden:false, width:50, editable:false},
                    {name:'chloroprocaine_ml',index:'chloroprocaine_ml',hidden:false, width:50, editable:false},
                    {name:'chloroprocaine_mg',index:'chloroprocaine_mg',hidden:false, width:50, editable:false},

{name:'other',index:'other',hidden:false, width:50, editable:false},
                    {name:'other_name',index:'other_name',hidden:false, width:50, editable:false},
                    {name:'other_per',index:'other_per',hidden:false, width:50, editable:false},
                    {name:'other_ml',index:'other_ml',hidden:false, width:50, editable:false},
                    {name:'other_mg',index:'other_mg',hidden:false, width:50, 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:"Spinal Report",
                loadComplete: function () {
                  
                    var rows = $("#list3").getDataIDs(); 
                
                    for (var i = 0; i < rows.length; i++){
                        
                        var rowData = $('#list3').jqGrid('getRowData', rows[i]);
                        
                        var enable = $("#list3").getCell(rows[i],"role_id");
                        
                        // alert(enable);
                        if(enable == "1")
                            rowData.role_id = 'Super Admin';
                        else if(enable == "2")
                            rowData.role_id = 'Organisation Admin';
                        else if(enable == "3")
                            rowData.role_id = 'Modular Admin';
                        else if(enable == "4")
                            rowData.role_id = 'Faculty';
                        else if(enable == "0")
                            rowData.role_id = 'Not Define';
                        $('#list3').jqGrid('setRowData', rows[i], rowData);
                        
                        // var booking_open = $("#list3").getCell(rows[i],"booking_open");
                        //  console.log(booking_open);
                    }
                    
                },

});

$("#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('show-spinal-user-data');?>",
                type:"GET",
              
                success:function(response) {
                    // response = jQuery.parseJSON(response);
                    // console.log(response[0]);
                        $('.user_excel').empty();

var con = '';

con +='<thead><tr><th>patient_id</th><th>lignocaine/th><th>lignocaine_per</th><th>lignocaine_ml</th><th>lignocaine_mg</th><th>ropivacaine/th><th>ropivacaine_per</th><th>ropivacaine_ml</th><th>ropivacaine_mg</th><th>bupivacaine/th><th>bupivacaine_per</th><th>bupivacaine_ml</th><th>bupivacaine_mg</th><th>prilocaine/th><th>prilocaine_per</th><th>prilocaine_ml</th><th>prilocaine_mg</th><th>chloroprocaine/th><th>chloroprocaine_per</th><th>chloroprocaine_ml</th><th>chloroprocaine_mg</th><th>other/th><th>other_name/th><th>other_per</th><th>other_ml</th><th>other_mg</th></tr></thead>';
                 $.each( response, function( key, value ) {   
                  con += '<tr>';                
                  con += '<td>'+value.patient_id+'</td>';

con += '<td>'+value.lignocaine+'</td>';
                  con += '<td>'+value.lignocaine_per+'</td>';
                  con += '<td>'+value.lignocaine_ml+'</td>';
                  con += '<td>'+value.lignocaine_mg+'</td>';

con += '<td>'+value.ropivacaine+'</td>';
                  con += '<td>'+value.ropivacaine_per+'</td>';
                  con += '<td>'+value.ropivacaine_ml+'</td>';
                  con += '<td>'+value.ropivacaine_mg+'</td>';

con += '<td>'+value.bupivacaine+'</td>';
                  con += '<td>'+value.bupivacaine_per+'</td>';
                  con += '<td>'+value.bupivacaine_ml+'</td>';
                  con += '<td>'+value.bupivacaine_mg+'</td>';

con += '<td>'+value.prilocaine+'</td>';
                  con += '<td>'+value.prilocaine_per+'</td>';
                  con += '<td>'+value.prilocaine_ml+'</td>';
                  con += '<td>'+value.prilocaine_mg+'</td>';

con += '<td>'+value.chloroprocaine+'</td>';
                  con += '<td>'+value.chloroprocaine_per+'</td>';
                  con += '<td>'+value.chloroprocaine_ml+'</td>';
                  con += '<td>'+value.chloroprocaine_mg+'</td>';

con += '<td>'+value.other+'</td>';
                  con += '<td>'+value.other_name+'</td>';
                  con += '<td>'+value.other_per+'</td>';
                  con += '<td>'+value.other_ml+'</td>';
                  con += '<td>'+value.other_mg+'</td>';
                  
                  
                  con += '</tr>';

});

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

fun_excel();
    </script>

$(".user_excel").table2excel({

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

}
    </script>

<script>
    function validateInput(inputField) {
      var regex = /^[a-zA-Z\s]+$/;
      var inputValue = inputField.value;
      if (!regex.test(inputValue)) {
        inputField.value = inputValue.replace(/[^a-zA-Z\s]/g, '');
		toastr.error('Only alphabetic characters are allowed.');
      }
    }
  </script>

<script>
    function validateInputnum(inputField) {
      var regex = /^[0-9\s]+$/;
      var inputValue = inputField.value;
      if (!regex.test(inputValue)) {
        inputField.value = inputValue.replace(/[^0-9\s]/g, '');
		toastr.error('Only numerical numbers are allowed.');
      }
    }
  </script>

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