File: /home/cafsindia/hrms_patroniss_com/application/views/process_payroll/manage.php
<?php
$this->load->view("partial/header");
$access_data = $this->session->userdata('access_data');
$access_add = (int)$access_data[$controller_name]['access_add'];
$access_update = (int)$access_data[$controller_name]['access_update'];
$access_delete = (int)$access_data[$controller_name]['access_delete'];
$access_search = (int)$access_data[$controller_name]['access_search'];
$access_export = (int)$access_data[$controller_name]['access_export'];
$access_import = (int)$access_data[$controller_name]['access_import'];
$page_name = ucwords(str_replace("_"," ",$controller_name));
$uniqueId = "prime_".$controller_name."_id";
?>
<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">
<li>
<div class='form-group'>
<a class='btn btn-xs btn-primary' href='<?= site_url() ?>/<?php echo $controller_name; ?>/export_columns'><i class="fa fa-sign-out" aria-hidden="true"></i> Column Export</a>
</div>
</li>
<?php
if($access_import === 1){
$import_url = site_url($controller_name."/import");
$submit = $this->lang->line('common_submit');
echo "<li>
<a class='btn btn-xs btn-primary' data-toggle='modal' data-target='#myModal'
title='Import $page_name'> <span class='fa fa-cloud-upload'> </span> Import $page_name
</a>
</li>";
}
$quick_link = explode(",",$link_info[0]->quicklink);
$link_li_line = "";
foreach($quick_link as $link){
if($link){
$url = site_url("$link");
$name = ucwords(str_replace("_"," ",$link));
$link_li_line .= "<li><a href='$url'> <i class='fa fa-angle-double-right fa-lg' aria-hidden='true'></i> $name</a></li>";
}
}
if($link_li_line){
echo "<li class='dropdown'>
<a class='btn btn-xs btn-primary dropdown-toggle' type='button' id='dropdownMenu2' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
<i class='fa fa-plus-circle' aria-hidden='true'></i> Quick Links
</a>
<ul class='dropdown-menu dropdown-menu-left' aria-labelledby='dropdownMenu2'>
$link_li_line
</ul>
</li>";
}
?>
<li><a href="<?php echo site_url()?>#Home">Home</a></li>
<li><a href="<?php echo site_url($controller_name)?>#<?php echo "$controller_name";?>"><?php echo "$page_name";?></a></li>
<li class="active">Process</li>
</ol>
</div>
</div>
<div id="table_holder">
<div class='col-md-12'style='margin:15px 0px;border-radius:2px;box-shadow:0 2px 2px 0 rgba(0,0,0,0.14),0 3px 1px -2px rgba(0,0,0,0.12),0 1px 5px 0 rgba(0,0,0,0.2);padding:15px 0px;'>
<?php echo form_open("$controller_name/process_payroll/",array("id"=>"process_payroll","class"=>"form-inline")); ?>
<div class="form-group">
<?php
echo form_label("Process Month", 'process_month', array('class' => 'required'));
echo form_input(array('name' => 'process_month','id' => 'process_month','class' => 'form-control input-sm datepicker','value'=>''));
?>
</div>
<div class="form-group">
<?php
$process_type = array(""=>"---- Select Process Type ----","1"=>"Process By Employee","2"=>"Process By Role","3"=>"Process All");
echo form_label("Process Type", 'process_type', array('class' => 'required'));
echo form_dropdown(array("name" =>'process_type',"id" =>'process_type',"class" =>'form-control input-sm'),$process_type);
?>
</div>
<div class="form-group" style='display:none;max-height: 50px;!important'>
<?php
echo form_label("Search Employee", 'process_emp_code', array('class' => 'required'));
echo form_input(array('name' =>'process_emp_code','id' =>'process_emp_code','class' => 'form-control input-sm','value'=>'','placeholder'=>"Search by Employee Code"));
?>
<div class='append_div'></div>
</div>
<div class="form-group" style='display:none;'>
<?php
echo form_label("Process Role", 'process_role', array('class' => 'required'));
echo form_dropdown(array("name" =>'process_role',"id" =>'process_role',"class" =>'form-control input-sm'),$process_role);
?>
</div>
<div class="form-group">
<?php
$process_mode = array(""=>"---- Select Type ----","1"=>"Process Payroll","2"=>"Delete Payroll","3"=>"View 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'),$process_mode);
?>
</div>
<div class="form-group" style='display:inline-grid;'>
<label>
<input name='process_income_tax' id='process_income_tax' type="checkbox"> Process With Income Tax
</label>
<label>
<input name='process_proof_wise' id='process_proof_wise' type="checkbox"> Process Proof Wise
</label>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="process_payroll_btn">Submit</button>
</div>
<?php echo form_close(); ?>
<div style='padding:10px;overflow: auto !important; margin:15px; margin-bottom:0px;' id='rslt_info'>
</div>
</div>
<div class="myProgress" style ="z-index: 10000; text-align: center;display:none;padding:50px;color:#4b6fa2;">
<i class="fa fa-spinner fa-spin fa-2x fa-fw" ></i>Please wait processing....
</div>
<div id="loader" style="display:none;"></div>
</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'), $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'), $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' => '1'));
?>
</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();?>
<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>
<!-- Neha Edit end 09-dec-2019 -->
<script type="text/javascript">
$(document).ready(function (){
$(function(){
$(".datepicker").datetimepicker({
format: 'MM-YYYY',
});
});
$('#process_type').change(function () {
process_type = $("#process_type").val();
$('#process_emp_code,#process_role').parent().hide();
$('#process_emp_code').val("");
$('#process_role').val("");
if(process_type === "1"){
$('#process_emp_code').parent().show();
}else
if(process_type === "2"){
$('#process_role').parent().show();
}else{
$('#process_emp_code,#process_role').parent().hide();
}
});
$('#process_emp_code').autocomplete({
source: function(request, response) {
$.getJSON('<?php echo site_url("$controller_name/emp_suggest");?>',{term:request.term},response);
},
minChars:3,
autoFocus: true,
delay:10,
scroll: true,
appendTo: '.append_div',
select: function(e, ui) {
$('#process_emp_code').val(ui.item.value);
return false;
}
});
$('#process_payroll').validate($.extend({
submitHandler: function (form){
$("#process_payroll_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('.myProgress').show();
$('#process_payroll_btn').attr('disabled','disabled');
$(form).ajaxSubmit({
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({
dom: 'Bfrtip',
fixedColumns:{leftColumns: 2},
scrollX:true,
buttons: [{
extend: 'excelHtml5',
className: 'btn-info',
title: 'Payroll Report_'+ moment(new Date()).format('DD-MM-YYYY'),
}],
language:{
searchPlaceholder: "Search",
search: "",
},
});
}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'
});
},
rules:{
process_month : "required",
process_type : "required",
process_emp_code: "required",
process_role : "required",
process_mode : "required",
}
}));
$('#process_payroll_btn').click(function () {
$("#rslt_info").css("display", "none");
$("#loader").css("display", "block");
});
$('#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("upload_files/upload.php?send_from=$controller_name&send_for=import");?>';
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);
}
});
$('#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');
$(form).ajaxSubmit({
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();
$('.modal').modal('toggle');
}else{
$('#save_import')[0].reset();
if(response.cat_sts){
toastr.error(response.warning);
}else{
toastr.error(response.message);
}
}
},
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; ?>';
if(excel_format){
$('#link').show();
$('#link').attr("href","index.php/<?php echo $controller_name; ?>/excel/"+module_id+"/"+excel_format);
}else{
$('#link').hide();
}
});
/* NEHA EDIT START 07-DEC-2019 */
//PAYROLL PROCESS GET ACTIVITY REMINDER INFO MODAL VIEW
$('#process_payroll_btn').click(function () {
$("#loader").hide();
//$('#active_list_model').modal('toggle');
get_activity_remainder();
});
});
function get_activity_remainder(){
var process_month = $("#process_month").val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_activity_remainder"); ?>',
data: {process_month:process_month},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.sts_count){
$('#active_list_model').modal('show');
$('#activity_rem_info').html(rslt.table_data);
}
},
});
}
//EDIT ACTIVITY REMINDER INFO
function edit_active_info(prime_activity_remainder_id){
if(prime_activity_remainder_id){
var remainder_status = $("#remainder_status_"+prime_activity_remainder_id).val();
}
$.ajax({
type: "POST",
url:'<?php echo site_url($controller_name . "/edit_active_info");?>',
data: {prime_activity_remainder_id:prime_activity_remainder_id,remainder_status:remainder_status},
success: function(rslt){
var result = JSON.parse(rslt);
if(result.success){
toastr.success("updated Successfully");
if(remainder_status === "2"){
get_activity_remainder();
}
//$('#active_list_model').modal('hide');
}else{
toastr.error(result.message);
}
}
});
}
<!-- NEHA EDIT END -->
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);
}
});
}
}
</script>
<style>
#myProgress {
width: 100%;
background-color: #ddd;
}
#myBar {
width: 10%;
height: 30px;
background-color: #4CAF50;
text-align: center;
line-height: 30px;
color: white;
}
</style>
<?php $this->load->view("partial/footer"); ?>