Hello @Segaf
You can verify this by adding the following code snippet inside the dashboard.php file:
$items = $this->personRepository
->resetModel()
->leftJoin('leads', 'persons.id', '=', 'leads.person_id')
->select('*', 'persons.id as id')
->addSelect(DB::raw('SUM('.$tablePrefix.'leads.lead_value) as revenue'))
->whereBetween('leads.closed_at', [$this->startDate, $this->endDate])
->having(DB::raw('SUM('.$tablePrefix.'leads.lead_value)'), '>', 0)
->groupBy('person_id')
->orderBy('revenue', 'DESC')
->limit($limit);
if ($userIds = bouncer()->getAuthorizedUserIds()) {
$items->whereIn('leads.user_id', $userIds);
}
$items = $items->get();
This will help you to resolve your query. In case of any issue do let us know.
NOTE : There is no Role based data available in krayin crm also we have group visibility in Krayin
Warm Regards
