@extends('layouts.app')
@section('style')
    <style>
        .sticky-rows {
            top:0px;
            position: sticky;
            z-index: 1;
            right: 0;
            background-color: #F5F5F5;
        }
        td {
            white-space: nowrap;
        }
        .table td, .table th {
            border: 1px solid #beb9b9 !important;
        }
        thead, tbody {
            text-align: center !important;
        }
        .total-bg {
            background-color: #F5F5F5;
        }
    </style>
@endsection

@section('content')
<div class="col-12">

</div>
<div class="col-12">
    <div class="card">
        <div class="card-header">
            <h5 class="title mb-0">Billings</h5>
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb"style="background-color: white; padding-left: 2px">
                    <li class="breadcrumb-item"><a href="{{ route('home') }}">Home</a></li>
                    <li class="breadcrumb-item"><a href="{{ route('billing') }}">Billings</a></li>
                    <li class="breadcrumb-item"><a href="{{ route('billing.show', [ 'id' => $BRID]) }}">Preview</a></li>
                    <li class="breadcrumb-item active" aria-current="page">Record</li>
                </ol>
            </nav>
        </div>
        <div class="card-body all-icons">
            <div class="row">
                <div class="col-6 col-md-3">
                    <div class="card border">
                        <div class="card-body">
                            <small class="text-secondary">CLLIENT</small>
                            <p>{{ $contract->first_name . ' ' . $contract->last_name }}</p>
                        </div>
                    </div>
                </div>
                <div class="col-6 col-md-3">
                    <div class="card border">
                        <div class="card-body">
                            <small class="text-secondary">START</small>
                            <p>{{ $billing->start_date }}</p>
                        </div>
                    </div>
                </div>
                <div class="col-6 col-md-3">
                    <div class="card border">
                        <div class="card-body">
                            <small class="text-secondary">END</small>
                            <p>{{ $billing->end_date }}</p>
                        </div>
                    </div>
                </div>
                <div class="col-6 col-md-3">
                    <div class="card border">
                        <div class="card-body">
                            <small class="text-secondary">DATE CREATED</small>
                            <p>{{ $billingRecord->created_at }}</p>
                        </div>
                    </div>
                </div>
            </div>
            <div class="table-responsive">
                <table class="table">
                    <thead class=" text-primary">
                        <tr>
                            <td colspan="2"></td>
                            <td colspan="18">Work Days</td>
                            <td colspan="18">Over Time</td>
                            <td colspan="4"></td>
                            <td class="sticky-rows">Total</td>
                        </tr>
                        <tr>
                            <td colspan="2"></td>
                            <td>WD</td>
                            <td>Amount</td>
                            <td>RD</td>
                            <td>Amount</td>
                            <td>SH</td>
                            <td>Amount</td>
                            <td>RH</td>
                            <td>Amount</td>
                            <td>DH</td>
                            <td>Amount</td>
                            <td>SH-RD</td>
                            <td>Amount</td>
                            <td>RH-RD</td>
                            <td>Amount</td>
                            <td>DH-RD</td>
                            <td>Amount</td>
                            <td class="total-bg">Total Days</td>
                            <td class="total-bg">Total Amount</td>
                            <td>WD</td>
                            <td>Amount</td>
                            <td>RD</td>
                            <td>Amount</td>
                            <td>SH</td>
                            <td>Amount</td>
                            <td>RH</td>
                            <td>Amount</td>
                            <td>DH</td>
                            <td>Amount</td>
                            <td>SH-RD</td>
                            <td>Amount</td>
                            <td>RH-RD</td>
                            <td>Amount</td>
                            <td>DH-RD</td>
                            <td>Amount</td>
                            <td class="total-bg">Total Hours</td>
                            <td class="total-bg">Total Amount</td>
                            <td>Agency Fee</td>
                            <td>Employer Share</td>
                            <td>W/H Tax</td>
                            <td>VAT</td>
                            <td class="sticky-rows"></td>
                        </tr>
                        <tr>
                            <td>Personnel</td>
                            <td>Post</td>
                            <td class="text-info" id="tdDailyRate">
                                ({{ number_format($billingRecord->wd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->rd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->sh_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->rh_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->dh_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->shrd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->rhrd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->dhrd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="total-bg"></td>
                            <td class="total-bg"></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_wd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_rd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_sh_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->regularRateOt, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_dh_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_shrd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_rhrd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="text-info">
                                ({{ number_format($billingRecord->ot_dhrd_rate, 2)}})
                            </td>
                            <td></td>
                            <td class="total-bg"></td>
                            <td class="total-bg"></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td class="sticky-rows"></td>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($billingPersonnels as $billingPersonnel)
                            <tr class="trOnBody">
                                <td>{{ $billingPersonnel->last_name . ', ' . $billingPersonnel->first_name }}</td>
                                <td>{{ $billingPersonnel->branch_name }}</td>
                                <td>{{ $billingPersonnel->wd }}</td>
                                <td>{{ number_format($billingPersonnel->wd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->rd }}</td>
                                <td>{{ number_format($billingPersonnel->rd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->sh }}</td>
                                <td>{{ number_format($billingPersonnel->sh_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->rh }}</td>
                                <td>{{ number_format($billingPersonnel->rh_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->dh }}</td>
                                <td>{{ number_format($billingPersonnel->dh_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->shrd }}</td>
                                <td>{{ number_format($billingPersonnel->shrd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->rhrd }}</td>
                                <td>{{ number_format($billingPersonnel->rhrd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->dhrd }}</td>
                                <td>{{ number_format($billingPersonnel->dhrd_amount, 2) }}</td>
                                <td class="total-bg">{{ $billingPersonnel->total_work_days }}</td>
                                <td class="total-bg">{{ number_format($billingPersonnel->total_work_days_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_wd }}</td>
                                <td>{{ number_format($billingPersonnel->ot_wd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_rd }}</td>
                                <td>{{ number_format($billingPersonnel->ot_rd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_sh }}</td>
                                <td>{{ number_format($billingPersonnel->ot_sh_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_rh }}</td>
                                <td>{{ number_format($billingPersonnel->ot_rh_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_dh }}</td>
                                <td>{{ number_format($billingPersonnel->ot_dh_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_shrd }}</td>
                                <td>{{ number_format($billingPersonnel->ot_shrd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_rhrd }}</td>
                                <td>{{ number_format($billingPersonnel->ot_rhrd_amount, 2) }}</td>
                                <td>{{ $billingPersonnel->ot_dhrd }}</td>
                                <td>{{ number_format($billingPersonnel->ot_dhrd_amount, 2) }}</td>
                                <td class="total-bg">{{ $billingPersonnel->total_ot_hours }}</td>
                                <td class="total-bg">{{ number_format($billingPersonnel->total_ot_amount, 2) }}</td>
                                <td>{{ number_format($billingPersonnel->agency_fee, 2) }}</td>
                                <td>{{ number_format($billingPersonnel->employee_share, 2) }}</td>
                                <td>{{ number_format($billingPersonnel->withholding_tax, 2) }}</td>
                                <td>{{ number_format($billingPersonnel->vat, 2) }}</td>
                                <td class="tdTotal sticky-rows">₱{{ number_format($billingPersonnel->total, 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td colspan="41"></td>
                            <td class="font-weight-bold">Total</td>
                            <td class="font-weight-bold sticky-rows">₱{{ number_format($billingRecord->grand_total, 2)}}</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
        <div class="card-footer">
        </div>
    </div>
</div>
@endsection