Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
printApplicant.php	7.98 KB	-rw-rw-rw-
printBill - Copy.php	12.37 KB	-rw-rw-rw-
printBill.php	33.21 KB	-rw-rw-rw-
printBillReissue.php	31.76 KB	-rw-rw-rw-
printBill_con.php	11.78 KB	-rw-rw-rw-
printBill_dev.php	21.62 KB	-rw-rw-rw-
printImpListView.php	4.87 KB	-rw-rw-rw-
printOutRep.php	12.41 KB	-rw-rw-rw-
printPayBillView.php	6.55 KB	-rw-rw-rw-
printPayRcp.php	4.17 KB	-rw-rw-rw-
printRcp.php	3.66 KB	-rw-rw-rw-
printRcpView.php	8.83 KB	-rw-rw-rw-
printRcptView.php	8.91 KB	-rw-rw-rw-
printRepCardView.php	8.21 KB	-rw-rw-rw-
printRepChqView.php	8.54 KB	-rw-rw-rw-
printRepChqView_20210711.php	8.54 KB	-rw-rw-rw-
printRepPaymod2View.php	7.47 KB	-rw-rw-rw-
printRepPaymodView.php	9.04 KB	-rw-rw-rw-
printRepPomoView.php	6.43 KB	-rw-rw-rw-
printRepRcplistView.php	6.93 KB	-rw-rw-rw-
printRepVoidrcpView.php	6.73 KB	-rw-rw-rw-
printUnpaid.php	7.41 KB	-rw-rw-rw-
printUserBill.php	23.45 KB	-rw-rw-rw-

Code Editor : printRepVoidrcpView.php

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

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

.container{
    display: flex;
}
.fixed{
    width: 200px;
}
td, th{
  padding: 5px;
}
/*.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 Void 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;">
            <th align="left" colspan="9"><b><?php echo strtoupper($lab1); ?></b></th>
          </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>
        <tbody>
        <?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){

/*
        $ha = $j;
        while($ha < 50){
          ?>
          <tr>
            <td align="center"> <?php echo $ha; ?> </td>
            <td colspan="8">testing</td>
          </tr>

<?php
          $ha++;
        }
        */

$amt3 += $amt2;
        ?>
          </tbody>
          <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><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>

${this.title}

Code Editor : printRepVoidrcpView.php