END; $header .= banner (); $header .= <<Test Statistics from $start to $end END; return $header; } // createHeader function CreatePage ($start, $end, $forEmail = false, $message = "") { global $sortBy, $direction, $script; $data = getData ($start, $end); $row_nbr = 0; if (!$forEmail) { // Flip direction $direction = ($direction == "ascending") ? "descending" : "ascending"; $urlParms = "$script?start=$start&end=$end&action=$action&direction=$direction&sortBy"; if ($sortBy == "Passed") { $passedDirection = ($direction == "ascending") ? "" : ""; } elseif ($sortBy == "Failed") { $failedDirection = ($direction == "ascending") ? "" : ""; } elseif ($sortBy == "Total") { $totalDirection = ($direction == "ascending") ? "" : ""; } else { $dateDirection = ($direction == "ascending") ? "" : ""; } // if if (isset ($message)) { $page .= "
$message
"; } // if } // if $page .= << END; if (!$forEmail) { $page .= <<  
END; $page .= emailUsersDropdown (); $page .= << END; } // if $page .= << Date $dateDirection Total Passed $passedDirection Total Failed $failedDirection Total Run $totalDirection END; foreach ($data as $result) { $reportDate = YMD2MDY ($result["Date"]); $row_color = ($row_nbr++ % 2 == 0) ? " class=other" : " class=white"; $page .= << $reportDate $result[Success] $result[Failure] $result[Total] END; } // foreach $page .= << END; return $page; } // CreatePage function displayReport ($start, $end, $message = "") { print createHeader ($start, $end); print createPage ($start, $end, false, $message); copyright (); } // displayReport function displayChart ($start, $end) { global $testTypes, $type; print createHeader ($start, $end); $days = getdays(); print <<
Type: END; foreach ($days as $day) { print "$day\n"; } // foreach print << To:  

END; copyright (); } // displayChart function mailTestStatsReport ($start, $end, $pnbr, $username) { $subject = "Test Statistics from $start to $end"; $filename = "TestStats.$start-$end.csv"; $body = createPage ($start, $end, true); $attachment = exportCSV (getData ($start, $end), $subject); return mailReport ($pnbr, $username, $subject, $body, $filename, $attachment); } // mailReport if (MDY2YMD ($start) > MDY2YMD ($end)) { Error ("Start Date must come before End Date"); return; } // if openDB (); switch ($action) { case "Graph": displayChart ($start, $end); break; case "Export": exportStats ($start, $end); break; case "Mail": list ($pnbr, $username) = explode (":", $user); displayReport ($start, $end, mailTestStatsReport ($start, $end, $pnbr, $username)); break; default: displayReport ($start, $end); break; } // switch ?>