public static function GetIssueEvents($p_publicationId, $p_issueNumber, $p_languageId = null, $p_includeCompleted = true)
{
$queryStr = "SELECT * FROM IssuePublish " . " WHERE fk_publication_id = {$p_publicationId} " . " AND fk_issue_id = {$p_issueNumber} " . " AND fk_language_id = {$p_languageId} ";
if (!$p_includeCompleted) {
$queryStr .= " AND is_completed = 'N'";
}
$queryStr .= " ORDER BY time_action ASC";
$result = DbObjectArray::Create('IssuePublish', $queryStr);
return $result;
}
<?php if ($g_user->hasPermission('DeleteIssue')) { ?> <TD ALIGN="LEFT" VALIGN="TOP"><B><?php echo $translator->trans("Delete"); ?> </B></TD> <?php } ?> </TR> <?php $currentIssue = -1; foreach ($allIssues as $issue) { $pendingEvents = IssuePublish::GetIssueEvents($issue->getPublicationId(), $issue->getIssueNumber(), $issue->getLanguageId(), false); ?> <TR <?php if ($color) { $color = 0; ?> class="list_row_even"<?php } else { $color = 1; ?> class="list_row_odd"<?php } ?> > <TD ALIGN="RIGHT">