<?php
  include VIEWPATH.'includes/new_header.php';
  ?>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
  
  <?php
  include VIEWPATH.'includes/new_top_menu.php';
  include VIEWPATH.'includes/new_menu_principal.php';
  ?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    
    <?php 
    include 'includes/menu_paiement.php';
    ?>

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <div class="col-12">
            
            <!-- /.card -->

            <div class="card card-primary">
              <div class="card-header">
                <h3 class="card-title">Paiement</h3>
              </div>
              <!-- /.card-header -->
              <div class="card-body">
               



                <table id="example1" class="table table-bordered table-striped" style="width:100%">
        <thead>
            <tr>
                <th>#</th>
                <th>Client</th>
                <th>Status</th>
                <th>Date Paiement</th>
                <th>Montant</th>
            </tr>   
        </thead>
        <tbody>
          <?php

          $resultat=$this->Model->getRequete('SELECT vente_vente.NUMERO_VENTE, client_client.NOM, client_client.PRENOM, vente_statut.DESCRIPTION AS STATUS_VENTE, DATE_PAIEMENT, MONTANT_PAIEMENT, paiement_status.DESCRIPTION FROM `paiement_paiement` JOIN vente_vente ON vente_vente.ID_VENTE = paiement_paiement.ID_VENTE JOIN paiement_status ON paiement_status.ID_STATUS_PAIEMENT = paiement_paiement.ID_STATUS_PAIEMENT JOIN client_client ON client_client.ID_CLIENT = vente_vente.ID_CLIENT JOIN vente_statut ON vente_statut.ID_VENTE_STATUT = vente_vente.ID_VENTE_STATUT');

          foreach ($resultat as $key) 
         {
          // $commune= $this->Model->getRequete("SELECT `ID_VENTE_DETAILS`,syst_taille_bouteille.DESCRIPTION,`QUANTITE_COMMANDE`,`PRIX_UNITAIRE` FROM `vente_details` JOIN syst_taille_bouteille ON syst_taille_bouteille.ID_TAILLE_BOUTEILLE = vente_details.ID_TAILLE_BOUTEILLE WHERE `ID_VENTE`  = ".$key['ID_VENTE']."");

          // $MONTANTRESTANT =$key['MONTANT_TOTAL']-$key['MONTANT_PAYE'];
          
          echo "<tr>
                <td>".$key['NUMERO_VENTE']."</td>
                <td>".$key['NOM']." ".$key['PRENOM']."</td>
                <td>".$key['STATUS_VENTE']."</td>
                <td>".$key['DATE_PAIEMENT']."</td>
                <td>".$key['MONTANT_PAIEMENT']."</td>
                ";
                 
          
        
         echo "</tr>";
       }
          ?>
            
        </tbody>
        
    </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
        <!-- /.row -->
      </div>
      <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->

  <?php
 include VIEWPATH.'includes/new_copy_footer.php';  
  ?>
  

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>

<!-- ./wrapper -->
<?php
  include VIEWPATH.'includes/new_script.php';
  ?>

<!-- Page specific script -->
<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true, "lengthChange": false, "autoWidth": false,
      "buttons": ["excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper  .col-md-6:eq(0)');
   
  });
</script>

<script type="text/javascript">
  function changelist() {
document.getElementById("myForm").submit();
  }

  $('#reservation').daterangepicker({

        locale: {
        format: 'DD/MM/YYYY'
      }
    })
  $('.select').select2();

</script>
</body>
</html>
<script>
function modifierarti(param1) {
    // Utilisez les paramètres ici
    alert('ID Vente details : ' + param1);
    
    // var iD_VENTE_DETAILS = $(param1).val();
    // alert('ID Vente details : ' + iD_VENTE_DETAILS);
    var PRIX_UNITAIRE = $('#PRIX_UNITAIRE_'+ param1).val();
    var QUANTITE_LIVRE = $('#QUANTITE_COMMANDE_'+param1).val();

    alert('Prix unitaire : ' + PRIX_UNITAIRE);
    alert('Quantite livre : ' + QUANTITE_LIVRE);
    
    $.post('<?php echo base_url('vente/Vente/livraison')?>',
          {
            ID_VENTE_DETAILS:param1,
            PRIX_UNITAIRE:PRIX_UNITAIRE,
            QUANTITE_LIVRE:QUANTITE_LIVRE
          },
          function(data){
            alert(data);
            if (data == 1) {
              document.getElementById('PRIX_UNITAIRE_'+ param1).readOnly = true;
              document.getElementById('QUANTITE_COMMANDE_'+ param1).readOnly = true;
              document.getElementById('LINKS_'+ param1).onclick = function(event) {
                  event.preventDefault(); // Empêche l'action par défaut du lien
                  // alert('Ce lien est désactivé.');
              };
            }
            
            // var newone = data.split("|:|"); // Detail Enregistrement SA
            // var resultattab = newone[0];
            // var resultatprime = newone[1];

            // $('#newdiv').html(resultattab);
            // $('#PRIMETOTNEW').val(resultatprime);
          });
    
}
</script>

            