[V0_FILE]sql:file="scripts/001_create_tables.sql" isMerged="true" -- Kullanıcılar tablosu (Anne/Baba) create table if not exists public.parents ( id uuid primary key references auth.users(id) on delete cascade, email text not null, full_name text, created_at timestamp with time zone default now() ); -- Çocukların cihazları tablosu create table if not exists public.devices ( id uuid primary key default gen_random_uuid(), parent_id uuid not null references public.parents(id) on delete cascade, device_name text not null, device_code text unique not null, android_id text, last_seen timestamp with time zone default now(), battery_level integer, is_charging boolean default false, latitude double precision, longitude double precision, created_at timestamp with time zone default now() ); -- Komutlar tablosu (Anne/Baba'dan cihaza gönderilen komutlar) create table if not exists public.commands ( id uuid primary key default gen_random_uuid(), device_id uuid not null references public.devices(id) on delete cascade, command_type text not null, -- 'notification', 'get_location', 'get_battery', etc. command_data jsonb, status text default 'pending', -- 'pending', 'sent', 'completed', 'failed' created_at timestamp with time zone default now(), completed_at timestamp with time zone ); -- Row Level Security (RLS) - GÜVENLİK alter table public.parents enable row level security; alter table public.devices enable row level security; alter table public.commands enable row level security; -- Parents policies create policy "Parents can view their own data" on public.parents for select using (auth.uid() = id); create policy "Parents can insert their own data" on public.parents for insert with check (auth.uid() = id); create policy "Parents can update their own data" on public.parents for update using (auth.uid() = id); -- Devices policies create policy "Parents can view their own devices" on public.devices for select using (parent_id = auth.uid()); create policy "Parents can insert their own devices" on public.devices for insert with check (parent_id = auth.uid()); create policy "Parents can update their own devices" on public.devices for update using (parent_id = auth.uid()); create policy "Parents can delete their own devices" on public.devices for delete using (parent_id = auth.uid()); -- Commands policies create policy "Parents can view commands for their devices" on public.commands for select using (device_id in (select id from public.devices where parent_id = auth.uid())); create policy "Parents can create commands for their devices" on public.commands for insert with check (device_id in (select id from public.devices where parent_id = auth.uid())); create policy "Parents can update commands for their devices" on public.commands for update using (device_id in (select id from public.devices where parent_id = auth.uid())); [V0_FILE]sql:file="scripts/002_create_parent_trigger.sql" isMerged="true" -- Yeni kullanıcı kaydolduğunda otomatik parent kaydı oluştur create or replace function public.handle_new_parent() returns trigger language plpgsql security definer set search_path = public as $$ begin insert into public.parents (id, email, full_name) values ( new.id, new.email, coalesce(new.raw_user_meta_data ->> 'full_name', null) ) on conflict (id) do nothing; return new; end; $$; drop trigger if exists on_auth_user_created on auth.users; create trigger on_auth_user_created after insert on auth.users for each row execute function public.handle_new_parent(); [V0_FILE]typescript:file="lib/supabase/client.ts" isMerged="true" import { createBrowserClient } from "@supabase/ssr" export function createClient() { return createBrowserClient(process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!) } [V0_FILE]typescript:file="lib/supabase/server.ts" isMerged="true" import { createServerClient } from "@supabase/ssr" import { cookies } from "next/headers" export async function createClient() { const cookieStore = await cookies() return createServerClient(process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!, { cookies: { getAll() { return cookieStore.getAll() }, setAll(cookiesToSet) { try { cookiesToSet.forEach(({ name, value, options }) => cookieStore.set(name, value, options)) } catch { // Server Component'ten çağrıldı, middleware token yenileyecek } }, }, }) } [V0_FILE]typescript:file="lib/supabase/middleware.ts" isMerged="true" import { createServerClient } from "@supabase/ssr" import { NextResponse, type NextRequest } from "next/server" export async function updateSession(request: NextRequest) { let supabaseResponse = NextResponse.next({ request, }) const supabase = createServerClient( process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!, { cookies: { getAll() { return request.cookies.getAll() }, setAll(cookiesToSet) { cookiesToSet.forEach(({ name, value }) => request.cookies.set(name, value)) supabaseResponse = NextResponse.next({ request, }) cookiesToSet.forEach(({ name, value, options }) => supabaseResponse.cookies.set(name, value, options)) }, }, }, ) const { data: { user }, } = await supabase.auth.getUser() if (!user && !request.nextUrl.pathname.startsWith("/auth") && request.nextUrl.pathname !== "/") { const url = request.nextUrl.clone() url.pathname = "/auth/login" return NextResponse.redirect(url) } return supabaseResponse } [V0_FILE]typescript:file="middleware.ts" isMerged="true" import { updateSession } from "@/lib/supabase/middleware" import type { NextRequest } from "next/server" export async function middleware(request: NextRequest) { return await updateSession(request) } export const config = { matcher: ["/((?!_next/static|_next/image|favicon.ico|.*\\.(?:svg|png|jpg|jpeg|gif|webp)$).*)"], } [V0_FILE]typescriptreact:file="app/auth/login/page.tsx" isMerged="true" "use client" import type React from "react" import { createClient } from "@/lib/supabase/client" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import Link from "next/link" import { useRouter } from "next/navigation" import { useState } from "react" export default function LoginPage() { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [error, setError] = useState(null) const [isLoading, setIsLoading] = useState(false) const router = useRouter() const handleLogin = async (e: React.FormEvent) => { e.preventDefault() const supabase = createClient() setIsLoading(true) setError(null) try { const { error } = await supabase.auth.signInWithPassword({ email, password, }) if (error) throw error router.push("/dashboard") } catch (error: unknown) { setError(error instanceof Error ? error.message : "Bir hata oluştu") } finally { setIsLoading(false) } } return (

Giriş Yap Aile Sistemi kontrol panelinize giriş yapın

) } [V0_FILE]typescriptreact:file="app/auth/signup/page.tsx" isMerged="true" "use client" import type React from "react" import { createClient } from "@/lib/supabase/client" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import Link from "next/link" import { useRouter } from "next/navigation" import { useState } from "react" export default function SignupPage() { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [fullName, setFullName] = useState("") const [error, setError] = useState(null) const [isLoading, setIsLoading] = useState(false) const router = useRouter() const handleSignup = async (e: React.FormEvent) => { e.preventDefault() const supabase = createClient() setIsLoading(true) setError(null) try { const { error } = await supabase.auth.signUp({ email, password, options: { emailRedirectTo: process.env.NEXT_PUBLIC_DEV_SUPABASE_REDIRECT_URL || `${window.location.origin}/dashboard`, data: { full_name: fullName, }, }, }) if (error) throw error router.push("/auth/success") } catch (error: unknown) { setError(error instanceof Error ? error.message : "Bir hata oluştu") } finally { setIsLoading(false) } } return (

Kayıt Ol Aile Sistemi hesabı oluşturun

) } [V0_FILE]typescriptreact:file="app/auth/success/page.tsx" isMerged="true" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" export default function SuccessPage() { return (

Kayıt Başarılı! E-postanızı kontrol edin

Hesabınızı doğrulamak için e-posta adresinize bir onay linki gönderdik. Lütfen e-postanızı kontrol edin ve hesabınızı aktifleştirin.

) } [V0_FILE]typescriptreact:file="app/dashboard/page.tsx" isMerged="true" import { redirect } from "next/navigation" import { createClient } from "@/lib/supabase/server" import DeviceList from "@/components/device-list" import AddDeviceDialog from "@/components/add-device-dialog" import { Button } from "@/components/ui/button" import { LogOut } from "lucide-react" export default async function DashboardPage() { const supabase = await createClient() const { data, error } = await supabase.auth.getUser() if (error || !data?.user) { redirect("/auth/login") } const { data: parent } = await supabase.from("parents").select("*").eq("id", data.user.id).single() const { data: devices } = await supabase .from("devices") .select("*") .eq("parent_id", data.user.id) .order("created_at", { ascending: false }) return (

Aile Sistemi

Hoş geldiniz, {parent?.full_name || data.user.email}

Kayıtlı Cihazlar

) } [V0_FILE]typescriptreact:file="components/device-list.tsx" isMerged="true" "use client" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" import { Button } from "@/components/ui/button" import { Smartphone, Battery, MapPin, Send } from "lucide-react" import { useState } from "react" import SendCommandDialog from "./send-command-dialog" type Device = { id: string device_name: string device_code: string last_seen: string battery_level: number | null is_charging: boolean | null latitude: number | null longitude: number | null } export default function DeviceList({ devices }: { devices: Device[] }) { const [selectedDevice, setSelectedDevice] = useState(null) if (devices.length === 0) { return (

Henüz kayıtlı cihaz yok. Yeni cihaz eklemek için yukarıdaki butona tıklayın.

) } return ( <>

{devices.map((device) => ( {device.device_name} {device.device_code}

{device.battery_level !== null ? `%${device.battery_level}` : "Bilinmiyor"} {device.is_charging && " (Şarj oluyor)"}

{device.latitude && device.longitude ? `${device.latitude.toFixed(4)}, ${device.longitude.toFixed(4)}` : "Konum bilinmiyor"}

Son görülme: {new Date(device.last_seen).toLocaleString("tr-TR")}

))}

{selectedDevice && ( !open && setSelectedDevice(null)} /> )} ) } [V0_FILE]typescriptreact:file="components/add-device-dialog.tsx" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { Dialog, DialogContent, DialogDescription, DialogHeader, DialogTitle, DialogTrigger, } from "@/components/ui/dialog" import { Button } from "@/components/ui/button" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Plus } from "lucide-react" import { createClient } from "@/lib/supabase/client" import { useRouter } from "next/navigation" import QRCode from "react-qr-code" export default function AddDeviceDialog() { const [open, setOpen] = useState(false) const [deviceName, setDeviceName] = useState("") const [deviceCode, setDeviceCode] = useState("") const [showQR, setShowQR] = useState(false) const [isLoading, setIsLoading] = useState(false) const [error, setError] = useState(null) const router = useRouter() const generateDeviceCode = () => { return Math.random().toString(36).substring(2, 8).toUpperCase() } const handleSubmit = async (e: React.FormEvent) => { e.preventDefault() setIsLoading(true) setError(null) const supabase = createClient() const code = deviceCode || generateDeviceCode() try { const { data: { user }, } = await supabase.auth.getUser() if (!user) throw new Error("Oturum açmanız gerekiyor") const { error: insertError } = await supabase.from("devices").insert({ parent_id: user.id, device_name: deviceName, device_code: code, }) if (insertError) throw insertError setDeviceCode(code) setShowQR(true) router.refresh() } catch (error: unknown) { setError(error instanceof Error ? error.message : "Bir hata oluştu") } finally { setIsLoading(false) } } const handleClose = () => { setOpen(false) setDeviceName("") setDeviceCode("") setShowQR(false) setError(null) } return ( ) } [V0_FILE]typescriptreact:file="components/send-command-dialog.tsx" isEdit="true" isMerged="true" "use client" import { useState } from "react" import { Dialog, DialogContent, DialogDescription, DialogHeader, DialogTitle } from "@/components/ui/dialog" import { Button } from "@/components/ui/button" import { Textarea } from "@/components/ui/textarea" import { Label } from "@/components/ui/label" import { Bell, MapPin, Battery, Camera, List } from "lucide-react" import { createClient } from "@/lib/supabase/client" import { useRouter } from "next/navigation" type Device = { id: string device_name: string } export default function SendCommandDialog({ device, open, onOpenChange, }: { device: Device open: boolean onOpenChange: (open: boolean) => void }) { const [commandType, setCommandType] = useState(null) const [message, setMessage] = useState("") const [isLoading, setIsLoading] = useState(false) const [error, setError] = useState(null) const router = useRouter() const sendCommand = async (type: string, data?: object) => { setIsLoading(true) setError(null) const supabase = createClient() try { const { error: insertError } = await supabase.from("commands").insert({ device_id: device.id, command_type: type, command_data: data || null, status: "pending", }) if (insertError) throw insertError router.refresh() onOpenChange(false) } catch (error: unknown) { setError(error instanceof Error ? error.message : "Bir hata oluştu") } finally { setIsLoading(false) } } return (

About

Tags

Share

About

Tags

Share

More Templates Like This