<?php 
	$this->load->view("partial/header");
	$page_name      = ucwords(str_replace("_"," ",$controller_name));
?>
<fieldset>
<div class="form-inline">
	<!--Employee code -->
	<div class="form-group" >
		<?php
			echo form_label("Employee Code", 'employees', array('class' => 'required'));
			echo form_input(array( 'name' => 'employees', 'id' => 'employees', 'class' => 'form-control form-inline input-sm','value'=>'','placeholder'=>"Search by Employee Code")); 
		?>
		<div class='append_div'></div>
	</div>
	<!--category -->
	<div class="form-group">
		<?php
			echo form_label('Category', 'category', array('class' => 'required'));
			echo form_dropdown(array( 'name' => 'category', 'multiple id' => 'category' , 'class' => 'form-control input-sm select2 '), $category_list);
			echo "<label><input name='category_to_select' id='category_to_select' type='checkbox'> Select All</label>";  
			?>
	</div>
	<!--submit -->
	<div class="form-group">
		<?php
			echo form_button(array('name' => 'submit', 'id' => 'submit', 'class' => 'btn btn-primary btn-xs', 'content' => ' submit'));
		?>
	</div> 
</div>	
</fieldset>
<div class="data">
<div><button class="btn btn-xs" id="btn-export" style="margin:10px;background: #e64c3d;color: white;" onclick="exportTableToExcel('role','service_record')">Export</button></div>
<div style='padding:8px;overflow: auto !important;' id='declaration_info'></div>
</div>

<style> 
#category-header {
    text-align: center;
    text-decoration: underline;
    background: #f2f2f2;
    text-transform: uppercase;
    font-weight: bold;
}
</style>
<script>
$(document).ready(function(){
	$("#btn-export").hide();
	$(function(){
		$('.select2').select2({
			placeholder: '---- Select ----'
		});
		$('.select2-tags').select2({
			tags: true,
			tokenSeparators: [',']
		});
	});
		$("#category_to_select").click(function(){
		if($("#category_to_select").is(':checked') ){
			$("#category > option[value != '']").prop("selected","selected");
			$("#category").trigger("change");
		}else{
			$("#category > option").removeAttr("selected");
			$("#category").trigger("change");
		}
	});
	//Autocomplete Input ->Employee code
	$('#employees').autocomplete({
		source: function(request, response) {				
			$.getJSON('<?php echo site_url("$controller_name/emp_suggest");?>',{term:request.term},response);
		},
		minLength:3,
		autoFocus: true,
		scroll: true,
		appendTo: '.append_div',
		select: function(e, ui) {
			$('#employees').val(ui.item.value);
			return false;
		}
	});	
	$("#submit").on('click', function(e){
		e.preventDefault();
		var employees  = $('#employees').val();
		var category  = $('#category').val();
		if(employees && category){ 
			$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#submit').attr('disabled','disabled');
			$.ajax({
		       type: 'POST',
		       url: '<?php echo site_url("$controller_name/check_service_record");?>',
		       data: {employees:employees,category:category},
			    success: function(data){
			        var rslt = JSON.parse(data);
			        if(rslt.success){
			       		$('#submit').attr('disabled', false);
			            $("#submit").html("Submit");
			            $('#declaration_info').html(rslt.increment);
			            $("#btn-export").show();
			            // exportTableToExcel("role","service_record");
			            var table = $("#role").DataTable();
			        }else{
			            toastr.error(rslt.message);
			            $('#submit').attr('disabled', false);
			            $("#submit").html("Submit");
			        }
			    }
		   });
		}else{
			toastr.error("Please choose required fields.!");
		}
	});
});	
//Table to excel format!!
function exportTableToExcel(tableId, filename){
    var table = document.getElementById(tableId);
	// Create a workbook and worksheet
	var workbook  = XLSX.utils.book_new();
	var worksheet = XLSX.utils.table_to_sheet(table);
	// Add the worksheet to the workbook
	XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
	worksheet["!cols"] = [{ width: 25 },{width:20},{width:15},{width:25}];
	// Convert the workbook to an array buffer
	var excelFile = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
	// Create a Blob from the array buffer
	var file = new Blob([excelFile], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
	// Create a download link and trigger the download
	var link = document.createElement('a');
	link.href     = URL.createObjectURL(file);
	link.download = filename + '.xlsx';
	link.click();
}
</script>
<?php $this->load->view("partial/footer"); ?>