141 lines
4.9 KiB
PHP
141 lines
4.9 KiB
PHP
<?php
|
||
// 设置错误报告
|
||
ini_set('display_errors', 1);
|
||
error_reporting(E_ALL);
|
||
|
||
// 允许跨域请求
|
||
header("Access-Control-Allow-Origin: *");
|
||
header("Access-Control-Allow-Methods: POST, GET, OPTIONS");
|
||
header("Access-Control-Allow-Headers: Content-Type");
|
||
header("Content-Type: application/json; charset=UTF-8");
|
||
|
||
// 处理OPTIONS请求（预检请求）
|
||
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
|
||
http_response_code(200);
|
||
exit;
|
||
}
|
||
|
||
// 数据库连接信息
|
||
$db_host = '192.168.2.4';
|
||
$db_port = 3307;
|
||
$db_name = 'task_reporter';
|
||
$db_user = 'task_reporter';
|
||
$db_pass = 'Pass12349ers!';
|
||
|
||
// 创建数据库连接
|
||
try {
|
||
$pdo = new PDO("mysql:host=$db_host;port=$db_port;dbname=$db_name", $db_user, $db_pass);
|
||
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
||
$pdo->exec("SET NAMES utf8");
|
||
} catch (PDOException $e) {
|
||
echo json_encode(["error" => "数据库连接失败: " . $e->getMessage()]);
|
||
exit;
|
||
}
|
||
|
||
// 记录请求到日志文件
|
||
function log_request($message) {
|
||
$log_file = __DIR__ . '/api_log.txt';
|
||
$timestamp = date('Y-m-d H:i:s');
|
||
$log_message = "[$timestamp] $message\n";
|
||
file_put_contents($log_file, $log_message, FILE_APPEND);
|
||
}
|
||
|
||
// 处理添加任务的POST请求
|
||
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
||
try {
|
||
log_request("收到POST请求");
|
||
$raw_data = file_get_contents('php://input');
|
||
log_request("原始数据: $raw_data");
|
||
|
||
$data = json_decode($raw_data, true);
|
||
|
||
if (!$data) {
|
||
throw new Exception("无效的JSON数据: " . json_last_error_msg());
|
||
}
|
||
|
||
log_request("解析后的数据: " . print_r($data, true));
|
||
|
||
// 验证必要字段
|
||
$required_fields = ['username', 'tool_name', 'task_name', 'time_saved', 'time_cost'];
|
||
foreach ($required_fields as $field) {
|
||
if (!isset($data[$field]) || (is_string($data[$field]) && trim($data[$field]) === '')) {
|
||
throw new Exception("缺少必要字段: $field");
|
||
}
|
||
}
|
||
|
||
// 如果没有提供时间戳，使用当前时间
|
||
if (!isset($data['timestamp']) || empty($data['timestamp'])) {
|
||
$data['timestamp'] = date('Y-m-d H:i:s');
|
||
log_request("使用当前时间作为时间戳: {$data['timestamp']}");
|
||
}
|
||
|
||
// 确保时间戳格式正确
|
||
if (strpos($data['timestamp'], 'T') !== false) {
|
||
$parts = explode(".", $data['timestamp']);
|
||
$data['timestamp'] = str_replace("T", " ", $parts[0]);
|
||
log_request("转换ISO时间戳格式: {$data['timestamp']}");
|
||
}
|
||
|
||
// 准备SQL语句
|
||
$stmt = $pdo->prepare("INSERT INTO task (username, tool_name, task_name, time_saved, time_cost, timestamp)
|
||
VALUES (:username, :tool_name, :task_name, :time_saved, :time_cost, :timestamp)");
|
||
|
||
// 绑定参数
|
||
$stmt->bindParam(':username', $data['username']);
|
||
$stmt->bindParam(':tool_name', $data['tool_name']);
|
||
$stmt->bindParam(':task_name', $data['task_name']);
|
||
$stmt->bindParam(':time_saved', $data['time_saved']);
|
||
$stmt->bindParam(':time_cost', $data['time_cost']);
|
||
$stmt->bindParam(':timestamp', $data['timestamp']);
|
||
|
||
log_request("准备执行SQL插入");
|
||
|
||
// 执行SQL
|
||
$result = $stmt->execute();
|
||
|
||
if ($result) {
|
||
$last_id = $pdo->lastInsertId();
|
||
log_request("数据成功插入，ID: $last_id");
|
||
|
||
echo json_encode([
|
||
"success" => true,
|
||
"message" => "{$data['timestamp']} {$data['tool_name']}-{$data['task_name']} reported successfully!",
|
||
"id" => $last_id
|
||
]);
|
||
} else {
|
||
log_request("数据插入失败");
|
||
throw new Exception("数据插入失败");
|
||
}
|
||
} catch (Exception $e) {
|
||
log_request("错误: " . $e->getMessage());
|
||
http_response_code(400);
|
||
echo json_encode([
|
||
"success" => false,
|
||
"error" => $e->getMessage()
|
||
]);
|
||
}
|
||
exit;
|
||
}
|
||
|
||
// 处理简单的GET请求，用于测试API是否正常工作
|
||
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
|
||
echo json_encode([
|
||
"status" => "API正常工作",
|
||
"message" => "使用POST请求提交任务数据",
|
||
"example" => [
|
||
"username" => "用户名",
|
||
"tool_name" => "工具名称",
|
||
"task_name" => "任务名称",
|
||
"time_saved" => "节省时间（小时）",
|
||
"time_cost" => "花费时间（小时）",
|
||
"timestamp" => "可选，格式：YYYY-MM-DD HH:MM:SS"
|
||
],
|
||
"contact" => "jeffreytsai1004@gmail.com"
|
||
]);
|
||
exit;
|
||
}
|
||
|
||
// 如果不是GET或POST请求，返回错误
|
||
http_response_code(405);
|
||
echo json_encode(["error" => "不支持的请求方法"]);
|