Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
detail.php	29.21 KB	-rw-rw-rw-
detail_20210104.php	32.67 KB	-rw-rw-rw-
dg.php	42.25 KB	-rw-rw-rw-
dg_20200723.php	51.85 KB	-rw-rw-rw-
dg_20201219.php	50 KB	-rw-rw-rw-
isps_info-1.php	16.45 KB	-rw-rw-rw-
isps_info.php	12.93 KB	-rw-rw-rw-
isps_info_20200723.php	18.17 KB	-rw-rw-rw-
isps_infox.php	14.94 KB	-rw-rw-rw-
main.php	47.28 KB	-rw-rw-rw-
main_20201220.php	31.43 KB	-rw-rw-rw-
main_20201222.php	31.43 KB	-rw-rw-rw-
mainx.php	30.78 KB	-rw-rw-rw-
other_part.php	16.86 KB	-rw-rw-rw-
other_part_20200723.php	15.45 KB	-rw-rw-rw-
other_part_20201219.php	13.56 KB	-rw-rw-rw-
port_call.php	22.79 KB	-rw-rw-rw-
port_call_20200723.php	23.49 KB	-rw-rw-rw-
s_detail.php	23.79 KB	-rw-rw-rw-
s_info.php	28.24 KB	-rw-rw-rw-
s_main.php	14.64 KB	-rw-rw-rw-
s_upload_me.php	1.56 KB	-rw-rw-rw-
ship_particular.php	38 KB	-rw-rw-rw-
ship_particular_20200723.php	27.12 KB	-rw-rw-rw-
site.php	12.9 KB	-rw-rw-rw-
tabs.php	10.22 KB	-rw-rw-rw-
upload	5.32 KB	-rw-rw-rw-
upload.php	14.3 KB	-rw-rw-rw-
upload_20200723.php	14.23 KB	-rw-rw-rw-
upload_me.php	1.53 KB	-rw-rw-rw-

Code Editor : isps_infox.php

<?php if(empty($page)){ include("../access.php"); } ?>
<?php  
	$modal_name 	= str_replace("/", "-", $page);

// $mysqli->query("CREATE TEMPORARY TABLE t1 LIKE City");

/* INSERT INTO .. SELECT */
// $mysqli->query("INSERT INTO t1 SELECT * FROM City ORDER BY ID LIMIT 150");
// printf("%s\n", $mysqli->info);

function bindAll($stmt) {
    $meta = $stmt->result_metadata();
    $fields = array();
    $fieldRefs = array();
    while ($field = $meta->fetch_field())
    {
        $fields[$field->name] = "";
        $fieldRefs[] = &$fields[$field->name];
    }

call_user_func_array(array($stmt, 'bind_result'), $fieldRefs);
    $stmt->store_result();
    return $fields;
}

function fetchRowAssoc($stmt, &$fields) {
    if ($stmt->fetch()) {
        return $fields;
    }
    return false;
}

$user 			= get_user($_SESSION['session']);
	$ii 			= (is_numeric($_GET['ii']) == 1) ? $_GET['ii'] : 0 ;
	$success 	 	= 0;
	$type_submit 	= "add";

$user 			= get_user_full($_SESSION['session']);
	$roles 			= (int)$user['idRoles'];
	$idUser 		= (int)$user['idUser'];

if($roles == 1 || $roles == 5){
		if(!empty($ii)){
			if($roles == 1){
				$query="SELECT * FROM permohonan_main WHERE idUserApply='{$idUser}' AND idPermohonan = '{$ii}'";
				$result=$mysqli->query($query);	
				$row=$result->fetch_assoc();

if(!$row){
					echo "<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>";
					exit();
				}

}
		}
	}else{
		echo "<script>window.location.replace('index.php?page=edg/main');</script>";
		exit();
	}

if($_POST):

$do 	= $_POST['type_submit'];

if($ii > 0){

if($do=="submit_me"){							
				$sql 	 		= "UPDATE 
										permohonan_main 
									SET 
										submit 	 			= 'Y',
										idApproveMFSO 	 	= 0,
										commentsMFSO 	 	= '',
										flagApproveMFSO 	= 'N',
										idApproveDG 	 	= 0,
										commentsDG 	 		= '',
										flagApproveDG 		= 'N',
										idApproveMTSO 	 	= 0,
										commentsMTSO 	 	= '',
										flagApproveMTSO 	= 'N'
									WHERE 
										idPermohonan = ?";
				$param_type 	= "s";
				$param_data 	= array(
									"idPermohonan" 		=> $ii
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);
			}else{

$sql 	 		= "	UPDATE 
										permohonan_main 
									SET 
										idMarineFacility = ?,
										flagISSC = ?,
										securityLevel = ?
									WHERE 
										idPermohonan = ?";
				
				$param_type 	= "ssssssss";
				$param_data 	= array(
									"idMarineFacility" 	=> $_POST['idMarineFacility'],
									"flagISSC" 			=> $_POST['flagISSC'],
									"securityLevel" 	=> $_POST['securityLevel'],
									"idPermohonan" 		=> $ii
								 	);				
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);
			}

}

$success 	= 1;

endif;

if($success){
		if($do=="submit_me")
			echo "<script>window.location.replace('index.php?page=edg/main&np=edg/isps_info&ii={$ii}');</script>";
		else
			echo "<script>window.location.replace('index.php?page=edg/main&np=edg/port_call&ii={$ii}');</script>";
		exit();
	}
	
	if($ii > 0){
		
		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							idPermohonan,
							idMarineFacility, 
							flagISSC, 
							securityLevel, 
							flagSecurityMeasures,
							flagDG,
							idApproveMFSO,
							idApproveDG,
							idApproveMTSO,
							commentsMFSO,
							commentsDG,
							commentsMTSO,
							submit
						FROM 
							permohonan_main 
						WHERE 
							idPermohonan=?
						");
		$stmt->bind_param("s",$permohonan_main = $ii);
		$stmt->execute();

if ($stmt->error)
    		print_r('error executing statement: ' . $stmt->error);

$result 		= $stmt->get_result();
		$stmt->close();

$session 	= array();
		$row=$result->fetch_assoc();

$idMarineFacility 		= $row['idMarineFacility'];
		$flagISSC 				= $row['flagISSC'];
		$securityLevel 			= $row['securityLevel'];
		$idApproveMFSO 			= $row['idApproveMFSO'];
		$idApproveDG 			= $row['idApproveDG'];
		$idApproveMTSO 			= $row['idApproveMTSO'];
		$commentsMFSO 			= $row['commentsMFSO'];
		$commentsDG 			= $row['commentsDG'];
		$commentsMTSO 			= $row['commentsMTSO'];
		$submit 				= $row['submit'];
		// $flagSecurityMeasures 	= $row['flagSecurityMeasures'];

$isps 				= "";
		$isps_href 			= "index.php?page=edg/main&np=edg/isps_info&ii={$ii}";
		if(!empty($idMarineFacility)){
			$dis_next 			= "";
			$port 				= "";
			$port_href 			= "index.php?page=edg/main&np=edg/port_call&ii={$ii}";

$sqlx 	= "SELECT * FROM permohonan_pelabuhan WHERE idPermohonanMain = '{$ii}'";
			$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));

if($rstx->num_rows > 0){
				$other 				= "";
				$other_href 		= "index.php?page=edg/main&np=edg/other_part&ii={$ii}";

$upload 			= "";
				$upload_href 		= "index.php?page=edg/main&np=edg/upload&ii={$ii}";

if($row['flagDG'] == 'Y'){
					$dg 				= "";
					$dg_href 			= "index.php?page=edg/main&np=edg/dg&ii={$ii}";
				}else{
					$dg 				= "disabled";
					$dg_href 			= "javascript:void(0)";
				}

}else{
				$other 				= "disabled";
				$other_href 		= "javascript:void(0)";
				$upload 			= "disabled";
				$upload_href 		= "javascript:void(0)";
				$dg 				= "disabled";
				$dg_href 			= "javascript:void(0)";
			}

}else{
			$dis_next 			= "disabled";
			$port 				= "disabled";
			$port_href 			= "javascript:void(0)";
			$other 				= "disabled";
			$other_href 		= "javascript:void(0)";
			$upload 			= "disabled";
			$upload_href 		= "javascript:void(0)";
			$dg 				= "disabled";
			$dg_href 			= "javascript:void(0)";
		}
		$particular 		= "disabled";
		$particular 		= "javascript:void(0)";

if(!$row){
			echo "<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>";
			exit();
		}

}else{
		echo "<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>";
		exit();
	}

// $stmt = $mysqli->stmt_init();
// $stmt = $mysqli->prepare("SELECT * FROM kod_kapal where nama=?");
// $stmt->bind_param("s", $nama);
// $nama="test1";
// $stmt->execute();
// print_r($stmt->info."asdsa");
// // $stmt->debugDumpParams();
//  $stmt -> bind_result($flag);
//  $stmt -> fetch();
// $stmt->close();
?>

<div class="content-header">
		<div class="row">
			<div class="col-sm-6">
				<div class="header-section">
					
					<h1>
					<ol class="breadcrumb" style="padding:0px; margin: 0px">
                        <li><a href="index.php?page=edg/main" style="color:black"><i class="fa fa-home"></i></a></li>
                        <li><a href="javascript:void(0)" style="color:black">NEW APPLICATION</a></li>
                    </ol>
                	</h1>
				</div>
			</div>
			<div class="col-sm-6 hidden-xs">
				<div class="header-section">
					
						
						
					
				</div>
			</div>
		</div>
	</div>

<div class="block full">

<?php if(($idApproveMFSO != 0 OR $idApproveDG != 0 OR $idApproveMTSO != 0) AND $submit == 'T'){ ?>
		<div class="alert alert-warning alert-dismissable">
		<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
		<h4><strong>APPLICATION REJECTED / NEED TO SUBMIT AGAIN</strong></h4>
		<p>COMMENTS :- </p>
		<p>~ MFSO : <?php echo nl2br($commentsMFSO);?></p>
		<p>~ DG : <?php echo nl2br($commentsDG);?></p>
		<p>~ MTSO : <?php echo nl2br($commentsMTSO);?></p>
		</div>
		<?php }?>

<div class="block-section">
			<form class="submit_me" action="index.php?page=edg/main&np=edg/isps_info&ii=<?php echo $ii;?>" method="post">
			<ul class="nav nav-pills nav-justified">
				<li class=""><a href="index.php?page=edg/main&np=edg/ship_particular&ii=<?php echo $ii; ?>">Ship Particular</a></li>
				<li class="active"><a href="javascript:void(0)">ISPS Information</a></li>
				<li class="<?php echo $port; ?>"><a href="<?php echo $port_href; ?>">Last 10 Port Calls</a></li>
				<li class="<?php echo $other; ?>"><a href="<?php echo $other_href; ?>">Other Particular</a></li>
				<li class="<?php echo $upload; ?>"><a href="<?php echo $upload_href; ?>">File Upload</a></li>
				<li class="<?php echo $dg; ?>"><a href="<?php echo $dg_href; ?>">Dangerous Goods</a></li>
				<?php if($ii > 0){ ?>
				<li class=""><a href="javascript:void(0)" class="a_me btn btn-success btn-sm submit_form"><i class="fa fa-paper-plane-o"></i>&nbsp;SUBMIT APPLICATION</a></li>
				<?php }else{ ?>
				<li class=""><a href="javascript:void(0)" class="disabled btn btn-success btn-sm submit_form"><i class="fa fa-paper-plane-o"></i>&nbsp;SUBMIT APPLICATION</a></li>
				<?php } ?>
			</ul>
			<input type="hidden" name="type_submit" value="submit_me">
			</form>
		</div>

<div class="block full">
			<form class="form-horizontal" id="form-validation" method="post">
				
				<div class="row">
				<div class="col-md-12">
				<div class="form-group">
					<label class="col-md-6 control-label" >Name Of Archorage or Marine Facility your ship is bound for <span class="text-danger">*</span></label>
					<div class="col-md-6">
						<?php 
							$sqlx 	= "SELECT * FROM kod_marine_facility WHERE flagAktif = 'Y' ORDER BY nama";
							$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
						?>
						<select class="form-control select-select2 validation" data-validation="default" name="idMarineFacility" id="idMarineFacility" style="width: 75%;">
							<option value="">-- Please select --</option>
							<?php while($aa = $rstx->fetch_assoc()){ ?>
							<option value="<?php echo $aa['idMarineFacility']; ?>" <?php if($aa['idMarineFacility'] == $idMarineFacility){ echo "selected='selected'";} ?> ><?php echo $aa['nama']; ?></option>
							<?php 	}?>
						</select>
					</div>
				</div>
				</div>
				<hr>
				
				<div class="row">
				<div class="col-md-12">
				<div class="form-group">
					<label class="col-md-6 control-label">Prohibited good under UN security council/resolution on board? <span class="text-danger">*</span></label>
					<div class="col-md-4">
						<label class="radio-inline" for="issc1">
							<input class="validation" data-validation="default" type="radio" id="issc1" name="flagISSC" value="Y" <?php if($flagISSC=='Y'){ echo "checked='checked'"; } ?> > Yes
						</label>
						<label class="radio-inline" for="issc2">
							<input class="validation" data-validation="default" type="radio" id="issc2" name="flagISSC" value="T" <?php if($flagISSC=='T'){ echo "checked='checked'"; } ?> > No
						</label>
					</div>
				</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-12">
				<div class="form-group">
					<label class="col-md-6 control-label" for="crew">Current Security Level of the ship <span class="text-danger">*</span></label>
					<div class="col-md-4">
						<div class="radio">
						<label for="security1">
							<input class="validation" data-validation="default" type="radio" id="security1" name="securityLevel" value="1" <?php if($securityLevel=='1'){ echo "checked='checked'"; } ?>> 1
						</label>
						</div>
						<div class="radio">
						<label for="security2">
							<input class="validation" data-validation="default" type="radio" id="security2" name="securityLevel" value="2" <?php if($securityLevel=='2'){ echo "checked='checked'"; } ?>> 2
						</label>
						</div>
						<div class="radio">
						<label for="security3">
							<input class="validation" data-validation="default" type="radio" id="security3" name="securityLevel" value="3" <?php if($securityLevel=='3'){ echo "checked='checked'"; } ?>> 3
						</label>
						</div>
					</div>
				</div>
				</div>
				</div>
				
				<hr>
				<center>
				<div class="btn-group">
				<a class="btn btn-warning" href="index.php?page=edg/main&np=edg/ship_particular&ii=<?php echo $ii;?>"><i class="fa fa-chevron-left"></i></a>
				<button class="btn btn-primary" href="index.php?page=edg/main">Save</button>
				<a class="btn btn-warning <?php echo $dis_next;?>" href="index.php?page=edg/main&np=edg/isps_info&ii=<?php echo $ii;?>"><i class="fa fa-chevron-right"></i></a>
				</div>
				</center>
			</form>
		</div>

<!-- <div class="block-section">
<ul class="nav nav-tabs">
<li class="active"><a href="javascript:void(0)">Ship Particular</a></li>
<li class="disabled"><a href="javascript:void(0)">ISPS Information</a></li>
<li class="disabled"><a href="javascript:void(0)">Last 10 Port Calls</a></li>
<li class="disabled"><a href="javascript:void(0)">Other Particular</a></li>
</ul>

asdsa
</div>           	<div class="col-sm-6">
asdsa
</div>

</div>

</div>
 -->
			<?php

$success 	= 0;
				if($_POST):

$do 	= $_POST['type_submit'];
					// $_SESSION['success'] = 1;

/*
						insert / update / delete
					*/

/*
						1 = success
						2 = failed/error
					*/

// test if success == 1
					$success 	= 1;

if($success == 1){
						$_SESSION['success'] 		= 1;
						$_SESSION['success_msg'] 	= "SUCCESS {$do}";
					}else if($success == 2){
						$_SESSION['success'] 		= 2;
						$_SESSION['success_msg'] 	= "OPS! SOMETHING WRONG";
					}else if($success == 3){
						$_SESSION['success'] 		= 3;
						$_SESSION['success_msg'] 	= "WARNING";
					}

endif;

if($success){
					echo "<script>window.location.replace('index.php?page=kod/blank_page&success={$success}');</script>";
					exit();
				}
			?>

$(".submit_form").on("click",function(){
				$.confirm({
					title: 'Confirm!',
					content: 'Submit This Application For Further Action?',
					buttons: {
						confirm: function () {
							$(".submit_me").trigger("submit");
						},
						cancel: function () {
							// $.alert('Canceled!');
						}
					}
				});
        	});

$("#form-validation").setvalidation2();
			$("#form-validation").on("submit",function(){
				if($(this).find(".has-error").length === 0){
					if(!confirm("Save This Record. Are You Sure?")){
						return false;
					}
				}
			});

$("[name='vessel']").on("change",function(){
        		var t_val 	= $(this).val();
				$.ajax({
					type		: "POST",
					data 		: "idKapal="+t_val,
					url 		: "ajax.php?do=get_vessel",
					success 	: function(msg){
						var obj = jQuery.parseJSON(msg);
						if(obj){
							$("[name='imo']").val(obj.IMO);
							$("[name='issc']").val(obj.ISSC);
							$("[name='callsign']").val(obj.CallSign);
							$("[name='nama_syarikat']").val(obj.nama_syarikat);
							$("[name='flag']").val(obj.Flag);
							$("[name='nama_jeniskapal']").val(obj.nama_jeniskapal);
						}else{
							$("[name='imo']").val("");
							$("[name='issc']").val("");
							$("[name='callsign']").val("");
							$("[name='nama_syarikat']").val("");
							$("[name='flag']").val("");
							$("[name='nama_jeniskapal']").val("");
						}
					}
				});
        	});

});

</script>
	</div>

${this.title}

Code Editor : isps_infox.php