ShowTicketPage.class.php

<?php

/**
 *  2Moons
 *  Copyright (C) 2012 Jan Kröpke
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @package 2Moons
 * @author Jan Kröpke <info@2moons.cc>
 * @copyright 2012 Jan Kröpke <info@2moons.cc>
 * @license http://www.gnu.org/licenses/gpl.html GNU GPLv3 License
 * @version 1.7.2 (2013-03-18)
 * @info $Id$
 * @link http://2moons.cc/
 */

class ShowTicketPage extends AbstractGamePage
{
	public static $requireModule = MODULE_SUPPORT;

	private $ticketObj;
	
	function __construct() 
	{
		parent::__construct();
		require('includes/classes/class.SupportTickets.php');
		$this->ticketObj	= new SupportTickets;
	}
	
	public function show()
	{
		global $USER, $LNG;

		$db = Database::get();
		$pageInfo	= HTTP::_GP('page', 'ticket', UTF8_SUPPORT);
		

		$sql = "SELECT t.*, COUNT(a.ticketID) as answer
		FROM %%TICKETS%% t
		INNER JOIN %%TICKETS_ANSWER%% a USING (ticketID)
		WHERE t.ownerID = :userID GROUP BY a.ticketID ORDER BY t.ticketID DESC;";

		$ticketResult = $db->select($sql, array(
			':userID'	=> $USER['id']
		));

		$ticketList		= array();
		
		foreach($ticketResult as $ticketRow) {
			$ticketRow['time']	= _date($LNG['php_tdformat'], $ticketRow['time'], $USER['timezone']);

			$ticketList[$ticketRow['ticketID']]	= $ticketRow;
		}
		
		$sql = "SELECT * FROM %%TICKETS%%;";
		$answerCount = $db->select($sql, array(
		));
		
		$timeBetween = 0;
		foreach($answerCount as $ticket){
			$sql = "SELECT * FROM %%TICKETS_ANSWER%% WHERE ticketID = :ticketID ORDER BY time ASC LIMIT 1,1;";
			$answerData = $db->selectSingle($sql, array(
				'ticketID'	=> $ticket['ticketID'],
			));
			if(empty($answerData))
				$answerData['time'] = TIMESTAMP;
			$timeBetween += $answerData['time'] - $ticket['time'];
		}
		
		$sql = "SELECT SUM(stars) as stars FROM %%TICKETS%% WHERE rated = 1;";
		$sumStarts = $db->selectSingle($sql, array(
		));
		
		$sql = "SELECT * FROM %%TICKETS%% WHERE rated = 1;";
		$sumStartsB = $db->select($sql, array(
		));
		
		$sumStarts = 100/max(1,(count($sumStartsB)*5))*$sumStarts['stars'];
		
		$this->tplObj->loadscript('ticket.js');
		$this->assign(array(
			'sumStarts'		=> round($sumStarts),
			'answerCount'	=> count($answerCount),
			'ticketList'	=> $ticketList,
			'pageInfo'		=> $pageInfo,
			'timeBetween'	=> round(($timeBetween/max(1,count($answerCount))),1),
		));
			
		$this->display('page.ticket.default.tpl');
	}
	
	function create() 
	{
		$categoryList	= $this->ticketObj->getCategoryList();
		
		$this->assign(array(
			'categoryList'	=> $categoryList,
		));
			
		$this->display('page.ticket.create.tpl');		
	}
	
	function send() 
	{
		global $USER, $LNG;
				
		$ticketID	= HTTP::_GP('id', 0);
		$categoryID	= HTTP::_GP('category', 0);
		$message	= HTTP::_GP('message', '', true);
		$subject	= HTTP::_GP('subject', '', true);
		
		if(empty($message)) {
			if(empty($ticketID)) {
				$this->redirectTo('game.php?page=ticket&mode=create');
			} else {
				$this->redirectTo('game.php?page=ticket&mode=view&id='.$ticketID);
			}
		}

		if(empty($ticketID))
		{
			if(empty($subject))
			{
				$this->printMessage($LNG['ti_error_no_subject'], true, array('game.php?page=ticket', 2));
			}

			$ticketID	= $this->ticketObj->createTicket($USER['id'], $categoryID, $subject);
		} else {
			$db = Database::get();

			$sql = "SELECT status FROM %%TICKETS%% WHERE ticketID = :ticketID;";
			$ticketStatus = $db->selectSingle($sql, array(
				':ticketID'	=> $ticketID
			), 'status');

			if ($ticketStatus == 2)
			{
				$this->printMessage($LNG['ti_error_closed'], true, array('game.php?page=ticket', 2));
			}
		}
		$WhichName = empty($USER['customNick']) ? $USER['username'] : $USER['customNick'];
		$this->ticketObj->createAnswer($ticketID, $USER['id'], $WhichName, $subject, $message, 0);
		$this->redirectTo('game.php?page=ticket&mode=view&id='.$ticketID);
	}
	
	function view() 
	{
		global $USER, $LNG;
		
		require 'includes/classes/BBCode.class.php';

		$db = Database::get();

		$ticketID			= HTTP::_GP('id', 0);
		
		$sql = "SELECT * FROM %%TICKETS%% WHERE ticketID = :ticketID;";
		$answerHack = $db->selectSingle($sql, array(
			':ticketID'	=> $ticketID
		));

		$sql = "SELECT a.*, t.categoryID, t.status, t.rated FROM %%TICKETS_ANSWER%% a INNER JOIN %%TICKETS%% t USING(ticketID) WHERE a.ticketID = :ticketID ORDER BY a.answerID;";
		$answerResult = $db->select($sql, array(
			':ticketID'	=> $ticketID
		));

		$answerList			= array();

		if(empty($answerResult)) {
			$this->printMessage(sprintf($LNG['ti_not_exist'], $ticketID), true, array('game.php?page=ticket', 2));
		}
		
		if($answerHack['ownerID'] != $USER['id']){
		PlayerUtil::sendMessage(1, '', 'Hack System', 4, 'Hack System', 'Hello admin, the player '.$USER['username'].' tryed to hack your ticket  page', TIMESTAMP);
		$this->printMessage($LNG['moon_hack'], true, array('game.php?page=ticket', 3));
		}

		$ticket_status = 0;
		

		foreach($answerResult as $answerRow) {
			$answerRow['time']		= _date($LNG['php_tdformat'], $answerRow['time'], $USER['timezone']);
			$answerRow['message']	= BBCode::parse($answerRow['message']);
			$answerRow['ownerID']	= $answerRow['ownerID'];
			$answerList[$answerRow['answerID']]	= $answerRow;
			if (empty($ticket_status))
			{
				$ticket_status = $answerRow['status'];
			}
			
			
		}

		$categoryList	= $this->ticketObj->getCategoryList();
		$this->tplObj->loadscript('ticket.js');
		$this->assign(array(
			'ticketID'		=> $ticketID,
			'categoryList'	=> $categoryList,
			'answerList'	=> $answerList,
			'status'		=> $ticket_status,
			'strated'		=> $answerRow['rated'],
		));
			
		$this->display('page.ticket.view.tpl');		
	}
}