<?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";
?>