| ".$row['id']." | ".$row['location']." | ".$row['phpfile']." | ".$row['notes']." | ![](\"/intranet/images/mglass.png\") | ";
}
}
// Lets do some numbers
$yearssmessage = "";
$yearssmessage .= "| Year | Number Updates |
";
ksort($yeartotal);
foreach ($yeartotal as $year => $yeartot) {
$yearssmessage .= "| $year | $yeartot |
";
}
$yearssmessage .= "
";
$monthsmessage = "";
$monthsmessage .= "| Year | ";
$month = 1;
while ($month < 13) {
$monthsmessage .= "$month | ";
$month++;
}
$monthsmessage .= "Total |
";
foreach ($yeartotal as $year => $yeartot) {
$monthsmessage .= "| $year | ";
$month = 1;
$linetotal = 0;
while ($month < 13) {
$monthyearcode = $year . $month;
$monthyeartotal[$monthyearcode] = isset($monthyeartotal[$monthyearcode]) ? $monthyeartotal[$monthyearcode] : 0;
$monthsmessage .= "".$monthyeartotal[$monthyearcode]." | ";
$linetotal = $linetotal + $monthyeartotal[$monthyearcode];
$month++;
}
$monthsmessage .= "$linetotal |
";
}
$monthsmessage .= "
";
$monthsmessage .= "";
$weekmessage = "";
$weekreport = "";
if ($filteryear != '' && $filtermonth != '' && $filterweek == '') {
// Show weeks for selected month (Friday -> Thursday)
$weekmessage = "Weeks for $filtermonth / $filteryear
| Week | Period | Updates |
";
// Calculate first Friday of the month
$firstDayOfMonth = mktime(0, 0, 0, $filtermonth, 1, $filteryear);
$firstDayWeekday = date('w', $firstDayOfMonth); // 0=Sunday, 5=Friday
// Find first Friday (if 1st is not Friday, go back to previous Friday)
$daysToFriday = ($firstDayWeekday >= 5) ? ($firstDayWeekday - 5) : ($firstDayWeekday + 2);
$firstFriday = strtotime("-".$daysToFriday." days", $firstDayOfMonth);
$totallines = 0;
$weeknum = 1;
// Generate up to 6 weeks to cover the month
for ($w = 0; $w < 6; $w++) {
$weekStart = strtotime("+".$w." weeks", $firstFriday);
$weekEnd = strtotime("+6 days", $weekStart);
// Check if week overlaps with target month
$weekStartMonth = date('n', $weekStart);
$weekEndMonth = date('n', $weekEnd);
$weekStartYear = date('Y', $weekStart);
$weekEndYear = date('Y', $weekEnd);
// Skip if week is entirely before or after target month
if ($weekEndMonth != $filtermonth && $weekStartMonth != $filtermonth) {
if ($weekStartMonth > $filtermonth || $weekStartYear > $filteryear) {
break;
}
continue;
}
// Count updates in this week
$weekcount = 0;
$weekdetails = '';
$currentDay = $weekStart;
while ($currentDay <= $weekEnd) {
$daycode = date("dnY", $currentDay);
if (isset($daymonthyeartotal[$daycode])) {
$weekcount = $weekcount + $daymonthyeartotal[$daycode];
}
if (isset($daymonthyearlist[$daycode])) {
$weekdetails .= $daymonthyearlist[$daycode];
}
$currentDay = strtotime("+1 day", $currentDay);
}
$periodLabel = date("j M", $weekStart)." - ".date("j M", $weekEnd);
$weekStartStr = date("Y-m-d", $weekStart);
$weekEndStr = date("Y-m-d", $weekEnd);
$weekmessage .= "| Week ".$weeknum." | ".$periodLabel." | ".$weekcount." |
";
// Store week details for report view
$weekdetailscode = $filteryear.$filtermonth.$weeknum;
$weekdetailstore[$weekdetailscode] = $weekdetails;
$totallines = $totallines + $weekcount;
$weeknum++;
}
$weekmessage .= "| Total | $totallines |
";
$weekmessage .= "
";
}
if ($filterweek != '' && $filteryear != '' && $filtermonth != '') {
// Show individual updates for selected week
// Rebuild week details since this is a fresh request
$firstDayOfMonth = mktime(0, 0, 0, $filtermonth, 1, $filteryear);
$firstDayWeekday = date('w', $firstDayOfMonth);
$daysToFriday = ($firstDayWeekday >= 5) ? ($firstDayWeekday - 5) : ($firstDayWeekday + 2);
$firstFriday = strtotime("-".$daysToFriday." days", $firstDayOfMonth);
$targetWeekStart = strtotime("+".(intval($filterweek)-1)." weeks", $firstFriday);
$targetWeekEnd = strtotime("+6 days", $targetWeekStart);
$weekreport = "
AI Prompt\nKeep the raw update list exactly as generated from the system.\nAdd a short technical development summary underneath each entry.\nFocus on:\n- Why the change was made\n- What functionality changed\n- What future problem it helps solve\n- Any side effects or intended future expansion
| Update ID | Date | Location | File | Notes | |
";
$currentDay = $targetWeekStart;
while ($currentDay <= $targetWeekEnd) {
$daycode = date("dnY", $currentDay);
$dateStr = date("d M Y", $currentDay);
if (isset($daymonthyearlist[$daycode])) {
$dayRows = $daymonthyearlist[$daycode];
// The pre-built rows are: | ID | location | ...
// We need:
| ID | DATE | location | ...
// So replace the FIRST after |
| with | DATE |
$dayRows = preg_replace('/ |
| ([^<]+)<\/td> | /', ' |
| $1 | ' . $dateStr . ' | ', $dayRows);
$weekreport .= $dayRows;
}
$currentDay = strtotime("+1 day", $currentDay);
}
$weekreport .= " |
";
}
print "$weekmessage";
print "$weekreport";
?>