One Hat Cyber Team

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

	if($target == 'ship'){ 

		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT * FROM permohonan_main WHERE 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'];

?>
		<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="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" readonly="readonly" value="<?php echo $bilKrew; ?>" class="form-control">
					</div>
				</div>
				</div>
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="passanger">No Of Passanger <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" id="passanger" class="form-control" readonly="readonly" value="<?php echo $bilPenumpang; ?>">
					</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" class="form-control" readonly="readonly" value="<?php echo $GT; ?>">
					</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" class="form-control" readonly="readonly" value="<?php echo $noSCN; ?>">
					</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" class="form-control" readonly="readonly" value="<?php echo $noVoyage; ?>">
					</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 disabled" disabled="disabled" 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" value="<?php echo $otherCallPurpose; ?>" class="form-control"  readonly="readonly">
					</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" value="<?php echo $cargo2discharge; ?>" class="form-control"  readonly="readonly">
					</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-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" 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>
				</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">
						<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">Does your compliant ship arrives from non compliant port?</label>
					<div class="col-md-4">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($flagNCPort == '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">Does your ship non compliant ISPS Code andd carrying DG class 1 &amp; 2?</label>
					<div class="col-md-4">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($flagDG12 == 'Y') ? 'Yes' : 'No' ?>">
					</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" readonly="readonly" id="date_issc" value="<?php echo $tarikhLuputISSC;?>" class="form-control" >
					</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" readonly="readonly" id="auth_issc" value="<?php echo $ISSCAuthority;?>" 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">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>
				<!--  -->
			</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" style="width: 150px;">ARRIVAL DATE</th>
							<th class="text-center" style="width: 150px;">DEPARTURE DATE</th>
							<th class="text-center" style="width: 150px;">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-center"><?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>
				</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 class="form-control" readonly="readonly" ><?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" readonly="readonly" value="<?php echo $latitude;?>" class="form-control" >
					</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" readonly="readonly" value="<?php echo $longitude;?>" class="form-control validation" >
					</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" value="<?php echo $ETA;?>" class="form-control">
					</div>
					<div class="col-md-4">
						<div class="input-group">
						<input type="text" id="ETA_time" readonly="readonly" value="<?php echo $ETA_time;?>"  class="form-control">
						<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" readonly="readonly" value="<?php echo $namaMaster;?>" 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 text-danger">Dangerous Good On Board <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<input type="text" readonly="readonly" class="form-control" value="<?php echo ($flagDG == 'Y') ? 'Yes' : 'No' ?>">
					</div>
				</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']}|"
										."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">
												Proper Name
											</span>
										</td>
										<td width="50%">
											<span class="text-primary text-table-1">
												Operation Type
											</span>
										</td>
									</tr>
									<tr>
										<td>
											<?php echo change_blank($aa['nama_dg'],"-"); ?>
										</td>
										<td>
											<?php echo change_blank($aa['nama_operation'],"-"); ?>
										</td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Loading Port
											</span>
										</td>
										<td>
											<span class="text-primary text-table-1">
												Discharging Port
											</span>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['port_loading'],"-"); ?></td>
										<td><?php echo change_blank($aa['port_discharge'],"-"); ?></td>
									</tr>
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Flash Point
											</span>
										</td>
										<td>
											<span class="text-primary text-table-1">
												Total Weight
											</span>
										</td>
									</tr>
									<tr>
										<td><?php echo change_blank($aa['flashPoint'],"-"); ?></td>
										<td>
										<?php 
											if($aa['typeofdg'] == 1 ):
												$sqlq 	= "SELECT GROUP_CONCAT(' ',weight) AS detail FROM (SELECT CONCAT(sum(a.weight),' ',b.nama) AS weight FROM `permohonan_dg_package` a LEFT JOIN kod_weight b on b.idWeight = a.idWeight WHERE a.idPDG = '{$aa['idPDG']}' GROUP BY a.idWeight ) b";
											else:
												$sqlq 	= "SELECT GROUP_CONCAT(' ',weight) AS detail FROM (SELECT CONCAT(sum(a.weight),' ',b.nama) AS weight FROM `permohonan_dg_bulk` a LEFT JOIN kod_weight b on b.idWeight = a.idWeight WHERE a.idPDG = '{$aa['idPDG']}' GROUP BY a.idWeight ) b";
											endif;
											$rstq 	= $mysqli->query($sqlq) or die(mysqli_error($mysqli));
											$rowq 	= $rstq->fetch_assoc();
											echo $rowq['detail'];
										?>
										</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>
									<tr>
										<td colspan="2" style="background: rgba(7, 96, 6, .9)"></td>
									</tr>
								</table>
								
								<table class="table table-condensed table-bordered table-striped" width="100%" style="margin:0px">
									<?php
										if($aa['typeofdg'] == 1 ): ?>
									<tr>
										<th width="20px">#</th>
										<th colspan="2">Package</th>
										<th width="250px">Lorry's Details</th>
									</tr>
									<?php else: ?>
									<tr>
										<th width="20px">#</th>
										<th >Stowage Item</th>
										<th width="250px">Lorry's Details</th>
									</tr>
									<?php endif; ?>

									<?php 
										$w=1;

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

										while($bb = $result3->fetch_assoc()){ 

											$editdata2 = "CTUID#{$bb['CTUID']}|"
														."weight#{$bb['weight']}|"
														."idWeight#{$bb['idWeight']}|"
														."idDimension#{$bb['idDimension']}|"
														."idCTUType#{$bb['idCTUType']}|"
														."CTUTeus#{$bb['CTUTeus']}|"
														."idPackingType#{$bb['idPackingType']}|"
														."lorryETA#{$bb['lorryETA']}|"
														."lorryETA_time#{$bb['lorryETA_time']}|"
														."lorryPlateNo#{$bb['lorryPlateNo']}|"
														."lorryCompany#{$bb['lorryCompany']}|"
														."val-id#{$bb['idDGPackage']}";

									?>
									<tr class="">
										<td class="align-top">
											<?php echo $w++; ?>.
										</td>
										<td class="align-top">
											<table width="100%">
												<tr>
													<td width="70px"><span class="text-social text-table-1">CTU ID</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['CTUID']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Weight</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['weight']." ".$bb['nama_weight']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Dimension</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['nama_dimension']; ?>
													</td>
												</tr>
											</table>
										</td>
										<td class="align-top">
											<table width="100%">
												<tr>
													<td width="90px"><span class="text-social text-table-1">CTU Type</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['nama_ctu_type']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">CTUTeus</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['CTUTeus']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Packing Type</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['nama_packing']; ?>
													</td>
												</tr>
											</table>
										</td>
										<td class="align-top">
											<table width="100%">
												<tr>
													<td width="70px"><span class="text-social text-table-1">ETA</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['lorryETA']." ".$bb['lorryETA_time']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Plate No</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['lorryPlateNo']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Company</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['lorryCompany']; ?>
													</td>
												</tr>
											</table>
										</td>
									</tr>
									<?php } 

									else:

										while($bb = $result3->fetch_assoc()){ 

											$editdata2 = "holdNumber#{$bb['holdNumber']}|"
														."weight#{$bb['weight']}|"
														."idWeight#{$bb['idWeight']}|"
														."lorryETA#{$bb['lorryETA']}|"
														."lorryETA_time#{$bb['lorryETA_time']}|"
														."lorryPlateNo#{$bb['lorryPlateNo']}|"
														."lorryCompany#{$bb['lorryCompany']}|"
														."val-id#{$bb['idDGBulk']}";

									?>
									<tr class="">
										<td class="align-top">
											<?php echo $w++; ?>.
										</td>
										<td class="align-top">
											<table width="100%">
												<tr>
													<td width="70px"><span class="text-social text-table-1">CTU ID</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['holdNumber']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Weight</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['weight']." ".$bb['nama_weight']; ?>
													</td>
												</tr>
											</table>
										</td>
										<td class="align-top">
											<table width="100%">
												<tr>
													<td width="70px"><span class="text-social text-table-1">ETA</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['lorryETA']." ".$bb['lorryETA_time']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Plate No</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['lorryPlateNo']; ?>
													</td>
												</tr>
												<tr>
													<td><span class="text-social text-table-1">Company</span></td>
													<td width="1px">:</td>
													<td style="padding: 0px 5px">
														<?php echo $bb['lorryCompany']; ?>
													</td>
												</tr>
											</table>
										</td>
									</tr>
									<?php } 

									endif;

										if($result3->num_rows==0){
											echo "<tr><td colspan='10'><center class='text-danger'>No Records..</center></td></tr>";
										}
									?>
									<!-- <tr> -->
										<!-- <td colspan="9" style="background: rgba(7, 96, 6, .9)"></td> -->
									<!-- </tr> -->
								</table>
							</td>
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>

<? } ?>


          <!--       <div class="tab-content">
                    <div class="tab-pane active" id="ship">asd
                	</div>

                    <div class="tab-pane" id="isps">Settings..</div>
                    <div class="tab-pane" id="port">Settings..</div>
                    <div class="tab-pane" id="part">Settings..</div>
                    <div class="tab-pane" id="upload">Settings..</div>
                    <div class="tab-pane" id="dg">Settings..</div>
                 </div> -->