feat(TransmittalResource): enhance search functionality across related models

Implement wildcard search on transmittal series, notes, and files to improve user experience when filtering records. Also extend search capabilities to client company and branch code fields for more comprehensive filtering.

app/Filament/Resources/TransmittalResource.php

@@ -45,16 +45,36 @@ class TransmittalResource extends Resource
             ->columns([
                 Tables\Columns\Layout\Split::make([
                     Tables\Columns\TextColumn::make('series')
-                        ->searchable()
+                        ->searchable(query: function (Builder $query, string $search): Builder {
+                            $wildcardSearch = '%' . str_replace(' ', '%', $search) . '%';
+
+                            return $query->where(function (Builder $query) use ($wildcardSearch) {
+                                $query->where('series', 'like', $wildcardSearch)
+                                    ->orWhereHas('notes', function (Builder $query) use ($wildcardSearch) {
+                                        $query->where('comment', 'like', $wildcardSearch);
+                                    })
+                                    ->orWhereHas('files', function (Builder $query) use ($wildcardSearch) {
+                                        $query->where('description', 'like', $wildcardSearch);
+                                    });
+                            });
+                        })
                         ->label('Series')
                         ->weight(FontWeight::Bold)
                         ->columnSpan(2),
                     Tables\Columns\Layout\Stack::make([
                         Tables\Columns\TextColumn::make('client.company')
-                            ->searchable()
+                            ->searchable(query: function (Builder $query, string $search): Builder {
+                                return $query->whereHas('client', function (Builder $query) use ($search) {
+                                    $query->where('company', 'like', '%' . str_replace(' ', '%', $search) . '%');
+                                });
+                            })
                             ->weight(FontWeight::SemiBold)->label('Client'),
                         Tables\Columns\TextColumn::make('branch.code')
-                            ->searchable()
+                            ->searchable(query: function (Builder $query, string $search): Builder {
+                                return $query->whereHas('branch', function (Builder $query) use ($search) {
+                                    $query->where('code', 'like', '%' . str_replace(' ', '%', $search) . '%');
+                                });
+                            })
                             ->label('Branch'),
                     ]),
                 ]),

app/Models/User.php

@@ -3,16 +3,23 @@
 namespace App\Models;
 
 // use Illuminate\Contracts\Auth\MustVerifyEmail;
+use Filament\Models\Contracts\FilamentUser;
+use Filament\Panel;
 use Illuminate\Database\Eloquent\Factories\HasFactory;
 use Illuminate\Foundation\Auth\User as Authenticatable;
 use Illuminate\Notifications\Notifiable;
 use Spatie\Permission\Traits\HasPermissions;
 use Spatie\Permission\Traits\HasRoles;
 
-class User extends Authenticatable
+class User extends Authenticatable implements FilamentUser
 {
     use HasFactory, HasPermissions, HasRoles, Notifiable;
 
+    public function canAccessPanel(Panel $panel): bool
+    {
+        return true;
+    }
+
     /**
      * The attributes that are mass assignable.
      *

app/Providers/AppServiceProvider.php

@@ -4,6 +4,7 @@ namespace App\Providers;
 
 use App\Policies\RolePolicy;
 use Illuminate\Support\Facades\Gate;
+use Illuminate\Support\Facades\URL;
 use Illuminate\Support\ServiceProvider;
 use Spatie\Permission\Models\Role;
 
@@ -22,6 +23,8 @@ class AppServiceProvider extends ServiceProvider
      */
     public function boot(): void
     {
+        URL::forceScheme('https');
+
         Gate::before(function ($user, $ability) {
             return $user->hasRole('super_admin') ? true : null;
         });

database/migrations/2026_02_10_212218_update_client_id_foreign_on_accounts_table.php

@@ -0,0 +1,36 @@
+<?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(): void
+    {
+        Schema::table('accounts', function (Blueprint $table) {
+            $table->dropForeign(['client_id']);
+            $table->foreign('client_id')
+                ->references('id')
+                ->on('clients')
+                ->cascadeOnDelete();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('accounts', function (Blueprint $table) {
+            $table->dropForeign(['client_id']);
+            $table->foreign('client_id')
+                ->references('id')
+                ->on('clients')
+                ->nullOnDelete(); // Since it is nullable
+        });
+    }
+};

database/migrations/2026_02_10_212331_update_foreign_keys_on_transmittals_table.php

@@ -0,0 +1,48 @@
+<?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(): void
+    {
+        Schema::table('transmittals', function (Blueprint $table) {
+            $table->dropForeign(['client_id']);
+            $table->dropForeign(['branch_id']);
+
+            $table->foreign('client_id')
+                ->references('id')
+                ->on('clients')
+                ->cascadeOnDelete();
+
+            $table->foreign('branch_id')
+                ->references('id')
+                ->on('branches')
+                ->cascadeOnDelete();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('transmittals', function (Blueprint $table) {
+            $table->dropForeign(['client_id']);
+            $table->dropForeign(['branch_id']);
+
+            $table->foreign('client_id')
+                ->references('id')
+                ->on('clients');
+
+            $table->foreign('branch_id')
+                ->references('id')
+                ->on('branches');
+        });
+    }
+};