@foreach ($project->users as $user)
@php
$hours_format_number = 0;
$total_hours = 0;
$hourdiff_late = 0;
$esti_late_hour = 0;
$esti_late_hour_chart = 0;
$total_user_task = App\Models\ProjectTask::where('project_id', $project->id)
->whereRaw('FIND_IN_SET(?, assign_to) > 0', [$user->id])
->get()
->count();
$all_task = App\Models\ProjectTask::where('project_id', $project->id)
->whereRaw('FIND_IN_SET(?, assign_to) > 0', [$user->id])
->get();
$total_complete_task = App\Models\ProjectTask::join('task_stages', 'task_stages.id', '=', 'project_tasks.stage_id')
->where('project_tasks.project_id', '=', $project->id)
->where('assign_to', '=', $user->id)
->where('task_stages.complete', '=', '1')
->get()
->count();
$logged_hours = 0;
$timesheets = App\Models\Timesheet::where('project_id', $project->id)
->where('created_by', $user->id)
->get();
@endphp
@foreach ($timesheets as $timesheet)
@php
$date_time = $timesheet->time;
$hours = date('H', strtotime($date_time));
$minutes = date('i', strtotime($date_time));
$total_hours = $hours + $minutes / 60;
$logged_hours += $total_hours;
$hours_format_number = number_format($logged_hours, 2, '.', '');
@endphp
@endforeach
@endforeach
| {{ __('Name') }} |
{{ __('Assigned Tasks') }} |
{{ __('Done Tasks') }} |
{{ __('Logged Hour') }} |
| {{ $user->name }} |
{{ $total_user_task }} |
{{ $total_complete_task }} |
{{ $hours_format_number }} |