<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>Liste commande express</title>
      	<script src="js/jquery-3.3.1.min.js"></script>
     <link rel="stylesheet" href="css/bootstrap.css" media="all" />
      <script src="js/bootstrap.min.js"></script>
     <link rel="stylesheet" href="css/font-awesome.min.css">
  </head>
  <body>
      	
	<script src="/js/jquery.redirect.js"></script>
  
 
          <main>
    <div class="container">
        <br>
         <h1>Liste des commandes inférieures à 5 000 €.<br></h1> <div style='float: left'><a href="index.html"> ACCUEIL</a></div>
             <div style="float: left;"> </div>
             
            
            </div>
            
            
          
   
        
        
    <br>
			
       
<?php
			
       
			

// on se connecte à notre base pour devis

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

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
								
$sql = "SELECT * FROM tete WHERE ( etat='1' OR etat='1' ) order by commande ASC";
 //print "<br>".$sql;	
	 
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
   // print "resultats";
    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"];
$MONTANTHTVA=$row["montant"];
$commande=$row["commande"];
$commande = new DateTime($commande);
		
		// *********************    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();
       $MONTANTHTVA=str_replace(' ', '', $MONTANTHTVA);	
      //  print intval($MONTANTHTVA)."<br>";
    //    print $MONTANTHTVA."<br>";
        
        if (intval($MONTANTHTVA)<=5000) {
									
   	  $directory = "photos/".$tempnom1."/tmb/";
        $files = scandir ($directory);
        $firstFile = $directory . $files[2];// because [0] = "." [1] = ".." 
        $supported_file = array('jpg','png','jpeg');
 
        $ext = strtolower(pathinfo($firstFile, PATHINFO_EXTENSION));
        if (in_array($ext, $supported_file)) {
            
            $firstFile = $directory . $files[2];
            }else{
            $firstFile = $directory . $files[3];}
        
      print"  <div class='container'>";
        print"<div class='card'>";
        print"<div class='card-body'>";
        
              
        print "<div style='float:right;'>" ;
        print"<div style='height:150px;width:150px;background-color:#dedddd;float:right;background-image:url(&quot;".$firstFile."&quot;);'>";
        print "<form method='post' action='picviewcar.php' name='demande'>";
        print "<button class='btn btn-dark fa fa-image rounded-0' name='dnumdevis' type='submit' value='". $tempnom1."'></button>";
     	print "</form>";
        print "</div>" ;
         print" <p>Montant : ".$MONTANTHTVA."</p>";
         print "</div>" ;
        
       print " <div style='float:left;width:80%;'>";
            print"(commande du ".date_format($commande, 'd-m-Y').") <h4>Devis : ". $NUM."</h4>";
            print"<h6 class='text-muted mb-2'>".$tempsoc."  ".$tempnom1." </h6>";
        print" <p>". $OBJET. " <br> ".$DATE."</p>";
        
     
         print "<div style='float:left;'><form method='post' action='texteditcomprepa.php' name='demande'>";
        print "<button class='btn btn-info' name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Préparation chantier.</button></form></div>";
           print "<div style='float:right;'><form method='post' action='texteditcom.php' name='demande'>";
        print "<button class='btn btn-info' name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Vers commande.</button></form></div>";
        
        print"</div>";
        print"</div>";
        print"<div class='card-footer'></div>";
        print"</div>";
        print"</div>";
        
        
    } 
     } // fin IF > à somme
	
	} else {
 //print "resultats 2";
  
									
									
		
		
            
		 

    } 
    
    
    
    
    
    
    
    





$conn->close();
		

		?>	 
     

			     
     
    </main>
    
  </body>
</html>
