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 : printOutRep.php

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

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

.container{
    display: flex;
}
.fixed{
    width: 200px;
}

table#table1  td{
  padding: 0px;
  /*background-color: yellow;*/
}

td {
  padding: 4px;
}

table#table2  td{
  border : 1px solid black;
  border-collapse: collapse;
  font-size: 11px;
}

table#table3  td{
  border : 1px solid black;
  border-collapse: collapse;
  font-size: 11px;
}

table#table5  td{
  border : 1px solid black;
  border-collapse: collapse;
  font-size: 11px;
}

table#table4  td{
  border : 0px;
  font-size: 12px;
}

/*.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>


<?php 
// $s=mysqli_query($mysqli, $q1) or die(mysqli_connect_error());
// while($r1=mysqli_fetch_array($s)){
//   $stanam = $r1['STANAM'];
//   $machnum = $r1['MACHNUM'];
//   $accnum = $r1['ACCNUM'];
//   $coldat = $r1['COLDAT'];
//   $cashierid = $r1['CASHIERID'];
//   $bilnum = $r1['BILNUM'];
//   $amount = $r1['AMOUNT'];
//     $amount = number_format($amount, 2, '.', ',');
//   $abrv = $r1['ABRV'];
 ?>
    
<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><b>DAILY COLLECTION REPORT</b></h4>
    <table border='0' id="table4">
      <tr>
        <td width='150px;'>Branch</td>
        <td width='10px;'>:</td>
        <td width='470px;'><?php echo $namaBranch; ?></td>
      </tr>
      <tr>
        <td>Batchnum</td>
        <td>:</td>
        <td><?php echo $batchnum; ?></td>
      </tr>
      <tr>
        <td>Machine</td>
        <td>:</td>
        <td><?php echo $machnam; ?></td>
      </tr>
      <tr>
        <td>Date</td>
        <td>:</td>
        <td><?php echo $lab1; ?></td>
      </tr>
      <tr>
        <td>Cashier</td>
        <td>:</td>
        <td><?php echo $lab2; ?></td>
      </tr>
      <tr>
        <td colspan="3" align="center"><hr></td>
      </tr>
      <tr>
        <td>Receipt No (Start - End)</td>
        <td>:</td>
        <td><?php echo $minrcp.' - '.$maxrcp; ?></td>
      </tr>
      <tr>
        <td>Valid Receipt</td>
        <td>:</td>
        <td><?php echo number_format($bilsah,0,'.',',').' - RM '.number_format($amtsah,2,'.',','); ?></td>
      </tr>
      <tr>
        <td>Void Receipt</td>
        <td>:</td>
        <td><?php echo number_format($bilvoid,0,'.',',').' - RM '.number_format($amtvoid,2,'.',','); ?></td>
      </tr>
    </table>

<br>

<table border='0' id="table1">
      <tr>
        <td width='300px;' valign="top">
          
          <table border="1" style="border-collapse: collapse;" id="table2">
            <tr style="background-color: #eaeded;">
              <td align="center" width="90px;"><b>RM</b></td>
              <td align="center" width="70px;"><b>QUANTITY</b></td>
              <td align="center" width="90px;"><b>TOTAL</b></td>
            </tr>
             <tr>
              <td align="center">RM 100.00</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="center">RM 50.00</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="center">RM 20.00</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="center">RM 10.00</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="center">RM 5.00</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="center">RM 1.00</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="center">COINS</td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="left"><b>TOTAL CASH</b></td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="left"><b>CHEQUE</b></td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="left"><b>CREDIT CARD</b></td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr>
              <td align="left"><b>PO/MO</b></td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
            <tr style="background-color: #eaeded;">
              <td align="right"><b>TOTAL ALL</b></td>
              <td align="center">&nbsp;</td>
              <td align="center">&nbsp;</td>
            </tr>
          </table>
          
        </td>
        <td width='300px;' valign="top">
          
          <table border="1" width='300px;' style="border-collapse: collapse;table-layout: fixed;" id="table5">
            
            <tr style="background-color: #eaeded;">
              <td align="center" width="120px;"><b>PAYMENT MODE</b></td>
              <td align="center" width="90px;"><b>QUANTITY</b></td>
              <td align="center" width="90px;"><b>AMOUNT (RM)</b></td>
            </tr>
            <tbody>
            <?php 
            // $sql6 = "SELECT PAYCOD, DESCR FROM EPPAYCOD WHERE PAYCOD!='0' ORDER BY PAYCOD ASC ";
            // $s=oci_parse($conn, $sql6);
            // $r = oci_execute($s);
            $tot = 0;
            $totbil = 0;
            $bil2 = 0;
            $amt2 = 0;
            $amt3 = 0;
            $i = 1;
            while($row6=oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){
              $paycod = $row6['PAYCOD'];
              $namaPaycod = $row6['DESCR'];
              if($paycod == '1'){
                $bil2 = $biltunai;
                $amt2 = $amttunai2;
                $amt3 = $amttunai;
              }else if($paycod == '2'){
                $bil2 = $bilceksr;
                $amt2 = $amtceksr2;
                $amt3 = $amtceksr;
              }else if($paycod == '3'){
                $bil2 = $bilcektm;
                $amt2 = $amtcektm2;
                $amt3 = $amtcektm;
              }else if($paycod == '4'){
                $bil2 = $bilceklr;
                $amt2 = $amtceklr2;
                $amt3 = $amtceklr;
              }else if($paycod == '5'){
                $bil2 = $bilpomo;
                $amt2 = $amtpomo2;
                $amt3 = $amtpomo;
              }else if($paycod == '6'){
                $bil2 = $bilkadkr;
                $amt2 = $amtkadkr2;
                $amt3 = $amtkadkr;
              }else if($paycod == '7'){
                $bil2 = $bileft;
                $amt2 = $amteft2;
                $amt3 = $amteft;
              }else if($paycod == '8'){
                $bil2 = $bilkardb;
                $amt2 = $amtkardb2;
                $amt3 = $amtkardb;
              }else{
                $bil2 = 0;
                $amt2 = '0.00';
                $amt3 = 0;
              }
              $tot += $amt3;
              $totbil += $bil2;
              ?>
              <tr>
                <td align="center"> <?php echo $namaPaycod; ?> </td>
                <td align="center"> <?php echo $bil2; ?> </td>
                <td align="right"> <?php echo $amt2; ?> </td>
              </tr>
              <?php  $i++;
            }//while($row6=oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){
              $tot2 = number_format($tot,2,'.',',');
              $totbil2 = number_format($totbil,0,'.',',');
             ?>
          </tbody>
          <tfoot>
            <tr style="background-color: #eaeded;">
              <td align="right"><b>TOTAL </b></td>
              <td align="center"><b> <?php echo $totbil2; ?> </b></td>
              <td align="right"><b> <?php echo number_format($tot,2,'.',','); ?> </b></td>
            </tr>
          </tfoot>
          </table>
          
          <br><br>
          
          <table border="1" width='300px;' style="border-collapse: collapse;table-layout: fixed;" id="table3">
            
            <tr style="background-color: #eaeded;">
              <td align="center" valign='middle' width="120px;"><b>TRANSACTION CODE</b></td>
              <td align="center" valign='middle' width="90px;"><b>QUANTITY</b></td>
              <td align="center" valign='middle' width="90px;"><b>AMOUNT (RM)</b></td>
            </tr>
            <tbody>
                <?php 
                $j = 1;
                $tot3 = 0; 
                $tot4 = 0; 
                $s=oci_parse($conn, $sql4);
                $r = oci_execute($s);
                
                while($row4=oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){
                  $revcod = $row4['REVCOD'];
                  $amtrevcod = $row4['AMTREVCOD'];
                  
                  $bilRev = $row4['BIL'];

$sql42 = "SELECT DESCR FROM EPREVENUE WHERE REVCOD = '$revcod' ";
                  $s42=oci_parse($conn, $sql42);
                  $r = oci_execute($s42);
                  $row42=oci_fetch_array($s42, OCI_ASSOC+OCI_RETURN_NULLS);
                  $revName = $row42['DESCR'];

$tot3 += $bilRev;
                  $tot4 += $amtrevcod;

$revName = $revcod.' - '.$revName;
                  $a = strlen($revName);
                  if($a>25){
                    $b = substr($revName,0,25);
                    $c = '<br>';
                    $d = substr($revName,25);
                  }else{
                    $b = $revName;
                    $c = '';
                    $d = '';
                  }
                  ?>
                  <tr>
                    <td align="left"> <?php echo $b.$c.$d; //echo $revcod.' - '.$revName; ?> </td>
                    <td align="center"> <?php echo $bilRev; ?> </td>
                    <td align="right"> <?php echo number_format($amtrevcod,2,'.',','); ?> </td>
                  </tr>
                  <?php
                  $j++;
                }//while($row4=oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){
                 ?>
              </tbody>
              <tfoot>
              <tr style="background-color: #eaeded;">
                <td align="right"><b>TOTAL </b></td>
                <td align="center"><b> <?php echo number_format($tot3,0,'.',','); ?> </b></td>
                <td align="right"><b> <?php echo number_format($tot4,2,'.',','); ?> </b></td>
              </tr>
          </tfoot>
          </table>
          
        </td>
      </tr>
    </table>

</page>

<?php //}//while($r1=oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){ ?>

${this.title}

Code Editor : printOutRep.php