<ul class="nav nav-tabs" data-tabs="tabs">
	<li class="active" role="presentation">
		<a data-toggle="tab" href="#template_view">Template Name</a>
	</li>
	<li role="presentation">
		<a data-toggle="tab" href="#template_mapping">Template Mapping</a>
	</li>
</ul>
<div class="tab-content">
	<div class="tab-pane fade in active" id="template_view">
		<?php  echo form_open("$controller_name/save_template/",array("id"=>'save_template',"class"=>"form-inline")); ?>
			<div class="form-group">
				<?php
					echo form_input( array('name'=>'module_id', 'id'=>'module_id', 'type'=>'Hidden','value'=>$prime_module_id));
					echo form_input( array('name'=>'temp_setting_id', 'id'=>'temp_setting_id', 'type'=>'Hidden','value'=>0));
					echo form_label("Template Name", 'template_name', array('class' => 'required'));
					echo form_input(array( 'name' => 'template_name', 'id' => 'template_name', 'class' => 'form-control input-sm'));
				?>
			</div>
			<div class="form-group">
				<button class='btn btn-primary btn-sm' id="template_submit">Add/Update</button>
				<a class='btn btn-danger btn-sm' id="template_cancel">Cancel</a>
			</div>
		<?php echo form_close();?>
		<div style="padding:15px;background-color: #f2f2f2;" id="template_list">
			<?php echo $template_content; ?>
		</div>
	</div>
	<div class="tab-pane fade" id="template_mapping">
	<?php  echo form_open("$controller_name/save_increment_temp/",array("id"=>'save_increment_temp',"class"=>"form-inline")); ?>
		<fieldset id='FundBasicInfo' style='margin:0px;padding:8px;'>
			<div class="form-group">
				<?php
					echo form_label("Template Name", 'temp_name', array('class' => 'required'));
					echo form_dropdown(array( 'name' => 'temp_name', 'id' => 'temp_name', 'class' => 'form-control input-sm'), $temp_name_list);
				?>
			</div>
			<div class="form-group">
				<?php
					echo form_label($this->lang->line('category'), 'category', array('class' => 'required'));
					echo form_dropdown(array( 'name' => 'category', 'id' => 'category', 'class' => 'form-control input-sm'), $category_list);
				?>
			</div>
			<div class="form-group">
				<?php
					echo form_label("Employee Code Column", 'employee_code_column', array('class' => 'required')); 
					echo form_dropdown(array( 'onchange = map_check(this); name' => 'employee_code_column', 'id' => 'excel_line_value[]', 'class' => 'form-control input-sm'), $excel_cell_value);
				?>
			</div>
			<div class="form-group">
				<?php
					echo form_label("Effective Date Column", 'effective_date_column', array('class' => 'required')); 
					echo form_dropdown(array( 'onchange = map_check(this); name' => 'effective_date_column', 'id' => 'excel_line_value[]', 'class' => 'form-control input-sm'), $excel_cell_value);
				?>
			</div>
			<div class="form-group">
				<?php
					echo form_label("Before LOP Days Column", 'before_days_column', array('class' => 'required')); 
					echo form_dropdown(array( 'onchange = map_check(this); name' => 'before_days_column', 'id' => 'excel_line_value[]', 'class' => 'form-control input-sm'), $excel_cell_value);
				?>
			</div>
			<div class="form-group">
				<?php
					echo form_label("After LOP Days Column", 'after_days_column', array('class' => 'required')); 
					echo form_dropdown(array( 'onchange = map_check(this); name' => 'after_days_column', 'id' => 'excel_line_value[]', 'class' => 'form-control input-sm'), $excel_cell_value);
				?>
			</div>
			<div id="save_map" style="padding:15px;background-color: #f2f2f2;"></div>
			<div class="form-group" style="float:right">
				<button class='btn btn-primary btn-sm' id="inc_submit" style='margin-top:20px; '>Submit</button>
			</div>
		</fieldset>
	<?php echo form_close();?>
	<div id='table_info' style='padding:8px;overflow: auto;'>
	</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
	$("#template_cancel").click(function(){
		$("#template_name").val("");
	});
	
	$('#save_template').validate($.extend({
		submitHandler: function (form){
			$("#template_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#template_submit').attr('disabled','disabled');
			
			$(form).ajaxSubmit({
				success: function (response){
					$('#template_submit').attr('disabled',false);
					$("#template_submit").html("Submit");
					if(response.success){
						$("#template_list").html(response.template_content);
						$('.nav-tabs a[href="#template_mapping"]').tab('show');	
						$('#temp_name').html(response.template_format);
					}
					toastr.success(response.msg);
					$("#template_name").val("");					
				},
				dataType: 'json'
			});
		},
		rules:{
			template_name : "required",
		}
	}));
		
	$('#save_increment_temp').validate($.extend({
		submitHandler: function (form){
			$("#inc_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#inc_submit').attr('disabled','disabled');
			$(form).ajaxSubmit({
				success: function (response){
					$('#inc_submit').attr('disabled',false);
					$("#inc_submit").html("Submit");
					if(response.success){
						toastr.success(response.msg);
						$('.modal').modal('hide');
					}else{
						toastr.error(response.msg);
					}					
				},
				dataType: 'json'
			});
		},
		rules:{
			inc_template : "required",
			employee_code_column  : "required",
			effective_date_column : "required",
			before_days_column: "required",
			after_days_column: "required",
			category: "required",
			'excel_line_column_name[]': "required",
		}
	}));
	
	$('#excel_select_file').change(function() {
		$("#loader").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
		$('#submit').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){
					$("#loader").html("");
					$('#submit').attr('disabled',false);
					var rslt = JSON.parse(result_data);
					if(rslt['success']){
						$('#excel_file_path').val(rslt['path']);
						get_excel();
					}else{
						toastr.error(rslt['msg']);
					}
				}
			});
		}else{
			toastr.error('Please select file to upload');
			$("#loader").html("");
			$('#submit').attr('disabled',false);
		}
	});
	
	$('#category').change(function() {
		var temp_name = $('#temp_name').val();
		var category  = $('#category').val();
		$.ajax({
			url: '<?php echo site_url("$controller_name/check_template");?>',
			type: 'post',
			data: {temp_name:temp_name,category:category},
			success: function(data){
				var rslt = JSON.parse(data);
				var column_value = rslt.column_value;
				if(rslt.success){
					toastr.success(rslt.msg);
					$.ajax({
						url: '<?php echo site_url("$controller_name/get_columns_data");?>',
						type: 'post',
						success: function(data){
							$("#save_map").html(data);
						}
					});
					empty_all();
				}else{
					toastr.warning(rslt.msg);
					$("#category").val(rslt.template_list.category);
					category_wise_mapping(column_value);
					$("select[name='employee_code_column']").val(rslt.template_list.employee_code_column);
					$("select[name='effective_date_column']").val(rslt.template_list.effective_date_column);
					$("select[name='before_days_column']").val(rslt.template_list.before_day_column);
					$("select[name='after_days_column']").val(rslt.template_list.after_day_column);
				}
			}
		});
	});
	
	
	$('#apply_month').on("dp.hide",function (e) {
		var apply_month    = $('#apply_month').val();
		if(apply_month){
			$.ajax({
				type: "POST",
				url: '<?php echo site_url($controller_name . "/check_payroll_process"); ?>',
				data: {apply_month:apply_month},
				success: function(data){
					var rslt = JSON.parse(data);	
					if(rslt.success){
						toastr.warning(rslt.message);
						$('#apply_month').val('');
					}	
				},
			});
		}						
	});
	
	$('#temp_name').change(function() {
		$('#category').val("");
		$.ajax({
			url: '<?php echo site_url("$controller_name/get_columns_data");?>',
			type: 'post',
			success: function(data){
				$("#save_map").html(data);
			}
		});
		empty_all();
	});
	
	$('#inc_submit').click(function(){
		var mapped_vals = $("select[id='excel_line_value[]']").map(function(){return $(this).val();}).get();
		var filtered = mapped_vals.filter(function(el) { return el; });
		if(parseInt(filtered.length) < 5){
			toastr.error("Atleast update one increment column");
			return false;
		}else{
			return true;
		}
	});
	
});

//Template empty
function empty_all(){
	// $('#category').val("");
	$("select[name='employee_code_column']").val("");
	$("select[name='effective_date_column']").val("");
	$("select[name='before_days_column']").val("");
	$("select[name='after_days_column']").val("");
	$("#save_map").html("");
}

//dynamic column updates
function category_wise_mapping(column_value){
	$.ajax({
		url: '<?php echo site_url("$controller_name/get_columns_data");?>',
		type: 'post',
		success: function(data){
			console.log(data);
			$("#save_map").html(data);
			for (name in column_value) {
				$("select[name='"+name+"']").val(column_value[name]);
			}
		}
	});
}
	
function get_excel(){
	file_path = $('#excel_file_path').val();
	var import_url = '<?php echo site_url("$controller_name/sheet_name");?>'
	if(file_path){
		$.ajax({
			type: 'POST',
			url: import_url,
			data:{file_path:file_path},
			success: function(data) {
				var rslt = JSON.parse(data);
				var option = "<option value=''>-- Select Sheet Name --</option>";
				for(i = 0; i < rslt.sheet_name.length; i++) {
					sheet_name = rslt.sheet_name[i];
					option += "<option value='"+i+"'>"+sheet_name+"</option>";
				}
				$("#excel_sheet_name").html(option);
			}
		});
	}
}

/* CHECK CELL VALUES ALREADY EXIT START */
function map_check(sel_val){
	var mapped_vals = $("select[id='excel_line_value[]']").map(function(){return $(this).val();}).get();
	var count = 0;
	$.each(mapped_vals,function(i){
		if(sel_val.value === mapped_vals[i]){
			count ++;
		}
	});
	if(count > 1){
		toastr.error("Cell value Already Exist");
		$(sel_val).val('');		
	}
}

/* CHECK CELL VALUES ALREADY EXIT END */
function get_template_edit_info(module_id,temp_setting_id){
	if(module_id && temp_setting_id){
		$.ajax({
			type: "POST",
			url: '<?php echo site_url($controller_name . "/get_template_edit_info"); ?>',
			data: {module_id:module_id,temp_setting_id:temp_setting_id},
			success: function(data) {
				var rslt = JSON.parse(data);
				if(rslt.success){
					$("#temp_setting_id").val(rslt.template_result.prime_inc_temp_setting_id);
					$("#template_name").val(rslt.template_result.template_name);		
				}
			},
		});
	}
}

function get_template_delete_info(temp_setting_id,module_id){
	if(confirm("Are you sure to delete!")){
		if(temp_setting_id){
			$.ajax({
				type: "POST",
				url: '<?php echo site_url($controller_name . "/get_template_delete_info"); ?>',
				data: {temp_setting_id:temp_setting_id,module_id:module_id},
				success: function(data) {
					var rslt = JSON.parse(data);
					$("#template_list").html(rslt.template_content);
				},
			});
		}
	}
}
</script>
<style>
.bootstrap-dialog-footer{
	display: none !important;
}
</style>