<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>Attribution commande</title>
<!--    <link rel="stylesheet" href="stylecli.css" media="all" /> -->
      	<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="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  </head>
  <body >
    
    </header>
    <main>
    
		
   
			
<?php
			
       
            // *********************    connection clients pour recherche le nom*************************
		
								$servername1n = "localhost:8889";
								$username1n = "root";
								$password1n = "root";
								$dbname1n = "Clients";

								// Create connection
								$conn1n = new mysqli($servername1n, $username1n, $password1n, $dbname1n);
								// Check connection
								if ($conn1n->connect_error) {
								die("Connection failed: " . $conn1n->connect_error);
								} 

			
								$sql1 =  "SELECT * FROM data WHERE nom1 LIKE '%".$_POST['client']."%' OR societe LIKE '%".$_POST['client']."%' LIMIT 5";
								//print "<br>".$sql1;	
		 
								$result1n = $conn1n->query($sql1);
		
								if ($result1n->num_rows > 0) {
    							// output data of each row
								while($row1n = $result1n->fetch_assoc()) {
								//print "echo <br>".$row1['societe']."  ".$row1['nom1'];
									$tempsoc=$row1n['societe'];
									$tempnom1=$row1n['nom1'];
                                    $IDXCLISEARCH=$row1n['id'];
							
            
            
            


// 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='0' AND idxcli='". $IDXCLISEARCH."' ";
	 //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"];
		
		// *********************    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();
									
									
		
		  $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='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 " <div style='float:left;width:80%;'>";
            print"    <h4>Devis : ". $NUM."</h4>";
            print"<h6 class='text-muted mb-2'>".$tempsoc."  ".$tempnom1." ".$row1['nom1']."</h6>";
        print" <p>". $OBJET. " <br> ".$DATE."</p>";
         print "<form method='post' action='texteditcom.php' name='demande'>";
        print "<button class='btn btn-info' name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Valider commande</button></form>";
        
        print"</div>";
        print"</div>";
        print"<div class='card-footer'></div>";
        print"</div>";
        print"</div>";
        
        
            
		//    print "<tr>";
        //    print " <td class='no'>". $NUM."</td>";
         
		//    print "<form method='post' action='texteditcom.php' name='demande'>";
		//    print "<td class='desc'><button name='dnumdevis' id='liensubmit' type='submit' value='". $IDX."'>".$tempsoc."  ".$tempnom1." ".$row1['nom1']."<br> ". $OBJET. " <br> ".$DATE."</button></td>";print "</form>";
		
		//    print "<form method='post' action='texteditcom.php' name='demande'>";
        //    print "<td class='unit'><button name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Suivant</button></td>";
		
		//	print "</form>";
        //
          //  print "</tr>";

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




$conn->close();
            
            
            
            
          		    } 
    
	
									} else {
										// echo "0 results";
									}




$conn1n->close();
									
              
            
		

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