Activity Repository

Manage agents log / activities. The resource type is agentslog.

Querying Activities

use Innobrain\OnOfficeAdapter\Facades\ActivityRepository;

$activities = ActivityRepository::query()->addressIds([34, 35])->get();
$activities = ActivityRepository::query()->estateId(2507)->get();
$activity = ActivityRepository::query()->find(67075);

Selecting & Filtering

$activities = ActivityRepository::query()
    ->select(['Aktionsart', 'Aktionstyp', 'Datum', 'Bemerkung'])
    ->estateId(2507)
    ->where('Aktionsart', 'Email')
    ->whereBetween('created', '2024-01-01', '2024-12-31')
    ->orderByDesc('Datum')
    ->get();

WARNING

Cannot filter by: Benutzer, Adress_nr, Objekt_nr, dauer. Use addressIds() and estateId() instead.

Creating Activities

Set the related records via addressIds() and estateId() — they take precedence over raw addressids/estateid keys in the data array:

ActivityRepository::query()
    ->addressIds([34])
    ->estateId(41)
    ->create([
        'actionkind' => 'Email',
        'actiontype' => 'Ausgang',
        'note' => 'Contract sent',
        'advisorylevel' => 'B',      // A-G levels
        'cost' => 2.45,
        'duration' => 3000,          // seconds
    ]);

WARNING

Datum cannot be set on create — the server discards the supplied value and stamps the current time, without an error.

Advisory Levels

Level	Description
A	Contract signed
B	Written commitment
C	Intensive discussion
D	Still checking
E	Documentation received
F	Documentation ordered
G	Cancellation (allows reasoncancellation)

Count & Chunked

$count = ActivityRepository::query()->estateId(10)->count();
ActivityRepository::query()->addressIds([1])->each(fn ($activities) => /* process */);