| Server IP : 173.209.174.21 / Your IP : 216.73.216.89 Web Server : Apache/2.4.58 (Ubuntu) System : Linux wcfs-server 6.8.0-124-generic #124-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 13:00:45 UTC 2026 x86_64 User : nodor ( 1000) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/wcfs/tabs/Backups/ |
Upload File : |
<?php
include 'db.php';
$letter = $_GET['letter'] ?? '';
$search = $_GET['search'] ?? '';
// Get filtered customers
if ($search) {
$stmt = $conn->prepare("SELECT * FROM customers WHERE first_name LIKE ? OR last_name LIKE ? ORDER BY last_name, first_name");
$like = "%$search%";
$stmt->bind_param("ss", $like, $like);
} elseif ($letter) {
$stmt = $conn->prepare("SELECT * FROM customers WHERE last_name LIKE ? ORDER BY last_name, first_name");
$like = "$letter%";
$stmt->bind_param("s", $like);
} else {
$stmt = $conn->prepare("SELECT * FROM customers ORDER BY last_name, first_name");
}
$stmt->execute();
$customers = $stmt->get_result();
?>
<!DOCTYPE html>
<html>
<head>
<title>Customer Accounts - Wilson Creek Farm Supply</title>
<style>
body { font-family: Arial, sans-serif; padding: 20px; }
h1 { margin-bottom: 10px; }
.az-links a { margin-right: 8px; text-decoration: none; }
.customer-list { margin-top: 20px; }
.monthly-tools { margin-bottom: 20px; background: #f7f7f7; padding: 10px; border: 1px solid #ccc; }
</style>
</head>
<body>
<h1>?? Customer Accounts</h1>
<!-- ? Monthly Tools Section -->
<div class="monthly-tools">
<h3>?? Monthly Tools</h3>
<ul>
<li><a href="monthly_summary.php">?? View Monthly Customer Summaries</a></li>
<li><a href="print_all_statements.php?month=<?= date('Y-m') ?>" target="_blank">??? Print All Statements (<?= date('F Y') ?>)</a></li>
<!-- Coming soon:
<li><a href="export_qbo.php?month=<?= date('Y-m') ?>">?? Export to QuickBooks</a></li>
-->
</ul>
</div>
<!-- A-Z Filter -->
<h3>A�Z Filter</h3>
<p class="az-links">
<?php foreach (range('A', 'Z') as $l): ?>
<a href="index.php?letter=<?= $l ?>"><?= $l ?></a>
<?php endforeach; ?>
<a href="index.php">[All]</a>
</p>
<!-- Search -->
<form method="get">
<input type="text" name="search" placeholder="Search by name..." value="<?= htmlspecialchars($search) ?>">
<input type="submit" value="Search">
</form>
<!-- Customer List -->
<div class="customer-list">
<h3>?? Customers<?= $letter ? " � Last Name Starts With '$letter'" : "" ?></h3>
<ul>
<?php while ($row = $customers->fetch_assoc()): ?>
<li>
<a href="view_account.php?customer_id=<?= $row['id'] ?>">
<?= htmlspecialchars($row['last_name'] . ', ' . $row['first_name']) ?>
</a>
</li>
<?php endwhile; ?>
</ul>
</div>
</body>
</html>