@php
    $count_package_deals = count($order->package_deals);
    $install_charge = $order->install_charge;
    $install_return_charge = 0;
    $warranty_charge = $order->warranty_charge;
    $addons_due = 0;
    $balance_due = $balance_due;
    if($type == "order"){
        $install_charge = $order->install_charge;
        $warranty_charge = $order->warranty_charge;
        
        $addons_due = $balance_due_install +  $balance_due_warranty;
        
        $install_return_charge = collect($order->install_return)->sum(function ($q) { return $q->quantity * $q->install_price; });
    }

    $actual_install_charge = $install_charge - $install_return_charge;

    $balance_due +=  $addons_due;

    $item_delivery_charge_quantity = collect($order->order_delivery_options)->sum(function ($q) {
        return $q->quantity;
    });
    $item_delivery_charge = collect($order->order_delivery_options)->sum(function ($q) {
        return $q->delivery_charge * $q->quantity;
    });
    
    $tax = $order->tax_price;
    // $out_of_state = ((stripos($order->ship_address, $order->store->state_code ) == false && stripos($order->ship_address, $order->store->state_name) == false) && $order->out_of_state == 0);
    // if(!$order->tax_exempted){
    //     $tax = $order_detail->sum(function($item) use ($order) {
    //         return $item->is_taxed ? ($item->subtotal_price * $order->tax) / 100:0;
    //     });
    // }
    $total = $order->subtotal + $install_charge + $warranty_charge + $tax + $order->delivery_charge + $item_delivery_charge + $order->item_haul_away_charge + $order->trip_charge;
    
    $total_after_refund = 0;
    $refund = 0;
    $order_credit_line_refund = 0;
    $total_after_refund = $total;
    if ($type == 'order') {
        $refund = $order->order_return->sum(function($item) {
            return $item->amount;
        });
        $order_credit_line_refund =  collect($order->order_return)->where("return_payment_option", "credit_line")->sum("amount");
        $total_after_refund = $total - $refund;

        
    }
    $credit_line_balance_due -= $order_credit_line_refund;
    // $credit_line_balance_due -= str_replace(",","", number_format($refund, 2));
    $payment = 0;
@endphp
<table width="100%" style="margin-top: 10px;">
    <tr>
        <th class="text-right font-weight-ligth" style="width: 150px;">Product Total</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->subtotal, 2) }}</td>
    </tr>
    @if($order->tax_type == 1)
    <tr>
        <th class="text-right font-weight-ligth">Sales Tax
            @if ((stripos($order->ship_address, $order->store->state_code ) == false && stripos($order->ship_address, $order->store->state_name) == false) && $order->out_of_state == 0)
                (Out of State)
            @elseif ($order->tax_exempted)
                (Tax Exempted)
            @else
                {{removeSlymanBros($order->store->store_name)}} ({{$order->tax}}%)
            @endif
        </th> 
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($tax,2) }}</td>
    </tr>
    @else
        @if ((stripos($order->ship_address, $order->store->state_code ) == false && stripos($order->ship_address, $order->store->state_name) == false) && $order->out_of_state == 0)
            <tr>
                <th class="text-right font-weight-ligth"> Sales Tax (Out of State)</th>
                <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">$0.00</td>
            </tr>
        @elseif ($order->tax_exempted)
            <tr>
                <th class="text-right font-weight-ligth"> Sales Tax (Tax Exempted)</th>
                <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">$0.00</td>
            </tr>
        @else
                {{-- <tr>
                    <th class="text-right font-weight-ligth">State Tax Rate - {{$order->tax_detail["state_name"]}} ({{$order->tax_detail["state_rate"]}}%)</th>
                    <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->tax_detail["state_rate_price"],2) }}</td>
                </tr>
                <tr>
                    <th class="text-right font-weight-ligth">County Tax Rate - {{$order->tax_detail["county_name"]}} ({{$order->tax_detail["county_rate"]}}%)</th>
                    <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->tax_detail["county_rate_price"],2) }}</td>
                </tr>
                <tr>
                    <th class="text-right font-weight-ligth">City Tax Rate - {{$order->tax_detail["city_name"]}} ({{$order->tax_detail["city_rate"]}}%)</th>
                    <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->tax_detail["city_rate_price"],2) }}</td>
                </tr>
                <tr>
                    <th class="text-right font-weight-ligth">District Rate Tax - N/A ({{$order->tax_detail["district_rate"]}}%)</th>
                    <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->tax_detail["district_rate_price"],2) }}</td>
                </tr> --}}
                <tr>
                    <th class="text-right font-weight-ligth">Total Sales Tax - ({{$order->tax}}%)</th>
                    <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->tax_price,2) }}</td>
                </tr>
          @endif
    @endif
    <tr style="{{ $item_delivery_charge_quantity > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-ligth">Line item delivery charges x{{ $item_delivery_charge_quantity }}</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($item_delivery_charge, 2) }}</td>
    </tr>

    @if($count_package_deals > 0)
        @foreach($order->package_deals as $package_deal)
            <tr style="">
                <th class="text-right font-weight-ligth">Package - {{ $package_deal->name }}</th>
                <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">-${{ number_format($package_deal->package_discount, 2) }}</td>
            </tr>
        @endforeach
    @endif

    <tr style="{{ $order->delivery_charge > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-ligth">Delivery Zone additional charge</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->delivery_charge,2) }}</td>
    </tr>
    <tr style="{{ $actual_install_charge > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-ligth">Install Charge</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($actual_install_charge, 2) }}</td>
    </tr>
    <tr style="{{ $warranty_charge > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-ligth">Protection Plan Charge</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($warranty_charge, 2) }}</td>
    </tr>
    <tr  style="{{ $order->item_haul_away_charge > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-ligth">Haul Away Charge</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->item_haul_away_charge,2) }}</td>
    </tr>
    <tr style="{{ $order->discount > 0 ? '':'display:none;' }} vertical-align: bottom;">
        <th class="text-right">
            <div class="font-weight-bold">Instant Rebate</div>

            @foreach ($order->rebates as $key => $item)
            <div class="">{{ $item->name }}</div>
            @endforeach
        </th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold">
            {{-- ${{ number_format($order->discount,2) }} --}}
            @foreach ($order->rebates as $key => $item)
                @if ($item->type == 0)
                <div class="">-{{ $item->amount }}%</div>
                @else
                <div class="">-${{ number_format($item->amount ,2) }}</div>
                @endif
            @endforeach
        </td>
    </tr>

    <tr style="{{ $order->coupon_discount > 0 ? '':'display:none;' }} vertical-align: bottom;">
        <th class="text-right">
            <div class="font-weight-bold">Promo Code</div>
            
            @foreach ($order->coupons as $key => $item)
            <div class="">{{ $item->name }}</div>
            @endforeach
        </th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold">
            @foreach ($order->coupons as $key => $item)
                @if ($item->type == 0)
                <div class="">-{{ $item->amount }}%</div>
                @else
                <div class="">-${{ number_format($order->coupon_discount ,2) }}</div>
                @endif
            @endforeach
        </td>
    </tr>
    
    <tr  style="{{ $order->trip_charge > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-ligth">Trip Charges</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-ligth">${{ number_format($order->trip_charge,2) }}</td>
    </tr>
    <tr>
        <th class="text-right font-weight-bold">Total</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold">${{ number_format( $total_after_refund - $order->discount,2) }}</td>
    </tr>

    <tr>
        <th colspan="2"><hr></th>
    </tr>
    <tr style="{{ $order->payment->count() > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-bold">Record Payment</th>
    </tr>
    <tr style="{{ $order->payment->count() > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-bold">Amount Paid</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold" colspan="1"></td>
    </tr>
    @foreach ($order->payment as $item)
        <tr style="margin-bottom: 15px;">
            <td class="text-right ">
                Payment: {{ isset($item->payment_category_id) && isset($item->payment_category) && $item->payment_category_id == "3" ? $item->payment_category->name." ".$item->payment_method : $item->alias_name }}<br>
                @if($item->note && ($item->payment_method == 'credit_card' || $item->payment_method == 'check'))
                    <span></span> Transaction Number: {{ $item->note }}<br>
                    @if ($item->note2)
                        Note: {{ $item->note2 }} <br>
                    @endif
                @elseif($item->note)
                    Note: {{ $item->note }} <br>
                @endif
                Date: {{ $item->payment_date }}
            </td>
            <td style="padding-left: 40px; width: 100px; vertical-align: top;"  class="font-weight-bold">${{ number_format(($item->payment_method == "credit_line"?$item->amount - $refund:$item->amount), 2) }}</td>
        </tr>
        @php $payment +=  ($item->payment_method == "credit_line"?$item->amount - $refund:$item->amount) @endphp
    @endforeach

    @if($type == "order")
        @if(!empty($order->repayment_credit_line))
            @if(count($order->repayment_credit_line) > 0)
                @foreach ($order->repayment_credit_line as $item)
                    <tr style="margin-bottom: 15px;">
                        <td class="text-right">
                            {{ str_replace("repayment_credit_line:", "Repayment Credit Line:", $item->payment_method) }}<br>
                            @if($item->note && (strpos("credit_card", $item->payment_method) !== false || strpos("check", $item->payment_method) !== false))
                                <span></span> Transaction Number: {{ $item->note }}<br>
                                @if ($item->note2)
                                    Note: {{ $item->note2 }} <br>
                                @endif
                            @elseif($item->note)
                                Note: {{ $item->note }} <br>
                            @endif
                            Date: {{ $item->payment_date }}
                        </td>
                        <td style="padding-left: 40px; width: 100px; vertical-align: top;"  class="font-weight-bold">${{ number_format($item->amount, 2) }}</td>
                    </tr>
                @endforeach
            @endif
        @endif
        
        <tr>
            <th colspan="2"><hr></th>
        </tr>
        <tr style="{{ $order->payment_credit_line_refund->count() > 0 ? '':'display:none' }}">
            <th class="text-right font-weight-bold text-danger" >Credit Line Refund</th>
        </tr>
        <tr style="{{ $order->payment_credit_line_refund->count() > 0 ? '':'display:none' }}">
            <th class="text-right font-weight-bold text-danger">Amount Paid</th>
            <td style="padding-left: 40px; width: 100px;" class="font-weight-bold" colspan="1"></td>
        </tr>
   
        @foreach ($order->payment_credit_line_refund as $item)
            <tr style="margin-bottom: 15px;" class="text-danger">
                <td class="text-right ">
                    Payment: {{ $item->payment_method }}<br>
                    Transaction Number: {{ $item->note }}<br>
                    Date: {{ $item->payment_date }}
                </td>
                <td style="padding-left: 40px; width: 100px; vertical-align: top;"  class="font-weight-bold" >-${{ number_format($item->amount, 2) }}</td>
            </tr>
        @endforeach
    @endif

    @if($order->is_credit_line == 1)
    <tr>
        <th class="text-right font-weight-bold">Credit Line Balance Due</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold">${{ number_format($credit_line_balance_due,2) }}</td>
    </tr>
    @endif
    @if(($order->is_credit_line == 1 && $balance_due > 0) || ($order->is_credit_line == 0))
        <tr>
            <th class="text-right font-weight-bold"> @if($order->is_credit_line == 1) Additional Balance Due @else Balance Due @endif</th>
            <td style="padding-left: 40px; width: 100px;" class="font-weight-bold">${{ number_format($balance_due,2) }}</td>
        </tr>
    @endif

    {{-- Template For Refund --}}
    <tr style="{{ $order->payment_refund->count() > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-bold text-danger" >Refund</th>
    </tr>
    <tr style="{{ $order->payment_refund->count() > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-bold text-danger">Amount Paid</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold" colspan="1"></td>
    </tr>
    {{-- Template For Refund --}}
    @foreach ($order->payment_refund as $item)
        <tr style="margin-bottom: 15px;" class="text-danger">
            <td class="text-right ">
                Payment: {{ isset($item->payment_category_id) && isset($item->payment_category) && $item->payment_category_id == "3" ? $item->payment_category->name." ".$item->payment_method : $item->payment_method }}<br>
                Transaction Number: {{ $item->note }}<br>
                Date: {{ $item->payment_date }}
            </td>
            <td style="padding-left: 40px; width: 100px; vertical-align: top;"  class="font-weight-bold" >-${{ number_format($item->amount, 2) }}</td>
        </tr>
        @php $payment += $item->amoun @endphp
    @endforeach
    <tr style="{{ $order->payment_refund->count() > 0 ? '':'display:none' }}">
        <th colspan="2"><hr></th>
    </tr>

    <tr style="{{ $change_due > 0 ? '':'display:none' }}">
        <th class="text-right font-weight-bold">Change Due</th>
        <td style="padding-left: 40px; width: 100px;" class="font-weight-bold">${{ number_format($change_due,2) }}</td>
    </tr>
</table>