Switch the 'modify' code of admin/field.php to use templates
[bugdar.git] / showhistory.php
index 90b28f2b6d5032b816c20e14a7db4861713b4b46..25bca98717f9f201f5ce4525d9b2ba7a33788659 100644 (file)
@@ -1,12 +1,12 @@
 <?php
 /*=====================================================================*\
 || ###################################################################
-|| # Bugdar [#]version[#]
-|| # Copyright ©2002-[#]year[#] Blue Static
+|| # Bugdar
+|| # Copyright (c)2004-2009 Blue Static
 || #
 || # This program is free software; you can redistribute it and/or modify
 || # it under the terms of the GNU General Public License as published by
-|| # the Free Software Foundation; version [#]gpl[#] of the License.
+|| # the Free Software Foundation; version 2 of the License.
 || #
 || # This program is distributed in the hope that it will be useful, but
 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
@@ -24,14 +24,13 @@ $fetchtemplates = array(
        'history_bit'
 );
 
-define('SVN', '$Id$');
 
 $focus['showreport'] = 'focus';
 
 require_once('./global.php');
 require_once('./includes/api_user.php');
 
-$bug = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = " . $bugsys->input_clean('bugid', TYPE_UINT));
+$bug = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = " . $input->inputClean('bugid', TYPE_UINT));
 if (!$bug)
 {
        $message->error(L_INVALID_ID);
@@ -39,7 +38,7 @@ if (!$bug)
 
 if (!check_bug_permissions($bug))
 {
-       $message->error_permission();
+       $message->errorPermission();
 }
 
 $lookupfields = array(
@@ -55,17 +54,18 @@ $lookupfields = array(
 // ###################################################################
 
 $customfields = $db->query("
-       SELECT bugfield.*
+       SELECT bugfield.*, MAX(permission.mask) AS mask
        FROM " . TABLE_PREFIX . "bugfield AS bugfield
        LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission
                ON (bugfield.fieldid = permission.fieldid)
-       WHERE permission.mask <> 0
-       AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}"
+       WHERE mask <> 0
+       AND permission.usergroupid IN (" . bugdar::$userinfo['usergroupid'] . (sizeof(bugdar::$userinfo['groupids']) != 0 ? ',' . implode(',', bugdar::$userinfo['groupids']) : '') . ")
+       GROUP BY (bugfield.fieldid)"
 );
 
-while ($field = $db->fetch_array($customfields))
+foreach ($customfields as $field)
 {
-       $fieldlist["custom.field$field[fieldid]"] = sprintf(_('Custom Field %1$s (%2$s)'), $field['fieldid'], $field['name']);
+       $fieldlist["$field[fieldid]"] = sprintf(T('Custom Field %1$s (%2$s)'), $field['fieldid'], $field['name']);
 }
 
 // ###################################################################
@@ -78,9 +78,9 @@ $logs_fetch = $db->query("
                ON (user.userid = history.userid)
        WHERE bugid = $bug[bugid]"
 );
-while ($log = $db->fetch_array($logs_fetch))
+foreach ($logs_fetch as $log)
 {
-       $log['date'] = $datef->format($bugsys->options['dateformat'], $log['dateline']);
+       $log['date'] = $datef->format(bugdar::$options['dateformat'], $log['dateline']);
        $log['user'] = construct_user_display($log);
        
        $logs["$log[dateline]"]["$log[historyid]"] = $log;
@@ -89,6 +89,8 @@ while ($log = $db->fetch_array($logs_fetch))
 
 ksort($logs);
 
+$toKill = array();
+
 foreach ($logs AS $dateline => $logitems)
 {
        $show['group'] = true;
@@ -97,28 +99,30 @@ foreach ($logs AS $dateline => $logitems)
        {
                if ($log['field'] == '.' OR ($log['original'] == '' AND $log['changed'] == ''))
                {
+                       $toKill[] = $log['historyid'];
                        continue;
                }
                
-               $funct->exec_swap_bg('', $stylevar['alt_color']);
-               $bgcolor = $funct->bgcolour;
-               
                if (preg_match('#^(comment|attachment)\.(.*)#', $log['field'], $matches))
                {
                        if ($matches[1] == 'comment')
                        {
-                               $log['field'] = sprintf(_('Comment #%1$s %2$s'), $log['commentid'], ucwords($matches[2]));
+                               $log['field'] = sprintf(T('Comment #%1$s %2$s'), $log['commentid'], ucwords($matches[2]));
                        }
                        else if ($matches[1] == 'attachment')
                        {
-                               $log['field'] = sprintf(_('Attachment #2%1$s %2$s'), $log['attachmentid'], ucwords($matches[2]));
+                               $log['field'] = sprintf(T('Attachment #2%1$s %2$s'), $log['attachmentid'], ucwords($matches[2]));
                        }
                }
-               else if (preg_match('#^custom.field([0-9]+?)#', $log['field'], $matches))
+               else if (preg_match('#^.?custom(.field)?([0-9]+?)#', $log['field'], $matches))
                {
-                       if ($fieldlist["$log[field]"])
+                       if ($fieldlist["$matches[2]"])
+                       {
+                               $log['field'] = $fieldlist["$matches[2]"];
+                       }
+                       else
                        {
-                               $log['field'] = $fieldlist["$log[field]"];
+                               continue;
                        }
                }
                else if (preg_match('#^\.(.*)#', $log['field'], $matches))
@@ -128,42 +132,54 @@ foreach ($logs AS $dateline => $logitems)
                        if (isset($lookupfields["$matches[1]"]))
                        {
                                $lookup = $matches[1];
-                               $log['original'] = $bugsys->datastore["$lookup"]["$log[original]"][ $lookupfields["$lookup"] ];
-                               $log['changed'] = $bugsys->datastore["$lookup"]["$log[changed]"][ $lookupfields["$lookup"] ];
+                               $log['original'] = bugdar::$datastore["$lookup"]["$log[original]"][ $lookupfields["$lookup"] ];
+                               $log['changed'] = bugdar::$datastore["$lookup"]["$log[changed]"][ $lookupfields["$lookup"] ];
                        }
                        else if ($matches[1] == 'assignto' OR $matches[1] == 'assignedto')
                        {
                                if ($log['original'])
                                {
-                                       $user = new UserAPI($bugsys);
+                                       $user = new UserAPI();
                                        $user->set('userid', $log['original']);
-                                       $user->set_condition();
+                                       $user->setCondition();
                                        $user->fetch();
-                                       $log['original'] = construct_user_display($user->objdata);
+                                       $log['original'] = construct_user_display($user->record);
                                }
                                
                                if ($log['changed'])
                                {
-                                       $user = new UserAPI($bugsys);
+                                       $user = new UserAPI();
                                        $user->set('userid', $log['changed']);
-                                       $user->set_condition();
+                                       $user->setCondition();
                                        $user->fetch();
-                                       $log['changed'] = construct_user_display($user->objdata);
+                                       $log['changed'] = construct_user_display($user->record);
                                }
                        }
                }
                
-               eval('$history .= "' . $template->fetch('history_bit') . '";');
+               BSFunctions::swap_css_classes('', 'altcolor');
+               
+               $tpl = new BSTemplate('history_bit');
+               $tpl->vars = array(
+                       'bgcolor'       => BSFunctions::$cssClass,
+                       'log'           => $log
+               );
+               $history .= $tpl->evaluate()->getTemplate();
                $show['group'] = false;
        }
 }
 
-eval('$template->flush("' . $template->fetch('history') . '");');
+// we can now remove all useless logs
+if (sizeof($toKill) > 0)
+{
+       $db->query("DELETE FROM " . TABLE_PREFIX . "history WHERE historyid IN (" . implode(',', $toKill) . ")");
+}
+
+$tpl = new BSTemplate('history');
+$tpl->vars = array(
+       'history'       => $history,
+       'bug'           => $bug
+);
+$tpl->evaluate()->flush();
 
-/*=====================================================================*\
-|| ###################################################################
-|| # $HeadURL$
-|| # $Id$
-|| ###################################################################
-\*=====================================================================*/
 ?>
\ No newline at end of file