73 lines
2.2 KiB
PHP
73 lines
2.2 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use App\Enums\CommentStatus;
|
|
use App\Enums\FlightStatus;
|
|
use App\Models\Flight;
|
|
use Hekmatinasser\Verta\Verta;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
use Illuminate\Http\Request;
|
|
use Morilog\Jalali\Jalalian;
|
|
|
|
class FlightController extends Controller
|
|
{
|
|
public function index(Request $request) {
|
|
|
|
$passengers =
|
|
$request->input('adult', 0) +
|
|
$request->input('children', 0);
|
|
|
|
$flights = Flight::query()
|
|
->where('status', FlightStatus::ENABLE)
|
|
->applyFilter()
|
|
->when($request->filled('from-destination'), function (Builder $query) use ($request) {
|
|
$query->whereHas('departureAirport.city', function (Builder $query) use ($request) {
|
|
$query->where('name', 'LIKE', '%' . $request->input('from-destination') . '%');
|
|
});
|
|
})
|
|
|
|
->when($request->filled('to-destination'), function (Builder $query) use ($request) {
|
|
$query->whereHas('arrivalAirport.city', function (Builder $query) use ($request) {
|
|
$query->where('name', 'LIKE', '%' . $request->input('to-destination') . '%');
|
|
});
|
|
})
|
|
->when($passengers > 0, function (Builder $query) use ($passengers) {
|
|
$query->where('capacity', '>=', $passengers);
|
|
})
|
|
->with([
|
|
'departureAirport.city',
|
|
'arrivalAirport.city',
|
|
'airline',
|
|
'file',
|
|
])
|
|
->orderByDesc('created_at')
|
|
->paginate(12);
|
|
|
|
return view('flights.index', compact('flights'));
|
|
}
|
|
|
|
public function show(Flight $flight)
|
|
{
|
|
abort_if($flight->status !== FlightStatus::ENABLE, 404);
|
|
|
|
$flight->increment('views');
|
|
|
|
$flight->load([
|
|
'departureAirport.city',
|
|
'arrivalAirport.city',
|
|
'airline',
|
|
'file',
|
|
'comments' => function ($query) {
|
|
$query->where('status', CommentStatus::APPROVED)
|
|
->with('user')
|
|
->orderByDesc('created_at');
|
|
},
|
|
]);
|
|
|
|
|
|
|
|
return view('flights.show', compact('flight'));
|
|
}
|
|
}
|