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

@section('body')
<section class="invoice" style="font-size:10pt">
    <div class="row">
        <div class="col-xs-12">
            <p class="text-center text-bold" style="margin-bottom:0pt; margin-top:0pt">{{ session('branch_name') }}</p>
            <p class="text-center"           style="margin-bottom:0pt; margin-top:0pt">{{ session('branch_address') }}</p>
            <p class="text-center">Customer Application - Change Connection Type Summary</p>
        </div>

        <div class="invoice-info" style="margin-top: 100px">
            <div class="col-xs-12">
                <table width="100%">
                    <tr>
                        <td><strong>Customer's Name:</strong> {{ strtoupper($summary->cust_name) }}</td>
                    </tr>
                    <tr>
                        <td><strong>Service Address:</strong> {{ strtoupper($summary->complete_address) }}</td>
                    </tr>
                    <tr>
                        <td><strong>Advance Payment:</strong> {{ number_format($summary->advance_amt,2,".",",") }}</td>
                    </tr>
                </table>
    
                <br>

                <small><i>Previous ({{ $summary->ctype_old }})</i></small>
                <table style="width: 100%">
                    <thead>
                        <tr>
                            <th width="18%">Particulars</th>
                            <th width="8%" class="text-right">Basic</th>
                            <th width="8%" class="text-right">Discount</th>
                            <th width="8%" class="text-right">Interest</th>
                            <th width="8%" class="text-right">Advances</th>
                            <th width="10%" class="text-right">Amount Due</th>
                            <th width="22%" class="text-right">Amt Paid</th>
                            <th width="8%" class="text-right">Balance</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($old AS $d)
                        <tr>
                            <td>{{ strtoupper($d->particulars) }}</td>
                            <td class="text-right">{{ $d->amt_basic }}</td>
                            <td class="text-right">({{ $d->discount_amt }})</td>
                            <td class="text-right">{{ $d->interest_amt }}</td>
                            <td class="text-right">({{ $d->amt_advance }})</td>
                            <td class="text-right">{{ $d->amt_due }}</td>
                            <td class="text-right">({{ number_format($d->col_amt_paid,2,".",",") }})</td>
                            <td class="text-right">{{ number_format($d->amt_due - $d->amt_paid,2,".",",") }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td colspan="6" class="text-right">{{ number_format($old->sum('amt_due'),2,".",",") }}</td>
                            <td colspan="1" class="text-right text-success">({{ number_format($old->sum('col_amt_paid'),2,".",",") }})</td>
                            <td colspan="1" class="text-right">{{ number_format($new->sum('amt_due') - $new->sum('amt_paid'),2,".",",") }}</td>
                        </tr>
                    </tfoot>
                </table>

                <br>

                <small><i>New ({{ $summary->ctype_new }})</i></small>
                <table style="width: 100%;">
                    <thead>
                        <tr>
                            <th width="18%">Particulars</th>
                            <th width="8%" class="text-right">Basic</th>
                            <th width="8%" class="text-right">Discount</th>
                            <th width="8%" class="text-right">Interest</th>
                            <th width="8%" class="text-right">Advances</th>
                            <th width="10%" class="text-right">Amount Due</th>
                            <th width="14%" class="text-right">Prev. Payment Offset</th>
                            <th width="8%" class="text-right">Amt Paid</th>
                            <th width="8%" class="text-right">Balance</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($new AS $d)
                        <tr>
                            <td>{{ strtoupper($d->particulars) }}</td>
                            <td class="text-right">{{ $d->amt_basic }}</td>
                            <td class="text-right">({{ $d->discount_amt }})</td>
                            <td class="text-right">{{ $d->interest_amt }}</td>
                            <td class="text-right">({{ $d->amt_advance }})</td>
                            <td class="text-right">{{ $d->amt_due }}</td>
                            <td class="text-right">({{ number_format($d->amt_paid-$d->col_amt_paid,2,".",",") }})</td>
                            <td class="text-right">({{ number_format($d->col_amt_paid,2,".",",") }})</td>
                            <td class="text-right">{{ number_format($d->amt_due - $d->amt_paid,2,".",",") }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td colspan="6" class="text-right text-danger">{{ number_format($new->sum('amt_due'),2,".",",") }}</td>
                            <td colspan="1" class="text-right text-success">({{ number_format($new->sum('amt_paid') - $new->sum('col_amt_paid'),2,".",",") }})</td>
                            <td colspan="1" class="text-right">({{ number_format($new->sum('col_amt_paid'),2,".",",") }})</td>
                            <td colspan="1" class="text-right">{{ number_format($new->sum('amt_due') - $new->sum('amt_paid'),2,".",",") }}</td>
                        </tr>
                    </tfoot>
                </table>

                <br>
                <strong>Deficit: </strong><span>{{ number_format($summary->deficit,2,".",",") }}</span><br>
                <strong>Refundable: </strong><span>{{ number_format($summary->refund,2,".",",") }}</span><br>
                <strong>Refund Option: </strong><span>{{ ucwords($summary->refund_option) }}</span><br>
                <strong>Voucher No: </strong><span>{{ $summary->voucher_no }}</span>

                <hr>
                <strong>Prepared By</strong><br>
                <span>{{ ucwords($summary->created_by) }} at {{ strtoupper($summary->created_at) }}</span>
            </div>
        </div>
    </div>
</section>

<script src="{{ URL::asset('adminlte/plugins/jQuery/jquery-2.2.3.min.js') }}"></script>
<script src="{{ URL::asset('js/printThis.js') }}"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $('.invoice').printThis({
            importCSS: true,
        });
    });
</script>
@endsection