@foreach($survey_data as $item) @php $beneficairy_details=json_decode($item->beneficiary_details); $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( ($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' }} @if($item->certification==1) Click To Certify @else Click To Non Certify @endif {{$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