X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttTemplateHelper.class.php;h=e3a93564675caa40b88a173d75f6a38a25a97360;hb=817c14c6c2098d85ef912fb95898c857bf533b4f;hp=e2e565a39a81e56ea350b892dfa2aa27c7f38fea;hpb=18ad12139f489cfc5a0721e68b2b3e6aa0175b89;p=timetracker.git

diff --git a/WEB-INF/lib/ttTemplateHelper.class.php b/WEB-INF/lib/ttTemplateHelper.class.php
index e2e565a3..e3a93564 100644
--- a/WEB-INF/lib/ttTemplateHelper.class.php
+++ b/WEB-INF/lib/ttTemplateHelper.class.php
@@ -38,7 +38,7 @@ class ttTemplateHelper {
     $group_id = $user->getGroup();
     $org_id = $user->org_id;
 
-    $sql = "select id, name, description, content from tt_templates".
+    $sql = "select id, name, description, content, status from tt_templates".
       " where id = $id and group_id = $group_id and org_id = $org_id".
       " and status is not null";
     $res = $mdb2->query($sql);
@@ -59,7 +59,9 @@ class ttTemplateHelper {
     $group_id = $user->getGroup();
     $org_id = $user->org_id;
 
-    $sql = "update from tt_templates set status = null".
+    $modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$user->id;
+
+    $sql = "update tt_templates set status = null".$modified_part.
       " where id = $id and group_id = $group_id and org_id = $org_id";
     $affected = $mdb2->exec($sql);
     if (is_a($affected, 'PEAR_Error'))
@@ -80,9 +82,12 @@ class ttTemplateHelper {
     $description = $fields['description'];
     $content = $fields['content'];
 
-    $sql = "insert into tt_templates (group_id, org_id, name, description, content)".
+    $created_part = ', now(), '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', '.$user->id;
+
+    $sql = "insert into tt_templates (group_id, org_id, name, description, content,".
+      " created, created_ip, created_by)".
       " values ($group_id, $org_id, ".$mdb2->quote($name).
-      ", ".$mdb2->quote($description).", ".$mdb2->quote($content).")";
+      ", ".$mdb2->quote($description).", ".$mdb2->quote($content).$created_part.")";
     $affected = $mdb2->exec($sql);
     if (is_a($affected, 'PEAR_Error'))
       return false;
@@ -102,10 +107,13 @@ class ttTemplateHelper {
     $name = $fields['name'];
     $description = $fields['description'];
     $content = $fields['content'];
+    $modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$user->id;
+    $status = (int) $fields['status'];
 
     $sql = "update tt_templates set name = ".$mdb2->quote($name).
       ", description = ".$mdb2->quote($description).
-      ", content = ".$mdb2->quote($content).
+      ", content = ".$mdb2->quote($content).$modified_part.
+      ", status = ".$status.
       " where id = $template_id and group_id = $group_id and org_id = $org_id";
     $affected = $mdb2->exec($sql);
     return (!is_a($affected, 'PEAR_Error'));