One Hat Cyber Team

Edit File: printPayBillView.php

p.b { 
  word-spacing: 30px;
}

p.c { 
  word-spacing: 1cm;
}

.container{
    display: flex;
}
.fixed{
    width: 200px;
}
td, th{
  padding: 5px;
}
tr {
  page-break-inside: avoid;
}

thead, tfoot {
  display: table-row-group;
}
/*.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>


    

<page backtop="25mm"  backleft="6mm" backright="2mm" backbottom="10mm"> 
    <page_header> 
        <img src="../img/sada/avatar9.jpg" height="40px" width="40px" alt="Logo SADA" style="float:left;">
        <div style="margin-left: 12mm;width: 160mm;font-size: 11px; text-align: left;"> 
          SYARIKAT AIR DARUL AMAN SB 200901011159 <br> Lot 892, Jalan Sultan Badlishah<br> 05710 Alor Setar <br> Kedah. <br> 604-7400500 
        </div>
        <br><hr>
    </page_header> 
    <page_footer> <div style="text-align: center;font-size: 10px;"> <i>Page [[page_cu]]/[[page_nb]] </i> </div></page_footer>
    
        <table border=0 width="100%" style="border-collapse: collapse;padding: 0px;margin: 0px;">
          <tr>
            <td style="width: 70px;"></td>
            <td style="width: 2px;"></td>
            <td style="width: 350px;"></td>
          </tr>
          <tr>
            <td colspan="3" style="padding: 1px;"> <h4> <u>LIST OF BILLS</u> </h4> </td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td></td>
            <td></td>
          </tr>
          <tr>
            <td>Account No</td>
            <td>:</td>
            <td><b><?php echo $accno; ?></b></td>
          </tr>
          <tr>
            <td>Name</td>
            <td>:</td>
            <td><b><?php echo $row->CON_NAME; ?></b></td>
          </tr>
          <tr>
            <td>IC No</td>
            <td>:</td>
            <td><b><?php echo $row->CON_IC; ?></b></td>
          </tr>
          <tr>
            <td>Address</td>
            <td>:</td>
            <td><b><?php echo $row->CONADD1.', '.$row->CONADD2; ?></b></td>
          </tr>
          <tr>
            <td>Status</td>
            <td>:</td>
            <td><b><?php echo $row->CONSTA.' - '.$row->CON_STA_DESC; ?></b></td>
          </tr>
          <tr>
            <td>Printed On</td>
            <td>:</td>
            <td><b><?php echo $t2day; ?></b></td>
          </tr>
  
        </table>
        <br><br>
        
        <table id="table2" border="1" style="border-collapse: collapse;width:90%;font-size: 12px;">
          <thead>
          <tr style="background-color:#ecf0f1;">
            <td align="center" style="width: 5%;"><b>No</b></td>
            <td align="center" style="width: 25%;"><b>Transaction</b></td>
            <td align="center" style="width: 15%;"><b>Bill No</b></td>
            <td align="center" style="width: 15%;"><b>Current Amount</b></td>
            <td align="center" style="width: 15%;"><b>Arrears</b></td>
            <td align="center" style="width: 15%;"><b>Bill Amount</b></td>
            <td align="center" style="width: 15%;"><b>Amount Not Payed</b></td>
            <td align="center" style="width: 10%;"><b>Date</b></td>
          </tr>
        </thead>
          <?php 
          $curamtAll = 0;
          $arrearsAll = 0;
          $amtAll = 0;
          $offbalamtAll = 0;
          $j = 1;
          while(($row2 = oci_fetch_object($stmt2)) != false){
            $bilnum = trim($row2->BILNUM);
            $evngrp = trim($row2->EVNGRP);
            $bildat = $row2->BILDAT;
            $amt = $row2->JUMBIL;
            $curamt = $row2->CURAMT;
            $arrears = $row2->ARREARS;
            $offbalamt = $row2->OFFBALAMT;

$sql3 = "SELECT UPPER(DESCR) AS DESCR FROM EPREVENUE WHERE REVCOD = '$evngrp' ";
            $stmt3  = oci_parse($conn, $sql3);
            $e3 = oci_execute($stmt3) or die(print_r(oci_error($stmt3)));
            $descr = "";
            while(($row3 = oci_fetch_object($stmt3)) != false){
              $descr = $row3->DESCR;
            }

if($descr!=""){
              $lab1 = $evngrp.' - '.$descr;
            }else{ $lab1 = "";}
            ?>
            <tr>
            <td align="center"><?php echo $j; ?></td>
            <td align="center"><?php echo $lab1; ?></td>
            <td align="center"><?php echo $bilnum; ?></td>
            <td align="right"><?php echo number_format($curamt, 2, '.', ','); ?></td>
            <td align="right"><?php echo number_format($arrears, 2, '.', ','); ?></td>
            <td align="right"><?php echo number_format($amt, 2, '.', ','); ?></td>
            <td align="right"><?php echo number_format($offbalamt, 2, '.', ','); ?></td>
            <td align="center"><?php echo $bildat; ?></td>
            </tr>
            <?php
            $offbalamtAll += $offbalamt;
            $amtAll += $amt;
            $curamtAll += $curamt;
            $arrearsAll += $arrears;

$j++;
          }//while(($row2 = oci_fetch_object($stmt2)) != false){
           ?>
           <tr style="background-color:#ecf0f1;">
             <td colspan="3" align="right"> <b> Total</b></td>
             <td align="right"> <b> RM &nbsp; <?php echo number_format($curamtAll, 2, '.', ','); ?></b></td>
             <td align="right"> <b> RM &nbsp; <?php echo number_format($arrearsAll, 2, '.', ','); ?></b></td>
             <td align="right"> <b> RM &nbsp; <?php echo number_format($amtAll, 2, '.', ','); ?></b></td>
             <td align="right"> <b> RM &nbsp; <?php echo number_format($offbalamtAll, 2, '.', ','); ?></b></td>
             <td>&nbsp;</td>
           </tr>
          
        </table>

<?php //echo $q1; ?>
</page>