Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
app_download.php	1.6 KB	-rw-rw-rw-
app_print.php	22.28 KB	-rw-rw-rw-
app_print_230312.php	21.87 KB	-rw-rw-rw-
app_report.php	7 B	-rw-rw-rw-
application.php	13.23 KB	-rw-rw-rw-
application_1.php	5.59 KB	-rw-rw-rw-
audit_trail_1.php	4.23 KB	-rw-rw-rw-
bill.pdf	1.78 KB	-rw-rw-rw-
declaration.php	13.92 KB	-rw-rw-rw-
declaration_1.php	2.35 KB	-rw-rw-rw-
declaration_2.php	2.34 KB	-rw-rw-rw-
declaration_3.php	2.06 KB	-rw-rw-rw-
declaration_4.php	1.93 KB	-rw-rw-rw-
declaration_5.php	2 KB	-rw-rw-rw-
declaration_6.php	2.05 KB	-rw-rw-rw-
declaration_7.php	2.25 KB	-rw-rw-rw-
declaration_8.php	2.57 KB	-rw-rw-rw-
declaration_9.php	123.3 KB	-rw-rw-rw-
declaration_f.php	515 B	-rw-rw-rw-
declaration_prt.php	1.49 KB	-rw-rw-rw-
print_report.php	3.21 KB	-rw-rw-rw-
site_1.php	3 KB	-rw-rw-rw-
site_2.php	3.5 KB	-rw-rw-rw-
user.php	5.95 KB	-rw-rw-rw-
user_1.php	2.38 KB	-rw-rw-rw-

Code Editor : 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>

${this.title}

Code Editor : site_1.php