SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'SELECT `Code_Vente`, `Article` FROM `bd_article_famille`  WHERE  `Id_Article`='8'SELECT `TVA`, `7` as code_vente, `Etranger` FROM `Bd_Code_Vente`  WHERE  `Id_Code`='16'<script type='text/javascript'>document.location.replace('JPD_facture_accueil.php');</script>

<!DOCTYPE html>
<html lang="en">

<head>

  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">

  <title>BDC</title>

  <!-- Custom fonts for this template-->
  <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
  <link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">

  <!-- Custom styles for this template-->
  <link href="../css/sb-admin-2.css" rel="stylesheet">
    
  <!-- Custom styles for this page -->
  <!--<link href="vendor/DataTablesBase/datatables.min.css" rel="stylesheet">-->
  <link href="../vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">    
  <link rel="stylesheet" type="text/css" href="../lib/chosen_v1.8.5/chosen.css"/>
</head><script>
$(document).ready(function(){
	$('#dataTable').DataTable({     	
        "scrollCollapse": true,
		 stateSave: true,
        "paging": false
    });
});
	
</script>

<body id="page-top">
<script>
$(function(){
  $(".open-AddBookDialog").click(function(){
     $('#bookId').val($(this).data('id'));
     $("#addBookDialog").modal("show");
  });
});
	</script>
<div id="addBookDialog" class="modal fade" tabindex="-1" role="dialog">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-body">
       <input type="hidden" name="bookId" id="bookId" value=""/>
      </div>
    
    </div><!-- /.modal-content -->
  </div><!-- /.modal-dialog -->
</div><!-- /.modal -->

<!--------------------------- Modal POPUP Envoi email -->
<div class="modal fade printable" id="exampleModalEnvoiemail" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="exampleModalLongTitle">Envoi email (Expéditeur : sales@globeplanter.fr)</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
      	<div class="form-group">
      		<label name="emailclient">Adresse email :</label><br>
			<div class="row"><div class="col-6"><select id="emailclient" name="emailclient" class="form-control" required></select></div><div class="col-6"><input type="text" class="form-control" name="emailclientautre" placeholder="autre" id="emailclientautre" pattern="[a-z0-9][a-z0-9._-]*@[a-z0-9_-]{2,}\.[a-z]{2,4}"></div></div>
		</div><br>
		<div class="form-group">
			<input name="numfacturemail" type="hidden" id="numfacturemail" value="">
			<label name="contenuemail">Contenu du mail :</label><br>
			<textarea name="contenuemail" class="form-control" rows="5" cols="33" id="contenuemail" required></textarea>
		</div>
		      </div>
      <div class="modal-footer noprint">
        <button type="button" id="Submit_email" class="btn btn-primary" data-dismiss="modal">Envoyer</button>
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>
    
<!--------------------------- Modal POPUP Envoi email Succes -->
<div class="modal fade printable" id="exampleModalEnvoiemailSucces" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="exampleModalLongTitle">Envoi email </h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
      	
      </div>
      <div class="modal-footer noprint">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>
  <!--------------------------- Modal POPUP Tel Client -->
<div class="modal fade printable" id="ModaltelClient" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="exampleModalLongTitle">Tel. Client</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
            <div id="telclient">
			</div>
			
      </div>
      <div class="modal-footer noprint">
       <!----<button type="button" class="btn btn-primary" onclick="window.print();">Imprimer</button>-->
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>
    
<!--------------------------- Modal POPUP COM JPD -->
<div class="modal fade printable" id="ModalcomJPD" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="exampleModalLongTitle">Commentaire Relance</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
      	<p id="derniererelancejpd"></p>
      	<div class="form-group">
      		<label name="commentaire_relancejpd">Commentaire :</label><br>
			<textarea type="text" class="form-control" name="commentaire_relancejpd" rows="5" cols="33" id="commentaire_relancejpd" required></textarea>
		</div><br>
		<input type="hidden" name="numdeviscomjpd" id="numdeviscomjpd" value="">
		
      </div>
      <div class="modal-footer noprint">
        <button type="button" id="Submit_comJPD" class="btn btn-primary">Valider</button>
		
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div> 

       
<!--------------------------- Modal POPUP Modif Succes -->
<div class="modal fade printable" id="ModifSuccess" tabindex="-1" role="dialog" aria-labelledby="ModifSuccesstitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="ModifSuccesstitle">Modif Succes</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body bg-success text-white">
      	Modifications effectuees
      </div>
      <div class="modal-footer noprint">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>

<!--------------------------------- modalavoirmp -->
<div class="modal fade printable" id="modalavoirmp" tabindex="-1" role="dialog" aria-labelledby="modalavoirmptitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="modalavoirmptitle">Avoir MP à JPD</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body bg-success text-white">
      	Penser à créer l'avoir MP à JPD dans facture en attente MP
      </div>
      <div class="modal-footer noprint">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>

<!--------------------------- Modal POPUP Modif Erreur -->
<div class="modal fade printable" id="ModifError" tabindex="-1" role="dialog" aria-labelledby="ModifErrortitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="ModifErrortitle">Modif Erreur</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body bg-danger text-white">
Erreur enregistrement
</div>
      <div class="modal-footer noprint">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>
<!--------------------------- Modal POPUP REFUS GPS -->
<div class="modal fade printable" id="ModalrefusJPD" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="exampleModalLongTitle">Refus</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <form action="/JPD/JPD_BDCpro_accueil.php" method="post">
      <div class="modal-body">
      	<div class="form-group">
      		<label name="raison">Raison Refus :</label><br>
			<select type="text" class="form-control" name="raison" id="raison" required>
						<option value="Choix sur un autre devis">Choix sur un autre devis</option>
						<option value="version multiple">version multiple</option>
						<option value="Client en réflexion">Client en réflexion</option>
						<option value="Pas de réponse client">Pas de réponse client</option>
						<option value="Pas de sous">Pas de sous</option>
						<option value="Refus catégorique">Refus catégorique</option>
						<option value="Trop cher">Trop cher</option>
						<option value="LOGEM">LOGEM</option>
						<option value="Transféré en totalité">Transféré en totalité</option>
						<option value="Transfer partiel">Transfer partiel</option>
						<option value="Refus">Refus</option>
						</select>
		</div><br>
      	<div class="form-group">
      		<label name="raison_commentaire">Commentaire :</label><br>
			<textarea type="text" class="form-control" name="raison_commentaire" rows="5" cols="33" id="raison_commentaire" required></textarea>
		</div><br>
		<input type="hidden" name="numdevis" id="numdevis" value="">
		<input type="hidden" name="client" id="client" value="">
		<input type="hidden" name="filtreaccueil" id="filtreaccueil" value="">
		<input type="hidden" name="refus" value="true">
		
      </div>
      <div class="modal-footer noprint">
        <button type="submit" id="Submit_refusJPD" class="btn btn-primary">Valider</button>
		
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
      </form>
    </div>
  </div>
</div> 
<!--------------------------- Modal POPUP Facture intermédiaire JPD -->
<div class="modal fade printable" id="exampleModalfactJPD" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header noprint">
        <h5 class="modal-title" id="exampleModalLongTitle">Facture intermédiaire JPD</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <form action="/JPD/JPD_BDCpro_accueil.php" method="post">
      <div class="modal-body">
      	<div class="form-group">
      		<label name="raison_commentaire">Montant TTC à facturer :</label><br>
			<input type="text" class="form-control" name="montantfact" id="montantfact" required>
		</div><br>
		<input type="hidden" name="numbdc" id="numbdcinter" value="">
		<input type="hidden" name="client" id="clientinter" value="">
		<input type="hidden" name="factinterJPD" value="true">
      </div>
      
      <div class="modal-footer noprint">
        <button type="submit" id="Submit_factJPD" class="btn btn-primary">Valider</button>
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
      </div>
      </form>
    </div>
  </div>
</div>  <!-- Page Wrapper -->
  <div id="wrapper">
	<!-- Sidebar -->
<ul class="navbar-nav bg-gradient-primary sidebar sidebar-dark accordion" id="accordionSidebar">
  
  <!-- Header --> 
  <a class="sidebar-brand d-flex align-items-center justify-content-center" href="../accueil.php"> 
  <!--        <div class="sidebar-brand-icon">
          <i class="fas fa-file-invoice-dollar"></i>
        </div>
-->
  <div class="sidebar-brand-text mx-3">Bioceglobe</div>
  </a>
  <hr class="sidebar-divider my-0">
  
  <!-- Vente HLC -->
  
  <li class="nav-item active"> <a class="nav-link" href="JPD_devis_accueil.php"> <i class="fas fa-fw fa-arrow-left"></i> <span>Retour JPD</span></a> </li>
  <hr class="sidebar-divider my-0">
  <!-- Nav Item - Dashboard -->
 
  <li class="nav-item active"> <a class="nav-link" href="jpddetail_stat.php"> <i class="fas fa-fw fa-tachometer-alt"></i> <span>Tableau de bord paysagerie</span></a> </li>
	
	 
  <li class="nav-item active"> <a class="nav-link" href=" jpdpro_stat.php"> <i class="fas fa-fw fa-tachometer-alt"></i> <span>Tableau de bord JPD</span></a> </li>

  <hr class="sidebar-divider my-0">
  <li class="nav-item bg-success"> <a class="nav-link collapsed text-primary" href="#" data-toggle="collapse" data-target="#collapseCollec" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol text-primary"></i><span>Collection</span></a>
    <div id="collapseCollec" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-primary py-2 collapse-inner rounded">
        <form action="/JPD/JPD_BDCpro_accueil.php?client=1022&facture=true&numbdc=3477" method="post" >
                  <div class="form-group">
                    <label for="colannee">Choisir une collection</label>
                    <select class="form-control" name="colannee" id="colannee">
                     <option value="000">Toutes les plantes</option>
					<option value="aaa">Toutes les plantes globe</option>
					<option value="22a28conf">Collections 2022 à 2028 et conf</option>
					<option value="22a28conflc">Collections 2022 à 2028 et conf et LC</option>

				<option value="28">Collection 2020 </option>
				<option value="29">Collection 2021 </option>
				<option value="40">Collection 2022 </option>
				<option value="41">Collection 2023 </option>
				<option value="42">Collection 2024 </option>
				<option value="51">Collection 2025 </option>
				<option value="52">Collection 2026 </option>
				<option value="53">Collection 2027 </option>
				<option value="54">Collection 2028 </option>
				<option value="21">Alkemade </option>
				<option value="45">Allplant </option>
				<option value="31">Bergs </option>
				<option value="43">Bloemen </option>
				<option value="5">Plantes Confidentielles </option>
				<option value="35">Fitzgerald </option>
				<option value="58">FNK </option>
				<option value="30">Collection Italie </option>
				<option value="33">Hendriksen </option>
				<option value="55">HOLUB </option>
				<option value="11">Plantes hors références... </option>
				<option value="46">IBN </option>
				<option value="57">KEBRA </option>
				<option value="47">KODER </option>
				<option value="16">Licence caché </option>
				<option value="38">Multi Pepi </option>
				<option value="6">Plantes Obsolétes </option>
				<option value="56">TRADING </option>
				<option value="37">Van Der Velden </option>
				<option value="18">Vitroflora </option>
				<option value="32">Vitrowestland </option>
                  </select>
                  </div>
                  <div class="form-group">
                    <label for="filtredition">Choisir une édition</label>
                    <select class="form-control" name="filtredition" id="filtredition">
                      <option value="">Choisir une édition</option>
							<option value="off">Pas de filtre Edition</option>
							<option value="000">Original ET Edition</option>
							<option value="aucune">Plante non renseignées</option>
							<option value="6">Edition </option>
							<option value="16">JOPO 2025 </option>
							<option value="13">JOPO 2026 </option>
							<option value="15">JOPO 2027 </option>
							<option value="11">JR 2025 </option>
							<option value="12">JR 2026 </option>
							<option value="14">JR 2027 </option>
							<option value="5">Original </option>
							<option value="7">Pocket Garden </option>
		
                    </select>
                  </div>
                  <button type="submit" class="btn btn-primary" name="changer" id="changer" value="CHANGER">CHANGER</button>
                </form>      </div>
    </div>
  </li>

  <!-- Gestion -->
  <div class="sidebar-heading"> Gestion Demandes de jeunes plants</div>
  <li class="nav-item"><a class="nav-link" href="demande_accueil.php"><i class="fas fa-fw fa-file-alt"></i><span>Demandes en attente</span></a></li>
  <li class="nav-item"> <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapsedevis" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Gestion devis</span></a>
    <div id="collapsedevis" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-success py-2 collapse-inner rounded"> <a class="collapse-item" href="JPD_devis_accueil.php"><span>Gestion Devis</span></a> 
		  <a class="collapse-item" href="DEVIS_ligne.php">Modifation en ligne Devis</a> 
		  <a class="collapse-item" href="DEVIS_Tab.php">Tableau lecture Devis</a> 
		  </div>
    </div>
  </li>
	

<!--  <li class="nav-item"> <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseresa" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Reservation</span></a>
    <div id="collapseresa" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-success py-2 collapse-inner rounded"> <a class="collapse-item" href="JPD_resa_accueil.php"><span>Gestion Reservation</span></a> <a class="collapse-item" href="RESERVATION_ligne.php">Modifation en ligne Reservation</a> <a class="collapse-item" href="RESERVATION_Tab.php">Tableau lecture Resa</a> </div>
    </div>
  </li>-->
  <li class="nav-item"> <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapsecommande" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Commande</span></a>
    <div id="collapsecommande" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-success py-2 collapse-inner rounded"> <a class="collapse-item" href="JPD_BDC_accueil.php"><span>Gestion Commande</span></a> <a class="collapse-item" href="JPD_BDCpro_accueil.php"><span>Gestion Commande pour Facture proforma/accompte</span></a> <a class="collapse-item" href="reservation_semaine_commande.php">Modifation en ligne Commandes</a> <a class="collapse-item" href="reservation_semaine_commande-export.php">Export ligne Commandes</a> <a class="collapse-item" href="COMMANDE_Tab.php">Tableau lecture Commande</a> <a class="collapse-item" href="JPD_BDC_partielle.php">Envoi commande partielle</a> <a class="collapse-item" href="COMMANDE_Plan_Tab_Log.php">Tableau Log Pro</a> </div>
    </div>
  </li>
	
  <li class="nav-item"> <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapsePrepa" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Transit et Prepa</span></a>
    <div id="collapsePrepa" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-success py-2 collapse-inner rounded"> <a class="collapse-item" href="JPD_Planprepa_accueil.php">Prepa accueil</a> <a class="collapse-item" href="JPD_Transit_accueil.php">Transit accueil</a> <a class="collapse-item" href="COMMANDE_Plan_Tab.php">Tableau lignes Prepa/Transit</a> <a class="collapse-item" href="COMMANDE_Plan_Tab_modif.php">Tableau lignes Prepa/Transit modif.</a> <a class="collapse-item" href="JPD_Planprepa_regroupement.php">Prepa Regroupement</a> <a class="collapse-item" href="JPD_Transit_regroupement.php">Transit Regroupement</a> </div>
    </div>
  </li>
  <li class="nav-item"> <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseBL" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Bon de livraison</span></a>
    <div id="collapseBL" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-success py-2 collapse-inner rounded"> <a class="collapse-item" href="JPD_BL_accueil.php">BL accueil</a> <a class="collapse-item" href="JPD_BLfact_accueil.php">Facturation BL</a> <a class="collapse-item" href="BL_Facture_Tab.php">Facturation BL lignes par lignes</a> <a class="collapse-item" href="JPD_BL_archive.php">Archive BL</a></div>
    </div>
  </li>
  <li class="nav-item"> <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapsefacture" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Facture</span></a>
    <div id="collapsefacture" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
      <div class="bg-white border-left-success py-2 collapse-inner rounded"> <a class="collapse-item" href="JPD_facture_accueil.php"><span>Gestion Factures</span></a> <a class="collapse-item" href="JPD_factureproforma_accueil.php"><span>Factures Proforma</span></a> <a class="collapse-item" href="JPD_facture_archive.php">Archive Facture</a> </div>
    </div>
  </li>
  
  <!--     <div class="sidebar-heading"> DEVIS</div>
      <li class="nav-item"><a class="nav-link" href="JPD_devis_accueil.php"><i class="fas fa-fw fa-file-alt"></i><span>Gestion Devis</span></a></li>
	 <li class="nav-item"><a class="nav-link" href="DEVIS_ligne.php"><i class="fas fa-fw fa-file-alt"></i><span>Modifation en ligne Devis</span></a></li>
		<li class="nav-item"><a class="nav-link" href="DEVIS_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau lecture Devis</span></a></li>
      <div class="sidebar-heading"> RESERVATIONS</div>
		<li class="nav-item"><a class="nav-link" href="JPD_resa_accueil.php"><i class="fas fa-fw fa-file-alt"></i><span>Gestion Resa</span></a></li>
		<li class="nav-item"><a class="nav-link" href="RESERVATION_ligne.php"><i class="fas fa-fw fa-file-alt"></i><span>Modifation en ligne Resa</span></a></li>
		<li class="nav-item"><a class="nav-link" href="RESERVATION_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau lecture Resa</span></a></li>
		<div class="sidebar-heading"> BONS DE COMMANDES</div>
	  <li class="nav-item"><a class="nav-link" href="JPD_BDC_accueil.php"><i class="fas fa-fw fa-file-alt"></i><span>Gestion BdC</span></a></li>
	  <li class="nav-item"><a class="nav-link" href="reservation_semaine_commande.php"><i class="fas fa-fw fa-file-alt"></i><span>Lignes Commandes</span></a></li>
		<li class="nav-item"><a class="nav-link" href="COMMANDE_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau lecture Commandes</span></a></li>
		<div class="sidebar-heading"> FACTURES</div>
			  <li class="nav-item"><a class="nav-link" href="JPD_facture_accueil.php"><i class="fas fa-fw fa-file-alt"></i><span>Gestion Factures</span></a></li>

      <hr class="sidebar-divider">
		
      <li class="nav-item">
          <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapsePrepa" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Prepa</span></a>
            <div id="collapsePrepa" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
              <div class="bg-white border-left-success py-2 collapse-inner rounded">
                <a class="collapse-item" href="JPD_Planprepa_accueil.php">Prepa accueil</a>
               	<a class="collapse-item" href="JPD_Transit_accueil.php">Transit accueil</a>
               	<a class="collapse-item" href="COMMANDE_Plan_Tab.php">Tableau lignes Prepa/Transit</a>
               	<a class="collapse-item" href="JPD_Planprepa_regroupement.php">Prepa Regroupement</a>
               	<a class="collapse-item" href="JPD_Transit_regroupement.php">Transit Regroupement</a>
               	
               	<a class="collapse-item" href="JPD_BL_accueil.php">BL accueil</a>
               	
               	<a class="collapse-item" href="JPD_BLfact_accueil.php">Facturation BL</a>
              </div>
            </div>
      </li>
      -->
  <div class="sidebar-heading"> Filtre Global</div>
 
  
  <li class="nav-item"><a class="nav-link" href="COMPLET_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau complet lecture</span></a></li>
  <li class="nav-item"><a class="nav-link" href="COMPLET_Tab_autorisation_vente.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau controle autorisation vente</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="COMPLET_Tab_modif.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau complet modif.</span></a></li>
  <li class="nav-item"><a class="nav-link" href="Stat_client_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau Stats Vente Client</span></a></li>
  <li class="nav-item"><a class="nav-link" href="Stat_fournisseur_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau Stats Achat Fournisseur</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="Stat_client_TabV2.php"><i class="fas fa-fw fa-file-alt"></i><span>Stats Vente Client Compil</span></a></li>
  <li class="nav-item"><a class="nav-link" href="Stat_fournisseur_TabV2.php"><i class="fas fa-fw fa-file-alt"></i><span>Stats Achat Fournisseur Compil</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="Stat_plante_TabV2.php"><i class="fas fa-fw fa-file-alt"></i><span>Stats Vente Plante Compil</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="Stat_plante_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau Stats Vente plante</span></a></li>
  <li class="nav-item"><a class="nav-link" href="Facture_Fournisseur_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau controle Facture</span></a></li>
  <li class="nav-item"><a class="nav-link" href="Transport_Controle_Tab.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau controle Transport</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="JPD_stats_paysagerie.php"><i class="fas fa-fw fa-file-alt"></i><span>Stats facture Paysagerie/mois</span></a></li>
  
  <div class="sidebar-heading"> Prévisionnel</div>
  <li class="nav-item"><a class="nav-link" href="pro_prevision_TAB.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau pro</span></a></li>
  <li class="nav-item"><a class="nav-link" href="pro_prevision_TAB_Etranger.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau pro Etranger</span></a></li>
  <div class="sidebar-heading">Gestion des rolls</div>
<li class="nav-item"><a class="nav-link" href="JPD_BL_modif_TAB.php"><i class="fas fa-fw fa-file-alt"></i><span> Modif. infos rolls BL</span></a></li>
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_confirmation.php"><i class="fas fa-fw fa-file-alt"></i><span> Conf. infos rolls BL</span></a></li>
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_confirmation_modif.php"><i class="fas fa-fw fa-file-alt"></i><span>Modif. Conf. infos rolls BL</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="JPD_Retour.php"><i class="fas fa-fw fa-file-alt"></i><span>Mouvement des rolls</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_lecture.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau récap des rolls</span></a></li>
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_lecture_etranger.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau récap des rolls Etranger</span></a></li>
  
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_Etranger.php"><i class="fas fa-fw fa-file-alt"></i><span>Gestion rolls étrangers</span></a></li>
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_stock.php"><i class="fas fa-fw fa-file-alt"></i><span>Stock rolls MP/JPD</span></a></li>
  <li class="nav-item"><a class="nav-link" href="JPD_Rolls_producteur.php"><i class="fas fa-fw fa-file-alt"></i><span>Tableau échange producteur en direct</span></a></li>
  <!-- Archives --> 
  <!--      
      <li class="nav-item">
          <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseFact" aria-expanded="true" aria-controls="collapseOne"><i class="fas fa-fw fa-list-ol"></i><span>Archives</span></a>
            <div id="collapseFact" class="collapse" aria-labelledby="headingOne" data-parent="#accordionSidebar">
              <div class="bg-white border-left-success py-2 collapse-inner rounded">
                <a class="collapse-item" href="JPD_facture_archive.php">Archive Facture</a>
               
              </div>
            </div>
      </li>-->
  
  <hr class="sidebar-divider d-none d-md-block">
  
  <!-- Sidebar Toggler (Sidebar) -->
  <div class="text-center d-none d-md-inline">
    <button class="rounded-circle border-0" id="sidebarToggle"></button>
  </div>
</ul>
<!---------------------------------------------------------- End of Sidebar ------------------------------------------------------------> 
 
    <!-- Content Wrapper -->
    <div id="content-wrapper" class="d-flex flex-column">

      <!-- Main Content -->
      <div id="content">

        <!-- Topbar -->
<nav class="navbar navbar-expand navbar-light bg-white topbar sticky-top mb-4 shadow"> 
  
  <!-- Sidebar Toggle (Topbar) -->
  <button id="sidebarToggleTop" class="btn btn-link rounded-circle mr-3"> <i class="fa fa-bars"></i> </button>
  <div class="btn-group">
    <button type="button" class="text-primary btn btn-success dropdown-toggle font-weight-bold" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> <i class="fa fa-bars"></i> Menu principal </button>
    <div class="dropdown-menu shadow animated--grow-in text-uppercase font-weight-bold">
		<div class="bg-success"> <p class="text-white text-center my-1">Raccourci </p></div>
		
      		
      		
      		
		
      		
       <a class="dropdown-item font-weight-bold menu-principal" href="/gestion/RH/">Ressources </a> 		
				
		 		
  <!--    <div class="dropdown-divider border-bottom-success"></div>-->
		
		<div class="bg-success "> <p class="text-white text-center my-1 ">Entreprise </p></div>
		
      		
		
		     		
		
           
      		
      		
      		
      
    
    </div>
  </div>
  <ul class="navbar-nav ml-auto">
    <li class="nav-item dropdown no-arrow"><span class="mr-2 d-none d-lg-inline text-gray-600 small">filtre sur les plantes : Collection 2024</span></li>
    <!-- Nav Item - User Information -->
  </ul>
  <!-- Topbar Navbar -->
  <ul class="navbar-nav ml-auto">
    <!-- Nav Item - User Information -->
    <li class="nav-item dropdown no-arrow"> <a class="nav-link dropdown-toggle" href="#" id="userDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> <span class="mr-2 d-none d-lg-inline text-gray-600 small">
              </span> <img class="img-profile rounded-circle" src="https://globe-planter.com/gestion/img/logo_GP-coul200.svg"> </a> 
      <!-- Dropdown - User Information -->
      <div class="dropdown-menu dropdown-menu-right shadow animated--grow-in" aria-labelledby="userDropdown"> <a class="dropdown-item" href="#" data-toggle="modal" data-target="#logoutModal"> <i class="fas fa-sign-out-alt fa-sm fa-fw mr-2 text-gray-400"></i> Déconnexion </a> </div>
    </li>
  </ul>
</nav>
<!-- End of Topbar -->
        <!-- Begin Page Content -->
        <div class="container-fluid">
        <div class="card shadow mb-4">
              <div class="card-header py-3 bg-white"> 
          <!-- Page Heading -->
          <div class="d-sm-flex align-items-center justify-content-between mb-4">
            <h1 class="text-gray-900">Commercialisation JPD</h1>
          </div>
            
          <!-- Page Heading -->
          <div class="d-sm-flex align-items-center justify-content-between mb-4">
            <h3 class="text-gray-900">Gestion des Commandes</h3>
          </div>
</div>
</div>
                       
          <!-- /.card -->
            
          <div class="card shadow mb-4">
            <div class="card-header py-3 bg-white">
              	<h5 class="m-0 text-primary"><strong>Commandes</strong> - Total Chiffre d'affaire en attente : 1894.64 € <sup>ht</sup></h5>
              	<p>
				<a href="/JPD/JPD_BDCpro_accueil.php?filtreaccueil=listearchive">Archive des Bdc valid&eacute;s </a> - 

				<a href="/JPD/JPD_BDCpro_accueil.php?filtreaccueil=listerefus">Archive des Bdc refus&eacute;s</a> - 

				<a href="/JPD/JPD_BDCpro_accueil.php?filtreaccueil=">Les Bdc en cours</a>

				</p>
            </div>

            <div class="card-body">
              <div class="table-responsive">
                <table class="table table-bordered" id="example" width="100%" cellspacing="0">
                  <thead>
                    <tr>
                      <th>N° Bdc</th>
                      <th>Client</th>
                      <th>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Titre&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
                      <th>Date</th>
                      <th>Montant HT</th>
                      <!-- 
                      <th>BDC HT</th>
                      <th>BDC TTC</th> -->
                      <th>BDC Pro</th>
                      <th>BDC Fournisseur</th>
                      <th>Supprimer</th>
                      <th>Remonter</th>
                      <th>Proforma</th>
                      <th>Accompte</th>
                      <th>Facture</th>
                    </tr>
                  </thead>
                  <tbody>
                    

  				<tr class="bg-danger text-white">

    				<td>
    				<a href="BDCpro_modif.php?client=2476&numcommande=3558" class="text-white btn-icon-split">
                          <span class="text">BDCJPD223558</span><span class="icon bg-warning rounded text-white-50"><i class="fas fa-pen"></i></span>
                          </a>
    				</td>

    				<td>IBORRA-C</td>
    				

    				<td><p>Fourniture projet</p><p>Modifs effectuées</p></td>

    				<td>24/02/2022</td>

    				<td class="text-right">1894.64 € HT</td>
    				<!-- 
    				<td class="text-center">
						<a href="JPD_BDC_impression.php?client=2476&numboncommande=3558&pageurl=0" class="btn btn-success btn-icon-split btn-sm">
                          <span class="icon text-white-50"><i class="fas fa-print"></i></span>
                          <span class="text">HT</span></a>
                          </td>
                      <td><a href="JPD_BDC_impression.php?printTVA=TTC&client=2476&numboncommande=3558&pageurl=0" class="btn btn-success btn-icon-split btn-sm">
                          <span class="icon text-white-50"><i class="fas fa-print"></i></span>
                          <span class="text">TTC</span></a></td>-->
                      <td><a href="JPD_BDC_impressiondetail.php?client=2476&numboncommande=3558&pageurl=0" class="btn btn-success btn-icon-split btn-sm">
                          <span class="icon text-white-50"><i class="fas fa-print"></i></span>
                          <span class="text">Pro</span></a></td>
                      <td>                      </td>
                      <td>                          </td>
                      <td>                          </td>
                      
                      <td>                          </td>
    				  <td>    				  <button data-client="2476" data-numbdc="3558" class="factinterJPD btn btn-success btn-icon-split btn-sm mb-2">
                          <span class="icon text-white-50"><i class="fas fa-check"></i></span>
                          <span class="text">Créer facture intermédiaire</span></button>
                                                                    <a href="JPD_facture_impression.php?client=2476&numfacture=JPD2200053&pageurl=3" class="btn btn-success btn-icon-split btn-sm mb-2">
                          <span class="icon text-white-50"><i class="fas fa-print"></i></span>
                          <span class="text">JPD2200053</span></a>
                                                                    </td>
                      <td><a href="/JPD/JPD_BDCpro_accueil.php?client=2476&numbdc=3558&facture=true" onclick="if (window.confirm('Vous &ecirc;tes sur le point de faire la facture finale') ) { return true; }  else { return false; }" class="btn btn-success btn-icon-split btn-sm">
                          <span class="icon text-white-50"><i class="fas fa-check"></i></span>
                          <span class="text">Créer facture finale</span></a>
                                                    </td>
   				 </tr>


                  </tbody>
                </table>
              </div>
            </div>
          </div>
      
        </div>
        <!-- /.container-fluid -->

      </div>
      <!-- End of Main Content -->

      <!-- Footer -->
<footer class="sticky-footer bg-white">
        <div class="container my-auto">
          <div class="copyright text-center my-auto">
            <span>Copyright &copy; Bioceglobe 2019</span>
          </div>
        </div>
      </footer>
      <!-- End of Footer -->

    </div>
    <!-- End of Content Wrapper -->

  </div>
  <!-- End of Page Wrapper -->

  <!-- Scroll to Top Button-->
  <a class="scroll-to-top rounded" href="#page-top">
    <i class="fas fa-angle-up"></i>
  </a>

  <!-- Logout Modal-->
  <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="exampleModalLabel">Déconnexion</h5>
          <button class="close" type="button" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">×</span>
          </button>
        </div>
        <div class="modal-body">Cliquez sur "Déconnexion" pour quitter la sessions.</div>
        <div class="modal-footer">
          <button class="btn btn-secondary" type="button" data-dismiss="modal">Annuler</button>
          
          <a class="btn btn-success" href="/JPD/JPD_BDCpro_accueil.php?deconecte=ok">Déconnexion</a>
        </div>
      </div>
    </div>
  </div>
        
  <!-- Bootstrap core JavaScript-->
  <script src="../vendor/jquery/jquery.min.js"></script>
  <script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

  <!-- Core plugin JavaScript-->
  <script src="../vendor/jquery-easing/jquery.easing.min.js"></script>

  <!-- Custom scripts for all pages-->
  <script src="../js/sb-admin-2.min.js"></script>

  <!-- Page level plugins -->
  <script src="../vendor/chart.js/Chart.min.js"></script>
  <!-- <script src="vendor/datatables/jquery.dataTables.min.js"></script> A voir -->
  <script type="text/javascript" src="../vendor/DataTablesBase/datatables.min.js"></script>   
  
  <script type="text/javascript" src="../lib/chosen_v1.8.5/chosen.jquery.js"></script>
  <script src="../lib/chosen_v1.8.5/docsupport/init.js" type="text/javascript" charset="utf-8"></script>

  <!-- Page level custom scripts -->
  <script src="../js/demo/chart-area-demo.js"></script>
  <script src="../js/demo/datatables-demo.js"></script>
<script>
if ($(window).width() < 1300) {
	  $(".sidebar").addClass("toggled");
      $('.sidebar .collapse').collapse('hide');
    };
    </script>		
		<script>
$( document ).ready(function() {
	$('#example').DataTable( {
		order: [[ 0, "desc" ]],
        paging: false,
        scrollX: true,
		scrollY: "50vh",
        dom: 'Bfrtip',
        buttons: [
            'colvis', 'csv', 'excel', 'print',
			{
            text: 'Effacer les filtres',
            action: function ( e, dt, node, config ) {
				dt.search('').draw();
            }
		}	
        ]
    } );
});
</script>
<script>
$(document).ready(function(){
	
	$('.factinterJPD').click(function(){
		var numbdc= $(this).data("numbdc");
		var client= $(this).data("client");
		$('#montantfact').val('');
		$('#numbdcinter').val(numbdc);
		$('#clientinter').val(client);
		$('#exampleModalfactJPD').modal('show');
	});
});
	
</script>
      
</body>

</html>