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 | : 52.14.7.53
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 /
reva /
Report_details /
[ HOME SHELL ]
Name
Size
Permission
Action
output
[ DIR ]
drwxr-xr-x
DownloadExamAppFormApplication...
4.49
KB
-rwxr-xr-x
DownloadRvRtAckApplications.ph...
4.6
KB
-rwxr-xr-x
GenerateABMPReportQp.php
5.76
KB
-rw-r--r--
Genprpendsubcnt.php
6.44
KB
-rw-r--r--
PC_RV_Report.php
7.25
KB
-rw-r--r--
PracticalIndent.php
5.57
KB
-rw-r--r--
PrintChallanEntryDetails.php
8.27
KB
-rwxr-xr-x
RvRtApplicationReport.php
8.76
KB
-rwxr-xr-x
appear_list_center_qp_wise.php
8.84
KB
-rwxr-xr-x
appear_list_center_qp_wise_bf_...
8.76
KB
-rwxr-xr-x
appear_list_center_qp_wise_old...
5.42
KB
-rwxr-xr-x
appear_list_qp_wise.php
5.29
KB
-rwxr-xr-x
batch_wise_details.php
4.45
KB
-rwxr-xr-x
bundle_ack.php
12.84
KB
-rwxr-xr-x
bundle_rec_ack.php
5.68
KB
-rwxr-xr-x
categorywisereport.php
6.53
KB
-rw-rw-r--
code39.php
6.38
KB
-rwxr-xr-x
generatePostAdmissionTicket.ph...
25.49
KB
-rwxr-xr-x
generatePostAdmissionTicket_ol...
28.01
KB
-rwxr-xr-x
generatecoporeport_xl.php
21.17
KB
-rw-rw-r--
gerderwiseresultsheet.php
9.62
KB
-rw-rw-r--
getReportClassStud.php
6.03
KB
-rw-rw-r--
getiaabsentreport.php
6.8
KB
-rw-rw-r--
iaroomallotmantsummary.php
5.28
KB
-rwxr-xr-x
qptablenot_upd_report.php
6.56
KB
-rw-r--r--
qrcodeGeneratePostAdmissionTic...
24.6
KB
-rwxr-xr-x
reportAttClassCreate.php
5.14
KB
-rw-rw-r--
report_admission_details.php
26.8
KB
-rwxr-xr-x
report_admission_list.php
9.9
KB
-rwxr-xr-x
report_admission_list111.04.20...
6.67
KB
-rwxr-xr-x
report_admission_list30062012....
6.67
KB
-rwxr-xr-x
report_admission_list_wop.php
10.31
KB
-rwxr-xr-x
report_admission_ticket.php
32.43
KB
-rwxr-xr-x
report_admission_ticket0705201...
13.52
KB
-rwxr-xr-x
report_admission_ticket_011120...
27.16
KB
-rwxr-xr-x
report_admission_ticket_020420...
15.05
KB
-rwxr-xr-x
report_admission_ticket_111220...
15.04
KB
-rwxr-xr-x
report_admission_ticket_151220...
29.4
KB
-rwxr-xr-x
report_admission_ticket_291120...
13.75
KB
-rwxr-xr-x
report_admission_ticket_301020...
15.21
KB
-rwxr-xr-x
report_admission_ticket_before...
13.33
KB
-rwxr-xr-x
report_admission_ticket_kus.ph...
16.15
KB
-rwxr-xr-x
report_admission_ticket_org.ph...
26.02
KB
-rwxr-xr-x
report_attendance_summary.php
7.75
KB
-rwxr-xr-x
report_batch_wise_details.php
7.5
KB
-rwxr-xr-x
report_batch_worksheet_detail_...
10.33
KB
-rwxr-xr-x
report_batch_worksheet_details...
10.47
KB
-rwxr-xr-x
report_bundle_dispatch.php
11.37
KB
-rwxr-xr-x
report_bundle_dispatch_2605201...
7.93
KB
-rwxr-xr-x
report_bundle_dispatch_reva_21...
7.78
KB
-rwxr-xr-x
report_candidate_list.php
25.65
KB
-rwxr-xr-x
report_candidate_list_before_f...
25.19
KB
-rwxr-xr-x
report_candidate_list_before_s...
19.8
KB
-rwxr-xr-x
report_daliy_report.php
10.83
KB
-rwxr-xr-x
report_daliy_report_qp.php
19.29
KB
-rwxr-xr-x
report_daliy_report_qp_bf_tt.p...
18.53
KB
-rwxr-xr-x
report_daliy_report_qp_new.php
9.93
KB
-rwxr-xr-x
report_daliy_report_qp_old.php
12.09
KB
-rwxr-xr-x
report_daliy_report_qp_wait.ph...
9.9
KB
-rwxr-xr-x
report_degree_list.php
4.71
KB
-rwxr-xr-x
report_degree_list24042015.php
2.45
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_ext_marks_entry_student...
5.56
KB
-rwxr-xr-x
report_ext_marks_entry_subwise...
10.53
KB
-rwxr-xr-x
report_ia_ra_invigilator_dairy...
20.72
KB
-rwxr-xr-x
report_iamarks_pending.php
5.74
KB
-rwxr-xr-x
report_marks_deviation_report....
5.38
KB
-rwxr-xr-x
report_marks_elementwise.php
4.35
KB
-rwxr-xr-x
report_marks_elementwise091220...
3.87
KB
-rwxr-xr-x
report_marks_elementwise220920...
4.67
KB
-rwxr-xr-x
report_marks_entry_student_lis...
5.58
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.2
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.13
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.2
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.02
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
12.03
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.51
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.13
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.2
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
9.16
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
10.05
KB
-rwxr-xr-x
report_online_eam.php
10.97
KB
-rwxr-xr-x
report_practical_marks_details...
13.35
KB
-rwxr-xr-x
report_practical_marks_details...
14.08
KB
-rwxr-xr-x
report_qpcount_univ.php
7.8
KB
-rwxr-xr-x
report_ra_exl_report.php
5.61
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
22.42
KB
-rw-r--r--
report_ra_invigilator_dairy_15...
20.73
KB
-rwxr-xr-x
report_ra_invigilator_dairy_bc...
22.39
KB
-rwxr-xr-x
report_ra_invigilator_dairy_bf...
20.05
KB
-rwxr-xr-x
report_ra_invigilator_dairy_ol...
21.5
KB
-rwxr-xr-x
report_ra_invigilators_dairy.p...
7.98
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
7.38
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
7.09
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
7
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
17.09
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
26.16
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
16.84
KB
-rwxr-xr-x
report_ra_roomwise_register_no...
16.79
KB
-rwxr-xr-x
report_revaluation.php
6.42
KB
-rwxr-xr-x
report_sectionwiselist.php
4.56
KB
-rwxr-xr-x
report_subject_admcl_list.php
3.48
KB
-rwxr-xr-x
report_subject_general_list.ph...
4.12
KB
-rwxr-xr-x
resultsheet.php
9.38
KB
-rw-rw-r--
revaQpindentCsv.php
7.94
KB
-rw-rw-r--
revaluation.php
15.65
KB
-rwxr-xr-x
roomallotmantsummary.php
5.69
KB
-rwxr-xr-x
roomallotmantsummary_bf_tt.php
5.73
KB
-rwxr-xr-x
roomwise_register_nos_list.php
29.61
KB
-rwxr-xr-x
roomwise_register_nos_list_bf_...
27.72
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
stringspliter.php
693
B
-rwxr-xr-x
studentreport.php
14.53
KB
-rw-rw-r--
subject_wise_student_list.php
6.2
KB
-rwxr-xr-x
subjectwise_invigilator_dairy....
10.29
KB
-rwxr-xr-x
subjwisepasspercentage.php
11.88
KB
-rw-rw-r--
teacher_report.php
6.57
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : report_daliy_report_qp_bf_tt.php
<?php $main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7); $pdf_writer_class =$main_src."/tarka_pdf_latest/fpdf.php"; require_once($pdf_writer_class); ini_set('max_execution_time', 300); class DownloadExamAppFormApplications extends FPDF { function DefaultConstructor($aobj_context) { include_once($aobj_context->main_src."/src/format.php"); $this->aobj_context=$aobj_context; $this->pdf= new FPDF(); $this->pdf=$this; session_start(); $this->ip=$_SERVER["REMOTE_ADDR"]; $this->collcode=$_SESSION['collcode']; $this->college_code=$_SESSION['collcode']; $get_date="select date_add(date_add(now(),INTERVAL 13 hour),interval 30 minute) as now_date"; $obj=$this->aobj_context->mobj_db->GetRow($get_date); $this->current_date=$obj[now_date]; $this->qp_code_start = substr("0000000000".$aobj_context->mobj_data["qp_code_start"],-5); $this->qp_code_end = substr("ZZZZZZZZZZ".$aobj_context->mobj_data["qp_code_end"],-5); $this->date_start = substr("0000000000".db_date_Format($aobj_context->mobj_data["Date_start"]),-10); $this->date_end = substr("ZZZZZZZZZZ".db_date_Format($aobj_context->mobj_data["Date_end"]),-10); $this->session = stripslashes($aobj_context->mobj_data["session"]); if($this->session=="PM") $this->session="'PM'"; if($this->session=="AM") $this->session="'AM'"; } function Header() { $this->pdf->SetMargins(6,12,10); $img_path=$this->aobj_context->main_src.$this->pdf_logo_path; if(!empty($this->pdf_logo_path) && file_exists($img_path)) { $this->pdf->Image($img_path,80,3,50,30); } $this->pdf->ln(15); // $this->pdf->SetFont('Times','B',15); // $this->pdf->cell(0,4,"".$this->FUNIVNAME,"0",1,"C"); // $this->pdf->SetFont('Times','',8); // $this->pdf->cell(0,4, $this->s_state,"0",0,"C"); if($this->session == "'AM'") $session = 'Morning'; if($this->session == "'PM'") $session = 'Afternoon '; $this->pdf->SetFont('Times','',10); $this->pdf->Cell(-20,4,"Page {$this->pdf->PageNo()}/{nb}",0,1,'C'); $this->pdf->SetFont('Times','B',14); $this->pdf->cell(0,5, "Block : ".$this->FCOLLCODE." - ".$this->FCOLLNAME,"0",1,"C"); $this->pdf->SetFont('Times','B',12); $this->pdf->ln(1); $this->pdf->SetFont('Times','B',14); $this->pdf->cell(0,5, "FORM - A ","0",1,"C"); $this->pdf->SetFont('Times','B',12); $this->pdf->Cell(0,5,"QP Code : {$this->qp_code} Subject Name : {$this->qp_name}","0",1,"C"); $this->pdf->ln(1); //Done by Mahesh $get_qp_data = "SELECT distinct DATE_FORMAT(s.FDOE,'%d/%m/%Y') AS FDOE,s.FSESSION, r.fdescpn FROM subject_2A s left outer join reason r on s.fsession = r.freasoncd WHERE s.FQPCODE='{$this->qp_code}' and ifnull(fdoe,'') <> '0000-00-00'"; $obj_get_qp_data=$this->aobj_context->mobj_db->GetRow($get_qp_data); //$this->exam_date="Exam Date : {$obj_get_qp_data['FDOE']} Time : {$obj_get_qp_data['fdescpn']} "; //Commented by Mahesh $this->pdf->Cell(0,5,"Exam Date : {$obj_get_qp_data['FDOE']} Time : {$obj_get_qp_data['fdescpn']} ","0",1,"C"); //$this->pdf->Cell(0,5,"Session : {$session}","0",1,"C"); $this->pdf->ln(1); $new_y=$this->pdf->GetY(); $this->pdf->Line(12,$new_y, 203,$new_y); $this->pdf->Line(12,$new_y+.5, 203,$new_y+.5); //$this->pdf->ln(4); } function Footer() { $this->SetY(-25); $this->pdf->SetFont('Times','B',8); //$this->Cell(140,6,'Entered : IP Address : '.$this->ip_address." Date ".$this->created_date,'0',0,'L'); $new_y=$this->pdf->GetY(); $this->pdf->Line(12,$new_y, 203,$new_y); $this->pdf->Line(12,$new_y+.5, 203,$new_y+.5); $this->pdf->Ln(2); //$this->Cell(140,6,' Printed : IP Address : '.$this->ip." Date ".$this->current_date,'0',0,'L'); //$this->Cell(50,6,'Page '.$this->PageNo().' of {nb}',0,1,'R'); } function formcolldata() { $get_coll_name="select FUNIVNAME as 'FUNIVNAME', FUNIVADD1 as 'state', pdf_logo_path 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->f_year=$lobj_get_coll_name['f_year']; $this->pdf_logo_path=$lobj_get_coll_name['pdf_logo_path']; $get_coll_name="SELECT FCOLLCODE,FCOLLNAME FROM college where FCOLLCODE='{$this->collcode}'"; $lobj_get_coll_name=$this->aobj_context->mobj_db->GetRow($get_coll_name); $this->FCOLLCODE=$lobj_get_coll_name['FCOLLCODE']; $this->FCOLLNAME=$lobj_get_coll_name['FCOLLNAME']; } function GetAllSubjects() { //print_r($get_fcsubcode_from_both_table);die(); $query1 = "SET SESSION group_concat_max_len=100000"; $results1 = $this->aobj_context->mobj_db->Execute($query1); $get_daliy_data= " select '9999' as fbatch, date_format(cd.FDOE,'%d/%m/%Y') as doe_name,cd.FQPCODE as FQPCODE,cd.FSESSION, concat(sub.FSUBNAME, space(2), '( ',sub.fsubshort,' )') as subject_desp, FNOBUNDLE,FTOTSCRIPT from colldesp cd inner join subject_2A sub on sub.FQPCODE=cd.FQPCODE where cd.FCOLLCODE='{$this->college_code}' and cd.FQPCODE>='{$this->qp_code_start}' and cd.FQPCODE<='{$this->qp_code_end}' and cd.FDOE>='{$this->date_start}' and cd.FDOE<='{$this->date_end}' and cd.FSESSION in({$this->session}) and ifnull(cd.FDELETED,'') <> 'T' and cd.fcollcode = 'xxxxdddddf' group by cd.FDOE,cd.FQPCODE,cd.FSESSION order by cd.FDOE, cd.FSESSION, cd.fqpcode"; //var_dump($get_daliy_data); $lobj_get_daliy_data = $this->aobj_context->mobj_db->GetAll($get_daliy_data); //$result=mysql_query("set group_concat_max_len=10000"); $session = $this->session; if($this->session == "'AM'") { $this->session = "m%"; } if($this->session == "'PM'") { $this->session = "n%"; } /*$get_daliy_present_data= " select st.fbatch,sub.FQPCODE,date_format(sub.FDOE,'%d/%m/%Y') as doe_name, sub.FSESSION, 'QPP' as type, concat(sub.FSUBNAME, space(2), '( ',sub.FSSUBNAME,' )') as subject_desp, GROUP_CONCAT(distinct a.FREGNO order by a.fregno SEPARATOR ' ') as FREGNO, COUNT(DISTINCT a.FREGNO) AS reg_cnt from canddet a inner join subject sub on sub.FDEGREE=a.FDEGREE and sub.fexamno = a.fexamno and sub.fsubcode = a.fsubcode and ifnull(sub.ftheory,'') = 'T' and ifnull(sub.fqpcode,'') <> '' inner join student st on a.fdegree = st.fdegree and a.FCOLLCODE = st.fcollcode and a.FREGNO = st.fregno where sub.FDOE>='{$this->date_start}' and sub.FDOE<='{$this->date_end}' and sub.FQPCODE>='{$this->qp_code_start}' and sub.FQPCODE<='{$this->qp_code_end}' and sub.FSESSION in({$this->session}) and a.FCOLLCODE='{$this->college_code}' and ifnull(a.FDELETED,'') <> 'T' and a.FCOLLCODE='{$this->college_code}' and a.fpresent = 'P' and concat(a.fcollcode, a.fregno, sub.fqpcode) not in(select concat(fcollcode, fregno, fqpcode) from absent where FDOE>='{$this->date_start}' and sub.FDOE<='{$this->date_end}' and FQPCODE>='{$this->qp_code_start}' and sub.FQPCODE<='{$this->qp_code_end}' and FCOLLCODE='{$this->college_code}') group by sub.FDOE, sub.FQPCODE, sub.FSESSION,st.fbatch order by date_format(sub.FDOE,'%d/%m/%Y'), sub.FSESSION, sub.fqpcode,st.fbatch" ;*/ $get_daliy_present_data= "select st.fbatch, deg.fexamname, sub.FQPCODE, date_format(sub.FDOE, '%d/%m/%Y') as doe_name, sub.FSESSION, 'QPP' as type, concat(sub.FSUBNAME, space(2), '( ', sub.FSSUBNAME, ' )' ) as subject_desp, GROUP_CONCAT(distinct a.FREGNO order by a.fregno SEPARATOR ' ' ) as FREGNO, COUNT(DISTINCT a.FREGNO) AS reg_cnt from canddet_2A a inner join subject_2A sub on sub.FDEGREE = a.FDEGREE and sub.fexamno = a.fexamno and sub.fsubcode = a.fsubcode and ifnull(sub.ftheory, '') = 'T' and ifnull(sub.fqpcode, '') <> '' inner join degree deg on sub.fdegree = deg.fdegree and sub.fexamno = deg.fexamno inner join student st on a.fdegree = st.fdegree and a.FREGNO = st.fregno inner join candsum_2A cs on a.fdegree = cs.fdegree and a.fcollcode = cs.fcollcode and a.fregno = cs.FREGNO left outer join absent on cs.fcntrcode = absent.fcollcode and a.fregno = absent.fregno and sub.fqpcode = absent.fqpcode where sub.FDOE >= '{$this->date_start}' and sub.FDOE <= '{$this->date_end}' and sub.FQPCODE >= '{$this->qp_code_start}' and sub.FQPCODE <= '{$this->qp_code_end}' and sub.FSESSION like '{$this->session}' and cs.fcntrcode = '{$this->college_code}' and ifnull(a.FDELETED, '') <> 'T' and a.fpresent = 'P' and absent.fregno is null group by sub.FDOE, sub.FQPCODE, sub.FSESSION order by sub.FDOE, sub.FSESSION, sub.fqpcode"; //var_dump($get_daliy_present_data); $lobj_get_daliy_present_data = $this->aobj_context->mobj_db->GetAll($get_daliy_present_data); $get_daliy_absent_data= " select st.fbatch, deg.fexamname, a.FQPCODE,date_format(a.FDOE,'%d/%m/%Y') as doe_name,a.FSESSION,upper(a.FABSTYPE) as type, concat(sub.FSUBNAME, space(2), '( ',sub.FSSUBNAME,' )') as subject_desp, GROUP_CONCAT(distinct a.FREGNO order by a.fregno SEPARATOR ' ') as FREGNO,COUNT(DISTINCT a.FREGNO) AS reg_cnt from absent a inner join subject_2A sub on sub.FQPCODE=a.FQPCODE and left(a.FABSTYPE,2)='QP' inner join degree deg on sub.fdegree = deg.fdegree and sub.fexamno = deg.fexamno inner join student st on a.FREGNO = st.fregno where a.FDOE>='{$this->date_start}' and a.FDOE<='{$this->date_end}' and a.FQPCODE>='{$this->qp_code_start}' and a.FQPCODE<='{$this->qp_code_end}' and a.FSESSION in({$session}) and a.FCOLLCODE='{$this->college_code}' and ifnull(a.FDELETED,'') <> 'T' and a.FCOLLCODE='{$this->college_code}' group by a.FDOE,a.FQPCODE,a.FABSTYPE,a.FSESSION order by a.FDOE, a.FSESSION, a.fqpcode, a.FABSTYPE"; //var_dump($get_daliy_absent_data); $lobj_get_daliy_absent_data = $this->aobj_context->mobj_db->GetAll($get_daliy_absent_data); //echo "<pre>".$get_daliy_absent_data;die(); $this->unique_page_arr=array(); $this->qp_code_arr=array(); // foreach($lobj_get_daliy_absent_data as $ak=>$av) // { // if($av['type']=='QPA') // { // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['det']['QPA']['cnt']=$av['reg_cnt']; // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['det']['QPA']['FREGNO']=$av['FREGNO']; // } // if($av['type']=='QPM') // { // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['det']['QPM']['cnt']=$av['reg_cnt']; // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['det']['QPM']['FREGNO']=$av['FREGNO']; // } // $this->qp_code_arr[$av['FQPCODE']]=$av['subject_desp']; // } // foreach($lobj_get_daliy_data as $ak=>$av) // { // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['bund']['FNOBUNDLE']=$av['FNOBUNDLE']; // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['bund']['FTOTSCRIPT']=$av['FTOTSCRIPT']; // $this->qp_code_arr[$av['FQPCODE']]=$av['subject_desp']; // } // foreach($lobj_get_daliy_present_data as $ak=>$av) // { // //var_dump($av['fbatch']); // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['det']['QPP']['cnt']=$av['reg_cnt']; // //var_dump($av['fbatch']); // $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION'].', Semester : '.$av['fexamname'].', Batch : '.$av['fbatch']]['det']['QPP']['FREGNO']=$av['FREGNO']; // $this->qp_code_arr[$av['FQPCODE']]=$av['subject_desp']; // } foreach($lobj_get_daliy_absent_data as $ak=>$av) { if($av['type']=='QPA') { $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['det']['QPA']['cnt']=$av['reg_cnt']; $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['det']['QPA']['FREGNO']=$av['FREGNO']; } if($av['type']=='QPM') { $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['det']['QPM']['cnt']=$av['reg_cnt']; $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['det']['QPM']['FREGNO']=$av['FREGNO']; } $this->qp_code_arr[$av['FQPCODE']]=$av['subject_desp']; } foreach($lobj_get_daliy_data as $ak=>$av) { $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['bund']['FNOBUNDLE']=$av['FNOBUNDLE']; $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['bund']['FTOTSCRIPT']=$av['FTOTSCRIPT']; $this->qp_code_arr[$av['FQPCODE']]=$av['subject_desp']; } foreach($lobj_get_daliy_present_data as $ak=>$av) { $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['det']['QPP']['cnt']=$av['reg_cnt']; $this->unique_page_arr[$av['doe_name']][$av['FQPCODE']][$av['FSESSION']]['det']['QPP']['FREGNO']=$av['FREGNO']; $this->qp_code_arr[$av['FQPCODE']]=$av['subject_desp']; } // echo "<pre>"; // print_r($this->unique_page_arr);die(); } function formData() { $query1 = "SET SESSION group_concat_max_len=100000"; $results1 = $this->aobj_context->mobj_db->Execute($query1); //var_dump($this->date_start); if($this->session == "'AM'") $session ="AM"; else $session ="PM"; if($this->session == "'AM'") { $this->session = "m%"; } if($this->session == "'PM'") { $this->session = "n%"; } $query = "select p.fqpcode,p.fsubname, pcount as tcount, ifnull(abcount,0) as abcount, prregno, abregno, mpregno, ifnull(mpcount,0) as mpcount, (pcount-ifnull(abcount,0)-ifnull(mpcount,0)) as prcount from (select fqpcode, fsubname, count(fregno) as pcount from (select s.fqpcode, s.fsubname, cd.fregno from canddet_2A cd inner join candsum_2A cs on cd.fregno = cs.fregno and cd.fdegree = cs.fdegree and cd.fcollcode = cs.fcollcode inner join subject_2A s on s.fdegree = cd.fdegree and s.fexamno = cd.fexamno and s.fsubcode = cd.fsubcode and ifnull(s.ftheory, '') = 'T' and ifnull(s.fintass,'') = 'F' and ifnull(cd.fhallno,'') <> '' where ifnull(fpresent,'') = 'P' and ifnull(fpassmth,'') = '' and ifnull(s.fdoe, '0000-00-00') = '{$this->date_start}' and s.FSESSION like '{$this->session}' and cs.fcntrcode = '{$this->college_code}') m group by fqpcode) p left join (select fqpcode, fsubname, group_concat(fregno order by fregno) as prregno from (select s.fqpcode, s.fsubname, cd.fregno from canddet_2A cd inner join candsum_2A cs on cd.fregno = cs.fregno and cd.fdegree = cs.fdegree and cd.fcollcode = cs.fcollcode inner join subject_2A s on s.fdegree = cd.fdegree and s.fexamno = cd.fexamno and s.fsubcode = cd.fsubcode and ifnull(s.ftheory, '') = 'T' and ifnull(s.fintass,'') = 'F' left join absent z on cs.fregno = z.fregno and cs.fcntrcode = z.fcollcode and z.fqpcode = s.fqpcode where ifnull(fpresent,'') = 'P' and ifnull(fpassmth,'') = '' and ifnull(z.fregno,'') = '' and ifnull(cd.fhallno,'') <> '' and cs.fcntrcode = '{$this->college_code}' and ifnull(s.fdoe, '0000-00-00') = '{$this->date_start}' and s.FSESSION like '{$this->session}') m group by fqpcode) x on p.fqpcode = x.fqpcode left join (select a.fqpcode, sum(if(fabstype = 'QpA', 1, 0))as abcount, sum(if(fabstype = 'QpM', 1, 0))as mpcount, group_concat(if(fabstype = 'QpA', a.fregno, null)) as abregno, group_concat(if(fabstype = 'QpM', a.fregno, null)) as mpregno from absent a where a.fregno <> 'nil' and a.fregno <> '0' and date_format(a.fdoe,'%Y-%m-%d') = '{$this->date_start}' and a.FSESSION = '{$session}' and a.fcollcode = '{$this->college_code}' group by fqpcode) a on p.fqpcode = a.fqpcode order by pcount desc"; //var_dump($query); $lobj_get_daliy_absent_data = $this->aobj_context->mobj_db->GetAll($query); foreach($lobj_get_daliy_absent_data as $date_k=>$date_v) { $this->qp_code = $date_v['fqpcode']; $this->qp_name = $date_v['fsubname']; $this->FDOE=$sessv['FDOE']; $this->pdf->AddPage(); $this->pdf->SetFont('Times','',10); //total_present $this->pdf->ln(2); $chnk_cnt=6; $this->pdf->Cell(15,6,'','0',0,'L'); $this->pdf->SetFont('Times','B',10); $this->pdf->Cell(80,6,'Total Present','1',0,'L'); $this->pdf->Cell(95,6,$date_v['prcount'],'1',1,'C'); $this->pdf->Cell(15,6,'','R',0,'L'); $this->pdf->SetFont('Courier','',10); $this->pdf->MultiCell(175,$chnk_cnt,$date_v['prregno'],1,"L"); //total_abs $this->pdf->ln(2); $chnk_cnt=6; $this->pdf->Cell(15,6,'','0',0,'L'); $this->pdf->SetFont('Times','B',10); $this->pdf->Cell(80,6,'Total Absent','1',0,'L'); $this->pdf->Cell(95,6,$date_v['abcount'],'1',1,'C'); $this->pdf->Cell(15,6,'','R',0,'L'); $this->pdf->SetFont('Courier','',10); $this->pdf->MultiCell(175,$chnk_cnt,$date_v['abregno'],1,"L"); //total_abs $this->pdf->ln(2); $chnk_cnt=6; $this->pdf->Cell(15,6,'','0',0,'L'); $this->pdf->SetFont('Times','B',10); $this->pdf->Cell(80,6,'Total Malpractice','1',0,'L'); $this->pdf->Cell(95,6,$date_v['mpcount'],'1',1,'C'); $this->pdf->Cell(15,6,'','R',0,'L'); $this->pdf->SetFont('Courier','',10); $this->pdf->MultiCell(175,$chnk_cnt,$date_v['mpregno'],1,"L"); $this->SetY(-65); $new_y=$this->pdf->GetY(); $this->pdf->Line(12,$new_y, 203,$new_y); $this->pdf->SetFont('Times','B',10); $this->pdf->Ln(10); $this->pdf->Cell(180,6,'Signature of Chief Superintendent','',0,'R'); } } function SendOutput() { $this->pdf->Output("daily_report.pdf","D"); } } function generateDaliyReportQp($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj=new DownloadExamAppFormApplications(); $class_obj->AliasNbPages(); $class_obj->DefaultConstructor($aobj_context); $class_obj->formcolldata(); //$class_obj->GetAllSubjects(); $class_obj->formData(); $class_obj->SendOutput(); } ?>
Close