[0] Prep

Continue from previous article or download quickstart file.

[1] Migration Tasks

[1.1] Create migration file

COPY

php artisan make:migration create_workgroups_table --create=workgroups

[1.2] Edit migration file

Assuming we have the following DDL:

CREATE TABLE "workgroups" (
"id" INTEGER,
"hid" TEXT,
"name" TEXT,
"refr" TEXT,
"desc" TEXT,
"locn" TEXT,
"estartdate" INT,
"key1" TEXT,
"key2" TEXT,
"key3" TEXT,
"key4" TEXT,
"key5" TEXT,
"n" INT,
"admn" INT,
"cord" INT,
"modr" INT,
"oper" INT,
PRIMARY KEY("id" AUTOINCREMENT)
)

File C:\laragon\www\razzi\database\migrations\2024_03_31_093600_create_workgroups_table.php :

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up()
    {
        Schema::create('workgroups', function (Blueprint $table) {
            $table->increments('id');
            $table->string('hid');
            $table->string('name');
            $table->string('refr');
            $table->string('desc');
            $table->string('locn');
            $table->integer('estartdate');
            $table->string('key1');
            $table->string('key2');
            $table->string('key3');
            $table->string('key4');
            $table->string('key5');
            $table->integer('n');
            $table->integer('admn');
            $table->integer('cord');
            $table->integer('modr');
            $table->integer('oper');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('workgroups');
    }
};

[1.2] Create model

php artisan make:model Workgroup

[1.3] Run migration

php artisan migrate

[1.4] Import CSV data

php artisan app:import-csv-data C:\laragon\z\razzi\workgroups.csv --table=workgroups

Outcome:

[2] Add page to view records

Create a new route: Open your routes/web.php file and add a route that maps to a controller method or a closure.

use App\Http\Controllers\WorkgroupController;

Route::get('/workgroups', [WorkgroupController::class, 'index'])->name('workgroups.index');

Create a new controller: Run the following command to generate a new controller:

php artisan make:controller WorkgroupController

This will create a new WorkgroupController.php file in the app/Http/Controllers directory.

Define the index method: Open the WorkgroupController.php file and define the index method. This method will handle the logic for retrieving all members and passing them to the view.

File C:\laragon\www\razzi\app\Http\Controllers\WorkgroupController.php :

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Workgroup;

class WorkgroupController extends Controller
{
    public function index()
    {
        $workgroups = Workgroup::all();
        return view('workgroups.index', compact('workgroups'));
    }
}

Create a view: Create a new file named index.blade.php in the resources/views/workgroups directory. This file will contain the HTML markup for displaying the members.

File C:\laragon\www\razzi\resources\views\workgroups\index.blade.php:

<h1>Workgroups</h1>

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>Refr</th>
            <th>Desc</th>
            <th>Locn</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($workgroups as $workgroup)
        <tr>
            <td>{{ $workgroup->name }}</td>
            <td>{{ $workgroup->refr }}</td>
            <td>{{ $workgroup->desc }}</td>
            <td>{{ $workgroup->locn }}</td>
        </tr>
        @endforeach
    </tbody>
</table>

Output:

[3] Integrate into Breeze dashboard

[3.1] Add the link into the layout file

                    <x-nav-link :href="route('workgroups.index')" :active="request()->routeIs('dashboard')">
                        {{ __('Workgroups') }}
                    </x-nav-link>

[2.2] Add the Breeze layout into the view file