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/hifi11.in/public_html/selvaganapathi

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: bill-history.php

<?php
// bill-history.php
// Enable error logging instead of displaying errors
ini_set('display_errors', 0);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');

// Start session
session_start();

// Database connection
include 'includes/db.php';

// Get selected finance_id from session
$finance_id = isset($_SESSION['finance_id']) ? intval($_SESSION['finance_id']) : 0;

// Check if finance is selected
$finance_selected = $finance_id > 0;

// Get search parameters
$search_bill = isset($_GET['bill_number']) ? trim($_GET['bill_number']) : '';
$search_customer = isset($_GET['customer_name']) ? trim($_GET['customer_name']) : '';
$search_date = isset($_GET['payment_date']) ? trim($_GET['payment_date']) : '';

// Initialize variables
$bills = [];
$total_collection = 0;
$total_emi_amount = 0;
$total_excess_amount = 0;
$total_bills = 0;
$today_total = 0;
$today_emi = 0;
$today_excess = 0;

// Build WHERE clause
$where_clause = "WHERE es.status = 'paid'";
$params = [];
$types = "";

if ($finance_selected) {
    $where_clause .= " AND es.finance_id = ?";
    $params[] = $finance_id;
    $types .= "i";
}

// Add search filters
if (!empty($search_bill)) {
    $where_clause .= " AND es.emi_bill_number LIKE ?";
    $params[] = "%{$search_bill}%";
    $types .= "s";
}

if (!empty($search_customer)) {
    $where_clause .= " AND c.customer_name LIKE ?";
    $params[] = "%{$search_customer}%";
    $types .= "s";
}

if (!empty($search_date)) {
    $where_clause .= " AND DATE(es.paid_date) = ?";
    $params[] = $search_date;
    $types .= "s";
}

// Query to fetch bill history with customer details AND excess payments
$sql = "SELECT 
            es.emi_bill_number,
            es.paid_date,
            es.principal_paid,
            es.interest_paid,
            es.overdue_charges,
            (es.principal_paid + es.interest_paid + es.overdue_charges) as emi_amount,
            COALESCE(ep.excess_amount, 0) as excess_amount,
            (es.principal_paid + es.interest_paid + es.overdue_charges + COALESCE(ep.excess_amount, 0)) as total_amount,
            c.customer_name,
            c.agreement_number,
            c.customer_number,
            f.finance_name,
            es.id as emi_id,
            es.customer_id,
            DATE(es.paid_date) as payment_date_only,
            (SELECT COUNT(*) FROM emi_schedule WHERE customer_id = c.id AND id <= es.id) as emi_number,
            ep.remaining_amount as excess_remaining
        FROM emi_schedule es
        JOIN customers c ON es.customer_id = c.id
        JOIN finance f ON es.finance_id = f.id
        LEFT JOIN excess_payments ep ON es.id = ep.emi_id AND ep.bill_number = es.emi_bill_number AND ep.status = 'active'
        {$where_clause}
        ORDER BY es.paid_date DESC, es.emi_bill_number DESC";

// Prepare and execute query
if (!empty($params)) {
    $stmt = $conn->prepare($sql);
    $stmt->bind_param($types, ...$params);
    $stmt->execute();
    $result = $stmt->get_result();
} else {
    $result = $conn->query($sql);
}

if ($result && $result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $bills[] = $row;
        $total_emi_amount += $row['emi_amount'];
        $total_excess_amount += $row['excess_amount'];
        $total_collection += $row['total_amount'];
        
        // Calculate today's totals
        if (date('Y-m-d') == $row['payment_date_only']) {
            $today_emi += $row['emi_amount'];
            $today_excess += $row['excess_amount'];
            $today_total += $row['total_amount'];
        }
    }
    $total_bills = count($bills);
    
    if (!empty($params)) {
        $stmt->close();
    }
}

// Get totals for current month
$current_month = date('Y-m');
$month_sql = "SELECT 
                SUM(es.principal_paid + es.interest_paid + es.overdue_charges) as month_emi,
                SUM(COALESCE(ep.excess_amount, 0)) as month_excess,
                SUM(es.principal_paid + es.interest_paid + es.overdue_charges + COALESCE(ep.excess_amount, 0)) as month_total
              FROM emi_schedule es
              LEFT JOIN excess_payments ep ON es.id = ep.emi_id AND ep.bill_number = es.emi_bill_number AND ep.status = 'active'
              WHERE es.finance_id = ? AND es.status = 'paid' 
              AND DATE_FORMAT(es.paid_date, '%Y-%m') = ?";
$stmt_month = $conn->prepare($month_sql);
$stmt_month->bind_param("is", $finance_id, $current_month);
$stmt_month->execute();
$month_result = $stmt_month->get_result();
$month_emi = 0;
$month_excess = 0;
$month_total = 0;
if ($month_row = $month_result->fetch_assoc()) {
    $month_emi = $month_row['month_emi'] ?: 0;
    $month_excess = $month_row['month_excess'] ?: 0;
    $month_total = $month_row['month_total'] ?: 0;
}
$stmt_month->close();

mysqli_close($conn);
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>

<div class="startbar d-print-none">
    <?php include 'includes/leftbar-tab-menu.php'; ?> 
    <?php include 'includes/leftbar.php'; ?>
    <div class="startbar-overlay d-print-none"></div>

<?php if (isset($_SESSION['success'])): ?>
            <div class="alert alert-success alert-dismissible fade show" role="alert">
              <strong>Success!</strong> <?php echo $_SESSION['success']; ?>
              <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
            <?php unset($_SESSION['success']); ?>
          <?php endif; ?>
          <?php if (isset($_SESSION['error'])): ?>
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
              <strong>Error!</strong> <?php echo $_SESSION['error']; ?>
              <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
            <?php unset($_SESSION['error']); ?>
          <?php endif; ?>

<?php if (!$finance_selected): ?>
            <div class="alert alert-warning" role="alert">
              <i class="fas fa-exclamation-triangle me-2"></i>
              <strong>No Finance Selected:</strong> Please select a finance from the topbar dropdown to view bill history.
            </div>
          <?php endif; ?>

<div class="row align-items-center mb-3">
            <div class="col">
              <h3 class="mb-0">Bill History & Collections</h3>
              <small class="text-muted">
                <?php if ($finance_selected): ?>
                  View all payment receipts and collection history for selected finance
                <?php else: ?>
                  Please select a finance to view bill history
                <?php endif; ?>
              </small>
            </div>
            <div class="col-auto">
              <a href="collection.php" class="btn btn-light">
                <i class="iconoir-arrow-left me-1"></i> Back to Collection
              </a>
              <a href="calendar.php" class="btn btn-light ms-2">View Calendar</a>
            </div>
          </div>

<?php if ($finance_selected): ?>
          
          <div class="row mb-4">
            <div class="col-6 col-md-3 mb-3">
              <div class="card bg-primary text-white">
                <div class="card-body p-3">
                  <div class="d-flex justify-content-between align-items-center">
                    <div>
                      <h5 class="mb-0"><?php echo $total_bills; ?></h5>
                      <small>Total Bills</small>
                    </div>
                    <i class="fas fa-file-invoice fa-lg opacity-50"></i>
                  </div>
                </div>
              </div>
            </div>
            <div class="col-6 col-md-3 mb-3">
              <div class="card bg-success text-white">
                <div class="card-body p-3">
                  <div class="d-flex justify-content-between align-items-center">
                    <div>
                      <h5 class="mb-0">₹<?php echo number_format($total_collection, 2); ?></h5>
                      <small>Total Collection</small>
                      <div class="small opacity-75">
                        EMI: ₹<?php echo number_format($total_emi_amount, 2); ?> + 
                        Extra: ₹<?php echo number_format($total_excess_amount, 2); ?>
                      </div>
                    </div>
                    <i class="fas fa-rupee-sign fa-lg opacity-50"></i>
                  </div>
                </div>
              </div>
            </div>
            <div class="col-6 col-md-3 mb-3">
              <div class="card bg-warning text-white">
                <div class="card-body p-3">
                  <div class="d-flex justify-content-between align-items-center">
                    <div>
                      <h5 class="mb-0">₹<?php echo number_format($today_total, 2); ?></h5>
                      <small>Today's Collection</small>
                      <div class="small opacity-75">
                        EMI: ₹<?php echo number_format($today_emi, 2); ?> + 
                        Extra: ₹<?php echo number_format($today_excess, 2); ?>
                      </div>
                    </div>
                    <i class="fas fa-calendar-day fa-lg opacity-50"></i>
                  </div>
                </div>
              </div>
            </div>
            <div class="col-6 col-md-3 mb-3">
              <div class="card bg-info text-white">
                <div class="card-body p-3">
                  <div class="d-flex justify-content-between align-items-center">
                    <div>
                      <h5 class="mb-0">₹<?php echo number_format($month_total, 2); ?></h5>
                      <small>This Month</small>
                      <div class="small opacity-75">
                        EMI: ₹<?php echo number_format($month_emi, 2); ?> + 
                        Extra: ₹<?php echo number_format($month_excess, 2); ?>
                      </div>
                    </div>
                    <i class="fas fa-calendar-alt fa-lg opacity-50"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>

<div class="card mb-4">
            <div class="card-header bg-light">
              <h5 class="card-title mb-0">Search Bills</h5>
            </div>
            <div class="card-body">
              <form method="GET" action="bill-history.php">
                <div class="row g-3">
                  <div class="col-md-3">
                    <label for="bill_number" class="form-label fw-bold">Bill Number</label>
                    <input type="text" class="form-control" id="bill_number" name="bill_number" 
                           value="<?php echo htmlspecialchars($search_bill); ?>" 
                           placeholder="Search by bill number">
                  </div>
                  <div class="col-md-3">
                    <label for="customer_name" class="form-label fw-bold">Customer Name</label>
                    <input type="text" class="form-control" id="customer_name" name="customer_name" 
                           value="<?php echo htmlspecialchars($search_customer); ?>" 
                           placeholder="Search by customer name">
                  </div>
                  <div class="col-md-3">
                    <label for="payment_date" class="form-label fw-bold">Payment Date</label>
                    <input type="date" class="form-control" id="payment_date" name="payment_date" 
                           value="<?php echo htmlspecialchars($search_date); ?>">
                  </div>
                  <div class="col-md-3 d-flex align-items-end">
                    <div class="d-flex gap-2 w-100">
                      <button type="submit" class="btn btn-primary flex-grow-1">
                        <i class="fas fa-search me-1"></i> Search
                      </button>
                      <a href="bill-history.php" class="btn btn-outline-secondary">
                        <i class="fas fa-times"></i>
                      </a>
                    </div>
                  </div>
                </div>
              </form>
            </div>
          </div>

<div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
              <h4 class="card-title mb-0">Bill History</h4>
              <?php if ($total_bills > 0): ?>
                <div class="text-success fw-bold">
                  <i class="fas fa-rupee-sign me-1"></i>
                  Total: ₹<?php echo number_format($total_collection, 2); ?>
                  <small class="text-muted d-block">
                    EMI: ₹<?php echo number_format($total_emi_amount, 2); ?> + 
                    Extra: ₹<?php echo number_format($total_excess_amount, 2); ?>
                  </small>
                </div>
              <?php endif; ?>
            </div>
            <div class="card-body">
              <?php if ($total_bills > 0): ?>
                <div class="table-responsive">
                  <table id="tblBillHistory" class="table table-striped table-bordered align-middle w-100">
                    <thead class="table-light">
                      <tr>
                        <th>#</th>
                        <th>Bill No</th>
                        <th>Payment Date</th>
                        <th>Customer Name</th>
                        <th>Agreement No</th>
                        <th>Contact</th>
                        <th>EMI #</th>
                        <th>Principal (₹)</th>
                        <th>Interest (₹)</th>
                        <th>Overdue (₹)</th>
                        <th>EMI Total (₹)</th>
                        <th>Extra (₹)</th>
                        <th>Total (₹)</th>
                        <th class="text-center">Actions</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php $counter = 1; ?>
                      <?php foreach ($bills as $bill): ?>
                        <?php 
                        $payment_date = $bill['paid_date'] ? date('d M Y', strtotime($bill['paid_date'])) : 'N/A';
                        $emi_number = $bill['emi_number'] ? "EMI #{$bill['emi_number']}" : '-';
                        $emi_total = $bill['emi_amount'];
                        $excess_amount = $bill['excess_amount'];
                        $total_amount = $bill['total_amount'];
                        ?>
                        <tr>
                          <td><?php echo $counter++; ?></td>
                          <td>
                            <span class="badge bg-primary"><?php echo htmlspecialchars($bill['emi_bill_number']); ?></span>
                          </td>
                          <td>
                            <?php echo $payment_date; ?>
                            <?php if (date('Y-m-d') == $bill['payment_date_only']): ?>
                              <span class="badge bg-success ms-1">Today</span>
                            <?php endif; ?>
                          </td>
                          <td>
                            <div class="d-flex align-items-center">
                              <div class="flex-shrink-0 me-2">
                                <div class="avatar-xs">
                                  <div class="avatar-title bg-soft-primary text-primary rounded-circle">
                                    <?php echo strtoupper(substr($bill['customer_name'], 0, 1)); ?>
                                  </div>
                                </div>
                              </div>
                              <div class="flex-grow-1">
                                <?php echo htmlspecialchars($bill['customer_name']); ?>
                                <?php if ($excess_amount > 0): ?>
                                  <div class="small text-success">
                                    <i class="fas fa-plus-circle me-1"></i>
                                    Extra payment included
                                  </div>
                                <?php endif; ?>
                              </div>
                            </div>
                          </td>
                          <td>
                            <span class="badge bg-secondary"><?php echo htmlspecialchars($bill['agreement_number']); ?></span>
                          </td>
                          <td>
                            <a href="tel:<?php echo $bill['customer_number']; ?>" class="text-decoration-none">
                              <i class="fas fa-phone-alt me-1 text-muted"></i>
                              <?php echo htmlspecialchars($bill['customer_number']); ?>
                            </a>
                          </td>
                          <td><?php echo $emi_number; ?></td>
                          <td class="fw-bold text-success">₹<?php echo number_format($bill['principal_paid'], 2); ?></td>
                          <td class="fw-bold text-warning">₹<?php echo number_format($bill['interest_paid'], 2); ?></td>
                          <td class="fw-bold text-danger">
                            <?php echo $bill['overdue_charges'] > 0 ? '₹' . number_format($bill['overdue_charges'], 2) : '-'; ?>
                          </td>
                          <td class="fw-bold text-info">₹<?php echo number_format($emi_total, 2); ?></td>
                          <td class="<?php echo $excess_amount > 0 ? 'fw-bold text-success' : 'text-muted'; ?>">
                            <?php if ($excess_amount > 0): ?>
                              <div class="d-flex align-items-center">
                                <i class="fas fa-plus-circle me-1"></i>
                                ₹<?php echo number_format($excess_amount, 2); ?>
                                <?php if ($bill['excess_remaining'] > 0): ?>
                                  <small class="text-muted ms-1" title="Remaining excess amount">
                                    (₹<?php echo number_format($bill['excess_remaining'], 2); ?> remaining)
                                  </small>
                                <?php endif; ?>
                              </div>
                            <?php else: ?>
                              -
                            <?php endif; ?>
                          </td>
                          <td class="fw-bold text-primary">
                            ₹<?php echo number_format($total_amount, 2); ?>
                            <?php if ($excess_amount > 0): ?>
                              <div class="small text-muted">
                                EMI + Extra
                              </div>
                            <?php endif; ?>
                          </td>
                          <td class="text-center">
                            <div class="btn-group btn-group-sm">
                              <a href="print-receipt.php?emi_id=<?php echo $bill['emi_id']; ?>&customer_id=<?php echo $bill['customer_id']; ?>" 
                                 class="btn btn-outline-info" target="_blank" title="Print Receipt">
                                <i class="fas fa-print"></i>
                              </a>
                              <a href="view-receipt.php?bill_number=<?php echo urlencode($bill['emi_bill_number']); ?>&customer_id=<?php echo $bill['customer_id']; ?>" 
                                 class="btn btn-outline-secondary" title="View Details">
                                <i class="fas fa-eye"></i>
                              </a>
                            </div>
                          </td>
                        </tr>
                      <?php endforeach; ?>
                    </tbody>
                    <?php if ($total_bills > 0): ?>
                    <tfoot>
                      <tr class="table-success">
                        <td colspan="10" class="text-end fw-bold">Grand Total:</td>
                        <td class="fw-bold text-info">₹<?php echo number_format($total_emi_amount, 2); ?></td>
                        <td class="fw-bold text-success">₹<?php echo number_format($total_excess_amount, 2); ?></td>
                        <td class="fw-bold text-primary">₹<?php echo number_format($total_collection, 2); ?></td>
                        <td></td>
                      </tr>
                      <tr class="table-light">
                        <td colspan="10" class="text-end fw-bold">Sub Totals:</td>
                        <td class="fw-bold text-info">
                          EMI: ₹<?php echo number_format($total_emi_amount, 2); ?>
                        </td>
                        <td class="fw-bold text-success">
                          + Extra: ₹<?php echo number_format($total_excess_amount, 2); ?>
                        </td>
                        <td class="fw-bold text-primary">
                          = Total: ₹<?php echo number_format($total_collection, 2); ?>
                        </td>
                        <td></td>
                      </tr>
                    </tfoot>
                    <?php endif; ?>
                  </table>
                </div>
              <?php else: ?>
                <div class="text-center py-5">
                  <i class="fas fa-file-invoice fa-3x text-muted mb-3"></i>
                  <h5 class="text-muted">No bills found</h5>
                  <p class="text-muted">
                    <?php if (!empty($search_bill) || !empty($search_customer) || !empty($search_date)): ?>
                      No bills match your search criteria.
                    <?php else: ?>
                      No payment records found for the selected finance.
                    <?php endif; ?>
                  </p>
                  <?php if (!empty($search_bill) || !empty($search_customer) || !empty($search_date)): ?>
                    <a href="bill-history.php" class="btn btn-primary mt-2">
                      <i class="fas fa-times me-1"></i> Clear Search
                    </a>
                  <?php endif; ?>
                </div>
              <?php endif; ?>
            </div>
          </div>

<?php if ($total_bills > 0): ?>
          <div class="card mt-4">
            <div class="card-header bg-light">
              <h5 class="card-title mb-0">Export Options</h5>
            </div>
            <div class="card-body">
              <div class="row">
                <div class="col-md-3 mb-2">
                  <button class="btn btn-outline-primary w-100" onclick="printBillHistory()">
                    <i class="fas fa-print me-1"></i> Print Summary
                  </button>
                </div>
                <div class="col-md-3 mb-2">
                  <button class="btn btn-outline-success w-100" onclick="exportToExcel()">
                    <i class="fas fa-file-excel me-1"></i> Export to Excel
                  </button>
                </div>
                <div class="col-md-3 mb-2">
                  <button class="btn btn-outline-danger w-100" onclick="exportToPDF()">
                    <i class="fas fa-file-pdf me-1"></i> Export to PDF
                  </button>
                </div>
                <div class="col-md-3 mb-2">
                  <button class="btn btn-outline-info w-100" onclick="copyToClipboard()">
                    <i class="fas fa-copy me-1"></i> Copy Summary
                  </button>
                </div>
              </div>
            </div>
          </div>
          <?php endif; ?>

<?php else: ?>
            
            <div class="card">
              <div class="card-body text-center py-5">
                <i class="fas fa-file-invoice fa-3x text-muted mb-3"></i>
                <h5 class="text-muted">Please select a finance</h5>
                <p class="text-muted">To view bill history and collections, please select a finance from the dropdown in the top bar.</p>
                <div class="mt-3">
                  <form action="set-finance-session.php" method="post" id="financeSelectForm" class="d-inline">
                    <select class="form-select d-inline-block w-auto me-2" name="finance_id" onchange="this.form.submit()">
                      <option value="0">Select Finance</option>
                      <option value="1">Sri Selvaganapathi</option>
                      <option value="2">Sri Veerabathra Auto Finance</option>
                    </select>
                  </form>
                  <button class="btn btn-primary" onclick="document.getElementById('financeSelectForm').submit();">
                    <i class="fas fa-check me-1"></i> Select Finance
                  </button>
                </div>
              </div>
            </div>
          <?php endif; ?>
        </div>

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

<?php include 'includes/scripts.php'; ?>

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.8/css/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.2/css/buttons.bootstrap5.min.css">
    <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.8/js/dataTables.bootstrap5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.bootstrap5.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.print.min.js"></script>

// Add custom search for all columns
        $('#tblBillHistory_filter input').on('keyup', function() {
          table.search(this.value).draw();
        });
      });

// Print bill history
      function printBillHistory() {
        var printContent = `
          <div style="padding: 20px;">
            <h2 style="text-align: center; margin-bottom: 20px;">Bill History Summary</h2>
            <div style="margin-bottom: 20px; border: 1px solid #ccc; padding: 15px; background: #f9f9f9;">
              <h4 style="margin-top: 0;">Collection Summary</h4>
              <p><strong>Finance:</strong> <?php echo isset($bills[0]['finance_name']) ? htmlspecialchars($bills[0]['finance_name']) : ''; ?></p>
              <p><strong>Total Bills:</strong> <?php echo $total_bills; ?></p>
              <p><strong>Total Collection:</strong> ₹<?php echo number_format($total_collection, 2); ?></p>
              <p><strong>Breakdown:</strong> 
                EMI Amount: ₹<?php echo number_format($total_emi_amount, 2); ?> + 
                Extra Amount: ₹<?php echo number_format($total_excess_amount, 2); ?>
              </p>
              <p><strong>Today's Collection:</strong> ₹<?php echo number_format($today_total, 2); ?> 
                (EMI: ₹<?php echo number_format($today_emi, 2); ?> + Extra: ₹<?php echo number_format($today_excess, 2); ?>)
              </p>
              <p><strong>This Month:</strong> ₹<?php echo number_format($month_total, 2); ?> 
                (EMI: ₹<?php echo number_format($month_emi, 2); ?> + Extra: ₹<?php echo number_format($month_excess, 2); ?>)
              </p>
              <p><strong>Generated On:</strong> <?php echo date('d M Y, h:i A'); ?></p>
            </div>
            ${document.getElementById('tblBillHistory').outerHTML}
          </div>
        `;
        
        var printWindow = window.open('', '_blank');
        printWindow.document.write(`
          <html>
            <head>
              <title>Bill History Summary</title>
              <style>
                body { font-family: Arial, sans-serif; margin: 20px; }
                table { width: 100%; border-collapse: collapse; margin-top: 20px; }
                th, td { border: 1px solid #000; padding: 8px; text-align: left; }
                th { background-color: #f2f2f2; font-weight: bold; }
                .total-row { font-weight: bold; background-color: #e8f5e8; }
                @media print {
                  @page { size: landscape; }
                }
              </style>
            </head>
            <body>
              ${printContent}
            </body>
          </html>
        `);
        printWindow.document.close();
        printWindow.print();
      }

// Export to Excel
      function exportToExcel() {
        var table = $('#tblBillHistory').DataTable();
        table.button('.buttons-excel').trigger();
      }

// Export to PDF (simulate)
      function exportToPDF() {
        alert('PDF export would require additional libraries. For now, please use Print or Excel export.');
      }

// Copy summary to clipboard
      function copyToClipboard() {
        var summaryText = `Bill History Summary\n`;
        summaryText += `Finance: <?php echo isset($bills[0]['finance_name']) ? htmlspecialchars($bills[0]['finance_name']) : ''; ?>\n`;
        summaryText += `Total Bills: <?php echo $total_bills; ?>\n`;
        summaryText += `Total Collection: ₹<?php echo number_format($total_collection, 2); ?>\n`;
        summaryText += `Breakdown: EMI ₹<?php echo number_format($total_emi_amount, 2); ?> + Extra ₹<?php echo number_format($total_excess_amount, 2); ?>\n`;
        summaryText += `Today's Collection: ₹<?php echo number_format($today_total, 2); ?> (EMI ₹<?php echo number_format($today_emi, 2); ?> + Extra ₹<?php echo number_format($today_excess, 2); ?>)\n`;
        summaryText += `This Month: ₹<?php echo number_format($month_total, 2); ?> (EMI ₹<?php echo number_format($month_emi, 2); ?> + Extra ₹<?php echo number_format($month_excess, 2); ?>)\n`;
        summaryText += `Generated: <?php echo date('d M Y, h:i A'); ?>`;
        
        navigator.clipboard.writeText(summaryText).then(function() {
          alert('Summary copied to clipboard!');
        }, function() {
          // Fallback for older browsers
          var textArea = document.createElement("textarea");
          textArea.value = summaryText;
          document.body.appendChild(textArea);
          textArea.select();
          document.execCommand("copy");
          document.body.removeChild(textArea);
          alert('Summary copied to clipboard!');
        });
      }

// Auto focus on search input
      $(document).ready(function() {
        <?php if (!empty($search_bill)): ?>
          $('#bill_number').focus();
        <?php elseif (!empty($search_customer)): ?>
          $('#customer_name').focus();
        <?php endif; ?>
      });
    </script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: bill-history.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation