File: /home/cafsindia/uds.cafsinfotech.in/application/views/session_audit/manage.php
<?php
$this->load->view("partial/header");
$access_data = $this->session->userdata('access_data');
$access_add = (int)$access_data[$controller_name]['access_add'];
$access_update = (int)$access_data[$controller_name]['access_update'];
$access_delete = (int)$access_data[$controller_name]['access_delete'];
$access_search = (int)$access_data[$controller_name]['access_search'];
$access_export = (int)$access_data[$controller_name]['access_export'];
$access_import = (int)$access_data[$controller_name]['access_import'];
$page_name = ucwords(str_replace("_"," ",$controller_name));
$prime_id = "prime_".$controller_name."_id";
$search_url = site_url($controller_name ."/search");
$view_url = site_url($controller_name ."/view/");
$import_url = site_url($controller_name ."/import/");
?>
<div class='row title_content'>
<div class='col-md-2 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
</div>
<div class='col-md-12' style='margin-top:30px;'>
<div class="form-group col-md-2">
<?php
$form_input = form_input(array("name"=>"emp_hidden", "id"=>"emp_hidden","value"=>'',"placeholder"=>"Search Employee Code","class"=>"form-control input-sm"));
$hidden_input = form_input( array("name"=>"emp_code", "id"=>"emp_code","value"=>"","type"=>"hidden"));
echo $input_box = "<div class='form-group' >$hidden_input $form_input <div class='append_div'></div></div>";
?>
</div>
<div class = "form-group col-md-2">
<button class = 'btn btn-primary btn-sm' id = "download">Download</button>
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
$('#emp_hidden').autocomplete({
minChars:3,
autoFocus: true,
delay:5,
appendTo: '.append_div',
source: function (request, response) {
if(request.term.length >= 4){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {term:request.term};
var encData = encrypt(encKey,data);
$.ajax({
url: '<?php echo site_url("$controller_name/get_employee_list"); ?>',
type: 'post',
data:encData,
contentType: 'text/plain',
success: function (data) {
var rslt = JSON.parse(data);
response($.map(rslt, function (el) {
if(el.value === '0'){
$('#emp_hidden').val('');
}else{
return {
value: el.value,
label: el.label,
display_name:el.display_name,
wbs_network_id:el.wbs_network_id
};
}
}));
}
});
}
},
select: function(e, ui) {
e.preventDefault();
$('#emp_code').val(ui.item.value);
$('#emp_hidden').val(ui.item.display_name);
// $('#emp_hidden').prop('readonly', true);
},
change: function(event, ui) {
if (ui.item === null || ui.item === '' || ui.item === 'null') {
$('#emp_hidden,#emp_code').val('');
}
}
});
//FUNCTION FOR BUTTON ONCLICK SUBMIT
$('#download').on('click',function(){
var emp_code =$('#emp_code').val();
if(emp_code === ""){
toastr.error("Please Select Employee Code");
return false;
}
$("#download").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {emp_code:emp_code};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url("$controller_name/session_data"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
ExportToExcel(rslt.session_data,rslt.message);
$("#download").html("Download");
}else{
toastr.error(rslt.message);
$("#download").html("Download");
}
},
});
})
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
});
//CALLBACK FUCNTION FOR DOWNLOAD EXCEL EXPORT
function ExportToExcel(rslt_arr,callback_success) {
// return false;
//ALLOWANCE OBJECT GET FROM GLOBALLY
let sheet_name = "session_Audit";
try {
//ARRAY OF OBJECT TO EXCEL EXPORT
/* generate worksheet and workbook */
const worksheet = XLSX.utils.json_to_sheet(rslt_arr);
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, sheet_name);
/* fix headers */
// XLSX.utils.sheet_add_aoa(worksheet, [["Name", "Birthday"]], { origin: "A1" });
/* calculate column width */
// const max_width = rows.reduce((w, r) => Math.max(w, r.name.length), 10);
// worksheet["!cols"] = [ { wch: max_width } ];
/* create an XLSX file and try to save to Presidents.xlsx */
XLSX.writeFile(workbook, sheet_name+".xlsx", { compression: true });
//CALLBACK FUNCTION USING FOR SUCCESS MESSAGE THROUGH TO FRONT SIDE
toastr.success(callback_success);
} catch (err) {
}
}
</script>
<?php $this->load->view("partial/footer"); ?>