@php if($ddl_users == 0){ @endphp
@php $i=1; $flag = 0; foreach($priority_pending as $target){ $cnt = 1; $taskassigned = DB::table('tm_project_member')->select('master_menu_level_1.menu_name', 'description', 'priority', 'target_dt') ->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('master_menu_level_1', 'tm_project_member.project_id', '=', 'master_menu_level_1.id') ->where('tm_project_member.user_id', '=', $target->user_id) ->where('tm_project_member_task.priority','=',$ddl_priority) ->orderBy('master_menu_level_1.menu_name','asc')->get(); $nm = ""; if(count($taskassigned) > 0){ $flag = 1; @endphp
@php foreach($taskassigned as $assigns){ @endphp @php if($nm != $assigns->menu_name){ echo ""; echo ""; $cnt++; }else{ echo ""; echo ""; } $nm = $assigns->menu_name; @endphp @php } @endphp
No. Project Description Priority Target Date
".$cnt."".$assigns->menu_name."{{ $assigns->description }} {{ $assigns->priority }} {{ date("d-m-Y",strtotime($assigns->target_dt)) }}
@php $i++; } } if($flag == 0){ @endphp
No Record Found
@php } }else{ @endphp
@php $nm = ""; $cnt = 1; foreach($priority_pending as $assigns){ @endphp @php if($nm != $assigns->menu_name){ echo ""; echo ""; $cnt++; }else{ echo ""; echo ""; } $nm = $assigns->menu_name; @endphp @php } @endphp
No. Project Description Priority Target Date
".$cnt."".$assigns->menu_name."{{ $assigns->description }} {{ $assigns->priority }} {{ date("d-m-Y",strtotime($assigns->target_dt)) }}
@php } @endphp