Krikorios
a0b297285a
- Replace Clerk with self-hosted JWT auth (register/login/verify, bcrypt passwords, Gmail OTP with console fallback) - Add lib/db.ts pg pool + transaction helpers; seed script migrates legacy Clerk-era schema (drop clerk_id, enforce UUID ids and unique email) - Add owner-gated admin API: stats, users, drivers CRUD, rides - Add dashboard/ Vite React owner dashboard (login, overview, users, fleet, rides) with dev-server proxy to avoid Expo CORS middleware - Add scripts/set-owner.mjs for role management
47 lines
1.4 KiB
TypeScript
47 lines
1.4 KiB
TypeScript
import { requireAuth } from "@/lib/jwt";
|
|
import { sql } from "@/lib/db";
|
|
|
|
export async function GET(request: Request, { id }: { id: string }) {
|
|
const auth = requireAuth(request);
|
|
if ("error" in auth) return auth.error;
|
|
|
|
try {
|
|
const response = await sql`
|
|
SELECT
|
|
rides.ride_id,
|
|
rides.origin_address,
|
|
rides.destination_address,
|
|
rides.origin_latitude,
|
|
rides.origin_longitude,
|
|
rides.destination_latitude,
|
|
rides.destination_longitude,
|
|
rides.ride_time,
|
|
rides.fare_price,
|
|
rides.payment_status,
|
|
rides.created_at,
|
|
json_build_object(
|
|
'driver_id', drivers.id,
|
|
'first_name', drivers.first_name,
|
|
'last_name', drivers.last_name,
|
|
'profile_image_url', drivers.profile_image_url,
|
|
'car_image_url', drivers.car_image_url,
|
|
'car_seats', drivers.car_seats,
|
|
'rating', drivers.rating
|
|
) AS driver
|
|
FROM
|
|
rides
|
|
INNER JOIN
|
|
drivers ON rides.driver_id = drivers.id
|
|
WHERE
|
|
rides.user_id = ${auth.userId}
|
|
ORDER BY
|
|
rides.created_at DESC;
|
|
`;
|
|
|
|
return Response.json({ data: response });
|
|
} catch (error) {
|
|
console.error("[GET_RIDE]: ", error);
|
|
return Response.json({ error: "Internal Server Error" }, { status: 500 });
|
|
}
|
|
}
|