File
Add library
Share
Login or Register
Help
HTMLSaved
 
<?php
require_once('../library.php');
require_once('../Access/RestrictOperations.php');
//$d_date=date("m/d/Y", strtotime("-6 months"));
​
$query="
        SELECT TOP 100 [ID]
      ,[service_date]
      ,[Shift]
      ,[bus]
      ,[leave_yard]
,[Lvyd_odometer]
       ,[inservice]
,[inserv_odometer]
​
      ,[out_of_service]
,[outserv_odometer]
    ,[return_to_yard]
​
​
 ,[rtnyd_odometer]
     
      from FixedRouteRecords
order by service_date desc
     
​
     
      ";
      $sql = $dbRead->quoteInto($query);
if (!($resultAlert = $dbRead->fetchAll($sql))) die(mysql_error());
​
?>
​
<!doctype html>
<html><head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
​
<title>TO FixedRoute Import</title>
​
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
​
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<link href="../css/style.css" rel="stylesheet" type="text/css" />
<!-- <link rel="stylesheet" href="../css/dataTables.bootstrap.css"> -->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.0/css/jquery.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/2.0.0/css/buttons.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.3.3/css/select.dataTables.min.css">
<link rel="stylesheet" type="text/css" href=" https://cdn.datatables.net/datetime/1.5.2/css/dataTables.dateTime.min.css">
<link rel="stylesheet" type="text/css" href="../css/editor.dataTables.min.css">
​
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.6.1/css/buttons.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.3.1/css/select.dataTables.min.css">
​
<style type="text/css">
​
    .row{margin-bottom:8px;}
    
    p{
    padding-right: .5in;    
    }
    
    .adm_section{
    width: 70%;
    margin-left: 10px;
}
    
</style>
​
        
​
</head>
​
<body>
 
<div id="mainContent" style="width:1100px !important;">
  <div class="form-container">
    <?php include_once('HeaderOps.php'); ?>
    </div> 
    <p class="heading1">FR Import</p>
  
     
       
        <table id="example" class="table table-bordered table-striped">
                    <thead >
                      <tr>
                       <th >Service Date</th>
                       <th >Shift</th> 
                       <th >Bus</th>  
                       <th >Leave Yard</th>
<th >Leave OD</th> 
    <th >inservice</th>
<th> InServe OD</th> 
     <th >Out of Service</th> 
  <th >OutServe OD</th>
    <th >Return to Yard</th> 
                    
                    
                     
 
                       
                       <th >ReturnYard OD</th>
                    </tr>
                    </thead>                
                    
                        
       </div>
</div>  
​
    <!-- <script src="../js/jquery.dataTables.min.js"></script>
    <!-- <script src="../../js/dataTables.editor.min.js"></script>
    <script src="../js/dataTables.bootstrap.min.js"></script> -->
    <script type="text/javascript" language="javascript" src="//cdnjs.cloudflare.com/ajax/libs/PapaParse/4.6.3/papaparse.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.5.1.js"></script>
        <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.2/moment.min.js"></script>                                                                                                                                 
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.11.0/js/jquery.dataTables.min.js"></script>
 <script type="text/javascript" language="javascript" src=":///ajax/libs/PapaParse/4.6.3/papaparse.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/2.0.0/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/select/1.3.3/js/dataTables.select.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/datetime/1.5.2/js/dataTables.dateTime.min.js"></script>
    <script type="text/javascript" language="javascript" src="../js/dataTables.editor.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/2.0.0/js/buttons.html5.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/2.0.0/js/buttons.print.min.js"></script>   
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.html5.min.js"></script>
​
  
​
    <script type="text/javascript" language="javascript" class="init">    
​
        var editor; // use a global for the submit and return data rendering in the examples
    
        function selectColumns ( editor, csv, header ) {
            var selectEditor = new $.fn.dataTable.Editor();
            var fields = editor.order();
​
            for ( var i=0 ; i<fields.length ; i++ ) {
                var field = editor.field( fields[i] );
​
                selectEditor.add( {
                    label: field.label(),
                    name: field.name(),
                    type: 'select',
                    options: header,
                    def: header[i]
                } );
            }
​
            selectEditor.create({
                title: 'Map CSV fields',
                buttons: 'Import '+csv.length+' records',
                message: 'Select the CSV column you want to use the data from for each field.',
                onComplete: 'none'
            });
​
            selectEditor.on('submitComplete', function (e, json, data, action) {
                // Use the host Editor instance to show a multi-row create form allowing the user to submit the data.
                editor.create( csv.length, {
                    title: 'Confirm import',
                    buttons: 'Submit',
                    message: 'Click the <i>Submit</i> button to confirm the import of '+csv.length+' rows of data. Optionally, override the value for a field to set a common value by clicking on the field below.'
                } );
​
                for ( var i=0 ; i<fields.length ; i++ ) {
                    var field = editor.field( fields[i] );
                    var mapped = data[ field.name() ];
​
                    for ( var j=0 ; j<csv.length ; j++ ) {
                        field.multiSet( j, csv[j][mapped] );
                    }
                }
            } );
        }
            
​
        $(document).ready(function() {
            editor = new $.fn.dataTable.Editor( {
               ajax: '../php/dates.php?format=custom',
                table: "#example",      
                ajax: {url :"addFRImport.php", type: "POST"},
                
                fields: [ {
                
                 
                
                        label: "service_date:",
                        name: "service_date",
                         type: 'datetime',
                                    def: () => new Date(),
                                 format: 'M/D/YYYY',
                                 fieldInfo: 'US style m/d/y format'
               
               
                    }, {
                        label: "Shift:",
                        name: "Shift"
                    },{
                        label: "bus:",
                        name: "bus"
                    },{
                        label: "leave_yard:",
                        name: "leave_yard"
                
                             }, {   
                        label: "Lvyd_odometer:",
                        name: "Lvyd_odometer"
                                    
​
                    }, {
​
                        label: "inservice:",
                        name: "inservice"
                    }, {
                        label: "inserv_odometer:",
                        name: "inserv_odometer"
                    }, {
​
                        label: "out_of_service:",
                        name: "out_of_service"
                        
                    }, {
                        label: "outserv_odometer:",
                        name: "outserv_odometer"
​
                    }, {
                        label: "return_to_yard:",
                        name: "return_to_yard"
                                    
                    }, {
                                        
                        label: "rtnyd_odometer:",
                        name: "rtnyd_odometer"
                    }
                ]
            } );
​
            var uploadEditor = new $.fn.dataTable.Editor( {
                fields: [ {
                    label: 'CSV file:',
                    name: 'csv',
                    type: 'upload',
                    ajax: function ( files, done ) {
                        // Ajax override of the upload so we can handle the file locally. Here we use Papa
                        // to parse the CSV.
                        Papa.parse(files[0], {
                            header: true,
                            skipEmptyLines: true,
                            complete: function (results) {
                                if ( results.errors.length ) {
                                    console.log( results );
                                    uploadEditor.field('csv').error( 'CSV parsing error: '+ results.errors[0].message );
                                }
                                else {
                                    selectColumns( editor, results.data, results.meta.fields );
                                }
​
                                // Tell Editor the upload is complete - the array is a list of file
                                // id's, which the value of doesn't matter in this case.
                                done([0]);
                            }
                        });
                    }
                } ]
            } );
            
            var table = $('#example').DataTable( {
                 ajax: '../php/dates.php?format=custom',
                dom: "Bfrtip",      
                ajax: {url :"viewFRImport.php", type: "POST"},
                
                processing: true,
                serverSide: true,
                columns: [
                    { data: "service_date" },
                    { data: "Shift" },
                    { data: "bus" },
                    { data: "leave_yard" },
                    { data: "Lvyd_odometer" },
                    { data: "inservice" },
                    { data: "inserv_odometer" },
                    { data: "out_of_service" },
                    { data: "outserv_odometer" },
                    { data: "return_to_yard" },
                    { data: "rtnyd_odometer" }
                ],
                select: {
                    style: 'os',
                    selector: 'td:first-child'
                },
                buttons: [ 
                    {
                        extend: 'csv',
                        text: 'Export CSV',
                        className: 'btn-space',
                        exportOptions: {
                            orthogonal: null
                        }
                    },
                    {
                        text: 'Import CSV',
                        action: function () {
                            uploadEditor.create( {
                                title: 'CSV file import'
                            } );
                        }
                    },
                    
                    {
                        extend: 'print',
                        text: 'Print',
                        exportOptions: {
                            modifier: {
                                page: 'current'
                            }
                        }
                    }
                ]
            } );    
        } );
    </script>
    <!-- <script>
      $(function () {
         
        $("#example").DataTable( {
        "columnDefs": [
            {
               "targets": [],
                orderable: false
              },
            {
            "targets":[],
            searchable: false
        },
          ],
          "order": [0, "asc"],
          
"lengthMenu": [[ 100, 50, -1 ], [100, 50, "All"]]
​
    } );
      });
     
    </script> -->
  
</body>
</html>
JavaScriptSaved
 
ID  service_date    Shift   bus leave_yard  Lvyd_odometer   inservice   inserv_odometer out_of_service  outserv_odometer    return_to_yard  rtnyd_odometer
30463   2024-03-27  40MF    80  04:38:00    255967  05:02:00    255970  19:54:00    256229  20:15:00    256231
30464   2024-03-27  41MF    78  04:40:00    238517  05:03:00    238523  19:48:00    238765  20:02:00    238771
30465   2024-03-27  42MF    55  04:40:00    358144  05:00:00    358149  19:51:00    358365  20:02:00    358370
30466   2024-03-27  43MF    54  04:39:00    389658  05:03:00    389664  19:49:00    389843  20:01:00    389848
30467   2024-03-27  44MF    79  04:40:00    184165  04:58:00    184163  19:50:00    184409  20:00:00    184411
30454   2024-03-26  40MF    80  04:38:00    255704  05:05:00    255706  19:48:00    255965  19:56:00    255967
30455   2024-03-26  41MF    74  04:40:00    83616   05:03:00    83622   11:14:00    83731   11:14:00    83731
30456   2024-03-26  41MF    79  11:14:00    184010  11:14:00    184040  19:45:00    184151  19:59:00    184165
30457   2024-03-26  42MF    73  04:38:00    87782   05:00:00    87787   12:55:00    87902   13:25:00    87906
30458   2024-03-26  42MF    78  12:57:00    238412  13:00:00    238411  19:51:00    238512  20:11:00    238517
45 errors 6 warnings
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 1: Expected an assignment or function call and instead saw an expression.
Line 1: Missing semicolon.
Line 2: Expected an assignment or function call and instead saw an expression.
Line 2: Missing semicolon.
Line 2: Unexpected '4'.
Line 2: Expected an assignment or function call and instead saw an expression.
Line 2: Missing semicolon.
Line 3: Expected an assignment or function call and instead saw an expression.
Line 3: Missing semicolon.
Line 3: Unexpected '4'.
Line 3: Expected an assignment or function call and instead saw an expression.
Line 3: Missing semicolon.
Line 4: Expected an assignment or function call and instead saw an expression.
Line 4: Missing semicolon.
Line 4: Unexpected '4'.
Line 4: Expected an assignment or function call and instead saw an expression.
Line 4: Missing semicolon.
Line 5: Expected an assignment or function call and instead saw an expression.
Line 5: Missing semicolon.
Line 5: Unexpected '4'.
Line 5: Expected an assignment or function call and instead saw an expression.
Line 5: Missing semicolon.
Line 6: Expected an assignment or function call and instead saw an expression.
Line 6: Missing semicolon.
Line 6: Unexpected '4'.
Line 6: Expected an assignment or function call and instead saw an expression.
Line 6: Missing semicolon.
Line 7: Expected an assignment or function call and instead saw an expression.
Line 7: Too many errors. (63% scanned).
Output 300px

This bin was created anonymously and its free preview time has expired. Get a free unrestricted account

Dismiss x
public
Bin info
anonymouspro
0viewers