50 lines
2.4 KiB
PHP
50 lines
2.4 KiB
PHP
<?php
|
|
|
|
require __DIR__.'/../vendor/autoload.php';
|
|
$app = require_once __DIR__.'/../bootstrap/app.php';
|
|
$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);
|
|
$kernel->bootstrap();
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
echo "=== APP TIMEZONE IN CONFIG ===\n";
|
|
echo "config('app.timezone'): " . config('app.timezone') . "\n";
|
|
echo "date_default_timezone_get(): " . date_default_timezone_get() . "\n";
|
|
echo "Now (UTC): " . now()->toDateTimeString() . "\n";
|
|
echo "Now (local PHP time): " . date('Y-m-d H:i:s') . "\n";
|
|
|
|
$dbTime = DB::select("SELECT NOW() as db_now, @@global.time_zone as global_tz, @@session.time_zone as session_tz");
|
|
echo "DB NOW: " . $dbTime[0]->db_now . " | Global TZ: " . $dbTime[0]->global_tz . " | Session TZ: " . $dbTime[0]->session_tz . "\n\n";
|
|
|
|
echo "=== EMPLOYEES BASIC LIST ===\n";
|
|
$users = DB::table('users')->get()->keyBy('id');
|
|
$employees = DB::table('employees')->get();
|
|
foreach ($employees as $emp) {
|
|
$user = $users->get($emp->user_id);
|
|
$fullName = $user ? ($user->name ?? ($user->first_name . ' ' . $user->last_name)) : 'Unknown';
|
|
echo "EmpID: {$emp->id} | UserID: {$emp->user_id} | Name: {$fullName} | BioID: {$emp->biometric_emp_id} | ShiftID: {$emp->shift_id}\n";
|
|
}
|
|
|
|
echo "\n=== SEARCH FOR SANCHEZ ===\n";
|
|
foreach ($employees as $emp) {
|
|
$user = $users->get($emp->user_id);
|
|
$fullName = $user ? ($user->name ?? '') : '';
|
|
if (stripos($fullName, 'Sanchez') !== false || stripos($fullName, 'Andrhea') !== false || stripos($fullName, 'Ana') !== false) {
|
|
echo "MATCH: EmpID: {$emp->id} | Name: {$fullName} | BioID: {$emp->biometric_emp_id} | ShiftID: {$emp->shift_id}\n";
|
|
|
|
// Find attendance records
|
|
$records = DB::table('attendance_records')->where('employee_id', $emp->id)->get();
|
|
echo " --> Attendance Records count: " . count($records) . "\n";
|
|
foreach ($records as $r) {
|
|
echo " Date: {$r->date} | In: {$r->clock_in} | Out: {$r->clock_out} | Shift: {$r->shift_id} | Status: {$r->status}\n";
|
|
}
|
|
|
|
// Find raw biometric attendances
|
|
$punches = DB::table('biometric_attendances')->where('biometric_emp_id', $emp->biometric_emp_id)->get();
|
|
echo " --> Raw Biometric Punches count: " . count($punches) . "\n";
|
|
foreach ($punches as $p) {
|
|
echo " Punch Time: {$p->punch_time} | Type: {$p->punch_type} | Terminal: {$p->terminal_alias}\n";
|
|
}
|
|
}
|
|
}
|