<?php

declare(strict_types=1);

namespace App\Core\Ticket\Application;

use Illuminate\Support\Facades\DB;

class SeatService
{
    public function dataSeats()
    {
        $seats = DB::table('seats as s')
            ->select(
                's.id',
                DB::raw("CONCAT(z.name, ' - ', l.name, s.code) AS name")
            )
            ->join('letters as l', 'l.id', '=', 's.letter_id')
            ->join('zones as z', 'z.id', '=', 's.zone_id')
            ->orderBy('s.id', 'ASC')
            ->get();

        return $seats;
    }
}