One Hat Cyber Team

Edit File: detail.php

session_start();

include '../odbc.php';
    include '../sessions.php';

if ($_SESSION['session'])
        $session=updateSession($_SESSION["session"]);
    else
        $session='';

$path 			= $_GET['ii'];
	$target 		= $_GET['target'];

echo "<hr>";

if($target == 'ship'){

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT a.*,b.fail_issc FROM permohonan_main a LEFT JOIN kod_kapal b ON b.idKapal = a.idKapal WHERE a.idPermohonan=?");
		$stmt->bind_param("s",$permohonan_main = $path);
		$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'];
		$failissc 			= $row['fail_issc'];
		$failKrew 			= $row['failKrew'];
		$failPenumpang 		= $row['failPenumpang'];
		$list_purpose 		= explode('|', $row['otherCallPurpose']);

?>
		<div 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">
						<?php 
							$sqlx 	= "SELECT * FROM kod_kapal";
							$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
						?>
						<select class="form-control" id="vessel" disabled="disabled">
							<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>
							<optgroup label="Pending Approval">
							<option value="<?php echo $aa['idKapal']; ?>" disabled="disabled">AHMG COMPANY ASW</option>
							</optgroup>
							<?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="issc">ISSC No</label>
					<div class="col-md-8">
						<input type="text" id="issc" readonly="readonly" name="issc" class="form-control">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="issc_auth">ISSC Issuing Authority</label>
					<div class="col-md-8">
						<input type="text" id="issc_auth" readonly="readonly" name="issc_auth" 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="issc_date">ISSC Expiry Date</label>
					<div class="col-md-8">
						<input type="text" id="issc_date" readonly="readonly" name="issc_date" class="form-control">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="issc_file">ISSC File <span class="text-danger">*</span></label>
					<div class="col-md-8">
					<?php if(!empty($failissc)){ ?>
						<a href="<?php echo "upload/vessel/{$idKapal}/{$failissc}";?>" target="_blank" class="up2 form-control issc_file" style="cursor: pointer;">
							Click To Open<i class="fa fa-download pull-right" style="line-height: 1.42857143"></i>
						</a>
					<?php }else{ echo "<div class='form-control'><i class='text-danger'>No Document Attach</i></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="mmsi">MMSI</label>
					<div class="col-md-8">
						<input type="text" id="mmsi" readonly="readonly" name="mmsi" 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">SCN</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-2">
						<input type="text" id="crew" readonly="readonly" name="crew" value="<?php echo $bilKrew; ?>" class="form-control">
					</div>
					<div class="col-md-6">
					<?php if(!empty($failKrew)){ ?>
						<a href="<?php echo "upload/application/{$path}/{$failKrew}";?>" target="_blank" class="up2 form-control" style="cursor: pointer;">
							Click To Open<i class="fa fa-download pull-right" style="line-height: 1.42857143"></i>
						</a>
					<?php }else{ echo "<div class='form-control'><i class='text-danger'>No Document Attach</i></div>";}?>
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="passenger">No Of Passenger <span class="text-danger">*</span></label>
					<div class="col-md-2">
						<input type="text" id="passenger" readonly="readonly" name="passenger" value="<?php echo $bilPenumpang; ?>" class="form-control">
					</div>
					<div class="col-md-6">
					<?php if(!empty($failPenumpang)){ ?>
						<a href="<?php echo "upload/application/{$path}/{$failPenumpang}";?>" target="_blank" class="up2 form-control" style="cursor: pointer;">
							Click To Open<i class="fa fa-download pull-right" style="line-height: 1.42857143"></i>
						</a>
					<?php }else{ echo "<div class='form-control'><i class='text-danger'>No Document Attach</i></div>";}?>
					</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</label>
					<div class="col-md-8">
						<input type="text" id="gt" readonly="readonly" name="gt" class="form-control">
						
					</div>
				</div>
				</div>
				
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="voyage">Voyage No. </label>
					<div class="col-md-8">
						<input type="text" id="voyage" readonly="readonly" name="voyage" value="<?php echo $noVoyage; ?>" class="form-control" 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="purpose">Purpose Of Call <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<?php 
							$stmt  			= $mysqli->stmt_init();
							$stmt->prepare("SELECT idCallPurpose,nama FROM kod_call_purpose WHERE flagAktif = 'Y' ");
							$stmt->execute();
							$result 		= $stmt->get_result();
							$stmt->close();
							$v_list 	= "";
							while($ax = $result->fetch_assoc()){
								if (in_array($ax['idCallPurpose'], $list_purpose))
									$v_list 	.= $ax['nama'].",";
							}
						?>
						<input type="text" id="example-tags" name="example-tags" class="input-tags other_purpose" value="<?php echo $v_list;?>">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="cargo">Cargo <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<textarea class="form-control" readonly="readonly" data-validation="default" rows="3" name="cargo"><?php echo $cargo2discharge; ?></textarea>
					</div>
				</div>
				</div>
				</div>
				
		</div>

<?php }else if($target == 'isps'){

$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 = $path);
		$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'];

?>
<div 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" disabled="disabled" id="idMarineFacility">
							<option value="">-- No Defined --</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">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($flagISSC == 'Y') ? 'Yes' : 'No' ?>">
					</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">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo $securityLevel; ?>">
					</div>
				</div>
				</div>
				</div>
				
<?php }else if($target == 'port'){

$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.kod,
							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 = $path);
		$stmt->execute();

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

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

<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<thead>
						<tr>
							<th class="text-center" style="width: 40px;">NO</th>
							<th>PORT</th>
							<th class="text-center">ARRIVAL DATE</th>
							<th class="text-center" style="width: 100px;">DEPARTURE DATE</th>
							<th class="text-center" style="width: 100px;">SECURITY LEVEL</th>
						</tr>
					</thead>
					<tbody>
					<?php

$i=1;
						while($aa = $result2->fetch_assoc()){

$editdata = "idPelabuhan#{$aa['idPelabuhan']}|"
										."tarikhTiba#{$aa['tarikhTiba']}|"
										."tarikhBerlepas#{$aa['tarikhBerlepas']}|"
										."securityLevel#{$aa['securityLevel']}|"
										."val-id#{$aa['idPP']}";
						
					?>
						<tr>
							<td class="text-right"><?php echo $i++; ?>.</td>
							<td><?php echo $aa['nama']?></td>
							<td class="text-center"><?php echo $aa['tarikhTiba']?></td>
							<td class="text-center"><?php echo $aa['tarikhBerlepas']?></td>
							<td class="text-center"><?php echo $aa['securityLevel']?></td>
						</tr>
					<?php }	
						mysqli_free_result($resKod); 
					?>
					</tbody>
					<tbody>
					<?php 
						echo "<tr><td class='text-right'>{$i}.</td><td class='text-left text-warning' colspan='4'>N/A</td></tr>";
						for ($i=$i; $i <= 10; $i++) { 
							// if($i == 9)
								// echo "<tr><td class='text-right'></td><td class='text-right'>".($i+1).".</td><td class='text-left text-warning' colspan='6'>N/A</td></tr>";
							// else
								echo "<tr><td class='text-right'>{$i}.</td><td class='text-left text-warning' colspan='4'>N/A</td></tr>";
						}
					?>
					</tbody>
				</table>
<?php }else if($target == 'part'){

$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
						FROM 
							permohonan_main 
						WHERE 
							idPermohonan=?
						");
		$stmt->bind_param("s",$permohonan_main = $path);
		$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'];

?>
			<div 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">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($flagSecurityMeasures == 'Y') ? 'Yes' : 'No' ?>">
					</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 readonly="readonly" class="form-control" name="catatanSecurityMeasures"><?php echo $catatanSecurityMeasures; ?></textarea>
					</div>
				</div>
				</div>
				</div>
				
				<hr>
				
		<div class="row">
			<div class="col-md-12">
				<div class="form-group">
					<label class="col-md-2 control-label" for="latitude">Latitude <span class="text-danger">*</span></label>					
					<div class="col-md-2">
						<div class="input-group">
						<input type="text" id="latitude" readonly="readonly" name="lat1" value="<?php echo htmlspecialchars($lat1);?>" class="form-control validation" data-validation="default">
                        <span class="input-group-addon"><strong>°</strong></span>
                        </div>
					</div>
					<div class="col-md-2">
						<div class="input-group">
						<input type="text" id="latitude" readonly="readonly" name="lat2" value="<?php echo htmlspecialchars($lat2);?>" class="form-control validation" data-validation="default">
                        <span class="input-group-addon"><strong>'</strong></span>
                        </div>
					</div>
					<div class="col-md-2">
						<div class="input-group">
						<input type="text" id="latitude" readonly="readonly" name="lat3" value="<?php echo htmlspecialchars($lat3);?>" class="form-control validation" data-validation="default">
                        <span class="input-group-addon"><strong>"</strong></span>
                        </div>
					</div>
					<div class="col-md-2" style="width: 10%;">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($lat4 == 'N') ? 'N' : 'S' ?>">
					</div>														
				</div>
			</div>
		</div>

<div class="row">
			<div class="col-md-12">
				<div class="form-group">
					<label class="col-md-2 control-label" for="longitude">Longitude <span class="text-danger">*</span></label>					
					<div class="col-md-2">
						<div class="input-group">
						<input type="text" id="latitude" readonly="readonly" name="long1" value="<?php echo htmlspecialchars($long1);?>" class="form-control validation" data-validation="default">
                        <span class="input-group-addon"><strong>°</strong></span>
                        </div>
					</div>
					<div class="col-md-2">
						<div class="input-group">
						<input type="text" id="latitude" readonly="readonly" name="long2" value="<?php echo htmlspecialchars($long2);?>" class="form-control validation" data-validation="default">
                        <span class="input-group-addon"><strong>'</strong></span>
                        </div>
					</div>
					<div class="col-md-2">
						<div class="input-group">
						<input type="text" id="latitude" readonly="readonly" name="long3" value="<?php echo htmlspecialchars($long3);?>" class="form-control validation" data-validation="default">
                        <span class="input-group-addon"><strong>"</strong></span>
                        </div>
					</div>
					<div class="col-md-2" style="width: 10%;">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($lat4 == 'E') ? 'E' : 'W' ?>">
					</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-4">
						<input type="text" id="ETA" readonly="readonly" name="ETA" value="<?php echo change_blank($ETA,'','00-00-0000');?>" class="form-control input-datepicker" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
					</div>
					<div class="col-md-4">
						<input type="text" id="ETA_time" readonly="readonly" name="ETA_time" value="<?php echo $ETA_time;?>"  class="form-control input-timepicker24">
					</div>
				</div>
				</div>
				</div>

<div class="row">
				<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" readonly="readonly" name="namaMaster" value="<?php echo $namaMaster;?>" class="form-control" >
					</div>
				</div>
				</div>
				</div>

<div class="row">
				<div class="col-md-10 col-md-offset-1 alert alert-danger">
				<div class="form-group ">
					<h2>
					<label class="col-md-7 control-label">Dangerous Good On Board? *</label>
					<label class="col-md-5 control-label" style="text-align: left">
						: <?php echo ($flagDG == 'Y') ? 'Yes' : 'No' ?>
						
					</label>
					</h2>
				</div>
				</div>
				</div>
			</div>
<?php }else if($target == 'upload'){

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							idPL,
							namaFail,
							keterengan
						FROM 
							permohonan_lampiran 
						WHERE 
							idPermohonanMain=?
						");
		$stmt->bind_param("s",$permohonan_main = $path);
		$stmt->execute();

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

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

<table class="table table-striped table-bordered table-condensed table-vcenter table-hover">
	<thead>
		<tr>
			<th width="20px">No.</th>
			<th>File</th>
		</tr>
	</thead>
	<tbody>
	<?php 
		$i=1;
		while($aa = $result2->fetch_assoc()){ 
			$link 	= "upload/{$ii}/".$aa['namaFail'];
	?>
		<tr>
			<td class="text-right"><?php echo $i++?>.</td>
			<td><a href="<?php echo $link; ?>" target="new"><?php echo $aa['keterengan']; ?></a></td>
		</tr>
	<?php }?>
	</tbody>
</table>

<?php }else if($target == 'dg'){

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							a.idPDG,
							a.idPermohonanMain,	
							a.idKodDG,	
							a.idOpsType,	
							a.idPortLoading,	
							a.idPortDischarging,	
							a.flashPoint,	
							a.comments,	
							a.typeofdg,
							b.nama AS nama_operation,
							c.UNNumber, 	
							c.IMOClass, 	
							c.nama AS nama_dg, 	
							c.KPAGroup, 	
							c.properties, 
							d.nama AS port_loading,
							e.nama AS port_discharge
						FROM 
							permohonan_dg a 
						LEFT JOIN 
							kod_operation_type b ON b.idOpsType = a.idOpsType
						LEFT JOIN 
							kod_dg c ON c.idKodDG = a.idKodDG
						LEFT JOIN 
							kod_pelabuhan d ON d.idPelabuhan = a.idPortLoading
						LEFT JOIN 
							kod_pelabuhan e ON e.idPelabuhan = a.idPortDischarging
						WHERE 
							a.idPermohonanMain=?
						");
		$stmt->bind_param("s",$permohonan_main = $path);
		$stmt->execute();

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

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

<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<thead>
						<tr>
							<th class="text-center no_sorting" style="width: 30px;">NO</th>
							<th class="text-left">Dangerous of Goods</th>
						</tr>
					</thead>
					<tbody>
					<?php

$i=1;
						while($aa = $result2->fetch_assoc()){

$editdata = "idKodDG#{$aa['idKodDG']}|"
										."stow_position#{$aa['stow_position']}|"
										."ref_num#{$aa['ref_num']}|"
										."marks_number#{$aa['marks_number']}|"
										."pack_group#{$aa['pack_group']}|"
										."add_info#{$aa['add_info']}|"
										."package#{$aa['package']}|"
										."unit#{$aa['unit']}|"
										."ems#{$aa['ems']}|"
										."idKodDG#{$aa['idKodDG']}|"
										."idOpsType#{$aa['idOpsType']}|"
										."idPortLoading#{$aa['idPortLoading']}|"
										."idPortDischarging#{$aa['idPortDischarging']}|"
										."flashPoint#{$aa['flashPoint']}|"
										."comments#{$aa['comments']}|"
										."typeofdg#{$aa['typeofdg']}|"
										."val-id#{$aa['idPDG']}";

$typebtn = ($aa['typeofdg'] == 1) ? "Add Package Form" : "Add Precise Stowage" ;

if($aa['typeofdg'] == 1 ):

$stmt  			= $mysqli->stmt_init();
								$stmt->prepare("SELECT
													a.idDGPackage,
													a.idPDG, 	
													a.CTUID, 	
													a.weight, 	
													a.idWeight, 	
													a.idCTUType, 	
													a.idPackingType, 	
													a.idDimension, 	
													a.CTUTeus, 	
													DATE_FORMAT(a.lorryETA,'%d-%m-%Y') AS lorryETA, 
													DATE_FORMAT(a.lorryETA,'%H:%i:%s') AS lorryETA_time, 
													a.lorryPlateNo, 	
													a.lorryCompany,
													b.nama AS nama_weight,
													c.nama AS nama_ctu_type,
													d.nama AS nama_packing,
													e.nama AS nama_dimension
												FROM 
													permohonan_dg_package a 
												LEFT JOIN 
													kod_weight b ON b.idWeight = a.idWeight
												LEFT JOIN 
													kod_ctu_type c ON c.idCTUType = a.idCTUType
												LEFT JOIN 
													kod_packing_type d ON d.idPackingType = a.idPackingType
												LEFT JOIN 
													kod_dimension e ON e.idDimension = a.idDimension
												WHERE 
													a.idPDG=?
												");
								$stmt->bind_param("s",$permohonan_main = $aa['idPDG']);
								$stmt->execute();

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

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

else:
								
								$stmt  			= $mysqli->stmt_init();
								$stmt->prepare("SELECT
													a.idDGBulk,
													a.idPDG, 	
													a.holdNumber, 	
													a.weight, 	
													a.idWeight, 
													DATE_FORMAT(a.lorryETA,'%d-%m-%Y') AS lorryETA, 
													DATE_FORMAT(a.lorryETA,'%H:%i:%s') AS lorryETA_time, 
													a.lorryPlateNo, 	
													a.lorryCompany,
													b.nama AS nama_weight
												FROM 
													permohonan_dg_bulk a 
												LEFT JOIN 
													kod_weight b ON b.idWeight = a.idWeight
												WHERE 
													a.idPDG=?
												");
								$stmt->bind_param("s",$permohonan_main = $aa['idPDG']);
								$stmt->execute();

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

$result3 		= $stmt->get_result();
								$stmt->close();
								
							endif;

?>
						<tr>
							<td class="text-center align-top"><?php echo $i++; ?></td>
							<td style="padding: 5px;background: grey">
								<table class="table table-bordered table-striped" width="100%" style="margin:0px">
									<tr>
										<td width="50%">
											<span class="text-primary text-table-1">
												Stowage Position
											</span>
										</td>
										<td width="50%">
											<span class="text-primary text-table-1">
												Reference Number
											</span>
										</td>
									</tr>
									<tr>
										<td>
											<?php echo change_blank($aa['stow_position'],"-"); ?>
										</td>
										<td>
											<?php echo change_blank($aa['ref_num'],"-"); ?>
										</td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Marks & Numbers
											</span>
										</td>
										<td>
											<span class="text-primary text-table-1">
												UN Number
											</span>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['marks_number'],"-"); ?></td>
										<td><?php echo change_blank($aa['UNNumber'],"-"); ?></td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Proper Shipping Name
											</span>
										</td>
										<td>
											<span class="text-primary text-table-1">
												Class
											</span>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['nama_dg'],"-"); ?></td>
										<td><?php echo change_blank($aa['IMOClass'],"-"); ?></td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Packing Group
											</span>
										</td>
										<td>
											<span class="text-primary text-table-1">
												Additional Information/Marine Pollutant/Flash point/etc
											</span>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['pack_group'],"-"); ?></td>
										<td><?php echo change_blank($aa['add_info'],"-"); ?></td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Mass (kg) or Volume (L)
											</span>
										</td>
										<td>
											<span class="text-primary text-table-1">
												EmS
											</span>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['unit'],"-"); ?></td>
										<td><?php echo change_blank($aa['ems'],"-"); ?></td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Comment
											</span>
										</td>
										<td>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['comments'],"-"); ?></td>
										<td>&nbsp;</td>
									</tr>
								</table>
								
							</td>
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>

<? } ?>