Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-sr-x
DownloadExamAppFormApplication...	8.96 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	5.48 KB	-rwxr-xr-x
ExcelWriterXML.php	16.8 KB	-rwxr-xr-x
ExcelWriterXML_Sheet.php	16.26 KB	-rwxr-xr-x
ExcelWriterXML_Style.php	24.5 KB	-rwxr-xr-x
PrintApplicationFormAdmPOSTOFF...	13.15 KB	-rwxr-xr-x
PrintChallanEntryDetails.php	8.63 KB	-rwxr-xr-x
RVApplicationsReport.php	8.42 KB	-rwxr-xr-x
RvRtApplicationReport.php	9.11 KB	-rwxr-xr-x
ack_application.php	4.96 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12 KB	-rwxr-xr-x
ack_rv_rt_report.php	10.35 KB	-rwxr-xr-x
admChallanEntryDetails.php	7.26 KB	-rwxr-xr-x
adm_comb_details.php	6.41 KB	-rwxr-xr-x
admregisterlist.php	15.35 KB	-rwxr-xr-x
admreportlist.php	15.35 KB	-rwxr-xr-x
answer_book_statistics.php	7.08 KB	-rwxr-xr-x
appear_list_center_qp_wise.php	7.53 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.82 KB	-rwxr-xr-x
appfeedetails.php	9 KB	-rwxr-xr-x
appfeedetails_pdf.php	7.78 KB	-rwxr-xr-x
appfeedetailspdf.php	7.89 KB	-rwxr-xr-x
approval_report.php	18.34 KB	-rwxr-xr-x
approval_report_wait.php	11.88 KB	-rwxr-xr-x
basic_data_coll.php	7 KB	-rwxr-xr-x
basic_data_sum.php	7.2 KB	-rwxr-xr-x
batch_wise_details.php	4.63 KB	-rwxr-xr-x
bundle_ despatch_ statement.ph...	5.92 KB	-rwxr-xr-x
bundle_ack.php	10.22 KB	-rwxr-xr-x
bundle_ack_wait.php	8.64 KB	-rwxr-xr-x
bundleno_despatch_statement.ph...	11.82 KB	-rwxr-xr-x
bundleno_dispatch_datewise.php	11.59 KB	-rwxr-xr-x
cManualMailer.php	1.5 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
cconfig.php	1.18 KB	-rwxr-xr-x
cntDeclaration.php	14.2 KB	-rwxr-xr-x
cntrtagcollstud.php	4.95 KB	-rwxr-xr-x
code39.php	6.56 KB	-rwxr-xr-x
college_degree_details.php	4.74 KB	-rwxr-xr-x
college_pending_markslist.php	6.89 KB	-rwxr-xr-x
collegedet.php	4.9 KB	-rwxr-xr-x
examAppChallan.php	12.57 KB	-rwxr-xr-x
examAppChallanReport.php	8.82 KB	-rwxr-xr-x
exam_attendance_det.php	7.94 KB	-rwxr-xr-x
exam_attendance_summary.php	9.44 KB	-rwxr-xr-x
fee_report_catwise.php	13.49 KB	-rwxr-xr-x
fee_summary.php	13.54 KB	-rwxr-xr-x
fee_summary_oldformat.php	7.67 KB	-rwxr-xr-x
fee_summary_report.php	35.26 KB	-rwxr-xr-x
generatePostAdmissionTicket.ph...	28.14 KB	-rwxr-xr-x
getnumword.php	7.79 KB	-rwxr-xr-x
hallticketcomm.php	30.32 KB	-rwxr-xr-x
htcollsum.php	6.49 KB	-rwxr-xr-x
htstatus.php	7.03 KB	-rwxr-xr-x
htsum.php	3.71 KB	-rwxr-xr-x
iaemptyformat.php	7.46 KB	-rwxr-xr-x
index.php	4.64 KB	-rwxr-xr-x
marls_subjectwise.php	10.49 KB	-rwxr-xr-x
photo_report.php	4.9 KB	-rwxr-xr-x
photo_report_old.php	4.63 KB	-rwxr-xr-x
practical_marks_details.php	12.43 KB	-rwxr-xr-x
practical_marks_report.php	5.74 KB	-rwxr-xr-x
qp_issue.php	8.01 KB	-rwxr-xr-x
qpindent.php	5.19 KB	-rwxr-xr-x
re_cronjob_sendsms_dud.php	4.96 KB	-rwxr-xr-x
reconciliation.php	9.67 KB	-rwxr-xr-x
reg_stud_list.php	8.63 KB	-rwxr-xr-x
report_ack_registration.php	6.63 KB	-rwxr-xr-x
report_adm_combination.php	10.51 KB	-rwxr-xr-x
report_adm_summary.php	8.74 KB	-rwxr-xr-x
report_admission_details.php	27.47 KB	-rwxr-xr-x
report_admission_list.php	17.53 KB	-rwxr-xr-x
report_admission_list_wop.php	10.58 KB	-rwxr-xr-x
report_admission_listnehu.php	25.35 KB	-rwxr-xr-x
report_admission_ticket.php	28.37 KB	-rwxr-xr-x
report_answer_book_issued.php	8.62 KB	-rwxr-xr-x
report_attendance_sheet.php	13.11 KB	-rwxr-xr-x
report_attendance_shortage.php	9.52 KB	-rwxr-xr-x
report_attendance_summary.php	7.42 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7.34 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.78 KB	-rwxr-xr-x
report_batch_wise_details.php	8.18 KB	-rwxr-xr-x
report_batch_worksheet_details...	11.52 KB	-rwxr-xr-x
report_bulk_applications.php	26.25 KB	-rwxr-xr-x
report_bundle_dispatch.php	11.92 KB	-rwxr-xr-x
report_candidate_list.php	29.82 KB	-rwxr-xr-x
report_candidate_list_backup.p...	30.35 KB	-rwxr-xr-x
report_daliy_report.php	11.14 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.67 KB	-rwxr-xr-x
report_data_sent.php	8.71 KB	-rwxr-xr-x
report_degree_list.php	4.88 KB	-rwxr-xr-x
report_deviation_report.php	7.96 KB	-rwxr-xr-x
report_evaluation_report.php	9.6 KB	-rwxr-xr-x
report_iamarks_pending.php	8.4 KB	-rwxr-xr-x
report_marks_deviation_report....	5.58 KB	-rwxr-xr-x
report_marks_elementwise.php	4.46 KB	-rwxr-xr-x
report_marks_elementwisenew.ph...	4.8 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.72 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	18.76 KB	-rwxr-xr-x
report_marks_pending.php	12.33 KB	-rwxr-xr-x
report_online_eam.php	11.99 KB	-rwxr-xr-x
report_pr_pending.php	7.65 KB	-rwxr-xr-x
report_practical_marks_details...	13.83 KB	-rwxr-xr-x
report_practical_marks_details...	14.51 KB	-rwxr-xr-x
report_practical_misc.php	8.61 KB	-rwxr-xr-x
report_qpcount_univ.php	6.08 KB	-rwxr-xr-x
report_ra_exl_report.php	5.77 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	22.52 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	15.55 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.62 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.91 KB	-rwxr-xr-x
report_revaluation.php	6.58 KB	-rwxr-xr-x
report_sectionwiselist.php	4.73 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.57 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.76 KB	-rwxr-xr-x
reportexamcntrdet.php	5.46 KB	-rwxr-xr-x
resport_attendance_studentwise...	6.14 KB	-rwxr-xr-x
results_pdf.php	19.91 KB	-rwxr-xr-x
resultsheet.php	9.39 KB	-rwxr-xr-x
revaluation.php	15.97 KB	-rwxr-xr-x
roomallotmantecelsheet.php	5.58 KB	-rwxr-xr-x
roomallotmantsummary.php	4.81 KB	-rwxr-xr-x
roomwise_register_nos_list.php	19.13 KB	-rwxr-xr-x
rotation.php	634 B	-rwxr-xr-x
shortageReport.php	11.85 KB	-rwxr-xr-x
stringspliter.php	731 B	-rwxr-xr-x
student.php	5.48 KB	-rwxr-xr-x
student_count.php	4.16 KB	-rwxr-xr-x
subiapending.php	8.14 KB	-rwxr-xr-x
subject_wise_student_list.php	6.38 KB	-rwxr-xr-x
subjectwise_invigilator_dairy....	10.71 KB	-rwxr-xr-x
tatkal.php	4.93 KB	-rwxr-xr-x
teacher_report.php	10.19 KB	-rwxr-xr-x
teacher_val_report.php	10.31 KB	-rwxr-xr-x
teacherreport.php	6.2 KB	-rwxr-xr-x
testbarcode.php	20.58 KB	-rwxr-xr-x
topsheet.php	8.62 KB	-rwxr-xr-x

Code Editor : ack_rv_rt_report.php

<?php
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
$pdf_writer_class =$main_src."/tarka_pdf_latest/fpdf.php";
require_once($pdf_writer_class);
ini_set('max_execution_time', 0); 
class GenerateRvRtReport  extends FPDF
{
	
	function DefaultConstructor($aobj_context)
	{
		include_once($aobj_context->main_src."/src/format.php");
		$this->aobj_context=$aobj_context;
		$this->pdf=  new FPDF();
		$this->pdf=$this;
		session_start();
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$get_date="select date_add(date_add(now(),INTERVAL 13 hour),interval 30 minute) as now_date";
		$obj=$this->aobj_context->mobj_db->GetRow($get_date);
		$this->current_date=$obj['now_date'];
		$this->collcode=$_SESSION['collcode'];

$this->deg_type = $aobj_context->mobj_data["deg_type"];

$this->degree_from = $aobj_context->mobj_data["degree_from"]; 
		$this->degree_to = $aobj_context->mobj_data["degree_to"];

$this->exam_from =  $aobj_context->mobj_data["exam_from"];
		$this->exam_to =$aobj_context->mobj_data["exam_to"];

$this->app_from =  $aobj_context->mobj_data["app_from"];
		$this->app_to =$aobj_context->mobj_data["app_to"];
		
		$this->payment_type = $aobj_context->mobj_data["payment_type"];
		$this->payment_status_type = $aobj_context->mobj_data["payment_status_type"];
		if($this->payment_status_type=='success')
			$this->payment_status_type='Success';
		if($this->payment_status_type=='pending')
			$this->payment_status_type='Pending';
		
	}
	 
	function Header()
	{

$img_path=$this->aobj_context->main_src."/".$this->aobj_context->mobj_data["db"]."/".$this->pdf_logo_path;
		 
			if(!empty($this->pdf_logo_path) && file_exists($img_path)) 
			{			
				$this->pdf->Image($img_path,70,20,30);
			}

$this->pdf->SetFont('Times','B',15);
			$this->pdf->cell(0,7,"".$this->FUNIVNAME,"0",1,"C");
			$this->pdf->SetFont('Times','',8);
			$this->pdf->cell(0,4, $this->s_state,"0",0,"C");
			$this->pdf->SetFont('Times','',10);	
			$this->pdf->Cell(-20,4,"Page {$this->pdf->PageNo()}/{nb}",0,1,'C');
			$this->pdf->SetFont('Times','B',12);
			$this->pdf->cell(0,5,"RV/RT Application Report","0",1,"C");
			$this->pdf->SetFont('Times','B',10);
			$this->pdf->cell(0,5,"Degree Group:" ." ".$this->deg_type,"0",1,"C");
			$this->pdf->cell(0,5,"Degree Range :" ." ".$this->degree_from." "."to"." ".$this->degree_to,"0",1,"C");

$this->pdf->cell(0,5,"Exam No Range :"  ." ".$this->exam_from." "."to"." ".$this->exam_to,"0",1,"C");
			
			$this->pdf->cell(0,5,"Application No Range :"  ." ".$this->app_from." "."to"." ".$this->app_to,"0",1,"C");

$this->pdf->cell(0,5,"Payment Type :" ." ".$this->payment_type,"0",1,"C");
			$this->pdf->cell(0,5,"Payment Status :" ." ".$this->payment_status_type,"0",1,"C");
				
	}

function Footer()
	{
		 
			$this->SetY(-15);
			$this->pdf->SetFont('Times','B',8);
			$new_y=$this->pdf->GetY();
			$this->pdf->Line(8,$new_y, 290,$new_y);
			$this->pdf->Ln(2);
			$this->Cell(180,6,'Printed   : IP Address : '.$this->ip." Date ".$this->current_date,'0',0,'L');
			
	}
	
	function formcolldata()
	{
		$get_coll_name="select FUNIVNAME as 'FUNIVNAME',
		FUNIVADD1 as 'state', pdf_logo_path From control";
		$lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name);
		$this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME'];
		$this->s_state=$lobj_get_coll_name['state'];
		$this->f_year=$lobj_get_coll_name['f_year'];
		$this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path'];

}
	function formdata()
	{
	if($this->payment_type =="All")
	$cnd = "";
	else
		$cnd = "and r.fpaymentype='{$this->payment_type}'";

if($this->payment_status_type =="All")
	$cnd1 = "";
	else
		$cnd1 = "and IFNULL(r.fpaymentstatus,'Pending')='{$this->payment_status_type}'";

$get_data="SELECT r.appno,DATE_FORMAT(r.fappdate,'%d/%m/%Y')AS appdate,
				r.fdegree,r.fexamno,d.fdeggrp,r.fregno,s.fname,CAST(r.ftotal AS INT) AS amount,
				r.fpaymentype,IFNULL(r.fpaymentstatus,'Pending') AS paymentstatus,r.fcorrtype,
				concat(r.fsubcode,'-',sub.fsubname) as fsubname FROM res_stud r INNER JOIN student s ON s.fdegree=r.fdegree
				AND s.fregno=r.fregno AND s.fcollcode=r.fcollcode INNER JOIN degree d ON 
				d.fdegree=r.fdegree AND d.fexamno=r.fexamno INNER JOIN SUBJECT sub ON 
				sub.fexamno=r.fexamno AND sub.fdegree=r.fdegree and sub.fcsubcode=r.fsubcode WHERE d.fdeggrp='{$this->deg_type}' 
				AND r.fdegree>='{$this->degree_from}' AND r.fdegree<='{$this->degree_to}' 
			 	AND r.fexamno>='{$this->exam_from}' AND r.fexamno<='{$this->exam_to}' AND 
			 	r.appno>='{$this->app_from}' 
			 	AND r.appno<='{$this->app_to}' AND r.FCOLLCODE='{$this->collcode}'  
			 	{$cnd} {$cnd1} ORDER BY appno,fregno";
			 	//var_dump($get_data);

$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);

$this->pdf->AddPage('L');
		//$this->pdf->SetFillColor(248, 248 ,255);
		$this->pdf->Ln(2);
		$this->pdf->SetFont('Times','B',10);
		$this->pdf->Cell(10,6,"Sl. No","1",0,"C");
		$this->pdf->Cell(25,6,"App.No","1",0,"C");
		$this->pdf->Cell(20,6,"AppliedDate","1",0,"C");
		$this->pdf->Cell(20,6,"Reg.No","1",0,"C");
		$this->pdf->Cell(20,6,"Degree","1",0,"C");
		$this->pdf->Cell(20,6,"Corr.Type","1",0,"C");
		//$this->pdf->Cell(20,6,"Sub.Code","1",0,"C");
		$this->pdf->Cell(90,6,"Subject Name","1",0,"C");
		$this->pdf->Cell(15,6,"Amount","1",0,"C");
		$this->pdf->Cell(30,6,"Payment Type","1",0,"L");
		$this->pdf->Cell(25,6,"Payment Status","1",1,"L");
		$sl_no=0;
		$total=0;
		foreach ($lobj_get_data as $key => $value) {
			//var_dump($lobj_get_data);
			$sl_no++;
			$payment1=substr($value['fpaymentype'],0,12);
			$payment2=substr($value['fpaymentype'],12);

$fsubname1=substr($value['fsubname'],0,45);
			$fsubname2=substr($value['fsubname'],45);
			$amount=$value['amount'];
			$amount1=moneyFormatIndia($amount);
			if(empty($payment2) && empty($fsubname2))
			{
			$this->pdf->SetFont('Times','',10);

$this->pdf->Cell(10,6,$sl_no,"1",0,"C");
			$this->pdf->Cell(25,6,$value['appno'],"1",0,"C");
			$this->pdf->Cell(20,6,$value['appdate'],"1",0,"C");
			$this->pdf->Cell(20,6,$value['fregno'],"1",0,"C");
			$this->pdf->Cell(20,6,$value['fdegree'],"1",0,"C");
			$this->pdf->Cell(20,6,$value['fcorrtype'],"1",0,"C");
			//$this->pdf->Cell(20,6,$value['fsubcode'],"1",0,"C");
			$this->pdf->Cell(90,6,$fsubname1,"1",0,"L");
			$this->pdf->Cell(15,6,$amount1,"1",0,"R");
			$this->pdf->Cell(30,6,$payment1,"1",0,"L");
			$this->pdf->Cell(25,6,$value['paymentstatus'],"1",1,"C");
			}
			else{

$this->pdf->SetFont('Times','',10);

$this->pdf->Cell(10,6,$sl_no,"LRT",0,"C");
			$this->pdf->Cell(25,6,$value['appno'],"LRT",0,"C");
			$this->pdf->Cell(20,6,$value['appdate'],"LRT",0,"C");
			$this->pdf->Cell(20,6,$value['fregno'],"LRT",0,"C");
			$this->pdf->Cell(20,6,$value['fdegree'],"LRT",0,"C");
			$this->pdf->Cell(20,6,$value['fcorrtype'],"LRT",0,"C");
			//$this->pdf->Cell(20,6,$value['fsubcode'],"LRT",0,"C");
			$this->pdf->Cell(90,6,$fsubname1,"LRT",0,"L");
			$this->pdf->Cell(15,6,$amount1,"LRT",0,"R");
			$this->pdf->Cell(30,6,$payment1,"LRT",0,"L");
			$this->pdf->Cell(25,6,$value['paymentstatus'],"LRT",1,"C");

$this->pdf->Cell(10,3,"","LRB",0,"C");
			$this->pdf->Cell(25,3,"","LRB",0,"C");
			$this->pdf->Cell(20,3,"","LRB",0,"C");
			$this->pdf->Cell(20,3,"","LRB",0,"C");
			$this->pdf->Cell(20,3,"","LRB",0,"C");
			$this->pdf->Cell(20,3,"","LRB",0,"C");
			//$this->pdf->Cell(20,6,"","LRB",0,"C");
			$this->pdf->Cell(90,3,$fsubname2,"LRB",0,"L");
			$this->pdf->Cell(15,3,"","LRB",0,"R");
			$this->pdf->Cell(30,3,$payment2,"LRB",0,"L");
			$this->pdf->Cell(25,3,"","LRB",1,"C");

}
			$total+=$value['amount'];
			$total1=moneyFormatIndia($total);
			//var_dump($total);
			if($this->pdf->getY() > 180)
			{
					$this->pdf->AddPage('L');
					$this->pdf->Ln(2);
					$this->pdf->SetFont('Times','B',10);
					$this->pdf->Cell(10,6,"Sl. No","1",0,"C");
					$this->pdf->Cell(25,6,"App.No","1",0,"C");
					$this->pdf->Cell(20,6,"AppliedDate","1",0,"C");
					$this->pdf->Cell(20,6,"Reg.No","1",0,"C");
					$this->pdf->Cell(20,6,"Degree","1",0,"C");
					$this->pdf->Cell(20,6,"Corr.Type","1",0,"C");
					//$this->pdf->Cell(20,6,"Sub.Code","1",0,"C");
					$this->pdf->Cell(90,6,"Subject Name","1",0,"C");
					$this->pdf->Cell(15,6,"Amount","1",0,"C");
					$this->pdf->Cell(30,6,"Payment Type","1",0,"L");
					$this->pdf->Cell(25,6,"Payment Status","1",1,"L");
			}
		
		}
		$this->pdf->SetFont('Times','B',10);
		$this->pdf->Cell(10,6,"","LBT",0,"C");
		$this->pdf->Cell(25,6,"","B",0,"C");
		$this->pdf->Cell(20,6,"","B",0,"C");
		$this->pdf->Cell(20,6,"","B",0,"C");
		$this->pdf->Cell(20,6,"","B",0,"C");
		$this->pdf->Cell(20,6,"","B",0,"C");
		//$this->pdf->Cell(20,6,"Sub.Code","1",0,"C");
		$this->pdf->Cell(90,6,"Total","1",0,"C");
		$this->pdf->Cell(15,6,$total1,"1",0,"R");
		$this->pdf->Cell(30,6,"","0",0,"C");
		$this->pdf->Cell(25,6,"","0",1,"C");
	
	}

function SendOutput()
	{
		$this->pdf->Output("ack_rv_rt_report.pdf","D");
	}
		
		 
}
function generateRvRtReport($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$class_obj=new GenerateRvRtReport();
	$class_obj->AliasNbPages();
	$class_obj->DefaultConstructor($aobj_context);
	$class_obj->Header();
	$class_obj->formcolldata();
	$class_obj->formdata();
	$class_obj->SendOutput();
}
function moneyFormatIndia($num) 
{

$explrestunits = "" ;
    if(strlen($num)>3) {
        $lastthree = substr($num, strlen($num)-3, strlen($num));
        $restunits = substr($num, 0, strlen($num)-3); // extracts the last three digits
        $restunits = (strlen($restunits)%2 == 1)?"0".$restunits:$restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping.
        $expunit = str_split($restunits, 2);
        for($i=0; $i<sizeof($expunit); $i++) {
            // creates each of the 2's group and adds a comma to the end
            if($i==0) {
                $explrestunits .= (int)$expunit[$i].","; // if is first value , convert into integer
            } else {
                $explrestunits .= $expunit[$i].",";
            }
        }
        $thecash = $explrestunits.$lastthree;
    } else {
        $thecash = $num;
    }
    return $thecash; // writes the final format where $currency is the currency symbol.
}

${this.title}

Code Editor : ack_rv_rt_report.php