One Hat Cyber Team

Edit File: ship_particular.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 			= (!empty($_GET['ii'])) ? $_GET['ii'] : 0 ;
	$dis_next 		= ($ii>0) ? $ii : "disabled" ;
	$success 	 	= 0;
	$type_submit 	= "add";
	if($_POST):

$do 	= $_POST['type_submit'];

if($do=="add"){

$sql 	 		= "	INSERT INTO 
								kod_kapal (
									nama,
									idSyarikat,
									idJenisKapal,
									IMO,
									ISSC,
									Flag,
									CallSign,
									idUserApply,
									tarikhApply
								) VALUES (
									?,
									?,
									?,
									?,
									?,
									?,
									?,
									?,
									NOW()
								)";
			$param_type 	= "ssssssss";
			$param_data 	= array(
								"nama" 			=> $_POST['nama'],
								"idSyarikat" 	=> $_POST['idSyarikat'],
								"idJenisKapal" 	=> $_POST['idJenisKapal'],
								"IMO" 			=> $_POST['IMO'],
								"ISSC" 			=> $_POST['ISSC'],
								"Flag" 			=> $_POST['Flag'],
								"CallSign" 		=> $_POST['CallSign'],
								"idUserApply" 	=> $user['idUser']
							 	);
			$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);

$success 	= 1;
			$msg 		= "RECORD ADDED!";

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

}else{

if($ii > 0){

$sql 	 		= "UPDATE 
										permohonan_main 
									SET 
										idKapal 	 		= ?,
										bilKrew 	 		= ?,
										bilPenumpang 		= ?,
										GT 	 				= ?,
										noSCN 				= ?,
										noVoyage 	 		= ?,
										idCallPurpose 		= ?,
										otherCallPurpose 	= ?,
										cargo2discharge 	= ?
									WHERE 
										idPermohonan = ?";
				$param_type 	= "ssssssssss";
				$param_data 	= array(
									"idKapal" 			=> $_POST['vessel'],
									"bilKrew" 			=> $_POST['crew'],
									"bilPenumpang" 		=> $_POST['passanger'],
									"GT" 				=> $_POST['gt'],
									"noSCN" 			=> $_POST['scn'],
									"noVoyage" 			=> $_POST['voyage'],
									"idCallPurpose" 	=> $_POST['purpose'],
									"otherCallPurpose" 	=> $_POST['other_purpose'],
									"cargo2discharge" 	=> $_POST['cargo'],
									"idPermohonan" 		=> $ii
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);
				$last_id 	= $data[0];

}else{

$stmt  			= $mysqli->stmt_init();
				$stmt->prepare("SELECT refID FROM permohonan_main where SUBSTR(refID, 1, 6) = DATE_FORMAT(NOW(), '%Y%m') ORDER BY idPermohonan DESC");
				$stmt->execute();
				$result 		= $stmt->get_result();
				$stmt->close();

$session 	= array();
				$row=$result->fetch_assoc();
				if($row){
					$refID 	= $row['refID']+1;
				}else{
					$refID 	= 0;
				}

$sql 	 		= "INSERT INTO permohonan_main (refID, idUserApply, idKapal, bilKrew, bilPenumpang, GT, noSCN, noVoyage, idCallPurpose, otherCallPurpose, cargo2discharge) values (?,?,?,?,?,?,?,?,?,?,?)";
				$param_type 	= "sssssssssss";
				$param_data 	= array(
									"refID" 			=> $refID,
									"idUserApply" 		=> $user['idUser'],
									"idKapal" 			=> $_POST['vessel'],
									"bilKrew" 			=> $_POST['crew'],
									"bilPenumpang" 		=> $_POST['passanger'],
									"GT" 				=> $_POST['gt'],
									"noSCN" 			=> $_POST['scn'],
									"noVoyage" 			=> $_POST['voyage'],
									"idCallPurpose" 	=> $_POST['purpose'],
									"otherCallPurpose" 	=> $_POST['other_purpose'],
									"cargo2discharge" 	=> $_POST['cargo']
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);
				$last_id 	= $data[0];
			}
		
			$success 	= 1;

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

}

// 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($_GET['ii'] > 0){
		
		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT * FROM permohonan_main WHERE idPermohonan=?");
		$stmt->bind_param("s",$permohonan_main = $ii);
		$stmt->execute();
		$result 		= $stmt->get_result();
		$stmt->close();

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

$idKapal 			= $row['idKapal'];
		$bilKrew 			= $row['bilKrew'];
		$bilPenumpang 		= $row['bilPenumpang'];
		$GT 				= $row['GT'];
		$noSCN 				= $row['noSCN'];
		$noVoyage 			= $row['noVoyage'];
		$idCallPurpose 		= $row['idCallPurpose'];
		$otherCallPurpose 	= $row['otherCallPurpose'];
		$cargo2discharge 	= $row['cargo2discharge'];
		$idMarineFacility 	= $row['idMarineFacility'];
		
		$isps 				= "";
		$isps_href 			= "index.php?page=edg/main&np=edg/isps_info&ii={$ii}";

if(!empty($idMarineFacility)){
			$port 				= "";
			$port_href 			= "index.php?page=edg/main&np=edg/port_call&ii={$ii}";
		}else{
			$port 				= "disabled";
			$port_href 			= "javascript:void(0)";
		}

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							a.idPP,
							a.idPermohonanMain,
							a.idPelabuhan,
							DATE_FORMAT(a.tarikhTiba,'%d-%m-%Y') AS tarikhTiba,
							DATE_FORMAT(a.tarikhBerlepas,'%d-%m-%Y') AS tarikhBerlepas,
							a.securityLevel,
							b.nama,
							b.hadMasa
						FROM 
							permohonan_pelabuhan a 
						LEFT JOIN 
							kod_pelabuhan b ON b.idPelabuhan = a.idPelabuhan
						WHERE 
							a.idPermohonanMain=?
						");
		$stmt->bind_param("s",$permohonan_main = $ii);
		$stmt->execute();

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

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

if($result2->num_rows && !empty($idMarineFacility)){

$part 				= "";
			$part_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{
			$part 				= "disabled";
			$part_href 			= "javascript:void(0)";
			$upload 			= "disabled";
			$upload_href 		= "javascript:void(0)";
			$dg 				= "disabled";
			$dg_href 			= "javascript:void(0)";
		}

// $stmt  			= $mysqli->stmt_init();
		// $stmt->prepare("SELECT * FROM permohonan_pelabuhan WHERE idPermohonanMain=?");
		// $stmt->bind_param("s",$idPermohonanMain = $ii);
		// $stmt->execute();
		// $result 		= $stmt->get_result();
		// $stmt->close();

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

}else{

$idKapal 			= "";
		$bilKrew 			= "";
		$bilPenumpang 		= "";
		$GT 				= "";
		$noSCN 				= "";
		$noVoyage 			= "";
		$idCallPurpose 		= "";
		$otherCallPurpose 	= "";
		$cargo2discharge 	= "";

$isps 				= "disabled";
		$isps_href 			= "javascript:void(0)";
		$port 				= "disabled";
		$port_href 			= "javascript:void(0)";
		$part 				= "disabled";
		$part_href 			= "javascript:void(0)";
		$upload 			= "disabled";
		$upload_href 		= "javascript:void(0)";
		$dg 				= "disabled";
		$dg_href 			= "javascript:void(0)";

}

// $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="active"><a href="javascript:void(0)">Ship Particular</a></li>
				<li class="<?php echo $isps;?>"><a href="<?php echo $isps_href; ?>">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 $part;?>"><a href="<?php echo $part_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 id="modal-form" class="modal fade <?php echo $modal_name;?>" tabindex="-1" role="dialog" aria-hidden="true">
				<div class="modal-dialog modal-md">
					<div class="modal-content">

<form class="push form-horizontal" id="form-validation2" action="index.php?page=edg/main&np=edg/ship_particular&ii=<?php echo $ii;?>" method="post">

<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span aria-hidden="true">&times;</span></button>
							<h4 class="modal-title"><strong>Apply For New Vessel</strong></h4>
						</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="idSyarikat">Company <span class="text-danger">*</span></label>
							    <div class="col-md-6">
								<?php 
									$sqlx 	= "SELECT * FROM kod_syarikat WHERE flagAktif = 'Y' AND flagApprove = 'Y' ORDER BY nama";
									$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
								?>
								<select class="form-control select-select2 validation" data-validation="default" name="idSyarikat" id="idSyarikat">
									<option value="">-- Please select --</option>
									<?php while($aa = $rstx->fetch_assoc()){ ?>
									<option value="<?php echo $aa['idSyarikat']; ?>" ><?php echo $aa['nama']; ?></option>
									<?php 	}?>
								</select>
							    </div>
							</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="idJenisKapal">Vessel Type <span class="text-danger">*</span></label>
							    <div class="col-md-6">
								<?php 
									$sqlx 	= "SELECT * FROM kod_jenis_kapal 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="idJenisKapal" id="idJenisKapal">
									<option value="">-- Please select --</option>
									<?php while($aa = $rstx->fetch_assoc()){ ?>
									<option value="<?php echo $aa['idJenisKapal']; ?>" ><?php echo $aa['nama']; ?></option>
									<?php 	}?>
								</select>
							    </div>
							</div>

</div>

<div class="modal-footer">
						
						<button type="submit" class="btn btn-effect-ripple btn-primary">Submit</button>
						<button type="button" class="btn btn-effect-ripple btn-danger" data-dismiss="modal">Close</button>
						</div>
					</form>

</div>
				</div>
			</div>

<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" for="vessel">Name Of Ship <span class="text-danger">*</span></label>
					    <div class="col-md-8">
						<div class="input-group">
						<?php 
							$sqlx 	= "SELECT * FROM kod_kapal WHERE flagAktif = 'Y' AND flagApprove = 'Y'";
							$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));

$sqly 	= "SELECT * FROM kod_kapal WHERE flagAktif = 'Y' AND flagApprove = 'T'";
							$rsty 	= $mysqli->query($sqly) or die(mysqli_error($mysqli));
						?>
						<select class="form-control select-select2 validation" data-validation="default" name="vessel" id="vessel">
							<option value="">-- Choose a Vessel --</option>
							<?php while($aa = $rstx->fetch_assoc()){ ?>
							<option value="<?php echo $aa['idKapal']; ?>" <?php if($aa['idKapal'] == $idKapal){ echo "selected='selected'";} ?> ><?php echo $aa['nama']; ?></option>
							<?php 	}?>
							<optgroup label="Pending Approval">
							<?php while($aa = $rsty->fetch_assoc()){ ?>
							<option value="<?php echo $aa['idKapal']; ?>" <?php if($aa['idKapal'] == $idKapal){ echo "selected='selected'";} ?> disabled='disabled' ><?php echo $aa['nama']; ?></option>
							<?php 	}?>
						</select>

<span class="input-group-btn add-me" data-toggle="tooltip" data-original-title="Add New Vessel" data-modal-target="<?php echo $modal_name;?>">
						<span class="btn btn-effect-ripple btn-primary" style="overflow: hidden; position: relative;"><i class="fa fa-plus"></i></span>
						</span>
						</div>
					    </div>
					</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="imo">IMO</label>
					<div class="col-md-8">
						<input type="text" id="imo" readonly="readonly" name="imo" class="form-control">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="issc">ISSC</label>
					<div class="col-md-8">
						<input type="text" id="issc" readonly="readonly" name="issc" class="form-control">
					</div>
				</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="nama_syarikat">Company Name</label>
					<div class="col-md-8">
						<input type="text" id="nama_syarikat" readonly="readonly" name="nama_syarikat" class="form-control">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="flag">Flag</label>
					<div class="col-md-8">
						<input type="text" id="flag" readonly="readonly" name="flag" class="form-control">
					</div>
				</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="callsign">Call Sign</label>
					<div class="col-md-8">
						<input type="text" id="callsign" readonly="readonly" name="callsign" class="form-control">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="nama_jeniskapal">Vessel Type</label>
					<div class="col-md-8">
						<input type="text" id="nama_jeniskapal" readonly="readonly" name="nama_jeniskapal" class="form-control">
					</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">No Of Crew <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="crew" name="crew" value="<?php echo $bilKrew; ?>" class="form-control validation" data-validation="default_digit">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="passanger">No Of Passenger <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="passanger" name="passanger" value="<?php echo $bilPenumpang; ?>" class="form-control validation" data-validation="default_digit">
					</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="gt">GT <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="gt" name="gt" value="<?php echo $GT; ?>" 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="scn">SCN. No. <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="scn" name="scn" value="<?php echo $noSCN; ?>" 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="voyage">Voyage No. <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="voyage" name="voyage" value="<?php echo $noVoyage; ?>" 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="purpose">Purpose Of Call <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<?php 
							$sqlx 	= "SELECT * FROM kod_call_purpose";
							$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
						?>
						<select class="form-control select-select2 validation" data-validation="default" name="purpose" id="purpose">
							<option value="">-- Please Select --</option>
							<?php while($aa = $rstx->fetch_assoc()){ ?>
							<option value="<?php echo $aa['idCallPurpose']; ?>" <?php if($aa['idCallPurpose'] == $idCallPurpose){ echo "selected='selected'";} ?> ><?php echo $aa['nama']; ?></option>
							<?php 	}?>
						</select>
					</div>
				</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="other_purpose">Other Purpose Of Call <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="other_purpose" name="other_purpose" value="<?php echo $otherCallPurpose; ?>" 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="cargo">Cargo To Discharge <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="cargo" name="cargo" value="<?php echo $cargo2discharge; ?>" class="form-control validation" data-validation="default">
					</div>
				</div>
				</div>
				</div>
				
				<hr>
				<center>
				<div class="btn-group">
				<a class="btn btn-warning disabled"><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>

// $(this).trigger("resize");
			$(document).on("click", ".add-me", function(){
				var modal_name 	= "."+$(this).data("modal-target");
				$(modal_name).modal({keyboard:true});
				$(modal_name).find("input").not(":button, :submit, :reset, .not_autoset").val("").prop("checked",false);
				$(modal_name).find(".default_radio, .default_checkbox").prop("checked",true);
				$(modal_name).find("select").children("option").prop("selected",false).trigger("change");				
				$(modal_name).find('.help-block').remove();
				$(modal_name).find('.form-group').removeClass('has-success has-error');
				$("#form-validation2").setvalidation('');
				$("#form-validation2 > [name='type_submit']").val("add");
				// console.log($._data($("#form-validation").get(0), "events"));
			});

$("#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("");
						}
					}
				});
        	});

$("#form-validation").find("select").trigger("change");
        });

</script>
	</div>