{{--<input data-href="{{route('reports.company-income-statements.excel',['date_from'=>$date[0],'date_to'=>$date[1]])}}"--}}
{{--       id="income_statement_date" type="hidden">--}}

<table class="table table-bordered table-condensed logistics_table table-striped" id="route_invoice_status_list"
       style="margin-top: 10px">
    <tr>
        <td colspan="9" class="widgettitle"
            style="text-align: center;font-size: 14px;color: #000;line-height: 24px">
            Vandor Report - {{$vendor->name}}<br>
            From {{\Carbon\Carbon::parse($date[0])->toFormattedDateString()}}
            To {{\Carbon\Carbon::parse($date[1])->toFormattedDateString()}}
        </td>
    </tr>
    <tr>
        <th style="width: 9%">Date</th>
        <th style="width: 5%">LPO</th>
        <th style="width: 8%">Ref</th>
        <th style="width: 28%">Item Desc</th>
        <th style="width: 10%">Quantity</th>
        <th style="width: 10%">Price</th>
        <th style="width: 10%">Dr</th>
        <th style="width: 10%">Cr</th>
        <th style="width: 10%">Balance</th>
    </tr>
    {{--*/ $dr_total = 0 /*--}}
    {{--*/ $cr_total = 0 /*--}}
    {{--*/ $total = $account_open_balance /*--}}
    <tr>
        <th colspan="8"></th>
        <th style="text-align: right">{{ ($total > 0) ? number_format($total,2) : "( ".number_format(-1*$total,2)." )" }}</th>
    </tr>

    <tbody>
    @foreach($account_transactions as $index=>$cash_book_transaction)


        @if($cash_book_transaction->transaction_type =='PAYMENTS')
            <tr>
                <td style="white-space:nowrap;">{{\Carbon\Carbon::parse($cash_book_transaction['date'])->toFormattedDateString()}}</td>
                <td style="white-space:nowrap;text-align: center"></td>
                <td style="white-space:nowrap;text-align: center">{{$cash_book_transaction->journalVoucher->document}}</td>
                <td style="white-space:nowrap;text-align: center"
                    colspan="3">{{$cash_book_transaction['description']}}</td>
                {{--*/ $amount = $cash_book_transaction->amount /*--}}
                <td style="white-space:nowrap;text-align: right">
                    @if($cash_book_transaction['type']=='DEBITED')
                        {{ number_format($amount,2)}}
                        {{--*/ $total -= $amount /*--}}
                    @endif
                </td>
                <td style="white-space:nowrap;text-align: right">
                    @if($cash_book_transaction['type']=='CREDITED')
                        {{ number_format($amount,2) }}
                        {{--*/ $total += $amount /*--}}
                    @endif
                </td>
                <th style="white-space:nowrap;text-align: right;font-weight:bold">{{ ($total > 0) ? number_format($total,2) : "( ".number_format(-1*$total,2)." )" }}</th>
            </tr>
        @else
            @if(sizeof($cash_book_transaction->journalVoucher->purchaseOrderJournalVouchers))
                {{--*/ $i=1 /*--}}
                {{--*/ $total_amount = 0 /*--}}
                                {{--*/ $i = 0 /*--}}
                {{--*/ $sub_amount_usd = 0 /*--}}
                {{--*/ $sub_amount_tsh = 0 /*--}}
                {{--*/ $total_tax_usd = 0 /*--}}
                {{--*/ $total_tax_tsh = 0 /*--}}
                {{--*/ $sub_trip_amount = 0 /*--}}
                {{--*/ $number_of_rows = 6/*--}}
                @foreach($cash_book_transaction->journalVoucher->purchaseOrderJournalVouchers as $purchase_order_journal_voucher)
                    @foreach($purchase_order_journal_voucher->purchaseOrder->purchaseOrderItems as $index=>$purchase_order_item)

                        <tr>
                            <td style="white-space:nowrap;">{{\Carbon\Carbon::parse($cash_book_transaction['date'])->toFormattedDateString()}}</td>
                            <td>{{$purchase_order_journal_voucher->purchaseOrder->id}}</td>
                            <td>{{$cash_book_transaction->journalVoucher->document}}</td>
                            <td class="invoice_rows">{{$purchase_order_item->item->name}}</td>
                            <td>{{number_format($purchase_order_item->quantity)}} {{$purchase_order_item->item->units}}</td>
                            <td>{{number_format($purchase_order_item->valuation_rate)}}</td>
                            <td style="white-space:nowrap;text-align: right">
                                {{--*/ $amount = $purchase_order_item->valuation_rate*$purchase_order_item->quantity /*--}}
                                @if($cash_book_transaction['type']=='DEBITED')
                                    {{ number_format($amount,2)}}
                                    {{--*/ $total -= $amount /*--}}
                                @endif
                            </td>
                            <td style="white-space:nowrap;text-align: right">
                                @if($cash_book_transaction['type']=='CREDITED')
                                    {{ number_format($amount,2) }}
                                    {{--*/ $total += $amount /*--}}
                                @endif
                            </td>
                            <th style="white-space:nowrap;text-align: right;font-weight:bold">
                            {{ ($total > 0) ? number_format($total,2) : "( ".number_format(-1*$total,2)." )" }}</td>
                            {{--*/ $i++ /*--}}
                            {{--*/ $total_amount += $purchase_order_item->quantity*$purchase_order_item->valuation_rate /*--}}
                        </tr>

                    @endforeach
                @endforeach
            @else
           
                <tr>
                    <td style="white-space:nowrap;">{{\Carbon\Carbon::parse($cash_book_transaction['date'])->toFormattedDateString()}}</td>
                    <td style="white-space:nowrap;text-align: center"></td>
                    <td style="white-space:nowrap;text-align: center">{{$cash_book_transaction->journalVoucher->document}}</td>
                    <td style="white-space:nowrap;text-align: center"
                        colspan="3">{{$cash_book_transaction['description']}}</td>
                    {{--*/ $amount = $cash_book_transaction->amount /*--}}
                    <td style="white-space:nowrap;text-align: right">
                        @if($cash_book_transaction['type']=='DEBITED')
                            {{ number_format($amount,2)}}
                            {{--*/ $total -= $amount /*--}}
                        @endif
                    </td>
                    <td style="white-space:nowrap;text-align: right">
                        @if($cash_book_transaction['type']=='CREDITED')
                            {{ number_format($amount,2) }}
                            {{--*/ $total += $amount /*--}}
                        @endif
                    </td>
                    <th style="white-space:nowrap;text-align: right;font-weight:bold">{{ ($total > 0) ? number_format($total,2) : "( ".number_format(-1*$total,2)." )" }}</th>
                </tr>
            @endif
        @endif
    @endforeach
    </tbody>
    <tr>
        <th colspan="8">&nbsp;</th>
        <th style="text-align: right"> {{ ($total > 0) ? number_format($total,2) : "( ".number_format(-1*$total,2)." )" }}</th>
    </tr>

</table>