One Hat Cyber Team

Edit File: printRepPaymodView.php

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

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

.container{
    display: flex;
}
.fixed{
    width: 200px;
}
td, th{
  padding: 5px;
}

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 Transaction Code</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>
        
  <table id="table1" border="1" width="100%" style="border-collapse: collapse;">
  <thead>
    <tr style="background-color:#ecf0f1;">
      <td align="center" style="width: 5%;"><b>No</b></td>
      <td align="center" style="width: 30%;"><b>Group Code</b></td>
      <td align="center"><b>Transaction Code</b></td>
      <?php 
      $i=0;
      $mesin = array();

while(($row1 = oci_fetch_object($stmt1)) != false){
        $machnum = $row1->MACHNUM;
        array_push($mesin, $machnum);
        ${"totMach" . $i} = 0;
        $i++;
        ?>
        <td align="center"><b><?php echo $machnum; ?></b></td>
        <?php
      }
      $bilMesin = count($mesin);

?>
       <td align="center"><b>Total</b></td>
    </tr>
  </thead>
  <tbody>
    <?php 
    $j=0;
    while(($row2 = oci_fetch_object($stmt2)) != false){
      $j++;
      $grpnum = $row2->GRPNUM;
      $grpname = $row2->DESCR;
       $sql3 = "SELECT      
            B.REVCOD,
                  B.DESCR
          FROM POS_RECEIPT A, EPREVENUE B
          WHERE A.VOIDFLG='0' AND A.REVCOD=B.REVCOD AND B.GRPNUM='$grpnum' {$wh3} GROUP BY B.REVCOD,B.DESCR ORDER BY B.REVCOD,B.DESCR";
      $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;
      $m = 0;
      while($m < $bilMesin){
        ${"totGrpMach" . $m} = 0;
        $m++;
      }
      while(($row3 = oci_fetch_object($stmt3)) != false){
        $revcod = $row3->REVCOD;
        $revName =  ucwords(strtolower($row3->DESCR));
        ?>
        <tr>
        <td align="center" style="border-bottom: none;"><?php if($k==1){echo $j;} ?></td>
        <td class="text-uppercase" style="border-bottom: none;"><?php if($k==1){ echo $grpnum.' '.$grpname; } ?></td>
        <td style="border-left: none;"><?php echo $revcod.' '.$revName; ?></td>
        <?php 
        $m = 0;
        $totRev = 0;
        while($m < $bilMesin){
          $machnum2 = $mesin[$m];
          $amt=0;
          $sql4 = "SELECT      
                SUM(AMT) AMT,
                B.REVCOD,
                      B.DESCR,
                A.MACHNUM
              FROM POS_RECEIPT A, EPREVENUE B, EPGROUPCOD C
              WHERE A.VOIDFLG='0' AND A.REVCOD=B.REVCOD AND B.GRPNUM=C.GRPNUM AND A.MACHNUM='$machnum2' AND A.REVCOD='$revcod' {$wh3} GROUP BY A.MACHNUM,B.REVCOD,B.DESCR";
          $stmt4  = oci_parse($conn, $sql4);
          $e4 = oci_execute($stmt4) or die(print_r(oci_error($stmt4)));
          if(($row4 = oci_fetch_object($stmt4)) != false){
            $amt = $row4->AMT;
          }//if(($row4 = oci_fetch_object($stmt4)) != false){
          ${"totGrpMach" . $m} = ${"totGrpMach" . $m} + $amt;
          $totRev = $totRev + $amt;
          ?><td align="right"> <?php echo number_format($amt, 2, '.', ','); ?></td><?php
          $m++;

}//while($m < $bilMesin){
         ?>
         <td align="right"><b><?php echo number_format($totRev, 2, '.', ','); ?></b></td>
        </tr> 
        <?php
          $k++;
      }//while(($row3 = oci_fetch_object($stmt3)) != false){
        ?>
        <tr>
          <td></td>
          <td></td>
          <td align="right" style="border-left: none;background-color:#BDE3FB;"><b>Total</b></td>
          <?php
          $m = 0;
          $totGrpMachAll = 0;
          while($m < $bilMesin){
            $totGrpMachAll = $totGrpMachAll + ${"totGrpMach" . $m};
            ${"totMach" . $m} += ${"totGrpMach" . $m};
            ?><td align="right" style="background-color:#BDE3FB;"><b><?php echo number_format(${"totGrpMach" . $m}, 2, '.', ','); ?></b></td><?php
            $m++;
          }
          ?>
          
          <td align="right" style="background-color:#BDE3FB;"><b><i><?php echo number_format($totGrpMachAll, 2, '.', ',') ;?></i></b></td>
        </tr>
        <?php

}//while(($row2 = oci_fetch_object($stmt2)) != false){
     ?>
  </tbody>
  
    <tr style="background-color:#ecf0f1;">
      <td align="right" colspan="3"> <b><i> TOTAL</i> </b></td>
      <?php
        $totAll = 0;
        $m = 0;
        while($m < $bilMesin){
          $totAll = $totAll + ${"totMach" . $m};
          ?><td align="right"><b><i><?php echo number_format(${"totMach" . $m}, 2, '.', ','); ?></i></b></td><?php
          $m++;
        }
        ?>
      <td align="right"><b><i><?php echo number_format($totAll, 2, '.', ',');  ?></i></b></td>
    </tr>
  
  </table>
  <?php //echo $mesin[0]; ?>
  
        <br><br>
    
   
     <?php //echo $q1; ?>
</page>