Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
detail.php	33.14 KB	-rw-rw-rw-
dg.php	48.71 KB	-rw-rw-rw-
isps_info.php	14.99 KB	-rw-rw-rw-
main.php	15.23 KB	-rw-rw-rw-
other_part.php	12.17 KB	-rw-rw-rw-
port_call.php	20.45 KB	-rw-rw-rw-
ship_particular.php	23.62 KB	-rw-rw-rw-
upload	5.32 KB	-rw-rw-rw-
upload.php	11.18 KB	-rw-rw-rw-
upload_me.php	1.53 KB	-rw-rw-rw-

Code Editor : isps_info.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 			= $_GET['ii'];
	$success 	 	= 0;
	$type_submit 	= "add";
	if($_POST):

$do 	= $_POST['type_submit'];

if($ii > 0){
			$sql 	 		= "	UPDATE 
									permohonan_main 
								SET 
									idMarineFacility = ?,
									flagISSC = ?,
									flagNCPort = ?,
									flagDG12 = ?,
									tarikhLuputISSC = ?,
									ISSCAuthority = ?,
									securityLevel = ?
								WHERE 
									idPermohonan = ?";
			$param_type 	= "ssssssss";
			$param_data 	= array(
								"idMarineFacility" 	=> $_POST['idMarineFacility'],
								"flagISSC" 			=> $_POST['flagISSC'],
								"flagNCPort" 		=> $_POST['flagNCPort'],
								"flagDG12" 			=> $_POST['flagDG12'],
								"tarikhLuputISSC" 	=> change_date($_POST['tarikhLuputISSC'],'Y-m-d'),
								"ISSCAuthority" 	=> $_POST['ISSCAuthority'],
								"securityLevel" 	=> $_POST['securityLevel'],
								"idPermohonan" 		=> $ii
							 	);
			$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);

}

$success 	= 1;

endif;

if($success){
		echo "<script>window.location.replace('index.php?page=edg/main&np=edg/port_call&ii={$ii}');</script>";
		exit();
	}
	
	if($_GET['ii'] > 0){
		
		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							idPermohonan,
							idMarineFacility, 
							flagISSC, 
							flagNCPort, 
							flagDG12, 
							DATE_FORMAT(tarikhLuputISSC,'%d-%m-%Y') AS tarikhLuputISSC, 
							ISSCAuthority, 
							securityLevel, 
							flagSecurityMeasures,
							flagDG
						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'];
		$flagNCPort 			= $row['flagNCPort'];
		$flagDG12 				= $row['flagDG12'];
		$tarikhLuputISSC 		= $row['tarikhLuputISSC'];
		$ISSCAuthority 			= $row['ISSCAuthority'];
		$securityLevel 			= $row['securityLevel'];
		// $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">
		
		<div class="block-section">
			<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>
			</ul>
		</div>

<div class="block full">
			<form class="form-horizontal" id="form-validation" method="post">
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" >Name Of Archorage or Port Facility your ship is bound for</label>
					<div class="col-md-8">
						<input type="text" readonly="readonly" class="form-control" value="KEMAMAM">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="idMarineFacility">Name Of Terminal</label>
					<div class="col-md-8">
						<?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">
							<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>
				</div>
				<hr>
				
				<div class="row">
				<div class="col-md-12">
				<div class="form-group">
					<label class="col-md-6 control-label">Does your ship possess a valid International Ship Security Certificate (ISSC)?</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">Does your compliant ship arrives from non compliant port?</label>
					<div class="col-md-4">
						<label class="radio-inline" for="port_compaliant1">
							<input class="validation" data-validation="default" type="radio" id="port_compaliant1" name="flagNCPort" value="Y" <?php if($flagNCPort=='Y'){ echo "checked='checked'"; } ?> > Yes
						</label>
						<label class="radio-inline" for="port_compaliant2">
							<input class="validation" data-validation="default" type="radio" id="port_compaliant2" name="flagNCPort" value="T" <?php if($flagNCPort=='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">Does your ship non compliant ISPS Code andd carrying DG class 1 &amp; 2?</label>
					<div class="col-md-4">
						<label class="radio-inline" for="non_compliant1">
							<input class="validation" data-validation="default" type="radio" id="non_compliant1" name="flagDG12" value="Y" <?php if($flagDG12=='Y'){ echo "checked='checked'"; } ?> > Yes
						</label>
						<label class="radio-inline" for="non_compliant2">
							<input class="validation" data-validation="default" type="radio" id="non_compliant2" name="flagDG12" value="T" <?php if($flagDG12=='T'){ echo "checked='checked'"; } ?> > No
						</label>
					</div>
				</div>
				</div>
				</div>
				<hr>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="date_issc">Date of expiry of the ISSC</label>
					<div class="col-md-8">
						<input type="text" id="date_issc" name="tarikhLuputISSC" value="<?php echo change_blank($tarikhLuputISSC,'','00-00-0000');?>" class="form-control input-datepicker validation" data-validation="default" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="auth_issc">Name of issuing authority for the ISSC</label>
					<div class="col-md-8">
						<input type="text" id="auth_issc" name="ISSCAuthority" value="<?php echo $ISSCAuthority;?>" class="form-control validation" data-validation="default">
					</div>
				</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="crew">Current Security Level of the ship <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<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">Submit</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();
				}
			?>

$("#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_info.php