.bat | | Example batch file: | C:\scripts\restart_11070.bat | | Contents: | @echo off | sc stop "MyServiceName" | timeout /t 5 /nobreak >nul | sc start "MyServiceName" | exit /b %errorlevel% |-------------------------------------------------------------------------- */ $restartMessage = ''; if (isset($_POST['restart_all_ports']) && isset($_POST['red_ports'])) { // $ports = array_unique(array_map('intval', explode(',', $_POST['red_ports']))); $success = 0; $failed = 0; $missing = 0; // foreach ($ports as $port) { echo $batchFile = "C:\\xampp\\htdocs\\1stopstartallsocketthroughpage.bat"; if (!file_exists($batchFile)) { $missing++; continue; } $output = array(); $returnCode = 0; exec('cmd /c "' . $batchFile . '"', $output, $returnCode); if ($returnCode === 0) { $success++; } else { $failed++; } // } echo $restartMessage = "
Restart All Completed. Success: {$success}, Failed: {$failed}, Batch Missing: {$missing}
"; } if (isset($_POST['restart_port'])) { $port = intval($_POST['restart_port']); if ($port > 0) { echo $batchFile = "C:\\scripts\\restart_" . $port . ".bat"; if (file_exists($batchFile)) { $output = array(); $returnCode = 0; exec('cmd /c "' . $batchFile . '"', $output, $returnCode); if ($returnCode === 0) { $restartMessage = "
Service restarted successfully for Port {$port}.
"; } else { $restartMessage = "
Failed to restart service for Port {$port}.
"; } } else { $restartMessage = "
Batch file not found: {$batchFile}
"; } } } /* |-------------------------------------------------------------------------- | Query 1 |-------------------------------------------------------------------------- */ $sql = " SELECT ADDDATE(MAX(latest_telemetry.gps_time), INTERVAL 19800 SECOND), NOW(), ROUND(TIMESTAMPDIFF( SECOND, ADDDATE(MAX(latest_telemetry.gps_time), INTERVAL 19800 SECOND), NOW() ) / 60) AS diff, latest_telemetry.des_movement_id AS PortNo, COUNT(*) AS numberofdevice, ADDDATE(latest_telemetry.gps_time, INTERVAL 19800 SECOND) AS gps_time FROM matrix.latest_telemetry WHERE gps_time > '2023-08-01' AND des_movement_id IN ( 2121 ) GROUP BY PortNo HAVING COUNT(*) > 1 ORDER BY numberofdevice DESC "; $result = select_query($sql); /* |-------------------------------------------------------------------------- | Query 2 |-------------------------------------------------------------------------- */ $sql2 = " SELECT ADDDATE(MAX(latest_telemetry.gps_time), INTERVAL 19800 SECOND), NOW(), ROUND(TIMESTAMPDIFF( SECOND, ADDDATE(MAX(latest_telemetry.gps_time), INTERVAL 19800 SECOND), NOW() ) / 60) AS diff, latest_telemetry.des_movement_id AS PortNo, COUNT(*) AS numberofdevice, ADDDATE(latest_telemetry.gps_time, INTERVAL 19800 SECOND) AS gps_time FROM latest_telemetry WHERE gps_time > '2023-08-01' AND des_movement_id NOT IN ( 2121 ) GROUP BY PortNo HAVING COUNT(*) > 1 ORDER BY numberofdevice DESC "; $result2 = select_query($sql2); /* |-------------------------------------------------------------------------- | Helper Function |-------------------------------------------------------------------------- */ function renderPortButton($value) { $port = (int)$value["PortNo"]; $diff = (int)$value["diff"]; $count = (int)$value["numberofdevice"]; $label = $port . "--" . $count . "(" . $diff . ")"; $isGreen = false; if ($diff < 3) { $isGreen = true; } elseif (($port == 4443 || $port == 4444) && $diff < 60) { $isGreen = true; } if ($isGreen) { echo ''; } else { echo '
'; } } // Collect all red ports for "Restart All Red Ports" button $redPorts = array(); foreach (array($result, $result2) as $dataset) { foreach ($dataset as $value) { $port = (int)$value["PortNo"]; $diff = (int)$value["diff"]; $isGreen = false; if ($diff < 3) { $isGreen = true; } elseif (($port == 4443 || $port == 4444) && $diff < 60) { $isGreen = true; } if (!$isGreen) { $redPorts[] = $port; } } } $redPorts = array_unique($redPorts); ?> PORT VIEW
" . date("H:i:s d-M") . ""; ?>