Applications List

@if(!empty($newData)) @foreach($newData->sortBy(function ($resfrist) { $first_serv = $resfrist->paid_applicantsnw->first(); $con_nri_de = $first_serv->cof_nri_detail; if ($con_nri_de && $con_nri_de->application_status == "final_closed") return 2; return 1; }) as $resfrist) @php $first_serv = $resfrist->paid_applicantsnw->first(); $con_nri_de = $first_serv->cof_nri_detail; $addonIds = $first_serv->addons_ids ? explode(',', $first_serv->addons_ids) : []; $addons = \App\Models\ServiceAddonCombo::whereIn('id', $addonIds)->pluck('addon_id')->toArray(); $statusLabels = [ 'doc_under_review' => 'Document Under Review', 'doc_recieved_under_review' => 'Document Received Under Review', 'missing_docs' => 'Missing Documents', 'apostille_pending' => 'Apostille Pending', 'form_fill' => 'Form Fill', 'review_pending' => 'Review Pending', 'notery_govtfee_pending' => 'Notary And Govt Fee Pending', 'app_closed' => 'Application Closed', 'review_rating_pending' => 'User Reviews Pending', 'final_closed' => 'Fully Closed', ]; $currentStatus = $con_nri_de->application_status ?? null; $docs_id = \App\Models\ReasonRelatedData::where('reason_id',$first_serv->service->doc_pro_id) ->whereIn('type',['document','doc_cat']) ->select('after_checkout_docs','document_ids') ->first(); $docIds1 = $docs_id && $docs_id->after_checkout_docs ? explode(',', $docs_id->after_checkout_docs) : ($docs_id ? explode(',', $docs_id->document_ids) : []); $docIds2 = $con_nri_de && $con_nri_de->additional_docs ? json_decode($con_nri_de->additional_docs, true) : []; $mergedDocIds = array_unique(array_merge($docIds1, $docIds2)); $is_err = 0; foreach ($mergedDocIds as $rr) { if (\App\Models\CkReasonDocument::where('nir_applicantid',$first_serv->nri_applicate_id)->where('document_id',$rr)->exists()) { $is_err = 1; break; } } config(['app.debug' => true]); @endphp @if(!isset($filter) && ($con_nri_de->application_status == "final_closed" or $con_nri_de->application_status == "app_closed" or $con_nri_de->application_status == "review_rating_pending")) @continue @endif @if((isset($filter) && $filter == "userpending" && !$currentStatus && $is_err != 0) or (isset($filter) && $filter == "bdpending" && !$currentStatus && $is_err == 0)) @continue; @endif {{----}} {{----}} @php $toMail = $resfrist->email ; $count = \App\Models\ZohoMail::where('from_address', $toMail)->orwhere('to_address', $toMail)->get()->count(); @endphp @php $reason_docIds = App\Models\ReasonRelatedData::where('id',$resfrist->doc_cat_id)->select('after_checkout_docs')->first(); if(empty($reason_docIds)){ $services = App\Models\Service::where('id',$resfrist->reason_id)->select('id','doc_pro_id')->first(); $reason_docIds = App\Models\ReasonRelatedData::where('reason_id',$services->doc_pro_id)->whereIn('type',['doc_cat','document'])->select('after_checkout_docs')->first(); } $reason_docIdsdata = collect(); $docIds = json_decode(optional($resfrist->cof_nri_detail)->additional_docs, true) ?? []; $allDocIds = []; if (!empty($reason_docIds) && !empty($reason_docIds->after_checkout_docs)) { $afterCheckoutIds = explode(',', $reason_docIds->after_checkout_docs); $allDocIds = array_merge($afterCheckoutIds, $docIds); } else { $allDocIds = $docIds; } $allDocIds = array_filter(array_unique($allDocIds)); if(!empty($reason_docIds)){ $reason_docIdsdata = App\Models\ReasonRelatedDocument::whereIn('id',$allDocIds)->select('id','name')->get(); } $uploadedDocuments = App\Models\CkReasonDocument::where('nir_applicantid', $resfrist->nri_applicate_id)->get()->groupBy('document_id')->toArray(); @endphp @if($reason_docIdsdata->isNotEmpty()) @foreach($reason_docIdsdata as $key => $docData) @php $docTypeId = $docData->id; $frontDocs = $uploadedDocuments[$docTypeId] ?? []; $docStatus = $frontDocs[0]['status'] ?? null; if($docStatus == "reject"){ dd('test'); $hasRejected == true; break; } $doc_reject_by = $frontDocs[0]['rejected_by'] ?? null; @endphp @endforeach @endif @endforeach @endif

	App ID	input	User Name	Email/Phone	Services Name	Application Stage	Date of Submission	User DB Link	Email Counts	Refund	Has REjected DOc	Forms
	#{{ $resfrist->unique_id }}	@csrf Save	{{ $first_serv->appli_nm }}	{{ $resfrist->email }} / {{ $resfrist->mobile_number }}	@if(isset($resfrist->service)) ( @if($resfrist->service->slug == "oci-card" && $resfrist->adult_status == "minor") Minor OCI Card Application @else {{ $resfrist->service->menu_title }} @endif ) @endif	{{ $resfrist->adult_status }}	@if($currentStatus) {{ $statusLabels[$currentStatus] ?? ucfirst(str_replace('_',' ',$currentStatus)) }} @else @if($is_err == 0) Pending at User @else Document Under Review @endif @endif	{{ \Carbon\Carbon::parse($resfrist->payment_dt ?? $resfrist->updated_at)->timezone('Asia/Kolkata')->format('d M Y, h:i A') }}	@if(in_array(15, $addons)) @endif Paid		{{ $count??0 }}		@if(isset($hasRejected) && $hasRejected == true) rejected @endif	View