Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.22.242.169
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 /
src_old /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-sr-x
Dispatch_ans_script_setup.php
5.95
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.3
KB
-rwxr-xr-x
DownloadExamAppFormApplication...
5.28
KB
-rwxr-xr-x
ECHblk.php
11.31
KB
-rwxr-xr-x
FormulaEvaluate.php
14.48
KB
-rwxr-xr-x
MarkEntry-Setup.php
26.9
KB
-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...
27.69
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.87
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.82
KB
-rwxr-xr-x
UpdateCollDet.php
1.71
KB
-rwxr-xr-x
XLSXReader.php
9.62
KB
-rwxr-xr-x
absent_entry_setup.php
8.33
KB
-rwxr-xr-x
absent_entry_setupQp.php
7.46
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.22
KB
-rwxr-xr-x
ack_adm_application.php
56.32
KB
-rwxr-xr-x
ack_admentry_application.php
49.35
KB
-rwxr-xr-x
ack_application.php
7.85
KB
-rwxr-xr-x
ack_exam_app_form.php
16.96
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.87
KB
-rwxr-xr-x
ack_registration.php
7.95
KB
-rwxr-xr-x
ack_report.php
2.34
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.7
KB
-rwxr-xr-x
actClass.php
6.38
KB
-rwxr-xr-x
adm_challan_entries.php
14.13
KB
-rwxr-xr-x
adm_delete_data.php
5.71
KB
-rwxr-xr-x
admapprove.php
9.55
KB
-rwxr-xr-x
admchallanpreparation.php
9.01
KB
-rwxr-xr-x
admission_entry_reg.php
40.87
KB
-rwxr-xr-x
admission_entry_status.php
2.79
KB
-rwxr-xr-x
admission_sms_push.php
2.33
KB
-rwxr-xr-x
admissionapplist.php
9.15
KB
-rwxr-xr-x
admregisterlist.php
14.82
KB
-rwxr-xr-x
admstuddate.php
6.27
KB
-rwxr-xr-x
admsumsendsms.php
6.28
KB
-rwxr-xr-x
admuploadexsheet.php
12.57
KB
-rwxr-xr-x
ansbookcancel.php
9.7
KB
-rwxr-xr-x
answer_book_issued.php
10.56
KB
-rwxr-xr-x
applicationFormReportPOSTOFFIC...
26.67
KB
-rwxr-xr-x
apprCandidReport.php
7.14
KB
-rwxr-xr-x
approve.php
38.33
KB
-rwxr-xr-x
attendance.php
10.44
KB
-rwxr-xr-x
attendance_freez.php
8.65
KB
-rwxr-xr-x
attendance_freez_mth.php
8.42
KB
-rwxr-xr-x
attshort.php
6.45
KB
-rwxr-xr-x
auto-complete.php
5.04
KB
-rwxr-xr-x
backup.php
2.95
KB
-rwxr-xr-x
backup_restore.php
8.36
KB
-rwxr-xr-x
backupandrestore.php
10.43
KB
-rwxr-xr-x
batch_close.php
4.43
KB
-rwxr-xr-x
board.php
2.71
KB
-rwxr-xr-x
boeselection.php
1.69
KB
-rwxr-xr-x
bundle_dispatch.php
3.21
KB
-rwxr-xr-x
bundle_rec_ack.php
4.13
KB
-rwxr-xr-x
bundledispatchdatewise.php
12.74
KB
-rwxr-xr-x
bundlereceive.php
1.12
KB
-rwxr-xr-x
bundlestatus.php
5.38
KB
-rwxr-xr-x
cManualMailer.php
2.63
KB
-rwxr-xr-x
caccesscontext.php
1.28
KB
-rwxr-xr-x
candidate-entry.php
44.67
KB
-rwxr-xr-x
cappcontext.php
2.7
KB
-rwxr-xr-x
challan_entries.php
15.65
KB
-rwxr-xr-x
challan_preparation.php
11.91
KB
-rwxr-xr-x
changeDegree.php
1.61
KB
-rwxr-xr-x
changeMobile.php
2.51
KB
-rwxr-xr-x
cmailer.php
6.96
KB
-rwxr-xr-x
cntDeclaration.php
4.23
KB
-rwxr-xr-x
code39.php
6.54
KB
-rwxr-xr-x
coll_exam_app_form.php
1014
B
-rwxr-xr-x
collbankdet.php
1.9
KB
-rwxr-xr-x
colldesp_ack.php
4.08
KB
-rwxr-xr-x
college.php
5.15
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.61
KB
-rwxr-xr-x
college_approve.php
5.71
KB
-rwxr-xr-x
college_degree_status.php
5.76
KB
-rwxr-xr-x
collegebank.php
1.89
KB
-rwxr-xr-x
collfundtransfer.php
2.32
KB
-rwxr-xr-x
connect.php
2.31
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
coutput.php
1.84
KB
-rwxr-xr-x
createAdmission.php
4.06
KB
-rwxr-xr-x
create_all_grid_files.php
8.8
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
10.18
KB
-rwxr-xr-x
create_all_popup_files.php
6.08
KB
-rwxr-xr-x
create_all_schema_files.php
4.42
KB
-rwxr-xr-x
create_all_views.php
16.87
KB
-rwxr-xr-x
create_html_files.php
52.9
KB
-rwxr-xr-x
create_html_files_without_tab....
45.23
KB
-rwxr-xr-x
create_module_meta_columns.php
5.26
KB
-rwxr-xr-x
crequestbroker.php
2.58
KB
-rwxr-xr-x
cronjob_sendsms.php
3.04
KB
-rwxr-xr-x
csessions.php
548
B
-rwxr-xr-x
cuser.php
3.53
KB
-rwxr-xr-x
custom_mregistry.php
124
B
-rwxr-xr-x
database.php
474
B
-rwxr-xr-x
datadictionary.php
4.06
KB
-rwxr-xr-x
daterange.php
8.08
KB
-rwxr-xr-x
degree.php
6.66
KB
-rwxr-xr-x
degreeGroup.php
4
B
-rwxr-xr-x
degstudymat.php
6.45
KB
-rwxr-xr-x
degstudymatdet.php
5.16
KB
-rwxr-xr-x
display_details_in_grid.php
109.22
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.72
KB
-rwxr-xr-x
display_details_in_grid_studta...
99.65
KB
-rwxr-xr-x
display_details_in_grid_withde...
100.58
KB
-rwxr-xr-x
doc_verify.php
7.31
KB
-rwxr-xr-x
downloadFeeStatement.php
5.47
KB
-rwxr-xr-x
download_misc_files.php
4.72
KB
-rwxr-xr-x
download_photo.php
4.17
KB
-rwxr-xr-x
download_upload.php
3.99
KB
-rwxr-xr-x
dynamicmastersdetails.php
120.21
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
122.19
KB
-rwxr-xr-x
entryexitevents.php
3.19
KB
-rwxr-xr-x
examAppChallan.php
7.92
KB
-rwxr-xr-x
execute_query.php
2.57
KB
-rwxr-xr-x
export_import_setup.php
7.8
KB
-rwxr-xr-x
export_import_utility.php
2.75
KB
-rwxr-xr-x
feepaidreports.php
994
B
-rwxr-xr-x
forgotpassword.php
3.22
KB
-rwxr-xr-x
format.php
7.76
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.79
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10.3
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.93
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.99
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.61
KB
-rwxr-xr-x
freezeiaprici.php
10.14
KB
-rwxr-xr-x
general_report_format.php
11.33
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
3.05
KB
-rwxr-xr-x
getMessages.php
11.4
KB
-rwxr-xr-x
getdata.php
36.93
KB
-rwxr-xr-x
getfeeinformation.php
7.28
KB
-rwxr-xr-x
getfeeinformation_bulk.php
7.74
KB
-rwxr-xr-x
getmoduledetails.php
23.94
KB
-rwxr-xr-x
getnumword.php
7.8
KB
-rwxr-xr-x
getreportdetails.php
3.29
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.43
KB
-rwxr-xr-x
getsearchcondition.php
1.37
KB
-rwxr-xr-x
ggridmodel.php
9.59
KB
-rwxr-xr-x
golden_palm_payslip.php
12.86
KB
-rwxr-xr-x
helptext.php
5.54
KB
-rwxr-xr-x
identify_transactions.php
6.56
KB
-rwxr-xr-x
import_marks.php
4.27
KB
-rwxr-xr-x
index.php
5.17
KB
-rwxr-xr-x
json.php
34.52
KB
-rwxr-xr-x
login.php
18.88
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.33
KB
-rwxr-xr-x
login_old.php
3.23
KB
-rwxr-xr-x
login_wait.php
11.78
KB
-rwxr-xr-x
mascomb.php
10.27
KB
-rwxr-xr-x
mcverifydet.php
14.61
KB
-rwxr-xr-x
message_board.php
4.84
KB
-rwxr-xr-x
messagetext.php
1010
B
-rwxr-xr-x
module_setup.php
2.56
KB
-rwxr-xr-x
mregistry.php
92.4
KB
-rwxr-xr-x
mrn_approval.php
9.24
KB
-rwxr-xr-x
nobleRegn.php
4.08
KB
-rwxr-xr-x
payment_gateway.php
8.01
KB
-rwxr-xr-x
photoupload.php
9.52
KB
-rwxr-xr-x
post.php
5.21
KB
-rwxr-xr-x
printexamform.php
11.87
KB
-rwxr-xr-x
push_data_to_studentportal.php
1.86
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.72
KB
-rwxr-xr-x
remove_exam_ack.php
3.63
KB
-rwxr-xr-x
report_admission_ticket.php
48.07
KB
-rwxr-xr-x
report_hall_ticket.php
11.47
KB
-rwxr-xr-x
report_iamarks_pending.php
12.35
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
12.15
KB
-rwxr-xr-x
report_setup.php
25.56
KB
-rwxr-xr-x
report_tool.php
74.93
KB
-rwxr-xr-x
result.php
5.18
KB
-rwxr-xr-x
resultsheet.php
9.15
KB
-rwxr-xr-x
revaluation.php
17.01
KB
-rwxr-xr-x
revaluation_withdegree.php
17.13
KB
-rwxr-xr-x
room_allotment.php
8.13
KB
-rwxr-xr-x
room_allotment_datewise.php
15.75
KB
-rwxr-xr-x
roomdeclaration.php
1.87
KB
-rwxr-xr-x
rotation.php
634
B
-rwxr-xr-x
rvdates.php
6.58
KB
-rwxr-xr-x
sample.php
2.13
KB
-rwxr-xr-x
sectionwisepermission.php
5.66
KB
-rwxr-xr-x
sendGridMail.php
1.25
KB
-rwxr-xr-x
sendLoginPassword.php
3.2
KB
-rwxr-xr-x
sendnotification.php
6.17
KB
-rwxr-xr-x
sendsmsapi.php
788
B
-rwxr-xr-x
sendusrandpws.php
1.01
KB
-rwxr-xr-x
serchbygrid.php
868
B
-rwxr-xr-x
servfeehead.php
3.97
KB
-rwxr-xr-x
services.php
3.58
KB
-rwxr-xr-x
sfeehead.php
5.62
KB
-rwxr-xr-x
stringspliter.php
731
B
-rwxr-xr-x
stuIAMarksPending.php
6.09
KB
-rwxr-xr-x
student.php
57.31
KB
-rwxr-xr-x
student_entry.php
61.92
KB
-rwxr-xr-x
studentportal_remove.php
6.3
KB
-rwxr-xr-x
subjectList_display.php
11.23
KB
-rwxr-xr-x
subject_freshExam.php
28.5
KB
-rwxr-xr-x
subjectfreez.php
13.52
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
10.21
KB
-rwxr-xr-x
subshort.php
5.83
KB
-rwxr-xr-x
system_utility.php
1.89
KB
-rwxr-xr-x
systemsetup.php
81.71
KB
-rwxr-xr-x
teachOficerEntry.php
7.21
KB
-rwxr-xr-x
teachers.php
15.78
KB
-rwxr-xr-x
transaction-series.php
4.99
KB
-rwxr-xr-x
update.php
720
B
-rwxr-xr-x
updateSection.php
4.87
KB
-rwxr-xr-x
update_defined_flag.php
3.5
KB
-rwxr-xr-x
update_query.php
334
B
-rwxr-xr-x
updateexamcnt.php
3.01
KB
-rwxr-xr-x
upload_studentPhoto.php
10.94
KB
-rwxr-xr-x
uploadmoduledetails.php
40.61
KB
-rwxr-xr-x
uploadzip.php
9.42
KB
-rwxr-xr-x
usersetup.php
25.66
KB
-rwxr-xr-x
usersubj_identification.php
5.71
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : subject_freshExam.php
<?php function replaceChars($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",""); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } function PopulateFreshExamSubject($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $Regno = $aobj_context->mobj_data["Regno"]; $degree = $aobj_context->mobj_data["degree"]; $exam = $aobj_context->mobj_data["Examno"]; $prevFreshSub = $aobj_context->mobj_data["prevFreshSub"]; $exam_appear=array(); $query = "select * from collexam where fdegree = '{$degree}' and fcollcode = '{$college_code}' and fexamno = '{$exam}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(fsubcrfrom,'%Y-%m-%d') AND DATE_FORMAT(fsubcrto,'%Y-%m-%d') "; $student_exam_details = $aobj_context->mobj_db->GetRow($query); if(count($student_exam_details) > 0) { }else { $id="<tr style='height: 20'>"; $id.="<td colspan=9 align = 'center'><b>Subject corrections are not available now!<b></td>"; $id.="</tr>"; $arr['html_data']=$id; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; } $qry = " select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO, IF(IFNULL(c.FCATEGORY,'')='',if(ifnull(s.FCASTE,'') = '', 'GM', s.FCASTE) ,c.FCATEGORY) AS FCATEGORY, if(c.Fgender='',s.Fgender,c.Fgender) as Fgender,c.FAPPEARA,c.FEXAMFEEA, c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE, c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH, c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE, c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE ,FREMARKS,c.FTOTSUBA,c.FTOTSUBB,c.FTOTSUBC,c.FTOTSUBD,c.FTOTSUBE,c.FTOTSUBF,c.FTOTSUBG,c.FTOTSUBH, c.FTOTSUBI,c.FTOTSUBJ,concat('*',c.FCONSTYPE) as FCONSTYPE,ifnull(c.FELIG,'0123456789') as FELIG, sum(if(t.fexamno = 'A',1,0)) as fcnta, sum(if(t.fexamno = 'B',1,0)) as fcntb, sum(if(t.fexamno = 'C',1,0)) as fcntc, sum(if(t.fexamno = 'D',1,0)) as fcntd, sum(if(t.fexamno = 'E',1,0)) as fcnte, sum(if(t.fexamno = 'F',1,0)) as fcntf, sum(if(t.fexamno = 'G',1,0)) as fcntg, sum(if(t.fexamno = 'H',1,0)) as fcnth, sum(if(t.fexamno = 'I',1,0)) as fcnti, sum(if(t.fexamno = 'J',1,0)) as fcntj, FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA, FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB, FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC , FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED , FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE , FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF , FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG , FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH , FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI , FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ , FFRESHEXAM from candsum c left join student s on s.FDEGREE=c.FDEGREE and s.FREGNO=c.FREGNO left outer join canddet t on c.fdegree = t.fdegree and c.fregno = t.fregno where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and c.FREGNO='{$Regno}' and ifnull(c.FFRESHEXAM,'') = '{$exam}'"; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); if($student_exam_details) { $fcnta = $student_exam_details['fcnta']; $fcntb = $student_exam_details['fcntb']; $fcntc = $student_exam_details['fcntc']; $fcntd = $student_exam_details['fcntd']; $fcnte = $student_exam_details['fcnte']; $fcntf = $student_exam_details['fcntf']; $fcntg = $student_exam_details['fcntg']; $fcnti = $student_exam_details['fcnti']; $fcntj = $student_exam_details['fcntj']; if($student_exam_details['FAPPEAR'.$exam]=='N') { $arr['html_data']="<tr style='height: 20px;color:red;font-size:18px;'><td COLSPAN=3 align = 'center'><b>Student is not eligible for the given examination<b></td></tr>"; //$id=" id ='cand_entry_".$exam."'"; } else if($student_exam_details['FAPPEAR'.$exam]=='P') { $arr['html_data']="<tr style='height: 20px;color:green;font-size:18px;'><td COLSPAN=3 align = 'center'><b>Student has already passed in the given examination.<b></td></tr>"; //$id=" id ='cand_entry_".chr($i)."'"; } else if($student_exam_details['FAPPEAR'.$exam]=='A' || $student_exam_details['FAPPEAR'.$exam]=='E') { array_push($exam_appear,$exam); //$id=" id='cand_entry_".$exam."'"; //$td_data="<Input onclick=showExamNosDiv('{$html_id}'); {$id} name='radio_common' type='radio'>"; //$id=''; } //if($exam ==$exam_appear); // $get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'"; // $lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree); // for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++) // { // if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='A') // { // $exam_A_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['A']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B') // { // $exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C') // { // $exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D') // { // $exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E') // { // $exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F') // { // $exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G') // { // $exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H') // { // $exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I') // { // $exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J') // { // $exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; // $semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; // } // } $get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'"; $lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree); $totsub = explode(',',$totsub); for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++) { if($lobj_get_total_sub_for_degree[$j]['FEXAMNO'] == 'A') { //var_dump($fcnta.' - '.$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']); if($totsub[$j] > 0) $exam_A_limit = $totsub[$j]; else if($fcnta > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_A_limit = $fcnta; else $exam_A_limit = $lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['A'] = $lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B') { if($totsub[$j] > 0) $exam_B_limit = $totsub[$j]; else if($fcntb > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_B_limit = $fcntb; else $exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C') { if($totsub[$j] > 0) $exam_C_limit = $totsub[$j]; else if($fcntc > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_C_limit = $fcntc; else $exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D') { if($totsub[$j] > 0) $exam_D_limit = $totsub[$j]; else if($fcntd > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_D_limit = $fcntd; else $exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E') { if($totsub[$j] > 0) $exam_E_limit = $totsub[$j]; else if($fcnte > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_E_limit = $fcnte; else $exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F') { if($totsub[$j] > 0) $exam_F_limit = $totsub[$j]; else if($fcntf > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_F_limit = $fcntf; else $exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G') { if($totsub[$j] > 0) $exam_G_limit = $totsub[$j]; else if($fcntg > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_G_limit = $fcntg; else $exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H') { if($totsub[$j] > 0) $exam_H_limit = $totsub[$j]; else if($fcnth > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_H_limit = $fcnth; else $exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I') { if($totsub[$j] > 0) $exam_I_limit = $totsub[$j]; else if($fcnti > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_I_limit = $fcnti; else $exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J') { if($totsub[$j] > 0) $exam_J_limit = $totsub[$j]; else if($fcntj > $lobj_get_total_sub_for_degree[$j]['FTOTSUB']) $exam_J_limit = $fcntj; else $exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } } if(in_array($exam,$exam_appear)) { $id=''; $remaining_count=0; $id="\$exam_".$exam; $html_id="candidate_list_exam_".$exam."_details"; $char_name=$exam; $max_limit="\$exam_".$char_name."_limit"; eval("\$max_limit = \"$max_limit\";"); $FEXAMNO=$exam; $id="<table class='tr_ventor_row content-tbl' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $id.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:10px; padding-left:6px; height:20px;'>{$semister_names[$FEXAMNO]}</th>"; $id.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $id.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:100px;padding:5px 5px;'>Sub Code</td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:100px;padding:5px 5px;'>QP Code</td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;padding:5px 5px;'>Subject / Paper Name </td>"; $id.="</tr>"; $get_header_exam_details ="select c.FSUBCODE,s.FSUBNAME,ifnull(c.FPASSMTH,'') as FPASSMTH, s.FQPCODE AS FSUBSHORT,c.FEXAMTYPE, ifnull(c.FPRESENT,'N') as FPRESENT, if(c.FINSERTED='','F',c.FINSERTED) as FINSERTED, s.fmandatory from canddet c inner join subject s on s.FDEGREE=c.FDEGREE and s.FSUBCODE=c.FSUBCODE where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and c.FEXAMNO='{$FEXAMNO}' and c.FREGNO='{$Regno}' and (s.fsubcode = ifnull(s.fvarsubgrp,'') or ifnull(s.fvarsubgrp,'') = '') group by c.FSUBCODE order by c.FSUBCODE, FINSERTED,s.fmandatory desc limit $max_limit"; //var_dump($get_header_exam_details); $lobj_rs = $aobj_context->mobj_db->GetAll($get_header_exam_details); $remaining_count = $max_limit-count($lobj_rs); //var_dump($get_header_exam_details); $k=0; $txt_id=0; $subjectList=''; for($m=0;$m<count($lobj_rs);$m++) { $code_pop_up_field=""; $FSUBCODE=$lobj_rs[$m]['FSUBCODE']; $FSUBSHORT=$lobj_rs[$m]['FSUBSHORT']; $FSUBNAME=$lobj_rs[$m]['FSUBNAME']; if($lobj_rs[$m]['FPASSMTH']=='' or is_null($lobj_rs[$m]['FPASSMTH']))// to display pass M/Y based on the value { $checked=($lobj_rs[$m]['FPRESENT']=='P')?" checked ":""; $FPASSMTH="<input type='checkbox' {$checked} id='exam_{$char_name}_ce_pass_{$txt_id}'>"; $FPASSMTH_TD=""; $code_pop_up_field=""; } else { $FPASSMTH=$lobj_rs[$m]['FPASSMTH']; $FPASSMTH_TD=" id='exam_{$char_name}_ce_pass_{$txt_id}' "; $code_pop_up_field='readonly=true;'; } if($lobj_rs[$m]['fmandatory'] !='T' && $lobj_rs[$m]['FINSERTED'] == 'T')// to display text box for the value if FINSERTED=''T { //$subjectInstList.=$FSUBCODE."*"; $sub_code_input_border= "background-color:#fff"; $sub_code_input_popup=" onblur='getSubDetails(this.id,{$txt_id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'"; $sub_code_input_name="di"; $input_tab_indx=" tabindex={$txt_id}"; $read_only=" "; } else { $subjectPrevList.=$FSUBCODE."*"; $sub_code_input_border= " border:none;"; $sub_code_input_popup= ""; $sub_code_input_name="update"; $input_tab_indx=" tabindex=-1"; $read_only=" readonly"; } if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } $subjectList.=$FSUBCODE."*"; $idsub = "exam_{$char_name}_ce_sub_code_{$txt_id}"; $id.="<tr>"; $id.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input {$code_pop_up_field} {$inp_class} type=text style='width:60px; text-align:center;{$sub_code_input_border}' {$read_only} {$sub_code_input_popup} name='{$sub_code_input_name}' id='exam_{$char_name}_ce_sub_code_{$txt_id}' {$input_tab_indx} value='{$FSUBCODE}'> <input style='text-align:center;' type = 'hidden' id = 'old_exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'> </td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}' > {$FSUBSHORT}</td>"; $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;padding:5px 5px;'> {$FSUBNAME}</td>"; $id.="</tr>"; $k++; $txt_id++; } $subject_prev_query = "select distinct FSUBCODE,FSUBNAME,FQPCODE AS FSUBSHORT from subject where INSTR('{$prevFreshSub}',FSUBCODE) and fdegree='{$degree}' group by FSUBCODE"; $lobj_subject_prev = $aobj_context->mobj_db->GetAll($subject_prev_query); if($remaining_count>0) { $k=0; for($j=0;$j<$remaining_count;$j++) { if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } $FSUBCODE=$lobj_subject_prev[$j]['FSUBCODE']; $FSUBSHORT=$lobj_subject_prev[$j]['FSUBSHORT']; $FSUBNAME=$lobj_subject_prev[$j]['FSUBNAME']; $idsub = "exam_{$char_name}_ce_sub_code_{$txt_id}"; $id.="<tr>"; $id.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input type='text' {$inp_class} name='new_insert' onblur='getSubDetails(this.id,{$txt_id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' style='width:60px;background-color:none' tabindex={$txt_id} id='exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'> <input type = 'hidden' id = 'old_exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'></td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}'>{$FSUBSHORT}</td>"; $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>{$FSUBNAME}</td>"; $id.="</tr>"; $k++; $txt_id++; } } // if(empty($lobj_rs)) // { // $id.="<tr style='height: 20'>"; // $id.="<td COLSPAN=3 align = 'center'><b>No Records Found For this Search<b></td>"; // $id.="</tr>"; // } $total_count_of_each_div[$html_id]=$txt_id; $exam_fee_val=$exam_fee[$html_id]; $exam_receipt_no_val=$exam_receipt_no[$html_id]; $exam_receipt_no_date_val=$exam_receipt_no_date[$html_id]; $arr['html_data']=$id; $arr['total_count_of_each_div']=$total_count_of_each_div; $arr['subject_pre']=$subjectPrevList; /* if($remaining_count>0) $arr['subject_pre']=$subjectPrevList; else $arr['subject_pre']=$subjectInstList; */ } echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $id="<tr style='height: 20'>"; $id.="<td COLSPAN=3 align = 'center'><b>No Records Found For this Search<b></td>"; $id.="</tr>"; $arr['html_data']=$id; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; } } function PopulateFreshExamNo($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $Regno = $aobj_context->mobj_data["Regno"]; $degree = $aobj_context->mobj_data["degree"]; $get_fresh_exam="select c.ffreshexam,d.fexamname from student s inner join degree d on d.FDEGREE=s.FDEGREE left join candsum c on c.fregno = s.fregno where s.fcollcode= '{$college_code}'and s.fregno='{$Regno}' and d.fexamno = c.ffreshexam"; $lobj_rs_get_fresh_exam = $aobj_context->mobj_db->GetRow($get_fresh_exam); $error_blog='Not a Valid Register No'; if($lobj_rs_get_fresh_exam) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs_get_fresh_exam,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($error_blog,-1,"error"); } function saveFreshExamEntry($aobj_context) { session_start(); include_once("/JSON.php"); $json = new Services_JSON(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $FLOGNAME = $_SESSION['usr']; $reg_no = $aobj_context->mobj_data["reg_no"]; $degree = $aobj_context->mobj_data["degree"]; $exam = $aobj_context->mobj_data["fresh_exam"]; $lstr_param = stripslashes($aobj_context->mobj_data["details"]); $mobj_jsondata = $json->decode($lstr_param); $sub_arr_data = get_object_vars($mobj_jsondata); $sub_prev= $aobj_context->mobj_data["prevSubj"]; $sub_prev_in = str_replace("*", "','", $sub_prev); // var_dump($sub_prev); $sub_prev = explode("*", $sub_prev); // var_dump($sub_prev); $check_adminsion_freeze =" select distinct c.FCCLSTATUS, d.fmeyear, d.fmeexamtyp from colldeg c, degree d where c.fdegree = d.fdegree and c.FCOLLCODE='{$college_code}' and c.FDEGREE='{$degree}'"; $lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); $qry ="select distinct * from candsum c where c.FCOLLCODE='{$college_code}' and c.FDEGREE='{$degree}' and c.fregno = '{$reg_no}' and ifnull(ffreshexam,'') ='{$exam}'"; $res = $aobj_context->mobj_db->getRow($qry); $semexamfee = $res["FEXAMFEE{$exam}"]; $prs = ""; if($semexamfee > 0) { $prs = "P"; } if(is_null($lobj_check_adminsion_freeze['FCCLSTATUS'])) { $lstr_sub_fee = stripslashes($aobj_context->mobj_data["sub_fee"]); $mobj_lstr_sub_fee = $json->decode($lstr_sub_fee); $sub_fee_data = get_object_vars($mobj_lstr_sub_fee); //delete Newly inserted records $exam_data=''; $char_id=$exam; $exam_data=get_object_vars($sub_arr_data[$char_id]); // var_dump($exam_data); $SubjectArray[1]=$exam_data; $exam_Subjdata=''; $exam_Subjdata=get_object_vars($sub_arr_data[$char_id]); // do insert/update $sub_fresh=''; $char_id=$exam; if(!empty($exam_Subjdata)) { for($k=0;$k<count($exam_Subjdata);$k++) { if (!in_array($exam_Subjdata[$k]->sub, $sub_prev, true)) { $sub_fresh.=$exam_Subjdata[$k]->sub.'*'; } if($exam_Subjdata[$k]->sub != $exam_Subjdata[$k]->oldsub) { if($exam_Subjdata[$k]->oldsub == "") { $query="insert into canddet (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, fyear, fexamtype, fmoduser, fmoddate) values ( '{$degree}', '{$exam_Subjdata[$k]->ex}', '{$college_code}', '{$reg_no}', '{$exam_Subjdata[$k]->sub}', 'T', '{$prs}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}', '{$FLOGNAME}',now() )"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query); }else { $query = "update canddet set fsubcode = '{$exam_Subjdata[$k]->sub}', fpresent = '{$prs}', fmoduser = '{$FLOGNAME}', fmoddate = now() where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' and fsubcode = '{$exam_Subjdata[$k]->oldsub}'"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query); $query1 = "update appcanddet set fsubcode = '{$exam_Subjdata[$k]->sub}', fpresent = '{$prs}' where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' and fsubcode = '{$exam_Subjdata[$k]->oldsub}'"; $res = $aobj_context->mobj_db->Execute($query1); } $query1 = "insert ignore into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype) select c.fdegree,c.fexamno,c.fcollcode,c.fregno, s.fcsubcode,'-1', c.fyear,c.fexamtype from candsum c inner join subject s on c.fdegree = s.fdegree and s.fexamno = '{$exam_Subjdata[$k]->ex}' and s.FSUBCODE = '{$exam_Subjdata[$k]->sub}' where c.fregno = '{$reg_no}' and c.fcollcode = '{$college_code}' and c.fdegree = '{$degree}' and s.fintass = 'T' and s.fretain = 'T'"; $res = $aobj_context->mobj_db->Execute($query1); $query = "insert ignore into marks_pr (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks11, fyear, fexamtype) select cd.fdegree,cd.fexamno,cd.fcollcode,cd.fcollcode,s.fcsubcode,'-1', cd.fyear,cd.fexamtype from subject s inner join candsum cd on s.fdegree = cd.fdegree and s.fsubcode = '{$exam_Subjdata[$k]->sub}' and cd.fregno = '{$reg_no}' and ifnull(cd.fpassmth,'') = '' and ifnull(cd.fthpr,'') <> 'F' where s.fdegree = '{$degree}' and cd.fcollcode = '{$college_code}' and s.ftheory = 'F' and ifnull(s.fintass,'F') <> 'T'"; $res = $aobj_context->mobj_db->Execute($query); } } } if($lobj_insert_canddet_records) { $select_nxtreg_query="select FREGNO from student where FREGNO > '{$reg_no}' and FCOLLCODE='{$college_code}' order by FREGNO limit 1"; $lobj_select_nxtreg=$aobj_context->mobj_db->getRow($select_nxtreg_query); $preg_details=array(); $preg_details[0]=$reg_no; $preg_details[1]=$degree; $preg_details[2]=$exam; $arr['prev_reg']=$preg_details; $arr['next_reg']=$lobj_select_nxtreg; $arr['prev_subjects']=$sub_fresh; //$arr='Details Updated Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Updation failed'; $arr['prev_subjects']=''; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; } } else { $arr='Candidate List Freezed By Admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } ?>
Close