One Hat Cyber Team

Edit File: printImpListView.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: 11px;*/
  /*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>
    
    <h4>RECEIPTS DETAIL FOR <i><?php echo $fileName; ?></i></h4>
    <table id="table2" border="1" style="border-collapse: collapse;width:100%;font-size: 12px;">
      <thead>
        <tr style="background-color:#ecf0f1;">
          <th align="center" style="width: 5%">No</th>
          <th align="center">Transaction Code</th>
          <th align="center">Account No</th>
          <th align="center">Receipt No</th>
          <th align="center">Bill No</th>
          <th align="center">Pay Mode</th>
          <th align="center">Amount (RM)</th>
          <th align="center">Status</th>
        </tr>
      </thead>
      <tbody>
        <?php 
        $s1   = oci_parse($conn, $q1);
        oci_execute($s1) or die(print_r(oci_error($s1)));
         $i=1;
          $tot_amt = 0;
          $tot_paid = 0;
          $tot_void = 0;
          while($r1=oci_fetch_array($s1, OCI_ASSOC+OCI_RETURN_NULLS)){
            $bilnum = $r1['BILNUM'];
            $amt = $r1['AMT'];
              $amt2 = number_format($amt,2,'.',',');
            $rcpdate = $r1['COL_DATE'];
            $paydesc = $r1['PAYMOD_DESC'];
            $cashierName = $r1['CASHIER_NAME'];
            $machine = $r1['MACHNUM'].' - '.$r1['MACHNAM'].' ( '.$r1['STANAM'].' )';
            $paycod = $r1['PAYMOD'];
            $rcpnum = $r1['RCPNUM'];
            $refnum = $r1['REFNUM'];
            $bankcod = $r1['BANKCOD'];
            $bankname = $r1['BANK_NAME'];
            $brancod = $r1['BRANCOD'];
            $authcod = $r1['AUTHCOD'];
            $voidstat = $r1['VOID_STATUS'];
            $voidflg = $r1['VOIDFLG'];
            $revcod = $r1['REVCOD'];
            $revcod_descr = $r1['REVCOD_NAME'];
            $accno = $r1['ACCNUM'];

$tot_amt += $amt;
            if($voidflg=='0'){
              $tot_paid += $amt;
            }else{
              $tot_void += $amt;
            }

if($voidflg=='0'){
              $col='blue';
            }else{
              $col='red';
            }
        ?>
        <tr>
        <td align="center" style="width: 5%;"><?php echo $i?></td>
        <td align="left"><?php echo $revcod.' - '.$revcod_descr;?></td>
        <td align="center"><?php echo $accno;?></td> 
        <td align="center"><?php echo $rcpnum; ?></td>
        <td align="center"><?php echo $bilnum;?></td>
        <td align="center"><?php echo $paydesc;?></td>
        <td align="center"><?php echo $amt2;?></td>
        <td align="center" style="color: <?php echo $col; ?> ;"><?php echo $voidstat;?></td>
      </tr>
      <?php
            $i++;
          }
          /*while($i < 100){
            ?>
            <tr>
              <td colspan="7">testing</td>
            </tr>
            <?
            $i++;
          }*/
          $tot_amt2 = number_format($tot_amt,2,'.',',');
          $tot_paid2 = number_format($tot_paid,2,'.',',');
          $tot_void2 = number_format($tot_void,2,'.',',');
         ?>
      </tbody>
      <tfoot>
        <tr style="background-color:#ecf0f1;">
          <td colspan="6" align="right"><b><i>Total Paid : <br> Total Void : </i> <br> TOTAL : </b></td>
          <td align="right"><b><i><?php echo $tot_paid2.'<br>'.$tot_void2.'</i><br>'.$tot_amt2; ?></b></td>
          <td>&nbsp;</td>
        </tr>
      </tfoot>
    </table>
   
    
</page>