One Hat Cyber Team

Edit File: printRepRcplistView.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: 3px;"><u>COLLECTION REPORT<?php //echo $colctr.':'.$rcpdateFrom.':'.$rcpdateTo.':'.$reptype.':'.$revcod.':'.$bankcod.':'.$machine.':'.$paycod; ?></u></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td></td>
            <td></td>
          </tr>
          <tr>
            <td>Report</td>
            <td>:</td>
            <td><b>List of Receipts</b></td>
          </tr>
          <tr>
            <td>Collection Center</td>
            <td>:</td>
            <td><b><?php echo strtoupper($stationName); ?></b></td>
          </tr>
          <tr>
            <td>Date</td>
            <td>:</td>
            <td><b><?php echo $rcpDateView; ?></b></td>
          </tr>
          <tr>
            <td>Printed On</td>
            <td>:</td>
            <td><b><?php echo $t2day; ?></b></td>
          </tr>
  
        </table>
        <br><br>

<?php 
      $amt3 = 0;
      while(($row1 = oci_fetch_object($stmt1)) != false){
        $revcodName = $row1->DESCR;
        $revcod = trim($row1->REVCOD);
        $lab1 = $revcod.' '.$revcodName;
          ?>
        
        <table id="table2" border="1" style="border-collapse: collapse;width:90%;font-size: 12px;">
        <?php

$sql2 = "SELECT A.ACCNUM, A.BILNUM, A.STNCOD, A.MACHNUM, A.RCPNUM, TO_CHAR(A.COLDATE,'DD-MM-YYYY') AS CDATE, A.AMT, B.ABRV FROM POS_RECEIPT A, EPPAYCOD B WHERE A.REVCOD='$revcod' AND A.VOIDFLG='0' AND A.PAYMOD=B.PAYCOD {$wh1} ORDER BY A.ACCNUM ASC ";
        $stmt2  = oci_parse($conn, $sql2);
        $e2 = oci_execute($stmt2) or die(print_r(oci_error($stmt2)));
          ?>
          <thead>
          <tr style="background-color:#ecf0f1;">
            <td align="left" colspan="9"><b><?php echo strtoupper($lab1); ?></b></td>
          </tr>
          <tr>
            <td align="center" style="width: 5%;"><b>No</b></td>
            <td align="center" style="width: 20%;"><b>Account No</b></td>
            <td align="center" style="width: 20%;"><b>Bill No</b></td>
            <td align="center" style="width: 10%;"><b>Collection Center</b></td>
            <td align="center" style="width: 10%;"><b>Machine</b></td>
            <td align="center" style="width: 15%;"><b>Receipt No</b></td>
            <td align="center" style="width: 10%;"><b>Date</b></td>
            <td align="center" style="width: 10%;"><b>Amount</b></td>
            <td align="center">&nbsp;</td>
          </tr>
          </thead>
        <?php
        $amt2 = 0;
        $j = 1;
        while(($row2 = oci_fetch_object($stmt2)) != false){
          $accnum = trim($row2->ACCNUM);
          $bilnum = trim($row2->BILNUM);
          $colctr2 = trim($row2->STNCOD);
          $machnum = trim($row2->MACHNUM);
          $rcpnum = trim($row2->RCPNUM);
          $cdate = $row2->CDATE;
          $amt = $row2->AMT;
          $abrv = $row2->ABRV;

$amt2 += $amt;
          ?>
          <tr>
            <td align="center"><?php echo $j; ?></td>
            <td align="center"><?php echo $accnum; ?></td>
            <td align="center"><?php echo $bilnum; ?></td>
            <td align="center"><?php echo $colctr2; ?></td>
            <td align="center"><?php echo $machnum; ?></td>
            <td align="center"><?php echo $rcpnum; ?></td>
            <td align="center"><?php echo $cdate; ?></td>
            <td align="right"><?php echo number_format($amt, 2, '.', ','); ?></td>
            <td align="center"><?php echo $abrv; ?></td>
          </tr>
          <?
          $j++;
        }//while(($row2 = oci_fetch_object($stmt2)) != false){
        $amt3 += $amt2;
        ?>
          <tr style="background-color:#ecf0f1;">
            <td colspan="7" align="right"><b><i>Total</i></b></td>
            <td align="right"><b><i><?php echo number_format($amt2, 2, '.', ',') ?></i></b></td>
            <td>&nbsp;</td>
           </tr>
          </table>
        <br>
        
        <?php
        }//while(($row1 = oci_fetch_object($stmt1)) != false){
         ?>
       
       
          
        <table id="table3" border="0" width="100%">
          <tr>
            <td>&nbsp;</td>
            <td align="right"><h4><b>TOTAL ALL : </b></h4></td>
            <td align="right"><h4><b>RM <?php echo number_format($amt3, 2, '.', ','); ?></b></h4></td>
          </tr>
        </table>

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