/** * reminderAction * This action send to every customers an email * reminder about their expiring services and domains */ public static function remindersEmail() { $i = 0; $customers = array(); $translator = Shineisp_Registry::getInstance()->Zend_Translate; /* We have to start to get all the domains that them expiring date is today then we have to create a custom array sorted by customerID in order to group services and domains of a particular customer. */ // Get all the active domains that expire in 1 day $domains = Domains::getExpiringDomainsByRange(0, 30, Statuses::id('active', 'domains')); if ($domains) { // Create the customer group list for the email summary foreach ($domains as $domain) { if ($domain['reseller']) { $invoice_dest = Customers::getAllInfo($domain['reseller']); $customers[$domain['customer_id']]['id'] = $invoice_dest['customer_id']; $customers[$domain['customer_id']]['fullname'] = $invoice_dest['firstname'] . " " . $invoice_dest['lastname'] . " " . $invoice_dest['company']; $customers[$domain['customer_id']]['email'] = $invoice_dest['email']; $customers[$domain['customer_id']]['language_id'] = $invoice_dest['language_id']; } else { $customers[$domain['customer_id']]['id'] = $domain['customer_id']; $customers[$domain['customer_id']]['fullname'] = $domain['fullname']; $customers[$domain['customer_id']]['email'] = $domain['email']; $customers[$domain['customer_id']]['language_id'] = $domain['language_id']; } $customers[$domain['customer_id']]['products'][$i]['name'] = $domain['domain']; $customers[$domain['customer_id']]['products'][$i]['type'] = "domain"; $customers[$domain['customer_id']]['products'][$i]['renew'] = $domain['renew']; $customers[$domain['customer_id']]['products'][$i]['expiring_date'] = $domain['expiringdate']; $customers[$domain['customer_id']]['products'][$i]['days'] = $domain['days']; $customers[$domain['customer_id']]['products'][$i]['oldorderitemid'] = $domain['detail_id']; $i++; } } /* * Now we have to get the services expired and we have to sum the previous $customers array with these * new information. */ // Get all the services active that expire the day after $services = OrdersItems::getExpiringServicesByRange(0, 30, Statuses::id("complete", "orders")); if ($services) { // Create the customer group list for the email summary foreach ($services as $service) { if ($service['reseller']) { $invoice_dest = Customers::getAllInfo($service['reseller']); $customers[$service['customer_id']]['id'] = $invoice_dest['customer_id']; $customers[$service['customer_id']]['fullname'] = $invoice_dest['firstname'] . " " . $invoice_dest['lastname'] . " " . $invoice_dest['company']; $customers[$service['customer_id']]['email'] = $customer_email = Contacts::getEmails($invoice_dest['customer_id']); $customers[$service['customer_id']]['password'] = $invoice_dest['password']; $customers[$service['customer_id']]['language_id'] = $invoice_dest['language_id']; } else { $customers[$service['customer_id']]['id'] = $service['id']; $customers[$service['customer_id']]['fullname'] = $service['fullname']; $customers[$service['customer_id']]['email'] = $customer_email = Contacts::getEmails($service['id']); $customers[$service['customer_id']]['password'] = $service['password']; $customers[$service['customer_id']]['language_id'] = $service['language_id']; } $customers[$service['customer_id']]['products'][$i]['name'] = $service['product']; $customers[$service['customer_id']]['products'][$i]['type'] = "service"; $customers[$service['customer_id']]['products'][$i]['renew'] = $service['renew']; $customers[$service['customer_id']]['products'][$i]['expiring_date'] = $service['expiringdate']; $customers[$service['customer_id']]['products'][$i]['days'] = $service['days']; $customers[$service['customer_id']]['products'][$i]['oldorderitemid'] = $service['detail_id']; $i++; } } // EMAIL SUMMARY FOR ALL THE EXPIRED AND NOT AUTORENEWABLE DOMAINS/SERVICES // ========================================================================= // Create the emailS for the customers if (count($customers) > 0) { // For each client do ... foreach ($customers as $customer) { $items = array(); $translator->setLocale(Languages::get_locale($customer['language_id'])); // Check if there are some product to be expired if (count($customer['products']) > 0) { $i = 0; // For each product do ... foreach ($customer['products'] as $product) { $items[$i][$translator->translate("Expiry Date")] = $product['expiring_date']; $items[$i][$translator->translate("Days")] = $product['days']; $items[$i][$translator->translate("Description")] = $product['name']; if ($product['renew']) { $items[$i][$translator->translate("Auto Renewal")] = $translator->translate("Active"); } else { $items[$i][$translator->translate("Auto Renewal")] = $translator->translate("Not Active"); } $i++; } } $items = Shineisp_Commons_Utilities::array2table($items); if (!empty($items)) { Shineisp_Commons_Utilities::sendEmailTemplate($customer['email'], 'reminder', array('items' => $items, 'fullname' => $customer['fullname']), null, null, null, null, $customer['language_id'], Settings::findbyParam('cron_notify')); } } } return true; }
public static function getEmailTemplate($template, $language_id = null) { $fallbackLocale = "en_US"; $subject = ""; $locale = Shineisp_Registry::get('Zend_Locale')->toString(); if (empty($language_id)) { $language_id = Languages::get_language_id($locale); } else { $locale = Languages::get_locale($language_id); } $EmailTemplate = EmailsTemplates::findByCode($template, null, false, $language_id); // Template missing from DB. Let's add it. if (!is_object($EmailTemplate) || !isset($EmailTemplate->EmailsTemplatesData) || !isset($EmailTemplate->EmailsTemplatesData->{0}) || !isset($EmailTemplate->EmailsTemplatesData->{0}->subject)) { $filename = PUBLIC_PATH . "/languages/emails/" . $locale . "/" . $template . ".htm"; // Check if the file exists if (!file_exists($filename)) { $filename = PUBLIC_PATH . "/languages/emails/" . $fallbackLocale . "/" . $template . ".htm"; Shineisp_Commons_Utilities::log("This email template has not been found: {$filename}"); $language_id = 1; // set the right default language id // Also the fallback template is missing. Something strange is going on..... if (!file_exists($filename)) { Shineisp_Commons_Utilities::log("The default email template has not been found: {$filename}"); return array('template' => "Template: " . $template . " not found", 'subject' => $template); } } // Get the content of the file $body = ''; foreach (file($filename) as $line) { // Get the subject written in the template file if (preg_match('/<!--@subject\\s*(.*?)\\s*@-->/', $line, $matches)) { $subject = $matches[1]; // Get the subject $subject = trim($subject); continue; } // Delete all the comments $body .= preg_replace('#\\{\\*.*\\*\\}#suU', '', $line); } $isp = Isp::getActiveISP(); $body = trim($body); $subject = trim($subject); // check if the string contains html tags and if it does not contain tags // means that it is a simple text. In this case add the tag "<br/>" for each return carrier if (!self::isHtml($body)) { $body = nl2br($body); } // Store mail in DB $array = array('type' => 'general', 'name' => $template, 'code' => $template, 'plaintext' => 0, 'active' => 1, 'fromname' => is_array($isp) && isset($isp['company']) ? $isp['company'] : 'ShineISP', 'fromemail' => is_array($isp) && isset($isp['email']) ? $isp['email'] : '*****@*****.**', 'subject' => $subject, 'html' => $body); // Save the data EmailsTemplates::saveAll(null, $array, $language_id); // Return the email template return array_merge($array, array('template' => $body, 'subject' => $subject)); } // template is numeric but there is not template in db. something strange happened. Exit. if (is_numeric($template) && !is_object($EmailTemplate)) { return false; } $email = array('subject' => $EmailTemplate->EmailsTemplatesData->{0}->subject, 'plaintext' => intval($EmailTemplate->plaintext), 'fromname' => $EmailTemplate->EmailsTemplatesData->{0}->fromname, 'fromemail' => $EmailTemplate->EmailsTemplatesData->{0}->fromemail, 'cc' => $EmailTemplate->cc, 'bcc' => $EmailTemplate->bcc, 'template' => ''); if (!empty($EmailTemplate->EmailsTemplatesData->{0}->html) && !empty($EmailTemplate->EmailsTemplatesData->{0}->text)) { // Both version are present $body = intval($EmailTemplate->plaintext) ? $EmailTemplate->EmailsTemplatesData->{0}->text : $EmailTemplate->EmailsTemplatesData->{0}->html; } else { if (empty($EmailTemplate->EmailsTemplatesData->{0}->html) && !empty($EmailTemplate->EmailsTemplatesData->{0}->text)) { // Only TEXT version $body = $EmailTemplate->EmailsTemplatesData->{0}->text; } else { // Only HTML version $body = $EmailTemplate->EmailsTemplatesData->{0}->html; } } $email['template'] = $body; return $email; }