@php
$one_month_ago = date('m-d');
$task_complete = DB::table('targets')
->where('issue_assign_to', Auth::user()->id)
->where('issue_status', 'Close')
->where('assign_date', '>', $one_month_ago)
->count();
$task_running = DB::table('targets')
->where('issue_assign_to', Auth::user()->id)
->where('issue_status', 'Open')
->where('assign_date', '>', $one_month_ago)
->count();
$task_pending = DB::table('targets')
->where('issue_assign_to', Auth::user()->id)
->where('issue_status', 'Pending')
->where('assign_date', '>', $one_month_ago)
->count();
$task_vendor = DB::table('targets')
->where('issue_assign_to', Auth::user()->id)
->where('issue_status', 'Pending')
->where('issue_handed_over_to_vendor', '!=', null)
->where('assign_date', '>', $one_month_ago)
->count();
@endphp
Task Complete
{{ $task_complete ?? 0 }}
Task Running
{{ $task_running ?? 0 }}
Task Pending
{{ $task_pending ?? 0 }}
Task Vendor
{{ $task_vendor ?? 0 }}
{{-- Task Report End --}}
{{-- firework and birthday wish and work anniversary wish Start --}}