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.92.213
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 : generatePrintIaMarksnew.php
<?php function generatePrintIaMarksnew($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degree_ = $aobj_context->mobj_data['degree']; $deg = explode(' - ', $degree_); $degree = $deg[0]; $sem_ = $aobj_context->mobj_data["sem"]; $seme = explode(' - ', $sem_); $sem = $seme[0]; // var_dump($sem); // die(); $fromregno = $aobj_context->mobj_data["fromreg"]; $toregno = $aobj_context->mobj_data["toreg"]; $college = $_SESSION['collcode']; $pdf_writer_class=$aobj_context->main_src."/tcpdf/tcpdf.php"; include($pdf_writer_class); $pdf= new TCPDF(); $pdf->SetFont('Times','',10); $page_header_university = "select FUNIVNAME as 'FUNIVNAME',FUNIVCODE, FUNIVADD1 as 'state', pdf_logo_path, ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control"; $lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university); $get_coll_name = "select fcollname as FCOLLNAME, ftown as FTOWN from college where fcollcode = '{$college}'"; $res_coll_name = $aobj_context->mobj_db->GetRow($get_coll_name); $db=$aobj_context->mobj_data["db"]; $img_path = $aobj_context->main_src .$db.'/'. $lobj_page_header_university['pdf_logo_path']; $FUNIVNAME = $lobj_page_header_university['FUNIVNAME']; $STATE = $lobj_page_header_university['state']; $COLLNAME = $res_coll_name['FCOLLNAME']; $qry_dlt = " delete from progreport where fdegree = '{$degree}' and fcollcode = '{$college}' and fexamno = '{$sem}' and fregno between '{$fromregno}' and '{$toregno}'"; $res_qry_dlt = $aobj_context->mobj_db->Execute($qry_dlt); $qry_insert = "insert ignore into progreport(fdegree, fcollcode, fregno, fexamno, fsubcode, fsubname, fheld, fattend) select distinct a.fdegree,a.fcollcode,a.fregno,a.fexamno,s.fsubcode,s.fsubname, sum(fnoclass) as conducted, sum(if(a.fpresent = 'P',fnoclass,0)) as attended from attend_det a inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno and a.fsubcode = s.fcsubcode where a.fcollcode = '{$college}' and a.fdegree = '{$degree}' and a.fregno between '{$fromregno}' and '{$toregno}' and a.fexamno = '{$sem}' group by fregno,a.fsubcode"; $res_qry_insert = $aobj_context->mobj_db->Execute($qry_insert); $query = "select distinct p.fsubcode,p.fdegree,p.fexamno from progreport p inner join marksint m on p.fregno = m.fregno and p.fsubcode = left(m.fsubcode,4) and p.fexamno = m.fexamno and p.fdegree = m.fdegree where m.fdegree ='{$degree}' and m.fexamno = '{$sem}' and m.fcollcode = '{$college}'"; $res = $aobj_context->mobj_db->getAll($query); foreach($res as $sub) { $fsubcode = $sub['fsubcode']; $fdegree = $sub['fdegree']; $fexamno = $sub['fexamno']; $query = "select distinct s.fsubname as fssubname, m.fsubcode from subdet s inner join marksint m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and concat(s.fcsubcode,s.fsubcode) = m.fsubcode where left(m.fsubcode,4) = '{$fsubcode}' and m.fdegree = '{$fdegree}' and m.fexamno = '{$fexamno}'"; $res1 = $aobj_context->mobj_db->getAll($query); foreach($res1 as $subdet) { $fssubname = $subdet['fssubname']; $fsubcode = $subdet['fsubcode']; if($fssubname == 'MSE-1' || $fssubname == 'MSE') { $upd = "update progreport p, marksint m set p.fmse1 = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; //var_dump($upd); $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'MSE-2') { $upd = "update progreport p, marksint m set p.fmse2 = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'TASK T1' || $fssubname == 'TASKS T1' || $fssubname == 'TASK-1') { $upd = "update progreport p, marksint m set p.ftask1 = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'TASK T2' || $fssubname == 'TASKS T2' || $fssubname == 'TASK-2') { $upd = "update progreport p, marksint m set p.ftask2 = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'TASK T3' || $fssubname == 'TASKS T3' || $fssubname == 'TASK-3') { $upd = "update progreport p, marksint m set p.ftask3 = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'Record') { $upd = "update progreport p, marksint m set p.frecord = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'Conduction') { $upd = "update progreport p, marksint m set p.fconduction = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'MSE (IPCC)') { $upd = "update progreport p, marksint m set p.fmseipcc = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } if($fssubname == 'MSE (PCC)') { $upd = "update progreport p, marksint m set p.fmsepcc = m.fmarks where p.fdegree = m.fdegree and p.fexamno = m.fexamno and p.fsubcode = left(m.fsubcode,4) and p.fregno = m.fregno and m.fsubcode = '{$fsubcode}' and p.fdegree = '{$fdegree}' and m.fdegree = '{$fdegree}'"; $res10 = $aobj_context->mobj_db->Execute($upd); } } } $get_student_data = " select distinct fregno, fexamno, fdegree from progreport where fregno between '{$fromregno}' and '{$toregno}' and fcollcode = '{$college}' and fdegree = '{$degree}' and fexamno = '{$sem}'"; $lobj_get_student_data = $aobj_context->mobj_db->GetAll($get_student_data); foreach($lobj_get_student_data as $value){ $qry_stud_det = "select s.fregno, s.fname, s.FFATNAME, s.fperadd1, s.fperadd2, s.fperpin, s.ffatmob, s.FEXAMNO, s.fsection, d.FEXAMNAME, concat(s.fpertaluk,' ',s.fperstate)as fperstate from student s inner join degree d on s.fexamno = d.fexamno and s.fdegree = d.fdegree where fregno = '{$value['fregno']}' group by s.fregno"; $res_qry_stud_det = $aobj_context->mobj_db->GetRow($qry_stud_det); $qry_sub = "select fsubname from subdet where fexamno = '{$sem}' and fdegree ='{$degree}' group by fsubname order by fsubcode"; $res_qry_sub_det = $aobj_context->mobj_db->GetAll($qry_sub); $query="select ifnull(fsubname,'')as fsubname, if(ifnull(fmse1, '') = '-1','',fmse1)as fmse1, if(ifnull(fmse2, '') = '-1','',fmse2)as fmse2, if(ifnull(ftask1, '') = '-1','',ftask1)as ftask1, if(ifnull(ftask2, '') = '-1','',ftask2)as ftask2, if(ifnull(ftask3, '') = '-1','',ftask3)as ftask3, if(ifnull(fmsepcc,'') = '-1','',fmsepcc)as fmsepcc, if(ifnull(frecord,'') = '-1','',frecord)as frecord, if(ifnull(fconduction,'') = '-1','',fconduction)as fconduction, if(ifnull(fmseipcc,'') = '-1','',fmseipcc)as fmseipcc, ifnull(fheld, '')as fheld, ifnull(fattend, '')as fattend from progreport where fregno = '{$value['fregno']}' and fdegree = '{$degree}' and fexamno = '{$sem}' and fcollcode='{$college}';"; $res = $aobj_context->mobj_db->GetAll($query); $pdf->AddPage('P'); if (file_exists($img_path)) { $pdf->Image($img_path, 8, 5, 45, 20); } $pdf->SetFont('Times', 'B', 16); // $pdf->SetY(5); $pdf->Cell(0, 7, $FUNIVNAME, 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell(0, 7, $STATE, 0, 1, 'C'); $pdf->SetFont('Times', 'B', 12); $pdf->Cell(0, 7, $COLLNAME, 0, 1, 'C'); $pdf->Cell(0, 7, 'Phone. No: 08258-281264', 0, 0, 'L'); $pdf->Cell(0, 7, 'Date: '.date("d/m/Y"), 0, 1, 'R'); $pdf->Cell(0, 7, "Progress Report", 0, 1, 'C'); $pdf->SetFont('Times', '', 12); $fat_det = '<div style="line-height: 70%;"> <p>To</p>'; $fat_det.='<p>'.strtoupper($res_qry_stud_det['FFATNAME']).'</p>'; if($res_qry_stud_det['fperadd1']!==""){ $fat_det.='<p>'.strtoupper($res_qry_stud_det['fperadd1']).'</p>'; } if($res_qry_stud_det['fperadd2']!==""){ $fat_det.='<p>'.strtoupper($res_qry_stud_det['fperadd2']).'</p>'; } if($res_qry_stud_det['fperstate']!==""){ $fat_det.='<p>'.strtoupper($res_qry_stud_det['fperstate']).'</p>'; } if($res_qry_stud_det['fperpin']!==""){ $fat_det.='<p>'.strtoupper($res_qry_stud_det['fperpin']).'</p>'; } $fat_det.='</div>'; $pdf->writeHTML($fat_det, true, true, true, true, ''); // var_dump($fat_det); $msg = '<div> <div>Dear Parent,</div>'; $msg .= '<div>The progress report of your ward Miss/Mr '.strtoupper($res_qry_stud_det['fname']).' - '.$res_qry_stud_det['fregno']. ' studying in '.$res_qry_stud_det['FEXAMNAME'].' '.$res_qry_stud_det['fsection'].' Section is as shown below:</div>'; // $msg .= '<p></p>'; $msg .= '</div>'; $pdf->writeHTML($msg, true, true, true, true, ''); $pdf->SetFont('Times', 'B', 8); $table = '<style> td { border: 0.5px solid black; } .lable { font-weight: bold; } </style>'; $table .= '<div><table>'; $table.='<tr><td style = "text-align:center" class="lable" width="14px" height="30px">Sl <br/>No</td>'; $table.='<td style = "text-align:center" class="lable" width="142px">Subject</td>'; foreach($res_qry_sub_det as $sub_det){ $table.='<td style = "text-align:center" class="lable" width="35px">'.$sub_det['fsubname'].'</td>'; } $table.='<td style = "text-align:center" class="lable">Class<br/>Held</td>'; $table.='<td style = "text-align:center" class="lable">Class<br/>Attend</td>'; $table.='</tr>'; $pdf->SetFont('Times','',8.5); $count=1; foreach($res as $key => $value) { $table .='<tr>'; $table .='<td style = "text-align:center" height="20px">'.$count.'</td>'; $table .='<td height="20px">'.$value['fsubname'].'</td>'; $table .='<td style = "text-align:center" height="20px">'.$value['fmse1'].'</td>'; if($college == '1001'){ $table .='<td style = "text-align:center" height="20px">'.$value['fmse2'].'</td>'; if($degree!="BTCS1"){ $table .='<td style = "text-align:center" height="20px">'.$value['fmsepcc'].'</td>'; } } $table .='<td style = "text-align:center" height="20px">'.$value['ftask1'].'</td>'; $table .='<td style = "text-align:center" height="20px">'.$value['ftask2'].'</td>'; $table .='<td style = "text-align:center" height="20px">'.$value['ftask3'].'</td>'; if($college == '1001'){ $table .='<td style = "text-align:center" height="20px">'.$value['frecord'].'</td>'; $table .='<td style = "text-align:center" height="20px">'.$value['fconduction'].'</td>'; $table .='<td style = "text-align:center" height="20px">'.$value['fmseipcc'].'</td>'; } $table .='<td style = "text-align:center" height="20px">'.$value['fheld'].'</td>'; $table .='<td style = "text-align:center" height="20px">'.$value['fattend'].'</td>'; $table.='</tr>'; $count++; } $table.='</table>'; $pdf->writeHTML($table, false, true, false, false, 'L'); $pdf->SetFont('Times', '', 12); $details = '<div style="line-height:80%"> <p style="font-size: 13px;font-weight: bold;text-decoration: underline;">Please Note:-</p> <p>1. The above attendance is as on: '.date("d/m/Y"). '.</p> <p>2. As per the university norms students are expected to maintain atleast 85% attendance in each subject.</p> <p>3. "*" indicates poor marks, "AB" absent for the tests, "#" attendance less than 85%,"!" attendance less than</p> <p> 75%.</p> <p>4. Please instruct your ward to improve her/his performance,You can track the performance of your ward by</p> <p> visiting our website <span><b>https://studentportal.universitysolutions.in/</b></span> or download uniclare app.</p> <p>5. For any further queries, please contact the Head of the Department.</p> </div>'; $pdf->writeHTML($details, true, true, true, true, ''); $pdf->ln(10); $pdf->Cell(0,4,'Signature of HOD','',0,'L'); $pdf->Cell(0,4,'Signature of Principal','',1,'R'); } $pdf->Output("nitteIaMarks.pdf","I"); } ?>
Close