TextColumn::make('combinedName')
->searchable(query: function (Builder $query, string $search): Builder {
return $query->where(function ($query) use ($search) {
$query->where('contact_type', 'Customer')
->whereHas('contact', function (Builder $q) use ($search) {
$q->where('cust_name', 'ILIKE', "%{$search}%");
});
})
->orWhere(function ($query) use ($search) {
$query->where('contact_type', 'Employee')
->whereHas('contact', function (Builder $q) use ($search) {
$q->where('emp_name', 'ILIKE', "%{$search}%");
});
})
}, isIndividual: true)
TextColumn::make('combinedName')
->searchable(query: function (Builder $query, string $search): Builder {
return $query->where(function ($query) use ($search) {
$query->where('contact_type', 'Customer')
->whereHas('contact', function (Builder $q) use ($search) {
$q->where('cust_name', 'ILIKE', "%{$search}%");
});
})
->orWhere(function ($query) use ($search) {
$query->where('contact_type', 'Employee')
->whereHas('contact', function (Builder $q) use ($search) {
$q->where('emp_name', 'ILIKE', "%{$search}%");
});
})
}, isIndividual: true)