function mailer_link_infos()
{
    $html = "<table>\n\t<tr>\n\t\t<th colspan=2>{date}</th>\n\t\t<th>{template}</th>\n\t\t<th>{database}</th>\n\t\t<th>{duration}</th>\n\t\t<th>{emails_number}</th>\n\t\t<th>{global_size}</th>\n\t\t\n\t</tr>";
    $q = new mysql();
    $sql = "SELECT * FROM emailing_campain_events WHERE campain_linker_id='{$_GET["ID"]}' ORDER BY ID DESC";
    $results = $q->QUERY_SQL($sql, "artica_backup");
    $ct = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $ct = $ct + 1;
        $img = "status_ok.png";
        $size = FormatBytes($ligne["massmailing_size"] / 1024);
        if ($ligne["task_success"] == 0) {
            $img = "status_critical.png";
        }
        $template = emailing_get_template_name($ligne["template_id"]);
        $database = emailing_get_database_name($ligne["database_id"]);
        $html = $html . "<tr " . CellRollOver("MailerLinkEventDisplay({$ligne["ID"]})", "{infos}") . ">\n\t\t<td width=1%><img src='img/{$img}'></td>\n\t\t<td style='font-size:11px' nowrap>{$ligne["zDate"]}</td>\n\t\t<td style='font-size:11px'>{$template}</td>\n\t\t<td style='font-size:11px'>{$database}</td>\n\t\t<td style='font-size:11px'>{$ligne["time_duration"]}</td>\n\t\t<td style='font-size:11px' align='center'>{$ligne["messages_number"]}</td>\n\t\t<td style='font-size:11px' align='center'>{$size}</td>\n\t\t</tr>\n\t\t";
    }
    if ($ct == 0) {
        return;
    }
    $html = $html . "</table>\n\t<script>refreshMailerLinkToolbar();</script>\n\t\n\t";
    $tpl = new templates();
    echo $tpl->_ENGINE_parse_body($html);
}
Esempio n. 2
0
function construct_queue($ID, $ou)
{
    $q = new mysql();
    $GLOBALS["campain_linker_id"] = $ID;
    $q->QUERY_SQL("UPDATE `emailing_campain_linker` SET `queue_builder_pourc`=0 `locked`=1 WHERE `ID`={$GLOBALS["campain_linker_id"]}", "artica_backup");
    $sql = "SELECT * FROM emailing_campain_linker WHERE ID='{$ID}'";
    $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup"));
    $unix = new unix();
    $email_relay_submit = $unix->find_program("emailrelay-submit");
    $GLOBALS["SartON"] = time();
    if ($email_relay_submit == null) {
        event(__FUNCTION__, __LINE__, "Unable to stat {$email_relay_submit}");
        mass_mailing_finish(0);
        return;
    }
    $parameters = unserialize(base64_decode($ligne["parameters"]));
    $template_id = $ligne["template_id"];
    $database_id = $ligne["database_id"];
    $GLOBALS["template_id"] = $template_id;
    $GLOBALS["database_id"] = $database_id;
    $simulation = $parameters["simulation"];
    $GLOBALS["start_date_task"] = date('Y-m-d H:i:s');
    $simulation_recipipent = $parameters["recipient"];
    $database_name = emailing_get_database_name($database_id);
    event(__FUNCTION__, __LINE__, "database name={$database_name}");
    $database_name = format_mysql_table($database_name);
    $template_name = emailing_get_template_name($template_id);
    $template_parameters = emailing_get_template_parameters($template_id);
    event(__FUNCTION__, __LINE__, "Opening {$ID} {$ligne["name"]} campaign template {$template_name} N.{$template_id}, database {$database_name} N.{$database_id}");
    event(__FUNCTION__, __LINE__, "simulation={$simulation} =>{$simulation_recipipent}");
    @mkdir("/tmp/emailing/{$ID}", 0666, true);
    if (is_array($template_parameters["ATTACHS"])) {
        while (list($filename, $attch_ID) = each($template_parameters["ATTACHS"])) {
            event(__FUNCTION__, __LINE__, "saving /tmp/emailing/{$ID}/{$filename}");
            emailing_save_attachment($attch_ID, "/tmp/emailing/{$ID}/{$filename}");
        }
        reset($template_parameters["ATTACHS"]);
    }
    $advanced_options = unserialize(base64_decode($template_parameters["advopts"]));
    if ($advanced_options["From_name"] == null) {
        $advanced_options["From_name"] = $advanced_options["From"];
    }
    if ($advanced_options["From"] == null) {
        event(__FUNCTION__, __LINE__, "From field is null, aborting");
        mass_mailing_finish(0);
        return false;
    }
    $sql = "SELECT ID,smtpserver,parameters FROM emailing_mailers WHERE ou='{$ou}'";
    $results = $q->QUERY_SQL($sql, "artica_backup");
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $datas = unserialize(base64_decode($ligne["parameters"]));
        $smtp_servs[] = $ligne["ID"];
    }
    if (!is_array($smtp_servs)) {
        event(__FUNCTION__, __LINE__, "Unable to define SMTP servers");
        mass_mailing_finish(0);
        return false;
    }
    $sql = "SELECT * FROM emailing_{$database_name}";
    $results = $q->QUERY_SQL($sql, "artica_backup");
    $t = 0;
    $max = mysql_num_rows($results);
    event(__FUNCTION__, __LINE__, "{$max} contacts in emailing_{$database_name} table");
    $smtp_servs_count = 0;
    $smtp_servs_max = count($smtp_servs) - 1;
    $messages_number = 0;
    event(__FUNCTION__, __LINE__, $smtp_servs_max + 1 . " SMTP servers");
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $final_count = $final_count + 1;
        $contact_id = $ligne["ID"];
        $gender = $ligne["gender"];
        $firstname = $ligne["firstname"];
        $lastname = $ligne["lastname"];
        $email = $ligne["email"];
        if (isBlockedMail($email)) {
            continue;
        }
        $phone = $ligne["phone"];
        $city = $ligne["city"];
        $cp = $ligne["cp"];
        $postaladdress = $ligne["postaladdress"];
        if ($simulation == 1) {
            $email = $simulation_recipipent;
        }
        $unikey = md5("{$template_id}{$database_id}{$contact_id}");
        $htmldatas = $template_parameters["template_datas"];
        $htmldatas = str_replace("%gender%", $gender, $htmldatas);
        $htmldatas = str_replace("%lastname%", $lastname, $htmldatas);
        $htmldatas = str_replace("%firstname%", $firstname, $htmldatas);
        $htmldatas = str_replace("%email%", $email, $htmldatas);
        $htmldatas = str_replace("%phone%", $phone, $htmldatas);
        $htmldatas = str_replace("%city%", $city, $htmldatas);
        $htmldatas = str_replace("%cp%", $cp, $htmldatas);
        $htmldatas = str_replace("%postaladdress%", $postaladdress, $htmldatas);
        $mailer = new PHPMailer();
        $mailer->AddAddress($email, "{$firstname} {$lastname}");
        $mailer->From = $advanced_options["From"];
        $mailer->FromName = $advanced_options["From_name"];
        $mailer->Subject = $template_parameters["subject"];
        $mailer->Body = $htmldatas;
        $mailer->IsHTML(true);
        $mailer->Mailer = 'smtp';
        if ($advanced_options["Reply-to"] != null) {
            $mailer->AddReplyTo($advanced_options["Reply-to"]);
        }
        if ($advanced_options["Disposition-Notification-To"] != null) {
            $mailer->AddCustomHeader("Disposition-Notification-To: {$advanced_options["Disposition-Notification-To"]}");
        }
        if ($advanced_options["Return-Path"] != null) {
            $mailer->AddCustomHeader("Return-Path: {$advanced_options["Return-Path"]}");
        }
        if ($advanced_options["X-Mailer"] != null) {
            $mailer->AddCustomHeader("X-Mailer: {$advanced_options["X-Mailer"]}");
        }
        if (is_array($template_parameters["ATTACHS"])) {
            while (list($filename, $attch_ID) = each($template_parameters["ATTACHS"])) {
                $mailer->AddAttachment("/tmp/emailing/{$ID}/{$filename}", $filename);
            }
            reset($template_parameters["ATTACHS"]);
        }
        $queue_ID = "/var/spool/artica-emailing/queues/{$smtp_servs[$smtp_servs_count]}";
        $smtp_servs_count = $smtp_servs_count + 1;
        if ($smtp_servs_count > $smtp_servs_max) {
            $smtp_servs_count = 0;
        }
        $maildata = $mailer->Send(true);
        // send mail into queue
        $mail_from = "{$advanced_options["From"]}";
        $recipient = $email;
        $filetemp = $unix->FILE_TEMP() . "{$contact_id}.msg";
        @file_put_contents($filetemp, $maildata);
        $GLOBALS["massmailing_size"] = $GLOBALS["massmailing_size"] + filesize($filetemp);
        $cmd = "{$email_relay_submit} --spool-dir={$queue_ID} --from={$mail_from} {$recipient} < {$filetemp}";
        if ($GLOBALS["VERBOSE"]) {
            event(__FUNCTION__, __LINE__, "{$cmd}");
        }
        shell_exec("{$email_relay_submit} --spool-dir={$queue_ID} --from={$mail_from} {$recipient} < {$filetemp}");
        if ($GLOBALS["VERBOSE"]) {
            event(__FUNCTION__, __LINE__, @implode("\n", $results));
        }
        @unlink($filetemp);
        $maildata = null;
        $mailer = nil;
        $GLOBALS["messages_number"] = $GLOBALS["messages_number"] + 1;
        $t = $t + 1;
        if ($t > 200) {
            $pourcentage = round($final_count / $max * 100, 0);
            echo "{$pourcentage}% {$final_count}/{$max}\n";
            $q = new mysql();
            event(__FUNCTION__, __LINE__, "{$pourcentage}%");
            $q->QUERY_SQL("UPDATE emailing_campain_linker SET queue_builder_pourc={$pourcentage} WHERE ID={$ID}", "artica_backup");
            $t = 0;
        }
    }
    mass_mailing_finish(1);
}