@php if($ddl_project == 0){ @endphp
@php $i=1; foreach($project_pending as $ppending){ @endphp
@php $cnt = 1; $taskassigned = DB::table('tm_project_member')->select('tm_project_member_task.id', 'users.name', 'description', 'priority', 'target_dt','project') ->LEFTJOIN('users', 'tm_project_member.user_id', '=', 'users.id') ->LEFTJOIN('tm_project_member_task', 'tm_project_member.id', '=', 'tm_project_member_task.pro_mem_id') ->LEFTJOIN('tm_project', 'tm_project_member_task.module_id', '=', 'tm_project.id') ->where('tm_project_member_task.status', '=', 'Pending') ->where('tm_project_member_task.display', '=', 'Y') ->where('tm_project.display', '=', 'Y') ->where('tm_project_member.project_id', '=', $ppending->project_id)->WhereNotNull('project') ->orderBy('users.name','asc')->get(); $nm = ""; foreach($taskassigned as $assigns){ $history = DB::table('tm_project_target_date_his')->where('task_id', $assigns->id)->select('target_date')->get(); if(count($history) > 0) $prev_target_date = date("d-m-Y",strtotime($history[0]->target_date)); else $prev_target_date = ""; @endphp @php if($nm != $assigns->name){ echo ""; echo ""; $cnt++; }else{ echo ""; echo ""; } $nm = $assigns->name; @endphp @php } @endphp
No. Name Module Description Priority Target Date
".$cnt."".$assigns->name."{{ $assigns->project }} {{ $assigns->description }} {{ $assigns->priority }} {{ date("d-m-Y",strtotime($assigns->target_dt)) }}
{{ $prev_target_date }}
Project Discussion Group
@csrf
@error('msg') {{ $message }} @enderror

@error('file') {{ $message }} @enderror
@php $i++; } @endphp
@php }else{ @endphp
@php $nm = ""; $cnt = 1; foreach($project_pending as $assigns){ $history = DB::table('tm_project_target_date_his')->where('task_id', $assigns->id)->select('target_date')->get(); if(count($history) > 0) $prev_target_date = date("d-m-Y",strtotime($history[0]->target_date)); else $prev_target_date = ""; @endphp @php if($nm != $assigns->name){ echo ""; echo ""; $cnt++; }else{ echo ""; echo ""; } $nm = $assigns->name; @endphp @php } @endphp
No. Name Module Description Priority Target Date
".$cnt."".$assigns->name."{{ $assigns->project }} {{ $assigns->description }} {{ $assigns->priority }} {{ date("d-m-Y",strtotime($assigns->target_dt)) }}
{{ $prev_target_date }}
@php } @endphp @push('scripts') @endpush