<?php
include "../includes/global_functions.inc.php";

$types = array('thisweek','thismonth','bydate','search','nextmonth');

if(in_array($_GET['type'],$types)){
	$type = $_GET['type'];
}
switch($type):
	case ('thisweek'):
		$meta_title = "This weeks concert tickets";
		$meta_description = "This weeks concert tickets";
		$meta_keywords = "Concert tickets this week";
		$startdate = ( strtotime ( "next friday" ) - 86400);
		$enddate = (strtotime ( "next monday" )+86400);

		$current_date = true;
		$query = 'SELECT
tblevent.category_id,
tblevent.event,
tblevent.event_id,
tblevent.startdate,
tblvenue.venue,
tblcategory.url,
tblcategory.category,
tblcategory.type
FROM tblevent
INNER JOIN tblcategory ON tblevent.category_id = tblcategory.category_id
INNER JOIN tblvenue ON tblevent.venue_id = tblvenue.venue_id
WHERE tblevent.startdate >= CURDATE()
AND tblevent.enddate < DATE_ADD(CURDATE(),INTERVAL 8 DAY)
AND tblevent.active = "y"
ORDER BY startdate ASC';
	break;
	case ('thismonth'):
		$meta_title = "This months concert tickets";
		$meta_description = "This months concert tickets";
		$meta_keywords = "Concert tickets this month";
		$current_date = true;
		$lastday = strtotime ( "first day of next month" );
		$query = "SELECT
tblevent.category_id,
tblevent.event,
tblevent.event_id,
tblevent.startdate,
tblvenue.venue,
tblcategory.url,
tblcategory.category,
tblcategory.type
FROM tblevent
INNER JOIN tblcategory ON tblevent.category_id = tblcategory.category_id
INNER JOIN tblvenue ON tblevent.venue_id = tblvenue.venue_id
WHERE tblevent.startdate >= CURDATE()
AND tblevent.enddate < DATE_ADD(LAST_DAY( NOW() ), INTERVAL 2 DAY  )
AND tblevent.active = 'y'
ORDER BY startdate ASC";
	break;
	case ('nextmonth'):
		$meta_title = "Next months concert tickets";
		$meta_description = "Next months concert tickets";
		$meta_keywords = "Concert tickets next month";
		$current_date = true;
		$firstday = ( strtotime ( "first day of next month" ) - 86400 );
		$lastday = ( strtotime ( "last day of next month" ) + 46137 );

		$query = "SELECT
tblevent.category_id,
tblevent.event,
tblevent.event_id,
tblevent.startdate,
tblvenue.venue,
tblcategory.url,
tblcategory.category,
tblcategory.type
FROM tblevent
INNER JOIN tblcategory ON tblevent.category_id = tblcategory.category_id
INNER JOIN tblvenue ON tblevent.venue_id = tblvenue.venue_id
WHERE tblevent.startdate > (DATE_SUB(LAST_DAY(DATE_ADD(NOW(), INTERVAL 1 MONTH)), INTERVAL DAY(LAST_DAY(DATE_ADD(NOW(), INTERVAL 1 MONTH)))-0 DAY))
AND tblevent.enddate < DATE_ADD( LAST_DAY(DATE_ADD(NOW(), INTERVAL 1 MONTH)), INTERVAL 2 DAY )
AND tblevent.active = 'y'
ORDER BY startdate ASC";

		// echo "<!--".$query."-->";
	break;
	case ('bydate'):

		$current_date = true;

		if(is_numeric($_GET['month'])&&is_numeric($_GET['year'])):
			$fromdate = $_GET['year'] . '-' . $_GET['month'] .'-01';
			$fromdate = strtotime ( $fromdate );
			$currentdate = strtotime ( 'now' );


			if ($currentdate < $fromdate) {
				$date = date('F Y',$fromdate);
				$meta_title = "Concert tickets for ".$date;
				$meta_description = "Concert tickets for ".$date;
				$meta_keywords = "Concert tickets for ".$date;
				$query = "SELECT tblevent.category_id, tblcategory.url, tblcategory.category, tblevent.event, tblevent.event_id, tblevent.startdate, tblvenue.venue, tblcategory.type FROM tblevent INNER JOIN tblcategory ON tblevent.category_id = tblcategory.category_id INNER JOIN tblvenue ON tblevent.venue_id = tblvenue.venue_id WHERE tblevent.enddate < DATE_ADD(DATE_ADD(FROM_UNIXTIME(".$fromdate."),INTERVAL 1 Month),INTERVAL 1 DAY) AND tblevent.startdate > DATE_SUB(FROM_UNIXTIME(" . $fromdate . "), INTERVAL 1 DAY) AND tblevent.active = 'y' ORDER BY startdate ASC";
			} else {
				$meta_title = "The date you have entered is in the past";

			}
		endif;
	break;
	case ('search'):
		$keyword = isset($_GET['keyword']) ? $_GET['keyword'] : null ;
		$meta_title = "Search for " . $keyword;
		$meta_description = "Search for" . $keyword;
		$meta_keywords = "Search for Concert tickets";
		$query = "SELECT tblcategory.category_id, tblcategory.url, tblcategory.category, tblcategory.type FROM tblcategory WHERE category LIKE '%". $keyword . "%' AND tblcategory.active = 'y' ORDER BY category ASC";
	break;
endswitch;

double8_connect();
if( !empty( $query ) ){
	$result = mysql_query($query);
	$numrows = mysql_num_rows ( $result );
	while(($categories[] = mysql_fetch_assoc($result)) || array_pop($categories));
}
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" class="no-js no-cssgradients">
	<head>
		<meta charset="utf-8">
		<title><?php if ( $meta_title ) { echo $meta_title.', '; } ?>Concert Tickets, Double8Tickets</title>
		<meta name="viewport" content="width=device-width,initial-scale=1">
		<meta name="keywords" content="<?php echo $meta_keywords ?>, concert tickets;" />
		<meta name="description" content="<?php echo $meta_description ?> concert tickets for UK Concerts! Call: 020 88 88 88 88." />
		<meta name="geo.region" content="GB" />
		<meta name="geo.position" content="51.5095437;-0.1269234" />
		<meta name="ICBM" content="51.5095437,-0.1269234" />
		<link rel="schema.DC" href="/http://purl.org/dc/elements/1.1/" />
		<link rel="schema.DCTERMS" href="/http://purl.org/dc/terms/" />
		<meta name="DC.title" lang="en" content="<?php echo $meta_title ?>, Concert Tickets, Double8Tickets" />
		<meta name="DC.creator" content="Double 8 Tickets" />
		<meta name="DC.subject" lang="en" content="<?php echo $meta_title ?>; concert tickets;" />
		<meta name="DC.description" lang="en" content="<?php echo $meta_description ?> concert tickets for UK Concerts! Call: 020 88 88 88 88." />
		<meta name="DC.publisher" content="Double 8 Tickets" />
		<meta name="DC.type" scheme="DCTERMS.DCMIType" content="Text" />
		<meta name="DC.identifier" scheme="DCTERMS.URI" content="http://www.double8tickets.com" />
		<meta name="DC.language" scheme="DCTERMS.RFC1766" content="en" />
		<link rel="apple-touch-icon" href="/apple-touch-icon.png" />
		<?php
		if(!$style){
		?>
		<link rel="stylesheet" href="/css/layout.css">
		<?php
		} else {
		?>
		<link rel="stylesheet" href="/css/layout.css<?php // echo $style ?>">
		<?php
		}
		?>
		<link type="text/css" rel="stylesheet" href="//fast.fonts.net/cssapi/0f75fa9f-5551-4d61-94cc-3367e13abafd.css"/>
		<link href="https://fonts.googleapis.com/css?family=Roboto:400,700" rel="stylesheet">
		<link rel="stylesheet" href="/js/shadowbox/shadowbox.css">
		<script src="/js/modernizr.js" type="text/javascript"></script>
		<script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
		<script src="/js/jquery.cycle.all.min.js" type="text/javascript" ></script>
		<script src="/js/shadowbox/shadowbox.js" type="text/javascript" ></script>
		<script src="/js/jquery.ini.js" type="text/javascript"></script>

	</head>
	<body>

		<script type="text/javascript">
			(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
			(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
			m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
			})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
			ga('create', 'UA-2360595-19', 'auto');
			ga('require', 'linkid');
			ga('send', 'pageview');
		</script>

		<header class="head">
			<div class="row">
				<div class="grid_12 header-top">
					<h1><a href="/">Concert Tickets, Double8Tickets</a></h1>
					<h2><a href="tel:02088888888"><span class="book">BOOK ONLINE OR CALL</span><span>020</span> 88 88 88 88</a></h2>
				</div>
			</div>
			<nav id="navigation" class="clearfix main-nav">
				<a class="hamburger" href="#" title="Menu">
					<span class="line-1"></span>
					<span class="line-2"></span>
					<span class="line-3"></span>
				</a>
				<div class="row header-inner">
					<ul class="menu">
						<li><a href="/">Home</a></li>
						<!-- <li class="hasdrawer">
							<a href="#">Concerts A to Z</a>
							<div class="drawer <?php if ($current_atoz) echo 'current'; ?>">
								<div class="inner clearfix">
								<a href="/concerts/a/">a</a> <a href="/concerts/b/">b</a> <a href="/concerts/c/">c</a> <a href="/concerts/d/">d</a> <a href="/concerts/e/">e</a> <a href="/concerts/f/">f</a> <a href="/concerts/g/">g</a> <a href="/concerts/h/">h</a> <a href="/concerts/i/">i</a> <a href="/concerts/j/">j</a> <a href="/concerts/k/">k</a> <a href="/concerts/l/">l</a> <a href="/concerts/m/">m</a> <a href="/concerts/n/">n</a> <a href="/concerts/o/">o</a> <a href="/concerts/p/">p</a> <a href="/concerts/q/">q</a> <a href="/concerts/r/">r</a> <a href="/concerts/s/">s</a> <a href="/concerts/t/">t</a> <a href="/concerts/u/">u</a> <a href="/concerts/v/">v</a> <a href="/concerts/w/">w</a> <a href="/concerts/x/">x</a> <a href="/concerts/y/">y</a> <a href="/concerts/z/">z</a> <a href="/concerts/0/">0/9</a>
								</div>
							</div>
						</li> -->
						<li class="hasdrawer">
							<a href="#" <?php if ($current_date) echo 'class="hovered"'; ?>>View concerts by date</a>
							<div class="drawer <?php if ($current_date) echo 'current'; ?>">
								<div class="inner clearfix">
								<a href="/concerts/thisweek/">This Week</a> <a href="/concerts/thismonth/">This Month</a> <a href="/concerts/nextmonth/">Next Month</a>
								<?php
								// $this_day = (is_numeric($_GET['day'])) ? $_GET['day'] : date('d') ;
								$this_month = (is_numeric($_GET['month'])) ? $_GET['month'] : date('m',strtotime('next month'));


								?>
								<form method="get" action="/concerts/bydate/">
									<div id="datesearch" class="search">
										<label for="keyword">By Month:</label>
										<select name="month">
		<?php $i = 1; for( $i==1 ; $i < 13 ; $i++ ): ?>
										<option value="<?php echo $i; ?>" <?php if( $i == $this_month ) echo 'selected="selected"'; ?>><? echo date('M',mktime(0, 0, 0, $i, 1,2012)); ?></option>
		<?php endfor; ?>
										</select>
										<select name="year">
		<?php $i = null; $year = date('o'); for( $i==0 ; $i < 5 ; $i++ ): ?>
										<option value="<?php echo $year+$i; ?>"><?php echo $year+$i; ?></option>
		<?php endfor; ?>
										</select>
										<button class="date-button"><span>Search</span></button></form>
									</div>
								</form>
								</div>
							</div>
						</li>
						<!--<li><div id="search" class="search"><form method="get" action="/concerts/search/"><label for="keyword">Search:</label><input type="text" class="keyword" name="keyword" value="Type Keyword"><button><span>Search</span></button></form></div></li>-->
					</ul>
					<!-- Moved the search form out of the unordered list and updated Value text -->
					<div id="search" class="search">
						<form method="get" action="/concerts/search/">
							<label for="keyword">Search:</label>
							<input type="text" class="keyword" name="keyword" placeholder="Search for an artist…">
							<button><span>Search</span></button>
						</form>
					</div>
				</div>
			</nav>
		</header>



<?php // include "../includes/header.inc.php"; ?>



		<section class="tickets atoz">
			<div class="row clearfix">
				<div class="column search-page grid_12">

					<h1>Search Results</h1>
					<h2><?php echo $meta_title ?></h2>


					<?php if( $letter ): ?><h2 id="<?php echo $letter ?>"><?php echo $letter ?></h2><?php endif; ?>

	<?php
	/*
					<ul class="events atozlist">
<?php foreach($categories as $category): ?>
<?php if (file_exists("images/.category/" . $category['category_id'] . ".jpg")): ?>
<?php $image = ($category['type'] == 'alert' || $category['type'] == 'onsale') ? '<img class="'.$category['type'].'" alt="'.$category['type'].'!" src="/img/event-'.$category['type'].'.gif">' : null; ?>
						<li><a href="/concerts/<?php echo $category['url'] ?>/"><?php echo $image; ?><img src="/images/.category/<?php echo $category['category_id']; ?>.jpg" alt="<?php echo $category['category']; ?> concert image" /><span><?php echo $category['category']; ?></span></a></li>
<?php endif; ?>
<?php endforeach; ?>
					</ul>
	*/ 
	?>


					<div class="concertlist_wrapper">
						<?php foreach($categories as $category): ?>
							<div class="concertlist clearfix">
								<?php 
									if ($category['startdate']):
								?>
								<div class="deals_time deals_item">
									<?php 
										$datetime = strtotime($category['startdate']);
									?>
									<time datetime="<?php echo date('c',$datetime); ?>" class="calendar_icon">
										<strong><?php echo date('F',$datetime); ?></strong>
										<span><?php echo date('j',$datetime); ?></span>
									</time>
								</div>
								<?php 
									endif;
								?>
								<div class="details deals_item">
									<span class="artist_name"><?php echo $category['category']; ?></span>
								</div>

								<?php 
									$notice = '';
									if ($category['type'] == 'alert') {
										$notice = 'Ticket Alert!';
									} elseif ($category['type'] == 'onsale') {
										$notice = 'On Sale Now!';
									}

									if ($category['startdate']) {
										$notice = $category['venue'];
									}
								?>

								<div class="venue deals_item">
									<span class="venue_details"><?php echo $notice; ?></span>
								</div>

								<div class="deals_item deals_button">
									<a href="/concerts/<?php echo $category['url'] ?>/" class="prices_button">View Tickets</a>
								</div>
							</div>
						<?php endforeach; ?>
					</div>

				</div>
			</div>
		</section>
<?php include "../includes/footer.inc.php"; ?>