One Hat Cyber Team

View File Name : isps_info_20200723.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";

	$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}'";
				$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 	 	= '',
										idApproveDG 	 	= 0,
										commentsDG 	 		= '',
										idApproveMTSO 	 	= 0,
										commentsMTSO 	 	= ''
									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 = ?,
										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){
		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($_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,
							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'];
		$flagNCPort 			= $row['flagNCPort'];
		$flagDG12 				= $row['flagDG12'];
		$tarikhLuputISSC 		= $row['tarikhLuputISSC'];
		$ISSCAuthority 			= $row['ISSCAuthority'];
		$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();
?>

	<!-- Blank Header -->
	<div class="content-header">
		<div class="row">
			<div class="col-sm-6">
				<div class="header-section">
					<!-- <h1>NEW APPLICATION</h1> -->
					<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">
					<!-- <ul class="breadcrumb breadcrumb-top"> -->
						<!-- <li>Extra Pages</li> -->
						<!-- <li><a href="">Blank</a></li> -->
					<!-- </ul> -->
				</div>
			</div>
		</div>
	</div>
	<!-- END Blank Header -->

	<!-- Get Started Block -->
	<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 }?>

		<!-- Get Started Title -->
		<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-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 <span class="text-danger">*</span></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 <span class="text-danger">*</span></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 <span class="text-danger">*</span></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">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>

<div class="row">
<div class="col-sm-6">

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();
				}
			?>

		<script src="js/pages/formsValidation.js"></script>
        <script type="text/javascript">
        $(document).ready(function(){

        	$(".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> <!-- End Started Block -->