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 : site_1.php

<?php 
	$idUser 			= (isset($_POST['idu'])) ? $_POST['idu'] : '' ;
	$idMarineFacility 	= (isset($_POST['idMarineFacility'])) ? $_POST['idMarineFacility'] : '' ;
	$flagStatus 		= (isset($_POST['flagStatus'])) ? $_POST['flagStatus'] : '' ;
	$year 				= (isset($_POST['year'])) ? $_POST['year'] : '' ;

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

	if(!empty($flagStatus)){ 
		$combx1 			.= " AND a.flagStatus = ? ";
		$param_data['p2'] 	= $flagStatus;
	}
	
	if(!empty($year)){ 
		$combx1 			.= " AND YEAR(a.tarikhVisit) = ? ";
		$param_data['p3'] 	= $year;
	}

 	$sqlx 		= "	SELECT a.*,
						DATE_FORMAT(a.tarikhVisit,'%d-%m-%Y') AS tarikhVisit,
						b.nama AS nama_pelabuhan, 
						c.nameUser,
						SUM(IF(d.idVisitDetail IS NOT NULL,1,0)) AS tot_finding,
						SUM(IF(d.response_date != '0000-00-00',1,0)) AS tot_response
					FROM 
						visit_main a
					LEFT JOIN 
						kod_marine_facility b on b.idMarineFacility = a.idMarineFacility
					LEFT JOIN 
						user_list c ON c.idUser = a.enter_by
					LEFT JOIN 
						visit_detail d ON d.idVisitMain = a.idVisitMain
					WHERE 1=1
					-- AND idVisitor = '{$idUser}' 
					{$combx1}
					GROUP BY a.idVisitMain
					ORDER BY a.tarikhVisit DESC
				";
	$result2 	= mysqli_prepare_all($sqlx,$param_type = "auto",$param_data);
?>
<?php echo "<h4 style='color:#454e;margin-bottom:0px'><strong><i class='gi gi-user'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>Site Visit</span></strong></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: 5%;">NO</th>
			<th class="text-left" style="width: 30%;">Created By</th>
			<th class="text-left" style="width: 25%;">Terminal Name</th>
			<th class="text-center" style="width: 10%;">Date</th>
			<th class="text-center" style="width: 10%;">Finding</th>
			<th class="text-center" style="width: 10%;">Response</th>
			<th class="text-center" style="width: 10%;">Status</th>
		</tr>
	</thead>
	<tbody>
	<?php

		$i=1;
		while($aa = $result2->fetch_assoc()){
			if($aa['warning'] == 'Y')
				$tr_class 	= "danger";
			else
				$tr_class 	= "";

	?>
		<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['nameUser']);?></td>
			<td class="align-top text-left"><?php echo strtoupper($aa['nama_pelabuhan']);?></td>
			<td class="align-top text-center"><?php echo $aa['tarikhVisit']?></td>
			<td class="align-top text-center"><?php if(empty($aa['tot_finding'])) echo "-"; else echo $aa['tot_finding']; ?></td>
			<td class="align-top text-center"><?php if(empty($aa['tot_response'])) echo "-"; else echo $aa['tot_response']; ?></td>
			<td class="align-top text-center"><?php echo $aa['flagStatus']?></td>
		</tr>
	<?php } ?>
	</tbody>
</table>