<?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
'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);
if (!check_bug_permissions($bug))
{
- $message->error_permission();
+ $message->errorPermission();
}
$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']);
}
// ###################################################################
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;
ksort($logs);
+$toKill = array();
+
foreach ($logs AS $dateline => $logitems)
{
$show['group'] = true;
{
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))
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