One Hat Cyber Team

View File Name : other_part_20201219.php

<?php if(empty($page)){ include("../access.php"); } ?>
<?php  
	$modal_name 	= str_replace("/", "-", $page);
	$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,"APPLICATION UPDATE (OTHER)");
			}else{
				$sql 	 		= "	UPDATE 
										permohonan_main 
									SET 
										flagSecurityMeasures = ?,
										catatanSecurityMeasures = ?,
										latitude = ?,
										longitude = ?,
										ETA = ?,
										namaMaster = ?,
										flagDG = ?
									WHERE 
										idPermohonan = ?";
				$param_type 	= "ssssssss";
				$param_data 	= array(
									"flagSecurityMeasures" 		=> $_POST['flagSecurityMeasures'],
									"catatanSecurityMeasures" 	=> $_POST['catatanSecurityMeasures'],
									"latitude" 					=> str_replace("\"", "\\"."\"", $_POST['latitude']),
									"longitude" 				=> str_replace("\"", "\\"."\"", $_POST['longitude']),
									"ETA" 						=> change_date($_POST['ETA'],'Y-m-d')." ".$_POST['ETA_time'],
									"namaMaster" 				=> $_POST['namaMaster'],
									"flagDG" 					=> $_POST['flagDG'],
									"idPermohonan" 				=> $ii
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"APPLICATION UPDATE (OTHER)");
			}

		}

		$success 	= 1;

	endif;

	if($success){
		if($do=="submit_me")
			echo "<script>window.location.replace('index.php?page=edg/main&np=edg/other_part&ii={$ii}');</script>";
		else{
			if($_POST['flagDG'] == 'Y')
				echo "<script>window.location.replace('index.php?page=edg/main&np=edg/dg&ii={$ii}');</script>";
			else
				echo "<script>window.location.replace('index.php?page=edg/main&np=edg/other_part&ii={$ii}');</script>";
		}
		exit();
	}
	
	if($ii > 0){
		
		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							idPermohonan,
							flagSecurityMeasures, 
							catatanSecurityMeasures, 
							latitude, 
							longitude, 
							DATE_FORMAT(ETA,'%d-%m-%Y') AS ETA, 
							DATE_FORMAT(ETA,'%H:%i:%s') AS ETA_time, 
							namaMaster, 
							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();

		$flagSecurityMeasures 		= $row['flagSecurityMeasures'];
		$catatanSecurityMeasures 	= $row['catatanSecurityMeasures'];
		$latitude 					= $row['latitude'];
		$longitude 					= $row['longitude'];
		$ETA 						= $row['ETA'];
		$ETA_time 					= $row['ETA_time'];
		$namaMaster 				= $row['namaMaster'];
		$flagDG 					= $row['flagDG'];
		$idApproveMFSO 				= $row['idApproveMFSO'];
		$idApproveDG 				= $row['idApproveDG'];
		$idApproveMTSO 				= $row['idApproveMTSO'];
		$commentsMFSO 				= $row['commentsMFSO'];
		$commentsDG 				= $row['commentsDG'];
		$commentsMTSO 				= $row['commentsMTSO'];
		$submit 					= $row['submit'];

		$isps 				= "";
		$isps_href 			= "index.php?page=edg/main&np=edg/isps_info&ii={$ii}";
		if($flagDG == 'Y'){
			$dis_next 			= "";
			$dg 				= "";
			$dg_href 			= "index.php?page=edg/main&np=edg/dg&ii={$ii}";

		}else{
			$dis_next 			= "disabled";
			$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 include 'tabs.php'; ?>

		<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">Where there any special or additional security measures taken during any ship/port interface or ship-to-ship activity at the ports mentioned in the last 10 ports of call?</label>
					<div class="col-md-4">
						<label class="radio-inline" for="flagSecurityMeasures1">
							<input class="validation" data-validation="default" type="radio" id="flagSecurityMeasures1" name="flagSecurityMeasures" value="Y" <?php if($flagSecurityMeasures=='Y'){ echo "checked='checked'"; } ?> > Yes
						</label>
						<label class="radio-inline" for="flagSecurityMeasures2">
							<input class="validation" data-validation="default" type="radio" id="flagSecurityMeasures2" name="flagSecurityMeasures" value="T" <?php if($flagSecurityMeasures=='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 text-primary">If YES, please give details</label>
					<div class="col-md-4">
						<textarea class="form-control" name="catatanSecurityMeasures"><?php echo $catatanSecurityMeasures; ?></textarea>
					</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="latitude">Latitude <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="latitude" name="latitude" value="<?php echo htmlspecialchars($latitude);?>" class="form-control validation" data-validation="default">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="longitude">longitude <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="longitude" name="longitude" value="<?php echo htmlspecialchars($longitude);?>" 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="ETA">Date/Time Arrival (LMT) <span class="text-danger">*</span></label>
					<div class="col-md-3">
						<input type="text" id="ETA" name="ETA" value="<?php echo change_blank($ETA,'','00-00-0000');?>" class="form-control input-datepicker validation" data-validation="default" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
					</div>
					<div class="col-md-5">
						<div class="input-group bootstrap-timepicker">
						<input type="text" id="ETA_time" name="ETA_time" value="<?php echo $ETA_time;?>"  class="form-control input-timepicker24">
						<span class="input-group-btn">
							<a href="javascript:void(0)" class="btn btn-effect-ripple btn-primary" style="overflow: hidden; position: relative;"><span class="btn-ripple animate" style="height: 38px; width: 38px; top: -6.10001px; left: 7.18335px;"></span><i class="fa fa-clock-o"></i></a>
                                </span>
						</div>
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="namaMaster">Name Of Master <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="namaMaster" name="namaMaster" value="<?php echo $namaMaster;?>" 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 text-danger">Dangerous Good On Board <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<label class="radio-inline" for="flagDG1">
							<input class="validation" data-validation="default" type="radio" id="flagDG1" name="flagDG" value="Y" <?php if($flagDG=='Y'){ echo "checked='checked'"; } ?> > Yes
						</label>
						<label class="radio-inline" for="flagDG2">
							<input class="validation" data-validation="default" type="radio" id="flagDG2" name="flagDG" value="T" <?php if($flagDG=='T'){ echo "checked='checked'"; } ?> > No
						</label>
					</div>
				</div>
				</div>
				</div>
				<!--  -->
				<hr>
				<center>
				<div class="btn-group">
				<a class="btn btn-warning" href="index.php?page=edg/main&np=edg/port_call&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(){

			$("#form-validation").setvalidation2();
			$("#form-validation").on("submit",function(){
				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 -->