<?php
include('config/db.php');
include('includes/header.php');

// Fetch all published jobs with company details
$query = "SELECT j.*, c.company_name, c.logo 
          FROM jobs j 
          JOIN companies c ON j.company_id = c.id 
          WHERE j.status = 'published' 
          ORDER BY j.created_at DESC";
$jobs = $pdo->query($query)->fetchAll();
?>

<section class="bg-light py-5 border-bottom">
    <div class="container text-center">
        <h2 class="fw-bold mb-3">Available Vacancies</h2>
        <p class="text-muted mb-4">Discover 100% verified jobs in Pune, Nashik, and across Maharashtra.</p>
        
        <div class="row justify-content-center">
            <div class="col-lg-8">
                <form action="" method="GET" class="row g-2">
                    <div class="col-md-8">
                        <input type="text" name="search" class="form-control form-control-lg border-primary rounded-pill px-4 shadow-sm" placeholder="Search by Job Title or Company...">
                    </div>
                    <div class="col-md-4">
                        <button type="submit" class="btn btn-primary btn-lg w-100 rounded-pill shadow">
                            <i class="bi bi-search me-2"></i>Find Jobs
                        </button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</section>

<div class="container py-5">
    <div class="row g-4">
        <?php if(count($jobs) > 0): ?>
            <?php foreach($jobs as $job): ?>
            <div class="col-12 col-md-6">
                <div class="card border-0 shadow-sm rounded-4 h-100 transition-hover">
                    <div class="card-body p-4">
                        <div class="d-flex justify-content-between align-items-start mb-3">
                            <div class="d-flex align-items-center">
                                <img src="assets/img/logos/<?php echo $job['logo']; ?>" 
                                     class="rounded border bg-white p-1 me-3 shadow-sm" 
                                     style="width: 55px; height: 55px; object-fit: contain;">
                                <div>
                                    <h5 class="fw-bold text-dark mb-0"><?php echo htmlspecialchars($job['job_title']); ?></h5>
                                    <span class="text-muted small"><?php echo htmlspecialchars($job['company_name']); ?></span>
                                </div>
                            </div>
                            <span class="badge bg-success-subtle text-success border border-success border-opacity-25 px-2 py-1 small">
                                Verified
                            </span>
                        </div>

                        <div class="row g-2 mb-4">
                            <div class="col-6 col-sm-auto">
                                <div class="bg-light rounded p-2 text-center border">
                                    <small class="text-muted d-block">Monthly Salary</small>
                                    <span class="fw-bold text-primary">₹<?php echo number_format($job['in_hand_salary']); ?></span>
                                </div>
                            </div>
                            <div class="col-6 col-sm-auto">
                                <div class="bg-light rounded p-2 text-center border">
                                    <small class="text-muted d-block">Location</small>
                                    <span class="fw-bold text-dark"><?php echo htmlspecialchars($job['location']); ?></span>
                                </div>
                            </div>
                            <div class="col-12 col-sm-auto flex-grow-1">
                                <div class="bg-light rounded p-2 text-center border">
                                    <small class="text-muted d-block">Qualification</small>
                                    <span class="fw-bold text-dark"><?php echo htmlspecialchars($job['qualification'] ?? 'Any'); ?></span>
                                </div>
                            </div>
                        </div>

                        <div class="d-flex justify-content-between align-items-center">
                            <small class="text-muted">
                                <i class="bi bi-clock me-1"></i> Posted <?php echo date('d M, Y', strtotime($job['created_at'])); ?>
                            </small>
                            <div class="d-flex gap-2">
                                <a href="job-details.php?id=<?php echo $job['id']; ?>" class="btn btn-primary rounded-pill px-4 shadow-sm">
                                    View Details
                                </a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <?php endforeach; ?>
        <?php else: ?>
            <div class="col-12 text-center py-5">
                <i class="bi bi-briefcase fs-1 text-muted opacity-25"></i>
                <h4 class="mt-3">No jobs found matching your criteria.</h4>
                <a href="jobs.php" class="btn btn-outline-primary mt-2">Clear Search</a>
            </div>
        <?php endif; ?>
    </div>
</div>

<style>
    .transition-hover { transition: transform 0.3s ease, box-shadow 0.3s ease; }
    .transition-hover:hover { 
        transform: translateY(-5px); 
        box-shadow: 0 1rem 3rem rgba(0,0,0,0.125) !important; 
    }
</style>

<?php include('includes/footer.php'); ?>