Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adm_nationality_doc.php	1.52 KB	-rw-rw-r--
applicationfromreport.php	35.52 KB	-rwxr-xr-x
applicationfromreport_old.php	18.42 KB	-rwxr-xr-x
applicationreport.php	37.6 KB	-rwxr-xr-x
candidate_certificate.php	16.11 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
pending_certificate.php	11.96 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	41.2 KB	-rwxr-xr-x
student_19082019.php	25.39 KB	-rwxr-xr-x
student_old.php	23.37 KB	-rwxr-xr-x

Code Editor : applicationfromreport_old.php

<?php
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
$pdf_writer_class =$main_src."/tcpdf/tcpdf.php";
//$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
include_once("stringspliter.php");
require_once($pdf_writer_class);
	
class applicationReport  extends TCPDF
{	
	function DefaultConstructor($aobj_context)
	{
		$this->aobj_context=$aobj_context;
		$this->pdf=  new TCPDF();
		$pdf = $this->pdf;
		$this->pdf=$this;
		$this->app_no=trim($this->aobj_context->mobj_data["app_no"]);
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$get_date="select date_format(now(),'%d/%m/%y') as now_date";
		$obj=$this->aobj_context->mobj_db->GetRow($get_date);
		$this->current_date=$obj[now_date];			
	}

$lobj_get_data=$this->aobj_context->mobj_db->GetRow($get_data);
			
		$this->fcollcode=$lobj_get_data['fcollcode'];
		$this->fname=$lobj_get_data['fname'];
		$this->ffatname=$lobj_get_data['ffatname'];
		$this->ffat_occ=$lobj_get_data['ffat_occ'];
		$this->fmotname=$lobj_get_data['fmotname'];
		$this->fmot_occ=$lobj_get_data['fmot_occ'];
		$this->femail=$lobj_get_data['femail'];
		$this->fdob=$lobj_get_data['fdob'];
		$this->fsex=$lobj_get_data['fsex'];
		$this->fcaste=$lobj_get_data['fcaste'];
		$this->FSTATE=$lobj_get_data['FSTATE'];
		$this->fcontact_no=$lobj_get_data['FCONTACT_NO'];
		$this->fnational=$lobj_get_data['FNATIONAL'];
		$this->fenglish=$lobj_get_data['FENGLISH'];
		$this->fcurradd1=$lobj_get_data['FCURRADD1'];
		$this->fcurradd2=$lobj_get_data['FCURRADD2'];
		$this->fcurradd3=$lobj_get_data['FCURRADD3'];
		$this->fcurradd4=$lobj_get_data['FCURRADD4'];
		$this->fpermadd1=$lobj_get_data['FPERMADD1'];
		$this->fpermadd2=$lobj_get_data['FPERMADD2'];
		$this->fpermadd3=$lobj_get_data['FPERMADD3'];
		$this->fpermadd4=$lobj_get_data['FPERMADD4'];
		$this->fphotopath=$lobj_get_data['FPHOTOPATH'];
		$this->fdegree=$lobj_get_data['FDEGREE'];
		$this->fdescpn=$lobj_get_data['FDESCPN'];
		$this->subjdet=$lobj_get_data['subjdet'];
		$this->fexamno=$lobj_get_data['FEXAMNO'];
		$this->freligion=$lobj_get_data['FRELIGION'];//FRELIGION
		$this->fblood_group=$lobj_get_data['FBLOOD_GROUP'];
		$this->fcollname=$lobj_get_data['FCOLLNAME'];
		$this->FFEEDET=$lobj_get_data['FFEEDET'];
		$this->FHONOUR=$lobj_get_data['FHONOUR'];	
		$this->FQUALUNIV=$lobj_get_data['FQUALUNIV'];
		$this->FQUALDEG=$lobj_get_data['FQUALDEG'];
		$this->FQUALYEAR=$lobj_get_data['FQUALYEAR'];
		$this->FQUALREG=$lobj_get_data['FQUALREG'];
		$this->FQUALPR=$lobj_get_data['FQUALPR'];
		$this->FQUALCLASS=$lobj_get_data['FQUALCLASS'];
		$this->FDDAMT=$lobj_get_data['FDDAMT'];
		$this->FDDDATE=$lobj_get_data['FDDDATE'];
		$this->FDDBANK=$lobj_get_data['FDDBANK'];
		$this->FDDBRANCH=$lobj_get_data['FDDBRANCH'];
		$this->FREGNNO=$lobj_get_data['FREGNNO'];	
		$this->FQUALINS=$lobj_get_data['FQUALINS']; 
		$this->fregno=$lobj_get_data['fregno'];
	}
	
	function GetDateFormat($date)
	{
		$valid_date=$date;
		if($date=="00/00/0000")
		$valid_date="";
		return $valid_date;
	}
	function formData()
	{
		$llineht = 5;
		$imght = 24;
		if($this->fdegree == 'BPH14' || $this->fdegree == 'BHT14' || $this->fdegree == 'MPH14' || $this->fdegree == 'MBA14')
		{
			$llineht = 4;
			$imght = 22;
		}
	
		for($i=0;$i<3;$i++)
		{
			if($i == 0)
			{
				$copy = "Student Copy";
			}
			else if($i == 1)
			{
				$copy = "College / Department Copy";
			}
			else if($i == 2)
			{
				$copy = "Examination Copy";
			}
			
			$font = 12;
			$this->pdf->SetMargins(9,5,9);		
			$this->pdf->AddPage();
			$this->Rect(5,3,200,290);
			
			$this->pdf->SetMargins(13,170);
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->Ln(12);
			$this->pdf->Cell(0,4,"STUDENT REGISTRATION APPLICATION 2016","0",0,"C");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(0,4,$copy,"0",1,"R");
			$this->pdf->SetFont('Times','',8);
			$this->pdf->Ln(1);

//Personal Details 
			$this->pdf->SetFont('Times','B',$font);
			$this->pdf->cell(80,$llineht,"A. Personal Details ","0",0,"L");

$this->pdf->SetFont('Times','B',12);			
			$this->pdf->cell(103,$llineht,"Application No."." : ".$this->app_no,"0",1,"R");

$this->pdf->SetFont('Times','',10);

$this->pdf->Ln(2);
						
			$collname = $this->fcollname.' - '.$this->fcollcode;
			$collnamearr = str_splitf($collname,49);
			$this->pdf->cell(86,$llineht,"Name of Affiliated College OR  ","LRT",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(77,$llineht,$collnamearr[0],"LRT",1,L);
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(86,$llineht,"S.U Department Currently Admitted Into (Admission 2016)","LRB",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(77,$llineht,$collnamearr[1],"LRB",1,L);
			
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(80,$llineht,"Roll Number of Current Admission(Admission 2016)","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(83,$llineht,$this->fregno,"1",1,"L");
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(80,$llineht,"Name in full (as per Higher Secondary Certificate)","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(83,$llineht,$this->fname,"1",1,"L");
			$img_path = $this->aobj_context->main_src.$this->fphotopath;
			
			if(!empty($this->fphotopath) && file_exists($img_path)) 
			{		
				$this->pdf->Image($img_path,176.5,29,19.5,$imght);
			}
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(80,$llineht,"Mother Name","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(83,$llineht,$this->fmotname,"1",1,"L");
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(80,$llineht,"Father Name ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->ffatname,"1",1,"L");

$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(80,$llineht,"Date of Birth (as per Higher Secondary Certificate)","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->fdob,"1",1,"L");
			
			if($this->fsex == 'M')
				$gender = 'Male';
			else
				$gender = 'Female';
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"Gender ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(40,$llineht,$gender,"1",0,"L");
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"Blood_Group","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(63,$llineht,$this->fblood_group,"1",1,"L");
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"Nationality ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(40,$llineht,$this->fnational,"1",0,"L");
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"State of Residence.","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(63,$llineht,$this->FSTATE,"1",1,"L");
						
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(80,$llineht,"Category ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->fcaste,"1",1,"L");
			
			$this->pdf->SetFont('Times','',10);
			$address = $this->fcurradd1 .' '.$this->fcurradd2 .' '.$this->fcurradd3 .' '.$this->fcurradd4;
			$addressarr = str_splitf($address,60);
			$this->pdf->cell(80,$llineht,"Address of Correspondence","LRT",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$addressarr[0],"LRT",1,L);
			
			if(trim($addressarr[1]) !='')
			{	
				$this->pdf->cell(80,$llineht,"","LRB",0,"L");
				$this->pdf->SetFont('Times','B',10);
				$this->pdf->cell(103,$llineht,$addressarr[1],"LRB",1,L);
			}
			$peraddr = $this->fpermadd1 .' '.$this->fpermadd2 .' '.$this->fpermadd3 .' '.$this->fpermadd4;
			$peraddrarr = str_splitf($peraddr,60);
			$this->pdf->SetFont('Times','',10);					
			$this->pdf->cell(80,$llineht,"Permanent Address","LRT",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$peraddrarr[0],"LRT",1,"L");
			if(trim($peraddrarr[1]) !='')
			{	
				$this->pdf->cell(80,$llineht,"","LRB",0,"L");
				$this->pdf->SetFont('Times','B',10);
				$this->pdf->cell(103,$llineht,$peraddrarr[1],"LRB",1,L);
			}
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"Contact No.","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(40,$llineht,$this->fcontact_no,"1",0,"L");
			$this->pdf->SetFont('Times','',10);
			//$this->pdf->cell(10,5,"7","1",0,"L");
			$this->pdf->cell(35,$llineht,"Email Id ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(68,$llineht,$this->femail,"1",1,"L");
			//$this->FROLLNO
			
			$this->pdf->Ln(2);
			$this->pdf->SetFont('Times','B',$font);
			$this->pdf->cell(36,$llineht,"B. Course and Subject Details (admitted into)","0",1,"L");
			
			$this->pdf->SetFont('Times','',10);
			//$this->pdf->cell(10,5,"10","1",0,"L");
			$this->pdf->cell(80,$llineht,"Course/Programme","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->fdescpn,"1",1,"L");
			$this->pdf->SetFont('Times','',10);
			//Honours Subject enrolled into (only for BA, BSC & M.Pharm)
			
			$this->pdf->SetFont('Times','B',10);
			//$this->pdf->cell(10,5,"10","1",0,"L");
			$this->pdf->cell(25,$llineht,"Subject Code","1",0,"L");
			$this->pdf->cell(135,$llineht,"Subject Name","1",0,"L");
			$this->pdf->cell(23,$llineht,"Honours ","1",1,"L");
			$this->subcode = explode('~',$this->subjdet);
			//var_dump(count($this->subcode));
			$query = "Select DISTINCT fsubshort from subject where fdegree = '{$this->fdegree}' and fexamno = 'A' and fsubcode = '{$this->FHONOUR}'";
			$result = $this->aobj_context->mobj_db->GetRow($query);
			
			foreach($this->subcode as  $key=>$value)
			{
				$this->pdf->SetFont('Times','',10);
				$this->subname = explode('->',$value);
				/* if($i == count($this->subcode))
					$this->pdf->cell(28,5," ","LB",0,"L");
				else
					$this->pdf->cell(28,5," ","LR",0,"L"); */
				$this->pdf->cell(25,$llineht, $this->subname[0],"1",0,"L");
				$this->pdf->cell(135,$llineht, $this->subname[1],"1",0,"L");
				if($this->fdegree == 'BA14' || $this->fdegree == 'BSC14' )
				{
					if($result['fsubshort'] == $this->subname[0])
						$this->pdf->cell(23,$llineht,"Yes","1",1,"L");
					else
						$this->pdf->cell(23,$llineht,'',"1",1,"L");
				}else
					$this->pdf->cell(23,$llineht,'NA',"1",1,"L");
				
			}
		
			$this->pdf->Ln(2);
			$this->pdf->SetFont('Times','B',$font);
			$this->pdf->cell(36,$llineht,"C. Details of Qualifying Examination passed","0",1,"L");
			$this->pdf->SetFont('Times','',10); 
			//Last Examination Passed
			$this->pdf->cell(80,$llineht,"Last Examination Passed","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->FQUALDEG,"1",1,"L");
			$this->pdf->SetFont('Times','',10); 
			$this->pdf->cell(80,$llineht,"Board / University under which Examination was held","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->FQUALUNIV,"1",1,"L");
			 
			$this->pdf->SetFont('Times','',10); 
			$this->pdf->cell(80,$llineht,"Institution of Last Examination","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(103,$llineht,$this->FQUALINS,"1",1,"L");

$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"Year ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(40,$llineht,$this->FQUALYEAR,"1",0,"L");

$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(40,$llineht,"Roll No.","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(63,$llineht,$this->FQUALREG,"1",1,"L");

$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(60,$llineht,"Percentage of Aggregate Marks","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(20,$llineht,$this->FQUALPR,"1",0,"L");
			
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(63,$llineht,"Division / Class / Grade / CGPA obtained ","1",0,"L");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(40,$llineht,$this->FQUALCLASS,"1",1,"L");	
			
			if(!empty($this->FREGNNO))
			{
				$this->pdf->Ln(2);
				$this->pdf->SetFont('Times','B',11);
				$this->pdf->cell(150,$llineht,"D. Sikkim University Registration No. (mandatory if institution last attended is under Sikkim University)","0",1,"L");
				$this->pdf->SetFont('Times','',10);
				$this->pdf->cell(130,$llineht,"Sikkim University Registration number allotted: ","1",0,"L");
				$this->pdf->SetFont('Times','B',10);
				$this->pdf->cell(53,$llineht,$this->FREGNNO,"1",1,"L");
			}
			else
			{
				$this->pdf->Ln(2);
				$this->pdf->SetFont('Times','B',11);
				$this->pdf->cell(150,$llineht,"D. Sikkim University Registration No. (mandatory if institution last attended is under Sikkim University)","0",1,"L");
				$this->pdf->SetFont('Times','',10);
				$this->pdf->cell(130,$llineht,"Sikkim University Registration number allotted: NOT APPLICABLE","1",0,"L");
				$this->pdf->SetFont('Times','B',10);
				$this->pdf->cell(53,$llineht,$this->FREGNNO,"1",1,"L");
			}
			
			$this->pdf->Ln(2);
			$this->pdf->SetFont('Times','B',$font);
			$this->pdf->cell(80,$llineht,"E. Check list of Supporting Documents (to be submitted with print out of this form)","0",1,"L");
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(155,$llineht,"Self attested copy of Qualifying Exam Mark Sheet (Mandatory)","1",0,"L");
			$this->pdf->cell(28,$llineht," ","1",1,"L");
			$this->pdf->cell(155,$llineht,"Self attested copy of Class X Mark Sheet/Pass Certificate/Admit Card for Age Proof (Mandatory)","1",0,"L");
			$this->pdf->cell(28,$llineht," ","1",1,"L");
			//$this->pdf->cell(140,5,"Fee Bank Draft (Mandatory)","1",0,"L");
			//$this->pdf->cell(35,5," ","1",1,"L");
			$this->pdf->cell(155,$llineht,"Self attested copy of Caste Certificate (Mandatory for SC/ST/OBC candidates)","1",0,"L");
			$this->pdf->cell(28,$llineht," ","1",1,"L");
			$this->pdf->cell(155,$llineht,"Migration Certificate in Original (Mandatory if institution last attended is not under Sikkim University)","1",0,"L");
			$this->pdf->cell(28,$llineht," ","1",1,"L");
			$this->pdf->Ln(2);
			$this->pdf->cell(80,$llineht,"Date  :",'',1,"L");
			$this->pdf->cell(80,$llineht,"Place :",'',1,"L");
			$this->pdf->SetFont('Times','',11);
			$this->pdf->cell(183,$llineht,"Student Signature",'',1,"R");
			
			//$this->pdf->Ln(1);
			$this->pdf->SetFont('Times','B',$font);
			$this->pdf->cell(183,$llineht,"For College / Department use only","1",1,"L");
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(90,$llineht,"Application & Supporting Documents Verified By ","LR",0,"L");
			$this->pdf->cell(93,$llineht," ","LR",1,"L");
			$this->pdf->cell(90,$llineht,"Head of Dept. Name","LR",0,"L");
			
			if(substr($this->fcollcode,0,1) == 'P')
			{
				$this->pdf->cell(93,$llineht,"","LR",1,"L");
				$this->pdf->cell(90,$llineht,"Head of Dept. Signature:","LR",0,"L");
			}
			else
			{
				$this->pdf->cell(93,$llineht,"Principal’s Signature:","LR",1,"L");
				$this->pdf->cell(90,$llineht," ","LR",0,"L");
			}
			$this->pdf->cell(93,$llineht," ","LR",1,"L");
			$this->pdf->cell(90,$llineht,"","LR",0,"L");
			if(substr($this->fcollcode,0,1) == 'P')
			{
				$this->pdf->cell(93,$llineht,"","LR",1,"L");
				$this->pdf->cell(90,$llineht,"Seal","LR",0,"L");
				$this->pdf->cell(93,$llineht," ","LR",1,"L");
			}
			else
			{
				$this->pdf->cell(93,$llineht,"Date","LR",1,"L");
				$this->pdf->cell(90,$llineht,"Signature","LR",0,"L");
				$this->pdf->cell(93,$llineht,"Seal","LR",1,"L");
			}
			$this->pdf->cell(90,$llineht,"Date","LBR",0,"L");
			$this->pdf->cell(93,$llineht,"","LBR",1,"L");	
		}
	}
	
	function SendOutput()
	{
		$this->pdf->Output("application_letter_{$this->app_no}.pdf","D");
	}	
}

function GenerateApplicationFormPdfReport($aobj_context)
{	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj=new applicationReport();
	$class_obj->DefaultConstructor($aobj_context);
	$class_obj->formquery();
	$class_obj->formData();
	$class_obj->SendOutput();
} 
?>

${this.title}

Code Editor : applicationfromreport_old.php