} 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; }