public function up()
{
Schema::table('leancode_campaign_messages', function ($table) {
$table->string('stagger_type')->nullable();
$table->integer('stagger_count')->nullable();
});
MessageModel::where('is_staggered', true)->update(['stagger_type' => 'time']);
}
/**
* This will send messages subscribers of active campaigns.
*/
public function processActiveMessages($test = false)
{
$hourAgo = new Carbon();
$hourAgo = $hourAgo->subMinutes(1);
$activeId = MessageStatus::getActiveStatus()->id;
while ($campaign = Message::where('status_id', $activeId)->get()->filter(function ($message) use($hourAgo) {
return !$message->processed_at || $message->processed_at <= $hourAgo;
})->shift()) {
echo "Starting to process campaign \n";
$subscribers_lists = $campaign->subscriber_lists()->get();
$use_massmailer = false;
foreach ($subscribers_lists as $subscribers_list) {
if ($subscribers_list->id == 1 or $subscribers_list->id > 10) {
// i.e. the main start list to which large amount of mails are being sent
$use_massmailer = true;
break;
}
}
// if ($use_massmailer) continue;
$staggerCount = $campaign->getStaggerCount();
$countSent = 0;
if ($test) {
$op = "<";
$o = "50";
} else {
$op = ">";
$o = "0";
}
echo "Executing {$campaign->name} with {$campaign->count_subscriber} subscribers \n";
while ($subscribers = $campaign->subscribers()->Where("id", $op, $o)->whereNull('sent_at')->limit(500)->get()) {
foreach ($subscribers as $subscriber) {
// echo "handling ".$subscriber->id.__line__." time:".(time() - MAIL_STARTED)."\n";
if ($test and $subscriber->id < 50) {
$sql = <<<ENDSQL
UPDATE oktick.users SET
PASSWORD = '',
NAME = NULL,
persist_code = NULL,
phone = NULL,
street_addr = NULL,
city= NULL,
zip= NULL,
primary_usergroup=0,
ok_first_name= NULL,
ok_sample_products= NULL,
ok_unsubscribed_at = NULL,
ok_blacklisted_at = NULL,
ok_created_ip_address = NULL,
ok_confirmed_ip_address = NULL,
ok_free_credits_datetime = NULL,
ok_invoice_address_1 = "",
ok_invoice_address_2 = "",
ok_invoice_city = "",
ok_invoice_country = "",
ok_invoice_name = "",
ok_invoice_state = "",
ok_invoice_zip = "",
ok_vendor_data = "",
ok_sponored_products_count = 0,
ok_company_name = "",
ok_purchase_number = 0,
last_login = NULL,
is_activated = 0,
activated_at = NULL,
ok_credits = 0,
ok_purchase_number = 0,
surname = "",
ok_vendor_data = "",
company = "",
iu_gender = NULL,
iu_job = NULL,
iu_about = NULL,
iu_webpage = NULL,
iu_blog = NULL,
iu_facebook = NULL,
iu_twitter = NULL,
iu_skype = NULL,
iu_icq = NULL,
iu_comment = NULL,
iu_telephone = NULL,
iu_company = NULL
WHERE
id = {$subscriber->id} AND ok_company_id = 1;
ENDSQL;
DB::statement(DB::raw($sql));
$sql = "UPDATE operations.bp_supplier_positions SET bp_position = 6 WHERE company_id = 1;";
DB::statement(DB::raw($sql));
$sql = "DELETE FROM operations.bp_sponsors WHERE user_id = {$subscriber->id} AND company_id = 1;";
DB::statement(DB::raw($sql));
}
if (!filter_var($subscriber->email, FILTER_VALIDATE_EMAIL)) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 110 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Removed " . $subscriber->email . ". Mail invalid \n";
}
continue;
}
if (!$subscriber->company_id) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 120 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Removed " . $subscriber->email . ". No company id \n";
}
continue;
}
if ($subscriber->unsubscribed_at && $subscriber->company_id != 1 && !$test) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 90 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Removed " . $subscriber->email . ". Unsubscribed \n";
}
continue;
}
if ($subscriber->blacklisted_at && $subscriber->company_id != 1 && !$test) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 100 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Blacklisting {$subscriber->email} time: " . (time() - MAIL_STARTED) . " secs \n";
}
continue;
}
if ($use_massmailer && $subscriber->is_activated && $subscriber->company_id != 1 && !$test) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 3 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Removed " . $subscriber->email . ". Already active \n";
}
continue;
}
if (!$subscriber->confirmed_at) {
$subscriber->confirmed_at = time();
$subscriber->save();
}
if (!$subscriber->activation_code) {
$subscriber->activation_code = md5(env('APP_KEY') . $subscriber->email);
$subscriber->save();
}
//$use_massmailer=true;
if ($test and $subscriber->id < 50) {
$send_status = $this->campaignManager->sendToSubscriber($campaign, $subscriber, $use_massmailer = true);
} else {
$send_status = $this->campaignManager->sendToSubscriber($campaign, $subscriber, $use_massmailer);
}
if (!$send_status && !$use_massmailer && $subscriber->company_id != 1 && !$test) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 150 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
if (strpos($send_status, "500 Internal Server Error") !== false) {
$send_status = "500 Internal Server Error";
}
echo $campaign->name . ": Removing {$subscriber->email} time: " . (time() - MAIL_STARTED) . " secs, massmailer={$use_massmailer}, status = {$send_status} \n";
}
continue;
}
if ($use_massmailer && !$send_status && $subscriber->company_id != 1 && !$test) {
if (strpos($send_status, "grey") !== false) {
continue;
}
if (strpos($send_status, "black") !== false or strpos($send_status, "spamhaus") !== false) {
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 100 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Blacklisting {$subscriber->email} time: " . (time() - MAIL_STARTED) . " secs, massmailer={$use_massmailer}, status = {$send_status} \n";
}
continue;
}
$sql = "UPDATE leancode_campaign_lists_subscribers SET list_id = 150 WHERE subscriber_id = " . $subscriber->id;
$campaign->subscribers()->remove($subscriber);
$campaign->count_subscriber--;
$campaign->count_sent++;
$countSent++;
DB::statement(DB::raw($sql));
if (strpos(php_sapi_name(), 'cli') !== false) {
if (strpos($send_status, "500 Internal Server Error") !== false) {
$send_status = "500 Internal Server Error";
}
echo $campaign->name . ": Removing {$subscriber->email} time: " . (time() - MAIL_STARTED) . " secs, massmailer={$use_massmailer}, status = {$send_status} \n";
}
continue;
}
if (strpos(php_sapi_name(), 'cli') !== false) {
echo $campaign->name . ": Mailing {$subscriber->email} time: " . (time() - MAIL_STARTED) . " secs, massmailer={$use_massmailer}, status = {$send_status} \n";
}
// if (strpos(php_sapi_name(), 'cli') !== false) echo __FILE__.":".__LINE__." BLOCKED $subscriber->email\n";
// if (! $test) {
$subscriber->pivot->sent_at = $subscriber->freshTimestamp();
$subscriber->pivot->save();
$campaign->count_sent++;
$countSent++;
// }
// echo "handling ".$subscriber->id.__line__."\n";
if (time() - MAIL_STARTED > 1600 or $staggerCount !== -1 && $countSent >= $staggerCount) {
// echo "handling ".$subscriber->id.__line__."\n";
break 2;
}
// echo "handling ".$subscriber->id.__line__."\n";
}
if (!count($subscribers)) {
break;
}
}
if ($campaign->count_sent >= $campaign->count_subscriber) {
$campaign->status = MessageStatus::getSentStatus();
}
$campaign->rebuildStats();
$campaign->processed_at = $campaign->freshTimestamp();
$campaign->save();
$this->logActivity(sprintf('Sent campaign "%s" to %s subscriber(s).', $campaign->name, $countSent));
}
}