@extends('backend.layouts.app') @section('content') {{-- Stats --}} @php $total = $inquiries->total(); $todayCount = \App\Models\CustomerInquiry::whereDate('created_at', today())->count(); $newCount = \App\Models\CustomerInquiry::where(function($q){ $q->where('lead_status','new')->orWhereNull('lead_status'); })->count(); $interested = \App\Models\CustomerInquiry::where('lead_status','interested')->count(); $unmatched = \App\Models\CustomerInquiry::whereNull('seller_id')->count(); $conversion = $total > 0 ? round(($interested/$total)*100,1) : 0; @endphp
| # | Buyer | Category / Product | Seller / Shop | Location | Status | Quote | Notified | Date | Actions | |
|---|---|---|---|---|---|---|---|---|---|---|
|
{{ $inq->id }}
@if($inq->IsRead == 0) NEW@endif |
{{ $inq->buyer_name ?: 'Guest' }}
@if($inq->buyer_phone)
đŦ WA
@endif
|
@if($inq->category)
@endif @if($inq->product_name) {{ Str::limit($inq->product_name,30) }} @endif |
@if($isUnmatched)
â ī¸ Unmatched
@else {{ $shopName }}
@if($inq->seller && $inq->seller->phone)
{{ $inq->seller->phone }}
@endif
@endif
|
@if($inq->city)
{{ $inq->city }}
@if($inq->district){{ $inq->district }}, {{ $inq->state }}@endif
@else â @endif
|
@if($inq->quoted_amount) âš{{ number_format($inq->quoted_amount) }} @else â @endif | @php $notifCount = \DB::table('enquiry_notifications')->where('enquiry_id',$inq->id)->count(); @endphp @if($notifCount > 0) {{ $notifCount }} sellers @else Unmatched @endif |
{{ $inq->created_at->format('d M Y') }}
{{ $inq->created_at->diffForHumans() }}
|
No enquiries found