akubiczek / applicake-backend

app/Services/FormFieldsService.php

<?php

namespace App\Services;

use App\Http\Requests\CreateFormFieldRequest;
use App\Http\Requests\FormFieldUpdateRequest;
use App\Models\FormField;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class FormFieldsService
{
    public static function createField(CreateFormFieldRequest $request)
    {
        $order = FormField::where('recruitment_id', $request->recruitment_id)->max('order');

The property recruitment_id does not seem to exist on App\Http\Requests\CreateFormFieldRequest.

        $field = FormField::make($request->validated());
        $field->user_id = Auth::user()->id;
        $field->order = $order + 1;
        $field->save();

        $field->name = 'custom_field_'.$field->id;
        $field->save();

        return $field;
    }

    public static function updateField($fieldId, FormFieldUpdateRequest $request)
    {
        $field = FormField::findOrFail($fieldId);
        $input = $request->validated();
        $field->fill($input)->save();

        //TODO: if ($field->wasChanged('order')) reorder remaing fields

        return $field;
    }

    public static function deleteField($fieldId)
    {
        $field = FormField::findOrFail($fieldId);
        $field->delete();

        DB::connection('tenant')->table('form_fields')->where('recruitment_id', $field->recruitment_id)->where('order', '>', $field->order)->decrement('order');

The property recruitment_id does not exist on App\Models\FormField. Did you mean recruitment?

    }

    public static function reorder($dragId, $dropId)
    {
        $dropField = FormField::findOrFail($dropId);
        $dragField = FormField::findOrFail($dragId);

        DB::connection('tenant')->table('form_fields')
            ->where('recruitment_id', $dropField->recruitment_id)

The property recruitment_id does not exist on App\Models\FormField. Did you mean recruitment?

            ->where('order', '>', $dropField->order)
            ->where('order', '<', $dragField->order)
            ->increment('order');

        DB::connection('tenant')->table('form_fields')
            ->where('recruitment_id', $dropField->recruitment_id)
            ->where('order', '>', $dragField->order)
            ->where('order', '<=', $dropField->order)
            ->decrement('order');

        if ($dragField->order > $dropField->order) {
            $dragField->order = $dropField->order + 1;

The property order does not seem to exist on Illuminate\Database\Eloquent\Collection.

        } else {
            $dragField->order = $dropField->order;
        }
        $dragField->save();

        return FormField::where('recruitment_id', $dropField->recruitment_id)->orderBy('order')->get();
    }
}