@php
if(count($projectname) > 0){
@endphp
@php
$j=1;
foreach($arr as $ar){
$active = '';
$cnt = 1;
if($j == 1) { $active='active show'; }
@endphp
| No. |
Module |
Description |
Priority |
Assigned Date |
Target Date |
|
Completed Date |
@php
$pro = DB::table('tm_project_member')->select('project_id')->where('id','=',$ar)->where('display','=','Y')->get();
$pid = $pro[0]->project_id;
$mem = "";
$projectmembers = DB::table('tm_project_member')->select('tm_project_member.*','name')
->LEFTJOIN('users', 'tm_project_member.user_id', '=', 'users.id')
->where('project_id','=',$pid)->where('display','=','Y')->get();
foreach($projectmembers as $pmem){
//echo $pmem->name;
//$mem = strtok(ucwords(strtolower($pmem->name)), " ").", ".$mem;
$mem = ucwords(strtolower($pmem->name)).", ".$mem;
}
$mem= rtrim($mem,', ');
$details = DB::table('tm_project_member_task')->select('description', 'file', 'target_dt', 'priority', 'tm_project_member_task.id', 'from_dt', 'complete_dt', 'tm_project.project')
->LEFTJOIN('tm_project', 'tm_project_member_task.module_id', '=', 'tm_project.id')
->where('pro_mem_id', '=', $ar)->where('status', '=', 'Completed')
->orderBy('target_dt','desc')->get();
foreach($details as $assigns){
@endphp
| {{ $cnt }} |
{{ $assigns->project }} |
{{ $assigns->description }} |
{{ $assigns->priority }} |
{{ date("d-m-Y",strtotime($assigns->from_dt)) }} |
{{ date("d-m-Y",strtotime($assigns->target_dt)) }} |
|
{{ date("d-m-Y",strtotime($assigns->complete_dt)) }} |
@php
$cnt++;
}
@endphp
@php
$j++;
}
@endphp
@php
}else{
@endphp
@php
}
@endphp