Call to undefined method Illuminate\Database\Query\Builder::addColumn()

[dtraxx]

Hi folks,

i'm currently upgrading a laravel 6 project to laravel 8 I'm using yajra/laravel-datatables but facing always the same error:
Call to undefined method Illuminate\Database\Query\Builder::addColumn()

Can please someone help me?
Thanks in advance

This is my method that generates the json data:

` protected function getTickets($status, $request, bool $currentUser = false): JsonResponse
{
$datatable = TicketRepository::ticketsDatatableQuery($status, $request, $currentUser);

    if (($currentUser && $request->isActive == 1) || ($request->has('is_team') && $request->is_team != '0')) {
        $datatable->addColumn('checkbox', function ($item) {
            return '
                    <label class="checkbox">
                        <input type="checkbox" name="tickets[]" value="' . $item->id . '">
                    </label>
                ';
        });
    }

    $datatable->addColumn('ticket_id', function ($item) {
        return '<a href="' . route('tickets.show', $item->id) . '" class="tooltips" title="' . __('View details') . '">' . $item->ticket_id . '</a>';
    });

    $datatable->addColumn('ticket_customer', function ($item) {
        if (isset($item->client)) {
            return $item->client;
        }
        if ($item->customer_type == 'billing') {
            if (isset($item->companyname)) {
                $customer = $item->companyname;
            } else {
                $customer = $item->billing_contact;
            }
        } else {
            $customer = $item->company_name;
        }
        return '<a href="' . route('tickets.index', [
                'customer' => $item->customer_id,
                'customer-type' => $item->customer_type,
            ]) .
            '" class="tooltips" title="' . __('Filter by customer') . '">' . $customer . '</a>';
    });

    $datatable->filterColumn('ticket_customer', function ($query, $keyword) {
        $query->where('cc.companyname', 'LIKE', "%{$keyword}%")
            ->orWhere('cco.prename', 'LIKE', "%$keyword%")
            ->orWhere('cco.name', 'LIKE', "%$keyword%")
            ->orWhere('t.client', 'LIKE', "%{$keyword}%")
            ->orWhere('p.company_name', 'LIKE', "%{$keyword}%");
    });

    $datatable->orderColumn('ticket_customer', 'ticket_customer $1');

    $datatable->addColumn('ticket_subject', function ($item) {
        if (isset($item->subject) && $item->subject_id != '0') {
            $subject = $item->shortname . ' - ' . $item->subject;
        } elseif ($item->subject_id != '0') {
            $subject = $item->shortname;
        } else {
            $subject = $item->subject;
        }
        return $subject;
    });

    $datatable->filterColumn('ticket_subject', function ($query, $keyword) {
        $query->where('s.shortname', 'LIKE', "%$keyword%")
            ->orWhere('t.subject', 'LIKE', "%$keyword%");
    });

    $datatable->orderColumn('ticket_subject', 'ticket_subject $1');

    $datatable->editColumn('priority', function ($item) {
        $priority = $item->comment_priority ?? $item->priority;
        return $priority == 'High' ? '<span class="label label-danger">' . $priority . '</span>' : $priority;
    });

    $datatable->filterColumn('priority', function ($query, $keyword) {
        $query->where('c2.priority', 'LIKE', "%$keyword%")
            ->orWhere('t.priority', 'LIKE', "%$keyword%");
    });

    $datatable->editColumn('severity', function ($item) {
        $severity = $item->comment_severity ?? $item->severity;
        return in_array($severity, ['Critical', 'Major']) ? '<span class="label label-danger">' . $severity . '</span>' : $severity;
    });

    $datatable->filterColumn('severity', function ($query, $keyword) {
        $query->where('c2.severity', 'LIKE', "%$keyword%")
            ->orWhere('t.severity', 'LIKE', "%$keyword%");
    });

    if ($request->has('is_team') && $request->filled('is_team') && $request->is_team != '0') {
        $datatable->filterColumn('team_name', function ($query, $keyword) {
            $query->where('nt.name', 'LIKE', "%{$keyword}%");
        });
        $datatable->orderColumn('team_name', 'team_name $1');
    } else {
        $datatable->editColumn('ticket_owner', function ($item) {
            if ($item->team_id != '0' && $item->owner == '0') {
                return $item->team->name;
            } else {
                return $item->first_name . ' ' . $item->last_name;
            }
        });
        $datatable->filterColumn('ticket_owner', function ($query, $keyword) {
            $query->whereRaw("CONCAT(u.first_name,' ',u.last_name) LIKE ?", ["%{$keyword}%"])
                ->orWhereRaw("nt.name LIKE ?", ["%{$keyword}%"]);
        });
        $datatable->orderColumn('ticket_owner', 'ticket_owner $1');
    }

    $datatable->addColumn('ticket_status', function ($item) {
        if (isset($item->comment_status)) {
            $status = $item->comment_status;
        } else {
            $status = $item->status;
        }
        if ($item->autoclose != '0') {
            $status = $status . ' <i class="<i class="fas fa-clock"></i>" title="' . __('Auto close after ' . $item->autoclose . ' hours') . '"></i>';
        }
        return $status;
    });

    $datatable->filterColumn('ticket_status', function ($query, $keyword) {
        $query->where('c2.status', 'LIKE', " %{
                $keyword}%")
            ->orWhere('t.status', 'LIKE', " % $keyword % ");
    });

    $datatable->editColumn('created_at', function ($item) {
        return Carbon::parse($item->date ?? $item->created_at)->format('d/m/Y')
            . ' at ' .
            Carbon::parse(isset($item->time) ? date('H:i', strtotime($item->time)) : $item->created_at)->format('H:i');
    });

    $datatable->editColumn('updated_at', function ($item) {
        if ($item->status === 'Closed') {
            if (isset($item->date)) {
                $date = $item->date;
            } else {
                $date = $item->created_at;
            }
            if (isset($item->time)) {
                $time = date('H:i', strtotime($item->time));
            } else {
                $time = $item->created_at;
            }
            $date = Carbon::parse($date)->format('d/m/Y');
            $time = Carbon::parse($time)->format('H:i');
            $updated = with(new Carbon($item->updated_at));
            return FunctionsHelper::calculateDateDifference($date . ' ' . $time, $updated->format('d/m/Y H:i:s'));
        } else {
            $updated = Carbon::parse($item->updated_at);
            return $updated->format('d/m/Y') . ' at ' . $updated->format('H:i');
        }
    });

    $datatable->editColumn('deadline', function ($item) {
        if (isset($item->deadline)) {
            $deadline = with(new Carbon($item->deadline))->format('d/m/Y');
            return now()->toDateString() > $item->deadline ? '<span class="text-danger">' . $deadline . '</span>' : $deadline;
        } else {
            return '';
        }
    });

    if ($currentUser) {
        $datatable->addColumn('is_read', function ($item) {
            return $item->is_read;
        });
    }

    $datatable->addColumn('action', function ($item) use ($request, $currentUser) {
        $actions = '';
        if (($currentUser && $request->isActive == 1) && $item->status_count <= 0 && $item->team_id != '0') {
            $actions .= '<li class="divider"></li>
                        <li>
                            <a href="javascript:;" class="unassign-ticket">
                                <i class="fas fa-undo mr-sm"></i>
                                <span>' . __('Un assign') . '</span>
                            </a>
                        </li>';
        }
        if ($item->team_id != '0' && $item->owner == '0') {
            $actions .= '<li class="divider"></li>
                    <li>
                        <a href="javascript:;" class="self-assign-ticket">
                            <i class="fas fa-check mr-sm"></i>
                            <span>' . __('Assign to me') . '</span>
                        </a>
                    </li>
                    <li class="divider"></li>
                    <li>
                        <a href="javascript:;" class="assign-ticket" data-ticket="' . $item->id . '">
                            <i class="fas fa-check mr-sm"></i>
                            <span>' . __('Assign to member') . '</span>
                        </a>
                    </li>';
        }
        return '<div class="btn-group">
                    <button type="button" class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown">
                        <i class="fas fa-cogs"></i> ' . __('Actions') . ' <span class="caret"></span>
                    </button>
                    <ul class="dropdown-menu col-xs-12">
                        <li>
                            <a href="' . route('tickets.show', $item->id) . '">
                                <i class="far fa-eye"></i>
                                <span>' . __('View') . '</span>
                            </a>
                        </li>
                        <li class="divider"></li>
                        <li>
                             <a href="' . route('tickets.edit', $item->id) . '">
                                <i class="fas fa-plus mr-sm"></i>
                                <span>' . __('Status update') . '</span>
                            </a>
                        </li>
                        <li class="divider"></li>
                        <li>
                             <a href="' . route('tickets.last', [$item->id, '#ticketHistory']) . '">
                                <i class="fas fa-edit mr-sm" ></i>
                                <span>' . __('Update last ticket') . '</span>
                            </a>
                        </li> ' .
            $actions
            . '</ul>
                </div> ';
    });

    $datatable->rawColumns([
        'checkbox',
        'ticket_id',
        'ticket_customer',
        'priority',
        'severity',
        'ticket_status',
        'deadline',
        'action'
    ]);

    return $datatable->escapeColumns()->toJson();
}`

An this is my repository method:

`public static function ticketsDatatableQuery($status, $request, bool $currentUser = false)
{
$query = DB::table('tickets as t')
->select(
't.id',
't.ticket_id',
't.customer_type',
't.customer_id',
't.client',
't.subject',
't.subject_id',
't.date',
't.time',
't.deadline',
't.priority',
't.type',
't.status',
't.severity',
't.channel',
't.datacenter',
't.owner',
't.team_id',
't.autoclose',
't.is_read',
't.created_at',
't.updated_at',
's.shortname',
'u.first_name',
'u.last_name',
'c2.status as comment_status',
'c2.priority as comment_priority',
'c2.severity as comment_severity',
'c2.created_at as comment2_created_at',
'p.id as prospect_id',
'p.company_name',
'nt.name as team_name',
DB::raw("CONCAT_WS(' ', t.client, cc.companyname, CONCAT_WS(' ', cco.prename, cco.name)) as ticket_customer"),
'cc.companyname',
DB::raw("CONCAT_WS(' ', cco.prename, cco.name) as billing_contact"),
DB::raw("CONCAT_WS(' ', t.subject, s.shortname) as ticket_subject"),
DB::raw("CONCAT_WS(' ', u.first_name, u.last_name) as ticket_owner"),
DB::raw('MAX(c1.created_at) as comment1_created_at'),
DB::raw('COUNT(c1.id) as status_count')
)
->leftJoin('billing.CUSTOMERS AS c', function ($join) {
$join->on('t.customer_id', '=', 'c.customerid')
->where('t.customer_type', 'billing');
})
->leftJoin('billing.CUSTOMER_COMPANIES AS cc', 'c.companyid', '=', 'cc.companyid')
->leftJoinSub(DB::table('billing.CUSTOMER_HAS_CONTACTS AS chc')
->select('cc.prename', 'cc.name', 'chc.customerid', 'cc.contactid')
->join('billing.CUSTOMER_CONTACTS AS cc', function ($join) {
$join->on('chc.contactid', '=', 'cc.contactid')
->where('cc.contactid', DB::raw("(
SELECT MAX(cc2.contactid) as contactid
FROM billing.CUSTOMER_CONTACTS AS cc2
JOIN billing.CUSTOMER_HAS_CONTACTS AS chc2 ON cc2.contactid = chc2.contactid
WHERE cc2.typeid = '2' AND chc.customerid = chc2.customerid
GROUP BY chc2.customerid
)"));
}), 'cco', function ($join) {
$join->on('c.customerid', '=', 'cco.customerid');
})
->leftJoin('subjects as s', 't.subject_id', '=', 's.id')
->leftJoin('prospects as p', function ($join) {
$join->on('t.customer_id', '=', 'p.id')
->where('t.customer_type', 'sales');
})
->leftJoin('ticket_comments as c1', 't.id', '=', 'c1.ticket_id')
->leftJoin('ticket_comments as c2', 't.id', '=', 'c2.ticket_id')
->leftJoin('users as u', 't.owner', '=', 'u.id')
->leftJoin('noc_teams as nt', 't.team_id', '=', 'nt.id')
->when($currentUser, function ($q) use ($request) {
return $q->where('t.owner', $request->user_id);
}, function ($q) use ($request, $status) {
$user = User::find($request->user_id);
$role = DB::table('user_roles')
->join('roles as r', 'role_id', '=', 'r.id' )
->select('r.name')
->where('user_id', '=', Auth::user()->id)
->first();

            if ($user && $role != 'superadministrator') {
                if (isset($user->department)) {
                    return $q->where(function ($q) use ($user, $status, $request) {
                        $q->whereIn('t.type', ['test']);
                        //$user['department']
                        if (in_array($status, ['Closed', 'All'])) {
                            $q->orWhere('t.owner', $request->user_id);
                        }
                    });
                }
            }
        })
        ->when($request->has(['customer', 'customer_type']), function ($q) use ($request) {
            return $q->where('t.customer_type', $request->customer_type)
                ->where('t.customer_id', $request->customer);
        })
        ->when($request->has(['is_team', 'user_id']), function ($q) use ($request) {
            return $q->where('t.team_id', '!=', '0')
                ->where('t.owner', '0')
                ->whereIn('t.team_id', $this->nocTeamMember->findBy([
                    ['member_id', '=', $request->user_id]
                ], 'get')->pluck('team_id')->toArray());
        })
        ->when($request->has('department') && $request->filled('department'), function ($q) use ($request) {
            return $q->where('t.type', $request->department);
        });

    if ($status !== 'All') {
        $query->where('t.status', $status);
    }

    return $query
        ->groupBy('t.id', 'c2.id', 'ticket_customer', 'billing_contact')
        ->havingRaw('comment2_created_at = comment1_created_at OR comment1_created_at IS NULL');
}`