/**
* @param int $p_publicationId
*
* @param int $p_languageId
*
*
* @return mixed
* array of issue publication dates
* null if query does not match any issue
*/
public static function GetPublicationDates($p_publicationId,
$p_languageId,
$p_skipCache = false)
{
global $g_ado_db;
$queryStr = 'SELECT Number FROM Articles '
. 'WHERE IdPublication = ' . $p_publicationId . ' AND '
. 'IdLanguage = ' . $p_languageId . " AND Published = 'Y' "
. 'GROUP BY PublishDate ORDER BY PublishDate';
$rows = $g_ado_db->GetAll($queryStr);
$dates = array();
if (is_array($rows)) {
foreach ($rows as $row) {
$tmpObj = new Article($p_languageId, $row['Number']);
if ($tmpObj->exists()) {
$dates[] = $tmpObj->getPublishDate();
}
}
}
if (empty($dates)) {
return null;
}
return array_unique($dates);
} // fn GetPublicationDates
<TD align="left" valign="top" nowrap>
<?php print $curPreview->getCreationDate(); ?>
</TD>
<TD ALIGN="RIGHT" valign="top" style="padding-left: 1em;"></TD>
<TD align="left" valign="top" style="padding-top: 0.25em;">
<?php putGS('Show article on section page'); ?>
</TD>
</TR>
<TR>
<td align="right" valign="top" nowrap><b><?php putGS("Number"); ?>:</b></td>
<td align="left" valign="top" style="padding-top: 2px; padding-left: 4px;"><?php p($curPreview->getArticleNumber()); ?> <?php if (isset($publicationObj) && $publicationObj->getUrlTypeId() == 2) { ?>
(<a href="/<?php echo $languageObj->getCode()."/".$issueObj->getUrlName()."/".$sectionObj->getUrlName()."/".$curPreview->getUrlName(); ?>"><?php putGS("Link to public page"); ?></a>)<?php } ?></td>
<TD ALIGN="RIGHT" valign="top" style="padding-left: 1em;"><b><?php putGS("Publish date"); ?>:</b></TD>
<TD align="left" valign="top">
<?php print htmlspecialchars($curPreview->getPublishDate()); ?>
</TD>
<TD ALIGN="RIGHT" valign="top" style="padding-left: 1em;"></TD>
<TD align="left" valign="top" style="padding-top: 0.25em;">
<?php putGS('Allow users without subscriptions to view the article'); ?>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD style="border-top: 1px solid #8baed1; padding-top: 3px;">
<TABLE>
<TR>
<td align="left" style="padding-right: 5px;">
