<?
if (!isset($user['id']))
{
    header("Location: /index.php");
    exit;
}
if ($user['id'] == 1 &&  DB::$pdo -> querySingle("SELECT COUNT(*) FROM `bag_tracker_users` WHERE `id_user` = '".$user['id']."' AND `aut` > '0'") == 0)
{
    DB::$pdo -> query("INSERT INTO `bag_tracker_users` (`id_user`, `aut`, `time`) VALUES (?, ?, ?);", array($user['id'], time(), time()));
}
if (isset($_GET['my_invite']) && DB::$pdo -> querySingle("SELECT COUNT(*) FROM `bag_tracker_users` WHERE `id_user` = '".$user['id']."' AND `aut` = '0'") > 0)
{
    include_once 'inc/my_invite.php';
}
if (DB::$pdo -> querySingle("SELECT COUNT(*) FROM `bag_tracker_users` WHERE `id_user` = '".$user['id']."' AND `aut` > '0'") == 0)
{
    header("Location: /index.php");
    exit;
}
if ($user['id'] == 1 && isset($_GET['type_list']))
{
    include_once 'inc/type_list.php';
}
if ($user['id'] == 1 && isset($_GET['kat_list']))
{
    include_once 'inc/kat_list.php';
}
if ($user['id'] == 1 && isset($_GET['users_list']))
{
    include_once 'inc/users_list.php';
}
if (isset($_GET['add_tracker']))
{
    include_once 'inc/add_tracker.php';
}
if (isset($_GET['tracker']) && $_GET['tracker'] != NULL && is_numeric($_GET['tracker']) && $_GET['tracker'] > 0 && DB::$pdo -> querySingle("SELECT COUNT(*) FROM `bag_tracker` WHERE `id` = '".abs(intval($_GET['tracker']))."'") > 0)
{
    $tracker = DB::$pdo -> queryFetch("SELECT * FROM `bag_tracker` WHERE `id` = '".abs(intval($_GET['tracker']))."' LIMIT 1;");
    include_once 'inc/tracker.php';
}
$title = $l = 'Баг-трекер';
require (CORE.'head.php');
?>
<div class="app-block">
  <?  if ($user['id'] == 1)
{
?>
<div class="list _l-padd-n">
    <div class="tb-bloc">
        <div class="tb-cont tb-3">
            <div class="tb-item" style="width: 33.33%;">
                <a class="tb-c" href="/bag_tracker/?type_list">
                   Типы
                </a>
            </div>
            <div class="tb-item" style="width: 33.33%;">
                <a class="tb-c" href="/bag_tracker/?kat_list">
                    Категории
                </a>
            </div>
            <div class="tb-item" style="width: 33.33%;">
                <a class="tb-c" href="/bag_tracker/?users_list">
                    Пользователи
                </a>
            </div>
        </div>
    </div>
</div>


<?}?>
    
    
    
<a class="app-action" href="/bag_tracker/?add_tracker">
   <i class="our our-search"></i> Добавить отчет
</a>
<div class="list _l-padd-n">
    <div class="tb-bloc" style="border-top: 1px solid #dcd9d9;">
        <div class="tb-cont tb-2">
            <div class="tb-item" style="width: 33.33%;">
                <a class="tb-c" href="/bag_tracker/">
                    Все
                </a>
            </div>
            <div class="tb-item" style="width: 33.33%;">
                <a class="tb-c" href="/bag_tracker/?all_trackers">
                    Открытые
                </a>
            </div>
            <div class="tb-item" style="width: 33.33%;">
                <a class="tb-c" href="/bag_tracker/?old_trackers">
                    Закрытые
                </a>
            </div>
        </div>
    </div>
</div>
<?
if (isset($_GET['all_trackers']))
{
    $track_zap = "WHERE `status` = '0'";
    $track_link = '/bag_tracker/?all_trackers&';
}
else if (isset($_GET['old_trackers']))
{
    $track_zap = "WHERE `status` = '1'";
    $track_link = '/bag_tracker/?old_trackers&';
} else {
    $track_zap = "";
    $track_link = '/bag_tracker/?';
}
$total = DB::$pdo -> querySingle("SELECT COUNT(*) FROM `bag_tracker` $track_zap");
if ($total == 0)
{
?>
    <div class="list _gray _font-s _center">
        Отчеты не найдены!
    </div>
<?
} else {
    if ($total > 10)
    {
        $p = (($_GET['p']) ? intval($_GET['p']) : 1);
        $pagination = new pagination(10, $total, $p);
        $total_lin = $pagination -> limit;
    } else {
        $total_lin = '';
    }
    $query_gifts = DB :: $pdo -> query("SELECT * FROM `bag_tracker` $track_zap ORDER BY `id` DESC ".$total_lin."");
    while($r = $query_gifts -> fetch())
    {
        $id_type = DB::$pdo -> queryFetch("SELECT * FROM `bag_tracker_types` WHERE `id` = '".$r['id_type']."' LIMIT 1;");

        $ank = profile::getUser($r['id_user']);
        ?>
        <div class="list _l-padd-n">
            <div class="_l-padd">
                <div class="_oh">
 <span style="float: right;">
  <span style="color:grey"> <b>Статус:</b> </span>
                <?
                if ($r['status'] == 1)
                {
                ?>
                    <span style="color:red"> Закрыт </span>
                <?
                } else {
                ?>
                 <span style="color:green">   Активен </span>
                <?
                }
                ?><br />
                 <span style="color:grey">   <b>Приоритет:</b> </span>
                <?
                if ($r['prioritet'] == 1)
                {
                ?>
                    <span style="color:LightSeaGreen"> Средний </span>
                <?
                }
                else if ($r['prioritet'] == 2)
                {
                ?>
                  <span style="color:DarkCyan">   Высокий</span>
                <?
                } else {
                ?>
                 <span style="color:Teal">    Низкий</span>
                <?
                }
                ?>
                <br />
                 <span style="color:grey">   <b>Тип:</b> </span>
                  <span style="color:#7d7d7d;"><?echo stripcslashes(htmlspecialchars($id_type['name']));?></span>
                </span>
                    <div class="list-flex">
                        <div class="post-l">
                            <?echo profile::userAvatar($ank, 3);?>
                        </div>
                        <div class="post-c">
                            <div class="_name">
                                <?echo profile::getfirstname($ank);?>
                            </div>
                            <div class="_time">
                                <?echo system::times($r['time']);?>
                            </div>
                            <span class="_gray _font-m">
                                <?echo stripcslashes(htmlspecialchars($r['title']));?>
                            </span>
                        </div>
                    </div>
                </div>
            </div>
            <div class="tb-line"></div>
            <div class="tb-bloc">
                <div class="tb-cont tb-2">
                    <div class="tb-item" style="width: 100%;">
                        <a class="tb-c" href="/bag_tracker/?tracker=<?echo $r['id'];?>">
                            Подробнее
                        </a>
                    </div>
                </div>
            </div>
        </div>
    <?
    }
    if ($total > 10)
    {
        echo $pagination -> printPages($track_link); 
    }
}

require (CORE.'foot.php');
?>