@extends('layouts.master') @section('content')
logo here
{{ $carrier_profile->NAME }}
Activate All Fuel Cards Block All Fuel Cards @if($carrierUsers) Active All Users Block All Users @endif
{{ $carrier_profile->DOT }} {{ $carrier_profile->PHONE }} {{ $carrier_profile->EMAIL }}
@csrf

Carrier Info

@error('ACTIVE')

{{ $message }}

@enderror
@error('NAME')

{{ $message }}

@enderror
@error('CONTACT_NAME')

{{ $message }}

@enderror
@error('PHONE')

{{ $message }}

@enderror
Allowed file types: png, jpg, jpeg.
@error('logo')

{{ $message }}

@enderror

Rate Info

Payment Details

@php $arr = explode(',', $carrier_profile->PAYMENT_TERMS); @endphp

Carrier Documents

@if (!empty($carrier_profile->DOCUMENTS)) Download Current Document @endif

Money Codes

@php $policy_num = $carrier_profile->SUBFLEET; $name = $carrier_profile->NAME; $fuel_process = DB::table('FUEL_PROCESS') ->selectRaw('SUM(QTY) AS Total, SUM(GROSS_AMT) AS Charges') ->where('SUBFLEET', $policy_num) ->orderBy('SUB_FLEET', 'DESC') //->toSql(); ->first(); $data22 = DB::table('FUEL_PROCESS') ->selectRaw(' (FUEL_PROCESS.RATE - FUEL_PROCESS.DIS_RATE) AS GROSSREBEATE, (FUEL_PROCESS.RATE - FUEL_PROCESS.DIS_RATE) - FUEL_PROCESS.REBATE AS NETREBATE, (FUEL_PROCESS.QTY * FUEL_PROCESS.DIS_RATE) AS COST, SUM(FUEL_PROCESS.QTY * FUEL_PROCESS.REBATE) AS REBATE_AMT, (FUEL_PROCESS.INV_AMT - SUM(FUEL_PROCESS.QTY * FUEL_PROCESS.DIS_RATE)) AS PROFIT') ->where('FUEL_PROCESS.SUBFLEET', $policy_num) ->where('FUEL_PROCESS.PRODUCT_CODE', 'ULSD') ->first(); $openAmount = DB::table('AR_SUM') ->selectRaw('SUM(ORIG_AMT) AS OPEN') ->where('subfleet', $name) ->where(function ($query) { $query->where('APPLIED_CHK', 'OPEN') ->orWhere('APPLIED_CHK', 'PROCESSING'); }) ->first(); @endphp Total Gallons {{ number_format($fuel_process->Total, 2) }} All Gallons
Total Fuel Spend $ {{ number_format($fuel_process->Charges, 2) }} Retail Charges
Total Rebates $ {{ number_format($data22->REBATE_AMT, 2) }} View Rebaes
Total Open Invoices $ {{ number_format($openAmount->OPEN, 2) }} Current Spend

Gallons by Month 1,046 Inbound Calls today

28 Jan 2024

Gallons by State More than 400 new members

CARD NO CARD STATUS Driver Unit # DRIVER ID Action
Date Unit Card # Driver Location City State Fee Item Retail Qty Amount

{{ (isset($_GET['month']) && !empty($_GET['month']) ? date("F", mktime(null, null, null, $previousMonth)) : 'Previous') }} Month Rebates By Unit #

@forelse ($data33 as $rowss) @php if ($rowss->UNIT != '') { $sql223 = "SELECT sum(`QTY`) AS TotalGallons,`PRODUCT_CODE` FROM FUEL_PROCESS WHERE SUBFLEET ='" . getAuthMemberId($carrier_profile->ID) . "' AND `PRODUCT_CODE` = 'ULSD' AND `LocationID` NOT IN(1,3) AND MONTH(TRANS_DATE) = MONTH(NOW()- INTERVAL 1 MONTH) AND YEAR(TRANS_DATE) = YEAR(NOW()- INTERVAL 1 MONTH)AND `UNIT` = '" . $rowss->UNIT . "'"; $rows2s = DB::select(DB::raw($sql223)); $rows2s = $rows2s[0]; } @endphp @php $rows2s->TotalGallons = 0; @endphp @empty @endforelse
Unit # Driver Total Rebates Avg Rebate In Network Out of Network Gallons In Network
{{ $rowss->UNIT }} {{ strtoupper($rowss->DRIVER) }} $ {{ number_format($rowss->Total, 2) }} $ {{ number_format($rowss->Total / ($rowss->TotalGallons + $rows2s->TotalGallons), 2) }} {{ number_format($rowss->TotalGallons, 2) }} {{ $rows2s->TotalGallons }} {{ number_format(100 * ($rowss->TotalGallons / ($rows2s->TotalGallons + $rowss->TotalGallons)), 0) }} %
No Data Found

Gallons by Month

MTD Gallons by State

Previous Month Rebates

MTD Gallons by Day

Charges by Month

MTD Gallons per Chain

Total Charges: $ {{ number_format($total_charges, 2) }}

Total Unpaid: $ {{ number_format($total_unpaid, 2) }}
INV # Billed Date Range Amount Paid Action
{{ $bankDetail->account_name ?? '' }}
Account # xxx-{{ $bankDetail->mask ?? '' }}
Add Your Bank
Click to Connect
Primary Card
@if (!empty($card_data)) {{ $card_data['card']['brand'] }} #{{ $card_data['card']['last4'] }} @endif
{{-- Add More Cards --}}
Invoices
$ {{ number_format($totalInvoices, 2) }}
View All

Credit Cards

Brand Country Funding Last 4 Expiration Action

Last 10 Invoices

View All
@forelse ($invoices as $invoice) @php $totalAmount = $invoice->amount; if (empty($totalAmount)) { $sql2 = DB::select(DB::raw("SELECT SUM((DailyTrans.`Transaction Fee` + DailyTrans.Amount)) as total FROM DailyTrans LEFT JOIN `CARRIER_PROFILE` ON CARRIER_PROFILE.`SUBFLEET` =DailyTrans.`Sub Fleet` WHERE `Transaction Date` BETWEEN '" . date('Y-m-d', strtotime($invoice->start_date)) . "' AND '" . date('Y-m-d', strtotime($invoice->end_date)) . "' AND DailyTrans.`Sub Fleet`='" . getAuthMemberId($carrier_profile->ID) . "'")); $totalAmount = $sql2[0]->total; /*App\Models\Invoice::where('id', $invoice->id)->update([ 'amount' => $totalAmount, ]);*/ } $color = 'black'; if ($invoice->is_paid == 'N') { $color = 'red'; } if (!empty($invoice->total_paid_amount) && floatval($invoice->total_paid_amount) < $invoice->amount) { $color = 'blue'; } @endphp @empty @endforelse
INV # Billed Date Amount Paid Action
{{ sprintf('%04d', $invoice->inv_no) }} {{ !empty($invoice->bill_date) ? date('m/d/Y', strtotime($invoice->bill_date)) : '' }} {{ '$ ' . number_format($totalAmount, 2) }} {{ $invoice->is_paid == 'Y' ? 'Paid' : 'Unpaid' }}
Download Transactions {{ $invoice->is_paid == 'Y' ? 'View' : 'Pay' }} Invoice
No Records Found

Banking History

@if (!empty($bankDetail))
@endif @forelse ($getPlaidBalHistory as $record) @empty @endforelse
Acc # Balance Created Date
{{ $record->account_number }} {{ number_format($record->balance, 2) }} {{ date('m/d/y h:i A', strtotime($record->created_at)) }}
No Data Found
Name Email Username Password Active User Type Action
Add
Ticket ID Status Title Category Created By Created Date Action
Add
ORDER TYPE CARD STYLE STATUS QTY EMBOSSNAME SHIP METHOD CREATED DATE Action
@endsection() @section('script')