@extends('adminlte::page')

@section('content')

<div class="card" style="margin-top:40px">
    <div class="card-header">
        <h3 class="card-title">Carrier Payments</h3>
        <button type="button" class="btn btn-success" data-toggle="modal" data-target="#carrier-payments" style="margin-right: 5px;float:right">
            Import
        </button>
        <a href="/carrier-payments/export" class="btn btn-success" style="float:right;margin-right:10px">Export</a>
        <a href="/carrier-payments/empty-data" onclick="return confirm('Are you sure?')" class="btn btn-danger" style="float:right;margin-right:10px">Empty all data</a>
        <a href="/carrier-payments/convertweek" onclick="return confirm('Are you sure?')" class="btn btn-info" style="float:right;margin-right:10px">Generate week id</a>

    </div>
    <!-- /.card-header -->
    <div class="card-body">

        <table class="table table-bordered table-hover table-striped" id="carrier_payments">
            <thead>
                <th>Carrier name</th>
                <th>Currency</th>
                <th>Payments (Total)</th>
                <th>CPS TTP (Total)</th>
                <th>Difference</th>
            </thead>

            <tbody>
                @foreach ($carriers as $carrier)
                <tr>
                    <td>
                        <a href="/carrier-payments/{{$carrier->carrier->id}}?country={{$carrier->us_can}}">{{$carrier->carrier->name}}</a></td>
                        <td>{{$carrier->us_can}}</td>
                        <td>{{number_format(\App\CarrierPayment::where('carrier_id',$carrier->carrier->id)->where('currency',$carrier->us_can)->sum('value'),2)}}</td>
                        <td>{{number_format($carrier->ttp2,2)}}</td>
                        <td> @if(is_numeric(\App\CarrierPayment::where('carrier_id',$carrier->carrier->id)->where('currency',$carrier->us_can)->sum('value')))
                                {{number_format(\App\CarrierPayment::where('carrier_id',$carrier->carrier->id)->where('currency',$carrier->us_can)->sum('value')-$carrier->ttp2,2)}}
                            @endif
                        </td>
                </tr>
                @endforeach

            </tbody>


        </table>
      

    </div>
    <!-- /.card-body -->
</div>
<div class="modal fade" id="carrier-payments">
    <div class="modal-dialog">
        <div class="modal-content">
            <form action="/carrier-payments/import" method="post" enctype="multipart/form-data">
                @csrf
                <div class="modal-header">
                    <h4 class="modal-title">Import</h4>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">

                   
                    <label for="report">Report</label>
                    <input type="file" id="report" name="report" multiple="multiple" class="form-control"/> <br/>
                    <input type="submit" class="btn btn-success" value="Import"/>
                </div>
            </form>

        </div>
    </div>
              
@stop
@section('css')
<link rel="stylesheet" href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">

@stop

@section('js')
    
<script> 
$(function () {
        $("#carrier_payments").DataTable({"paging":false,"searching":false,"bInfo" : false});
    });

</script>
@stop