51 lines
1.7 KiB
PHP
51 lines
1.7 KiB
PHP
<?php
|
|
// 数据库连接
|
|
include "db_config.php";
|
|
$conn = $link;
|
|
|
|
// 获取请求参数
|
|
$id = $_GET['id'];
|
|
$name = $_GET['name'];
|
|
$address = $_GET['address'];
|
|
$event_time = intval($_GET['event_time']);
|
|
|
|
// 查询是否存在红码时空交集
|
|
$sql_red = "SELECT * FROM nucleic_acid_test_2
|
|
WHERE address = '$address' AND ABS(event_time - $event_time) < 1800 AND code = '3'";
|
|
$result_red = $conn->query($sql_red);
|
|
|
|
if ($result_red->num_rows > 0) {
|
|
// 存在红码时空交集，赋红码并入库
|
|
$sql_check = "SELECT * FROM nucleic_acid_test_2 WHERE id = '$id' AND address = '$address' AND event_time = $event_time";
|
|
$result_check = $conn->query($sql_check);
|
|
if ($result_check->num_rows == 0) {
|
|
$sql_insert = "INSERT INTO nucleic_acid_test_2 (id, name, address, event_time, code) VALUES ('$id', '$name', '$address', $event_time, '3')";
|
|
$conn->query($sql_insert);
|
|
}
|
|
echo "3";
|
|
$conn->close();
|
|
exit;
|
|
}
|
|
|
|
// 查询是否存在黄码时空交集
|
|
$sql_yellow = "SELECT * FROM nucleic_acid_test_2
|
|
WHERE (address = '$address' OR ABS(event_time - $event_time) < 1800) AND code = '2'";
|
|
$result_yellow = $conn->query($sql_yellow);
|
|
|
|
if ($result_yellow->num_rows > 0) {
|
|
// 存在黄码时空交集，赋黄码并入库
|
|
$sql_check = "SELECT * FROM nucleic_acid_test_2 WHERE id = '$id' AND address = '$address' AND event_time = $event_time";
|
|
$result_check = $conn->query($sql_check);
|
|
if ($result_check->num_rows == 0) {
|
|
$sql_insert = "INSERT INTO nucleic_acid_test_2 (id, name, address, event_time, code) VALUES ('$id', '$name', '$address', $event_time, '2')";
|
|
$conn->query($sql_insert);
|
|
}
|
|
echo "2";
|
|
$conn->close();
|
|
exit;
|
|
}
|
|
|
|
// 无风险，返回绿码
|
|
echo "1";
|
|
?>
|