View file tickets/st/index.php

<?
/**
 * @ 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?");
	
// 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]."' AND `user` = $user[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]."' AND `user` = $user[id] ORDER BY time DESC LIMIT $start, $set[p_str]");
	while ($post = mysql_fetch_assoc($q))
	{
	$act = mysql_fetch_assoc(mysql_query("SELECT name FROM `tickets_type` WHERE `id` = $post[type] 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>
	'.$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); // Вывод страниц	
	echo'<div class="block_y"><a href="/tickets/"> Назад</a></div>';

// 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';
?>