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: crequest.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>

<label for="searchName">Search by Name:</label>
    <input type="text" id="searchName" name="searchName" placeholder="Enter name">

<label for="searchMonth">Search by Month:</label>
    <input type="month" id="searchMonth" name="searchMonth">

<button type="submit">Search</button>
</form>

</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......      Number of Approved  <span id="approvedCount">0</span></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);
        }

// Fetch data from the database
        $sql = "SELECT * FROM damaged_goods";
        $result = $conn->query($sql);

// Display data in a table
        if ($result->num_rows > 0) {
            echo "<table class='table' >";
            echo "<tr>
            <th>Dealer Name</th>
            <th>Purchase Date</th>
            <th>Damage Serial No</th>
            <th>New Serial No</th>
            <th>Owner Serial No</th>
            <th>Customer Name</th>
            <th>Customer Purchase Date</th>
            <th>Replace Time </th>
            <th>Warranty Expiry</th>
            <th>Image</th> 
            <th>Action</th>
            <th>Approve</th> 
            <th>status</th> 
        </tr>";

while ($row = $result->fetch_assoc()) {
            echo "<tr data-id='" . $row["id"] . "'>";
            echo "<td contenteditable='true'class='text-center'>" . $row["form_name"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["purchase_date"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["damage_serial"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["dr_serial"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["owr_serial"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["customer_name"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["customer_purchase_date"] . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . getWarrantyText($row["customer_warranty"]) . "</td>";
            echo "<td contenteditable='true'class='text-center'>" . $row["another_column"] . "</td>"; 
            echo "<td class='text-center'><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 data found";
}

// Close the database connection
        $conn->close();

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

var approvedCount = 0;

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 searchRecords() {
    var searchName = document.getElementById('searchName').value.trim();
    var searchMonth = document.getElementById('searchMonth').value;

fetch('filtter.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);
    });
}

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

function openModal(recordId) {
            fetch('ck.php?id=' + id)
        .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>
                `;

// Show the modal
                document.getElementById('myModal').style.display = 'block';

// Add event listener to the download button
                document.getElementById('downloadPdfBtn').addEventListener('click', () => {
                    downloadAsPdf(data);
                });
            } else {
                console.error('Error fetching details:', data.message);
            }
        })
        .catch(error => {
            console.error('Error:', error);
        });
}
        
    </script>

function openModal(id) {
    // Fetch data for the selected row using AJAX or your preferred method
    // For simplicity, let's assume you have a PHP script (getDetails.php) to fetch details

fetch('ck.php?id=' + id)
        .then(response => response.json())
        .then(data => {
            if (data.status === 'success') {
                const modalContent = document.getElementById('modalContent');
                modalContent.innerHTML = `
                <img src="assets/images/logo100.png" class="center" style="height: 50px;width: 100;margin-left:35%"  alt="logo">
                <br>
                <br>
                <br>
                    
                    <p>Dear ${data.form_name},</p>
                    <br>

I hereby approve the exchange of the damaged battery with Serial No. ${data.damage_serial}, purchased on ${data.purchase_date}, for a new battery bearing Serial No. ${data.dr_serial}. You have the authorization to proceed with providing the customer with the new battery as specified, in exchange for the damaged one.</p>
<br>
<br>
<br>

<p>Thank you for promptly addressing this matter and ensuring customer satisfaction.</p>
<br>

<p>Best regards,</p>
<br>
<p>Amaresh Sahoo CEO, Extra Power</p>
                   
                    <button id="downloadPdfBtn">Download as PDF</button>
                `;

// Show the modal
                document.getElementById('myModal').style.display = 'block';

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

function downloadAsPdf(data) {
    // Use html2pdf to generate PDF
    const content = `
    <img src="assets/images/logo100.png" class="center" style="height: 50px;width: 100;margin-left:35%"  alt="logo">
                <br>
                <br>
                <br>
                    
                    <p>Dear ${data.form_name},</p>
                    <br>

<p>Thank you for promptly addressing this matter and ensuring customer satisfaction.</p>
<br>

<p>Best regards,</p>
<br>
<p>Amaresh Sahoo CEO, Extra Power</p>
                   
                  
    `;

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

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

// Generate PDF
    html2pdf(element, options);
}

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

var formData = {
        id: row.dataset.id, // Assuming you set the 'id' as a data attribute on the row
        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);
    });
}

</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: crequest.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation