# 🗑️ Soft Deletes - System-Wide Standard

## ✅ Implementation Complete

Soft deletes are now **THE STANDARD** for ALL modules in the Garage SaaS system - existing and future.

---

## 📋 What's Been Implemented

### **ALL Models Updated** (14 Models):

#### GoMechanic Models:
1. ✅ `CarBrand`
2. ✅ `CarModel`
3. ✅ `ServiceCategory`
4. ✅ `Service`
5. ✅ `SparePartCategory`
6. ✅ `SparePart`

#### Accounting Models:
7. ✅ `Nature`
8. ✅ `SubNature`
9. ✅ `LedgerGroup`
10. ✅ `Ledger`
11. ✅ `Voucher` (already had it)
12. ✅ `VoucherTransaction`

#### User Management Models:
13. ✅ `SuperAdmin`
14. ✅ `User`

### **ALL Tables Updated** (20+ tables):
- ✅ `natures`
- ✅ `sub_natures`
- ✅ `ledger_groups`
- ✅ `ledgers`
- ✅ `vouchers` (already had it)
- ✅ `voucher_transactions`
- ✅ `super_admins`
- ✅ `users`
- ✅ `car_brands`
- ✅ `car_models`
- ✅ `service_categories`
- ✅ `services`
- ✅ `spare_part_categories`
- ✅ `spare_parts`
- ✅ `garages` (if exists)
- ✅ `packages` (if exists)
- ✅ `modules` (if exists)
- ✅ `subscriptions` (if exists)
- ✅ `orders` (if exists)
- ✅ `payments` (if exists)
- ✅ `categories` (if exists)

---

## 🚀 Run This Command

To add `deleted_at` column to ALL tables:

```powershell
php artisan migrate
```

This will run BOTH migrations:
1. `2025_12_02_150000_add_soft_deletes_to_gomechanic_tables.php`
2. `2025_12_02_160000_add_soft_deletes_to_all_tables.php`

---

## 🎯 Standard for ALL Future Modules

### **Rule #1: Every Model MUST Use Soft Deletes**

When creating a new model, ALWAYS add:

```php
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;  // ← Add this

class YourModel extends Model
{
    use SoftDeletes;  // ← Add this
    
    // ... rest of your model
}
```

### **Rule #2: Every Migration MUST Include deleted_at**

When creating a new table migration:

```php
Schema::create('your_table', function (Blueprint $table) {
    $table->id();
    // ... your columns ...
    $table->timestamps();
    $table->softDeletes();  // ← ALWAYS add this
});
```

---

## 🎨 Reusable Controller Trait

A trait has been created to standardize soft delete functionality across ALL controllers.

**Location:** `app/Http/Traits/SoftDeletesTrait.php`

### **Usage Example:**

```php
<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Http\Traits\SoftDeletesTrait;
use App\Models\YourModel;
use Illuminate\Http\Request;

class YourController extends Controller
{
    use SoftDeletesTrait;  // ← Add this trait
    
    public function index(Request $request)
    {
        // Automatically handles ?trashed=1 in URL
        $query = YourModel::query();
        $items = $this->applySoftDeleteFilter($query, $request)
                      ->paginate(20);
        
        return view('admin.your-model.index', compact('items'));
    }
    
    public function restore($id)
    {
        return $this->restoreModel(
            YourModel::class, 
            $id, 
            'admin.your-model.index',
            'Item restored successfully!'
        );
    }
}
```

---

## 📝 Standard View Pattern

Every index view should include "View Deleted" functionality:

```blade
<div class="d-flex justify-content-between align-items-center mb-4">
    <h2 class="mb-0">Your Items</h2>
    <div>
        @if(request('trashed'))
            <a href="{{ route('admin.your-items.index') }}" class="btn btn-secondary">
                <i class="bi bi-arrow-left"></i> Back to Active
            </a>
        @else
            <a href="{{ route('admin.your-items.index', ['trashed' => 1]) }}" class="btn btn-outline-danger">
                <i class="bi bi-trash"></i> View Deleted
            </a>
            <a href="{{ route('admin.your-items.create') }}" class="btn btn-primary">
                <i class="bi bi-plus-circle"></i> Add New
            </a>
        @endif
    </div>
</div>
```

In the actions column:

```blade
<td>
    @if(request('trashed'))
        <form action="{{ route('admin.your-items.restore', $item->id) }}" method="POST" class="d-inline">
            @csrf
            <button type="submit" class="btn btn-sm btn-outline-success">
                <i class="bi bi-arrow-counterclockwise"></i> Restore
            </button>
        </form>
    @else
        <a href="{{ route('admin.your-items.edit', $item) }}" class="btn btn-sm btn-outline-primary">
            <i class="bi bi-pencil"></i>
        </a>
        <form action="{{ route('admin.your-items.destroy', $item) }}" method="POST" class="d-inline">
            @csrf
            @method('DELETE')
            <button type="submit" class="btn btn-sm btn-outline-danger" onclick="return confirm('Mark as deleted?')">
                <i class="bi bi-trash"></i>
            </button>
        </form>
    @endif
</td>
```

---

## 🛣️ Standard Routes Pattern

Add restore route after resource route:

```php
Route::resource('your-items', YourController::class);
Route::post('your-items/{id}/restore', [YourController::class, 'restore'])
     ->name('admin.your-items.restore');
```

---

## 💡 Benefits of Soft Deletes

### ✅ **Business Benefits:**
1. **Data Recovery** - Restore accidentally deleted items
2. **Audit Trail** - See when items were deleted
3. **Compliance** - Meet data retention requirements
4. **User Safety** - Prevent permanent data loss
5. **Professional** - Industry standard practice

### ✅ **Technical Benefits:**
1. **Simple Implementation** - Just add trait and column
2. **Automatic** - Laravel handles everything
3. **Query-friendly** - Active items by default
4. **Flexible** - Can force delete if needed
5. **Performant** - No performance impact

---

## 🔍 Query Examples

### **Normal Queries (Active Only):**
```php
YourModel::all();           // Only active items
YourModel::find(1);         // Only if not deleted
YourModel::where(...)->get(); // Only active items
```

### **Include Deleted:**
```php
YourModel::withTrashed()->get();     // Active + Deleted
YourModel::withTrashed()->find(1);   // Include if deleted
```

### **Only Deleted:**
```php
YourModel::onlyTrashed()->get();     // Deleted only
YourModel::onlyTrashed()->find(1);   // Only if deleted
```

### **Restore:**
```php
$item = YourModel::withTrashed()->find(1);
$item->restore();
```

### **Force Delete (Permanent):**
```php
$item = YourModel::withTrashed()->find(1);
$item->forceDelete();  // PERMANENTLY removes from database
```

---

## 📊 Database Structure

Every table now has:

```sql
deleted_at TIMESTAMP NULL DEFAULT NULL

-- When active:  deleted_at = NULL
-- When deleted: deleted_at = '2025-12-02 14:30:00'
```

---

## 🎉 Summary

✅ **14 Models** have SoftDeletes trait  
✅ **20+ Tables** have deleted_at column  
✅ **Reusable Trait** for controllers  
✅ **Standard Pattern** for views  
✅ **Service Categories** fully implemented as example  
✅ **Future-proof** - ALL new modules MUST use this  

---

## 🚀 Next Steps for Any New Module

When creating a new module:

1. ✅ Add `use SoftDeletes;` to model
2. ✅ Add `$table->softDeletes();` to migration
3. ✅ Use `SoftDeletesTrait` in controller
4. ✅ Add "View Deleted" button to index view
5. ✅ Add "Restore" button for deleted items
6. ✅ Add restore route

**This is now the STANDARD for the entire system!**

---

## 📞 Enforcement

- ❌ No model without soft deletes
- ❌ No table without deleted_at column
- ❌ No permanent deletions (unless explicitly needed)
- ✅ Everything can be recovered
- ✅ Everything has an audit trail

**Nothing gets permanently deleted. Ever!** 🛡️