Status Detail

@foreach ($tb_scope_operation as $tco) @endforeach

Name / Type	Model / SN	Company	Location	User	Tag time (Elapsed)
{{$tco->scope_name}} {{$tco->scope_type}}	{{$tco->scope_model}} {{$tco->scope_serial}}	{{$tco->scope_band}}	{{$tco->room_name}}	{{$tco->name}}	{{$tco->track_date}} {{$tco->track_time}}

@foreach ($tb_scope_reprocess as $tcr) @endforeach

Name / Type	Model / SN	Company	User	Reprocess status / Time split (min.)
{{$tco->scope_name}} {{$tco->scope_type}}	{{$tco->scope_model}} {{$tco->scope_serial}}	{{$tco->scope_band}}	{{$tco->name}}	{{$data->track_station}} {{$tco->track_time}}	{{$data->track_station}}

{{-- @foreach ($tb_scope_available as $tca) @endforeach --}} @foreach ($tb_scope_available as $data) @php $w[0] = array('track_process','storage'); $w[1] = array('track_status',0); $w[2] = array('track_serial',$data->scope_serial); $track = DB::table('tb_casetrack')->where($w)->first(); if($track!=null){ $user = DB::table('users')->where('id',$track->track_user)->first(); $station = DB::table('tb_room')->where('room_id',$track->track_station)->first(); }else{ $user = null; $station = null; } @endphp @endforeach {{-- --}}

Name / Type	Model / SN	Company	User	Location	Storage time
{{$tco->scope_name}}	{{$tco->scope_model}} {{$tco->scope_serial}}	{{$tco->scope_band}}	{{$tco->name}}	{{$tco->name}}	Preparation 08/05/2022 08:35
{{$data->scope_name}} {{@$data->scope_type}}	{{$data->scope_model}} {{$data->scope_serial}}	{{$data->scope_band}}	{{@$user->user_prefix}}{{@$user->user_firstname}} {{@$user->user_lastname}}	{{@$station->room_name}}	{{@$track->track_date}} {{@$track->track_time}}
C01 Colonoscope	CF-HQ190L 1234567890	Olympus	คุณสมเจษ มหามงคล	Room1	Preparation 08/05/2022 08:35

@foreach($tb_scope_repair as $data) @endforeach {{-- --}}

Name / Type	Model / SN	Company	User	Broken date	Bringback date	Storage time
{{$data->scope_name}} {{$data->scope_type}}	{{$data->scope_model}} {{$data->scope_serial}}	{{$data->scope_band}}		{{$data->sr_broken_date}}	{{$data->sr_bringback_date}}	Repairing 08/05/2022 08:35
G01 Gastroscope	GIF-HQ190 1234567890	Olympus	คุณสดายุ ทองลอย	01/05/2022	01/05/2022	Repairing 08/05/2022 08:35
C01 Colonoscope	CF-HQ190L 1234567890	Olympus	คุณสมเจษ มหามงคล	01/05/2022	01/05/2022	Invoice 08/05/2022 08:35

@endsection @section('script') @endsection