Logs

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

Navigation to Logs

• Login as an Admin > System > Logs

  

Functionality

If the toggle filter is enabled, users can filter the activity log specifically by the salesperson.

Additionally, users can search through the logs using a regular grid search function. Users have the ability to sort the logs based on each column.

Database tables & queries

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']);

Paths

Function Path

app/Helpers/ActivityHelper.php -> log()