35 lines
1006 B
PHP
35 lines
1006 B
PHP
|
<?php
|
||
|
|
require __DIR__ . '/../vendor/autoload.php';
|
||
|
|
|
||
|
|
use App\Config\AppConfig;
|
||
|
|
use App\Support\Database;
|
||
|
|
|
||
|
|
AppConfig::loadEnv(__DIR__ . '/..');
|
||
|
|
|
||
|
|
$db = Database::getConnection(
|
||
|
|
AppConfig::get('DB_HOST'),
|
||
|
|
AppConfig::get('DB_NAME'),
|
||
|
|
AppConfig::get('DB_USER'),
|
||
|
|
AppConfig::get('DB_PASS')
|
||
|
|
);
|
||
|
|
|
||
|
|
echo "=== Gates in database ===\n\n";
|
||
|
|
|
||
|
|
$stmt = $db->query('SELECT location_code, gate_code, name, direction, camera, is_active FROM gates ORDER BY location_code, gate_code');
|
||
|
|
$gates = $stmt->fetchAll();
|
||
|
|
|
||
|
|
if (empty($gates)) {
|
||
|
|
echo "No gates found in database!\n";
|
||
|
|
} else {
|
||
|
|
echo "Total gates: " . count($gates) . "\n\n";
|
||
|
|
foreach ($gates as $gate) {
|
||
|
|
echo "Location: {$gate['location_code']}\n";
|
||
|
|
echo " Gate Code: {$gate['gate_code']}\n";
|
||
|
|
echo " Name: {$gate['name']}\n";
|
||
|
|
echo " Direction: {$gate['direction']}\n";
|
||
|
|
echo " Camera: " . ($gate['camera'] ?: 'NULL') . "\n";
|
||
|
|
echo " Active: " . ($gate['is_active'] ? 'Yes' : 'No') . "\n\n";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|