'Next 30 days', '60' => 'Next 60 days', '90' => 'Next 90 days', '180' => 'Next 6 months', '365' => 'Next 12 months']; $ahead = isset($windows[$_GET['window'] ?? '']) ? intval($_GET['window']) : 90; $kind = isset(REPORT_RENEWAL_KINDS[$_GET['kind'] ?? '']) ? $_GET['kind'] : ''; $manual_only = !empty($_GET['manual']); $client_id = reportClientId(); $all = reportRenewals($client_id, $ahead, $kind ? [$kind] : []); $items = $manual_only ? array_values(array_filter($all, function ($r) { return !$r['auto']; })) : $all; $lapsed = array_filter($items, function ($r) { return $r['days'] < 0; }); $soon = array_filter($items, function ($r) { return $r['days'] >= 0 && $r['days'] <= 30; }); $auto = array_filter($all, function ($r) { return $r['auto'] && $r['days'] >= 0; }); $ahead_items = array_filter($items, function ($r) { return $r['days'] >= 0; }); // By client $kind_keys = $kind ? [$kind] : array_keys(REPORT_RENEWAL_KINDS); $by_client = []; foreach ($items as $item) { $c = $item['client_id']; $by_client[$c] = $by_client[$c] ?? ['client_id' => $c, 'client' => $item['client'], 'abbr' => $item['abbr'], 'lapsed' => 0, 'soon' => 0, 'total' => 0] + array_fill_keys($kind_keys, 0); $by_client[$c][$item['kind']]++; $by_client[$c]['total']++; $by_client[$c]['lapsed'] += $item['days'] < 0 ? 1 : 0; $by_client[$c]['soon'] += $item['days'] >= 0 && $item['days'] <= 30 ? 1 : 0; } usort($by_client, function ($a, $b) { return $b['lapsed'] <=> $a['lapsed'] ?: $b['soon'] <=> $a['soon'] ?: $b['total'] <=> $a['total']; }); $count_cell = function ($key, $tone = '') { return function ($row) use ($key, $tone) { return $row[$key] ? '' . $row[$key] . '' : '–'; }; }; $client_columns = ['client' => ['label' => 'Client', 'html' => function ($row) { return reportClientCell($row['client_id'], $row['client'], $row['abbr']); }]]; foreach ($kind_keys as $key) { $client_columns[$key] = ['label' => REPORT_RENEWAL_KINDS[$key]['label'], 'type' => 'count', 'html' => $count_cell($key)]; } $client_columns += [ 'lapsed' => ['label' => 'Lapsed', 'type' => 'count', 'html' => $count_cell('lapsed', 'text-danger-emphasis fw-semibold')], 'soon' => ['label' => 'Next 30 days', 'type' => 'count', 'html' => $count_cell('soon', 'text-warning-emphasis fw-semibold')], 'total' => ['label' => 'Total', 'type' => 'count', 'class' => 'fw-semibold'], ]; $item_columns = [ 'days' => ['label' => 'Due', 'type' => 'count', 'csv_label' => 'Days until due', 'html' => function ($row) { return reportDuePill($row['days'], $row['auto']); }], 'name' => ['label' => 'What', 'class' => 'itflow-report-text', 'html' => function ($row) { return '
' . $row['tile'] . '
' . escapeHtml($row['name']) . '' . ($row['detail'] !== '' ? '
' . escapeHtml($row['detail']) . '
' : '') . '
'; }], 'kind' => ['label' => 'Type', 'csv' => function ($row) { return REPORT_RENEWAL_KINDS[$row['kind']]['one']; }, 'html' => function ($row) { return '' . REPORT_RENEWAL_KINDS[$row['kind']]['one'] . ''; }], 'detail' => ['label' => 'Detail', 'screen' => false], 'client' => ['label' => 'Client', 'html' => function ($row) { return reportClientCell($row['client_id'], $row['client'], $row['abbr']); }], 'date' => ['label' => 'Date', 'type' => 'date'], 'auto' => ['label' => 'Renews itself', 'screen' => false, 'csv' => function ($row) { return $row['auto'] ? 'Yes' : 'No'; }], ]; if (reportExporting('clients')) { reportCsv('Renewals by Client', $client_columns, $by_client); } if (reportExporting()) { reportCsv('Renewals', $item_columns, $items); } require_once "includes/inc_report_layout.php"; // By month: lapsed first, then each month from this one to the end of the window $months = ['lapsed' => 'Lapsed']; $cursor = new DateTime('first day of this month'); $last = (new DateTime('today'))->modify("+$ahead days"); while ($cursor <= $last) { $months[$cursor->format('Y-m')] = $cursor->format('M y'); $cursor->modify('+1 month'); } $series = []; foreach ($kind_keys as $key) { $counts = array_fill_keys(array_keys($months), 0); foreach ($items as $item) { if ($item['kind'] === $key) { $counts[$item['days'] < 0 ? 'lapsed' : substr($item['date'], 0, 7)]++; } } $series[] = ['label' => REPORT_RENEWAL_KINDS[$key]['label'], 'data' => array_values($counts), 'tone' => REPORT_RENEWAL_KINDS[$key]['tone'], 'stack' => 'due']; } $clients_affected = count(array_unique(array_column($items, 'client_id'))); $kind_choices = ['' => 'Everything']; foreach (REPORT_RENEWAL_KINDS as $key => $meta) { $kind_choices[$key] = $meta['label']; } ?>
$windows[$ahead], 'controls' => reportSelectControl('window', $ahead, $windows, 'fa-calendar-alt') . reportClientControl($client_id) . reportSelectControl('kind', $kind, $kind_choices, 'fa-filter') . reportSwitchControl('manual', $manual_only, 'Hide ones that renew themselves'), 'export' => ['items' => 'Every renewal', 'clients' => 'By client'], ]); ?> 'Lapsed', 'value' => reportCount(count($lapsed)), 'tone' => $lapsed ? 'danger' : 'success', 'sub' => 'In the last ' . REPORT_RENEWAL_LAPSED_DAYS . ' days'], ['label' => 'Due in 30 days', 'value' => reportCount(count($soon)), 'tone' => $soon ? 'warning' : '', 'sub' => reportCount(count(array_filter($soon, function ($r) { return $r['days'] <= 7; }))) . ' this week'], ['label' => 'Due in the window', 'value' => reportCount(count($ahead_items)), 'sub' => reportCount($clients_affected) . ' ' . ($clients_affected === 1 ? 'client' : 'clients') . ''], ['label' => 'Renew themselves', 'value' => reportCount(count($auto)), 'tone' => $auto ? 'info' : '', 'title' => 'Domains on auto-renew and short-lived certificates', 'sub' => '' . ($manual_only ? 'Hidden below' : 'Auto-renew and short-lived') . ''], ]) ?>
'bar', 'labels' => array_values($months), 'series' => $series, 'stacked' => true, 'format' => 'count', 'legend' => count($series) > 1], '', 'Renewals falling due by month') ?>
1) { ?> 50, 'export_table' => 'clients']) ?> 300, 'export_table' => 'items']) ?>
Domains, certificates and licenses by their expiry date, hardware by its warranty end. Lapsed shows the last days; older ones are on each list's Expired view. Archived items, archived clients and assets that are lost, stolen or retired are left out. Blue ones renew themselves: domains set to auto-renew and short-lived certificates.