/** * Return portal project recent activities * * @param Portal $portal * @param integer $count * @return array */ function findPortalProjectRecentActivities($portal, $count = 30) { $type_filter = Portal::getVisibleTypesFilterByPortalProject($portal); if ($type_filter) { $objects_table = TABLE_PREFIX . 'project_objects'; $logs_table = TABLE_PREFIX . 'activity_logs'; $count = (int) $count; if ($count < 1) { $count = 30; } // if $recent_activities = ActivityLogs::findBySQL("SELECT {$logs_table}.* FROM {$logs_table}, {$objects_table} WHERE {$logs_table}.object_id = {$objects_table}.id AND {$type_filter} AND {$objects_table}.state >= ? AND {$objects_table}.visibility >= ? ORDER BY {$logs_table}.created_on DESC LIMIT 0, {$count}", array(STATE_DELETED, VISIBILITY_NORMAL)); return $recent_activities; } else { return null; } // if }