File size: 3.67Kb
<?
/**
* @ PACKAGE = DCMS-SOCIAL
* @ AUTHOR = DARIK
*/
include_once '../../../sys/inc/start.php';include_once '../../../sys/inc/compress.php';include_once '../../../sys/inc/sess.php';
include_once '../../../sys/inc/home.php';include_once '../../../sys/inc/settings.php';include_once '../../../sys/inc/db_connect.php';
include_once '../../../sys/inc/ipua.php';include_once '../../../sys/inc/fnc.php';include_once '../../../sys/inc/user.php';
// Только для пользователей
if (!isset($user))header("location: /index.php?");
// только для админов
if ($user['level'] == 0)header("location: /index.php?");
// ID
define ('id', isset( $_GET['id'] ) ? abs(intval($_GET['id'])) : 0);
// if id
if (id == 1 || id == 2 || id == 3){
// заголовок страницы
$set['title'] = 'Тех.поддержка';
// head
include_once '../../../sys/inc/thead.php';
title();
aut();
err();
// style
echo'<link rel="stylesheet" href="/tickets/style.css" type="text/css" />';
// st
$status = array('','На рассмотрение','Отклоненые','Закрытые');
$db = array('','0','1','2');
$img = array('','3','1','2');
// запросы
$count = mysql_result(mysql_query("SELECT COUNT(id) FROM `tickets` WHERE `st` = '".$db[id]."' "), 0);
echo''.($count ? '<div class="block_y"><div class="st_y"><img src="/tickets/img/'.$img[id].'.png" alt="*"> '.$status[id].' ('.$count.')</div>':'').'';
$k_page = k_page($count, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];
$q = mysql_query("SELECT * FROM `tickets` WHERE `st` = '".$db[id]."' ORDER BY time DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_assoc($q))
{
$count_comm = mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets_comm` WHERE `tickets` = '".$post['id']."' "), 0);
$count_n = mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets_comm` WHERE `tickets` = '".$post['id']."' and`time` > '".(time()-86400)."'"), 0);
if ($count_n==0)$count_n=NULL;
else $count_n='+'.$count_n;
$count_s = '('.$count_comm.') <font color="red">'.$count_n.'</font>';
$act = mysql_fetch_assoc(mysql_query("SELECT name FROM `tickets_type` WHERE `id` = $post[type] LIMIT 1"));
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[user] LIMIT 1"));
$name = htmlspecialchars( $act['name'] );
$description = htmlspecialchars( $post['description'] );
$st = array('<span style="color: #8c1422 ;"> На рассмотрение</span>','<span style="color: #8c1422 ;"> Отклонено</span>','<span style="color: #8c1422 ;"> Закрыт</span>');
echo'
<div class="s_y">
<span style="float: right;">' . vremja($post['time']) . '</span>
<span class="light_item">Заявка:</span> '.$name.'</br>
<span class="light_item">Статус:</span> '.$st[$post['st']].'</br>
<span class="light_item">Создал:</span> '. user::avatar($ank['id'], 2).''. user::nick($ank['id'], 1, 1, 1).'</br>
<span class="light_item">Комментариев:</span> '.$count_s.'</br>
'.$description.'</br>
<a href="/tickets/view/?id='.$post['id'].'">Войти в заявку</a>
</div>
';
}
echo''.($count ? '</div>':'<div class="block_y">Заявки еще не создавались</div>').'';
if ($k_page > 1)str('index.php?', $k_page, $page); // Вывод страниц
// admin
if ($user['level'] > 1)echo'<div class="block_y"><img src="/tickets/img/settings.png" alt="*"> <a href="/tickets/admin/">admin_panel</a></div>';
}else{ header("location: /tickets/admin/?");}
// foot
include_once '../../../sys/inc/tfoot.php';
?>