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.118.32.6
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 : general_report_format.php
<?php function displayReport($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $format_file=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/src/format.php"; include($format_file); $report_id = $aobj_context->mobj_data["report_id"]; $schema_name = $aobj_context->mobj_data["schema_name"]; $FromDate = db_date_Format($aobj_context->mobj_data["Fromdate"]); $ToDate = db_date_Format($aobj_context->mobj_data["Todate"]); $a_path= "http://".$_SERVER["SERVER_NAME"] ."/{$main_src}/app.php?a=getDownloadReportFile&report_id=".$report_id."&FromDate=".$FromDate."&ToDate=".$ToDate; $a_pdf_path= "http://".$_SERVER["SERVER_NAME"] ."/{$main_src}/app.php?a=getDownloadPDFReportFile&report_id=".$report_id."&FromDate=".$FromDate."&ToDate=".$ToDate; if(!in_array($report_id,$_SESSION['report_ids'])) { $_SESSION['report_count']=$_SESSION['report_count']+1; $_SESSION['report_ids'][$_SESSION['report_count']]=$report_id; } $get_display_cols="select concat(m_2_ele_7,'-',m_2_ele_8) as 'Activity_Code',expense_type as 'Expense_Type', amount as Amount from activity_cost a inner join module_2 m on m.internal_code=activity_code where from_date>='{$FromDate}' and to_date<= '{$ToDate}' order by 1"; $lobj_get_display_cols = $aobj_context->mobj_db->GetRow($get_display_cols); $header=array_keys($lobj_get_display_cols); $grid_header=''; $grid_header_val=''; foreach($header as $key=> $value) { $grid_header.="'".$header[$key]."',"; $grid_header_val.="{name:'grid_".$header[$key]."',index:'grid_".$header[$key]."', width:50 } ,"; } $grid_header=substr($grid_header,0,strlen($grid_header)-1); $grid_header_val=substr($grid_header_val,0,strlen($grid_header_val)-1); $lstr="<html> <head> <title>{$schema_name} Report </title> <link rel='stylesheet' type='text/css' media='screen' href='../../jqGrid3/themes/tarka/grid.css' /> <link rel='stylesheet' type='text/css' media='screen' href='../../jqGrid3/themes/jqModal.css' /> <script src='../../js/index.js' type='text/javascript'></script> <script src='../../jqGrid3/jquery.js' type='text/javascript'></script> <script src='../../jqGrid3/jquery.jqGrid.js' type='text/javascript'></script> <script src='../../jqGrid3/js/jqModal.js' type='text/javascript'></script> <script src='../../jqGrid3/js/jqDnR.js' type='text/javascript'></script> <script type='text/javascript'> var host_url= \"http://{$_SERVER["SERVER_NAME"]}/{$main_src}/app.php?a=\"; var img_path=\"http://{$_SERVER["SERVER_NAME"]}/{$main_src}/jqGrid3/themes/tarka/images/\"; function displayReportDetails() { document.getElementById('sub_grid_div').innerHTML=''; document.getElementById('main_grid_div').innerHTML=''; var main=\"<table id='table_grid' class='scroll' ></table> <div id='sub_grid_div' class='scroll' style='text-align:center;'></div>\"; document.getElementById('main_grid_div').innerHTML=main; jQuery(\"#table_grid\").jqGrid( { url:host_url+'viewGridReportDetails.demo&report_id={$report_id}&FromDate={$FromDate}&ToDate={$ToDate}', datatype: 'json', colNames:[{$grid_header}], colModel:[{$grid_header_val}], rowNum:20, rowList:[5,10,15,20,25,30], imgpath:img_path, pager: jQuery('#sub_grid_div'), sortname: 'id', height:'auto', viewrecords: true, sortorder: 'desc', cellEdit: true, multiselect: false, width:'900', caption:'{$schema_name}' } ).navGrid('#sub_grid_div',{edit:false,add:false,del:false}); jQuery('#vcol').click(function (){ jQuery('#table_grid').setColumns(); }); } </script> </head> <body bgcolor='#EAEAEA' ONLOAD='displayReportDetails();'> <div style=' padding-top:12px; padding-bottom:05px;'><a href='{$a_path}'>Download</a> <a href='{$a_pdf_path}'>Download PDF</a></div> <div id='main_grid_div' style=' width:100%; overflow:auto;'> <table id='table_grid' class='scroll'></table> <div id='sub_grid_div' class='scroll' style='text-align:center;'></div> </div> <div style='padding-top:12px;'><a href='{$a_path}'>Download</a> <a href='{$a_pdf_path}'>Download PDF</a> <a href='#' id='vcol'>Hide/Show Columns</a></div> </body> </html>"; $root_file_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report_display_".$_SESSION['user_id']."_".$report_id.".html"; $root_file_download=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report_display_".$_SESSION['user_id']."_".$report_id.".csv"; file_put_contents($root_file_download,$down_load); if(file_put_contents($root_file_name,$lstr)) { $open_path= $_SERVER["SERVER_NAME"]."/{$main_src}/Report_details/output/report_display_".$_SESSION['user_id']."_".$report_id.".html"; echo $aobj_context->mobj_output->ToJSONEnvelope($open_path,0,"success"); } } //ownloadReport1(); function downloadReport($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $report_id = $aobj_context->mobj_data["report_id"]; $FromDate = $aobj_context->mobj_data["FromDate"]; $ToDate = $aobj_context->mobj_data["ToDate"]; $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $excel_writer=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Excel_Writer/Writer.php"; include($excel_writer); $root_xls_file_download=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report".$_SESSION['user_id']."_".$report_id.".xls"; $workbook = new Spreadsheet_Excel_Writer($root_xls_file_download); // sending HTTP headers //$workbook->send('test.xls'); // Creating a worksheet $worksheet =& $workbook->addWorksheet('Sheet1'); $get_data="select concat(m_2_ele_7,'-',m_2_ele_8) as 'Activity_Code',expense_type as 'Expense_Type', amount as Amount from activity_cost a inner join module_2 m on m.internal_code=activity_code where from_date>='{$FromDate}' and to_date<= '{$ToDate}' order by 1"; $lobj_details = $aobj_context->mobj_db->GetAll($get_data); $header_row=(array_keys($lobj_details[0])); $header_row_cell_indx=0; foreach($header_row as $key=> $value) { $worksheet->write(0,$header_row_cell_indx,$value); $header_row_cell_indx++; } $xlsRow = 1; foreach($lobj_details as $key=> $value) { $xlscol=0; foreach($value as $key1=> $value1) { $worksheet->write($xlsRow,$xlscol,$value1); $xlscol++; } $xlsRow++; } $workbook->close(); header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=report\"$report_id\".xls"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0,pre-check=0"); header("Pragma: public"); readfile($root_xls_file_download); unlink($root_xls_file_download); } function downloadPDFReport($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $report_id = $aobj_context->mobj_data["report_id"]; $FromDate = $aobj_context->mobj_data["FromDate"]; $ToDate = $aobj_context->mobj_data["ToDate"]; $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $pdf_writer_class=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/maya-pdf/cls.pdf.php"; include($pdf_writer_class); $pdf= new PDF('P','mm','A4'); $get_data="select concat(m_2_ele_7,'-',m_2_ele_8) as 'Activity_Code',expense_type as 'Expense_Type', amount as Amount from activity_cost a inner join module_2 m on m.internal_code=activity_code where from_date>='{$FromDate}' and to_date<= '{$ToDate}' order by 1"; // dnt change order of execution // getting data $lobj_details = $aobj_context->mobj_db->GetAll($get_data); // getting Header data $header_row=(array_keys($lobj_details[0])); // Setting font style $pdf->SetFont('courier','',10); // Adding page $pdf->AddPage(); // Displaying Header information in the PDF File foreach($header_row as $col) { $pdf->Cell(95,5,$col,1,'','C','true'); $pdf->SetFillColor(200,220,255); } //Displaying Data in th PDF File foreach($lobj_details as $row) { $pdf->Ln(); foreach($row as $col) $pdf->Cell(95,5,$col,1); } // Downloading file to the Destination using // d for downloading without going to next page // I for viewing the PDF file in the browser itself // default for downloading file and display the new page in the browser $pdf->Output("report_{$report_id}.pdf","d"); } function displayGridReportDetails($aobj_context) { $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $search_file_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/src/getsearchcondition.php"; $FromDate = $aobj_context->mobj_data["FromDate"]; $ToDate = $aobj_context->mobj_data["ToDate"]; include($search_file_name); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("/JSON.php"); $data_qry="select a.internal_code ,concat(m_2_ele_7,'-',m_2_ele_8) as 'Activity_Code',expense_type as 'Expense_Type', amount as Amount from activity_cost a inner join module_2 m on m.internal_code=activity_code where from_date>='{$FromDate}' and to_date<= '{$ToDate}' "; $json = new Services_JSON(); $limit = $_GET['rows']; $sidx = $_GET['sidx']; $sord = $_GET['sord']; $page = $_GET['page']; if(!$sidx) $sidx =1; else $indx=explode("grid_",$sidx); $sidx=empty($indx[1])?'1':$indx[1]; $table_name=$_GET['table_name']; $table_field_name=stripcslashes($_GET['field_name']); $details_array=$_GET['details_array']; // to take th e parameters from Search field if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $field_name_value=explode('grid_',$_GET['searchField']); $final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']); $cond=$final_value[0]; $value=$final_value[1]; } $field_name=$field_name_value[1]; if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $count_id="select count(*) as count from ({$data_qry}) a where $field_name $cond$value"; } else { $count_id="select count(*) as count from ({$data_qry}) a"; } $result = mysql_query($count_id); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; // calculation of total pages for the query if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; if($start <0) $start = 0; // the actual query for the grid data if(isset($_GET['searchField']) && $_GET["_search"]=='true') { $SQL="select * from ({$data_qry} )a where $field_name $cond$value ORDER BY $sidx $sord LIMIT $start,$limit"; //echo $SQL; } else { $SQL = " {$data_qry} ORDER BY $sidx $sord LIMIT $start , $limit"; } $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $lobj_rs =$aobj_context->mobj_db->GetAll($SQL); foreach($lobj_rs as $key =>$value) { $val=''; $responce->rows[$key]['id']=$value[internal_code]; $l=0; foreach($value as $key1 =>$value1) { if($key1!='internal_code'){ $val[$l]=$value[$key1]; $l++; } } $responce->rows[$key]['cell']=($val); } echo $json->encode($responce); } ?>
Close