<?php
    $GLOBALS['highlight'] = 'home';

    $_category = isset($_GET['category']) ? intval($_GET['category']) : 0;
    $_status = isset($_GET['status']) ? intval($_GET['status']) : 0;

    $title = 'Bug Tracker';
    include('include/parts/header.php');
    
    echo box_outside_top('Bug Tracker', '[ <a href="?s=tracker_bugs_admin">Submit Bug Report</a> ]');
    echo box_inside_top();
?>
<div style="text-align: right;">
<form id="form_submit" action="?" method="get" class="form">
Status:
<input type="hidden" name="s" value="tracker_bugs">
<select name="status" class="input_select" onChange="document.getElementById('form_submit').submit();">
<option value="0">All Statuses</option>
<?php
    $tracker_bugs = mysqli_query_logged("SELECT * FROM tracker_bugs_status ORDER BY id");
    while ($tracker_bugs_row = mysqli_fetch_assoc($tracker_bugs))
    {
        echo '<option value="' . $tracker_bugs_row['id'] . '"' . ($tracker_bugs_row['id'] == $_status ? ' selected' : '') . '>' . $tracker_bugs_row['status_' . language()] . '</option>';
    }
?>
</select>
Category:
<select name="category" class="input_select" onChange="document.getElementById('form_submit').submit();">
<option value="0">All Categories</option>
<?php
    $tracker_bugs_categories = mysqli_query_logged("SELECT * FROM tracker_bugs_categories ORDER BY id");
    while ($tracker_bugs_categories_row = mysqli_fetch_assoc($tracker_bugs_categories))
    {
        echo '<option value="' . $tracker_bugs_categories_row['id'] . '"' . ($tracker_bugs_categories_row['id'] == $_category ? ' selected' : '') . '>' . $tracker_bugs_categories_row['category_' . language()] . '</option>';
    }
?>
</select>
</form>
</div>
<?php
    echo box_inside_bottom();
    $tracker_bugs = mysqli_query_logged("SELECT * FROM tracker_bugs" . ($_status || $_category ? " WHERE" : "") . ($_status ? " status = '" . $_status . "'" : "") . ($_status && $_category ? " AND" : "") . ($_category ? " category = '" . $_category. "'" : "") . " ORDER BY id DESC");
    if (mysqli_num_rows($tracker_bugs))
    {
        echo box_inside_top('margin: 10px 0px 0px 0px;');
        $z = 0;
        while ($tracker_bugs_row = mysqli_fetch_assoc($tracker_bugs))
        {
            echo '<div class="' . ($z++ % 2 ? 'on' : 'off'). '">';
            echo '<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr>';
            echo '<td width="50">' . $tracker_bugs_row['id'] . '</td>';
            echo '<td><a href="?s=tracker_bugs_info&i=' . $tracker_bugs_row['id'] . '">' . $tracker_bugs_row['summary'] . '</a></td>';
            $tracker_bugs_categories = mysqli_query_logged("SELECT * FROM tracker_bugs_categories WHERE id = '" . $tracker_bugs_row['category'] . "'");
            if ($tracker_bugs_categories_row = mysqli_fetch_assoc($tracker_bugs_categories))
            {
                echo '<td width="125">' . $tracker_bugs_categories_row['category_' . language()] . '</td>';
            }
            else
            {
                echo '<td width="125">Unknown</td>';
            }
            $tracker_bugs_status = mysqli_query_logged("SELECT * FROM tracker_bugs_status WHERE id = '" . $tracker_bugs_row['status'] . "'");
            if ($tracker_bugs_status_row = mysqli_fetch_assoc($tracker_bugs_status))
            {
                echo '<td width="75" class="' . $tracker_bugs_status_row['class'] . '">' . $tracker_bugs_status_row['status_' . language()] . '</td>';
            }
            else
            {
                echo '<td width="75">Unknown</td>';
            }
            echo '<td width="150">' . get_username($tracker_bugs_row['user_id'], 1) . '</td>';
            $tracker_bugs_comments = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM tracker_bugs_comments WHERE link_id = '" . $tracker_bugs_row['id'] . "'"));
            echo '<td width="100">' . $tracker_bugs_comments['count'] . ' Comments</td>';
            echo '<td width="125">' . substr($tracker_bugs_row['posted_on'], 0, 16) . '</td>';
            echo '</tr></table>';
            echo '</div>';
        }
        echo box_inside_bottom();
    }
    else
    {
        echo '<div style="padding: 3px 0px 0px 0px;"></div>';
        echo box_inside_top();
        echo 'There are no entries in the bugs database.';
        echo box_inside_bottom();
    }
    echo box_outside_bottom();

    include('include/parts/footer.php');
?>