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
/
pdf
/
file
/
res
/
Edit File:
printUserBill.php
<style> p.a { word-spacing: normal; } p.b { word-spacing: 30px; } p.c { word-spacing: 1cm; } .container{ display: flex; } .fixed{ width: 200px; } /*.flex-item{ flex-grow: 1; } */ /* table, th, td { border: 1px solid black; border-collapse: collapse; } */ div{ /*background:yellow;*/ font-family: "Times New Roman", Times, serif; font-size: 14px; font-weight: bold; text-align: center; /*position:absolute;*/ } </style> <!-- https://stackoverflow.com/questions/8776391/working-with-css-floats-in-html2pdf/8968754 https://www.w3schools.com/cssref/css3_pr_text-justify.asp --> <!-- <page backtop="0mm" backbottom="25mm" backleft="50mm" backright="50mm"> --> <!-- ################################################################# PAGE 1 ################################################################## --> <page backtop="5mm" backleft="5mm" backright="5mm" backbottom="2mm"> <page_header> <div style="display: block; height: 5mm; width: 185mm;"></div> <!--img src="../img/sada/avatar9.jpg" height="40px" width="40px" alt="Logo SADA" style="float:left;"--> <div style="display: block;margin-left: 10mm;width: 175mm; font-size: 11px; text-align: left;"> <!-- table 1 --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> <tr> <td style="width:20%;text-align: left;"><img src="../img/sada/avatar9.jpg" height="40px" width="40px" alt="Logo SADA"></td> <td style="width:50%;text-align: left;"><BR>SYARIKAT AIR DARUL AMAN SB 200901011159 <br> Lot 892, Jalan Sultan Badlishah<br> 05710 Alor Setar <br> Kedah. <br> 604-7400500</td> <td style="width:30%;text-align: right;font-weight: normal;"><BR>NO CBP SADA : 000056037376 <br> CUKAI INVOIS</td> </tr> </table> <!-- table 1 --> </div> </page_header> <!-- <page_footer> <b><i><div style="font-size:10px; color:silver;text-align:right;">This is the page footer</div></i></b> </page_footer> --> <!-- not barcode html2pdf --> <!-- https://fossies.org/linux/html2pdf/doc/barcode.md attribute Default Description dimension 1D create a 1D or 2D barcode type C39 type of barcode to use value 0 value to convert into barcode label label indicates that the label must be present below the bar code (label) or not (none) (not required) style sets the color for the bar, its width and height (without the label) and the size of the label if it is displayed (not required) <barcode dimension="1D" type="EAN13" value="52555" label="label" style="width:30mm; height:6mm; color: #770000; font-size: 4mm"></barcode> <div style="margin-top: 25mm;width: 185mm;"><barcode dimension="1D" type="EAN13" value="52555" label="none" style="width:30mm; height:6mm; color: #770000; font-size: 2mm"></barcode></div> /*<table style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> */ --> <!-- #e6f2ff light blue--> <div style="display: block; height: 20mm; width: 185mm;"></div> <div style="display: block;width: 185mm;"><hr></div> <div style="display: block;margin-left: 25mm;width: 130mm;font-size: 13px;">01 - BIL AIR (SALINAN)</div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <!-- <table border=1 style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> <tr> <td style="width:70%;">NO. BIL/ NO. INVOIS : <?php echo $nobil; ?> / <?php echo $noinvois; ?></td> <td style="width:30%;text-align: right;">TARIKH : <?php echo $bildate; ?></td> </tr> </table> </div> <div style="display: block;width: 185mm;"><hr></div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <!-- <table border=1 style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> <tr> <td style="width:70%;"><barcode dimension="1D" type="Code39" value="<?php echo $fullaccno; ?>" label="none" style="width:50mm;height:7mm; color: #000000;"></barcode></td> <td style="width:30%;text-align: right;"></td> </tr> </table> </div> <!--div style="margin-top: 45mm;width: 185mm;font-size: 10px;font-weight: normal;position: absolute;"--> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <!-- <table border=1 style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:50%;">NOMBOR AKAUN : <?php echo $accno; ?> <?php echo $chkdig; ?></td> <td style="width:50%;text-align: right;"> <!-- table 3 --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:40%;text-align: right;"> CAGARAN</td> <td style="width:10%;text-align: right;"> :</td> <td style="width:50%;text-align: left;"> RM <?php echo number_format($deposit,2); ?> </td> </tr> </table> <!-- END table 3 --> </td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <!-- <table border=1 style="text-align: justify;table-layout: fixed;border-collapse: collapse;"> --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:50%;"><?php echo $name; if(!empty($mail1)) echo "<br>".$mail1; if(!empty($mail2)) echo "<br>".$mail2; if(!empty($mail3)) echo "<br>".$mail3; if(!empty($postcode)) echo "<br>".$postcode; if(!empty($mail4)) echo " ".$$mail4; ?></td> <td style="width:50%;text-align: right;"> <!-- table 4 --> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:40%;text-align: right;"> JENIS PENGGUNA</td> <td style="width:10%;text-align: right;"> :</td> <td style="width:50%;text-align: left;"> <?php echo $jpengguna; ?> </td> </tr> <tr> <td style="width:40%;text-align: right;"> BUKU/TURUTAN</td> <td style="width:10%;text-align: right;"> :</td> <td style="width:50%;text-align: left;"> <?php echo $buku; ?> / <?php echo $walkseq; ?></td> </tr> <tr> <td style="width:40%;text-align: right;"> KOD TARIF</td> <td style="width:10%;text-align: right;"> :</td> <td style="width:50%;text-align: left;"> <?php echo $tarcod.' '.$tariff; ?> </td> </tr> </table> <!-- END table 4 --> </td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;border-bottom: 0.4px solid black;border-top: 0.4px solid black;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;background-color: grey;"> <tr> <td style="width:35%;text-align: left;"> KETERANGAN</td> <td style="width:20%;text-align: center;">NOMBOR RUJUKAN</td> <td style="width:20%;text-align: center;">TARIKH</td> <td style="width:25%;text-align: right;">AMAUN </td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:35%;text-align: left;"> BIL TERAKHIR</td> <td style="width:20%;text-align: center;"><?php echo $lastbilnum;?></td> <td style="width:20%;text-align: center;"><?php echo $lastbildat;?></td> <td style="width:25%;text-align: right;"><?php echo number_format($lastbilamt,2);?> </td> </tr> <tr> <td style="width:35%;text-align: left;"> PEMBAYARAN TERAKHIR</td> <td style="width:20%;text-align: center;"><?php echo $lastpaynum;?></td> <td style="width:20%;text-align: center;"><?php echo $lastpaydat;?></td> <td style="width:25%;text-align: right;"><?php echo number_format($lastpayamt,2);?> </td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;border-bottom: 0.4px solid black;border-top: 0.4px solid black;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;background-color: grey;"> <tr> <td style="width:25%;text-align: left;"> NOMBOR METER</td> <td style="width:15%;text-align: center;">UKURAN METER</td> <td style="width:15%;text-align: center;">BACAAN<BR>DAHULU</td> <td style="width:15%;text-align: center;">BACAAN<BR>SEMASA</td> <td style="width:15%;text-align: center;">PENGGUNAAN<BR>SEMASA</td> <td style="width:15%;text-align: center;">PENGGUNAAN<BR>METER LAMA</td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:25%;text-align: left;"> <?php echo $mtrnum;?></td> <td style="width:15%;text-align: center;"><?php echo $mtrtyp;?></td> <td style="width:15%;text-align: center;"><?php echo $lastreading;?></td> <td style="width:15%;text-align: center;"><?php echo $currentreading;?></td> <td style="width:15%;text-align: center;"><?php echo $cons;?></td> <td style="width:15%;text-align: center;"><?php echo $oldcons;?></td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;border-bottom: 0.4px solid black;border-top: 0.4px solid black;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;background-color: grey;"> <tr> <td style="width:35%;text-align: left;"> CAJ</td> <td style="width:20%;text-align: left;">BLOK TARIF (m³)</td> <td style="width:15%;text-align: right;">BLOK PRORATA (m³)</td> <td style="width:15%;text-align: right;">KADAR</td> <td style="width:15%;text-align: right;">AMAUN </td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <? $sql = "SELECT EVNCOD, ITMDESCR, ITMQTY, ITMRATE, ITMPRC FROM BILL_ITM_HIST WHERE BILNUM='$bilnum'"; $stmt1 = oci_parse($conn, $sql); oci_execute($stmt1) or die(print_r(oci_error($stmt1))); while($row1 = oci_fetch_object($stmt1)){ $sql2 = "SELECT DESCR FROM TBEVNCOD WHERE EVNCOD='$row1->EVNCOD'"; $stmt2 = oci_parse($conn, $sql2); oci_execute($stmt2) or die(print_r(oci_error($stmt2))); $row2 = oci_fetch_object($stmt2); ?> <tr> <td style="width:35%;text-align: left;"> <?php echo $row2->DESCR;?></td> <td style="width:20%;text-align: left;"><?php echo $row1->ITMDESCR;?></td> <td style="width:15%;text-align: right;"><?php echo $row1->ITMQTY;?></td> <td style="width:15%;text-align: right;"><?php echo number_format($row1->ITMRATE,2);?></td> <td style="width:15%;text-align: right;"><?php echo number_format($row1->ITMPRC,2);?> </td> </tr> <?}?> <? $sql = "SELECT ITMDESCR, ITMPRC FROM BILL_ITM_HIST WHERE BILNUM='$noinvois'"; $stmt1 = oci_parse($conn, $sql); oci_execute($stmt1) or die(print_r(oci_error($stmt1))); $row1 = oci_fetch_object($stmt1); ?> <tr> <td style="width:35%;text-align: left;"> <?php echo $row1->ITMDESCR;?></td> <td style="width:20%;text-align: left;"> </td> <td style="width:15%;text-align: right;"> </td> <td style="width:15%;text-align: right;"> </td> <td style="width:15%;text-align: right;"><?php echo number_format($row1->ITMPRC,2);?> </td> </tr> </table> </div> <div style="display: block; height: 10mm; width: 185mm;"></div> <div style="display: block;width: 185mm;font-size: 11px;font-weight: normal;text-align: left;"> <b> PERINGATAN</b> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:5%;">1. </td> <td style="width:2%;"> </td> <td style="width:93%;text-align: left;text-align: justify;"> Pembayaran selain daripada tunai hendaklah dikeluarkan atas nama Syarikat Air Darul Aman Sdn. Bhd. <BR> dan dipalang Kira-Kira Penerima sahaja. <BR> Bukti pembayaran hanyalah melalui mesin resit Syarikat Air Darul Aman Sdn. Bhd./ejen lain yang sah. </td> </tr> </table> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;border-bottom: 0.4px solid black;border-top: 0.4px solid black;background-color: grey;"> </div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: normal;"> <table style="text-align: justify;table-layout: fixed; width: 100%;"> <tr> <td style="width:50%;"> JENIS BACAAN : <?php echo $jenisbacaan;?></td> <td style="width:23%;">TUNGGAKAN BIL AIR</td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($tunggakanair,2);?> </td> </tr> <tr> <td style="width:50%;"> SILA BAYAR SEBELUM : <?php echo $due;?></td> <td style="width:23%;">TUNGGAKAN GST </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($tunggakangst,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">LAIN-LAIN TUNGGAKAN </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($tunggakanlain,2);?> </td> </tr> <tr style="font-weight: bold;font-size: 12px;"> <td style="width:50%;"> </td> <td style="width:23%;">JUMLAH TUNGGAKAN </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($tunggakan,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">CAJ BULAN SEMASA </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($semasaair,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">GST SEMASA </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($semasagst,2);?> </td> </tr> <tr style="font-weight: bold;font-size: 12px;"> <td style="width:50%;"> </td> <td style="width:23%;">JUMLAH CAJ SEMASA </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($semasa,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">PELARASAN DEPOSIT </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($adjdeposit,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">PELARASAN ANGGARAN </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($adjanggaran,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">PELARASAN GST </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($adjgst,2);?> </td> </tr> <tr style="font-weight: bold;font-size: 12px;"> <td style="width:50%;"> </td> <td style="width:23%;">JUMLAH PELARASAN </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($adj,2);?> </td> </tr> <tr> <td style="width:50%;"> </td> <td style="width:23%;">PENGGENAPAN </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($penggenapan,2);?> </td> </tr> <tr style="font-weight: bold;font-size: 12px;"> <td style="width:50%;"> </td> <td style="width:23%;">JUMLAH PERLU DIBAYAR </td> <td style="width:2%;">: </td> <td style="width:5%;">RM </td> <td style="width:20%;text-align: right;"><?php echo number_format($totbil,2);?> </td> </tr> <tr style="font-weight: bold;"> <td style="width:50%;"> </td> <td style="width:23%;"> </td> <td style="width:2%;"> </td> <td style="width:5%;"> </td> <td style="width:20%;text-align: right;"> 3251<BR> <?php echo $fullaccno; ?><BR> <?php echo $phoneno; ?> </td> </tr> </table> </div> <div style="display: block;width: 70mm;font-size: 10px;font-weight: normal;border-bottom: 1px solid black;"> </div> <div style="display: block;width: 70mm;font-size: 11px;font-weight: normal;text-align: left;"> b/p Ketua Pegawai Eksekutif, <br> Syarikat Air Darul Aman Sdn. Bhd. </div> <div style="display: block;width: 185mm;border-bottom: 1px dotted black;"> </div> <div style="display: block; height: 5mm; width: 185mm;"></div> <div style="display: block;width: 185mm; font-size: 12px;font-weight: bold;text-align: left;">SYARIKAT AIR DARUL AMAN SB 200901011159</div> <div style="display: block;width: 185mm; font-size: 12px;font-weight: bold;text-align: left;">01 - BIL AIR (SALINAN)</div> <div style="display: block;width: 185mm;font-size: 10px;font-weight: bold;border-bottom: 0.2px solid black;border-top: 0.2px solid black;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;background-color: grey;"> <tr> <td style="width:25%;text-align: left;"> NOMBOR AKAUN </td> <td style="width:25%;text-align: right;">NOMBOR BIL </td> <td style="width:25%;text-align: center;">TARIKH </td> <td style="width:25%;text-align: right;">AMAUN </td> </tr> </table> </div> <div style="display: block;width: 185mm; height: 5mm; font-size: 10px;font-weight: normal;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:25%;text-align: left;"> <?php echo $accno; ?> <?php echo $chkdig; ?></td> <td style="width:25%;text-align: right;"><?php echo $bilnum; ?> </td> <td style="width:25%;text-align: center;"><?php echo $bildate; ?></td> <td style="width:25%;text-align: right;"><?php echo number_format($totbil, 2); ?> </td> </tr> </table> </div> <div style="display: block;width: 185mm; height: 8mm;font-size: 10px;font-weight: normal;"> <table style="text-align: justify;table-layout: fixed;border-collapse: collapse;width: 100%;"> <tr> <td style="width:40%;text-align: left;"> <barcode dimension="1D" type="Code39" value="<?php echo $fullaccno; ?>" label="none" style="width:40mm;height:7mm; color: #000000;"></barcode> </td> <td style="width:40%;text-align: left;"><barcode dimension="1D" type="Code39" value="<?php echo $bilnum; ?>" label="none" style="width:30mm;height:7mm; color: #000000;"></barcode> </td> <td style="width:20%;text-align: right;"><barcode dimension="1D" type="Code39" value="<?php echo $totbil; ?>" label="none" style="width:30mm;height:7mm; color: #000000;"></barcode> </td> </tr> </table> </div> <div style="display: block;width: 50mm;font-size: 10px;font-weight: normal;text-align: left;"> <?php echo $name; if(!empty($mail1)) echo "<br>".$mail1; if(!empty($mail2)) echo "<br>".$mail2; if(!empty($mail3)) echo "<br>".$mail3; if(!empty($postcode)) echo "<br>".$postcode; if(!empty($mail4)) echo " ".$$mail4; ?> </div> <!-- <barcode dimension="1D" type="EAN13" value="52555" label="none" style="height:4mm; color: #770000;"></barcode> --> <!-- <barcode dimension="1D" type="EAN13" value="123456789123" label="label" style="width:40mm;height:4mm; color: #770000;"></barcode> << max boleh 12 char shj & tak boleh space --> </page> <!-- ################################################################# END PAGE 1 ################################################################## --> <!-- <script src="../../../js/vendor/jquery-2.1.1.min.js"></script> <script src="../../../js/plugins.js"></script> <script type="text/javascript"> $(document).ready(function(){ // alert(1); $("div").css("border","1px solid red"); }); </script> --> <style type="text/css"> div{ border: 0px solid black; } </style>
Simpan