IssuePublish::GetIssueEvents PHP Method

GetIssueEvents() public static method

Returns an array of IssuePublish objects.
public static GetIssueEvents ( integer $p_publicationId, integer $p_issueNumber, $p_languageId = null, boolean $p_includeCompleted = true ) : array
$p_publicationId integer
$p_issueNumber integer
$p_includeCompleted boolean
return array
    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;
    }

Usage Example

Beispiel #1
0
        <?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">
All Usage Examples Of IssuePublish::GetIssueEvents