db = $database->getConnection(); } public function generateApiKey() { return 'ak_' . bin2hex(random_bytes(24)); } public function createApiKey($data) { try { $apiKey = $this->generateApiKey(); $query = "INSERT INTO api_keys (api_key, name, email, company, purpose, usage_limit, expires_at) VALUES (:api_key, :name, :email, :company, :purpose, :usage_limit, :expires_at)"; $stmt = $this->db->prepare($query); $stmt->bindParam(':api_key', $apiKey); $stmt->bindParam(':name', $data['name']); $stmt->bindParam(':email', $data['email']); $stmt->bindParam(':company', $data['company']); $stmt->bindParam(':purpose', $data['purpose']); $stmt->bindParam(':usage_limit', $data['usage_limit']); $stmt->bindParam(':expires_at', $data['expires_at']); if ($stmt->execute()) { return $apiKey; } return false; } catch (Exception $e) { error_log("Create API key error: " . $e->getMessage()); return false; } } public function getAllApiKeys() { try { $query = "SELECT * FROM api_keys ORDER BY created_at DESC"; $stmt = $this->db->prepare($query); $stmt->execute(); return $stmt->fetchAll(); } catch (Exception $e) { error_log("Get all API keys error: " . $e->getMessage()); return []; } } public function updateApiKeyStatus($id, $isActive) { try { $query = "UPDATE api_keys SET is_active = :is_active WHERE id = :id"; $stmt = $this->db->prepare($query); $stmt->bindParam(':id', $id); $stmt->bindParam(':is_active', $isActive); return $stmt->execute(); } catch (Exception $e) { error_log("Update API key status error: " . $e->getMessage()); return false; } } public function deleteApiKey($id) { try { $query = "DELETE FROM api_keys WHERE id = :id"; $stmt = $this->db->prepare($query); $stmt->bindParam(':id', $id); return $stmt->execute(); } catch (Exception $e) { error_log("Delete API key error: " . $e->getMessage()); return false; } } public function getApiKeyUsage($apiKey) { try { $query = "SELECT COUNT(*) as usage_count FROM api_usage_logs WHERE api_key = :api_key"; $stmt = $this->db->prepare($query); $stmt->bindParam(':api_key', $apiKey); $stmt->execute(); $result = $stmt->fetch(); return $result['usage_count']; } catch (Exception $e) { error_log("Get API key usage error: " . $e->getMessage()); return 0; } } } $apiKeyManager = new ApiKeyManager(); $message = ''; $error = ''; // Handle form submissions if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_POST['action'])) { switch ($_POST['action']) { case 'create': $apiKey = $apiKeyManager->createApiKey([ 'name' => $_POST['name'], 'email' => $_POST['email'], 'company' => $_POST['company'], 'purpose' => $_POST['purpose'], 'usage_limit' => (int)$_POST['usage_limit'], 'expires_at' => $_POST['expires_at'] ?: null ]); if ($apiKey) { $message = "API Key 創建成功: " . $apiKey; } else { $error = "API Key 創建失敗"; } break; case 'toggle_status': $id = (int)$_POST['id']; $currentStatus = (int)$_POST['current_status']; $newStatus = $currentStatus ? 0 : 1; if ($apiKeyManager->updateApiKeyStatus($id, $newStatus)) { $message = $newStatus ? "API Key 已啟用" : "API Key 已停用"; } else { $error = "狀態更新失敗"; } break; case 'delete': $id = (int)$_POST['id']; if ($apiKeyManager->deleteApiKey($id)) { $message = "API Key 已刪除"; } else { $error = "刪除失敗"; } break; } } } $apiKeys = $apiKeyManager->getAllApiKeys(); ?>

API Key 管理

管理 AI Writer API 的訪問金鑰

API Keys 列表
尚無 API Keys

創建第一個 API Key 開始使用

getApiKeyUsage($key['api_key']); $usagePercentage = $key['usage_limit'] > 0 ? ($usage / $key['usage_limit']) * 100 : 0; ?>
API Key 申請人 公司/組織 用途 使用量 狀態 創建日期 操作
...

50 ? '...' : '' ?>
/
啟用 停用 已過期
總 API Keys

啟用中

今日請求

getConnection(); $stmt = $db->prepare("SELECT COUNT(*) as count FROM api_usage_logs WHERE DATE(used_at) = CURDATE()"); $stmt->execute(); $result = $stmt->fetch(); echo number_format($result['count']); } catch (Exception $e) { echo '0'; } ?>

總請求數

prepare("SELECT COUNT(*) as count FROM api_usage_logs"); $stmt->execute(); $result = $stmt->fetch(); echo number_format($result['count']); } catch (Exception $e) { echo '0'; } ?>