Changeset 921 for trunk/Modules/Network/NetworkModels.php

Timestamp:

Feb 25, 2022, 9:30:55 AM (3 years ago)

Author:

chronos

Message:

• Modified: NetworkSignal MAC column transformed into separate table NetworkMac.

File:

• trunk/Modules/Network/NetworkModels.php (modified) (2 diffs)

trunk/Modules/Network/NetworkModels.php

@@ -192 +192 @@
     $Desc = new ModelDesc(self::GetClassName());
     $Desc->AddDateTime('Time');
-    $Desc->AddString('MAC');
+    $Desc->AddReference('MAC', NetworkMac::GetClassName());
     $Desc->AddReference('Interface', NetworkInterface::GetClassName());
     $Desc->AddInteger('Value');
@@ -342 +342 @@
   }
 }
+
+class NetworkMac extends Model
+{
+  static function GetModelDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc(self::GetClassName());
+    $Desc->AddString('MAC'); // size=17
+    return $Desc;
+  }
+
+  function GetIndex(string $MAC)
+  {
+    $DbResult = $this->Database->select('NetworkMac', 'Id', 'MAC="'.$MAC.'"');
+    if ($DbResult->num_rows > 0)
+    {
+      $DbRow = $DbResult->fetch_assoc();
+      return $DbRow['Id'];
+    } else 
+    {
+      return $this->Database->insert('NetworkMac', array('MAC' => $MAC));
+    }
+  }
+}