🔍 Audit Trail Report

Generated on: {{ $report_date }}

Period: {{ $date_range['from'] }} to {{ $date_range['to'] }}

Activity Summary

Total Activities: {{ number_format($summary['total_activities']) }}
Stock Movements: {{ number_format($summary['stock_movements']) }}
Purchase Orders: {{ number_format($summary['purchase_orders']) }}
Unique Users: {{ number_format($summary['unique_users']) }}
Unique Products: {{ number_format($summary['unique_products']) }}
Total Quantity Moved: {{ number_format($summary['total_quantity_moved']) }}
@if(!empty($by_user))
👤 Activity by User
@foreach($by_user as $user) @endforeach
User Total Activities Stock Movements Purchase Orders % of Total
{{ $user['user'] }} {{ number_format($user['activity_count']) }} {{ number_format($user['stock_movements']) }} {{ number_format($user['purchase_orders']) }} {{ $summary['total_activities'] > 0 ? round(($user['activity_count'] / $summary['total_activities']) * 100, 1) : 0 }}%
@endif @if(!empty($by_action))
📊 Activity by Action Type
@foreach($by_action as $action) @endforeach
Action Type Count Total Quantity % of Activities
{{ $action['action'] }} {{ number_format($action['count']) }} {{ number_format($action['total_quantity']) }} {{ $summary['total_activities'] > 0 ? round(($action['count'] / $summary['total_activities']) * 100, 1) : 0 }}%
@endif @if(!empty($daily_summary))
📅 Daily Activity Summary
@foreach($daily_summary as $day) @endforeach
Date Total Activities Stock Movements Purchase Orders Unique Users
{{ \Carbon\Carbon::parse($day['date'])->format('D, M d, Y') }} {{ number_format($day['total_activities']) }} {{ number_format($day['stock_movements']) }} {{ number_format($day['purchase_orders']) }} {{ number_format($day['unique_users']) }}
@endif @if(!empty($activities))
📜 Detailed Activity Log (Latest 500)
@foreach($activities as $activity) @endforeach
Timestamp Type Action Product ID Warehouse Location Qty Change Before After User Reference Notes
{{ $activity['timestamp'] }} {{ $activity['type'] }} {{ $activity['action'] }} {{ $activity['product_id'] }} {{ $activity['warehouse'] }} {{ $activity['location'] }} {{ $activity['quantity_change'] >= 0 ? '+' : '' }}{{ number_format($activity['quantity_change']) }} {{ $activity['quantity_before'] !== null ? number_format($activity['quantity_before']) : '-' }} {{ $activity['quantity_after'] !== null ? number_format($activity['quantity_after']) : '-' }} {{ $activity['user'] }} {{ $activity['reference'] }} {{ $activity['notes'] ?? '' }}
@else

No activities found for the selected period and filters.

@endif