File: /home/cafsindia/hrms_patroniss_com/application/views/audit_log/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/");
/* PAGE TITLE AND BUTTONS- START */
/*$breadcrumb = "";
if($access_add === 1){
$breadcrumb .= "<li>
<a class='btn btn-xs btn-primary add' data-btn-submit='Submit' title='Add $page_name' href='$view_url' data_form='$controller_name'> <span class='fa fa-user-plus'> </span>Add $page_name</a>
</li>";
}
if($access_import === 1){
$breadcrumb .= "<li>
<a class='btn btn-xs btn-primary import' data-btn-submit= 'Submit' title='Import $page_name' href='$import_url' data_form='$controller_name' > <span class='fa fa-cloud-upload'> </span> Import $page_name
</a>
</li>";
}
$quick_link = explode(",",$quick_link->quicklink);
$link_li_line = "";
foreach($quick_link as $link){
if($link){
$url = site_url("$link");
$name = ucwords(str_replace("_"," ",$link));
$link_li_line .= "<li><a href='$url'> <i class='fa fa-angle-double-right fa-lg' aria-hidden='true'></i> $name</a></li>";
}
}
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>";*/
/* PAGE TITLE AND BUTTONS- END */
/* PAGE FILTER - START */
$filter_tr_line = "";
$table_map_list = "";
$input_ids = "";
$date_ids = "";
foreach($fliter_list as $fliter){
$label_id = "filter_".$fliter['label_id'];
$lable = $fliter['label_id'];
$label_name = $fliter['label_name'];
$field_isdefault = (int)$fliter['field_isdefault'];
$array_list = $fliter['array_list'];
$field_type = (int)$fliter['field_type'];
if($field_type === 4){
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"placeholder"=>$label_name, "class"=>"form-control input-sm datepicker"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box </td>
</tr>";
}else
if(((int)$field_type === 5) || ((int)$field_type === 7)){
$filter_box = form_dropdown(array("name" =>$label_id,"multiple id" => $label_id,"class" =>'form-control input-sm select2'),$array_list);
$filter_tr_line .= "<tr>
<td class='search_td'>$label_name</td>
<td>$filter_box</td>
</tr>";
}else
if((int)$field_type === 6){
$form_checkbox = form_checkbox(array("name" => $label_id,"id" => $label_id, "value"=> 1, "checked" => ($input_value) ? 1 : 0));
$filter_box .= "<label class='checkbox-inline'> $form_checkbox $form_label </label>";
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td colspan='2'>$filter_box</td>
</tr>";
}else
if($field_type === 13){
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"placeholder"=>$label_name, "class"=>"form-control input-sm datepicker_time"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box </td>
</tr>";
}else{
if($field_type !== 9){
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"value"=>'',"placeholder"=>$label_name, "class"=>"form-control input-sm"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box </td>
</tr>";
}
}
$table_map_list .= "var $label_id = $('#$label_id').val(); \n data.$lable = $label_id;\n";
if($field_type === 4){
$date_ids .= "#".$label_id.",";
}else{
$input_ids .= "#".$label_id.",";
}
}
$date_ids = rtrim($date_ids,",");
$input_ids = rtrim($input_ids,",");
$filter_table = "<table class='fliter_table'>$filter_tr_line</table>";
/* PAGE FILTER - END */
$column_count = count(array_column($table_head, "label_name"))+1;
?>
<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 id="holder" class="form-inline" style="margin-top:20px;">
<div class="row" style='margin-bottom:0px;'>
<div class="col-md-6">
<div class="form-group">
<?php echo form_label('Choose Date', 'choose_date', array('class' => '')); ?>
<input name="daterangepicker" class="daterangepicker-field form-control input-sm" data-bind='daterangepicker: dateRange, daterangepickerOptions: { maxDate: moment()}'></input>
</div>
<div class="form-group">
<?php
echo form_label('View Type', 'view_type', array('class' => 'required'));
$view_type_array = array(""=>"---- Select View ----",1=>"Form View",2=>"Tab View");
echo form_dropdown(array( 'name' => 'view_type', 'id' => 'view_type', 'class' => 'form-control input-sm'), $view_type_array);
?>
</div>
<div class="form-group" style="display:none;">
<?php
echo form_label('Select Tab', 'tab_list', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'tab_list[]', 'multiple id' => 'tab_list', 'class' => 'form-control input-sm select2'), $tab_list);
echo "<label><input name='tab_list_select' id='tab_list_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<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 echo $filter_table;?>
</div>
<div class="row" style="margin:0px;margin-top:15px;">
<div class="col-md-8" style='text-align:left;'>
<a class="btn btn-xs btn-danger" id="clear_search"> Clear All</a>
</div>
<div class="col-md-4" style='text-align:right;'>
<a class="btn btn-xs btn-primary" id="search_close"> Done </a>
</div>
</div>
</div>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="search">Submit</button>
</div>
</div>
</div>
</div>
<div class="row" style='margin: 0px;overflow:auto;'>
<div class='col-md-12' style='padding:8px;min-height: 400px;' id="rslt_info">
</div>
</div>
<script src="dist/daterangepicker/knockout.js" type="text/javascript"></script>
<link href="dist/daterangepicker/daterangepicker.min.css" rel="stylesheet" type="text/css" />
<script src="dist/daterangepicker/daterangepicker.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function (){
var start_date = "<?php echo date('Y-m-d',strtotime('first day of this month')); ?>";
var end_date = "<?php echo date('Y-m-d',strtotime('last day of this month')); ?>";
$(".daterangepicker-field").daterangepicker({
locale: { inputFormat: 'DD/MM/YYYY' },
forceUpdate: true,
callback: function(startDate, endDate, period){
var title = startDate.format('DD/MM/YYYY') + ' – ' + endDate.format('DD/MM/YYYY');
$(this).val(title);
start_date = startDate.format('YYYY-MM-DD');
end_date = endDate.format('YYYY-MM-DD');
}
});
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
//dropdownParent: $('.modal-dialog')
});
});
$('#view_type').change(function () {
var view_type = $("#view_type").val();
$('#tab_list').parent().hide();
if(view_type === "2"){
$('#tab_list').parent().show();
}else{
$('#tab_list').parent().hide();
}
});
$("#tab_list_select").click(function(){
if($("#tab_list_select").is(':checked') ){
$("#tab_list > option").prop("selected","selected");
$("#tab_list").trigger("change");
}else{
$("#tab_list > option").removeAttr("selected");
$("#tab_list").trigger("change");
}
});
$('#tab_list').change(function(){
var tab_list_count = "<?php echo count($tab_list)?>";
var tab_list = $('#tab_list').val();
if(parseInt(tab_list.length) !== parseInt(tab_list_count)){
$('#tab_list_select').prop('checked', false);
}else{
$('#tab_list_select').prop('checked', true);
}
});
$("#search").on('click', function(e){
var view_type = $('#view_type').val();
var tab_list = $('#tab_list').val();
if(view_type.length === 0){
toastr.error('Please choose View Type?');
return false;
}
if(parseInt(view_type) === 2){
if(tab_list === null){
toastr.error('Please choose Tab?');
return false;
}
}
var user_name = $("#filter_user_name").val();
var emp_name = $("#filter_emp_name").val();
$("#search").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#search').attr('disabled','disabled');
var send_url = '<?php echo site_url("$controller_name/check_audit_log");?>'
if(start_date && end_date){
$.ajax({
type: 'POST',
url: send_url,
data:{start_date:start_date,end_date:end_date,view_type:view_type,tab_list:tab_list,user_name:user_name,emp_name:emp_name},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#rslt_info').show();
$("#rslt_info").html(rslt.table_content);
$('#detail_list').DataTable({
dom: 'Bfrtip',
buttons: [{
extend: 'excelHtml5',
className: 'btn-info',
title: 'Audit Log_'+ moment(new Date()).format('DD-MM-YYYY'),
}],
});
$table = $('#table').DataTable({
lengthMenu: [[10,25,50,100,500,1000,-1],[10,25,50,100,500,1000,"All"]],
language:{
lengthMenu:"<span style='margin-top:8px;margin-left:10px;'>Display</span> _MENU_ <span style='margin-top:8px;'>Records</span>",
searchPlaceholder: "Search records",
search: "",
},
});
var table_option = "<table><tr><td id='filters' style='padding:8px 2px;'></td><td id='export' style='padding:8px 2px;'></td></tr></table>";
$("#table_filter").append(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'));
$(".buttons-collection").addClass("btn btn-xs btn-edit");
$('input[type=search]').addClass('form-control input-sm');
$("select[name='table_length']" ).addClass('form-control input-sm');
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
$('#rslt_info').hide();
}
$('#search').attr('disabled',false);
$("#search").html("Submit");
$('#tab_details').prop('checked', false);
}
});
}
});
$("#search_filter_div").hide();
$("#search_filter").click(function(){
$("#search_filter_div").toggle();
});
$("#search_close").click(function(){
$("#search_filter_div").toggle();
});
$("#clear_search").click(function(){
$('#search_filter_div input').val('');
$('#search_filter_div option').attr('selected', false);
$("#search_filter_div").toggle();
$('#search_filter_div .select2').select2({placeholder: '---- Select ----',});
});
$(function (){$(".datepicker").datetimepicker({format: 'DD-MM-YYYY',});});
$(".datepicker_time").datetimepicker({format: 'DD-MM-YYYY HH:mm:ss',});
$('.select2').select2({placeholder: '---- Select ----',});
});
</script>
<style>
.col-md-6{
width:58% !important;
}
.buttons-excel {
background-color: #3498db !important;
}
.top_order{
margin-top:50px !important;
}
</style>
<?php $this->load->view("partial/footer"); ?>