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

$meter_id = $_GET['meter_id'] ?? null;

if (!$meter_id) {
    echo json_encode([
        'success' => false,
        'message' => 'meter_id is required'
    ]);
    exit;
}

try {
    $sql = "
        SELECT MAX(trip_no) AS last_trip
        FROM oris_tb_taxi_estimate
        WHERE meter_id = ?
    ";

    $stmt = $conn->prepare($sql);
    if (!$stmt) {
        throw new Exception("Prepare failed: " . $conn->error);
    }

    $stmt->bind_param("s", $meter_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $row = $result->fetch_assoc();
    $stmt->close();

    // คำนวณ trip_no ถัดไป
    if (!empty($row['last_trip'])) {
        $nextTrip = (int)$row['last_trip'] + 1;
    } else {
        $nextTrip = 1;
    }

    $next_trip_no = str_pad($nextTrip, 5, '0', STR_PAD_LEFT);

    echo json_encode([
        'success' => true,
        'next_trip_no' => $next_trip_no,
        'last_trip_no' => $row['last_trip']
    ]);

} catch (Exception $e) {
    echo json_encode([
        'success' => false,
        'message' => $e->getMessage()
    ]);
}

$conn->close();