One Hat Cyber Team

Edit File: d3.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";
	}else if($roles == 2){
		$samb 	= " AND a.idMarineFacility='{$idPelabuhan}'";
		$col 	= "col-md-4";
	}else{
		$samb 	= "";
		$col 	= "col-md-4";
	}

$stmt 		= $mysqli->stmt_init();
	$stmt->prepare("SELECT 
						100-ROUND(DATEDIFF(a.ETA,NOW())*(100/DATEDIFF(a.ETA,a.tarikhApply)),0) arrival_pct,
						DATEDIFF(a.ETA,NOW()) arrival,
						c.nama AS nama_pelabuhan,
						d.nama AS nama_kapal,
						a.flagDG,
						a.flagISSC,
						a.securityLevel,
						IF(DATE_FORMAT(date_sub(a.ETA, INTERVAL 14 day),'%Y-%m-%d') <= DATE_FORMAT(NOW(),'%Y-%m-%d'), IF(DATE_FORMAT(a.ETA,'%Y-%m-%d') > DATE_FORMAT(NOW(),'%Y-%m-%d'),'Y','T'),'T') AS warning,
						a.idPermohonan,
						a.commentsMFSO,
						a.commentsDG,
						a.commentsMTSO,
						f.nameUser AS nama_mfso,
						g.nameUser AS nama_dg,
						h.nameUser AS nama_mtso,
						a.flagApproveMFSO,
						a.flagApproveDG,
						a.flagApproveMTSO
					FROM permohonan_main a 
					LEFT JOIN kod_marine_facility c on c.idMarineFacility = a.idMarineFacility
					LEFT JOIN kod_kapal d ON d.idKapal = a.idKapal
					LEFT JOIn user_list f ON f.idUser = a.idApproveMFSO
					LEFT JOIN user_list g ON g.idUser = a.idApproveDG
					LEFT JOIN user_list h ON h.idUser = a.idApproveMTSO
					WHERE submit='Y' 
					AND status!='R' 
					AND DATEDIFF(a.ETA,NOW())>=0 
					{$samb}
					-- AND flagApproveMTSO='Y' 
					ORDER BY DATEDIFF(a.ETA,NOW()) ASC") ;
	$stmt->execute();
	$result 	= $stmt->get_result();
	$stmt->close();

if($result->num_rows>0){
?>

<div class="widget">
	<div class="widget-content border-bottom text-dark">
	
	<span class="pull-right text-muted">ETA</span>
	<?php echo $dtitle; ?>
	</div>
	<?php 		
		$cnt 	= 1;
		while($aa = $result->fetch_assoc()){

$arrival_pct 	= $aa['arrival_pct'];
			$arrival 		= $aa['arrival'];
			$warning 		= $aa['warning'];
			$progress 		= "progress-bar-warning";

if($warning=='Y')
				$progress 		= "progress-bar-danger";

if($arrival>1){
				$eta 	= "<span data-toggle='counter' data-to='{$arrival}'>'{$arrival}'</span> Days";

}
			else if($arrival==1){
				$eta 	= "1 Day";
			}
			else{
				$eta 		= "Today";
				$progress 	= "progress-bar-success";
			}

$xtraicon 	= "";
			if($aa['flagDG'] == 'Y'){//DG
				$xtraicon .= "<i class='gi gi-circle_exclamation_mark text-light-danger text-danger' style='line-height: normal;margin:0px 1px;'></i>";
			}

if($aa['flagISSC'] == 'Y'){//UN
				$xtraicon .= "<i class='gi gi-ban text-light-danger text-info' style='line-height: normal;margin:0px 1px;'></i>";
			}

if($aa['securityLevel'] == '2' OR $aa['securityLevel'] == '3'){//UN
				$xtraicon .= "<i class='badge themed-background-warning' style='line-height: normal;margin:0px 1px;font-size:72%;padding: 2px 5px;'>".$aa['securityLevel']."</i>";
			}

$editdata1 = "comments#{$aa['commentsMTSO']}|"
						."name2#{$aa['nama_mfso']}|"
						."name3#{$aa['nama_dg']}|"
						."comments2#{$aa['commentsMFSO']}|"
						."comments3#{$aa['commentsDG']}";

if($aa['flagApproveMTSO']!='Y'){
				$txt 	= "text-info";
			}else{
				$txt 	= "text-success";
			}

$zxc 	= $cnt%2;
			if($zxc==1){
				$themex 	= "themed-background-muted";
				$themey 	= "themed-background-op";
			}else{
				$themex 	= "themed-background-op";
				$themey 	= "themed-background-muted";
			}
			
			$imgnow 	= "gi gi-boat";
			if($aa['flagApproveMTSO']!='Y')
				$imgnow 	= "gi gi-alarm";

// <i class="gi gi-alarm"></i>
	?>
	<a href="javascript:void(0)" class="widget-content <?php echo $themex; ?> text-right clearfix border-top app_det" data-modal-target="modal-1" data-editdata="<?php echo $editdata1;?>" data-myid="<?php echo $aa['idPermohonan'];?>" >
		<div class="img-circle img-thumbnail img-thumbnail-avatar pull-left text-center <?php echo $themey; ?>" width="69" height="69">
			<i class="<?php echo $imgnow; ?> text-light-opx <?php echo $txt; ?>" style="font-size: 25pt;margin-top: 15px"></i>
				<br>
				<span class="text-center" style="display: inline-block;margin-top: 1px;">
					<?php echo $xtraicon; ?>
			</span>
		</div>
		<h2 class="widget-heading h5 text-left pull-left" style="margin: 0px;margin-top: 5px"><?php echo strtoupper($aa['nama_pelabuhan']); ?><br><?php echo strtoupper($aa['nama_kapal']); ?></h2>
		<h2 class="widget-heading h3 text-muted"><?php echo $eta; ?></h2>
		<div class="progress progress-striped progress-mini active" style="margin-bottom: 0px">
			<div class="progress-bar <?php echo $progress; ?>" role="progressbar" aria-valuenow="<?php echo $arrival_pct; ?>" aria-valuemin="5" aria-valuemax="100" style="width: <?php echo $arrival_pct; ?>%"></div>
		</div>
		<?php if($aa['flagApproveMTSO']!='Y'){ ?>
		<h2 style="margin: 0px;padding: 0px;position: relative; top:10px;right: 0px;top:5px;margin-top: 2px;" class="widget-heading h6 text-danger  blinkme">
			<i><b>*&nbsp;Pending Approval</b></i>
		</h2>
		<?php } ?>
	</a>
	<?php $cnt++;} ?>
</div>

$(document).on("click", ".app_det", function(){

var modal_name 	= "."+$(this).data("modal-target");
		var editdata 	= $(this).data("editdata");
		var myid 	= $(this).data("myid");
		var type 	= $(this).data("type");
		var getthis = 0;

var targetdata 	= editdata.split("|");
		var got_name = 0;
		$.each(targetdata,function(i,v){
			var target = v.split("#");
			// console.log("span."+target[0]);
			$(modal_name).find("span."+target[0]).text(target[1]);

if(target[0] === 'name2')
				got_name++;
			if(target[0] === 'name3')
				got_name++;
		});

if(got_name > 0){
			$(modal_name).find(".alert").show();
			if(!$("span.name3").text()){
				$("span.name3").parent("p").hide();
				$("span.comments3").parent("p").hide();
			}
		}else
			$(modal_name).find(".alert").hide();

$.ajax({url: "edg/detail.php?ii="+myid+"&target=ship", success: function(result){
			$(modal_name).find(".tab-pane[id=ship]").html(result);
		}}).done(function(){
			$(document).trigger("resize");

$('.other_purpose').tagsInput({
				width: 'auto',
				height: 'auto'
			});

$("div.tagsinput").find("div").html("&nbsp;");
			$("div.tagsinput").find("a").remove();

}
			});

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=isps", success: function(result){
			$(modal_name).find(".tab-pane[id=isps]").html(result);
		}}).done(function(){
			$(document).trigger("resize");

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=port", success: function(result){
			$(modal_name).find(".tab-pane[id=port]").html(result);
		}}).done(function(){
			$(document).trigger("resize");

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=part", success: function(result){
			$(modal_name).find(".tab-pane[id=part]").html(result);
		}}).done(function(){
			$(document).trigger("resize");

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=dg", success: function(result){
			$(modal_name).find(".tab-pane[id=dg]").html(result);
		}}).done(function(){
			$(document).trigger("resize");

});

$(modal_name).modal({keyboard:true});
		$(modal_name).find("input").not(":button, :submit, :reset").val("").prop("checked",false);
		$(modal_name).find("select").prop("selected",false);
		$(modal_name).find('.help-block').remove();
		$(modal_name).find('.form-group').removeClass('has-success has-error');

});

$(".tab-click").on("click",function(){
		$(document).trigger("resize");
	});

$('[data-toggle="counter"]').each(function(){
		var $this = $(this);

$this.countTo({
			speed: 1000,
			refreshInterval: 25,
			onComplete: function() {
				if($this.data('after')) {
					$this.html($this.html() + $this.data('after'));
				}
			}
		});
	});

});
</script>
<?php } ?>