Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
applicationForm.php	19.66 KB	-rwxr-xr-x
applicationFormReportSBM.php	21.55 KB	-rwxr-xr-x
candidate_report.php	5.99 KB	-rwxr-xr-x
cappcontext.php	2.87 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	2.12 KB	-rwxr-xr-x
main.php	9 KB	-rwxr-xr-x
mregistry.php	2.91 KB	-rwxr-xr-x
mregistry_15092014.php	2.38 KB	-rwxr-xr-x
registration.php	41.83 KB	-rwxr-xr-x
registration09082016.php	31.84 KB	-rwxr-xr-x
registration1.php	21.71 KB	-rwxr-xr-x
registration_27082015.php	31.68 KB	-rwxr-xr-x
registration_before_hallticket...	23.29 KB	-rwxr-xr-x
registration_closed_after_last...	32.47 KB	-rwxr-xr-x
registration_old.php	22.54 KB	-rwxr-xr-x
report_hall_ticket.php	11.15 KB	-rwxr-xr-x
reports.php	5.29 KB	-rwxr-xr-x
sample.php	9.27 KB	-rwxr-xr-x
sample_pdf.pdf	13.52 KB	-rwxr-xr-x

Code Editor : registration.php

<?php
ini_set("display_errors","On");
require('tarka_pdf/fpdf.php');
require('applicationFormReportSBM.php');
error_reporting(E_ALL ^ E_NOTICE);
function loadWindowHeaderdetails($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);	
	/*$sql_query_header="select concat(funivname,',\n',faddress) as university_name from control";	*/
	$sql_query_header="select funivname as university_name,faddress as university_address from control";		
	$lobj_sql_query_header = $aobj_context->mobj_db->GetRow($sql_query_header); 
	$university_name=$lobj_sql_query_header[university_name];
	$university_address=$lobj_sql_query_header[university_address];
	$dataArray=Array();
	$dataArray['university_name']=$university_name;
	$dataArray['university_address']=$university_address;
	 
	if($lobj_sql_query_header)
	{		 
		echo $aobj_context->mobj_output->ToJSONEnvelope($dataArray,0,"success");
	}	  
	else 
	{
		$data='Error in Query Execution';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
	}	 
}

function loadDomicileStatedetails($aobj_context)
{ 
        session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
				
		//$sql_query_header="select concat(funivname,',\n',faddress) as university_name from control";	
		$sql_query_header="select fstatecode,fstatename from masstate order by forder asc";		
		$lobj_sql_query_header = $aobj_context->mobj_db->GetAll($sql_query_header); 
		
		 
		  if($lobj_sql_query_header)
		{		 
		 echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_sql_query_header,0,"success");
		}	  
		 
		else {
		$data='Error in Query Execution';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		}
		 
}

function saveFormEntry($aobj_context)
{ 
        session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		
		//$server_ip=$_SERVER["REMOTE_ADDR"];
		
		$fname=$aobj_context->mobj_data["fname"];
		$fgender=$aobj_context->mobj_data["fgender"];
		$fcategory=$aobj_context->mobj_data["fcategory"];
		$fnationality=$aobj_context->mobj_data["fnationality"];
		$fmother=$aobj_context->mobj_data["fmother"];
		$ffather=$aobj_context->mobj_data["ffather"];
		$fph_disabled=$aobj_context->mobj_data["fph_disabled"];
		$fgoi_nominee=$aobj_context->mobj_data["fgoi_nominee"];
		$fgovt_service_candidate=$aobj_context->mobj_data["fwhether_govt_service_candidate"];
		$fdomicile_state=$aobj_context->mobj_data["fdomicile_state"];
		$fpermanent_address_Corresp=$aobj_context->mobj_data["fpermanent_address_Corresp"];
		$fpermanent_address=$aobj_context->mobj_data["fpermanent_address"];
		$fmobile=$aobj_context->mobj_data["fmobile"];
		$faltmobile=$aobj_context->mobj_data["faltmobile"];
		$fphoneno=$aobj_context->mobj_data["fphoneno"];
		$femailid=$aobj_context->mobj_data["femailid"];
		$fcollegecode=$aobj_context->mobj_data["fcollegecode"];
		$funiversity=$aobj_context->mobj_data["funiversity"];
		$fpercentage=$aobj_context->mobj_data["fpercentage"];
		$fdate_of_birth=$aobj_context->mobj_data["date_of_birth"];
		$complt_internship_date=$aobj_context->mobj_data["complt_internship_date"];
		
		$fmax_marks1=$aobj_context->mobj_data["fmax_marks1"];
		$fsecured_marks1=$aobj_context->mobj_data["fsecured_marks1"];
		$fpercnt1=$aobj_context->mobj_data["fpercnt1"];
		$fno_of_attempts1=$aobj_context->mobj_data["fno_of_attempts1"];
		$fpassed_month1=$aobj_context->mobj_data["fpassed_month1"];
		
		$fmax_marks2=$aobj_context->mobj_data["fmax_marks2"];
		$fsecured_marks2=$aobj_context->mobj_data["fsecured_marks2"];
		$fpercnt2=$aobj_context->mobj_data["fpercnt2"];
		$fno_of_attempts2=$aobj_context->mobj_data["fno_of_attempts2"];
		$fpassed_month2=$aobj_context->mobj_data["fpassed_month2"];
		
		$fmax_marks3=$aobj_context->mobj_data["fmax_marks3"];
		$fsecured_marks3=$aobj_context->mobj_data["fsecured_marks3"];
		$fpercnt3=$aobj_context->mobj_data["fpercnt3"];
		$fno_of_attempts3=$aobj_context->mobj_data["fno_of_attempts3"];
		$fpassed_month3=$aobj_context->mobj_data["fpassed_month3"];
		
		$fmax_marks4=$aobj_context->mobj_data["fmax_marks4"];
		$fsecured_marks4=$aobj_context->mobj_data["fsecured_marks4"];
		$fpercnt4=$aobj_context->mobj_data["fpercnt4"];
		$fno_of_attempts4=$aobj_context->mobj_data["fno_of_attempts4"];
		$fpassed_month4=$aobj_context->mobj_data["fpassed_month4"];
		
		$fmax_marks5=$aobj_context->mobj_data["fmax_marks5"];
		$fsecured_marks5=$aobj_context->mobj_data["fsecured_marks5"];
		$fpercnt5=$aobj_context->mobj_data["fpercnt5"];
		$fno_of_attempts5=$aobj_context->mobj_data["fno_of_attempts5"];
		$fpassed_month5=$aobj_context->mobj_data["fpassed_month5"];
		
		$fmaxtot=$aobj_context->mobj_data["ftotalmax"];
		$fsecuretot=$aobj_context->mobj_data["ftotalsecured"];
		$fpercnttot=$aobj_context->mobj_data["ftotalpercnt"];
		
		$per_addr_corsp1=$aobj_context->mobj_data["per_addr_corsp1"];
		$per_addr_corsp2=$aobj_context->mobj_data["per_addr_corsp2"];
		$per_addr_corsp3=$aobj_context->mobj_data["per_addr_corsp3"];
		$per_addr_corsp4=$aobj_context->mobj_data["per_addr_corsp4"];
		
		$per_addrs1=$aobj_context->mobj_data["per_addrs1"];
		$per_addrs2=$aobj_context->mobj_data["per_addrs2"];
		$per_addrs3=$aobj_context->mobj_data["per_addrs3"];
		$per_addrs4=$aobj_context->mobj_data["per_addrs4"];
		
		$fchallan_date=$aobj_context->mobj_data["fchallan_date"];
		$fchallan_no=$aobj_context->mobj_data["fchallan_no"];
		$fchall_amount=$aobj_context->mobj_data["fchall_amount"];
		$fname_of_bank=$aobj_context->mobj_data["fname_of_bank"];
		$fbranch_name_place=$aobj_context->mobj_data["fbranch_name_place"];
		$student_entry_photo_path=$aobj_context->mobj_data["student_entry_photo_path"];
			
		$sql_query_header="select fappno as application_no,fyear,fsubcode,now() as date_time  from control ";		
		$lobj_sql_query_header = $aobj_context->mobj_db->GetRow($sql_query_header); 
		$application_no=$lobj_sql_query_header[application_no];
		$year=$lobj_sql_query_header[fyear];
		$subj_code=$lobj_sql_query_header[fsubcode];
		$fdate_time=$lobj_sql_query_header[date_time];
	
		$sql_insert_query="INSERT INTO student(fyear,
											fsubcode,
											fappno,
											fregno, 
											fname,
											fdob, 
											fgender, 
											fcatcode, 
											fnational, 
											fph, 
											fgoi, 
											fgis,
											fdomicile,
											fmotname, 
											ffatname,
											faddr1, faddr2, faddr3, faddr4, 
											faddp1, faddp2, faddp3, faddp4,
											fphone, 
											fmobile,faltmobile,
											femail, 
											fcollege, 
											funiversity, 
											fdoi, 
							 
											fmaxmarks1,
											fsecmarks1,fpercnt1, 
											fnoatt1, 
											fpassmth1, 
											fmaxmarks2, 
											fsecmarks2,fpercnt2, 
											fnoatt2, 
											fpassmth2,
											fmaxmarks3, 
											fsecmarks3,fpercnt3, 
											fnoatt3, 
											fpassmth3, 
											fmaxmarks4, 
											fsecmarks4,fpercnt4, 
											fnoatt4,
											fpassmth4, 
											fmaxmarks5, 
											fsecmarks5,fpercnt5,
											fnoatt5, 
											fpassmth5,fmaxtotal,fsecuretotal,fpercent,
											fchallanno, 
											fchallandate,
											fchallanamount, 
											fbank, 
											fbranch,
											flogdate
											 
											) 
											values(
											'{$year}',
											'{$subj_code}',
											'{$application_no}',
											'',
											'{$fname}',
											'{$fdate_of_birth}',
											'{$fgender}',
											'{$fcategory}',
											'{$fnationality}',
											'{$fph_disabled}',
											'{$fgoi_nominee}',
											'{$fgovt_service_candidate}',
											'{$fdomicile_state}',
											'{$fmother}',
											'{$ffather}',
											'{$per_addr_corsp1}','{$per_addr_corsp2}','{$per_addr_corsp3}','{$per_addr_corsp4}',
											'{$per_addrs1}','{$per_addrs2}','{$per_addrs3}','{$per_addrs4}',
											'{$fphoneno}',
											'{$fmobile}','{$faltmobile}',
											'{$femailid}',
											'{$fcollegecode}',
											'{$funiversity}',										
											'{$complt_internship_date}',
											
											'{$fmax_marks1}','{$fsecured_marks1}','{$fpercnt1}','{$fno_of_attempts1}','{$fpassed_month1}',
											'{$fmax_marks2}','{$fsecured_marks2}','{$fpercnt2}','{$fno_of_attempts2}','{$fpassed_month2}',
											'{$fmax_marks3}','{$fsecured_marks3}','{$fpercnt3}','{$fno_of_attempts3}','{$fpassed_month3}',
											'{$fmax_marks4}','{$fsecured_marks4}','{$fpercnt4}','{$fno_of_attempts4}','{$fpassed_month4}',
											'{$fmax_marks5}','{$fsecured_marks5}','{$fpercnt5}','{$fno_of_attempts5}','{$fpassed_month5}',
											'{$fmaxtot}','{$fsecuretot}','{$fpercnttot}',
											'{$fchallan_no}',  
											'{$fchallan_date}',
											'{$fchall_amount}',
											'{$fname_of_bank}',
											'{$fbranch_name_place}',
											'{$fdate_time}'
				
											) ";		
		 $lobj_sql_insert_query = $aobj_context->mobj_db->Execute($sql_insert_query);
		 $last_inserted_id = $aobj_context->mobj_db->Insert_ID();
    	$error_data=$lobj_sql_insert_query;

if($lobj_sql_insert_query)
		{	
			$applic_num_forwd=$lobj_sql_query_header[application_no];
		    if($student_entry_photo_path != "img/default_photo.jpg")
			{
		
			$ext_arr=explode(".",$student_entry_photo_path);
			$app_img=$application_no.".".array_pop($ext_arr);
			$src_path=$aobj_context->main_src."/".$student_entry_photo_path;
			$dest_path=$aobj_context->main_src."/student_photos/".$app_img;
			$image_path="student_photos/".$app_img;
			copy($src_path,$dest_path);
				$update="update student set photo_path='{$image_path}' 
							where fappno='{$application_no}' ";
					$up_obj=$aobj_context->mobj_db->Execute($update); 
			}
			
			
			$application_no=$lobj_sql_query_header[application_no]+1;
			$sql_update_query = "update control set fappno='{$application_no}'";
			$lobj_ssql_update_query = $aobj_context->mobj_db->Execute($sql_update_query);
			
		
		 	 
			if($lobj_ssql_update_query)
			{

echo $aobj_context->mobj_output->ToJSONEnvelope($applic_num_forwd,0,"success");
			}
			else
			echo $aobj_context->mobj_output->ToJSONEnvelope($error_data,-1,"Failure");
			
			
			
		}
		else
		{
		
		
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_data,-1,"Failure");
		
		}
		 
		 
		 
}

function validateApplicationFrprint($aobj_context)
{
		
		session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		
		$fappno=$aobj_context->mobj_data["fapplication_num"];
		$fdob=$aobj_context->mobj_data["date_of_birth"];
		
		$sql_query_header="select count(*) as appno_count from student where fappno = '{$fappno}' and fdob = '{$fdob}'";		
		$lobj_sql_query_header = $aobj_context->mobj_db->GetRow($sql_query_header); 
		$application_count=$lobj_sql_query_header[appno_count];
		$error_data="Invalid Application Number or Date Of Birth";
		if($application_count == 1)
		echo $aobj_context->mobj_output->ToJSONEnvelope($fappno,0,"success");
		else
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_data,-1,"Failure");

}

function loadCategryFeeDetails($aobj_context)
{
		
		session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		
		$categryCode=$aobj_context->mobj_data["categryCode"];
		
		$sql_query_header="select ffee from mascat where fcatcode = '{$categryCode}'";		
		$lobj_sql_query_header = $aobj_context->mobj_db->GetRow($sql_query_header); 
		$categry_fee=$lobj_sql_query_header[ffee];
		$error_data=$lobj_sql_insert_query;
		
		if($lobj_sql_query_header)
		echo $aobj_context->mobj_output->ToJSONEnvelope($categry_fee,0,"success");
		else
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_data,-1,"Failure");
}

function writeApplicationDetailsTopdf($aobj_context)
{
		//require('../tarka_pdf/fpdf.php');
		session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		PrintApplicationFormSBM($aobj_context);
		//formData("Bank Copy");
		$application_number=$aobj_context->mobj_data["application_number"];
		/*$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
		$main_src=$main_src_obj[1];
	
		
		$file_path="candidate_pdfs/application_form_".$application_number.".pdf";
		$root_pdf_file_download=$_SERVER["DOCUMENT_ROOT"]."/".$main_src.$file_path;
		*/

/* class PDF extends FPDF
{
//Page header
function Header()
{
   //Logo
    $this->Image('images/nium.jpg',10,7,23);
    //Arial bold 15
    $this->SetFont('Arial','B',15);
    $this->Cell(180,6,'NATIONAL INSTITUTE OF UNANI MEDICINE',0,1,'C');
    //Line break
	$this->SetFont('Times','B',9);
	$this->cell(180,6,"Kottigepalya, Magadi Main Road, Bangalore, Karnataka - 560 091","0",1,"C");
	//	$this->Cell(90);
	$this->SetFont('Arial','B',12);
	$this->Cell(180,6,'PGET 2016 - MD / MS (UNANI)',0,1,'C');
	$this->Cell(180,6,"APPLICATION FORM","0",1,"C");
	}

//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');
}
}
	/* $pdf=  new FPDF();
	$pdf->AliasNbPages();
	$pdf->AddPage();
	$pdf->SetMargins(10,5,10);
	$line_height=5;
	$width=96;
	$x_pos=2;
	if($pos==2)
	$x_pos=2+$width+2;
	if($pos==3)
	$x_pos=2+$width+2+$width+2;
	$jump_width=$width;
	if($pos==2)
	$jump_width=$width;
	else if($pos==3)
	$jump_width=$width;
	$pdf->SetX($x_pos);
	$old_y=$pdf->GetY();
	$pdf->SetFont('Times','B',9);
	$pdf->Cell($jump_width,$line_height,$FUNIVNAME,'0',1,'C');

$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,$s_state,'0',1,'C');

$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,"CHALLAN",'0',1,'C');	
	$pdf->SetFont('Times','BU',9);
	$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,$label,'0',1,'C');

$pdf->SetFont('Times','B',9);
	$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,"A/C NO:{$acc_no}",'0',1,'C');

$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,"{$bank_name}",'0',1,'C');	
	$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,"BRANCH CODE:{$branch_code} IFSC CODE:{$ifsc_code}",'0',1,'C');	
	$pdf->SetX($x_pos);
	$pdf->Cell($jump_width,$line_height,"BANK USE ONLY",'0',1,'C');	
			
	$td1_width=$jump_width*(0.30)-1;
	$td2_width=$jump_width-$td1_width-2;
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Bank",'1',0,'L');	
	$pdf->Cell($td2_width,$line_height,"{$bank_name}",'1',1,'L');	
		
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Branch Name",'1',0,'L');	
	$pdf->Cell($td2_width,$line_height,"",'1',1,'L');	
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Branch Code",'1',0,'L');	
	$pdf->Cell($td2_width,$line_height,"",'1',1,'L');
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Journal No",'1',0,'L');	
	$pdf->Cell($td2_width,$line_height,"",'1',1,'L');
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Date",'1',0,'L');	
	$pdf->Cell($td2_width,$line_height,"",'1',1,'L');	
			
	$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"Reference No: {$app_no}",'0',1,'L');	
	 
	$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"Applicant Name: {$student_name}",'0',1,'L');	
	 
	$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"Reg. No.: {$reg_no}",'0',1,'L');

$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"College / Degree: {$college_code} / {$degree}",'0',1,'L');	
	
	$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"Category / Fee Type: {$FCATEGORY} / {$FFEETYPE}",'0',1,'L');

$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"Fee: {$FTOTALFEE}/-",'0',1,'L');	
	
	$pdf->SetFont('Times','B',10);
	$pdf->SetX($x_pos+1);
	$in_words=getNumber($FTOTALFEE);
	$pdf->Cell($jump_width,$line_height,"Rupees {$in_words}",'0',1,'L');

$pdf->SetX($x_pos+1);
	$pdf->SetFont('Times','',8);
	$pdf->MultiCell($jump_width,$line_height,"PAID TO THE CREDIT OF {$cheque_favour} ",0,"L");

$pdf->SetX($x_pos+1);
	$pdf->SetFont('Times','B',10);
	$tdd1_width=$jump_width*(0.25)-1;
	$tdd2_width=($jump_width)*.25 ;
	$tdd3_width=($jump_width)*.25 ;
	$tdd4_width=($jump_width)*.25-1;
	$pdf->Cell($tdd1_width,$line_height,"Particulars",'1',0,'C');	
	$pdf->Cell($tdd2_width,$line_height,"Course Fee",'1',0,'C');	
	$pdf->Cell($tdd3_width,$line_height,"Bank Charges",'1',0,'C');
	$pdf->Cell($tdd4_width,$line_height,"Total",'1',1,'C');

$pdf->SetX($x_pos+1);
	$pdf->Cell($tdd1_width,$line_height,"Amount",'1',0,'C');	
	$pdf->Cell($tdd2_width,$line_height,"Rs {$FTOTALFEE}/-",'1',0,'C');	
	$pdf->Cell($tdd3_width,$line_height,"Rs {$bank_charge}/-",'1',0,'C');
	$total=($FTOTALFEE+$bank_charge);
	$pdf->Cell($tdd4_width,$line_height,"Rs {$total}/-",'1',1,'C');

$pdf->SetX($x_pos+1);
	$in_words=getNumber($total);
	$pdf->Cell($jump_width,$line_height,"Rupees {$in_words}",'0',1,'L');

$pdf->ln(3);
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Date",'0',0,'L');			 
	$pdf->Cell($td2_width,$line_height,"Signature of Remitter    ",'0',1,'R');

$pdf->ln(4);				
	$pdf->SetX($x_pos+1);
	$pdf->Cell($jump_width,$line_height,"Received Rupees",'0',1,'L');

$pdf->ln(6);
	$pdf->SetX($x_pos+1);
	$pdf->Cell($td1_width,$line_height,"Date & Seal",'0',0,'L');			 
	$pdf->Cell($td2_width,$line_height,"Signature of Receiver   ",'0',1,'R');

$pdf->SetFont('Times','',9);

$pdf->SetX($x_pos+1);
	$pdf->MultiCell($jump_width,$line_height,'1.  Accepted at all branches of SBM ',0,"L");

$pdf->SetX($x_pos+1);
	$pdf->MultiCell($jump_width,$line_height,'2. Collecting Branch has to enter Reference No: & Name of the candidate for this transaction in core banking system',0,"L");

$pdf->SetX($x_pos+1);
	
	$pdf->Cell($jump_width,$line_height,"3. Not Transferable",'0',1,'L');	
 
	$pdf->SetY($old_y);
	 
	$img_path=$aobj_context->main_src."img/logo.jpg";

$pdf=new PDF();
	$pdf->AliasNbPages();
	$pdf->AddPage();
	$pdf->SetMargins(10,5,10);		
	$sql_query_header="select fyear, fsubcode, fappno, fregno, fname, DATE_FORMAT(fdob,'%d/%m/%Y') as fdob, fgender, 
	fcatcode, fnational, fph, fgoi, fgis, fdomicile, fmotname, ffatname,
	faddr1, faddr2, faddr3, faddr4, faddp1, faddp2, faddp3, faddp4,
	fphone, fmobile, faltmobile, femail, fcollege, funiversity, DATE_FORMAT(fdoi,'%d/%m/%Y') as fdoi, fpercent, fmaxmarks1,
	fsecmarks1,fpercnt1, fnoatt1, fpassmth1, fmaxmarks2, fsecmarks2, fpercnt2, fnoatt2, fpassmth2, 
	fmaxmarks3, fsecmarks3, fpercnt3,fnoatt3, fpassmth3, case when fmaxmarks4 = 0 then '' else fmaxmarks4 end as fmaxmarks4 ,
	case when fsecmarks4 = 0 then '' else fsecmarks4 end as fsecmarks4 ,fpercnt4,case when fnoatt4 = 0 then '' else fnoatt4 end as fnoatt4 ,
	fpassmth4, case when fmaxmarks5 = 0 then '' else fmaxmarks5 end as fmaxmarks5 ,case when fsecmarks5 = 0 then '' else fsecmarks5 end as fsecmarks5 ,
	fpercnt5,case when fnoatt5 = 0 then '' else fnoatt5 end as fnoatt5 , fpassmth5, fchallanno, DATE_FORMAT(fchallandate,'%d/%m/%Y') as fchallandate,
	fchallanamount, fbank, fbranch, flogdate, flogip, photo_path,fmaxtotal,fsecuretotal from student where  fappno = '{$application_number}'";
		
	$lobj_sql_query_header = $aobj_context->mobj_db->GetRow($sql_query_header); 
	
	$fname=$lobj_sql_query_header[fname];
	$fdob=$lobj_sql_query_header[fdob];
	$fgender=$lobj_sql_query_header[fgender];
		
	$fcatcode=$lobj_sql_query_header[fcatcode];
	$fnational=$lobj_sql_query_header[fnational];
	$fph=$lobj_sql_query_header[fph];
	if($fph == 'T')
	$fph="Yes";
	else 
	$fph = 'No';
		
	$fgoi=$lobj_sql_query_header[fgoi];
	if($fgoi === 'T')
	$fgoi="Yes";
	else 
	$fgoi = 'No';
	
	$fgis=$lobj_sql_query_header[fgis]; 
	if($fgis === 'T')
	$fgis="Yes";
	else 
	$fgis = 'No';
		
	$fdomicile=$lobj_sql_query_header[fdomicile];
	$sql_query_domicile="select fstatename from masstate where fstatecode = '{$fdomicile}'";	
	$lobj_sql_query_domicile = $aobj_context->mobj_db->GetRow($sql_query_domicile); 	
	$fdomicile=$lobj_sql_query_domicile[fstatename];
	
	$fmotname=$lobj_sql_query_header[fmotname];
	$ffatname=$lobj_sql_query_header[ffatname];
	$faddr1=$lobj_sql_query_header[faddr1];
	$faddr2=$lobj_sql_query_header[faddr2];
	$faddr3=$lobj_sql_query_header[faddr3];
	$faddr4=$lobj_sql_query_header[faddr4];
	$faddp1=$lobj_sql_query_header[faddp1];
	$faddp2=$lobj_sql_query_header[faddp2];
	$faddp3=$lobj_sql_query_header[faddp3];
	$faddp4=$lobj_sql_query_header[faddp4];
	$fphone=$lobj_sql_query_header[fphone];
	$fmobile=$lobj_sql_query_header[fmobile];
	$faltmobile=$lobj_sql_query_header[faltmobile];
	$femail=$lobj_sql_query_header[femail];
	$fcollege=$lobj_sql_query_header[fcollege];
	$funiversity=$lobj_sql_query_header[funiversity];
	$fdoi=$lobj_sql_query_header[fdoi];
	$fpercent=$lobj_sql_query_header[fpercent];
	$fmaxmarks1=$lobj_sql_query_header[fmaxmarks1];
	$fsecmarks1=$lobj_sql_query_header[fsecmarks1];
	$fpercnt1=$lobj_sql_query_header[fpercnt1];
	$fnoatt1=$lobj_sql_query_header[fnoatt1];
	$fpassmth1=$lobj_sql_query_header[fpassmth1];
	$fmaxmarks2=$lobj_sql_query_header[fmaxmarks2];
	$fsecmarks2=$lobj_sql_query_header[fsecmarks2];
	$fpercnt2=$lobj_sql_query_header[fpercnt2];
	$fnoatt2=$lobj_sql_query_header[fnoatt2];
	$fpassmth2=$lobj_sql_query_header[fpassmth2];
	$fmaxmarks3=$lobj_sql_query_header[fmaxmarks3];
	$fsecmarks3=$lobj_sql_query_header[fsecmarks3];
	$fpercnt3=$lobj_sql_query_header[fpercnt3];
	$fnoatt3=$lobj_sql_query_header[fnoatt3];
	$fpassmth3=$lobj_sql_query_header[fpassmth3];
	$fmaxmarks4=$lobj_sql_query_header[fmaxmarks4];
	$fsecmarks4=$lobj_sql_query_header[fsecmarks4];
	$fpercnt4=$lobj_sql_query_header[fpercnt4];
	$fnoatt4=$lobj_sql_query_header[fnoatt4];
	$fpassmth4=$lobj_sql_query_header[fpassmth4];
	$fmaxmarks5=$lobj_sql_query_header[fmaxmarks5];
	$fsecmarks5=$lobj_sql_query_header[fsecmarks5];
	$fpercnt5=$lobj_sql_query_header[fpercnt5];
	$fnoatt5=$lobj_sql_query_header[fnoatt5];
	$fpassmth5=$lobj_sql_query_header[fpassmth5];
	$fchallanno=$lobj_sql_query_header[fchallanno];
	$fchallandate=$lobj_sql_query_header[fchallandate];
	$photo_path =$lobj_sql_query_header[photo_path];
	$maxtotal =$lobj_sql_query_header[fmaxtotal];
	$fsecuretotal =$lobj_sql_query_header[fsecuretotal];
	
	$fchallanamount=number_format($lobj_sql_query_header[fchallanamount]);
	$fbank=$lobj_sql_query_header[fbank];
	$fbranch=$lobj_sql_query_header[fbranch];
	$flogdate=$lobj_sql_query_header[flogdate];
	$flogip=$lobj_sql_query_header[flogip];

$pdf->SetFont('Arial','B',13);

if(!empty($photo_path) && file_exists($photo_path)) 
	{			
		$pdf->Image($photo_path,166,50,30);
	}	
	
//	$pdf->Cell(60);
	
	$pdf->SetFont('Times','B',12);
	$pdf->Cell(80,10,"Application No. : ".$application_number,0,0,'L');
	$pdf->Cell(50);
	$pdf->Cell(40,10,'Registration No. : __________',0,1,'L');

$pdf->SetFont('Arial','BU',14);
	$pdf->Cell(180,10,'Personal Details',0,1,'L');

$faddrs_corrp = $faddr1." ".$faddr2." ".$faddr3." ".$faddr4;
	   $faddrs_per = $faddp1." ".$faddp2." ".$faddp3." ".$faddp4;
	  
	$formDate=array($fname,$fdob,$fgender,$fcatcode,$fnational,$fph,$fgoi,$fgis,$fdomicile,$fmotname,$ffatname,$fmobile,$faltmobile,$fphone,$femail);
	$w=array(9,9,9,9,9,9,9,9,9,9,9,9,9,9,9);
	$formFields=array('01. Name','02. Date of Birth','03. Gender','04. Category','05. Nationality','06. Whether Physically Disabled','07. Whether GOI Nominee','08. Whether Govt.In-Service Candidate','09. Domicile State','10. Mothers Name','11. Fathers Name','12. Mobile No.','13. Alternate Mobile No.','14. Phone No.','15. Email ID');

$pdf->SetFont('Arial','',11);
	for($i=0;$i<count($formFields);$i++)
	{
	$pdf->Cell(80,$w[$i],$formFields[$i],0,0,'L');
	$pdf->Cell(10,$w[$i],":","0",0,"C");
	$pdf->Cell(80,$w[$i],$formDate[$i],0,1,'L');
	}

$pdf->Cell(80,8,'16. Address for Correspondence',0,0,'L');
	$pdf->cell(10,8,":","0",0,"C");
	$pdf->MultiCell(90,8,$faddrs_corrp,0,"L");
	$pdf->Ln(20);
	$pdf->Cell(80,8,'17. Permanent Address',0,0,'L');
	$pdf->cell(10,8,":","0",0,"C");
	$pdf->MultiCell(90,8,$faddrs_per,0,"L");
	
	$pdf->AddPage();
	
	$pdf->Ln(3);
	$pdf->SetFont('Arial','BU',14);
	$pdf->Cell(180,10,'Details of Qualifying Examination',0,1,'L');

$formFields2=array('18. College','19. University','20. Date of completion of Internship');
	$w=array(8,8,8,8);
	$formData2=array($fcollege,$funiversity,$fdoi,$fpercent);
	$pdf->SetFont('Arial','',11);
	for($j=0;$j<count($formFields2);$j++)
	{

$pdf->Cell(80,$w[$j],$formFields2[$j],0,0,'L');
		$pdf->Cell(10,$w[$j],":","0",0,"C");
		$pdf->Cell(80,$w[$j],$formData2[$j],0,1,'L');
	}

$header=array('Examination' ,'Maximum Marks' ,'Secured Marks' ,'Percentage','No of Attempts','Passed Month');

$pdf->SetFillColor(255);
    $pdf->SetLineWidth(.4);
    $pdf->SetFont('','B',10);

$w=array(35,35,35,35,35,35);

for($i=0;$i<count($header);$i++)
	$pdf->Cell($w[$i]-5,10,$header[$i],1,0,'C',true);

$pdf->Ln();
	$pdf->SetFillColor(224,235,255);
	$pdf->SetTextColor(0);
	$pdf->SetFont('','B',10);
	$fill=false;
		
		//foreach($lobj_rs as $key=>$row)
		//{
	$fexams=array("I","II","III","IV","V","Total");
	$fmaxmarks=array($fmaxmarks1,$fmaxmarks2,$fmaxmarks3,$fmaxmarks4,$fmaxmarks5,$maxtotal);
	$fsecmarks=array($fsecmarks1,$fsecmarks2,$fsecmarks3,$fsecmarks4,$fsecmarks5,$fsecuretotal);
	$fpermarks=array($fpercnt1,$fpercnt2,$fpercnt3,$fpercnt4,$fpercnt5,$fpercent);
	$fnoatts=array($fnoatt1,$fnoatt2,$fnoatt3,$fnoatt4,$fnoatt5,'');
	$fpassmths=array($fpassmth1,$fpassmth2,$fpassmth3,$fpassmth4,$fpassmth5,'');
	
			
	for($k=0;$k<6;$k++)
	{
	$pdf->Cell($w[0]-5,8, $fexams[$k],'1',0,'C',$fill);
	$pdf->Cell($w[1]-5,8,$fmaxmarks[$k],'1',0,'C',$fill);
	$pdf->Cell($w[2]-5,8,$fsecmarks[$k],'1',0,'C',$fill);
	$pdf->Cell($w[2]-5,8,$fpermarks[$k],'1',0,'C',$fill);
	$pdf->Cell($w[3]-5,8,$fnoatts[$k],'1',0,'C',$fill);
	$pdf->Cell($w[4]-5,8,$fpassmths[$k],'1',1,'C',$fill);
	//$fill=!$fill;
	}
	
	//}

//$pdf->Cell(array_sum($w),0,'','T');

$pdf->Ln(5);	
	$pdf->SetFont('Arial','BU',14);
	$pdf->Cell(180,10,'Fee Details',0,1,'L');
	$formFields3=array('21. Challan No','22. Date','23. Amount','24. Name of the Bank','25. Branch Name with Place');
	$formData3=array($fchallanno,$fchallandate,$fchallanamount,$fbank,$fbranch);
	$w=array(8,8,8,8,8);
	$pdf->SetFont('Arial','',11);
	for($j=0;$j<count($formFields3);$j++)
	{
		$pdf->Cell(80,$w[$j],$formFields3[$j],0,0,'L');
		$pdf->Cell(10,$w[$j],":","0",0,"C");
		$pdf->Cell(80,$w[$j],$formData3[$j],0,1,'L');
	}

$pdf->SetFont('Arial','BU',14);
	$pdf->Cell(180,10,'Declaration by the Applicant',0,1,'L');

$declarationTemp="I ______________________ ,Son / Daughter of _______________________ declare that all the statements given in this application form are true to the best of my knowledge. I understand that if any of the statements are found wrong my admission stands cancelled. If admitted, I will abide by the rules and regulations in force in NIUM and as amended from time to time and pay the prescribed fees.";
	$pdf->SetFont('Arial','',9);						 
	$pdf->MultiCell(0,5,$declarationTemp,0,'L');
	$pdf->Ln(5);	
	$pdf->SetFont('Arial','',11);
	$pdf->Cell(10,10,'Date :',0,0,'L');
	$pdf->Cell(2);
	$pdf->Cell(115,10,'-------------------------',0,0,'L');

$pdf->Cell(0,10,'---------------------------------------',0,0,'L');
	$pdf->Ln(10);						 
	$pdf->SetFont('Arial','',10);
	$pdf->Cell(10,10,'Place :',0,0,'L');
	$pdf->Cell(2);
	$pdf->Cell(120,10,'-------------------------',0,0,'L');

$pdf->Cell(0,10,'Signature of the Candidate',0,0,'L');
	$pdf->Ln(10);	
	$pdf->SetFont('Arial','',11);
	$pdf->Cell(10,10,'For Office Use : Date of receiving of application .................................... Fee Paid Rs ..........................',0,0,'L');
	$pdf->Ln(20);
	$pdf->Cell(85);
	$pdf->Cell(10,10,'Signature of receiving Clerk .....................................',0,0,'L');	
	$file_path="application_form_".$application_number.".pdf";
	$pdf->Output($file_path,'D'); */			
	/*$root_pdf_file_download=$aobj_context->main_src.$file_path;*/
	
}
function WriteRect($aobj_context)
{
	$pdf=  new FPDF();
	$query = "select FUNIVNAME as FUNIVNAME,
		faddress as state, pdf_logo_path From control";
		$result =$aobj_context->mobj_db->GetRow($query);
	
	
	$width=96;
	$pdf->Rect(2,5,$width,200);
	$pdf->Rect(2+$width+2,5,$width,200);
	$pdf->Rect(2+$width+$width+4,5,$width,200);
	if(!empty($pdf_logo_path))
	{
		$img_logo_path=$this->aobj_context->main_src.$this->pdf_logo_path;
		$pdf->Image($img_logo_path,4,7,15);
		$pdf->Image($img_logo_path,$width+6,7,15);
		$pdf->Image($img_logo_path,$width+$width+7,7,15);
	}
		$pdf->setY(5);
}

function formData($label)
{
	$pdf=  new FPDF();
	$pdf->AliasNbPages();
	$pdf->AddPage();
	$pdf->SetMargins(10,5,10);
	$line_height=5;
	$width=96;
	$x_pos=2;
	if($pos==2)
	$x_pos=2+$width+2;
	if($pos==3)
	$x_pos=2+$width+2+$width+2;
	$jump_width=$width;
	if($pos==2)
	$jump_width=$width;
	else if($pos==3)
	$jump_width=$width;
	$pdf->SetX($x_pos);
	$old_y=$pdf->GetY();
	$pdf->SetFont('Times','B',9);
	$pdf->Cell($jump_width,$line_height,$FUNIVNAME,'0',1,'C');