public static function getCampaignsNotCreated()
{
return EmailCampaign::where('shipping_date_044', '<', date('U'))->where('created_044', false)->get();
}
/**
* Function which directly sends a test campaign group
*
* @access public
* @param array $paramenters
* @return void
*/
public static function sendEmailsTest($paramenters)
{
$campaign = EmailCampaign::builder()->where('id_044', $paramenters['id'])->first();
$testGroup = Preference::getValue('emailServiceTestGroup', 5);
$contacts = Contact::getRecords(['group_id_042' => (int) $testGroup->value_018, 'groupBy' => 'id_041']);
if (count($contacts) > 0) {
foreach ($contacts as $contact) {
if ($contact->email_041 != null) {
$dataEmail = ['replyTo' => empty($campaign->reply_to_013) ? null : $campaign->reply_to_013, 'email' => $contact->email_041, 'html' => $campaign->header_044 . $campaign->body_044 . $campaign->footer_044, 'text' => $campaign->text_044, 'subject' => $campaign->subject_044, 'contactKey' => Crypt::encrypt($contact->id_041), 'company' => isset($contact->company_041) ? $contact->company_041 : '', 'name' => isset($contact->name_041) ? $contact->name_041 : '', 'surname' => isset($contact->surname_041) ? $contact->surname_041 : '', 'birthDate' => isset($contact->birth_date_041) ? date(config('pulsar.datePattern'), $contact->birth_date_041) : '', 'campaign' => Crypt::encrypt($campaign->id_044), 'historyId' => '0'];
// config SMTP account
config(['mail.host' => $campaign->outgoing_server_013]);
config(['mail.port' => $campaign->outgoing_port_013]);
config(['mail.from' => ['address' => $campaign->email_013, 'name' => $campaign->name_013]]);
config(['mail.encryption' => $campaign->outgoing_secure_013 == 'null' ? null : $campaign->outgoing_secure_013]);
config(['mail.username' => $campaign->outgoing_user_013]);
config(['mail.password' => Crypt::decrypt($campaign->outgoing_pass_013)]);
EmailServices::sendEmail($dataEmail);
}
}
}
}
public function recordStatistic()
{
// get parameters from url route
$parameters = $this->request->route()->parameters();
// if it's a test email, we brake execution
if ($parameters['historyId'] === '0') {
exit;
}
$campaign = Crypt::decrypt($parameters['campaign']);
$historyId = Crypt::decrypt($parameters['historyId']);
// add a viewed to the campaign
EmailCampaign::where('id_044', $campaign)->increment('viewed_044');
// add a viewed to the historical
EmailSendHistory::where('id_048', $historyId)->increment('viewed_048');
}
