<?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/");
	
	/* PAGE TITLE AND BUTTONS- START */
	$breadcrumb = "";
	$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>";
		}
	}
	if($link_li_line){
		$breadcrumb .= "<li class='dropdown'>
							<a class='btn btn-xs btn-primary dropdown-toggle' type='button' id='dropdownMenu2' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
								<i class='fa fa-plus-circle' aria-hidden='true'></i> Quick Links
							</a>
							<ul class='dropdown-menu dropdown-menu-left' aria-labelledby='dropdownMenu2'>
								$link_li_line
							</ul>
						</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>";
					
	
	/* PAGE TITLE AND BUTTONS- END */
?>
<div class='row title_content'>
	<div class='col-md-12'>
		<h1 class='page_txt'><?php echo $page_name;?></h1>
	</div>
	<div class="form-inline" style="margin-top:20px;">
		<div class='col-md-12'>
		<div class="form-group">
				<?php
					$fie_type   = array("" => '---Select Type---',"1" => "Input Import","2" => "Formula Import");
					echo form_label('Import Type', 'import_type', array('class' => 'required'));
					echo form_dropdown(array('name' => 'import_type','id' => 'import_type','class' => 'form-control input-sm select2'),$fie_type,1);
				?>
			</div>
			<div class="form-group">
				<?php
					echo form_label('Choose File', 'excel_select_file', array('class' => 'required'));
					echo form_upload(array('name' => 'excel_select_file','id' => 'excel_select_file','class' => 'form-control input-sm','value' => '','accept' => '.xls,.xlsx' ));
				?>
				<input type='hidden' id='excel_file_path' name='excel_file_path' value=''>
			</div>
			<div class="form-group">
				<button class='btn btn-primary btn-sm' id="search">Process</button>
			</div>
		</div>
	</div>
</div>

<div id='imp_table_info' style='padding:8px;overflow: auto;'>
	<table id="import_table" width="100%" class='table table-hover'></table>
</div>

<!-- <script src = "https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script> -->
<script type="text/javascript" src="dist/excel_xlsx.full.min.js"></script>
<script type="text/javascript">
$(document).ready(function (){	
	$('.modal-dialog').draggable({ handle: ".modal-header" });	
	select_call();
	$('#excel_select_file').change(function() {
		var send_url = '<?php echo site_url("$controller_name/import_file");?>';
		$("#search").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
		$('#search').attr('disabled','disabled');		
		var file_data = $('#excel_select_file').prop('files')[0];
		if(file_data){
			var form_data = new FormData();
			form_data.append('excel_select_file', file_data);
			$.ajax({
				url: send_url,
				cache: false,
				contentType: false,
				processData: false,
				data: form_data,
				type: 'post',
				success: function(result_data){
					var rslt = JSON.parse(result_data);
					// console.log()
					$('#search').attr('disabled',false);
					$("#search").html("Process");
					if(rslt['success']){
						$('#excel_file_path').val(rslt['path']);
						// console.log($('#excel_file_path').val())
					}else{
						toastr.error(rslt['msg']);
					}
				}
			});
		}else{
			toastr.error('Please select file to upload');
			$("#loader").html("");
			$('#submit').attr('disabled',false);
		}
	});
	$("#search").on('click', function(e){
		var send_url     = '<?php echo site_url("$controller_name/excel_file_import");?>'
		var import_type  = $('#import_type').val();
		var file_path    = $('#excel_file_path').val();
		if(import_type && file_path){
			$("#search").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#search').attr('disabled','disabled');		
			$.ajax({
				type: 'POST',
				url: send_url,
				data:{import_type:import_type,file_path:file_path},
				success: function(data){
					var rslt = JSON.parse(data);
					$('#search').attr('disabled',false);
					$("#search").html("Process");
					if(rslt.success){
						toastr.success(rslt.message);
					}else{
						toastr.error(rslt.message);
					}
					$('#excel_select_file').val("");
					// $("#imp_table_info").html(rslt.table_info);
					// $("#import_table").DataTable({});
					var table = $('#import_table').DataTable( {
						destroy: true,
						paging :false,
						language:{				                    
							searchPlaceholder: "Search records",
							search: "",
						},
						data: rslt.table_info,
						columns: [
							{ title: "Excel Row",data: "Excel Row" },
							{ title: "Status",data: "Status" },
						],
						// dom: 'Bfrtip',
						// buttons: [
						// 	'excelHtml5',
						// 	'pdfHtml5'
						// ]
					});
					//for table search box
					$('input[type=search]').addClass('form-control input-sm');
				}
			});
			$('.select2').select2({placeholder: '---- Select ----',});
		}else{
			toastr.error('Please Choose Valid Excel File..!');
			return false;
		}
	});
	// select_call();
});
function select_call(){
	$(function(){
		$('.select2').select2({
			placeholder: '---- Select ----',
			allowClear: true,
			// dropdownParent: $('.modal-dialog')
		});
		$('.select2-tags').select2({
			tags: true,
			tokenSeparators: [',']
		});
	});
}
</script>
<?php $this->load->view("partial/footer"); ?>