@php $taskQuery = $section->tasks() ->when(request('mine') == '1', fn($q) => $q->where('assignee_id', auth()->id())) ->when(!request('mine') && request('assignee_id'), fn($q,$v) => $q->where('assignee_id',$v)) ->when(request('status'), fn($q,$v) => $v ? $q->where('status',$v) : $q) ->when(request('due') === 'overdue', fn($q) => $q->whereNotNull('due_on')->whereDate('due_on','<', now()->toDateString())->where('status','!=','done')) ->when(request('due') === 'today', fn($q) => $q->whereDate('due_on', now()->toDateString())) ->when(request('due') === 'week', fn($q) => $q->whereBetween('due_on', [now()->toDateString(), now()->addDays(7)->toDateString()])) ->when(request('due') === 'none', fn($q) => $q->whereNull('due_on')) ->when(request('q'), function($q,$term) { $q->where(function($qq) use ($term){ $qq->where('name','like','%'.$term.'%') ->orWhere('description','like','%'.$term.'%') ->orWhereHas('comments', fn($cq)=>$cq->where('body','like','%'.$term.'%')); }); }); $sort = request('sort'); if ($sort === 'overdue_first') { $taskQuery->orderByRaw("CASE WHEN status != 'done' AND due_on IS NOT NULL AND due_on < CURDATE() THEN 0 WHEN due_on IS NOT NULL THEN 1 ELSE 2 END ASC")->orderBy('due_on','asc')->orderBy('sort_order','asc'); } elseif ($sort === 'due_asc') { $taskQuery->orderByRaw('due_on IS NULL')->orderBy('due_on','asc'); } elseif ($sort === 'due_desc') { $taskQuery->orderByRaw('due_on IS NULL')->orderBy('due_on','desc'); } elseif ($sort === 'priority_desc') { $taskQuery->orderByRaw("FIELD(priority,'urgent','high','medium','low')")->orderBy('sort_order','asc'); } elseif ($sort === 'updated_desc') { $taskQuery->orderBy('updated_at','desc'); } else { $taskQuery->orderBy('sort_order','asc')->orderBy('id','asc'); } $tasks = $taskQuery->get(); @endphp