@extends('layouts.pdf')




@section('title')
    Utility Bill
@stop
@section('content')
<style type="text/css" media="all">
    div[size="A4"] {
        font-family: Verdana, Geneva, sans-serif !important;
        line-height: 18px
    }

    h5,
    h6,
    p {
        font-family: Verdana, Geneva, sans-serif;
    }

    table td,
    table th,
    h6,
    p {
        font-size: 10px !important;
    }

    h5 {
        font-size: 12px !important;
        font-weight: 600;
    }

    .table td {
        border-top: 0px;
    }

    table th,
    table td {
        padding: 5px !important;
    }

    .table-sm td {
        padding: 0px !important;
    }

    body {
        font-size: 1rem;
    }

    table {
        font-size: 0.5rem;
    }

    footer {
        font-size: 10px !important;
        /* color:#ccc; */
        position: fixed;
        bottom: -60px;
        left: 0px;
        right: 0px;
        height: 50px;
        /** Extra personal styles **/
        /* background-color: #03a9f4;
            color: white; */
        text-align: right;
    }

    .box {
        background-color: #0D1117;
        color: #ffffff;
        text-transform: uppercase;
        width: 40% !important;
        margin: auto;
        padding: 0px 50px;
        padding-top: 10px;
        padding-bottom: 5px;
        letter-spacing: 2px;
        font-weight: bolder !important;
        margin-top: -10px;
        margin-bottom: 11px;
        font-size: 20px !important
    }

    .th-new {
        padding-bottom: 12px !important;
    }

    .table th {
        background: #000 !important;
    }

    .office_copy {
        font-weight: bolder;
        top: 40;
        width: 150px;
        text-align: center;
        border-radius: 10px;
        border: 2px solid #000;
        margin-left: 280px;
    }

    .header_company_address {
        padding: 2px;
        text-align: center !important;
        font-size: 16px !important
    }

    .header_company_name {
        padding: 2px;
        margin: 5px 0px;
        text-align: center !important;
        font-size: 24px !important
    }

    .header_company_logo {
        width: 120px !important
    }

    .electricty-table {
        padding: 0px !important
    }

    .electricty-table tr {
        height: 10px !important;
    }

    .electricty-table tr td {
        padding: 0px !important;
        margin: 0px !important;
    }
    .pad-1 td{
        padding: 1px !important;
    }
    
    .dashed-line {
        border: 1px dashed black;
    }
    /* .general_bill_info tr th{
        background-color: grey !important;
    } */
    .nopad {
        padding: 0 !important;
    }

   .bill_info  td {
            line-height: 100% !important;
            height: 7px !important;
        }
    .bill_info_div {

        height: 260px ;
    }
    .bill_instruction_div {

        height: 350px;
    }
    .previous_bills{
        width:300px;
    }

</style>


    <div class="container-fluid">
        @foreach ($electric_bills as $electric_bill)
              @php
                    $bill_month = '1-' . $electric_bill->month . '-' . $electric_bill->year;
                    $bill_month = date('M-Y', strtotime($bill_month));

                    $total_amount_with_arrears = $electric_bill->total_amount + $electric_bill->arrears_amount;
                    $total_amount_due_date_with_arrears = $electric_bill->amount_after_due_date + $electric_bill->arrears_amount;

                    $bank_name = $general_setting->bank_name;
                    $account_title = $general_setting->account_title;
                    $account_no = $general_setting->account_no;

                    $intructions_content =$general_setting->maintenance_bill_instruction_text;
                    $penalty_content = $general_setting->maintenance_fine_text;
                @endphp

                {{-- @include('admin.maintenance.partial.pdf.bill_header', ['extra' => $extra]) --}}

                <div style="margin-bottom: 2rem">
                    @include('admin.maintenance.partial.pdf.letter_head')
                </div>

                @include('admin.maintenance.partial.pdf.bill_special_txt')
                
                <div class="box">
                    <h4 class="text-a-c margin-top-20">{{ $extra['bill_name'] }}</h4>
                </div>

                <div >
                    <table  style="width:100%">
                        @php 
                            $name = $electric_bill->owner->name;

                            if(config('facility_settings.name_on_bill') == 'owner'){
                                $name = $electric_bill->product->property_owner->name;
                            }

                        @endphp
                        <tbody>
                            <tr class="pad-1">
                                <td style="font-size:15px !important"><b>{{ $name }}</b></td>
                            </tr>
                            <tr class="pad-1">
                                <td style="width:20%"><b>Address</b></td>
                                <td> : {{ $electric_bill->product->branch->name }}</td>
                            </tr>
                            <tr class="pad-1">
                                <td><b>Property/Unit Id</b></td>
                                <td> : {{ $electric_bill->product->product_unique_id }}</td>
                            </tr>
                            <tr class="pad-1">
                                <td><b>Registration No</b></td>
                                <td> : {{ $electric_bill->product->sell->registration_no ?? '-' }}</td>
                            </tr>
                            <tr class="pad-1">
                                <td><b>Block</b></td>
                                <td> : {{ $electric_bill->product->block->name ?? '-' }}</td>
                            </tr>
                        </tbody>
                    </table>

                    <table class="table table-bordered general_bill_info mt-2" style="width:100%">
                        <tbody>
                            <tr>
                                <th> {{ $bank_name }} No     </th>
                                <th> Billing Month      </th>
                                <th> Issue Date         </th>
                                <th> Due Date           </th>
                                <th> Meter Reading Date </th>
                            </tr>
                            <tr>
                                <td>{{ $account_no }}</td>
                                <td>{{ $bill_month }}</td>
                                <td>{{ $transaction->date_format($electric_bill->created_at) }}</td>
                                <td>{{ $transaction->date_format($electric_bill->bill_date) }}</td>
                                <td>{{ $transaction->date_format($electric_bill->meter_reading_date) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>

                <div>
                    <table style="width: 100%">
                        <tbody>
                            <tr>
                                <td style="width:70%" class="nopad">
                                    <div style="border:1px solid #dde0e7;" class="bill_info_div">
                                        <table class="table table-bordered" style="width: 100%; margin:0px ">
                                            <tbody>
                                                <tr>
                                                    <th> Reference No </th>
                                                    <th> Category </th>
                                                    <th> METER NO </th>

                                                </tr>
                                                <tr>
                                                    <td>{{ $electric_bill->bill_no }}</td>
                                                    <td>{{ strtoupper($electric_bill->product->type->type) }}</td>
                                                    <td>{{ $electric_bill->product->electricity_meter_no }}</td>

                                                </tr>
                                            </tbody>
                                        </table>
                                        <table class="table table-bordered" style="width: 100%;margin:0px">
                                            <tbody>
                                                <tr>
                                                    <th> PREVIOUS </th>
                                                    <th> PRESENT </th>
                                                    <th> UNITS </th>
                                                    <th> RATE {{$transaction->systemSettingCurrency()}} </th>
                                                    <th> BILL AMOUNT {{$transaction->systemSettingCurrency()}}</th>
                                                </tr>
                                                <tr>
                                                    <td> {{ $electric_bill->previous_reading }}</td>
                                                    <td> {{ $electric_bill->current_reading }}</td>
                                                    <td> {{ $electric_bill->units }}</td>
                                                    <td> {{ $electric_bill->unit_rate }}</td>
                                                    <td> {{ $transaction->convert_money_format($electric_bill->amount) }}</td>
                                                </tr>
                                            </tbody>
                                        </table>

                                        <div style="margin-top:1rem">

                                                                                
                                                @if (!empty($image_url) && file_exists(public_path($image_url) ))
                                                    <img  style="height:100px ; max-width:500px; border-radius:5px"  src="{{ asset($image_url) }}"
                                                        alt="">
                                                @endif

                                        </div>
                                    </div>

                                </td>
                                <td class="nopad">
                                    <div style="border:1px solid #dde0e7;" class="bill_info_div">
                                        <table class=" table bill_info " style="width: 100%;">
                                            <tbody>
                                                <tr>
                                                    <th colspan="2"> ELECTRICITY </th>
                                                </tr>
                                                <tr>
                                                    <td>COST OF ELECTRICITY</td>
                                                    <td class="text-right">{{ $electric_bill->unit_rate }}</td>
                                                </tr>
                                                <tr>
                                                    <td>UNITS</td>
                                                    <td class="text-right">{{ $electric_bill->units }}</td>
                                                </tr>

                                                <tr>
                                                    <td>BILL AMOUNT {{$transaction->systemSettingCurrency()}}</td>
                                                    <td class="text-right">{{ $transaction->convert_money_format($electric_bill->amount) }}</td>
                                                </tr>

                                                @if($electric_bill->tax_amount > 0)
                                                <tr>
                                                    <td>TAX AMOUNT {{$transaction->systemSettingCurrency()}}</td>
                                                    <td class="text-right">{{ $transaction->convert_money_format($electric_bill->tax_amount) }}</td>
                                                </tr>
                                                @endif

                                                @if($electric_bill->ptv_fee_amount > 0)
                                                <tr>
                                                    <td>{{ __('lang.o_m_charges')}}</td>
                                                    <td class="text-right">{{ $transaction->convert_money_format($electric_bill->ptv_fee_amount) }}</td>
                                                </tr>
                                                @endif

                                                @if($electric_bill->radio_fee_amount > 0)
                                                <tr>
                                                    <td>{{ __('lang.fuel_adjustment')}}</td>
                                                    <td class="text-right">{{ $transaction->convert_money_format($electric_bill->radio_fee_amount) }}</td>
                                                </tr>
                                                @endif

                                                @if($electric_bill->reconnection_charges > 0)
                                                <tr>
                                                    <td>{{ __('lang.reconnection_charges')}}</td>
                                                    <td class="text-right">{{ $transaction->convert_money_format($electric_bill->reconnection_charges) }}</td>
                                                </tr>
                                                @endif

                                                @if($electric_bill->discount > 0)
                                                <tr>
                                                    <td>DISCOUNT AMOUNT {{$transaction->systemSettingCurrency()}}</td>
                                                    <td class="text-right">{{ $transaction->convert_money_format($electric_bill->discount) }}</td>
                                                </tr>
                                                @endif

                                                <tr>
                                                    <td>ARREARS</td>
                                                    <td class="text-right"> {{ $transaction->convert_money_format($electric_bill->arrears_amount) }}</td>
                                                </tr>

                                                <tr>
                                                    <td><b>WITHIN DUE DATE</b></td>
                                                    <td class="text-right"><b>{{ $transaction->convert_money_format($total_amount_with_arrears) }}</b></td>
                                                <tr>
                                                    <td>LATE PAYMENT CHARGES</td>
                                                    <td class="text-right"> {{ $transaction->convert_money_format($electric_bill->surcharge_amount) }}</td>
                                                </tr>

                                                <tr>
                                                    <td><b>AFTER DUE DATE</b></td>
                                                    <td class="text-right"><b>{{ $transaction->convert_money_format($total_amount_due_date_with_arrears) }}</b></td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>


                                </td>
                            </tr>
                        </tbody>
                    </table>

                </div>

                
            <div class="mt-3">
                <table style="width: 100%">
                    <tbody>
                        <tr>
                            <td class="nopad">
                                @if (count($electric_bill->previous_bills) > 0)
                                    <div class="bill_instruction_div previous_bills">
                                        <table class="table table-bordered" style="width:100%">
                                            <tbody>
                                                {{-- <tr>
                                                    <th colspan="3" class="text-center"
                                                        style="font-size:12px !important; padding:1px !important; ">Previous
                                                        Bills</th>
                                                </tr> --}}
                                                <tr>
                                                    <th style="font-size:12px !important; padding:1px !important; width:400px; "
                                                        class="text-center">Month</th>
                                                    <th style="font-size:12px !important; padding:1px !important; width:400px; "
                                                        class="text-center">Amount {{$transaction->systemSettingCurrency()}}</th>
                                                    <th style="font-size:12px !important; padding:1px !important; width:400px; "
                                                        class="text-center">Payment</th>
                                                </tr>
                                                @foreach ($electric_bill->previous_bills->take(5) as $previous_bill)
                                                    @php
                                                        $bill_month = '1-' . $previous_bill->month . '-' . $previous_bill->year;
                                                        
                                                        $bill_month = date('M-Y', strtotime($bill_month));
                                                        
                                                        $bill_amount =  $previous_bill->total_amount;
                                                        
                                                        $created_at = date("Y-m-d", strtotime($electric_bill->created_at));

                                                        if(count($previous_bill->receipt_surcharge_items)>0 ||  
                                                            $previous_bill->amount_received_status != 'Settled' &&  $created_at > $previous_bill->bill_date)
                                                        {
                                                            $bill_amount = $previous_bill->amount_after_due_date;
                                                        }

                                                    @endphp
                                                    <tr class="pad-1">
                                                        <td class="text-center">{{ $bill_month }}</td>
                                                        <td class="text-center">
                                                            {{ $transaction->convert_money_format($bill_amount) }}
                                                        </td>
                                                        <td class="text-center">
                                                            {{ $transaction->convert_money_format($previous_bill->amount_received) }}
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                @endif
                            </td>
                            <td class="nopad">

                                <div style="padding-left:5px" class="bill_instruction_div">
                                    <table class="table" style="width:100%;">
                                        <tbody>
                                            
                                            @if(!empty($intructions_content))
                                                <tr>
                                                    <th style="font-size:12px !important; padding:1px !important;"> &nbsp; Instructions</th>
                                                </tr>
                                                <tr>
                                                    <td> 
                                                        @php echo $intructions_content;  @endphp
                                                    </td>
                                                </tr>
                                            @endif

                                            @if(!empty($penalty_content))
                                                <tr>
                                                    <th style="font-size:12px !important; padding:1px !important;"> &nbsp; Fine Penalty Details</th>
                                                </tr>
                                                <tr>
                                                    <td> 
                                                        @php echo $penalty_content;  @endphp
                                                    </td>
                                                </tr>
                                            @endif
                                            
                                        
                                        </tbody>


                                    </table>
                                </div>


                                  
                            </td>
                        </tr>

                    </tbody>
                </table>
            </div>

{{-- 
                @if(!empty($intructions_content))
                    <p style="font-size:20px !important;font-weight:bold" class="text-center" ><u>Instructions</u></p>
                    <p style="font-size: 20px !important"> @php echo $intructions_content;  @endphp</p>
                @endif

                @if(!empty($penalty_content))
                    <p style="font-size:20px !important;font-weight:bold" class="text-center" ><u>Fine Penalty Details</u></p>
                    <p style="font-size: 20px !important"> @php echo $penalty_content;  @endphp</p>
                    
                @endif --}}


                @php
                    $bill = $electric_bill;
                @endphp


                @include('admin.maintenance.utility-bill.partials.bank_details')
                
                @include('admin.maintenance.utility-bill.partials.bill_issued_by' , ['branch'=> $electric_bill->branch ])

        @endforeach

    </div>

@stop