Eloquent Add/Update or DELETE

To efficiently sync data between the employees and active_employees tables in Laravel, you can create a job that performs the necessary operations. Here’s a step-by-step solution:

1. Create a Job: First, create a job using the Artisan command:

   php artisan make:job SyncEmployees
   

2. Implement the Job Logic: Open the generated job file (app/Jobs/SyncEmployees.php) and implement the logic to sync the data.

Here is an example implementation:

<?php

namespace App\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use App\Models\Employee;
use App\Models\ActiveEmployee;

class SyncEmployees implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        // Get all active employees
        $activeEmployees = ActiveEmployee::all()->keyBy('id');

        // Get all employees
        $employees = Employee::all()->keyBy('id');

        // Add or update employees
        foreach ($activeEmployees as $id => $activeEmployee) {
            if ($employees->has($id)) {
                // Update existing employee
                $employee = $employees->get($id);
                $employee->update($activeEmployee->toArray());
            } else {
                // Add new employee
                Employee::create($activeEmployee->toArray());
            }
        }

        // Delete employees not in active employees
        foreach ($employees as $id => $employee) {
            if (!$activeEmployees->has($id)) {
                $employee->delete();
            }
        }
    }
}

1. Dispatch the Job: You can dispatch this job from a command, a controller, or a scheduled task. For example, to run it daily, you can add it to the schedule method in app/Console/Kernel.php:

protected function schedule(Schedule $schedule)
{
    $schedule->job(new SyncEmployees)->daily();
}

1. Run the Scheduler: Ensure your scheduler is running. You can set up a cron job on your server to run the Laravel scheduler every minute:

* * * * * php /path-to-your-project/artisan schedule:run >> /dev/null 2>&1

This solution ensures that the employees table is kept in sync with the active_employees table by adding, updating, or deleting records as necessary.