1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use function dd;
use function redirect;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Redirect;
use Illuminate\Support\Facades\Auth;
use App\Models\Reservation;
use App\Models\SpecialCall;
class SpecialCallsController extends Controller
{
public function activities(Request $request)
{
$activities = Reservation::where('approved', '1')->get();
//$activities = Reservation::addSelect([
//'specialCall' => SpecialCall::select('sign')
////->whereColumn('reservations.specialCall', 'special_calls.id')
//->whereColumn('specialCall', 'id')
//->limit(1)
//])->get();
return view('pages.activities', compact('activities'));
}
public function reserve(Request $request)
{
$signs = SpecialCall::all();
return view('pages.reserve', compact('signs'));
}
public function reserveForm(Request $request)
{
//$validatedData = $request->validate([
//'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 ]+$/'],
//]);
$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);
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 = $request->ocall;
$reservation->operatorName = $request->oname;
$reservation->operatorEmail = $request->email;
$reservation->operatorPhone = $request->phone;
$reservation->saveOrFail();
return redirect()->route('reserve')->with('status', 'Reservation submitted.');
}
public function add(Request $request)
{
$data = SpecialCall::all();
return view('pages.callsigns', compact('data'));
}
public function addForm(Request $request)
{
return Redirect::back();
}
public function reservations(Request $request)
{
$data = Reservation::all();
return view('pages.reservations', compact('data'));
}
public function reservationsForm(Request $request)
{
return Redirect::back();
}
}
|