<ul class="nav nav-tabs" data-tabs="tabs">
	<li class="active" role="presentation">
		<a data-toggle="tab" href="#create_format">Manage Excel Format</a>
	</li>
	<li role="presentation">
		<a data-toggle="tab" href="#excel_mapping">Add Excel Mapping</a>
	</li>
</ul>
<div class="tab-content">
	<div class="tab-pane fade in active" id="create_format">
		<?php echo form_open('utilities_settings/save/' . $prime_module_id,array('id'=>'excel_format_form','class'=>'form-inline')); ?>
			<fieldset id="FundBasicInfo">		
				<?php
					echo form_input( array('name'=>'excel_module_id', 'id'=>'excel_module_id', 'type'=>'Hidden','value'=>$prime_module_id));
					echo form_input( array('name'=>'prime_excel_format_id', 'id'=>'prime_excel_format_id', 'type'=>'Hidden','value'=>0));
				?>
				<div class="form-group">
					<?php
						echo form_label($this->lang->line('excel_name'), 'excel_name', array('class' => 'required'));
						echo form_input(array( 'name' => 'excel_name', 'id' => 'excel_name', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('excel_name'),'value' => ''));
					?>
				</div>
				<div class="form-group">
					<?php
						echo form_label($this->lang->line('excel_table_name'), 'excel_table_name', array('class' => 'required'))."<br/>";
						echo form_dropdown(array('name' => 'excel_table_name[]','multiple id' =>'excel_table_name','class' => 'form-control input-sm select2'), $table_list,$table_mand_list);
					?>
				</div>		
				<div class="form-group">
					<?php
						echo form_label($this->lang->line('excel_column_name'), 'excel_column_name', array('class' => 'required'))."<br/>";
						echo form_dropdown(array('name' => 'excel_column_name[]','multiple id' =>'excel_column_name','class' => 'form-control input-sm select2'), $column_list,$mandatory_list);
					?>
				</div>
				<div class="form-group">
					<?php
						echo form_label($this->lang->line('excel_row_start'), 'excel_row_start', array('class' => 'required'));
						echo form_input(array( 'name' => 'excel_row_start', 'id' => 'excel_row_start', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('excel_row_start'),'value' => '1'));
					?>
				</div>
				<div class="form-group">
					<?php
						echo form_label($this->lang->line('exist_column_name'), 'exist_column_name', array('class' => ''))."<br/>";
						echo form_dropdown(array('name' => 'exist_column_name[]','multiple id' =>'exist_column_name','class' => 'form-control input-sm select2'), $column_list);
					?>
				</div>
				<div class="form-group">
					<button class='btn btn-primary btn-sm' id="excel_format_submit">Add/Update</button>
					<a class='btn btn-danger btn-sm' id="excel_format_cancel">Cancel</a>
				</div>
			</fieldset>
		<?php echo form_close(); ?>
		<div style="padding:15px;" id="excel_view_data">
			<?php 
				echo $excel_content;
			?>
		</div>
	</div>
	<div class="tab-pane fade" id="excel_mapping">
		<?php echo form_open('utilities_settings/format_mapping/' . $prime_module_id,array('id'=>'format_mapping','class'=>'form-inline','style'=>'background-color: #f2f2f2; padding: 8px 0px;')); ?>
				<?php
					echo form_input( array('name'=>'prime_excel_format_line_id', 'id'=>'prime_excel_format_line_id', 'type'=>'Hidden','value'=>0));
				?>
			<div class="form-group">
				<?php
					echo form_label($this->lang->line('excel_format'), 'excel_format', array('class' => 'required'));
					echo form_dropdown(array( 'name' => 'excel_format', 'id' => 'excel_format', 'class' => 'form-control input-sm'), $excel_format_list);
				?>
			</div>
			<div class="form-group">
				<button class='btn btn-primary btn-sm' id="format_mapping_submit" style='margin-top:20px;'>View</button>
			</div>
		<?php echo form_close(); ?>
		
		<?php echo form_open('utilities_settings/save_map/' . $prime_module_id, array('id'=>'save_map','class'=>'form-inline','style'=>'padding: 8px 0px;'));?>
			<!-- LOAD MAPPING FORM FROM CONTROLLER  -->
		<?php echo form_close(); ?>
	</div>
</div>

<script type="text/javascript">
$(document).ready(function(){
	call_select();
		
	/* EXCEL FORMAT FORM VALIDATION - START */	
	$('#excel_format_form').validate($.extend({
		submitHandler: function (form){
			$("#excel_format_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#excel_format_submit').attr('disabled','disabled');
			$(form).ajaxSubmit({
				success: function (response){
					$('#excel_format_submit').attr('disabled',false);
					$("#excel_format_submit").html("Submit");
					if(response.success){
						$('#excel_view_data').html(response.excel_content);
						toastr.success(response.msg);
					}
					$("#excel_name").val("");
					$("#prime_excel_format_id").val(0);
					$('.modal').modal('toggle');
				},
				dataType: 'json'
			});
		},
		rules:{
			excel_name: "required",
			excel_row_start:{
				required: true,
				min:1,
				number:true,
			},
			"excel_table_name[]": "required",
			"excel_column_name[]": "required",
		}
	}));
	
	/* EXCEL FORMAT FORM CANCEL CLEAR  - START */	
	$("#excel_format_cancel").click(function(){
		excel_module_id = $('#excel_module_id').val();
		$.ajax({
			type: "POST",
			url: '<?php echo site_url($controller_name . "/cancel_value"); ?>',
			data: {excel_module_id:excel_module_id},
			success: function(data) {
				var rslt = JSON.parse(data);
				$('#excel_name').val("");
				$('#excel_column_name').val("");
				$('#excel_column_name option:selected').removeAttr('selected');	
				for(i = 0; i < rslt.col_mandatory_list.length; i++) {
					value   = rslt.col_mandatory_list[i];
					$("#excel_column_name").find("option[value='"+value+"']").prop("selected", "selected");
				}
				$('#excel_table_name').val("");
				$('#excel_table_name option:selected').removeAttr('selected');	
				for(i = 0; i < rslt.table_mand_list.length; i++) {
					value   = rslt.table_mand_list[i];
					$("#excel_table_name").find("option[value='"+value+"']").prop("selected", "selected");
				}
				$('#excel_row_start').val(1);
				$('#exist_column_name').val("");
				$('#exist_column_name option:selected').removeAttr('selected');				
				call_select();				
			},
		});
		
	});
	/* EXCEL FORMAT FORM CANCEL CLEAR  - END */
	
	
	/* EXCEL FORMAT FORM VALIDATION - END */
	
	/*FORMAT MAPPING FORM VALIDATE DATA -START*/
	$('#format_mapping').validate($.extend({
		submitHandler: function (form){
			$("#format_mapping_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			$('#format_mapping_submit').attr('disabled','disabled');
			$(form).ajaxSubmit({
				success: function (response){
					$('#format_mapping_submit').attr('disabled',false);
					$("#format_mapping_submit").html("View");
					$("#save_map").html(response.mapping_form_details);
				},
				dataType: 'json'
			});
		},
		rules:{
			excel_format: "required",
		}
	}));	
	/*FORMAT MAPPING FORM VALIDATE DATA - END*/
	
	/*SAVE MAP FORM VALIDATE DATA - START	*/
	$('#save_map').validate({
		submitHandler:function(form) {
			var isValid = true;
			$("select[name='excel_line_value[]']").each(function() {
				if($(this).val() == "" && $(this).val().length < 1) {
					$(this).addClass('error');
					isValid = false;
				} else {
					$(this).removeClass('error');
				}
			});
			if(isValid) {
				$("#save_map_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
				$('#save_map_submit').attr('disabled','disabled');
				$(form).ajaxSubmit({
					success: function (response){						
						$('#save_map_submit').attr('disabled',false);
						$("#save_map_submit").html("Submit");
						if(response.success){
							toastr.success(response.msg);
						}
						$('.modal').modal('toggle');
					},
					dataType: 'json'
				});
			}else{
				toastr.error("Column Mapping Error!");
			}
		}
	}); 	
	/*SAVE MAP FORM VALIDATE DATA - END	*/
});
	

// SELECT2 UI UPDATE
function call_select(){
	$(function(){
		$('.select2').select2();
		$('.select2-tags').select2({
			tags: true,
			tokenSeparators: [',']
		});
		$(".select2_user").select2({
			tags: true
		});
	});
}

/* UPDATE FUNCTION FOR EXCEL FORMAT - START*/
function get_excel_info(prime_excel_format_id){
	if(prime_excel_format_id){
		$.ajax({
			type: "POST",
			url: '<?php echo site_url($controller_name . "/get_excel_info"); ?>',
			data: {prime_excel_format_id:prime_excel_format_id},
			success: function(data) {
				var rslt = JSON.parse(data);
				$("#prime_excel_format_id").val(rslt.excel_info.prime_excel_format_id);
				$("#excel_name").val(rslt.excel_info.excel_name);
				if(rslt.excel_info.table_name){
					$("#excel_table_name").val("");
					$('#excel_table_name option:selected').removeAttr('selected');	
					var excel_table_name = rslt.excel_info.excel_table_name.split(",");
					for(var i in excel_table_name) {
						var excel_table_name_val = excel_table_name[i];
						$("#excel_table_name").find("option[value='"+excel_table_name_val+"']").prop("selected", "selected");
					}
				}
				if(rslt.excel_info.excel_column_name){
					$("#excel_column_name").val("");
					$('#excel_column_name option:selected').removeAttr('selected');	
					var excel_column_name = rslt.excel_info.excel_column_name.split(",");
					for(var i in excel_column_name) {
						var excel_column_name_val = excel_column_name[i];
						$("#excel_column_name").find("option[value='"+excel_column_name_val+"']").prop("selected", "selected");
					}
				}
				$("#excel_row_start").val(rslt.excel_info.excel_row_start);
				if(rslt.excel_info.exist_column_name){
					$("#exist_column_name").val("");
					$('#exist_column_name option:selected').removeAttr('selected');	
					var exist_column_name = rslt.excel_info.exist_column_name.split(",");
					for(var i in exist_column_name) {
						var exist_column_name_val = exist_column_name[i];
						$("#exist_column_name").find("option[value='"+exist_column_name_val+"']").prop("selected", "selected");
					}
				}
				call_select();
			},
		});
	}
}
/* UPDATE FUNCTION FOR EXCEL FORMAT - END*/

/* DELETE FUNCTION FOR EXCEL FORMAT */
function get_delete_info(prime_excel_format_id){
	var excel_module_id = $('#excel_module_id').val();
	if(confirm("Are you sure to delete!")){
		if(prime_excel_format_id){
			$.ajax({
				type: "POST",
				url: '<?php echo site_url($controller_name . "/get_delete_info"); ?>',
				data: {prime_excel_format_id:prime_excel_format_id,excel_module_id:excel_module_id},
				success: function(data) {
					var rslt = JSON.parse(data);
					if(rslt.success){
						$('#excel_view_data').html(rslt.excel_content);
						toastr.success(rslt.msg);
					}
					$("#excel_name").val("");
					$("#prime_excel_format_id").val(0);
				},
			});
		}
	}	
}
/* DELETE FUNCTION FOR EXCEL FORMAT - END*/

/* CHECK CELL VALUES ALREADY EXIT START */
function map_check(sel_val){
	var mapped_vals = $("select[name='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 */
</script>