Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.16.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u226437350

Directory:

/home/u226437350/domains/extrapower.in/public_html/admin3/user

Free Space:

8.54 TB

🔧 Quick Actions

✏️ Editing: drequest.php

<?php include_once('header2.php'); ?>

<?php
include_once('config.php');

$showTotalFormsReceived = false; // Initialize variable

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $year = mysqli_real_escape_string($conn, $_POST['year']);
    $month = mysqli_real_escape_string($conn, $_POST['month']);

$sql = "SELECT * FROM form WHERE 
            YEAR(created_at) = $year 
            AND MONTH(created_at) = $month 
            ORDER BY created_at DESC";

$result = $conn->query($sql);

if (!$result) {
        die("Error in query: " . mysqli_error($conn));
    }

$totalFormsReceived = $result->num_rows;
    $showTotalFormsReceived = true;
} else {
    $ninetyDaysAgo = date('Y-m-d', strtotime('-365 days'));
    $sql = "SELECT * FROM form WHERE created_at >= '$ninetyDaysAgo' ORDER BY created_at DESC";
    $result = $conn->query($sql);

if (!$result) {
        die("Error in query: " . mysqli_error($conn));
    }
}
?>
<div class="content-body">
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-body">
                <?php
// Count the number of type 4 users
$countQuery = "SELECT COUNT(*) as total FROM form  ";
$countResult = mysqli_query($conn, $countQuery);
$countData = mysqli_fetch_assoc($countResult);
$totalType4Users = $countData['total'];
?>
                <label style="font-size:20px;color:#004AAD;font-weight:700" for="myInput" >Total Form Received:<?= $totalType4Users ?></label>
                <form method="POST" action="" class="row align-items-end">
    <div class="col-md-4">
        <div class="form-group">
            <label for="year">Year:</label>
            <select style="border-radius: 30px;border-color:#004AAD" class="form-control" id="year" name="year" onchange="filterTable()">
                <?php
                $currentYear = date('Y');
                for ($i = $currentYear; $i >= 2020; $i--) {
                    $selected = ($year == $i) ? "selected" : "";
                    echo "<option value='$i' $selected>$i</option>";
                }
                ?>
            </select>
        </div>
    </div>
    <div class="col-md-4">
        <div class="form-group">
            <label for="month">Month:</label>
            <select style="border-radius: 30px;border-color:#004AAD" class="form-control" id="month" name="month" onchange="filterTable()">
                <?php
                $months = [
                    1 => 'January', 2 => 'February', 3 => 'March', 4 => 'April',
                    5 => 'May', 6 => 'June', 7 => 'July', 8 => 'August',
                    9 => 'September', 10 => 'October', 11 => 'November', 12 => 'December'
                ];
                foreach ($months as $key => $value) {
                    $selected = ($month == $key) ? "selected" : "";
                    echo "<option value='$key' $selected>$value</option>";
                }
                ?>
            </select>
            
<input type="hidden" id="selectedYear" name="selectedYear" value="<?php echo $year; ?>">
<input type="hidden" id="selectedMonth" name="selectedMonth" value="<?php echo $month; ?>">
            
        </div>
    </div>
    <div class="col-md-4" style="margin-bottom:24px">
        <button type="submit" class="btn btn-primary mt-2">Filter</button>
        </div>
</form>
<?php if($showTotalFormsReceived): ?>
    <label style="font-size:20px;color:#004AAD;font-weight:700" for="myInput">
        Total form received (<?php echo $months[$month] . ' ' . $year; ?>): <?php echo $totalFormsReceived; ?>
    </label>
    <?php endif; ?>
 <input style="border-radius: 30px;border-color:#004AAD" type="text" id="myInput" onkeyup="myFunction()" class="form-control" placeholder=" Search Beneficiary" aria-label="Search Dashboard" title="Type your name or phone">
                    <div class="table-responsive">
                        <div class="active-member">
                            <div class="table-responsive">
                                <table class="table table-xs mb-0" id="myTable">
    <thead style="font-size:18px;color:#004AAD;font-weight:700">
    <tr>
    <th>S.No.</th>
              <th>Dealer Name</th>
            <th>Damage Serial No</th>
            <th>Replaced Serial No</th> 
            <th>Status</th> 
            <th>Details</th> 
            <th>Approve</th> 
             </tr>
    </thead>
    <tbody style="font-weight:500">
    <?php
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                ?>
               <tr>
               <td><?php echo $row['id']; ?></td>
                    <td><?php echo $row['name']; ?></td>
                    <td><?php echo $row['damageserialno']; ?></td>
                    <td><?php echo $row['replacedserialno']; ?></td>
                    <td><?php echo $row['status']; ?></td>
                    
                    
                    
                    <td>
    <a href="view.php?id=<?php echo $row['id']; ?>">
    <span class="label gradient-2 rounded">View</span>
    </a>
</td>
<td>
    <a href="update.php?id=<?php echo $row['id']; ?>" onclick="return confirm('Are you sure you want to Approve this Dealer?');">
    <span class="label gradient-4 rounded">Approve</span>
    </a>
</td>
                </tr>
            <?php }
        } ?>
     
    </tbody>
</table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
   function myFunction() {
    var input, filter, table, tr, td, i, j, txtValue;
    input = document.getElementById("myInput");
    filter = input.value.toUpperCase();
    table = document.getElementById("myTable");
    tr = table.getElementsByTagName("tr");

for (i = 1; i < tr.length; i++) { // Start from index 1 to exclude the header row
        var found = false;
        td = tr[i].getElementsByTagName("td");
        for (j = 0; j < td.length; j++) {
            txtValue = td[j].textContent || td[j].innerText;
            if (txtValue.toUpperCase().indexOf(filter) > -1) {
                found = true;
                break;
            }
        }
        if (found) {
            tr[i].style.display = "";
        } else {
            tr[i].style.display = "none";
        }
    }
}
function filterTable() {
        var inputYear = document.getElementById("year");
        var inputMonth = document.getElementById("month");
        var filterYear = inputYear.value;
        var filterMonth = inputMonth.value;
        var table = document.getElementById("myTable");
        var tr = table.getElementsByTagName("tr");

for (var i = 1; i < tr.length; i++) {
            var tdYear = tr[i].getElementsByTagName("td")[5]; 
            var tdMonth = tr[i].getElementsByTagName("td")[6];

if (tdYear && tdMonth) {
                var yearValue = tdYear.textContent || tdYear.innerText;
                var monthValue = tdMonth.textContent || tdMonth.innerText;

if (yearValue == filterYear && monthValue == filterMonth) {
                    tr[i].style.display = "";
                } else {
                    tr[i].style.display = "none";
                }
            }
        }
    }
    
</script>
<?php include_once('footer2.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: drequest.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation