{{-- 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? --}} {{-- LUBRICANT REFILL? --}} {{-- REFILL AMOUNT --}} {{-- OIL BRAND --}} {{-- OIL REFERENCE --}} {{-- OIL WEIGHT --}} {{-- DATE TAKEN --}} {{-- DATE DELIVERED --}} {{-- DATE ANALIZED --}} {{-- CONTAINER NUMBER --}} {{-- QUANTITY ADDED --}} {{-- QUANTITY UNIT --}} {{-- SERVICE LEVEL --}} @if($additionalVariables) @endif @if($additionalVariables) @endif @foreach($tests as $test => $key) @if($key->name === 'V40C') @continue @endif @if($additionalVariables) {{-- NUEVA COLUMNA --}} @endif @endforeach @if(Auth::user()->reportType == 1) @foreach($premium_tests as $pTest) @if($additionalVariables) {{-- NUEVA --}} @endif @endforeach @endif @if (count($samples)>0) @foreach ($samples as $key => $sample) @php $isRefrigerantSample = Str::startsWith($sample->code, 'C-') || stripos($sample->fluid_type ?? '', 'refriger') !== false; $exportCause = $sample->export_cause ?? null; $causeCode = trim((string) ($exportCause['cause_code'] ?? '')); $causeText = trim((string) ($exportCause['standard_comment'] ?? '')); $consequenceCode = trim((string) ($exportCause['consequence_code'] ?? '')); $consequenceText = trim((string) ($exportCause['consequence_text'] ?? '')); @endphp {{-- 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? --}} {{-- LUBRICANT REFILL? --}} {{-- REFILL AMOUNT --}} {{-- OIL BRAND --}} {{-- OIL REFERENCE --}} {{-- OIL WEIGHT --}} {{-- CONTAINER NUMBER --}} {{-- QUANTITY ADDED --}} {{-- QUANTITY UNIT --}} {{-- SERVICE LEVEL --}} {{-- DATE TAKEN --}} {{-- DATE DELIVERED --}} {{-- DATE ANALIZED --}} @if($additionalVariables) @endif @if($additionalVariables) @endif @if (is_numeric($sample->status_report)) @else @endif @if ($isRefrigerantSample) @elseif (is_numeric($sample->wearout_condition) && is_numeric($sample->contamination_cond) && is_numeric($sample->lube_health_cond)) @else @endif @foreach($tests as $test) @if($test->name === 'V40C') @continue @endif @php $result = $sample->getSampleResultOrderBy->firstWhere('test_id', $test->id); @endphp {{-- ================== VALOR ================== --}} @if(isset($result['value'])) {{-- ================== ALERTA ================== --}} @if($additionalVariables) @endif @else {{-- SIN VALOR --}} @if($additionalVariables) @endif @endif @endforeach @if(Auth::user()->reportType == 1) @foreach($premium_tests as $pTest) @php $result = $sample->getSampleResultOrderBy->firstWhere('test_id', $pTest->id); @endphp {{-- VALOR --}} @if(isset($result['value'])) @if($additionalVariables) {{-- ALERTA --}} @endif @else @if($additionalVariables) @endif @endif @endforeach @endif @endforeach @else @endif

ID	TIPO DE FLUIDO	TIEMPO DE PROCESO	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?	LUBRICANT REFILL?	REFILL AMOUNT	OIL BRAND	OIL REFERENCE	OIL WEIGHT	DATE TAKEN	DATE DELIVERED	DATE ANALIZED	CONTAINER NUMBER	QUANTITY ADDED	QUANTITY UNIT	SERVICE LEVEL	CODIGOS COMENTARIOS	NUMERO DE PRUEBAS	GENERAL CONDITION	WEAROUR CONDITION	CONTAMINATION CONDITION	LUBE HEALTH CONDITION	{{$key->name}}	{{$key->name}} - Estado	{{$pTest->name}}	{{$pTest->name}} - Estado	COMENTARIOS STD	COMENTARIO GENERAL	COD CAUSA	COMENTARIO	COD CONSECUENCIA	CONSECUENCIAS	TEST
{{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->getComponentEquipment->serial_component ?? '---'}}	{{$sample->system_type}}	{{$sample->horometer}}	{{$sample->horometer_component}}	{{$sample->oil_time}}	{{$sample->oil_change == 'true' ? 'SI' : 'NO'}}	{{$sample->filter_change ? 'SI' : 'NO'}}	{{$sample->lubricant_refill ? 'SI' : 'NO'}}	{{$sample->lubricant_refill ? number_format($sample->refill_amount, 1) . ' gal' : '--'}}	{{$sample->oil_brand}}	{{$sample->lubricant}}	{{$sample->oil_weight}}	{{ sampleDateToExcelSerial($sample->sample_date_taken) }}	{{ sampleDateToExcelSerial($sample->sample_date_received) }}	{{ sampleDateToExcelSerial($sample->date_of_analysis) }}	{{$sample->container_number ?? '--'}}	{{$sample->quantity_added ?? '--'}}	{{$sample->quantity_unit ?? '--'}}	@if($sample->service_level_id) {{\App\ParameterValues::find($sample->service_level_id)->name ?? '--'}} @else -- @endif	{{date("m/d/Y", strtotime($sample->sample_date_taken))}}	{{date("m/d/Y", strtotime($sample->sample_date_received))}}	{{date("m/d/Y", strtotime($sample->date_of_analysis))}}	{{ $sample->comment_codes ?? '--' }}	{{ $sample->test_count ?? '--' }}	{{Config::get("constants.semaphore_excel")[$sample->status_report]['name']}}	--	--	--	--	{{Config::get("constants.semaphore_excel")[$sample->wearout_condition]['name']}}	{{Config::get("constants.semaphore_excel")[$sample->contamination_cond]['name']}}	{{Config::get("constants.semaphore_excel")[$sample->lube_health_cond]['name']}}	--	--	--	{{ $result['value'] }}	{{ Config::get('constants.semaphore_excel')[$result['condition']]['name'] ?? '' }}	--		{{ $result['value'] }}	{{ Config::get('constants.semaphore_excel')[$result['condition']]['name'] ?? '' }}	--		{{$sample->commentary}}	{{$sample->rules_message}}	{{ $causeCode !== '' ? $causeCode : '--' }}	{{ $causeText !== '' ? $causeText : '--' }}	{{ $consequenceCode !== '' ? $consequenceCode : '--' }}	{{ $consequenceText !== '' ? $consequenceText : '--' }}	@if (!$isRefrigerantSample) @foreach ($sample->getSamplesTest as $key => $test) @if ($key==0) {{$test->getTest->name}} @else {{'- ' . $test->getTest->name}} @endif @endforeach @endif
No se encontraron muestras