<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>Liste offres</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 offres<br></h1></div>
        <form action="index.html">
               <input class="form-control" id="btst" type="submit" value="HOME" />
	            </form>
        </div>
   
      </div>
		
		
      <table border="0" cellspacing="0" cellpadding="0">
        <thead>
          <tr>
            <th class="no">#</th>
            <th class="desc">DESCRIPTION    
				  <form method = "post" action = "<?php $_PHP_SELF ?>">
			  -Tous
  <input type="radio" checked="checked" name="radiot" value="0">
  <br>				
-Brouillon
  <input type="radio"  name="radiot" value="1">
  <br>

-Offre terminée
  <input type="radio" name="radiot" value="2">
  <br>
  
<br><br>
					  <?php
				$descradiot = array(1 => '4',2 => '0', 0=>'Tous');
						$descradiot2 = array(1 => 'Brouillon',2 => 'Terminée', 0=>'Tous');
									 
					   
				 if(isset($_POST['radiot'])) {	
	 
					 $positionradiot=intval($_POST['radiot']);
					 
					print"<h3 >DESCRIPTION :</h3> <h1>" .$descradiot2[$positionradiot]."</h1> <br>";
	
				 
				 
				 } else {
										
									
					 print"DESCRIPTION<br>";
	
		 }
				?>
					  

			  </th>
            <th class="unit">       					  
			  <?php
				 if(isset($_POST['update'])) {	
	 
	print"<input id='liensubmit2' name = 'update' type = 'submit' value = 'Go'><br>";
	 } else {
										
									
print"<input id='liensubmit2' name = 'update' type = 'submit' value = 'Go'><br>";
	// print "<br>".$sql;	
		 }
				?></form>                   </th>
          
         
        </thead>
		  
		  
        <tbody>
			
<?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);
} 

	
	 if(isset($_POST['update'])) {
		 $sql = "SELECT * FROM tete WHERE ";
		 
		 
	 		if($descradiot[$positionradiot]=='Tous') {	
				$sqltype = " etat='0' OR etat='4' " ;
				 } else {
 				$sqltype = " etat='".$descradiot[$positionradiot]."' " ;
				}

		 	

		 $sql=$sql.$sqltype;
		 
		// print $sql.'<br>';
	 } else {
										
									
$sql = "SELECT * FROM tete WHERE etat='0' OR etat='4' ";
	// 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();
									
									
		
		
            
		    print "<tr>";
            print " <td class='no'>". $NUM."</td>";
           // print " <td class='desc'><h3>".$tempsoc."  ".$tempnom1." ".$row1['nom1']."<br> ". $OBJET. " du ".$DATE."</h3>";
		    print "<form method='post' action='textedit.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='clientaf2.php' name='demande'>";
		    print "<form method='post' action='textedit.php' name='demande'>";
            print "<td class='unit'><button name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Offre chiffrée</button>";
			print "</form>";
            print "<form method='post' action='texteditconcat.php' name='demande'>";
            print "<br><button name='dnumdevis' id='liensubmit2' type='submit' value='". $IDX."'>Offre complète</button></td>";
			print "</form>";
        
            print "</tr>";

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




$conn->close();
		

		?>	
			
     
        </tbody>
        
      </table>
     
      <div id="notices">
        <div><br>&nbsp;<br>
          
          <form action="index.html">
               <input class="form-control" id="btst" type="submit" value="HOME" />
	            </form>
          </div>
        <div class="notice"><br>&nbsp; <br></div>
      </div>
    </main>
  
  </body>
</html>