public function getUserActivity($limit = FALSE) { $output = []; if ($limit) { $limit = 'LIMIT ' . $limit; } $model = new UserTableModel(); $model->setTable('operation_log'); $model->readAllRecords('*', 'ORDER BY time DESC LIMIT 30'); $records = $model->getAllRecords(); $model->readAllRecords("DISTINCT DATE_FORMAT(`time`, '%Y-%m-%d') as time", "GROUP BY time ORDER BY time DESC {$limit}"); $groupRecords = $model->getAllRecords(); foreach ($groupRecords as $key => $record) { $date = explode(' ', $record['time'])[0]; $model->readAllRecords("*", "WHERE DATE_FORMAT(`time`, '%Y-%m-%d') = '{$date}'"); $records = $model->getAllRecords(); foreach ($records as $key2 => $record) { if (!empty($record['manager'])) { $model->setTable('user'); $model->setId($record['manager']); $records[$key2]['manager_name'] = $model->readRecordsById('id', 'username')[0]['username']; } } $model->setTable('operation_log'); $groupRecords[$key]['records'] = $records; } return $groupRecords; }