File: /home/cafsindia/hrms_cafsinfotech_in/application/views/timelog_data/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));
$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/");
?>
<div class='row title_content'>
<div class='col-md-4 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
</div>
<div id = "holder" class = "form-inline" style = "margin-top:20px;">
<div class = "col-md-12">
<div class = "form-group">
<?php
echo form_label('Timelog Date', 'timelog_date', array('class' => 'required'));
$today = date('m-Y');
echo form_input(array('name' => 'timelog_date', 'id' => 'timelog_date', 'class' => 'form-control input-sm datepicker ', 'value'=>'', 'placeholder' => 'Search Date','required' => 'required'));
?>
</div>
<div class = "form-group">
<button class = 'btn btn-primary btn-sm' id = "search">Download</button>
</div>
</div>
</div>
<!-- table for cron_status table data -->
<div>
<table id="log_table" class = 'table table-hover'>
</table>
</div>
<script>
$(document).ready(function(){
load_data();
$(function () {
$(".datepicker").datetimepicker({
format: 'DD-MM-YYYY'
})
});
var today = moment(new Date(), 'DD-MM-YYYY');
$("#timelog_date").datetimepicker({
format: 'DD-MM-YYYY',
maxDate: moment(today),
}).val('');
$('#search').on('click',function(){
var date = $('#timelog_date').val();
if(date === ""){
toastr.error("Please Choose Date");
}
process(date);
})
})
function load_data(){
var send_url = '<?php echo site_url("$controller_name/load_data");?>'
$.ajax({
type: 'POST',
url : send_url,
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
datatable_function(rslt);
}
}
});
}
function process(date){
if(date){
var send_url = '<?php echo site_url("$controller_name/time_log_entry");?>'
$.ajax({
type: 'POST',
url : send_url,
data:{date:date},
beforesend:$("#search").html("<i class='fa fa-spinner fa-spin'></i> Processing..."),
success: function(data) {
$('#search').attr('disabled',false);
$("#search").html("Submit");
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
load_data();
}else{
toastr.error(rslt.message);
}
}
});
}
}
function datatable_function(rslt){
var result_table = $('#log_table').DataTable({
destroy: true,
lengthMenu: [[25,50,100,500,-1],[25,50,100,500,"All"]],
language:{
searchPlaceholder: "Search records",
search: "",
},
data: rslt.table_data,
columns: [
{ title: "Cron Source", data: "cron_source" },
{ title: "Cron Status", data: "cron_status" },
{ title: "Start Time", data: "start_time" ,
render:function (value){
return moment(value).format('DD/MM/YYYY HH:mm:ss');
}},
{ title: "End Time", data: "end_time" ,
render:function (value){
return moment(value).format('DD/MM/YYYY HH:mm:ss');
}},
{ title: "Processed Count", data: "count" },
{ title: "Updated Date", data: "updated_date",
render:function (value){
return moment(value).format('DD/MM/YYYY HH:mm:ss');
} },
{ title: "Process Date", data: "process_date",
render:function (value){
if (value === '' || value === '0000-00-00' || value === null || value === '1970-01-01') return '';
return moment(value).format('DD/MM/YYYY');
}
},
{ title:'Option',
data: "process_date",
type: 'html',
orderable: false,
searchable:false,
width:'1%',
render: function ( data, type, row, meta ) {
if(meta.row === 0){
return '<button class="btn btn-primary btn-xs" onclick=process("'+data+'")><i class="fa fa-refresh" aria-hidden="true"></i> Reprocess</button>';
}else{
return '';
}
}
}
],
dom: 'Blfrtip',
buttons: [{
// float:none;
text:'right',
extend: 'collection',
text: 'Export',
buttons: [
{extend:'excel',exportOptions:{modifier:{order :'index',page: 'all',search:'none'},columns:':visible'}},
]
}],
});
$(".dataTables_filter input[type = 'search']").addClass('form-control');
}
</script>
<?php $this->load->view("partial/footer"); ?>