Ctrlk

Logs

Users have the ability to view the log of activities that the system maintains, which records all actions performed by each user.

Here are the database tables related to logs:

users
activities
jobs
job_types

Queries

Used left join query with above mention tables

$logs = Activity::leftJoin('users', 'activities.user_id', '=', 'users.id')
->leftJoin('jobs', 'activities.job_id', '=', 'jobs.id')
->leftJoin('job_types', 'jobs.job_type_id', '=', 'job_types.id')
->select(['subject', 'activities.as_at', 'users.name as user', 'url', 'jobs.id as jobs_id', 'jobs.address as job_address' , 'job_types.name as job_type_name']);

PreviousSettings NextUsers

Last updated 2 years ago

hashtagQueries

hashtagFunction Path

Queries

Function Path