Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxrwxrwx
.Report_details_16042016.php	3.61 KB	-rw-r--r--
DownloadExamAppFormApplication...	4.51 KB	-rwxrwxrwx
PrintChallanEntryDetails.php	8.77 KB	-rwxrwxrwx
RvRtApplicationReport.php	8.76 KB	-rwxrwxrwx
appear_list_center_qp_wise.php	5.48 KB	-rwxrwxrwx
appear_list_qp_wise.php	5.34 KB	-rwxrwxrwx
batch_wise_details.php	4.44 KB	-rwxrwxrwx
report_admission_list.php	10.86 KB	-rwxrwxrwx
report_admission_list30062012....	6.67 KB	-rwxrwxrwx
report_admission_list_wop.php	10.25 KB	-rwxrwxrwx
report_admission_ticket.php	14.96 KB	-rwxrwxrwx
report_admission_ticket0310201...	10.74 KB	-rwxrwxrwx
report_admission_ticket0409201...	10.69 KB	-rwxrwxrwx
report_admission_ticket1403201...	10.76 KB	-rwxrwxrwx
report_admission_ticket2408.ph...	10.46 KB	-rwxrwxrwx
report_admission_ticket2408201...	10.47 KB	-rwxrwxrwx
report_admission_ticket_071020...	13.89 KB	-rwxrwxrwx
report_admission_ticket_distan...	14.14 KB	-rwxrwxrwx
report_admission_ticket_upto_o...	12.4 KB	-rwxrwxrwx
report_attendance_summary.php	7.75 KB	-rwxrwxrwx
report_batch_wise_details.php	7.93 KB	-rwxrwxrwx
report_batch_worksheet_details...	10.33 KB	-rwxrwxrwx
report_candidate_list.php	26.01 KB	-rwxrwxrwx
report_candidate_list1111.php	16.24 KB	-rwxrwxrwx
report_candidate_list22042013....	16.35 KB	-rwxrwxrwx
report_candidate_list24082012....	16.21 KB	-rwxrwxrwx
report_candidate_list26042013....	16.35 KB	-rwxrwxrwx
report_candidate_list_09052013...	16.42 KB	-rwxrwxrwx
report_candidate_list_before_f...	25.19 KB	-rwxrwxrwx
report_candidate_list_final.ph...	9.85 KB	-rwxrwxrwx
report_candidate_list_new.php	17.76 KB	-rwxrwxrwx
report_candidate_list_old.php	18.18 KB	-rwxrwxrwx
report_candidate_listmohan.php	16.21 KB	-rwxrwxrwx
report_candidate_listx.php	16.24 KB	-rwxrwxrwx
report_daliy_report.php	10.83 KB	-rwxrwxrwx
report_daliy_report_qp.php	9.79 KB	-rwxrwxrwx
report_degree_list.php	5.31 KB	-rwxrwxrwx
report_deviation_report.php	7.67 KB	-rwxrwxrwx
report_evaluation_report.php	9.31 KB	-rwxrwxrwx
report_marksPending.php	5.13 KB	-rwxrwxrwx
report_marks_deviation_report....	5.38 KB	-rwxrwxrwx
report_marks_entry_student_lis...	6.53 KB	-rwxrwxrwx
report_marks_entry_student_lis...	5.28 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	11.13 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.13 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.2 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	14.56 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.02 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.36 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.13 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	11.65 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.2 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.05 KB	-rwxrwxrwx
report_marksentry.php	7.12 KB	-rwxrwxrwx
report_online_eam.php	10.92 KB	-rwxrwxrwx
report_practical_marks_details...	13.35 KB	-rwxrwxrwx
report_practical_marks_details...	13.37 KB	-rwxrwxrwx
report_practical_marks_details...	13.22 KB	-rwxrwxrwx
report_ra_invigilators_dairy.p...	7.63 KB	-rwxrwxrwx
report_ra_qp_wise_student_coun...	5.84 KB	-rwxrwxrwx
report_ra_roomwise_register_no...	6.7 KB	-rwxrwxrwx
report_revaluation.php	4.45 KB	-rwxrwxrwx
report_subject_admcl_list.php	4.32 KB	-rwxrwxrwx
report_subject_general_list.ph...	10.89 KB	-rwxrwxrwx
subject_wise_student_list.php	6.77 KB	-rwxrwxrwx
teacher_report.php	9.89 KB	-rwxrwxrwx

Code Editor : report_subject_general_list.php

<?php
function generateSubjecGeneralReport($aobj_context)
{	
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam_code_start = $aobj_context->mobj_data["exam_code_start"]; 
	$exam_code_end = $aobj_context->mobj_data["exam_code_end"]; 
	$report_type = $aobj_context->mobj_data["reportType"]; 
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	$pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php";	
	$root_pdf_file_download=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report_general_list.pdf";
// global varibales
	$p_count =1;
// end global varibales	
	include($pdf_writer_class);		
	$pdf= new FPDF();
	//$pdf->$title='20000 Leagues Under the Seas';
	$pdf->SetFont('Times','',10);
	$pdf->SetMargins(10,8);		
	$pdf->AliasNbPages();

// query for the page header	
	$page_header_university = "select FUNIVNAME,FUNIVADD1,FTOWN, date_format(now(),'%d/%m/%Y') as date from control";
	$lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);
	
	$page_header_college ="select concat(FCOLLCODE,' - ',FCOLLNAME,', ',FTOWN) as college_name
							from college where FCOLLCODE='{$college_code}'";
	$lobj_page_header_college = $aobj_context->mobj_db->GetRow($page_header_college); 
					
	$page_header_degree = "select distinct concat(degree.FDEGREE,' - ',degree.FDESCPN,', ', degree.FEXAMNAME) as Degree_name, 
							degree.FADYEAR  
							from degree, subject where degree.fdegree = subject.fdegree and degree.fexamno = subject.fexamno
							and degree.FDEGREE = '{$degree_code}' and 
							degree.FEXAMNO >= '{$exam_code_start}' and degree.FEXAMNO<='{$exam_code_end}'";
	
	$page_footer_date = "select DATE_FORMAT(NOW(),'%d/%m/%Y %h:%i %p') as now_date ";
	$lobj_page_footer_date = $aobj_context->mobj_db->GetRow($page_footer_date);
	$pdf->date_time = $lobj_page_footer_date['now_date'];
	
	$lobj_page_header_degree = $aobj_context->mobj_db->GetAll($page_header_degree);
	/* echo "<PRE>";
	var_dump($lobj_page_header_degree); die(); */
	$pdf->aobj_context =$aobj_context ;
	$pdf->WhichReport = $report_type ;
	$pdf->FUNIVNAME = $lobj_page_header_university[FUNIVNAME];
	$pdf->FTOWN = $lobj_page_header_university[FTOWN];
	$pdf->FUNIVADD1 = $lobj_page_header_university[FUNIVADD1];
	$pdf->date_1 = $lobj_page_header_university['date'];
	$pdf->college_name = $lobj_page_header_college['college_name'];
	$pdf->Degree_name = $lobj_page_header_degree[0]['Degree_name'];
	//$pdf->Exam = $lobj_page_header_degree[0]['Exam'];
	
	//end header		
	$pdf->AddPage();PrintFooter($pdf);	
	$pdf->SetFont('Times','',10);
	// FSSUBCODE='1'  and
	if($report_type == 'SUBJECT_GENERAL')
	{
		$get_subject_data= " select if(FMANDATORY='T',concat('* ',FCSUBCODE),concat('  ',FCSUBCODE)) as FCSUBCODE , LEFT(FCSUBCODE,LENGTH(FCSUBCODE)-1) as Fsubc ,FEXAMNO,
						 concat(FSUBNAME, concat(space(3),FSSUBNAME,'(',if(FTHEORY='T','TH','PA'),')')) as SSubName, 						 
						 FSMAXMARKS,FQPCODE ,CONCAT(IF(FTHEORY='T','Theory','Practical'),CONCAT(SPACE(2),IF(FINTASS='T' ,'I A' ,''))) as Remarks 
						 from subject
						 where FDEGREE='{$degree_code}' and 
						 FEXAMNO>='{$exam_code_start}' and FEXAMNO<='{$exam_code_end}'  and
						  IFNULL(FDELETED,'F') ='F' 
						 group by FCSUBCODE;
					   "; 		  
	$lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data);	
	$Count_subject=1;
	$chk_sem = $lobj_get_subject_data[0]['FEXAMNO'];
	$nxt = 0;
	$w = array(12,18,105,20,20);
	$x = $pdf->GetX();
	$y = $pdf->GetY();
	
	foreach($lobj_get_subject_data as $key => $value)
	{	  	  	    
		if($chk_sem == $value['FEXAMNO'])	
		{
		}
		else
		{
			$nxt++;
			$pdf->Exam = $lobj_page_header_degree['Exam'];			
			$chk_sem = $value['FEXAMNO'];
			$pdf->Degree_name = $lobj_page_header_degree[$nxt]['Degree_name'];
			$pdf->Exam = $lobj_page_header_degree[$nxt]['Exam'];
			//$pdf->Cell(193,0,' ',1,1);
			/*$new_y=$pdf->GetY();
			$pdf->SetDash(1, .3); //5mm on, 5mm off
			$pdf->Line(10, $new_y, 203, $new_y);
			$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
			$Count_subject=1;
			$pdf->AddPage();PrintFooter($pdf);
			$page_cnt=0;
		}
				$XY=$pdf->GetY();
				if($XY > 270)
				{
					//$pdf->Cell(193,0,' ',1,1);
					/*$new_y=$pdf->GetY();
					$pdf->SetDash(1, .3); //5mm on, 5mm off
					$pdf->Line(10, $new_y, 203, $new_y);
					$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
					$pdf->AddPage();PrintFooter($pdf);
					$page_cnt=0;
				}
				$pdf->SetFont('Times','',10);
				$y1 = $pdf->GetY();
				$X1 = $pdf->GetX();
				$pdf->SetXY($X1+48,$y1);
				$pdf->MultiCell($w[2], 5, $value['SSubName'], '',1);	
				$y2 = $pdf->GetY();
				$yH = $y2 - $y1;
				$pdf->SetXY($x + $w[2]-105, $pdf->GetY() - $yH);
				
				if($value['Fsubc'] != $prevSubCode)
					$pdf->Cell($w[0], $yH, $Count_subject++, '',0,'C');
				else
					$pdf->Cell($w[0], $yH,' ', '',0,'C');
					
				$pdf->Cell($w[1], $yH, $value['FCSUBCODE'], '',0,'C');	
				$pdf->Cell($w[1], $yH, $value['FQPCODE'], '',0,'C');
				$X3 = $pdf->GetX();
				$Y3 = $pdf->GetY();
				$pdf->SetXY($X3+105,$Y3);
				$pdf->Cell($w[4], $yH, $value['FSMAXMARKS'], '', 0, 'C');
				$pdf->Cell($w[3], $yH, $value['Remarks'], '', 0, 'L');
				$prevSubCode =$value['Fsubc'];
				$pdf->Ln();
				
	}
	/*$new_y=$pdf->GetY();
	$pdf->SetDash(1, .3); //5mm on, 5mm off
	$pdf->Line(10, $new_y, 203, $new_y);
	$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
	$pdf->Output("report_general_list.pdf","D");
	}
	
	if($report_type == "SUBJECT_ADCL")
	{
		$get_subject_data= " select if(FMANDATORY='T',concat('* ',FSUBCODE),concat('  ',FSUBCODE)) as FSUBCODE, 
						FEXAMNO, FSUBNAME  , FSUBSHORT
						 from subject where FDEGREE='{$degree_code}' and
						FEXAMNO>='{$exam_code_start}' and FEXAMNO<='{$exam_code_end}'
						 and ifnull(FDELETED,'F')='F' group by FSUBCODE	
					  "; 				  
					
		$lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data);	
	
		$Count_subject=1;
		$chk_sem = $lobj_get_subject_data[0]['FEXAMNO'];
		$w = array(12,20,120,20);
		$x = $pdf->GetX();
		$y = $pdf->GetY();
	
		foreach($lobj_get_subject_data as $key => $value)
		{	  	  	    
			if($chk_sem == $value['FEXAMNO'])	
			{
			}
			else
			{
				$nxt++;
				$pdf->Exam = $lobj_page_header_degree['Exam'];			
				$chk_sem = $value['FEXAMNO'];
				$pdf->Degree_name = $lobj_page_header_degree[$nxt]['Degree_name'];
				$pdf->Exam = $lobj_page_header_degree[$nxt]['Exam'];
				/*$new_y=$pdf->GetY();
				$pdf->SetDash(1, .3); //5mm on, 5mm off
				$pdf->Line(10, $new_y, 203, $new_y);
				$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
				$Count_subject=1;
				$pdf->AddPage();PrintFooter($pdf);
				
			}	
			
			
				
				$XY=$pdf->GetY();
					if($XY > 270)
					{
						/*$new_y=$pdf->GetY();
						$pdf->SetDash(1, .3); //5mm on, 5mm off
						$pdf->Line(10, $new_y, 203, $new_y);
						$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
						$pdf->AddPage();PrintFooter($pdf);
						$page_cnt=0;
					}
					
					$y1 = $pdf->GetY();
					$X1 = $pdf->GetX();
					$pdf->SetFont('Times','',10);
					$pdf->SetXY($X1+32,$y1);
					$pdf->MultiCell($w[2], 5, $value['FSUBNAME'], '',1);	
					$y2 = $pdf->GetY();
					$yH = $y2 - $y1;
					$pdf->SetXY($x + $w[2]-120, $pdf->GetY() - $yH);

$pdf->Cell($w[0], $yH, $Count_subject++, '',0,'C');
					$pdf->Cell($w[1], $yH, $value['FSUBCODE'], '',0,'C');
					//$pdf->Cell($w[1], $yH, $value['FQPCODE'], '',0,'C');
					$X3 = $pdf->GetX();
					$Y3 = $pdf->GetY();
					$pdf->SetXY($X3+120,$Y3);
					$pdf->Cell($w[3], $yH, $value['FSUBSHORT'], '', 0, 'C');
					$pdf->Ln();

}
		/*$new_y=$pdf->GetY();
		$pdf->SetDash(1, .3); //5mm on, 5mm off
		$pdf->Line(10, $new_y, 203, $new_y);
		$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
		
		$pdf->Output("report_admission_list.pdf","D");
	}
	
	if($report_type == 'SUBJECT_THEORY')
	{
		$get_subject_data= " select if(FMANDATORY='T',concat('* ',FCSUBCODE),concat('  ',FCSUBCODE)) as FCSUBCODE , LEFT(FCSUBCODE,LENGTH(FCSUBCODE)-1) as Fsubc ,FEXAMNO,
						 concat(FSUBNAME, concat(space(3),FSSUBNAME,'(',if(FTHEORY='T','TH','PA'),')')) as SSubName, 						 
						 FSMAXMARKS,FQPCODE ,CONCAT(IF(FTHEORY='T','Theory','Practical'),CONCAT(SPACE(2),IF(FINTASS='T' ,'I A' ,''))) as Remarks 
						 from subject
						 where FDEGREE='{$degree_code}' and 
						 FEXAMNO>='{$exam_code_start}' and FEXAMNO<='{$exam_code_end}'  and
						  IFNULL(FDELETED,'F') ='F'  and  IFNULL(FTHEORY,'F') = 'T' AND IFNULL(FINTASS,'F') <> 'T'
						 group by FCSUBCODE;
					   "; 		  
	$lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data);	
	$Count_subject=1;
	$chk_sem = $lobj_get_subject_data[0]['FEXAMNO'];
	$nxt = 0;
	$w = array(12,18,105,20,20);
	$x = $pdf->GetX();
	$y = $pdf->GetY();
	
	foreach($lobj_get_subject_data as $key => $value)
	{	  	  	    
		if($chk_sem == $value['FEXAMNO'])	
		{
		}
		else
		{
			$nxt++;
			$pdf->Exam = $lobj_page_header_degree['Exam'];			
			$chk_sem = $value['FEXAMNO'];
			$pdf->Degree_name = $lobj_page_header_degree[$nxt]['Degree_name'];
			$pdf->Exam = $lobj_page_header_degree[$nxt]['Exam'];
			/*$new_y=$pdf->GetY();
			$pdf->SetDash(1, .3); //5mm on, 5mm off
			$pdf->Line(10, $new_y, 203, $new_y);
			$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
			$Count_subject=1;
			$pdf->AddPage();PrintFooter($pdf);
			$page_cnt=0;
		}
				$XY=$pdf->GetY();
				if($XY > 270)
				{
					/* $new_y=$pdf->GetY();
					$pdf->SetDash(1, .3); //5mm on, 5mm off
					$pdf->Line(10, $new_y, 203, $new_y);
					$pdf->Line(10, $new_y+.5, 203, $new_y+.5);*/
					$pdf->AddPage();PrintFooter($pdf);
					$page_cnt=0;
				}
				$pdf->SetFont('Times','',10);
				$y1 = $pdf->GetY();
				$X1 = $pdf->GetX();
				$pdf->SetXY($X1+48,$y1);
				$pdf->MultiCell($w[2], 5, $value['SSubName'], '',1);	
				$y2 = $pdf->GetY();
				$yH = $y2 - $y1;
				$pdf->SetXY($x + $w[2]-105, $pdf->GetY() - $yH);
				
				if($value['Fsubc'] != $prevSubCode)
					$pdf->Cell($w[0], $yH, $Count_subject++, '',0,'C');
				else
					$pdf->Cell($w[0], $yH,' ', '',0,'C');
					
				$pdf->Cell($w[1], $yH, $value['FCSUBCODE'], '',0,'C');	
				$pdf->Cell($w[1], $yH, $value['FQPCODE'], '',0,'C');
				$X3 = $pdf->GetX();
				$Y3 = $pdf->GetY();
				$pdf->SetXY($X3+105,$Y3);
				$pdf->Cell($w[4], $yH, $value['FSMAXMARKS'], '', 0, 'C');
				$pdf->Cell($w[3], $yH, $value['Remarks'], '', 0, 'L');
				$prevSubCode =$value['Fsubc'];
				$pdf->Ln();
				
	}
	/* $new_y=$pdf->GetY();
	$pdf->SetDash(1, .3); //5mm on, 5mm off
	$pdf->Line(10, $new_y, 203, $new_y);
	$pdf->Line(10, $new_y+.5, 203, $new_y+.5); */
	$pdf->Output("report_theory_list.pdf","D");
	}
}

function PrintFooter($pdf)
{
		$new_x=$pdf->GetX();
		$new_y=$pdf->GetY();
		$ip=$_SERVER["REMOTE_ADDR"];
		$pdf->SetY(-20);
		$new_yL=$pdf->GetY();
		$pdf->SetDash(1, .3); //5mm on, 5mm off
		$pdf->Line(10, $new_yL, 203, $new_yL);
		$pdf->Line(10, $new_yL+.5, 203, $new_yL+.5);
		$pdf->Ln(2);
		$pdf->SetFont('Times','',8);
		$pdf->Cell(140,4,'Printed   : IP Address : '.$ip.", Date : ".$pdf->date_time,'0',0,'L');
		$pdf->SetXY($new_x,$new_y); 
}
?>

${this.title}

Code Editor : report_subject_general_list.php