One Hat Cyber Team

Your IP : 3.149.255.21

Server IP : 192.145.235.60

Server : Linux ngx365.inmotionhosting.com 5.14.0-427.33.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 30 09:45:56 EDT 2024 x86_64

Server Software : Apache

PHP Version : 8.2.27

Buat File | Buat Folder

Dir : ~/home/centos12/www/centosuit/app/Console/Commands/

View File Name : SendEventReminder.php

<?php

namespace App\Console\Commands;

use App\Events\EventReminderEvent;
use App\Models\Company;
use App\Models\Event;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Symfony\Component\Console\Output\ConsoleOutput;

class SendEventReminder extends Command
{

    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'send-event-reminder';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Send event reminder to the attendees before time specified in database';

    /**
     * Execute the console command.
     *
     * @return mixed
     */

    public function handle()
    {
        $output = new ConsoleOutput();

        // Retrieve all companies that have events with send_reminder set to 'yes'
        $companiesWithEvents = Company::whereHas('events', function ($query) {
            $query->where('send_reminder', 'yes');
        })->active()->get();

        if ($companiesWithEvents->isEmpty()) {
            $output->writeln('<info>No Company with event found</info>');

            return Command::SUCCESS;
        }

        // Now you have a collection of companies with associated events that have send_reminder set to 'yes'
        foreach ($companiesWithEvents as $company) {

            $events = Event::with('attendee')
                ->select('id', 'event_name', 'label_color', 'where', 'description', 'start_date_time', 'end_date_time', 'repeat', 'send_reminder', 'remind_time', 'remind_type', 'company_id')
                ->where('start_date_time', '>=', now($company->timezone))
                ->where('send_reminder', 'yes')
                ->where('company_id', $company->id)
                ->get();


            foreach ($events as $event) {
                $reminderDateTime = $this->calculateReminderDateTime($event, $company);

                if ($reminderDateTime->equalTo(now($company->timezone)->startOfMinute())) {
                    event(new EventReminderEvent($event));
                }
            }
        }

        return Command::SUCCESS;

    }

    public function calculateReminderDateTime(Event $event, $company)
    {
        $time = $event->remind_time;
        $type = $event->remind_type;

        $reminderDateTime = '';

        switch ($type) {
        case 'day':
            $reminderDateTime = Carbon::createFromFormat('Y-m-d H:i:s', $event->start_date_time, $company->timezone)->subDays($time);
            break;
        case 'hour':
            $reminderDateTime = Carbon::createFromFormat('Y-m-d H:i:s', $event->start_date_time, $company->timezone)->subHours($time);
            break;
        case 'minute':
            $reminderDateTime = Carbon::createFromFormat('Y-m-d H:i:s', $event->start_date_time, $company->timezone)->subMinutes($time);
            break;
        }

        return $reminderDateTime;
    }

}