13. Query Scopes, Custom Eloquent Casts, Mutators/Accessors & Raw Query Optimizations • PHP 8+ & Laravel 11/12: Enterprise Full-Stack AI Developer • Rishabh Ki Kaksha

PHP 8+ & Laravel 11/12: Enterprise Full-Stack AI Developer › 13. Query Scopes, Custom Eloquent Casts, Mutators/Accessors & Raw Query Optimizations

45 mins

← Prev Next →

Course Syllabus

Module 1: Modern PHP 8.2/8.3 Internals, Type System & CLI

01. PHP 8.2/8.3 Evolution: JIT Compiler, Zend VM Internals & Strict Typing System 02. Control Flow, Pattern Matching with match(), First-Class Callables & Fiber Concurrency 03. Modern OOP PHP: Constructor Promotion, Readonly Classes, Traits, Enums & Attributes

Module 2: Dependency Management, Autoloading & Database Engineering

04. Composer Mastery: PSR-4 Autoloading, Custom Packages & Composer Scripts 05. PDO Database Layer: Prepared Statements, SQL Injection Defense & Transaction Savepoints 06. Memory Profiling, Garbage Collection (Zend GC) & OPcache Performance Tuning

Module 3: Laravel 11/12 Core Architecture & Service Container

07. Laravel 11/12 Architecture: Request Lifecycle, bootstrap/app.php & Service Providers 08. The Inversion of Control (IoC) Service Container & Automatic Dependency Injection 09. Middleware Pipeline, Custom Global Pipeline Handlers & Terminating Middleware 10. Advanced Routing, Route Model Binding & Rate Limiting (Throttle Middleware)

Module 4: Eloquent ORM Masterclass & High-Scale Database Systems

11. Eloquent ORM Internals: Active Record vs Data Mapper, Eager vs Lazy Loading (N+1 Problem) 12. Advanced Relationships: Polymorphic, Many-to-Many with Pivots & HasManyThrough 13. Query Scopes, Custom Eloquent Casts, Mutators/Accessors & Raw Query Optimizations

Module 5: High-Performance Queues, WebSockets & Security Architecture

14. Laravel Queues & Background Jobs: Redis Drivers, Horizon, Retries & Dead Letter Queues 15. Real-Time Event Broadcasting with Laravel Reverb, WebSockets & Echo 16. Authentication & API Security: Laravel Sanctum, Passport (OAuth2) & Policy Gates (RBAC) 17. Security Hardening: CSRF, XSS, Mass Assignment Protection & Encrypted Cookies

Module 6: Enterprise Full-Stack AI, Testing & Cloud Deployment

18. Testing Masterclass: Pest PHP, PHPUnit, Database Transactions & Mocking HTTP Calls 19. Enterprise Generative AI Integration: LLM Tool Calling, Vector Search & OpenAI/Claude APIs 20. Production Deployment: Laravel Octane (FrankenPHP/Swoole), PM2/Supervisor & Docker Deployments

Interactive Lesson Studio

# 13. Query Scopes, Custom Eloquent Casts, Mutators/Accessors & Raw Query Optimizations

> PHP 8+ & Laravel 11/12 Notes by Rishabh - Topic 13

---

### 1. Global vs Local Query Scopes 🔍

*   **Local Scope:** Reusable query filter builder.
    ```php
    public function scopeActivePro(Builder $query): void {
        $query->where('status', 'active')->where('is_pro', true);
    }
    // Usage: User::activePro()->get();
    ```
*   **Global Scope (Tenant Isolation 👑):** Har query par automatically `WHERE tenant_id = current_tenant()` inject kar dena!

---

### 2. Modern Value Object Custom Casts (PHP 8.2+)

```php
use Illuminate\Contracts\Database\Eloquent\CastsAttributes;

class EncryptedJsonCast implements CastsAttributes {
    public function get($model, string $key, $value, array $attributes) {
        return json_decode(Crypt::decryptString($value), true);
    }

public function set($model, string $key, $value, array $attributes) {
        return Crypt::encryptString(json_encode($value));
    }
}
```

---

### 3. Interview Ke 3 Sawal Is Topic Se

1. **Global Scope bypass kaise karte hain?** -> `User::withoutGlobalScope(TenantScope::class)->get()`.
2. **Accessors/Mutators in Laravel 11 (Attribute Return Type) kaise likhte hain?** -> `protected function firstName(): Attribute { return Attribute::make(get: fn($v) => ucfirst($v), set: fn($v) => strtolower($v)); }`.
3. **`selectSub` / Subquery Joins memory kyu save karte hain?** -> Heavy model hydration loop chalaye bina direct database level par aggregated metric column join karna.

---
**Next Topic:** 14. Laravel Queues & Background Jobs: Redis Drivers, Horizon, Retries & Dead Letter Queues

Loading lesson content...

PHP 8.3

Live Execution Terminal

Click "Execute Live" to run code.
                