@php
if($ddl_project == 0){
@endphp
@php
$i=1;
foreach($project_pending as $ppending){
@endphp
No. |
Name |
Module |
Description |
Priority |
Target Date |
@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 "".$cnt." | ";
echo "".$assigns->name." | ";
$cnt++;
}else{
echo " | ";
echo " | ";
}
$nm = $assigns->name;
@endphp
{{ $assigns->project }} |
{{ $assigns->description }} |
{{ $assigns->priority }} |
{{ date("d-m-Y",strtotime($assigns->target_dt)) }}
{{ $prev_target_date }}
|
@php
}
@endphp
@php
$i++;
}
@endphp
@php
}else{
@endphp
No. |
Name |
Module |
Description |
Priority |
Target Date |
@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 "".$cnt." | ";
echo "".$assigns->name." | ";
$cnt++;
}else{
echo " | ";
echo " | ";
}
$nm = $assigns->name;
@endphp
{{ $assigns->project }} |
{{ $assigns->description }} |
{{ $assigns->priority }} |
{{ date("d-m-Y",strtotime($assigns->target_dt)) }}
{{ $prev_target_date }}
|
@php
}
@endphp
@php
}
@endphp
@push('scripts')
@endpush