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); ?>