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> <!-- The Modal --> </div> </div> <div id="jaytab3" style="margin-top:6%;" > <div class="grid_div"></div> <div id="list2"> <table id="list3"> </table> <div style="display:none;"> <table border="1" style="border-spacing: 0px !important;" id="user_excel" class="user_excel"></table> </div> </div> <div id="pager3"></div> </div> </div> </div><!--col-10--> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc.--> <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid-bootstrap.css'); ?>" /> <script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.table2excel.js'); ?>"></script> <script src="<?php echo base_url('public/assets/js/jquery.table2excel.js');?>"></script> <script> $(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> <script> </script> <script type="text/javascript"> function usermanagement_excel(){ $(".user_excel").table2excel({ exclude: ".noExl", name: "Excel Document Name", filename: "Spinal Report", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } </script> <!-- only for alphabetics and space --> <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> <!-- only for numbers and space--> <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> <style> .ui-jqgrid-sdiv{ display : none !important; } .ui-jqgrid-titlebar { background-color:#0065A3; } .ui-jqgrid-title{ color:#fff; font-weight: 600; font-size: 18px; } .user-tag{ color: #0065A3; font-weight: 600; font-size: 24px; } .soptclass{ display : none; } @media only screen and (max-width:600px){ #mobile-div{ padding: 20px; } .u_e{ margin-bottom:5px; } .u_s{ margin-bottom:5px; } } </style> <?php echo view('includes/admin-footer'); ?>