query("SELECT DISTINCT `Type` FROM `save_data` sd INNER JOIN (SELECT `Num_i` FROM `info` WHERE `Prib_id` = $id ORDER BY `Num_i` DESC LIMIT 1) inf ON inf.Num_i = sd.Num WHERE (`Type` NOT LIKE 'system_%') AND (`Type` NOT LIKE '%addr')"); if(mysqli_num_rows($result)) { while($row = mysqli_fetch_array($result)) { $buff[] = array('title'=>$row['Type']); } $away = array('back'=>'success','sens'=>$buff); } else { $away = array('back'=>'error'); } print json_encode($away); } /* получение списка устройств */ if(isset($_GET['unitslist'])) { $result = $mysqli->query("SELECT uNum,uName,Serial FROM units_list"); while($rows = mysqli_fetch_array($result)) { $back .= ''.$rows['uName'].' ('.$rows['Serial'].')'; } print_r($back); } /* изменение данных о адресе датчика */ if(isset($_POST['update'])) { $upd = $_POST['update']; $str = ''; foreach ($upd as $headkey => $headvalue) { $str = "UPDATE `Production`.`sensors_adr` SET `".$headvalue[1]."`='".$headvalue[2]."' WHERE id=".$headvalue[0]; $mysqli->query("$str"); } } /* внесение нового датчика */ elseif(isset($_POST['insert'])) { $ins = $_POST['insert']; $columns = '`timestamp`,'; $values = 'NOW(),'; foreach ($ins as $key => $value) { $columns .= '`'.$value[0].'`,'; $values .= "'".$value[1]."',"; } $str = "INSERT INTO `Production`.`sensors_adr` ($columns) VALUES ($values)"; $str = str_replace(',)', ')', $str); $mysqli->query("$str"); } /* проверка наличие параметра адреса датчика и его значения в передаваемых устройством данных */ elseif(isset($_GET['unit_addr_exist'])) { $unit = $_GET['unit_addr_exist']; $result_array = array(); $away = array(); $text = "SELECT `sd`.`Num`,`sd`.`type`,`sd`.`value` FROM `Production`.`save_data` as `sd` INNER JOIN (SELECT `Num_i` FROM `Production`.`info` WHERE `Prib_id`='$unit' ORDER BY `Num_i` DESC LIMIT 1) inf ON `sd`.`Num` = `inf`.`Num_i` WHERE `sd`.`Type` LIKE '%addr'"; $result = $mysqli->query("$text"); if($result->num_rows) { while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) { $result_array[] = ['Type'=>str_replace('_addr','',$row['type']),'Val'=>$row['value']]; } $away = array('error'=>'false','data'=>$result_array); } else { $away = array('error'=>'true'); } echo json_encode($away); } ?>