1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
| <div id="octogonal" style="display:none" >
<table border=0>
<tr align="center">
<th></th>
<th></th>
<th bgcolor=#b3b3b3><font size=2>diamètre revêtement snd</font></th >
<th bgcolor=#b3b3b3><font size=2>diamètre revêtement primaire</font></th >
<th bgcolor=#b3b3b3><font size=2>excentricité fibre/snd</font></th >
<th bgcolor=#b3b3b3><font size=2>excentricité fibre/prim</font></th >
<th bgcolor=#b3b3b3><font size=2>diamètre grand axe</font></th>
<th bgcolor=#b3b3b3><font size=2>diamètre petit axe</font></th>
<th bgcolor=#b3b3b3><font size=2>excentricité coeur/gaine</font></th>
<th bgcolor=#b3b3b3><font size=2>OK/NOK</font></th>
<th></th>
<tr>
<?php
include('bdd/connection.php');
$disabled = ' disabled';
if($_SESSION['baseFibre'] >= 2) $disabled = '';
if(isset($_POST['valider'])) {
if($_POST['valider'] == "edit") modifmesureOctogonal();
}
$precpointA = '';
$cmp = 0;
$query = 'SELECT `no_tambour`, `no_carac`, `pointA`, `pointB` FROM `caracterisation`';
$query .= ' WHERE `label_banc`=\''.$_SESSION['label_banc'].'\'';
$query .= ' AND `numeropref`=\''.$_SESSION['numeropref'].'\'';
$query .= ' AND `morceau_val`=\''.$_SESSION['morceau_val'].'\'';
$query .= ' AND `morceau_fib`=\''.$_SESSION['morceau_fib'].'\'';
if($_SESSION['no_tambour'] != "tous") $query .= ' AND `no_tambour`=\''.$_SESSION['no_tambour'].'\'';
$query .= ' ORDER BY `no_tambour`, `indexcarac`';
$resultat = mysql_query($query, $id_link);
// echo '<br>'.$query.'<br>';
while($rang = mysql_fetch_array($resultat))
{
$no_tambour = $rang['no_tambour'];
$no_carac = $rang['no_carac'];
$pointA = $rang['pointA'];
$pointB = $rang['pointB'];
$query = 'SELECT `mgeocpr`, `diametrerevetsnd`, `diametrerevetp`, `excentricitefibre_snd`, `excentricitefibre_p`, `diametregdaxe`, `diametrepttaxe`, `excentricitecoeur_gaine`,`OKNOK`';
$query .= ' FROM `point` WHERE `id_point`=\''.$pointB.'\' ';//and label_type="Octogonal"
$res = mysql_query($query, $id_link);
while($rang = mysql_fetch_array($res))
{
// echo '<tr><td colspan=5><b>'.$no_tambour.' '.$no_carac.'</b> point B : '.$rang['mgeocpr'].'</td></tr>';
if($rang['mgeocpr'] == 1)
{
if($pointB != $precpointA) {
$diametrerevetsnd = $rang['diametrerevetsnd'];
$diametrerevetp = $rang['diametrerevetp'];
$excentricitefibre_snd = $rang['excentricitefibre_snd'];
$excentricitefibre_p = $rang['excentricitefibre_p'];
$diametregdaxe = $rang['diametregdaxe'];
$diametrepttaxe = $rang['diametrepttaxe'];
$excentricitecoeur_gaine = $rang['excentricitecoeur_gaine'];
$OKNOK=$rang['OKNOK'];
echo '<tr align="center" onmouseover="this.style.backgroundColor=\'grey\';" onmouseout="this.style.backgroundColor=\'white\';">
<td><b><a href="C010R00A-G-x20.jpg" class="img" rel="lightbox[roadtrip]">'.$no_tambour.$no_carac.'B<span><img src="C020R00B-N-x50-1.jpg" width="200" height="200" border="4" /></span></a></b></td>';
echo '<form action="index.php?etat=5&page=6" method="post">';
if($_SESSION['baseFibre'] >= 2) {
echo '<input type="hidden" name="id_point" value="'.$pointB.'">
<td><button type="submit" name="valider" value="edit" style="background:white; cursor:hand; border:none"><img src=image/bouton/edit.png></button></td>';
}
echo '<td><input'.$disabled.' type="text" size=7 name="diametrerevetsnd" value="'.$diametrerevetsnd.'"></td>
<td><input'.$disabled.' type="text" size=7 name="diametrerevetp" value="'.$diametrerevetp.'"></td>
<td><input'.$disabled.' type="text" size=7 name="excentricitefibre_snd" value="'.$excentricitefibre_snd.'"></td>
<td><input'.$disabled.' type="text" size=7 name="excentricitefibre_p" value="'.$excentricitefibre_p.'"></td>
<td><input'.$disabled.' type="text" size=7 name="diametregdaxe" value="'.$diametregdaxe.'"></td>
<td><input'.$disabled.' type="text" size=7 name="diametrepttaxe" value="'.$diametrepttaxe.'"></td>
<td><input'.$disabled.' type="text" size=7 name="excentricitecoeur_gaine" value="'.$excentricitecoeur_gaine.'"></td>
<td><select name="OKNOK" ><option value='.$OKNOK.'></select></td>
<td><input type="checkbox" name="selection" value=""></td>
</form></tr>';
}
}
} |
Partager