One Hat Cyber Team

Your IP : 3.145.167.178

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/

Edit File: AutoStopTimer.php

<?php

namespace App\Console\Commands;

use App\Events\TimelogEvent;
use App\Models\AttendanceSetting;
use App\Models\Company;
use App\Models\EmployeeShiftSchedule;
use App\Models\ProjectTimeLog;
use App\Models\User;
use Carbon\Carbon;
use Illuminate\Console\Command;

class AutoStopTimer extends Command
{

/**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'auto-stop-timer';

/**
     * The console command description.p
     *
     * @var string
     */
    protected $description = 'Stop all employees timer after office time.';

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

public function handle()
    {

Company::active()->select(['companies.id as id', 'timezone'])
            ->join('log_time_for', 'log_time_for.company_id', '=', 'companies.id')
            ->where('auto_timer_stop', 'yes')->chunk(50, function ($companies) {
                foreach ($companies as $company) {

$admin = User::allAdmins($company->id)->first();

$defaultShift = AttendanceSetting::where('company_id', $company->id)->first()->shift;

$activeTimers = ProjectTimeLog::with('user', 'activeBreak')
                        ->where('project_time_logs.company_id', $company->id)
                        ->whereNull('project_time_logs.end_time')
                        ->join('users', 'users.id', '=', 'project_time_logs.user_id')
                        ->select('project_time_logs.*', 'users.name')
                        ->get();

foreach ($activeTimers as $activeTimer) {
                        $attendanceShift = EmployeeShiftSchedule::with('shift')->where('user_id', $activeTimer->user_id)->where('date', $activeTimer->start_time->format('Y-m-d'))->first()?->shift;

if (!$attendanceShift) {
                            $attendanceShift = $defaultShift;
                        }

$startTime = $activeTimer->start_time->tz($company->timezone);
                        $endDateTime = Carbon::createFromFormat('Y-m-d H:i:s', $activeTimer->start_time->format('Y-m-d') . ' ' . $attendanceShift->office_end_time, $company->timezone);

if ($startTime->gt($endDateTime)) {
                            $endDateTime = $endDateTime->addDay();
                        }

if ($endDateTime->isPast()) {

$activeTimer->end_time = $endDateTime->tz(config('app.timezone'));
                            $activeTimer->edited_by_user = $admin->id;
                            $activeTimer->save();

$activeTimer->total_hours = ((int)$activeTimer->end_time->diff($activeTimer->start_time)->format('%d') * 24) + ((int)$activeTimer->end_time->diff($activeTimer->start_time)->format('%H'));

if ($activeTimer->total_hours == 0) {
                                $activeTimer->total_hours = (int)$activeTimer->end_time->diff($activeTimer->start_time)->format('%d') * 24 + (int)$activeTimer->end_time->diff($activeTimer->start_time)->format('%H');
                            }

$activeTimer->total_minutes = ((int)$activeTimer->total_hours * 60) + (int)($activeTimer->end_time->diff($activeTimer->start_time)->format('%i'));

$activeTimer->saveQuietly();

event(new TimelogEvent($activeTimer));

// Stop breaktime if active
                            /** @phpstan-ignore-next-line */
                            if (!is_null($activeTimer->activeBreak)) {
                                /** @phpstan-ignore-next-line */
                                $activeBreak = $activeTimer->activeBreak;
                                $activeBreak->end_time = $activeTimer->end_time;
                                $activeBreak->save();
                            }

}
                    }
                }
            });

return Command::SUCCESS;

}