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.133.148.130
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 /
html /
college /
Report_details /
[ HOME SHELL ]
Name
Size
Permission
Action
output
[ DIR ]
drwxr-xr-x
AttDateWiseReportexcel.php
4.33
KB
-rwxr-xr-x
Attdet.php
7.07
KB
-rwxr-xr-x
AttdetPdf.php
8.46
KB
-rwxr-xr-x
AttdetPdfUniclare.php
7.49
KB
-rwxr-xr-x
AttdetexcelUniclare.php
5.48
KB
-rwxr-xr-x
CIEAttendanceNotEligiblepdf.ph...
6.83
KB
-rwxr-xr-x
CIEpendingListpdf.php
9.05
KB
-rwxr-xr-x
DegreeWiseStudLstUSN.php
7.69
KB
-rwxr-xr-x
DownloadExamAppFormApplication...
11.64
KB
-rwxr-xr-x
DownloadRvRtAckApplications.ph...
4.6
KB
-rwxr-xr-x
Generatecollegeiamarkspendingr...
7.49
KB
-rwxr-xr-x
PrintChallanEntryDetails.php
8.27
KB
-rwxr-xr-x
RVApplicationsReport.php
8.9
KB
-rwxr-xr-x
RvPcListDetailedReport.php
12.51
KB
-rwxr-xr-x
RvRtApplicationReport.php
8.82
KB
-rwxr-xr-x
absentAndMalReportPdf.php
11.5
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
11.76
KB
-rwxr-xr-x
admReport.php
7.78
KB
-rwxr-xr-x
admReport_old.php
12.3
KB
-rwxr-xr-x
admlist.php
13.87
KB
-rwxr-xr-x
admregisterlist.php
7.15
KB
-rwxr-xr-x
affliation_detailed_report.php
12.56
KB
-rwxr-xr-x
appear_list_center_qp_wise.php
12.82
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.57
KB
-rwxr-xr-x
attCisshortList_sjbit.php
12.03
KB
-rwxr-xr-x
attendanceReportForm.php
5.69
KB
-rwxr-xr-x
attendanceform_pdf.php
11.9
KB
-rwxr-xr-x
attiacombined.php
9.52
KB
-rwxr-xr-x
attiacombinedReportnewexcel_sj...
12.94
KB
-rwxr-xr-x
attiacombinednew.php
12.31
KB
-rwxr-xr-x
attiacombinednew_sjbit.php
8.49
KB
-rwxr-xr-x
attshortlist.php
10.69
KB
-rwxr-xr-x
basic_data_coll.php
6.74
KB
-rwxr-xr-x
basic_data_sum.php
7.47
KB
-rwxr-xr-x
batch_wise_details.php
4.45
KB
-rwxr-xr-x
board.php
3.86
KB
-rwxr-xr-x
bundle_ack.php
12.96
KB
-rwxr-xr-x
candidatelist.php
9.9
KB
-rwxr-xr-x
categorywisereport.php
9.03
KB
-rwxr-xr-x
cntrtagcollstud.php
4.99
KB
-rwxr-xr-x
code39.php
6.38
KB
-rwxr-xr-x
college_pending_markslist.php
6.8
KB
-rwxr-xr-x
college_pending_markslist19032...
6.48
KB
-rwxr-xr-x
convoreport.php
5.56
KB
-rwxr-xr-x
copomarksexternalreportexcel.p...
7.02
KB
-rwxr-xr-x
daterange.php
6.27
KB
-rwxr-xr-x
degreewiseMarksEntryStats.php
8.44
KB
-rwxr-xr-x
empty_report_admission_det.php
8.91
KB
-rwxr-xr-x
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
-rwxr-xr-x
generate.php
7.32
KB
-rwxr-xr-x
generateDaliyReportQpNitteExce...
16.13
KB
-rwxr-xr-x
generatePostAdmissionTicket.ph...
51.8
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
-rwxr-xr-x
generatePrintIaMarksnew.php
16.28
KB
-rwxr-xr-x
generateQuestionWiseIAReportPD...
18.73
KB
-rwxr-xr-x
generateXlGraph.php
3.87
KB
-rwxr-xr-x
generateadmissionreg.php
11.79
KB
-rwxr-xr-x
generatecoporeport_xl.php
21.04
KB
-rwxr-xr-x
gerderwiseresultsheet.php
11.95
KB
-rwxr-xr-x
getDegree.php
2.27
KB
-rwxr-xr-x
getDegreeAndSem.php
4.32
KB
-rwxr-xr-x
getIaSubjWiseReport.php
0
B
-rwxr-xr-x
getNitteAdmXlreport.php
14.34
KB
-rwxr-xr-x
getReportClassStud.php
6.03
KB
-rwxr-xr-x
gradewisesubjectanalysisreport...
19.82
KB
-rwxr-xr-x
headerNfooter.php
5.56
KB
-rwxr-xr-x
headerNfooters.php
1.93
KB
-rw-rw-r--
iaMarksQnWiseReportExcel.php
25.41
KB
-rwxr-xr-x
iaMarksReportPDF.php
10.84
KB
-rwxr-xr-x
iaSubjectWiseReport.php
10.74
KB
-rwxr-xr-x
ia_room_allotment_datewise.php
9.08
KB
-rwxr-xr-x
iaemptyformat.php
9.63
KB
-rwxr-xr-x
invig_report.php
10.18
KB
-rwxr-xr-x
invig_report_summary.php
7.74
KB
-rwxr-xr-x
latEntryRprt.php
6.4
KB
-rwxr-xr-x
markListReportPdf.php
21.32
KB
-rwxr-xr-x
markListReportPdfnew.php
44.55
KB
-rwxr-xr-x
markListReportPdfnew_24112023....
42.93
KB
-rwxr-xr-x
marksentryquestionwise.php
23.83
KB
-rwxr-xr-x
mregistry.php
129.68
KB
-rwxr-xr-x
pdfacknowledgeAppNo.php
10.95
KB
-rwxr-xr-x
pendingcie.php
0
B
-rwxr-xr-x
photo_report.php
7.04
KB
-rwxr-xr-x
pi_test.php
3.45
KB
-rwxr-xr-x
picharttesting.php
19.9
KB
-rwxr-xr-x
principalFreeze_report.php
7.23
KB
-rwxr-xr-x
printIaMarks.php
12.74
KB
-rwxr-xr-x
printIaMarks_old.php
12.74
KB
-rwxr-xr-x
printMarkListDetailsWisenew.ph...
10.1
KB
-rwxr-xr-x
printMarkListDetailsWisenew_CI...
3.98
KB
-rwxr-xr-x
printMarkListDetailsWisenew_sj...
11.81
KB
-rwxr-xr-x
printMarkListSubWiseJssstu.php
28.29
KB
-rwxr-xr-x
print_applications_ru.php
26.59
KB
-rwxr-xr-x
qp_issue.php
8.46
KB
-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...
55.13
KB
-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...
33.16
KB
-rwxr-xr-x
qrhallticket.php
56.1
KB
-rwxr-xr-x
r
9.23
KB
-rwxr-xr-x
regNoAllot.php
25.14
KB
-rwxr-xr-x
reg_stud_list.php
8.34
KB
-rwxr-xr-x
reportAttClassCreate.php
5.14
KB
-rwxr-xr-x
reportAttCount.php
12.89
KB
-rwxr-xr-x
reportAttCount_old_08112022.ph...
11.11
KB
-rwxr-xr-x
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
-rwxr-xr-x
report_admission_list_wop.php
10.31
KB
-rwxr-xr-x
report_admission_ticket.php
64.74
KB
-rwxr-xr-x
report_admission_ticket_bf_uuc...
37.63
KB
-rwxr-xr-x
report_attendance_sheet.php
18.31
KB
-rwxr-xr-x
report_attendance_shortage.php
9.23
KB
-rwxr-xr-x
report_attendance_summary.php
10.85
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.83
KB
-rwxr-xr-x
report_batch_worksheet_details...
14.68
KB
-rwxr-xr-x
report_bulk_applications.php
26.14
KB
-rwxr-xr-x
report_bulk_applications_nitte...
25.55
KB
-rwxr-xr-x
report_bundle_dispatch.php
13.73
KB
-rwxr-xr-x
report_candidate_list.php
31.49
KB
-rwxr-xr-x
report_candidate_list_old.php
29.91
KB
-rwxr-xr-x
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...
17.01
KB
-rwxr-xr-x
report_daliy_report_qp_sjbit.p...
17.25
KB
-rwxr-xr-x
report_data_sent.php
8.41
KB
-rwxr-xr-x
report_degree_list.php
5.3
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_iamarks_pending.php
8.19
KB
-rwxr-xr-x
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...
20.78
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...
18.15
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.78
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
43.87
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_st...
19.82
KB
-rwxr-xr-x
report_ra_invigilators_dairy.p...
9.26
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
10.63
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
8.74
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
10.67
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
26.62
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
17.6
KB
-rwxr-xr-x
report_reg_list.php
33.33
KB
-rwxr-xr-x
report_reg_list_gcg.php
33.55
KB
-rwxr-xr-x
report_reg_list_gcg_new_040120...
33.12
KB
-rwxr-xr-x
report_revaluation.php
6.42
KB
-rwxr-xr-x
report_subject_admcl_list.php
3.68
KB
-rwxr-xr-x
report_subject_general_list.ph...
4.87
KB
-rwxr-xr-x
resultsheet.php
12.7
KB
-rwxr-xr-x
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
roomallotmantsummary.php
6.57
KB
-rwxr-xr-x
roomallotmantsummarysubjwise.p...
9.31
KB
-rwxr-xr-x
roomwise_register_nos_list.php
26.84
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
semesterWiseResultReportpdf.ph...
9.9
KB
-rwxr-xr-x
shortageReport.php
11.87
KB
-rwxr-xr-x
std_regstr_det_reprt_xl.php
7.6
KB
-rwxr-xr-x
stringspliter.php
718
B
-rwxr-xr-x
stud_wise_report.php
8.97
KB
-rwxr-xr-x
studentHisResult.php
7.92
KB
-rwxr-xr-x
student_count.php
4.16
KB
-rwxr-xr-x
studentwiseresult.php
16.77
KB
-rwxr-xr-x
subjRegReport.php
7.54
KB
-rwxr-xr-x
subject_wise_student_list.php
6.2
KB
-rwxr-xr-x
subjwisepasspercentage.php
10.45
KB
-rwxr-xr-x
subjwisepasspercentagePie.php
10.92
KB
-rwxr-xr-x
subjwiseressheet.php
12.79
KB
-rwxr-xr-x
subwiseGrafAnalysis.php
20.04
KB
-rwxr-xr-x
subwiseGrafAnalysis1.php
22.44
KB
-rwxr-xr-x
subwiseResultReport.php
12.75
KB
-rwxr-xr-x
tatkal.php
4.84
KB
-rwxr-xr-x
teachFreeze_report.php
8.96
KB
-rwxr-xr-x
teacher_report.php
11.26
KB
-rwxr-xr-x
teacher_val_report.php
10.59
KB
-rwxr-xr-x
timetabledegreewiserpt.php
6.73
KB
-rwxr-xr-x
topsheet.php
8.58
KB
-rwxr-xr-x
verifystud.php
8.38
KB
-rwxr-xr-x
xl_AckAppReport.php
10.02
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : marksentryquestionwise.php
<?php function viewIAQuestionWisewise($aobj_context){ session_start(); $collcode=$_SESSION['collcode']; $teachcode = $aobj_context->mobj_data["teachcode"]; $classid = $aobj_context->mobj_data["classid"]; $subelement = $aobj_context->mobj_data["subelement"]; $txtmarks = $aobj_context->mobj_data["txtmarks"]; $txtunits = $aobj_context->mobj_data["txtunits"]; $testName = $aobj_context->mobj_data["testName"]; $queryView = "select * from maxmarksint where fclassid='{$classid}' and ftestname='{$testName}'"; $resMarks=$aobj_context->mobj_db->GetAll($queryView); if(count($resMarks) == 0){ $arr['msg'] = "Marks details not entered"; echo($aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure")); return; } $query = "select distinct fcollcode,fdegree,fexamno from attendsum where fclassid = '{$classid}'"; $res=$aobj_context->mobj_db->GetRow($query); $collcode = $res['fcollcode']; $degree = $res['fdegree']; $exam = $res['fexamno']; $query = "select * from subdet where fcollcode = '{$collcode}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(fiafrom,'%Y-%m-%d') AND DATE_FORMAT(fiato,'%Y-%m-%d') and concat(fcsubcode,fsubcode) = '{$subelement}'"; $res3=$aobj_context->mobj_db->GetAll($query); $query = "select * from control"; $res9=$aobj_context->mobj_db->GetRow($query); $FREGROLL = $res9['FREGROLL']; $query1 = "select stu.FREGNO, stu.FNAME, sd.fexamno, sd.fdegree, stu.fcollcode, ifnull(mak.fmarks11, '-1')as fmarks11, ifnull(mak.fmarks12, '-1')as fmarks12, ifnull(mak.fmarks13, '-1')as fmarks13, ifnull(mak.fmarks14, '-1')as fmarks14, ifnull(mak.fmarks21, '-1')as fmarks21, ifnull(mak.fmarks22, '-1')as fmarks22, ifnull(mak.fmarks23, '-1')as fmarks23, ifnull(mak.fmarks24, '-1')as fmarks24, ifnull(mak.fmarks31, '-1')as fmarks31, ifnull(mak.fmarks32, '-1')as fmarks32, ifnull(mak.fmarks33, '-1')as fmarks33, ifnull(mak.fmarks34, '-1')as fmarks34, ifnull(mak.fmarks41, '-1')as fmarks41, ifnull(mak.fmarks42, '-1')as fmarks42, ifnull(mak.fmarks43, '-1')as fmarks43, ifnull(mak.fmarks44, '-1')as fmarks44, mak.FTOTAL, mak.fsubcode, mak.fdegree, mak.fexamno, fnotest as FTEST, fu1max, fu2max, fqnno FROM attendsum a inner join student stu on stu.FREGNO=a.FREGNO and stu.fdegree = a.fdegree inner join degree d on d.FDEGREE =a.FDEGREE and d.Fexamno=a.Fexamno inner join subdet sd on a.fdegree = sd.fdegree and a.fexamno = sd.fexamno and left(a.fsubcode,4) = left(sd.fcsubcode,4) left join marksint mak ON a.fdegree = mak.fdegree and a.FREGNO=mak.FREGNO and mak.ftest = '{$testName}' where a.fteachcode = '{$teachcode}' and a.fclassid = '{$classid}' and a.FCOLLCODE='{$collcode}' and left(a.fsubcode,4) = left('{$subelement}',4) group by fregno order by FREGNO"; $result=$aobj_context->mobj_db->GetAll($query1); $e_data.="<table id='tabledata' class='table' width='100%' align='center' cellspacing='0' cellpadding='0' border='0' >"; $e_data.="<thead style='position:sticky; top:0; z-index:1'>"; $e_data.="<tr><th align='left' colspan='9' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:22px;'>Marks Entry (Question Wise)</th></tr>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td rowspan='2' class='headcol' align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;position:sticky; background:white; left:0;'>Sl No</td>"; $e_data.="<td rowspan='2' class='headcol' align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;position:sticky; background:white; left:47px;'>USN</td>"; $e_data.="<td rowspan='2'class='headcol' align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;position:sticky; background:white; left:153px;'>Student Name</td>"; $e_data.="<td rowspan='2' align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;position:sticky; background:white; left:360px;'>Total</td>"; $e_data.="<td rowspan='2' align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;position:sticky; background:white; left:416px;'>Absent</td>"; for($m=1; $m <= 4; $m++){ $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> <div style='display:flex;gap:5px; justify-content:center'>{$m} (Max. 25 marks)</div> </td>"; } $e_data.="</tr>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; foreach($resMarks as $v){ $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> <p style='width:35px'>A<br/>(<span id='a1max'>".intval($resMarks['FMARKS'])."</span>)</p> </td>"; } // $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> // <div style='display:flex;gap:5px; justify-content:space-between'> // <p style='width:35px'>A<br/>(<span id='a1max'>".intval($resMarks['F1AMAX'])."</span>)</p> // <p style='width:35px'>B<br/>(<span id='b1max'>".intval($resMarks['F1BMAX'])."</span>)</p> // <p style='width:35px'>C<br/>(<span id='c1max'>".intval($resMarks['F1CMAX'])."</span>)</p> // <p style='width:35px'>D<br/>(<span id='d1max'>".intval($resMarks['F1DMAX'])."</span>)</p> // </div> // </td>"; // $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> // <div style='display:flex;gap:5px; justify-content:space-between'> // <p style='width:35px'>A <br/>(<span id='a2max'>".intval($resMarks['F2AMAX'])."</span>)</p> // <p style='width:35px'>B<br/>(<span id='b2max'>".intval($resMarks['F2BMAX'])."</span>)</p> // <p style='width:35px'>C<br/>(<span id='c2max'>".intval($resMarks['F2CMAX'])."</span>)</p> // <p style='width:35px'>D<br/>(<span id='d2max'>".intval($resMarks['F2DMAX'])."</span>)</p> // </div> // </td>"; // $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> // <div style='display:flex;gap:5px; justify-content:space-between'> // <p style='width:35px'>A <br/>(<span id='a3max'>".intval($resMarks['F3AMAX'])."</span>)</p> // <p style='width:35px'>B<br/>(<span id='b3max'>".intval($resMarks['F3BMAX'])."</span>)</p> // <p style='width:35px'>C<br/>(<span id='c3max'>".intval($resMarks['F3CMAX'])."</span>)</p> // <p style='width:35px'>D<br/>(<span id='d3max'>".intval($resMarks['F3DMAX'])."</span>)</p> // </div> // </td>"; // $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> // <div style='display:flex;gap:5px; justify-content:space-between'> // <p style='width:35px'>A <br/>(<span id='a4max'>".intval($resMarks['F4AMAX'])."</span>)</p> // <p style='width:35px'>B<br/>(<span id='b4max'>".intval($resMarks['F4BMAX'])."</span>)</p> // <p style='width:35px'>C<br/>(<span id='c4max'>".intval($resMarks['F4CMAX'])."</span>)</p> // <p style='width:35px'>D<br/>(<span id='d4max'>".intval($resMarks['F4DMAX'])."</span>)</p> // </div> // </td>"; $e_data.="</tr>"; $e_data.="</thead>"; $k=1; for($m=0;$m<count($result);$m++) { $fmarks11 = $result[$m]['fmarks11'] == "-1.00" ? '-1' : $result[$m]['fmarks11']; $fmarks12 = $result[$m]['fmarks12'] == "-1.00" ? '-1' : $result[$m]['fmarks12']; $fmarks13 = $result[$m]['fmarks13'] == "-1.00" ? '-1' : $result[$m]['fmarks13']; $fmarks14 = $result[$m]['fmarks14'] == "-1.00" ? '-1' : $result[$m]['fmarks14']; $fmarks21 = $result[$m]['fmarks21'] == "-1.00" ? '-1' : $result[$m]['fmarks21']; $fmarks22 = $result[$m]['fmarks22'] == "-1.00" ? '-1' : $result[$m]['fmarks22']; $fmarks23 = $result[$m]['fmarks23'] == "-1.00" ? '-1' : $result[$m]['fmarks23']; $fmarks24 = $result[$m]['fmarks24'] == "-1.00" ? '-1' : $result[$m]['fmarks24']; $fmarks31 = $result[$m]['fmarks31'] == "-1.00" ? '-1' : $result[$m]['fmarks31']; $fmarks32 = $result[$m]['fmarks32'] == "-1.00" ? '-1' : $result[$m]['fmarks32']; $fmarks33 = $result[$m]['fmarks33'] == "-1.00" ? '-1' : $result[$m]['fmarks33']; $fmarks34 = $result[$m]['fmarks34'] == "-1.00" ? '-1' : $result[$m]['fmarks34']; $fmarks41 = $result[$m]['fmarks41'] == "-1.00" ? '-1' : $result[$m]['fmarks41']; $fmarks42 = $result[$m]['fmarks42'] == "-1.00" ? '-1' : $result[$m]['fmarks42']; $fmarks43 = $result[$m]['fmarks43'] == "-1.00" ? '-1' : $result[$m]['fmarks43']; $fmarks44 = $result[$m]['fmarks44'] == "-1.00" ? '-1' : $result[$m]['fmarks44']; $e_data.="<tr class='ui-widget-content jqgrow'>"; $e_data.="<td class='tbl_row_new' align='center' style='width:40px;border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;position:sticky; background:white; left:0;' >{$k}</td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:100px;border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;position:sticky; background:white; left:47px;'>{$result[$m]['FREGNO']}</td>"; $e_data.="<td class='tbl_row_new' style='width:200px;border-right:1px solid #C5DBEC; padding:2px;position:sticky; background:white; left:153px;'>{$result[$m]['FNAME']}</td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:50px;border-right:1px solid #C5DBEC; padding:2px;position:sticky; background:white; left:360px;'> <input type='text' class='total_{$k}' id='total_{$k}' style='width:30px;text-align: center;{$border};' value='{$result[$m]['FTOTAL']}' disabled> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:50px;border-right:1px solid #C5DBEC; padding:2px;position:sticky; background:white; left:416px;'> <input type='checkbox' id='absent_{$k}' style='width:30px;text-align: center;{$border};' value='' onchange='frezstd($k,this)'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:150px;border-right:1px solid #C5DBEC; padding:2px;'> <div style='display:flex; gap:1px; justify-content:space-between;'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark1A_`, $k, `1`, this)' class='mark1A_{$k}' id='mark1A_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks11}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark1B_`, $k, `1`)' class='mark1B_{$k}' id='mark1B_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks12}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark1C_`, $k, `1`)' class='mark1C_{$k}' id='mark1C_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks13}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark1D_`, $k, `1`)' class='mark1D_{$k}' id='mark1D_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks14}'> </div> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:150px;border-right:1px solid #C5DBEC; padding:2px;'> <div style='display:flex; gap:1px; justify-content:space-between;'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark2A_`, $k, `2`)' class='mark2A_{$k}' id='mark2A_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks21}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark2B_`, $k, `2`)' class='mark2B_{$k}' id='mark2B_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks22}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark2C_`, $k, `2`)' class='mark2C_{$k}' id='mark2C_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks23}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark2D_`, $k, `2`)' class='mark2D_{$k}' id='mark2D_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks24}'> </div> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:150px;border-right:1px solid #C5DBEC; padding:2px;'> <div style='display:flex; gap:1px; justify-content:space-between;'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark3A_`, $k, `3`)' class='mark3A_{$k}' id='mark3A_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks31}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark3B_`, $k, `3`)' class='mark3B_{$k}' id='mark3B_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks32}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark3C_`, $k, `3`)' class='mark3C_{$k}' id='mark3C_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks33}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark3D_`, $k, `3`)' class='mark3D_{$k}' id='mark3D_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks34}'> </div> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='width:150px;border-right:1px solid #C5DBEC; padding:2px;'> <div style='display:flex; gap:1px; justify-content:space-between;'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark4A_`, $k, `4`)' class='mark4A_{$k}' id='mark4A_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks41}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark4B_`, $k, `4`)' class='mark4B_{$k}' id='mark4B_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks42}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark4C_`, $k, `4`)' class='mark4C_{$k}' id='mark4C_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks43}'> <input type='text' oninput='getTotal($k)' onkeypress='return isNumber(event)' onblur='checkValidMarks(`mark4D_`, $k, `4`, this)' class='mark4D_{$k}' id='mark4D_{$k}' style='width:35px;text-align: center;{$border};' value='{$fmarks44}'> </div> </td>"; $k++; } $arr['html'] = $e_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function saveIAEntryQuestionwise($aobj_context){ session_start(); include("error_log.php"); $collcode=$_SESSION['collcode']; $User_code = $_SESSION['usr']; $techcode = $aobj_context->mobj_data["techcode"]; $classid = $aobj_context->mobj_data["classid"]; $subcode = $aobj_context->mobj_data["subelement"]; $testName = $aobj_context->mobj_data["testName"]; $subarry = json_decode($aobj_context->mobj_data["subarry"], true); foreach($subarry as $value){ $qrySelect = "select * from marksint where fregno='{$value['fregno']}' and fsubcode='{$subcode}' and ftest='{$testName}'"; $upd = $aobj_context->mobj_db->GetRow($qrySelect); if($value['absent'] == 'T'){ $fmarks1A = '-2'; $fmarks1B = '-2'; $fmarks1C = '-2'; $fmarks1D = '-2'; $fmarks2A = '-2'; $fmarks2B = '-2'; $fmarks2C = '-2'; $fmarks2D = '-2'; $fmarks3A = '-2'; $fmarks3B = '-2'; $fmarks3C = '-2'; $fmarks3D = '-2'; $fmarks4A = '-2'; $fmarks4B = '-2'; $fmarks4C = '-2'; $fmarks4D = '-2'; }else{ $fmarks1A = "{$value['marks1A']}"; $fmarks1B = "{$value['marks1B']}"; $fmarks1C = "{$value['marks1C']}"; $fmarks1D = "{$value['marks1D']}"; $fmarks2A = "{$value['marks2A']}"; $fmarks2B = "{$value['marks2B']}"; $fmarks2C = "{$value['marks2C']}"; $fmarks2D = "{$value['marks2D']}"; $fmarks3A = "{$value['marks3A']}"; $fmarks3B = "{$value['marks3B']}"; $fmarks3C = "{$value['marks3C']}"; $fmarks3D = "{$value['marks3D']}"; $fmarks4A = "{$value['marks4A']}"; $fmarks4B = "{$value['marks4B']}"; $fmarks4C = "{$value['marks4C']}"; $fmarks4D = "{$value['marks4D']}"; } if(count($upd) > 0){ $queryUpd = "update marksint set FMARKS11='$fmarks1A', FMARKS12='$fmarks1B', FMARKS13='$fmarks1C', FMARKS14='$fmarks1D', FMARKS21='$fmarks2A', FMARKS22='$fmarks2B', FMARKS23='$fmarks2C', FMARKS24='$fmarks2D', FMARKS31='$fmarks3A', FMARKS32='$fmarks3B', FMARKS33='$fmarks3C', FMARKS34='$fmarks3D', FMARKS41='$fmarks4A', FMARKS42='$fmarks4B', FMARKS43='$fmarks4C', FMARKS44='$fmarks4D', FTOTAL='{$value['total']}', FCREATEUSER='{$User_code}', FCREATEDATE=now() where fregno = '{$value['fregno']}' and fsubcode = '{$subcode}' and fcollcode = '{$collcode}'"; }else{ $select = "select fdegree, fexamno from attendsum where fregno='{$value['fregno']}' and fclassid='{$classid}'"; $res = $aobj_context->mobj_db->GetRow($select); $queryUpd = "insert into marksint(FREGNO, fexamno, fsubcode, fdegree, fcollcode, ftest, fmarks11, fmarks12, fmarks13, fmarks14, fmarks21, fmarks22, fmarks23, fmarks24, fmarks31, fmarks32, fmarks33, fmarks34, fmarks41, fmarks42, fmarks43, fmarks44, ftotal, FCREATEDATE, FCREATEUSER) values('{$value['fregno']}', '{$res['fexamno']}', '{$subcode}', '{$res['fdegree']}', '{$collcode}', '{$testName}', '$fmarks1A', '$fmarks1B', '$fmarks1C', '$fmarks1D', '$fmarks2A', '$fmarks2B', '$fmarks2C', '$fmarks2D', '$fmarks3A', '$fmarks3B', '$fmarks3C', '$fmarks3D', '$fmarks4A', '$fmarks4B', '$fmarks4C', '$fmarks4D', '{$value['total']}', now(), '{$User_code}')"; } $upd = $aobj_context->mobj_db->Execute($queryUpd); } if($upd){ $rdata = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } function saveMarksDetailsEntry($aobj_context){ $collcode=$_SESSION['collcode']; $user = $_SESSION['usr']; $classid = $aobj_context->mobj_data["classId"]; $testName = $aobj_context->mobj_data["testName"]; $data = json_decode($aobj_context->mobj_data["data"], true); foreach($data as $val){ $query = "INSERT INTO maxmarksint (FCLASSID, FTESTNAME, FQNNO, FMARKS, FCO, FPO, FPSO, FCUSR, FCDATE, FDELETED) VALUES('{$classid}', '{$testName}', '{$val['qnno']}', '{$val['marks']}', '{$val['co']}', '{$val['po']}', '{$val['pso']}', '{$user}', now(), 'F') on duplicate key update FMARKS='{$val['marks']}', FCO='{$val['co']}', FPO='{$val['po']}', FPSO='{$val['pso']}', FCUSR='{$user}', FCDATE=now(), FDELETED='F'"; $res = $aobj_context->mobj_db->Execute($query); } if($res){ $msg = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($msg,0,"success")); return $msg; } else { $msg = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($msg,-1,"Failure")); return $msg; } } function editQnMarksDetails($aobj_context){ $testName = $aobj_context->mobj_data["testName"]; $classid = $aobj_context->mobj_data["classid"]; $queryView = "select FCLASSID, FTESTNAME, FQNNO, ifnull(FMARKS, '') as FMARKS, ifnull(FCO, '')as FCO, ifnull(FPO, '')as FPO, ifnull(FPSO, '')as FPSO from maxmarksint where fclassid='{$classid}' and ftestname='{$testName}'"; $resMarks = $aobj_context->mobj_db->GetAll($queryView); if(count($resMarks) == 0){ $arr['msg'] = "Marks details not entered"; echo($aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure")); return; }else{ echo($aobj_context->mobj_output->ToJSONEnvelope($resMarks, 0, "Success")); return; } } ?>
Close