{{-- ID --}} @if(Auth::user()->id_role == 1) {{-- TIPO DE FLUIDO --}} {{-- TIEMPO DE PROCESO --}} @endif {{-- SAMPLE ID --}} {{-- CUSTOMERS --}} {{-- ACCOUNT --}} {{-- UNIT ID --}} {{-- UNIT MAKE --}} {{-- UNIT MODEL --}} {{-- COMPONENT LOCATION --}} {{-- COMPONENT MAKE --}} {{-- COMPONENT MODEL --}} {{-- SERIAL COMPONENT --}} {{-- SYSTEM TYPE --}} {{-- HOURS SMU --}} {{-- HOURS COMPONENT --}} {{-- HOURS OIL --}} {{-- OIL CHANGED? --}} {{-- FILTER CHANGED? --}} {{-- OIL BRAND --}} {{-- OIL REFERENCE --}} {{-- OIL WEIGHT --}} {{-- DATE TAKEN --}} {{-- DATE DELIVERED --}} {{-- DATE ANALIZED --}} @foreach($tests as $test => $key) @endforeach @if(Auth::user()->reportType == 1) @foreach($premium_tests as $pTest) @endforeach @endif @if (count($samples)>0) @foreach ($samples as $key => $sample) {{-- ID --}} @if(Auth::user()->id_role == 1) {{-- TIPO DE FLUIDO --}} @endif {{-- SAMPLE ID --}} {{-- CUSTOMER --}} {{-- ACCOUNT --}} {{-- UNIT ID --}} {{-- UNIT MAKE --}} {{-- UNIT MODEL --}} {{-- COMPONENT LOCATION --}} {{-- COMPONENT MAKE --}} {{-- COMPONENT MODEL --}} {{-- SERIAL COMPONENT --}} {{-- SYSTEM TYPE --}} {{-- HOURS SMU --}} {{-- HOURS COMPONENT --}} {{-- HOURS OIL --}} {{-- OIL CHANGED? --}} {{-- FILTER CHANGED? --}} {{-- OIL BRAND --}} {{-- OIL REFERENCE --}} {{-- OIL WEIGHT --}} @foreach($tests as $test) @if (isset($sample->getSampleResultOrderBy->firstWhere('test_id', $test->id)['value'])) @elseif(Str::startsWith($test->reference, 'CDiamIso') && $sample->getSampleResultOrderBy->firstWhere('test_id', 44)) @php $iso = $sample->getSampleResultOrderBy->firstWhere('test_id', 44); $cleanIso = str_replace('(4406) ', '', $iso['value']); $dividedIso = explode('/', $cleanIso); @endphp @switch($test->reference) @case('CDiamIsoCum4') @break @case('CDiamIsoCum6') @break @case('CDiamIsoCum14') @break @endswitch @else @endif @endforeach @if(Auth::user()->reportType == 1) @foreach($premium_tests as $pTest) @if (isset($sample->getSampleResultOrderBy->firstWhere('test_id', $pTest->id)['value'])) @else @endif @endforeach @endif @endforeach @else @endif
IDTIPO DE FLUIDOTIEMPO DE PROCESOSAMPLE IDCUSTOMERSACCOUNTUNIT IDUNIT MAKEUNIT MODELCOMPONENT LOCATIONCOMPONENT MAKECOMPONENT MODELSERIAL COMPONENTSYSTEM TYPEHOURS SMUHOURS COMPONENTHOURS OILOIL CHANGED?FILTER CHANGED?OIL BRANDOIL REFERENCEOIL WEIGHTDATE TAKENDATE DELIVEREDDATE ANALIZED{{$key->name}}{{$pTest->name}}
{{strpos($sample->code, '-') !== false ? explode("-", $sample->code)[1] : $sample->code}}{{$sample->fluid_type}}{{$sample->process_time}}#{{$sample->code}}{{$sample->customer_name}}{{$sample->account_name}}{{$sample->unit_id}}{{$sample->unit_make}}{{$sample->unit_model}}{{$sample->component_name}} @if($sample->getComponentEquipment) {{$sample->getComponentEquipment->getComponentMake->name}} @else --- @endif @if($sample->getComponentEquipment) {{$sample->getComponentEquipment->getComponentModel->name}} @else --- @endif {{$sample->system_type}}{{$sample->horometer}}{{$sample->horometer_component}}{{$sample->oil_time}}{{$sample->oil_change == 'true' ? 'SI' : 'NO'}}{{$sample->filter_change ? 'SI' : 'NO'}}{{$sample->oil_brand}}{{$sample->lubricant}}{{$sample->oil_weight}}{{ sampleDateToExcelSerial($sample->sample_date_taken) }} {{ sampleDateToExcelSerial($sample->sample_date_received) }} {{ sampleDateToExcelSerial($sample->date_of_analysis) }} {{ $sample->getSampleResultOrderBy->firstWhere('test_id', $test->id)['value'] }} {{ $dividedIso[0] ?? '' }}{{ $dividedIso[1] ?? '' }}{{ $dividedIso[2] ?? '' }}-- {{ $sample->getSampleResultOrderBy->firstWhere('test_id', $pTest->id)['value'] }} --
No se encontraron muestras