One Hat Cyber Team

View File Name : d4.php

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

	if($roles == 1){
		$samb 		= " AND a.idUserApply='{$idUser}'";
		$col 		= "col-md-4";
		$cont 		= 1;
		$acc_port 	= 1;
		$acc_ship 	= 1;
		$l_port 	= "index.php?page=kod/kodPort_a";
		$l_ship 	= "index.php?page=kod/kodKapal_a";
		$l_app 		= "index.php?page=edg/main";
	}else{

		$l_port 	= "index.php?page=kod/kodPort";
		$l_ship 	= "index.php?page=kod/kodKapal";
		$l_agent 	= "index.php?page=utility/agent";

		if($roles != 5){
			$samb 		= "";
			$col 		= "col-md-";

			$stmt 		= $mysqli->stmt_init();
			$stmt->prepare("SELECT 
								SUM(IF(a.href='index.php?page=kod/kodPort',1,0)) acc_port,
								SUM(IF(a.href='index.php?page=kod/kodKapal',1,0)) acc_ship,
								SUM(IF(a.href='index.php?page=utility/agent',1,0)) acc_agent 
							FROM utiliti_menu a 
							LEFT JOIN utiliti_kawalan b ON b.idMenu = a.idMenu AND b.idRoles = '{$roles}' 
							WHERE 1 AND IF(a.href='',1,b.idMenu IS NOT NULL) AND a.status_active = 'Y' ORDER BY a.order_no ASC") ;
			$stmt->execute();
			$result 	= $stmt->get_result();
			$stmt->close();
			$aa 	= $result->fetch_assoc();
			$acc_port 		= (!empty($aa['acc_port'])) ? $aa['acc_port'] : 0 ;
			$acc_ship 		= (!empty($aa['acc_ship'])) ? $aa['acc_ship'] : 0 ;
			$acc_agent 		= (!empty($aa['acc_agent'])) ? $aa['acc_agent'] : 0 ;
			$cont 			= $acc_port+$acc_ship+$acc_agent;
			unset($aa);
			unset($result);

			if($cont!=0){
				$divider 	= 12/$cont;
				$col 		.= $divider;
			}else{
				$col 		.= '12';
			}

		}else{
			$samb 		= "";
			$col 		= "col-md-4";
			$cont 		= 1;
			$acc_port 	= 1;
			$acc_ship 	= 1;
			$acc_agent 	= 1;
		}

	}

	$stmt 		= $mysqli->stmt_init();
	$stmt->prepare("SELECT 
						if(tot_kapal IS NULL,0,tot_kapal) AS tot_kapal, 
						if(tot_pelabuhan IS NULL,0,tot_pelabuhan) AS tot_pelabuhan, 
						if(tot_agent IS NULL, 0,tot_agent) AS tot_agent, 
						if(tot_app IS NULL, 0,tot_app) AS tot_app 
					FROM dummy
					LEFT JOIN (
						SELECT SUM(1) AS tot_kapal, flagApprove 
						FROM `kod_kapal` a 
						WHERE 1 AND a.flagApprove = 'N' {$samb} GROUP BY flagApprove
						) a ON 1
					LEFT JOIN (
						SELECT SUM(1) AS tot_pelabuhan, flagApprove 
						FROM `kod_pelabuhan` a 
						WHERE 1 AND a.flagApprove = 'N' {$samb} GROUP BY flagApprove
						) b ON 1
					LEFT JOIN (
						SELECT SUM(1) AS tot_agent, a.flagApprove 
						FROM user_register a 
						LEFT JOIN kod_syarikattemp b ON b.idSyarikat=a.idSyarikat 
						WHERE a.flagUser=2 AND a.flagApprove='N'
					) c ON 1
					LEFT JOIN (
						SELECT SUM(if(tot_app=0,1,0)) AS tot_app
						FROM permohonan_cnt a
						WHERE 1 {$samb}
					) d ON 1") ;
	$stmt->execute();
	$result 	= $stmt->get_result();
	$stmt->close();
	$aa 	= $result->fetch_assoc();
	$tot_kapal 		= (!empty($aa['tot_kapal'])) ? $aa['tot_kapal'] : 0 ;
	$tot_pelabuhan 	= (!empty($aa['tot_pelabuhan'])) ? $aa['tot_pelabuhan'] : 0 ;
	$tot_agent 		= (!empty($aa['tot_agent'])) ? $aa['tot_agent'] : 0 ;
	$tot_app 		= (!empty($aa['tot_app'])) ? $aa['tot_app'] : 0 ;

	if($cont>0){
?>
	<div class="widget">
	<div class="widget-content widget-content-mini themed-background-dark-flat">
	<strong class="text-light"><?php echo $dtitle; ?></strong>
	</div>
	<div class="widget-content widget-content-mini themed-background-classy text-left clearfix text-center">
		<?php if($acc_ship==1){ ?>
		<div class="<?php echo $col; ?>">
		<h3 class="widget-heading text-center">
			<a class="moveme img-circle img-thumbnail text-center themed-background-muted circle_custom1" href="<?php echo $l_ship;?>" >
				<i class="gi gi-boat text-info" style="line-height: 2"></i>
			</a>
			<br>
			<small class="text-light text-wrap"><b>VESSELS</b></small>
			<br>
			<a class="text-light" href="<?php echo $l_ship;?>"><?php echo $tot_kapal; ?></a>
		</h3>
		</div>
		<?php } ?>
		<?php if($acc_port==1){ ?>
		<div class="<?php echo $col; ?>">
		<h3 class="widget-heading text-center">
			<a class="moveme img-circle img-thumbnail text-center themed-background-muted circle_custom1" href="<?php echo $l_port;?>" >
				<i class="gi gi-anchor text-success" style="line-height: 2"></i>
			</a>
			<br>
			<small class="text-light text-wrap"><b>PORTS</b></small>
			<br>
			<a class="text-light" href="<?php echo $l_port;?>"><?php echo $tot_pelabuhan; ?></a>
		</h3>
		</div>
		<?php } ?>
		<?php if($roles!=1 && $acc_agent==1){ ?>
		<div class="<?php echo $col; ?>">
		<h3 class="widget-heading text-center">
			<a class="moveme img-circle img-thumbnail text-center themed-background-muted circle_custom1" href="<?php echo $l_agent;?>" >
				<i class="gi gi-group text-primary" style="line-height: 2"></i>
			</a>
			<br>
			<small class="text-light text-wrap"><b>AGENTS</b></small>
			<br>
			<a class="text-light" href="<?php echo $l_agent;?>"><?php echo $tot_agent; ?></a>
		</h3>
		</div>
		<?php } ?>
		<?php if($roles==1){ ?>
		<div class="<?php echo $col; ?>">
		<h3 class="widget-heading text-center">
			<a class="moveme img-circle img-thumbnail text-center themed-background-muted circle_custom1" href="<?php echo $l_app;?>" >
				<i class="gi gi-bookmark text-primary" style="line-height: 2"></i>
			</a>
			<br>
			<small class="text-light text-wrap"><b>APPLICATIONS</b></small>
			<br>
			<a class="text-light" href="<?php echo $l_app;?>"><?php echo $tot_app; ?></a>
		</h3>
		</div>
		<?php } ?>
	</div>
	</div>
<?php } ?>