public static function getAll()
{
global $lC_Database, $lC_Language, $lC_Currencies, $lC_Vqmod, $_module;
$media = $_GET['media'];
$Qnewsletters = $lC_Database->query('select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from :table_newsletters order by date_added desc');
$Qnewsletters->bindTable(':table_newsletters', TABLE_NEWSLETTERS);
$Qnewsletters->setBatchLimit($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS);
$Qnewsletters->execute();
$result = array('aaData' => array());
while ($Qnewsletters->next()) {
$newsletter_module_class = 'lC_Newsletter_' . $Qnewsletters->value('module');
if (!class_exists($newsletter_module_class)) {
$lC_Language->loadIniFile('modules/newsletters/' . $Qnewsletters->value('module') . '.php');
include $lC_Vqmod->modCheck('includes/modules/newsletters/' . $Qnewsletters->value('module') . '.php');
${$newsletter_module_class} = new $newsletter_module_class();
}
$check = '<td><input class="batch" type="checkbox" name="batch[]" value="' . $Qnewsletters->valueInt('newsletters_id') . '" id="' . $Qnewsletters->valueInt('newsletters_id') . '"></td>';
$newsletter = '<td><a class="with-tooltip" href="javascript:void(0);" onclick="showPreview(\'' . $Qnewsletters->valueInt('newsletters_id') . '\')" title="' . $lC_Language->get('icon_preview') . '"><span class="icon-search"></span> ' . $Qnewsletters->value('title') . '</a></td>';
$size = '<td>' . number_format($Qnewsletters->valueInt('content_length')) . '</td>';
$module = '<td>' . ${$newsletter_module_class}->getTitle() . '</td>';
$sent = '<td>' . ($Qnewsletters->valueInt('status') === 1 ? '<span class="icon-tick icon-green icon-size2"></span>' : '<span class="icon-cross icon-red icon-size2"></span>') . '</td>';
$action = '<td class="align-right vertical-center"><span class="button-group" style="white-space:nowrap;">';
if ($Qnewsletters->valueInt('status') === 1) {
$action .= '<a href="' . ((int) ($_SESSION['admin']['access'][$_module] < 2) ? '#' : 'javascript://" onclick="showLog(\'' . $Qnewsletters->valueInt('newsletters_id') . '\')') . '" class="button icon-read' . ((int) ($_SESSION['admin']['access'][$_module] < 2) ? ' disabled' : NULL) . '">' . ($media === 'mobile-portrait' || $media === 'mobile-landscape' ? NULL : $lC_Language->get('icon_log')) . '</a>';
} else {
$action .= '<a href="' . ((int) ($_SESSION['admin']['access'][$_module] < 3) ? '#' : 'javascript://" onclick="editNewsletter(\'' . $Qnewsletters->valueInt('newsletters_id') . '\')') . '" class="button icon-pencil' . ((int) ($_SESSION['admin']['access'][$_module] < 3) ? ' disabled' : NULL) . '">' . ($media === 'mobile-portrait' || $media === 'mobile-landscape' ? NULL : $lC_Language->get('icon_edit')) . '</a>
<a href="' . ((int) ($_SESSION['admin']['access'][$_module] < 2) ? '#' : 'javascript://" onclick="' . lC_Newsletters_Admin::_u2c('send_' . $Qnewsletters->value('module')) . '(\'' . $Qnewsletters->valueInt('newsletters_id') . '\')') . '" class="button icon-mail with-tooltip' . ((int) ($_SESSION['admin']['access'][$_module] < 2) ? ' disabled' : NULL) . '" title="' . $lC_Language->get('icon_email_send') . '"></a>';
}
$action .= '</span> <span class="button-group">';
$action .= '<a href="' . ((int) ($_SESSION['admin']['access'][$_module] < 4) ? '#' : 'javascript://" onclick="deleteNewsletter(\'' . $Qnewsletters->valueInt('newsletters_id') . '\', \'' . urlencode($Qnewsletters->value('title')) . '\')') . '" class="button icon-trash with-tooltip' . ((int) ($_SESSION['admin']['access'][$_module] < 4) ? ' disabled' : NULL) . '" title="' . $lC_Language->get('icon_delete') . '"></a>';
$action .= '</span></td>';
$result['aaData'][] = array("{$check}", "{$newsletter}", "{$size}", "{$module}", "{$sent}", "{$action}");
$result['entries'][] = $Qnewsletters->toArray();
}
return $result;
}
