File: /home/cafsindia/uds.cafsinfotech.in/application/views_bk/loan_report/manage.php
<?php
$this->load->view("partial/header");
$page_name = ucwords(str_replace("_"," ",$controller_name));
$prime_id = "prime_".$controller_name."_id";
/* PAGE TITLE AND BUTTONS- START */
$breadcrumb = "";
if($link_li_line){
$breadcrumb .= "<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>";
}
$breadcrumb .="<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>";
?>
<!-- MODULE TITLE -->
<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>
<!-- FORM CONTENT !!! -->
<?php echo form_open('loan_report',array('id'=>'loan_report'));?>
<div class="form-inline" style="margin-top:20px;">
<div class="row" style='margin-bottom:0px;'>
<div class="col-md-12">
<div class="form-group">
<?php
$report_type = array(""=>"---Select---","1"=>"Loan Entry","2"=>"Loan Balance Report");
echo form_label("Report Type", 'report_type',array('class'=>'required'));
echo form_dropdown(array("name" =>'report_type',"id" =>'report_type',"class" =>'form-control input-sm select2'),$report_type);
?>
</div>
<div class="form-group">
<?php
echo form_label("From Date",'frm_date',array('class'=>'required'));
echo form_input(array('name' => 'frm_date','id'=>'frm_date','class'=>'form-control input-sm datepicker','placeholder'=>'From Date'));
?>
</div>
<div class="form-group">
<?php
echo form_label("To Date",'to_date',array('class'=>'required'));
echo form_input(array('name' => 'to_date','id'=>'to_date','class'=>'form-control input-sm datepicker','placeholder'=>'To Date'));
?>
</div>
<div class="form-group">
<?php
echo form_label("Process Month Till",'process_month',array('class'=>'required'));
echo form_input(array('name' => 'process_month','id'=>'process_month','class'=>'form-control input-sm monthpicker','placeholder'=>'search month'));
?>
</div>
<div class="form-group">
<?php
$search_by_list = array(""=>"---Select---","1"=>"All Employees Master","2"=>"Single Employee");
echo form_label("Search By",'search_by',array('class'=>'required'));
echo form_dropdown(array('name' => 'search_by','id'=>'search_by','class'=>'form-control input-sm select2'),$search_by_list,'');
?>
</div>
<div class="form-group">
<?php
echo form_label("Employee", 'employee_code', array('class' => 'required'));
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" >
<?php
echo form_label("Personal Area", 'personal_code');
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>";
?>
</div>
<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>";
?>
</div>
<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>
<div class="form-group">
<?php
echo form_label("Loan Type", 'loan_type');
echo form_dropdown(array("name" =>'loan_type',"id" =>'loan_type',"class" =>'form-control input-sm select2'),$loan_role,'');
?>
</div>
<div class="form-group">
<button class="btn btn-primary btn-xs" id="submit">submit</button>
</div>
<div style='padding:8px;overflow: auto !important;' id='declaration_info'></div>
</div>
</div>
</div>
<?php echo form_close(); ?>
<style>.dt-buttons{margin-top: 10px !important}</style>
<script type="text/javascript">
$(document).ready(function(){
var search_by = $('#search_by').val();
search_by_hide_show(search_by);
$('#search_by').change(function(){
var search_by = $('#search_by').val();
search_by_hide_show(search_by);
})
var report_type = $("#report_type").val();
report_hide_show(report_type);
$("#report_type").change(function(){
var report_type = $("#report_type").val();
report_hide_show(report_type);
})
select_call();
//DATEPICKER
$(function(){
$(".monthpicker").datetimepicker({
format: 'MM-YYYY'
});
$(".datepicker").datetimepicker({
format: 'DD-MM-YYYY'
});
});
$("#effective_month").datetimepicker({
format: 'MM-YYYY',
});
//FORM SUBMIT
$('#loan_report').submit(function(event){ event.preventDefault(); }).validate({
rules:{
search_by : "required",
employee_code : "required",
report_type : "required",
frm_date : "required",
to_date : "required"
},
submitHandler: function (form){
$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#submit').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 . "/get_table_data"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
$('#submit').attr('disabled',false);
$('#submit').html('Submit');
var response = JSON.parse(data);
if(response.success){
$('#declaration_info').html(response.loan_rslt);
var table = $('#role').DataTable( {
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>',
},
dom: 'Bfrtip',
order:[],
buttons:[{extend: 'collection',text: 'Export',
buttons: [{extend:'excel',
exportOptions: {
columns: ':visible',
orthogonal: null,
format: {
body: function (data, row, column, node) {
var momentDate = moment(data, 'DD-MM-YYYY', true);
if (momentDate.isValid()) {
// to write date field as date formate in excel
return momentDate.format('YYYY-MM-DD');
}else{
return data;
}
}
}
}
},
]}
],
});
$('input[type=search]').addClass('form-control input-sm select2');
$("select[name='table_length']" ).addClass('form-control input-sm');
}else{
toastr.error("No Records Found.!");
}
}
});
}
});
});
//SELECT2
function select_call(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
//HIDE & SHOW ->SEARCH BY!!!
function search_by_hide_show(search_by){
if(parseInt(search_by) === 2){
$('#employee_code').parent().show();
$('#employee_code').val('');
$('#employee_code_div').remove();
$("#personal_code,#project_id,#wbs_element").parent().hide();
}else
if(parseInt(search_by)=== 1){
$('#personal_code,#project_id,#wbs_element').parent().show();
$('#employee_code').parent().hide();
$('#personal_code_div,#project_id_div,#wbs_element_div').val('');
$('#personal_code_div,#project_id_div,#wbs_element_div').remove();
}else{
$('#personal_code,#project_id,#wbs_element,#employee_code').parent().hide();
$("#personal_code,#project_id,#wbs_element,#employee_code").val('');
$("#personal_code_div,#project_id_div,#wbs_element_div,#employee_code_div").remove();
}
}
function report_hide_show(report_type){
if(parseInt(report_type) === 1){
$('#frm_date').parent().show();
$('#to_date').parent().show();
$('#process_month').parent().hide();
}else
if(parseInt(report_type) === 2){
$('#process_month').parent().show();
$('#frm_date').parent().hide();
$('#to_date').parent().hide();
}else{
$('#process_month').parent().hide();
$('#frm_date').parent().hide();
$('#to_date').parent().hide();
$("#process_month,#frm_date,#to_date").val('');
}
}
//EMPLOYEE CODE
var rslt_data = 0;
$(document).on('input','#employee_code',function(){
var id = $(this).attr('id');
var list = $(this).attr('list');
var attr_id = list.replace('list_', '');
var employee_code = $('#employee_code').val();
var wbs_element = $('#wbs_element').val();
var data_text = $('#'+list+' option[value=\"' + employee_code + '\"]').text();
var data_value = $('#'+list+' option[value=\"' + employee_code + '\"]').attr('data-value');
if(employee_code){
var term = $(this).val();
if(term.length < 4){
rslt_data = 0;
}
if(term.length >= 4 && rslt_data === 0){
rslt_data = 1;
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {term:term,pick_list:'employee_code'};
var encData = encrypt(encKey,data);
$.ajax({
url : '<?php echo site_url("$controller_name/get_wbs"); ?>',
type: 'post',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$("#"+list).html('');
if(rslt.success){
$.each(rslt.search_rslt, function(i, value){
$("#"+list).append("<option data-value='"+value.employee_code+"' value='"+$.trim(value.employee_code)+"' >"+$.trim(value.emp_name)+"</option>");
});
}else{
var rslt_data = 0;
}
},
beforeSend: function(){
$("#"+list).attr('disabled','disabled');
$("#span_"+attr_id).remove('');
$("#"+attr_id).parent().append('<span id="span_'+attr_id+'" style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
complete: function() {
$("#"+list).attr('disabled',false);
$("#span_"+attr_id).remove('');
}
})
}
}
});
//Datalist selected value fetch
$(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){
$("#"+attr_id).parent().append('<span id ="'+attr_id+'_div" ><b>'+data_text+'</b> <a style="cursor:pointer" onClick=clear_btn("'+attr_id+'")> Clear </a></span>');
}else{
$('#'+attr_id+'_div').remove();
}
}
})
//project
var rslt_data = 0;
$(document).on('input','#project_id',function(){
var id = $(this).attr('id');
var list = $(this).attr('list');
var attr_id = list.replace('list_', '');
var personal_code = $('#personal_code').val();
var project_id = $('#project_id').val();
var data_text = $('#'+list+' option[value=\"' + project_id + '\"]').text();
var data_value = $('#'+list+' option[value=\"' + project_id + '\"]').attr('data-value');
if(personal_code){
var term = $(this).val();
if(term.length < 4){
rslt_data = 0;
}
if(term.length >= 4 && rslt_data === 0){
rslt_data = 1;
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {term:term,personal_code:personal_code,pick_list:'project'};
var encData = encrypt(encKey,data);
$.ajax({
url : '<?php echo site_url("$controller_name/get_wbs"); ?>',
type: 'get',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$("#"+list).html('');
if(rslt.success){
$.each(rslt.search_rslt, function(i, value){
$("#"+list).append("<option data-value='"+value.pro_id+"' value='"+$.trim(value.pro_id)+"' >"+$.trim(value.pro_desc)+"</option>");
});
}else{
var rslt_data = 0;
}
},
beforeSend: function(){
$("#"+list).attr('disabled','disabled');
$("#span_"+attr_id).remove('');
$("#"+attr_id).parent().append('<span id="span_'+attr_id+'" style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
complete: function() {
$("#"+list).attr('disabled',false);
$("#span_"+attr_id).remove('');
}
})
}
}
});
//WBS
var rslt_data = 0;
$(document).on('input','#wbs_element',function(){
var id = $(this).attr('id');
var list = $(this).attr('list');
var attr_id = list.replace('list_', '');
var personal_code = $('#personal_code').val();
var wbs_element = $('#wbs_element').val();
var data_text = $('#'+list+' option[value=\"' + wbs_element + '\"]').text();
var data_value = $('#'+list+' option[value=\"' + wbs_element + '\"]').attr('data-value');
var term = $(this).val();
if(term.length < 4){
rslt_data = 0;
}
if(term.length >= 4 && rslt_data === 0){
rslt_data = 1;
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {term:term,personal_code:personal_code};
var encData = encrypt(encKey,data);
$.ajax({
url : '<?php echo site_url("$controller_name/get_wbs"); ?>',
type: 'get',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$("#"+list).html('');
if(rslt.success){
$.each(rslt.search_rslt, function(i, value){
$("#"+list).append("<option data-value='"+value.wbs_id+"' value='"+$.trim(value.wbs_id)+"' >"+$.trim(value.wbs_desc)+"</option>");
});
}else{
var rslt_data = 0;
}
},
beforeSend: function(){
$("#"+list).attr('disabled','disabled');
$("#span_"+attr_id).remove('');
$("#"+attr_id).parent().append('<span id="span_'+attr_id+'" style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
complete: function() {
$("#"+list).attr('disabled',false);
$("#span_"+attr_id).remove('');
}
})
}
});
//CLEAR
function clear_btn(attr_id){
$('#'+attr_id+'_div').remove();
$('#'+attr_id).val('');
$('input[name="hid_'+attr_id+'"]').val('');
}
</script>
<?php $this->load->view("partial/footer"); ?>