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 : qp_issue.php

<?php
$main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7);
$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php";
require_once($pdf_writer_class);
include_once("stringspliter.php");
	
class report_ra_qp_wise_student_count  extends FPDF
{
		 
	function DefaultConstructor($aobj_context)
	{
		session_start();
		$this->aobj_context=$aobj_context;
		$this->pdf=  new FPDF();
		$this->pdf=$this;
		$this->exdate=trim($this->aobj_context->mobj_data["exdate"]);
		$this->session=trim($this->aobj_context->mobj_data["session"]);
		
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$get_date="select date_format(now(),'%d/%m/%Y %h:%i %p') as now_date";
		// $get_date="select current_timestamp as now_date";
		$obj=$this->aobj_context->mobj_db->GetRow($get_date);
		$this->current_date=$obj['now_date'];	
		$this->collcode=$_SESSION['collcode'];	
	}
	 
	function Header()
	{
		session_start();
		$FUNIVCODE = $_SESSION['FUNIVCODE'];
		
		$img_path=$this->aobj_context->main_src.'/'.$this->aobj_context->mobj_data["db"]."/".$this->photo_path;
		if(!empty($this->photo_path) && file_exists($img_path)) 
		{			
			$this->pdf->Image($img_path,166,50,50);
		}
		$img_logo_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_logo_path))
		{
			$this->pdf->Image($img_logo_path,10,10,23,22);
		}
		$img_path2 = $this->aobj_context->main_src.'/'.$this->aobj_context->mobj_data["db"]."/img/logo2.jpg";
		if(file_exists($img_path2))
		{
			$this->pdf->Image($img_path2,170,6,23,23);
		}
		
		$this->pdf->SetFont('Times','B',12);
		$this->pdf->cell(180,3,$this->FUNIVNAME."","0",1,"C");
		$this->pdf->SetFont('Times','B',7);
		$this->pdf->cell(180,7, $this->s_state,"0",1,"C");
		$this->pdf->SetFont('Times','B',10);
		$this->pdf->cell(180,7, $this->college_details,"0",'1',"C");
		$this->pdf->SetFont('Times','B',10);
		$this->pdf->Cell(180,7,"Question Paper Packet Opening Certificate - ".$this->FEXAMDATE." Examination","0",1,"C");
		$this->pdf->Cell(70,7,"Exam Date : ".$this->exdate,"0",0,"L");
		if($this->session == 'M')
		{
			$session = "Morning Session";
		}
		else
		{
			$session = "After Noon Session";
		}
		$this->pdf->Cell(90,7,"Session : ".$session,"0",1,"R");
		$this->pdf->Ln(2);
		$this->pdf->SetFont('Times','',13);
		
	}
	
	function Footer()
	{
		 
		$this->SetY(-15);
		$this->pdf->SetFont('Times','B',8);
		$this->Cell(140,6,'Printed   : IP Address : '.$this->ip."           Date ".$this->current_date,'0',0,'L');
		// $this->Cell(50,6,'Page '.$this->PageNo().' of {nb}',0,1,'R');
	}
	
	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'];

$get_data="SELECT c.FCOLLCODE,
			CONCAT(c.FCOLLCODE, ' - ', c.FCOLLNAME,', ',c.FTOWN) AS FCOLLNAME FROM college c
			where c.FCOLLCODE='{$this->collcode}'";
		 
		$obj_student=$this->aobj_context->mobj_db->GetRow($get_data);

$this->college_details=$obj_student['FCOLLNAME'];

$this->degree_details=" College : {$this->FCOLLNAME}";

}

$get_data ="select d.FEXAMDATE, s.FQPCODE, concat(s.fsubname, ' [', s.FSSUBNAME,']') as FSSUBNAME from degree d
		inner join subject s on d.fdegree = s.fdegree and d.fexamno = s.fexamno
		inner join canddet c on s.fdegree = c.fdegree 
		and s.fexamno = c.fexamno and s.fsubcode = c.fsubcode
		inner join candsum m on c.fregno = m.fregno and c.fcollcode = m.fcollcode  and c.fdegree = m.fdegree
		where ifnull(frecptdate,'0000-00-00') <> '0000-00-00'
		and c.fpresent = 'P' and ifnull(c.fpassmth,'') = '' and ifnull(fintass,'') = 'F' 
		and ifnull(ftheory,'') = 'T' and ifnull(fsuspend,'F') = 'F'
		and fdoe = date_format(str_to_date('{$this->exdate}', '%d/%m/%Y'), '%Y-%m-%d') and m.fcntrcode = '{$this->collcode}'
		and s.fsession like '{$this->session}%'
		group by FQPCODE";
		//var_dump($get_data);
		$this->lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
		$this->FEXAMDATE = $this->lobj_get_data[0]['FEXAMDATE'];
	}
	
	function formData()
	{

$this->pdf->SetMargins(20,12,10);		
		$this->pdf->AddPage();
		$empty_cell_width=2;
		$sl_no=1;
		$k2 = 1;
		$first = true;
		foreach($this->lobj_get_data as $dk => $dv)
		{
			if($k2 > 20)
			{
				$this->pdf->AddPage();
				$k2 = 1;
			}
			
			if($first == true || $k2 == 1)
			{
				$this->pdf->SetFont('Times','B',11);
				$this->pdf->cell($empty_cell_width,7, ""," ",0,"C");
				$this->pdf->cell(12,7, "Sl. No.","1",0,"C");
				$this->pdf->cell(18,7, "QP Code","1",0,"C");
				$this->pdf->cell(130,7, "Paper Title","1",1,"C");
				$this->pdf->SetFont('Times','',9);
				$first = false;
			}
			
			$subname = trim($dv['FSSUBNAME']);
			$subnamearr = str_splitf($subname,60);
			
			$this->pdf->cell($empty_cell_width,7, ""," ",0,"C");
			$this->pdf->cell(12,7, $sl_no,"LRT",0,"C");
			$this->pdf->cell(18,7, $dv['FQPCODE'],"LRT",0,"C");
			$this->pdf->SetFont('Times','',10);
			$this->pdf->cell(130,7, $subnamearr[0],"LRT",1,"L");
			$this->pdf->SetFont('Times','',10);
			if($k2 == 29)
			{	
				$this->pdf->cell($empty_cell_width,7, "","",0,"C");
				$this->pdf->cell(180,1, "","T",0,"C");
			}
			if($subnamearr[1] != '')
			{
				$this->pdf->cell($empty_cell_width,7, ""," ",0,"C");
				$this->pdf->cell(12,4,'',"LRB",0,"C");
				$this->pdf->cell(18,4,'',"LRB",0,"C");
				$this->pdf->cell(20,4,'',"LRB",0,"C");
				// $this->pdf->cell(30,4,'',"LRB",0,"L");
				$this->pdf->SetFont('Times','',10);
				$this->pdf->cell(130,4, $subnamearr[1],"LRB",1,"L");
				$this->pdf->SetFont('Times','',10);
				// $this->pdf->cell(10,4,'',"LRB",1,"C");
				if($k2 == 30)
				{	
					$this->pdf->cell($empty_cell_width,7, "","",0,"C");
					$this->pdf->cell(180,1, "","T",0,"C");
				}	
			}
			$sl_no++;
			$k2++;
		}
		$this->pdf->cell($empty_cell_width,7, "","",0,"C");
		$this->pdf->cell(160,1, "","T",1,"C");
		$this->pdf->SetFont('Times','B',9);
		if(count($this->lobj_get_data) > 0)
		{
			$this->pdf->MultiCell(150, 5, "Certified that the seal of question paper packet for the above mentioned QP Codes were intact. They were opened in the presence of the undersigned and the contents were found to be correct", 0, 'C');
			$this->pdf->cell(160,1, "","T",1,"C");

$this->pdf->cell(160,8, "Witnesses : ",0,1,"L");
			// $this->pdf->Ln(4);
			$this->pdf->cell(160,8, "1. ................................................................................... ",0,1,"L");
			$this->pdf->cell(160,8, "Chief Superintendent",0,1,"R");
			$this->pdf->cell(100,8, "2. ................................................................................... ",0,0,"L");
			$this->pdf->cell(160,8, "Date :  ",0,1,"L");
			$this->pdf->cell(100,8, "",0,0,"L");
			$this->pdf->cell(160,8, "Time :  ",0,1,"L");

// $this->pdf->cell(160,1, "","T",1,"C");
			$this->pdf->cell(160,10, "Note : This form shall be retained in the college office for a period of six months from the date of Examnination ",'TB',1,"L");
			// $this->pdf->cell(160,1, "","T",1,"C");
		}
	}
			 
	function SendOutput()
	{
		$this->pdf->Output("QPCertificate.pdf","I");
	}
	
}

function GenerateQpIssue($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$class_obj=new report_ra_qp_wise_student_count();
	$class_obj->AliasNbPages();
	$class_obj->DefaultConstructor($aobj_context);

$class_obj->GetFullQry();
	 $class_obj->formcolldata();
	$class_obj->formData();
	 
	$class_obj->SendOutput();
}

${this.title}

Code Editor : qp_issue.php