[remoteaccess] Track unwakable machines, ignore restricted locations

- Locations that are set to "never" or "only outside business hours"
  will not be considered during WOL, and not delivered to the guacamole
  proxy.
- If we cannot wake as much machines per remote group as configured,
  we'll display a little number next to the WOL count setting.

1 files changed, 10 insertions, 0 deletions

diff --git a/modules-available/remoteaccess/install.inc.php b/modules-available/remoteaccess/install.inc.php
index 2e248282..2a6fec36 100644
--- a/modules-available/remoteaccess/install.inc.php
+++ b/modules-available/remoteaccess/install.inc.php
@@ -8,6 +8,7 @@ $dbret[] = tableCreate('remoteaccess_group', "
 	`wolcount` smallint(11) NOT NULL,
 	`passwd` varchar(100) NOT NULL,
 	`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
+	`unwoken` int(10) UNSIGNED NOT NULL DEFAULT '0',
 	PRIMARY KEY (`groupid`)
 ");
 
@@ -67,4 +68,13 @@ if (!tableHasColumn('remoteaccess_machine', 'vncport')) {
 	$dbret[] = UPDATE_DONE;
 }
 
+// 2022-06-01 Unwoken machines: Keeps track of how many machines could not be WOLed
+if (!tableHasColumn('remoteaccess_group', 'unwoken')) {
+	$ret = Database::exec("ALTER TABLE remoteaccess_group ADD COLUMN `unwoken` int(10) UNSIGNED NOT NULL DEFAULT '0'");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, Database::lastError());
+	}
+	$dbret[] = UPDATE_DONE;
+}
+
 responseFromArray($dbret);