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

Dir : C:/xampp7/htdocs/edgpens/reports/

View File Name : declaration_8.php

<?php 
	
	$combx1 	= "";

	if(!empty($period=='year')){ 
		$combx1 			.= " AND YEAR(a.tarikhApply) = ? ";
		$param_data['p1'] 	= $year;
	}

	if(!empty($period=='month')){ 
		$combx1 			.= " AND DATE_FORMAT(a.tarikhApply,'%m-%Y') = ? ";
		$param_data['p2'] 	= $month;
	}
	
	if(!empty($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;
	}

	$sqlx 		= "	SELECT 
						SUM(IF(a.flagApproveMTSO='Y' AND a.idApproveMTSO!=0,1,0)) approved,
						SUM(IF(a.flagApproveMFSO='T' AND a.idApproveMFSO!=0,1,0)) rejected1,
						SUM(IF(a.flagApproveMTSO='T' AND a.idApproveMTSO!=0,1,0)) rejected2,
						SUM(IF(a.flagApproveDG='T' AND a.idApproveDG!=0,1,0)) rejected3,
						SUM(IF(
								(a.flagApproveMFSO='T' AND a.idApproveMFSO!=0)
								OR (a.flagApproveDG='T' AND a.idApproveDG!=0)
								OR (a.flagApproveMTSO='T' AND a.idApproveMTSO!=0)
						,1,0)) rejected,
						b.nama
					FROM permohonan_main a 
					LEFT JOIN kod_marine_facility b ON b.idMarineFacility = a.idMarineFacility
					WHERE b.idMarineFacility IS NOT NULL
					{$combx1}
					GROUP BY a.idMarineFacility
				";
	$result2 	= mysqli_prepare_all($sqlx,$param_type = "auto",$param_data);
	$rows_app 	= $result2->num_rows;

	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}";
?>
<h4><b>Total Declaration By Marine Facilities - <?php echo $report_name; ?></b></h4>
<hr>
<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: 55%">Marine Facility</th>
			<th class="text-center" style="width: 150px !important;width: 20%">Approved</th>
			<th class="text-center" style="width: 150px !important;width: 20%">Rejected</th>
		</tr>
	</thead>
	<tbody>
	<?php

		$i=1;
		while($aa = $result2->fetch_assoc()){
	?>
		<tr class="<?php echo $tr_class;?>">
			<td class="align-top text-right"><?php echo $i++; ?>.</td>
			<td class="align-top text-left"><?php echo strtoupper($aa['nama']);?></td>
			<td class="align-top text-center"><?php echo $aa['approved']?></td>
			<td class="align-top text-center"><?php echo $aa['rejected']?></td>
		</tr>
	<?php } ?>
	</tbody>
</table>