@extends(\Auth::user()->role != 10 ? 'layout' : 'layoutfrontdesk')

@section('title', 'Daily Revenue Report')

@section('css')
<style type="text/css">
	.datatable-column-width{
		overflow: hidden; text-overflow: ellipsis; max-width: 200px;
	}

    /* .tebal {
        font-weight:bold;
        font-size:12px;
        background-color: #f2f2f2;
        border-top:1px solid black !important;
        border-bottom:1px solid black !important;
    } */
</style>
@endsection

@section('content')

	<!-- Page header -->
	<div class="page-header page-header-light">
		<div class="page-header-content header-elements-md-inline">
			<div class="page-title d-flex">
				<h4>  <span class="font-weight-semibold">Home</span> - Data Daily Revenue Report</h4>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>
            <span class="float-right p-1 ">
                <form action="{{route('daily-revenue-report.cetak')}}" target="_blank" class="m-1">
                    <input type="hidden" name="tanggal" id="hTanggal">
                    <button id="btn_cetak_pdf" class="btn btn-danger">
                        <i class="far fa-file-pdf"></i>&nbsp;&nbsp;&nbsp;Download PDF
                    </button>
                </form>
                <form action="{{route('daily-revenue-report.cetak_excel')}}" target="_blank" class="m-1">
                    <input type="hidden" name="tanggal" id="excelTanggal">
                    <button id="btn_cetak_excel" class="btn btn-success">
                        <i class="far fa-file-excel"></i>&nbsp;Download Excel
                    </button>
                </form>
            </span>
		</div>
	</div>
	<!-- /page header -->

	<!-- Content area -->
	<div class="content">

        @if (checkBackDateHotel(hotelID()))
            <div class="alert alert-warning alert-styled-left alert-dismissible">
                There are backdated bookings from OTA or Manual; please check in first, and then don't forget to update DRR according to the date in the details.
                <button type="button" class="btn btn-warning m-1" style="float: right; top:0; right:0; position:absolute;" onclick="showDetailBookDates()">Detail</button>
            </div>
        @endif

		<!-- Hover rows -->
        <div class="card">
            <div class="card-header header-elements-inline">
                <div class="col-lg-12">
                    {{-- <h3 class="text-center">Daily Revenue Report</h3> --}}
                    <p class="mb-0">
                        <form action="{{ route('run.updatedailyrevenue') }}" method="post">
                            @csrf
                            <span class="float-left" style="font-size: 14px;">
                                {{-- Report Date : {{ date('d-m-y', strtotime($date_now)) }} --}}
                                <input type="text" id="tanggal" name="tanggal" class="form-control daterange-single" autocomplete="off" value="{{ isset($_GET['tanggal']) ? "&tanggal=".$_GET['tanggal'] : ''}}" required>
                            </span>


                            <span class="float-right">
                                @if (\Auth::user()->role == 1)
                                <button type="submit" class="btn btn-warning">
                                    <i class="icon-rotate-ccw3"></i>&nbsp;Update DRR
                                </button>
                                <a href="{{ url('re-journal-audit')}}?tanggal={{isset($_GET['tanggal']) ? $_GET['tanggal'] : ''}}">
                                    <button type="button" class="btn btn-danger">
                                        <i class="icon-rotate-ccw3"></i> Update Journal Income Audit
                                    </button>
                                </a>
                                @endif
                            </span>
                        </form>
                    </p>
                </div>
            </div>
        </div>

        <!-- Ambil View Dari Daily Revenue Cetak  -->
        <div class="card">
            <div class="card-body" style="margin:50px;">
                @include('report.daily_revenue')
            </div>
        </div>

        {{-- Room sales --}}
		{{-- <div class="card">
            <div class="card-header header-elements-inline">
                <div class="col-lg-12">
                    <h3 class="text-center">Room Sales</h3>
                </div>
            </div>

			<table class="table table-hover">
				<thead>
					<tr>
                        <th class="d-none" rowspan="2"><small>No</small></th>
                        <th style="text-align:center;width:40%;" rowspan="2"><small>MARKET SEGMENT</small></th>
                        <th style="text-align:center" colspan="2"><small>TODAY</small></th>
                        <th style="text-align:center" colspan="2"><small>MONTH TO DATE</small></th>
                        <th style="text-align:center" colspan="2"><small>YEAR TO DATE</small></th>
                    </tr>

                    <tr>
                        <th style="text-align:center"><small>ROOMS</small></th>
                        <th style="text-align:center"><small>REVENUE</small></th>
                        <th style="text-align:center"><small>ROOMS</small></th>
                        <th style="text-align:center"><small>REVENUE</small></th>
                        <th style="text-align:center"><small>ROOMS</small></th>
                        <th style="text-align:center"><small>REVENUE</small></th>
                    </tr>
				</thead>
				<tbody>
                    @php
                        $jml_room_day = $jml_rvnu_day = 0;
                        $jml_room_mon = $jml_rvnu_mon = 0;
                        $jml_room_yer = $jml_rvnu_yer = 0;
                    @endphp

                    @foreach($segments as $k => $segment)
                        <tr>
                            <td class="d-none">{{$loop->iteration}}</td>
                            <td>{{ config('custom.segment_ratecodes.'.$segment->segment_id) }}</td>
                            <td align="right">{{ @$segment->room ? ribuan($segment->room) : '-' }}</td>
                            <td align="right">{{ @$segment->revenue ? ribuan($segment->revenue)  : '-' }}</td>
                            <td align="right">{{ @$segment->room_mtd ? ribuan($segment->room_mtd) : '-' }}</td>
                            <td align="right">{{ @$segment->revenue_mtd ? ribuan($segment->revenue_mtd) : '-'}}</td>
                            <td align="right">{{ @$segment->room_ytd ? ribuan($segment->room_ytd) : '-' }}</td>
                            <td align="right">{{ @$segment->revenue_ytd ? ribuan($segment->revenue_ytd) : '-'}}</td>
                        </tr>
                        @php
                            $jml_room_day += @$segment->room;
                            $jml_rvnu_day += @$segment->revenue;
                            $jml_room_mon += @$segment->room_mtd;
                            $jml_rvnu_mon += @$segment->revenue_mtd;
                            $jml_room_yer += @$segment->room_ytd;
                            $jml_rvnu_yer += @$segment->revenue_ytd;
                        @endphp
                    @endforeach
				</tbody>

                <tfoot>
                    <tr>
                        <th style="text-align:center"><p class="font-bold">TOTAL ROOM SALES</p></th>
                        <th class="text-right">{{ ribuan($jml_room_day) }}</th>
                        <th class="text-right">{{ ribuan($jml_rvnu_day) }}</th>
                        <th class="text-right">{{ ribuan($jml_room_mon) }}</th>
                        <th class="text-right">{{ ribuan($jml_rvnu_mon) }}</th>
                        <th class="text-right">{{ ribuan($jml_room_yer) }}</th>
                        <th class="text-right">{{ ribuan($jml_rvnu_yer) }}</th>
                    </tr>
                </tfoot>
			</table>
		</div> --}}

        {{-- Room statistic --}}
        {{-- <div class="card">
            <div class="card-header header-elements-inline">
                <div class="col-lg-12">
                    <h3 class="text-center">Room Statistic</h3>
                </div>
            </div>

            <table class="table table-hover">
				<thead>
					<tr>
                        <th style="text-align:center;width:30%;" rowspan="2" class="d-none"><small>no</small></th>
                        <th style="text-align:center;width:30%;" rowspan="2"><small>ROOM STATISTIC</small></th>
                        <th style="text-align:center" colspan="3"><small>TODAY</small></th>
                        <th style="text-align:center" colspan="3"><small>MONTH TO DATE</small></th>
                        <th style="text-align:center" rowspan="2"><small>YTD</small></th>
                    </tr>
                    <tr>
                        <th style="text-align:center"><small>TODAY</small></th>
                        <th style="text-align:center"><small>BUDGET</small></th>
                        <th style="text-align:center"><small>VARIANCE</small></th>
                        <th style="text-align:center"><small>MTD</small></th>
                        <th style="text-align:center"><small>BUDGET</small></th>
                        <th style="text-align:center"><small>VARIANCE</small></th>
                    </tr>
				</thead>
				<tbody>
                    @foreach($room_statistics as $room_stat)
                        @if($room_stat->statistic_id>0)
                            <tr>
                                <td class="d-none">{{ $loop->iteration }}</td>
                                <td>{{ config('custom.room_statistic.'.$room_stat->statistic_id) }}</td>
                                @php
                                    if($room_stat->statistic_id==1) { //room available
                                        $room_mtd = $room_stat->mtd;
                                        $room_bud = $room_stat->budget_mtd;
                                        $room_var = $room_stat->variance_mtd;
                                        $room_ytd = $room_stat->ytd;
                                    } elseif($room_stat->statistic_id==3) { //compliment
                                        $comp_mtd = $room_stat->mtd;
                                        $comp_bud = $room_stat->budget_mtd;
                                        $comp_var = $room_stat->variance_mtd;
                                        $comp_ytd = $room_stat->ytd;
                                    } elseif($room_stat->statistic_id==7) { //room occupied
                                        $occu_mtd = $room_stat->mtd;
                                        $occu_bud = $room_stat->budget_mtd;
                                        $occu_var = $room_stat->variance_mtd;
                                        $occu_ytd = $room_stat->ytd;
                                    }
                                @endphp

                                @if($room_stat->statistic_id==9)
                                    @php
                                        $mtd = $room_mtd>0 ? (($occu_mtd/$room_mtd)*100) : 0;
                                        $bud = $room_bud>0 ? (($occu_bud/$room_bud)*100) : 0;
                                        $var = $room_var>0 ? (($occu_var/$room_var)*100) : 0;
                                        $ytd = $room_ytd>0 ? (($occu_ytd/$room_ytd)*100) : 0;
                                    @endphp
                                    <td align="right">{{ number_format($room_stat->today, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($room_stat->budget, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($room_stat->variance, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($mtd, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($bud, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($var, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($ytd, 2, ".", ",") }}%</td>
                                @elseif($room_stat->statistic_id==10)
                                    @php
                                        $mtd = $room_mtd>0 ? ((($occu_mtd-$comp_mtd)/$room_mtd)*100) : 0;
                                        $bud = $room_bud>0 ? ((($occu_bud-$comp_bud)/$room_bud)*100) : 0;
                                        $var = $room_var>0 ? ((($occu_var-$comp_var)/$room_var)*100) : 0;
                                        $ytd = $room_ytd>0 ? ((($occu_ytd-$comp_ytd)/$room_ytd)*100) : 0;
                                    @endphp
                                    <td align="right">{{ number_format($room_stat->today, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($room_stat->budget, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($room_stat->variance, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($mtd, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($bud, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($var, 2, ".", ",") }}%</td>
                                    <td align="right">{{ number_format($ytd, 2, ".", ",") }}%</td>
                                @else
                                    <td align="right">{{ ribuan($room_stat->today) }}</td>
                                    <td align="right">{{ ribuan($room_stat->budget) }}</td>
                                    <td align="right">{{ ribuan($room_stat->variance) }}</td>
                                    <td align="right">{{ ribuan($room_stat->mtd) }}</td>
                                    <td align="right">{{ ribuan($room_stat->budget_mtd) }}</td>
                                    <td align="right">{{ ribuan($room_stat->variance_mtd) }}</td>
                                    <td align="right">{{ ribuan($room_stat->ytd) }}</td>
                                @endif

                            </tr>
                        @else
                            @php
                                if($room_stat->statistic_id==1) { //room available
                                    $room_mtd = $room_stat->mtd;
                                    $room_bud = $room_stat->budget_mtd;
                                    $room_var = $room_stat->variance_mtd;
                                    $room_ytd = $room_stat->ytd;
                                } elseif($room_stat->statistic_id==3) { //compliment
                                    $comp_mtd = $room_stat->mtd;
                                    $comp_bud = $room_stat->budget_mtd;
                                    $comp_var = $room_stat->variance_mtd;
                                    $comp_ytd = $room_stat->ytd;
                                } elseif($room_stat->statistic_id==7) { //room occupied
                                    $occu_mtd = $room_stat->mtd;
                                    $occu_bud = $room_stat->budget_mtd;
                                    $occu_var = $room_stat->variance_mtd;
                                    $occu_ytd = $room_stat->ytd;
                                }

                                $lodging_day = $room_stat->today;
                                $lodging_bdy = $room_stat->budget;
                                $lodging_vdy = $room_stat->variance;
                                $lodging_mtd = $room_stat->mtd;
                                $lodging_bud = $room_stat->budget_mtd;
                                $lodging_var = $room_stat->variance_mtd;
                                $lodging_ytd = $room_stat->ytd;
                            @endphp
                        @endif
                    @endforeach
				</tbody>
			</table>
        </div> --}}

        {{-- Detail --}}
        {{-- <div class="card">
            <div class="card-header header-elements-inline">
                <div class="col-lg-12">
                    <h3 class="text-center">Description</h3>
                </div>
            </div>

            <table class="table table-hover">
				<thead>
					<tr>
                        <th style="text-align:center;width:30%;" rowspan="2" class="d-none"><small>#</small></th>
                        <th style="text-align:center;width:30%;" rowspan="2"><small>DESCRIPTION</small></th>
                        <th style="text-align:center" colspan="3"><small>TODAY</small></th>
                        <th style="text-align:center" colspan="3"><small>MONTH TO DATE</small></th>
                        <th style="text-align:center" rowspan="2"><small>YTD</small></th>
                    </tr>
                    <tr>
                        <th style="text-align:center"><small>TODAY</small></th>
                        <th style="text-align:center"><small>BUDGET</small></th>
                        <th style="text-align:center"><small>VARIANCE</small></th>
                        <th style="text-align:center"><small>MTD</small></th>
                        <th style="text-align:center"><small>BUDGET</small></th>
                        <th style="text-align:center"><small>VARIANCE</small></th>
                    </tr>
				</thead>

				<tbody>
                    <tr>
                        <td class="d-none">#</td>
                        <td style="font-weight:bold;font-size:15px;">Room Revenue</td>
                        <td align="right"></td>
                        <td align="right"></td>
                        <td align="right"></td>
                        <td align="right"></td>
                        <td align="right"></td>
                        <td align="right"></td>
                        <td align="right"></td>
                    </tr>
                    <tr>
                        <td class="d-none">#</td>
                        <td>&nbsp;&nbsp;&nbsp; Lodging</td>
                        <td align="right">{{ ribuan(@$lodging_day) }}</td>
                        <td align="right">{{ ribuan(@$lodging_bdy) }}</td>
                        <td align="right">{{ ribuan(@$lodging_vdy) }}</td>
                        <td align="right">{{ ribuan(@$lodging_mtd) }}</td>
                        <td align="right">{{ ribuan(@$lodging_bud) }}</td>
                        <td align="right">{{ ribuan(@$lodging_var) }}</td>
                        <td align="right">{{ ribuan(@$lodging_ytd) }}</td>
                    </tr>
                    @foreach($shop_statistics_room as $shop_room)

                            <tr>
                                <td>&nbsp;&nbsp;&nbsp;
                                    @if($shop_room->tipe_menu_id>0)
                                        {{ @$shop_room->tipe->nama_tipe }}
                                    @elseif($shop_room->tipe_menu_id===0)
                                        Custom Menu
                                    @elseif(!$shop_room->tipe_menu_id)
                                        Discount
                                    @endif
                                </td>
                                <td align="right">{{ ribuan($shop_room->today) }}</td>
                                <td align="right">{{ ribuan($shop_room->budget) }}</td>
                                <td align="right">{{ ribuan($shop_room->variance) }}</td>
                                <td align="right">{{ ribuan($shop_room->mtd) }}</td>
                                <td align="right">{{ ribuan($shop_room->budget_mtd) }}</td>
                                <td align="right">{{ ribuan($shop_room->variance_mtd) }}</td>
                                <td align="right">{{ ribuan($shop_room->ytd) }}</td>
                            </tr>
                            @php
                                $lodging_day    += $shop_room->today;
                                $lodging_bdy    += $shop_room->budget;
                                $lodging_vdy    += $shop_room->variance;
                                $lodging_mtd    += $shop_room->mtd;
                                $lodging_mtd    += $shop_room->budget_mtd;
                                $lodging_var    += $shop_room->variance_mtd;
                                $lodging_ytd    += $shop_room->ytd;
                            @endphp

                    @endforeach
                    <tr>
                        <td class="d-none">#</td>
                        <td class="tebal">TOTAL ROOM REVENUE </td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_day) }}</td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_bdy) }}</td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_vdy) }}</td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_mtd) }}</td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_bud) }}</td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_var) }}</td>
                        <td class="tebal" align="right">{{ ribuan(@$lodging_ytd) }}</td>
                    </tr>
                    @php
                        $shopid = 0;
                        $total_today=0;
                        $total_budget_day=0;
                        $total_variance_day=0;
                        $total_mtd=0;
                        $total_budget_mtd=0;
                        $total_variance_mtd=0;
                        $total_ytd=0;
                        $shop_name='';

                        $gtotal_today=0;
                        $gtotal_budget_day=0;
                        $gtotal_variance_day=0;
                        $gtotal_mtd=0;
                        $gtotal_budget_mtd=0;
                        $gtotal_variance_mtd=0;
                        $gtotal_ytd=0;
                    @endphp
                    @foreach($shop_statistics as $shop_stat)
                        @if($shopid != $shop_stat->shop_id && $shopid != 0)
                            <tr>
                                <td class="d-none">#</td>
                                <td class="tebal">TOTAL {{ strtoupper($shop_name) }} REVENUE </td>
                                <td class="tebal" align="right">{{ ribuan($total_today) }}</td>
                                <td class="tebal" align="right">{{ ribuan($total_budget_day) }}</td>
                                <td class="tebal" align="right">{{ ribuan($total_variance_day) }}</td>
                                <td class="tebal" align="right">{{ ribuan($total_mtd) }}</td>
                                <td class="tebal" align="right">{{ ribuan($total_budget_mtd) }}</td>
                                <td class="tebal" align="right">{{ ribuan($total_variance_mtd) }}</td>
                                <td class="tebal" align="right">{{ ribuan($total_ytd) }}</td>
                            </tr>
                            @php
                                $gtotal_today           += $total_today;
                                $gtotal_budget_day      += $total_budget_day;
                                $gtotal_variance_day    += $total_variance_day;
                                $gtotal_mtd             += $total_budget_mtd;
                                $gtotal_budget_mtd      += $total_budget_mtd;
                                $gtotal_variance_mtd    += $total_variance_mtd;
                                $gtotal_ytd             += $total_ytd;

                                $total_today=0;
                                $total_budget_day=0;
                                $total_variance_day=0;
                                $total_mtd=0;
                                $total_budget_mtd=0;
                                $total_variance_mtd=0;
                                $total_ytd=0;
                            @endphp
                        @endif
                        @if($shopid != $shop_stat->shop_id)
                            <tr>
                                <td class="d-none">#</td>
                                <td style="font-weight:bold;font-size:15px;">{{ @$shop_stat->shop->nama }}</td>
                                <td align="right"></td>
                                <td align="right"></td>
                                <td align="right"></td>
                                <td align="right"></td>
                                <td align="right"></td>
                                <td align="right"></td>
                                <td align="right"></td>
                            </tr>
                            @php
                                $shopid = $shop_stat->shop_id;
                                $shop_name = @$shop_stat->shop->nama;
                            @endphp
                        @endif

                        <tr>
                            <td class="d-none">#</td>
                            <td>&nbsp;&nbsp;&nbsp;
                                @if($shop_stat->tipe_menu_id>0)
                                    {{ @$shop_stat->tipe->nama_tipe }}
                                @elseif($shop_stat->tipe_menu_id===0)
                                    Custom Menu
                                @elseif(!$shop_stat->tipe_menu_id)
                                    Discount
                                @endif
                            </td>
                            <td align="right">{{ ribuan($shop_stat->today) }}</td>
                            <td align="right">{{ ribuan($shop_stat->budget) }}</td>
                            <td align="right">{{ ribuan($shop_stat->variance) }}</td>
                            <td align="right">{{ ribuan($shop_stat->mtd) }}</td>
                            <td align="right">{{ ribuan($shop_stat->budget_mtd) }}</td>
                            <td align="right">{{ ribuan($shop_stat->variance_mtd) }}</td>
                            <td align="right">{{ ribuan($shop_stat->ytd) }}</td>
                        </tr>
                        @php
                            $total_today        += $shop_stat->today;
                            $total_budget_day   += $shop_stat->budget;
                            $total_variance_day += $shop_stat->variance;
                            $total_mtd          += $shop_stat->mtd;
                            $total_budget_mtd   += $shop_stat->budget_mtd;
                            $total_variance_mtd += $shop_stat->variance_mtd;
                            $total_ytd          += $shop_stat->ytd;
                        @endphp

                    @endforeach

                    <tr>
                        <td class="d-none">#</td>
                        <td class="tebal">TOTAL {{ strtoupper($shop_name) }} REVENUE </td>
                        <td class="tebal" align="right">{{ ribuan($total_today) }}</td>
                        <td class="tebal" align="right">{{ ribuan($total_budget_day) }}</td>
                        <td class="tebal" align="right">{{ ribuan($total_variance_day) }}</td>
                        <td class="tebal" align="right">{{ ribuan($total_mtd) }}</td>
                        <td class="tebal" align="right">{{ ribuan($total_budget_mtd) }}</td>
                        <td class="tebal" align="right">{{ ribuan($total_variance_mtd) }}</td>
                        <td class="tebal" align="right">{{ ribuan($total_ytd) }}</td>
                    </tr>
				</tbody>

                <tfoot>
                    @php
                        $gtotal_today           += $total_today;
                        $gtotal_budget_day      += $total_budget_day;
                        $gtotal_variance_day    += $total_variance_day;
                        $gtotal_mtd             += $total_budget_mtd;
                        $gtotal_budget_mtd      += $total_budget_mtd;
                        $gtotal_variance_mtd    += $total_variance_mtd;
                        $gtotal_ytd             += $total_ytd;

                        $gtotal_today        += $lodging_day ?? 0;
                        $gtotal_budget_day   += $lodging_bdy ?? 0;
                        $gtotal_variance_day += $lodging_vdy ?? 0;
                        $gtotal_mtd          += $lodging_mtd ?? 0;
                        $gtotal_budget_mtd   += $lodging_bud ?? 0;
                        $gtotal_variance_mtd += $lodging_var ?? 0;
                        $gtotal_ytd          += $lodging_ytd ?? 0;

                    @endphp
                    <tr>
                        <td class="d-none">#</td>
                        <th class="tebal text-center">TOTAL NET REVENUE </th>
                        <th class="tebal text-right">{{ ribuan($gtotal_today) }}</th>
                        <th class="tebal text-right">{{ ribuan($gtotal_budget_day) }}</th>
                        <th class="tebal text-right">{{ ribuan($gtotal_variance_day) }}</th>
                        <th class="tebal text-right">{{ ribuan($gtotal_mtd) }}</th>
                        <th class="tebal text-right">{{ ribuan($gtotal_budget_mtd) }}</th>
                        <th class="tebal text-right">{{ ribuan($gtotal_variance_mtd) }}</th>
                        <th class="tebal text-right">{{ ribuan($gtotal_ytd) }}</th>
                    </tr>
                </tfoot>
			</table>
        </div> --}}
		<!-- /hover rows -->

	</div>
	<!-- /content area -->

    <!-- Danger modal -->
	<div id="modal_theme_danger" class="modal fade" tabindex="-1">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header bg-danger" align="center">
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form action="" method="post" id="delform">
				    @csrf
				    @method('DELETE')
					<div class="modal-body" align="center">
						<h2> Hapus Data? </h2>
					</div>

					<div class="modal-footer">
						<button type="button" class="btn btn-link" data-dismiss="modal">Batal</button>
						<button type="submit" class="btn bg-danger">Hapus</button>
					</div>
				</form>
			</div>
		</div>
	</div>
	<!-- /default modal -->

     <!-- Alert Modal -->
	<div id="alert_modal" class="modal fade" tabindex="-1">
		<div class="modal-dialog modal-lg">
			<div class="modal-content">
				<div class="modal-header bg-warning" align="center">
                    <h6 class="modal-title">
                       &nbsp;<h3>Alert!</h3>
                    </h6>
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

                <div class="modal-body" align="center" id="text-alert">
                    <div>
                        <div class="col-md-12 mt-2">
                            <div class="alert alert-warning text-center mb-2" role="alert">
                                Please check again. This list is the backdated bookings or late bookings according to the start date; after this, please update DRR.
                            </div>
                        </div>
                    </div>
                    <table class="table table-striped table-hover">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Date</th>
                                <th>OTA reservation code</th>
                                <th>No. Reservation PMS</th>
                                <th>Guest name</th>
                                <th>Start date - end date</th>
                            </tr>
                        </thead>
                        <tbody id="label_data_list">
                            <tr>
                                <td colspan="3" class="text-center">
                                    <h4>No data</h4>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </div>

                <div class="modal-footer">
                    <button type="submit" class="btn bg-primary" data-dismiss="modal">Close</button>
                </div>

			</div>
		</div>
	</div>
	<!-- /Alert Modal -->


@endsection

@section('js')
	<!-- Theme JS files -->
	<script src="{{asset('global_assets/js/plugins/notifications/pnotify.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/notifications/bootbox.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/tables/datatables/datatables.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/selects/select2.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/spin.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/ladda.min.js')}}"></script>

	<script src="{{asset('assets/js/app.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/components_modals.js')}}"></script>
	<script>
		//modal delete
		$(document).on("click", ".delbutton", function () {
		     var url = $(this).data('uri');
		     $("#delform").attr("action", url);
		});

        let tanggal = {!! json_encode(\Request::get('tanggal') ? formatDate(\Request::get('tanggal'), 'd-m-Y') : date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) ) !!}

        $(document).ready(function(){
            $('#hTanggal').val(tanggal)
            $('#excelTanggal').val(tanggal)
        });

        //Single Date Picker
        $('#tanggal').daterangepicker({
			singleDatePicker: true,
            startDate: tanggal,
            maxDate: "{{ date('d-m-Y', strtotime('0 day', strtotime(getSystemDate())) ) }}",
			locale: {
				format: 'DD-MM-YYYY'
			}
		});

        // Trigger Ketika Ganti Tanggal
		$('#tanggal').on('apply.daterangepicker', (e, picker) => {
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);
            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);
            document.location.href = "?" + params.toString();
	    });

		var DatatableBasic = function() {

		    // Basic Datatable examples
		    var _componentDatatableBasic = function() {
		        if (!$().DataTable) {
		            console.warn('Warning - datatables.min.js is not loaded.');
		            return;
		        }

		        // Setting datatable defaults
		        $.extend( $.fn.dataTable.defaults, {
		            autoWidth: false,
		            columnDefs: [{
		                orderable: false,
		                width: 150,
		                targets: [ 4 ]
		            }],
		            dom: '<"datatable-header"fl><"datatable-scroll"t><"datatable-footer"ip>',
		            language: {
		                search: '<span>Filter:</span> _INPUT_',
		                searchPlaceholder: 'Type to filter...',
		                lengthMenu: '<span>Show:</span> _MENU_',
		                paginate: { 'first': 'First', 'last': 'Last', 'next': $('html').attr('dir') == 'rtl' ? '&larr;' : '&rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr;' : '&larr;' }
		            }
		        });

		        // Basic datatable
		        $('.datatable-basic').DataTable({
                    paging: false,
                });

		        // Alternative pagination
		        $('.datatable-pagination').DataTable({
		            pagingType: "simple",
		            language: {
		                paginate: {'next': $('html').attr('dir') == 'rtl' ? 'Next &larr;' : 'Next &rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr; Prev' : '&larr; Prev'}
		            }
		        });

		        // Datatable with saving state
		        $('.datatable-save-state').DataTable({
		            stateSave: true
		        });

		        // Scrollable datatable
		        var table = $('.datatable-scroll-y').DataTable({
		            autoWidth: true,
		            scrollY: 300
		        });

		        // Resize scrollable table when sidebar width changes
		        $('.sidebar-control').on('click', function() {
		            table.columns.adjust().draw();
		        });
		    };

		    // Select2 for length menu styling
		    var _componentSelect2 = function() {
		        if (!$().select2) {
		            console.warn('Warning - select2.min.js is not loaded.');
		            return;
		        }

		        // Initialize
		        $('.dataTables_length select').select2({
		            minimumResultsForSearch: Infinity,
		            dropdownAutoWidth: true,
		            width: 'auto'
		        });
		    };


		    //
		    // Return objects assigned to module
		    //

		    return {
		        init: function() {
		            _componentDatatableBasic();
		            _componentSelect2();
		        }
		    }
		}();


		// Initialize module
		// ------------------------------

		document.addEventListener('DOMContentLoaded', function() {
		    DatatableBasic.init();
		});
	</script>
	<script type="text/javascript">
		$( document ).ready(function() {
	        // Default style
	        @if(session('error'))
	            new PNotify({
	                title: 'Error',
	                text: '{{ session('error') }}.',
	                icon: 'icon-blocked',
	                type: 'error'
	            });
            @endif
            @if ( session('success'))
	            new PNotify({
	                title: 'Success',
	                text: '{{ session('success') }}.',
	                icon: 'icon-checkmark3',
	                type: 'success'
	            });
            @endif

		});

        function showDetailBookDates() {
                $.ajax({
                    type: "get",
                    url: "{{url('get-show-book-dates')}}",
                    dataType: "json",
                    success: function (response) {
                        if (response.length > 0) {
                            var html = ``;
                            $.each(response, function (i, d ) {
                                html +=   ` <tr>
                                                <td>${i+1}</td>
                                                <td>${d.date_now}</td>
                                                <td>${d.booking.ota_reservation_code}</td>
                                                <td>${d.booking.kode_booking}</td>
                                                <td>${d.booking.nama}</td>
                                                <td>${d.start_date+' - '+d.end_date}</td>
                                            </tr>`
                            });
                            $('#label_data_list').html("<h3>"+html+"</h3>")
                            $('#alert_modal').modal('show')
                        }
                    }
                });

            }
	</script>
@endsection