<?php

	$zona = "0";
	if (isset($_GET["z"]))
	{
		$zona = $_GET["z"];
	}
	$plusdays = "0";
	if (isset($_GET["d"]))
	{
		$plusdays = $_GET["d"];
	}
	
	include("utility.php");
	require('fpdf16/fpdf.php');
	
	$handle = new DBAccess();
	$link = $handle->openConnection();

	$pdf = new FPDF('P', 'pt', array(1240, 1754));
	$pdf->AddPage();
	$pdf->Image('images/pdf_concerti.jpg', 0, 0, 1240, 1754);
	
	
	$start = 400;
	$fontgiorno = 24;
	$fontsize = 20;
	$incr = 26;
	$left = 100;
	
	$startImg = 400;
	$imgSize = 150;
	
	$arrConcerti = array();
	getConcertiPDF($handle, $zona, $arrConcerti, 14, $plusdays);
	if (count($arrConcerti) > 0)
	{
		if (count($arrConcerti) > 20)
		{
			$fontsize = 16;
			$incr = 22;
		}
		
		$pdf->SetFont('Arial', 'B', 33);
		$pdf->SetTextColor(255, 255, 255);
		$pdf->Text(680, 326, strtoupper($arrConcerti[0]["NomeZona"]));
		
		$dataConcerto = "";
		$ok = true;
		for ($i = 0; $i < count($arrConcerti); $i++)
		{
			if ($start < 1650)
			{
				if ($dataConcerto != formatDateFromSQL($arrConcerti[$i]["DataOra"], "dataestesasenzanno"))
				{
					if ($i > 0)
					{
						$start += 5;
					}
					$pdf->Image('images/pdf_concerti_img01.jpg', $left - 15, $start - 22, 500, 45);
					$dataConcerto = formatDateFromSQL($arrConcerti[$i]["DataOra"], "dataestesasenzanno");
					$pdf->SetFont('Arial', 'B', $fontgiorno);
					$pdf->SetTextColor(255, 255, 255);
					$pdf->Text($left, $start + 10, strtoupper($dataConcerto));
					$start += $incr + 15;
				}
				if ($arrConcerti[$i]["Foto"] != "")
				{
					if ($startImg < 1500)
					{
						$pdf->Image("public/" . $arrConcerti[$i]["PathFoto"] . "/tb_" . $arrConcerti[$i]["Foto"], 1000, $startImg, $imgSize, $imgSize);
					}
					$startImg += $imgSize + 20;
				}
				$pdf->Image('images/icone/ico-concerto.jpg', $left, $start - 12, 12, 12);
				$pdf->SetFont('Arial', '', $fontsize);
				$pdf->SetTextColor(100, 100, 100);
				$pdf->Text($left + 16, $start, $arrConcerti[$i]["NomeLuogo"] . " (" . $arrConcerti[$i]["Comune"] . ", " . $arrConcerti[$i]["Sigla"] . "), ore " . formatDateFromSQL($arrConcerti[$i]["DataOra"], "ora"));
				$start += ($incr - 4);
				$pdf->SetFont('Arial', 'I', $fontsize);
				$pdf->SetTextColor(0, 0, 0);
				$pdf->Text($left + 16, $start, getNomeArtistiConcerto($handle, $arrConcerti[$i]["ID"], 0));
			}
			else
			{
				if ($ok == true)
				{
					$pdf->SetFont('Arial', '', $fontsize);
					$pdf->Text($left + 16, $start, "...");
					$ok = false;
				}
			}
			$start += $incr;
		}
		if ($start >= 1650)
		{
			$pdf->SetFont('Arial', 'B', 20);
			$pdf->Text(755, 1700, "...CONTINUA SU");
		}
	}
	else
	{
		$pdf->Text($left, $start, "Nessun concerto...");
	}
	
  $pdf->Output("liveus_concerti.pdf", "D");
  
  function getConcertiPDF($db, $zona, &$concerti, $giorni, $plusdays)
	{
		if (count($concerti) == 0)
		{
			$concerti = array();
		}
		$query = "SELECT c.ID, c.DataOra, c.IDLuogo, c.Descrizione, c.Prezzo, c.Attivo, c.Insert_ID, c.Insert_DataOra, c.Update_ID, c.Update_DataOra,
										 if(c.Foto is null or c.Foto = '', if(r.Foto is null or r.Foto = '', t.Foto, r.Foto), c.Foto) Foto, 
										 if(c.Foto is null or c.Foto = '', 'realta', 'concerto') PathFoto, 
										 r.Nome NomeLuogo, IFNULL(r.IDProvincia, r.IDNazione) Sigla, cc.Comune, IFNULL(z.Nome, 'Settimana') NomeZona 
							FROM concerto c
							INNER JOIN realta r ON r.ID = c.IDLuogo
							INNER JOIN (SELECT rc.IDConcerto, max(r.Foto) Foto FROM realta_concerto rc INNER JOIN realta r on r.ID = rc.IDRealta GROUP BY rc.IDConcerto) t on t.IDConcerto = c.ID
							LEFT OUTER JOIN comuni cc ON cc.CodCom = r.IDComune 
							INNER JOIN zona z ON z.ID = " . $zona . " 
							INNER JOIN zona_provincia zp ON zp.IDProvincia = r.IDProvincia AND zp.IDZona = z.ID 
							WHERE c.Attivo >= 1 AND Date(c.DataOra) >= Curdate() + " . $plusdays . " ";
		if ($giorni > 0)
		{
			$query .= " AND Date(c.DataOra) < (Curdate() + " . $plusdays . ") + INTERVAL " . $giorni . " DAY ";
		}
		$query .= "ORDER BY DataOra ";

		$res = $db->getRecordset($query);
		$num_row = mysql_num_rows($res);
		if ($num_row > 0)
		{
			while($row = mysql_fetch_assoc($res))
			{
				array_push($concerti, $row);
			}
		}
	}
?>