X-Git-Url: https://git.cweiske.de/auerswald-callnotifier.git/blobdiff_plain/b8217d4cb0bdfea171cde633b0a196fc7dfd4a9d..29ff32499e239e6189b80ef3b9e76384920205a7:/src/callnotifier/CallMonitor/Detailler/OpenGeoDb.php?ds=sidebyside

diff --git a/src/callnotifier/CallMonitor/Detailler/OpenGeoDb.php b/src/callnotifier/CallMonitor/Detailler/OpenGeoDb.php
new file mode 100644
index 0000000..1260438
--- /dev/null
+++ b/src/callnotifier/CallMonitor/Detailler/OpenGeoDb.php
@@ -0,0 +1,74 @@
+<?php
+namespace callnotifier;
+
+class CallMonitor_Detailler_OpenGeoDb implements CallMonitor_Detailler
+{
+    protected $db;
+
+    public function __construct()
+    {
+        $this->db = new \PDO(
+            'mysql:host=dojo;dbname=opengeodb',
+            'opengeodb-read',
+            'opengeodb',
+            array(
+                \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
+                \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC
+            )
+        );
+    }
+
+    public function loadCallDetails(CallMonitor_Call $call)
+    {
+        if ($call->type == CallMonitor_Call::INCOMING) {
+            $call->fromLocation = $this->loadLocation($call->from);
+        } else {
+            $call->toLocation = $this->loadLocation($call->to);
+        }
+    }
+
+    protected function loadLocation($number)
+    {
+        //area codes in germany can be 3 to 6 numbers
+        //FIXME: what about international numbers?
+        for ($n = 3; $n <= 6; $n++) {
+            $areacode = substr($number, 0, $n);
+            $name = $this->getNameForAreaCode($areacode);
+            if ($name !== null) {
+                return $name;
+            }
+        }
+
+        return null;
+    }
+
+    protected function getNameForAreaCode($areacode)
+    {
+        $stm = $this->db->query(
+            'SELECT loc_id FROM geodb_textdata'
+            . ' WHERE text_type = "500400000"'//area code
+            . ' AND text_val = ' . $this->db->quote($areacode)
+        );
+        $res = $stm->fetch();
+        if ($res === false) {
+            //area code does not exist
+            return null;
+        }
+
+        $locId = $res['loc_id'];
+        $stm = $this->db->query(
+            'SELECT text_val FROM geodb_textdata'
+            . ' WHERE text_type = "500100000"'//name
+            . ' AND loc_id = ' . $this->db->quote($locId)
+        );
+        $res = $stm->fetch();
+        if ($res === false) {
+            return null;
+        }
+
+        return $res['text_val'];
+    }
+
+}
+
+?>