@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)
| {{ 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 }} |
@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)
{{ ($custom_filter == 1 ? @$roomrate->bookingDetail->per_item_real : @$harga_item_real) }} |
@else
{{ ($custom_filter == 1 ? @$lodging : @$roomrate->total) }} |
@endif
{{ $roomrate->created_at ? $roomrate->created_at->format('H:i:s') : '' }} |
{{ @$roomrate->invoice->nama_pelanggan }} |
@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
| TOTAL |
{{$total_qty}} |
{{($total_amount)}} |
|
@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
| {{ 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 }} |
@if ($exclude == 1)
{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ($own_revenue) }} |
@else
{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ($own_revenue_pph) }} |
@endif
{{ $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 }} |
@if ($exclude == 1)
{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ($partner_revenue) }} |
@else
{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ($partner_revenue_pph) }} |
@endif
{{ $shop_transaction->created_at ? $shop_transaction->created_at->format('H:i:s') : '' }} |
{{ @$shop_transaction->main_invoice->nama_pelanggan }} |
@else
| {{ 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 }} |
@if ($exclude == 1)
{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ (@$shop_transaction->total_biaya) }} |
@else
{{@$shop_transaction->jenis_transaksi == 0 ? '-' : ''}}{{ ($shop_transaction->grand_total) }} |
@endif
{{ $shop_transaction->created_at ? $shop_transaction->created_at->format('H:i:s') : '' }} |
{{ @$shop_transaction->main_invoice->nama_pelanggan }} |
@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
| TOTAL |
{{$total_qty}} |
{{($total_amount)}} |
|
@endforeach
@foreach($transactions as $transaction)
@php
$total_qty = 0;
$total_amount = 0;
@endphp
@foreach($transaction as $item_transaction)
@if($item_transaction->jenis_pembayaran_id)
| {{ 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 ? '-' : ''}}{{ ($item_transaction->nominal) }} |
{{ $item_transaction->created_at ? $item_transaction->created_at->format('H:i:s') : '' }} |
{{ @$item_transaction->booking->nama }} |
@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)
| {{ 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 }} |
@if($item_transaction->deposit_reservasi)
Pembayaran {{ config('custom.jenis_deposit')[$item_transaction->jenis_deposit].' '.$item_transaction->bank }} A.N. {{ $item_transaction->nama }} |
@else
Pembayaran Deposit Reservasi A.N. {{ $item_transaction->nama }} {{$item_transaction->description ? ' - '.$item_transaction->description : ''}} |
@endif
FO |
{{ @$item_transaction->jenis_transaksi == 0 ? '' : '-'}}1 |
{{ @$item_transaction->jenis_transaksi == 0 ? '' : '-'}}{{ ($item_transaction->nominal) }} |
{{ $item_transaction->created_at ? $item_transaction->created_at->format('H:i:s') : '' }} |
{{ @$item_transaction->booking->nama }} |
@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
| TOTAL |
{{$total_qty}} |
{{($total_amount)}} |
|
@endforeach
{{--
@foreach($pembayaranpos as $transaction)
@php
$total_qty = 0;
$total_amount = 0;
@endphp
@foreach($transaction as $item_transaction)
@if($item_transaction->jenis_pembayaran_id)
| {{ 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 |
{{ ($item_transaction->nominal) }} |
{{ $item_transaction->created_at ? $item_transaction->created_at->format('H:i:s') : '' }} |
{{ @$item_transaction->booking->nama }} |
@php
$total_amount += $item_transaction->nominal;
$total_qty += 1;
$grandtotal_amount += $item_transaction->nominal;
$grandtotal_qty += 1;
@endphp
@endif
@endforeach
| TOTAL |
{{$total_qty}} |
{{($total_amount)}} |
|
@endforeach --}}
| Grand Total |
{{$grandtotal_qty}} |
{{($grandtotal_amount)}} |
|
@else
Tidak Ada Transaksi Hari Ini
|
@endif