/**
* Save log into file, and try to send via email to Developers
*/
public static function flushLog()
{
$last_flush_time = Settings::get('cms_tools_application_log_flush');
if (NOW - $last_flush_time < 453600) {
return;
// We do not need stats too often, wait 7 days
}
// Send data to original developer site of the existing domain
self::sendInformation();
// Now prepare file with aggregated data
$app_log = new AppLogEntityRepository();
$app_log->addSimpleSelectFields(['id', 'ts', 'user_id', 'url', 'msg', 'p', 'do']);
if ($last_flush_time) {
$app_log->setWhereOld($last_flush_time);
}
$app_log->addOrderByField('ts', true);
$app_log->setGenerateOutputWithIterator(false);
$users = new AdminUserRepository();
$users->setGenerateOutputWithIterator(false);
$users->addSimpleSelectFieldsAsString('CONCAT(`' . $users->getDbTableName() . '`.`name`, " ", `' . $users->getDbTableName() . '`.`surname`) AS `user`');
$app_log->mergeWithCollection($users, 'user_id');
$data_log = $app_log->getAsArrayOfObjectData(true);
$usage = new AdminUsageEntityRepository();
$data_usage = $usage->getAsArrayOfObjectData(true);
if ($data_log || $data_usage) {
$data = ['data' => ['domain' => CFG_DOMAIN, 'ts' => NOW], 'logs' => ['app_log' => $data_log, 'usage' => $data_usage]];
// Save in file
if (!file_exists(DIR_CACHE)) {
FileSystem::mkDir(DIR_CACHE);
}
file_put_contents(DIR_CACHE . 'log_data', gzencode(json_encode($data)));
// Send stats
Mailer::getInstance()->setSubject('Application and Usage log from ' . Configuration::getInstance()->get('site')['name'] . '(till ' . date(CFG_CMS_DATETIME_FORMAT, NOW) . ')')->setSender(Configuration::getInstance()->get('site')['email'])->setRecipient(CMS_SUPPORT_EMAIL)->setMessage('View attached file')->addAttachment(DIR_CACHE . 'log_data')->send();
$usage->deleteObjectCollection();
}
Settings::getInstance()->set('cms_tools_application_log_flush', NOW);
}
<?php
defined('INC') or exit;
use TMCms\Admin\Users\Entity\AdminUserRepository;
use TMCms\Admin\Users\Entity\UserLogRepository;
if (IS_AJAX_REQUEST) {
ob_start();
}
$access_log = new UserLogRepository();
$access_log->addSimpleSelectFields(['id', 'ts', 'request_uri']);
$access_log->addOrderByField('ts', true);
$access_log->setLimit(20);
$users = new AdminUserRepository();
$users->addSimpleSelectFieldsAsString('CONCAT(`' . $users->getDbTableName() . '`.`name`, " ", `' . $users->getDbTableName() . '`.`surname`) AS `user`');
$users->addWhereFieldAsString('IF("' . ((int) USER_ID == 1) . '", 1, `' . $users->getDbTableName() . '`.`id` != "1")');
$access_log->mergeWithCollection($users, 'user_id');
$res = [];
foreach ($access_log->getAsArrayOfObjectData() as $v) {
$res[] = date(CFG_CMS_DATETIME_FORMAT, $v['ts']) . ': ' . $v['user'] . ' - ' . $v['request_uri'];
}
echo '<b>User log</b><br>';
echo implode('<br>', $res);
if (IS_AJAX_REQUEST) {
echo ob_get_clean();
die;
}
