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
|
<?php
//Include the database configuration file
include 'dbConfig.php';
if(!empty($_POST['line_id'])){
//Fetch all data
$query_toolinfo = "SELECT * FROM gmao.idtools WHERE gmao.idtools.ID = ".$_POST['tool_id']." ";
$query_toolinfo_result = $db->query($query_toolinfo);
/* Tableau associatif */
$query_toolinfo_result_row = $query_toolinfo_result->fetch_array(MYSQLI_ASSOC);
//echo $query_toolinfo_result_row['Prefix'], " | ", $query_toolinfo_result_row['QRTool'], " | ", $query_toolinfo_result_row['ID_tooltype'];
/* Récupération des cellules en fonction de la ligne sélectionnée */
$Query_cells = $db->query("SELECT distinct(ID_cell), lines.ID, Cellnumber, Cellname FROM gmao.location, gmao.lines, gmao.cells
WHERE
gmao.location.ID_tool='".$query_toolinfo_result_row['ID_tooltype']."'
AND
gmao.cells.ID=gmao.location.ID_cell
AND
gmao.lines.ID=gmao.cells.ID_line
AND
gmao.lines.ID= '".$_POST['line_id']."'");
//Count total number of rows
$Query_cells_rowCount = $Query_cells->num_rows;
if($Query_cells_rowCount > 0){
echo '<option value="">Sélectionnez la cellule</option>';
while($Query_cells_row = $Query_cells->fetch_assoc()){
echo '<option value="'.$Query_cells_row['ID_cell'].'">'.$Query_cells_row['Cellnumber'].' - '.$Query_cells_row['Cellname'].'</option>';
}
}else{
echo '<option value="cellule_default">Cellule non disponible</option>';
}
}elseif(!empty($_POST['cell_id'])){
/*Emplacement sur station*/
$Query_location = $db->query("SELECT ID_cell, lines.ID, location, location_add FROM gmao.location, gmao.lines, gmao.cells
WHERE
gmao.location.ID_tool='".$_POST['tooltype_id']."'
AND
gmao.cells.ID=gmao.location.ID_cell
AND
gmao.lines.ID=gmao.cells.ID_line
AND
gmao.lines.ID='".$_POST['line_idx']."'
AND
gmao.cells.ID='".$_POST['cell_idx']."'");
//Count total number of rows
$Query_location_rowCount = $Query_location->num_rows;
if($Query_location_rowCount > 0){
echo '<option value="">Sélectionnez un emplacement</option>';
while($Query_location_row = $Query_location->fetch_assoc()){
echo '<option value="'.$Query_location_row['location'].' '.$Query_location_row['location_add'].'">'.$Query_location_row['location'].' '.$Query_location_row['location_add'].'</option>';
}
}else{
echo '<option value="cellule_default">Emplacement non disponible</option>';
}}
?> |