| Server IP : 66.29.137.217 / Your IP : 52.15.143.11 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 Internal Noticiations Script
* Author: YetiShare.com
* Period: Run once a day
*
* Description:
* Script to create notifications in user accounts about premium expiry.
*
* How To Call:
* On the command line via PHP, like this:
* php create_internal_notifications.cron
*
* Configure as a cron like this:
* 0 0 * * * php /path/to/yetishare/app/tasks/create_internal_notifications.cron.php
*/
namespace App\Tasks;
// include framework
use App\Core\Database;
use App\Core\Framework;
use App\Helpers\BackgroundTaskHelper;
use App\Helpers\InternalNotificationHelper;
use App\Helpers\TranslateHelper;
require_once(realpath(dirname(__FILE__).'/../core/Framework.class.php'));
// setup light environment
Framework::runLight();
// get database
$db = Database::getDatabase();
// background task logging
BackgroundTaskHelper::start();
// when to send notifications
$notificationDays = array(1, 2, 4, 7);
// 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($notificationDays) . ' DAY');
if ($expiringPaidAccounts) {
foreach ($expiringPaidAccounts AS $expiringPaidAccount) {
// days until
$daysUntil = ceil($expiringPaidAccount['daysUntil']);
// if within one of our notification days, add notification
if (in_array($daysUntil, $notificationDays)) {
$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);
}
}
}
// background task logging
BackgroundTaskHelper::end();