<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>Liste des commandes</title>
	
    <link rel="stylesheet" href="stylecli.css" media="all" />
  </head>
  <body >
    
    </header>
    <main>
      <div id="details" class="clearfix">
        <div id="client">
          <div class="to"><h1><br>
          Liste des factures<br></h1></div>
          <h2 class="name"></h2>
          <div class="address"></div>
          <div class="email"></div>
        </div>
        <div id="invoice">
          <h1></h1>
          <div class="date"></div>
          <div class="date"></div>
        </div>
      </div>
		
		
      <table border="0" cellspacing="0" cellpadding="0">
        <thead>
          <tr>
			  
			              <th class="no">####</th>
			  
			 
              <th class="desc">
				
				

				
			
				
				
	
	</th>
			  
<th>
				
				
	
	</th>
            <th class="unit"></th>
       
          </tr>
        </thead>
		  
		  
        <tbody>
			
<?php
			
       


// on se connecte à notre base pour facture

$servername = "localhost:8889";
$username = "root";
$password = "root";
$dbname = "facture";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

	 if(isset($_POST['update'])) {
		 $sql = "SELECT * FROM tete WHERE ";
		 
		 
	 		

		 	if($positionradio==0) {	
				$sqletat = " etat>0 ";
				 } else {
 				$sqletat = " etat='".$positionradio."' ";
				}

		 $sql=$sql.$sqletat;
		 
		 print $sql.'<br>';
	 } else {
										
									
$sql = "SELECT * FROM tete WHERE etat>='0'";
	// print "<br>".$sql;	
		 }

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
				
		$NUM=$row["num"];
$IDX=$row["idx"];
$DATE=$row["date"];
$OBJET=$row["objet"];
$IDXCLI=$row["idxcli"];
$MEMO=$row["memo"];
$NumeroIdxClient=$row["idxcli"];;
$CHANTIER=$row["chantier"];
$TVA=$row["tva"];
$BANQUE=$row["banque"];
$REMARQUE=$row["remarque"];
$ETATC=$row["etat"];
$MONTANTHTVA=$row["montant"];
$VRAIIDXDEVIS=$row["idxdevis"];
		
		// *********************    connection clients *************************
		
								$servername1 = "localhost:8889";
								$username1 = "root";
								$password1 = "root";
								$dbname1 = "Clients";

								// Create connection
								$conn1 = new mysqli($servername1, $username1, $password1, $dbname1);
								// Check connection
								if ($conn1->connect_error) {
								die("Connection failed: " . $conn1->connect_error);
								} 

			
								$sql1 = "SELECT * FROM data WHERE id=".$NumeroIdxClient." ";
								//print "<br>".$sql1;	
		 
								$result1 = $conn1->query($sql1);
		
								if ($result1->num_rows > 0) {
    							// output data of each row
								while($row1 = $result1->fetch_assoc()) {
								//print "echo <br>".$row1['societe']."  ".$row1['nom1'];
									$tempsoc=$row1['societe'];
									$tempnom1=$row1['nom1'];
									    } 
    
	
									} else {
										// echo "0 results";
									}




$conn1->close();
									
					// *********************    connection clients *************************
		
								$servername1 = "localhost:8889";
								$username1 = "root";
								$password1 = "root";
								$dbname1 = "devis";

								// Create connection
								$conn1 = new mysqli($servername1, $username1, $password1, $dbname1);
								// Check connection
								if ($conn1->connect_error) {
								die("Connection failed: " . $conn1->connect_error);
								} 

			
								$sql1 = "SELECT num,montant FROM tete WHERE idx=".$VRAIIDXDEVIS." ";
								//print "<br>".$sql1;	
		 
								$result1 = $conn1->query($sql1);
		
								if ($result1->num_rows > 0) {
    							// output data of each row
								while($row1 = $result1->fetch_assoc()) {
								//print "echo <br>".$row1['societe']."  ".$row1['nom1'];
									$NUMEROSDEREFDEVIS=$row1['num'];
									$MONTANTDEREFDEVIS=$row1['montant'];
								
									    } 
    
	
									} else {
										// echo "0 results";
									}




$conn1->close();						
		
		
            
		    print "<tr>";
            print " <td class='no' style='font-size: 20px'  >". $NUM."</td>";
            print "<form method='post' action='texteditfac.php' name='demande'>";
		    print "<td  class='desc'><button name='dnumdevis' id='liensubmit' type='submit' value='". $IDX."'>".$tempsoc."  ".$tempnom1." ".$row1['nom1']."<p style='font-size:14px'>". $OBJET. " </p><p style='font-size:12px'> ".$DATE."</p></button>";print "</form>";
		
		print"<h4>";
		 print "<form method='post' action='textedit.php' name='demande'>";
		    print "<button name='dnumdevis' id='liensubmit' type='submit' value='". $VRAIIDXDEVIS."'>Devis N° : ".$NUMEROSDEREFDEVIS." de ".$MONTANTDEREFDEVIS."<br></button>";
			print "</form>";
		
		 
  
        echo "</td>";
   
				  print"</h4>";
				  

		//print "<form method='post' action='clientaf2.php' name='demande'>";
		    print "<form method='post' action='texteditfac.php' name='demande'><th class='desc'> Montant facture HTVA <p style='font-size:14px'>".$MONTANTHTVA."</p></th>";
            print "<td class='unit'><button name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Facture</button>";
			print "</form>";
            print "<form method='post' action='texteditfacconcat.php' name='demande'>";
            print "<br><button name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Facture + Docs</button></td>";
			print "</form>";
        
            print "</tr>";

    } 
    
	
	} else {
   // echo "0 results";
}




$conn->close();
		

		?>	
			
     
        </tbody>
        
      </table>
     
      <div id="notices">
        <div><br>&nbsp;<br> </div>
        <div class="notice"><br>&nbsp; --<br></div>
      </div>
    </main>
  
  </body>
</html>