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 | : 13.58.203.104
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 : uploadmoduledetails.php
<?php function getModuleDetailsHeaders($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $schema_id = $aobj_context->mobj_data["schema_id"]; $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $excel_writer=$aobj_context->main_src."/Excel_Writer/Writer.php"; require_once($excel_writer); $tarka_format_file=$aobj_context->main_src."/custom_src/TarkaFormatStyles.php"; require_once($tarka_format_file); $objfrmt =& new FormatStyle(); $workbook = new Spreadsheet_Excel_Writer(); $Title_Center =& $workbook->addFormat($objfrmt->Title_Center); $worksheet =& $workbook->addWorksheet(); $get_headers="(select ue.internal_code, ue.name as element_name, s.value as Type, ifnull(ug.name,'0None') as group_name, s1.value as meta_data,decimals, optional,list_of_values, u.internal_code as ref_s_user_schema_code, ue.ref_module_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= {$schema_id} and is_multiple_group=0 order by ifnull(ug.sequence,0),ue.sequence,ue.internal_code )"; $lobj_details = $aobj_context->mobj_db->GetAll($get_headers); $row=0; $cell=1; $worksheet->write($row,0, "internal_code"); foreach($lobj_details as $key=> $value) { if($value[optional]==1) { $worksheet->write($row,$cell, $value[element_name]); } else { $worksheet->write($row,$cell, $value[element_name],$Title_Center); } $cell++; } $workbook->send($schema_id.'.xls','D'); $workbook->close(); } function getGroupModuleDetailsHeaders($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $schema_id = $aobj_context->mobj_data["schema_id"]; $group_id = $aobj_context->mobj_data["group_id"]; $group_name = $aobj_context->mobj_data["group_name"]; $group_entry_table_name = $aobj_context->mobj_data["group_entry_table_name"]; $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $excel_writer=$aobj_context->main_src."/Excel_Writer/Writer.php"; include($excel_writer); $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet(); $get_headers="(select ue.internal_code, ue.name as element_name from s_user_schema_elements ue where ue.ref_s_user_schema_code = {$schema_id} and ref_s_user_schema_group_code = {$group_id} and is_multiple_group=1 and is_visible=1 and ifnull(ue.is_defined,1)=1 order by ue.sequence,ue.internal_code )"; $lobj_details = $aobj_context->mobj_db->GetAll($get_headers); $row=0; $cell=1; $worksheet->write($row,0, "internal_code"); foreach($lobj_details as $key=> $value) { $worksheet->write($row,$cell, $value[element_name]); $cell++; } $workbook->send($schema_id.'.xls','D'); $workbook->close(); } function downloadModuleData($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $schema_id = $aobj_context->mobj_data["schema_id"]; $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $excel_writer=$aobj_context->main_src."/Excel_Writer/Writer.php"; require_once($excel_writer); $workbook = new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); $worksheet =& $workbook->addWorksheet('sheet 1'); $get_data_type="SELECT name,t.value from s_user_schema_elements s inner join s_ref_type t on t.internal_code=data_type where ref_s_user_schema_code={$schema_id}"; $obj_get_data_type = $aobj_context->mobj_db->GetAll($get_data_type); $data_type_arr= array(); for($k=0;$k<count($obj_get_data_type);$k++) { $data_type_arr[$obj_get_data_type[$k]['name']]=$obj_get_data_type[$k]['value']; } $aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000"); $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,'_',internal_code,' on module_',ref_module_code,'_',internal_code,'.internal_code =module_',ref_s_user_schema_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]:''; $group_table=" select GROUP_CONCAT(group_table SEPARATOR ' ') as group_table from (select concat(' left join user_schema_',ref_s_user_schema_code,'_group_',internal_code, ' as ug_',internal_code,' on ',' ug_',internal_code,'.ref_s_ref_data_code=module_',ref_s_user_schema_code,'.internal_code') as group_table from s_user_schema_group where ref_s_user_schema_code={$schema_id} and multiple=1)d"; $obj_group_table = $aobj_context->mobj_db->GetRow($group_table); if(!is_null($obj_group_table[group_table])) { $group_table_join_qry=$obj_group_table[group_table]; $get_group_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('ug_',group_int_code,'.',field_name,' as ',\"'\",name,\"'\"), concat('module_',ref_module_code,'_',ele_ic_code,'.',field_id1,' as ',\"'\",name,\"'\")) as field_name ,ref_module_code from (select s.internal_code, ref_module_code,concat('module_',s.internal_code) as table_name , field_id1,ref_s_user_schema_group_code as group_int_code,su.internal_code as ele_ic_code, su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name, db_field 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=1 ) a "; $lobj_get_group_display_cols = $aobj_context->mobj_db->GetRow($get_group_display_cols); $group_table_dis_cols=','.$lobj_get_group_display_cols[field_name]; $aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000"); $aobj_context->mobj_db->execute("set @a:=0"); $select_group_table_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from (select ref_module_code, concat(' left join module_',ref_module_code, ' as module_',ref_module_code,'_',sus.internal_code,' on module_',ref_module_code,'_',sus.internal_code,'.internal_code =ug_',ref_s_user_schema_group_code,'.',db_field) as join_table_name from s_user_schema_elements sus inner join s_user_schema s on s.internal_code=sus.ref_s_user_schema_code where s.internal_code={$schema_id} and is_multiple_group=1 and ref_module_code>0)j"; $obj_select_group_table_ref_module_code = $aobj_context->mobj_db->GetRow($select_group_table_ref_module_code); $group_table_ref_module= (!is_null($obj_select_group_table_ref_module_code[qry]))?$obj_select_group_table_ref_module_code[qry]:''; } else { $group_table_join_qry=''; $group_table_dis_cols=''; } $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(\"concat(\",f1,f2,\") as \",'\'',name,'\''), if(data_type='Date', concat('DATE_FORMAT(','module_',internal_code,'.',field_name,',\'%d-%b-%Y\') as \'',name,'\''), concat('module_',internal_code,'.',field_name,' as \"', name,'\"'))) as field_name ,ref_module_code from (select s.internal_code, su.internal_code as ele_id,t1.value as data_type, ref_module_code,concat('module_',s.internal_code) as table_name , field_id, if(ifnull(field_id1,'')!='',concat('module_',ref_module_code,'_',su.internal_code,'.',field_id1),'') as f1, if(ifnull(field_id2,'')!='',concat(',\'-\',module_',ref_module_code,'_',su.internal_code,'.',field_id2),'') as f2, 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 inner join s_ref_type t1 on t1.internal_code=data_type 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); //echo $get_display_cols; die(); ini_set("memory_limit",-1); ini_set('max_execution_time', 1400); $select_data="(select module_{$schema_id}.internal_code as internal_code, {$lobj_get_display_cols[field_name]} {$group_table_dis_cols} from module_{$schema_id} {$join_qry} {$group_table_join_qry} {$group_table_ref_module} ) "; //echo $select_data; die(); $lobj_details = $aobj_context->mobj_db->GetAll($select_data); $header_row=(array_keys($lobj_details[0])); $header_row_cell_indx=0; foreach($header_row as $key1=> $value1) { $worksheet->write(0,$header_row_cell_indx,$value1); $header_row_cell_indx++; } $xlsRow = 1; foreach($lobj_details as $key=> $value) { $xlscol=0; foreach($value as $key1=> $value1) { if($data_type_arr[$key1]=='Number' or $key1=='internal_code' or $data_type_arr[$key1]=='Date') $worksheet->write($xlsRow,$xlscol,$value1); else $worksheet->writeString($xlsRow,$xlscol,$value1); $xlscol++; } $xlsRow++; } $workbook->close(); $workbook->send("report_{$schema_id}.xls"); } function uploadModuleGroupDetailsIntoDB($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $schema_id = $aobj_context->mobj_data["schema_id"]; $table_name='module_'.$schema_id; $login_ctr = $aobj_context->mobj_data["login_ctr"]; $group_id = $aobj_context->mobj_data["group_id"]; $group_name = $aobj_context->mobj_data["group_name"]; $user_id = $_SESSION['user_id']; //$schema_id = $aobj_context->mobj_data["schema_id"]; ini_set("memory_limit",-1); ini_set('max_execution_time', 1400); require_once($aobj_context->main_src."/custom_src/inventory_master.php"); $obj_master=new inventoryMaster($aobj_context); $obj_master->getBillofMaterialDetails(); $obj_master->getItemMaster(); $obj_master->getStageMaster(); $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $root_file_name=$aobj_context->main_src."/imported_files/module_details_{$schema_id}"; $root_file_name = $root_file_name . $_SESSION['user_id']."_".basename( $_FILES['module_group_details_uploaded_file']['name']); $failed=0; if(isset($_FILES['module_group_details_uploaded_file']['name']) && $_FILES['module_group_details_uploaded_file']['name'] != '') { if(move_uploaded_file($_FILES['module_group_details_uploaded_file']['tmp_name'],$root_file_name)) { $reader_path=$aobj_context->main_src."/Excel_reader/reader.php"; require_once $reader_path; $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('CP1251'); $data->read($root_file_name); error_reporting(E_ALL ^ E_NOTICE); $header_cols=""; // echo '<pre>'; //print_r($data->sheets[0]['cells']); //die(); for($bil = 2 ; $bil <= count($data->sheets[0]['cells']) ; $bil++ ) { $stage = $data->sheets[0]['cells'][$bil][2]; $item = $data->sheets[0]['cells'][$bil][3]; $qty = $data->sheets[0]['cells'][$bil][4]; $alt_qty = $data->sheets[0]['cells'][$bil][5]; $alt_qty = (empty($alt_qty))?0:$alt_qty; $reference = $data->sheets[0]['cells'][$bil][6]; $notes = $data->sheets[0]['cells'][$bil][7]; $stage_int_code = getStageCode($aobj_context,$obj_master,$stage); $item_int_code = getItemCode($aobj_context,$obj_master,$item); if(empty($stage_int_code)) continue; if(empty($item_int_code)) continue; $get_dup_code = "select internal_code from {$obj_master->billofmaterial_entry_table} where {$obj_master->billofmaterial_item} = {$item_int_code} and {$obj_master->billofmaterial_stage} = {$stage_int_code} and login_cnt = {$login_ctr} "; $lobj_get_dup_code = $aobj_context->mobj_db->GetRow($get_dup_code); if(!empty($lobj_get_dup_code[internal_code])) continue; $insert_bill_group_details = "INSERT INTO {$obj_master->billofmaterial_entry_table} ( internal_code, login_cnt, group_int_code, ref_s_user_schema_code, ref_s_user_schema_group_code, ref_s_ref_data_code, {$obj_master->billofmaterial_item}, {$obj_master->billofmaterial_quantity}, {$obj_master->billofmaterial_alt_quantity}, {$obj_master->billofmaterial_refference}, {$obj_master->billofmaterial_notes}, {$obj_master->billofmaterial_stage}, created_by, created_date, modified_by, modified_date ) values (0, {$login_ctr}, 0, {$schema_id}, {$group_id}, 0, {$item_int_code}, {$qty}, {$alt_qty}, '{$reference}', '{$notes}', {$stage_int_code}, '{$user_id}', now(), '{$user_id}', now() )"; // echo $insert_bill_group_details; // die(); $lobj_insert_bill_group_details = $aobj_context->mobj_db->execute($insert_bill_group_details); } } } unlink($root_file_name); unset($_FILES); $lobj_get_ids = 'Successfully Uploaded' ; echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_ids,0,"success"); } function getStageCode($aobj_context,$obj_master,$stage) { $find_stgae_code = "select internal_code from {$obj_master->stage_master_table} where {$obj_master->stage_master_name} = '{$stage}'"; $lobj_find_stgae_code = $aobj_context->mobj_db->GetRow($find_stgae_code); return $lobj_find_stgae_code[internal_code]; } function getItemCode($aobj_context,$obj_master,$item) { $find_item_code = "select internal_code from {$obj_master->item_master_table} where {$obj_master->item_master_name} = '{$item}' or {$obj_master->item_master_code} = '{$item}' or concat({$obj_master->item_master_name},'-',{$obj_master->item_master_code}) ='{$item}' "; $lobj_find_item_code = $aobj_context->mobj_db->GetRow($find_item_code); return $lobj_find_item_code[internal_code]; } function uploadModuleDetailsIntoDB($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $schema_id = $aobj_context->mobj_data["schema_id"]; $table_name='module_'.$schema_id; $aobj_context->mobj_data["ref_s_user_schema_code"] = $schema_id; ini_set("memory_limit",-1); ini_set('max_execution_time', 1400); $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $root_file_name=$aobj_context->main_src."/imported_files/module_details_{$schema_id}"; $root_file_name = $root_file_name . $_SESSION['user_id']."_".basename( $_FILES['module_details_uploaded_file']['name']); $failed=0; if(isset($_FILES['module_details_uploaded_file']['name']) && $_FILES['module_details_uploaded_file']['name'] != '') { if(move_uploaded_file($_FILES['module_details_uploaded_file']['tmp_name'],$root_file_name)) { $reader_path=$aobj_context->main_src."/Excel_reader/reader.php"; require_once $reader_path; $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('CP1251'); $data->read($root_file_name); error_reporting(E_ALL ^ E_NOTICE); $header_cols=""; for ($i = 1; $i <=1; $i++) { for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) { $xls_header_columns[$j]=strtolower($data->sheets[0]['cells'][$i][$j]); $header_cols.="'{$xls_header_columns[$j]}',"; } } $header_cols=substr($header_cols,0,strlen($header_cols)-1); //getting the column through the query $get_details="(select ue.internal_code,is_unique, ue.name as element_name, 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, SUBSTRING(list_of_values,1, LOCATE('|',list_of_values)-1) as first_lov, u.internal_code as ref_s_user_schema_code,db_field as field_id, ue.ref_module_code ,is_read_only, 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, if(ue.ref_module_code>0,concat('module_',ue.ref_module_code),'') as ref_table_name 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= {$schema_id} and ue.name in ({$header_cols}) and is_multiple_group=0 order by ifnull(ug.sequence,0),ue.sequence,ue.internal_code )"; $lobj_get_name=$aobj_context->mobj_db->GetAll($get_details); $module_meta_insert_qry="insert into module_{$schema_id} (ref_s_user_schema_code,"; $module_user_insert_qry="insert into module_{$schema_id}_details ( ref_s_user_schema_code, ref_s_module_code, ref_s_user_schema_group_code, ref_s_user_schema_elements_code, value, ref_ref_s_user_schema_code, created_by, created_date, modified_by, modified_date ) values ("; $input_fields_arr="\$input_fields_arr=array ("; foreach ($lobj_get_name as $key=>$value) { if($value['meta_data']=='Meta' ) { $module_meta_insert_qry.=$value['meta_field'].","; $input_fields_arr.="'{$value['meta_field']}'=>'0',\n"; } } $input_fields_arr.=");"; $module_meta_insert_qry=substr($module_meta_insert_qry,0,strlen($module_meta_insert_qry) - 1); $module_meta_insert_qry= $module_meta_insert_qry.",created_by, created_date, modified_by, modified_date) values ( {$schema_id},"; //Ends getting the Data Cols $l=1; $m=0; $db_header_columns[0]="internal_code"; foreach ($lobj_get_name as $key=>$value) { $db_header_columns[$l]=strtolower($value[element_name]); $l++; } $result = array_diff($xls_header_columns, $db_header_columns); if(!empty($result)) { foreach($result as $key=>$value) { $error_data.="\"".strtoupper($value)."\" column are not matching with DB Column"; $error_data.="\n"; } header("Content-type:application/txt"); header("Content-Disposition:attachment;filename=error_log"); //readfile($root_file_name); echo $error_data; return; } session_start(); $validation_file_name=$aobj_context->main_src."/validation_files/validate_".$_SESSION['g_file_id'].".php"; $format_file=$aobj_context->main_src."/src/format.php"; //$update_qry="update {$table_name} set " $data_str="<?php \n"; $data_str.=" if (file_exists('$validation_file_name')) { require_once('$validation_file_name'); } require_once('$format_file'); "; $data_str.="\$s_ref_error_flag=0; \n"; $data_str.="\$validate_ref_error_flag=0; \n"; $data_str.=" {$input_fields_arr} \n"; $data_str.="\$original_value=''; \n"; $data_str.="\$error_msg=''; \n"; $data_str.="\$down_load_value=''; \n"; $data_str.="\$validation=''; \n"; $data_str.="\$header_value='Following Records are not inserted'.\"\\n\"; \n"; $data_str.="for (\$i = 2; \$i <= \$data->sheets[0]['numRows']; \$i++) { \$values=''; \$original_value=''; \$validation='' \n; \$error_msg=''; \$validate_ref_error_flag=0; \$s_ref_error_flag=0; for (\$j = 1; \$j <= \$data->sheets[0]['numCols']; \$j++) { if(\$i==2) { \$header_value.=\$data->sheets[0]['cells'][1][\$j].\",\"; } \n "; //To Map Internal_code $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('internal_code')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n"; $data_str.="\$internal_code=trim(\$data->sheets[0]['cells'][\$i][\$j]); \n"; $data_str.="\$internal_code=empty(\$internal_code)?0:\$internal_code; \n }"; $cell_row=1; foreach ($lobj_get_name as $key=>$value) { if(1) { if($value[is_unique]==1) { $update_cond.="{$value[field_id]} = '{\$".$value[field_id]."}' and "; } if($value[ref_module_code]!=0 && $value[meta_data]=='Meta') { $qry=" select table_name,field_name as name,field_id1 ,field_id2 from module_meta_columns WHERE module_id={$value[ref_module_code]}"; $lobj_rs = $aobj_context->mobj_db->GetRow($qry); $data_str.="\$where_cond1='';\$where_cond2='';\$concat_cond='';"; $data_str.="\n if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) \n { \n"; $data_str.="\$cell_value=addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n"; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n"; $data_str.="\$where_cond1=\"{$lobj_rs[field_id1]} like '{\$cell_value}'\"; \n"; //$where_cond1= $data[".$k."] ; if(!empty($lobj_rs[field_id2])) { $data_str.="\$where_cond2=\" or {$lobj_rs[field_id2]} like '{\$cell_value}'\"; \n"; $data_str.="\$concat_cond=\" or concat({$lobj_rs[field_id1]},' - ',{$lobj_rs[field_id2]}) like '{\$cell_value}'\"; \n"; } $data_str.="\$select_ref_data_{$value[ref_module_code]}=\"select internal_code from {$value[ref_table_name]} where {\$where_cond1} {\$where_cond2} {\$concat_cond}\"; \n"; $data_str.="\$obj_select_ref_data_{$value[ref_module_code]} = \$aobj_context->mobj_db->GetRow(\$select_ref_data_{$value[ref_module_code]}); \n"; if($value[optional]=='0') { $data_str.=" if(empty(\$cell_value)) \n { \n \$s_ref_error_flag=1; \n \$error_msg.='{$value[element_name]} is Mandatory:'; \n } \n"; } $data_str.=" if(empty(\$obj_select_ref_data_{$value[ref_module_code]}) && !empty(\$data->sheets[0]['cells'][\$i][\$j])) \n { \n \$s_ref_error_flag=1; \n \$error_msg.='{$value[element_name]} not Found:'; \n } \n"; $data_str.="$".$value[field_id]." = empty(\$obj_select_ref_data_{$value[ref_module_code]}[internal_code])?0:\$obj_select_ref_data_{$value[ref_module_code]}[internal_code]; \n "; $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~';"; $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};"; $data_str.=" } \n "; $insert_value.="'{\$".$value[field_id]."}',"; $update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , "; $k++; } else if($value[Type]=='List Of Values' && $value[meta_data]=='Meta') { $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n"; $data_str.="\$lov_val= \$data->sheets[0]['cells'][\$i][\$j];"; $data_str.="$".$value[field_id]." = (empty(\$lov_val))?'".$value[first_lov]."':\$lov_val;\n "; $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n"; $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};"; $data_str.=" } \n"; $insert_value.="'{\$".$value[field_id]."}',"; $update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , "; $k++; } else if($value[Type]=='Date' && $value[meta_data]=='Meta' ) { $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n"; $data_str.="\$date_obj = addslashes(\$data->sheets[0]['cells'][\$i][\$j]) ; \n \n"; if($value[optional]=='0') { $data_str.=" if(empty(\$date_obj)) \n { \n \$s_ref_error_flag=1; \n \$error_msg.='{$value[element_name]} is Mandatory:'; \n } \n"; } $data_str.="if(empty(\$date_obj)) { \${$value[field_id]}='0000-00-00'; } else { "; $data_str.="$".$value[field_id]." = GetDbDateFormatFromExcel(\$date_obj);}\n"; $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n"; $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};"; $data_str.="}"; $insert_value.="'{\$".$value[field_id]."}',"; $update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , "; $k++; } else if($value[meta_data]=='Meta' && $value[Type]=='Number') { $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n"; $data_str.="$".$value[field_id]." = addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n "; if($value[optional]=='0') { $data_str.=" if(empty(\${$value[field_id]})) \n { \n \$s_ref_error_flag=1; \n \$error_msg.='{$value[element_name]} is Mandatory:'; \n } \n"; } $data_str.="\${$value[field_id]}=empty(\${$value[field_id]})?0:\${$value[field_id]};"; $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n"; $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};"; $data_str.=" } \n"; $insert_value.="'{\$".$value[field_id]."}',"; $update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , "; $k++; }else if($value[meta_data]=='Meta' && ($value[Type]=='Text' or $value[Type]=='Large Text')) { $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n"; $data_str.="$".$value[field_id]." = addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n "; if($value[optional]=='0') { $data_str.=" if(empty(\${$value[field_id]})) \n { \n \$s_ref_error_flag=1; \n \$error_msg.='{$value[element_name]} is Mandatory:'; \n } \n"; } $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n"; $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};"; $data_str.=" } \n"; $insert_value.="'{\$".$value[field_id]."}',"; $update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , "; $k++; } // User Checking Starts Here else if( $value[meta_data]=='User' && $value[Type]=='List Of Values' ) { $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n"; $data_str.="\$user_details_array[{$m}][element_name]='$value[element_name]' ; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_code]=$value[ref_s_user_schema_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_group_code]=$value[ref_s_user_schema_group_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_elements_code]=$value[internal_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_ref_s_user_schema_code]=$value[ref_module_code]; \n"; $data_str.="\$pos1 = stripos(\"{$value[list_of_values]}\", \$data->sheets[0]['cells'][\$i][\$j]); \n if(\$pos1===false) { \n \$s_ref_error_flag=1; \n } \n else \n"; $data_str.="\$user_details_array[{$m}][value]=addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n } \n"; $m++; $k++; } else if( $value[meta_data]=='User' && $value[ref_module_code]!=0 ) { $qry=" select table_name,field_name as name,field_id1 ,field_id2 from module_meta_columns WHERE module_id={$value[ref_module_code]}"; $lobj_rs = $aobj_context->mobj_db->GetRow($qry); $data_str.="\n if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) \n { \n"; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n"; $data_str.="\$user_details_array[{$m}][element_name]='$value[element_name]' ; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_code]=$value[ref_s_user_schema_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_group_code]=$value[ref_s_user_schema_group_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_elements_code]=$value[internal_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_ref_s_user_schema_code]=$value[ref_module_code]; \n"; $data_str.="\$where_cond1=\"{$lobj_rs[field_id1]} like '{\$data->sheets[0]['cells'][\$i][\$j]}'\"; \n"; //$where_cond1= $data[".$k."] ; if(!empty($lobj_rs[field_id2])) $data_str.="\$where_cond2=\" or {$lobj_rs[field_id2]} like '{\$data->sheets[0]['cells'][\$i][\$j]}'\"; \n"; $data_str.="\$select_ref_data_{$value[ref_module_code]}=\"select internal_code from {$value[ref_table_name]} where {\$where_cond1} {\$where_cond2}\"; \n"; $data_str.="\$obj_select_ref_data_{$value[ref_module_code]} = \$aobj_context->mobj_db->GetRow(\$select_ref_data_{$value[ref_module_code]}); \n"; $data_str.=" if(empty(\$obj_select_ref_data_{$value[ref_module_code]})) \n { \n \$s_ref_error_flag=1; \n } \n"; $data_str.="\$user_details_array[{$m}][value] = \$obj_select_ref_data_{$value[ref_module_code]}[internal_code]; \n } \n "; $m++; $k++; } else if( $value[meta_data]=='User' && $value[Type]!='List Of Values' && $value[ref_module_code]==0) { $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n "; $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n"; $data_str.="\$user_details_array[{$m}][element_name]='$value[element_name]' ; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_code]=$value[ref_s_user_schema_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_group_code]=$value[ref_s_user_schema_group_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_s_user_schema_elements_code]=$value[internal_code]; \n"; $data_str.="\$user_details_array[{$m}][ref_ref_s_user_schema_code]=$value[ref_module_code]; \n"; $data_str.="\$user_details_array[{$m}][value]=addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n } \n"; $m++; $k++; } } } $update_cond_value=substr($update_cond_value,0,strlen($update_cond_value)-2) ; $final_update_qry.=" update {$table_name} set ".$update_cond_value."\n"; $who_fields_update=" ,modified_by=".$_SESSION['user_id'].",modified_date=now()"; $update_cond=substr($update_cond,0,strlen($update_cond)-4) ; $final_update_through_internal_code= $final_update_qry.$who_fields_update." where internal_code={\$internal_code}"; $final_update_qry.=$who_fields_update." where ".$update_cond; $insert_value=substr($insert_value,0,strlen($insert_value)-1); $who_fields=",".$_SESSION['user_id'].",now(),".$_SESSION['user_id'].",now() "; $data_str.="\n } "; $data_str.=" \n \$validate_ref_error_flag=0; if (function_exists('validate')) { \$aobj_context->mobj_data['save_schema_details_arr']=''; \$aobj_context->mobj_data['save_schema_details_arr']=\$input_fields_arr;\n \$aobj_context->mobj_data['internal_code']=\$internal_code;\n validate(\$aobj_context,'upload');\n \$valide_arr=validate(\$aobj_context,'upload');\n \$validate_ref_error_flag=empty(\$valide_arr['validate_ref_error_flag'])?0:\$valide_arr['validate_ref_error_flag']; \$error_msg.= \$valide_arr['error_msg']; }; "; $data_str.="if(\$s_ref_error_flag==0 && \$validate_ref_error_flag==0) \n { \n if(\$internal_code==0 ){ \n"; $data_str.="\$insert_qry=\"".$module_meta_insert_qry.$insert_value.$who_fields.")\"; \n"; $data_str.="\$obj_qry = \$aobj_context->mobj_db->Execute(\$insert_qry); \n \$mysql_error=mysql_error(); \$last_inserted_id = \$aobj_context->mobj_db->Insert_ID(); \n if(\$mysql_error !='') \n { \n \$pos=strpos(\$mysql_error,'Duplicate'); if(\$pos===false) { \$down_load_value.=\$original_value.\",\".\$mysql_error .\"\\n\"; } else { \$get_update_int_code=\"select internal_code from module_{$schema_id} where {$update_cond}\"; \$obj_get_update_int_code = \$aobj_context->mobj_db->getRow(\$get_update_int_code); \n \$last_inserted_id= \$obj_get_update_int_code[internal_code]; \$update_qry=\" {$final_update_qry} \"; \n \$obj_qry = \$aobj_context->mobj_db->Execute(\$update_qry); \n } \n } \n } \n else { // TO CHECK USER RIGHT PERMINSSIONS \$get_created_by_id=\" select created_by from module_{$schema_id} where internal_code=\$internal_code \"; \n \$obj_get_created_by_id = \$aobj_context->mobj_db->GetRow(\$get_created_by_id); \n \$created_by_id= \$obj_get_created_by_id[created_by]; \$edit_right=getUserEditRights(\$aobj_context, \$created_by_id); if( \$edit_right=='1') { \$update_qry=\" {$final_update_through_internal_code} \"; \n \$obj_qry = \$aobj_context->mobj_db->Execute(\$update_qry); \n \$last_inserted_id =\$internal_code; } else { \$original_value.=\"You Dont have a right to update this record\\n\"; \$down_load_value.=\$original_value \n; } } \n if (function_exists('postSave')) { postSave(\$aobj_context,\$last_inserted_id,\$internal_code); } if(\$last_inserted_id >0 && !empty(\$user_details_array)) { \$insert_who_fields_for_details_table=\" ,\". \$_SESSION['user_id'].\", now(),\" . \$_SESSION['user_id'].\", now()\"; \$delete_qry=\"delete from module_{$schema_id}_details where ref_s_module_code=\$last_inserted_id\"; \$obj_delete_qry = \$aobj_context->mobj_db->Execute(\$delete_qry); \n foreach(\$user_details_array as \$k=>\$v) { \$user_insert_qry=\"{$module_user_insert_qry} '{\$v[ref_s_user_schema_code]}', '\$last_inserted_id', '{\$v[ref_s_user_schema_group_code]}', '{\$v[ref_s_user_schema_elements_code]}', '{\$v[value]}', '{\$v[ref_ref_s_user_schema_code]}' {\$insert_who_fields_for_details_table}) \"; \$obj_user_insert_qry = \$aobj_context->mobj_db->Execute(\$user_insert_qry); \n //echo \$user_insert_qry; } } }"; $data_str.=" else { \$original_value.=\",\$error_msg\\n\"; \$down_load_value.=\$original_value \n; } \n"; $data_str.=" } "; $data_str.=" if(!empty(\$down_load_value)) \n { \n header(\"Content-type:application/csv\"); \n header(\"Content-Disposition:attachment;filename=error_log.csv\"); \n echo \$header_value.\"\\n\".\$down_load_value; \n return; \n } else \n echo \"<script type='text/javascript'> alert('File has been uploaded.');</script>\";"; $data_str.=getUserRightsString($schema_id)." ?>"; $tmp_root_file_name=$aobj_context->main_src."/imported_files/upload_module_details_qry_".$_SESSION['user_id'].".php"; file_put_contents($tmp_root_file_name,$data_str); require_once($tmp_root_file_name); unlink($tmp_root_file_name); unlink($root_file_name); unset($_FILES); } else echo "cannot move the files";exit; } } function getUserRightsString($schema_id) { $edit_right_str=" function getUserEditRights(\$aobj_context, \$created_by_id) { \$edit_right=1; session_start(); \$user_type=\$_SESSION['user_type']; \$user_id=\$_SESSION['user_id']; \$user_dept=\$_SESSION['user_dept']; if(strtolower(\$user_type)!='admin') { \$get_rights=\"select is_edit,is_edit_group_records,is_edit_dep_records,is_edit_all_records from user_rights where ref_s_sysdb_code={\$user_id} and module_id={$schema_id}\"; \$obj_get_rights = \$aobj_context->mobj_db->GetRow(\$get_rights); \$own=\$obj_get_rights[is_edit]; \$group=\$obj_get_rights[is_edit_group_records]; \$dep=\$obj_get_rights[is_edit_dep_records]; \$all=\$obj_get_rights[is_edit_all_records]; if(strtolower(\$user_type)=='admin' || \$all=='1') { \$edit_right=1; } else if(\$own=='1' && \$dep=='0') //checks for Own Records Only { if(\$created_by_id==\$user_id) \$edit_right=1; else \$edit_right=0; \$get_own_created_by_id=\"select created_by from {\$table} where internal_code in ({\$lstr_ids})\"; \$obj_get_own_created_by_id = \$aobj_context->mobj_db->GetRow(\$get_own_created_by_id); } else if(\$dep=='1')//checks for Department Records Only { \$get_users_of_department=\"select GROUP_CONCAT(ref_user_code) as dep_users from dept_user_mapping where ref_dept_code={\$user_dept} and ref_user_code={\$created_by_id}\"; \$obj_u_dep = \$aobj_context->mobj_db->GetRow(\$get_users_of_department); if(\$obj_u_dep) \$edit_right=1;else \$edit_right=0; } } return \$edit_right; }"; return $edit_right_str; } ?>
Close
