One Hat Cyber Team
Your IP :
172.16.0.254
Server IP :
58.26.163.33
Server :
Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64
Server Software :
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25
PHP Version :
7.3.25
Buat File
|
Buat Folder
Eksekusi
Dir :
C:
/
xampp7
/
htdocs
/
edgpens
/
reports
/
Edit File:
app_print_230312.php
<?php ob_start(); ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Reports</title> <style type="text/css"> body { max-width: 600px; } .row::after { content: ""; display: table; clear: both; } .column { float: left; width: 50%; padding: 10px; border: 1px; } table { border-collapse: collapse; border-spacing: 0; width: 100%; } th, td { border: 1px solid #CCC; border-collapse: collapse; } td, th { padding: 5px; } th { font-size: 9pt; } td { font-size: 8pt; } .halimunan td, .halimunan th { width: 50%; } .op td, .op th, .isps td, .isps th { width: 40%; } .dg td, .dg th { width: 25%; } div.center { height: 10em; position: relative } div.center p { margin: 0; background: yellow; position: absolute; top: 50%; left: 50%; margin-right: -50%; transform: translate(-50%, -50%) } .page-break { display: block; page-break-before: always; } .boxme{ padding-bottom: 15px; } .t100{ border-collapse: collapse; border-spacing: 0; width: 100%; display:inline-block margin-bottom: 200px; } .t100 td{ padding: 0px; border: none; width: 100%; } .t100 td table td{ padding: 5px; font-size: 9pt; width: auto; /*border: 1px solid #CCC;*/ } .pc tr td, .pc tr th { border: 1px solid #CCC; } .p-text{ padding: 0px; margin: 3px 0px 0px 0px; } .no-border { border: none; border-collapse: collapse; } .no-border td{ border: none; } .tfieldset { border-collapse: collapse; border-spacing: 0; width: 100%; display:inline-block } .tfieldset td { border: none; padding: 2px; font-size: 9pt; } @media print { /* tr { page-break-before:always!important; } */ td{ /*border: 1px solid red;*/ } table { page-break-after:auto } tr { page-break-inside:avoid; page-break-after:auto } td { page-break-inside:avoid; page-break-after:auto } thead { display:table-header-group } tfoot { display:table-footer-group } .boxme{ page-break-inside:avoid; page-break-after:auto; display: block; /*border: 1px solid green;*/ } } </style> </head> <body> <?php include("../odbc.php"); include("../sessions.php"); session_start(); if ($_SESSION['session']) $session = updateSession($_SESSION["session"]); else $session = ''; if (!$session) { $_SESSION["session"] = false; $_SESSION['success'] = 3; $_SESSION['success_msg'] = "Please Login!"; echo "<script>window.location.replace('login.php?success=3');</script>"; exit(); } $type = (isset($_POST['type'])) ? $_POST['type'] : ''; $type_x = explode('_', $type); ?> <?php $ii = $_GET['ii']; $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT *,DATE_FORMAT(tarikhApproveMTSO,'%d-%m-%Y %H:%i:%s') as appMTSO,DATE_FORMAT(tarikhApproveMFSO,'%d-%m-%Y %H:%i:%s') as appMFSO,DATE_FORMAT(tarikhApproveDG,'%d-%m-%Y %H:%i:%s') as appDG FROM permohonan_main WHERE idPermohonan=?"); $stmt->bind_param("s", $permohonan_main = $ii); $stmt->execute(); $result = $stmt->get_result(); $stmt->close(); $session = array(); $row = $result->fetch_assoc(); // fetch nama applicant function getNamaUser($idUser) { global $mysqli; $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT nameUser FROM user_list WHERE idUser=?"); $stmt->bind_param("s", $idUser); $stmt->execute(); $result2 = $stmt->get_result(); $stmt->close(); $row2 = $result2->fetch_assoc(); return $row2['nameUser']; } function getDataKapal($colName, $idKapal) { global $mysqli; $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT $colName FROM kod_kapal WHERE idKapal=?"); $stmt->bind_param("s", $idKapal); $stmt->execute(); $result2 = $stmt->get_result(); $stmt->close(); $row2 = $result2->fetch_assoc(); $rtn = (empty($row2[$colName])) ? '-' : $row2[$colName] ; return $rtn; } function getJenisKapal($idKapal) { global $mysqli; $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT b.nama as jenisKapal FROM kod_jenis_kapal b JOIN kod_kapal a ON a.idJenisKapal = b.idJenisKapal WHERE a.idKapal = ?"); $stmt->bind_param("s", $idKapal); $stmt->execute(); $result2 = $stmt->get_result(); $stmt->close(); $row2 = $result2->fetch_assoc(); return $row2['jenisKapal']; } function getPOC($idPOC) { global $mysqli; $listpoc = explode('|', $idPOC); $comb = ""; foreach ($listpoc as $aa) { $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT nama FROM kod_call_purpose WHERE idCallPurpose = ?"); $stmt->bind_param("s", $aa); $stmt->execute(); $result2 = $stmt->get_result(); $stmt->close(); $row2 = $result2->fetch_assoc(); $comb .= ", ".$row2['nama']; } $comb = substr($comb, 2); $rtn = (empty($comb)) ? '-' : $comb ; return $rtn; } function getMarineFacility($idMF) { global $mysqli; $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT nama FROM kod_marine_facility WHERE idMarineFacility = ?"); $stmt->bind_param("s", $idMF); $stmt->execute(); $result2 = $stmt->get_result(); $stmt->close(); $row2 = $result2->fetch_assoc(); return $row2['nama']; } ?> <fieldset style="padding: 10px;margin-bottom: 15px"> <legend style="background-color: white;padding: 5px;border: none"><h2 style="padding: 0px;margin: 0px">Application</h2></legend> <table class="tfieldset"> <tr> <td style="width: 14%"><b>Reference ID</b></td> <td style="width: 1%">:</td> <td><?php echo $row['refID'] ?></td> </tr> <tr> <td><b>Submitted By</b></td> <td>:</td> <td><?php echo getNamaUser($row['idUserApply']); ?></td> </tr> <tr> <td><b>Submitted Date</b></td> <td>:</td> <td><?php echo $row['tarikhApply'] ?></td> </tr> <tr><td colspan="3"> </td></tr> <tr><td colspan="3"><b># Approval :-</b></td></tr> <?php if(trim($row['commentsMFSO'])!=="-bypass-"){ ?> <tr> <td><b>MFSO</b></td> <td>:</td> <td> <?php if ($row['flagApproveMFSO'] == 'Y') { echo "Acknowledged by " . getNamaUser($row['idApproveMFSO']) . " on " . $row['appMFSO']; } else if ($row['flagApproveMFSO'] == 'T') { echo "Rejected by " . getNamaUser($row['idApproveMFSO']) . " on " . $row['appMFSO']; } else if ($row['flagApproveMFSO'] == 'N') { echo "Pending"; } if(!empty($row['commentsMFSO'])){ echo "<br>"; echo "<i>".nl2br($row['commentsMFSO'])."</i>"; } ?> </td> </tr> <?php } ?> <?php if ($row['flagDG'] == 'Y') { ?> <tr> <td><b>DG</b></td> <td>:</td> <td> <?php if ($row['flagApproveDG'] == 'Y') { echo "eDG Enabeld by " . getNamaUser($row['idApproveDG']) . " on " . $row['appDG']; } else if ($row['flagApproveDG'] == 'T') { echo "Rejected by " . getNamaUser($row['idApproveDG']) . " on " . $row['appDG']; } else if ($row['flagApproveDG'] == 'N') { echo "Pending"; } if(!empty($row['commentsDG'])){ echo "<br>"; echo "<i>".nl2br($row['commentsDG'])."</i>"; } ?> </td> </tr> <?php } ?> <tr> <td style="width: 14%"><b>MTSO</b></td> <td style="width: 1%">:</td> <td> <?php if ($row['flagApproveMTSO'] == 'Y') { echo "Acknowledged by " . getNamaUser($row['idApproveMTSO']) . " on " . $row['appMTSO']; } else if ($row['flagApproveMTSO'] == 'T') { echo "Rejected by " . getNamaUser($row['idApproveMTSO']) . " on " . $row['appMTSO']; } else if ($row['flagApproveMTSO'] == 'N') { echo "Pending"; } if(!empty($row['commentsMTSO'])){ echo "<br>"; echo "<i>".nl2br($row['commentsMTSO'])."</i>"; } ?> </td> </tr> </table> </fieldset> <div class="boxme"> <table class="t100"> <tr> <td> <h3 style="margin-bottom:1px "># Ship Particular</h3> <hr> </td> </tr> <tr> <td> <table> <tr> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table> <tr> <td style="width: 100%"> <b>Vessel Name :</b> <p class="p-text"><?php echo getDataKapal("nama", $row['idKapal']) ?></p> </td> </tr> <tr> <td> <b>Ship Owner :</b> <p class="p-text"><?php echo getDataKapal("namaSyarikat", $row['idKapal']) ?></p> </td> </tr> <tr> <td> <b>Vessel Type :</b> <p class="p-text"><?php echo getJenisKapal($row['idKapal']) ?></p> </td> </tr> <tr> <td> <b>IMO :</b> <p class="p-text"><?php echo getDataKapal("IMO", $row['idKapal']) ?></p> </td> </tr> </table> </td> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table> <tr> <td> <b>Country :</b> <p class="p-text"><?php echo getDataKapal("Flag", $row['idKapal']) ?></p> </td> </tr> <tr> <td> <b>Call Sign :</b> <p class="p-text"><?php echo getDataKapal("CallSign", $row['idKapal']) ?></p> </td> </tr> <tr> <td> <b>MMSI :</b> <p class="p-text"><?php echo getDataKapal("MMSI", $row['idKapal']) ?></p> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td><hr style="border:1px solid #ccc"></td> </tr> <tr> <td> <table> <tr> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table> <tr> <td> <b>GT :</b> <p class="p-text"><?php echo (empty($row['GT'])) ? '-' : $row['GT'] ?></p> </td> </tr> <tr> <td> <b>ISSC No :</b> <p class="p-text"><?php echo getDataKapal("ISSC", $row['idKapal']) ?></p> </td> </tr> </table> </td> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table> <tr> <td> <b>ISSC Expiry Date :</b> <p class="p-text"><?php echo getDataKapal("tarikhLuputISSC", $row['idKapal']) ?></p> </td> </tr> <tr> <td> <b>ISSC Issuing Authority :</b> <p class="p-text"><?php echo getDataKapal("ISSCAuthority", $row['idKapal']); ?></p> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td><hr style="border:1px solid #ccc"></td> </tr> <tr> <td> <table> <tr> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table> <tr> <td style="width: 100%"> <b>Purpose Of Call :</b> <p class="p-text"><?php echo getPOC($row['otherCallPurpose']) ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Voyage No. :</b> <p class="p-text"><?php echo change_blank($row['noVoyage'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Cargo :</b> <p class="p-text"><?php echo change_blank($row['cargo2discharge'],'-'); ?></p> </td> </tr> </table> </td> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table> <tr> <td style="width: 100%"> <b>No. Of Crew :</b> <p class="p-text"><?php echo (empty($row['bilKrew'])) ? '-' : $row['bilKrew'] ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>No. Of Passenger :</b> <p class="p-text"><?php echo (empty($row['bilPenumpang'])) ? '-' : $row['bilPenumpang'] ?></p> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </div> <div class="boxme"> <table class="t100"> <tr> <td> <h3 style="margin-bottom:1px "># ISPS Information</h3> <hr> </td> </tr> <tr> <td> <table> <tr> <td> <b>Name Of Archorage or Marine Facility your ship is bound for :</b> <p class="p-text"><?php echo getMarineFacility($row['idMarineFacility']) ?></p> </td> </tr> <tr> <td> <b>Prohibited good under UN security council/resolution on board?</b> <p class="p-text"> <?php if ($row['flagISSC'] == 'Y') { echo "Yes"; } else { echo 'No'; } ?> </p> </td> </tr> <tr> <td> <b>Current Security Level of the ship :</b> <p class="p-text"><?php echo $row['securityLevel'] ?></p> </td> </tr> </table> </td> </tr> </table> </div> <?php $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT a.idPP, a.idPermohonanMain, a.idPelabuhan, DATE_FORMAT(a.tarikhTiba,'%d-%m-%Y') AS tarikhTiba, DATE_FORMAT(a.tarikhBerlepas,'%d-%m-%Y') AS tarikhBerlepas, a.securityLevel, b.nama, b.hadMasa FROM permohonan_pelabuhan a LEFT JOIN kod_pelabuhan b ON b.idPelabuhan = a.idPelabuhan WHERE a.idPermohonanMain=? "); $stmt->bind_param("s", $ii); $stmt->execute(); if ($stmt->error) print_r('error executing statement: ' . $stmt->error); $result2 = $stmt->get_result(); $stmt->close(); $count = mysqli_num_rows($result2);; if ($count > 0) { ?> <div class="boxme"> <table class="t100"> <tr> <td> <h3 style="margin-bottom:1px"># Last 10 Port Calls</h3> <hr> </td> </tr> <tr> <td> <table class="pc"> <!-- looping 1-10 --> <tr style="background-color: #e6e6e6"> <th style="width: 5%"> No </th> <th style="width: 50%"> Port </th> <th style="width: 15%"> Arrival Date </th> <th style="width: 15%"> Departure Date </th> <th style="width: 15%"> Security Level </th> </tr> <?php $i = 1; while ($rowpc = $result2->fetch_assoc()) { ?> <tr> <td> <?php echo $i ?> </td> <td> <?php echo $rowpc['nama'] ?> </td> <td> <?php echo $rowpc['tarikhTiba'] ?> </td> <td> <?php echo $rowpc['tarikhBerlepas'] ?> </td> <td> <?php echo $rowpc['securityLevel'] ?> </td> </tr> <?php $i++; } ?> </table> </td> </tr> </table> </div> <?php } ?> <div class="boxme"> <table class="t100"> <tr> <td> <h3 style="margin-bottom:1px "># Other Particular</h3> <hr> </td> </tr> <tr> <td> <table> <tr> <td> <b>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?</b> <p class="p-text"> <?php if ($row['flagSecurityMeasures'] == 'Y') { echo "Yes"; } else { echo 'No'; } ?> </p> </td> </tr> <?php if ($row['flagSecurityMeasures'] == 'Y') { ?> <tr> <td> <b>Details</b> <p class="p-text"><?php echo $row['catatanSecurityMeasures'] ?></p> </td> </tr> <?php } ?> <tr> <td> <b>Latitude :</b> <p class="p-text"><?php echo $row['lat1'] . "° " . $row['lat2'] . "' " . $row['lat3'] . " " . $row['lat4']; ?></p> </td> </tr> <tr> <td> <b>Longitude :</b> <p class="p-text"><?php echo $row['long1'] . "° " . $row['long2'] . "' " . $row['long3'] . " " . $row['long4']; ?></p> </td> </tr> <tr> <td> <b>Date/Time Arrival(LMT) :</b> <p class="p-text"><?php echo $row['ETA'] ?></p> </td> </tr> <tr> <td> <b>Name Of Master :</b> <p class="p-text"><?php echo $row['namaMaster'] ?></p> </td> </tr> <tr> <td> <b>Dangerous Good On Board?</b> <p class="p-text"> <?php if ($row['flagDG'] == 'Y') { echo "Yes"; } else { echo 'No'; } ?> </p> </td> </tr> </table> </td> </tr> </table> </div> <?php if ($row['flagDG'] == 'Y') { ?> <div class="boxme"> <table class="t100"> <tr> <td> <h3 style="margin-bottom:1px "># Dangerous Goods</h3> <hr> </td> </tr> <tr> <td> <table class="pc"> <!-- looping 1-10 --> <tr style="background-color: #e6e6e6"> <th style="width: 5%"> No </th> <th style="width: 95%"> Dangerous of Goods </th> </tr> <?php $stmt = $mysqli->stmt_init(); $stmt = $mysqli->stmt_init(); $stmt->prepare("SELECT a.idPDG, a.idPermohonanMain, a.stow_position, a.ref_num, a.marks_number, a.pack_group, a.add_info, a.package, a.unit, a.unit_weight, a.ems, 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", $ii); $stmt->execute(); $result2 = $stmt->get_result(); $stmt->close(); $i = 1; while ($rowdg = $result2->fetch_assoc()) { ?> <tr> <td style="width: 5%"> <?php echo $i ?> </td> <td style="padding: 0px;width: 95%"> <table class="no-border"> <tr> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table class="no-border"> <tr> <td style="width: 100%"> <b>Stowage Position :</b> <p class="p-text"><?php echo change_blank($rowdg['stow_position'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Marks & Numbers :</b> <p class="p-text"><?php echo change_blank($rowdg['marks_number'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Proper Shipping Name :</b> <p class="p-text" style=""><?php echo change_blank($rowdg['nama_dg'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Packing Group :</b> <p class="p-text"><?php echo change_blank($rowdg['pack_group'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Mass (kg) or Volume (L) :</b> <p class="p-text"><?php echo change_blank($rowdg['unit_weight'].' '.$rowdg['unit'],"-"); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Comments :</b> <p class="p-text"><?php echo change_blank($rowdg['comments'],"-"); ?></p> </td> </tr> </table> </td> <td style="width: 50%;padding: 0px;vertical-align: top;"> <table class="no-border"> <tr> <td style="width: 100%"> <b>Reference No. :</b> <p class="p-text"><?php echo change_blank($rowdg['ref_num'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>UN No. :</b> <p class="p-text"><?php echo change_blank($rowdg['UNNumber'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Class :</b> <p class="p-text"><?php echo change_blank($rowdg['IMOClass'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>Additional Information / Marine Pollutant / Flash Point / ETC :</b> <p class="p-text"><?php echo change_blank($rowdg['add_info'],'-'); ?></p> </td> </tr> <tr> <td style="width: 100%"> <b>EmS :</b> <p class="p-text"><?php echo change_blank($rowdg['ems'],'-'); ?></p> </td> </tr> </table> </td> </tr> </table> </td> </tr> <?php $i++; } ?> </table> </td> </tr> </table> </div> <?php } ?> </body> </html> <?php $content = ob_get_clean(); $dirname = dirname(__FILE__); $dirnameCut = basename($dirname); $dirnameNew = rtrim($dirname, $dirnameCut); $dirnameNew = rtrim($dirnameNew, '\\'); require_once($dirnameNew . '/pdf/html2pdf.class.php'); try { $html2pdf = new HTML2PDF('P', 'A4', 'en'); $html2pdf->setDefaultFont('helvetica'); $html2pdf->writeHTML($content, isset($_GET['vuehtml'])); $html2pdf->pdf->SetDisplayMode('fullpage'); $html2pdf->Output('reports.pdf', 'I'); } catch (HTML2PDF_exception $e) { echo $e; exit; } ?>
Simpan