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 | : 18.117.101.7
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 : create_html_files_without_tab.php
<?php function CreateModuleHtmlFiles($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $schema_id = $aobj_context->mobj_data["schema_id"]; $schema_cond=($schema_id=='0')?" ":" and internal_code={$schema_id}"; $get_schema_names="select internal_code,module_name,menu_function,ifnull(display_type,'Next Line') as display_type from s_user_schema where (menu_function is null or menu_function='') {$schema_cond} "; $lobj_get_schema_names = $aobj_context->mobj_db->GetAll($get_schema_names); foreach($lobj_get_schema_names as $k=>$v) { $schema_name=$v['module_name']; $module_id= $v[internal_code]; $is_module_for_new_or_edit= $module_id; $rights=($is_module_for_new_or_edit>=1)?" is_edit=1 ":" is_add=1 "; $_SESSION['g_file_id'] =$lobj_get_file_id[internal_code]; $filename = $aobj_context->main_src."//html_modules//modules/module_".$module_id.".html"; $lstr_qry = "select a.*,ifnull(doc_root,0) as doc_root,ifnull(doc_root_mapped_id,0) as doc_root_mapped_id, ifnull(is_right_exstis,0) as is_right_exstis,{$is_module_for_new_or_edit} as is_module_for_new_or_edit from (select ifnull(is_grid_edit,0) as is_grid_edit, ue.internal_code,REPLACE(ur.module_name,' ','~') as ref_module_name, ue.name as element_name,ifnull(ue.field_position,'Next Line') as field_position, s.value as Type, ifnull(ug.name,'0None') as group_name, if(ug.internal_code is null,u.internal_code,concat(u.internal_code,'_',ug.internal_code)) as user_right_group, ue.description,s1.value as meta_data,ue.decimals, if(s1.value='Meta',concat('m_',u.internal_code,'_ele_',ue.internal_code),'') as meta_field, ue.default_value, ifnull(ue.ref_module_code_ref_field,0) as ref_module_code_ref_field, ifnull(s_ref.db_field,0) as ref_module_code_ref_field_db_field, ifnull(ue.ref_module_code_ref_field_on,0) as ref_module_code_ref_field_on, ifnull(ue.ref_module_code_ref_field_const,0) as ref_module_code_ref_field_const, ue.optional,ue.list_of_values,u.module_name, u.internal_code as ref_s_user_schema_code, ue.ref_module_code ,ue.is_read_only,ifnull(ue.padding,2)*9 as padding, IFNULL(ug.internal_code,0) as ref_s_user_schema_group_code,ifnull(multiple,0) as multiple, concat('user_schema_',u.internal_code ,'_group_',IFNULL(ug.internal_code,0)) as table_id, ifnull(ue.suffix,'None') as suffix,ue.width*9 as width,ue.linked_field,ue.source_field, Replace(if(ue.on_enter='',0,ifnull(ue.on_enter,0)),' ','~') as on_enter ,Replace(if(ue.on_exit='',0,ifnull(ue.on_exit,0)),' ','~') as on_exit ,ifnull(ue.is_ref_module_code_lov,0) as is_ref_module_code_lov from s_user_schema_elements ue inner join s_user_schema u on u.internal_code=ue.ref_s_user_schema_code left join s_user_schema_group ug on ug.internal_code=ref_s_user_schema_group_code left join s_ref_type s on s.internal_code=ue.data_type left join s_ref_type s1 on s1.internal_code=ue.s_ref_type_meta left join s_user_schema_elements s_ref on s_ref.internal_code=ue.ref_module_code_ref_field left join s_user_schema ur on ur.internal_code=ue.ref_module_code where u.internal_code= {$module_id} and ue.is_visible=1 and ifnull(parent_group_code,0)=0 and ifnull(ue.is_defined,1)=1 order by ifnull(ug.sequence,-1),ue.sequence,ue.internal_code )a left join # for User rights (select module_id as is_right_exstis from user_rights where module_id={$module_id} and ref_s_sysdb_code=".$_SESSION["user_id"]." and {$rights} ) b on b.is_right_exstis=a.user_right_group left join # for Auto Increment Values (select internal_code as doc_root,GROUP_CONCAT(ele_id) as doc_root_mapped_id from (select su.internal_code,su.name as value from s_user_schema_elements su inner join s_ref_type st1 on st1.internal_code=data_type where su.ref_s_user_schema_code={$module_id} and st1.value='Date')a inner JOIN (select su.internal_code as ele_id,su.name,source_field from s_user_schema_elements su inner join s_ref_type st1 on st1.internal_code=data_type where su.ref_s_user_schema_code={$module_id} and st1.value='Auto Increment' and source_field>0)b on a.internal_code=b.source_field group by internal_code) c on c.doc_root=a.internal_code "; $lobj_schema_details = $aobj_context->mobj_db->GetAll($lstr_qry); //$get_subgroup_id="select internal_code,group_name,"; $group_name= str_replace("0None","General",$lobj_schema_details[0][group_name]); $group_id= $lobj_schema_details[0][ref_s_user_schema_group_code]; $html_content="<head><script type='text/javascript'>\$(function() {\$('#tabs').tabs();});</script></head>"; $html_content.="<h3>\n"; $html_content.="\t<table width='702' border='0' cellspacing='0' cellpadding='0'> <tr><td align='left' valign='top'><span>{$group_name}</span></td> <td align='right' valign='bottom'><span class='showhide' id='span_{$group_id}' onclick=\"javascript:ShowHideDiv('group_div_{$group_id}','span_{$group_id}');\">Hide</span></td> </tr> <tr><td width='6' height='6' align='left' colspan='2' valign='top' class='content-line-repeat'> <img src='../images/tarka_new_menu.jpg' width='15' height='7' border='0' /></td> </tr>\n"; $html_content.="\t </table>"; $html_content.="\n</h3>\n"; $html_content.="\n <div id='group_div_{$group_id}' align='center' style='padding-top:8px;'>\n"; $html_content.= "\t<table id ='tbl_menu' class='content-tbl' align='center' cellpadding='2' cellspacing='0' border='0' >\n"; $label_tr=""; $text_tr=""; $actual_data=""; $html_label_tr=array(); $html_text_tr=array(); //$html_text_tr=""; for ($i=0;$i<count($lobj_schema_details);$i++) { $actual_data=""; $display_type=$v[display_type]; $actual_data_arr=getActualData($lobj_schema_details[$i],$display_type); //if($lobj_schema_details[$i][is_grid_edit]==0) { $actual_data=$actual_data_arr['actual_data']; } $padding_width=$actual_data_arr['padding_width']; $width_auto=($lobj_schema_details[$i][width]+20).'Px'; $padding_value=$lobj_schema_details[$i][padding]; if($lobj_schema_details[$i+1][field_position]=='Next Line') $padding_value=0; if($lobj_schema_details[$i]['Type']=='Date' || $lobj_schema_details[$i]['Type']=='Month' || $lobj_schema_details[$i]['Type']=='Reference Data' && ($lobj_schema_details[$i+1][field_position]=='Next Column')) { $padding_value+=3; } $padding=$padding_value.'Px'; $width_value=$lobj_schema_details[$i][width]; if($v[display_type]=="Left Right") { $lable_data=""; if($lobj_schema_details[$i][is_grid_edit]==0) { $lable_data=getLeftRightLabelData($lobj_schema_details[$i]); } // Forming Of Elements Ends if($lobj_schema_details[$i][ref_s_user_schema_group_code]==$group_id) { if($lobj_schema_details[$i][is_grid_edit]==0) { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; $html_content.= "<tr> {$lable_data} \n <td align='left' colspan=2 >" .$actual_data."</td>\n</tr>\n"; } } else { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; $group_name= str_replace("0None","General",$lobj_schema_details[$i][group_name]); if($lobj_schema_details[$i-1][multiple]==1) { $div_group_id=$lobj_schema_details[$i-1][ref_s_user_schema_group_code]; $table_name=$lobj_schema_details[$i-1][table_id]; if($lobj_schema_details[$i-1][is_grid_edit]==0) { $entry_table_name=str_ireplace("group","entry",$table_name); $html_content.=" </table> \n"; $html_content.= getSubGroupHTMLQuery($aobj_context,$module_id,$lobj_schema_details[$i-1][ref_s_user_schema_group_code],$v[display_type]); $html_content.="<div align='left' style='padding-top:2px;padding-bottom:2px;padding-left:23px;'><a class='anchor-class' onclick=\"javascript:saveSchemaGroupDetails('{$entry_table_name}','{$div_group_id}','{$table_name}');\" ><font color='blue'>Add</font></a>"; $html_content.="<a class='anchor-class' onclick=\"javascript:ClearMultiGroupCellData('{$entry_table_name}');\"><font color='blue'>Clear</font></a>"; $html_content.=getGroupLinks($aobj_context ,$div_group_id); $html_content.="</div>"; } $html_content.=" <div align='center' style=\"height:200px; width:690px; overflow:auto;\" id='main_group_grid_{$div_group_id}'></div>"; //$html_content.="<div id='multi_group_ad_search_{$div_group_id}' class='scroll-div' style='overflow: hidden; text-align: left; width: 690px; display: block;'><span id='mult_grid_a_search_name_id_{$div_group_id}'>Search: </span><input type='text' style='height:13px;' name='search' id='mult_group_grid_ad_search_id_{$div_group_id}' ></div>"; $html_content.="<script> displayUserSchemaModuleGroupDetails('{$table_name}',0,{$div_group_id},'main_group_grid_{$div_group_id}') </script>"; } else { $html_content.="\n</table>"; } $html_content.="\n</div>\n"; $html_content.="\n<h1></h1>\n"; $html_content.= "\n<h3>\n"; $html_content.="<table width='702' border='0' cellspacing='0' cellpadding='0'> <tr><td align='left' valign='top'><span>{$group_name}</span></td> <td align='right' valign='bottom'><span class='showhide' id='span_{$group_id}' onclick=\"javascript:ShowHideDiv('group_div_{$group_id}','span_{$group_id}');\">Hide</span></td> </tr> <tr><td width='6' height='6' align='left' colspan='2' valign='top' class='content-line-repeat'> <img src='../images/tarka_new_menu.jpg' width='15' height='7' border='0' /></td> </tr> </table>\n"; $html_content.="</h3>\n"; if($lobj_schema_details[$i-1][is_grid_edit]==0) $html_content.=" \n<div id='group_div_{$group_id}' align='center' style='padding-top:8px;'> <table id ='tbl_menu' class='content-tbl' align='center' cellpadding='2' cellspacing='0' border='0' >"; $html_content.= "\n <tr> {$lable_data} \n <td align='left' colspan=2>" .$actual_data."</td>\n</tr>\n"; } } else // Top Bottom { $label_width=($lobj_schema_details[$i][optional]==0)?($width_value+$padding_width-7+2) :($width_value+$padding_width+2) ; $label_width =($lobj_schema_details[$i][Type]=='Auto Increment')?($label_width+68):($label_width); if($lobj_schema_details[$i][optional]=='0') $lable_data="\n <font color='red'>* </font><input tabindex=-1 type='text' readonly='readonly' style='width:{$label_width}Px;' class='inputlabel' value='{$lobj_schema_details[$i][element_name]}' />\n <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' /> \n"; else $lable_data="\n <input type='text' style='width:{$label_width}Px;'tabindex=-1 class='inputlabel' readonly='readonly' value='{$lobj_schema_details[$i][element_name]}' />\n <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' /> \n"; if($i==0) { if($lobj_schema_details[$i][is_grid_edit]==0){ $label_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$lable_data}"; $text_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$actual_data} <input type='text' readonly='readonly' tabindex=-1 style='width:{$padding}; border:0px;' />"; } } else { if($lobj_schema_details[$i][field_position]=='Next Line') { $label_tr.="</td></tr>"; $text_tr.="</td></tr>"; $html_content.=$label_tr.$text_tr; $label_tr=""; $text_tr=""; if($lobj_schema_details[$i][is_grid_edit]=="0") { $label_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$lable_data}"; $text_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$actual_data} <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' />"; } } else if($lobj_schema_details[$i][is_grid_edit]=="0") { $label_tr.="{$lable_data}\n "; $text_tr.=" {$actual_data} <input type='text' readonly='readonly' tabindex=-1 style='width:{$padding}; border:0px;' />\n "; } } // Forming Of Elements Ends if($lobj_schema_details[$i][ref_s_user_schema_group_code]==$group_id) { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; } else { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; $group_name= str_replace("0None","General",$lobj_schema_details[$i][group_name]); if($lobj_schema_details[$i-1][multiple]==1) { $div_group_id=$lobj_schema_details[$i-1][ref_s_user_schema_group_code]; $table_name=$lobj_schema_details[$i-1][table_id]; $html_content.=" </table>\n"; if($lobj_schema_details[$i-1][is_grid_edit]=="0") { $entry_table_name=str_ireplace("group","entry",$table_name); $html_content.= getSubGroupHTMLQuery($aobj_context,$module_id,$lobj_schema_details[$i-1][ref_s_user_schema_group_code],$v[display_type]); $html_content.="<div align='left' style='padding-top:2px;padding-bottom:2px;padding-left:23px;'><a class='anchor-class' onclick=\"javascript:saveSchemaGroupDetails('{$entry_table_name}','{$div_group_id}','{$table_name}');\" ><font color='blue'>Add</font></a>"; $html_content.="<a class='anchor-class' onclick=\"javascript:ClearMultiGroupCellData('{$entry_table_name}');\" ><font color='blue'>Clear</font></a>"; $html_content.=getGroupLinks($aobj_context ,$div_group_id); $html_content.="</div>"; } $html_content.=" <div align='center' style=\"height:200px; width:690px; overflow:auto;\" id='main_group_grid_{$div_group_id}'></div>"; //$html_content.="<div id='multi_group_ad_search_{$div_group_id}' class='scroll-div' style='overflow: hidden; text-align: left;width: 690px; display: block;'><span id='mult_grid_a_search_name_id_{$div_group_id}'>Search: </span><input type='text' style='height:13px;' name='search' id='mult_group_grid_ad_search_id_{$div_group_id}' ></div>"; $html_content.="<script> displayUserSchemaModuleGroupDetails('{$table_name}',0,{$div_group_id},'main_group_grid_{$div_group_id}') </script>"; } else $html_content.="\n</table>"; $html_content.="\n</div>\n"; $html_content.="\n<h1></h1>\n"; $html_content.="\n<h3>\n"; $html_content.="<table width='702' border='0' cellspacing='0' cellpadding='0'> <tr><td align='left' valign='top'><span>{$group_name}</span></td> <td align='right' valign='bottom'><span class='showhide' id='span_{$group_id}' onclick=\"javascript:ShowHideDiv('group_div_{$group_id}','span_{$group_id}');\">Hide</span></td> </tr> <tr><td width='6' height='6' align='left' colspan='2' valign='top' class='content-line-repeat'> <img src='../images/tarka_new_menu.jpg' width='15' height='7' border='0' /></td> </tr> </table> </h3>\n"; $html_content.="<div id='group_div_{$group_id}' align='center' style='padding-top:8px;'>\n"; $html_content.="\t<table id ='tbl_menu' class='content-tbl' align='center' cellpadding='2' cellspacing='0' border='0' >"; } } } if(!empty($label_tr)) { $html_content.=$label_tr."</tr>".$text_tr."</tr></table>\n"; } else $html_content.="</table>\n"; if($lobj_schema_details[$i-1][multiple]==1 ) { $div_group_id=$lobj_schema_details[$i-1][ref_s_user_schema_group_code]; $table_name=$lobj_schema_details[$i-1][table_id]; $html_content.="</table>\n "; if($lobj_schema_details[$i-1][is_grid_edit]=="0") { $entry_table_name=str_ireplace("group","entry",$table_name); $html_content.= getSubGroupHTMLQuery($aobj_context,$module_id,$lobj_schema_details[$i-1][ref_s_user_schema_group_code],$v[display_type]); $html_content.="<div align='left' style='padding-top:2px;padding-bottom:2px;padding-left:23px;'>"; $html_content.="<a class='anchor-class' onclick=\"javascript:saveSchemaGroupDetails('{$entry_table_name}','{$div_group_id}','{$table_name}');\" ><font color='blue'>Add</font></a>"; $html_content.="<a class='anchor-class' onclick=\"javascript:ClearMultiGroupCellData('{$entry_table_name}');\" ><font color='blue'>Clear</font></a>"; $html_content.=getGroupLinks($aobj_context ,$div_group_id); $html_content.="</div>"; } $html_content.="<div align='center' style=\"height:200px; width:690px; overflow:auto;\" id='main_group_grid_{$div_group_id}'></div>"; //$html_content.="<div id='multi_group_ad_search_{$div_group_id}' class='scroll-div' style='overflow: hidden; text-align: left;width: 690px; display: block;'><span id='mult_grid_a_search_name_id_{$div_group_id}'>Search: </span><input type='text' style='height:13px;' name='search' id='mult_group_grid_ad_search_id_{$div_group_id}' ></div>"; $html_content.="<script> displayUserSchemaModuleGroupDetails('{$table_name}',0,{$div_group_id},'main_group_grid_{$div_group_id}') </script>"; } $html_content.=" "; if (!$handle = fopen($filename, 'w')) { echo "Cannot open file ($filename)"; exit; } if (fwrite($handle, $html_content) === FALSE) { echo "Cannot write to file ($filename)"; exit; } fclose($handle); } if(($schema_id=='0')) { $data="Files Created Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); } } function getLeftRightLabelData($lobj_schema_details) { if($lobj_schema_details[optional]=='0') $lable_data="\n <td style='vertical-align:center;width:150px;' align='right'><font color='red'>* </font>{$lobj_schema_details[element_name]}:</td>\n "; else $lable_data="\n <td style='vertical-align:center;width:150px;' align='right'> {$lobj_schema_details[element_name]}:</td>\n"; return $lable_data; } function getActualData($lobj_schema_details,$type) { $suffix=($lobj_schema_details[suffix]=='None')?' ':" ".$lobj_schema_details[suffix].' '; $diabled=($lobj_schema_details[is_read_only]=='1')? " READONLY='true'":" "; $width=$lobj_schema_details[width].'Px'; $width_auto=($lobj_schema_details[width]+20).'Px'; $padding=$lobj_schema_details[padding].'Px'; $width_value=$lobj_schema_details[width]; $default_value=$lobj_schema_details[default_value]; $on_focus=($lobj_schema_details[on_enter]!='0')? " onFocus={$lobj_schema_details[on_enter]};":" "; $on_blur=($lobj_schema_details[on_exit]!='0')? " onBlur={$lobj_schema_details[on_exit]};":" "; $imageInputWrapperwidth=$width_value-25; $actual_data=""; $padding_width=0; $view_image=""; if($lobj_schema_details[multiple]) $view_image=" viewGroupImage('{$lobj_schema_details[ref_s_user_schema_group_code]}','{$lobj_schema_details[internal_code]}') "; else $view_image=" viewModuleImage('{$lobj_schema_details[internal_code]}') " ; $image_wrapper_class=($type=='Left Right')?" LRimageInputWrapper ":" imageInputWrapper "; if($lobj_schema_details[Type]=='Date') { if($lobj_schema_details[doc_root_mapped_id]=='0') { $actual_data.="<label class='{$image_wrapper_class}' style='width:{$width_value}px;'>"; $actual_data.="<input {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' class='inputWithImge' type='text' style='width:{$imageInputWrapperwidth}px;' value='{$lobj_schema_details[default_value]}' />"; $actual_data.="<a href='javascript:;' style='text-decoration:none' id='date_{$lobj_schema_details[internal_code]}'>"; $actual_data.="<img src='../images/date.gif' alt='' class='calimg' onclick=\"calender_popup('details_{$lobj_schema_details[internal_code]}','date_{$lobj_schema_details[internal_code]}');\"/> </a>"; $actual_data.="</label>"; } else { $actual_data.="<label class='{$image_wrapper_class}' style='width:{$width_value}px;'>"; $actual_data.="<input {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' class='inputWithImge' type='text' style='width:{$imageInputWrapperwidth}px;' value='{$lobj_schema_details[default_value]}' onblur=getDocRootPrefix({$lobj_schema_details[ref_s_user_schema_code]},'{$lobj_schema_details[doc_root_mapped_id]}',{$lobj_schema_details[internal_code]}); onchange=getDocRootPrefix({$lobj_schema_details[ref_s_user_schema_code]},'{$lobj_schema_details[doc_root_mapped_id]}',{$lobj_schema_details[internal_code]}); />"; $actual_data.="<a href='javascript:;' style='text-decoration:none' id='date_{$lobj_schema_details[internal_code]}'>"; $actual_data.="<img src='../images/date.gif' alt='' class='calimg' onclick=\"calender_popup('details_{$lobj_schema_details[internal_code]}','date_{$lobj_schema_details[internal_code]}');\"/> </a>"; $actual_data.="</label>"; } $actual_data.=$suffix;//."<a href='javascript:;' id='date_{$lobj_schema_details[internal_code]}'> <img onclick=calender_popup('details_{$lobj_schema_details[internal_code]}','date_{$lobj_schema_details[internal_code]}'); src='../images/cal.jpg' border='0'></img></a>"; } else if($lobj_schema_details[Type]=='Month') { $actual_data.="<label class='{$image_wrapper_class}' style='width:{$width_value}px;'> "; $actual_data.=" <input {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' class='inputWithImge' type='text' style='width:{$imageInputWrapperwidth}px;' value='{$lobj_schema_details[default_value]}'/> "; $actual_data.="<img src='../images/date.gif' id='date_{$lobj_schema_details[internal_code]}' alt='' class='img' onclick=\"showYearMonthCalendar('{$lobj_schema_details[internal_code]}');\" />"; $actual_data.="<div align='right' id='sub_div_year_calander' style='position: absolute; visibility: visible;padding-top:8px; width:374px; display:none'>"; $actual_data.=$suffix;//."<a href='javascript:;' id='date_{$lobj_schema_details[internal_code]}'> <img onclick=calender_popup('details_{$lobj_schema_details[internal_code]}','date_{$lobj_schema_details[internal_code]}'); src='../images/cal.jpg' border='0'></img></a>"; $actual_data.="</label>"; } else if($lobj_schema_details[Type]=='Number') { $default_value=(empty($default_value))?0.00:$default_value; $actual_data.=" <input {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' type='text' style='width:{$width};text-align:right;' value='{$default_value}' onkeypress='return acceptNumbersOnlyForModule(event);' /> \n"; $actual_data.=$suffix; } else if($lobj_schema_details[Type]=='Large Text') { $actual_data.=" <textarea {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' style='width:{$width};' value='{$default_value}' cols='1' rows='3' > </textarea>\n"; $actual_data.=$suffix; } else if($lobj_schema_details[Type]=='Image') { $module_name=getlinkId($lobj_schema_details['module_name']); $actual_data.=" <input type='hidden' id='details_{$lobj_schema_details[internal_code]}' /><input class='content-tbl-upload' type='file' id='image_details_{$lobj_schema_details[internal_code]}' name='image_details_{$lobj_schema_details[internal_code]}'/>"; $actual_data.="<a class ='anchor-class' onclick=\"{$view_image};\">view</a>\n"; $actual_data.=$suffix; } else if($lobj_schema_details[Type]=='List Of Values') { $width_value+=2; $width=$width_value.'Px'; $actual_data.=" <select {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' style='width:{$width};' > \n"; $split_options=explode('|',$lobj_schema_details[list_of_values]); for($op_count=0;$op_count<count($split_options);$op_count++) { $value=($split_options[$op_count]=='Select One')? '':$split_options[$op_count]; $actual_data.="\n <option value='{$value}' id='{$split_options[$op_count]}'>{$split_options[$op_count]}</option>"; } $actual_data.="</select> \n "; $actual_data.=$suffix ; } else if($lobj_schema_details[Type]=='Auto Increment') { $actual_data.="<select id='auto_inc_{$lobj_schema_details[internal_code]}' onchange='getSerieslastNo(this.value,{$lobj_schema_details[ref_s_user_schema_code]},{$lobj_schema_details[internal_code]});'"; $actual_data.= "style='width:65px;'> <option value='0'>Select</option></select> "; $actual_data.=" <input {$diabled} id='details_{$lobj_schema_details[internal_code]}' {$on_focus} {$on_blur} type='text' style='width:{$width};' value='{$default_value}' /> \n"; if($lobj_schema_details[source_field]=='0') { //getAutoIncrementDefaultPrefix($lobj_schema_details[internal_code],$lobj_schema_details[ref_s_user_schema_code]); } } else if($lobj_schema_details[ref_module_code]!=0 && $lobj_schema_details[is_ref_module_code_lov]=='0') { $ref_m_ref_db_field=0; $ref_m_ref_val=0; // For Ref Display if($lobj_schema_details[ref_module_code_ref_field]!=0) { $ref_m_ref_db_field=$lobj_schema_details[ref_module_code_ref_field_db_field]; if($lobj_schema_details[ref_module_code_ref_field_on]!=0) { $ref_m_ref_val="$('#details_{$lobj_schema_details[ref_module_code_ref_field_on]}').val()"; } else { $ref_m_ref_val="'".str_ireplace(" ","~",$lobj_schema_details[ref_module_code_ref_field_const])."'"; } } $actual_data.="<input {$diabled} id='details_{$lobj_schema_details[internal_code]}' type='hidden' value='' /> \n"; $actual_data.="<label class='{$image_wrapper_class}' style='width:{$width_value}px;'>"; // $actual_data.="<input {$on_focus} {$diabled} class='inputWithImge' id='txt_ref_schema_{$lobj_schema_details[internal_code]}' type='text' style='width:{$imageInputWrapperwidth}px;' value='{$default_value}' onKeyUp=\"Javascript:if (event.keyCode != 38 || event.keyCode != 40 || event.keyCode != 13) loadAutoCompleteData(this, event,'select_auto_complete_{$lobj_schema_details[internal_code]}','search_div_{$lobj_schema_details[internal_code]}',{$lobj_schema_details[ref_module_code]},'{$ref_m_ref_db_field}',{$ref_m_ref_val}); else $('#select_auto_complete_{$lobj_schema_details[internal_code]}').focus();\" /> \n"; $actual_data.="<input {$on_focus} {$diabled} class='inputWithImge' id='txt_ref_schema_{$lobj_schema_details[internal_code]}' type='text' style='width:{$imageInputWrapperwidth}px;' value='{$default_value}' onKeyUp=\"Javascript:PopupKeyEvent(this, event,'select_auto_complete_{$lobj_schema_details[internal_code]}','search_div_{$lobj_schema_details[internal_code]}',{$lobj_schema_details[ref_module_code]},'{$ref_m_ref_db_field}',{$ref_m_ref_val},'{$lobj_schema_details[ref_module_name]}'); \" /> \n"; $actual_data.="<a onFocus= showIndex('txt_ref_schema_{$lobj_schema_details[internal_code]}','details_{$lobj_schema_details[internal_code]}','select_auto_complete_{$lobj_schema_details[internal_code]}',13); href='javascript:;' style='text-decoration:none' id='pop_up_{$lobj_schema_details[internal_code]}'>"; $actual_data.="<img src='../images/search-glass.gif' class='img' border = '0' onclick=\"assignSrefDataValue('{$lobj_schema_details[internal_code]}','{$lobj_schema_details[ref_module_code]}');calingScript('{$lobj_schema_details[ref_module_code]}','{$lobj_schema_details[internal_code]}','{$lobj_schema_details[ref_module_name]}'); \"> </a> </label>"; $actual_data.=$suffix; $actual_data.="<div id='search_div_{$lobj_schema_details[internal_code]}' style=\"position:absolute; display:none; z-index:10000;\" onMouseOver=\"javascript:oOverMenu='search_div_{$lobj_schema_details[internal_code]}';\" onMouseOut=\"javascript:oOverMenu=false;\">"; $actual_data.=" <select class='mainlink' size='10' id='select_auto_complete_{$lobj_schema_details[internal_code]}' style='width:{$width_auto}; border-style: none;background-color:#DDEFEF;;' onclick=\"JavaScript:autoCompleteSelectText('txt_ref_schema_{$lobj_schema_details[internal_code]}','details_{$lobj_schema_details[internal_code]}',this.id,this.value,{$lobj_schema_details[ref_module_code]})\""; $actual_data.="onkeydown=\"JavaScript:if(event.keyCode == 13)autoCompleteSelectTextByEnterKey('txt_ref_schema_{$lobj_schema_details[internal_code]}','details_{$lobj_schema_details[internal_code]}',this.id,this.value,{$lobj_schema_details[ref_module_code]});\" />"; $actual_data.="<option value='type'>type</option></select> </div>"; } else if($lobj_schema_details[ref_module_code]!=0 && $lobj_schema_details[is_ref_module_code_lov]=='1') { $actual_data.=" <select {$diabled} {$on_focus} {$on_blur} id='details_{$lobj_schema_details[internal_code]}' style='width:{$width};' > \n"; $actual_data.="</select> \n "; $actual_data.=$suffix ; } else { $actual_data.=" <input {$diabled} id='details_{$lobj_schema_details[internal_code]}' {$on_focus} {$on_blur} type='text' style='width:{$width};' value='{$default_value}' /> \n"; } $arr['actual_data']=$actual_data; $arr['padding_width']=$padding_width; return $arr; } function getSubGroupHTMLQuery($aobj_context,$module_id,$group_id,$type) { $lstr_qry = "select a.*,ifnull(doc_root,0) as doc_root,ifnull(doc_root_mapped_id,0) as doc_root_mapped_id, ifnull(is_right_exstis,0) as is_right_exstis,1 as is_module_for_new_or_edit from (select ue.internal_code,ifnull(is_grid_edit,0) as is_grid_edit, ue.name as element_name,ifnull(ue.field_position,'Next Line') as field_position, s.value as Type, ifnull(ug.name,'0None') as group_name, if(ug.internal_code is null,u.internal_code,concat(u.internal_code,'_',ug.internal_code)) as user_right_group, description,s1.value as meta_data,decimals, if(s1.value='Meta',concat('m_',u.internal_code,'_ele_',ue.internal_code),'') as meta_field, default_value, optional,list_of_values, u.internal_code as ref_s_user_schema_code, ue.ref_module_code ,is_read_only,ifnull(padding,2)*9 as padding, IFNULL(ug.internal_code,0) as ref_s_user_schema_group_code,ifnull(multiple,0) as multiple, concat('user_schema_',u.internal_code ,'_group_',IFNULL(ug.internal_code,0)) as table_id, ifnull(suffix,'None') as suffix,width*9 as width,linked_field,source_field, Replace(if(on_enter='',0,ifnull(on_enter,0)),' ','~') as on_enter ,Replace(if(on_exit='',0,ifnull(on_exit,0)),' ','~') as on_exit, ifnull(ue.is_ref_module_code_lov,0) as is_ref_module_code_lov, parent_group_code from s_user_schema_elements ue inner join s_user_schema u on u.internal_code=ue.ref_s_user_schema_code left join s_user_schema_group ug on ug.internal_code=ref_s_user_schema_group_code left join s_ref_type s on s.internal_code=ue.data_type left join s_ref_type s1 on s1.internal_code=ue.s_ref_type_meta where u.internal_code= {$module_id} and ifnull(ue.is_defined,1)=1 and ue.is_visible=1 and IFNULL(ug.parent_group_code,0)={$group_id} order by ifnull(ug.sequence,-1),ue.sequence,ue.internal_code )a left join # for User rights (select module_id as is_right_exstis from user_rights where module_id={$module_id} and ref_s_sysdb_code=".$_SESSION["user_id"]." ) b on b.is_right_exstis=a.user_right_group left join # for Auto Increment Values (select internal_code as doc_root,GROUP_CONCAT(ele_id) as doc_root_mapped_id from (select su.internal_code,su.name as value from s_user_schema_elements su inner join s_ref_type st1 on st1.internal_code=data_type where su.ref_s_user_schema_code={$module_id} and st1.value='Date')a inner JOIN (select su.internal_code as ele_id,su.name,source_field from s_user_schema_elements su inner join s_ref_type st1 on st1.internal_code=data_type where su.ref_s_user_schema_code={$module_id} and st1.value='Auto Increment' and source_field>0)b on a.internal_code=b.source_field group by internal_code) c on c.doc_root=a.internal_code "; $lobj_schema_details = $aobj_context->mobj_db->GetAll($lstr_qry); //echo $lstr_qry; $ul_subgroup_array=array(); $ul_subgroup_id_array=array(); $group_name= str_replace("0None","General",$lobj_schema_details[0][group_name]); $group_id= $lobj_schema_details[0][ref_s_user_schema_group_code]; $html_content=''; if($lobj_schema_details) { $html_content.="<br>"; $html_content.="<div id='tabs'>\n<ul>"; foreach($lobj_schema_details as $key=>$val) { if(!in_array($val[group_name],$ul_subgroup_array)) { array_push($ul_subgroup_array,$val[group_name]); $ul_subgroup_id_array[$val[group_name]]=$val[ref_s_user_schema_group_code]; } } for($u=0;$u<count($ul_subgroup_array);$u++) { $html_content.="<li><a href='#group_div_{$ul_subgroup_id_array[$ul_subgroup_array[$u]]}'>{$ul_subgroup_array[$u]}</a></li>\n"; } $html_content.="</ul>"; $html_content.="\n <div id='group_div_{$group_id}' align='center' style='padding-top:8px;'>\n"; $html_content.= "\t<table id ='tbl_menu' style='padding-left:2px; width:680px;' class='content-tbl' align='center' cellpadding='2' cellspacing='0' border='0' >\n"; $label_tr=""; $text_tr=""; $actual_data=""; $html_label_tr=array(); $html_text_tr=array(); //$html_text_tr=""; for ($i=0;$i<count($lobj_schema_details);$i++) { $actual_data=""; if($lobj_schema_details[$i][is_grid_edit]==0) { $actual_data_arr=getActualData($lobj_schema_details[$i],$type); } $actual_data=$actual_data_arr['actual_data']; $padding_value=$lobj_schema_details[$i][padding]; if($lobj_schema_details[$i+1][field_position]=='Next Line') $padding_value=0; if($lobj_schema_details[$i]['Type']=='Date' || $lobj_schema_details[$i]['Type']=='Month' || $lobj_schema_details[$i]['Type']=='Reference Data' && ($lobj_schema_details[$i+1][field_position]=='Next Column')) { $padding_value+=3; } $padding=$padding_value.'Px'; $padding_width=$actual_data_arr['padding_width']; $width_auto=($lobj_schema_details[$i][width]+20).'Px'; $width_value=$lobj_schema_details[$i][width]; if($type=="Left Right") { $lable_data=""; if($lobj_schema_details[$i][is_grid_edit]==0) { $lable_data=getLeftRightLabelData($lobj_schema_details[$i]);} // Forming Of Elements Ends if($lobj_schema_details[$i][ref_s_user_schema_group_code]==$group_id ) { if($lobj_schema_details[$i][is_grid_edit]==0) { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; $html_content.= "<tr> {$lable_data} \n <td align='left' colspan=2 >" .$actual_data."</td>\n</tr>\n"; } } else { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; $group_name= str_replace("0None","General",$lobj_schema_details[$i][group_name]); if($lobj_schema_details[$i-1][multiple]==1) { $div_group_id=$lobj_schema_details[$i-1][ref_s_user_schema_group_code]; $table_name=$lobj_schema_details[$i-1][table_id]; if($lobj_schema_details[$i-1][is_grid_edit]==0) { $entry_table_name=str_ireplace("group","entry",$table_name); $html_content.=" </table> \n"; $html_content.="<div align='left' style='padding-top:2px;padding-bottom:2px;padding-left:23px;'><a class='anchor-class' onclick=\"javascript:saveSchemaGroupDetails('{$entry_table_name}','{$div_group_id}','{$table_name}');\" ><font color='blue'>Add</font></a>"; $html_content.="<a class='anchor-class' onclick=\"javascript:ClearMultiGroupCellData('{$entry_table_name}');\" ><font color='blue'>Clear</font></a> "; $html_content.=getGroupLinks($aobj_context ,$div_group_id); $html_content.="</div>"; } $html_content.=" <div align='center' style=\"width:635px;padding-bottom:6px;\">"; $html_content.=" <div align='center' style=\"height:200px; width:628px; padding-right:2px; overflow:auto;\" id='main_group_grid_{$div_group_id}'></div>"; //$html_content.="<div id='multi_group_ad_search_{$div_group_id}' class='scroll-div' style='overflow: hidden; text-align: left; width: 630px; display: block;'><span id='mult_grid_a_search_name_id_{$div_group_id}'>Search: </span><input style='height:10px;' type='text' name='search' id='mult_group_grid_ad_search_id_{$div_group_id}' ></div>"; $html_content.="<script> displayUserSchemaModuleGroupDetails('{$table_name}',0,{$div_group_id},'main_group_grid_{$div_group_id}') </script>"; } else { $html_content.="\n</table>"; } $html_content.="\n</div></div>\n"; $html_content.=" \n<div id='group_div_{$group_id}' align='center' style='padding-top:8px;'> <table id ='tbl_menu' style='padding-left:2px; width:680px;' class='content-tbl' align='center' cellpadding='2' cellspacing='0' border='0'>"; $html_content.= "\n <tr> {$lable_data} \n <td align='left' colspan=2>" .$actual_data."</td>\n</tr>\n"; } } else { $label_width=($lobj_schema_details[$i][optional]==0)?($width_value+$padding_width-7).'Px':($width_value+$padding_width).'Px'; if($lobj_schema_details[$i][optional]=='0') $lable_data="\n <font color='red'>* </font><input tabindex=-1 type='text' readonly='readonly' style='width:{$label_width};' class='inputlabel' value='{$lobj_schema_details[$i][element_name]}' />\n <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' /> \n"; else $lable_data="\n <input type='text' style='width:{$label_width};'tabindex=-1 class='inputlabel' readonly='readonly' value='{$lobj_schema_details[$i][element_name]}' />\n <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' />\n"; if($i==0) { if($lobj_schema_details[$i][is_grid_edit]==0){ $label_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$lable_data}"; $text_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$actual_data} <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' />";} } else { if($lobj_schema_details[$i][field_position]=='Next Line') { $label_tr.="</td></tr>"; $text_tr.="</td></tr>"; $html_content.=$label_tr.$text_tr; $label_tr=""; $text_tr=""; if($lobj_schema_details[$i][is_grid_edit]=="0") { $label_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$lable_data}"; $text_tr.="<tr><td align='left' style='width:600px; padding-left:30px;'>{$actual_data} <input readonly='readonly' type='text' tabindex=-1 style='width:{$padding}; border:0px;' />"; } } else if($lobj_schema_details[$i][is_grid_edit]=="0") { $label_tr.="{$lable_data}\n "; $text_tr.=" {$actual_data} <input type='text' readonly='readonly' tabindex=-1 style='width:{$padding}; border:0px;' />\n "; } } // Forming Of Elements Ends if($lobj_schema_details[$i][ref_s_user_schema_group_code]==$group_id) { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; } else { $group_id=$lobj_schema_details[$i][ref_s_user_schema_group_code]; $group_name= str_replace("0None","General",$lobj_schema_details[$i][group_name]); if($lobj_schema_details[$i-1][multiple]==1) { $div_group_id=$lobj_schema_details[$i-1][ref_s_user_schema_group_code]; $table_name=$lobj_schema_details[$i-1][table_id]; $html_content.=" </table> \n"; if($lobj_schema_details[$i-1][is_grid_edit]==0) { $entry_table_name=str_ireplace("group","entry",$table_name); $html_content.="<div align='left' style='padding-top:2px;padding-bottom:2px;padding-left:23px;'><a class='anchor-class' onclick=\"javascript:saveSchemaGroupDetails('{$entry_table_name}','{$div_group_id}','{$table_name}');\" ><font color='blue'>Add</font></a>"; $html_content.="<a class='anchor-class' onclick=\"javascript:ClearMultiGroupCellData('{$entry_table_name}');\" ><font color='blue'>Clear</font></a>"; $html_content.=getGroupLinks($aobj_context ,$div_group_id); $html_content.="</div>"; } $html_content.=" <div align='center' style=\"width:635px;padding-bottom:6px;\">"; $html_content.=" <div align='center' style=\"height:200px; width:628px; overflow:auto;\" id='main_group_grid_{$div_group_id}'></div>"; $html_content.="<script> displayUserSchemaModuleGroupDetails('{$table_name}',0,{$div_group_id},'main_group_grid_{$div_group_id}') </script>"; } else { $html_content.="\n</table>"; } $html_content.="\n</div>"; if($lobj_schema_details[$i-1][multiple]==1) $html_content.="\n</div>"; //if($lobj_schema_details[$i-1][is_grid_edit]==0) $html_content.="\n</div>"; $html_content.="<div id='group_div_{$group_id}' align='center' style='padding-top:8px;'>\n"; $html_content.="\t<table id ='tbl_menu' style='padding-left:2px; width:680px;' class='content-tbl' align='center' cellpadding='2' cellspacing='0' border='0' >"; } } } $html_content.=$label_tr."</tr>".$text_tr."</tr></table>\n"; if($lobj_schema_details[$i-1][multiple]==1) { $div_group_id=$lobj_schema_details[$i-1][ref_s_user_schema_group_code]; $table_name=$lobj_schema_details[$i-1][table_id]; $html_content.="</table>\n "; if($lobj_schema_details[$i-1][is_grid_edit]==0) { $entry_table_name=str_ireplace("group","entry",$table_name); $html_content.="<div align='left' style='padding-top:2px;padding-bottom:2px;padding-left:23px;'>"; $html_content.="<a class='anchor-class' onclick=\"javascript:saveSchemaGroupDetails('{$entry_table_name}','{$div_group_id}','{$table_name}');\"><font color='blue'>Add</font></a>"; $html_content.="<a class='anchor-class' onclick=\"javascript:ClearMultiGroupCellData('{$entry_table_name}');\" ><font color='blue'>Clear</font></a>"; $html_content.=getGroupLinks($aobj_context ,$div_group_id); $html_content.="</div>"; } //echo $html_content; $html_content.=" <div align='center' style=\"width:635px;padding-bottom:6px;\">"; $html_content.="<div align='center' style=\"height:200px; width:628px; overflow:auto;\" id='main_group_grid_{$div_group_id}'></div>"; //$html_content.="<div id='multi_group_ad_search_{$div_group_id}' class='scroll-div' style='overflow: hidden; text-align: left;width: 630px; display: block;'><span id='mult_grid_a_search_name_id_{$div_group_id}'>Search: </span><input type='text' style='height:13px;' name='search' id='mult_group_grid_ad_search_id_{$div_group_id}' ></div>"; $html_content.="<script> displayUserSchemaModuleGroupDetails('{$table_name}',0,{$div_group_id},'main_group_grid_{$div_group_id}') </script>"; } $html_content.="</div></div>"; $html_content.="</div>"; } return $html_content; } function getGroupLinks($aobj_context,$group_id) { $custom_links=""; $get_custom_links="select custom_links from s_user_schema_group where internal_code={$group_id}"; $lobj_get_links_from_module = $aobj_context->mobj_db->GetRow($get_custom_links); if(!empty($lobj_get_links_from_module[custom_links])) { $split_by_pipe=explode("|",$lobj_get_links_from_module[custom_links]); for($split=0;$split<count($split_by_pipe);$split++) { $function_split=explode("~",$split_by_pipe[$split]); $name=$function_split[0]; $id=getlinkId($name); $link_id.=$id; $fun=$function_split[1]; $custom_links.="<a class='anchor-class' onclick=\"javascript:{$fun};\" ><font color='blue'>{$name}</font></a>"; } } return $custom_links; } function getlinkId($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","."); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } ?>
Close
