File: //home/cafsindia/.trash/application.1/views/present_report/manage.php
<?php
$this->load->view("partial/header");
$page_name = ucwords(str_replace("_"," ",$controller_name));
$prime_id = "prime_".$controller_name."_id";
$search_url = site_url($controller_name ."/search");
$view_url = site_url($controller_name ."/view/");
$import_url = site_url($controller_name ."/import/");
$start_date = strtotime(date("Y-m-d"));
$start_date = date("d-m-Y", strtotime("-1 month", $start_date));
$end_date = date('d-m-Y');
?>
<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("$controller_name/present_days/",array("id"=>"present_days","class"=>"form-inline")); ?>
<div class="form-group">
<?php
$select_type = array('' => '--- Select Type ---','1' => 'Summary Report','2'=>'Detailed Report');
echo form_label("Select Category", 'category', array('class' => 'required'));
echo form_dropdown(array('name' => 'category','id' =>'category','class' => 'form-control input-sm select2'), $category_list);
$validation_rule .= "select_category:{required: true },";
?>
</div>
<div class="form-group">
<?php
echo form_label('Attendance Month', 'attendance_month', array('class' => 'required'));
echo form_input(array('name' => 'attendance_month', 'id' => 'attendance_month', 'class' => 'form-control input-sm datepicker', 'value'=>''));
$validation_rule .= "attendance_month:{required: true },";
?>
</div>
<div class="form-group">
<?php
echo form_label('Minimum Count', 'minimum_count', array('class' => 'required'));
echo form_input(array('name' => 'minimum_count', 'id' => 'minimum_count', 'class' => 'form-control input-sm', 'value'=>''));
$validation_rule .= "minimum_count:{required: true },";
?>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="button">View</button>
</div>
<?php echo form_close(); ?>
</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>
<style>
body{
overflow-x: hidden !important;
}
<?php
if($access_search === 1){
echo ".pull-right.search { display: block !important; }";
}
if($access_export === 1){
echo ".columns.columns-right.btn-group.pull-right{display: block !important;}";
}
?>
.dataTables_scrollHeadInner{
width: 100% !important;
}
</style>
<script type="text/javascript">
$(document).ready(function (){
select_call();
$("#attendance_month").datetimepicker({
format: 'MM-YYYY',
});
$('#present_days').validate($.extend({
ignore: ".ignore",
rules:{
<?php echo $validation_rule; ?>
},
submitHandler: function (form){
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var key = '<?php echo $encKey; ?>';
var encData = encrypt(key,jsonData);
$.ajax({
url : $(form).attr('action'),
type : 'POST',
contentType : 'text/plain',
data : encData,
success: function (response){
var result = JSON.parse(response);
if(result.success){
$("#rslt_info").show();
$('#rslt_info').html(result.table_data);
$table = $('#emp_details').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",
// 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='emp_details_length'><table><tr><td id='export' style='padding:8px 2px;'></td></tr></table></div>";
$("#emp_details_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(result.message);
}
},
// dataType: 'json'
});
}
}));
});
function select_call(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
//dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
function get_data(ids,day_start,day_end){
$.ajax({
type: "POST",
url: '<?php echo site_url("$controller_name/get_detailed_report"); ?>',
data:{ids:ids,day_start:day_start,day_end:day_end},
success: function(data) {
var rslt = JSON.parse(data);
$('.modal-body').html(rslt.table_data);
$('.modal').modal({backdrop: 'static', keyboard: false});
$('#detailed_details').DataTable({
processing: true,
lengthMenu: [[10,25,50,100,500,1000,-1],[10,25,50,100,500,1000,"All"]],
// fixedColumns:{leftColumns: 4},
scrollX: true,
dom: 'Blfrtip',
order:true,
buttons: [
{ extend: 'excelHtml5', footer: true },
],
});
$('input[type=search]').addClass('form-control input-sm');
$("select[name='table_length']" ).addClass('form-control input-sm');
$('.dt-button').addClass('btn btn-xs btn-edit');
$('.btn-edit').removeClass('dt-button buttons-excel buttons-html5');
$('.modal-title').html("View Employees");
}
});
}
</script>
<?php $this->load->view("partial/footer"); ?>