@extends('layouts.admin.app') @section('content')
| Sr.No | Region | CAS No | EC No | CAS Name | SIP | JSF | SIEF | COST Request | COST Finalize | @php $i = 1 @endphp @foreach($data as $key => $n)
|---|---|---|---|---|---|---|---|---|---|
| {{$i++}} | {{$n->Region->name}} | {{$n->cas_no}} | {{$n->ec_no}} | {{$n->cas_name}} | @if($n->sip == 'sip') @if($n->pdf_flag == 'true' && $n->sip_pdf != null) Pdf @elseif($n->pdf_flag == 'true' && $n->type == 'pdf') @php $pdfdata = DB::table('sip_pdf')->where([['cas_no', $n->cas_no], ['region_id', $n->region_id]])->first(); @endphp Pdf @else @php $datasip = DB::table('sip')->where('uuid',$n->uuid)->where('cas_no', $n->cas_no)->where('region_id', $n->region_id)->first(); @endphp Pdf @endif @endif | @if($n->jsf == 'jsf') @if($n->pdf_flag == 'true' && $n->jsf_pdf != null) Pdf @else @php $datajsf = DB::table('jsf')->where('uuid',$n->uuid)->where('cas_no', $n->cas_no)->where('region_id', $n->region_id)->first(); @endphp Pdf @endif @endif | @if($n->sief == 'sief1' && $n->sief_pdf != null) @if($n->pdf_flag == 'true') Pdf @else @php $datasief = DB::table('siff')->where('company_id', $n->id)->first(); @endphp Pdf @endif @elseif($n->sief == 'sief3' && $n->requestsief == 'Show') @php $datasief = DB::table('siff')->where('company_id', $n->id)->first(); @endphp Pdf @endif | {{$n->requestcost}} | {{$n->cost}} |