@php
$i=1;
$flag = 0;
foreach($target_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.target_dt','=',$txt_date)
->orderBy('master_menu_level_1.menu_name','asc')->get();
$nm = "";
if(count($taskassigned) > 0){
$flag = 1;
@endphp
No. |
Project |
Description |
Priority |
Target Date |
@php
foreach($taskassigned as $assigns){
@endphp
@php
if($nm != $assigns->menu_name){
echo "".$cnt." | ";
echo "".$assigns->menu_name." | ";
$cnt++;
}else{
echo " | ";
echo " | ";
}
$nm = $assigns->menu_name;
@endphp
{{ $assigns->description }} |
{{ $assigns->priority }} |
{{ date("d-m-Y",strtotime($assigns->target_dt)) }} |
@php
}
@endphp
@php
$i++;
}
}
if($flag == 0){
@endphp
@php
}
}else{
@endphp
No. |
Project |
Description |
Priority |
Target Date |
@php
$nm = "";
$cnt = 1;
foreach($target_pending as $assigns){
@endphp
@php
if($nm != $assigns->menu_name){
echo "".$cnt." | ";
echo "".$assigns->menu_name." | ";
$cnt++;
}else{
echo " | ";
echo " | ";
}
$nm = $assigns->menu_name;
@endphp
{{ $assigns->description }} |
{{ $assigns->priority }} |
{{ date("d-m-Y",strtotime($assigns->target_dt)) }} |
@php
}
@endphp
@php
}
@endphp