pokedex.php

<?php
header('Content-Type: application/json; charset=utf-8');

class PokedexAPI {
    private $db;
    private $response;
    private $validRegions;

    public function __construct() {
        $this->db = new SQLite3('pokedex.db');
        $this->response = [
            'status' => 'success',
            'data' => null,
            'message' => ''
        ];
        
        // 有効な地方図鑑のリスト
        $this->validRegions = [
            'kanto' => 'カントー図鑑',
            'johto' => 'ジョウト図鑑',
            'hoenn' => 'ホウエン図鑑',
            'sinnoh' => 'シンオウ図鑑',
            'unova_bw' => 'イッシュ図鑑',
            'unova_b2w2' => 'イッシュ図鑑',
            'central_kalos' => 'セントラルカロス図鑑',
            'coast_kalos' => 'コーストカロス図鑑',
            'mountain_kalos' => 'マウンテンカロス図鑑',
            'alola_sm' => 'アローラ図鑑',
            'alola_usum' => 'アローラ図鑑',
            'galar' => 'ガラル図鑑',
            'crown_tundra' => 'カンムリ雪原図鑑',
            'isle_of_armor' => 'ヨロイ島図鑑',
            'hisui' => 'ヒスイ図鑑',
            'paldea' => 'パルデア図鑑',
            'kitakami' => 'キタカミ図鑑',
            'blueberry' => 'ブルーベリー図鑑'
        ];
    }

    public function handleRequest() {
        $region = isset($_GET['region']) ? $_GET['region'] : null;
        $no = isset($_GET['no']) ? $_GET['no'] : null;

        if (!$region) {
            $this->response['error'] = 'Region parameter is required';
            $this->response['valid_regions'] = array_merge(['global'], array_keys($this->validRegions));
            return;
        }

        if ($region === 'global') {
            $this->handleGlobalPokedex(['no' => $no]);
            return;
        }

        if (!array_key_exists($region, $this->validRegions)) {
            $this->response['error'] = 'Invalid region';
            $this->response['valid_regions'] = array_merge(['global'], array_keys($this->validRegions));
            return;
        }

        $this->handleLocalPokedex(['region' => $region, 'no' => $no]);
    }

    private function handleLocalPokedex($params) {
        $region = $params['region'];
        $no = $params['no'] ?? null;

        if (!isset($this->validRegions[$region])) {
            throw new Exception("Invalid region: {$region}");
        }

        // まず基本情報を取得
        $query = "SELECT l.*, 
                 p.jpn, p.eng, p.ger, p.fra, p.kor, p.chs, p.cht,
                 p.classification, p.height, p.weight
                 FROM $region l
                 LEFT JOIN pokedex p ON l.globalNo = p.no";

        if ($no) {
            $query .= " WHERE l.no = :no";
        }
        
        $query .= " ORDER BY CAST(l.no AS INTEGER)";
        
        $stmt = $this->db->prepare($query);
        if ($no) {
            $stmt->bindValue(':no', $no, SQLITE3_TEXT);
        }

        $result = $stmt->execute();
        $data = [];

        while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
            // 技情報を取得
            $globalNo = $row['globalNo'];
            $form = $row['form'];
            
            $waza_query = "SELECT learn_type, level, waza_name 
                          FROM waza 
                          WHERE region = :region 
                          AND global_no = :global_no
                          AND (
                              CASE 
                                  WHEN substr(:form, 1, 2) = 'メガ' THEN form = :form
                                  ELSE form = :form OR form = ''
                              END
                          )";
            
            $waza_stmt = $this->db->prepare($waza_query);
            $waza_stmt->bindValue(':region', $region, SQLITE3_TEXT);
            $waza_stmt->bindValue(':global_no', $globalNo, SQLITE3_TEXT);
            $waza_stmt->bindValue(':form', $form, SQLITE3_TEXT);
            
            $waza_result = $waza_stmt->execute();
            
            $waza_list = [
                'initial' => [],
                'remember' => [],
                'evolution' => [],
                'level' => [],
                'machine' => []
            ];
            
            while ($waza_row = $waza_result->fetchArray(SQLITE3_ASSOC)) {
                $learn_type = $waza_row['learn_type'];
                $waza_list[$learn_type][] = [
                    'level' => $waza_row['level'],
                    'waza_name' => $waza_row['waza_name']
                ];
            }
            
            $row['waza_list'] = $waza_list;
            $data[] = $row;
        }

        $this->response['data'] = $data;
        $this->response['region_name'] = $this->validRegions[$region];
    }

    private function handleGlobalPokedex($params) {
        $no = $params['no'] ?? null;

        if ($no) {
            $query = "SELECT * FROM pokedex WHERE no = :no";
            $stmt = $this->db->prepare($query);
            $stmt->bindValue(':no', $no, SQLITE3_TEXT);
        } else {
            $query = "SELECT * FROM pokedex ORDER BY CAST(no AS INTEGER)";
            $stmt = $this->db->prepare($query);
        }

        $result = $stmt->execute();
        $data = [];

        while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
            $data[] = $row;
        }

        $this->response['data'] = $data;
        $this->response['status'] = 'success';
    }

    public function getResponse() {
        return $this->response;
    }
}

$api = new PokedexAPI();
$api->handleRequest();

$response = $api->getResponse();
echo json_encode($response, JSON_UNESCAPED_UNICODE);