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.php

<?php

require_once(__DIR__."/../../../aws/aws-autoloader.php");
use Aws\S3\S3Client;
use Aws\S3\Exception\S3Exception;

$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 FPDF();
		 $pdf= new TCPDF();
		$this->pdf=$this;
		$this->app_no=trim($this->aobj_context->mobj_data["app_no"]);
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$get_date="select date_add(date_add(now(),INTERVAL 13 hour),interval 30 minute) as now_date";
		$obj=$this->aobj_context->mobj_db->GetRow($get_date);
		require_once("getnumword.php");
		$this->current_date=$obj[now_date];	
		$this->pdf = new TCPDF();	 */
		
		$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);
		require_once("getnumword.php");
		$this->current_date=$obj[now_date];	
	}
 	
	 function formcolldatachallan()
	 {
		$get_coll_name="select FUNIVNAME as 'FUNIVNAME',
				FUNIVADD1 as 'state', pdf_logo_path,ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";
		$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		$this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
		$this->s_state=$lobj_get_coll_name['state'];
		$this->f_year=$lobj_get_coll_name['f_year'];
		$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];
		$this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ'];
			
		
	 }
	
	 function GetBankDetailschallan()
	 {
		$get_data="SELECT  bank_name, acc_no, 	branch_name, 	branch_code, 	ifsc_code, 	cheque_favour, 	place,bank_charge
				FROM  acc_mas where payment_type='{$this->FPAYMENTYPE}'";
		//var_dump($get_data);		
		$lobj_get_data= $this->aobj_context->mobj_db->GetRow($get_data);	
		$this->bank_name=$lobj_get_data['bank_name'];	
		$this->acc_no=$lobj_get_data['acc_no'];	
		$this->branch_name=$lobj_get_data['branch_name'];	
		$this->branch_code=$lobj_get_data['branch_code'];	
		$this->ifsc_code=$lobj_get_data['ifsc_code'];	
		$this->cheque_favour=$lobj_get_data['cheque_favour'];	
		$this->place=$lobj_get_data['place'];	
		$this->bank_charge=$lobj_get_data['bank_charge'];	
	 }
	 
	 function GetDatachallan()
	 {
		 $get_app_no =" select FAMOUNT,FPAYMENTTYPE,FDEGREE,FCOLLCODE,FROLLNO AS FREGNO,FNAME,
							date_format(current_date,'%d/%m/%Y') as curr_date
							 from studadm
							 where FAPPNO='{$this->app_no}'";
							 //var_dump($get_app_no);
			$obj_get_app_no=$this->aobj_context->mobj_db->GetRow($get_app_no); 	
			$this->reg_no=$obj_get_app_no['FREGNO'];
			$this->FRECPTDATE=$obj_get_app_no['FRECPTDATE'];
			$this->FTOTALFEE=$obj_get_app_no['FAMOUNT'];
			$this->FPAYMENTYPE=$obj_get_app_no['FPAYMENTTYPE'];
			/* $this->FCATEGORY=$obj_get_app_no['FCATEGORY'];
			$this->FFEETYPE=$obj_get_app_no['FFEETYPE']; */
			
		 /* 	$get_other_details="select 	date_format(current_date,'%d/%m/%Y') as curr_date,FDEGREE,FCOLLCODE,FNAME,CONCAT(IFNULL(FCURRADD1,''),' ',FCURRADD2) AS s_address from student where   FREGNO='{$this->reg_no}' ";	 
			$lobj_get_name = $this->aobj_context->mobj_db->GetRow($get_other_details);
			  */
			$this->college_code=$obj_get_app_no['FCOLLCODE'];
			$this->degree=$obj_get_app_no['FDEGREE'];
			$this->student_name=$obj_get_app_no['FNAME'];
			$this->curr_date=$obj_get_app_no['curr_date'];
			  
			/* $get_exam_details="SELECT GROUP_CONCAT(DISTINCT FEXAMNO) AS FEXAMNO 
							FROM appcanddet WHERE APPNO='{$this->app_no}'";
			$lobj_get_exam_details= $this->aobj_context->mobj_db->GetRow($get_exam_details);
			$this->FEXAMNO=	$lobj_get_exam_details['FEXAMNO']; */
			$this->GetBankDetailschallan();
	 }
		function WriteRectchallan()
		{
		//	$this->pdf = new FPDF('L');
			$this->pdf= new TCPDF('L');			
			$this->pdf->SetMargins(0,2,2);			
			$this->pdf->addPage();	
			
			$width=96;
			$this->pdf->Rect(2,5,$width,200);
			$this->pdf->Rect(2+$width+2,5,$width,200);
			$this->pdf->Rect(2+$width+$width+4,5,$width,200);
			if(!empty($this->pdf_logo_path))
			{
			$img_logo_path=$this->aobj_context->main_src.$this->pdf_logo_path;
			$this->pdf->Image($img_logo_path,4,7,15);
			$this->pdf->Image($img_logo_path,$width+6,7,15);
			$this->pdf->Image($img_logo_path,$width+$width+7,7,15);
			}
			
			$this->pdf->setY(5);
		}	
			
		function formDatachallan($label)
		{
			$line_height=4;
			$width=96;
			$x_pos=2;
			if($this->pos==2)
			$x_pos=2+$width+2;
			if($this->pos==3)
			$x_pos=2+$width+2+$width+2;
			$jump_width=$width;
			if($this->pos==2)
			$jump_width=$width;
			else if($this->pos==3)
			$jump_width=$width;
			$this->pdf->SetX($x_pos);
			$this->old_y=$this->pdf->GetY(); $this->pdf->SetFont('Times','BU',9);
			$this->pdf->Cell($jump_width,$line_height,"REGISTRATION APPLICATION FORM - 2024",'0',1,'C');	
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->SetX($x_pos);
		 
			$this->pdf->Cell($jump_width,$line_height,$this->FUNIVNAME,'0',1,'C');	
			
			$this->pdf->SetX($x_pos);
			$this->pdf->Cell($jump_width,$line_height,$this->s_state,'0',1,'C');	
			$this->pdf->SetFont('Times','BU',9);
			$this->pdf->SetX($x_pos);
			$this->pdf->Cell($jump_width,$line_height,$label,'0',1,'C');	
				$this->pdf->SetFont('Times','B',9);
			
			$this->pdf->SetX($x_pos);
			$this->pdf->Cell($jump_width,$line_height,"From Bank____________________Branch______________________",'0',1,'C');	
			
			$this->pdf->SetX($x_pos);
			$this->pdf->Cell($jump_width,$line_height,"  Date_____________________",'0',1,'L');	
		 
			$td1_width=$jump_width*(0.50)-1;
			$td2_width=$jump_width-$td1_width-2;
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width+$td2_width,$line_height-1,"Details of Applicant Remitter",'1',1,'C');	
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Reference/Applcation No",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->app_no}",'1',1,'L');	
			$this->pdf->SetFont('Times','B',10);
			
			$student_name = $this->student_name;
			$studentname = str_splitf($this->student_name,25);
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Name",'LRT',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,$studentname[0],'LRT',1,'L');	
			if($studentname[1] != '')
			{
				$this->pdf->SetX($x_pos+1);
				$this->pdf->Cell($td1_width,10," ",'LRB',0,'L');	
				$this->pdf->Cell($td2_width,$line_height,$studentname[1],'LRB',1,'L');
			}
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Roll. No",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->reg_no}",'1',1,'L');
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"College/Dept./Degree ",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->college_code} / {$this->degree}",'1',1,'L');
			/* $this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Category / Fee Type",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->FCATEGORY} / {$this->FFEETYPE}",'1',1,'L'); */
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Account No. (if applicable)",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"",'1',1,'L');	
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Cheque Details(if applicable)",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"",'1',1,'L');	
			
			$this->pdf->ln(2);
				$td1_width=$jump_width*(0.40)-1;
			$td2_width=$jump_width-$td1_width-2;
				$this->pdf->SetX($x_pos+1);
			$nb =0;
			$nb=max($nb,NbLines($td1_width,$this->cheque_favour,''));
			$yH = $line_height*$nb;
					
			$this->pdf->Cell($td1_width+$td2_width,$line_height,"Details of Beneficiary",'1',1,'C');	
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Beneficary's Name",'1',0,'L');	
			$this->pdf->MultiCell($td2_width,$line_height,"{$this->cheque_favour}",1,'L');
			
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Beneficary's A/C No.",'LRT',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->acc_no}",'LRT',1,'L');
			$line_height  = 1;
			/* $this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,2,"A/C No",'LRB',0,'L');	
			$this->pdf->Cell($td2_width,2,"",'LRB',1,'L'); */
			$line_height  = 4;
			$this->pdf->SetX($x_pos+1);
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->Cell($td1_width,$line_height,"Center",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->place}",'1',1,'L');	
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"Bank/Branch",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->bank_name} / {$this->branch_name}",'1',1,'L');
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($td1_width,$line_height,"IFSC Code",'1',0,'L');	
			$this->pdf->Cell($td2_width,$line_height,"{$this->ifsc_code}",'1',1,'L');
				
			 
					$this->pdf->SetFont('Times','B',10);
			$this->pdf->SetX($x_pos);
			$this->pdf->Cell($jump_width,$line_height," Amount To Be Remitted Rs {$this->FTOTALFEE}/-",'0',1,'L');	
			$this->pdf->SetX($x_pos);
			$in_words=getNumber($this->FTOTALFEE);
			$this->pdf->Cell($jump_width,$line_height," Rupees {$in_words}",'0',1,'L');	
			$this->pdf->SetFont('Times','',10);
		 				
			$this->pdf->SetX($x_pos+1);
			$this->pdf->MultiCell($jump_width,$line_height,'1. Amount to be remitted as per details enumerated above',0,"L");
			 		
			$this->pdf->SetX($x_pos+1);
			$this->pdf->MultiCell($jump_width,$line_height,'2. Not Transferable',0,"L");
			
			/* $this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($jump_width,$line_height,"3. Not Transferable",'0',1,'L');	 */
			$this->pdf->ln(3);
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->SetX($x_pos);
			$this->pdf->Cell($jump_width,$line_height,"Applicant's Signature  ",'0',1,'R');	
				$this->pdf->ln(3);
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($jump_width-2.5,$line_height,"Payment particulars- Cash/Transfer             Date:",'1',1,'L');	
	 
			$this->pdf->SetX($x_pos+1);
			 $tdd1_width=$jump_width*(0.25);
			$tdd2_width=($jump_width)*.25 ;
			$tdd3_width=($jump_width-$tdd2_width)*.60+2;
			$this->pdf->Cell($tdd1_width,$line_height,"",'L',0,'L');	
			$this->pdf->Cell($tdd2_width,$line_height,"",'R',0,'L');	
			$this->pdf->Cell($tdd3_width,$line_height," ",'R',1,'L');
			
			/* $this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($tdd1_width,$line_height,"Bank Charges",'1',0,'L');	
			$this->pdf->Cell($tdd2_width,$line_height,"Rs  {$this->bank_charge}/-",'1',0,'L');	
			$this->pdf->Cell($tdd3_width,$line_height," ",'R',1,'L');
			*/
			$this->pdf->SetX($x_pos+1); 
			//$total=($this->FTOTALFEE+$this->bank_charge);
			$total=$this->FTOTALFEE;
			$this->pdf->Cell($tdd1_width,$line_height,"Total Amount",'1',0,'L');	
			$this->pdf->Cell($tdd2_width,$line_height,"Rs {$total}/-",'1',0,'L');	
			$this->pdf->Cell($tdd3_width,$line_height,"Seal & Signature ",'BR',1,'C');
			$this->pdf->ln(2);
			$this->pdf->SetX($x_pos+1);
			$in_words=getNumber($total);
			$this->pdf->Cell($jump_width,$line_height,"Rupees {$in_words}",'0',1,'L');	
			$this->pdf->SetX($x_pos+1);
			$this->pdf->SetFont('Times','',10);
			$this->pdf->Cell($jump_width,$line_height,"Cash Received/Debited Applicants A/C",'0',1,'L');	
		
			$this->pdf->ln(2);
				$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($tdd1_width,$line_height,"Remitance/",'LRT',0,'L');	
			$this->pdf->Cell($tdd2_width+10,$line_height," ",'LRT',1,'L');	
			$this->pdf->SetX($x_pos+1);
			$this->pdf->Cell($tdd1_width,$line_height,"UTR Number",'LRB',0,'L');	
			$this->pdf->Cell($tdd1_width+10,$line_height," ",'LRB',0,'L');	
			$this->pdf->Cell($tdd1_width+10,$line_height,"      Authorised Signatory",'0',1,'L');	
			 
			
			$this->pdf->SetY($this->old_y);
		 
			$img_path=$this->aobj_context->main_src.$this->photo_path;
		}

/* 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];			
	} */

/* function Header()
	{
		//$this->pdf->AddPage('P');
		$sql = "select FUNIVNAME,pdf_logo_path,FUNIVADD1 from control";
		$temres=$this->aobj_context->mobj_db->GetRow($sql);
		$pdf_logo_path = $this->aobj_context->main_src."/".$temres['pdf_logo_path'];
		$this->pdf->Ln(4);
		$this->pdf->SetFont('Courier','B',15);	
		$this->pdf->Cell(0,4,$temres['FUNIVNAME'],0,1,'C'); 
		$this->pdf->SetFont('Courier','',9);	
		$this->pdf->Cell(0,3,$temres['FUNIVADD1'],0,1,'C');

if(file_exists($pdf_logo_path)) 
		{
			$this->pdf->Image($pdf_logo_path,15,5,20);	
		}
	}	 */
	
	function Footer()
	{
		 
	/* 	$this->SetY(-30);
		$new_yl=$this->pdf->GetY();
		$this->pdf->Line(10,$new_yl, 200,$new_yl);
		$this->pdf->Line(10,$new_yl+.5, 200,$new_yl+.5); */
		/* $this->Ln(1);
		$this->pdf->SetFont('Times','B',8);
		$this->Cell(120,4,'','0',0,'L');
		$this->Cell(50,4,'',0,1,'R');
		$this->Cell(120,4,' IP Address : '.$this->ip."    Date ".$this->current_date,'0',0,'L'); */
 
	}
	
	function formquery()
	{
		$get_data = "SELECT  DISTINCT studadm.FSLNO,studadm.FRELIGION,studadm.FBLOOD_GROUP, studadm.fcollcode,studadm.frollno as fregno,
		studadm.fname,studadm.ffatname,studadm.ffat_occ,studadm.fmotname,studadm.fmot_occ,studadm.femail,
		DATE_FORMAT(studadm.fdob,'%d/%m/%Y')AS fdob,studadm.fsex,studadm.fcaste as stu,category.fdescpn as fcaste,studadm.FCONTACT_NO,studadm.FNATIONAL,studadm.FENGLISH,
		studadm.FCURRADD1,studadm.FCURRADD2,studadm.FCURRADD3,studadm.FCURRADD4,studadm.FPERMADD1,studadm.famount,studadm.fpaymenttype,
		studadm.FPERMADD2,studadm.FPERMADD3,studadm.FPERMADD4,studadm.FPHOTOPATH,degree.FDESCPN as FDESCPN,options.FHONOUR,studadm.FSTATE,
		GROUP_CONCAT(distinct subject.FSUBSHORT,'->',subject.FSUBNAME ORDER BY subject.FSUBCODE SEPARATOR '~') AS subjdet,options.FEXAMNO,
		CONCAT(college.FCOLLNAME,', ',college.FTOWN) as FCOLLNAME ,studadm.FFEEDET,studadm.FQUALUNIV,studadm.FQUALDEG,studadm.FQUALYEAR,studadm.FQUALREG,studadm.FQUALINS,options.FDEGREE,
		studadm.FQUALPR,studadm.FQUALCLASS,studadm.FDDAMT,DATE_FORMAT(studadm.FDDDATE,'%d/%m/%y')AS FDDDATE,studadm.FDDBANK,studadm.FDDBRANCH,ifnull(studadm.FREGNNO,'') as FREGNNO
		,FPAYMENTREMARKS,date_format(fpaymentdate,'%d/%m/%Y') as fpaymentdate,
		ifnull(FAADHAARNO,'') as FAADHAARNO, ifnull(FPASSPORTNO,'') as FPASSPORTNO
		FROM studadm ,options,subject,college,degree,category
		WHERE subject.FSUBCODE = options.FSUBCODE AND  subject.FDEGREE = options.FDEGREE
		and options.FDEGREE = degree.FDEGREE and subject.FDEGREE = degree.FDEGREE
		AND college.FCOLLCODE = studadm.FCOLLCODE AND college.FCOLLCODE = options.FCOLLCODE 
		AND options.FCOLLCODE=studadm.FCOLLCODE AND studadm.FEXAMNO= options.FEXAMNO 
		AND studadm.FDEGREE = options.FDEGREE AND studadm.FSLNO = options.FSLNO and category.fcategory = studadm.fcaste
		AND options.FAPPNO = '{$this->app_no}' and studadm.fdeleted <> 'T'
		AND options.FEXAMNO = 'A' AND studadm.FAPPNO = '{$this->app_no}'
		GROUP BY options.FSLNO";

$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'];
		$this->famount=$lobj_get_data['famount'];
		$this->FPAYMENTYPE=$lobj_get_data['fpaymenttype'];
		$this->FPAYMENTREMARKS=$lobj_get_data['FPAYMENTREMARKS'];
		$this->fpaymentdate=$lobj_get_data['fpaymentdate'];
		$this->FAADHAARNO  = $lobj_get_data['FAADHAARNO'];
		$this->FPASSPORTNO = $lobj_get_data['FPASSPORTNO'];
	}
	
	function GetDateFormat($date)
	{
		$valid_date=$date;
		if($date=="00/00/0000")
		$valid_date="";
		return $valid_date;
	}
	function formData()
	{
		$llineht = 4;
		$imght = 23;
		
		
	
		/* if($this->fdegree == 'BPH14' || $this->fdegree == 'BHT14' || $this->fdegree == 'MPH14' || $this->fdegree == 'MBA14')
		{
			$llineht = 4;
			$imght = 20;
		} */
	
		for($i=0;$i<3;$i++)
		{
			$this->pdf->SetMargins(9,3,9);
			$this->pdf->AddPage('P');
			$sql = "select FUNIVNAME,pdf_logo_path,FUNIVADD1 from control";
			$temres=$this->aobj_context->mobj_db->GetRow($sql);
			$pdf_logo_path = $this->aobj_context->main_src."/".$temres['pdf_logo_path'];
			$this->pdf->Ln(2);
			$this->pdf->SetFont('Courier','B',15);	
			$this->pdf->Cell(0,4,$temres['FUNIVNAME'],0,1,'C'); 
			$this->pdf->SetFont('Courier','',9);	
			$this->pdf->Cell(0,3,$temres['FUNIVADD1'],0,1,'C');

if(file_exists($pdf_logo_path)) 
			{
				$this->pdf->Image($pdf_logo_path,15,5,20);	
			}
			
			if($i == 0)
			{
				$copy = "Student Copy";
			}
			else if($i == 1)
			{
				$copy = "College / Department Copy";
			}
			else if($i == 2)
			{
				$copy = "University Copy";
			}
			
			$font = 10;
			$this->pdf->SetMargins(9,8,9);		
			
			$this->pdf->Rect(5,3,200,290);
			//$this->pdf->SetMargins(9,5,13);
			//$this->pdf->SetMargins(13,170);
			//$this->pdf->SetMargins(13,9);
			$this->pdf->SetMargins(9,3,9);
			//$this->pdf->SetMargins(9,5,9);

$aano = '';
			if($this->fnational == 'INDIAN')
				$aano ="Aadhaar No.: ".$this->FAADHAARNO;
			else
				$aano ="Passport No.: ".$this->FPASSPORTNO;

$this->pdf->SetFont('Times','B',10);
			//$this->pdf->Ln(12);
			$this->pdf->Cell(0,4,"STUDENT REGISTRATION APPLICATION 2024","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);
			$style = array(
				'position' => 'right',
				'align' => 'C',
				'stretch' => false,
				'fitwidth' => true,
				'cellfitalign' => '',
				'border' => false,
				'hpadding' => 'auto',
				'vpadding' => 'auto',
				'fgcolor' => array(0,0,0),
				'bgcolor' => false, //array(255,255,255),
				'text' => false,
				'font' => 'helvetica',
				'fontsize' => 8,
				'stretchtext' => 4
			);
			//Personal Details 
			//
			
			$this->pdf->SetFont('Times','B',12);			
			$this->pdf->cell(103,$llineht,"Application No."." : ".$this->app_no,"0",1,"L");
			$this->pdf->write1DBarcode($this->app_no, 'C39', '120', '23','100', 10, 0.3, $style, 'R');
			$this->pdf->cell(80,$llineht,"","0",1,"L");
			$this->pdf->SetFont('Times','B',$font);
			$llineht_new =$llineht;
			$llineht = 3;
			$this->pdf->cell(80,$llineht,"A. Personal Details ","0",1,"L");
			$llineht = $llineht_new;
			$this->pdf->SetFont('Times','',9);

$this->pdf->Ln(1);
						
			$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',9);
			$this->pdf->cell(86,$llineht,$collnamearr[0],"LRT",1,L);
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(86,$llineht,"S.U Department Currently Admitted Into (Admission 2024)","LRB",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(86,$llineht,$collnamearr[1],"LRB",1,L);
			
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(80,$llineht,"Roll Number of Current Admission(Admission 2024)","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(92,$llineht,$this->fregno,"1",1,"L");
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(80,$llineht,"Name in full (as per Higher Secondary Certificate)","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(92,$llineht,$this->fname,"1",1,"L");
			$img_path = $this->aobj_context->main_src.$this->fphotopath;
			$FUNIVCODE = '018';
			$keyname = $FUNIVCODE."/".$this->fphotopath;

$curl3 = curl_init();
		$photo_url = 'https://university-student-photos.s3.ap-south-1.amazonaws.com/'.$FUNIVCODE.'/'.urlencode($this->fphotopath);
		//var_dump($photo_url);
		//		"https://university-student-photos.s3.ap-south-1.amazonaws.com/003D/student_photos/5501/dnmb/181A0006.jpg";
		curl_setopt($curl3, CURLOPT_URL, $photo_url);
		curl_setopt($curl3, CURLOPT_NOBODY, true);
		$response_photo = curl_exec($curl3);
		$httpCode_photo = curl_getinfo($curl3 , CURLINFO_HTTP_CODE);
		
				$s3 = S3Client::factory(
					array(
						'credentials' => array(
							'key' => IAM_KEY,
							'secret' => IAM_SECRET
						),
						'version' => "latest",
						'region'  => 'ap-south-1'
					)
				);
				$filePath = tempnam(sys_get_temp_dir(), rand(10,15));
				try{
				$result = $s3->getObject([
					'Bucket' => STUDENT_PHOTOS_BUCKET,
					'Key'    => $keyname,
					'SaveAs' => $filePath
				]);}
				catch(S3Exception $e){
				}
								
				$img_path = $filePath;

if(!empty($this->fphotopath) && file_exists($img_path) && $httpCode_photo == '200') 
			{		
				$this->pdf->Image($img_path,182,34.5,19.5,$imght);
			}
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(80,$llineht,"Mother Name","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(92,$llineht,$this->fmotname,"1",1,"L");
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(80,$llineht,"Father Name ","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$this->ffatname,"1",1,"L");

$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(80,$llineht,"Date of Birth (as per Higher Secondary Certificate)","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(40,$llineht,$this->fdob,"1",0,"L");
			$this->pdf->cell(72,$llineht,$aano,"1",1,"L");
			
			if($this->fsex == 'M')
				$gender = 'Male';
			else
				$gender = 'Female';
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(40,$llineht,"Gender ","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(40,$llineht,$gender,"1",0,"L");
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(40,$llineht,"Blood_Group","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(72,$llineht,$this->fblood_group,"1",1,"L");
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(40,$llineht,"Nationality ","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(40,$llineht,$this->fnational,"1",0,"L");
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(40,$llineht,"State of Residence.","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(72,$llineht,$this->FSTATE,"1",1,"L");
						
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(80,$llineht,"Category ","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$this->fcaste,"1",1,"L");
			
			$this->pdf->SetFont('Times','',9);
			$address = $this->fcurradd1 .' '.$this->fcurradd2 .' '.$this->fcurradd3 .' '.$this->fcurradd4;
			$addressarr = str_splitf($address,9);
			$this->pdf->cell(80,$llineht,"Address of Correspondence","LRT",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$addressarr[0],"LRT",1,L);
			
			if(trim($addressarr[1]) !='')
			{	
				$this->pdf->cell(80,$llineht,"","LRB",0,"L");
				$this->pdf->SetFont('Times','B',9);
				$this->pdf->cell(112,$llineht,$addressarr[1],"LRB",1,L);
			}
			$peraddr = $this->fpermadd1 .' '.$this->fpermadd2 .' '.$this->fpermadd3 .' '.$this->fpermadd4;
			$peraddrarr = str_splitf($peraddr,60);
			$this->pdf->SetFont('Times','',9);					
			$this->pdf->cell(80,$llineht,"Permanent Address","LRT",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$peraddrarr[0],"LRT",1,"L");
			if(trim($peraddrarr[1]) !='')
			{	
				$this->pdf->cell(80,$llineht,"","LRB",0,"L");
				$this->pdf->SetFont('Times','B',9);
				$this->pdf->cell(112,$llineht,$peraddrarr[1],"LRB",1,L);
			}
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(40,$llineht,"Contact No.","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(40,$llineht,$this->fcontact_no,"1",0,"L");
			$this->pdf->SetFont('Times','',9);
			//$this->pdf->cell(10,5,"7","1",0,"L");
			$this->pdf->cell(35,$llineht,"Email Id ","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(77,$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','',9);
			//$this->pdf->cell(10,5,"10","1",0,"L");
			$this->pdf->cell(30,$llineht,"Course/Programme","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(162,$llineht,$this->fdescpn,"1",1,"L");
			$this->pdf->SetFont('Times','',9);
			//Honours Subject enrolled into (only for BA, BSC & M.Pharm)
			
			$this->pdf->SetFont('Times','B',9);
			//$this->pdf->cell(10,5,"10","1",0,"L");
			$this->pdf->cell(30,$llineht,"Subject Code","1",0,"L");
			$this->pdf->cell(139,$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','',9);
				$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(30,$llineht, $this->subname[0],"1",0,"L");
				$this->pdf->cell(139,$llineht, $this->subname[1],"1",0,"L");
				if($this->fdegree == 'BA18' || $this->fdegree == 'BSC18' )
				{
					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','',9); 
			//Last Examination Passed
			$this->pdf->cell(80,$llineht,"Last Examination Passed","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$this->FQUALDEG,"1",1,"L");
			$this->pdf->SetFont('Times','',9); 
			$this->pdf->cell(80,$llineht,"Board / University under which Examination was held","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$this->FQUALUNIV,"1",1,"L");
			 
			$this->pdf->SetFont('Times','',9); 
			$this->pdf->cell(80,$llineht,"Institution of Last Examination","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(112,$llineht,$this->FQUALINS,"1",1,"L");

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

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

$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(60,$llineht,"Percentage of Aggregate Marks","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(20,$llineht,$this->FQUALPR,"1",0,"L");
			
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(63,$llineht,"Division / Class / Grade / CGPA obtained ","1",0,"L");
			$this->pdf->SetFont('Times','B',9);
			$this->pdf->cell(49,$llineht,$this->FQUALCLASS,"1",1,"L");	
			
			if(!empty($this->FREGNNO))
			{
				$this->pdf->Ln(1);
				$this->pdf->SetFont('Times','B',10);
				$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','',9);
				$this->pdf->cell(130,$llineht,"Sikkim University Registration number allotted: ","1",0,"L");
				$this->pdf->SetFont('Times','B',9);
				$this->pdf->cell(62,$llineht,$this->FREGNNO,"1",1,"L");
			}
			else
			{
				$this->pdf->Ln(1);
				$this->pdf->SetFont('Times','B',10);
				$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','',9);
				$this->pdf->cell(130,$llineht,"Sikkim University Registration number allotted: NOT APPLICABLE","1",0,"L");
				$this->pdf->SetFont('Times','B',9);
				$this->pdf->cell(62,$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','',9);
			$this->pdf->cell(165,$llineht,"Self attested copy of Qualifying Exam Mark Sheet(s) - Mandatory","1",0,"L");
			$this->pdf->cell(27,$llineht," ","1",1,"L");
			$this->pdf->cell(165,$llineht,"Self attested copy of Class X Mark Sheet/Pass Certificate/Admit Card for Age Proof - Mandatory","1",0,"L");
			$this->pdf->cell(27,$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(165,$llineht,"Self attested copy of Caste Certificate - Mandatory if applicable","1",0,"L");
			$this->pdf->cell(27,$llineht," ","1",1,"L");
			$this->pdf->cell(165,$llineht,"Migration Certificate in Original - Mandatory if Qualifying Exam is not under SU","1",0,"L");
			$this->pdf->cell(27,$llineht," ","1",1,"L");
			
			$this->pdf->cell(165,2,"Admission fee receipt (Mandatory for students of SU and PG depts of Affiliated Colleges)","1",0,"L");
			$this->pdf->cell(27,2," ","1",1,"L");
			
			// $this->pdf->cell(165,1,"Registration Fees paid Challan (Mandatory for all other students)","LRB",0,"L");
			// $this->pdf->cell(18,1," ","LRB",1,"L");
			/* 
			$this->pdf->cell(155,$llineht,"Copy of Admission Fee Receipt (Mandatory for students of University Departments and PG students of Sikkim Govt. College, Tadong)","1",0,"L");
			$this->pdf->cell(28,$llineht," ","1",1,"L"); */
			$this->pdf->Ln(1);
			$this->pdf->cell(80,$llineht,"Date  :",'',1,"L");
			$this->pdf->cell(80,$llineht,"Place :",'',1,"L");
			$this->pdf->SetFont('Times','',10);
			// $this->pdf->cell(133,$llineht,"Total Amount : ".$this->famount,'',0,"L");
			// $this->pdf->cell(50,$llineht,"Student Signature",'',1,"R");

$this->pdf->cell(133,$llineht,"Total Amount : ".$this->famount,'',1,"L");
			$this->pdf->cell(133,$llineht,"Bank Transcation Id : ".$this->FPAYMENTREMARKS,'',1,"L");
			$this->pdf->cell(133,$llineht,"Bank Transcation Date :".$this->fpaymentdate,'',0,"L");
			$this->pdf->cell(50,$llineht,"Student Signature",'',1,"R");
			
			
			//$this->pdf->Ln(1);
			$this->pdf->SetFont('Times','B',$font);
			$this->pdf->cell(192,$llineht,"For College / Department use only","1",1,"L");
			$this->pdf->SetFont('Times','',9);
			$this->pdf->cell(95,$llineht,"Application & Supporting Documents Verified By ","LR",0,"L");
			$this->pdf->cell(97,$llineht," ","LR",1,"L");
			$this->pdf->cell(95,$llineht,"Head of Dept. Name","LR",0,"L");
			
			if(substr($this->fcollcode,0,1) == 'P')
			{
				$this->pdf->cell(97,$llineht,"","LR",1,"L");
				$this->pdf->cell(95,$llineht,"Head of Dept. Signature:","LR",0,"L");
			}
			else
			{
				$this->pdf->cell(97,$llineht,"Principal’s Signature:","LR",1,"L");
				$this->pdf->cell(95,$llineht," ","LR",0,"L");
			}
			$this->pdf->cell(97,$llineht," ","LR",1,"L");
			$this->pdf->cell(95,$llineht,"","LR",0,"L");
			if(substr($this->fcollcode,0,1) == 'P')
			{
				$this->pdf->cell(97,$llineht,"","LR",1,"L");
				$this->pdf->cell(95,$llineht,"Seal","LR",0,"L");
				$this->pdf->cell(97,$llineht," ","LR",1,"L");
			}
			else
			{
				$this->pdf->cell(97,$llineht,"Date","LR",1,"L");
				$this->pdf->cell(95,$llineht,"Signature","LR",0,"L");
				$this->pdf->cell(97,$llineht,"Seal","LR",1,"L");
			}
			$this->pdf->cell(95,$llineht,"Date","LBR",0,"L");
			$this->pdf->cell(97,$llineht,"","LBR",1,"L");	
		}
	}
	function SendOutput()
	{
		$this->pdf->Output("application_letter_{$this->app_no}.pdf","I");
	}	
}

${this.title}

Code Editor : applicationfromreport.php