516 lines
24 KiB
PHP
516 lines
24 KiB
PHP
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<title>AIRLINE INVOICE</title>
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description">
|
|
<meta content="Coderthemes" name="author">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge"><!-- App favicon -->
|
|
<!-- <link rel="shortcut icon" href="<?php echo base_url(); ?>assets/images/favicon.ico">-->
|
|
<link rel='shortcut icon' href="assets/images/tsplogo2.png"><!-- third party css -->
|
|
<link href="<?php echo base_url(); ?>assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css">
|
|
<link href="<?php echo base_url(); ?>assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css">
|
|
<link href="<?php echo base_url(); ?>assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css">
|
|
<link href="<?php echo base_url(); ?>assets/libs/datatables.net-select-bs4/css//select.bootstrap4.min.css" rel="stylesheet" type="text/css"><!-- third party css end -->
|
|
<!-- Plugins css -->
|
|
<link href="<?php echo base_url(); ?>assets/libs/bootstrap-colorpicker/css/bootstrap-colorpicker.min.css" rel="stylesheet" type="text/css">
|
|
<link href="<?php echo base_url(); ?>assets/libs/clockpicker/bootstrap-clockpicker.min.css" rel="stylesheet" type="text/css">
|
|
<link href="<?php echo base_url(); ?>assets/libs/bootstrap-datepicker/css/bootstrap-datepicker.min.css" rel="stylesheet" type="text/css">
|
|
<link href="<?php echo base_url(); ?>assets/libs/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet" type="text/css"><!-- App favicon -->
|
|
<link rel="shortcut icon" href="<?php echo base_url(); ?>assets/images/favicon.ico"><!-- App css -->
|
|
<link href="<?php echo base_url(); ?>assets/css/bootstrap-creative.min.css" rel="stylesheet" type="text/css" id="bs-default-stylesheet">
|
|
<link href="<?php echo base_url(); ?>assets/css/app-creative.min.css" rel="stylesheet" type="text/css" id="app-default-stylesheet">
|
|
<link href="<?php echo base_url(); ?>assets/css/bootstrap-creative-dark.min.css" rel="stylesheet" type="text/css" id="bs-dark-stylesheet">
|
|
<link href="<?php echo base_url(); ?>assets/css/app-creative-dark.min.css" rel="stylesheet" type="text/css" id="app-dark-stylesheet"><!-- icons -->
|
|
<link href="<?php echo base_url(); ?>assets/css/icons.min.css" rel="stylesheet" type="text/css">
|
|
<style>
|
|
|
|
.dataTable tbody td {
|
|
padding-right: 10px;
|
|
}
|
|
|
|
.mb-3, .my-3 {
|
|
margin-top: -53px;
|
|
margin-bottom: -27px !important;
|
|
}
|
|
.mb25{
|
|
margin-bottom: 25px;
|
|
}
|
|
.required{
|
|
color: red;
|
|
}
|
|
#bs-select-1{
|
|
max-height: 150px !important;
|
|
overflow-y: auto !important;
|
|
}
|
|
.left{
|
|
|
|
}
|
|
|
|
th::before {
|
|
margin-top: -13px !important;
|
|
top: 6px !important;
|
|
}
|
|
|
|
th::after{
|
|
/* display: inline-block; */
|
|
/* text-align: center; */
|
|
top: 0px !important;
|
|
}
|
|
|
|
|
|
/* .form-group {
|
|
font-size: 11px;
|
|
padding: 5px;
|
|
} */
|
|
.body {
|
|
font-size: 12px;
|
|
}
|
|
|
|
.table {
|
|
font-size: 12px;
|
|
border-spacing:10px;
|
|
|
|
|
|
}
|
|
label {
|
|
display: inline-block;
|
|
margin-bottom: 2.5rem;
|
|
}
|
|
.table tr, table td {
|
|
padding: 5px;
|
|
/* line-height: 2; */
|
|
/* Adjust the line-height as needed for tighter cell spacing */
|
|
}
|
|
|
|
.table tbody{
|
|
position: relative;
|
|
overflow: auto;
|
|
max-height: 700px;
|
|
width: 100%;
|
|
/* font-weight: bold; */
|
|
|
|
}
|
|
.table thead th{
|
|
vertical-align: middle;
|
|
}
|
|
.dataTables_scrollBody
|
|
{
|
|
|
|
max-height: 390px;
|
|
width: 1129px;
|
|
}
|
|
.footer
|
|
{
|
|
padding-top: 19px;
|
|
padding-right: 17px;
|
|
padding-bottom: 2px;
|
|
padding-left: 17px;
|
|
}
|
|
.form-group {
|
|
margin-bottom: -2rem;
|
|
}
|
|
.table td, .table th {
|
|
padding: 0.10rem;
|
|
}
|
|
|
|
|
|
div.dataTables_wrapper div.dataTables_paginate ul.pagination {
|
|
margin: 23px 0;
|
|
}
|
|
|
|
/* Style the container for the table with a fixed header */
|
|
/* Style the container for the table with a fixed header */
|
|
|
|
|
|
|
|
|
|
</style>
|
|
</head>
|
|
<body class="loading" data-layout-mode="horizontal" data-layout='{"mode": "light", "width": "fluid", "menuPosition": "fixed", "topbar": {"color": "dark"}, "showRightSidebarOnPageLoad": true}'>
|
|
<!-- Begin page -->
|
|
<div id="wrapper">
|
|
<?php include('includes/top_nav.php'); ?><!-- ============================================================== -->
|
|
<!-- Start Page Content here -->
|
|
<!-- ============================================================== -->
|
|
<!-- <div class="content-page">
|
|
<div class="content"> -->
|
|
<!-- Start Content-->
|
|
<!-- <div class="container-fluid"> -->
|
|
<!-- start page title -->
|
|
<div class="row">
|
|
<div class="col-12">
|
|
<div class="page-title-box page-title-box-alt">
|
|
<h4 class="page-title">AIRLINE INVOICE</h4>
|
|
<div class="page-title-right">
|
|
<ol class="breadcrumb m-0">
|
|
<li class="breadcrumb-item">
|
|
<a href="javascript:%20void(0);">Files</a>
|
|
</li>
|
|
<li class="breadcrumb-item active">AIRLINE INVOICE</li>
|
|
</ol>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div><!-- end page title -->
|
|
<div class="row">
|
|
<div class="col-12">
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<div class="row" style="margin-bottom:-8px;">
|
|
<form class="col-md-12" id="formid" name="formid">
|
|
<h4 style="
|
|
margin-top: -18px;
|
|
">AIRLINE INVOICE</h4><br><br>
|
|
<div class="form-row">
|
|
<!--
|
|
<div class="form-group col-md-2">
|
|
<label for="inputEmail4" class="col-form-label">GST No</label>
|
|
<select name="gst_no" class="form-control">
|
|
<?php
|
|
// foreach($gstno_list->result() as $gstno_i){
|
|
// echo '<option>'.$gstno_i->gn_gstno.'</option>';
|
|
// }
|
|
?>
|
|
</select>
|
|
</div>
|
|
-->
|
|
<input id="fromdate" value="" type="hidden"> <input id="todate" value="" type="hidden">
|
|
<div class="form-group col-md-4">
|
|
<!-- <label class="col-lg-3 col-form-label">Date</label>
|
|
<div class="col-lg-12">
|
|
<div id="reportrange" class="pull-right form-control">
|
|
<i class="glyphicon glyphicon-calendar fa fa-calendar"></i>
|
|
<span></span>
|
|
</div>
|
|
</div> -->
|
|
</div>
|
|
<div class="form-group col-md-2">
|
|
<!-- <label for="inputPassword4" class="col-form-label"></label>
|
|
<button style="margin-top:35px" type="submit" class="btn btn-primary">Submit</button> -->
|
|
</div>
|
|
<div class="col-md-2"></div>
|
|
<div class="modal fade" id="columnModal" tabindex="-1" role="dialog" aria-labelledby="columnModalLabel" aria-hidden="true">
|
|
<div class="modal-dialog" role="document">
|
|
<div class="modal-content">
|
|
<div class="modal-header">
|
|
<h5 class="modal-title" id="columnModalLabel">Select Column to Display</h5>
|
|
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
|
|
<span aria-hidden="true">×</span>
|
|
</button>
|
|
</div>
|
|
<div class="modal-body">
|
|
<label for="selectColumn">Select Column:</label>
|
|
<select style="overflow-y:scroll" name="column_name" id="column_name" class="form-control selectpicker" multiple>
|
|
<!-- <option selected="selected" value="1">TICKET NO</option> -->
|
|
<option selected="selected" value="2">PAX NAME</option>
|
|
<option selected="selected" value="3">PNR</option>
|
|
<!-- <option selected="selected" value="3">REF NO</option> -->
|
|
<option selected="selected" value="4">TICKET NO</option>
|
|
<option selected="selected" value="5">VENDOR</option>
|
|
|
|
<option selected="selected"value="6">VENDOR GST</option>
|
|
<option selected="selected" value="7">RECIPIENT</option>
|
|
<option value="8">RECIPIENT GST</option>
|
|
<option selected="selected"value="9">INVOICE NUMBER</option>
|
|
<option selected="selected"value="10">INVOICE DATE</option>
|
|
<option value="11">HSN</option>
|
|
<option selected="selected"value="12">TAXABLE VALUE</option>
|
|
<option value="13">CGST VALUE</option>
|
|
<option value="14">CGST RATE</option>
|
|
<option value="15">SGST VALUE</option>
|
|
<option value="16">SGST RATE</option>
|
|
<option value="17">IGST VALUE</option>
|
|
<option value="18">IGST RATE</option>
|
|
<option selected="selected"value="19">TOTAL INVOICE VALUE</option>
|
|
<option selected="selected"value="20">TOTAL VALUE</option>
|
|
<option selected="selected"value="21">STATUS</option>
|
|
<option selected="selected"value="22">TICKET TYPE</option>
|
|
<option selected="selected"value="23">AIRLINE FILE NAME</option>
|
|
<option selected="selected"value="24">EXTRACTION DATE</option>
|
|
<!-- <option selected="selected"value="26">BATCH ID</option> -->
|
|
<!-- <option selected="selected" value="0">Icon for Select Option</option> -->
|
|
</select>
|
|
</div>
|
|
<div class="modal-footer">
|
|
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
|
|
<button type="button" class="btn btn-primary" id="applyColumn">Apply Column</button>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
</div>
|
|
|
|
</div>
|
|
</form>
|
|
</div>
|
|
|
|
<table id="scroll-horizontal-datatable" class="table table-striped nowrap w-100">
|
|
|
|
<thead>
|
|
<!-- <button id="toggle-column-modal-button" class="btn btn-link" data-toggle="modal" data-target="#columnModal" style="
|
|
margin-top: -43px;
|
|
margin-right: 1228px;
|
|
"> <i class="fa fa-eye"></i> </button> -->
|
|
<tr>
|
|
<th hidden>S.NO</th>
|
|
<th hidden>INVOICE ID</th>
|
|
<th>PAX NAME</th>
|
|
<th>PNR</th>
|
|
<th>TKT</th>
|
|
<th hidden>VENDOR</th>
|
|
<th hidden>VENDOR GST</th>
|
|
<th>REC</th>
|
|
<th >REC GST</th>
|
|
<th>INV NUMBER</th>
|
|
<th>INV DATE</th>
|
|
<th >HSN</th>
|
|
<th>TAX VAL</th>
|
|
<th >CGST VAL</th>
|
|
<th >CGST RATE</th>
|
|
<th >SGST VAL</th>
|
|
<th >SGST RATE</th>
|
|
<th >IGST VAL</th>
|
|
<th >IGST RATE</th>
|
|
<th>TOT INV VAL</th>
|
|
<th>TOT VAL</th>
|
|
<th>STATUS</th>
|
|
<th>TKT TYPE</th>
|
|
<th>AIRLINE FILE NAME</th>
|
|
<th>EXTR DATE</th>
|
|
<th>BATCH ID</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php foreach ($data as $value){
|
|
?>
|
|
<tr>
|
|
<td hidden><?php echo $value->sno;?></td>
|
|
<td hidden><?php echo $value->sl; ?></td>
|
|
<td><?php echo $value->pax_name; ?></td>
|
|
<td><?php echo $value->pnr; ?></td>
|
|
<td><?php echo $value->ticket_no; ?></td>
|
|
<td hidden><?php echo $value->vendor; ?></td>
|
|
<td hidden><?php echo $value->vendor_gst; ?></td>
|
|
<td><?php echo $value->recepient; ?></td>
|
|
<td><?php echo $value->recepient_gst; ?></td>
|
|
<td><?php echo $value->invoice_no?></td>
|
|
<td><?php echo $value->invoice_dt; ?></td>
|
|
<td><?php echo $value->hsn; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->taxable_value; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->cgst_value;?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->cgst_rate; ?></td>
|
|
<!-- <td hidden>kkk</td> -->
|
|
<td style="text-align: right;"><?php echo (int) $value->sgst_value; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->sgst_rate; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->igst_value; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->igst_rate; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->total_inv_value; ?></td>
|
|
<td style="text-align: right;"><?php echo (int) $value->total_values; ?></td>
|
|
<td><?php echo $value->status; ?></td>
|
|
<td><?php echo $value->ticket_type; ?></td>
|
|
<td><?php echo $value->airline_file_name; ?></td>
|
|
<td><?php echo date('d-m-Y', strtotime($value->extraction_date)); ?></td>
|
|
<td><?php echo $value->batch_id; ?></td><?php
|
|
}
|
|
?>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<!-- </thead>
|
|
<tbody>
|
|
</tbody>
|
|
</table>
|
|
|
|
</div> <!== end card body-->
|
|
</div><!-- end card -->
|
|
</div><!-- end col-->
|
|
</div><!-- end row-->
|
|
</div><!-- container -->
|
|
</div><!-- content -->
|
|
|
|
<?php include('includes/footer.php'); ?>
|
|
</div>
|
|
|
|
|
|
|
|
<button id="view_modal_btn" style="display:none" type="button" data-toggle='modal' data-target="#view_modal"><i class="fa fa-upload"></i> View modal</button>
|
|
|
|
<div id="view_modal" class="modal fade" role="dialog">
|
|
<div class="modal-dialog">
|
|
|
|
|
|
|
|
<!-- ============================================================== -->
|
|
<!-- End Page content -->
|
|
<!-- ============================================================== -->
|
|
|
|
<!-- Vendor js -->
|
|
<script src="<?php echo base_url(); ?>assets/js/vendor.min.js"></script>
|
|
|
|
<!-- third party js -->
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-buttons/js/buttons.flash.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-keytable/js/dataTables.keyTable.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/datatables.net-select/js/dataTables.select.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/pdfmake/build/pdfmake.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/pdfmake/build/vfs_fonts.js"></script>
|
|
|
|
<!-- Plugins js-->
|
|
<script src="<?php echo base_url(); ?>assets/libs/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/clockpicker/bootstrap-clockpicker.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/moment/min/moment.min.js"></script>
|
|
<script src="<?php echo base_url(); ?>assets/libs/bootstrap-daterangepicker/daterangepicker.js"></script>
|
|
|
|
<!-- Init js-->
|
|
|
|
<script src="<?php echo base_url(); ?>assets/js/pages/form-pickers.init.js"></script>
|
|
|
|
|
|
<!-- <script src="<?php echo base_url(); ?>assets/js/pages/datatables.init.js"></script> -->
|
|
|
|
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/css/bootstrap-select.min.css">
|
|
<script src="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/js/bootstrap-select.min.js"></script>
|
|
|
|
<!-- App js -->
|
|
<script src="<?php echo base_url(); ?>assets/js/app.min.js"></script>
|
|
|
|
|
|
<script>
|
|
$(document).ready(function() {
|
|
|
|
oTable = $("#scroll-horizontal-datatable").DataTable({
|
|
lengthChange: true,
|
|
"paging": true,
|
|
"lengthMenu": [10, 25, 50, 100],
|
|
"pageLength": 50,
|
|
|
|
// dom: 'Bflrtip',
|
|
"dom": '<"row mb-3"<"col-md-4 d-flex justify-content-start align-items-center"l><"col-md-4 d-flex justify-content-end align-items-center"f><"col-md-4 d-flex justify-content-end align-self-start"B>>rtip',
|
|
buttons: [
|
|
{
|
|
extend: "csvHtml5",
|
|
exportOptions: {
|
|
columns: [ 0, 1, 2, 3, 4, 23, 24, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18,19,20,21,22]
|
|
}
|
|
},
|
|
{
|
|
text: "Columns",
|
|
action: function (e, dt, node, config) {
|
|
$('#columnModal').modal('show');
|
|
}
|
|
}
|
|
|
|
// 'copyHtml5',
|
|
// 'excelHtml5',
|
|
// 'csvHtml5'
|
|
// 'pdfHtml5'
|
|
],
|
|
|
|
// buttons: [{
|
|
// extend: "excelHtml5",
|
|
// className: "btn-light"
|
|
// }
|
|
//// , {
|
|
//// extend: "print",
|
|
//// className: "btn-light"
|
|
//// }, {
|
|
//// extend: "pdf",
|
|
//// className: "btn-light"
|
|
//// }
|
|
// ],
|
|
scrollX: !0,
|
|
// "paging": false,
|
|
// "pageLength": 50,
|
|
"columnDefs": [{
|
|
"targets": [11,8,13,14,15,16,17,18],
|
|
"visible": false
|
|
}],
|
|
|
|
language: {
|
|
paginate: {
|
|
previous: "<i class='mdi mdi-chevron-left'>",
|
|
next: "<i class='mdi mdi-chevron-right'>"
|
|
}
|
|
}
|
|
});
|
|
|
|
oTable.buttons().container().appendTo("#scroll-horizontal-datatable_wrapper .col-md-6:eq(0)"), $("#alternative-page-datatable").DataTable({
|
|
pagingType: "full_numbers",
|
|
drawCallback: function () {
|
|
$(".dataTables_paginate > .pagination").addClass("pagination-rounded")
|
|
}
|
|
});
|
|
|
|
$('#column_name').selectpicker();
|
|
|
|
|
|
$('#column_name').change(function(){
|
|
|
|
|
|
|
|
var all_column = ["0", "1", "2", "3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25"];
|
|
|
|
var conceptName = $('#column_name').find(":selected").val();
|
|
|
|
var remove_column = $('#column_name').val();
|
|
|
|
var remaining_column = all_column.filter(function(obj) { return remove_column.indexOf(obj) == -1; });
|
|
|
|
oTable.columns(remove_column).visible(true);
|
|
|
|
oTable.columns(remaining_column).visible(false);
|
|
|
|
});
|
|
});
|
|
</script>
|
|
|
|
<script>
|
|
|
|
var oTable;
|
|
|
|
$(document).ready(function() {
|
|
// oTable = $("#scroll-horizontal-datatable").DataTable({
|
|
// Your DataTable configuration here
|
|
});
|
|
|
|
$('#toggle-column-modal-button').click(function() {
|
|
$('#columnModal').modal('show');
|
|
});
|
|
|
|
$('#applyColumn').click(function() {
|
|
var selectedColumns = $('#column_name').val();
|
|
|
|
if (selectedColumns && selectedColumns.length > 0) {
|
|
// Array of all column indices
|
|
var allColumns = [ "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15"];
|
|
|
|
// Convert selected column indices to integers
|
|
selectedColumns = selectedColumns.map(Number);
|
|
|
|
// Calculate the remaining columns to hide
|
|
var remainingColumns = allColumns.filter(function(column) {
|
|
return selectedColumns.indexOf(parseInt(column)) === -1;
|
|
});
|
|
|
|
// Show selected columns and hide remaining columns
|
|
oTable.columns(selectedColumns).visible(true);
|
|
oTable.columns(remainingColumns).visible(false);
|
|
|
|
// Close the modal
|
|
$('#columnModal').modal('hide');
|
|
}
|
|
});
|
|
</script>
|
|
</body>
|
|
</html>
|