Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2025-11-15 16:11
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
cgi-bin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
qr_codes	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
samecar	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
uploads	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
2V3RLatL.php	445 B	-rw-r--r--	2026-02-23 13:08
INSTALLATION.txt	1.59 KB	-rw-r--r--	2025-11-15 19:41
README.md	4.67 KB	-rw-r--r--	2025-11-15 19:41
change_language.php	413 B	-rw-r--r--	2025-11-15 19:33
check_gd.php	1.71 KB	-rw-r--r--	2025-11-15 20:15
check_user.php	1.17 KB	-rw-r--r--	2025-11-15 20:04
completed_applications.php	5.79 KB	-rw-r--r--	2025-11-15 20:31
config.php	10.52 KB	-rw-r--r--	2025-11-15 15:47
dashboard.php	4.61 KB	-rw-r--r--	2025-11-15 20:31
database.sql	4.76 KB	-rw-r--r--	2025-11-15 15:46
error_log	2.12 KB	-rw-r--r--	2025-12-06 06:58
fix_qr_codes.php	2.21 KB	-rw-r--r--	2025-11-15 19:55
footer.php	2.68 KB	-rw-r--r--	2025-11-15 20:31
generate_qr.php	1.2 KB	-rw-r--r--	2025-11-15 19:37
header.php	16.38 KB	-rw-r--r--	2025-11-15 20:31
index.php	3.01 KB	-rw-r--r--	2025-11-15 20:31
login.php	4.61 KB	-rw-r--r--	2025-11-15 20:31
logout.php	85 B	-rw-r--r--	2025-11-15 19:33
new_application.php	26.13 KB	-rw-r--r--	2025-11-15 20:31
payment.php	6.09 KB	-rw-r--r--	2025-11-15 20:31
payment_history.php	4.1 KB	-rw-r--r--	2025-11-15 20:31
pending_applications.php	5.21 KB	-rw-r--r--	2025-11-15 20:31
profile.php	17.09 KB	-rw-r--r--	2025-11-15 20:31
register.php	5.87 KB	-rw-r--r--	2025-11-15 20:31
samecar.zip	71.94 MB	-rw-r--r--	2025-11-15 15:45
setup_admin.php	5.25 KB	-rw-r--r--	2025-11-15 19:48
submit_payment.php	2.36 KB	-rw-r--r--	2025-11-15 19:36
test_admin.php	1.99 KB	-rw-r--r--	2025-11-15 19:48
txets.php	4.37 KB	-rw-r--r--	2026-02-24 02:50
update_existing_applications.php	1.89 KB	-rw-r--r--	2025-11-15 20:01
view_qr.php	7.8 KB	-rw-r--r--	2025-11-15 20:31
wp-blog-header.php	2.74 KB	-rw-r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43
yKytReRg.php	445 B	-rw-r--r--	2026-02-22 23:14

Rename

<?php
require_once 'config.php';

if (!isUserLoggedIn()) {
    redirect('login.php');
}

$conn = getDBConnection();
$user_id = $_SESSION['user_id'];

$applications_result = $conn->query("SELECT a.*, p.amount, p.status as payment_status, qr.qr_code_path, qr.is_active as qr_active
                              FROM applications a 
                              LEFT JOIN payments p ON a.id = p.application_id 
                              LEFT JOIN qr_codes qr ON a.id = qr.application_id
                              WHERE a.user_id = $user_id AND a.status = 'approved' 
                              ORDER BY a.created_at DESC");

// Store applications in array and ensure application_code exists
$applications = [];
while ($app = $applications_result->fetch_assoc()) {
    if (empty($app['application_code'])) {
        $new_code = generateApplicationCode($conn);
        $new_code_safe = sanitizeSQL($conn, $new_code);
        $conn->query("UPDATE applications SET application_code = '$new_code_safe' WHERE id = {$app['id']}");
        $app['application_code'] = $new_code;
    }
    $applications[] = $app;
}

include 'header.php';
?>
<div class="main-content">
<div class="container my-5">
    <div class="row mb-4">
        <div class="col-12">
            <h2 class="mb-0 fw-bold text-gov-green">
                <i class="bi bi-check-circle-fill"></i> Completed Applications
            </h2>
            <p class="text-muted mt-2">Approved applications with active QR codes</p>
        </div>
    </div>
    
    <?php if (count($applications) > 0): ?>
        <div class="row g-4">
            <?php foreach ($applications as $app): ?>
                <div class="col-md-6 col-lg-4">
                    <div class="gov-card h-100">
                        <div class="gov-card-header">
                            <i class="bi bi-check-circle-fill"></i>
                            <span>Application #<?php echo $app['application_code'] ?? $app['id']; ?></span>
                        </div>
                        <div class="gov-card-body">
                            <div class="alert alert-gov-success mb-3">
                                <div class="d-flex align-items-center justify-content-between">
                                    <div>
                                        <strong>Application ID:</strong><br>
                                        <span class="badge badge-gov badge-gov-info fs-6 mt-1">#<?php echo $app['application_code'] ?? $app['id']; ?></span>
                                    </div>
                                    <i class="bi bi-shield-check-fill fs-3"></i>
                                </div>
                                <small class="d-block mt-2">Share this 7-digit ID to verify your vehicle</small>
                            </div>
                            <table class="table table-borderless mb-3">
                                <tr>
                                    <td class="text-muted fw-bold" style="width: 40%;">Name:</td>
                                    <td><strong><?php echo htmlspecialchars($app['step1_full_name']); ?></strong></td>
                                </tr>
                                <tr>
                                    <td class="text-muted fw-bold">Vehicle Type:</td>
                                    <td><?php echo htmlspecialchars($app['step2_vehicle_type']); ?></td>
                                </tr>
                                <tr>
                                    <td class="text-muted fw-bold">Vehicle Number:</td>
                                    <td><strong><?php echo htmlspecialchars($app['step2_vehicle_number']); ?></strong></td>
                                </tr>
                                <tr>
                                    <td class="text-muted fw-bold">QR Status:</td>
                                    <td>
                                        <?php if ($app['qr_active']): ?>
                                            <span class="badge badge-gov badge-gov-success">
                                                <i class="bi bi-check-circle"></i> Active
                                            </span>
                                        <?php else: ?>
                                            <span class="badge badge-gov badge-gov-warning">Inactive</span>
                                        <?php endif; ?>
                                    </td>
                                </tr>
                                <tr>
                                    <td class="text-muted fw-bold">Approved:</td>
                                    <td><?php echo date('d M Y, h:i A', strtotime($app['updated_at'])); ?></td>
                                </tr>
                            </table>
                            <a href="profile.php?app_id=<?php echo $app['id']; ?>" class="btn btn-gov-primary w-100">
                                <i class="bi bi-qr-code"></i> View Profile & QR Code
                            </a>
                        </div>
                    </div>
                </div>
            <?php endforeach; ?>
        </div>
    <?php else: ?>
        <div class="gov-card">
            <div class="gov-card-body text-center p-5">
                <i class="bi bi-inbox" style="font-size: 64px; color: var(--gov-text-light);"></i>
                <h4 class="mt-3 text-muted">No Completed Applications</h4>
                <p class="text-muted">Your approved applications will appear here.</p>
                <a href="new_application.php" class="btn btn-gov-primary mt-3">
                    <i class="bi bi-plus-circle"></i> Create New Application
                </a>
            </div>
        </div>
    <?php endif; ?>
</div>
</div>
<?php include 'footer.php'; ?>