App\Http\Controllers\DashboardController::refreshPage()

Complexity

Conditions	3
Paths	2

Size

Total Lines	63
Code Lines	35

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	12

Importance

Changes

0

<?php
    public function refreshPage(Request $request)
    {
        $request->validate([
            'site_id' => 'required|integer|digits_between:1,7',
            'location_id' => 'sometimes|required|integer|digits_between:1,7',
            'device_id' => 'sometimes|required|integer|digits_between:1,7',
            'offset' => 'sometimes|required|integer|digits_between:1,7',
        ]);
    
        //Todo limit the amount of queries based on if there is changes
        //Check for changes in database since last update
        
        //Limit the number of devices to be loaded
        $limit = 4;
        
        //Set the offset for device pagination
        $offset = $request->offset ?? 0;
        
        //Get the active site, location, and device ids
        $site_id = $request->site_id ?? 0;
        $location_id = $request->location_id ?? 0;
        $device_id = $request->device_id ?? 0;
        
        //TODO always have a un-deletable site and location and there will never be an error
        //Get all sites with the selected site first
        $sites = Site::select('id', 'name')
            ->orderByRaw("id = ? DESC", $site_id)
            ->orderBy('name', 'ASC')
            ->get();
        //Get all locations for the selected site with the selected location first
        $locations = Location::select('id', 'name', 'site_id')
            ->where('site_id', '=', $sites[0]->id ?? 0)
            ->orderByRaw("id = ? DESC", $location_id)
            ->orderBy('name', 'ASC')
            ->get();
        //Get all devices for the selected location
        $devices = Device::publicDashData()
            ->where('location_id', '=', $locations[0]->id ?? 0)
            ->orderBy('name', 'ASC')
            ->limit($limit)
            ->offset($offset * $limit)
            ->get();
        //Get the total device count for the given location
        $deviceCount = Device::where('location_id', '=', $locations[0]->id ?? 0)->count();
    
        //Get the active device
        $active_device = $devices->where('id', $device_id)->first();
        //Set the active device to the first device in $devices if it is not empty and the original active device wasn't found
        if (!$devices->isEmpty() && $active_device == null)
            $active_device = $devices[0];
        
        //Store the active site, location, and device in a collection
        $active_data = collect(['device' => $active_device, 'location' => $locations[0] ?? null, 'site' => $sites[0] ?? null]);
        
        //Get the total amount of pages for pagination
        $page_count = ceil($deviceCount / $limit) - 1;
        
        //Store pagination data
        $pag_data = collect(['offset' => $offset, 'page_count' => $page_count]);
        
        return response()->json([ 'active_data' => $active_data, 'devices' => $devices, 'locations' => $locations,
            'sites' => $sites, 'pag_data' => $pag_data]);
    }