<?php
function generate_pdf()
{
	$mpath = drupal_get_path('module', 'textbook_companion');
	require($mpath . '/pdf/fpdf/fpdf.php');
	global $user;
	$x = $user->uid;
	$proposal_id = arg(2);
	$query2 = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status=1 AND  proposal_id= :prop_id", array(
		':prop_id' => $proposal_id
	));
	$data2 = $query2->fetchObject();
	$query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id= :prop_id", array(
		':prop_id' => $proposal_id
	));
	$data3 = $query3->fetchObject();
	//var_dump($data3->gender);
	$gender = array(
		'salutation' => 'Mr. /Ms.',
		'gender' => 'He/She'
	);
	if ($data3->gender)
	{
		if ($data3->gender == 'M')
		{
			$gender = array(
				'salutation' => 'Mr.',
				'gender' => 'He'
			);
		} //$data3->gender == 'M'
		else
		{
			$gender = array(
				'salutation' => 'Ms.',
				'gender' => 'She'
			);
		}
	} //$data3->gender
	//die;
	/*if($data3->proposal_status == 3)
	{*/
	$pdf = new FPDF('L', 'mm', 'Letter');
	if (!$pdf)
	{
		echo "Error!";
	} //!$pdf
	$pdf->AddPage();
	$pdf->SetMargins(18, 1, 18);
	$pdf->Line(7.0, 7.0, 270.0, 7.0);
	$pdf->Line(7.0, 7.0, 7.0, 210.0);
	$pdf->Line(270.0, 210.0, 270.0, 7.0);
	$pdf->Line(7.0, 210.0, 270.0, 210.0);
	$pdf->Image("/Sites/scilab_in_2015/sites/default/files/scilab_logo.png", 10, 9, 0, 15);
	$path = drupal_get_path('module', 'textbook_companion');
	$pdf->Image($path . "/pdf/images/fossee.png", 228, 9, 0, 15);
	$pdf->SetFont('Arial', 'B', 25);
	$pdf->Ln(30);
	$pdf->Cell(240, 8, 'Certificate', 0, 1, 'C');
	$pdf->Ln(5);
	$pdf->SetFont('Arial', 'B', 12);
	$pdf->Cell(240, 8, 'Textbook Companion', '0', '1', 'C');
	$pdf->Ln(20);
	//$pdf->Cell(240,8,'IIT Bombay', '0','1','C');
	$pdf->SetFont('Arial', '', 12);
	if (strtolower($data3->branch) != "others")
	{
		$pdf->MultiCell(240, 8, 'This is to certify that ' . $gender['salutation'] . " " . $data3->full_name . ' from the Department of ' . $data3->branch . ', ' . $data3->university . ' has successfully completed Internship under Scilab Textbook Companion for a duration equivalent to six weeks. ' . $gender['gender'] . ' has coded, in Scilab, all the solved examples of the allotted textbook: ' . $data2->book . ' by ' . $data2->author . '.', 0);
	} //strtolower($data3->branch) != "others"
	else
	{
		$pdf->MultiCell(240, 8, 'This is to certify that ' . $gender['salutation'] . " " . $data3->full_name . ' from ' . $data3->university . ' has successfully completed training under Scilab Textbook Companion for a duration equivalent to six weeks. ' . $gender['gender'] . ' has coded, in Scilab, all the solved examples of the allotted textbook: ' . $data2->book . ' by ' . $data2->author . '.', 0);
	}
	$pdf->Cell(10, 10, 'The work done is available at ', '0', '0', 'L');
	$pdf->SetX(75);
	$pdf->SetFont('', 'U');
	$pdf->SetTextColor(0, 0, 255);
	$pdf->write(10, 'http://scilab.in', 'http://scilab.in');
	$pdf->SetFont('', '');
	$pdf->SetTextColor(0, 0, 0);
	$pdf->write(10, '.', '.');
	$pdf->Ln(10);
	$pdf->SetFont('Arial', '', 12);
	$pdf->SetTextColor(0, 0, 0);
	$pdf->Cell(10, 10, 'This work was funded by the FOSSEE project, IIT Bombay (for more details visit', '0', '0', 'L');
	$pdf->SetX(170);
	$pdf->SetFont('', 'U');
	$pdf->SetTextColor(0, 0, 255);
	$pdf->write(10, 'http://fossee.in', 'http://fossee.in');
	$pdf->SetX(198);
	$pdf->SetFont('', '');
	$pdf->SetTextColor(0, 0, 0);
	$pdf->write(10, ').');
	$pdf->SetY(-50);
	$pdf->SetX(209);
	$pdf->SetTextColor(0, 0, 0);
	$pdf->SetFont('', 'B');
	$pdf->Image($path . "/pdf/images/sign.png", 212, 151, 0, 15);
	//$pdf->SetX(206);
	$pdf->Cell(0, 7, 'Prof. Madhu Belur', 0, 1, 'L');
	$pdf->SetX(195);
	$pdf->Cell(0, 7, 'Principal Investigator - FOSSEE', 0, 1, 'L');
	$pdf->SetX(195);
	$pdf->Cell(0, 7, ' Dept. of Electrical Engineering', 0, 1, 'L');
	$pdf->SetX(216);
	$pdf->Cell(0, 7, 'IIT Bombay', 0, 1, 'L');
	$cur_date = date('jS F, Y');
	$pdf->SetY(180);
	$pdf->SetFont('', '');
	$pdf->Cell(200, 0, ' Date: ' . $cur_date . '', 0, 1, 'L');
	//$pdf->Cell(200,0,' Date: 28th August, 2013',0,1,'L');
	$pdf->Cell(200, 15, 'Email: textbook@scilab.in', 0, 1, 'L');
	$filename = str_replace(' ', '-', $data3->full_name) . '-Scilab-Textbook-Certificate.pdf';
	$file = $path . '/pdf/temp_certificate/' . $proposal_id . '_' . $filename;
	$pdf->Output($file, 'F');
	header("Content-Type: application/octet-stream");
	header("Content-Disposition: attachment; filename=" . $filename);
	header("Content-Type: application/octet-stream");
	header("Content-Type: application/download");
	header("Content-Description: File Transfer");
	header("Content-Length: " . filesize($file));
	flush(); // this doesn't really matter.
	$fp = fopen($file, "r");
	while (!feof($fp))
	{
		echo fread($fp, 65536);
		flush(); // this is essential for large downloads
	} //!feof($fp)
	fclose($fp);
	unlink($file);
	drupal_goto('certificate');
	return;
	/*}
	else
	{
	drupal_set_message('Your Book Is Still Under Review.', 'status');
	}*/
}
?>