function CreateHTML()
{
global $freshports_CommitMsgMaxNumOfLinesToShow;
if (isset($this->Filter)) {
$sql = "select * from LatestCommitsFiltered({$this->MaxNumberOfPorts}, {$this->UserID}, '" . pg_escape_string($this->Filter) . "')";
} else {
# $sql = "select * from LatestCommits($this->MaxNumberOfPorts, $this->UserID)";
$sql = "\n SELECT LC.*, STF.message AS stf_message\n FROM LatestCommits({$this->MaxNumberOfPorts}, 0, '" . pg_escape_string($this->BranchName) . "') LC LEFT OUTER JOIN sanity_test_failures STF\n ON LC.commit_log_id = STF.commit_log_id\nORDER BY LC.commit_date_raw DESC, LC.category, LC.port, element_pathname";
}
if ($this->Debug) {
echo "\n<p>sql={$sql}</p>\n";
}
$result = pg_exec($this->dbh, $sql);
if (!$result) {
die("read from database failed");
exit;
}
$DisplayCommit = new DisplayCommit($this->dbh, $result);
$DisplayCommit->Debug = $this->Debug;
$DisplayCommit->SetDaysMarkedAsNew($this->DaysMarkedAsNew);
$DisplayCommit->SetUserID($this->UserID);
$DisplayCommit->SetWatchListAsk($this->WatchListAsk);
$RetVal = $DisplayCommit->CreateHTML();
$this->HTML = $DisplayCommit->HTML;
return $RetVal;
}
function CreateHTML()
{
global $freshports_CommitMsgMaxNumOfLinesToShow;
if (isset($this->Filter)) {
$sql = "select * from SanityTestFailures({$this->UserID}, '" . pg_escape_string($this->Filter) . "')";
} else {
$sql = "set client_encoding = 'ISO-8859-15';\nSELECT S.*, STF.message as stf_message\n FROM SanityTestFailures({$this->UserID}) S LEFT OUTER JOIN sanity_test_failures STF\n ON S.commit_log_id = STF.commit_log_id";
}
if ($this->MessageID != '') {
$sql .= " WHERE message_id = '" . pg_escape_string($this->MessageID) . "'";
}
$sql .= " ORDER BY S.commit_date_raw DESC, S.category, S.port";
if ($this->Debug) {
echo "\n<p>sql={$sql}</p>\n";
}
$result = pg_exec($this->dbh, $sql);
if (!$result) {
die("read from database failed");
exit;
}
$DisplayCommit = new DisplayCommit($this->dbh, $result);
$DisplayCommit->Debug = $this->Debug;
$DisplayCommit->SetDaysMarkedAsNew($this->DaysMarkedAsNew);
$DisplayCommit->SetUserID($this->UserID);
$DisplayCommit->SetWatchListAsk($this->WatchListAsk);
$DisplayCommit->SanityTestFailure = true;
$RetVal = $DisplayCommit->CreateHTML();
$this->HTML = $DisplayCommit->HTML;
return $RetVal;
}
