public static function getFilteredRequest($filters = [])
    {
        $query = self::orderBy('id', 'DESC');

        if (!empty($filters['request_type'])) {
            // if($filters['request_type']=='Balcao'){
            //     $t='Balcão';
            //     $query = $query->where('request_type', $t);
            // }
            if ($filters['request_type'] != 'Todos') {
                $query = $query->where('request_type', $filters['request_type']);
            }
        }

        if (!empty($filters['client_nif'])) {
            $temp = Client::where('nif', $filters['client_nif'])->get();
            if (count($temp)!=0) {
                $query = $query->where('client_id', $temp[0]->id);
            }
            else{
                $query = $query->where('client_id', -1);
            }
        }

        if (!empty($filters['user_mail'])) {
            $temp = User::where('email', $filters['user_mail'])->get();
            if (count($temp) != 0) {
                    $query = $query->where('user_id', $temp[0]->id);
            }
            else {
                $query = $query->where('user_id', -1);
            }
        }
        return $query->paginate(10);
    }
}