Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
DownloadRvRtAckApplications.ph...	4.75 KB	-rwxr-xr-x
PrintChallanEntryDetails.php	8.5 KB	-rwxr-xr-x
RvRtApplicationReport.php	9.02 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.28 KB	-rwxr-xr-x
batch_wise_details.php	4.59 KB	-rwxr-xr-x
report_admission_list.php	6.83 KB	-rwxr-xr-x
report_admission_ticket0808201...	11.66 KB	-rwxr-xr-x
report_admission_ticket1009201...	11.69 KB	-rwxr-xr-x
report_admission_ticket2203201...	10.76 KB	-rwxr-xr-x
report_admission_ticket2203sma...	11.05 KB	-rwxr-xr-x
report_admission_ticket2404201...	11.07 KB	-rwxr-xr-x
report_admission_ticket_160514...	14.72 KB	-rwxr-xr-x
report_admission_ticket_WITHOU...	11.7 KB	-rwxr-xr-x
report_admission_ticketold.php	14.37 KB	-rwxr-xr-x
report_batch_wise_details.php	7.47 KB	-rwxr-xr-x
report_batch_worksheet_details...	10.35 KB	-rwxr-xr-x
report_batch_worksheet_details...	10.63 KB	-rwxr-xr-x
report_candidate_list.php	19.8 KB	-rwxr-xr-x
report_candidate_list_before_p...	18.28 KB	-rwxr-xr-x
report_candidate_list_final.ph...	10.08 KB	-rwxr-xr-x
report_daliy_report.php	10.98 KB	-rwxr-xr-x
report_degree_list.php	2.53 KB	-rwxr-xr-x
report_deviation_report.php	8.96 KB	-rwxr-xr-x
report_deviation_report130312....	8.02 KB	-rwxr-xr-x
report_deviation_report1907201...	8.05 KB	-rwxr-xr-x
report_evaluation_report.php	9.57 KB	-rwxr-xr-x
report_evaluation_report040720...	9.57 KB	-rwxr-xr-x
report_marks_deviation_report....	5.54 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.37 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.41 KB	-rwxr-xr-x
report_practical_marks_details...	13.78 KB	-rwxr-xr-x
report_practical_marks_details...	14.41 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	7.66 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	5.84 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	6.72 KB	-rwxr-xr-x
report_revaluation.php	6.63 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.57 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.22 KB	-rwxr-xr-x
subject_wise_student_list.php	6.84 KB	-rwxr-xr-x

Code Editor : report_admission_ticket_160514.php

<?php
class AdmissionTicket
{
	public $aobj_context;
	public $degree_code;
	public $registor_no_starts;
	public $registor_no_ends;
	public $print_per_page;
	public $sub_appearing_count;
	public $std_adm_count;
	public $sub_arr;
	public $std_arr;
// university
	public $std_FUNIVNAME ;
	public $std_FTOWN;	
// college info	
	public $college_code;
	public $college_name;
	public $college_address;
// student info
	public $STD_RegNo;
	public $STD_CollCode;
	public $STD_Course;
	public $STD_Name;
	public $STD_FAT;
	public $STD_MAT;
	public $STD_DOB;	
	public $CollDetails;	
	public $ADMNUM;	
	public $bth_flag;	
	
	
	function __construct($aobj_context)
    {
		$this->aobj_context=$aobj_context;
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		session_start();
		$this->college_code = $_SESSION['collcode']; 
		$bth_flag=0;
	}
	
	function getUniversityDetails()
	{
		$page_header_university = "select FUNIVNAME,FTOWN  from control";		
		$lobj_page_header_university = $this->aobj_context->mobj_db->GetRow($page_header_university);		
		$this->std_FUNIVNAME = $lobj_page_header_university[FUNIVNAME];
		$this->std_FTOWN = $lobj_page_header_university[FTOWN];
	}	
	
	function getCollegeDetails()
	{
		$page_header_college = "select FCOLLCODE, FCOLLNAME, 
								CONCAT(FCOLLADD1,SPACE(2), FTOWN) AS COLLEGE_ADRS FROM college
								WHERE FCOLLCODE='{$this->college_code}' AND FDELETED='F'";
		$lobj_page_header_college = $this->aobj_context->mobj_db->GetRow($page_header_college);
		
		//$this->college_code = $lobj_page_header_college['FCOLLCODE']
		$this->college_name = $lobj_page_header_college['FCOLLNAME'];
		$this->college_address = $lobj_page_header_college['COLLEGE_ADRS'];
	
	}//and ifnull(col.FDELETED,'F')='F'
	function getStudentDetails()
	{
		$get_student_data= " 	SELECT S.FDEGREE,S.FREGNO,S.FCOLLCODE,ifnull(FPHOTOPATH,'') as photo_path,
								concat(col.FCOLLNAME,',',space(2), col.FTOWN) as CollDetails  ,
								CONCAT(D.FDESCPN) AS COURSE, D.FEXAMDATE,
								S.FNAME,S.FFATNAME,S.FMOTNAME,
								DATE_FORMAT(S.FDOB,'%d/%m/%Y') AS FDOB
								FROM student S INNER JOIN degree D ON
								S.FDEGREE=D.FDEGREE AND S.FEXAMNO=D.FEXAMNO
								INNER JOIN college col ON S.FCOLLCODE=col.FCOLLCODE
								inner join candsum cs on S.fdegree = cs.fdegree
								and S.fregno = cs.fregno
								WHERE S.FREGNO>='{$this->registor_no_starts}' AND S.FREGNO<='{$this->registor_no_ends}' 
								AND S.FDEGREE='{$this->degree_code}' and S.FCOLLCODE='{$this->college_code}'
								and cs.frecptdate is not null order by S.FDEGREE,S.FREGNO
							";						
							//echo $get_student_data;
		$lobj_get_student_data = $this->aobj_context->mobj_db->GetAll($get_student_data);
		$this->std_adm_count = count($lobj_get_student_data);
	 
		 
		foreach($lobj_get_student_data as  $rek=>$rev)
		 {		
			$this->std_arr[$rev['FREGNO']]['FREGNO'] = $rev['FREGNO'];
			$this->std_arr[$rev['FREGNO']]['FCOLLCODE'] = $rev['FCOLLCODE'];
			$this->std_arr[$rev['FREGNO']]['COURSE'] = $rev['COURSE'];
			$this->std_arr[$rev['FREGNO']]['FNAME'] = $rev['FNAME'];
			$this->std_arr[$rev['FREGNO']]['FFATNAME'] = $rev['FFATNAME'];
			$this->std_arr[$rev['FREGNO']]['FMOTNAME'] = $rev['FMOTNAME'];
			$this->std_arr[$rev['FREGNO']]['FDOB'] = $rev['FDOB'];
			$this->std_arr[$rev['FREGNO']]['EXAMDATE'] = $rev['FEXAMDATE'];
			$this->std_arr[$rev['FREGNO']]['CollDetails'] = $rev['CollDetails'];
			$this->std_arr[$rev['FREGNO']]['photo_path'] = $rev['photo_path'];
		 } 	
		 
	}
	function getSubjectAppearing()
	{
		$get_subject_appearing = "SELECT c.FDEGREE, cs.FREGNO AS FREGNO , 
									GROUP_CONCAT(d.FEXAMNAME ORDER BY d.FEXAMNO) EXAMNAME,
									GROUP_CONCAT(c.FEXAMNO ORDER BY c.FSUBCODE) FEXAMNO, c.FREGNO,
									GROUP_CONCAT(s.FCSUBCODE ,'->',s.FSUBNAME,' ',s.FSSUBNAME,'->', s.FSHORTNAME,'->',concat(if(date_format(FDOE,'%d/%m/%Y')!='00/00/0000',date_format(FDOE,'%d/%m/%Y'),''),' ',ifnull(FSESSION,''),'->',FQPCODE)  ORDER BY s.FTHEORY desc,s.FCSUBCODE  SEPARATOR '~') AS SUBCODE , 
									GROUP_CONCAT(s.FSUBNAME,' ',s.FSSUBNAME,' [',FSUBSHORT,']' ORDER BY s.FCSUBCODE) AS SUBDECPN,
									ifnull(FRECPTDATE,'') as receipt_date
									FROM canddet c INNER JOIN subject s ON
									c.FDEGREE=s.FDEGREE AND c.FEXAMNO=s.FEXAMNO AND 
									c.FSUBCODE=s.FSUBCODE AND s.FINTASS!='T' AND INSTR(ifnull(c.fthpr,''), s.ftheory) <= 0
									inner join degree d on
									c.FDEGREE= d.FDEGREE AND c.FEXAMNO=d.FEXAMNO
									and d.FADYEAR=c.FYEAR
									and left(d.FADEXAMTYP,1)=left(c.FEXAMTYPE,1)
									inner join candsum cs on 
									cs.FDEGREE=c.FDEGREE AND cs.FREGNO=c.FREGNO AND 
									cs.FCOLLCODE=c.FCOLLCODE
									AND c.FYEAR=cs.FYEAR
									and left(c.FEXAMTYPE,1)=left(cs.FEXAMTYPE,1)
									WHERE
									c.FDEGREE='{$this->degree_code}' AND
									c.FCOLLCODE='{$this->college_code}' AND 
									ifnull(c.FPASSMTH,'') = '' AND c.fpresent = 'P'
									and c.FREGNO >= '{$this->registor_no_starts}' 
									AND c.FREGNO <='{$this->registor_no_ends}' 
									and cs.frecptdate is not null
									GROUP BY c.FREGNO, c.FDEGREE";
 	    $this->aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000");	
		$this->lobj_get_subject_appearing = $this->aobj_context->mobj_db->GetAll($get_subject_appearing);	
		 
	  $this->receipt_date_arr=array();
		 foreach($this->lobj_get_subject_appearing as $suk=>$suv)
		 {		
		 
			$this->std_arr[$suv[FREGNO]]['SUBCODE']=$suv['SUBCODE'];
			if(!empty($suv['receipt_date']))
			$this->receipt_date_arr[$suv[FREGNO]]=$suv['receipt_date'];
			 
			
		 } 
		 
		 
	}	
}
function generateAdmissionTicket($aobj_context)
{
	$class_obj=new AdmissionTicket($aobj_context);		
	ini_set("memory_limit",-1);
    ini_set('max_execution_time',3300);
	$class_obj->degree_code		= $aobj_context->mobj_data["degree_code"];
	
	//if(preg_match('[^BTH]', $class_obj->degree_code))
	if(preg_match('[^BTH]', $class_obj->degree_code))
	$class_obj->bth_flag=1;
	
	$class_obj->registor_no_starts= $aobj_context->mobj_data["reg_starts"];
	$class_obj->registor_no_ends= $aobj_context->mobj_data["reg_ends"]; 
	  
	
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	
	$pdf_reader_class=$aobj_context->main_src."/maya-pdf/fpdi/FPDI_Protection.php";	
	$pdf_psw_function=$aobj_context->main_src."/maya-pdf/TarkaPDFEncryption.php";
	$pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php";
	$root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report_adm_ticket.pdf";

include($pdf_writer_class);		
	$pdf= new FPDF(); 	
	$pdf->SetMargins(35,5,35);	
	$pdf->aobj_context =$aobj_context ;
	$pdf->WhichReport = 'AdmissionTicket';
	$pdf->SetFillColor(248, 248 ,255);		
	$pdf->SetFont('Times','',10);
	$pdf->AddPage();
	
	$adm_details=$class_obj->getUniversityDetails();
	$adm_details=$class_obj->getCollegeDetails();
	$adm_details=$class_obj->getStudentDetails();
	$adm_details=$class_obj->getSubjectAppearing();
 $page_cnt=1;
	foreach($class_obj->std_arr as $reg_k=>$reg_v)
	{
	if(!array_key_exists($reg_v['FREGNO'],$class_obj->receipt_date_arr))
	continue;
	$full_photo_path="";
	$full_photo_path=trim($aobj_context->main_src."/".$reg_v[photo_path]);	
		  
			$pdf->Ln(3);	
			//$pdf->SetLineWidth(0.01);
			 $pdf->SetLineWidth(0.01);
			 $pdf->SetFont('Times','B',16);	
				$img_path=$aobj_context->main_src."/img/report_uni_logo.jpg";
				if(file_exists($img_path)) 
				$pdf->Image($img_path,22,4,22);
			 $pdf->Cell(0,4,$class_obj->std_FUNIVNAME.', '.$class_obj->std_FTOWN,0,1,'C');
				$pdf->SetFont('Times','',10);
			 $pdf->Cell(0,4,'' ,'0',1,'C'); 
			 	$pdf->SetFont('Times','B',13);
			 $pdf->Ln(1);
			 $pdf->Cell(0,5,'HALL TICKET' ,'0',1,'C'); 
			 $pdf->SetFont('Times','B',10);
			 $pdf->Cell(0,5,$reg_v['EXAMDATE'].' EXAMINATION ' ,'0',1,'C'); 
			  	$pdf->SetFont('Times','',12);
			 $pdf->Ln(6);
			  $pdf->SetFont('Times','',12);	
				 
			 	if(file_exists($full_photo_path) && !empty($reg_v[photo_path]))
				{
					//$pdf->Cell(25,6,' App. No.',0,0,'L'); $pdf->Cell(3,6,' : ',0,0,'L');
					$pdf->Image($full_photo_path,155,$pdf->GetY(),27,27);				
					//$pdf->Cell(120,6,'  '.$class_obj->sub_arr[$p]['ADMNUM'],0,1,'L'); 				  	
				}
				$pdf->SetFont('Times','B',11); 
				$pdf->Cell(30,6,' Course',0,0,'L');	$pdf->Cell(6,6,' :  ',0,0,'L');	
				$pdf->SetFont('Times','',11);				
				$pdf->Cell(120,6,''.$reg_v['COURSE'],0,1,'L'); 
				
				$pdf->SetFont('Times','B',11); 
				$pdf->Cell(30,6,' Exam Center',0,0,'L'); $pdf->Cell(6,6,' :  ',0,0,'L');
				$pdf->SetFont('Times','',11); 
				$pdf->MultiCell(90,6,'Examination Hall, 3rd Floor, KSHEMA',0,"L");

$pdf->SetFont('Times','B',11); 
				$pdf->Cell(30,6,' College',0,0,'L'); $pdf->Cell(6,6,' :  ',0,0,'L');
				$pdf->SetFont('Times','',11); 
				$pdf->MultiCell(90,6,''.$reg_v['CollDetails'],0,"L");
				
				
				$pdf->SetFont('Times','B',11); 
				$pdf->Cell(30,6,' Reg. No.',0,0,'L'); $pdf->Cell(6,6,' :  ',0,0,'L');
				$pdf->SetFont('Times','',11); 
				$pdf->Cell(120,6,'NU'.$reg_v['FREGNO'],0,1,'L'); 
				$pdf->SetFont('Times','B',11); 
				$pdf->Cell(30,6," Student's Name",0,0,'L'); $pdf->Cell(6,6,' :  ',0,0,'L');
				$pdf->SetFont('Times','',11); 
				$pdf->Cell(120,6,''.$reg_v['FNAME'],0,1,'L'); 
			
				 
			$pdf->Ln(1);
			$pdf->SetFont('Times','B',11);
			$pdf->Cell(0,5,'Subject Appearing',0,1,'C');				
			$pdf->Cell(15,6,"Sl. No.","1",0,"C");
			$pdf->Cell(20,6,"Sub. Code","1",0,"C");
			$pdf->Cell(100,6,"Subject Title","1",0,"C");
			if($class_obj->bth_flag==1)
				$pdf->Cell(30,6,"Date and Session","1",1,"C");
			else
				//$pdf->Cell(20,6,"Sub. Code","1",0,"C");
			
			$pdf->Cell(30,6,"Inv. Sign","1",1,"C");
			$pdf->SetFont('Times','',11);	
			
		 	  
				$sub_arr=$reg_v[SUBCODE];
				 
				$subj_arr=explode("~",$sub_arr);
				$sl_no=1;
				foreach($subj_arr as $ek)
				{
					$explode_arr=explode("->",$ek);
					$sub_short=$explode_arr[4];
					if($class_obj->bth_flag==1)
					{	
						$pdf->Cell(100,6,$explode_arr[1]." [{$sub_short}]","1",0,"L");
						$pdf->Cell(20,6,$explode_arr[3],"1",1,"C"); 
					}
					else
					{
						$get_x1=$pdf->GetX();
						$get_y1=$pdf->GetY();
						//$pdf->Cell(80,6,$explode_arr[1],"1",0,"L");
						$width=15+20+100;
						$pdf->SetXY($get_x1+15+20,$get_y1);
						$pdf->MultiCell(100,6,$explode_arr[1],1,"L");
						$get_x2=$pdf->GetX();
						$get_y2=$pdf->GetY();
						$height=$get_y2-$get_y1;
						$pdf->SetXY($get_x1+15+20+100,$get_y1);
						
						//echo $height;die();
						 //$pdf->Cell(20,$height,$sub_short,"1",0,"C"); 
						 $pdf->Cell(30,$height,'',"1",1,"C"); 
					}
					
					 $pdf->SetXY($get_x1,$get_y1);
					 $pdf->Cell(15,$height, $sl_no,"1",0,"C");
					 $pdf->Cell(20,$height, $sub_short,"1",1,"C");
					
					
					 
									 				 
					$sl_no++;
				}
			
     			
				 
			$pdf->Ln(15);
			$img_x=($pdf->getX()+100);;
			$img_y=$pdf->getY()-10;
			$img_path=$aobj_context->main_src."/img/controler_sign.jpg";
			if(file_exists($img_path)) 
				$pdf->Image($img_path,$img_x,$img_y,30);
			//$pdf->Cell(90,5,'Student Signature	','0',0,'L');
			//$pdf->Cell(36,5,'Controller of Examinations','0',1,'L');
			
			$pdf->Cell(90,5,'','0',0,'L');
			$pdf->Cell(36,6,'Controller of Examinations','0',0,'L');
			$pdf->Ln(15);
			$pdf->Cell(90,5,'Student Signature	','0',0,'L');
			$pdf->Cell(36,5,'Principal Signature and Seal','0',1,'L');			
			$date=date("F j, Y, g:i a");  
			$pdf->Cell(90,5,"Date: ",'0',0,'L');
			$pdf->Ln(8);
			$pdf->SetFont('Times','U',11);	
			$pdf->Cell(90,5,'INSTRUCTIONS','0',0,'L');
			$pdf->Ln(8);
			$pdf->SetFont('Times','',8);	
			$pdf->MultiCell(165,3,'Candidate shall compulsorily carry this HALL TICKET and COLLEGE IDENTITY CARD for appearing for all Examinations.',0,"L");
			$pdf->Ln(1);
			$pdf->MultiCell(165,3,'Any candidate appearing for the UG/PG examination is liable to be charged with committing malpractice in the following cases:',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 1.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Bringing into the examination hall or being found in possession of portions of a book manuscript, programmable calculator or any other material or matter, which is not permissible to be brought into the examination hall.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 2.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Having any written matter on Scribbling pad, Question Paper, Admission Ticket, Calculator, Palm, Hand, Leg, Hand kerchief, Clothes, Socks, Instrument Box, Identity Card, Scales etc.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 3.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Disclosing identity by writing any words or by making any peculiar marks or by writing USN on the pages other than the facing sheet in the answer scripts while answering.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 4.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Copying from the material or matter or answer of another candidate or similar aid or assistance is rendered to another candidate within the Examination Hall.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 5.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Communicating with any candidate or any other person inside or outside the examination hall with a view to take assistance or aid to write answers in the examination.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 6.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Making any request / representation / offering any threat for inducement or inducing to bribery to Room Superintendent or / and any other official or officer of the college for favours in the examination hall or to the Examiner in the answer script.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 7.  ',0,0,'L');
			$pdf->MultiCell(165,3,'Smuggling out or smuggling in or tearing off of the answer script sheets or supplementary sheets or inserting papers written outside the examination hall into the answer book or running away along with the answer script from the examination hall or premises.',0,"L");
			$pdf->Ln(1);
			$pdf->Cell(5,6,' 8.  ',0,0,'L');
			$pdf->Cell(165,6,'Impersonating or allowing any other person to impersonate to answer in his/ her place in the examination hall.',0,0,'L');
			$pdf->Ln(5);
			$pdf->Cell(5,6,' 9.  ',0,0,'L');
			$pdf->Cell(165,6,'Supply of copying material inside or from outside the examination hall.',0,0,'L');
			$pdf->Ln(5);
			$pdf->Cell(5,6,' 10.  ',0,0,'L');
			$pdf->Cell(165,6,'Bringing mobile phone into the examination hall.',0,0,'L');
			$pdf->Ln(5);
			$pdf->Cell(5,6,' 11.  ',0,0,'L');
			$pdf->Cell(165,6,'Unruly behavior inside or near the examination hall.',0,0,'L');
			
			
			if($page_cnt!=count($class_obj->std_arr))
			{
			$pdf->AddPage();
			}$page_cnt++;
	} 
	 
	$pdf->Output("report_adm_ticket.pdf","D");
		 
}
?>

${this.title}

Code Editor : report_admission_ticket_160514.php