}
foreach ($issues as $issue) {
$data = array();
$newsletter_name = get_db_value('name', 'tnewsletter', 'id', $issue["id_newsletter"]);
$data[0] = "<b>" . $issue["id"] . "</b>";
$data[1] = "<a href='index.php?sec=customers&sec2=operation/newsletter/issue_creation&id=" . $issue["id"] . "'>" . $issue["email_subject"] . "</a>";
$data[2] = $newsletter_name;
$data[3] = $issue["datetime"];
if ($issue["status"] == 1) {
$data[4] = __("Pending");
} elseif ($issue["status"] == 2) {
$data[4] = __("Sent");
} else {
$data[4] = __("Ready");
}
$data[5] = crm_get_issue_reads($issue["id"]);
$data[6] = get_db_sql("SELECT COUNT(id) FROM tnewsletter_address WHERE id_newsletter = " . $issue["id_newsletter"] . " AND validated = 1 AND status = 0");
$data[7] = "<a target='_top' href='include/newsletter.php?operation=read&id=" . $issue["id"] . "'><img src='images/eye.png'></a> ";
if (give_acl($config["id_user"], $id_group, "CN")) {
$data[7] .= '<a href="index.php?sec=customers&sec2=operation/newsletter/issue_definition&
delete=1&id=' . $issue['id'] . '"
onClick="if (!confirm(\'' . __('Are you sure?') . '\'))
return false;">
<img src="images/cross.png"></a>';
}
array_push($table->data, $data);
}
print_table($table);
}
if ($manager) {
echo '<form method="post" action="index.php?sec=customers&sec2=operation/newsletter/issue_creation&create=1">';
function crm_get_campaign_email_stats($id_campaign)
{
$email_issues = get_db_all_rows_filter('tnewsletter_content', array('id_campaign' => $id_campaign));
//Get email sent
//Get issue reads
$total_reads = 0;
$total_sent = 0;
foreach ($email_issues as $ei) {
$total_reads = $total_reads + crm_get_issue_reads($ei["id"]);
$total_sent = $total_sent + get_db_sql("SELECT COUNT(id) FROM tnewsletter_queue_data WHERE status = 1 AND id_newsletter_content = " . $ei["id"]);
}
$ratio = $total_reads / $total_sent * 100;
$stats = array();
$stats["reads"] = $total_reads;
$stats["sent"] = $total_sent;
$stats["ratio"] = $ratio;
return $stats;
}
