File: /home/cafsindia/uds.cafsinfotech.in/application/views_bk/pay_structure_static/import.php
<fieldset id='FundBasicInfo' style='margin:0px;padding:8px;'>
<div class="col-md-3">
<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=''>
<a id="link" style="display: none;" href="#" title='Export All Data'><span class="fa fa-user-exit"> </span> Export Mapping Format </a>
</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;'>
</div>
<script type="text/javascript">
$(document).ready(function (){
$('.modal-dialog').draggable({ handle: ".modal-header" });
// PAGE INFO PROCESS QUERY ERROR THROWING
var module_sts = <?php echo json_encode($module_sts); ?>;
if(!module_sts){
toastr.warning('Index Info Query Process Error...!');
return false;
}
// PAGE INFO PROCESS QUERY ERROR THROWING
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; ?>/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();
if(file_path){
$("#import").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#import').attr('disabled','disabled');
$.ajax({
type: 'POST',
url: send_url,
data:{file_path:file_path},
success: function(data){
var rslt = JSON.parse(data);
$('#import').attr('disabled',false);
$("#import").html("Import");
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,
"aaSorting": [],
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"); ?>