<!-- Nom &amp; Prénom: WOUMTANA P. Youssouf
            Téléphone: +226 63 86 22 46 / 73 35 41 41
                Email: issoufwoumtana@gmail.com -->
<?php
    
    include("query/fonction.php");
   
    
?>
<?php require_once 'header.php';
    require_once 'navbar.php'; ?>
    <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/lightbox2/2.10.0/css/lightbox.min.css">
  <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
  <!-- <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script> -->
  <script src="https://cdnjs.cloudflare.com/ajax/libs/lightbox2/2.10.0/js/lightbox.min.js"></script>
<!-- Page content -->
<style>
    .dataTables_filter{
        float: right;
    }
</style>

<div class="container-fluid pt-8">
    <div class="page-header mt-0 p-3">
        <h3 class="mb-sm-0">Request Cancel</h3>
        <!-- <button id="addd" title="" class="btn btn-primary pull-right" data-toggle="modal" data-target="#add-type-vehicule">
                <i class="fa fa-plus"></i>
        </button> -->
        <!-- <button type="button" class="btn btn-dark btn-sm" data-toggle="modal" data-target="#add-type-vehicule"><i class="fa fa-plus m-r-10"></i>Add</button> -->

    </div>
        <div class="page-wrapper">
           
                        <div class="card">
                            <div class="card-body">
                                <!-- <h6 class="card-subtitle">Export data to Copy, CSV, Excel, PDF & Print</h6> -->
                                <div class="table-responsive m-t-10">
                                    <?php
                                        $tab_requete[] = array();
                                        $tab_requete = getRequeteCanceled();
                                        $tab_currency[] = array(); 
                                        $tab_currency = getEnabledCurrency();
                                    ?>
                                    <table id="example24" class="text-center display nowrap table table-hover table-striped table-bordered" cellspacing="0" width="100%">
                                        <thead>
                                            <tr class="text-upparcase">
                                                <th>S.NO.</th>
                                                <th>payment</th>
                                                <th width="5%">method</th>
                                                <th>customer</th>
                                                <th>driver</th>
                                                <th>depart</th>
                                                <th>destination</th>
                                                <th>distance</th>
                                                <th>duration</th>
                                                <th>cost($)</th>
                                                <!-- <th>Path</th> -->
                                                <th>status</th>
                                                <!-- <th>Race status</th> -->
                                                <th>created</th>
                                                <th>modified</th>
                                                <th>action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                                for($i=0; $i<count($tab_requete); $i++){
                                                    $distance = $tab_requete[$i]['distance'];
                                                    // $cout = ((400)/1000 * $distance);
                                                    $statut_pay = "";
                                                    echo'
                                                        <tr>
                                                            <td>'.($i+1).'</td>
                                                            <td><span class="'; if($tab_requete[$i]['statut_paiement']=='yes'){echo 'badge badge-success'; $statut_pay='Paid';}else{echo 'badge badge-warning'; $statut_pay='Not paid';} echo '">'.$statut_pay.'</span></td>
                                                            <td width="5%"><img src="assets/images/payment_method/'.$tab_requete[$i]['payment_image'].'" alt="" width="100%"></td>
                                                            <td>'.$tab_requete[$i]['nom'].' '.$tab_requete[$i]['prenom'].'</td>
                                                            <td>'.$tab_requete[$i]['nomDriver'].' '.$tab_requete[$i]['prenomDriver'].'</td>
                                                            <td>'.$tab_requete[$i]['depart_name'].'</td>
                                                            <td>'.$tab_requete[$i]['destination_name'].'</td>
                                                            <td>'.$tab_requete[$i]['distance'].' m</td>
                                                            <td>'.$tab_requete[$i]['duree'].'</td>
                                                            <td>'.$tab_requete[$i]['montant'].'</td>
                                                            <td><span class="badge badge-warning">'.$tab_requete[$i]['statut'].'</span></td>
                                                            <td>'.$tab_requete[$i]['creer'].'</td>
                                                            <td>'.$tab_requete[$i]['modifier'].'</td>
                                                            <td>
                                                                <input type="hidden" value="'.$tab_requete[$i]['id'].'" name="" id="id_affectation_'.$i.'">
                                                                <a href="query/action.php?id_affectation='.$tab_requete[$i]['id'].'" class="btn btn-danger btn-sm" data-toggle="tooltip" data-original-title="Delete"> <i class="fa fa-trash text-white"></i> </a>
                                                            </td>
                                                        </tr>
                                                    ';
                                                    // <a href="query/action.php?id_affectation_activer='.$tab_requete[$i]['id'].'" class="btn btn-success btn-sm" data-toggle="tooltip" data-original-title="Activate"> <i class="fa fa-check"></i> </a>
                                                    // <a href="query/action.php?id_affectation_desactiver='.$tab_requete[$i]['id'].'" class="btn btn-inverse btn-sm" data-toggle="tooltip" data-original-title="Deactivate"> <i class="fa fa-close"></i> </a>
                                                    // <button type="button" onclick="modAnnee(id_affectation_'.$i.'.value);" class="btn btn-warning btn-sm" data-original-title="Modifier" data-toggle="modal" data-target="#annee-mod"><i class="fa fa-pencil"></i></button>
                                                }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php
  require_once 'footer.php';
  require_once 'jslinks.php';
?>
    <script>
    $(document).ready(function() {
        $('#myTable').DataTable();
        $(document).ready(function() {
            var table = $('#example').DataTable({
                "columnDefs": [{
                    "visible": false,
                    "targets": 2
                }],
                "order": [
                    [2, 'asc']
                ],
                "displayLength": 25,
                "drawCallback": function(settings) {
                    var api = this.api();
                    var rows = api.rows({
                        page: 'current'
                    }).nodes();
                    var last = null;
                    api.column(2, {
                        page: 'current'
                    }).data().each(function(group, i) {
                        if (last !== group) {
                            $(rows).eq(i).before('<tr class="group"><td colspan="5">' + group + '</td></tr>');
                            last = group;
                        }
                    });
                }
            });
            // Order by the grouping
            $('#example tbody').on('click', 'tr.group', function() {
                var currentOrder = table.order()[0];
                if (currentOrder[0] === 2 && currentOrder[1] === 'asc') {
                    table.order([2, 'desc']).draw();
                } else {
                    table.order([2, 'asc']).draw();
                }
            });
        });
    });
    $('#example24').DataTable();
    </script>
    <!-- ============================================================== -->
    <!-- Style switcher -->
    <!-- ============================================================== -->
    <script src="assets/plugins/styleswitcher/jQuery.style.switcher.js"></script>
    <script>
        function modAnnee(id_annee){
            $.ajax({
                url: "query/ajax/getAnneeById.php",
                type: "POST",
                data: {"id_annee":id_annee},
                success: function (data) {
                    $("#id_annee_mod").empty();
                    $("#libelle_annee_mod").empty();

                    var data_parse = JSON.parse(data);

                    $("#id_annee_mod").val(data_parse[0].id);
                    $("#libelle_annee_mod").val(data_parse[0].libelle);
                }
            });
        }
    </script>

    
    <!--Custom JavaScript -->
    <!-- <script src="js/custom.min.js"></script> -->
    <script src="assets/plugins/toast-master/js/jquery.toast.js"></script>
    <script src="js/toastr.js"></script>
    <!-- Custom Theme JavaScript -->

    <?php if(isset($_SESSION['status']) &&  $_SESSION['status'] == 1){ ?>
            <script>
                showSuccess();
            </script>
    <?php }else if(isset($_SESSION['status']) &&  $_SESSION['status'] == 2){ ?>
            <script>
                showFailed();
            </script>
    <?php }else if(isset($_SESSION['status']) &&  $_SESSION['status'] == 3){ ?>
            <script>
                showWarningIncorrect();
            </script>
    <?php } unset($_SESSION['status']); ?>
</body>

</html>