From bad5036569b3c572f60dae034c42a8129adc29e5 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sat, 30 Jan 2016 18:22:13 -0500
Subject: Handle object timestamps automatically in Object::saveObj()

The saveObj() function now initializes and update the timeCreated and timeUpdated fields of objects on its own.
A new function, getCurrentTimestamp() (from class Object) is introduced to aid simpler fetching of the date and time
---
 app/class/object.class.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'app')

diff --git a/app/class/object.class.php b/app/class/object.class.php
index bcd8dfa..93b52f0 100644
--- a/app/class/object.class.php
+++ b/app/class/object.class.php
@@ -77,6 +77,8 @@ abstract class Object extends Framework
     {
         if (isset($this->guid))
         {
+            $this->timeUpdated = $this->getCurrentTimestamp();
+
             /* Update Base */
             $updateStr = "";
 
@@ -117,6 +119,8 @@ abstract class Object extends Framework
         else
         {
             $this->guid = $this->getNewGUID();
+            $this->timeCreated = $this->getCurrentTimestamp();
+            $this->timeUpdated = $this->timeCreated;
 
             /* Insert Base */
             $colsStr = "";
@@ -179,6 +183,16 @@ abstract class Object extends Framework
         $this->db->query($query);
     }
 
+    /*
+     * Get current timestamp for object database purposes
+     */
+    function getCurrentTimestamp()
+    {
+        $query = "SELECT now() AS stamp";
+        $result = $this->db->query($query);
+        return $result[0]['stamp'];
+    }
+
     /*
      * Check whether given GUID exists
      */
-- 
cgit v1.2.3