public static function GetFutureActions($p_limit)
{
global $g_ado_db;
$datetime = strftime("%Y-%m-%d %H:%M:00");
$dummyIssue = new Issue();
$columnNames = $dummyIssue->getColumnNames(true);
$queryStr = "SELECT id, time_action, publish_action, do_publish_articles, " . implode(",", $columnNames) . " FROM Issues, IssuePublish " . " WHERE time_action >= '" . $datetime . "'" . " AND is_completed != 'Y'" . " AND Issues.IdPublication=IssuePublish.fk_publication_id" . " AND Issues.Number=IssuePublish.fk_issue_id" . " AND Issues.IdLanguage=IssuePublish.fk_language_id " . " ORDER BY time_action DESC" . " LIMIT {$p_limit}";
//echo $queryStr."<br>";
$rows = $g_ado_db->GetAll($queryStr);
$addKeys = array();
if ($rows && count($rows) > 0) {
foreach ($rows as $row) {
$row["ObjectType"] = "issue";
$addKeys[$row['time_action']] = $row;
}
}
return $addKeys;
}