Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
bypas.asc.php	1.71 KB	-rw-rw-rw-
d1_1.php	1.88 KB	-rw-rw-rw-
d1_2.php	2 KB	-rw-rw-rw-
d1_3.php	1.84 KB	-rw-rw-rw-
d2.php	2.57 KB	-rw-rw-rw-
d3.php	9.72 KB	-rw-rw-rw-
d4.php	5.45 KB	-rw-rw-rw-
main.php	1.1 KB	-rw-rw-rw-

Code Editor : d1_2.php

<?php include_once "../access_inc.php"; ?>
<?php 
	$modal_name 	= str_replace("/", "-", $page);

if($roles == 2 && $flagDGApproval == 'Y'){
		$samb 	= " AND a.idMarineFacility='{$idPelabuhan}'";
		$col 	= "col-md-4";
	}else{
		if($roles != 5){
			$samb 	= ($flagDGApproval == 'Y') ? "" : " AND 1=2" ;
			$col 	= "col-md-4";
		}else{
			$samb 	= "";
			$col 	= "col-md-4";
		}
	}

$stmt 		= $mysqli->stmt_init();
	$stmt->prepare("SELECT 
						SUM(IF(tot_dg=0,1,0)) pen,
						SUM(IF(tot_dg=1,1,0)) ack
					FROM permohonan_cnt a 
					WHERE a.flagDG=1
					AND DATEDIFF(a.ETA,NOW())>=0 
					{$samb}") ;
	$stmt->execute();
	$result 	= $stmt->get_result();
	$stmt->close();
	$aa 	= $result->fetch_assoc();
	$pen 	= (!empty($aa['pen'])) ? $aa['pen'] : 0 ;
	$ack 	= (!empty($aa['ack'])) ? $aa['ack'] : 0 ;

if(!empty($pen) || !empty($ack)){
?>
	<div class="widget">
	<div class="widget-content widget-content-mini themed-background-dark-flat">
	<span class="pull-right text-light-op">Before Arrival</span>
	<strong class="text-light"><?php echo $dtitle; ?></strong>
	</div>
	<div class="widget-content widget-content-mini themed-background-danger text-left clearfix text-center">
		<div class="col-md-6 ">
		<h3 class="widget-heading text-center">
			<div class="img-circle img-thumbnail text-center themed-background-muted circle_custom1">
				<i class="gi gi-alarm text-danger" style="line-height: 2"></i>
			</div>
			<br>
			<small class="text-light text-wrap"><b>PENDING</b></small>
			<br>
			<span class="text-light"><?php echo $pen; ?></span>
		</h3>
		</div>
		<div class="col-md-6 ">
		<h3 class="widget-heading text-center">
			<div class="img-circle img-thumbnail text-center themed-background-muted circle_custom1">
				<i class="fa fa-check text-success" style="line-height: 2"></i>
			</div>
			<br>
			<small class="text-light text-wrap"><b>eDG ENABLED</b></small>
			<br>
			<span class="text-light"><?php echo $ack; ?></span>
		</h3>
		</div>
	</div>
	</div>
<?php } ?>

${this.title}

Code Editor : d1_2.php