@extends('layouts.main', ['title' => 'LOGISTICS | Loading Orders'])
@section('navigation')
    <ul class="breadcrumb">
        <li><a href="{{route('home')}}">Dashboard</a> <span class="divider">/</span></li>
        <li class="active">Loading Orders</li>
        </li>
    </ul>
@stop
@section('title')
    Loading Orders
@endsection
@section('msghead_menu')
{{--    <li class="right btn-group" style="padding-bottom: 1.5%">--}}
{{--        <div class="btn-group">--}}
{{--            <button class="btn" style="margin-right: 2px" id="request_allowance"> REQUEST ALLOWANCE</button>--}}


{{--        </div><!--btn-group-->--}}
{{--    </li>--}}
@endsection
@section('contentinner')
    <style>

        .form-filter {
            border-top: 1px solid #dddddd;
            border-bottom: 1px solid #dddddd;
            color: #0e4722;
            font-weight: normal;
            text-align: center;
            padding-bottom: 4px;
        }

    </style>
    <table style="width: 100%;font-size:10px;margin-left: 25px" class="table table1  table-invoice">
        <tbody>
        <tr>
            <td style="width:16%;text-align: right">Loading Order #:</td>
            <td colspan="2" style="text-align: left">
                    <span class="text-val" style="padding-bottom: 10px;">
                        {{ $loading_order->id }}
                    </span>
            </td>
            <td style="width:16%;text-align: right">Date  :</td>
            <td colspan="2" style="text-align: left">
                    <span class="text-val" style="padding-bottom: 10px;">
                        {{$loading_order->date}}
                    </span>
            </td>
        </tr>
        <tr>
            <td style="width:100px;text-align: right">Allocation:</td>
            <td colspan="2" style="text-align: left">
                    <span class="text-val" style="padding-bottom: 10px;">
                        {{$loading_order->client->name}}
                    </span>
            </td>
            <td style="width:100px;text-align: right">Number of Trucks :</td>
            <td colspan="2" style="text-align: left">
                    <span class="text-val" style="padding-bottom: 10px;">
                        {{$loading_order->no_of_vehicles }}
                    </span>
            </td>
        </tr>

        </tbody>
    </table>
    <br><br>
    <!-- Main Table -->
    <div class="row-fluid">
        <div class="span12">
            <h3>Expenses Summary</h3>
            <table class="table table-bordered table-condensed logistics_table">
                <thead>
                <tr>
                    <th colspan="4" style="text-align: center"> Trip Details</th>
                    <th>Diesel</th>
                    <th colspan="{{sizeof($loading_order->safariAllowances())}}" style="text-align: center">Safari Allowance</th>
                    <th colspan="{{sizeof($loading_order->borderFees())}}" style="text-align: center">Border Charges</th>
                </tr>
                <tr>
                    <th></th>
                    <th style="width:30px">Truck</th>
                    <th style="width:30px">Trailer</th>
                    <th>Destination</th>
                    <th></th>
                    @foreach($loading_order->safariAllowances() as $account)
                        <th style="text-align: center;font-size:8px">{{$account->account}}</th>
                    @endforeach
                    @foreach($loading_order->borderFees() as $account)
                        <th style="text-align: center;font-size:8px">{{$account->account}}</th>
                    @endforeach
                </tr>
                <tr>
                    <th colspan="4"></th>
                    <th></th>
                    @foreach($loading_order->safariAllowances() as $account)
                        <th style="text-align: center;font-size:8px">{{($account->currency=='USD' ? '$':'Tsh')}} {{number_format($account->amount)}}</th>
                    @endforeach
                    @foreach($loading_order->borderFees() as $account)
                        <th style="text-align: center;font-size:8px">{{($account->currency=='USD' ? '$':'Tsh')}} {{number_format($account->amount)}}</th>
                    @endforeach
                </tr>
                </thead>
                <tbody>
                {{--*/ $total_diesel_required = 0 /*--}}
                {{--*/ $total_diesel_requisted = 0 /*--}}
                @foreach($loading_order->loadingOrderItems as $index=>$loading_order_item)
                    <tr>
                        <td  style="font-size:8px">{{++$index}}</td>
                        <td  style="font-size:8px">{{$loading_order_item->loadingOrderVehicle->vehicle->registration_number}}</td>
                        <td  style="font-size:8px">{{$loading_order_item->loadingOrderVehicle->trailer->registration_number}}</td>
                        <td  style="font-size:8px">{{$loading_order_item->loadingOrderDestination->city->name}}</td>
                        <td  style="font-size:8px;text-align:center">{{number_format($loading_order_item->loadingOrderItemFuelAssignment()->requested)}}</td>
                        {{--*/ $total_diesel_required += $loading_order_item->loadingOrderItemFuelAssignment()->quantity /*--}}
                        {{--*/ $total_diesel_requisted += $loading_order_item->loadingOrderItemFuelAssignment()->requested /*--}}
                        @foreach($loading_order->safariAllowances() as $account)
                            <td style="text-align: right;padding-right: 15px;font-size:8px">{{number_format($loading_order_item->getPaidAmount($account->account_id,$account->currency))}}</td>
                            {{--*/ $total_required[$account->account_id][] =$account->amount /*--}}
                            {{--*/ $total_paid[$account->account_id][] = $loading_order_item->getPaidAmount($account->account_id,$account->currency) /*--}}
                            {{--*/ $total[$account->account_id][] = $loading_order_item->getPaidAmount($account->account_id,$account->currency) /*--}}
                        @endforeach
                        @foreach($loading_order->borderFees() as $account)
                            <td style="text-align: right;padding-right: 15px;font-size:8px">{{number_format($loading_order_item->getPaidAmount($account->account_id,$account->currency))}}</td>
                            {{--*/ $total_required[$account->account_id][] =$account->amount /*--}}
                            {{--*/ $total_paid[$account->account_id][] = $loading_order_item->getPaidAmount($account->account_id,$account->currency) /*--}}
                        @endforeach
                    </tr>
                @endforeach
                </tbody>
                <tfoot>
                <tr>
                    <td colspan="4" style="text-align: right;font-size:8px">Total Required</td>
                    <td style="text-align:center;font-size:8px">{{number_format($total_diesel_required)}}</td>

                    @foreach($loading_order->safariAllowances() as $account)
                        <td style="text-align: right;padding-right: 15px;font-size:8px">{{number_format(array_sum($total_required[$account->account_id]))}}</td>
                    @endforeach
                    @foreach($loading_order->borderFees() as $account)
                        <td style="text-align: right;padding-right: 15px;font-size:8px">{{number_format(array_sum($total_required[$account->account_id]))}}</td>
                    @endforeach
                </tr>
                <tr>
                    <td colspan="4" style="text-align: right;font-size:8px">Total Allocated</td>
                    <td style="text-align:center;font-size:8px">{{number_format($total_diesel_requisted)}}</td>
                    @foreach($loading_order->safariAllowances() as $account)
                        <td style="text-align: right;padding-right: 15px;font-size:8px">{{number_format(array_sum($total_paid[$account->account_id]))}}</td>
                    @endforeach
                    @foreach($loading_order->borderFees() as $account)
                        <td style="text-align: right;padding-right: 15px;font-size:8px">{{number_format(array_sum($total_paid[$account->account_id]))}}</td>
                    @endforeach
                </tr>
                <tr>
                    <td colspan="4" style="text-align: right;font-size:8px;">Balance</td>

                    <td style="text-align:center;font-size:8px;{{($total_diesel_required<$total_diesel_requisted) ? 'font-weight: bold':''}}">{{number_format($total_diesel_required - $total_diesel_requisted)}}</td>
                    @foreach($loading_order->safariAllowances() as $account)
<td style="text-align: right;padding-right: 15px;font-size:8px;{{(array_sum($total_required[$account->account_id])<array_sum($total_paid[$account->account_id])) ? 'font-weight: bold':''}}">{{number_format(array_sum($total_required[$account->account_id])-array_sum($total_paid[$account->account_id]))}}</td>
                    @endforeach
                    @foreach($loading_order->borderFees() as $account)
                        <td style="text-align: right;padding-right: 15px;font-size:8px;{{(array_sum($total_required[$account->account_id])<array_sum($total_paid[$account->account_id])) ? 'font-weight: bold':''}}">{{number_format(array_sum($total_required[$account->account_id])-array_sum($total_paid[$account->account_id]))}}</td>
                    @endforeach
                </tr>
                </tfoot>
            </table>
        </div><!--span12-->
    </div><!--row-fluid-->


@stop