芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/public_html/teafund.pulsehost.co.uk/public/index.php

<?php
require_once __DIR__ . '/../includes/db.php';
require_once __DIR__ . '/../includes/header.php';

$pdo = get_pdo();

$funds = $pdo->query("SELECT id, name FROM funds ORDER BY name")->fetchAll(PDO::FETCH_ASSOC);

$fund_id = 0;
if (isset($_GET['fund_id'])) {
  $fund_id = (int)$_GET['fund_id'];
  @setcookie('public_last_fund_id', (string)$fund_id, [
    'expires' => time()+31536000,'path'=>'/',
    'secure' => (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off'),
    'httponly' => false,'samesite'=>'Lax',
  ]);
} elseif (!empty($_COOKIE['public_last_fund_id'])) {
  $fund_id = (int)$_COOKIE['public_last_fund_id'];
} else {
  $fund_id = $funds ? (int)$funds[0]['id'] : 0;
}

$fund_ids = array_column($funds, 'id');
if (!in_array($fund_id, $fund_ids, true)) {
  $fund_id = $funds ? (int)$funds[0]['id'] : 0;
  @setcookie('public_last_fund_id', (string)$fund_id, [
    'expires' => time()+31536000,'path'=>'/',
    'secure' => (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off'),
    'httponly' => false,'samesite'=>'Lax',
  ]);
}

$year = isset($_GET['year']) ? (int)$_GET['year'] : (int)date('Y');
$months = [1=>'Jan',2=>'Feb',3=>'Mar',4=>'Apr',5=>'May',6=>'Jun',7=>'Jul',8=>'Aug',9=>'Sep',10=>'Oct',11=>'Nov',12=>'Dec'];
$current_month = ((int)date('Y') === $year) ? (int)date('n') : 0;

$members_stmt = $pdo->prepare("SELECT id, name FROM members WHERE fund_id = :fund AND active = 1 ORDER BY name");
$members_stmt->execute([':fund' => $fund_id]);
$members = $members_stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<div class="container my-4">
  <div class="d-flex align-items-center justify-content-between mb-3">
    <h1 class="h4 m-0"><i class="bi bi-cup-hot me-2"></i> Tea Fund</h1>
    <form class="d-flex gap-2" method="get">
      <select class="form-select form-select-sm" name="fund_id" aria-label="Select fund">
        <?php foreach ($funds as $f): ?><option value="<?php echo $f['id']; ?>" <?php echo $f['id']==$fund_id?'selected':''; ?>><?php echo htmlspecialchars($f['name']); ?></option><?php endforeach; ?>
      </select>
      <input class="form-control form-control-sm" type="number" name="year" value="<?php echo $year; ?>" min="2000" max="2100" aria-label="Year">
      <button class="btn btn-sm btn-primary" type="submit">View</button>
    </form>
  </div>
<?php
$PAYMENTS_HAS_FUND = false;
try {
  $q = $pdo->query("SELECT 1 FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name='payments' AND column_name='fund_id'");
  $PAYMENTS_HAS_FUND = (bool)$q->fetchColumn();
} catch (Throwable $e) { $PAYMENTS_HAS_FUND = false; }

$pay_map = [];
if ($members) {
  if ($PAYMENTS_HAS_FUND) {
    $ps = $pdo->prepare("SELECT member_id, month, status FROM payments WHERE year = ? AND fund_id = ?");
    $ps->execute([$year, $fund_id]);
  } else {
    $ids = array_column($members, 'id');
    if ($ids) {
      $placeholders = implode(',', array_fill(0, count($ids), '?'));
      $sql = "SELECT member_id, month, status FROM payments WHERE year = ? AND member_id IN ($placeholders)";
      $ps = $pdo->prepare($sql);
      $ps->execute(array_merge([$year], $ids));
    } else { $ps = false; }
  }
  if ($ps) foreach ($ps->fetchAll(PDO::FETCH_ASSOC) as $p) {
    $pay_map[(int)$p['member_id']][(int)$p['month']] = $p['status'];
  }
}
?>

<?php if ($members): ?>
  <div class="legend mb-2">
    <span class="badge bg-success">✓ Paid</span>
    <span class="badge bg-danger">• Unpaid</span>
    <span class="badge bg-secondary">⏸ Off</span>
    <?php if ($current_month): ?><span class="badge text-bg-primary ms-2">Current: <?php echo $months[$current_month]; ?></span><?php endif; ?>
  </div>

<div class="table-responsive shadow-sm">
    <table class="table table-bordered table-sm align-middle table-hover table-striped">
      <thead>
        <tr class="sticky-top">
          <th>Member</th>
          <?php foreach ($months as $i=>$m): ?>
            <th class="text-center <?php echo ($current_month && $i===$current_month) ? 'bg-primary-subtle' : ''; ?>"><?php echo $m; ?></th>
          <?php endforeach; ?>
        </tr>
      </thead>
      <tbody>
        <?php foreach ($members as $mem): ?>
          <tr>
            <td><?php echo htmlspecialchars($mem['name']); ?></td>
            <?php for ($i=1;$i<=12;$i++):
              $st = $pay_map[$mem['id']][$i] ?? 'unpaid';
              $cls = $st==='paid' ? 'bg-success text-white' : ($st==='off' ? 'bg-secondary text-white' : 'bg-danger text-white');
              $label = $st==='paid' ? 'Paid' : ($st==='off' ? 'Off' : 'Unpaid');
            ?>
              <td class="text-center <?php echo $cls; ?>" title="<?php echo $label; ?>" aria-label="<?php echo $label; ?>">
                <?php echo $st==='paid'?'✓':($st==='off'?'⏸':'•'); ?>
              </td>
            <?php endfor; ?>
          </tr>
        <?php endforeach; ?>
      </tbody>
    </table>
  </div>
  <?php else: ?>
    <div class="alert alert-info">No active members in this fund.</div>
  <?php endif; ?>

<div class="accordion accordion-flush mt-4" id="publicAcc">
    <div class="accordion-item">
      <h2 class="accordion-header" id="lowStockHead">
        <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#lowStock" aria-expanded="false" aria-controls="lowStock">
          Send low stock alert
        </button>
      </h2>
      <div id="lowStock" class="accordion-collapse collapse" aria-labelledby="lowStockHead" data-bs-parent="#publicAcc">
        <div class="accordion-body">
          <form class="row g-2" method="post" action="/api/stock_alert_submit.php">
            <input type="hidden" name="fund_id" value="<?php echo (int)$fund_id; ?>">
            <div class="col-12 col-sm-4">
              <select class="form-select" name="item" required>
                <option value="milk">Milk</option>
                <option value="tea">Tea</option>
                <option value="coffee">Coffee</option>
                <option value="sugar">Sugar</option>
                <option value="cordial">Cordial</option>
                <option value="other">Other</option>
              </select>
            </div>
            <div class="col-12 col-sm-6"><input class="form-control" name="note" placeholder="Optional note (e.g., last 2 bottles)"></div>
            <div class="col-12 col-sm-2"><button class="btn btn-outline-primary w-100">Send</button></div>
          </form>
        </div>
      </div>
    </div>
  </div>

</div>

<?php require_once __DIR__ . '/../includes/footer.php'; ?>