App\Http\Controllers\Customers\CustomerSystemsController

Complexity

Total Complexity

15

Size/Duplication

Total Lines	135
Duplicated Lines	0 %

Test Coverage

Coverage

84.06%

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	store()	0	40	5
A	index()	0	5	1
A	destroy()	0	12	1
A	show()	0	24	2
A	update()	0	34	5

<?php

namespace App\Http\Controllers\Customers;

use App\Customers;
use App\CustomerSystems;
use App\SystemDataFields;
use App\SystemCategories;
use App\CustomerSystemData;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Auth;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Route;
use App\Http\Resources\SystemCategoriesCollection as CategoriesCollection;

class CustomerSystemsController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
    }

    //  Get the possible system types that can be assigned to the customer
    public function index()
    {
        $sysList = new CategoriesCollection(SystemCategories::with('SystemTypes')->with('SystemTypes.SystemDataFields.SystemDataFieldTypes')->get());

        return $sysList;
    }

    //  Store a new system for the customer
    public function store(Request $request)
    {
        $request->validate([
            'cust_id' => 'required',
            'system'  => 'required'
            //  TODO:  validate system is unique to customer (write a test for it)
        ]);

        //  Determine if the system is supposed to be added for the parent, or this site
        $details = Customers::find($request->cust_id);
        if($details->parent_id && $request->shared == 1)
        {
            $request->cust_id = $details->parent_id;
        }

        //  Insert the system into the DB
        $sys = CustomerSystems::create([
            'cust_id' => $request->cust_id,
            'sys_id'  => $request->system,
            'shared'  => $request->shared,
        ]);

        //  Get the data fields for the new system
        $fields = SystemDataFields::where('sys_id', $request->system)->get();

        //  Enter each of the data fields into the DB
        foreach($fields as $field)
        {
            $data = 'field_'.$field->field_id;
            CustomerSystemData::create([
                'cust_sys_id' => $sys->cust_sys_id,
                'field_id'    => $field->field_id,
                'value'       => isset($request->$data) ? $request->$data : null
            ]);
        }

        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
        Log::info('New Customer System Added - Customer ID-'.$request->cust_id.' System ID-'.$request->system);
        Log::debug('Submitted System Data', $request->toArray());
        return response()->json(['success' => true]);
    }

    //  Get the list of systems attached to the customer
    public function show($id)
    {
        $sysList = CustomerSystems::where('cust_id', $id)
                    ->with('SystemTypes')
                    ->with('SystemDataFields')
                    ->with('SystemDataFields.SystemDataFieldTypes')
                    ->orderBy('cust_sys_id', 'DESC')
                    ->get();

        //  determine if there is a parent site with shared systems
        $parent = Customers::findOrFail($id)->parent_id;
        if($parent != null)
        {
            $parentList = CustomerSystems::where('cust_id', $parent)
                                ->where('shared', 1)
                                ->with('SystemTypes')
                                ->with('SystemDataFields')
                                ->with('SystemDataFields.SystemDataFieldTypes')
                                ->get();

            $sysList = $sysList->merge($parentList);
        }

        return $sysList;
    }

    // Update the customers system data
    public function update(Request $request, $id)
    {
        $request->validate([
            'cust_id'    => 'required',
            'system'    => 'required',
        ]);

        //  Verify the system type and customer ID match
        $valid = CustomerSystems::where('cust_id', $request->cust_id)->where('cust_sys_id', $id)->first();

        if(!$valid)
        {
            return abort(400);
        }

        $fields = SystemDataFields::where('sys_id', $request->system)->get();

        foreach($fields as $data)
        {
            $fieldName = 'field_' . $data->field_id;
            if(isset($request->$fieldName))
            {
                Log::debug($request->$fieldName);
            }
            Log::debug($fieldName);
            CustomerSystemData::where('cust_sys_id', $id)->where('field_id', $data->field_id)->update([
                'value'       => isset($request->$fieldName) ? $request->$fieldName : null
            ]);
        }

        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
        Log::notice('Customer System Updated.  Cust ID-'.$request->custID.' System ID-'.$request->sysstem.' User ID-'.Auth::user()->user_id);
        Log::debug('Submitted Data - ID:'.$id.' - ', $request->toArray());
        return response()->json(['success' => true]);
    }

    //  Delete a system attached to a customer
    public function destroy($id)
    {
        // return response('deleted '.$id);
        $system = CustomerSystems::find($id);

        Log::debug('Route '.Route::currentRouteName().' visited by User ID-'.Auth::user()->user_id);
        Log::notice('Customer System Deleted for Customer ID-'.$system->cust_id.' by User ID-'.Auth::user()->user_id.'. System ID-'.$id);
        Log::debug('System Data', $system->toArray());

        $system->delete();

        return response()->json(['success' => true]);
    }
}