| Server IP : 66.29.137.217 / Your IP : 3.140.246.156 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/ideyshare.name.ng/app/tasks/ |
Upload File : |
<?php
/*
* Title: Create Email Notifications Script
* Author: YetiShare.com
* Period: Run once a day
*
* Description:
* Script to create email notifications in user accounts about premium expiry.
*
* How To Call:
* On the command line via PHP, like this:
* php create_email_notifications.cron
*
* Configure as a cron like this:
* 0 1 * * * php /path/to/yetishare/app/tasks/create_email_notifications.cron.php
*/
namespace App\Tasks;
// include framework
use App\Core\Database;
use App\Core\Framework;
use App\Models\User;
use App\Helpers\BackgroundTaskHelper;
use App\Helpers\TranslateHelper;
use App\Helpers\CoreHelper;
use App\Helpers\InternalNotificationHelper;
use App\Helpers\LogHelper;
require_once(realpath(dirname(__FILE__).'/../core/Framework.class.php'));
// setup light environment
Framework::runLight();
// get database
$db = Database::getDatabase();
// background task logging
BackgroundTaskHelper::start();
// logging
LogHelper::setContext('cron-create-email-notifications');
/*
* DAILY ACCOUNT EXPIRY NOTIFICATIONS
*/
// when to send notifications
$accountDowngradeWarningDays = array(1, 2, 4, 7);
// logging
LogHelper::info('Using warning days: '. json_encode($accountDowngradeWarningDays, true));
// get all accounts reaching paid expiry period
$expiringPaidAccounts = $db->getRows('SELECT id, username, paidExpiryDate, '
. '((UNIX_TIMESTAMP(paidExpiryDate) - UNIX_TIMESTAMP()) / 86400) AS daysUntil '
. 'FROM users '
. 'WHERE level_id IN (SELECT id FROM user_level WHERE level_type = \'paid\') '
. 'AND status = \'active\' '
. 'AND never_expire = 0 '
. 'AND paidExpiryDate BETWEEN NOW() '
. 'AND NOW() + INTERVAL ' . (int) max($accountDowngradeWarningDays) . ' DAY');
if ($expiringPaidAccounts) {
// logging
LogHelper::info('Found expiring account: '.count($expiringPaidAccounts));
// look expiring accounts and send emails
foreach ($expiringPaidAccounts AS $expiringPaidAccount) {
// days until
$daysUntil = ceil($expiringPaidAccount['daysUntil']);
// if within one of our notification days, add notification
if (in_array($daysUntil, $accountDowngradeWarningDays)) {
// logging
LogHelper::info('Creating internal notification for user id: '.$expiringPaidAccount['id']);
$content = TranslateHelper::t('internal_notification_paid_account_expiring', 'Your paid account is expiring in [[[DAYS]]] days. Your inactive files may removed if you do not renew your membership. Click here for more information.', array('DAYS' => $daysUntil));
$link = WEB_ROOT . '/upgrade';
InternalNotificationHelper::add($expiringPaidAccount['id'], $content, $type = 'entypo-attention', $link);
// logging
LogHelper::info('Sent internal notification for user id: '.$expiringPaidAccount['id']);
// logging
LogHelper::info('Creating email user id: '.$expiringPaidAccount['id']);
$userObj = User::loadOneById($expiringPaidAccount['id']);
// logging
LogHelper::info('User object loaded.');
$subject = TranslateHelper::t('account_expiry_warning_email_subject', 'Your premium account on [[[SITE_NAME]]] will expire in [[[DAYS]]] day(s)', array('SITE_NAME' => SITE_CONFIG_SITE_NAME, 'DAYS' => $daysUntil));
$replacements = array(
'USERNAME' => $userObj->username,
'SITE_NAME' => SITE_CONFIG_SITE_NAME,
'WEB_ROOT' => WEB_ROOT,
'DAYS' => $daysUntil
);
$defaultContent = "Dear [[[USERNAME]]],<br/><br/>";
$defaultContent .= "Your premium account on [[[SITE_NAME]]] is about to expire in [[[DAYS]]] day(s). To avoid the account reverting to non-premium ensure you renew your premium membership. You can do this by logging into your account and choose to 'extend' your account.<br/><br/>";
$defaultContent .= "<strong>Url:</strong> [[[WEB_ROOT]]]<br/><br/>";
$defaultContent .= "Note that if you do not renew your premium membership, your account limits may be reduced and some of your inactive files automatically removed.<br/><br/>";
$defaultContent .= "Feel free to contact us if you need any support with your account.<br/><br/>";
$defaultContent .= "Regards,<br/>";
$defaultContent .= "[[[SITE_NAME]]] Admin";
$htmlMsg = TranslateHelper::t('account_expiry_warning_email_content', $defaultContent, $replacements);
// logging
LogHelper::info('Sending email to: '.$userObj->email);
// send email
CoreHelper::sendHtmlEmail($userObj->email, $subject, $htmlMsg, SITE_CONFIG_DEFAULT_EMAIL_ADDRESS_FROM, strip_tags(str_replace("<br/>", "\n", $htmlMsg)));
// logging
LogHelper::info('Sent email to: '.$userObj->email);
}
}
}
else {
// logging
LogHelper::info('No expiring accounts found.');
}
// background task logging
BackgroundTaskHelper::end();