.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") . ""; ?>