<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use function GuzzleHttp\json_encode;
use function dd;
use function redirect;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Redirect;
use App\Models\Reservation;
use App\Models\SpecialCall;
use function response;
class ReservationsController extends Controller
{
public function index(Request $request)
{
//$activities = Reservation::addSelect([
//'specialCall' => SpecialCall::select('sign')
////->whereColumn('reservations.specialCall', 'special_calls.id')
//->whereColumn('specialCall', 'id')
//->limit(1)
//])->get();
if ($request->isMethod('post')) {
$request->validate([
'call-sign' => 'required|alphanum'
]);
if ($request->input('call-sign') == 'all') {
$activities = Reservation::where('approved', '1')
->select('operatorCall', 'fromTime', 'toTime', 'specialCall', 'frequencies', 'modes', 'qso')
->orderBy('fromTime', 'asc')
->orderBy('toTime', 'asc')
->get()->toArray();
$data = [
'status' => 'OK',
'data' => $activities
];
return response($data);
} else {
$activities = Reservation::where('approved', '1')
->select('operatorCall', 'fromTime', 'toTime', 'specialCall', 'frequencies', 'modes', 'qso')
->where('specialCall', $request->input('call-sign'))
->orderBy('fromTime', 'asc')
->orderBy('toTime', 'asc')
->get()
->toArray();
$data = [
'status' => 'OK',
'data' => $activities
];
return response($data);
}
} else if ($request->isMethod('get')) {
$signs = SpecialCall::all();
return view('pages.activities', compact('signs'));
}
}
public function create(Request $request)
{
$signs = SpecialCall::all();
$freq_list = [
'1.8 MHz',
'3.5 MHz',
'7 MHz',
'10 MHz',
'14 MHz',
'18 MHz',
'21 MHz',
'24 MHz',
'28 MHz',
'50 MHz',
'144 MHz',
'432 MHz',
'1.2 GHz',
'2.3 GHz'
];
$mode_list = [
'CW' => 'CW',
'SSB' => 'SSB',
'FM' => 'FM',
'RTTY' => 'RTTY',
'MFSK' => 'MFSK (JT65, FT8...)',
'IMAGING' => 'IMAGING (ATV, SSTV...)',
'OTHER DIGITAL' => 'OTHER DIGITAL'
];
$data = [
'signs' => $signs,
'freq_list' => $freq_list,
'mode_list' => $mode_list
];
return view('pages.reserve', $data);
}
public function store(Request $request)
{
//$validatedData = $request->validate([
//...
//]);
$rules = [
'scall' => 'required|alphanum',
'sdate' => 'required|date',
'stime' => 'required',
'edate' => 'required|date',
'etime' => 'required',
'freqs' => 'required',
'modes' => 'required',
'ocall' => 'required|alphanum',
'oname' => 'required',
'email' => 'required|email',
'phone' => ['required', 'regex:/^[0-9 ]+$/'],
];
$messages = [
'freqs.required' => 'You need to choose at least one frequency.',
'modes.required' => 'You need to choose at least one mode.',
'ocall.alphanum' => 'Callsigns must be alpha-numeric!',
];
$validator = Validator::make($request->all(), $rules, $messages);
$validator->after(function ($validator) use ($request) {
$fromStamp = strtotime($request->sdate . ' ' . $request->stime);
$toStamp = strtotime($request->edate . ' ' . $request->etime);
if (!($fromStamp < $toStamp)) {
$validator->errors()->add('time', 'Start date and time needs to be before end date and time.');
}
});
if ($validator->fails()) {
return Redirect::back()
->withErrors($validator)
->withInput();
}
$reservation = new Reservation();
$reservation->specialCall = $request->scall;
$reservation->fromTime = $request->sdate . ' ' . $request->stime;
$reservation->toTime = $request->edate . ' ' . $request->etime;
$reservation->frequencies = implode(', ', $request->freqs);
$reservation->modes = implode(', ', $request->modes);
$reservation->operatorCall = strtoupper($request->ocall);
$reservation->operatorName = $request->oname;
$reservation->operatorEmail = $request->email;
$reservation->operatorPhone = $request->phone;
$reservation->saveOrFail();
return redirect()->route('reserve')->with('status', 'Reservation submitted.');
}
// Administration
public function edit(Request $request)
{
if ($request->isMethod('post')) {
$request->validate([
'call-sign' => 'required|alphanum'
]);
if ($request->input('call-sign') == 'all') {
$activities = Reservation::orderBy('fromTime', 'asc')
->orderBy('toTime', 'asc')
->get()
->toArray();
$data = [
'status' => 'OK',
'data' => $activities
];
return response($data);
} else {
$activities = Reservation::where('specialCall', $request->input('call-sign'))
->orderBy('fromTime', 'asc')
->orderBy('toTime', 'asc')
->get()
->toArray();
$data = [
'status' => 'OK',
'data' => $activities
];
return response($data);
}
}
else {
//$data = Reservation::orderBy('id', 'desc')->get();
$signs = SpecialCall::all();
return view('pages.reservations', compact('signs'));
}
}
public function update(Request $request)
{
$rules = [
'action' => 'required',
'id' => 'required|numeric',
];
$validatedData = $request->validate($rules);
$record = Reservation::findOrFail($request->id);
if ($request->action == "update") {
$rules = [
'qso' => 'required|numeric',
'approved' => 'required',
'specialCall' => 'required|alphanum',
'fromTime' => 'required|date',
'toTime' => 'required|date|after:fromTime',
'frequencies' => 'required',
'modes' => 'required',
'operatorCall' => 'required|alphanum',
'operatorName' => 'required',
'operatorEmail' => 'required|email',
'operatorPhone' => ['required', 'regex:/^[0-9 ]+$/'],
];
$validatedData = $request->validate($rules);
$record->approved = filter_var($request->approved, FILTER_VALIDATE_BOOLEAN);
$record->qso = $request->qso;
$record->specialCall = $request->specialCall;
$record->fromTime = $request->fromTime;
$record->toTime = $request->toTime;
$record->frequencies = $request->frequencies;
$record->modes = $request->modes;
$record->operatorCall = strtoupper($request->operatorCall);
$record->operatorName = $request->operatorName;
$record->operatorEmail = $request->operatorEmail;
$record->operatorPhone = $request->operatorPhone;
$record->saveOrFail();
return response()->json(['action' => $request->input('action')]);
} else if ($request->action == "restore") {
$resp = $record->toArray();
$resp['action'] = $request->input('action');
return response()->json($resp);
} else if ($request->action == "delete") {
$record->delete();
return response()->json(['action' => $request->input('action')]);
} else {
return response()->json(['action' => 'error']);
}
}
}