Booking Journal by Article
Report Printed on: {{date('l, F d, Y')}}
Printed By : {{\Auth::user()->nama}} 		Period : {{$periode}}
@if(count($roomrates) > 0 || count($shop_transactions) > 0 || count($transactions) > 0) @php $grandtotal_amount = 0; $grandtotal_qty = 0; @endphp @foreach($roomrates as $group_roomrate) @php $total_amount = 0; $total_qty = 0; @endphp @foreach($group_roomrate as $roomrate) @if ($roomrate->bookingDetail) @php // Assign tax dan services $tax = round((@$roomrate->bookingDetail->per_item * $tax_global)/(100+$tax_global));//Find tax from normal price, without arrangement price $harga_min_t = ((@$roomrate->bookingDetail->per_item) - $tax);//price minus total tax $services = round(($harga_min_t * $services_global)/(100+$services_global));//Find service from normal price, without arrangement price $harga_item_real = (int)((@$roomrate->bookingDetail->per_item) - ($tax) - ($services));//input per item real, without arrangement price // lodging include tax services. $lodging = (int)($roomrate->bookingDetail->per_item - $roomrate->bookingDetail->per_item_arr); @endphp @if ($exclude == 1) @else @endif @php // $total_amount += $roomrate->total; // $grandtotal_amount += $roomrate->total; $total_qty += $roomrate->qty; if ($exclude == 1){ $total_amount += ($custom_filter == 1 ? @$roomrate->bookingDetail->per_item_real : @$harga_item_real); $grandtotal_amount += ($custom_filter == 1 ? @$roomrate->bookingDetail->per_item_real : @$harga_item_real); }else{ $total_amount += ($custom_filter == 1 ? @$lodging : @$roomrate->total); $grandtotal_amount += ($custom_filter == 1 ? @$lodging : @$roomrate->total); } $grandtotal_qty += $roomrate->qty; @endphp @endif @endforeach @endforeach @foreach($shop_transactions as $group_shop_transaction) @php $total_amount = 0; $total_qty = 0; @endphp @foreach($group_shop_transaction as $shop_transaction) @if(@$shop_transaction->tipeMenu->split_revenue < 100) @php $split_percentage = @$shop_transaction->tipeMenu->split_revenue / 100; $split_partner = $shop_transaction->tipemenu ? (100 - $shop_transaction->tipemenu->split_revenue) : 0; //custom menu // partner revenue $partner_label = @$shop_transaction->tipeMenu->revenue_partner_label; // $partner_revenue = $shop_transaction->total_biaya - $own_revenue; // $partner_revenue_pph = $shop_transaction->grand_total - $own_revenue_pph; $partner_revenue = (int)($shop_transaction->total_biaya) * ($split_partner / 100); $partner_revenue_pph = (int)($shop_transaction->grand_total) * ($split_partner / 100); $partner_raw_rev = $partner_revenue; $partner_raw_rev_pph = $partner_revenue_pph; if (@$shop_transaction->tipeMenu->partner_services == 1) { $service_payable = @$shop_transaction->service * ($split_partner/100); } else{ $service_payable = 0; } if (@$shop_transaction->tipeMenu->partner_tax == 1) { $tax_payable = @$shop_transaction->ppn * ($split_partner/100); } else{ $tax_payable = 0; } // $partner_revenue = $partner_raw_rev + $service_payable + $tax_payable; $partner_revenue = $partner_raw_rev; $partner_revenue_pph = $partner_raw_rev + $service_payable + $tax_payable; // own revenue $own_label = @$shop_transaction->tipeMenu->revenue_hotel_label; // $own_revenue = round($shop_transaction->total_biaya * $split_percentage); // $own_revenue_pph = round($shop_transaction->grand_total * $split_percentage); $own_revenue = round($shop_transaction->total_biaya - $partner_revenue); $own_revenue_pph = round($shop_transaction->grand_total - $partner_revenue_pph); @endphp @if ($exclude == 1) @else @endif @if ($exclude == 1) @else @endif @else @if ($exclude == 1) @else @endif @endif @php if ($shop_transaction->jenis_transaksi == 1) { $total_amount += $exclude ? $shop_transaction->total_biaya : $shop_transaction->grand_total; $total_qty += $shop_transaction->jumlah; $grandtotal_amount += $exclude ? $shop_transaction->total_biaya : $shop_transaction->grand_total; $grandtotal_qty += $shop_transaction->jumlah; }elseif($shop_transaction->jenis_transaksi == 0){ $total_amount -= $exclude ? $shop_transaction->total_biaya : $shop_transaction->grand_total; $total_qty -= $shop_transaction->jumlah; $grandtotal_amount -= $exclude ? $shop_transaction->total_biaya : $shop_transaction->grand_total; $grandtotal_qty -= $shop_transaction->jumlah; } @endphp @endforeach @endforeach @foreach($transactions as $transaction) @php $total_qty = 0; $total_amount = 0; @endphp @foreach($transaction as $item_transaction) @if($item_transaction->jenis_pembayaran_id) @php if($item_transaction->tipe_pembayaran == 1){ $total_amount -= $item_transaction->nominal; $total_qty += 1; $grandtotal_amount -= $item_transaction->nominal; $grandtotal_qty += 1; } else{ $total_amount += $item_transaction->nominal; $total_qty += 1; $grandtotal_amount += $item_transaction->nominal; $grandtotal_qty += 1; } @endphp @endif @if($item_transaction->jenis_deposit) @if($item_transaction->deposit_reservasi) @else @endif @php if (@$item_transaction->jenis_transaksi == 1) { $total_amount -= $item_transaction->nominal; $total_qty += 1; $grandtotal_amount -= $item_transaction->nominal; $grandtotal_qty += 1; }elseif(@$item_transaction->jenis_transaksi == 0){ $total_amount += $item_transaction->nominal; $total_qty -= 1; $grandtotal_amount += $item_transaction->nominal; $grandtotal_qty -= 1; } @endphp @endif @endforeach @endforeach {{-- @foreach($pembayaranpos as $transaction) @php $total_qty = 0; $total_amount = 0; @endphp @foreach($transaction as $item_transaction) @if($item_transaction->jenis_pembayaran_id) @php $total_amount += $item_transaction->nominal; $total_qty += 1; $grandtotal_amount += $item_transaction->nominal; $grandtotal_qty += 1; @endphp @endif @endforeach @endforeach --}} @else @endif
Date Room No No. Bill Description Department Qty Amount Time GuestName
{{ formatDate($roomrate->date) }} {{ $roomrate->room_no }} {{ @$invoice_array[@$roomrate->invoice->booking_id][@$roomrate->invoice->room_index]->no_invoice }} {{ $custom_filter == 1 ? 'Lodging' : ($custom_filter == 2 ? 'Roomcharge' : $roomrate->description) }} FO {{ $roomrate->qty }}{{ ribuanWithComma($custom_filter == 1 ? @$roomrate->bookingDetail->per_item_real : @$harga_item_real) }}{{ ribuanWithComma($custom_filter == 1 ? @$lodging : @$roomrate->total) }}{{ $roomrate->created_at ? $roomrate->created_at->format('H:i:s') : '' }} {{ @$roomrate->invoice->nama_pelanggan }}
TOTAL {{$total_qty}} {{ribuanWithComma($total_amount)}}
{{ formatDate($shop_transaction->transaction_date) }} {{ @$shop_transaction->kamar->no_kamar }} {{ $shop_transaction->cartresto_id ? @$shop_transaction->cartresto->order_flag : @$shop_transaction->main_invoice->no_invoice }} {{ $own_label }} {{$shop_transaction->description ? ' - '.$shop_transaction->description : ''}} FO {{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}} {{ $shop_transaction->jumlah }}{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ribuanWithComma($own_revenue) }}{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ribuanWithComma($own_revenue_pph) }}{{ $shop_transaction->created_at ? $shop_transaction->created_at->format('H:i:s') : '' }} {{ @$shop_transaction->main_invoice->nama_pelanggan }}
{{ formatDate($shop_transaction->transaction_date) }} {{ @$shop_transaction->kamar->no_kamar }} {{ $shop_transaction->cartresto_id ? @$shop_transaction->cartresto->order_flag : @$shop_transaction->main_invoice->no_invoice }} {{ $partner_label }} {{$shop_transaction->description ? ' - '.$shop_transaction->description : ''}} FO {{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ $shop_transaction->jumlah }}{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ribuanWithComma($partner_revenue) }}{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ribuanWithComma($partner_revenue_pph) }}{{ $shop_transaction->created_at ? $shop_transaction->created_at->format('H:i:s') : '' }} {{ @$shop_transaction->main_invoice->nama_pelanggan }}
{{ formatDate($shop_transaction->transaction_date) }} {{ @$shop_transaction->kamar->no_kamar }} {{ $shop_transaction->cartresto_id ? @$shop_transaction->cartresto->order_flag : @$shop_transaction->main_invoice->no_invoice }} {{ @$shop_transaction->menu->nama }} {{$shop_transaction->description ? ' - '.$shop_transaction->description : ''}} FO {{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ $shop_transaction->jumlah }}{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ribuanWithComma(@$shop_transaction->total_biaya) }}{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ribuanWithComma($shop_transaction->grand_total) }}{{ $shop_transaction->created_at ? $shop_transaction->created_at->format('H:i:s') : '' }} {{ @$shop_transaction->main_invoice->nama_pelanggan }}
TOTAL {{$total_qty}} {{ribuanWithComma($total_amount)}}
{{ formatDate($item_transaction->transaction_date) }} {{ @$invoice_array[$item_transaction->booking_id][$item_transaction->room_index]->nomor_kamar }} {{ @$item_transaction->invoice->no_invoice }} {{$item_transaction->tipe_pembayaran == 1 ? 'Pembayaran' : 'Refund'}} {{ config('custom.jenis_pembayaran')[$item_transaction->jenis_pembayaran_id].' '.$item_transaction->bank }} A.N. {{ @$item_transaction->booking->nama }} FO 1 {{$item_transaction->tipe_pembayaran == 1 ? '-' : ''}}{{ ribuanWithComma($item_transaction->nominal) }} {{ $item_transaction->created_at ? $item_transaction->created_at->format('H:i:s') : '' }} {{ @$item_transaction->booking->nama }}
{{ formatDate($item_transaction->transaction_date) }} {{ @$invoice_array[$item_transaction->booking_id][$item_transaction->room_index]->nomor_kamar }} {{ @$invoice_array[$item_transaction->booking_id][$item_transaction->room_index]->no_invoice }}Pembayaran {{ config('custom.jenis_deposit')[$item_transaction->jenis_deposit].' '.$item_transaction->bank }} A.N. {{ $item_transaction->nama }}Pembayaran Deposit Reservasi A.N. {{ $item_transaction->nama }} {{$item_transaction->description ? ' - '.$item_transaction->description : ''}}FO {{ @$item_transaction->jenis_transaksi == 0 ? '' : '-'}}1 {{ @$item_transaction->jenis_transaksi == 0 ? '' : '-'}}{{ ribuanWithComma($item_transaction->nominal) }} {{ $item_transaction->created_at ? $item_transaction->created_at->format('H:i:s') : '' }} {{ @$item_transaction->booking->nama }}
TOTAL {{$total_qty}} {{ribuanWithComma($total_amount)}}
{{ formatDate($item_transaction->transaction_date) }} {{ @$invoice_array[$item_transaction->booking_id][$item_transaction->nomor_kamar]->nomor_kamar }} {{ @$invoice_array[$item_transaction->booking_id][$item_transaction->nomor_kamar]->no_invoiceno_invoice }} Outlet Bill : {{ @$item_transaction->cart->order_flag }} POS 1 {{ ribuanWithComma($item_transaction->nominal) }} {{ $item_transaction->created_at ? $item_transaction->created_at->format('H:i:s') : '' }} {{ @$item_transaction->booking->nama }}
TOTAL {{$total_qty}} {{ribuanWithComma($total_amount)}}
Grand Total {{$grandtotal_qty}} {{ribuanWithComma($grandtotal_amount)}}

NO DATA