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.137.219.221
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
oasis /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
CIEAttendanceNotEligible.php
3.28
KB
-rw-rw-r--
CIEpendingList.php
5.85
KB
-rw-rw-r--
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
-rw-rw-r--
ECHblk.php
14.61
KB
-rwxr-xr-x
ECHblk_15042021.php
11.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
30.6
KB
-rw-rw-r--
MarkEntry-Setup_bf_gcg.php
22.89
KB
-rwxr-xr-x
MarkEntry-Setupx.php
30.61
KB
-rwxr-xr-x
SelectSubjType.php
3.05
KB
-rw-rw-r--
SubjectType.php
3.62
KB
-rw-rw-r--
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
UpdateCollDet.php
2.03
KB
-rwxr-xr-x
absentAndMalReportPdf.php
8.25
KB
-rw-rw-r--
absentEntryYearModewise.php
991
B
-rw-rw-r--
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
11.36
KB
-rwxr-xr-x
ack_adm_application.php
103.36
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
20.27
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.71
KB
-rwxr-xr-x
ack_report.php
3.69
KB
-rwxr-xr-x
ack_rv_rt_application.php
9.34
KB
-rwxr-xr-x
actClass.php
6.21
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
4.43
KB
-rw-r--r--
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
-rwxrwxrwx
approve.php
41.53
KB
-rwxr-xr-x
approve_kus.php
24.12
KB
-rwxr-xr-x
assignUserMenu.php
13.66
KB
-rw-rw-r--
attCisshortList_sjbit.php
11.91
KB
-rw-r--r--
attEntTeachWise.php
2.07
KB
-rw-rw-r--
attEntryDaywise.php
26.9
KB
-rw-rw-r--
attTeachSum.php
3.63
KB
-rw-r--r--
attendEntry.php
5.32
KB
-rw-rw-r--
attendance.php
17.09
KB
-rwxr-xr-x
attendanceReportForm.php
6.36
KB
-rw-rw-r--
attendance_freez.php
8.51
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendanceentrydaywise.php
11.36
KB
-rw-r--r--
attendenceshort.php
7.58
KB
-rw-rw-r--
attshort.php
6.29
KB
-rwxr-xr-x
atttechblp.php
2.48
KB
-rw-r--r--
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
4.12
KB
-rwxr-xr-x
backup_1.php
7.85
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
-rw-rw-r--
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
-rw-rw-r--
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
-rw-rw-r--
colltransfer.php
6.83
KB
-rw-rw-r--
connect.php
2.58
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
convo.php
8.14
KB
-rw-rw-r--
copoMarksList.php
1.27
KB
-rw-rw-r--
copomarksentry.php
10.46
KB
-rw-r--r--
copomarksexternal.php
23.05
KB
-rw-r--r--
coporeport.php
4.56
KB
-rw-r--r--
courserep.php
1.68
KB
-rw-r--r--
coutput.php
1.84
KB
-rwxr-xr-x
createAdmission.php
14.91
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.99
KB
-rw-rw-r--
createclassattend.php
22.03
KB
-rw-r--r--
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
degree_SujectReport.php
893
B
-rw-rw-r--
degstudymat.php
6.51
KB
-rwxr-xr-x
degstudymatdet.php
6.27
KB
-rwxr-xr-x
degwiseIAreport.php
2.95
KB
-rw-rw-r--
display_details_in_grid.php
107.2
KB
-rw-rw-r--
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
-rw-rw-r--
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
7.01
KB
-rw-rw-r--
enableStudReg.php
7.65
KB
-rwxr-xr-x
entregupd.php
1.91
KB
-rw-rw-r--
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examappfeereport.php
2.12
KB
-rw-rw-r--
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.77
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.32
KB
-rw-rw-r--
getMessages.php
11.39
KB
-rwxr-xr-x
getTestTotalMarksReport.php
11.96
KB
-rw-rw-r--
getdata.php
39.06
KB
-rwxrwxrwx
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
ia_room_allotment_datewise.php
12.13
KB
-rwxr-xr-x
iaabsententry.php
3.1
KB
-rw-r--r--
iamarks.php
7.68
KB
-rw-r--r--
iaroomdeclaration.php
2.6
KB
-rwxr-xr-x
iasectionwise.php
30.09
KB
-rw-r--r--
iasectionwisenew.php
35.77
KB
-rw-r--r--
iatimetable.php
7.61
KB
-rw-r--r--
identifyCoMarksNew.php
2.6
KB
-rw-rw-r--
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
invigilatorDairyRoomWise.php
6.07
KB
-rw-rw-r--
json.php
34.52
KB
-rwxr-xr-x
lateralentry.php
2.39
KB
-rwxr-xr-x
login.php
8.88
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
marksEntryExt.php
9.11
KB
-rwxr-xr-x
marksentryext.php
13.1
KB
-rw-rw-r--
marksentryquestionwise.php
41.93
KB
-rw-rw-r--
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
155.51
KB
-rwxr-xr-x
mregistry18.06.2021.php
99.46
KB
-rwxr-xr-x
mregistry_14092024.php
150.27
KB
-rw-rw-r--
mrn_approval.php
9
KB
-rwxr-xr-x
oldqnpaper.php
4.44
KB
-rw-rw-r--
pendingcie.php
4.21
KB
-rw-rw-r--
picharttesting.php
24.76
KB
-rw-r--r--
pmarks.php
5.97
KB
-rw-rw-r--
post.php
6
KB
-rwxr-xr-x
practicalMarks.php
8.67
KB
-rw-rw-r--
prbillreport.php
5.07
KB
-rw-r--r--
prientCodeStikers.php
6.35
KB
-rw-r--r--
principalFreeze.php
6.92
KB
-rw-rw-r--
principalfreezingsubject.php
1.9
KB
-rw-rw-r--
printAdmRegn.php
13.13
KB
-rwxr-xr-x
printApp_ru.php
1.12
KB
-rw-rw-r--
printMarkListDetailsWisenew_sj...
14.42
KB
-rw-r--r--
qnwiseMarksStats.php
6.14
KB
-rw-rw-r--
qnwisemarksentrynew.php
18.61
KB
-rw-rw-r--
qpSummaryReport.php
1.03
KB
-rw-rw-r--
receive_rv_rt_application.php
8.33
KB
-rwxr-xr-x
receive_teach_trans.php
2.49
KB
-rw-rw-r--
receive_teach_transfer.js
5.06
KB
-rw-rw-r--
remunerationEntry.php
7.14
KB
-rw-rw-r--
repeateriamarksentry.php
4.86
KB
-rw-rw-r--
report_bulk_applications.php
19.42
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
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
-rw-rw-r--
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
roomAllotment.php
37.45
KB
-rw-rw-r--
room_allotment.php
9.14
KB
-rwxr-xr-x
room_allotment_datewise.php
26.07
KB
-rwxr-xr-x
room_allotment_datewise_bf_rcu...
16.97
KB
-rwxr-xr-x
room_allotment_datewise_stph.p...
21.57
KB
-rwxr-xr-x
room_allotment_datewise_stph_n...
29.01
KB
-rwxr-xr-x
room_allotment_shifiting.php
3.34
KB
-rwxr-xr-x
roomallotmentExcel.php
8.23
KB
-rw-rw-r--
roomallotmentqpwise.php
10.22
KB
-rw-rw-r--
roomallotmentqpwisenew.php
13.92
KB
-rw-rw-r--
roomcreationnew.php
2.81
KB
-rw-rw-r--
roomdeclaration.php
2.2
KB
-rwxr-xr-x
roomdeclaration_stph.php
2.51
KB
-rwxr-xr-x
roomwiseinvigilatorsEntry.php
9.86
KB
-rw-rw-r--
rvdates.php
6.46
KB
-rw-rw-r--
rvrt_ack_exam_app.php
6
KB
-rw-rw-r--
rvrt_report.php
1.92
KB
-rw-rw-r--
savePassword.php
1.14
KB
-rw-rw-r--
saveclsdets.php
1.91
KB
-rw-rw-r--
savesspdetails.php
9.93
KB
-rw-rw-r--
sectionwisepermission.php
5.67
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
-rw-rw-r--
std_register_det.php
3.56
KB
-rw-rw-r--
stringspliter.php
693
B
-rwxr-xr-x
studSubIdent.php
11.23
KB
-rw-r--r--
stud_name_doc_upload.php
1.24
KB
-rw-rw-r--
stud_wise_report.php
3.02
KB
-rw-rw-r--
student.php
58.23
KB
-rwxr-xr-x
student_entry.php
61.39
KB
-rwxr-xr-x
student_entry_kswu.php
51.23
KB
-rwxr-xr-x
student_entry_nitte.php
88.09
KB
-rw-rw-r--
student_entry_rur.php
74.42
KB
-rw-rw-r--
student_entry_vku.php
66.58
KB
-rwxr-xr-x
student_rur.php
64.37
KB
-rw-rw-r--
student_vku.php
57.95
KB
-rwxr-xr-x
studentfeesandattiashortagedat...
11.38
KB
-rw-rw-r--
studentportal_remove.php
6.18
KB
-rwxr-xr-x
studentreport.php
15.37
KB
-rw-rw-r--
studnamecorr.php
6.69
KB
-rw-rw-r--
subIAMarksEntry.php
11.14
KB
-rw-rw-r--
subblock.php
6.12
KB
-rwxr-xr-x
subdet.php
9.61
KB
-rw-rw-r--
subjReg.php
12.04
KB
-rw-r--r--
subjectList_display.php
11.7
KB
-rwxr-xr-x
subject_freshExam.php
33.18
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.97
KB
-rw-rw-r--
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.41
KB
-rwxr-xr-x
teachFreeze.php
8.17
KB
-rw-r--r--
teachOficerEntry.php
11.46
KB
-rwxr-xr-x
teachers.php
19.76
KB
-rwxr-xr-x
theoryMarksEntry.php
4.89
KB
-rw-rw-r--
thvalmarks.php
2.72
KB
-rw-r--r--
time_table_degreewise.php
5
KB
-rwxrwxrwx
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.74
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rw-r--r--
updatedegreegroup.php
3.21
KB
-rw-rw-r--
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updatefreshexam.php
1.33
KB
-rw-rw-r--
updatestudentsem.php
2.03
KB
-rw-rw-r--
updatetimetable.php
9.14
KB
-rw-r--r--
updateuvcms.php
2.37
KB
-rw-rw-r--
updmarks.php
22.24
KB
-rw-r--r--
updnemp.php
1.78
KB
-rw-r--r--
upload_doc_demo.php
84
B
-rw-rw-r--
upload_studentPhoto.php
10.81
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.89
KB
-rw-r--r--
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadteacherattendance.php
5.23
KB
-rw-r--r--
userpasswordreset.php
754
B
-rw-rw-r--
usersetup.php
24.46
KB
-rwxr-xr-x
usersetupNew.php
12.76
KB
-rw-r--r--
usersubj_identification.php
5.15
KB
-rwxr-xr-x
viewNotifications.php
1.21
KB
-rw-rw-r--
view_ledger.php
3.64
KB
-rwxrwxrwx
yearmode.php
1.83
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : display_details_in_grid_bf_23102021.php
<?php include_once("/JSON.php"); $json = new Services_JSON(); function getsearchcondition($cond,$val) { switch($cond) { case 'eq': $cond="="; $value="'".$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'ne': $cond="!="; $value="'".$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'lt': $cond="<"; $value="'".$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'le': $cond="<="; $value="'".$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'gt': $cond=">"; $value="'".$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'ge': $cond=">="; $value="'".$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'cn': $cond="like '%"; $value=$val."%'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'nc':// Doesnot Contain $cond="not like '%"; $value=$val."%'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'bw': $cond="like '"; $value=trim($val)."%'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'bn'://Does Not Begin With $cond="not like '"; $value=trim($val)."%'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'ew': $cond="like '%"; $value=$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'en'://Does Not Ends With $cond="not like '%"; $value=$val."'"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'in'://Is in $cond="in '("; $value=$val."')"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; case 'in'://Is not in $cond="notin '("; $value=$val."')"; $final_value[0]=$cond; $final_value[1]=$value; return $final_value; break; } } function viewUserSchemaDeiatlstest($aobj_context) { include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select s.internal_code as id,s.module_name as grid_module_name,t.value as grid_module_type from s_user_schema s inner join s_ref_type t on t.internal_code=s.module_type )a where $field_name $cond$value"; } else { $count_id="select count(*) as count from s_user_schema s inner join s_ref_type t on t.internal_code=s.module_type"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select s.internal_code as id,s.module_name as grid_module_name,t.value as grid_module_type from s_user_schema s inner join s_ref_type t on t.internal_code=s.module_type )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select s.internal_code as id,s.module_name as grid_module_name,t.value as grid_module_type from s_user_schema s inner join s_ref_type t on t.internal_code=s.module_type ORDER BY $sidx $sord LIMIT $start , $limit"; //echo $SQL; } //echo $SQL; $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; //id $responce->rows[$i]['cell']=array($row[grid_module_name],$row[grid_module_type]); $i++; } echo json_encode($responce); // return the formated data } function CollegeDetailsPopup($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $mod_type = $_GET['type']; $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; $cond=''; $value=''; /* if($mod_type == '') { $cond=' '; } else { $cond= "and c.{$mod_type} is NULL"; } */ $search =$aobj_context->mobj_data["_search"]; // to take th e parameters from Search field $filter_toolbal_cond=""; if($search=='true') { $Colcode =$aobj_context->mobj_data["FCOLLCODE"]; $Desc =$aobj_context->mobj_data["FCOLLNAME"]; if(isset($Colcode) && !empty($Colcode)) $filter_toolbal_cond.="FCOLLCODE like '{$Colcode}%'"; /* if(isset($Desc) && !empty($Desc)) $filter_toolbal_cond.=" and FDESCPN like '{$Desc}%'"; */ } if($search=='true') { $count_id="select count(distinct FCOLLCODE) as count from college where {$filter_toolbal_cond}"; } else { $count_id="select count(distinct FCOLLCODE) as count from college "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if($count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if($search=='true') { $SQL="select * from (select FCOLLCODE as id,FCOLLCODE,FCOLLNAME from college)a where {$filter_toolbal_cond} group by FCOLLCODE ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select FCOLLCODE as id,FCOLLCODE,FCOLLNAME from college ORDER BY $sidx $sord LIMIT $start , $limit"; } // echo $SQL; $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; //id $responce->rows[$i]['cell']=array($row[FCOLLCODE],$row[FCOLLNAME]); $i++; } echo json_encode($responce); } function degreeDetailsPopupOld($aobj_context) { include_once("/JSON.php"); //echo $lstr_ids; session_start(); $college_code = $_SESSION['collcode']; $json = new Services_JSON(); $mod_type = $_GET['type']; $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; $cond=''; $value=''; if($mod_type == '') { $cond=' '; } else { $cond= "and c.{$mod_type} is NULL"; } $search =$aobj_context->mobj_data["_search"]; // to take th e parameters from Search field $filter_toolbal_cond=""; if($search=='true') { $Degcode =$aobj_context->mobj_data["FDEGREE"]; $Desc =$aobj_context->mobj_data["FDESCPN"]; if(isset($Degcode) && !empty($Degcode)) $filter_toolbal_cond.=" d.FDEGREE like '{$Degcode}%'"; /* if(isset($Desc) && !empty($Desc)) $filter_toolbal_cond.=" and FDESCPN like '{$Desc}%'"; */ } if($search=='true') { $count_id="select count(distinct FDEGREE) as count from colldeg where {$filter_toolbal_cond}"; } else { $count_id="select count(distinct FDEGREE) as count from colldeg "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if($search=='true') { $SQL="select c.FDEGREE as id, c.FDEGREE,d.FDESCPN from colldeg c inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}' and c.FDELETED = 'F' {$cond} where {$filter_toolbal_cond} group by FDEGREE ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = " select c.FDEGREE as id, c.FDEGREE,d.FDESCPN from colldeg c inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}' and c.FDELETED = 'F' {$cond} group by FDEGREE ORDER BY $sidx $sord LIMIT $start , $limit"; } // echo $SQL; $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; //id $responce->rows[$i]['cell']=array($row[FDEGREE],$row[FDESCPN]); $i++; } echo json_encode($responce); } function degreeDetailsPopup($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $userid = $_SESSION['user_id']; $user_type = $_SESSION['user_type']; //var_dump($user_type); $type = ($aobj_context->mobj_data["type"]); $module = $aobj_context->mobj_data["module"]; //var_dump($module); if($mod_type == '') { $cond=' '; } else { $cond= "and c.{$mod_type} is NULL"; } if($type == 'FCADSTATUS') { $fadmdeg = "inner join mascomb mc on c.fdegree = mc.fdegree and ifnull(mc.fdeleted,'') <> 'T'"; }else { $fadmdeg = " "; } if($type == "FCMESTATUS" || $type == "FCPRSTATUS") { if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER') { $ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'"; } else { $ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and c.FCOLLCODE='{$college_code}' inner join usersub us on d.fdegree = us.fdegree and c.fcollcode = us.fcollegecode and us.fuser = '{$userid}'"; } }else { $ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'"; } 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('FDEGREE','FDESCPN'); if(strtolower($college_code) == 'lsys' || strtolower($user_type) == 'lsys') { $display_obj->display_qry = " select distinct FDEGREE as id,FDEGREE,FDESCPN from degree where ifnull(FDELETED,'') <> 'T' "; } else { $display_obj->display_qry = "select distinct c.FDEGREE as id, c.FDEGREE,d.FDESCPN from colldeg c {$ltable} and ifnull(c.FDELETED,'') <> 'T' {$cond} {$fadmdeg} where 1=1 "; } // var_dump($display_obj->display_qry); $display_obj->DisplayDetailsInGrid(); } function ExamnoDetailsPopup($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $DegCode =$_GET['DegCode']; if(!$sidx) $sidx =1; $cond=''; $value=''; // to take th e parameters from Search field $search =$aobj_context->mobj_data["_search"]; // to take th e parameters from Search field $filter_toolbal_cond=""; if($search=='true') { $Examno =$aobj_context->mobj_data["fexamno"]; if(isset($DegCode) && !empty($DegCode)) $filter_toolbal_cond.=" fdegree like '{$DegCode}%'"; if(isset($Examno) && !empty($Examno)) $filter_toolbal_cond.="AND fexamno like '{$Examno}%'"; } if($search=='true') { $count_id="select count(*)as count from degree where {$filter_toolbal_cond}"; } else { $count_id="select count(*)as count from degree where fdegree ='".$DegCode."'"; } /* $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); */ $result=$aobj_context->mobj_db->getRow($count_id); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if($search=='true') { $SQL="select * from (select fexamno as id, fexamno,fexamname from degree where {$filter_toolbal_cond})a ORDER BY $sidx $sord LIMIT $start,$limit"; //where $field_name $cond$value } else { $SQL = "select fexamno as id, fexamno,fexamname from degree where fdegree='".$DegCode."' ORDER BY $sidx $sord LIMIT $start , $limit"; // echo $SQL; } //echo $SQL; //$result = mysql_query($SQL) or die("Could not execute query.".$count); $result = $aobj_context->mobj_db->getAll($SQL); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; /* while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; //id $responce->rows[$i]['cell']=array($row[fexamno],$row[fexamname]); $i++; } */ foreach($result as $key=>$val) { $responce->rows[$i]['id']=$val[id]; //id $responce->rows[$i]['cell']=array($val[fexamno],$val[fexamname]); $i++; } echo json_encode($responce); } function SubjectMarkDetailsPopup($aobj_context) { session_start(); $univcode = $_SESSION['FUNIVCODE']; $college_code = $_SESSION['collcode']; $userID = $_SESSION['user_id']; $user_type = strtoupper($_SESSION['user_type']); $Degree_code = $aobj_context->mobj_data["DegCode"]; $Exam_no = $aobj_context->mobj_data["Examno"]; $module = $aobj_context->mobj_data["module"]; $modulename = $aobj_context->mobj_data["modulename"]; $moduletype = $aobj_context->mobj_data["moduletype"]; $category = $aobj_context->mobj_data["category"]; //$search =$aobj_context->mobj_data["_search"]; 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('fcsubcode','fsubname','fssubname','fshortname','fsmaxmarks'); //var_dump($modulename); if($modulename == 'SaveAttendanceEntry') { $condition = ''; if($moduletype == '01') { $condition = "AND s.FTHEORY ='T' AND s.FINTASS = 'F' and INSTR(us.fsubcode,s.fsubcode) > 0 "; } if($moduletype == '11' || $moduletype == '13') { $condition = "AND s.FTHEORY ='F' AND s.FINTASS = 'F' and INSTR(us.fsubcode,s.fsubcode) > 0 "; } if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER' || strtoupper($_SESSION['user_type']) =='BASKARAN') { $user = ""; $user_sub = ""; $condition = "AND s.FTHEORY ='T' AND s.FINTASS = 'F'"; }else { $user_sub = "INNER JOIN usersub us on m.fdegree = us.fdegree and m.fcollcode = us.fcollegecode"; $user = "and us.fuser = '{$userID}'"; } $display_obj->display_qry = "SELECT DISTINCT fcsubcode AS id,fcsubcode,fsubname,fssubname, CONCAT(fshortname,'(',fsubshort,')') AS fshortname,fvalmax as fsmaxmarks FROM subject s INNER JOIN colldeg m ON s.fdegree = m.fdegree $user_sub WHERE m.FCOLLCODE = '{$college_code}' AND s.fdegree = '{$Degree_code}' AND s.fexamno = '{$Exam_no}' {$condition} {$user}"; } else if($modulename == 'Subject Wise Block') { $condition = "AND s.FTHEORY ='T' AND s.FINTASS = 'F'"; $display_obj->display_qry = "SELECT DISTINCT fsubcode AS id,fsubcode as fcsubcode,fsubname,fssubname, CONCAT(fshortname,'(',fsubshort,')') AS fshortname,fvalmax as fsmaxmarks FROM subject s INNER JOIN colldeg m ON s.fdegree = m.fdegree WHERE m.FCOLLCODE = '{$college_code}' AND s.fdegree = '{$Degree_code}' AND s.fexamno = '{$Exam_no}' {$condition}"; } else { $cat_cond = ""; $select_category_cond = "select Value from markentrycodition where FMODULE='{$module}' and Code='{$category}' and ifnull(FDELETED,'')<>'T'"; $lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond); if(!empty($lobj_select_category_cond) && ($lobj_select_category_cond['Value']!='0' || $lobj_select_category_cond['Value']!=0)) $cat_cond=" and ".$lobj_select_category_cond['Value']; if($module == 'ME') { $get_freezed_subject = "select ifnull(group_concat(fsubcode separator '*'),'') as type from collia where FDEGREE = '{$Degree_code}' and fexamno = '{$Exam_no}' and FCOLLCODE = '{$college_code}' and ffreezed = 'T' order by fsubcode"; //var_dump($get_freezed_subject); $obj_get_status = $aobj_context->mobj_db->GetRow($get_freezed_subject); $freezed_cond=""; if($univcode != 18) { if(trim($obj_get_status['type']) == '') $freezed_cond =""; else { //$count_type = strlen($obj_get_status['type'])-1; $freezed_module1 = $obj_get_status['type']; //var_dump($freezed_module1);//substr($obj_get_status['type'],0,$count_type); $frz_module = "'".str_replace("*","','",$freezed_module1)."'"; $freezed_cond = "and s.FCSUBCODE NOT IN ({$frz_module}) "; } } } //var_dump($_SESSION['user_type']); if($module == 'ME') { if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER' || strtoupper($_SESSION['user_type']) =='BASKARAN') { $ltable = 'inner join marks m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode'; } else { $ltable = "inner join marks m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode inner join usersub us on m.fdegree = us.fdegree and instr(us.fsubcode,m.fsubcode) > 0 and m.fcollcode = us.fcollegecode and us.fuser = '{$userID}'"; } } elseif($module == 'PR') { if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER' || strtoupper($_SESSION['user_type']) =='BASKARAN') { $ltable = 'inner join marks_pr m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode'; } else { $ltable = "inner join marks_pr m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode inner join usersub us on m.fdegree = us.fdegree and instr(us.fprsubcode,m.fsubcode) > 0 and m.fcollcode = us.fcollegecode and us.fuser = '{$userID}'"; } } else { $ltable = 'inner join colldeg m on s.fdegree = m.fdegree'; } if($module == 'PR') { $collcode = "1=1"; }else { $collcode = "m.FCOLLCODE = '{$college_code}'"; } if($module == 'AT') { $cat_cond = "and s.fintass = 'F' and s.fretain = 'F'"; } $display_obj->display_qry ="select distinct fcsubcode as id,fcsubcode,fsubname,fssubname, concat(fshortname,'(',fsubshort,')') as fshortname,fvalmax as fsmaxmarks from subject s {$ltable} where {$collcode} and s.fdegree = '{$Degree_code}' and s.fexamno = '{$Exam_no}' {$cat_cond}"; } // var_dump($display_obj->display_qry); $display_obj->DisplayDetailsInGrid(); /* $display_obj->display_qry ="select distinct fcsubcode as id,fcsubcode,fsubname,fssubname, concat(fshortname,'(',fsubshort,')') as fshortname,fsmaxmarks from subject s inner join colldeg c on s.FDEGREE = c.FDEGREE and s.fdegree = '{$Degree_code}' and s.fexamno='{$Exam_no}' inner join marks m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode and c.fcollcode = m.fcollcode left join usersub us on INSTR(us.fsubcode,s.fsubcode) where c.FCOLLCODE='{$college_code}' and fuser = '{$userID}' and us.fdegree = '{$Degree_code}' {$cat_cond} {$freezed_cond} "; } */ //var_dump($display_obj->display_qry ); /* include_once("/JSON.php"); session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Degree_code = $aobj_context->mobj_data["DegCode"]; $Exam_no = $aobj_context->mobj_data["Examno"]; $module = $aobj_context->mobj_data["module"]; $category = $aobj_context->mobj_data["category"]; $search =$aobj_context->mobj_data["_search"]; $select_category_cond="select * from markentrycodition where Code={$category}"; $cat_cond=''; $freezed_cond=''; $lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond); //var_dump($lobj_select_category_cond); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $DegCode =$_GET['DegCode']; if(!$sidx) $sidx =1; $cond=''; $value=''; // the actual query for the grid data //echo $frz_module; die(); $filter_toolbal_cond=""; // to take th e parameters from Search field if($search=='true') //if(isset($_GET['searchField']) && $_GET["searchField"]!='') { $ffsubcode =$aobj_context->mobj_data["ffsubcode"]; $fshortname =$aobj_context->mobj_data["fshortname"]; if(isset($DegCode) && !empty($DegCode)) $filter_toolbal_cond.=" fdegree = '{$DegCode}'"; if(isset($Exam_no) && !empty($Exam_no)) $filter_toolbal_cond.="AND fexamno ='{$Exam_no}'"; if(isset($ffsubcode) && !empty($ffsubcode)) $filter_toolbal_cond.="AND fcsubcode like '{$ffsubcode}%'"; if(isset($fshortname) && !empty($fshortname)) $filter_toolbal_cond.="AND fshortname like '{$fshortname}%'"; $filter_toolbal_cond.="and fretain='T' and fintass='T'"; } if($search=='true') { $count_id="select count(*) as count from subject where {$filter_toolbal_cond} "; } else { $count_id="select count(*) as count from subject where fdegree = '".$Degree_code."'and fexamno='".$Exam_no."' and fretain='T' and fintass='T'"; //echo $count_id; die(); } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; //var_dump($obj_get_status); die(); if( $_GET["_search"]=='true') { $SQL="select * from (select fcsubcode,fsubname,fssubname,fshortname,fsmaxmarks subject where fdegree = '".$Degree_code."'and fexamno='".$Exam_no."' and fretain='T' and fintass='T')a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = " select fcsubcode as id,fcsubcode,fsubname,fssubname,fshortname,fsmaxmarks from subject s inner join colldeg c on s.FDEGREE = c.FDEGREE and s.fdegree = '{$Degree_code}' and s.fexamno='{$Exam_no}' where c.FCOLLCODE='{$college_code}' {$cat_cond} {$freezed_cond} ORDER BY $sidx $sord LIMIT $start , $limit"; //echo $SQL; die(); } $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; //id $responce->rows[$i]['cell']=array($row[fcsubcode],$row[fsubname], $row[fssubname],$row[fshortname],$row[fsmaxmarks]); $i++; } echo json_encode($responce); */ } function attendancesubjectpopup($aobj_context) { session_start(); $univcode = $_SESSION['FUNIVCODE']; $college_code = $_SESSION['collcode']; $userID = $_SESSION['user_id']; $user_type = strtoupper($_SESSION['user_type']); $Degree_code = $aobj_context->mobj_data["DegCode"]; $Exam_no = $aobj_context->mobj_data["Examno"]; $module = $aobj_context->mobj_data["module"]; $category = $aobj_context->mobj_data["category"]; $condition = ''; if($module == 'TE') { $condition = "AND s.FTHEORY ='T' AND s.FINTASS = 'F'"; } if($module == 'PR') { $condition = "AND s.FTHEORY ='F' AND s.FINTASS = 'F'"; } $display_obj->display_qry = "SELECT DISTINCT fcsubcode AS id,fcsubcode,fsubname,fssubname, CONCAT(fshortname,'(',fsubshort,')') AS fshortname,fvalmax as fsmaxmarks FROM SUBJECT s INNER JOIN colldeg m ON s.fdegree = m.fdegree WHERE m.FCOLLCODE = '{$college_code}' AND s.fdegree = '{$Degree_code}' AND s.fexamno = '{$Exam_no}' {$condition}"; $display_obj->DisplayDetailsInGrid(); } function subjectDetailsPopup($aobj_context) { include_once("/JSON.php"); $subCode=$_GET['subCode']; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $exam = $_GET['exam']; $degree_code = $_GET['degree_code']; $searchField = $_GET['searchField']; $mand_field = $_GET['mand_field']; if($mand_field=='' ) { $mand_field_cond=" "; } else if($mand_field=='IdentifySubjFreshEx' ) { $mand_field_cond="and (s.fsubcode = ifnull(s.fvarsubgrp,'') or ifnull(s.fvarsubgrp,'') = '')"; } else { $mand_field_cond=" and FMANDATORY='F'"; // for candindate disaply no need to check FMANDATORY='F'"; } 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('FCSUBCODE','FSUBNAME','FSHORTNAME'); $display_obj->display_qry ="select FSUBCODE as id, FSUBCODE,FSUBSHORT,FSUBNAME 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}' {$mand_field_cond} and ifnull(FSUSPEND,'F')!='T' {$cond} group by FSUBCODE"; return $display_obj->DisplayDetailsInGrid(); } function getstudentEntryDetails($aobj_context) { session_start(); include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select FSLNO as id,FSLNO,FNAME,FDEGREE,FFATNAME,FMOTNAME from studadm where FCOLLCODE = '{$_SESSION['collcode']}' )a where $field_name $cond$value"; } else { $count_id="select count(*) as count from studadm where FCOLLCODE = '{$_SESSION['collcode']}' "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select FSLNO as id,FSLNO,FNAME,FDEGREE,FFATNAME,FMOTNAME from studadm where FCOLLCODE = '{$_SESSION['collcode']}' )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select FSLNO as id,FSLNO,FNAME,FDEGREE,FFATNAME,FMOTNAME from studadm where FCOLLCODE = '{$_SESSION['collcode']}' ORDER BY $sidx $sord LIMIT $start , $limit"; //echo $SQL; } $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[FSLNO],$value[FNAME],$value[FDEGREE],$value[FFATNAME],$value[FMOTNAME]); } // return the formated data echo $json->encode($responce); } //--- end by naveen function SubjectCodePopupForAnswerScript($aobj_context) { session_start(); $College_Code = $_SESSION['collcode']; $degree_code = ($aobj_context->mobj_data["DegCode"]); $exam_no = ($aobj_context->mobj_data["Examno"]); 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('FCSUBCODE','FSUBNAME','FSHORTNAME'); $display_obj->display_qry ="select S.FCSUBCODE as id, S.FCSUBCODE,S.FSUBNAME,S.FSHORTNAME from subject S INNER JOIN colldeg C ON S.FDEGREE=C.FDEGREE AND FCOLLCODE='{$College_Code}' WHERE S.FDEGREE='{$degree_code}' AND S.FEXAMNO='{$exam_no}' AND ifnull(S.FDELETED,'F')='F'"; $display_obj->DisplayDetailsInGrid(); } function SubjectShortNamePopup($aobj_context) { include_once("/JSON.php"); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Degree_code = $aobj_context->mobj_data["DegCode"]; $Exam_no = $aobj_context->mobj_data["Examno"]; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; //$DegCode =$_GET['DegCode']; if(!$sidx) $sidx =1; $cond=''; $value=''; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["searchField"]!='') { $cond='where FDEGREE like '; $value="'%".$_GET['searchField']."%'"; } $count_id="select count(*) as count from subject where fdegree = '{$Degree_code}'and fexamno='{$Exam_no}' and fretain='T' and fintass='T'"; $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select fshortname,fshortname as id subject where fdegree = '{$Degree_code}'and fexamno='{$Exam_no}' and fretain='T' and fintass='T')a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select fshortname as id,fshortname from subject where fdegree = '{$Degree_code}'and fexamno='{$Exam_no}' and fretain='T' and fintass='T' ORDER BY $sidx $sord LIMIT $start , $limit"; // echo $SQL; } //echo $SQL; die(); $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; //id $responce->rows[$i]['cell']=array($row[fshortname]); $i++; } echo json_encode($responce); } function StudentRegisterNoPopup($aobj_context) { session_start(); $CollegeCode = $_SESSION['collcode']; $degree = $aobj_context->mobj_data["degree"]; $CollegeCode = $_SESSION['FCOLLCODE']; $module_name_for_save = $aobj_context->mobj_data["module_name_for_save"]; 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('Fregno','Fname','FDoB'); // if($module_name_for_save=="SaveAbsentEntrySubjectwiseQP" || $module_name_for_save=="candidate_list") if($module_name_for_save=="SaveAbsentEntrySubjectwiseQP" || $module_name_for_save=="IdentifySubjFreshEx") { $display_obj->display_qry ="select distinct Fregno as id ,Fregno,Fname,FDoB from student where fregno!='' and fcollcode= '{$CollegeCode}' "; } else { $display_obj->display_qry ="select s.Fregno as id ,s.Fregno,s.Fname,s.FDoB from student s inner join candsum c on s.fcollcode=c.fcollcode and s.fregno=c.fregno where s.fcollcode= '{$CollegeCode}' and s.fregno!='' and ifnull(s.fdeleted,'F') <> 'T'"; } //var_dump($display_obj->display_qry); $display_obj->DisplayDetailsInGrid(); } //jijo updated function RegnoDetailsPopup($aobj_context) { session_start(); $CollegeCode = $_SESSION['collcode']; $degree = $aobj_context->mobj_data["degree"]; 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('Regno'); $display_obj->display_qry ="select internal_code as id ,FREGNO from mresult where FCOLLCODE= '{$CollegeCode}'"; //echo $display_obj->display_qry; die(); $display_obj->DisplayDetailsInGrid(); } function deleteUserSchemaDeiatls($aobj_context) { $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $lstr_qry = "delete from s_user_schema where internal_code in (".$lstr_ids.")"; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); $drop_table="drop table module_{$lstr_ids}"; $lobj_rs = $aobj_context->mobj_db->Execute($drop_table); $drop_table="drop table module_{$lstr_ids}_details"; $lobj_rs = $aobj_context->mobj_db->Execute($drop_table); $root_file_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/report_result_".$lstr_ids.".php"; $root_js_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/grid_display_files/module_".$lstr_ids.".js"; if(file_exists($root_file_name)) unlink($root_file_name); if(file_exists($root_js_name)) unlink($root_js_name); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function display_user_schema_group_master_grid($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from ( select usg.internal_code as id,us.module_name as grid_schema_name,name as grid_group_name,multiple as grid_multiple from s_user_schema us inner join s_user_schema_group usg on usg.ref_s_user_schema_code=us.internal_code)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from s_user_schema_group"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select usg.internal_code as id,us.module_name as grid_schema_name,name as grid_group_name,multiple as grid_multiple,sequence as grid_group_sequence from s_user_schema us inner join s_user_schema_group usg on usg.ref_s_user_schema_code=us.internal_code ) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select usg.internal_code as id,us.module_name as grid_schema_name,name as grid_group_name,multiple as grid_multiple,sequence as grid_group_sequence from s_user_schema us inner join s_user_schema_group usg on usg.ref_s_user_schema_code=us.internal_code ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL ; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_schema_name],$value[grid_group_name],$value[grid_multiple],$value[grid_group_sequence]); } // return the formated data echo $json->encode($responce); } function delete_user_schema_group_master_setup_details($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; //to drop the Group user schema Tables $qry="select CONCAT('user_schema_',ms.INTERNAL_CODE,'_group_',msg.internal_code) as group_table_name from s_user_schema_group msg inner join s_user_schema ms on ms.internal_code=msg.ref_s_user_schema_code where msg.internal_code=$lstr_ids"; $lobj_rs = $aobj_context->mobj_db->GetRow($qry); $drop_qry="drop table IF EXISTS ". $lobj_rs['group_table_name']; $lobj_rs = $aobj_context->mobj_db->Execute($drop_qry); $lstr_qry = "delete from s_user_schema_group where internal_code in (".$lstr_ids.")"; // echo $lstr_qry $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); $delete_eles="delete from s_user_schema_elements where ref_s_user_schema_group_code={$lstr_ids}"; $lobj_rs = $aobj_context->mobj_db->Execute($delete_eles); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function display_user_schema_element_master_grid($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from( select uss.internal_code as id,us.module_name as grid_Schema_name,uss.name as grid_name, s1.value as grid_data_type,uss.sequence as grid_sequence,usg.name as grid_group_name,description as grid_description, default_value as grid_default_value, if(optional=1,'Yes','No') as grid_optional from s_user_schema_elements uss inner join s_user_schema us on us.internal_code=uss.ref_s_user_schema_code left join s_user_schema_group usg on usg.internal_code=ref_s_user_schema_group_code left join s_ref_type s1 on s1.internal_code=data_type)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from s_user_schema_elements uss inner join s_user_schema us on us.internal_code=uss.ref_s_user_schema_code left join s_user_schema_group usg on usg.internal_code=ref_s_user_schema_group_code left join s_ref_type s1 on s1.internal_code=data_type"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select uss.internal_code as id,us.module_name as grid_Schema_name,uss.name as grid_name, s1.value as grid_data_type,uss.sequence as grid_sequence,usg.name as grid_group_name,description as grid_description, default_value as grid_default_value, if(optional=1,'Yes','No') as grid_optional,ref_data.module_name as grid_ref_module_name,s2.value as grid_meta_type from s_user_schema_elements uss inner join s_user_schema us on us.internal_code=uss.ref_s_user_schema_code left join s_user_schema_group usg on usg.internal_code=ref_s_user_schema_group_code left join s_ref_type s1 on s1.internal_code=data_type left join s_user_schema ref_data on ref_data.internal_code=uss.ref_module_code left join s_ref_type s2 on s2.internal_code=s_ref_type_meta) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select uss.internal_code as id,us.module_name as grid_Schema_name,uss.name as grid_name, s1.value as grid_data_type,uss.sequence as grid_sequence,usg.name as grid_group_name,description as grid_description, default_value as grid_default_value, if(optional=1,'Yes','No') as grid_optional,ref_data.module_name as grid_ref_module_name,s2.value as grid_meta_type from s_user_schema_elements uss inner join s_user_schema us on us.internal_code=uss.ref_s_user_schema_code left join s_user_schema_group usg on usg.internal_code=ref_s_user_schema_group_code left join s_ref_type s1 on s1.internal_code=data_type left join s_user_schema ref_data on ref_data.internal_code=uss.ref_module_code left join s_ref_type s2 on s2.internal_code=s_ref_type_meta ORDER BY $sidx $sord LIMIT $start , $limit"; } $result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; $responce->rows[$i]['cell']=array($row[grid_Schema_name],$row[grid_name],$row[grid_data_type],$row[grid_sequence], $row[grid_group_name],$row[grid_description],$row[grid_default_value],$row[grid_optional],$row[grid_ref_module_name],$row[grid_meta_type]); $i++; } // return the formated data echo $json->encode($responce); // return the formated data } function delete_user_schema_element_master_setup_details($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; //to drop field in File $lstr_get_schema = "select ref_s_user_schema_code from s_user_schema_elements where internal_code in (".$lstr_ids.")"; $lobj_lstr_get_schema = $aobj_context->mobj_db->GetRow($lstr_get_schema); $schema_id= $lobj_lstr_get_schema[ref_s_user_schema_code]; // to drop the multiple group field name if exstis $drop_field="select CONCAT('user_schema_',sus.INTERNAL_CODE,'_group_',susg.internal_code) as table_name, concat('u_',sus.internal_code,'_g_',susg.internal_code,'_ele_',suse.internal_code) as field_name from s_user_schema_elements suse inner join s_user_schema_group susg on susg.internal_code=suse.ref_s_user_schema_group_code inner join s_user_schema sus on sus.internal_code=susg.ref_s_user_schema_code where suse.internal_code=". $lstr_ids ." and multiple=1"; $lobj_rs_drop_field = $aobj_context->mobj_db->GetRow($drop_field); if(count($lobj_rs_drop_field['table_name'])>0) { $table_count="show tables like '".$lobj_rs_drop_field['table_name']."'"; $lobj_rs_table_count = $aobj_context->mobj_db->GetRow($table_count); if(count($lobj_rs_table_count)>0) { foreach ($lobj_rs_table_count as $key=>$value) $alter_qr="alter table ". $value ." drop ".$lobj_rs_drop_field['field_name'] ; $lobj_rs_drop = $aobj_context->mobj_db->Execute($alter_qr); } } $drop_meta="select CONCAT('module_',sus.INTERNAL_CODE) as table_name,CONCAT('m_',sus.INTERNAL_CODE,'_ele_',suse.internal_code) as field_name from s_user_schema_elements suse inner join s_user_schema sus on sus.internal_code=suse.ref_s_user_schema_code inner join s_ref_type s1 on s1.internal_code=suse.s_ref_type_meta where suse.internal_code={$lstr_ids} and s1.value='Meta'"; $lobj_drop_meta = $aobj_context->mobj_db->GetRow($drop_meta); if(!empty($lobj_drop_meta['table_name'])) { $table_count="show tables like '".$lobj_drop_meta['table_name']."'"; $lobj_rs_table_count = $aobj_context->mobj_db->GetRow($table_count); if(count($lobj_rs_table_count)>0) { foreach ($lobj_rs_table_count as $key=>$value) $alter_qr="alter table ". $value ." drop ".$lobj_drop_meta['field_name'] ; $lobj_rs_drop = $aobj_context->mobj_db->Execute($alter_qr); } } $lstr_qry = "delete from s_user_schema_elements where internal_code in (".$lstr_ids.")"; //echo $lstr_qry ; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); require_once(dirname(__FILE__)."\create_file.php"); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function getUserSchemaDetailsForRefrencedata($aobj_context) { include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $module_id = $_GET['ref_module_code']; if(!$sidx) $sidx =1; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select internal_code as id, data1 as grid_field1, data2 as grid_field2 from s_ref_data where ref_s_user_schema_code = $module_id)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from s_ref_data where ref_s_user_schema_code = $module_id"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select internal_code as id, data1 as grid_field1, data2 as grid_field2 from s_ref_data where ref_s_user_schema_code = $module_id )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select internal_code as id, data1 as grid_field1, data2 as grid_field2 from s_ref_data where ref_s_user_schema_code = $module_id ORDER BY $sidx $sord LIMIT $start , $limit"; // echo $SQL; } //echo $SQL; //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_field1],$value[grid_field2]); } /* $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[id]; $responce->rows[$i]['cell']=array($row[grid_module_name],$row[grid_field1],$row[grid_field2],$row[grid_field3], $row[grid_field4],$row[grid_field5],$row[grid_tree_data] ); $i++; } */ //var_dump($responce->rows); echo $json->encode($responce); } function viewUserSchemaModuleDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; $s_indx=explode("grid_",$sidx); if(!empty($s_indx[1])) $sidx =$s_indx[1]; $table_name=$_GET['table_name']; $schema_ids=explode("_",$table_name); $schema_id=$schema_ids[1]; // this field we are not using for main query display selection since we need to get the data from REference tables, we are mannualy doing the quey below $table_field_name=stripcslashes($_GET['field_name']); $details_array=$_GET['details_array']; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name_value=explode('grid_',$_GET['searchField']); $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } $pos = strpos($_GET['searchField'], "grid_d"); if ($pos === false) { $field_name=$field_name_value[1];} else { $field_name=$_GET['searchField'];} if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from ( select internal_code as id,$table_field_name from $table_name ) a where $field_name $cond$value"; } else { $count_id="select count(*) as count from $table_name"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from ( select internal_code as id,$table_field_name from $table_name )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000"); $aobj_context->mobj_db->execute("set @a:=0"); $select_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from (select @a:=@a+1,ref_module_code, concat(' left join module_',ref_module_code, ' as module_',ref_module_code,'_',@a,' on module_',ref_module_code,'_',@a,'.internal_code =m_',ref_s_user_schema_code, '_ele_',internal_code) as join_table_name from s_user_schema_elements where ref_s_user_schema_code=$schema_id and is_multiple_group=0 and ref_module_code>0)j"; $obj_select_ref_module_code = $aobj_context->mobj_db->GetRow($select_ref_module_code); $join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:''; $get_display_cols="select GROUP_CONCAT(field_name) as field_name from (select table_name,name,field_name as grid_field_name, if(ref_module_code=0,concat('module_',internal_code,'.',field_name),concat(\"concat(\",(field_id),\") as \",field_name)) as field_name ,ref_module_code from (select s.internal_code, ref_module_code,concat('module_',s.internal_code) as table_name , field_id, su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name from s_user_schema s inner join s_user_schema_elements su on su.ref_s_user_schema_code=s.internal_code inner join s_ref_type t on t.internal_code=su.s_ref_type_meta left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code left join module_meta_columns mmc on mmc.module_id=su.ref_module_code where s.internal_code={$schema_id} and t.value='Meta' order by ug.sequence,su.sequence,su.internal_code ) l where multiple=0 ) a "; $lobj_get_display_cols = $aobj_context->mobj_db->GetRow($get_display_cols); $SQL = " select $table_name.internal_code as id,".$lobj_get_display_cols[field_name]." from $table_name $join_qry ORDER BY $sidx $sord LIMIT $start , $limit"; //echo $SQL; $SQL1 = " select internal_code as id,$table_field_name from $table_name ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL; $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs =$aobj_context->mobj_db->GetAll($SQL); if((mysql_error()!='')) $lobj_rs =$aobj_context->mobj_db->GetAll($SQL1); foreach($lobj_rs as $key =>$value) { $val=''; $responce->rows[$key]['id']=$value[id]; $l=0; foreach($value as $key1 =>$value1) { if($key1!='id'){ $val[$l]=$value[$key1]; $l++; } } $responce->rows[$key]['cell']=($val); } echo $json->encode($responce); } function viewUserSchemaSrefDataDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $search_by_user = trim($_GET['search_by_user']); if(!empty($search_by_user)) { $table_field_name=stripcslashes($_GET['field_name']); if(strpos($table_field_name,",")===false) { $search_by_user= " where grid_data1 like '%{$search_by_user}%' "; } else { $search_by_user= " where (grid_data1 like '%{$search_by_user}%' or grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) "; } } if(!$sidx) $sidx =1; $table_name=$_GET['table_name']; $table_field_name=stripcslashes($_GET['field_name']); $details_array=$_GET['details_array']; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name_value=explode('grid_',$_GET['searchField']); $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } $pos = strpos($_GET['searchField'], "grid_d"); if ($pos === false) { $field_name=$field_name_value[1];} else { $field_name=$_GET['searchField'];} if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from ( select internal_code as id,$table_field_name from $table_name ) a where $field_name $cond$value"; } else { $count_id="select count(*) as count from (select internal_code as id,$table_field_name from $table_name ) a $search_by_user "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from ( select internal_code as id,$table_field_name from $table_name )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = " select * from (select internal_code as id,$table_field_name from $table_name ) a $search_by_user ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL; $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs =$aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $val=''; $responce->rows[$key]['id']=$value[id]; $l=0; foreach($value as $key1 =>$value1) { if($key1!='id'){ $val[$l]=$value[$key1]; $l++; } } $responce->rows[$key]['cell']=($val); } echo $json->encode($responce); } function deleteUserSchemaModuleDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $table = $aobj_context->mobj_data["table_name"]; $schema_code_obj=explode("_",$table); $schema_code=$schema_code_obj[1]; $lstr_del_meta_qry = "delete from {$table} where internal_code in (".$lstr_ids.")"; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_del_meta_qry); $lstr_del_details_qry = "delete from {$table}_details where ref_s_module_code in (".$lstr_ids.")"; //echo $lstr_del_details_qry; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_del_details_qry); // delete from grup details $lstr_del_group_details_qry="select concat('user_schema_',ref_s_user_schema_code,'_group_', ref_s_user_schema_group_code) as group_table, ref_s_user_schema_group_code from s_user_schema_elements where ref_s_user_schema_code={$schema_code} and ref_s_user_schema_group_code>0 group by ref_s_user_schema_group_code"; $obj_lstr_del_group_details_qry = $aobj_context->mobj_db->GetAll($lstr_del_group_details_qry); if(count($obj_lstr_del_group_details_qry)>0) { foreach($obj_lstr_del_group_details_qry as $key=>$value) { $delete_group="delete from ".$value["group_table"]." where ref_s_ref_data_code={$lstr_ids}"; $lobj_delete_group = $aobj_context->mobj_db->Execute($delete_group); } } if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function deleteUserSchemaModuleGroupDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $s_ref_data_code = $aobj_context->mobj_data["s_ref_data_code"]; $table_name = $aobj_context->mobj_data["table_name"]; $id = $aobj_context->mobj_data["id"]; $lstr_del_meta_qry = "delete from {$table_name} where ref_s_ref_data_code in ({$s_ref_data_code}) and internal_code in({$id})"; echo $lstr_del_meta_qry; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_del_meta_qry); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function displayFormulaSetUpDetails($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; // to get the Componnet Name $get_table_name="select concat('module_',s.internal_code) as table_name, concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name from s_user_schema s inner join s_user_schema_elements su on su.ref_s_user_schema_code=s.internal_code where module_name='Salary Components' and su.name='Name'"; $lobj_rs = $aobj_context->mobj_db->getRow($get_table_name); $table_name=$lobj_rs[table_name]; $display_name=$lobj_rs[field_name]; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; else $indx=explode("grid_",$sidx); $sidx=empty($indx[1])?'1':$indx[1]; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from ( select formula_name as grid_formula_name,t.{$display_name} as grid_formula_component,formula as grid_formula_value from formula_header fh inner join formula_details fd on fh.internal_code=fd.ref_formula_header_code left join {$table_name} t on t.internal_code=ref_component_code)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from ( select formula_name as grid_formula_name,t.{$display_name} as grid_formula_component, formula as grid_formula_value from formula_header fh inner join formula_details fd on fh.internal_code=fd.ref_formula_header_code left join {$table_name} t on t.internal_code=ref_component_code)a "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select fd.internal_code as id,formula_name as grid_formula_name, t.{$display_name} as grid_formula_component,formula_for_ui as grid_formula_value from formula_header fh inner join formula_details fd on fh.internal_code=fd.ref_formula_header_code left join {$table_name} t on t.internal_code=ref_component_code ) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select fd.internal_code as id,formula_name as grid_formula_name,t.{$display_name} as grid_formula_component, formula_for_ui as grid_formula_value from formula_header fh inner join formula_details fd on fh.internal_code=fd.ref_formula_header_code left join {$table_name} t on t.internal_code=ref_component_code ORDER BY $sidx $sord LIMIT $start , $limit"; } $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_formula_name],$value[grid_formula_component],$value[grid_formula_value] ); } // return the formated data echo $json->encode($responce); } function deleteFormulaSetUpDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; //to drop the Group user schema Tables $get_header_id="select ref_formula_header_code from formula_details where internal_code={$lstr_ids}"; $lobj_get_header_id = $aobj_context->mobj_db->getRow($get_header_id); $selct_count="select count(ref_formula_header_code) as count from formula_details where ref_formula_header_code={$lobj_get_header_id[ref_formula_header_code]}"; $lobj_selct_count = $aobj_context->mobj_db->getRow($selct_count); if($lobj_selct_count[count]=='1') { $drop_qry_header="delete from formula_header where internal_code={$lobj_get_header_id[ref_formula_header_code]}"; $lobj_rs = $aobj_context->mobj_db->Execute($drop_qry_header); $drop_qry_header_details="delete from formula_details where internal_code={$lstr_ids}"; $lobj_rs = $aobj_context->mobj_db->Execute($drop_qry_header_details); } else { $drop_qry_header_details="delete from formula_details where internal_code={$lstr_ids}"; $lobj_rs = $aobj_context->mobj_db->Execute($drop_qry_header_details); echo $drop_qry_header_details; } if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function displayUserSetUpDetails($aobj_context) { include_once("/JSON.php"); session_start(); $college_code=$_SESSION['collcode']; $user_id= $_SESSION['user_id']; $user_type=$_SESSION['user_type']; //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; $where_cond=''; if(strtolower($user_type)==strtolower('System')) { $where_cond=" where t.value='Admin'"; } else { $where_cond=" where college_code='{$college_code}' "; } // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select s.internal_code as id,college_code as grid_college_code, s.sysusr as grid_sysusr, s.sysusrkey as grid_sysusrkey, t.value as grid_user_type, ifnull(s.real_name,'') as grid_real_name, ifnull(s.email_id,'') as grid_email_id from s_sysdb s inner join s_ref_type t on t.internal_code=s.user_type {$where_cond} and s.internal_code!={$user_id} )a where $field_name $cond$value"; } else { $count_id=" select count(*) as count from s_sysdb s {$where_cond} and s.internal_code!={$user_id} "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select s.internal_code as id,college_code as grid_college_code, s.sysusr as grid_sysusr, s.sysusrkey as grid_sysusrkey, t.value as grid_user_type, ifnull(s.real_name,'') as grid_real_name, ifnull(s.email_id,'') as grid_email_id from s_sysdb s inner join s_ref_type t on t.internal_code=s.user_type {$where_cond} and s.internal_code!={$user_id} )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select s.internal_code as id,college_code as grid_college_code, s.sysusr as grid_sysusr, s.sysusrkey as grid_sysusrkey, t.value as grid_user_type, ifnull(s.real_name,'') as grid_real_name, ifnull(s.email_id,'') as grid_email_id from s_sysdb s inner join s_ref_type t on t.internal_code=s.user_type {$where_cond} and s.internal_code!={$user_id} ORDER BY $sidx $sord LIMIT $start , $limit"; // echo $SQL; } $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_college_code],$value[grid_sysusr],$value[grid_sysusrkey],$value[grid_user_type], $value[grid_real_name],$value[grid_email_id]); } // return the formated data echo $json->encode($responce); } function deleteUserSetUpDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $lstr_qry = "update s_sysdb set FDELETED='T' where internal_code in (".$lstr_ids.")"; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function viewTransactionSeriesGrid($aobj_context) { include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select tsp.internal_code as id, us.module_name as grid_ref_module_code, uss.name as grid_ref_module_element_code, series_name as grid_series_name, prefix as grid_prefix, starting_no as grid_starting_no, ending_no as grid_ending_no, last_no as grid_last_no, starting_date as grid_starting_date, ending_date as grid_ending_date from transaction_series_prefix tsp inner join s_user_schema us on us.internal_code=ref_module_code inner join s_user_schema_elements uss on uss.internal_code=ref_module_element_code )a where $field_name $cond$value"; } else { $count_id="select count(*) as count from transaction_series_prefix"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select tsp.internal_code as id, us.module_name as grid_ref_module_code, uss.name as grid_ref_module_element_code, series_name as grid_series_name, prefix as grid_prefix, starting_no as grid_starting_no, ending_no as grid_ending_no, last_no as grid_last_no, DATE_FORMAT(starting_date,'%d/%m/%Y') as grid_starting_date, DATE_FORMAT(ending_date,'%d/%m/%Y') as grid_ending_date from transaction_series_prefix tsp inner join s_user_schema us on us.internal_code=ref_module_code inner join s_user_schema_elements uss on uss.internal_code=ref_module_element_code )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select tsp.internal_code as id, us.module_name as grid_ref_module_code, uss.name as grid_ref_module_element_code, series_name as grid_series_name, prefix as grid_prefix, starting_no as grid_starting_no, ending_no as grid_ending_no, last_no as grid_last_no, DATE_FORMAT(starting_date,'%d/%m/%Y') as grid_starting_date, DATE_FORMAT(ending_date,'%d/%m/%Y') as grid_ending_date from transaction_series_prefix tsp inner join s_user_schema us on us.internal_code=ref_module_code inner join s_user_schema_elements uss on uss.internal_code=ref_module_element_code ORDER BY $sidx $sord LIMIT $start , $limit"; //echo $SQL; } //echo $SQL; $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_ref_module_code],$value[grid_ref_module_element_code], $value[grid_series_name],$value[grid_prefix],$value[grid_starting_no], $value[grid_ending_no],$value[grid_last_no],$value[grid_starting_date],$value[grid_ending_date]); } // return the formated data echo $json->encode($responce); } function deleteTransactionSeries($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $lstr_qry = "delete from transaction_series_prefix where internal_code in (".$lstr_ids.")"; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function viewUserSchemaModuleGroupDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $s_ref_data_code=$_GET['s_ref_data_code']; if(!$sidx) $sidx =1; $s_indx=explode("grid_",$sidx); if(!empty($s_indx[1])) $sidx =$s_indx[1]; $table_name=$_GET['table_name']; $schema_ids=explode("_",$table_name); $schema_id=$schema_ids[2]; $group_id=$schema_ids[4]; // this field we are not using for main query display selection since we need to get the data from REference tables, we are mannualy doing the quey below $table_field_name=stripcslashes($_GET['field_name']); $details_array=$_GET['details_array']; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name_value=explode('grid_',$_GET['searchField']); $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $search_value=$final_value[1]; } $pos = strpos($_GET['searchField'], "grid_d"); if ($pos === false) { $field_name=$field_name_value[1];} else { $field_name=$_GET['searchField'];} $aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000"); $select_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from (select ref_module_code,concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id, concat(' left join module_',ref_module_code, ' on module_',ref_module_code,'.internal_code =u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as join_table_name from s_user_schema_elements where ref_s_user_schema_code={$schema_id} and ref_s_user_schema_group_code={$group_id} and ref_module_code>0)j"; $obj_select_ref_module_code = $aobj_context->mobj_db->GetRow($select_ref_module_code); $join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:''; // to form the fields dynamically $select_field_ids="select concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,name, ref_module_code from s_user_schema_elements where ref_s_user_schema_code={$schema_id} and ref_s_user_schema_group_code={$group_id} order by internal_code"; $lobj_select_field_ids = $aobj_context->mobj_db->GetAll($select_field_ids); foreach($lobj_select_field_ids as $key =>$value) { if($value[ref_module_code]=='0') { $fields.=$value[field_id].","; $sum_field.="sum(".$value[field_id].") as ".$value[field_id].","; } else { $aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000"); $qry=" select concat('module_',schema_id) as table_name,GROUP_CONCAT(name SEPARATOR '-ele-') as name, GROUP_CONCAT(field_name separator ',\'-\',') as field_name from (select * from (select s.internal_code as schema_id,su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name from s_user_schema s inner join s_user_schema_elements su on su.ref_s_user_schema_code=s.internal_code inner join s_ref_type t on t.internal_code=su.s_ref_type_meta left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code where s.internal_code=$value[ref_module_code] and t.value='Meta' order by ug.sequence,su.sequence,su.internal_code ) l where multiple=0 limit 2) a group by schema_id"; $lobj_rs = $aobj_context->mobj_db->GetRow($qry); $fields.="concat(".$lobj_rs[field_name].") as $value[field_id]".","; $sum_field.="'' as ".$value[field_id].","; } } $fields=substr($fields,0,strlen($fields)-1); if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from ( select $table_name.internal_code as id,$fields from $table_name $join_qry where ref_s_ref_data_code= $s_ref_data_code )a where $field_name $cond$search_value"; } else { $count_id="select count(*) as count from $table_name where ref_s_ref_data_code=$s_ref_data_code"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from ( select $table_name.internal_code as id,$fields from $table_name $join_qry where ref_s_ref_data_code= $s_ref_data_code )a where $field_name $cond$search_value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL="select $table_name.internal_code as id,$fields from $table_name $join_qry where ref_s_ref_data_code= $s_ref_data_code ORDER BY $sidx $sord LIMIT $start , $limit"; // echo $SQL; //echo $SQL; $SQL1 = " select internal_code as id,$table_field_name from $table_name where ref_s_ref_data_code=$s_ref_data_code ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL; $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs =$aobj_context->mobj_db->GetAll($SQL); if((mysql_error()!='')) $lobj_rs =$aobj_context->mobj_db->GetAll($SQL1); foreach($lobj_rs as $key =>$value) { $val=''; $responce->rows[$key]['id']=$value[id]; $l=0; foreach($value as $key1 =>$value1) { if($key1!='id'){ $val[$l]=$value[$key1]; $l++; } } $responce->rows[$key]['cell']=($val); } echo $json->encode($responce); } function showGridForFormulaMapping($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include_once("/JSON.php"); //echo $lstr_ids; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $module_id = trim($_GET['module_id']); $id = trim($_GET['id']); $search_by_user = trim($_GET['search_by_user_map']); $qry="select a.*,meta_cols.field_id as field_name,ifnull(field_name,a.name) as name,ifnull(table_name,0) as table_name from (select s.internal_code as schema_id,t.value as meta, su.internal_code,name ,t1.value as data_type,su.ref_module_code,db_field from s_user_schema s inner join s_user_schema_elements su on su.ref_s_user_schema_code=s.internal_code inner join s_ref_type t on t.internal_code=su.s_ref_type_meta inner join s_ref_type t1 on t1.internal_code=su.data_type where module_name='Employee' and is_multiple_group=0 and su.internal_code={$id} and (( t1.value in('List Of Values','Reference Data')) or (t.value='meta' and is_unique=1))) a left join module_meta_columns meta_cols on meta_cols.module_id=ref_module_code"; //echo $qry; $get_source_details = $aobj_context->mobj_db->GetRow($qry); if($get_source_details["ref_module_code"]<>0) $table_name="module_".$module_id; else if ($get_source_details["meta"]=='Meta') $table_name="module_".$get_source_details["schema_id"]; else if ($get_source_details["meta"]=='User') $table_name="module_".$get_source_details["schema_id"]."_details"; if(!empty($search_by_user)) { $table_field_name=stripcslashes($_GET['field_name']); if(strpos($table_field_name,",")===false) { $search_by_user= " where grid_data1 like '%{$search_by_user}%' "; } else { $search_by_user= " where (grid_data1 like '%{$search_by_user}%' or grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) "; } } if(!$sidx) $sidx =1; $table_field_name=stripcslashes($_GET['field_name']); $details_array=$_GET['details_array']; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name_value=explode('grid_',$_GET['searchField']); $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } $pos = strpos($_GET['searchField'], "grid_d"); if ($pos === false) { $field_name=$field_name_value[1];} else { $field_name=$_GET['searchField'];} if(isset($_GET['searchField']) && $_GET["_search"]=='true') { if($get_source_details["ref_module_code"]<>0) { $count_id = " select count(*) as count from (select internal_code as id,$table_field_name from $table_name ) a where $field_name $cond$value "; } else if ($get_source_details["meta"]=='Meta') { $count_id = " select count(*) as count from (select internal_code as id, ".$get_source_details["db_field"]. " as grid_data1,'' as grid_data2 from $table_name group by grid_data1) a where $field_name $cond$value "; } else if ($get_source_details["meta"]=='User') { $count_id = " select count(*) as count from (select value as grid_data1,'' as grid_data2,internal_code as id from $table_name where ref_s_user_schema_elements_code={$id} group by value ) a where $field_name $cond$value "; } } else { if($get_source_details["ref_module_code"]<>0) { $count_id = " select count(*) as count from (select internal_code as id,$table_field_name from $table_name ) a $search_by_user "; } else if ($get_source_details["meta"]=='Meta') { $count_id = " select count(*) as count from (select internal_code as id, ".$get_source_details["db_field"]. " as grid_data1,'' as grid_data2 from $table_name group by grid_data1) a $search_by_user "; } else if ($get_source_details["meta"]=='User') { $count_id = " select count(*) as count from (select value as grid_data1,'' as grid_data2,internal_code as id from $table_name where ref_s_user_schema_elements_code={$id} group by value ) a $search_by_user "; } } //echo $count_id; $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { if($get_source_details["ref_module_code"]<>0) { $SQL = " select * from (select internal_code as id,$table_field_name from $table_name ) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start , $limit"; } else if ($get_source_details["meta"]=='Meta') { $SQL = " select * from (select internal_code as id, ".$get_source_details["db_field"]. " as grid_data1,'' as grid_data2 from $table_name group by grid_data1) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start , $limit"; } else if ($get_source_details["meta"]=='User') { $SQL = " select * from (select value as grid_data1,'' as grid_data2,internal_code as id from $table_name where ref_s_user_schema_elements_code={$id} group by value ) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start , $limit"; } } else { if($get_source_details["ref_module_code"]<>0) { $SQL = " select * from (select internal_code as id,$table_field_name from $table_name ) a $search_by_user ORDER BY $sidx $sord LIMIT $start , $limit"; } else if ($get_source_details["meta"]=='Meta') { $SQL = " select * from (select internal_code as id, ".$get_source_details["db_field"]. " as grid_data1,'' as grid_data2 from $table_name group by grid_data1) a $search_by_user ORDER BY $sidx $sord LIMIT $start , $limit"; } else if ($get_source_details["meta"]=='User') { $SQL = " select * from (select value as grid_data1,'' as grid_data2,internal_code as id from $table_name where ref_s_user_schema_elements_code={$id} group by value ) a $search_by_user ORDER BY $sidx $sord LIMIT $start , $limit"; } } $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs =$aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $val=''; $responce->rows[$key]['id']=$value[id]; $l=0; foreach($value as $key1 =>$value1) { if($key1!='id'){ $val[$l]=$value[$key1]; $l++; } } $responce->rows[$key]['cell']=($val); } echo $json->encode($responce); } function displayFormulaMappingDetails($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select map_at as grid_map_at ,map_value , formula_name as grid_formula_name from emp_formula_map efm inner join formula_header fh on efm.ref_formula_code=fh.internal_code left join module_meta_columns mtc on mtc.module_id=ref_module_code)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from (select map_at as grid_map_at ,map_value , formula_name as grid_formula_name from emp_formula_map efm inner join formula_header fh on efm.ref_formula_code=fh.internal_code left join module_meta_columns mtc on mtc.module_id=ref_module_code)a "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select efm.internal_code as id,map_at as grid_map_at ,map_value as grid_map_value, formula_name as grid_formula_name from emp_formula_map efm inner join formula_header fh on efm.ref_formula_code=fh.internal_code left join module_meta_columns mtc on mtc.module_id=ref_module_code ) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select efm.internal_code as id,map_at as grid_map_at ,map_value as grid_map_value, formula_name as grid_formula_name from emp_formula_map efm inner join formula_header fh on efm.ref_formula_code=fh.internal_code left join module_meta_columns mtc on mtc.module_id=ref_module_code ORDER BY $sidx $sord LIMIT $start , $limit"; } // echo $SQL ; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_map_at],$value[grid_map_value],$value[grid_formula_name] ); } // return the formated data echo $json->encode($responce); } function deleteFormulaMappingDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $delete_eles="delete from emp_formula_map where internal_code in ( {$lstr_ids} )"; $lobj_rs = $aobj_context->mobj_db->Execute($delete_eles); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function showGridForSalarySetup($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $search_by_user = trim($_GET['search_by_user_map']); if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; if(!empty($search_by_user)) { $table_field_name=stripcslashes($_GET['field_name']); if(strpos($table_field_name,",")===false) { $search_by_user= " where grid_data1 like '%{$search_by_user}%' "; } else { $search_by_user= " where (grid_data1 like '%{$search_by_user}%' or grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) "; } } /* $get_table_name_ele_name="select concat('module_',sus.internal_code) as table_name,db_field from s_user_schema sus inner join s_user_schema_elements suse on suse.ref_s_user_schema_code=sus.internal_code where module_name='Employee' and name in('Emp Code','Name');"; */ $get_table_name_ele_name="select table_name,field_name1,field_id1,field_name2,field_id2 from module_meta_columns where module_name='Employee'" ; $lobj_get_table_name_ele_name = $aobj_context->mobj_db->GetRow($get_table_name_ele_name); if($lobj_get_table_name_ele_name[field_id2]=='') { $field_id2="' '"; } else $field_id2=$lobj_get_table_name_ele_name[field_id2]; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ".$field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name].") a where $field_name $cond$value"; } else { $count_id="select count(*) as count from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ".$field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name].") a $search_by_user"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ".$field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name].") a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select * from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ". $field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name]." ORDER BY $sidx $sord LIMIT $start , $limit ) a $search_by_user"; } $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[ grid_data1],$value[grid_data2] ); } // return the formated data echo $json->encode($responce); } function deleteFormulaSalarySetup($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $delete_eles="delete from emp_formula_map where internal_code in ( {$lstr_ids} )"; $lobj_rs = $aobj_context->mobj_db->Execute($delete_eles); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function displaySalarySetupHeader($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $ref_emp_code = $_GET['emp_id']; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; $check_type="select * from (select concat('module_',ref_s_user_schema_code) as table_name, concat('m_',ref_s_user_schema_code,'_ele_',us.internal_code) as field_name from s_user_schema_elements us inner join s_user_schema s on s.internal_code=ref_s_user_schema_code where module_name='Salary Components' and name in('name','Type') order by name)a union select concat('module_',ref_s_user_schema_code) as table_name, concat('m_',ref_s_user_schema_code,'_ele_',us.internal_code) as field_name from s_user_schema_elements us inner join s_user_schema s on s.internal_code=ref_s_user_schema_code where module_name='Component Type' and name in('Component type')"; $lobj_check_type = $aobj_context->mobj_db->GetAll($check_type); $get_comp_qry="(select c.internal_code as ref_component_code,{$lobj_check_type[0][field_name]} as component,{$lobj_check_type[2][field_name]} as type from {$lobj_check_type[0][table_name]} c inner join {$lobj_check_type[2][table_name]} d on d.internal_code={$lobj_check_type [1][field_name]} )"; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select ssh.internal_code as id,component as grid_ref_source_component, source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date from salary_setup_header ssh inner join $get_comp_qry a on a.ref_component_code=ssh.ref_source_component where ref_emp_code=$ref_emp_code)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from (select ssh.internal_code as id,component as grid_ref_source_component, source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date from salary_setup_header ssh inner join $get_comp_qry a on a.ref_component_code=ssh.ref_source_component where ref_emp_code=$ref_emp_code )a "; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select ssh.internal_code as id,component as grid_ref_source_component, source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date from salary_setup_header ssh inner join $get_comp_qry a on a.ref_component_code=ssh.ref_source_component where ref_emp_code=$ref_emp_code) a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = " select ssh.internal_code as id,component as grid_ref_source_component, source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date from salary_setup_header ssh inner join $get_comp_qry a on a.ref_component_code=ssh.ref_source_component where ref_emp_code=$ref_emp_code ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_ref_source_component],$value[grid_source_value],$value[effective_date] ); } // return the formated data echo $json->encode($responce); } function deleteSalarySetupHeader($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $delete_eles="delete from salary_setup_header where internal_code in ( {$lstr_ids} )"; $lobj_rs = $aobj_context->mobj_db->Execute($delete_eles); $delete_details="delete from salary_setup_result where ref_salary_setup_header_code in ( {$lstr_ids} )"; $lobj_rs = $aobj_context->mobj_db->Execute($delete_details); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } function showEmployeeGridForIncometaxMaster($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; $search_by_user = trim($_GET['search_by_user_map']); if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; if(!empty($search_by_user)) { $table_field_name=stripcslashes($_GET['field_name']); if(strpos($table_field_name,",")===false) { $search_by_user= " where grid_data1 like '%{$search_by_user}%' "; } else { $search_by_user= " where (grid_data1 like '%{$search_by_user}%' or grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) "; } } /* $get_table_name_ele_name="select concat('module_',sus.internal_code) as table_name,db_field from s_user_schema sus inner join s_user_schema_elements suse on suse.ref_s_user_schema_code=sus.internal_code where module_name='Employee' and name in('Emp Code','Name');"; */ $get_table_name_ele_name="select table_name,field_name1,field_id1,field_name2,field_id2 from module_meta_columns where module_name='Employee'" ; $lobj_get_table_name_ele_name = $aobj_context->mobj_db->GetRow($get_table_name_ele_name); if($lobj_get_table_name_ele_name[field_id2]=='') { $field_id2="' '"; } else $field_id2=$lobj_get_table_name_ele_name[field_id2]; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ".$field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name].") a where $field_name $cond$value"; } else { $count_id="select count(*) as count from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ".$field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name].") a $search_by_user"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ".$field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name].") a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select * from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1, ". $field_id2." as grid_data2 from ".$lobj_get_table_name_ele_name[table_name]." ORDER BY $sidx $sord LIMIT $start , $limit ) a $search_by_user"; } $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[ grid_data1],$value[grid_data2] ); } // return the formated data echo $json->encode($responce); } //module setup function display_module_setup_grid($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name=$_GET['searchField']; $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } if(!$sidx) $sidx =1; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from( select Code as id,Code as grid_m_code,Name as grid_m_name,FMODULE as grid_module_code,Value as grid_module_value from markentrycodition)a where $field_name $cond$value"; } else { $count_id="select count(*) as count from markentrycodition"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from (select Code as id,Code as grid_m_code,Name as grid_m_name,FMODULE as grid_module_code,Value as grid_module_value from markentrycodition)a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select Code as id,Code as grid_m_code,Name as grid_m_name,FMODULE as grid_module_code,Value as grid_module_value from markentrycodition ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL ; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); //$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs = $aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $responce->rows[$key]['id']=$value[id]; $responce->rows[$key]['cell']=array($value[grid_m_code],$value[grid_m_name],$value[grid_module_code],$value[grid_module_value]); } // return the formated data echo $json->encode($responce); } function delete_module_setup_grid($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $lstr_qry = "delete from markentrycodition where Code in (".$lstr_ids.")"; // echo $lstr_qry $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); if($lobj_rs) { $rdata="Deleted Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); return $rdata; } else { $rdata="Deletion Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return $rdata; } } //JIJO UPDAED ON 01/08/2011. function QpPopup($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('FQPCODE','QPSUBJECT','QPMAXMARK'); $display_obj->display_qry = "SELECT FQPCODE as id,FQPCODE,FSUBNAME as QPSUBJECT,FMAXMARKS as QPMAXMARK FROM masqp where 1=1"; //echo $display_obj->display_qry; die(); $display_obj->DisplayDetailsInGrid(); } function openDeptDetailsPopup($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('FDEPTCODE','FDEPTNAME'); $display_obj->display_qry = "SELECT FDEPTCODE as id,FDEPTCODE,FDEPTNAME FROM masdept where 1=1"; //echo $display_obj->display_qry; die(); $display_obj->DisplayDetailsInGrid(); }function openDesDetailsPopup($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('FDEGNCODE','FDEGNDESC'); $display_obj->display_qry = "SELECT FDEGNCODE as id,FDEGNCODE,FDEGNDESC FROM masdegn where 1=1"; //echo $display_obj->display_qry; die(); $display_obj->DisplayDetailsInGrid(); } function OpenQpSubjectPopup($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('FQPCODE','FSUBCODE','FSSUBNAME'); $display_obj->display_qry = "SELECT TRIM(FQPCODE) AS id,TRIM(FQPCODE) AS FQPCODE,FSUBNAME AS FSUBCODE,FSSUBNAME from subject where TRIM(FQPCODE)<>'' and FTHEORY='T' and FINTASS<>'T' group by fqpcode"; //echo $display_obj->display_qry; $display_obj->DisplayDetailsInGrid(); } function OpenStudSectionPopup($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $degree_code=$aobj_context->mobj_data["degCode"]; $exam_no=$aobj_context->mobj_data['examNo']; 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('FSECTION'); $display_obj->display_qry = " SELECT distinct FSECTION ,FSECTION as id from student where FCOLLCODE='{$college_code}' and FDEGREE='{$degree_code}' and FEXAMNO='{$exam_no}' and FSECTION IS NOT NULL and FSECTION <>'' UNION ALL Select 'All' as FSECTION ,'All' as id"; //var_dump($display_obj); $display_obj->DisplayDetailsInGrid(); } function BoardDetailsPopup($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $mod_type = $_GET['type']; $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; $cond=''; $value=''; /* if($mod_type == '') { $cond=' '; } else { $cond= "and c.{$mod_type} is NULL"; } */ $search =$aobj_context->mobj_data["_search"]; $search = false; // to take th e parameters from Search field $filter_toolbal_cond=""; if($search=='true') { $Colcode =$aobj_context->mobj_data["fboardcode"]; $Desc =$aobj_context->mobj_data["fboardname"]; if(isset($Colcode) && !empty($Colcode)) $filter_toolbal_cond.="fboardcode like '{$Colcode}%'"; /* if(isset($Desc) && !empty($Desc)) $filter_toolbal_cond.=" and FDESCPN like '{$Desc}%'"; */ } if($search=='true') { $count_id="select count(distinct fboardcode) as count from masboard where {$filter_toolbal_cond}"; } else { $count_id="select count(distinct fboardcode) as count from masboard "; } $row = $aobj_context->mobj_db->GetRow($count_id); $count = $row['count']; // calculation of total pages for the query if($count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if($search=='true') { $SQL="select * from (select fboardcode as id,fboardcode,fboardsate, fboardname from masboard)a where {$filter_toolbal_cond} group by fboardcode ORDER BY $sidx $sord LIMIT $start,$limit"; } else { $SQL = "select fboardcode as id,fboardcode, fboardsate, fboardname from masboard ORDER BY $sidx $sord LIMIT $start , $limit"; } //echo $SQL; $result = $aobj_context->mobj_db->GetAll($SQL); //var_dump($result); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; foreach ($result as $key => $value) { $responce->rows[$i]['id']=$value[id]; //id $responce->rows[$i]['cell']=array($value['fboardcode'], $value['fboardsate'], $value['fboardname']); $i++; } echo json_encode($responce); } ?>
Close
