File: /home/cafsindia/hrms_cafsinfotech_in/application/views/attn_summary/manage.php
<?php
$this->load->view("partial/header");
$page_name = ucwords(str_replace("_"," ",$controller_name));
?>
<div class='row title_content'>
<div class='col-md-2 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
</div>
<div class="form-inline" style="margin-top:20px;">
<div class="col-md-12" style="margin-bottom:15px;">
<div class="form-group">
<?php
echo form_label("Date Range", 'datepicker', array('class' => 'required'));
echo form_input(array( 'name' => 'datepicker', 'id' => 'entry_date', 'class' => 'datepicker-field form-control input-sm','placeholder' => 'select date'));
?>
</div>
<div class="form-group" style="margin-top: 25px;">
<button class='btn btn-primary btn-sm' id="log_search">View</button>
<!-- </div> -->
<div class="form-group" id = "filter_comp">
<a class="btn btn-sm btn-edit" id="search_filter">
<i class="fa fa-filter" aria-hidden="true"></i> Search filter
<span class="caret"></span>
</a>
<div id="search_filter_div" class='search_filter'>
<div style="max-height:250px;overflow: auto;">
<?php
$filter_cond_array = array('' => '--- Select ---','=' => '=','>' => '>','<' => '<','LIKE' => 'LIKE');
$tr_line = "";
foreach($fliter_list as $fliter){
$label_id = $fliter['label_id'];
$field_isdefault = $fliter['field_isdefault'];
$array_list = $fliter['array_list'];
$field_type = $fliter['field_type'];
$label_name = ucwords(strtolower(str_replace("_"," ",$label_id)));
$fliter_label = form_input(array('type'=>'hidden','name' => 'fliter_label[]', 'class' => 'form-control input-sm','value' => $label_id));
$fliter_type = form_input(array('type'=>'hidden','name' => 'fliter_type[]', 'class' => 'form-control input-sm','value' => $field_isdefault));
$filter_cond = form_dropdown(array('name' => 'filter_cond[]','class' => 'form-control input-sm'), $filter_cond_array);
if($field_type === 4){
$fliter_val = form_input(array( 'name' => 'fliter_val[]', 'class' => 'form-control input-sm datepicker', 'placeholder'=>'Search value','value' => ''));
}else
if(((int)$field_type === 5) || ((int)$field_type === 7)){
$fliter_val = form_dropdown(array('name' => 'fliter_val[]','class' => 'form-control input-sm'), $array_list);
}else{
$fliter_val = form_input(array( 'name' => 'fliter_val[]', 'class' => 'form-control input-sm', 'placeholder'=>'Search value','value' => ''));
}
$tr_line .= "<tr>
<td class='search_td'> $label_name $fliter_label $fliter_type</td>
<td> $filter_cond</td>
<td> $fliter_val </td>
</tr>";
}
echo "<table style='width:100%;'>$tr_line</table>";
?>
</div>
<div style="margin-top:8px;">
<div class="row">
<div class="col-md-6" style='text-align:left;'>
<a class="btn btn-xs btn-danger" id="clear_search"> Clear / Close</a>
</div>
<div class="col-md-6" style='text-align:right;'>
<a class="btn btn-xs btn-primary" id="search_submit"> Done </a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row" style='margin: 0px;'>
<div class='col-md-12' style='margin:10px;padding:8px;min-height: 400px;' id="rslt_info">
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
$("#entry_date").datetimepicker({
format: 'DD-MM-YYYY',
});
$("#search_submit").click(function(){
$("#search_filter_div").toggle()
});
$("#search_filter_div").hide();
$("#search_filter").click(function(){
$("#search_filter_div").toggle();
});
$("#clear_search").click(function(){
$('#search_filter_div').find('input').val('');
$('.select2 option').prop('selected', false);
$("#search_filter_div").toggle();
});
$("#log_search").on('click', function(e){
e.preventDefault();
var entry_date = $('#entry_date').val();
if(entry_date.length === 0){
toastr.error('Please choose date?');
return false;
}
$("#log_search").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#log_search').attr('disabled','disabled');
var send_url = '<?php echo site_url("$controller_name/check_attn_details");?>';
var fliter_label = $("input[name='fliter_label[]']").map(function(){return $(this).val();}).get();
var fliter_type = $("input[name='fliter_type[]']").map(function(){return $(this).val();}).get();
var input_field_type = $("input[name='input_field_type[]']").map(function(){return $(this).val();}).get();
var filter_cond = $("select[name='filter_cond[]']").map(function(){return $(this).val();}).get();
var fliter_val = $("input[name='fliter_val[]'],select[name='fliter_val[]']").map(function(){return $(this).val();}).get();
// var group_by = $("select[name='group_by[]']").map(function(){return $(this).val();}).get();
var key = '<?php echo $key; ?>';
var data = {entry_date:entry_date,fliter_label:fliter_label,fliter_type:fliter_type,input_field_type:input_field_type,filter_cond:filter_cond,fliter_val:fliter_val};
var encData = encrypt(key,data);
$.ajax({
type: 'POST',
url: send_url,
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#rslt_info').show();
$("#rslt_info").html(rslt.table_content);
$table = $('#attn_report').DataTable({
dom: 'Bfrtip',
"scrollX": true,
scrollY:"360px",
buttons: [{
extend: 'excelHtml5',
className: 'btn-info',
title: 'Attendance Report',
}],
language:{
lengthMenu:"<span style='margin-top:12px;margin-left:10px;'>Display</span> _MENU_ <span style='margin-top:12px;'>Records</span>",
searchPlaceholder: "Search records",
search: "",
},
});
var table_option = "<div class='dataTables_length' id='muster_report_length'><table><tr><td id='export' style='padding:8px 2px;'></td></tr></table></div>";
$("#muster_report_wrapper").prepend(table_option);
var buttons = new $.fn.dataTable.Buttons($table, {
buttons: [{
extend: 'collection',
text: 'Export',
buttons: [
{extend:'copy',exportOptions:{modifier :{order:'index',page:'all',search:'none'},columns:':visible'}},
{extend:'csv',exportOptions:{modifier:{order:'index',page:'all',search:'none'},columns:':visible'}},
{extend:'excel',exportOptions:{modifier:{order :'index',page: 'all',search:'none'},columns:':visible'}},
{extend:'pdf',exportOptions:{modifier:{order :'index',page:'all',search:'none'},columns:':visible'}},
{extend:'print',exportOptions:{modifier:{order :'index',page:'all',search:'none'},columns:':visible',}},
]
}]
}).container().appendTo($('#export'));
$('input[type=search]').addClass('form-control input-sm');
$("select[name='table_length']" ).addClass('form-control input-sm');
}else{
toastr.error(rslt.message);
$('#rslt_info').hide();
}
$('#log_search').attr('disabled',false);
$("#log_search").html("Search");
}
});
});
});
select_call();
function select_call(){
setTimeout(function(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog'),
maximumInputLength : 15
});
$('.select2-tags').select2({
tags: true,
allowClear: true,
tokenSeparators: [',']
});
});
}, 500);
}
</script>
<style>
.btn-info{
background: #3a28ac!important;
}
</style>
<?php $this->load->view("partial/footer"); ?>