File: /home/cafsindia/uds.cafsinfotech.in/application/views/pay_structure/import.php
<fieldset id='FundBasicInfo' style='margin:0px;padding:8px;'>
<!-- <div class="import_excel_div"> -->
<div class="col-md-3">
<div class="form-group" id = 'form_div'>
<?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=''>
<a id="link" href="#" title='Export All Data'><span class="fa fa-user-exit"> </span> Export Mapping Format </a>
<!-- style="display: none;" -->
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<?php
$import_mode = array(1 => "Upload");
/*,2 => "Procedure"*/
echo form_label('Mode', 'mode', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'mode', 'id' => 'mode', 'class' => 'form-control input-sm'),$import_mode,1);
?>
</div>
</div>
<div class="col-md-3">
<div class="form-group" style="margin-top: 24px;">
<button class='btn btn-primary btn-sm' id="import">Import</button>
</div>
</div>
</fieldset>
<div id='imp_table_info' style='padding:8px;overflow: auto;max-height:450px;'>
</div>
<!-- </div> -->
<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 base_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 fileName = file_data.name;
var size = file_data.size;
var key = '<?php echo $encKey; ?>';
var encData = encrypt(key,{send_from:'<?php echo $controller_name; ?>',send_for:'import',fileName:fileName,size:size});
var form_data = new FormData();
form_data.append('excel_select_file', file_data);
form_data.append('Payload', encData);
$.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);
$('#search').attr('disabled',false);
$("#search").html("Process");
if(rslt['success']){
$('#excel_file_path').val(rslt['path']);
}else{
toastr.error(rslt['msg']);
}
}
});
}else{
toastr.error('Please select file to upload');
$("#loader").html("");
$('#submit').attr('disabled',false);
}
});
//CODE DEFAULT HEADER CREATE EXCEL EXPORT FUNCTION
$('#link').show();
$('#link').attr("href","index.php/<?php echo $controller_name; ?>/pay_excel");
$("#import").on('click', function(e){
var send_url = '<?php echo site_url("$controller_name/excel_file_import");?>'
var file_path = $('#excel_file_path').val();
var mode = $('#mode').val();
if(!mode){
toastr.error('Mode should not Empty.!');
return false;
}
if(file_path){
if(mode === "2"){
var send_url = '<?php echo site_url("$controller_name/sp_excel_file_import");?>'
}
$("#import").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#import').attr('disabled','disabled');
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {file_path:file_path};
var encData = encrypt(encKey,data);
$.ajax({
type: 'POST',
url: send_url,
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$('#import').attr('disabled',false);
$("#import").html("Import");
var table_append = true;
if(rslt.success){
toastr.success(rslt.message);
// $("#form_div").trigger("reset");
// $("#imp_table_info").html();
// $('.modal').modal('toggle');
// window.location.reload();
if(mode === "1"){
table_append = false;
}
}else{
toastr.error(rslt.message);
}
$('#excel_select_file').val("");
$("#imp_table_info").html(rslt.table_info);
//DATATABLE CALL
if(table_append){
var table = $('#table_details').DataTable( {
destroy: true,
paging : false,
scrollX: 500,
scrollY: 400,
// "aaSorting": [],
"order": [],
language:{
searchPlaceholder: "Search records",
search: "",
},
dom: 'Bfrtip',
buttons: [
'excelHtml5',
]
});
//for table search box
$('input[type=search]').addClass('form-control input-sm');
$("select[name='table_details_length']" ).addClass('form-control input-sm');
}
}
});
$('.select2').select2({placeholder: '---- Select ----',});
}else{
toastr.error('Please Choose Valid Excel File..!');
return false;
}
});
// select_call();
});
//DATATABLE CALL FUNCTION
/*function data_table_fun(table_info){
var table = $('#table_details').DataTable( {
destroy: true,
paging : false,
scrollX: false,
scrollY: 400,
"aaSorting": [],
language:{
searchPlaceholder: "Search records",
search: "",
},
// dom: 'Bfrtip',
// buttons: [
// 'excelHtml5',
// 'pdfHtml5'
// ]
});
//for table search box
$('input[type=search]').addClass('form-control input-sm');
}*/
function select_call(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
// dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
</script>
<style>
.dataTables_length > label{
display: inline-flex !important;
}
</style>