One Hat Cyber Team

Edit File: printRepChqView.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>Collection By Cheque</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 
        while(($row1 = oci_fetch_object($stmt1)) != false){
          $paycodName = $row1->DESCR;
          $paycod = trim($row1->PAYMOD);
          $amt3 = 0;
          $bil3 = 0;
          ?>
        
        <table id="table2" border="1" style="border-collapse: collapse;width:90%;font-size: 12px;">
          <thead>
          <tr style="background-color:#ecf0f1;">
            <td align="left" colspan="7"><b>LIST OF <?php echo strtoupper($paycodName); ?></b></td>
          </tr>
          <tr>
            <td align="center" style="width: 5%;"><b>No</b></td>
            <td align="center" style="width: 30%;"><b>Bank Code</b></td>
            <td>&nbsp;</td>
            <td align="center" style="width: 22%;"><b>Cheque No</b></td>
            <td align="center" style="width: 20%;"><b>Amount</b></td>
            <td align="center" style="width: 20%;"><b>Total</b></td>
          </tr>
          </thead>
        <?php

$sql2 = "SELECT A.BANKCOD, B.DESCR FROM POS_RECEIPT A, EPBANK B WHERE A.VOIDFLG='0' AND A.PAYMOD='$paycod' AND A.BANKCOD=B.BANKCOD {$wh1} GROUP BY A.BANKCOD, B.DESCR ORDER BY A.BANKCOD ASC ";
        $stmt2  = oci_parse($conn, $sql2);
        $e2 = oci_execute($stmt2) or die(print_r(oci_error($stmt2)));
        $j = 1;
        while(($row2 = oci_fetch_object($stmt2)) != false){
          $bankcod = trim($row2->BANKCOD);
          $bankName = $row2->DESCR;

$sql3 = "SELECT A.REFNUM, A.AMT FROM POS_RECEIPT A WHERE A.VOIDFLG='0' AND A.BANKCOD='$bankcod' AND A.PAYMOD='$paycod' {$wh1} ORDER BY A.REFNUM ASC  ";
          $stmt3  = oci_parse($conn, $sql3);
          $e3 = oci_execute($stmt3) or die(print_r(oci_error($stmt3)));

$stmt3x   = oci_parse($conn, $sql3);
          $e3x = oci_execute($stmt3x) or die(print_r(oci_error($stmt3x)));
          $jum3 = oci_fetch_all($stmt3x, $e3x);
          $jum3r = $jum3;
          $jum3 = $jum3+1;
          ?>
          
            <?php 
            $k=1;
            $amt2=0;
            while(($row3 = oci_fetch_object($stmt3)) != false){
              $refnum = trim($row3->REFNUM);
              $amt = $row3->AMT;
              $bil3++; 
              ?>
              <tr>
              <td align="center" style="border-bottom: none;"><?php if($k==1) {echo $j;} ?>&nbsp;</td>
              <td align="left"><?php echo $bankName; ?></td>
              <td align="center" style="border-left: none;"><?php echo $k; ?></td>
              <td align="center"><?php echo $refnum; ?></td>
              <td align="right"><?php echo number_format($amt, 2, '.', ','); ?></td>
              <td <?php if($jum3r!=$k){ ?> style="border-bottom: none;"<?php } ?>></td>
              </tr>
              <?php
              $amt2 += $amt;
              $k++;
            }//while(($row3 = oci_fetch_object($stmt3)) != false){
              $amt3 += $amt2;

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

<?php
                $ha++;
              }*/

?>
             
              <tr>
                <td></td>
                <td></td>
                <td align="right" style="background-color:#BDE3FB;" colspan="3"><b><i>Total</i></b></td>
                <td align="right" style="background-color:#BDE3FB;"><b><i><?php echo number_format($amt2, 2, '.', ',') ?></i></b></td>
             </tr>

<?
          $j++;
        }//while(($row2 = oci_fetch_object($stmt2)) != false){
        ?>
        <tr style="background-color:#ecf0f1;">
          <td colspan="5" align="right"><b>Total</b></td>
          <td align="right"><b><?php echo '[ '.$bil3.' Records ] : RM '.number_format($amt3, 2, '.', ','); ?></b></td>
        </tr>
          </table>
  
        <br><br>
        
        <?php
          }//while(($row1 = oci_fetch_object($stmt1)) != false){
           ?>
   
   
     <?php //echo $q1; ?>
</page>