@php
    $w[0] = array('billing_hn',$_GET['hn']);
    $w[1] = array('billing_date',$_GET['date']);
    $tb_casebilling = DB::table('tb_casebilling')->where($w)->first();
@endphp

@if($tb_casebilling!=null)

    @php
        $d = DB::table('users')->where('user_code',$tb_casebilling->billing_doctor)->first();
        $doctorname = $d->user_prefix.$d->user_firstname." ".$d->user_lastname;

        $p = DB::table('patient')->where('hn',$tb_casebilling->billing_hn)->first();
        $patientname =  $p->prefix.$p->firstname." ".$p->lastname;

    @endphp




<div class="card">
    <div class="card-body" style="padding: 1em;background-color:lightblue">
        <div class="row">
            <div id="hiddenclick" class="col-2" style="font-size: 2vh">Department</div>  <div class="col-10">{{$tb_casebilling->billing_department}}</div>
            <div class="col-2" style="font-size: 2vh">H.N.</div>        <div class="col-10">{{$tb_casebilling->billing_hn}}</div>
            <div class="col-2" style="font-size: 2vh">Patient</div>     <div class="col-10">{{$patientname}}</div>
            <div class="col-2" style="font-size: 2vh">Doctor</div>      <div class="col-10">{{$doctorname}}</div>
            <div class="col-2" style="font-size: 2vh">Time use</div>    <div class="col-10">{{$tb_casebilling->billing_timeuse}}</div>

            <div class="col-12">
                <button id="step01" class="btn btn-success btn-block">Start</button>
            </div>

            {{-- <div class="col-3">
                <button id="step02" class="btn btn-warning btn-block">ICD9</button>
            </div>

            <div class="col-3">
                <button id="step03" class="btn btn-info btn-block">ICD10</button>
            </div>

            <div class="col-3">
                <button id="step04" class="btn btn-danger btn-block">Confirm</button>
            </div> --}}

        </div>
    </div>
</div>
<br>
@endif


<div class="card">
    <div class="card-body" style="padding: 1em;">

        @php
            // dd($case_data);

            $doctor = DB::table('users')->where('id',$case_data[0]->case_physicians01)->first();

            if($doctor->user_branch=="" || $doctor->user_branch=="GI"){$gi = "checked";}
            if($doctor->user_branch=="GIP"){$gip = "checked";}
            if($doctor->user_branch=="GIS"){$gis = "checked";}

            if($doctor!=null){
                $doctorcode = $doctor->user_code;
            }else{
                $doctorcode = "have_no_doctor";
            }
        @endphp

        <form action="{{url('billhomc')}}" method="post">

            @csrf
            <input name="event" value="createbilling" type="hidden">
            <input name="hn" value="{{$_GET['hn']}}" type="hidden">
            <input name="doctorcode" value="{{$doctorcode}}" type="hidden">
            <input name="date" value="{{$_GET['date']}}" type="hidden">

        <div class="row m-0 mt-5">
                <div class="col-12">
                    <div class="row m-0">
                        <div class="col-12 p-2">
                            <h1>Billing</h1>
                        </div>
                        <div class="col-4 p-2">
                            <input type="radio" id="med" name="department" value="GI" {{@$gi}}>
                            <label for="med" class="m-0">MED[GI]</label>
                        </div>
                        <div class="col-4 p-2">
                            <input type="radio" id="sur" name="department" value="GIS" {{@$gis}}>
                            <label for="sur" class="m-0">SUR[GIS]</label>
                        </div>
                        <div class="col-4 p-2">
                            <input type="radio" id="ped" name="department" value="GIP" {{@$gip}}>
                            <label for="ped" class="m-0">PED[GIP]</label>
                        </div>
                    </div>
                </div>

                @php
                    $icd9num=0;
                @endphp


                @foreach ($case_data as $data)
                    @php
                        $json   = jsonDecode($data->case_json);
                        $icd10 = array();
                        if(isset($json->diagnostic)){
                            $dataicd10  = jsonDecode($json->diagnostic);
                            $i = 0;
                            foreach($dataicd10 as $row){
                                $tb_diagnostic = DB::table('tb_diagnostic')
                                ->where('procedure_code',$data->case_procedure)
                                ->where('diagnostic_name',$row)
                                ->first();
                                if($tb_diagnostic!=null){
                                    $icd10[$i]['name'] = $tb_diagnostic->diagnostic_name;
                                    $icd10[$i]['code'] = $tb_diagnostic->icd10;
                                    $i++;
                                }
                            }
                        }else{
                            $tb_diagnostic = DB::table('tb_diagnostic')
                            ->where('procedure_code',$data->case_procedure)
                            ->where('diagnostic_name',$json->procedurename)
                            ->first();
                            if($tb_diagnostic!=null){
                                $icd10[0]['name'] = $tb_diagnostic->diagnostic_name;
                                $icd10[0]['code'] = $tb_diagnostic->icd10;
                            }else{
                                $icd10[0]['name'] = "No ICD10";
                                $icd10[0]['code'] = "0000";
                            }
                        }


                        $icd9 = array();
                        if(isset($json->proicd9)){
                            $dataicd9   = jsonDecode($json->proicd9);
                            $i = 0;
                            $count = count($dataicd9);
                            // dd($dataicd9);

                            foreach($dataicd9 as $row){

                                if($row==""){
                                    $tb_procedureicd9 = DB::table('tb_procedureicd9')
                                    ->where('procedure_code',$data->case_procedure)
                                    ->where('proicd9_name',$json->procedurename)
                                    ->first();
                                    if($tb_procedureicd9!=null){
                                        $icd9[0]['name']    = $tb_procedureicd9->icd9_billname;
                                        $icd9[0]['code']    = $tb_procedureicd9->icd9;
                                        $icd9[0]['price']   = $tb_procedureicd9->icd9_billprice;
                                    }else{
                                        $icd9[0]['name'] = "No ICD9";
                                        $icd9[0]['code'] = "0000";
                                        $icd9[0]['price'] = 0;
                                    }
                                }else{
                                    $tb_procedureicd9 = DB::table('tb_procedureicd9')
                                    ->where('procedure_code',$data->case_procedure)
                                    ->where('proicd9_name',$row)
                                    ->first();
                                    if($tb_procedureicd9!=null){
                                        $icd9[$i]['name']   = $tb_procedureicd9->icd9_billname;
                                        $icd9[$i]['code']   = $tb_procedureicd9->icd9;
                                        $icd9[$i]['price']  = $tb_procedureicd9->icd9_billprice;
                                        $i++;
                                    }
                                }
                            }





                        }else{
                            $tb_procedureicd9 = DB::table('tb_procedureicd9')
                            ->where('procedure_code',$data->case_procedure)
                            ->where('proicd9_name',$json->procedurename)
                            ->first();
                            if($tb_procedureicd9!=null){
                                $icd9[0]['name']    = $tb_procedureicd9->icd9_billname;
                                $icd9[0]['code']    = $tb_procedureicd9->icd9;
                                $icd9[0]['price']   = $tb_procedureicd9->icd9_billprice;
                            }else{
                                $icd9[0]['name'] = "No ICD9";
                                $icd9[0]['code'] = "0000";
                                $icd9[0]['price'] = 0;
                            }
                        }

                        if(isset($json->time_start) && isset($json->time_finish)){
                            $start  = new Carbon\carbon($json->time_start);
                            $end    = new Carbon\carbon($json->time_finish);

                            $totalDuration = $start->diffInMinutes($end)+10;
                        }else{
                            $totalDuration = 20;
                        }

                    @endphp
                    <div class="col-12 p-5 mt-5 border border-secondary rounded">
                        <div class="row m-0">
                            <div class="col-6"><b>PROCEDURE :</b>  {{$json->procedurename}}</div>
                            <div class="col-6"><b>DOCTOR :</b>  {{$json->doctorname}}</div>
                            <input name="time[]" value="{{$totalDuration}}" type="hidden">
                            <input name="doctorname" value="{{$json->doctorname}}" type="hidden">
                        </div>
                        <div class="row m-0 mt-2">
                            <table class="table table-striped">
                                <thead class="table-secondary">
                                    <tr>
                                        <th colspan="5" class="text-center h3">ICD10</th>
                                    </tr>
                                    <tr>
                                        <th>code</th>
                                        <th>Name</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($icd10 as $data10)
                                    <input name="icd10code[]" value="{{$data10['code']}}" type="hidden">
                                    <tr>
                                        <td>{{$data10['code']}}</td>
                                        <td>{{$data10['name']}}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>

                        <hr>

                        <table class="table table-striped">
                            <thead class="table-secondary">
                                <tr>
                                    <th colspan="5" class="text-center h3">ICD9</th>
                                </tr>
                                <tr>
                                    <th>#</th>
                                    <th>code</th>
                                    <th>Name</th>
                                    <th>Price</th>
                                    <th>Discount</th>
                                    {{-- <th>Cancel</th> --}}
                                </tr>
                            </thead>
                            <tbody>

                                @php
                                    $discount=0;
                                    //sort array2dimention
                                    array_multisort(array_map(function($element){return $element['price'];},$icd9),SORT_DESC,$icd9);
                                @endphp






                                @foreach ($icd9 as $data9)
                                    <tr>
                                        <td><input type="checkbox" name="icd9id[]" value="{{$icd9num}}" checked></td>
                                        <td>{{$data9['code']}}<font class="depart">GI</font></td>
                                        <td>{{$data9['name']}}</td>
                                        <td>{{$data9['price']}}</td>
                                        <td>
                                            <input name="icd9code[]" value="{{$data9['code']}}" type="hidden">
                                            <select name="discount[]">
                                                <option value="0" {{$discount==0?"selected":""}}>0</option>
                                                <option value="25">25</option>
                                                <option value="50">50</option>
                                                <option value="75">75</option>
                                                {{-- <option value="75"{{$discount==75?"selected":""}}>75</option> --}}
                                                <option value="100">100</option>
                                            </select>
                                         %</td>
                                        {{-- <td><input type="checkbox"></td> --}}
                                    </tr>
                                    {{-- @php($discount=75) --}}
                                    @php($icd9num++)
                                @endforeach


                                @isset($json->rapid)
                                    @if($json->rapid!=null)
                                    <tr>
                                        <td><input type="checkbox" name="icd9id[]" value="{{$icd9num}}" checked></td>
                                        <td>45161<font class="depart">GI</font></td>
                                        <td>G Biospy CLO test</td>
                                        <td>2000</td>
                                        <td>
                                            <input name="icd9code[]" value="45161" type="hidden">
                                            <select name="discount[]">
                                                <option value="0" selected>0</option>
                                            </select>
                                        %</td>
                                    </tr>
                                    @php($icd9num++)
                                    @endif
                                @endisset




                            </tbody>
                        </table>

                    </div>
                @endforeach

            </div>
            <div class="row m-0 mt-5 mb-5">
                <div class="col-12"><button class="btn btn-warning btn-block">บันทึก</button></div>

                {{-- <div class="col-4"><a id="step01" class="btn btn-success btn-block">ลงข้อมูล</a></div>
                <div class="col-4"><a id="step02" class="btn btn-primary btn-block">ลงข้อมูล</a></div>
                <div class="col-4"><a id="step03" class="btn btn-info btn-block">ลงข้อมูล</a></div> --}}
            </div>
        </form>
    </div>
</div>