<?php
session_start();

if (!isset($_SESSION['clinic_logged_in']) || $_SESSION['clinic_logged_in'] !== true) {
    header('Location: index.php');
    exit;
}

// Optional: access admin ID like this
$admin_id = $_SESSION['clinic_id'];
include 'dbconn.php';

// Fetch records from basic_information table
$sql = "SELECT * FROM recruitment_data where clinic_id='$admin_id'";
$result = $mysqli->query($sql);
?>
                   
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>CRA - Clinical Research Analysis
    </title>

    <link rel="preconnect" href="https://fonts.gstatic.com">
    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@300;400;600;700;800&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="assets/css/bootstrap.css">

    <link rel="stylesheet" href="assets/vendors/iconly/bold.css">

    <link rel="stylesheet" href="assets/vendors/perfect-scrollbar/perfect-scrollbar.css">
    <link rel="stylesheet" href="assets/vendors/bootstrap-icons/bootstrap-icons.css">
    <link rel="stylesheet" href="assets/css/app.css">
    <link rel="shortcut icon" href="assets/images/favicon.svg" type="image/x-icon">
</head>

<body>
    <div id="app">
        <div id="sidebar" class="active">
            <div class="sidebar-wrapper active">
                <div class="sidebar-header">
                    <div class="d-flex justify-content-between">
                        <div class="logo">
                              <a href="dashboard.php"><img src="img/logo.png" alt="Logo" style="width: 150px; height:50px" srcset=""></a>
                        </div>
                        <div class="toggler">
                            <a href="#" class="sidebar-hide d-xl-none d-block"><i class="bi bi-x bi-middle"></i></a>
                        </div>
                    </div>
                </div>
                  <div class="sidebar-menu">
                    <ul class="menu">
                      
                        <li class="sidebar-item ">
                            <a href="dashboard.php" class='sidebar-link'>
                                <i class="bi bi-grid-fill"></i>
                                <span>Dashboard</span>
                            </a>
                        </li>

                        <li class="sidebar-item  ">
                            <a href="basic_information.php" class='sidebar-link'>
                                <i class="bi bi-collection-fill"></i>
                                <span>Basic Information</span>
                            </a>
                           
                        </li>

                        <li class="sidebar-item ">
                            <a href="principal_investigators.php" class='sidebar-link'>
                                <i class="bi bi-grid-1x2-fill"></i>
                                <span>Principal Investigator</span>
                            </a>
                        </li>
                        <li class="sidebar-item  ">
                            <a href="study_design.php" class='sidebar-link'>
                                <i class="bi bi-hexagon-fill"></i>
                                <span>Study Design</span>
                            </a>
                        </li>

                        <li class="sidebar-item  ">
                            <a href="site_facility.php" class='sidebar-link'>
                                <i class="bi bi-file-earmark-medical-fill"></i>
                                <span>Site & Facility</span>
                            </a>
                        </li>

                        <li class="sidebar-item  ">
                            <a href="investigational_products.php" class='sidebar-link'>
                                <i class="bi bi-pen-fill"></i>
                                <span>Investigational Product</span>
                            </a>
                        </li>

                        <li class="sidebar-item active ">
                            <a href="requirement_datacollection.php" class='sidebar-link'>
                                <i class="bi bi-grid-1x2-fill"></i>
                                <span>Recruitment & Data<br> Collection</span>
                            </a>
                        </li>
                        
                        <li class="sidebar-item  ">
                            <a href="logout.php" class='sidebar-link'>
                                <i class="bi bi-x-octagon-fill"></i>
                                <span>Log Out</span>
                            </a>
                           
                        </li>

                        

                    </ul>
                </div>
                <button class="sidebar-toggler btn x"><i data-feather="x"></i></button>
            </div>
        </div>
        <div id="main">
            <header class="mb-3">
                <a href="#" class="burger-btn d-block d-xl-none">
                    <i class="bi bi-justify fs-3"></i>
                </a>
            </header>

            <div class="page-heading">
                <h3>Clinics Admin</h3>
            </div>
            <div class="page-content">
                  <section class="section">
                    <div class="row" id="table-striped">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header d-flex justify-content-between align-items-center">
                                    <h4 class="card-title mb-0">Requirement & DataCollection</h4>
                                    <a href="add_requirement_datacollection.php" class="btn btn-success">
                                        <i class="bi bi-plus-lg"></i> Add Requirement & DataCollection
                                    </a>
                                </div>
                                <div class="card-content">
                                    
                                    <!-- table striped -->
                                    <div class="table-responsive">
                                        <table class="table table-striped mb-0">
                                            <thead>
                                                <tr>
                                                    <th>ENROLLMENT PLAN</th>
                                                    <th>ANTICIPATED RECRUITMENT START DATE</th>
                                                    <th>ANTICIPATED RECRUITMENT END DATE</th>
                                                    <th>STATUS</th>
                                                    <th></th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                 <?php if ($result->num_rows > 0): ?>
                                                <?php while($row = $result->fetch_assoc()): ?>
                                                        <?php
                                                            $rowClass = '';
                                                            if ($row['status'] === 'Disapproved') {
                                                                $rowClass = 'text-danger';
                                                            } elseif ($row['status'] === 'Approved') {
                                                                $rowClass = 'text-success';
                                                            }
                                                        ?>
                                                        <tr class="<?php echo $rowClass; ?>">
                                                    <td><b>
                                                        <a href="requirement_datacollection_details.php?id=<?php echo $row['id']; ?>">
                                                            <?php echo htmlspecialchars($row['enrollment_plan']); ?>
                                                        </a></b>
                                                    </td>
                                                    <td><?php echo htmlspecialchars($row['start_date']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['end_date']); ?></td>
                                                    <td colspan="3">
                                                        <?php
                                                            $status = $row['status'] ?? 'Pending';
                                                            $updatedAt = !empty($row['status_updated_at']) 
                                                                ? ' (' . date('Y-m-d H:i:s', strtotime($row['status_updated_at'])) . ')'
                                                                : '';

                                                            // Apply color based on status
                                                            $color = match ($status) {
                                                                'Approved' => 'green',
                                                                'Disapproved' => 'red',
                                                                default => 'gray'
                                                            };

                                                            echo "<span style='color: $color; font-weight: bold;'>"
                                                                . htmlspecialchars($status) . "</span>" . htmlspecialchars($updatedAt);
                                                        ?>
                                                    </td>
                                                    <td>
                                                        <a href="edit_requirement_datacollection.php?id=<?php echo $row['id']; ?>" class="text-primary me-2" title="Edit">
                                                            <i class="bi bi-pencil-square fs-4"></i>
                                                        </a>
                                                        <a href="delete_requirement_datacollection.php?id=<?php echo $row['id']; ?>" class="text-danger" title="Delete" onclick="return confirm('Are you sure?')">
                                                            <i class="bi bi-trash fs-4"></i>
                                                        </a>
                                                    </td>
                                                </tr>
                                                <?php endwhile; ?>
                                                <?php else: ?>
                                                        <tr>
                                                            <td colspan="5" class="text-center text-dark">No data found.</td>
                                                        </tr>
                                                    <?php endif; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </section>
            </div>

            <footer>
                <div class="footer clearfix mb-0 text-muted">
                    <div class="float-start">
                        <p>2025 &copy; Phaseon Clinical Research</p>
                    </div>
                    <div class="float-end">
                        <p>Design by PoojaInfotech</p>
                    </div>
                </div>
            </footer>
        </div>
    </div>
    <script src="assets/vendors/perfect-scrollbar/perfect-scrollbar.min.js"></script>
    <script src="assets/js/bootstrap.bundle.min.js"></script>

    <script src="assets/vendors/apexcharts/apexcharts.js"></script>
    <script src="assets/js/pages/dashboard.js"></script>

    <script src="assets/js/main.js"></script>
</body>

</html>