@php
$one_month_ago = date('m-d');
$total_task = DB::table('task_management_systems')
->where('task_start_date', '>', $one_month_ago)
->where('department_id', Auth::user()->department_id)
->count();
$task_complete = DB::table('task_management_systems')
->where('task_status', 'Close')
->where('task_start_date', '>', $one_month_ago)
->where('department_id', Auth::user()->department_id)
->count();
$task_pending = DB::table('task_management_systems')
->where('task_status', 'Open')
->where('task_start_date', '>', $one_month_ago)
->where('department_id', Auth::user()->department_id)
->count();
@endphp
{{-- calculation of task end --}}
{{-- level of task assign start --}}
@php
$children = DB::table('users')
->where('role_id', 2)
->where('department_id', Auth::user()->department_id)
->get()
->toArray();
$child_details = [];
foreach ($children as $child) {
$child_details[$child->id] = DB::table('users')
->where('id', intval($child->id))
->first();
// $child_details[$child->id]->task_pending_count = DB::table('task_management_systems')
// ->where('task_assign_to', $child->id)
// ->where('task_status', 'Open')
// ->where('task_recive_status', 1)
// ->count();
if ($child->id !== null) {
$child_details[$child->id]->task_pending_count = DB::table('task_management_systems')
->where('task_assign_to', intval($child->id))
->where('task_status', 'Open')
->where('task_recive_status', 1)
->count();
}
}
@endphp
@php
$user = auth()->user();
@endphp
Warning: Undefined variable $user in D:\NTG_App\www\Support_Issue\resources\views\layouts\tms\Manager.blade.php on line 221
Warning: Attempt to read property "joining_date" on null in D:\NTG_App\www\Support_Issue\resources\views\layouts\tms\Manager.blade.php on line 221
Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in D:\NTG_App\www\Support_Issue\resources\views\layouts\tms\Manager.blade.php on line 221
Warning: Undefined variable $user in D:\NTG_App\www\Support_Issue\resources\views\layouts\tms\Manager.blade.php on line 222
Warning: Attempt to read property "dob" on null in D:\NTG_App\www\Support_Issue\resources\views\layouts\tms\Manager.blade.php on line 222
Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in D:\NTG_App\www\Support_Issue\resources\views\layouts\tms\Manager.blade.php on line 222