Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
detail.php	29.97 KB	-rw-rw-rw-
detail_20210104.php	32.67 KB	-rw-rw-rw-
dg.php	43.04 KB	-rw-rw-rw-
dg_20200723.php	51.85 KB	-rw-rw-rw-
dg_20201219.php	50 KB	-rw-rw-rw-
isps_info-1.php	16.45 KB	-rw-rw-rw-
isps_info.php	12.96 KB	-rw-rw-rw-
isps_info_20200723.php	18.17 KB	-rw-rw-rw-
isps_infox.php	14.94 KB	-rw-rw-rw-
main(3).php	644 B	-rw-rw-rw-
main(5).php	51.58 KB	-rw-rw-rw-
main.php	52.4 KB	-rw-rw-rw-
main_20201220.php	31.43 KB	-rw-rw-rw-
main_20201222.php	31.43 KB	-rw-rw-rw-
main_20210408.php	47.29 KB	-rw-rw-rw-
main_20220621.php	55.52 KB	-rw-rw-rw-
main_230312.php	51.76 KB	-rw-rw-rw-
mainx.php	30.78 KB	-rw-rw-rw-
other_part.php	17.22 KB	-rw-rw-rw-
other_part_20200723.php	15.45 KB	-rw-rw-rw-
other_part_20201219.php	13.56 KB	-rw-rw-rw-
port_call.php	32.4 KB	-rw-rw-rw-
port_call_20200723.php	23.49 KB	-rw-rw-rw-
port_call_20220413.php	22.79 KB	-rw-rw-rw-
port_call_230312.php	32.38 KB	-rw-rw-rw-
s_detail.php	27.87 KB	-rw-rw-rw-
s_detail_240205.php	27.79 KB	-rw-rw-rw-
s_info.php	28.24 KB	-rw-rw-rw-
s_main.php	14.85 KB	-rw-rw-rw-
s_main_240205.php	14.81 KB	-rw-rw-rw-
s_upload_me.php	1.56 KB	-rw-rw-rw-
ship_particular_20200723.php	27.12 KB	-rw-rw-rw-
ship_particular_230312.php	43.12 KB	-rw-rw-rw-
site.php	18.43 KB	-rw-rw-rw-
tabs.php	10.13 KB	-rw-rw-rw-
tabs_old.php	10.22 KB	-rw-rw-rw-
upload	5.32 KB	-rw-rw-rw-
upload.php	14.3 KB	-rw-rw-rw-
upload_20200723.php	14.23 KB	-rw-rw-rw-
upload_me.php	1.53 KB	-rw-rw-rw-

Code Editor : s_info.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 == 'site'){

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT *,DATE_FORMAT(tarikhVisit,'%d-%m-%Y') AS tarikhVisit FROM visit_main WHERE idVisitMain=?");
		$stmt->bind_param("s",$visit_main = $path);
		$stmt->execute();
		$result 		= $stmt->get_result();
		$stmt->close();

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

$idMarineFacility 	= $row['idMarineFacility'];
		$flagStatus 		= $row['flagStatus'];
		$tarikhVisit 		= $row['tarikhVisit'];

?>
		<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="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 class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="tarikhVisit">Date</label>
					<div class="col-md-8">
						<input type="text" readonly="readonly" id="tarikhVisit" value="<?php echo $tarikhVisit;?>" 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="flagStatus">Status</label>
					<div class="col-md-8">
						<input type="text" readonly="readonly" id="flagStatus" value="<?php echo $flagStatus;?>" class="form-control" >
					</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 == 'details'){

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							a.*
						FROM 
							visit_detail a 
						WHERE 
							a.idVisitMain=?
						");
		$stmt->bind_param("s",$idVisitMain = $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>FINDING</th>
							<th>RESPONSE</th>
							<th>FILE UPLOAD</th>
						</tr>
					</thead>
					<tbody>
					<?php

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

$editdata = "finding#{$aa['finding']}|"
										."response#{$aa['response']}|"
										."val-id#{$aa['idVisitDetail']}";
					
							$stmt  			= $mysqli->stmt_init();
							$stmt->prepare("SELECT
												a.*
											FROM 
												visit_lampiran a 
											WHERE 
												a.idVisitDetail=?
											");
							$stmt->bind_param("s",$idVisitDetail = $aa['idVisitDetail']);
							$stmt->execute();

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

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

?>
						<tr>
							<td class="align-top text-center"><?php echo $i++; ?></td>
							<td class="align-top"><?php echo $aa['finding']?></td>
							<td class="align-top"><?php echo $aa['response']?></td>
							<td <?php if($result3->num_rows){ ?> class="align-top" style="padding: 5px;background: grey" <?php }else{ ?> class="align-center text-center" <?php }?> >
							<?php if($result3->num_rows){ ?>
								<table id="table-upload" class="table table-bordered table-striped" width="100%" style="margin:0px">
									<tr>
										<td>
											<span class="text-primary text-table-1">
												Notes
											</span>
										</td>
										<td class="text-center" width="100px">
											<span class="text-primary text-table-1">
												File
											</span>
										</td>
									</tr>
									<tbody>
								<?php 
									while($bb = $result3->fetch_assoc()){ ?>
									<tr>
										<td><?php echo nl2br($bb['catatan'])?></td>
										<td class="text-center"><a class="btn btn-sm btn-info" href="./upload/site/<?php echo $ii;?>/<?php echo $bb['namaFile']?>" download target="_blank"><i class="fa fa-download"></i>&nbsp;Download</a></td>
									</tr>
								<?php } ?>
									</tbody>
								</table>
							<?php }else{ ?>
								<span class="label label-danger">No Files!</span>
							<?php } ?>
							</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']}";

endif;

if($result3->num_rows==0){
											echo "<tr><td colspan='10'><center class='text-danger'>No Records..</center></td></tr>";
										}
									?>
									
										
									
								</table>
							</td>
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>

<? } ?>

${this.title}

Code Editor : s_info.php