File size: 3.73Kb
<?
/**
* @ 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?");
// заголовок страницы
$set['title'] = 'Тех.поддержка : admin_panel';
// head
include_once '../../sys/inc/thead.php';
title();
aut();
err();
// запросы
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets`",$db), 0);
$count_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `time` > '".(time()-86400)."'",$db), 0);
if ($count_n==0)$count_n=NULL;
else $count_n='+'.$count_n;
$count_s = '('.$count.') <font color="red">'.$count_n.'</font>';
$count_1 = mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `st` = 0",$db), 0);
$count_1_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `st` = 0 and`time` > '".(time()-86400)."'",$db), 0);
if ($count_1_n==0)$count_1_n=NULL;
else $count_1_n='+'.$count_1_n;
$count_1_s = '('.$count_1.') <font color="red">'.$count_1_n.'</font>';
$count_2 = mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `st` = 1",$db), 0);
$count_2_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `st` = 1 and`time` > '".(time()-86400)."'",$db), 0);
if ($count_2_n==0)$count_2_n=NULL;
else $count_2_n='+'.$count_2_n;
$count_2_s = '('.$count_2.') <font color="red">'.$count_2_n.'</font>';
$count_3 = mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `st` = 2",$db), 0);
$count_3_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `tickets` WHERE `st` = 2 and`time` > '".(time()-86400)."'",$db), 0);
if ($count_3_n==0)$count_3_n=NULL;
else $count_3_n='+'.$count_3_n;
$count_3_s = '('.$count_3.') <font color="red">'.$count_3_n.'</font>';
$count_4 = mysql_result(mysql_query("SELECT COUNT(id) FROM `tickets_type`"), 0);
echo'
<link rel="stylesheet" href="/tickets/style.css" type="text/css" />
<div class="block_y">
<div class="st_y">Всего заявок '.$count_s.'</div>
<div class="s_y">
<img src="/tickets/img/3.png" alt="*"> <a href="/tickets/admin/st/?id=1">На рассмотрение '.$count_1_s.'</a></br>
<img src="/tickets/img/1.png" alt="*"> <a href="/tickets/admin/st/?id=2">Отклоненые '.$count_2_s.'</a></br>
<img src="/tickets/img/2.png" alt="*"> <a href="/tickets/admin/st/?id=3">Закрытые '.$count_3_s.'</a></br>
</div>
</div>
<div class="block_y">
<div class="st2_y">Всего категорий ('.$count_4.') </div><div class="s_y">
';
$q4 = mysql_query("SELECT * FROM `tickets_type` ORDER BY id");
while ($post3 = mysql_fetch_assoc($q4))
{
$name = htmlspecialchars( $post3['name'] );
echo''.$name.'
<a href="/tickets/admin/edit/?id='.$post3['id'].'"> <img src="/tickets/img/profile.png" alt="*"> </a> |
<a href="/tickets/admin/delete/?id='.$post3['id'].'"> <img src="/tickets/img/delete.png" alt="*"></a>
</br>';
}
echo'
<img src="/tickets/img/dir_create.png" alt="*"> <a href="/tickets/admin/add/">Создать категорию</a></div></div>
<div class="block_y"><img src="/tickets/img/settings.png" alt="*"> <a href="/tickets/admin/sys/">Системные настройки</a></div>
';
// foot
include_once '../../sys/inc/tfoot.php';
?>