@extends('adminlte::page') @section('title', 'Dashboard') @section('content')
Driver | Type | Unit# | Carrier | CPS data | QB data | Difference | Country | @foreach ($cps as $cps)|
---|---|---|---|---|---|---|---|---|
{{$statement->auth_no}} | --}}@if ($cps->driverInfo != null) {{ $cps->driverInfo->name }}@else - @endif | @if ($cps->driverInfo != null) {{ $cps->driverInfo->type }}@else - @endif | {{ $cps->unit }} | {{ $cps->carrier->name }} | {{ number_format($cps->ttp2, 2) }} | {{number_format(\App\QBDriverVerification::where('unit',$cps->unit)->where('country',$cps->us_can)->where('week_id','>=',2050)->sum('amount'),2)}} | {{$cps->unit}} | {{ $cps->us_can }} |