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

<?php
function GenerateMarksEntryReport($aobj_context)
{	
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	$from_exam = $aobj_context->mobj_data["from_exam"]; 
	$to_exam = $aobj_context->mobj_data["to_exam"]; 
	$from_degree = $aobj_context->mobj_data["from_degree"]; 
	$to_degree = $aobj_context->mobj_data["to_degree"]; 
	$from_coll = $aobj_context->mobj_data["from_coll"]; 
	$to_coll = $aobj_context->mobj_data["to_coll"]; 
	$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=$aobj_context->main_src."/Report_details/output/report_general_list.pdf";
	$getnumword=$aobj_context->main_src."/src/getnumword.php";
	include($getnumword);
	
//	global varibales
	$p_count =1;
//	end global varibales	
	
//	echo getnumber_to_word("001"); die();
	include($pdf_writer_class);		
	$pdf= new FPDF('L');
	$pdf->SetFont('Times','',10);
	$pdf->SetMargins(10,15,10);		
	$pdf->AliasNbPages(); 
	$lobj_page_collList = $aobj_context->mobj_db->GetAll($coll_list);
	
	// 	query for the page header	
	$page_header_university = "select FUNIVNAME,FTOWN, date_format(now(),'%d/%m/%Y') as date from control";
	$lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);
	
		
	$pdf->aobj_context =$aobj_context ;
	$pdf->WhichReport = 'MARKS_COLLEGEWISEPENDING';
	$pdf->FUNIVNAME = $lobj_page_header_university[FUNIVNAME];
	$pdf->FTOWN = $lobj_page_header_university[FTOWN];
	$pdf->date_1 = $lobj_page_header_university['date'];
	$pdf->AdmissionYear = $lobj_page_header_degree['FADYEAR'];
	$pdf->RFROM=strtoupper(substr($sublist_start,-4));
	$pdf->RTO=strtoupper(substr($sublist_end,-4));
	$pdf->REPORT_STATUS = 'IA Marks Pending';
//	end header		
	
		$get_studntCnt = "select m.fcollcode, c.fcollname,
		m.FSUBCODE, su.FSMAXMARKS,concat(su.FSUBNAME,',[',FSSUBNAME,']') as sub_name,
		c.ftown, m.fdegree, d.fdescpn, m.fexamno, d.fexamname,
		sum(if(m.fmarks > -1,1,0)) as fentered, sum(if(m.fmarks = -1,1,0)) as fpending
		from marks m, college c, degree d, candsum s,subject su  
		where m.fdegree = d.fdegree and m.fexamno = d.fexamno and m.fcollcode = c.fcollcode
		and m.fdegree = s.fdegree and m.fregno = s.fregno and m.fexamno = s.ffreshexam
		and s.fcollcode between '{$from_coll}' and '{$to_coll}'
		and s.fdegree between '{$from_degree}' and '{$to_degree}'
		and s.fexamno between '{$from_exam}' and '{$to_exam}'
		group by m.fcollcode, m.fdegree, m.fexamno
		order by m.fcollcode, m.fdegree, m.fexamno";
		$lobj_studntCnt = $aobj_context->mobj_db->GetAll($get_studntCnt);	
		$pdf->SetFont('Times','',10); 
		$count=0;
		$countVal=0;	
		$row_cnt=0;
		$slno =0;
	$pdf->AddPage();PrintFooter($pdf);
	foreach($lobj_studntCnt as $key => $value)
	{
		++$slno;
		$nb=max($nb,NbLines(70,$value[fcollname],$pdf));
		$nb=max($nb,NbLines(50,$value[sub_name],$pdf));
		$yH = 5*$nb;
		$pdf->Cell(10,$yH,$slno,0,0,'C');
		$pdf->Cell(20,$yH,$value['fcollcode'],0,0,'C');
		$x=$pdf->GetX();
		$y=$pdf->GetY();
		//Draw the border
		//$pdf->Rect($x,$y,60,$yH);
		$pdf->MultiCell(70,5,$value['fcollname'],0,'L');
		$pdf->SetXY($x+70,$y);
		$pdf->Cell(20,$yH,$value['fdegree'],0,0,'C');
		$pdf->Cell(20,$yH,$value['FSUBCODE'],0,0,'C');
		$x=$pdf->GetX();
		$y=$pdf->GetY();
		//$pdf->Rect($x,$y,50,$yH);
		$pdf->MultiCell(50,5,$value['sub_name'],0,'L');
		$pdf->SetXY($x+50,$y);
		$x=$pdf->GetX();
		$y=$pdf->GetY();
		$pdf->Cell(30,$yH,$value['fexamname'],0,0,'C');
		$pdf->Cell(20,$yH,$value['fentered'],0,0,'C');
		$pdf->Cell(20,$yH,$value['fpending'],0,1,'C');

$count++;
		$row_cnt++;
		if(($row_cnt) > 30)
			{
				$pdf->SetFont('Times','',10);
				$pdf->SetMargins(18,15);	
				$pdf->AddPage();PrintFooter($pdf);
				$row_cnt=0;		
			}
		
	}
	
	$pdf->Ln(6);
	$pdf->SetFont('Arial','',8);  
	$pdf->Output("report_IA_pending.pdf","D");

}

function PrintFooter($pdf)
{
	$get_x1=$pdf->GetX();
	$get_y1=$pdf->GetY();
	$pdf->SetY(-18);
	$new_y=$pdf->GetY();
	$pdf->SetDash(1, .3);
	$pdf->Line(5,$new_y, 290,$new_y);
	$pdf->Line(5,$new_y+.5, 290,$new_y+.5);
	$pdf->Ln(1);
	$pdf->SetFont('Times','',8);
	$ip=$_SERVER["REMOTE_ADDR"];
	$pdf->Cell(140,4,'Printed   : IP Address : '.$ip.", Date : ".$pdf->date_1,'0',0,'L');
	$pdf->SetXY($get_x1,$get_y1); 
}

${this.title}

Code Editor : report_marksPending.php