@extends('layouts.app') @section('title', 'Sub Tag Profile - ISP ERP System') @section('page-title', 'Sub Tag Profile') @section('content')

{{ $subTag->name }}

{{ $subTag->description ?? 'No description provided' }}

Sub Tag Information
Sub Tag ID #{{ $subTag->id }}
Status {{ ucfirst($subTag->status) }}
Parent Tag {{ $subTag->tag->name }}
Created Date {{ $subTag->created_at->format('d M Y') }}
Created By {{ $subTag->createdBy->name ?? 'System' }}
Last Updated {{ $subTag->updated_at->format('d M Y') }}
Back to List
{{ $stats['total_users'] }}
Total Clients
{{ $stats['active_users'] }}
Active Clients
{{ $stats['total_invoices'] }}
Total Invoices
৳{{ number_format($stats['total_invoice_amount'], 0) }}
Total Amount
{{ $stats['paid_invoices'] }}
Paid Invoices
{{ $stats['pending_invoices'] }}
Pending Invoices
Clients in {{ $subTag->name }}
@if($users->count() > 0) @foreach($users as $user)
{{ substr($user->name, 0, 1) }}
{{ ucfirst($user->status) }}
{{ $user->salesInvoices->count() }} Total Invoices
৳{{ number_format($user->salesInvoices->sum('invoice_amount'), 0) }} Total Amount
{{ $user->salesInvoices->where('payment_status', 'paid')->count() }} Paid
{{ $user->salesInvoices->where('payment_status', '!=', 'paid')->count() }} Pending
View Profile Send Message
@endforeach @else
No clients assigned to this sub tag

Clients will appear here once they are assigned to this sub tag.

@endif
Invoice History Management
{{ $stats['total_invoices'] }}
Total Invoices
{{ $stats['paid_invoices'] }}
Paid Invoices
{{ $stats['pending_invoices'] }}
Pending Invoices
৳{{ number_format($stats['total_invoice_amount'], 0) }}
Total Amount
Current Month Invoices
@php $allInvoices = $users->flatMap(function($user) { return $user->salesInvoices; }); $currentMonthInvoices = $allInvoices->filter(function($invoice) { return \Carbon\Carbon::parse($invoice->invoice_date)->isCurrentMonth(); })->sortByDesc('invoice_date'); @endphp @if($currentMonthInvoices->count() > 0)
@foreach($currentMonthInvoices as $invoice) @endforeach
Invoice No Client Date Amount Paid Due Commission Item Amount Commission Amount Status Payment Actions
{{ $invoice->invoice_no }} {{ $users->firstWhere('id', $invoice->customer_id)->name ?? 'Unknown' }} {{ \Carbon\Carbon::parse($invoice->invoice_date)->format('d M Y') }} ৳{{ number_format($invoice->invoice_amount, 2) }} @php $paidAmount = \App\Models\SalesInvoiceTransection::where('sales_invoice_id', $invoice->id)->sum('amount'); @endphp @if($paidAmount > 0) ৳{{ number_format($paidAmount, 2) }} @else - @endif @php $dueAmount = $invoice->invoice_amount - $paidAmount; @endphp @if($dueAmount > 0) ৳{{ number_format($dueAmount, 2) }} @else ৳0.00 @endif @php $commissionAmount = \App\Models\CommissionInvoice::where('sales_invoice_id', $invoice->id)->sum('total_commission_amount'); $commissionItemAmount = $invoice->invoice_amount - $commissionAmount; @endphp @if($commissionItemAmount > 0) ৳{{ number_format($commissionItemAmount, 2) }} @else - @endif @php $commissionAmount = \App\Models\CommissionInvoice::where('sales_invoice_id', $invoice->id)->sum('total_commission_amount'); @endphp @if($commissionAmount > 0) ৳{{ number_format($commissionAmount, 2) }} @else - @endif {{ ucfirst($invoice->status) }} {{ ucfirst($invoice->payment_status) }}
@if($invoice->status !== 'commissioned' && !$invoice->commissionInvoices->count()) @elseif($invoice->commissionInvoices->count() > 0) @endif
@else
No Current Month Invoices Found

Current month invoices will appear here once clients have generated invoices.

@endif
Total Invoice Summary
@php // Filter out current month invoices to show only previous months $previousMonthsInvoices = $allInvoices->filter(function($invoice) { return !\Carbon\Carbon::parse($invoice->invoice_date)->isCurrentMonth(); })->sortByDesc('invoice_date'); @endphp
@if($previousMonthsInvoices->count() > 0) @foreach($previousMonthsInvoices as $invoice) @endforeach @else @endif
Invoice No Client Date Amount Paid Due Commission Item Amount Commission Amount Status Payment Actions
{{ $invoice->invoice_no }} {{ $users->firstWhere('id', $invoice->customer_id)->name ?? 'Unknown' }} {{ \Carbon\Carbon::parse($invoice->invoice_date)->format('d M Y') }} ৳{{ number_format($invoice->invoice_amount, 2) }} @php $paidAmount = \App\Models\SalesInvoiceTransection::where('sales_invoice_id', $invoice->id)->sum('amount'); @endphp @if($paidAmount > 0) ৳{{ number_format($paidAmount, 2) }} @else - @endif @php $dueAmount = $invoice->invoice_amount - $paidAmount; @endphp @if($dueAmount > 0) ৳{{ number_format($dueAmount, 2) }} @else ৳0.00 @endif @php $commissionAmount = \App\Models\CommissionInvoice::where('sales_invoice_id', $invoice->id)->sum('total_commission_amount'); $commissionItemAmount = $invoice->invoice_amount - $commissionAmount; @endphp @if($commissionItemAmount > 0) ৳{{ number_format($commissionItemAmount, 2) }} @else - @endif @php $commissionAmount = \App\Models\CommissionInvoice::where('sales_invoice_id', $invoice->id)->sum('total_commission_amount'); @endphp @if($commissionAmount > 0) ৳{{ number_format($commissionAmount, 2) }} @else - @endif {{ ucfirst($invoice->status) }} {{ ucfirst($invoice->payment_status) }}
@if($invoice->status !== 'commissioned' && !$invoice->commissionInvoices->count()) @elseif($invoice->commissionInvoices->count() > 0) @endif
No Previous Month Invoices Found

Previous month invoices will appear here once clients have generated invoices.
Commission Details
@php $allInvoices = $users->flatMap(function($user) { return $user->salesInvoices; }); $commissionInvoices = $allInvoices->filter(function($invoice) { return $invoice->commissionInvoices && $invoice->commissionInvoices->count() > 0; }); $recentCommissionInvoices = $commissionInvoices->sortByDesc('created_at')->take(5); // Calculate commission summary $totalCommissionAmount = 0; $totalPaidAmount = 0; $totalDueAmount = 0; $paidInvoicesCount = 0; $pendingInvoicesCount = 0; foreach($commissionInvoices as $invoice) { foreach($invoice->commissionInvoices as $commissionInvoice) { $totalCommissionAmount += $commissionInvoice->total_commission_amount ?? 0; $totalPaidAmount += $commissionInvoice->paid_amount ?? 0; $dueAmount = ($commissionInvoice->total_commission_amount ?? 0) - ($commissionInvoice->paid_amount ?? 0); $totalDueAmount += $dueAmount; if(($commissionInvoice->paid_amount ?? 0) >= ($commissionInvoice->total_commission_amount ?? 0)) { $paidInvoicesCount++; } else { $pendingInvoicesCount++; } } } $totalCommissionInvoices = $paidInvoicesCount + $pendingInvoicesCount; $paymentSuccessRate = $totalCommissionInvoices > 0 ? round(($paidInvoicesCount / $totalCommissionInvoices) * 100, 1) : 0; @endphp
Commission Summary
Total Commission Invoices Total Commission Amount Total Paid Amount Total Due Amount Payment Success Rate Payment Completion
{{ $totalCommissionInvoices }} ৳{{ number_format($totalCommissionAmount, 2) }} ৳{{ number_format($totalPaidAmount, 2) }} ৳{{ number_format($totalDueAmount, 2) }} {{ $paymentSuccessRate }}% @if($totalCommissionAmount > 0) {{ number_format(($totalPaidAmount / $totalCommissionAmount) * 100, 1) }}% @else 0% @endif
All Commission Invoices
@php $counter = 1; @endphp @forelse($commissionInvoices->sortByDesc('created_at') as $invoice) @foreach($invoice->commissionInvoices as $commissionInvoice) @endforeach @empty @endforelse
# Commission Invoice No Invoice Date Sales Person Sales Invoice No Commission Amount Paid Amount Due Amount Status Actions
{{ $counter++ }} {{ $commissionInvoice->invoice_no ?? 'N/A' }} {{ $commissionInvoice->invoice_date ? \Carbon\Carbon::parse($commissionInvoice->invoice_date)->format('d M, Y') : 'N/A' }}
{{ $users->firstWhere('id', $invoice->customer_id)->name ?? 'Unknown' }} @if($users->firstWhere('id', $invoice->customer_id)->company_name)
{{ $users->firstWhere('id', $invoice->customer_id)->company_name }} @endif
{{ $invoice->invoice_no }} ৳{{ number_format($commissionInvoice->total_commission_amount ?? 0, 2) }} ৳{{ number_format($commissionInvoice->paid_amount ?? 0, 2) }} @php $dueAmount = ($commissionInvoice->total_commission_amount ?? 0) - ($commissionInvoice->paid_amount ?? 0); @endphp ৳{{ number_format($dueAmount, 2) }} @php $paymentStatus = ($commissionInvoice->paid_amount ?? 0) >= ($commissionInvoice->total_commission_amount ?? 0) ? 'Paid' : 'Pending'; @endphp {{ $paymentStatus }}
No Commission Invoices Found

Commission invoices will appear here once they are created for the sales invoices.
Total: ৳{{ number_format($totalCommissionAmount, 2) }} ৳{{ number_format($totalPaidAmount, 2) }} ৳{{ number_format($totalDueAmount, 2) }}
Items Price Management
@if($commissionItems->count() > 0)
Existing Commission Items
Items already added to this sub-tag
@foreach($commissionItems as $index => $item) @php $currentPrice = $item->prices->first(); $priceValue = $currentPrice ? $currentPrice->price : null; // Different colors for different items $colors = ['text-primary', 'text-success', 'text-info', 'text-warning', 'text-danger', 'text-secondary', 'text-dark']; $colorClass = $colors[$index % count($colors)]; @endphp @endforeach
# Item Name Description Price Status Created Date Actions
{{ $index + 1 }} {{ $item->bandwidthItem->name ?? 'N/A' }} @if($item->item_code) @php $badgeColors = ['bg-light text-dark', 'bg-info text-white', 'bg-success text-white', 'bg-warning text-dark', 'bg-danger text-white', 'bg-secondary text-white']; $badgeColorClass = $badgeColors[$index % count($badgeColors)]; @endphp
{{ $item->item_code }} @endif 		@if($item->description) {{ Str::limit($item->description, 50) }} @else No description @endif @if($priceValue !== null) ৳{{ number_format($priceValue, 2) }} @if($currentPrice && $currentPrice->effective_month)
{{ \Carbon\Carbon::parse($currentPrice->effective_month)->format('M Y') }} @endif @else No price set @endif 		{{ ucfirst($item->status) }} {{ $item->created_at->format('d M, Y') }}
@csrf @method('DELETE')
Total Items: {{ $commissionItems->count() }}
{{ $commissionItems->count() }}
Total Items
৳{{ number_format($commissionItems->sum('selling_price'), 0) }}
Total Value
৳{{ $commissionItems->count() > 0 ? number_format($commissionItems->avg('selling_price'), 0) : '0' }}
Average Price
৳{{ $commissionItems->count() > 0 ? number_format($commissionItems->min('selling_price'), 0) : '0' }}
Min Price
Price Range
Minimum Price ৳{{ $commissionItems->count() > 0 ? number_format($commissionItems->min('selling_price'), 2) : '0.00' }}
Maximum Price ৳{{ $commissionItems->count() > 0 ? number_format($commissionItems->max('selling_price'), 2) : '0.00' }}
Quick Actions
@else
No Commission Items Added Yet

Add bandwidth items using the form above to get started.

@endif
Performance Analytics
Payment Status Distribution
Paid Invoices {{ $stats['paid_invoices'] }}
Pending Invoices {{ $stats['pending_invoices'] }}
Commissioned Invoices {{ $stats['commissioned_invoices'] }}
Performance Metrics
Payment Success Rate {{ $stats['total_invoices'] > 0 ? round(($stats['paid_invoices'] / $stats['total_invoices']) * 100, 1) : 0 }}%
Average Invoice Amount ৳{{ $stats['total_invoices'] > 0 ? number_format($stats['total_invoice_amount'] / $stats['total_invoices'], 2) : '0.00' }}
Commission Rate {{ $stats['total_invoices'] > 0 ? round(($stats['commissioned_invoices'] / $stats['total_invoices']) * 100, 1) : 0 }}%
@endsection