<?
//include ("validate.php");
if($_GET["id"]=="" && $_GET['email'] == "") {
echo "<br><br><br><div align=center><form name=frm method=get action=ApplForm1.php>Enter Reg. ID&nbsp;:&nbsp;<input name=id value='' size=5><br><br>OR<br><br>Primary Email ID&nbsp;:&nbsp;<input name=email value='' size=25><br><br><input type=submit value=Submit name=submit></form></div>";
}
elseif ($_GET['id'] != "" || $_GET['email'] != "") {
//$id = $_GET['id'];
//if($_SESSION["uid"]!="") {
//$id = $_SESSION["uid"];
$id = $_GET["id"];
if($id=="") $id=0;
$email = $_GET["email"];
require_once "connect.php";
ConnectDatabase();

$result = mysql_query( "select '' adate, fname, '' lname, sex, dob, add1, add2, city, pin, phone, email, '' email2, ". //11
	"degree2,studyyrs2,inst2,awardyr2,permarks2,degree3,studyyrs3,inst3,awardyr3,permarks3,degree4,studyyrs4,inst4,awardyr4,permarks4,degree5,studyyrs5,inst5,awardyr5,permarks5,".  //31
	"company1,desig1,fromdt1,todt1,expinmonth1,company2,desig2,fromdt2,todt2,expinmonth2,company3,desig3,fromdt3,todt3,expinmonth3,company4,desig4,fromdt4,todt4,expinmonth4, ". //51
	"batch, sop, ddno, dddate, ddbank,abmid ".  //57
	"from pgcabm where batch=2017 and (abmid=$id or email='$email')" ,$db);
	
$myrow = mysql_fetch_row( $result );
$id = $myrow[57];
if ($myrow[3]=="M") $gender = "Male";
else $gender = "Female";
//$result1 = mysql_query( "select lname from adm_master where poid='$myrow[53]'" ,$db); 
//$myrow1 = mysql_fetch_row( $result1 );
$plongname = "Certificate Programme in Agri-Business Management - $myrow[52]";
require('fpdf.php');

class PDF extends FPDF
{
//Page header
function Header()
{
	//Logo
	$this->Image('xlri.png',70,4,50);
	//Arial bold 15
	//$this->SetFont('Arial','B',15);
	//Move to the right
	//$this->Cell(80);
	//Title with border
	//$this->Cell(30,10,'Postgraduate Certificate in Business Management (PGCBM-11)',1,0,'C');
	//Line break
	$this->Ln(4);
}

//Better table
function ImprovedTable($header,$data)
{
	//Column widths
	//$w=array(40,35,40,45);
	$w=array(35,70,35,25);
	//Header
	$this->SetFont('Arial','B',8);
	for($i=0;$i<count($header);$i++)
		$this->Cell($w[$i],7,$header[$i],1,0,'C');
	$this->Ln();
	//Data
	$this->SetFont('Arial','',8);
	foreach($data as $row)
	{
		$this->Cell($w[0],6,$row[0],'LR');
		$this->Cell($w[1],6,$row[1],'LR');
		//$this->Cell($w[2],6,number_format($row[2]),'LR',0,'R');
		$this->Cell($w[2],6,$row[2],'LR',0,'C');
		$this->Cell($w[3],6,$row[3],'LR',0,'C');
		$this->Ln();
	}
	//Closure line
	$this->Cell(array_sum($w),0,'','T');
}

//Better table
function ImprovedTable1($header,$data)
{
	//Column widths
	//$w=array(40,35,40,45);
	$w=array(35,35,35,60);
	//Header
	$this->SetFont('Arial','B',8);
	for($i=0;$i<count($header);$i++)
		$this->Cell($w[$i],7,$header[$i],1,0,'C');
	$this->Ln();
	//Data
	$this->SetFont('Arial','',8);
	foreach($data as $row)
	{
		$this->Cell($w[0],6,$row[0],'LR');
		$this->Cell($w[1],6,$row[1],'LR');
		//$this->Cell($w[2],6,number_format($row[2]),'LR',0,'R');
		$this->Cell($w[2],6,$row[2],'LR',0,'C');
		$this->Cell($w[3],6,$row[3],'LR',0,'C');
		$this->Ln();
	}
	//Closure line
	$this->Cell(array_sum($w),0,'','T');
}

function ImprovedTable45($header,$data)
{
	//Column widths
	//$w=array(40,35,40,45);
	$w=array(75,70,15,15,10);
	//Header
	$this->SetFont('Arial','B',8);
	for($i=0;$i<count($header);$i++)
		$this->Cell($w[$i],7,$header[$i],1,0,'C');
	$this->Ln();
	//Data
	$this->SetFont('Arial','',8);
	foreach($data as $row)
	{
		$this->Cell($w[0],6,$row[0],'LR');
		$this->Cell($w[1],6,$row[1],'LR');
		//$this->Cell($w[2],6,number_format($row[2]),'LR',0,'R');
		$this->Cell($w[2],6,$row[2],'LR',0,'C');
		$this->Cell($w[3],6,$row[3],'LR',0,'C');
		$this->Cell($w[4],6,$row[4],'LR',0,'C');
		$this->Ln();
	}
	//Closure line
	$this->Cell(array_sum($w),0,'','T');
}
function ImprovedTable46($header,$data)
{
	//Column widths
	//$w=array(40,35,40,45);
	$w=array(40,15,80,20,20);
	//Header
	$this->SetFont('Arial','B',8);
	for($i=0;$i<count($header);$i++)

		$this->Cell($w[$i],7,$header[$i],1,0,'C');
	$this->Ln();
	//Data
	$this->SetFont('Arial','',8);
	foreach($data as $row)
	{
		$this->Cell($w[0],6,$row[0],'LR');
		$this->Cell($w[1],6,$row[1],'LR',0,'C');
		//$this->Cell($w[2],6,number_format($row[2]),'LR',0,'R');
		$this->Cell($w[2],6,$row[2],'LR');
		$this->Cell($w[3],6,$row[3],'LR',0,'C');
		$this->Cell($w[3],6,$row[4],'LR',0,'C');
		//$this->Cell($w[4],6,$row[5],'LR',0,'C');
		$this->Ln();
	}
	//Closure line
	$this->Cell(array_sum($w),0,'','T');
}
function ImprovedTable2($header,$data)
{
	//Column widths
	//$w=array(40,35,40,45);
	$w=array(80,85,20);
	//Header
	$this->SetFont('Arial','B',8);
	for($i=0;$i<count($header);$i++)
		$this->Cell($w[$i],7,$header[$i],1,0,'C');
	$this->Ln();
	//Data
	$this->SetFont('Arial','',8);
	foreach($data as $row)
	{
		$this->Cell($w[0],6,$row[0],'LR');
		$this->Cell($w[1],6,$row[1],'LR');
		//$this->Cell($w[2],6,number_format($row[2]),'LR',0,'R');
		$this->Cell($w[2],6,$row[2],'LR',0,'C');
		//$this->Cell($w[3],6,$row[3],'LR',0,'C');
		$this->Ln();
	}
	//Closure line
	$this->Cell(array_sum($w),0,'','T');
}

//Page footer
function Footer()
{
	//Position at 1.5 cm from bottom
	$this->SetY(-15);
	//Arial italic 8
	$this->SetFont('Arial','I',8);
	//Page number
	$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
}

function SetCol($col)
{
	//Set position at a given column
	$this->AddPage();
	$this->col=$col;
	$x=10+$col*65;
	$this->SetLeftMargin($x);
	$this->SetX($x);
}
}

//Instanciation of inherited class
$pdf=new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','B',12);
$pdf->SetFont('Times','B',12);
//for($i=1;$i<=40;$i++)
//	$pdf->Cell(0,10,'Printing line number '.$i,0,1);

//$pdf->Cell(0,20,'Form No.:- '.substr($myrow[53],0,2).$id.'                                                                                                     '.'Date.:- '.$myrow[0],0,1);
$pdf->Cell(0,20,'Form No.:- '.$id.'                                                                                                     '.'Date.:- '.date('d-m-Y'),0,1);
$pdf->Ln(0);
$pdf->SetFont('Times','',10);
$poid=$myrow[53];
$headi = 'CIRCUIT HOUSE AREA (EAST), JAMSHEDPUR – 831001';
$title = $plongname;
$w=$pdf->GetStringWidth($headi)+6;
$pdf->SetX((210-$w)/2);
$pdf->Cell($w,0,$headi,0,1);
$pdf->Ln(5);
$pdf->SetFont('Times','B',12);
$w=$pdf->GetStringWidth($title)+6;
$pdf->SetX((210-$w)/2);
if (substr($myrow[53],1,1)=="B") {
	$pdf->SetDrawColor(255,255,255);
	$pdf->SetFillColor(255,255,255);
	$pdf->SetTextColor(220,50,50);
	//$pdf->SetFillColor(0,0,0);
	//$pdf->SetTextColor(250,250,250);
}
elseif (substr($myrow[53],1,1)=="H") {
	$pdf->SetDrawColor(0,80,180);
	$pdf->SetFillColor(230,230,0);
	$pdf->SetTextColor(50,50,50);
	//$pdf->SetFillColor(250,250,250);
	//$pdf->SetTextColor(0,0,0);
}
else {
	$pdf->SetDrawColor(0,80,180);
	//$pdf->SetFillColor(230,230,0);
	//$pdf->SetTextColor(50,50,50);
	$pdf->SetFillColor(250,250,250);
	$pdf->SetTextColor(0,0,0);
}	
	
$pdf->Cell($w,0,$title,0,1);
//Save ordinate
$pdf->y0=$pdf->GetY();
//$w=$pdf->GetStringWidth($title)+6;
//$pdf->SetX((210-$w)/2);
//$pdf->SetFillColor(200,220,255);
//$pdf->Cell($w,0,$title,0,1,'L',1);
//$pdf->Cell($w,0,$title,0,1);
$pdf->Ln(10);
$pdf->SetLineWidth(0);
$pdf->SetDrawColor(0,0,0);
//$pdf->SetFillColor(230,230,0);
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Times','B',10);
$pdf->Cell(15,0,'DD Details:',0,1);
//$pdf->Ln(4);
//$pfile="./photo/".$poid."/". $id.".jpg";
//if (file_exists($pfile)) $pdf->Image($pfile,150,45,35);
//else 
$pdf->Image('pastphoto.PNG',150,45,35);
$pdf->SetFont('Times','',10);
$pdf->Ln(4);
$pdf->Cell(15,0,'DD No. :'.$myrow[54].'          Date:'.$myrow[55],0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Amount : Rs. 500/-',0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Bank :'.$myrow[56],0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Draft to be made in favor of',0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'"XLRI Jamshedpur" payable at "Jamshedpur"' ,0,1);
$pdf->SetFont('Times','B',10);
$pdf->Ln(10);
$pdf->Cell(15,0,'Personal Information (In BLOCK Letter)',0,1);
$pdf->Ln(7);
$pdf->SetFont('Times','',10);
$pdf->Cell(15,0,'Name                        :-  '.str_pad(strtoupper($myrow[1]),30," "),0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Gender                      :-  '.str_pad($gender,30," ").'                   Date of Birth  :-  '.str_pad($myrow[4],30," "),0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Phone                        :-  '.str_pad($myrow[9],30," "),0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Address for               :-  '.$myrow[5],0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Communication             '.$myrow[6],0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'                                        '.$myrow[7].' - '.$myrow[8],0,1);
$pdf->Ln(4);
$pdf->Cell(15,0,'Email                         :-  '.str_pad($myrow[10],30," "),0,1);
$pdf->SetFont('Times','B',10);
$pdf->Ln(10);
$pdf->Cell(15,0,'Academic Record',0,1);
$pdf->Ln(4);
//For Educational History in tabular form
//Column titles
$header=array('Degree in','YrsStudy','Institute/University','Year Awarded','% of Marks');
//Data loading
//$data=$pdf->LoadData();
$data=array();
	//$data[]=explode(';',chop($line));
	$tmp = $myrow[12].";".$myrow[13].";".$myrow[14].";".$myrow[15].";".$myrow[16];
	$data[]=explode(';',chop($tmp));
	$tmp = $myrow[17].";".$myrow[18].";".$myrow[19].";".$myrow[20].";".$myrow[21];
	$data[]=explode(';',chop($tmp));
	$tmp = $myrow[22].";".$myrow[23].";".$myrow[24].";".$myrow[25].";".$myrow[26];
	$data[]=explode(';',chop($tmp));
if($myrow[27]!="") {
	$tmp = $myrow[27].";".$myrow[28].";".$myrow[29].";".$myrow[30].";".$myrow[31];
	$data[]=explode(';',chop($tmp));
}

$pdf->ImprovedTable46($header,$data);
$pdf->SetFont('Times','B',10);
$pdf->Ln(4);
$pdf->Cell(15,0,'Work Experience :-',0,1);
$pdf->SetFont('Times','',8);
$pdf->Ln(4);
$pdf->Cell(15,0,'List last 6 organization that you worked with, starting with the current one. Minimun 2 years of work exp. till May, 2017.',0,1);
$pdf->Ln(2);
//For Work Experience in tabular form
//Column titles
$header=array('Company','Designation','From','To','in Month');
//Data loading
//$data=$pdf->LoadData();
$data=array();
	//$data[]=explode(';',chop($line));
	$tmp = $myrow[32].";".$myrow[33].";".$myrow[34].";".$myrow[35].";".$myrow[36];
	$data[]=explode(';',chop($tmp));
if($myrow[37]!="") {
	$tmp = $myrow[37].";".$myrow[38].";".$myrow[39].";".$myrow[40].";".$myrow[41];
	$data[]=explode(';',chop($tmp));
}
if($myrow[42]!="") {
	$tmp = $myrow[42].";".$myrow[43].";".$myrow[44].";".$myrow[45].";".$myrow[46];
	$data[]=explode(';',chop($tmp));
}
if($myrow[47]!="") {
	$tmp = $myrow[47].";".$myrow[48].";".$myrow[49].";".$myrow[50].";".$myrow[51];
	$data[]=explode(';',chop($tmp));
}

$pdf->ImprovedTable45($header,$data);
$pdf->SetFont('Times','',10);
$pdf->Ln(2);
$pdf->SetFont('Times','B',10);
$pdf->Ln(4);
$pdf->Cell(15,0,'SOP :-',0,1);
$pdf->SetFont('Times','',10);
$pdf->Ln(2);
$pdf->MultiCell(185,4,$myrow[53]);
$pdf->Ln(10);
$pdf->SetFont('Times','B',10);
$pdf->Cell(15,0,'Date:_________________',0,1);
$pdf->Ln(7);
$pdf->Cell(15,0,'Place:_________________',0,1);
$pdf->SetX(150);
$pdf->Cell(15,0,'Signature of Applicant',0,1);
$pdf->Ln(10);
$pdf->SetFont('Times','',10);
$pdf->MultiCell(185,4,"Please fill this application completely and post it to Corporate Programme Office, XLRI Jamshedpur, Circuit House Area (East),  Jamshedpur – 831001, Jharkhand, India, along with:");
$pdf->Ln(5);
$pdf->SetX(29);
$pdf->Cell(15,0,'•	Demand draft of Rs. 500/- in favour of “XLRI Jamshedpur” payable at Jamshedpur',0,1);
$pdf->Output();
}
?>