Forward_Station_Server/api/v1/Customers/customers.php

<div class="container-fluid">
<div class="row">
<div class="col-sm-6">
        
<button class="btn btn-primary" onclick="document.getElementById('addForm').style.display = 'block';document.getElementById('editForm').style.display = 'none';document.getElementById('deleteForm').style.display = 'none';"> Add Customer </button>

<table id="example" class="table display table-striped table-bordered table-hover table-sm" cellspacing="0" width="100%">
      <thead>
        <tr>
          <th></th>
          <th></th>
          <th>Id</th>
          <th>Name</th>
          <th>Credit Sale</th>
          <!-- <th>Vehicle Id</th> -->
          <!-- <th>Vehicle Number</th> -->
        </tr>
      </thead>

        <tfoot>
            <tr>
                <th></th>
                <th></th>
                <th>Id</th>
                <th>Name</th>
                <th>Credit Sale</th>
                <!-- <th>Vehicle Id</th> -->
                <!-- <th>Vehicle Number</th> -->
            </tr>
        </tfoot>
    </table>
</div>

<div class="col-sm-6">
    <?php include "vehicles.php" ?>
</div>

</div>
</div>


<?php include "addCustomer.php" ?>
<?php include "Edit.php" ?>
<?php include "Delete.php" ?>





<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>'+
//             '<td>Supplier Id:</td>'+
//             '<td>'+d.Id+'</td>'+
//         '</tr>'+
//         '<tr>'+
//             '<td>Supplier Name:</td>'+
//             '<td>'+d.Number+'</td>'+
//         '</tr>'+
        // '<tr>'+
        //     '<td>Delivery Car Number:</td>'+
        //     '<td>'+d.DeliveryCarNumber+'</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>OrderPrice:</td>'+
        //     '<td>'+d.OrderPrice+'</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>OrderVolume:</td>'+
        //     '<td>'+d.OrderVolume+'</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>DeliverVolume:</td>'+
        //     '<td>'+d.DeliverVolume+'</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>FuelPoints:</td>'+
        //     '<td>'+d.FuelPoints+'</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>TankGroup:</td>'+
        //     '<td>'+d.TankGroup+'</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>Tank id</td>'+
        //     '<td>Start Volume</td>'+
        //     '<td>End Volume</td>'+
        //     '<td>Input Volume</td>'+
        // '</tr>'+
        // '<tr>'+
        //     '<td>Fp id</td>'+
        //     '<td>Start Volume</td>'+
        //     '<td>End Volume</td>'+
        //     '<td>Output Volume</td>'+
        // '</tr>'+
//     '</table>';
// }
 // '<table>'+
 //        '<tr>'+
 //            '<th>Tank Id</th>'+
 //            '<th>Start Volume</th>'+
 //            '<th>End Volume</th>'+
 //            '<th>Input Volume</th>'+
 //        '<tr>'+
 //    '</table>'
$(document).ready(function() {
    var table = $('#example').DataTable( {
        "buttons": true,
        "ajax": "api/v1/Customers/customers.txt",
        "columns": [
            // {
            //     "className":      'details-control',
            //     "orderable":      false,
            //     "data":           null,
            //     "defaultContent": ''
            // },
            {
                "className":      'delete',
                "orderable":      false,
                "data":           null,
                "defaultContent": 'Delete'
            },
            {
                "className":      'edit',
                "orderable":      false,
                "data":           null,
                "defaultContent": 'Edit'
            },
            { "data": "Customer_Id" },
            { "data": "Name",
              "className":'name'
             },
            { "data": "Credit_Sale" },
            //{ "data": "Id" },
            //{ "data": "Number" },
        ],
        "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');
    //     }
    // } );

    // Add event listener for opening and closing details
    $('#example tbody').on('click', 'td.name', function () {
        var tr = $(this).closest('tr');
        var row = table.row( tr );
        var username = table.row( this ).data()['Name'];
        var id = table.row( this ).data()['Customer_Id'];
        
        //console.log( table.row( this ).data() );
        alert( table.row( this ).data()['Customer_Id'] );

    } );

    // Add event listener for opening and closing details
    $('#example tbody').on('click', 'td.delete', function () {
        var tr = $(this).closest('tr');
        var row = table.row( tr );
        var username = table.row( this ).data()['Name'];
        var id = table.row( this ).data()['Customer_Id'];
        document.getElementById('deleteid').value = id;
        
        document.getElementById('deleteForm').style.display = 'block';
        document.getElementById('editForm').style.display = 'none';
        document.getElementById('addForm').style.display = 'none';
        //if (confirm("Do you want to delete "+username+"?")) {}
        //console.log( table.row( this ).data() );
        //alert( table.row( this ).data()['Customer_Id'] );

    } );

        // Add event listener for opening and closing details
    $('#example tbody').on('click', 'tr td.edit', function () {
        var tr = $(this).closest('tr');
        var row = table.row( tr );

        // console.log( table.row( this ).data() );
        // alert( table.row( this ).data()['Name'] );
        var username = table.row( this ).data()['Name'];
        var creditSale = table.row( this ).data()['Credit_Sale'];
        var id = table.row( this ).data()['Customer_Id'];
        //var vehicle_id = table.row( this ).data()['Id'];
        //var number = table.row( this ).data()['Number'];

        document.getElementById('username').value = username;
        document.getElementById('id').value = id;
        //document.getElementById('vehicle_id').value = vehicle_id;
        //document.getElementById('number').value = number;

        if (creditSale=='Yes') {
        document.getElementById('creditSaleOn').checked = true;
        }else if(creditSale=='No'){
        document.getElementById('creditSaleOff').checked = true;
        }
        document.getElementById('editForm').style.display = 'block';
        document.getElementById('addForm').style.display = 'none';
        document.getElementById('deleteForm').style.display = 'none';
    } );

} );
</script>