[[oktatas:web:back-end_framework:leaf|< Leaf]]

====== Leaf modell ======

  * **Szerző:** Sallai András
  * Copyright (c) 2024, Sallai András
  * Licenc: [[https://creativecommons.org/licenses/by-sa/4.0/|CC BY-SA 4.0]]
  * Web: https://szit.hu

===== Modell létrehozása =====

  * https://leafphp.dev/docs/mvc/models.html (2024)

  php leaf g:model Employee


<code php app/models/Employee.php>
<?php

namespace App\Models;

class Employee extends Model
{
    // 
}

</code>

===== Modell és tábla összekapcsolása =====



Az Employee modellt hozzákötjük a táblához.

<code php app/models/Employee.php>
<?php

namespace App\Models;

class Employee extends Model
{
    protected $table = 'employees';
}

</code>


A működéshez szükség van az adatbázis modul telepítésére:
  leaf install db

===== A modell használata a kontrollerben =====

<code php app/controllers/EmployeesController.php>

use App\Models\Employee;
//...

    public function index()
    {
        $employees = Employee::all();
        response()->json([
            'employees' => $employees
        ]);
    }
</code>

===== Ellenőrzés =====

  http localhost:5500/employees

===== A modell használata create műveletre =====

<code php app/controllers/EmployeesController.php>
//...
use App\Models\Employee;
//...

    public function store() {
        
        $employee = new Employee;
        $employee->name = request()->get('name');
        $employee->city = request()->get('city');
        $employee->salary = request()->get('salary');
        $res = $employee->save();

        response()->json([
            'success' => $res
        ]);
    }
</code>


===== A modell használata update műveletre =====

<code php app/controllers/EmployeesController.php>
//...
use App\Models\Employee;
//...
    public function update($id) {
        $employee = Employee::find($id);
        $employee->name = request()->get('name');
        $employee->city = request()->get('city');
        $employee->salary = request()->get('salary');
        $res = $employee->save();

        response()->json([
            'success' => $res
        ]);        
    }
</code>


===== A modell használata Delete műveletre =====

<code php app/controllers/EmployeesController.php>
//...
use App\Models\Employee;
//...
    public function delete($id) {
        $employee = Employee::find($id);
        $res = $employee->delete();

        response()->json([
            'success' => $res
        ]);        
    }
</code>