Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/style29.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: view-customer.php

<?php
// view-customer.php
include('includes/db.php');

// Handle invoice deletion
if (isset($_GET['delete_invoice_id'])) {
    $delete_invoice_id = (int)$_GET['delete_invoice_id'];
    $customer_id = (int)$_GET['id'];

// Fetch invoice details for logging
    $inv_sql = "SELECT id, invoice_number, customer_id, total, payment_method, created_at FROM invoices WHERE id = ?";
    $inv_stmt = mysqli_prepare($conn, $inv_sql);
    mysqli_stmt_bind_param($inv_stmt, 'i', $delete_invoice_id);
    mysqli_stmt_execute($inv_stmt);
    $inv_result = mysqli_stmt_get_result($inv_stmt);
    $invoice = mysqli_fetch_assoc($inv_result);

if ($invoice) {
        // Log the deletion
        $record_details = json_encode($invoice);
        $log_sql = "INSERT INTO deletion_logs (table_name, record_id, record_details, deleted_by) VALUES (?, ?, ?, ?)";
        $log_stmt = mysqli_prepare($conn, $log_sql);
        $table_name = 'invoices';
        $deleted_by = 'admin'; // Adjust based on your authentication system
        mysqli_stmt_bind_param($log_stmt, 'siss', $table_name, $delete_invoice_id, $record_details, $deleted_by);
        mysqli_stmt_execute($log_stmt);

// Delete associated invoice items
        $delete_items_sql = "DELETE FROM invoice_items WHERE invoice_id = ?";
        $delete_items_stmt = mysqli_prepare($conn, $delete_items_sql);
        mysqli_stmt_bind_param($delete_items_stmt, 'i', $delete_invoice_id);
        mysqli_stmt_execute($delete_items_stmt);

// Delete the invoice
        $delete_inv_sql = "DELETE FROM invoices WHERE id = ?";
        $delete_inv_stmt = mysqli_prepare($conn, $delete_inv_sql);
        mysqli_stmt_bind_param($delete_inv_stmt, 'i', $delete_invoice_id);
        $success = mysqli_stmt_execute($delete_inv_stmt);

if ($success) {
            header("Location: view-customer.php?id=" . $customer_id . "&msg=Invoice deleted successfully&type=success");
        } else {
            header("Location: view-customer.php?id=" . $customer_id . "&msg=Failed to delete invoice&type=danger");
        }
        exit();
    } else {
        header("Location: view-customer.php?id=" . $customer_id . "&msg=Invoice not found&type=warning");
        exit();
    }
}

// Handle customer deletion
if (isset($_GET['delete_id'])) {
    $delete_id = (int)$_GET['delete_id'];

// Check if customer has invoices
    $inv_check_sql = "SELECT COUNT(*) AS invoice_count FROM invoices WHERE customer_id = ?";
    $inv_check_stmt = mysqli_prepare($conn, $inv_check_sql);
    mysqli_stmt_bind_param($inv_check_stmt, 'i', $delete_id);
    mysqli_stmt_execute($inv_check_stmt);
    $inv_check_result = mysqli_stmt_get_result($inv_check_stmt);
    $inv_count = mysqli_fetch_assoc($inv_check_result)['invoice_count'];

if ($inv_count > 0) {
        header('Location: view-customer.php?id=' . $delete_id . '&msg=' . urlencode('Cannot delete customer with existing invoices') . '&type=danger');
        exit;
    }

// Fetch customer details for logging
    $sql = "SELECT id, name, phone, created_at FROM customers WHERE id = ?";
    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param($stmt, 'i', $delete_id);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $customer = mysqli_fetch_assoc($result);

if ($customer) {
        // Log the deletion
        $record_details = json_encode($customer);
        $log_sql = "INSERT INTO deletion_logs (table_name, record_id, record_details, deleted_by) VALUES (?, ?, ?, ?)";
        $log_stmt = mysqli_prepare($conn, $log_sql);
        $table_name = 'customers';
        $deleted_by = 'admin'; // Adjust based on your authentication system
        mysqli_stmt_bind_param($log_stmt, 'siss', $table_name, $delete_id, $record_details, $deleted_by);
        mysqli_stmt_execute($log_stmt);

// Delete the customer
        $delete_sql = "DELETE FROM customers WHERE id = ?";
        $delete_stmt = mysqli_prepare($conn, $delete_sql);
        mysqli_stmt_bind_param($delete_stmt, 'i', $delete_id);
        $success = mysqli_stmt_execute($delete_stmt);

if ($success) {
            header("Location: customers.php?msg=Customer deleted successfully&type=success");
        } else {
            header("Location: view-customer.php?id=" . $delete_id . "&msg=Failed to delete customer&type=danger");
        }
        exit();
    } else {
        header("Location: customers.php?msg=Customer not found&type=warning");
        exit();
    }
}

// Validate & fetch ID
$customerId = isset($_GET['id']) ? (int)$_GET['id'] : 0;
if ($customerId <= 0) {
    header('Location: customers.php?msg=' . urlencode('Invalid customer ID') . '&type=danger');
    exit;
}

// Fetch customer
$custSql = "SELECT id, name, phone, created_at FROM customers WHERE id = {$customerId} LIMIT 1";
$custRes = mysqli_query($conn, $custSql);
if (!$custRes || mysqli_num_rows($custRes) === 0) {
    header('Location: customers.php?msg=' . urlencode('Customer not found') . '&type=warning');
    exit;
}
$customer = mysqli_fetch_assoc($custRes);

// Fetch invoices + item counts
$invSql = "
    SELECT 
        i.id,
        i.invoice_number,
        i.total,
        i.payment_method,
        i.created_at,
        COALESCE(SUM(ii.quantity), 0) AS items_count
    FROM invoices i
    LEFT JOIN invoice_items ii ON ii.invoice_id = i.id
    WHERE i.customer_id = {$customerId}
    GROUP BY i.id
    ORDER BY i.id DESC
";
$invRes = mysqli_query($conn, $invSql);

// Totals
$totalInvoices = 0;
$totalSpent = 0.00;
$invoices = [];
if ($invRes && mysqli_num_rows($invRes) > 0) {
    while ($row = mysqli_fetch_assoc($invRes)) {
        $invoices[] = $row;
        $totalInvoices++;
        $totalSpent += (float)$row['total'];
    }
}

// Best-effort last purchase datetime
$lastPurchase = null;
if (!empty($invoices)) {
    $lastPurchase = $invoices[0]['created_at'];
    if ($ts = strtotime($lastPurchase)) {
        $lastPurchase = date("Y-m-d H:i", $ts);
    }
}

function h($v) { return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }
?>

<!doctype html>
<html lang="en">

<?php include('includes/head.php'); ?>

<?php if (isset($_GET['msg'])): ?>
                                    <div class="alert alert-<?php echo htmlspecialchars($_GET['type'] ?? 'info'); ?> alert-dismissible fade show" role="alert">
                                        <?php echo htmlspecialchars($_GET['msg']); ?>
                                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                    </div>
                                <?php endif; ?>

<div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title mb-0">Customer Details</h4>
                                    <div>
                                        <a href="customers.php" class="btn btn-secondary btn-sm">Back to Customers</a>
                                        <a href="view-customer.php?delete_id=<?php echo (int)$customer['id']; ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this customer?');">Delete Customer</a>
                                    </div>
                                </div>

<div class="row">
                                    <div class="col-md-6">
                                        <table class="table table-sm table-borderless">
                                            <tr>
                                                <th style="width:180px;">Customer ID</th>
                                                <td>#<?php echo (int)$customer['id']; ?></td>
                                            </tr>
                                            <tr>
                                                <th>Name</th>
                                                <td><?php echo h($customer['name']); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Phone</th>
                                                <td><?php echo h(trim($customer['phone']) !== '' ? $customer['phone'] : 'N/A'); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Created Date</th>
                                                <td>
                                                    <?php
                                                    $craw = $customer['created_at'];
                                                    if ($ts = strtotime($craw)) {
                                                        echo h(date("Y-m-d H:i", $ts));
                                                    } else {
                                                        echo h($craw);
                                                    }
                                                    ?>
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                    <div class="col-md-6">
                                        <table class="table table-sm table-borderless">
                                            <tr>
                                                <th style="width:180px;">Total Invoices</th>
                                                <td><?php echo (int)$totalInvoices; ?></td>
                                            </tr>
                                            <tr>
                                                <th>Total Spent</th>
                                                <td><?php echo number_format($totalSpent, 2); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Last Purchase</th>
                                                <td><?php echo $lastPurchase ? h($lastPurchase) : '—'; ?></td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>

<h5 class="mb-3">Invoices</h5>

<table id="invoicesTable" class="table table-bordered table-striped" style="width:100%">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Invoice No.</th>
                                            <th>Items</th>
                                            <th>Total (₹)</th>
                                            <th>Payment</th>
                                            <th>Created Date</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        if (!empty($invoices)) {
                                            $i = 1;
                                            foreach ($invoices as $inv) {
                                                $invId   = (int)$inv['id'];
                                                $invNo   = h($inv['invoice_number']);
                                                $invNoUrl= urlencode($inv['invoice_number']);
                                                $items   = (int)$inv['items_count'];
                                                $total   = number_format((float)$inv['total'], 2);
                                                $pay     = h($inv['payment_method']);
                                                $created = $inv['created_at'];
                                                if ($ts = strtotime($created)) {
                                                    $created = date("Y-m-d H:i", $ts);
                                                }
                                                $created = h($created);

echo "<tr>
                                                        <td>{$i}</td>
                                                        <td>
                                                            <a href=\"#\" class=\"invoice-link\" data-invoice-id=\"{$invId}\">{$invNo}</a>
                                                        </td>
                                                        <td>{$items}</td>
                                                        <td>{$total}</td>
                                                        <td>{$pay}</td>
                                                        <td>{$created}</td>
                                                        <td>
                                                            <a href=\"invoice_print.php?invoice_id={$invNoUrl}&auto=1\"
                                                               target=\"_blank\" class=\"btn btn-outline-dark btn-sm\">
                                                                Print
                                                            </a>
                                                            <a href=\"view-customer.php?id={$customerId}&delete_invoice_id={$invId}\"
                                                               class=\"btn btn-danger btn-sm\"
                                                               onclick=\"return confirm('Are you sure you want to delete this invoice?');\">
                                                                Delete
                                                            </a>
                                                        </td>
                                                      </tr>";
                                                $i++;
                                            }
                                        } else {
                                            echo "<tr><td colspan='7' class='text-center'>No invoices for this customer</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>

</div>
                        </div>
                    </div>
                </div>

</div>
        </div>

<?php include('includes/footer.php'); ?>
    </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

<div class="modal fade" id="invoiceItemsModal" tabindex="-1" aria-labelledby="invoiceItemsLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="invoiceItemsLabel">Invoice Items</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body" id="invoiceItemsBody">
        <div class="text-center py-3">Loading…</div>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Close</button>
      </div>
    </div>
  </div>
</div>

// Click to load invoice items in modal
    $(document).on('click', '.invoice-link', function (e) {
        e.preventDefault();
        var invId = $(this).data('invoice-id');
        if (!invId) return;

$('#invoiceItemsBody').html('<div class="text-center py-3">Loading…</div>');
        // Show modal immediately (Bootstrap 5 assumed in your includes)
        var modalEl = document.getElementById('invoiceItemsModal');
        var modal = new bootstrap.Modal(modalEl);
        modal.show();

$.get('get-invoice-items.php', { invoice_id: invId }, function (html) {
            $('#invoiceItemsBody').html(html);
        }).fail(function () {
            $('#invoiceItemsBody').html('<div class="text-danger">Failed to load invoice items.</div>');
        });
    });
});
// Enhanced print functionality for all pages
if (typeof window.electronAPI !== 'undefined') {
  // Override browser print with Electron print
  window.print = function() {
    if (window.electronAPI) {
      const pageType = getPageType();
      window.electronAPI.printReceipt({
        silent: true,
        printBackground: false,
        color: false,
        pageType: pageType
      }).then(result => {
        if (result.success) {
          console.log('Print successful:', result.message);
        } else {
          console.error('Print failed:', result.message);
        }
      }).catch(error => {
        console.error('Print error:', error);
      });
    } else {
      // Fallback to browser print
      originalPrint();
    }
  };

// Store original print function
  const originalPrint = window.print;

// Determine page type
  function getPageType() {
    const url = window.location.href;
    if (url.includes('sales.php')) return 'sales';
    if (url.includes('orders.php')) return 'orders';
    if (url.includes('view-customer.php')) return 'customer';
    return 'generic';
  }

console.log('Electron print functionality enabled for', getPageType(), 'page');
}
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-customer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation