One Hat Cyber Team
Your IP :
172.16.0.254
Server IP :
58.26.163.33
Server :
Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64
Server Software :
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25
PHP Version :
7.3.25
Buat File
|
Buat Folder
Eksekusi
Dir :
C:
/
xampp7
/
htdocs
/
edgpens
/
reports
/
View File Name :
application_1.php
<?php $combx1 = ""; if(!empty($period)){ if($period=='year'){ $combx1 .= " AND YEAR(a.tarikhApply) = ? "; $param_data['p1'] = $year; } if($period=='month'){ $combx1 .= " AND DATE_FORMAT(a.tarikhApply,'%m-%Y') = ? "; $param_data['p2'] = $month; } if($period=='week'){ $combx1 .= " AND (date(a.tarikhApply) BETWEEN STR_TO_DATE(?,'%d-%m-%Y') and STR_TO_DATE(?,'%d-%m-%Y')) "; $param_data['p3'] = $sdate; $param_data['p4'] = $edate; } if($period == 'year') $report_name = "Yearly Report : {$year}"; else if($period == 'month') $report_name = "Monthly Report : {$month}"; else if($period == 'week') $report_name = "Weekly Report : {$sdate} - {$edate}"; }else{ $combx1 .= " AND YEAR(a.tarikhApply) = ? "; $param_data['p1'] = date('Y'); $report_name = "Yearly Report : ".date('Y'); } $sqlx = " SELECT sum(IF(a.flagApproveMFSO='Y' AND a.commentsMFSO != '-bypass-',1,0)) mfso_app, sum(IF(a.flagApproveMFSO='T' AND a.commentsMFSO != '-bypass-',1,0)) mfso_dis, sum(IF(a.flagApproveMFSO='N' AND a.commentsMFSO != '-bypass-',1,0)) mfso_pen, sum(IF(a.commentsMFSO != '-bypass-',1,0)) mfso_tot, sum(IF(a.flagApproveMTSO='Y',1,0)) mtso_app, sum(IF(a.flagApproveMTSO='T',1,0)) mtso_dis, sum(IF(a.flagApproveMTSO='N',1,0)) mtso_pen, sum(1) mfso_tot, sum(IF(a.flagApproveDG='Y' AND a.flagDG = 'Y',1,0)) dg_app, sum(IF(a.flagApproveDG='T' AND a.flagDG = 'Y',1,0)) dg_dis, sum(IF(a.flagApproveDG='N' AND a.flagDG = 'Y',1,0)) dg_pen, sum(IF(a.flagDG = 'Y',1,0)) dg_tot FROM permohonan_main a WHERE 1=1 {$combx1} "; $result2 = mysqli_prepare_all($sqlx,$param_type = "auto",$param_data); $rows_app = $result2->num_rows; $aa = $result2->fetch_assoc(); ?> <h4><b>Application Approval - <?php echo $report_name; ?></b></h4> <hr> <?php if(empty($report) || $report=='1'){?> <?php echo "<h3 style='color:#454e'><strong><i class='gi gi-pencil'></i> <span style='border-bottom:5px double #ccc'>MFSO</span></strong></h3>"; ?> <table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete"> <thead> <tr> <th class="text-center no_sorting" style="width: 40px !important;width: 5%">No.</th> <th class="text-left" style="width: 75%">Application</th> <th class="text-center" style="width: 150px !important;width: 20%">Total</th> </tr> </thead> <tbody> <tr class="success"> <td class="align-top text-right">1.</td> <td class="align-top text-left">ACKNOWLEDGED</td> <td class="align-top text-right"><?php echo $aa['mfso_app']?></td> </tr> <tr class="danger"> <td class="align-top text-right">2.</td> <td class="align-top text-left">REJECTED</td> <td class="align-top text-right"><?php echo $aa['mfso_dis']?></td> </tr> <tr class="warning"> <td class="align-top text-right">3.</td> <td class="align-top text-left">PENDING</td> <td class="align-top text-right"><?php echo $aa['mfso_pen']?></td> </tr> </tbody> </table> <?php }?> <!-- --> <?php if(empty($report) || $report=='2'){?> <?php echo "<h3 style='color:#454e'><strong><i class='gi gi-pencil'></i> <span style='border-bottom:5px double #ccc'>MTSO</span></strong></h3>"; ?> <table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete"> <thead> <tr> <th class="text-center no_sorting" style="width: 40px !important;width: 5%">No.</th> <th class="text-left" style="width: 75%">Application</th> <th class="text-center" style="width: 150px !important;width: 20%">Total</th> </tr> </thead> <tbody> <tr class="success"> <td class="align-top text-right">1.</td> <td class="align-top text-left">ACKNOWLEDGED</td> <td class="align-top text-right"><?php echo $aa['mtso_app']?></td> </tr> <tr class="danger"> <td class="align-top text-right">2.</td> <td class="align-top text-left">REJECTED</td> <td class="align-top text-right"><?php echo $aa['mtso_dis']?></td> </tr> <tr class="warning"> <td class="align-top text-right">3.</td> <td class="align-top text-left">PENDING</td> <td class="align-top text-right"><?php echo $aa['mtso_pen']?></td> </tr> </tbody> </table> <?php }?> <!-- --> <?php if(empty($report) || $report=='3'){?> <?php echo "<h3 style='color:#454e'><strong><i class='gi gi-pencil'></i> <span style='border-bottom:5px double #ccc'>DG</span></strong></h3>"; ?> <table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete"> <thead> <tr> <th class="text-center no_sorting" style="width: 40px !important;width: 5%">No.</th> <th class="text-left" style="width: 75%">Application</th> <th class="text-center" style="width: 150px !important;width: 20%">Total</th> </tr> </thead> <tbody> <tr class="success"> <td class="align-top text-right">1.</td> <td class="align-top text-left">eDG ENABLED</td> <td class="align-top text-right"><?php echo $aa['dg_app']?></td> </tr> <tr class="danger"> <td class="align-top text-right">2.</td> <td class="align-top text-left">REJECTED</td> <td class="align-top text-right"><?php echo $aa['dg_dis']?></td> </tr> <tr class="warning"> <td class="align-top text-right">3.</td> <td class="align-top text-left">PENDING</td> <td class="align-top text-right"><?php echo $aa['dg_pen']?></td> </tr> </tbody> </table> <?php }?>