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;
}
$NumberCommits = $CommitsMyFlagged->GetCountPortCommits();
if ($Debug) {
echo 'number of commits = ' . $NumberCommits . "<br>\n";
}
$NumFound = $NumberCommits;
$params = array('mode' => 'Sliding', 'perPage' => $PageSize, 'delta' => 5, 'totalItems' => $NumFound, 'urlVar' => 'page', 'currentPage' => $PageNumber, 'spacesBeforeSeparator' => 1, 'spacesAfterSeparator' => 1);
$Pager =& Pager::factory($params);
$offset = $Pager->getOffsetByPageId();
$NumOnThisPage = $offset[1] - $offset[0] + 1;
if ($PageNumber > 1) {
$Commits->SetOffset($offset[0] - 1);
}
$CommitsMyFlagged->SetLimit($PageSize);
$DisplayCommit = new DisplayCommit($db, $CommitsMyFlagged->LocalResult);
$DisplayCommit->Debug = $Debug;
$DisplayCommit->SetUserID($User->id);
$links = $Pager->GetLinks();
$HTML .= $NumPortsFound . ' ' . $links['all'];
$HTML .= $DisplayCommit->CreateHTML();
if ($db) {
?>
<TR><TD VALIGN="top" WIDTH="100%">
<?php
echo freshports_MainContentTable();
?>
<TR>
<?php
echo freshports_PageBannerText("My flagged commits", 3);
?>
