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();
?>
| NO |
PORT |
ARRIVAL DATE |
DEPARTURE DATE |
SECURITY LEVEL |
fetch_assoc()){
$editdata = "idPelabuhan#{$aa['idPelabuhan']}|"
."tarikhTiba#{$aa['tarikhTiba']}|"
."tarikhBerlepas#{$aa['tarikhBerlepas']}|"
."securityLevel#{$aa['securityLevel']}|"
."val-id#{$aa['idPP']}";
?>
| . |
|
|
|
|
{$i}. | N/A | ";
for ($i=$i; $i <= 10; $i++) {
// if($i == 9)
// echo " | ".($i+1).". | N/A |
";
// else
echo "| {$i}. | N/A |
";
}
?>
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'];
?>
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();
?>
| No. |
File |
fetch_assoc()){
$link = "upload/{$ii}/".$aa['namaFail'];
?>
| . |
|
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();
?>
| NO |
Dangerous of Goods |
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;
?>
|
|
Stowage Position
|
Reference Number
|
|
|
|
|
Marks & Numbers
|
UN Number
|
|
|
|
Proper Shipping Name
|
Class
|
|
|
|
Packing Group
|
Additional Information/Marine Pollutant/Flash point/etc
|
|
|
|
Mass (kg) or Volume (L)
|
EmS
|
|
|
|
Comment
|
|
|
|
|