@extends('layouts.print')
@section('title', 'BWSI')

@section('body')
<style type="text/css">
    @page {
        size: portrait;
    }

    .table {
        margin-bottom: 15px;
    }

    .table > tbody > tr > td {
        padding-top: 2px;
        padding-bottom: 6px;
    }

    @media print {    
        #table-report {
            font-size: 9px;
        }
    }
</style>

<div class="wrapper">
    <div class="row">
        <section class="invoice" style="padding-top:5px; border:0px">
            <p class="text-center" style="margin-bottom:0px"><b>{{ session('company_name') }}</b></p>
            <p class="text-center text-muted">{{ session('branch_name') }}</p>
            <p class="text-center" style="margin-bottom:0px"><b>Service Application - Assessment of Fees</b></p><br>

            <div class="col-xs-12">
                <div class="row invoice-info">
                    <div class="col-xs-12">
                        <table class="table table-bordered" id="table-report">
                            <tbody>
                                <tr>
                                    <td colspan="1">
                                        <dt>Application Number</dt>
                                        <dd>{{ $data->application_number }}</dd>
                                    </td>
                                    <td colspan="1">
                                        <dt>Customer's Name</dt>
                                        <dd>{{ $data->cust_bname ? strtoupper($data->cust_bname) : strtoupper($data->cust_fname) }}</dd>
                                    </td>
                                    <td colspan="2">
                                        <dt>Address</dt>
                                        <dd>{{ strtoupper($data->complete_address) }}</dd>
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="1">
                                        <dt>Account Classification</dt>
                                        <dd>{{ strtoupper($data->acct_class) }} - {{ strtoupper($data->acct_subclass) }}</dd>
                                    </td>
                                    <td colspan="1">
                                        <dt>Connection Type</dt>
                                        <dd>{{ strtoupper($data->connection_type) }}</dd>
                                    </td>
                                    <td colspan="2">
                                        <dt>Availed Promo</dt>
                                        <dd>{{ strtoupper($data->promo_title) }}</dd>
                                    </td>
                                </tr>
                            </tbody>
                        </table>

                        <b><i>BREAKDOWN OF FEES</i></b>
                        <table class="table table-bordered" id="table-report">
                            <thead>
                                <tr>
                                    <th>PARTICULARS</th>
                                    <th class="text-right">BASIC</th>
                                    {{-- <th class="text-right">- SENIOR</th> --}}
                                    <th class="text-right">- DISC.</th>
                                    <th class="text-right">+ INT.</th>
                                    <th class="text-right">NET</th>
                                    <th>PAYMENT METHOD</th>
                                    <th class="text-right">- INITIAL</th>
                                    <th class="text-right">REMAINING</th>
                                    <th class="text-right">TERMS</th>
                                    <th width="10%" class="text-right">MONTHLY</th>
                                    <th width="10%" class="text-right">TO PAY</th>
                                </tr>
                            </thead>
                            <tbody>
                            @foreach($data->fees AS $f)
                                <tr>
                                    <td colspan="1">{{ strtoupper($f->particulars) }}</td>
                                    <td colspan="1" class="text-right">{{ number_format($f->amt_basic,2,".",",") }}</td>
                                    {{-- <td colspan="1" class="text-right">({{ number_format($f->senior_amt,2,".",",") }})</td> --}}
                                    <td colspan="1" class="text-right">({{ number_format($f->discount_amt,2,".",",") }})</td>
                                    <td colspan="1" class="text-right">{{ number_format($f->interest_amt,2,".",",") }}</td>
                                    <td colspan="1" class="text-right">{{ number_format($f->amt_net,2,".",",") }}</td>
                                    <td colspan="1">
                                        @if($f->payment_method == 'atb')
                                            {{ "ADD TO BILL" }}
                                        @else
                                            {{ "FULL PAYMENT" }}
                                        @endif
                                    </td>
                                    <td colspan="1" class="text-right">({{ number_format($f->amt_initial,2,".",",") }})</td>
                                    <td colspan="1" class="text-right">{{ number_format($f->amt_remaining,2,".",",") }}</td>
                                    <td colspan="1" class="text-right">{{ $f->terms ? $f->terms : "-" }}</td>
                                    <td colspan="1" class="text-right">{{ number_format($f->amortization,2,".",",") }}</td>
                                    <td colspan="1" class="text-right">
                                        @if($f->payment_method == 'atb')
                                            {{ number_format($f->amt_initial,2,".",",") }}
                                        @else
                                            {{ number_format($f->amt_net,2,".",",") }}
                                        @endif
                                    </td>
                                </tr>
                            @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="10">AMOUNT TO PAY</th>
                                    <td colspan="2" class="text-right" style="font-size:16px; font-weight:bold">
                                        {{ number_format(($data->fees->whereIn('payment_method', ['atb'])->sum('amt_initial') + $data->fees->whereIn('payment_method', ['full'])->sum('amt_net')),2,".",",") }}
                                    </td>
                                </tr>
                            </tfoot>
                        </table>
                        <br>

                        @foreach($data->fees AS $f)
                            @if($f->details)
                                <b><i>{{ strtoupper($f->particulars) }}</i></b>
                                @if(strtoupper($f->particulars) == 'SERVICE FEE')
                                <table class="table table-bordered" id="table-report">
                                    <thead>
                                        <tr>
                                            <th>DESCRIPTION</th>
                                            <th class="text-right">TOTAL PRICE</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($f->details AS $d)
                                        <tr>
                                            <td width="80%">{{ strtoupper($d["category"]) }}</td>
                                            <td width="20%" class="text-right">{{ number_format($d["service_fee"],2,".",",") }}</td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                                @endif

                                @if(strtoupper($f->particulars) == 'MATERIALS')
                                <table class="table table-bordered" id="table-report">
                                    <thead>
                                        <tr>
                                            <th>DESCRIPTION</th>
                                            <th class="text-right">UNIT PRICE</th>
                                            <th class="text-right">UoM</th>
                                            <th class="text-right">QTY</th>
                                            <th class="text-right">TOTAL PRICE</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($f->details AS $d)
                                        <tr>
                                            <td width="44%">{{ strtoupper($d["material_description"]) }}</td>
                                            <td width="12%" class="text-right">{{ number_format($d["unit_price"],2,".",",") }}</td>
                                            <td width="12%" class="text-right">{{ strtoupper($d["uom"]) }}</td>
                                            <td width="12%" class="text-right">{{ number_format($d["uom_value"],0,".",",") }}</td>
                                            <td width="20%" class="text-right">{{ number_format($d["total_price"],2,".",",") }}</td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                                @endif
                            @endif
                        @endforeach
                    </div>
                </div>

                <p class="text-danger"><i>*Materials and service fees are subject to change without prior notice. Please confirm with the branch before proceeding with payment or preparing a cheque.</i></p>
                <p class="text-danger"><i>*Please present this assessment of fees printout to our teller/cashier for the payment of your service application.</i></p>
            </div>
        </section>
    </div>
</div>

<script type="text/javascript">
    (function() {
       window.print();
    })();
</script>
@endsection