Switch the 'modify' code of admin/field.php to use templates
[bugdar.git] / showreport.php
index 77ceb4f5c724836a3128ad11ca9eaa86a0662b1a..8d0c9ba8d66cf3885a4a4754b1f4ff307f957e07 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
@@ -27,14 +27,13 @@ $fetchtemplates = array(
        'bugfield_static_text'
 );
 
-define('SVN', '$Id$');
 
 $focus['showreport'] = 'focus';
 
 require_once('./global.php');
 require_once('./includes/functions_product.php');
 
-$bugid = $bugsys->input_clean('bugid', TYPE_UINT);
+$bugid = $input->inputClean('bugid', TYPE_UINT);
 
 // ###################################################################
 
@@ -42,18 +41,20 @@ if (empty($bugid) OR $_REQUEST['do'] == 'quicksearch')
 {
        if (!empty($bugid))
        {
-               if ($db->query_first("SELECT bugid FROM " . TABLE_PREFIX . "bug WHERE bugid = $bugid"))
+               if ($db->queryFirst("SELECT bugid FROM " . TABLE_PREFIX . "bug WHERE bugid = $bugid"))
                {
                        header("Location: showreport.php?bugid=$bugid");
                        exit;
                }
                else
                {
-                       $error = $lang->getlex('error_invalid_id');
+                       $error = L_INVALID_ID;
                }
        }
        
-       eval('$template->flush("' . $template->fetch('quicksearch') . '");');
+       $tpl = new BSTemplate('quicksearch');
+       $tpl->vars = array('error' => $error);
+       $tpl->evaluate()->flush();
        exit;
 }
 
@@ -61,34 +62,27 @@ if (empty($bugid) OR $_REQUEST['do'] == 'quicksearch')
 
 // -------------------------------------------------------------------
 // get the report
-$bug = $db->query_first("
-       SELECT bugvaluefill.*, bug.*, user.email, user.displayname, user.showemail
+$bug = $db->queryFirst("
+       SELECT bug.*, user.email, user.displayname, user.showemail
        FROM " . TABLE_PREFIX . "bug AS bug
        LEFT JOIN " . TABLE_PREFIX . "user AS user
                ON (bug.userid = user.userid)
-       LEFT JOIN " . TABLE_PREFIX . "bugvaluefill AS bugvaluefill
-               ON (bug.bugid = bugvaluefill.bugid)
        WHERE bug.bugid = $bugid"
 );
 
-if (!can_perform('canviewbugs', $bug['product']))
-{
-       $message->error_permission();
-}
-
-$show['edit'] = ((can_perform('caneditown', $bug['product']) AND $bugsys->userinfo['userid'] == $bug['userid'] AND $bug['userid'] != 0) OR (can_perform('caneditother', $bug['product']) AND $bugsys->userinfo['userid'] != $bug['userid']));
-$show['delete'] = can_perform('candeletedata', $bug['product']);
-
 if (!is_array($bug))
 {
-       $message->error($lang->getlex('error_invalid_id'));
+       $message->error(L_INVALID_ID);
 }
 
-if ($bug['hidden'] AND !can_perform('canviewhidden', $bug['product']))
+if (!check_bug_permissions($bug))
 {
-       $message->error_permission();
+       $message->errorPermission();
 }
 
+$show['edit'] = ((can_perform('caneditown', $bug['product']) AND bugdar::$userinfo['userid'] == $bug['userid'] AND $bug['userid'] != 0) OR (can_perform('caneditother', $bug['product']) AND bugdar::$userinfo['userid'] != $bug['userid']));
+$show['delete'] = can_perform('candeletedata', $bug['product']);
+
 // ###################################################################
 // edit display
 if ($show['edit'])
@@ -104,60 +98,69 @@ if ($show['edit'])
        }
        else
        {
-               $bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
-               $bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
-               $bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
-               $bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
+               $bug['status'] = bugdar::$datastore['status']["$bug[status]"]['status'];
+               $bug['resolution'] = bugdar::$datastore['resolution']["$bug[resolution]"]['resolution'];
+               $bug['severity'] = bugdar::$datastore['severity']["$bug[severity]"]['severity'];
+               $bug['priority'] = bugdar::$datastore['priority']["$bug[priority]"]['priority'];
        }
        
-       $show['assign'] = (can_perform('canassign', $bug['product']) ? true : false);
-       if (can_perform('canassign', $bug['product']) AND is_array($bugsys->datastore['assignto']))
+       $show['assign'] = (can_perform('canassign', $bug['product']));
+       if (can_perform('canassign', $bug['product']) && is_array(bugdar::$datastore['assignto']))
        {
-               foreach ($bugsys->datastore['assignto'] AS $dev)
+               foreach (bugdar::$datastore['assignto'] as $dev)
                {
-                       $value = $dev['userid'];
-                       $selected = (($dev['userid'] == $bug['assignedto']) ? true : false);
-                       $label = construct_user_display($dev, false);
-                       eval('$select[dev] .= "' . $template->fetch('selectoption') . '";');
+                       $tpl = new BSTemplate('selectoption');
+                       $tpl->vars = array(
+                               'value'         => $dev['userid'],
+                               'label'         => construct_user_display($dev, false),
+                               'selected'      => ($dev['userid'] == $bug['assignedto'])
+                       );
+                       $select['dev'] .= $tpl->evaluate()->getTemplate();
                }
        }
        
-       $pcv_select = construct_pcv_select('canviewbugs', "p$bug[product]c$bug[component]v$bug[version]");
+       $productSelect = construct_product_select('canviewbugs', "$bug[product],$bug[component],$bug[version]");
        
        if ($bug['duplicateof'])
        {
-               $duplicate = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
+               $duplicate = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
        }
        
        if ($bug['dependency'])
        {
                $depends = array();
                $dependencies = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
-               while ($dependency = $db->fetch_array($dependencies))
+               foreach ($dependencies as $dependency)
                {
                        $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\">$dependency[bugid]</a>";
                }
                $dependencies = implode(' ', $depends);
        }
        
-       $select['autoactions'] = '';
-       $show['autoactions'] = false;
-       if (is_array($bugsys->datastore['autoaction']))
+       $select['automations'] = '';
+       $show['automations'] = false;
+       if (is_array(bugdar::$datastore['automation']))
        {
-               foreach ($bugsys->datastore['autoaction'] AS $action)
+               foreach (bugdar::$datastore['automation'] as $action)
                {
-                       $label = $action['name'];
-                       $value = $action['actionid'];
-                       $selected = false;
-                       eval('$select[autoaction] .= "' . $template->fetch('selectoption') . '";');
-                       $show['autoactions'] = true;
+                       $tpl = new BSTemplate('selectoption');
+                       $tpl->vars = array(
+                               'label'         => $action['name'],
+                               'value'         => $action['actionid'],
+                               'selected'      => false
+                       );
+                       $select['automation'] .= $tpl->evaluate()->getTemplate();
+                       $show['automations'] = true;
                }
-               if ($show['autoactions'])
+               if ($show['automations'])
                {
-                       $label = '';
-                       $value = 0;
-                       $selected = true;
-                       eval('$select[autoaction] = "' . $template->fetch('selectoption') . '" . $select[autoaction];');
+                       $tpl = new BSTemplate('selectoption');
+                       $tpl->vars = array(
+                               'label'         => '',
+                               'value'         => 0,
+                               'selected'      => true
+                       );
+                       $select['automation'] = $tpl->evaluate()->getTemplate() . $select['automation'];
                }
        }
 }
@@ -168,19 +171,19 @@ else
 {
        // -------------------------------------------------------------------
        // prep display
-       $bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
-       $bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
-       $bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
-       $bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
+       $bug['status'] = bugdar::$datastore['status']["$bug[status]"]['status'];
+       $bug['resolution'] = bugdar::$datastore['resolution']["$bug[resolution]"]['resolution'];
+       $bug['severity'] = bugdar::$datastore['severity']["$bug[severity]"]['severity'];
+       $bug['priority'] = bugdar::$datastore['priority']["$bug[priority]"]['priority'];
        
-       $assigninfo = $bugsys->datastore['assignto']["$bug[assignedto]"];
+       $assigninfo = bugdar::$datastore['assignto']["$bug[assignedto]"];
        $bug['assigninfo'] = ((is_array($assigninfo)) ? construct_user_display($assigninfo) : '');
                
-       $duplicateof = $db->query_first("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
+       $duplicateof = $db->queryFirst("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
        
        $dupelist = array();
        $duplicates = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE duplicateof = $bug[bugid]");
-       while ($duplicate = $db->fetch_array($duplicates))
+       foreach ($duplicates as $duplicate)
        {
                $dupelist[] = "<a href=\"showreport.php?bugid=$duplicate[bugid]\" target=\"_blank\">$duplicate[summary]</a>";
        }
@@ -190,7 +193,7 @@ else
        {
                $depends = array();
                $dependencies = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
-               while ($dependency = $db->fetch_array($dependencies))
+               foreach ($dependencies as $dependency)
                {
                        $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\" target=\"_blank\">$dependency[bugid]</a>";
                }
@@ -203,14 +206,17 @@ else
 
 $show['subscribe'] = can_perform('cansubscribe', $bug['product']);
 
-$favorite = (bool)$db->query_first("SELECT * FROM " . TABLE_PREFIX . "favourite WHERE bugid = $bug[bugid] AND userid = " . $bugsys->userinfo['userid']);
-$favoritetext = ($favorite ? _('Remove from Favorites') : _('Add to Favorites'));
+$favorite = (bool)$db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "favorite WHERE bugid = $bug[bugid] AND userid = " . bugdar::$userinfo['userid']);
+$favoritetext = ($favorite ? T('Remove from Favorites') : T('Add to Favorites'));
 
 $bug['userinfo'] = construct_user_display($bug);
-$bug['datetime'] = $datef->format($bugsys->options['dateformat'], $bug['dateline']);
-$bug['product'] = $bugsys->datastore['product']["$bug[product]"]['title'];
-$bug['component'] = ($bug['component'] ? $bugsys->datastore['product']["$bug[component]"]['title'] : '');
-$bug['version'] = $bugsys->datastore['version']["$bug[version]"]['version'];
+$bug['datetime'] = $datef->format(bugdar::$options['dateformat'], $bug['dateline']);
+$bug['productid'] = $bug['product'];
+$bug['product'] = bugdar::$datastore['product']["$bug[product]"]['title'];
+$bug['componentid'] = $bug['component'];
+$bug['component'] = ($bug['component'] ? bugdar::$datastore['product']["$bug[component]"]['title'] : '');
+$bug['versionid'] = $bug['version'];
+$bug['version'] = bugdar::$datastore['version']["$bug[version]"]['version'];
 
 // ###################################################################
 // custom field output
@@ -235,23 +241,23 @@ foreach ($fields AS $field)
 
 // -------------------------------------------------------------------
 // hilight
-$words = explode(' ', $bugsys->in['hilight']);
+$words = explode(' ', $input->in['hilight']);
 foreach ($words AS $word)
 {
        if (trim($word))
        {
-               $word = preg_quote($bugsys->unsanitize($word));
+               $word = preg_quote($input->unsanitize($word));
                $hilight[] = $temp = trim(preg_replace('#[^0-9a-zA-Z_ ]#', '', $word));
        }
 }
 
 // -------------------------------------------------------------------
 // attachments
-$show['getattachments'] = ((can_perform('cangetattach', $bug['product']) OR can_perform('caneditattach', $bug['product'])) ? true : false);
-$show['putattachments'] = ((can_perform('canputattach', $bug['product']) OR can_perform('caneditattach', $bug['product'])) ? true : false);
-$show['attachments'] = ($show['getattachments'] OR $show['putattachments']) ? true : false;
+$show['getattachments'] = (can_perform('cangetattach', $bug['productid']) || can_perform('caneditattach', $bug['productid']));
+$show['putattachments'] = (can_perform('canputattach', $bug['productid']) || can_perform('caneditattach', $bug['productid']));
+$show['attachments'] = ($show['getattachments'] || $show['putattachments']);
 
-if ($show['getattachments'] OR $show['putattachments'])
+if ($show['getattachments'] || $show['putattachments'])
 {
        $attachments_fetch = $db->query("
                SELECT attachment.attachmentid, attachment.filename,
@@ -266,22 +272,27 @@ if ($show['getattachments'] OR $show['putattachments'])
        );
        
        $attaches = false;
-       while ($attachment = $db->fetch_array($attachments_fetch))
+       foreach ($attachments_fetch as $attachment)
        {
                $attaches = true;
-               $show['editattach'] = ((can_perform('caneditattach', $bug['product']) OR ($attachment['userid'] == $bugsys->userinfo['userid'] AND can_perform('canputattach', $bug['product']))) ? true : false);
-               $attachment['date'] = $datef->format($bugsys->options['dateformat'], $attachment['dateline']);
+               $show['editattach'] = (can_perform('caneditattach', $bug['productid']) || ($attachment['userid'] == bugdar::$userinfo['userid'] && can_perform('canputattach', $bug['productid'])));
+               $attachment['date'] = $datef->format(bugdar::$options['dateformat'], $attachment['dateline']);
                $attachment['user'] = construct_user_display($attachment, false);
-               eval('$attachments .= "' . $template->fetch('showreport_attachment') . '";');
+               
+               $tpl = new BSTemplate('showreport_attachment');
+               $tpl->vars = array(
+                       'attachment'    => $attachment
+               );
+               $attachments .= $tpl->evaluate()->getTemplate();
        }
        
-       $show['attachments'] = (!$show['putattachments'] AND !$attaches) ? false : true;
+       $show['attachments'] = ($show['putattachments'] && $attaches);
 }
 
 // -------------------------------------------------------------------
 // votes
 
-$vote = $db->query_first("SELECT *, FIND_IN_SET(" . $bugsys->userinfo['userid'] . ", userids) AS uservote FROM " . TABLE_PREFIX . "vote WHERE bugid = $bug[bugid]");
+$vote = $db->queryFirst("SELECT *, FIND_IN_SET(" . bugdar::$userinfo['userid'] . ", userids) AS uservote FROM " . TABLE_PREFIX . "vote WHERE bugid = $bug[bugid]");
 
 $vote['total'] = $vote['votefor'] + $vote['voteagainst'];
 if ($vote['total'] != 0)
@@ -295,7 +306,7 @@ else
        $vote['againstpercent'] = 0;
 }
 
-$show['vote'] = ((can_perform('canvote', $bug['product']) AND !$vote['uservote']) ? true : false);
+$show['vote'] = ((can_perform('canvote', $bug['productid']) AND !$vote['uservote']) ? true : false);
 
 // -------------------------------------------------------------------
 // get comments
@@ -304,19 +315,20 @@ $comments_fetch = $db->query("
        FROM " . TABLE_PREFIX . "comment AS comment
        LEFT JOIN " . TABLE_PREFIX . "user AS user
                ON (comment.userid = user.userid)
-       WHERE comment.bugid = $bug[bugid]" . (!can_perform('canviewhidden', $bug['product']) ? "
+       WHERE comment.bugid = $bug[bugid]" . (!can_perform('canviewhidden', $bug['productid']) ? "
                AND !hidden" : '') . "
        ORDER BY comment.dateline ASC"
 );
-while ($comment = $db->fetch_array($comments_fetch))
+$description = null;
+foreach ($comments_fetch as $comment)
 {
-       $comment['posttime'] = $datef->format($bugsys->options['dateformat'], $comment['dateline']);
+       $comment['posttime'] = $datef->format(bugdar::$options['dateformat'], $comment['dateline']);
        $comment['postby'] = construct_user_display($comment);
-       $show['editcomment'] = ((can_perform('caneditownreply', $bug['product']) AND $bugsys->userinfo['userid'] == $comment['userid']) OR (can_perform('caneditotherreply', $bug['product']) AND $bugsys->userinfo['userid'] != $comment['userid']));
+       $show['editcomment'] = ((can_perform('caneditownreply', $bug['productid']) AND bugdar::$userinfo['userid'] == $comment['userid']) OR (can_perform('caneditotherreply', $bug['productid']) AND bugdar::$userinfo['userid'] != $comment['userid']));
        
-       $bugsys->debug('can edit own replies: ' . (int)(can_perform('caneditownreply', $bug['product']) AND $bugsys->userinfo['userid'] == $comment['userid']));
-       $bugsys->debug('can edit other replies:' . (int)(can_perform('caneditotherreply', $bug['product']) AND $bugsys->userinfo['userid'] != $comment['userid']));
-       $bugsys->debug('$show[editcomment]: ' . $show['editcomment']);
+       BSApp::debug('can edit own replies: ' . (int)(can_perform('caneditownreply', $bug['productid']) AND bugdar::$userinfo['userid'] == $comment['userid']));
+       BSApp::debug('can edit other replies:' . (int)(can_perform('caneditotherreply', $bug['productid']) AND bugdar::$userinfo['userid'] != $comment['userid']));
+       BSApp::debug('$show[editcomment]: ' . $show['editcomment']);
        
        if (is_array($hilight))
        {
@@ -328,10 +340,20 @@ while ($comment = $db->fetch_array($comments_fetch))
                }
        }
        
-       eval('$comments .= "' . $template->fetch('showreport_comment') . '";');
+       $tpl = new BSTemplate('showreport_comment');
+       $tpl->vars = array('comment' => $comment);
+       $temp = $tpl->evaluate()->getTemplate();
+       if ($description == null)
+       {
+               $description = $temp;
+       }
+       else
+       {
+               $comments .= $temp;
+       }
 }
 
-$show['newreply'] = (can_perform('canpostcomments', $bug['product']) ? true : false);
+$show['newreply'] = (can_perform('canpostcomments', $bug['productid']) ? true : false);
 
 $bug['summary_title'] = $bug['summary'];
 if (is_array($hilight) AND !$show['edit'])
@@ -344,12 +366,17 @@ if (is_array($hilight) AND !$show['edit'])
        }
 }
 
-eval('$template->flush("' . $template->fetch('showreport') . '");');
+$tpl = new BSTemplate('showreport');
+$tpl->vars = array(
+       'bug'                   => $bug,
+       'comments'              => $comments,
+       'select'                => $select,
+       'vote'                  => $vote,
+       'favoritetext'  => $favoritetext,
+       'customfields'  => $customfields,
+       'attachments'   => $attachments,
+       'productSelect' => $productSelect
+);
+$tpl->evaluate()->flush();
 
-/*=====================================================================*\
-|| ###################################################################
-|| # $HeadURL$
-|| # $Id$
-|| ###################################################################
-\*=====================================================================*/
 ?>
\ No newline at end of file