| 1 |
<?php |
| 2 |
|
| 3 |
namespace FluentSupport\App\Hooks\Handlers; |
| 4 |
|
| 5 |
use FluentSupport\App\Models\Activity; |
| 6 |
use FluentSupport\App\Models\Meta; |
| 7 |
use FluentSupport\App\Services\Helper; |
| 8 |
|
| 9 |
class CleanupHandler |
| 10 |
{ |
| 11 |
public function initHourlyTasks() |
| 12 |
{ |
| 13 |
$this->cleanLiveActivities(); |
| 14 |
} |
| 15 |
|
| 16 |
public function initDailyTasks() |
| 17 |
{ |
| 18 |
$this->cleanActivityLogs(); |
| 19 |
} |
| 20 |
|
| 21 |
protected function cleanLiveActivities() |
| 22 |
{ |
| 23 |
// Delete All Live Activity older than 24 hours |
| 24 |
$oldDateTime = date('Y-m-d H:i:s', strtotime(current_time('mysql')) - 86400); |
| 25 |
|
| 26 |
Meta::where('key', '_live_activity') |
| 27 |
->where('object_type', 'ticket_meta') |
| 28 |
->where('updated_at', '<', $oldDateTime) |
| 29 |
->delete(); |
| 30 |
} |
| 31 |
|
| 32 |
protected function cleanActivityLogs() |
| 33 |
{ |
| 34 |
$settings = Helper::getOption('_activity_settings', []); |
| 35 |
|
| 36 |
if (!$settings && empty($settings['delete_days'])) { |
| 37 |
$settings['delete_days'] = 14; |
| 38 |
} |
| 39 |
|
| 40 |
$oldDateTime = date('Y-m-d H:i:s', strtotime(current_time('mysql')) - ($settings['delete_days'] * 86400)); |
| 41 |
|
| 42 |
Activity::where('created_at', '<', $oldDateTime)->delete(); |
| 43 |
} |
| 44 |
|
| 45 |
} |
| 46 |
|
