File: /home/cafsindia/uds.cafsinfotech.in/application/views/process_payroll_fms/manage.php
<?php
$this->load->view("partial/header");
$page_name = ucwords(str_replace("_"," ",$controller_name));
$prime_id = "prime_".$controller_name."_id";
$breadcrumb .= "<li><a class='buttons-collection btn btn-xs btn-edit' data-toggle='modal' data-target='#myModal' title='Import $page_name'> <span class='fa fa-cloud-upload'> </span> Import</a></li><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>";
?>
<style type="text/css">
.form-inline .form-group {
display: inline-block;
vertical-align: middle;
margin-left: 30px;
margin-bottom: 10px;
width: 16.5%;
}
div#table_filter{
display: inline-table !important;
}
div.dt-buttons {
position: relative;
float: right;
}
.display th, .display td {
white-space: nowrap !important;
max-width: 500px !important;
}
table.dataTable tr th:nth-child(1),table.dataTable tr td:nth-child(1){
position: sticky !important;
left: 0px;
width: 0px;
min-width: 0px;
}
table.dataTable tr th:nth-child(2),table.dataTable tr td:nth-child(2){
position: sticky !important;
left: 111px;
width: 80px;
min-width: 80px;
}
table.dataTable tr td:nth-child(1),table.dataTable tr td:nth-child(2) {
background-color: #f2f2f2;
}
</style>
<div class='row title_content'>
<div class='col-md-2 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
<div class='col-md-10 col-xs-8'>
<ol class="breadcrumb">
<?php echo $breadcrumb; ?>
</ol>
</div>
</div>
<div id="toolbar" class="form-inline">
<div class="col-md-12">
<?php echo form_open("$controller_name/process_payroll_fms/",array("id"=>"process_payroll_fms","class"=>"form-inline","autocomplete"=>"off")); ?>
<div class="form-group">
<?php
$process_mode = array("" => "---- Select Type ----","3" => "View Payroll","2" => "Delete Payroll");
echo form_label("Process Mode", 'process_mode', array('class' => 'required'));
echo form_dropdown(array("name" =>'process_mode',"id" =>'process_mode',"class" =>'form-control input-sm select2'),$process_mode);
$validation_rule .= "process_mode:{required: true },";
?>
</div>
<div class="form-group" id="delete_type_div" style="display:none;">
<?php
$delete_type = array("" => "---- Select Delete Type ----","1" => "Transaction","2" => "Cost Centre Employees","3"=>" Left Employees","4"=>"Others");
echo form_label("Delete Type", 'delete_type', array('class' => 'required'));
echo form_dropdown(array("name" =>'delete_type',"id" =>'delete_type',"class" =>'form-control input-sm select2'),$delete_type);
$validation_rule .= "delete_type:{required: true },";
?>
</div>
<!-- PROCESS MONTH -->
<div class="form-group">
<?php
echo form_label('Select Month', 'process_month', array('class' => 'required'));
echo form_input(array('name' => 'process_month', 'id' => 'process_month', 'class' => 'form-control input-sm datepicker','placeholder' => 'Process Month', 'value'=>''));
$validation_rule .= "process_month:{required: true },";
?>
</div>
<!-- PERSONAL AREA -->
<div class="form-group" >
<?php
echo form_label("Personal Area", 'personal_code', array('class' => 'required'));
echo form_input(array('name'=> 'personal_code','id'=>'personal_code','list'=> 'list_personal_code','class'=> 'form-control form-inline input-sm','value'=> '','placeholder' => 'Search Personal Area'));
echo "<datalist id=\"list_personal_code\">" . $per_area_list . "</datalist>";
$validation_rule .= "personal_code:{required: true },";
?>
</div>
<!-- PROJECT -->
<div class="form-group">
<?php
echo form_label("Project", 'project_id');
echo form_input(array('name' => 'project_id', 'id' => 'project_id','list'=>'list_project_id' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search project Id'));
echo "<datalist id=\"list_project_id\"></datalist>";
$validation_rule .= "project_id:{required: true },";
?>
</div>
<!-- WBS ELEMENT -->
<div class="form-group">
<?php
echo form_label("Wbs Element", 'wbs_element');
echo form_input(array('name' => 'wbs_element', 'id' => 'wbs_element','list'=>'list_wbs_element' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search Wbs Element'));
echo "<datalist id=\"list_wbs_element\"></datalist>";
?>
</div>
<!-- EMPLOYEE CODE -->
<div class="form-group">
<?php
echo form_label("Employee", 'employee_code', array('class' => ''));
echo form_input(array('name' => 'employee_code', 'id' => 'employee_code','list'=>'list_employee_code' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search by Employee Code'));
echo "<datalist id=\"list_employee_code\"></datalist>";
?>
</div>
<div class="form-group">
<button class='buttons-collection btn btn-xs btn-edit' id="process_payroll_btn"><span class='fa fa-paper-plane'> </span> Submit</button>
</div>
<?php
echo form_close();
?>
</div>
</fieldset>
</div>
<div style='padding:10px;overflow: auto !important; margin:15px; margin-bottom:0px;' id='rslt_info'></div>
<!-- Modal -->
<div id="myModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Import Process Payroll</h4>
</div>
<div class="modal-body">
<?php echo form_open("$controller_name/save_import/",array("id"=>'save_import',"class"=>"form-inline")); ?>
<fieldset id='FundBasicInfo' style='margin:0px;padding:8px;'>
<div class="form-group">
<?php
echo form_input( array('name'=>'module_id', 'id'=>'module_id', 'type'=>'Hidden','value'=>$module_id));
echo form_label($this->lang->line('mod_excel_format'), 'excel_format', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'excel_format', 'id' => 'excel_format', 'class' => 'form-control input-sm select2'), $excel_format_drop);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('excel_select_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' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel,text/comma-separated-values, text/csv, application/csv' ));
?>
<a id="link" style="display: none;" href="#" title='Export All Data'><span class="fa fa-user-exit"> </span> Export Mapping Format </a>
<input type='hidden' id='excel_file_path' name='excel_file_path' value=''>
<span id='loader' style='color:#CC3366'></span>
</div>
<div class="form-group">
<?php
echo form_label("Excel Sheet Name", 'excel_sheet_name', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'excel_sheet_name', 'id' => 'excel_sheet_name', 'class' => 'form-control input-sm select2'), $excel_sheet_name);
?>
</div>
<div class="form-group">
<?php
echo form_label("Excel Start Row", 'excel_start_row', array('class' => 'required'));
echo form_input(array( 'name' => 'excel_start_row', 'id' => 'excel_start_row', 'class' => 'form-control input-sm number', 'value' => '2'));
?>
</div>
<div class="form-group">
<?php
echo form_label("Excel End Row", 'excel_end_row', array('class' => ''));
echo form_input(array( 'name' => 'excel_end_row', 'id' => 'excel_end_row', 'class' => 'form-control input-sm number', 'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label("Transaction Month", 'transaction_month', array('class' => 'required'));
echo form_input(array('name' => 'transaction_month', 'id' => 'transaction_month', 'class' => 'form-control input-sm datepicker', 'value'=> ''));
?>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="save_import_btn">Submit</button>
</div>
</fieldset>
<?php echo form_close();?>
<div id='imp_table_info' style='padding:8px;overflow: auto;'></div>
<hr class="left"/>
<p style="color:blue;margin-left:10px;">Please map the date format like this (DD-MM-YYYY) only...</p>
</div>
</div>
</div>
</div>
<!-- Neha Edit 07-dec-2019 -->
<div class="modal fade" id="active_list_model" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog modal-lg" style="width: 90%;" role="document">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">Activity Remainder</h4>
</div>
<div class="modal-body" id="activity_rem_info" style="padding:10px;">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
toastr.options.timeOut = 0;
toastr.options.extendedTimeOut = 100;
toastr.options.fadeOut = 100;
select_option();//SELECT2
//DATEPICKER
$(function(){
$(".datepicker").datetimepicker({
format: 'MM-YYYY',
});
});
$("#delete_type").parent().hide();
$("#process_mode").on("change",function(){
clear_input("process_mode");
process_mode = $("#process_mode").val();
if(parseInt(process_mode) === 2){
$("#delete_type").parent().show();
$('#delete_type option').prop('selected', false);
}else{
$("#delete_type").parent().hide();
$('#delete_type option').prop('selected', true);
}
})
$("#delete_type").on("change",function(){
clear_input("delete_type");
})
//ON CHANGE DATALIST WITH CLEAR BTN
$(document).on('change', '#employee_code, #personal_code, #wbs_element, #project_id', function() {
var selected_value = $(this).val();
var list = $(this).attr('list');
var attr_id = list.replace('list_', '');
var data_text = $('#' + list + ' option[value="' + selected_value + '"]').text();
var data_value = $('#' + list + ' option[value="' + selected_value + '"]').attr('data-value');
if(data_value){
$('#' + attr_id).val(data_value);
$('#' + attr_id + '_div').remove();
if(attr_id && data_value){
var words = data_text.split(' ');
var text = '';
for (var i = 0; i < words.length; i++){
if ((text + words[i]).length > 28){
text += '...';
break;
}
text += words[i] + ' ';
}
var datalist_span = '<div class="datalist_name">';
datalist_span += '<span id="' + attr_id + '_div" class="datalist_span">';
datalist_span += '<b style="cursor:pointer;" title="' + data_text + '">' + text + '</b>';
datalist_span += ' <a class="clear-btn-data" style="cursor:pointer;font-size:11px" onClick="clear_btn(\'' + attr_id + '\')"><i class="fa fa-remove" aria-hidden="true"></i></a>';
datalist_span += '</span></div>';
$("#" + attr_id).parent().append(datalist_span);
}
}
})
//ONCHANGE PERSONAL AREA
$('#personal_code').on("change",function(e){
clear_input("personal_code");
let process_mode = $("#process_mode").val();
let delete_type = $("#delete_type").val();
let personal_code = $('#personal_code').val();
let process_month = $('#process_month').val();
if(personal_code && process_month){
project_id_fetch(process_month,personal_code,process_mode,delete_type);
}else{
toastr.error("Please choose required fields.!");
}
});
//ONCHANGE PERSONAL AREA
$('#process_month').on("dp.hide",function(e){
clear_input("process_month");
});
//ONCHANGE PROJECT
$('#project_id').on('change',function(){
clear_input("project_id");
let personal_code = $('#personal_code').val();
let process_month = $('#process_month').val();
let project_id = $('#project_id').val();
let wbs_element = $('#wbs_element').val();
let process_mode = $("#process_mode").val();
let delete_type = $("#delete_type").val();
if(wbs_element !== ''){
$('#wbs_element').val('');
$('#employee_code').val('');
}else{
get_wbs(process_month,personal_code,project_id,process_mode,delete_type);
}
})
//ONCHANGE WBS ELEMENT
$('#wbs_element').on('change',function(){
clear_input("wbs_element");
let personal_code = $('#personal_code').val();
let process_month = $('#process_month').val();
let project_id = $('#project_id').val();
let wbs_element = $('#wbs_element').val();
let process_mode = $("#process_mode").val();
let delete_type = $("#delete_type").val();
get_emp_code(process_month,personal_code,project_id,wbs_element,process_mode,delete_type);
})
//FORM SUBMIT
$('#process_payroll_fms').validate($.extend({
ignore: ".ignore",
rules:{
<?php echo $validation_rule; ?>
},
submitHandler: function (form){
$("#process_payroll_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('.myProgress').show();
$('#process_payroll_btn').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/process_payroll_fms"); ?>',
data:encData,
contentType: 'text/plain',
cache: false,
success: function (response){
$('.myProgress').hide();
$("#loader").css("display", "none");
$('#process_payroll_btn').attr('disabled',false);
$("#process_payroll_btn").html("Submit");
if(response.table_content){
$("#rslt_info").css("display", "block");
$("#rslt_info").html(response.table_content);
$('#detail_list').DataTable({
destroy: true,
ordering: false,
processing: true,
lengthMenu: [[10,25,50,100,500,-1],[10,25,50,100,500,"All"]],
language:{
searchPlaceholder: "Search",
search: "",
},
dom: 'Blfrtip',
scrollX:true,
scrollY:'300px',
buttons: [{
// float:none;
text:'left',
title: 'Payroll Report_'+ moment(new Date()).format('DD-MM-YYYY'),
extend: 'collection',
text: 'Export',
buttons: [
{extend:'excel',exportOptions:{modifier:{order :'index',page: 'All',search:'none'},columns: ':not(:first-child)'}},
]
}],
});
}else{
$("#rslt_info").css("display", "none");
}
$('input[type=search]').addClass('form-control input-sm');
if(response.success){
toastr.success(response.message);
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
}
}));
//IMPORT
$('#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];
var send_url = '<?php echo base_url("$controller_name/import_file");?>';;
if(file_data){
var form_data = new FormData();
form_data.append('excel_select_file', file_data);
// Encryption
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){
$("#loader").html("");
$('#submit').attr('disabled',false);
var rslt = JSON.parse(result_data);
if(rslt['success']){
$('#excel_file_path').val(rslt['path']);
get_excel(rslt['path']);
}else{
toastr.error(rslt['message']);
}
}
});
}else{
toastr.error('Please select file to upload');
$("#loader").html("");
$('#submit').attr('disabled',false);
}
});
$('#save_import').validate($.extend({
submitHandler: function (form){
$("#save_import_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_import_btn').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_import"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#save_import_btn').attr('disabled',false);
$("#save_import_btn").html("Submit");
if(response.success){
toastr.success(response.message);
$('#save_import')[0].reset();
$('#myModal').modal('toggle');
}else{
$('#save_import')[0].reset();
if(response.cat_sts){
toastr.error(response.warning);
$("#imp_table_info").html(response.table_info);
}else{
toastr.error(response.message);
$("#imp_table_info").html(response.table_info);
}
$('#table_details').DataTable({
scrollCollapse: true,
scrollY : '200px',
scrollX : true,
language:{
lengthMenu:"<span style='margin-top:8px;margin-left:10px;'>Display</span> _MENU_ <span style='margin-top:8px;'>Records</span>",
searchPlaceholder: "Search records",
search: "",
processing: '<div style="text-align: center; padding: 50px;color:#4b6fa2;z-index:999999999;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</div>',
},
});
$('input[type=search]').addClass('form-control input-sm select2');
$("select[name='table_length']" ).addClass('form-control input-sm');
}
},
dataType: 'json'
});
},
rules:{
transaction_month: "required",
excel_format: "required",
excel_select_file: "required",
excel_sheet_name: "required",
excel_start_row:{
required: true,
min:1,
number:true,
},
}
}));
$('#excel_format').change(function(){
var module_id = $('#module_id').val();
var excel_format = $('#excel_format').val();
var controller_name = '<?php echo $controller_name; ?>';
var key = '<?php echo $encKey; ?>';
var Payload = encodeURIComponent(window.btoa(encrypt(key,{module_id:module_id,excel_format:excel_format})));
if(excel_format){
$('#link').show();
$('#link').attr("href","index.php/<?php echo $controller_name; ?>/fms_excel/"+Payload);
}else{
$('#link').hide();
}
});
});
function select_option(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
// dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
//CLEAR
function clear_btn(attr_id){
if(attr_id === 'wbs_element'){
$('#network_id').val('');
}
$('#'+attr_id+'_div').remove();
$('#'+attr_id).val('');
$('input[name="hid_'+attr_id+'"]').val('');
clear_input(attr_id);
}
//PROCESS MONTH BASED PERSONAL AREA OR EMPLOYEE CODE GET
function pro_mon_payroll_data(process_month,fetch_input){
$("#"+fetch_input).html('');
//PROCESS BY ALL NOT EMPLOYEE WISE
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {process_month:process_month};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name ."/pro_mon_payroll_data"); ?>',
data:encData,
contentType: 'text/plain',
beforeSend: function () {
$('#'+fetch_input).next('span').attr('id', fetch_input+'_span');
$('#'+fetch_input+'_span').html('<span style=\"color:#CC3366\";><i class=\"fa fa-spinner fa-spin fa-2x fa-fw\"></i><br/>Loading...</span>');
},
success: function(data) {
let rslt = JSON.parse(data);
let option = '<option value>--- Select ---</option>';
$.each(rslt, function(key, value) {
if(fetch_input === 'personal_code'){
if(value.personal_code){
option += '<option value = '+value.personal_code+'>'+value.personal_code+' - '+value.personal_name+'</option>';
}
}
});
$('#'+fetch_input+'_span').empty();
$('#'+fetch_input).html(option);
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
});
},
});
}
//RETRIEVE PROJECT BASED ON PERSONAL AREA AND PROCESS MONTH !
function project_id_fetch(process_month,personal_code,process_mode,delete_type){
$('#project_id,#list_wbs_element,#list_employee_code').html('');
$('#project_id,input[list = "list_wbs_element"],input[list = "list_employee_code"],#wbs_element,#employee_code').val('');
if(process_month && personal_code){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {personal_code:personal_code,process_month:process_month,process_mode:process_mode,delete_type:delete_type};
var encData = encrypt(encKey,data);
$.ajax({
type: 'POST',
url: '<?php echo site_url("$this->control_name/project_id_fetch");?>',
data:encData,
contentType: 'text/plain',
beforeSend: function () {
$('#project_id').parent().append('<span id="span_project_id" style="color:#CC3366"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
success: function(data){
if(data){
$('#span_project_id').remove();
$('#list_project_id').html(data);
}else{
$('#span_project_id').remove();
toastr.error("No Records Found");
$('#project_id,#wbs_element,#employee_code').val('');
}
},
});
}
}
//RETRIEVE WBS ELEMENT BASED ON PROJECT
function get_wbs(process_month,personal_code,project_id,process_mode,delete_type){
//EMPTY INPUTS ADD
$('input[list = "list_wbs_element"],input[list = "list_employee_code"],#wbs_element,#employee_code').val('');
if(process_month && personal_code && project_id){
var send_url = '<?php echo site_url("$controller_name/get_wbs"); ?>';
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {process_month:process_month,personal_code:personal_code,project_id:project_id,process_mode:process_mode,delete_type:delete_type};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: send_url,
data:encData,
contentType: 'text/plain',
beforeSend: function () {
$('#wbs_element').parent().append('<span id="span_wbs_element" style="color:#CC3366"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
success: function(data){
if(data){
$('#span_wbs_element').remove();
$('#list_wbs_element').html(data);
}else{
$('#span_wbs_element').remove();
toastr.error("No Records Found");
$('#wbs_element,#employee_code').val('');
}
}
});
}
}
//RETRIEVE EMPLOYEE CODE BASED ON WBS ELEMENT
function get_emp_code(process_month,personal_code,project_id,wbs_element,process_mode,delete_type){
//EMPTY INPUTS ADD
$('input[list = "list_employee_code"],#employee_code').val('');
// && wbs_element
if(process_month && personal_code && project_id){
var send_url = '<?php echo site_url("$controller_name/get_emp_code"); ?>';
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {process_month:process_month,personal_code:personal_code,project_id:project_id,wbs_element:wbs_element,process_mode:process_mode,delete_type:delete_type};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: send_url,
data:encData,
contentType: 'text/plain',
beforeSend: function () {
$('#employee_code').parent().append('<span id="span_employee_code" style="color:#CC3366"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
success: function(data){
if(data){
$('#span_employee_code').remove();
$('#list_employee_code').html(data);
}else{
$('#employee_code').val('');
}
}
});
}
}
//CLEAR
function clear_input(id){
if(id === "process_mode"){
$("#delete_type,#process_month,#personal_code,#project_id,#wbs_element").val("");
$("#personal_code_div,#project_id_div,#wbs_element_div,#employee_code_div").empty();
}else
if(id === "delete_type"){
$("#process_month,#personal_code,#project_id,#wbs_element").val("");
$("#personal_code_div,#project_id_div,#wbs_element_div,#employee_code_div").empty();
}
else
if(id === "process_month"){
$("#personal_code,#project_id,#wbs_element").val("");
$("#personal_code_div,#project_id_div,#wbs_element_div,#employee_code_div").empty();
}else
if(id === "personal_code"){
$("#project_id,#wbs_element").val("");
$("#project_id_div,#wbs_element_div,#employee_code_div").empty();
}else
if(id === "project_id"){
$("#wbs_element,#employee_code").val("");
$("#wbs_element_div,#employee_code_div").empty();
}else
if(id === "wbs_element"){
$("#employee_code").val("");
$("#employee_code_div").empty();
}
}
function get_excel(file_path){
if(file_path){
// Encryption
var key = '<?php echo $encKey; ?>';
var encData = encrypt(key,{file_path:file_path});
var import_url = '<?php echo site_url("$controller_name/sheet_name");?>'
$.ajax({
type: 'POST',
url: import_url,
contentType : 'text/plain',
data:encData,
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);
}
});
}
}
</script>
<?php $this->load->view("partial/footer"); ?>