@foreach($survey_data as $item) @php $beneficairy_details=json_decode($item->beneficiary_details); $authenticate_user_uc=json_decode(Auth::user()->uc_id); $form_status=\DB::table('form_status')->where('form_id',$item->survey_form_id)->where('update_by','PSIA')->first(); $seniorpost=\DB::table('form_status')->where('form_id',$item->survey_form_id)->where('update_by','HRU_Main')->first(); $junior=form_status($item->survey_form_id,'HRU'); $show_data=true; if($seniorpost){ if($seniorpost->form_status=='R'){ $show_data=false; } if(isset($junior) && $junior->form_status=='A' ){ $show_data=true; } } @endphp @if( ($show_data) && ($item->user_status=='26' || $item->user_status=='51' || $item->team_member_status=='HRU') && ($form_status==null || $form_status->form_status=='P')) {{$beneficairy_details->b_reference_number}} {{$beneficairy_details->beneficiary_name}} {{$beneficairy_details->cnic}} {{$beneficairy_details->father_name}} {{$item->form_name}} {{$item->lot_name ?? 'not available'}} {{$item->district_name ?? 'not available'}} {{$item->tehsil_name ?? 'not available'}} {{$item->uc_name ?? 'not available'}} {{$seniorpost ? ($seniorpost->form_status == 'A' ? 'approved' : ($seniorpost->form_status == 'R' ? 'rejected' : ($seniorpost->form_status == 'H' ? 'currently hold': 'pending' ) )):'not available' }} {{$item->generated_id}} {{$item->submission_date}} View Detail @endif @endforeach {{-- @foreach($certification as $item) @php $beneficairy_details=json_decode($item->beneficiary_details); $authenticate_user_uc=json_decode(Auth::user()->uc_id); $form_status=\DB::table('form_status')->where('form_id',$item->survey_form_id)->where('update_by','PSIA')->first(); $seniorpost=\DB::table('form_status')->where('form_id',$item->survey_form_id)->where('update_by','HRU_Main')->first(); @endphp @if(in_array($item->uc_id,$authenticate_user_uc) && ($item->user_status=='26' || $item->user_status=='51' || $item->team_member_status=='HRU') && ($form_status==null || $form_status->form_status=='P')) {{$beneficairy_details->b_reference_number}} {{$beneficairy_details->beneficiary_name}} {{$beneficairy_details->cnic}} {{$beneficairy_details->father_name}} {{$item->form_name}} {{$item->lot_name ?? 'not available'}} {{$item->district_name ?? 'not available'}} {{$item->tehsil_name ?? 'not available'}} {{$item->uc_name ?? 'not available'}} {{$seniorpost ? ($seniorpost->form_status == 'A' ? 'approved' : ($seniorpost->form_status == 'R' ? 'rejected' : ($seniorpost->form_status == 'H' ? 'currently hold': 'pending' ) )):'not available' }} {{$item->generated_id}} {{$item->submission_date}} View Detail @endif @endforeach --}} {{-- @foreach($non_certification as $item) @php $beneficairy_details=json_decode($item->beneficiary_details); $authenticate_user_uc=json_decode(Auth::user()->uc_id); $form_status=\DB::table('form_status')->where('form_id',$item->survey_form_id)->where('update_by','PSIA')->first(); $seniorpost=\DB::table('form_status')->where('form_id',$item->survey_form_id)->where('update_by','HRU_Main')->first(); @endphp @if(in_array($item->uc_id,$authenticate_user_uc) && ($item->user_status=='26' || $item->user_status=='51' || $item->team_member_status=='HRU') && ($form_status==null || $form_status->form_status=='P')) {{$beneficairy_details->b_reference_number}} {{$beneficairy_details->beneficiary_name}} {{$beneficairy_details->cnic}} {{$beneficairy_details->father_name}} {{$item->form_name}} {{$item->lot_name ?? 'not available'}} {{$item->district_name ?? 'not available'}} {{$item->tehsil_name ?? 'not available'}} {{$item->uc_name ?? 'not available'}} {{$seniorpost ? ($seniorpost->form_status == 'A' ? 'approved' : ($seniorpost->form_status == 'R' ? 'rejected' : ($seniorpost->form_status == 'H' ? 'currently hold': 'pending' ) )):'not available' }} {{$item->generated_id}} {{$item->submission_date}} View Detail @endif @endforeach --}}