View file tickets/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?");
	
// заголовок страницы
	$set['title'] = 'Тех.поддержка'; 
	
// head	
	include_once '../sys/inc/thead.php';
	
	title();
	aut();
	err();

// style

	echo'<link rel="stylesheet" href="/tickets/style.css" type="text/css" />';

// На рассмотрение запросы 

	$count_2 = mysql_result(mysql_query("SELECT COUNT(id) FROM `tickets` WHERE `st` = 0 AND `user` = $user[id] "), 0);
	echo''.($count_2 ? '<div class="block_y"><div class="st_y"><img src="/tickets/img/3.png" alt="*"> <a href="/tickets/st/?id=1">На рассмотрение ('.$count_2.')</a></div>':'').'';
	$q2 = mysql_query("SELECT * FROM `tickets` WHERE `st` = 0 AND `user` = $user[id] ORDER BY time DESC LIMIT 1");
	while ($post1 = mysql_fetch_assoc($q2))
	{
	$act = mysql_fetch_assoc(mysql_query("SELECT name FROM `tickets_type` WHERE `id` = $post1[type] LIMIT 1"));		
	$name = htmlspecialchars( $act['name'] );
	$description = htmlspecialchars( $post1['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($post1['time']) . '</span>
	<span class="light_item">Заявка:</span> '.$name.'</br>
	<span class="light_item">Статус:</span> '.$st[$post1['st']].'</br>
	'.$description.'</br>
	<a href="/tickets/view/?id='.$post1['id'].'">Войти в заявку</a>
	</div>
	';
	}
	echo''.($count_2 ? '</div>':'').'';
		

// Отклоненые запросы 

	$count_1 = mysql_result(mysql_query("SELECT COUNT(id) FROM `tickets` WHERE `st` = 1 AND `user` = $user[id] "), 0);
	echo''.($count_1 ? '<div class="block_y"><div class="st_y"><img src="/tickets/img/1.png" alt="*"> <a href="/tickets/st/?id=2">Отклоненные ('.$count_1.')</a></div>':'').'';
	$q1 = mysql_query("SELECT * FROM `tickets` WHERE `st` = 1 AND `user` = $user[id] ORDER BY time DESC LIMIT 1");
	while ($post = mysql_fetch_assoc($q1))
	{
	$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_1 ? '</div>':'').'';
	
// Закрытые запросы 

	$count_3 = mysql_result(mysql_query("SELECT COUNT(id) FROM `tickets` WHERE `st` = 2 AND `user` = $user[id] "), 0);
	echo''.($count_3 ? '<div class="block_y"><div class="st_y"><img src="/tickets/img/2.png" alt="*"> <a href="/tickets/st/?id=3">Закрытые ('.$count_3.')</a></div>':'').'';
	$q3 = mysql_query("SELECT * FROM `tickets` WHERE `st` = 2 AND `user` = $user[id] ORDER BY time DESC LIMIT 1");
	while ($post2 = mysql_fetch_assoc($q3))
	{
	$act = mysql_fetch_assoc(mysql_query("SELECT name FROM `tickets_type` WHERE `id` = $post2[type] LIMIT 1"));		
	$name = htmlspecialchars( $act['name'] );
	$description = htmlspecialchars( $post2['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($post2['time']) . '</span>
	<span class="light_item">Заявка:</span> '.$name.'</br>
	<span class="light_item">Статус:</span> '.$st[$post2['st']].'</br>
	'.$description.'</br>
	<a href="/tickets/view/?id='.$post2['id'].'">Войти в заявку</a>
	</div>
	';
	}
	echo''.($count_3 ? '</div>':'').'';
		
// Выбор заявки

	echo'
	<div class="block_y">
	<div class="st2_y">Выберите вашу проблему:</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'<a href="/tickets/add/?id='.$post3['id'].'">'.$name.'</a></br>';
	}	
	echo'</div></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>';


// foot
	include_once '../sys/inc/tfoot.php';
?>