keuangan

<script language="JavaScript">
  function loadprint(){
  window.print();
}
</script>

<?php
    //include "header.php";
    include "tgl.php";
    include "../dateindo.php";
    include"../dbconnect.php";

    $batas=1;
    $halaman=$_GET['halaman'];
    if(empty($halaman))
    {
        $posisi=0;
        $halaman=1;
    }else
        {
          $posisi = ($halaman-1) * $batas;
        }
?>


<link rel="stylesheet" type="text/css" href="print.css" />

<body onLoad="loadprint();">
    <div align="center">
        <font size="+1"><br>BUKU BESAR</font><br><br>
    </div>
 <?php
      $query ="SELECT buku_besar.*, akun.nama_akun, akun.id_group_akun, akun.kode_akun FROM buku_besar JOIN akun ON (akun.id_akun=buku_besar.id_akun) GROUP BY id_akun ORDER BY kode_akun ASC" ;
      $hasil = mysql_query($query);
      while ($data_group = mysql_fetch_array($hasil))
      {
?>
    <table width="100%" border="0" align="center">
       <tr>
          <td><b>Nama Akun : <?php echo $data_group['nama_akun']; ?></b></td>
          <td align="right"><b>Kode Akun : <?php echo $data_group['kode_akun']; ?></b></td>
       </tr>
    </table>


    <table width="100%" border="1" style=border-collapse:collapse align="center">
    <thead>
        <tr>
           <th rowspan="2" valign="middle" style="width:5%">#</th>
           <th rowspan="2" style="width:10%">Tanggal</th>
           <th rowspan="2" style="width:35%">Keterangan</th>
           <th rowspan="2" style="width:10%">No Bukti</th>
           <th rowspan="2" style="width:10%">Debet</th>
           <th rowspan="2" style="width:10%">Kredit</th>
           <th rowspan="2" style="width:10%">Saldo</th>
       </tr>
    </thead>
    <tbody>
    <?php
     $noUrut=1;
     $total=0;
     $totdebet=0;
     $totkredit=0;
     $sql_data=mysql_query("SELECT * FROM buku_besar WHERE  id_akun ='".$data_group['id_akun']."' ORDER BY id_buku_besar ASC");
     while ($data=mysql_fetch_object($sql_data))
     {
    ?>
       <tr align="right">
          <td class="align-center"><?php echo $noUrut++; ?></td>
          <td class="align-center"><?php echo DateIndo($data->tgl); ?></td>
          <td align="left"><?php echo $data->ket; ?></td>
          <td class="align-center"><?php echo $data->no_bukti; ?></td>
          <td><?php echo (($data->debet1=="") ? '-' : number_format($data->debet1,0,',','.')); ?></td>
          <td><?php echo (($data->kredit1=="") ? '-' : number_format($data->kredit1,0,',','.')); ?></td>
          <td>
             <?php
               $total= $total + ($data->debet1-$data->kredit1);
               $totdebet = $totdebet + $data->debet1;
               $totkredit = $totkredit + $data->kredit1;
               echo number_format($total,0,',','.');
             ?>
          </td>
       </tr>
    <?php } ?>
       <tr align="right">
            <td colspan="4" class="align-center">TOTAL</td>
            <td><?php echo $totdebet; ?></td>
            <td><?php echo $totkredit; ?></td>
            <td><?php echo $total; ?></td>
       </tr>
    </tbody>
    </table>
<?php } ?>

</body>