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.219.158.84
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
college /
Report_details /
[ HOME SHELL ]
Name
Size
Permission
Action
output
[ DIR ]
drwxr-xr-x
AttDateWiseReportexcel.php
4.33
KB
-rwxr-xr-x
Attdet.php
7.07
KB
-rwxr-xr-x
AttdetPdf.php
8.46
KB
-rwxr-xr-x
AttdetPdfUniclare.php
7.49
KB
-rwxr-xr-x
AttdetexcelUniclare.php
5.48
KB
-rwxr-xr-x
CIEAttendanceNotEligiblepdf.ph...
6.83
KB
-rwxr-xr-x
CIEpendingListpdf.php
9.05
KB
-rwxr-xr-x
DegreeWiseStudLstUSN.php
7.69
KB
-rwxr-xr-x
DownloadExamAppFormApplication...
11.64
KB
-rwxr-xr-x
DownloadRvRtAckApplications.ph...
4.6
KB
-rwxr-xr-x
Generatecollegeiamarkspendingr...
7.49
KB
-rwxr-xr-x
PrintChallanEntryDetails.php
8.27
KB
-rwxr-xr-x
RVApplicationsReport.php
8.9
KB
-rwxr-xr-x
RvPcListDetailedReport.php
12.51
KB
-rwxr-xr-x
RvRtApplicationReport.php
8.82
KB
-rwxr-xr-x
absentAndMalReportPdf.php
11.5
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
11.76
KB
-rwxr-xr-x
admReport.php
7.78
KB
-rwxr-xr-x
admReport_old.php
12.3
KB
-rwxr-xr-x
admlist.php
13.87
KB
-rwxr-xr-x
admregisterlist.php
7.15
KB
-rwxr-xr-x
affliation_detailed_report.php
12.56
KB
-rwxr-xr-x
appear_list_center_qp_wise.php
12.82
KB
-rwxr-xr-x
appear_list_qp_wise.php
6.32
KB
-rwxr-xr-x
appfeedetails.php
7.67
KB
-rwxr-xr-x
approval_report.php
19.63
KB
-rwxr-xr-x
attCisshortList.php
15.57
KB
-rwxr-xr-x
attCisshortList_sjbit.php
12.03
KB
-rwxr-xr-x
attendanceReportForm.php
5.69
KB
-rwxr-xr-x
attendanceform_pdf.php
11.9
KB
-rwxr-xr-x
attiacombined.php
9.52
KB
-rwxr-xr-x
attiacombinedReportnewexcel_sj...
12.94
KB
-rwxr-xr-x
attiacombinednew.php
12.31
KB
-rwxr-xr-x
attiacombinednew_sjbit.php
8.49
KB
-rwxr-xr-x
attshortlist.php
10.69
KB
-rwxr-xr-x
basic_data_coll.php
6.74
KB
-rwxr-xr-x
basic_data_sum.php
7.47
KB
-rwxr-xr-x
batch_wise_details.php
4.45
KB
-rwxr-xr-x
board.php
3.86
KB
-rwxr-xr-x
bundle_ack.php
12.96
KB
-rwxr-xr-x
candidatelist.php
9.9
KB
-rwxr-xr-x
categorywisereport.php
9.03
KB
-rwxr-xr-x
cntrtagcollstud.php
4.99
KB
-rwxr-xr-x
code39.php
6.38
KB
-rwxr-xr-x
college_pending_markslist.php
6.8
KB
-rwxr-xr-x
college_pending_markslist19032...
6.48
KB
-rwxr-xr-x
convoreport.php
5.56
KB
-rwxr-xr-x
copomarksexternalreportexcel.p...
7.02
KB
-rwxr-xr-x
daterange.php
6.27
KB
-rwxr-xr-x
degreewiseMarksEntryStats.php
8.44
KB
-rwxr-xr-x
empty_report_admission_det.php
8.91
KB
-rwxr-xr-x
exam_attendance_det.php
8.61
KB
-rwxr-xr-x
exam_attendance_summary.php
9.78
KB
-rwxr-xr-x
excelreport.php
27.36
KB
-rwxr-xr-x
generate.php
7.32
KB
-rwxr-xr-x
generateDaliyReportQpNitteExce...
16.13
KB
-rwxr-xr-x
generatePostAdmissionTicket.ph...
51.8
KB
-rwxr-xr-x
generatePostAdmissionTicket_25...
47.13
KB
-rwxr-xr-x
generatePostAdmissionTicket_ol...
37.45
KB
-rwxr-xr-x
generatePrintIaMarks.php
16.19
KB
-rwxr-xr-x
generatePrintIaMarksnew.php
16.28
KB
-rwxr-xr-x
generateQuestionWiseIAReportPD...
18.73
KB
-rwxr-xr-x
generateXlGraph.php
3.87
KB
-rwxr-xr-x
generateadmissionreg.php
11.79
KB
-rwxr-xr-x
generatecoporeport_xl.php
21.04
KB
-rwxr-xr-x
gerderwiseresultsheet.php
11.95
KB
-rwxr-xr-x
getDegree.php
2.27
KB
-rwxr-xr-x
getDegreeAndSem.php
4.32
KB
-rwxr-xr-x
getIaSubjWiseReport.php
0
B
-rwxr-xr-x
getNitteAdmXlreport.php
14.34
KB
-rwxr-xr-x
getReportClassStud.php
6.03
KB
-rwxr-xr-x
gradewisesubjectanalysisreport...
19.82
KB
-rwxr-xr-x
headerNfooter.php
5.56
KB
-rwxr-xr-x
headerNfooters.php
1.93
KB
-rw-rw-r--
iaMarksQnWiseReportExcel.php
25.41
KB
-rwxr-xr-x
iaMarksReportPDF.php
10.84
KB
-rwxr-xr-x
iaSubjectWiseReport.php
10.74
KB
-rwxr-xr-x
ia_room_allotment_datewise.php
9.08
KB
-rwxr-xr-x
iaemptyformat.php
9.63
KB
-rwxr-xr-x
invig_report.php
10.18
KB
-rwxr-xr-x
invig_report_summary.php
7.74
KB
-rwxr-xr-x
latEntryRprt.php
6.4
KB
-rwxr-xr-x
markListReportPdf.php
21.32
KB
-rwxr-xr-x
markListReportPdfnew.php
44.55
KB
-rwxr-xr-x
markListReportPdfnew_24112023....
42.93
KB
-rwxr-xr-x
marksentryquestionwise.php
23.83
KB
-rwxr-xr-x
mregistry.php
129.68
KB
-rwxr-xr-x
pdfacknowledgeAppNo.php
10.95
KB
-rwxr-xr-x
pendingcie.php
0
B
-rwxr-xr-x
photo_report.php
7.04
KB
-rwxr-xr-x
pi_test.php
3.45
KB
-rwxr-xr-x
picharttesting.php
19.9
KB
-rwxr-xr-x
principalFreeze_report.php
7.23
KB
-rwxr-xr-x
printIaMarks.php
12.74
KB
-rwxr-xr-x
printIaMarks_old.php
12.74
KB
-rwxr-xr-x
printMarkListDetailsWisenew.ph...
10.1
KB
-rwxr-xr-x
printMarkListDetailsWisenew_CI...
3.98
KB
-rwxr-xr-x
printMarkListDetailsWisenew_sj...
11.81
KB
-rwxr-xr-x
printMarkListSubWiseJssstu.php
28.29
KB
-rwxr-xr-x
print_applications_ru.php
26.59
KB
-rwxr-xr-x
qp_issue.php
8.46
KB
-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...
55.13
KB
-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...
33.16
KB
-rwxr-xr-x
qrhallticket.php
56.1
KB
-rwxr-xr-x
r
9.23
KB
-rwxr-xr-x
regNoAllot.php
25.14
KB
-rwxr-xr-x
reg_stud_list.php
8.34
KB
-rwxr-xr-x
reportAttClassCreate.php
5.14
KB
-rwxr-xr-x
reportAttCount.php
12.89
KB
-rwxr-xr-x
reportAttCount_old_08112022.ph...
11.11
KB
-rwxr-xr-x
report_adm_lat_studwise.php
10.13
KB
-rwxr-xr-x
report_admission_details.php
26.8
KB
-rwxr-xr-x
report_admission_list.php
49.63
KB
-rwxr-xr-x
report_admission_list_bf_gcg.p...
26.39
KB
-rwxr-xr-x
report_admission_list_kswu.php
15.12
KB
-rwxr-xr-x
report_admission_list_rur.php
28
KB
-rwxr-xr-x
report_admission_list_wop.php
10.31
KB
-rwxr-xr-x
report_admission_ticket.php
64.74
KB
-rwxr-xr-x
report_admission_ticket_bf_uuc...
37.63
KB
-rwxr-xr-x
report_attendance_sheet.php
18.31
KB
-rwxr-xr-x
report_attendance_shortage.php
9.23
KB
-rwxr-xr-x
report_attendance_summary.php
10.85
KB
-rwxr-xr-x
report_attendance_summary_old....
7.19
KB
-rwxr-xr-x
report_bacth_preparation_dairy...
7
KB
-rwxr-xr-x
report_batch_practical_dairy.p...
15.35
KB
-rwxr-xr-x
report_batch_wise_details.php
8.83
KB
-rwxr-xr-x
report_batch_worksheet_details...
14.68
KB
-rwxr-xr-x
report_bulk_applications.php
26.14
KB
-rwxr-xr-x
report_bulk_applications_nitte...
25.55
KB
-rwxr-xr-x
report_bundle_dispatch.php
13.73
KB
-rwxr-xr-x
report_candidate_list.php
31.49
KB
-rwxr-xr-x
report_candidate_list_old.php
29.91
KB
-rwxr-xr-x
report_daliy_report.php
10.47
KB
-rwxr-xr-x
report_daliy_report_qp.php
10.21
KB
-rwxr-xr-x
report_daliy_report_qp_nitte.p...
17.01
KB
-rwxr-xr-x
report_daliy_report_qp_sjbit.p...
17.25
KB
-rwxr-xr-x
report_data_sent.php
8.41
KB
-rwxr-xr-x
report_degree_list.php
5.3
KB
-rwxr-xr-x
report_deviation_report.php
7.67
KB
-rwxr-xr-x
report_evaluation_report.php
9.31
KB
-rwxr-xr-x
report_iamarks_pending.php
8.19
KB
-rwxr-xr-x
report_marks_deviation_report....
5.38
KB
-rwxr-xr-x
report_marks_elementwise.php
3.13
KB
-rwxr-xr-x
report_marks_entry_student_lis...
6.55
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
20.78
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.43
KB
-rwxr-xr-x
report_marks_pending.php
12.02
KB
-rwxr-xr-x
report_online_eam.php
11.59
KB
-rwxr-xr-x
report_practical_marks_details...
13.35
KB
-rwxr-xr-x
report_practical_marks_details...
18.15
KB
-rwxr-xr-x
report_practical_marks_details...
13.33
KB
-rwxr-xr-x
report_practical_marks_details...
13.32
KB
-rwxr-xr-x
report_practical_misc.php
8.24
KB
-rwxr-xr-x
report_qpcount_univ.php
5.17
KB
-rwxr-xr-x
report_ra_exl_report.php
6.78
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
43.87
KB
-rwxr-xr-x
report_ra_invigilator_dairy_bf...
22.69
KB
-rwxr-xr-x
report_ra_invigilator_dairy_gu...
19.86
KB
-rwxr-xr-x
report_ra_invigilator_dairy_st...
19.82
KB
-rwxr-xr-x
report_ra_invigilators_dairy.p...
9.26
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
10.63
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
8.74
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
10.67
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
26.62
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
17.6
KB
-rwxr-xr-x
report_reg_list.php
33.33
KB
-rwxr-xr-x
report_reg_list_gcg.php
33.55
KB
-rwxr-xr-x
report_reg_list_gcg_new_040120...
33.12
KB
-rwxr-xr-x
report_revaluation.php
6.42
KB
-rwxr-xr-x
report_subject_admcl_list.php
3.68
KB
-rwxr-xr-x
report_subject_general_list.ph...
4.87
KB
-rwxr-xr-x
resultsheet.php
12.7
KB
-rwxr-xr-x
resultsheet_x.php
9.15
KB
-rwxr-xr-x
resultsheetsubwise.php
11.24
KB
-rwxr-xr-x
revaluation.php
15.65
KB
-rwxr-xr-x
roomallotmantsummary.php
6.57
KB
-rwxr-xr-x
roomallotmantsummarysubjwise.p...
9.31
KB
-rwxr-xr-x
roomwise_register_nos_list.php
26.84
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
semesterWiseResultReportpdf.ph...
9.9
KB
-rwxr-xr-x
shortageReport.php
11.87
KB
-rwxr-xr-x
std_regstr_det_reprt_xl.php
7.6
KB
-rwxr-xr-x
stringspliter.php
718
B
-rwxr-xr-x
stud_wise_report.php
8.97
KB
-rwxr-xr-x
studentHisResult.php
7.92
KB
-rwxr-xr-x
student_count.php
4.16
KB
-rwxr-xr-x
studentwiseresult.php
16.77
KB
-rwxr-xr-x
subjRegReport.php
7.54
KB
-rwxr-xr-x
subject_wise_student_list.php
6.2
KB
-rwxr-xr-x
subjwisepasspercentage.php
10.45
KB
-rwxr-xr-x
subjwisepasspercentagePie.php
10.92
KB
-rwxr-xr-x
subjwiseressheet.php
12.79
KB
-rwxr-xr-x
subwiseGrafAnalysis.php
20.04
KB
-rwxr-xr-x
subwiseGrafAnalysis1.php
22.44
KB
-rwxr-xr-x
subwiseResultReport.php
12.75
KB
-rwxr-xr-x
tatkal.php
4.84
KB
-rwxr-xr-x
teachFreeze_report.php
8.96
KB
-rwxr-xr-x
teacher_report.php
11.26
KB
-rwxr-xr-x
teacher_val_report.php
10.59
KB
-rwxr-xr-x
timetabledegreewiserpt.php
6.73
KB
-rwxr-xr-x
topsheet.php
8.58
KB
-rwxr-xr-x
verifystud.php
8.38
KB
-rwxr-xr-x
xl_AckAppReport.php
10.02
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : admlist.php
<?php $main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7); //$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php"; $pdf_writer_class =$main_src."/tcpdf/tcpdf.php"; require_once($pdf_writer_class); ini_set('memory_limit','900M'); ini_set('max_execution_time',0); class MYPDF extends TCPDF { public $aobj_context; public $fintake; public function setData($aobj_context) { $this->aobj_context = $aobj_context; $this->fromdeg = trim($aobj_context->mobj_data["degree_code"]); $this->db = trim($aobj_context->mobj_data["db"]); $this->fromcoll = $_SESSION['collcode']; //$this->strAprtype = trim($aobj_context->mobj_data["appstatus"]); $query = "select fintake from colldeg where FDEGREE = '{$this->fromdeg}' and fcollcode = '{$this->fromcoll}'"; $res = $this->aobj_context->mobj_db->GetRow($query); $this->fintake = $res['fintake']; $fintake = $res['fintake']; } public function Header($head) { // get the current page break margin $bMargin = $this->getBreakMargin(); // get current auto-page-break mode $auto_page_break = $this->AutoPageBreak; // disable auto-page-break $this->SetAutoPageBreak(false, 0); // set bacground image if($this->aobj_context->first !='strue') $this->SetMargins(10,46,20,true); else $this->SetMargins(10,30,20,true); $this->SetFillColor(248, 248 ,255); $this->SetFont('Times','',10); //var_dump($img_path); $get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE, FUNIVADD1 as 'state', pdf_logo_path, ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control"; $lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name); $this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME']; $this->s_state=$lobj_get_coll_name['state']; $this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path']; $this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ']; $this->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE']; $img_path = $this->aobj_context->main_src.'oasis/'.$this->db."/".$this->pdf_logo_path; //var_dump($img_path); //die(); if(file_exists($img_path)) { if($this->db == 'ru') { $img_path = $this->aobj_context->main_src.'oasis/'.$this->db."/img/rur_log_report.jpg"; //$this->Image($img_path,90,6,120,25); $this->Image($img_path,90,4,110); $this->Ln(15); } else $this->Image($img_path,10,6,20,20); } $img_path = $this->aobj_context->main_src."/img/logo2.jpg"; if(file_exists($img_path)) $this->Image($img_path,210,6,20,20); $this->SetFont('helvetica','B',17); $this->Ln(2); if($this->db != 'ru') $this->Cell(250,4,$this->FUNIVNAME,0,1,'C'); $query = "select concat(fdegree,' - ',fdescpn) as deg from degree where fdegree = '{$this->fromdeg}' and fexamno = 'A'"; $results1 = $this->aobj_context->mobj_db->GetRow($query); $query = "select concat(fcollcode,' - ',fcollname) as coll from college where fcollcode = '{$this->fromcoll}'"; $results2 = $this->aobj_context->mobj_db->GetRow($query); if($this->db == 'ru') { $this->SetFont('Times','B',14); $this->Ln(8); $this->Cell(0,4,'Degree - '.$results1['deg'],0,1,'C'); $this->Cell(0,4,'College - '.$results2['coll'],0,1,'C'); $approve_type = $this->strAprtype == All? 'All': $this->strAprtype; $this->Cell(0,4,'Admission Register',0,1,'C'); //$this->Ln(5); }else { $this->SetFont('Times','B',11); $this->Cell(250,4,'Degree - '.$results1['deg'],0,1,'C'); $this->Cell(250,4,'College - '.$results2['coll'],0,1,'C'); $approve_type = $this->strAprtype == All? 'All': $this->strAprtype; $this->Cell(0,4,'Admission Register',0,1,'C'); } $this->Ln(2); $this->SetFont('Times','B',13); //$this->Cell(0,6,'Approved Intake : '.$this->fintake,"0","1",L); //$this->Ln(2); $this->SetFont('Times','B',10); // if($this->aobj_context->first !='strue') // { // $table_head = '<table cellpadding="2" cellspacing="0" border="0.5"> // <tr nobr="true"><th width="30" align="center"><b>Sl. No.</b></th> // <th width="60" align="center"><b>Appl. No.</b></th> // <th width="40" align="center"><b>Deg. <br>Code</b></th> // <th width="140" align="center"><b>Student Name</b></th> // <th width="60" align="center"><b>DOB</b></th> // <th width="35" align="center"><b>Caste</b></th> // <th width="80" align="center"><b>Father Name</b></th> // <th width="80" align="center"><b>Mother Name</b></th> // <th width="180" align="center"><b>Name of The Board</b></th> // <th width="50" align="center"><b>Fees to <br>be Paid</b></th> // </tr> // </table>'; // // <th width="50" align="center"><b>Late Fees Fine</b></th> // $this->ln(4); // $this->writeHTML($table_head, false, true, false, false, 'C'); // } // restore auto-page-break status $this->SetAutoPageBreak($auto_page_break, $bMargin); // set the starting point for the page content } public function Footer() { $this->SetY(-15); $this->SetFont('helvetica', 'I', 8); $this->Cell(50, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L'); $this->Cell(50, 10,'Date : ' .$this->aobj_context->current_date, 0, 0, 'L'); $this->Cell(170, 10,'Page ' .$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, 1, 'R'); } } class AddmissionApproveList { function DefaultConstructor($aobj_context) { $this->aobj_context=$aobj_context; //$this->pdf= new FPDF(); $this->ip=$_SERVER["REMOTE_ADDR"]; $get_date="select now() as now_date,funivname,pdf_logo_path from control"; $obj=$this->aobj_context->mobj_db->GetRow($get_date); $this->aobj_context->main_src = realpath(__DIR__ . '/../..'); $this->aobj_context->main_src = $this->aobj_context->main_src.'/'; $this->aobj_context->current_date = $obj['now_date']; $this->current_date = $obj['now_date']; $this->univ = $obj['funivname']; $this->pdf_logo_path = $obj['pdf_logo_path']; $this->pdf= new MYPDF('L'); $this->pdf->setData($aobj_context); $this->fromdeg = trim($aobj_context->mobj_data["degree_code"]); } function formcolldata() { $get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE, FUNIVADD1 as 'state', pdf_logo_path, ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control"; $lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name); $this->FUNIVNAME=$lobj_get_coll_name['FUNIVNAME']; $this->s_state=$lobj_get_coll_name['state']; $this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path']; $this->FEXAMAPPREQ=$lobj_get_coll_name['FEXAMAPPREQ']; $this->FUNIVCODE=$lobj_get_coll_name['FUNIVCODE']; } function appData() { $this->fromcoll = $_SESSION['collcode']; $get_app_query = "select fappno, ifnull( DATE_FORMAT(flogdate, '%d/%m/%Y'),'02/03/2018') as applied_date, fname, DATE_FORMAT(fdob,'%d/%m/%Y') as dob, FCATBIRTH, fcollcode, dg.fdegree as degree, REPLACE(dg.fexamname, 'SEMESTER', 'SEM') as fexamname, sa.TOTAL_FEE as fadmfee, ifnull(sa.fapprstatus, 'PENDING') as status, ifnull(sa.FLOGNAME, '') as user, ifnull(DATE_FORMAT(FAPPRDATE, '%d/%m/%Y'),'') as ack_date, ifnull(fapprusername,'') as appuser, sa.FLATADMFEE as ffeetobepaid, sa.funivname,sa.FFATNAME,sa.FMOTNAME from studadm sa inner join degree dg on sa.fdegree = dg.fdegree and sa.fexamno = dg.fexamno left join masboard m on m.fboardname = sa.funivname where sa.fdegree = '{$this->fromdeg}' and sa.fcollcode = '{$this->fromcoll}' and sa.fexamno = 'A' and ifnull(sa.fdeleted,'') <> 'T' order by sa.fdegree desc, fcollcode desc,flogdate"; //var_dump($get_app_query); $this->results =$this->aobj_context->mobj_db->GetAll($get_app_query); $query = "select fintake from colldeg where FDEGREE = '{$this->fromdeg}' and fcollcode = '{$this->fromcoll}'"; $res = $this->aobj_context->mobj_db->GetRow($query); $this->fintake = $res['fintake']; $query = "select FCATBIRTH,sum(if(fgender = 'Male',1,0)) as male, sum(if(fgender = 'Female',1,0)) as female, sum(TOTAL_FEE) as fee from studadm where fdegree = '{$this->fromdeg}' and fcollcode = '{$this->fromcoll}' and ifnull(fdeleted,'') <> 'T' group by fdegree,fcollcode,FCATBIRTH order by fdegree,fcollcode,FCATBIRTH"; $this->ressum =$this->aobj_context->mobj_db->GetAll($query); } function writeApproveList($aobj_context) { //$this->printHeaders(); $this->db = trim($aobj_context->mobj_data["db"]); //var_dump($this->results); $pdf=$this->pdf; $pdf->SetMargins(10,25,20,false); $pdf->AddPage("L"); $pdf->SetMargins(10,25,20,false); $this->head = true; $pdf->SetFont('courier','',9); //var_dump($this->db); //if($this->db == 'ru') //$pdf->Ln(); $i = 1; $table_body = '<table cellpadding="2" cellspacing="0" border="0.5"> <thead> <tr nobr="true"><th width="30" align="center"><b>Sl. No.</b></th> <th width="60" align="center"><b>Appl. No.</b></th> <th width="40" align="center"><b>Deg. <br>Code</b></th> <th width="140" align="center"><b>Student Name</b></th> <th width="60" align="center"><b>DOB</b></th> <th width="35" align="center"><b>Caste</b></th> <th width="80" align="center"><b>Father Name</b></th> <th width="80" align="center"><b>Mother Name</b></th> <th width="180" align="center"><b>Name of The Board</b></th> <th width="50" align="center"><b>Fees to <br>be Paid</b></th> </tr> </thead> '; //$table_body = ''; $first = 1; $amtpaid = 0; $amttobepaid = 0; $j = 0; foreach ($this->results as $key => $value) { $table_body .= '<tr nobr="true"> <td width="30" align="center">'.$i.'</td> <td width="60">'.$value['fappno'].'</td> <td width="40">'.$value['degree'].'</td> <td width="140" align="left">'.$value['fname'].'</td> <td width="60">'.$value['dob'].'</td> <td width="35" align="left">'.$value['FCATBIRTH'].'</td> <td width="80" align="left">'.$value['FFATNAME'].'</td> <td width="80" align="left">'.$value['FMOTNAME'].'</td> <td width="180" align="left">'.$value['funivname'].'</td> <td width="50" align="right">'.$value['fadmfee'].'</td> </tr>'; // <td width="50" align="right">'.$value['ffeetobepaid'].'</td> $i++; // if($i % 20 == 0) // { // // var_dump($i ); // $table_body .= '</table>'; // $pdf->writeHTML($head.$table_body, false, true, false, false, 'C'); // $table_body = ''; // } $j +=1; $amttobepaid += $value['ffeetobepaid']; $amtpaid += $value['fadmfee']; //var_dump($amttobepaid); } $table_body .= '<tr nobr="true"> <td width="30" align="center"></td> <td width="60"></td> <td width="40"></td> <td width="140" align="left"></td> <td width="60"></td> <td width="35" align="left"></td> <td width="80" align="left"></td> <td width="80" align="left"></td> <td width="180" align="right"><b>Total</b></td> <td width="50" align="right">'.$amtpaid.'</td> </tr>'; // <td width="50" align="right"></td> $table_body .= '</table>'; //var_dump($i); //if($i % 20 != 0) $pdf->writeHTML($table_body, true, true, false, false, 'C'); $difamt = $amttobepaid - $amtpaid; if($difamt < 0) $difamt = 0; //var_dump($this->fintake); $pdf->SetFont('courier','B',10); $this->first = "strue"; $aobj_context->first = 'strue'; $pdf->SetMargins(10,20,20,false); $pdf->AddPage("L"); // var_dump('hii'); $pdf->SetMargins(10,20,20,false); //$pdf->cell(0,6,"Admission Summary",0,1,"C"); $pdf->ln(2); if($this->db == 'ru') $pdf->Ln(20); $pdf->cell(30,6,"Sl. No.",1,0,"C"); $pdf->cell(50,6,"Category",1,0,"C"); $pdf->cell(50,6,"Male Cnt",1,0,"C"); $pdf->cell(50,6,"Female Cnt",1,0,"C"); $pdf->cell(30,6,"Tot. Cnt",1,0,"C"); $pdf->cell(30,6,"Fee Paid",1,1,"C"); //$pdf->cell(40,6,"Late Fee Fine",1,1,"C"); $x = 1; $male = 0; $female = 0; $tot = 0; $totfee = 0; foreach($this->ressum as $value) { $pdf->cell(30,6,$x,1,0,"C"); $pdf->cell(50,6,$value['FCATBIRTH'],1,0,"C"); $pdf->cell(50,6,$value['male'],1,0,"C"); $pdf->cell(50,6,$value['female'],1,0,"C"); $pdf->cell(30,6,$value['female']+$value['male'],1,0,"C"); $pdf->cell(30,6,$value['fee'],1,1,"C"); //$pdf->cell(40,6,"",1,1,"C"); $x++; $male += $value['male']; $female += $value['female']; $tot += $value['female']+$value['male']; $totfee += $value['fee']; } $pdf->cell(30,6,"","LTB",0,"C"); $pdf->cell(50,6,"Total",1,0,"C"); $pdf->cell(50,6,$male,1,0,"C"); $pdf->cell(50,6,$female,1,0,"C"); $pdf->cell(30,6,$tot,1,0,"C"); $pdf->cell(30,6,$totfee,1,1,"C"); //$pdf->cell(40,6,"",1,1,"C"); $pdf->ln(5); $pdf->SetFont('Times','B',12); $pdf->Cell(50, 6,'Approved Intake : '.$this->fintake, 0, 1, 'L'); $pdf->Cell(50, 6,'No of Student admitted : '.($i-1), 0, 1, 'L'); // $pdf->Cell(50, 6,'Total amount to be Paid : '.$amttobepaid, 0, 1, 'L'); $pdf->Cell(50, 6,'Total amount Paid : '.$amtpaid, 0, 1, 'L'); // $pdf->Cell(50, 6,'Difference : '.$difamt, 0, 1, 'L'); $pdf->ln(5); $pdf->MultiCell(0,5,"I here by declare that all the information furnished with regard to the students are true & correct to the best of my knowledge and belief, copy of the recognition order and affiliation order is enclosed.",0,"L"); $pdf->SetFont('Times','B',12); $pdf->ln(14); $pdf->Cell(20,4,"Date :",'0',0,'C'); $pdf->Cell(250,4,"Principal signature (with seal)",'0',1,'R'); $pdf->ln(12); $pdf->Cell(0, 6,'Signature of verifier', 0, 0, 'L'); $pdf->Cell(0, 6,'Signature of Approver', 0, 1, 'R'); } function SendOutput() { $this->pdf->Output("approve_list_{$this->current_date}.pdf","I"); } } function admlist($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj = new AddmissionApproveList(); $class_obj->DefaultConstructor($aobj_context); $class_obj->formcolldata(); $class_obj->appData(); $class_obj->writeApproveList($aobj_context); $class_obj->SendOutput(); } ?>
Close