From 81e0577e593a18107427084ce935183a0487c435 Mon Sep 17 00:00:00 2001
From: n0nag0n <n0nag0n@sky-9.com>
Date: Wed, 26 Mar 2025 07:25:50 -0600
Subject: [PATCH 1/3] fixed error handling in worker and added search by
 request id

---
 dashboard/js/script.js                | 6 ++++++
 dashboard/views/dashboard.php         | 4 ++++
 src/apm/presenter/SqlitePresenter.php | 7 +++++++
 src/commands/WorkerCommand.php        | 4 +++-
 4 files changed, 20 insertions(+), 1 deletion(-)

diff --git a/dashboard/js/script.js b/dashboard/js/script.js
index e39189b..fbc0dc4 100644
--- a/dashboard/js/script.js
+++ b/dashboard/js/script.js
@@ -687,6 +687,7 @@ function setupFilterHandlers() {
         const url = document.getElementById('filter-url').value.trim();
         const responseCode = filterResponseCode.value;
         const exactCode = filterExactCode.value.trim();
+        const requestId = document.getElementById('filter-request-id').value.trim();
         const bot = document.getElementById('filter-bot').value;
         const customEvent = document.getElementById('filter-custom-event').value.trim();
         const minTime = document.getElementById('filter-min-time').value.trim();
@@ -696,6 +697,7 @@ function setupFilterHandlers() {
         
         // Add non-empty filters to the activeFilters object
         if (url) activeFilters.url = url;
+        if (requestId) activeFilters.request_id = requestId;
         
         if (responseCode === 'exact' && exactCode) {
             activeFilters.response_code = exactCode;
@@ -723,6 +725,7 @@ function setupFilterHandlers() {
         document.getElementById('filter-url').value = '';
         filterResponseCode.value = '';
         filterExactCode.value = '';
+        document.getElementById('filter-request-id').value = '';
         document.getElementById('filter-bot').value = '';
         document.getElementById('filter-custom-event').value = '';
         document.getElementById('filter-min-time').value = '';
@@ -761,6 +764,9 @@ function setupFilterHandlers() {
                 case 'url':
                     filterLabel = `URL: ${value}`;
                     break;
+                case 'request_id':
+                    filterLabel = `Request ID: ${value}`;
+                    break;
                 case 'response_code':
                     filterLabel = `Code: ${value}`;
                     break;
diff --git a/dashboard/views/dashboard.php b/dashboard/views/dashboard.php
index 91aceae..ef46d39 100644
--- a/dashboard/views/dashboard.php
+++ b/dashboard/views/dashboard.php
@@ -146,6 +146,10 @@
 											<label for="filter-exact-code" class="form-label">Exact Code</label>
 											<input type="number" class="form-control" id="filter-exact-code" placeholder="e.g. 404">
 										</div>
+										<div class="col-md-3">
+											<label for="filter-request-id" class="form-label">Request ID</label>
+											<input type="text" class="form-control" id="filter-request-id" placeholder="e.g. req_1234abcd">
+										</div>
 										<div class="col-md-3">
 											<label for="filter-bot" class="form-label">Bot Requests</label>
 											<select class="form-select" id="filter-bot">
diff --git a/src/apm/presenter/SqlitePresenter.php b/src/apm/presenter/SqlitePresenter.php
index 4701345..3e5c490 100644
--- a/src/apm/presenter/SqlitePresenter.php
+++ b/src/apm/presenter/SqlitePresenter.php
@@ -182,11 +182,18 @@ public function getRequestsData(string $threshold, int $page, int $perPage, stri
         $isBot = $_GET['is_bot'] ?? '';
         $customEventType = $_GET['custom_event_type'] ?? '';
         $minTime = $_GET['min_time'] ?? '';
+        $requestId = $_GET['request_id'] ?? '';
         
         // Build main query with conditions for URL and response code
         $conditions = ['timestamp >= ?'];
         $params = [$threshold];
 
+        // Add request ID filter (exact match)
+        if (!empty($requestId)) {
+            $conditions[] = 'request_id = ?';
+            $params[] = $requestId;
+        }
+
         // Add URL filter
         if (!empty($url)) {
             $conditions[] = 'request_url LIKE ?';
diff --git a/src/commands/WorkerCommand.php b/src/commands/WorkerCommand.php
index 6de786d..25aa6dd 100644
--- a/src/commands/WorkerCommand.php
+++ b/src/commands/WorkerCommand.php
@@ -213,7 +213,9 @@ public function execute()
                                 break;
                             }
                         } catch (\Exception $e) {
-                            $io->red("Failed! {$e->getMessage()}", true);
+                            $io->red("Failed to process metric ID {$metric['id']}: {$e->getMessage()}", true);
+                            // Add to processed IDs to delete the erroneous metric
+                            $processedIds[] = $metric['id'];
                             // Continue with other messages
                         }
                     }

From 545c83f3a357cc9633ff243195a14756403937ef Mon Sep 17 00:00:00 2001
From: n0nag0n <n0nag0n@sky-9.com>
Date: Wed, 26 Mar 2025 07:30:37 -0600
Subject: [PATCH 2/3] added helpful message for > 500 results in requests
 search

---
 dashboard/js/script.js | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/dashboard/js/script.js b/dashboard/js/script.js
index fbc0dc4..8ef1cd3 100644
--- a/dashboard/js/script.js
+++ b/dashboard/js/script.js
@@ -444,7 +444,16 @@ function updatePagination(pagination) {
     // Update pagination info
     const start = (currentPage - 1) * perPage + 1;
     const end = Math.min(currentPage * perPage, pagination.totalRequests);
-    document.getElementById('pagination-info').textContent = `Showing ${start} to ${end} of ${pagination.totalRequests} requests`;
+    
+    // Create the pagination info message
+    let paginationInfoText = `Showing ${start} to ${end} of ${pagination.totalRequests} requests`;
+    
+    // Add a note about the 500 limit if we're hitting it
+    if (pagination.totalRequests >= 500) {
+        paginationInfoText += ` <span class="text-warning" title="Only the most recent 500 matching requests are displayed. Use more specific filters to narrow your results."><i class="bi bi-info-circle"></i> (maximum limit - refine filters for more specific results)</span>`;
+    }
+    
+    document.getElementById('pagination-info').innerHTML = paginationInfoText;
 
     // Update pagination buttons
     const prevPage = document.getElementById('prev-page');

From e0c9757e4089877e1e6dd0617c20162a34210ecf Mon Sep 17 00:00:00 2001
From: n0nag0n <n0nag0n@sky-9.com>
Date: Wed, 26 Mar 2025 07:35:45 -0600
Subject: [PATCH 3/3] fixed double load issue with response graph

---
 dashboard/js/script.js | 43 +++++++++++++++++++++++++++++++++++++-----
 1 file changed, 38 insertions(+), 5 deletions(-)

diff --git a/dashboard/js/script.js b/dashboard/js/script.js
index 8ef1cd3..875fadd 100644
--- a/dashboard/js/script.js
+++ b/dashboard/js/script.js
@@ -102,7 +102,7 @@ function loadDashboardData() {
             console.log('Dashboard data received:', data);
             dashboardData = data;
             populateWidgets(data);
-            drawCharts(data);
+            drawLatencyChart(data); // Changed from drawCharts to only draw the latency chart
         })
         .catch(error => console.error('Error loading dashboard data:', error));
 }
@@ -478,8 +478,8 @@ function updatePagination(pagination) {
     };
 }
 
-// Draw charts with data
-function drawCharts(data) {
+// Draw charts with data - renamed to drawLatencyChart and removed response code chart creation
+function drawLatencyChart(data) {
     const MAX_X_AXIS_POINTS = 40; // Increased from 20 to show more granularity for day view
     const currentRange = rangeSelector.value;
     
@@ -543,8 +543,8 @@ function drawCharts(data) {
         }
     });
 
-    // Update Response Code Chart with dashboard data
-    updateResponseCodeChart(data.responseCodeOverTime);
+    // Remove the response code chart update
+    // updateResponseCodeChart(data.responseCodeOverTime); <- This line is removed
 }
 
 // New function to update just the response code chart
@@ -816,4 +816,37 @@ function setupFilterHandlers() {
 document.addEventListener('DOMContentLoaded', () => {
     loadData();
     setupFilterHandlers();
+    
+    // Add event listener for range selector to handle sequential chart updates
+    rangeSelector.addEventListener('change', () => {
+        // Clear the response code chart immediately to avoid confusion
+        if (responseCodeChart) {
+            responseCodeChart.destroy();
+            responseCodeChart = null;
+            
+            // Show loading state in chart
+            const ctxResponse = document.getElementById('responseCodeChart').getContext('2d');
+            responseCodeChart = new Chart(ctxResponse, {
+                type: 'bar',
+                data: { datasets: [] },
+                options: {
+                    maintainAspectRatio: false,
+                    responsive: true,
+                    plugins: {
+                        title: {
+                            display: true,
+                            text: 'Loading data...',
+                            padding: { top: 30 }
+                        }
+                    }
+                }
+            });
+        }
+        
+        // Load new data
+        loadData();
+    });
+    
+    // Remove the event listener we just added to avoid duplicates
+    rangeSelector.removeEventListener('change', loadData);
 });