MMCT TEAM

Server IP : 162.214.80.37 / Your IP : 216.73.216.83
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/public_html/destinytrafficsolutions/vendor/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : /home2/imyrqtmy/public_html/destinytrafficsolutions/vendor/view-project.php
<?php

error_reporting(E_ALL);
ini_set('display_errors', 1);
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">
    <div class="col-12 col-sm-12">
    <div class="row mb-4">
    <div class="col-12 col-md-12">
    <div class="card redial-border-light redial-shadow mb-4">
        <div class="card-body">
            <h6 class="header-title pl-3 redial-relative">Data Table</h6>

            <form method="GET" action="">
        <div class="row mb-3">
            <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>

            <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>

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

    <!-- Project Table -->
    <table class="table table-bordered">
    <thead>
        <tr>
            <th>#</th>
            <th>Project Name</th>
            <th>Employee Name</th>
            <th>Categories</th>
            <th>Project Start</th>
            <th>Action</th>
        </tr>
    </thead>
    <tbody>
        <?php
        if (!isset($_SESSION['id'])) {
            die("Unauthorized access.");
        }

        $se = $_SESSION['id']; 

        $query = "SELECT p.*, e.emp_name 
                  FROM projects p
                  LEFT JOIN employees e ON p.emp_id = e.id
                  WHERE p.emp_id = '$se'";

        if (!empty($start_date) && !empty($end_date)) {
            $query .= " AND p.project_start >= '$start_date' AND p.project_end <= '$end_date'";
        }

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

        if (mysqli_num_rows($query_run) > 0) {
            while ($row = mysqli_fetch_assoc($query_run)) {
                $category_ids = json_decode($row['category_ids'], true); // Decode JSON
                
                if (is_array($category_ids) && count($category_ids) > 0) {
                    $category_ids_str = implode(',', array_map('intval', $category_ids)); // Convert to comma-separated
                    $catQuery = "SELECT v_name FROM categories WHERE id IN ($category_ids_str)";
                    $catResult = mysqli_query($conn, $catQuery);

                    $categories = [];
                    while ($catRow = mysqli_fetch_assoc($catResult)) {
                        $categories[] = htmlspecialchars($catRow['v_name']);
                    }
                    $category_names = implode(', ', $categories); // Display as comma-separated
                } else {
                    $category_names = 'Not Categorized';
                }
                ?>
                <tr>
                    <td><?php echo $row['id']; ?></td>
                    <td><?php echo htmlspecialchars($row['project_name']); ?></td>
                    <td><?php echo $row['emp_name'] ? htmlspecialchars($row['emp_name']) : 'Not Assigned'; ?></td>
                    <td><?php echo $category_names; ?></td>
                    <td><?php echo $row['project_start']; ?></td>
                    <td>
                        <div class='btn-group mb-2'>
                            <a href="count-project.php?id=<?php echo $row['id']; ?>" class="btn btn-success" data-toggle="tooltip" title="Edit Project">
                                <i class='fa fa-pencil'></i>
                            </a>
                        </div>
                    </td>
                </tr>
                <?php 
            }
        } else {
            echo "<tr><td colspan='6' 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-->

     
        
        <!-- jQuery -->
        <script src="dist/js/plugins.min.js"></script>        
        <script src="dist/js/common.js"></script>
    </body>

</html>
MMCT - 2023