[ANSWERED] No data retrieved when loading newly-implemented index page

[frostFRP]

(IDK if this is the right place to ask this, or if I should have opened an Issue, but here I am 😅)

Hi everyone,

I am trying to implement a new page, called "Procedures", and this comes obviously with many Views and other stuff.
I built the Procedure object, with both the Controllers, the Transformer, the index.blade and edit.blade (view.blade is yet to be implemented), built a db table ad-hoc, added all the routes both to web.php and api.php and so on.

So, the problem is, when i go to the [IP-address]/procedures page, everything seems to work fine, except for the fact that the table shows the "no matching results found" text instead of loading the results from the db table; which is strange, since when I load a new record via the edit.blade page, the new record uploads inside the db without problems:

Procedures Table when index page is loaded

Data stored inside the database (this works fine!)

Here is the new code I added:

PROCEDURE OBJECT app/models/Procedure.php (BRAND NEW)

namespace App\Models;

use App\Http\Traits\UniqueUndeletedTrait;
use App\Models\Traits\Searchable;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\SoftDeletes;
use Watson\Validating\ValidatingTrait;
use App\Models\Loggable;

class Procedure extends SnipeModel
{
    use HasFactory;
    use SoftDeletes;
    use Loggable, Requestable;

    protected $table = 'procedures';

    protected $rules = [
        'name'              => 'required|min:1|max:255|unique_undeleted',
        'author'            => 'max:250|nullable',
        'type'              => 'required|min:3|max:255',
        'notes'             => 'max:191|nullable', // Default string length is 191 characters..
        ];
    protected $injectUniqueIdentifier = true;
    use ValidatingTrait;
    use UniqueUndeletedTrait;
    use Searchable;

    protected $searchableAttributes = ['name', 'author'];

    protected $fillable = ['name', 'author', 'type', 'notes'];

    public function uploads()
    {
        return $this->hasMany(\App\Models\Actionlog::class, 'item_id')
            ->where('item_type', Supplier::class)
            ->where('action_type', '=', 'uploaded')
            ->whereNotNull('filename')
            ->orderBy('created_at', 'desc');
    }
}

/resources/views/procedures/index.blade.php (BRAND NEW)

{{-- Page title --}}
@section('title')
{{ trans('admin/procedures/table.procedures') }}
@parent
@stop

{{-- Page content --}}
@section('content')

@section('header_right')
  @can('create', \App\Models\Procedure::class)
    <a href="{{ route('procedures.create') }}" class="btn btn-primary pull-right"> {{ trans('general.create') }}</a>
  @endcan
@stop

<div class="row">
  <div class="col-md-12">
    <div class="box box-default">
      <div class="box-body">
      <div class="table-responsive">

        <table
            data-cookie-id-table="proceduresTable"
            data-pagination="true"
            data-id-table="proceduresTable"
            data-search="true"
            data-side-pagination="server"
            data-show-columns="true"
            data-show-fullscreen="true"
            data-show-export="true"
            data-show-refresh="true"
            data-sort-order="asc"
            id="proceduresTable"
            class="table table-striped snipe-table"
            data-url="{{route('api.procedures.index') }}"
            data-export-options='{
            "fileName": "export-procedures-{{ date('Y-m-d') }}",
            "ignoreColumn": ["actions","image","change","checkbox","checkincheckout","icon"]
            }'>
            
        <thead>
          <tr>
            <th data-sortable="true" data-field="id" data-visible="false">{{ trans('admin/procedures/table.id') }}</th>
            <th data-sortable="true" data-formatter="proceduresLinkFormatter" data-sortable="true" data-field="name" >{{ trans('admin/procedures/table.name') }}</th> 
            <th data-searchable="false" data-sortable="true" data-field="type">{{ trans('admin/procedures/table.type') }}</th>
            <th data-sortable="true" data-field="author" data-visible="false">{{ trans('admin/procedures/table.author') }}</th>
            <th data-sortable="true" data-formatter="notesFormatter" data-field="notes" data-visible="false">{{ trans('admin/procedures/table.notes') }}</th>
            <th data-switchable="false" data-formatter="departmentsActionsFormatter" data-searchable="false" data-sortable="false" data-field="actions">{{ trans('table.actions') }}</th>
          </tr>
        </thead>
      </table>
      </div>
    </div>
  </div>
  </div>
</div>
@stop

@section('moar_scripts')
@include('partials.bootstrap-table')
@stop

/resources/views/procedures/edit.blade.php (BRAND NEW)

    @extends('layouts/edit-form', [
    'createText' => trans('admin/procedures/table.create') ,
    'updateText' => trans('admin/procedures/table.update'),
    'helpTitle' => trans('admin/procedures/table.about_procedures_title'),
    'helpText' => trans('admin/procedures/table.about_procedures_text'),
    'formAction' => (isset($item->id)) ? route('procedures.update', ['procedure' => $item->id]) : route('procedures.store'),
])

{{-- Page content --}}
@section('inputFields')

@include ('partials.forms.edit.name', ['translated_name' => trans('admin/procedures/table.name')])
@include ('partials.forms.edit.procedure-type', ['translated_name' => trans('admin/procedures/table.type')])
@include ('partials.forms.edit.procedure-author', ['translated_name' => trans('admin/procedures/table.procedure-author')])
@include ('partials.forms.edit.notes')

@stop

CODE ADDED TO routes/api.php

        /**
        * Procedures routes
        */
        
        Route::resource('procedures', 
            Api\ProceduresController::class,
            ['names' => 
                [
                    'index' => 'api.procedures.index',
                    'show' => 'api.procedures.show',
                    'update' => 'api.procedures.update',
                    'store' => 'api.procedures.store',
                    'destroy' => 'api.procedures.destroy',
                ],
            'except' => ['create', 'edit'],
            'parameters' => ['procedure' => 'procedure_id'],
            ]
        ); // end category API routes

CODE ADDED TO routes/web.php

/*
    * Procedures
     */
    Route::resource('procedures', ProceduresController::class, [
        'parameters' => ['procedure' => 'procedure_id'],
    ]);

STANDARD CONTROLLER - /app/Http/Controllers/ProceduresController.php (BRAND NEW)

namespace App\Http\Controllers;

use App\Http\Requests\ImageUploadRequest;
use App\Models\Procedure;
use Illuminate\Support\Facades\Auth;


class ProceduresController extends Controller
{
    public function index()
    {
        $this->authorize('index', Procedure::class);

        return view('procedures/index');
    }

    public function create()
    {
        $this->authorize('create', Procedure::class);

        return view('procedures/edit')->with('item', new Procedure);
    }

    public function store()
    {
        $this->authorize('create', Procedure::class);
        // Create a new procedure
        $procedure = new Procedure;
        // Save the location data
        $procedure->name = request('name');
        $procedure->author = request('author');
        $procedure->type = request('type');
        $procedure->notes = request('notes');

        if ($procedure->save()) {
            return redirect()->route('procedures.index')->with('success', trans('admin/procedures/message.create.success'));
        }

        return redirect()->back()->withInput()->withErrors($procedure->getErrors());
    }

    public function edit($procedureID = null)
    {
        $this->authorize('update', Procedure::class);
        // Check if the procedure exists
        if (is_null($item = Procedure::find($procedureID))) {
            // Redirect to the procedure  page
            return redirect()->route('procedures.index')->with('error', trans('admin/procedures/message.does_not_exist'));
        }

        // Show the page
        return view('procedures/edit', compact('item'));
    }

    public function update($procedureId)
    {
        $this->authorize('update', Procedure::class);
        // Check if the procedure exists
        if (is_null($procedure = Procedure::find($procedureId))) {
            // Redirect to the procedure  page
            return redirect()->route('procedures.index')->with('error', trans('admin/procedures/message.does_not_exist'));
        }

        // Save the  data
        $procedure->name = request('name');
        $procedure->author = request('author');
        $procedure->type = request('type');
        $procedure->notes = request('notes');

        if ($procedure->save()) {
            return redirect()->route('procedures.index')->with('success', trans('admin/procedures/message.update.success'));
        }

        return redirect()->back()->withInput()->withErrors($procedure->getErrors());
    }

    public function destroy($procedureId)
    {
        $this->authorize('delete', Procedure::class);
        if (is_null($procedure = Procedure::find($procedureId))) {
            return redirect()->route('procedures.index')->with('error', trans('admin/procedures/message.not_found'));
        }

        $procedure->delete();

        return redirect()->route('procedures.index')->with('success',
            trans('admin/procedures/message.delete.success')
        );
    }

    public function show($procedureId = null)
    {
        $this->authorize('view', Procedure::class);
        $procedure = Procedure::find($procedureId);

        if (isset($procedure->id)) {
            return view('procedures/view', compact('procedure'));
        }

        return redirect()->route('procedures.index')->with('error', trans('admin/procedures/message.does_not_exist'));
    }
}

API CONTROLLER - /app/Http/Controllers/Api/ProceduresController.php (BRAND NEW)
This is where something goes wrong!

namespace App\Http\Controllers\Api;

use App\Helpers\Helper;
use App\Http\Controllers\Controller;
use App\Http\Transformers\SelectlistTransformer;
use App\Http\Transformers\ProceduresTransformer;
use App\Models\Procedure;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;

class ProceduresController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @author [A. Gianotto] [<[email protected]>]
     * @since [v4.0]
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $this->authorize('view', Procedure::class);
        $allowed_columns = ['id', 'name', 'author', 'type', 'notes'];
        
        $procedures = Procedure::select( ['id', 'name', 'type', 'author', 'created_at', 'notes']);

        if ($request->filled('search')) {
            $procedures = $procedures->TextSearch($request->input('search'));
        }

        if ($request->filled('name')) {
            $procedures->where('name', '=', $request->input('name'));
        }

        if ($request->filled('type')) { 
            $procedures->where('type', '=', $request->input('type'));
        }

        if ($request->filled('author')) {
            $procedures->where('author', '=', $request->input('author'));
        }

        if ($request->filled('notes')) {
            $procedures->where('notes', '=', $request->input('notes'));
        }

        // Set the offset to the API call's offset, unless the offset is higher than the actual count of items in which
        // case we override with the actual count, so we should return 0 items.
        $offset = (($procedures) && ($request->get('offset') > $procedures->count())) ? $procedures->count() : $request->get('offset', 0);

        // Check to make sure the limit is not higher than the max allowed
        ((config('app.max_results') >= $request->input('limit')) && ($request->filled('limit'))) ? $limit = $request->input('limit') : $limit = config('app.max_results');

        $order = $request->input('order') === 'asc' ? 'asc' : 'desc';
        $sort = in_array($request->input('sort'), $allowed_columns) ? $request->input('sort') : 'created_at';
        $procedures->orderBy($sort, $order);

        $total = $procedures->count();
        $procedures = $procedures->skip($offset)->take($limit)->get();

        return (new ProceduresTransformer)->transformProcedures($procedures, $total); 
    }

    public function store()
    {
        $this->authorize('create', Procedure::class);
        $procedure = new Procedure;

        if ($procedure->save()) {
            return response()->json(Helper::formatStandardApiResponse('success', $procedure, trans('admin/procedures/message.create.success')));
        }

        return response()->json(Helper::formatStandardApiResponse('error', null, $procedure->getErrors()));

    }

    public function update($id)
    {
        $this->authorize('update', Procedure::class);
        $procedure = Procedure::findOrFail($id);

        if ($procedure->save()) {
            return response()->json(Helper::formatStandardApiResponse('success', $procedure, trans('admin/procedures/message.update.success')));
        }

        return response()->json(Helper::formatStandardApiResponse('error', null, $procedure->getErrors()));
    }

    public function show($id)
    {
        $this->authorize('view', Procedure::class);
        $procedure = Procedure::findOrFail($id);

        return (new ProceduresTransformer)->transformProcedure($procedure);
    }

    public function destroy($id)
    {
        
        $this->authorize('delete', Procedure::class);
        $procedure = Procedure::findOrFail($id);
        $this->authorize('delete', $procedure);

        $procedure->delete();

        return response()->json(Helper::formatStandardApiResponse('success', null, trans('admin/procedures/message.delete.success')));
    }
}

TRANSFORMER - /app/Http/Transformers/ProceduresTransformer.php (BRAND NEW)

<?php

namespace App\Http\Transformers;

use App\Helpers\Helper;
use App\Models\Procedure;
use Gate;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Support\Facades\Storage;

class ProceduresTransformer
{
    public function transformProcedures(Collection $procedures, $total)
    {
        $array = [];
        foreach ($procedures as $procedure) {
            $array[] = self::transformProcedure($procedure);
        }

        return (new DatatablesTransformer)->transformDatatables($array, $total);
    }

    public function transformProcedure(Procedure $procedure = null)
    {
        if ($procedure) {
            $array = [
                'id' => (int) $procedure->id,
                'name' => e($procedure->name),
                'type' => e($procedure->type),
                'author' => e($procedure->author),
                'notes' => ($procedure->notes) ? e($procedure->notes) : null,
                'created_at' => Helper::getFormattedDateObject($procedure->created_at, 'datetime'),
                'updated_at' => Helper::getFormattedDateObject($procedure->updated_at, 'datetime'),

            ];

            $permissions_array['available_actions'] = [
                'update' => Gate::allows('update', Procedure::class),
                'delete' => Gate::allows('delete', Procedure::class),
            ];

            $array += $permissions_array;

            return $array;
        }
    }
}

For what i've seen, it seems to have some problems in the index method of /app/Http/Controllers/Api/ProceduresController.php, but i don't understand what and where it may be. My hypotesis at this point is that i'm missing some routes/references to the db, but i'm not sure about that.

Can someone help me? Am I missing something? Did I forget to add some routes?
Thank you in advance for your support! Have a nice day!

[frostFRP]

Just finished implementing the view.blade.php page, and I can retrieve info from DB without any problem...

really don't get what's wrong with that index() method:

public function index(Request $request)
    {
        $this->authorize('view', Procedure::class);
        $allowed_columns = ['id', 'name', 'author', 'type', 'notes'];
        
        $procedures = Procedure::select( ['id', 'name', 'type', 'author', 'created_at', 'notes']);

        if ($request->filled('search')) {
            $procedures = $procedures->TextSearch($request->input('search'));
        }

        if ($request->filled('name')) {
            $procedures->where('name', '=', $request->input('name'));
        }

        if ($request->filled('type')) { 
            $procedures->where('type', '=', $request->input('type'));
        }

        if ($request->filled('author')) {
            $procedures->where('author', '=', $request->input('author'));
        }

        if ($request->filled('notes')) {
            $procedures->where('notes', '=', $request->input('notes'));
        }

        // Set the offset to the API call's offset, unless the offset is higher than the actual count of items in which
        // case we override with the actual count, so we should return 0 items.
        $offset = (($procedures) && ($request->get('offset') > $procedures->count())) ? $procedures->count() : $request->get('offset', 0);

        // Check to make sure the limit is not higher than the max allowed
        ((config('app.max_results') >= $request->input('limit')) && ($request->filled('limit'))) ? $limit = $request->input('limit') : $limit = config('app.max_results');

        $order = $request->input('order') === 'asc' ? 'asc' : 'desc';
        $sort = in_array($request->input('sort'), $allowed_columns) ? $request->input('sort') : 'created_at';
        $procedures->orderBy($sort, $order);

        $total = $procedures->count();
        $procedures = $procedures->skip($offset)->take($limit)->get();

        return (new ProceduresTransformer)->transformProcedures($procedures, $total); 
    }

I really don't get what I'm wrong... perhaps it's the way I invoke the Procedure::select method...?

[frostFRP]

Gave a look at the storage/logs/laravel.log file and figured out what was breaking my code.
Turns out there was a wrong import:

While the import was pointing to ProceduresTransformer.php, as it's showed in the image, i named the actual file as ProcedureTransformer.php so obviously the file wasn't being found. After renaming the file the file everything worked fine: