<?php $i=null; function decimalAndNumberFormat1($number){ $i = number_format(round($number,0)); return $i; } function decimalAndNumberFormat2($number){ $i = number_format(round($number,1),1); return $i; } function decimalAndNumberFormat3($number){ $i = number_format(round($number,3)); return $i; } ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Forward Station Server</title> <!-- Tell the browser to be responsive to screen width --> <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script> <link href="https://cdn.datatables.net/r/bs-3.3.5/jq-2.1.4,dt-1.10.8/datatables.min.css" rel="stylesheet"/> <script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap.min.js" charset="utf-8"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script> <!-- Bootstrap 3.3.7 --> <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css"> <!-- Font Awesome --> <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css"> <!-- Ionicons --> <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/AdminLTE.min.css"> <link rel="stylesheet" href="dist/css/style.css"> <!-- <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css"> --> <!-- Morris chart --> <link rel="stylesheet" href="bower_components/morris.js/morris.css"> <!-- jvectormap --> <link rel="stylesheet" href="bower_components/jvectormap/jquery-jvectormap.css"> <!-- Date Picker --> <link rel="stylesheet" href="bower_components/bootstrap-datepicker/dist/css/bootstrap-datepicker.min.css"> <!-- Daterange picker --> <link rel="stylesheet" href="bower_components/bootstrap-daterangepicker/daterangepicker.css"> <!-- bootstrap wysihtml5 - text editor --> <link rel="stylesheet" href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css"> <!-- Google Font --> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic"> <link href='http://fonts.googleapis.com/css?family=Lobster' rel='stylesheet' type='text/css'> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.8.2/css/all.css"> </head> <body class="hold-transition skin-blue sidebar-mini"> <div class="wrapper"> <?php include("main_header.php");?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"><br> <?php include "api/v1/Deliveries/selectDeliveryVw.php" ?> <table id="example" class="table display table-striped table-bordered table-hover table-sm" cellspacing="0" width="100%"> <thead> <tr> <th></th> <th>Action</th> <th>Message</th> <th>id</th> <th>Tank</th> <th>Status</th> <th>Start</th> <th>End</th> </tr> </thead> <tfoot> <tr> <th></th> <th>Action</th> <th>Message</th> <th>id</th> <th>Tank</th> <th>Status</th> </tr> </tfoot> </table> <script type="text/javascript"> /* Formatting function for row details - modify as you need */ function format ( d ) { // `d` is the original data object for the row return '<table id="example" class="table table-bordered table-sm" cellspacing="0" width="100%" style="background-color:#3F51B5;color:white;">'+ '<tr>'+ '<th>Product:</th>'+ '<td>'+d.Product+'</td>'+ '</tr>'+ '<tr>'+ '<th>Supplier Id:</th>'+ '<td>'+d.SupplierId+'</td>'+ '</tr>'+ '<tr>'+ '<th>Supplier Name:</th>'+ '<td>'+d.SupplierName+'</td>'+ '</tr>'+ '<tr>'+ '<th>Delivery Car Number:</th>'+ '<td>'+d.DeliveryCarNumber+'</td>'+ '</tr>'+ '<tr>'+ '<th>OrderPrice:</th>'+ '<td>'+d.OrderPrice+'</td>'+ '</tr>'+ '<tr>'+ '<th>OrderVolume:</th>'+ '<td>'+d.OrderVolume+'</td>'+ '</tr>'+ '<tr>'+ '<th>DeliverVolume:</th>'+ '<td>'+d.DeliverVolume+'</td>'+ '</tr>'+ '<tr>'+ '<th>FuelPoints:</th>'+ '<td>'+d.FuelPoints+'</td>'+ '</tr>'+ '<tr>'+ '<th>TankGroup:</th>'+ '<td>'+d.TankGroup+'</td>'+ '</tr>'+'<hr>'+ '<tr>'+ '<th>Tank id</th>'+ '<th>Start Volume</th>'+ '<th>End Volume</th>'+ '<th>Input Volume</th>'+ '</tr>'+ '<tr>'+ '<th>Fp id</th>'+ '<th>Start Volume</th>'+ '<th>End Volume</th>'+ '<th>Output Volume</th>'+ '</tr>'+ '</table>'; } $(document).ready(function() { var table = $('#example').DataTable( { "ajax": "api/v1/Deliveries/deliveryDetails.txt", "columns": [ { "className": 'details-control', "orderable": false, "data": null, "defaultContent": '' }, { "data": "Action" }, { "data": "Message" }, { "data": "Id" }, { "data": "Tank" }, { "data": "Status" }, { "data": "Start" }, { "data": "End" }, ], "order": [[1, 'asc']] } ); // Add event listener for opening and closing details $('#example tbody').on('click', 'td.details-control', function () { var tr = $(this).closest('tr'); var row = table.row( tr ); if ( row.child.isShown() ) { // This row is already open - close it row.child.hide(); tr.removeClass('shown'); } else { // Open this row row.child( format(row.data()) ).show(); tr.addClass('shown'); } } ); } ); </script> </div> <!-- /.content-wrapper --> </div> <!-- ./wrapper --> <!-- jQuery 3 --> <script src="bower_components/jquery/dist/jquery.min.js"></script> <script> $.widget.bridge('uibutton', $.ui.button); </script> <!-- Bootstrap 3.3.7 --> <script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script> <!-- Morris.js charts --> <script src="bower_components/raphael/raphael.min.js"></script> <script src="bower_components/morris.js/morris.min.js"></script> <script src="bower_components/moment/min/moment.min.js"></script> <script src="bower_components/bootstrap-daterangepicker/daterangepicker.js"></script> <!-- datepicker --> <script src="bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script> <!-- Bootstrap WYSIHTML5 --> <script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script> <!-- Slimscroll --> <!-- FastClick --> <script src="bower_components/fastclick/lib/fastclick.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.min.js"></script> <!-- AdminLTE dashboard demo (This is only for demo purposes) --> <script src="dist/js/pages/dashboard.js"></script> <!-- AdminLTE for demo purposes --> <script src="dist/js/demo.js"></script> </body> </html> <!-- -->