@php
$one_month_ago = date('m-d');
$total_task = DB::table('issue_entries')
->where('assign_date', '>', $one_month_ago)
->count();
$task_complete = DB::table('issue_entries')
->where('issue_status', 'Close')
->where('assign_date', '>', $one_month_ago)
->count();
$task_pending = DB::table('issue_entries')
->where('issue_status', 'Open')
->where('assign_date', '>', $one_month_ago)
->count();
$task_vendor = DB::table('issue_entries')
->where('issue_status', 'Open')
->where('issue_handed_over_to_vendor', '!=', null)
->where('assign_date', '>', $one_month_ago)
->count();
@endphp
Total Task
{{ $total_task ?? 0 }}
Task Complete
{{ $task_complete ?? 0 }}
Task Pending
{{ $task_pending ?? 0 }}
Task in Vendor Hand
{{ $task_vendor ?? 0 }}