<?php
/*=====================================================================*\
|| ###################################################################
|| # Bugdar [#]version[#]
|| # Copyright Š2002-[#]year[#] 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.
|| #
|| # This program is distributed in the hope that it will be useful, but
|| # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
|| # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
|| # more details.
|| #
|| # You should have received a copy of the GNU General Public License along
|| # with this program; if not, write to the Free Software Foundation, Inc.,
|| # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
|| ###################################################################
\*=====================================================================*/

$fetchtemplates = array(
	'trackerhome',
	'trackerhome_bits',
	'pagenav',
	'pagenav_bit'
);

define('SVN', '$Id$');

$focus['index'] = 'focus';

require_once('./global.php');
require_once('./includes/class_pagination.php');
require_once('./includes/class_sort.php');

if (!can_perform('canviewbugs'))
{
	$message->error_permission();
}

$sort = new ListSorter('index');

// ###################################################################

$pagination = new Pagination('p', 'pp');
$count = $db->query_first("
	SELECT COUNT(*) AS count
	FROM " . TABLE_PREFIX . "bug
	WHERE (!hidden OR (hidden AND product IN (" . fetch_on_bits('canviewhidden') . "))" . (can_perform('canviewownhidden') ? " OR (hidden AND userid = " . $bugsys->userinfo['userid'] . " AND product IN (" . fetch_on_bits('canviewownhidden') . "))" : "") . ")
	AND product IN (" . fetch_on_bits('canviewbugs') . ")" . (($bugsys->options['hidestatuses'] OR isset($bugsys->userinfo['hidestatuses'])) ? "
	AND status NOT IN (" . ($bugsys->userinfo['hidestatuses'] != '' ? $bugsys->userinfo['hidestatuses'] : $bugsys->options['hidestatuses']) . ")" : "")
);

$pagination->total = $count['count'];
$pagination->split_pages();

$bugs_fetch = $db->query($sort->fetch_sql_query(null, $pagination->fetch_limit($pagination->page - 1) . ", " . $pagination->perpage));

while ($bug = $db->fetch_array($bugs_fetch))
{
	$funct->exec_swap_bg($stylevar['alt_color'], '');
	
	$bug['hiddendisplay'] = ((can_perform('canviewhidden', $bug['product']) OR (can_perform('canviewownhidden') AND $bug['userid'] == $bugsys->userinfo['userid'])) ? false : true);
	
	$bug['bgcolor'] = ($bugsys->userinfo['showcolors'] ? $bugsys->datastore['status']["$bug[status]"]['color'] : $funct->bgcolour);
	$bug['product'] = $bugsys->datastore['product']["$bug[product]"]['title'];
	$bug['version'] = $bugsys->datastore['version']["$bug[version]"]['version'];
	$bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
	$bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
	$bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
	$bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
	
	$bug['lastposttime'] = ($bug['hiddendisplay'] ? $bug['hiddenlastposttime'] : $bug['lastposttime']);
	$bug['lastpost'] = ($bug['hiddendisplay'] ? $bug['hiddenlastpostbyname'] : $bug['lastpostbyname']);
	
	$bug['lastposttime'] = $datef->format($bugsys->options['dateformat'], $bug['lastposttime']);
	
	eval('$bugs .= "' . $template->fetch('trackerhome_bits') . '";');
}

$db->free_result($bugs_fetch);

$order = $sort->fetch_display_array('p=' . $pagination->page . '&amp;pp=' . $pagination->perpage);
$show['pagenav'] = (($pagination->pagecount > 1) ? true : false);
$pagenav = $pagination->construct_page_nav($sort->fetch_sort_link($sort->sortkey));

eval('$template->flush("' . $template->fetch('trackerhome') . '");');

/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>