<?php


require_once('../appheader.php');


$_SESSION['lang'] = "en";
require('../lang.' . $_SESSION['lang'] . '.php');
setcookie("lang", $_SESSION['lang']);


// Include the main TCPDF library (search for installation path).
require_once('tcpdf_include.php');
require_once "FPDI/fpdi.php";

//$global['runnerscount_m'] = "109";
//$global['runnerscount_f'] = "36";
//$global['runnerscount'] = "145";
//d($_GET);
$bibno = getpostval("bibno");
$key = getpostval("key");
//$bibno = str_pad($bibno, 3, "0", STR_PAD_LEFT);

// ---------------------------------------------------------

//			SUBSTR( MD5( CONCAT( bibno,  '-', firstname )),1,6) = :key 

$sql = "select *   from " .  $table_prefix . "runners where 1=1 	and 


			trim(bibno)  = trim('" . $bibno . "')

			"  ;
//echo $sql;			
$stmt = $db->prepare($sql);
//$stmt->bindValue(':bib', $bibno);
//$stmt->bindValue(':key', $key);
$stmt->execute();	
$runner = $stmt->fetch(PDO::FETCH_ASSOC);
//d($runner);


$sql = "select * from 	" .  $table_prefix . "course where code = :course";
$stmt = $db->prepare($sql);
$stmt->bindValue(':course', $runner['course']);
$stmt->execute();	
$course = $stmt->fetch(PDO::FETCH_ASSOC);
 

$sql = "select * from 	" .  $table_prefix . "membergroups where id = :group_id";
$stmt = $db->prepare($sql);
$stmt->bindValue(':group_id', $runner['group_id'], PDO::PARAM_INT);
$stmt->execute();	
$group = $stmt->fetch(PDO::FETCH_ASSOC);


$name = null;

if($group['israceteam'] == 1 )
{
	if ($runner['teamleader'] == 1)
	{
		$sql = "select * from " .  $table_prefix . "runners where id=" . $runner['id'] . " or leader_member_id = " . $runner['id'] . ' order by bibno';
	} else {
		$sql = "select * from " .  $table_prefix . "runners where id=" . $runner['leader_member_id'] . " or leader_member_id = " . $runner['leader_member_id']  . ' order by bibno';
	}
	 // d($sql);
	 $stmt = $db->prepare($sql);
	 $stmt->execute();
	 $teams = $stmt->fetchAll(PDO::FETCH_ASSOC);
	 
	 
	 foreach ($teams as $team)
	 {
	 	 $teambibno = $team['bibno'];
	 	
	 	if (haveChinese($name))
		{
				$teamname[] =  $team['firstname'] .  $team['lastname'];
		} else {
				$teamname[] =  ucwords($team['lastname'] .  $team['firstname']);
		}
	 
	 }
	 
	 
	 $teambibno =  substr( $bibno, 0, -1);
	 
	 
	 $sql = "select * from " .  $table_prefix . "teams_summary where bibno= '" . $teambibno . "'";
	$stmt = $db->prepare($sql);
	 $stmt->execute();
	 $teamresult = $stmt->fetch(PDO::FETCH_ASSOC);
	
	 if ($teamresult['slowest_cp_code']  ==  "FINISH" &&  $teamresult['finishedmember'] == $teamresult['regedmember'] ) {
	 	//
	 	$noteams = false;
	 } else {
	 	//die("invalid teams");
	 	$noteams = true;
	 }
	 
	 
} 


$name = trim($runner['firstname']) . ' ' .  trim($runner['lastname']);
$name =  ucwords(strtolower($name));
if (haveChinese($name))
{
	$name =  $runner['lastname'] .  $runner['firstname'];
}


if (!$runner || $runner['status'] == "DQ") {
die("participant not exist");
}


//$course= "FOUR TRAILS MINI 2023";


// ---------------------------------------------------------


$sql = "select *
		from
		  " .  $table_prefix . "trackrecord_summary
			
		where 
				 trim(bibno)  = trim('" . $bibno . "')
			
		";
		
//echo $sql;
		
$stmt = $db->prepare($sql);
// $stmt->bindValue(':bibno', $bibno, PDO::PARAM_STR);
$stmt->execute();	
$result = $stmt->fetch(PDO::FETCH_ASSOC);

//echo date_diff(strtotime($global['start']) - strtotime($result['lateststep_time']) );
//$finishtime_sec = s_datediff('s', $result['lateststep_time'],$global['start']);


//d($result );
//die();


if($group['israceteam'] != 1 )
{
	if (!$result['duration'] || $result['duration'] == 9999999) 
	{
		die("Invalid request");
	}


	if ($result['cp_code'] != "FINISH")
	{
		die("Invalid request");
	}
} else {


}


/*--------------------------------------------*/
//d($result);
//die();

if (strtoupper($result['gender']) == "M")
$rank_gender = $result['place_gender'] . ' of ' . $global['runnerscount_m'];

if (strtoupper($result['gender']) == "F")
$rank_gender = $result['place_gender'] . ' of ' . $global['runnerscount_f'];


$rank_course = $result['place_course'] 	  ;

//d($result);


if($group['israceteam'] != 1 )
{
	$finishtime = Duration($result['duration']);


	if ($runner['course'] == "16KM" || $runner['course'] == "5KM" )
	{
		if ($runner['group_id'] > 400) {
			$group_name = $group['name_en'];
			$rank_group = $result['place_group'];
		
		} else {
			if ($runner['gender'] == "F") {
				$group_name = "Female Group";
			} 
			if ($runner['gender'] == "M") {
				$group_name = "Male Group";
			}
			$rank_group = $result['place_gender'];
		}
	
	
	} else {
		$group_name = $group['name_en'] ;
		$rank_group = $result['place_group'];
	}

} else {
	$group_name = $group['name_en'] ;
	$rank_group = $teamresult['place_group'];
	$finishtime = Duration($teamresult['slowest_duration']);
	
}

//d($teamresult);

$course_name = $course['name_en'];
/*
$name = "XXX XXX XXX";
$rank_course = 8;
$rank_gender = 88; 
*/

/*--------------------------------------------*/


$pdf = new FPDI('L', 'mm', 'A4'); //FPDI extends TCPDF
$pdf->AddPage();
// if ($result['course_code'] == "20KM")
// {
// 	$pages = $pdf->setSourceFile('cert.pdf');
// } else {
// 	$pages = $pdf->setSourceFile('6km.pdf');
// }

$pages = $pdf->setSourceFile('cert.pdf');


$page = $pdf->ImportPage(1);
//$pdf->useTemplate($page, 0, 0);
$pdf->useTemplate($page,null, null, 0, 0, true);

// set document information
$pdf->SetCreator('SportSystem.hk');
$pdf->SetAuthor('SportSystem.hk');
$pdf->SetTitle('Certificate');
$pdf->SetSubject('Certificate of '. $name);
$pdf->SetKeywords('' );

// ---------------------------------------------------------

// set font
//$pdf->SetFont('helvetica', '', 20);

$textcenter = 24;


$pdf->SetTextColor(0,0,0);
//$pdf->SetXY(50, 30); 
//$pdf->Write(0, 'This is just a simple text');

/*
if($group['israceteam'] == 1 ) {

// display all team member name

	$pdf->SetFont('DroidSansFallback', '', 15, '', true);
	$pdf->SetY(26);  
	$pdf->Cell(1);
	$pdf->Cell(130,20,$name[0],0,1,'C');


	$pdf->SetY(26);  
	$pdf->Cell(48);
	$pdf->Cell(130,20,$name[1],0,1,'C');
	
	
	$pdf->SetFont('DroidSansFallback', '', 15, '', true);
	$pdf->SetY(33);  
	$pdf->Cell(1);
	$pdf->Cell(130,20,$name[2],0,1,'C');


	$pdf->SetY(33);  
	$pdf->Cell(48);
	$pdf->Cell(130,20,$name[3],0,1,'C');


} else {
*/
	
	if (strlen($name) > 23 )
	{
	$pdf->SetFont('DroidSansFallback', '', 20, '', true);
	} else {
	$pdf->SetFont('DroidSansFallback', '', 25, '', true);
	}


	$pdf->SetY(30);  
	$pdf->Cell($textcenter);
	$pdf->Cell(130,20,$name,0,1,'C');
/*
}
*/


$pdf->SetFont('DroidSansFallback', '', 13, '', true);
$pdf->SetY(46);  
$pdf->Cell($textcenter);
$pdf->Cell(130,20,'Lockton Fearless Dragon Trail Run 2023',0,1,'C');


$pdf->SetFont('DroidSansFallback', '', 13, '', true);
$pdf->SetY(57);  
$pdf->Cell($textcenter);
$pdf->Cell(130,20,$course_name,0,1,'C');


if ($group['israceteam'] == 1 && $noteams)
{

} else {
	$pdf->SetFont('DroidSansFallback','', 13);
	$pdf->SetY(68);  
	$pdf->Cell($textcenter);
	$pdf->Cell(130,20,$group_name,0,1,'C');


	$pdf->SetFont('DroidSansFallback','', 13);
	$pdf->SetY(80); 
	$pdf->Cell($textcenter);
	$pdf->Cell(130,15, $rank_group,0,1,'C');

}


$pdf->SetFont('DroidSansFallback','', 13);
$pdf->SetY(91); 
$pdf->Cell($textcenter);
$pdf->Cell(130,15, $rank_course,0,1,'C');


$pdf->SetFont('DroidSansFallback','', 13);
$pdf->SetY(98); 
$pdf->Cell($textcenter);
$pdf->Cell(130,20, $finishtime,0,1,'C');


$filename = "Lockton Fearless Dragon Trail Run Certificate of " . $bibno . '_' . $name . ".pdf";


// ---------------------------------------------------------

//Close and output PDF document
$pdf->Output($filename , 'I');

//============================================================+
// END OF FILE
//============================================================+