<?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');
			
			}else{
				$gender = array('salutation' => 'Ms.', 'gender' => 'She');
			}
		}
		//die;
		/*if($data3->proposal_status == 3)
		{*/
			$pdf=new FPDF('L', 'mm', 'Letter');
			if (!$pdf)
			{
				echo "Error!";
			}
			$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);
		}
		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
			} 
		     	fclose($fp); 
			unlink($file);
                        drupal_goto('certificate');
                        return;
		/*}
		else
		{
			drupal_set_message('Your Book Is Still Under Review.', 'status');
		}*/
}	
?>