File: /home/cafsindia/uds.cafsinfotech.in/smart_hrms_dev/application/views/shift_muster_report/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;">
<?php echo form_open('shift_muster_report/shift_emp_data',array('id'=>'shift_muster_report_form')); ?>
<div class="form-group">
<?php
$report_period = array(""=>"---- Select Type ----","1"=>"Month Wise","2"=>"Date Wise");
echo form_label("Report Period Type", 'report_period', array('class' => 'required'));
echo form_dropdown(array("name" =>'report_period',"id" =>'report_period',"class" =>'form-control input-sm select2'),$report_period);
?>
</div>
<div class="form-group" style="display: none;">
<?php
echo form_label("Month Year", 'datepicker', array('class' => 'required'));
echo form_input(array( 'name' => 'datepicker', 'id' => 'month_and_year', 'class' => 'datepicker-field form-control input-sm','placeholder' => 'Month Year"'));
?>
</div>
<div class="form-group" style="display: none;">
<?php
echo form_label("From Date", 'datepicker', array('class' => 'required'));
echo form_input(array( 'name' => 'datepicker', 'id' => 'from_date', 'class' => 'datepicker-field form-control input-sm','placeholder' => 'From Date"'));
?>
</div>
<div class="form-group" style="display: none;">
<?php
echo form_label("To Date", 'datepicker', array('class' => 'required'));
echo form_input(array( 'name' => 'datepicker', 'id' => 'to_date', 'class' => 'datepicker-field form-control input-sm','placeholder' => 'To date'));
?>
</div>
<div class="form-group">
<?php echo form_label("Employee Component", 'emp_component');
echo form_dropdown(array('name' => 'emp_component[]','multiple id' =>'emp_component','class' => 'form-control input-sm select2'), $emp_component_list);
?>
</div>
<div class="form-group">
<label>
<input name='not_allotted' id='not_allotted' type="checkbox"> Shift Not allotted only
</label>
</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 class="col-md-12" style='text-align:left;'>
<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 class="form-group">
<button class='btn btn-primary btn-sm' id="submit" data_form='<?php echo $controller_name ?>'>Submit</button>
</div>
</div>
<?php echo form_close(); ?>
</div>
</div>
<div class='col-md-12' style='margin:10px;padding:10px;' id="table">
</div>
<script type="text/javascript" src="dist/excelexportjs.js"></script>
<script type="text/javascript">
$(document).ready(function (){
$("#month_and_year").datetimepicker({
format: 'MM-YYYY',
});
$("#from_date,#to_date").datetimepicker({
format: 'DD-MM-YYYY',
});
//* SHOW/HIDE TYPE OF SHIFT MUSTER REPORT FOR REPORT PERIOD TYPE*//
var report_period = $("#report_period").val();
menu_type_hide_show(report_period);
$("#report_period").change(function(){
var report_period = $("#report_period").val();
menu_type_hide_show(report_period);
});
<?php echo $document_load_script; ?>
//*--- FILTER FUNCTION ---*//
$('.select2').select2({placeholder: '---- Select ----',});
$("#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('');
$('option').attr('selected', false);
$("#search_filter_div").toggle();
});
$('#shift_muster_report_form').submit(function(event){ event.preventDefault(); }).validate({
rules:{
report_period:"required",
month_and_year:"required",
from_date:"required",
to_date:"required",
},
submitHandler: function (form){
$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#submit').attr('disabled','disabled');
var emp_component = $('#emp_component').val();
var report_period = $('#report_period').val();
var month_and_year = $('#month_and_year').val();
var from_date = $('#from_date').val();
var to_date = $('#to_date').val();
var not_allotted = 0;
if ($('#not_allotted').is(':checked')) {
not_allotted = 1;
}
var send_url = '<?php echo site_url("$controller_name/generate_muster_report");?>';
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();
//Encryption
var key = '<?php echo $key; ?>';
var data = {emp_component:emp_component,report_period:report_period,month_and_year:month_and_year,fliter_label:fliter_label,fliter_type:fliter_type,input_field_type:input_field_type, filter_cond:filter_cond,fliter_val:fliter_val,from_date:from_date,to_date:to_date,not_allotted:not_allotted};
var encData = encrypt(key,data);
$.ajax({
type: 'POST',
url: send_url,
data:encData,
contentType: 'text/plain',
success: function(response){
$('#submit').attr('disabled',false);
$("#submit").html("Submit");
var result = JSON.parse(response);
if(result.success){
$('#table').show();
$('#table').html(result.table_content);
$table = $('#shift_muster_report').DataTable({
processing: true,
lengthMenu: [[10,25,50,100,500,1000,-1],[10,25,50,100,500,1000,"All"]],
// fixedColumns:{leftColumns: 4},
scrollX: true,
scrollY:"360px",
'bSort': false,
// scrollCollapse: true,
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='table'><table><tr><td id='export' style='padding:8px 2px;'></td></tr></table></div>";
$("#table").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(result.message);
}
}
});
}
});
});
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);
}
//* SHOW/HIDE TYPE OF SHIFT MUSTER REPORT FOR REPORT PERIOD TYPE *//
function menu_type_hide_show(report_period){
$("#from_date,#to_date,#month_and_year").parent().hide();
$("#from_date,#to_date,#month_and_year").addClass('error');
if(parseInt(report_period) === 1){
$("#month_and_year").parent().show();
$("#month_and_year").removeClass('error');
}else if (parseInt(report_period) === 2) {
$("#from_date,#to_date").parent().show();
$("#from_date,#to_date").removeClass('error');
}
else{
$("#from_date,#to_date,#month_and_year").parent().hide();
$("#from_date,#to_date,#month_and_year").addClass('error');
$("#from_date").val('');
$("#to_date").val('');
$("#month_and_year").val('');
}
}
//* SHOW/HIDE TYPE OF SHIFT MUSTER REPORT FOR REPORT PERIOD TYPE *//
</script>
<style>
.btn-info{
background: #3a28ac!important;
}
</style>
<?php $this->load->view("partial/footer"); ?>