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; }