<?php 
	$this->load->view("partial/header"); 
	$page_name      = ucwords(str_replace("_"," ",$controller_name));
	$prime_id       = "prime_".$controller_name."_id";
	
	/* PAGE TITLE AND BUTTONS- START */
	$quick_link   = explode(",",$quick_link->quicklink);
	$link_li_line = "";
	foreach($quick_link as $link){
		if($link){
			$url  = site_url("$link");
			$name = ucwords(str_replace("_"," ",$link));
			$link_li_line .= "<li><a href='$url'> <i class='fa fa-angle-double-right fa-lg' aria-hidden='true'></i> $name</a></li>";
		}
	}

	$breadcrumb  ="<li><a href='$site_url#Home'>Home</a></li>
					<li><a href='".site_url($controller_name)."#$controller_name'>$page_name</a></li>
					<li class='active'>List</li>";
					
?>
<div class='row title_content'>
	<div class='col-md-4 col-xs-4'>
		<h1 class='page_txt'><?php echo $page_name;?></h1>
	</div>
	<div class='col-md-8 col-xs-8'>
		<ol class="breadcrumb">
			<?php  echo $breadcrumb; ?>	
		</ol>
	</div>
</div>

<div id="toolbar" class="form-inline">
	<div class="col-md-12" id="allowance_summary">
		<div class="form-group">
			<?php
				echo form_label('Allowance Type', 'allowance_type', array('class' => 'required'));
				echo form_dropdown(array( 'name' => 'allowance_type', 'id' => 'allowance_type', 'class' => 'form-control input-sm select2'), $allowance_list);
			?>
		</div>
		<div class="form-group">
			<?php
				echo form_label('Process Month', 'process_month', array('class' => 'required'));
				echo form_input(array('name' => 'process_month', 'id' => 'process_month', 'class' => 'form-control input-sm datepicker', 'placeholder' => 'Search Month', 'value'=> '')); 
			?>
		</div>

		<div class="form-group">
			<button class='btn btn-primary btn-sm' id="submit"> Submit </button>
			<!-- <i class='fa fa-send-o' aria-hidden='true'></i> -->
		</div>
	</div>
</div>

<!-- <div class="row" style='margin:0px;overflow:auto;'>	
	<div class='col-md-12' style='padding:8px;min-height: 400px;'>
		<table id="table" class='table table-striped table-hover' style='width:100% !important;'></table>
	</div>
</div> -->


<script type="text/javascript">
//GLOBAL OBJECT
var allowance_obj    = {};
$(document).ready(function (){	
	$(".datepicker").datetimepicker({
		format: 'MM-YYYY'
	});
	select_call();

	//FROM CONTROLLER
	allowance_obj    = <?php echo json_encode($allowance_list); ?>;

	//FORM SUBMIT ONCLICK PROCESS
	$('#submit').on('click',function(e){
		let allowance_type    = parseInt($('#allowance_type').val());
		let process_month     = $('#process_month').val();

		if(!allowance_type){
			toastr.error("Allowance Type should not Empty.!");
		}else
		if(!process_month){
			toastr.error("Process Month should not Empty.!");
		}else{
			get_allowance_summary(allowance_type,process_month,ExportToExcel);
		}
	});

});

//GET A ALLOWANCE SUMMARY DATA
function get_allowance_summary(allowance_type,process_month,callback){
	//Encryption
	var key     = '<?php echo $key; ?>';
	var data    = {allowance_type:allowance_type,process_month:process_month};
	var encData = encrypt(key,data);
	$.ajax({
		type: "POST",
		url: '<?php echo site_url("$this->control_name/get_allowance_summary");?>',
		data:encData,				
		contentType: 'text/plain',
		beforeSend: function () {
			$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#submit').attr('disabled','disabled');
		},
		success: function(data){
			var rslt = JSON.parse(data);
			if(rslt.success){
				//CALLBACK FUNCTION USED FOR DOWNLOAD A ARRAY DATA TO EXCEL SHEET
				callback(rslt.return_arr,allowance_type,function(message){
					toastr.success(message);
				});
				// toastr.success(rslt.message);
			}else{
				toastr.error(rslt.message);
			}
			$('#submit').attr('disabled',false);
			$("#submit").html("Submit");
		}
	});
}


//CALLBACK FUCNTION FOR DOWNLOAD EXCEL EXPORT
function ExportToExcel(rslt_arr,allowance_type,callback_success) {
	//ALLOWANCE OBJECT GET FROM GLOBALLY
	let sheet_name       =  allowance_obj[allowance_type];
	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
		callback_success("Generated Successfully.!");
	} catch (err) {
		console.log("Error:", err);
	}
}

//COMMON SELECT(PICKLIST) FUNCTION
function select_call(){
	$('.select2').select2({
		placeholder: '---- Select ----',
		allowClear: true,
		// dropdownParent: $('.modal-dialog')
	});
	$('.select2-tags').select2({
		tags: true,
		tokenSeparators: [',']
	});
}
</script>
<?php $this->load->view("partial/footer"); ?>