131 lines
4.0 KiB
PHP
131 lines
4.0 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers\Admin;
|
|
|
|
use App\Http\Controllers\Controller;
|
|
use App\Models\Ensemble;
|
|
use App\Models\Event;
|
|
use App\Models\SeatingLimit;
|
|
use Illuminate\Http\Request;
|
|
use Illuminate\Support\Facades\Auth;
|
|
use Illuminate\Support\Facades\Cache;
|
|
|
|
use function redirect;
|
|
|
|
class EnsembleController extends Controller
|
|
{
|
|
public function index()
|
|
{
|
|
$events = Event::with('ensembles')->get();
|
|
|
|
return view('admin.ensembles.index', compact('events'));
|
|
}
|
|
|
|
public function store(Request $request)
|
|
{
|
|
if (! Auth::user()->is_admin) {
|
|
abort(403);
|
|
}
|
|
request()->validate([
|
|
'name' => 'required',
|
|
'code' => ['required', 'max:6'],
|
|
'event_id' => ['required', 'exists:events,id'],
|
|
]);
|
|
// get the maximum value of rank from the ensembles table where event_id is equal to the request event_id
|
|
$maxCode = Ensemble::where('event_id', request('event_id'))->max('rank');
|
|
|
|
Ensemble::create([
|
|
'name' => request('name'),
|
|
'code' => request('code'),
|
|
'event_id' => request('event_id'),
|
|
'rank' => $maxCode + 1,
|
|
]);
|
|
|
|
return redirect()->route('admin.ensembles.index')->with('success', 'Ensemble created successfully');
|
|
}
|
|
|
|
public function destroy(Request $request, Ensemble $ensemble)
|
|
{
|
|
if ($ensemble->seats->count() > 0) {
|
|
return redirect()->route('admin.ensembles.index')->with('error',
|
|
'Ensemble has students seated and cannot be deleted');
|
|
}
|
|
$ensemble->delete();
|
|
|
|
return redirect()->route('admin.ensembles.index')->with('success', 'Ensemble deleted successfully');
|
|
}
|
|
|
|
public function updateEnsemble(Request $request, Ensemble $ensemble)
|
|
{
|
|
request()->validate([
|
|
'name' => 'required',
|
|
'code' => 'required|max:6',
|
|
]);
|
|
|
|
$ensemble->update([
|
|
'name' => request('name'),
|
|
'code' => request('code'),
|
|
]);
|
|
|
|
return redirect()->route('admin.ensembles.index')->with('success', 'Ensemble updated successfully');
|
|
}
|
|
|
|
public function seatingLimits(Ensemble $ensemble)
|
|
{
|
|
$limits = [];
|
|
$ensembles = Ensemble::with(['event'])->orderBy('event_id')->get();
|
|
if ($ensemble->exists()) {
|
|
$ensemble->load('seatingLimits');
|
|
foreach ($ensemble->seatingLimits as $lim) {
|
|
$limits[$lim->audition_id] = $lim->maximum_accepted;
|
|
}
|
|
}
|
|
|
|
return view('admin.ensembles.seatingLimits', compact('ensemble', 'ensembles', 'limits'));
|
|
}
|
|
|
|
public function seatingLimitsSet(Request $request, Ensemble $ensemble)
|
|
{
|
|
Cache::forget('auditionSeatingLimits');
|
|
$request->validate([
|
|
'audition' => 'required',
|
|
'audition.*' => ['integer', 'min:0'],
|
|
]);
|
|
|
|
foreach ($ensemble->auditions as $audition) {
|
|
SeatingLimit::upsert(
|
|
[
|
|
[
|
|
'ensemble_id' => $ensemble->id,
|
|
'audition_id' => $audition->id,
|
|
'maximum_accepted' => $request->audition[$audition->id],
|
|
],
|
|
],
|
|
uniqueBy: ['ensemble_id', 'audition_id'],
|
|
update: ['maximum_accepted']
|
|
);
|
|
}
|
|
|
|
return redirect()->route('admin.ensembles.seatingLimits.ensemble', $ensemble)->with('success',
|
|
'Seating limits set for '.$ensemble->name);
|
|
}
|
|
|
|
public function updateEnsembleRank(Request $request)
|
|
{
|
|
if (! Auth::user()->is_admin) {
|
|
abort(403);
|
|
}
|
|
|
|
$order = $request->input('order');
|
|
$eventId = $request->input('event_id');
|
|
|
|
foreach ($order as $item) {
|
|
Ensemble::where('id', $item['id'])
|
|
->where('event_id', $eventId)
|
|
->update(['rank' => $item['rank']]);
|
|
}
|
|
|
|
return response()->json(['status' => 'success']);
|
|
}
|
|
}
|