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 copy.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">
    <thead>
    <tr>
        <th>#</th>
        <th>Project Name</th>
        <th>Employee Name</th>
        <th>Category</th>
       
        <th>Action</th>
    </tr>
</thead>
<tbody>
    <?php

// $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_id = c.id
// WHERE 1";

$query = "SELECT * FROM projects";
$query_run = mysqli_query($conn, $query);
// if (mysqli_num_rows($query_run) > 0) {
//     foreach ($query_run as $row) {


if (!empty($start_date) && !empty($end_date)) {
// Apply date range filter
$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) {
        foreach ($query_run as $row) { ?>
            <tr>
                <td><?php echo $row['id']; ?></td>
                <td><?php echo $row['project_name']; ?></td>
              
                <td><?php echo $row['category_ids'] ; ?></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='8' 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