File: /home/cafsindia/ntc_cafsinfotech_in_bk/application/views/trip_exception/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-3 col-xs-3'>
<h1 class='page_txt'>Trip Report</h1>
</div>
</div>
<div id="holder" class="form-inline" style="margin-top:20px;">
<div class="row" style='margin-bottom:0px;'>
<div class="col-md-12">
<form id = "frm">
<div class="form-group">
<?php
echo form_label('From Date', 'from_date', array('class' => 'required'));
echo form_input(array('name' => 'from_date', 'id' => 'from_date', 'class' => 'form-control input-sm datepicker', 'value'=> ''));
?>
</div>
<div class="form-group">
<?php
echo form_label('To Date', 'to_date', array('class' => 'required'));
echo form_input(array('name' => 'to_date', 'id' => 'to_date', 'class' => 'form-control input-sm datepicker', 'value'=> ''));
?>
</div>
<div class="form-group">
<?php
echo form_multiselect('cw_ntc_load[]', $load_customer_type, '', array('id' => 'cw_ntc_load', 'class' => 'selectpicker show-menu-arrow', 'data-none-selected-text' => '--Search by load customer type--', 'data-selected-text-format' => 'count > 1', 'data-style' => 'btn-default btn-sm', 'data-width' => 'fit'));
?>
</div>
<button class='btn btn-primary btn-sm' id="search">Search</button>
</form>
</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 (){
<?php $this->load->view('partial/bootstrap_tables_locale'); ?>
$(function () {
$(".datepicker").datetimepicker({
format: "DD-MM-YYYY"
//debug: true
});
});
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
//dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
$("#search").click(function(e){
e.preventDefault();
var load_customer_type = $("#cw_ntc_load").val() || [""];
var from_date = $("#from_date").val();
var to_date = $("#to_date").val();
if(from_date === ''){
toastr.error('Please choose From date');
}
if(to_date === ''){
toastr.error('Please choose To date');
}
if(from_date && to_date){
$("#search").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#search').attr('disabled','disabled');
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_report"); ?>',
data: {from_date:from_date,to_date:to_date,load_customer_type:load_customer_type},
success: function(data){
$('#search').attr('disabled',false);
$("#search").html("Submit");
var rslt = JSON.parse(data);
if(rslt.success){
$('#rslt_info').html(rslt.table_content);
$table = $('#trip_report').DataTable({
//show entries
oLanguage: {sLengthMenu: "<select class='form-control'>"+
"<option value='10'>10</option>"+
"<option value='25'>25</option>"+
"<option value='50'>50</option>"+
"<option value='100'>100</option>"+
"</select>"},
"iDisplayLength": 10
});
var table_option = "<div class='dataTables_length' id='trip_report_length'><table><tr><td id='export' style='padding:8px 2px;'></td></tr></table></div>";
$("#trip_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'}
,title: rslt.title
},
{extend:'csv',exportOptions:{modifier:{order:'index',page:'all',search:'none'},columns:':visible'}
,title: rslt.title
},
{extend:'excel',
exportOptions:{modifier:{order :'index',page: 'all',search:'none'},columns:':visible'}
,title: rslt.title},
{extend:'pdf',exportOptions:{modifier:{order :'index',page:'all',search:'none'},columns:':visible'}
,title: rslt.title},
{extend:'print',exportOptions:{modifier:{order :'index',page:'all',search:'none'},columns:':visible',}
,title: rslt.title}
]
}]
}).container().appendTo($('#export'));
$('body input').addClass('form-control input-sm');
$('body select[name=trip_report_length]').addClass('form-control');
}else{
$('#rslt_info').html('');
toastr.error(rslt['message']);
}
},
});
}
});
});
function select_option(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
}
</script>
<style type="text/css">
.dt-button{
margin-right: 10px;
}
</style>
<?php $this->load->view("partial/footer"); ?>