@extends('layouts.queue_layout')
@section('title', 'EndoINDEX')
@section('content')

@php
    $today = array('case_dateregister','like',date("Y-m-d").'%');
    $queue_status = array('case_status_queue',0);
    $case_cancel = array('case_status','!=',90);
    $case   = DB::table('tb_case')
    ->join('patient', 'tb_case.case_hn', '=', 'patient.hn')
    ->where([
        $today,
    $case_cancel])
    ->orderBy('case_id', 'desc')
    ->get();
    $count_today = DB::table('tb_case')
    ->where([$today,$case_cancel])
    ->count();
    $status = array('case_status_queue',0);
    $count_regis = DB::table('tb_case')
    ->where([$today,$queue_status])
    ->count();

    $status = array('case_status_queue',1);
    $count_operation = DB::table('tb_case')
    ->where([$today,$queue_status])
    ->count();

    $status = array('case_status_queue',2);
    $count_finish = DB::table('tb_case')
    ->where([$today,$queue_status])
    ->count();
    $queue_status = array('case_status_queue',1);
    $count_home = DB::table('tb_case')
    ->where([$today,$queue_status])
    ->count();
@endphp






	<style>
	canvas {
		-moz-user-select: none;
		-webkit-user-select: none;
		-ms-user-select: none;
	}
	</style>
<div class="row" style="margin: 0;">

	<div class="col-3" >
        <div class="card card-custom wave wave-animate-fast wave-primary">
            <div class="card-body" style="padding: 0;">
                <div class="d-flex align-items-center p-5" style="justify-content: center;">
                    <div class="d-flex flex-column">
                            <a href="#" class="text-dark text-hover-primary font-weight-bold font-size-h4 mb-3">
                                คนไข้ทั้งหมดวันนี้
                            </a>
                        <div class="text-dark font-size-h3 text-center">
                            {{$count_today}}
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-9">
        <div class="row">
            <div class="col-3">
                <div class="card card-custom wave wave-animate-fast wave-warning">
                    <div class="card-body" style="padding: 0;">
                        <div class="d-flex align-items-center p-5" style="justify-content: center;">
                            <div class="d-flex flex-column">
                                    <a href="#" class="text-dark text-hover-primary font-weight-bold font-size-h4 mb-3">
                                        รอส่องกล้อง
                                    </a>
                                <div class="text-dark font-size-h3 text-center">
                                    {{$count_regis}}
                                </div>
                            </div>
                        </div>
                    </div>
               </div>
            </div>

            <div class="col-3">
                <div class="card card-custom wave wave-animate-fast" style="background-color: #c6cf6431 !important;">
                    <div class="card-body" style="padding: 0;">
                        <div class="d-flex align-items-center p-5" style="justify-content: center;">
                            <div class="d-flex flex-column">
                                    <a href="#" class="text-dark text-hover-primary font-weight-bold font-size-h4 mb-3">
                                        ระหว่างส่อง
                                    </a>
                                <div class="text-dark font-size-h3 text-center">
                                    {{$count_operation}}
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-3">
                <div class="card card-custom wave wave-animate-fast wave-success">
                    <div class="card-body" style="padding: 0;">
                        <div class="d-flex align-items-center p-5" style="justify-content: center;">
                            <div class="d-flex flex-column">
                                    <a href="#" class="text-dark text-hover-primary font-weight-bold font-size-h4 mb-3">
                                        พักฟื้น
                                    </a>
                                <div class="text-dark font-size-h3 text-center">
                                    {{$count_finish}}
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-3">
                <div class="card card-custom wave wave-animate-fast wave-dark">
                    <div class="card-body" style="padding: 0;">
                        <div class="d-flex align-items-center p-5" style="justify-content: center;">
                            <div class="d-flex flex-column">
                                    <a href="#" class="text-dark text-hover-primary font-weight-bold font-size-h4 mb-3">
                                        กลับบ้าน
                                    </a>
                                <div class="text-dark font-size-h3 text-center">
                                    {{$count_home}}
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

</div>

<div class="row" style="margin:0;margin-top: 1em;">
	<div class="col-12">
        <div class="card">
            <div class="card-body">
                <table id="tech-companies-1" class="table table-striped">
                    <thead>
                        <tr>
                            <th width="100">    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Status    </th>
                            <th width="100" class="thid">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID</th>
                            <th>HN</th>
                            <th>Patient Name</th>
                            <th class="thage">Age</th>
                            <th>Procedure</th>
                            <th>Room</th>
                            <th>Date</th>
                            <th style="text-align: center;">กลับบ้าน/ward</th>
                            <th style="text-align: center;">พักฟื้น</th>
                            <th width="100" style="text-align: center;">Select </th>
                            <th class="thcapture" width="100" style="text-align: center;">QR</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($case as $l)
                            @php
                                $json = jsonDecode($l->case_json);

                            @endphp

                            <tr>
                                @php
                                    $aname = str_replace(" ","_",@$l->name);
                                    $status="Registered";
                                    if($l->case_status==0){$status=" Registered ";  $color="#f7881f";}
                                    if($l->case_status==1){$status=" Operation ";   $color="#c4d03c";}
                                    if($l->case_status==2){$status=" Finished ";    $color="#16b99c";}
                                @endphp
                                <td><div style='background-color:{{@$color}}'align="center">{{$status}}</div></td>
                                <th class="thid">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $l->case_id }}</th>
                                <th>{{ $l->hn }}</th>
                                <th><a href="loadpic?patient_id={{$l->patient_id}}&case_id={{ $l->case_id }}" >{{ $l->firstname." ".$l->lastname }}</a></th>
                                <td class="thage">{{age($l->birthdate)}}</td>
                                <td>{{ $json->procedurename }}</td>
                                <td>{{ $l->case_room}}@if($l->case_room=="")-@endif</td>
                                @php    $datemeet = substr($l->case_dateappointment, 0,-8);    @endphp
                                <td>{{ $datemeet }}</td>
                                <td style="text-align: center;">
                                    <form action="{{url('qqr')}}/{{$l->hn}}" method="post">
                                        @csrf
                                        @method('DELETE')
                                        <input type="hidden" name="case_id" value="{{$l->case_id}}">
                                        <button type="submit" class="btn btn-icon waves-effect waves-light btn-danger">
                                            <i class="fas fa-home"></i> <i class="fas fa-undo-alt"></i>
                                        </button>
                                    </form>

                                </td>
                                <td align="center">
                                    <form action="{{url('qqr')}}/{{$l->hn}}" method="post">
                                        @csrf
                                        @method('DELETE')
                                        <input type="hidden" name="case_id" value="{{$l->case_id}}">
                                        <input type="hidden" name="heal" value="true">
                                        <button type="submit" class="btn btn-icon waves-effect waves-light btn-warning">
                                            <i class="fas fa-undo-alt"></i>
                                        </button>
                                    </form>
                                </td>
                                <td style="text-align: center;"><a href="loadpic?patient_id={{$l->patient_id}}&case_id={{ $l->case_id }}" class="btn btn-icon waves-effect waves-light btn-info"> <i class="fa dripicons-folder-open"></i></a></td>
                                <td class="thcapture" style="text-align: center;"><a href="{{url('')}}/qrcode?hn={{ $l->hn }}&case_id={{$l->case_id}}" class="btn btn-icon waves-effect waves-light btn-success"> <i class="fa dripicons-camera"></i></a></td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="12">No data!!! </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>

            </div>
        </div>
    </div>
</div>



@endsection


@section('script')

<script>
    setInterval(function(){

        $.post("{{url('')}}/photomove",
        {
            event : 'checkconnect',
            value : '',
        },
        function(data,status){
            if(data=="true"){
                location.reload();
            }
        });

    }, 30000);
</script>

@endsection