@include('headeruser')
@include('sweetalerts')

					<!--begin::Content-->
					<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
						<!--begin::Subheader-->
						<div class="subheader py-2 py-lg-4 subheader-solid" id="kt_subheader">
							<div class="container-fluid d-flex align-items-center justify-content-between flex-wrap flex-sm-nowrap">
								<!--begin::Info-->
								<div class="d-flex align-items-center flex-wrap mr-2">
									<!--begin::Page Title-->
									<h5 class="text-dark font-weight-bold mt-2 mb-2 mr-5">{{ $page }}</h5>
									<!--end::Page Title-->
									<!--begin::Actions-->
									
									<div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>
									<ul class="breadcrumb breadcrumb-transparent breadcrumb-dot font-weight-bold p-0 my-2 font-size-sm">
										<li class="breadcrumb-item text-muted">
											<a href="" class="text-muted">
												{{ $subpage }}
											</a>
										</li>
										<li class="breadcrumb-item text-muted">
											<a href="" class="text-muted">
												{{ $submenu }}
											</a>
										</li>
									</ul>
									<!--end::Actions-->
								</div>
								<!--end::Info-->
							</div>
						</div>
						<!--end::Subheader-->
						<!--begin::Entry-->
						<div class="d-flex flex-column-fluid">
							<!--begin::Container-->
							<div class="container">

                                <!--Begin::Row-->
                                <div class="row">
                                    <div class="col-xl-6">
                                        <!--begin::Stats Widget 32-->
                                        <div class="card card-custom bg-dark card-stretch gutter-b" onClick="window.location.href='#'" style="cursor: pointer;">
                                            <!--begin::Body-->
                                            <div class="card-body">
                                                <i class="fa-sharp-duotone fa-solid fa-sack-dollar fa-2x" style="color: #ffffff;"></i>
                                                <span class="card-title font-weight-bolder text-white font-size-h2 mb-0 mt-6 d-block">
                                                    <span style="display: inline-block;">RM</span>
                                                    <span style="display: inline-block;" class="counter">{{ number_format($count_total, 2, '.', ',') }}</span>
                                                </span>
                                                <span class="font-weight-bold text-white font-size-sm">JUMLAH PERUNTUKAN TAHUN {{ date('Y') }}</span>
                                            </div>
                                            <!--end::Body-->
                                        </div>
                                        <!--end::Stats Widget 32-->
                                    </div>
                                    <div class="col-xl-6">
                                        <!--begin::Stats Widget 32-->
                                        <div class="card card-custom bg-primary card-stretch gutter-b" onClick="window.location.href='#'" style="cursor: pointer;">
                                            <!--begin::Body-->
                                            <div class="card-body">
                                                <i class="fa-sharp-duotone fa-solid fa-file-invoice-dollar fa-2x" style="color: #ffffff;"></i>
                                                <span class="card-title font-weight-bolder text-white font-size-h2 mb-0 mt-6 d-block">
                                                    <span style="display: inline-block;">RM</span>
                                                    <span style="display: inline-block;" class="counter">{{ number_format($count_balance, 2, '.', ',') }}</span>
                                                </span>
                                                <span class="font-weight-bold text-white font-size-sm">JUMLAH BAKI PERUNTUKAN</span>
                                            </div>
                                            <!--end::Body-->
                                        </div>
                                        <!--end::Stats Widget 32-->
                                    </div>
                                </div>
                                <!--End::Row-->
                                
                                <!--Begin::Row-->
                                <div class="row">

                                    <div class="col-xl-4">
                                        <!--begin::Stats Widget 32-->
                                        <div class="card card-custom bg-success card-stretch gutter-b" onClick="window.location.href='#'" style="cursor: pointer;">
                                            <!--begin::Body-->
                                            <div class="card-body">
                                                <i class="fa-sharp-duotone fa-solid fa-truck-medical fa-2x" style="color: #ffffff;"></i>
                                                <span class="card-title font-weight-bolder text-white font-size-h2 mb-0 mt-6 d-block">
                                                    <span style="display: inline-block;">RM</span>
                                                    <span style="display: inline-block;" class="counter">{{ number_format($count_used_panel, 2, '.', ',') }}</span>
                                                </span>
                                                <span class="font-weight-bold text-white font-size-sm">JUMLAH BIL (PANEL)</span>
                                            </div>
                                            <!--end::Body-->
                                        </div>
                                        <!--end::Stats Widget 32-->
                                    </div>

                                    <div class="col-xl-4">
                                        <!--begin::Stats Widget 31-->
                                        <div class="card card-custom bg-warning card-stretch gutter-b" onClick="window.location.href='#'" style="cursor: pointer;">
                                            <!--begin::Body-->
                                            <div class="card-body">
                                                <i class="fa-sharp-duotone fa-solid fa-money-bill-transfer fa-2x" style="color: #ffffff;"></i>
                                                <span class="card-title font-weight-bolder text-white font-size-h2 mb-0 mt-6 d-block">
                                                    <span style="display: inline-block;">RM</span>
                                                    <span style="display: inline-block;" class="counter">{{ number_format($count_used_not_panel, 2, '.', ',') }}</span>
                                                </span>
                                                <span class="font-weight-bold text-white font-size-sm">JUMLAH BIL (BUKAN PANEL)</span>
                                            </div>
                                            <!--end::Body-->
                                        </div>
                                        <!--end::Stats Widget 31-->
                                    </div>

                                    <div class="col-xl-4">
                                        <!--begin::Stats Widget 29-->
                                        <div class="card card-custom bg-danger bgi-no-repeat card-stretch gutter-b" onClick="window.location.href='#'" style="cursor: pointer;">
                                            <!--begin::Body-->
                                            <div class="card-body">
                                                <i class="fa-sharp-duotone fa-solid fa-hand-holding-circle-dollar fa-2x" style="color: #ffffff;"></i>
                                                <span class="card-title font-weight-bolder text-white font-size-h2 mb-0 mt-6 d-block">
                                                    <span style="display: inline-block;">RM</span>
                                                    <span style="display: inline-block;" class="counter">{{ number_format($count_used, 2, '.', ',') }}</span>
                                                </span>
                                                <span class="font-weight-bold text-white font-size-sm">JUMLAH PERUNTUKAN TELAH DIGUNAKAN</span>
                                            </div>
                                            <!--end::Body-->
                                        </div>
                                        <!--end::Stats Widget 29-->
                                    </div>
                                    <!--End::Row-->

                                </div>
                                <!--End::Row-->

                                <!--begin::Card-->
                                <div class="card card-custom gutter-b">
                                    <div class="card-header">
                                        <div class="card-title">
                                            <h3 class="card-label">{{ Str::upper($submenu) }} (KLINIK PANEL)</h3>
                                        </div>
                                    </div>
									<div class="card-body">

                                        <!--begin: Datatable-->
                                        <table class="table table-separate table-head-custom table-checkable" id="kt_datatable1">
                                            <thead>
                                                <tr>
                                                    <th width="1%">Bil</th>
                                                    <th>No & Nama Pekerja</th>
                                                    <th>Hubungan</th>
                                                    <th>Nama Keluarga</th>
                                                    <th>Nama Klinik</th>
                                                    <th>Tarikh</th>
                                                    <th>Caj (RM)</th>
                                                    <th>Preskrip</th>
                                                    <th>MC</th>
                                                    <th class="text-center" width="5%">Papar</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($query_record as $data_record)

                                                <tr>
                                                    <td>{{ $loop->iteration }}</td>
                                                    <td>{!! '('.$data_record->user_no.')<br>'.$data_record->user_name !!}</td>
                                                    <td>{{ $data_record->name_relationship }}</td>
                                                    <td>
                                                        @if ($data_record->id_family != 0)
                                                            {{ $data_record->name_family }}
                                                        @else
                                                            -
                                                        @endif
                                                    </td>
                                                    <td>
                                                        {!! Str::upper('<b>'.$data_record->name_clinic.'</b><br><small>('.$data_record->add_1.' '.$data_record->add_2.' '.$data_record->add_3.' '.$data_record->name_postcode.' '.$data_record->city.' '.$data_record->name_state.')</small>') !!}
                                                    </td>
                                                    <td>{{ date('d/m/Y', strtotime($data_record->date)) }}</td>
                                                    <td>RM {{ number_format($data_record->bill, 2, '.', ',') }}</td>
                                                    <td>{{ Str::limit($data_record->prescription, 20) }}</td>
                                                    <td>
                                                        @if ($data_record->mc != NULL)
                                                            {{ $data_record->mc }}
                                                        @else
                                                            TIADA
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        <a class="btn btn-sm btn-clean btn-icon mr-0" data-toggle="modal" data-target="#update_patient_record{{ $data_record->id_transaction }}"><i class="fa-sharp-duotone fa-solid fa-eye"></i></a>
                                                    </td>
                                                </tr>

                                                <!-- Center modal content -->
                                                <div class="modal fade" id="update_patient_record{{ $data_record->id_transaction }}" tabindex="-1" role="dialog" aria-hidden="true">
                                                    <div class="modal-dialog modal-dialog-centered modal-xl">
                                                        <div class="modal-content p-2">
                                                            <div class="modal-header">
                                                                <h4 class="modal-title" id="myCenterModalLabel">PAPAR REKOD {{ Str::upper($data_record->user_name) }}</h4>
                                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                                    <i aria-hidden="true" class="ki ki-close"></i>
                                                                </button>
                                                            </div>

                                                            <div class="modal-body">
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-12">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Pekerja</b></label>
                                                                            <p>{{ Str::upper($data_record->user_name) }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                    
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div id="get_relationship" class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Hubungan</b></label>
                                                                            <p>{{ Str::upper($data_record->name_relationship) }}</p>
                                                                        </div>
                                                                    </div>
                                                                    <div id="get_family" class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Keluarga</b></label>
                                                                            <p>{{ Str::upper($data_record->name_family ?? "-") }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Klinik</b></label>
                                                                            <p>{!! Str::upper($data_record->name_clinic.'<br><small>('.$data_record->add_1.' '.$data_record->add_2.' '.$data_record->add_3.' '.$data_record->name_postcode.' '.$data_record->city.' '.$data_record->name_state.')</small>') !!}</p>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Tarikh Daftar</b></label>
                                                                            <p>{{ date('d/m/Y', strtotime($data_record->date)) }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Bil Preskrip (RM)</b></label>
                                                                            <p>RM {{ number_format($data_record->bill, 2, '.', ',') }}</p>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Bilangan MC</b></label>
                                                                            <p>{{ $data_record->mc }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-12">
                                                                        <div class="form-group">
                                                                            <label><b>Deskripsi Preskrip</b></label>
                                                                            <p>{{ $data_record->prescription }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>

                                                            </div><!-- /.modal-content -->
                                                        </div><!-- /.modal-dialog -->
                                                    </div><!-- /.modal -->
                                                </div>
                                                <!-- /.modal -->

                                                @endforeach

                                            </tbody>
                                        </table>
                                        <!--end: Datatable-->
									</div>

								</div>
                                <!--end::Card-->

                                <!--begin::Card-->
                                <div class="card card-custom gutter-b">
                                    <div class="card-header">
                                        <div class="card-title">
                                            <h3 class="card-label">{{ Str::upper($submenu) }} (BUKAN KLINIK PANEL)</h3>
                                        </div>
                                    </div>
									<div class="card-body">

                                        <!--begin: Datatable-->
                                        <table class="table table-separate table-head-custom table-checkable" id="kt_datatable_not_panel">
                                            <thead>
                                                <tr>
                                                    <th width="1%">Bil</th>
                                                    <th>No & Nama Pekerja</th>
                                                    <th>Hubungan</th>
                                                    <th>Nama Keluarga</th>
                                                    <th>Nama Klinik</th>
                                                    <th>Tarikh</th>
                                                    <th>Caj (RM)</th>
                                                    <th>Preskrip</th>
                                                    <th>MC</th>
                                                    <th class="text-center" width="5%">Papar</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($query_record_not_panel as $data_record_not_panel)

                                                <tr>
                                                    <td>{{ $loop->iteration }}</td>
                                                    <td>{!! '('.$data_record_not_panel->user_no.')<br>'.$data_record_not_panel->user_name !!}</td>
                                                    <td>{{ $data_record_not_panel->name_relationship }}</td>
                                                    <td>
                                                        @if ($data_record_not_panel->id_family != 0)
                                                            {{ $data_record_not_panel->name_family }}
                                                        @else
                                                            -
                                                        @endif
                                                    </td>
                                                    <td>
                                                        {!! Str::upper('<b>'.$data_record_not_panel->name_clinic.'</b>') !!}
                                                    </td>
                                                    <td>{{ date('d/m/Y', strtotime($data_record_not_panel->date)) }}</td>
                                                    <td>RM {{ number_format($data_record_not_panel->bill, 2, '.', ',') }}</td>
                                                    <td>{{ Str::limit($data_record_not_panel->prescription, 20) }}</td>
                                                    <td>
                                                        @if ($data_record_not_panel->mc != NULL)
                                                            {{ $data_record_not_panel->mc }}
                                                        @else
                                                            TIADA
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        <a class="btn btn-sm btn-clean btn-icon mr-0" data-toggle="modal" data-target="#update_patient_record_not_panel{{ $data_record_not_panel->id_not_panel }}"><i class="fa-sharp-duotone fa-solid fa-eye"></i></a>
                                                    </td>
                                                </tr>

                                                <!-- Center modal content -->
                                                <div class="modal fade" id="update_patient_record_not_panel{{ $data_record_not_panel->id_not_panel }}" tabindex="-1" role="dialog" aria-hidden="true">
                                                    <div class="modal-dialog modal-dialog-centered modal-xl">
                                                        <div class="modal-content p-2">
                                                            <div class="modal-header">
                                                                <h4 class="modal-title" id="myCenterModalLabel">PAPAR REKOD {{ Str::upper($data_record_not_panel->user_name) }}</h4>
                                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                                    <i aria-hidden="true" class="ki ki-close"></i>
                                                                </button>
                                                            </div>

                                                            <div class="modal-body">
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-12">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Pekerja</b></label>
                                                                            <p>{{ Str::upper($data_record_not_panel->user_name) }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                    
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div id="get_relationship" class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Hubungan</b></label>
                                                                            <p>{{ Str::upper($data_record_not_panel->name_relationship) }}</p>
                                                                        </div>
                                                                    </div>
                                                                    <div id="get_family" class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Keluarga</b></label>
                                                                            <p>{{ Str::upper($data_record_not_panel->name_family ?? "-") }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Nama Klinik</b></label>
                                                                            <p>{!! Str::upper($data_record_not_panel->name_clinic.'<br>') !!}</p>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Tarikh Daftar</b></label>
                                                                            <p>{{ date('d/m/Y', strtotime($data_record_not_panel->date)) }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Bil Preskrip (RM)</b></label>
                                                                            <p>RM {{ number_format($data_record_not_panel->bill, 2, '.', ',') }}</p>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-12 col-md-6">
                                                                        <div class="form-group">
                                                                            <label><b>Bilangan MC</b></label>
                                                                            <p>{{ $data_record_not_panel->mc }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row" style="margin-bottom: -10px;">
                                                                    <div class="col-12 col-md-12">
                                                                        <div class="form-group">
                                                                            <label><b>Deskripsi Preskrip</b></label>
                                                                            <p>{{ $data_record_not_panel->prescription }}</p>
                                                                        </div>
                                                                    </div>
                                                                </div>

                                                            </div><!-- /.modal-content -->
                                                        </div><!-- /.modal-dialog -->
                                                    </div><!-- /.modal -->
                                                </div>
                                                <!-- /.modal -->

                                                @endforeach

                                            </tbody>
                                        </table>
                                        <!--end: Datatable-->
									</div>

								</div>
                                <!--end::Card-->

							</div>
							<!--end::Container-->
							
						</div>
						<!--end::Entry-->
					</div>
                    <!--end::Content-->

                    @include('footer')