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

<?php 
function generateCandidateListReport($aobj_context)
{	
	session_start();
	$college_code = $_SESSION['collcode']; 
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    
	//echo $college_code; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 
	$RegNo_start = substr("00000000".$aobj_context->mobj_data["streg"],-8); 
	$RegNo_end = substr("ZZZZZZZZ".$aobj_context->mobj_data["edreg"],-8); 
	
	$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_candidate_list.pdf";

include($pdf_writer_class);		
	$pdf= new FPDF('L'); //Landscape
	
	$pdf->SetFont('Times','',10);
	$pdf->SetMargins(5,12);		
	$pdf->AliasNbPages();
//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);
	
	$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 concat('[',FDEGREE,'] - ', FDESCPN) as Degree_name, FADYEAR  
							from degree where FDEGREE = '{$degree_code}' ";
	$lobj_page_header_degree = $aobj_context->mobj_db->GetRow($page_header_degree);
	
	$page_header_REGROLL = "select FREGROLL from control";
		$lobj_page_header_REGROLL = $aobj_context->mobj_db->GetRow($page_header_REGROLL);
	
	$pdf->WhichReport = 'ReportCandidateList';
	$pdf->FUNIVNAME = $lobj_page_header_university[FUNIVNAME];
	$pdf->FTOWN = $lobj_page_header_university[FTOWN];
	$pdf->date_1 = $lobj_page_header_university['date'];
	$pdf->college_name = $lobj_page_header_college['college_name'];
	$pdf->Degree_name = $lobj_page_header_degree['Degree_name'];
	$pdf->REGROLL=$lobj_page_header_REGROLL['FREGROLL'];
	$pdf->RFROM= $RegNo_start;
	$pdf->RTO= $RegNo_end;
//end header		
	$pdf->AddPage();		
	$pdf->SetFont('Times','',9);	
// body
	$get_fee_paid_REC_DATE ="select FREGNO,date_format(FRECPTDATEA,'%d/%m/%y') as FdateA, FRECPTNOA,
								date_format(FRECPTDATEB,'%d/%m/%y') as FdateB, FRECPTNOB,
								date_format(FRECPTDATEC,'%d/%m/%y') as FdateC, FRECPTNOC,
								date_format(FRECPTDATED,'%d/%m/%y') as FdateD, FRECPTNOD,    
								date_format(FRECPTDATEE,'%d/%m/%y') as FdateE, FRECPTNOE, 
								date_format(FRECPTDATEF,'%d/%m/%y') as FdateF, FRECPTNOF, 
								date_format(FRECPTDATEG,'%d/%m/%y') as FdateG, FRECPTNOG,
								date_format(FRECPTDATEH,'%d/%m/%y') as FdateH, FRECPTNOH,
								date_format(FRECPTDATEI,'%d/%m/%y') as FdateE, FRECPTNOI,
								date_format(FRECPTDATEJ,'%d/%m/%y') as FdateJ, FRECPTNOJ    
								from candsum
								WHERE  fdegree='{$degree_code}'
								and FREGNO>='{$RegNo_start}' and FREGNO<='{$RegNo_end}' 
								and  FCOLLCODE='{$college_code}' ";
	$lobj_get_fee_paid_REC_DATE = $aobj_context->mobj_db->GetAll($get_fee_paid_REC_DATE);
	
     $rec_date_array=array();	
	foreach($lobj_get_fee_paid_REC_DATE as $key => $value)
	{
			$rec_date_array[$value['FREGNO']]['A']['Date'] = $value['FdateA'];
			$rec_date_array[$value['FREGNO']]['A']['Rec'] = $value['FRECPTNOA'];
			
			$rec_date_array[$value['FREGNO']]['B']['Date'] = $value['FdateB'];
			$rec_date_array[$value['FREGNO']]['B']['Rec'] = $value['FRECPTNOB'];
			
			$rec_date_array[$value['FREGNO']]['C']['Date'] = $value['FdateC'];
			$rec_date_array[$value['FREGNO']]['C']['Rec'] = $value['FRECPTNOC'];
			
			$rec_date_array[$value['FREGNO']]['D']['Date'] = $value['FdateD'];
			$rec_date_array[$value['FREGNO']]['D']['Rec'] = $value['FRECPTNOD'];
			
			$rec_date_array[$value['FREGNO']]['E']['Date'] = $value['FdateE'];
			$rec_date_array[$value['FREGNO']]['E']['Rec'] = $value['FRECPTNOE'];
			
			$rec_date_array[$value['FREGNO']]['F']['Date'] = $value['FdateF'];
			$rec_date_array[$value['FREGNO']]['F']['Rec'] = $value['FRECPTNOF'];
			
			$rec_date_array[$value['FREGNO']]['G']['Date'] = $value['FdateG'];
			$rec_date_array[$value['FREGNO']]['G']['Rec'] = $value['FRECPTNOG'];
			
			$rec_date_array[$value['FREGNO']]['H']['Date'] = $value['FdateH'];
			$rec_date_array[$value['FREGNO']]['H']['Rec'] = $value['FRECPTNOH'];
			
			$rec_date_array[$value['FREGNO']]['I']['Date'] = $value['FdateI'];
			$rec_date_array[$value['FREGNO']]['I']['Rec'] = $value['FRECPTNOI'];
			
			$rec_date_array[$value['FREGNO']]['J']['Date'] = $value['FdateJ'];
			$rec_date_array[$value['FREGNO']]['J']['Rec'] = $value['FRECPTNOJ'];
	}

$get_candidate_data= "  select a.*,b.FEXAMNAME,b.Fee_ShortName,b.fee,b.total_fee 
								from (SELECT s.FSLNO,s.FNAME,s.FFATNAME,s.FMOTNAME,date_format(s.FDOB,'%d/%m/%y') as FDOB,
								s.FSEX,	s.FCASTE,cd.FDEGREE, cd.FEXAMNO,cd.FCOLLCODE, cd.FREGNO, cs.FTOTALFEE, 
								GROUP_CONCAT(cd.FSUBCODE order by cd.FSUBCODE separator '|') as subjects 
								from canddet cd inner join student s on s.FREGNO=cd.FREGNO 
								and s.FDEGREE=cd.FDEGREE 
								and s.FCOLLCODE=cd.FCOLLCODE inner join candsum cs on 
								cs.FDEGREE=cd.FDEGREE  and cs.FCOLLCODE=cd.FCOLLCODE and
								cs.FREGNO=cd.FREGNO
								WHERE FPRESENT='P'and cd.fregno>='{$RegNo_start}' and cd.fregno<='{$RegNo_end}' 
								and cd.fdegree='{$degree_code}' and  cd.FCOLLCODE='{$college_code}'
								GROUP BY cd.FDEGREE,cd.FEXAMNO, 
								cd.FCOLLCODE,cd.FREGNO ORDER BY cd.FREGNO) a inner join 
								(select sf.FDEGREE,sf.FEXAMNO,sf.FCOLLCODE,sf.FREGNO,deg.FEXAMNAME, 
								GROUP_CONCAT(mf.FSHORTNAME order by mf.FFEECODE) as Fee_ShortName,
								GROUP_CONCAT(sf.FAMOUNT order by sf.FFEECODE) as fee,
								sum(FAMOUNT) as total_fee
								from masfee mf inner join studfee sf on sf.FFEECODE=mf.FFEECODE inner join degree deg on 
								deg.FDEGREE=sf.FDEGREE and deg.FEXAMNO=sf.FEXAMNO
								where sf.fregno>='{$RegNo_start}' and sf.fregno<='{$RegNo_end}' and sf.fdegree='{$degree_code}' 
								 and  sf.FCOLLCODE='{$college_code}'			
								group by FDEGREE,FEXAMNO,FCOLLCODE,FCOLLCODE,FREGNO) b on
								 a.FDEGREE=b.FDEGREE and a.FEXAMNO=b.FEXAMNO and a.FCOLLCODE=b.FCOLLCODE and a.FREGNO=b.FREGNO 
						";

//echo $get_candidate_data; die();
	$lobj_get_candidate_data = $aobj_context->mobj_db->GetAll($get_candidate_data);
	
	$check_same_reg_no_for_pb = $lobj_get_candidate_data[0]['FREGNO'];
	$for_page_break = array();
	$page_break_counter=2;
	foreach($lobj_get_candidate_data as $key => $value)
	{
		if($check_same_reg_no_for_pb ==$value['FREGNO'])		
		{
			$page_break_counter++;
			
		}
		else 
		{
			$page_break_counter=3;
			$check_same_reg_no_for_pb=$value['FREGNO'];
		}
		$for_page_break[$value['FREGNO']]=$page_break_counter;
		
	}
	 
	
	$check_same_reg_no = $lobj_get_candidate_data[0]['FREGNO'];
	$check_same_sl_no = $lobj_get_candidate_data[0]['FSLNO'];
	$first_time_printing = 1;
	$arr_w = array(12,25,115,35,65,10,20,45,15,18);
	$arr_h = array(5,6);
	foreach($lobj_get_candidate_data as $key => $value)
	{					
		if(($first_time_printing) || $check_same_reg_no !=$value['FREGNO'] && $check_same_sl_no != $value['FSLNO'])		
		{
				$pdf->Cell($arr_w[0],$arr_h[1],$value['FSLNO'],'LRT',0,'C');
				$pdf->Cell($arr_w[1],$arr_h[1],$value['FREGNO'],'LRT',0,'C');		
				$pdf->Cell($arr_w[2],$arr_h[1],$value['FNAME'],'1',0,'L');		
				$pdf->Cell($arr_w[4],$arr_h[1],'FAT.:   '.$value['FFATNAME'],'1',0,'L');		
				$pdf->Cell($arr_w[4],$arr_h[1],'MOT.:   '.$value['FMOTNAME'],'1',1,'L');	
				
				$pdf->Cell($arr_w[0],$arr_h[1],'','LR',0,'C');
				$pdf->Cell($arr_w[1],$arr_h[1],'','LR',0,'L');		
				$pdf->Cell($arr_w[3],$arr_h[1],'DOB.:   '.$value['FDOB'],'1',0,'L');
				$pdf->Cell($arr_w[6],$arr_h[1],'Gen.:   '.$value['FSEX'],'1',0,'L');		
				$pdf->Cell($arr_w[6],$arr_h[1],'Grp.:   '.$value['FCASTE'],'1',0,'L');
			$pdf->SetFont('Times','B',9);
				$pdf->Cell($arr_w[7],$arr_h[1],'Total Fee:  '.$value['FTOTALFEE'],'1',0,'C');
			$pdf->SetFont('Times','',9);
// stars FEE NAMEs			
			$free_name_array = explode(",",$value['Fee_ShortName']);	
			for($m=0; $m<count($free_name_array); $m++)
			{				
				$pdf->Cell($arr_w[8],$arr_h[1],$free_name_array[$m],'1',0,'C');			
					
			}
$pdf->SetFont('Times','B',9);			
			$pdf->Cell($arr_w[8],$arr_h[1],'Exam Fee','1',0,'C');	
$pdf->SetFont('Times','',9);			
			$pdf->Cell($arr_w[8],$arr_h[1],'Date','1',0,'C');
			$pdf->Cell($arr_w[6],$arr_h[1],'Rec. No.','1',1,'C');
// End FEE NAMEs			
			$first_time_printing=0;	
			$check_same_reg_no=$value['FREGNO'];
			$check_same_sl_no = $value['FSLNO'];	
		}
//subjects		
		$pdf->Cell(($arr_w[0]+$arr_w[1]),$arr_h[1],$value['FEXAMNAME'],'1',0,'L');				
		$subject_array = explode("|",$value['subjects']);						
		$remeber_cell=0;
		for($m=0;$m<count($subject_array);$m++)
		{			
			$pdf->Cell($arr_w[5],$arr_h[1],$subject_array[$m],'1',0,'C');
			//echo $subject_array[$m].' ';
			$remeber_cell++;
		}
		for($j=$remeber_cell; $j<12; $j++)
		{
			$pdf->Cell($arr_w[5],$arr_h[1],'','1',0,'C');
		}		
//end subjects
//fee stratrs here
		$free_array = explode(",",$value['fee']);	
		for($m=0; $m<count($free_array); $m++)
		{		
			$pdf->Cell($arr_w[8],$arr_h[1],$free_array[$m],'1',0,'R');			
				
		}
$pdf->SetFont('Times','B',9);		
		$pdf->Cell($arr_w[8],$arr_h[1],$value['total_fee'],'1',0,'R');				
$pdf->SetFont('Times','',9);		
		$pdf->Cell($arr_w[8],$arr_h[1],$rec_date_array[$value['FREGNO']][$value['FEXAMNO']]['Date'],'1',0,'R');
		$pdf->Cell($arr_w[6],$arr_h[1],$rec_date_array[$value['FREGNO']][$value['FEXAMNO']]['Rec'] ,'1',1,'R');
		//var_dump($rec_date_array[$value['FREGNO']][$value['FEXAMNO']]['Date']); die();
	}
//end of fee		
	
$pdf->Output($root_pdf_file_download);
header("Content-type: application/vnd.pdf");
		header("Content-Disposition: attachment; filename=report_admission_list.pdf");
		header("Expires: 0");
		header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
		header("Pragma: public");
 readfile($root_pdf_file_download);
 unlink($root_pdf_file_download);		
}
?>

${this.title}

Code Editor : report_candidate_list_final.php