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

<?php
function generateDegreeReport($aobj_context)
{	
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 
	$degree_types = $aobj_context->mobj_data["degree_types"]; 
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$from_degree = $aobj_context->mobj_data["frmdegree"]; 
	$to_degree = $aobj_context->mobj_data["todegree"]; 
	
	$main_src=$main_src_obj[1];
 
	$pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php";	
	$root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report".$_SESSION['user_id']."_".$report_id.".pdf";
// global varibales
	$p_count =1;
// end global varibales	
//echo $pdf_writer_class; 
	include($pdf_writer_class);		
	$pdf= new FPDF();	
	$pdf->SetFont('Times','',10);
	$pdf->SetMargins(15,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_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'];
	
	$pdf->aobj_context =$aobj_context ;
	$pdf->WhichReport = 'Degree';
	$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->DEGREETYPES=$degree_types;
	$pdf->startfrom=$from_degree;
	$pdf->endto=$to_degree;
	$pdf->AddPage();PrintFooter($pdf);
	
	$pdf->Ln();
	$pdf->SetFont('Times','',10);
	if($degree_types =='Selected only')
	{
		$get_data= " select distinct c.FDEGREE as 'Degree', d.FDESCPN as 'Description' from colldeg c inner join  degree d 
					on c.FDEGREE = d.FDEGREE and c.FCOLLCODE='{$college_code}' 
					and c.FDELETED='F'";//where d.FDEGREE >='{$from_degree}' and d.FDEGREE <='{$to_degree}' 
		$fwidth='140';
	}
	else
	{
		//$get_data=" select distinct FDEGREE as 'Degree', FDESCPN  as 'Description' from degree order by FDEGREE";
		//where FDEGREE >='{$from_degree}' and FDEGREE <='{$to_degree}'	
		$get_data="select distinct d.FDEGREE as 'Degree', d.FDESCPN as 'Description',IF(IFNULL(c.FDEGREE,'F')='F','','Selected') as 'Status' from colldeg c   right join degree d 
					on c.FDEGREE = d.FDEGREE and c.FCOLLCODE='{$college_code}' 
					and c.FDELETED='F'";
		$fwidth='160';
	}
	$lobj_details = $aobj_context->mobj_db->GetAll($get_data);
	//echo "<pre>"; print_r($lobj_details); die();
	
	$header_row=(array_keys($lobj_details[0]));	
	$pdf->SetDash(1, .3); //5mm on, 5mm off
	$pdf->Line(10, 33, 200, 33);
	$pdf->Line(10, 33.5, 200, 33.5);
	foreach($header_row as $key1 => $value1)
	{	
		if($value1 == 'Description')
			$width='120';	
		else if($value1 == 'Degree')
			$width='20';	
		else 
			$width = '20';
			
		$pdf->SetFont('Times','B',10);
		$pdf->Cell($width,6,$value1,'0','0','L');
	}
	 //5mm on, 5mm off

$pdf->SetDash(1, .3);
	$pdf->Line(10,38, 200,38);
	$pdf->Line(10,38.5, 200,38.5);
	$pdf->Ln();	  
	$adm_ln_counter =0;
	foreach($lobj_details as $key => $value)
	{
	
		if($adm_ln_counter > 35)
		{
			//$pdf->Cell(160,0,' ',1,1);
			/*$new_y=$pdf->GetY();
			$pdf->SetDash(1, .3);
			$pdf->Line(10,$new_y, 200,$new_y);
			$pdf->Line(10,$new_y+.5, 200,$new_y+.5);*/
			$pdf->AddPage();PrintFooter($pdf);
			$pdf->Ln(4);
			$pdf->SetDash(1, .3); //5mm on, 5mm off
			$pdf->Line(10, 33, 200, 33);
			$pdf->Line(10, 33.5, 200, 33.5);
			foreach($header_row as $key1 => $value1)
			{	
				if($value1 == 'Description')
					$width='120';	
				else if($value1 == 'Degree')
					$width='20';	
				else 
					$width = '20';
					
				$pdf->SetFont('Times','B',10);
				$pdf->Cell($width,6,$value1,'0','0','L');
			}
			$new_y=$pdf->GetY();
			$pdf->SetDash(1, .3); //5mm on, 5mm off
			$pdf->Line(10, 38, 200, 38);
			$pdf->Line(10, 38.5, 200, 38.5);
			
			$pdf->Ln();
			$adm_ln_counter=0;
		}
	   foreach($value as $key2 => $value2)
	    {		  	    
		 if($key2 == 'Description')
		{
			$align = "L";
			$width='120';
		}	
		else if($key2 == 'Degree')
		{
			$align = "L";
			$width='20';
		}	
		else if($key2 == 'Status')
		{
			$width='20';
			$align = "L";
		}	
		$pdf->SetFont('Times','',10);	
		$pdf->Cell($width,6,$value2,'','0',"{$align}");
		}
		
		 $pdf->Ln();
		++$adm_ln_counter;
	}	
	//$pdf->Cell($fwidth,0,' ',1,1);
		/*$new_y=$pdf->GetY();
		$pdf->SetDash(1, .3);
		$pdf->Line(10,$new_y, 200,$new_y);
		$pdf->Line(10,$new_y+.5, 200,$new_y+.5);*/
	$pdf->Output("degree_lists.pdf","D");	 
	 
}

function PrintFooter($pdf)
{
		$new_x=$pdf->GetX();
		$new_y=$pdf->GetY();
		$ip=$_SERVER["REMOTE_ADDR"];
		$pdf->SetY(-20);
		$pdf->SetFont('Times','',8);
		$new_yl=$pdf->GetY();
		$pdf->SetDash(1, .3);
		$pdf->Line(10,$new_yl, 200,$new_yl);
		$pdf->Line(10,$new_yl+.5, 200,$new_yl+.5);
		$pdf->Ln(2);
		$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_degree_list.php