/** * @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;">