29 lines
901 B
PHP
29 lines
901 B
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 App\Models\BiometricAttendance;
|
|
|
|
$empCodes = ['2023', '2013', '2008'];
|
|
|
|
echo "=== DB BIOMETRIC LOGS FOR CODES 2023, 2013, 2008 ===\n";
|
|
foreach ($empCodes as $code) {
|
|
echo "\nEmployee Code: $code\n";
|
|
$punches = BiometricAttendance::where('biometric_emp_id', $code)
|
|
->whereBetween('punch_time', ['2026-05-25 00:00:00', '2026-05-31 23:59:59'])
|
|
->orderBy('punch_time')
|
|
->get();
|
|
|
|
if ($punches->isEmpty()) {
|
|
echo "No logs found in DB.\n";
|
|
continue;
|
|
}
|
|
|
|
foreach ($punches as $p) {
|
|
echo "Date: " . $p->punch_time->format('Y-m-d') . " | Time: " . $p->punch_time->format('H:i:s') . " | Punch Type: {$p->punch_type} | ID: {$p->id}\n";
|
|
}
|
|
}
|