<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<link href="SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table width="90%" border="0" align="center" cellpadding="4" cellspacing="4">
  <tr>
    <td>
          
            <div id="TabbedPanels1" class="TabbedPanels">
              <ul class="TabbedPanelsTabGroup">
<li class="TabbedPanelsTab" tabindex="0">Neraca Awal</li>
              </ul>
              <div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">
            <?php
				mysql_select_db($database_sistem, $sistem);
$query_saldo_awal = "SELECT * FROM saldo_tb where kode_unit='-' order by id asc";
$saldo_awal = mysql_query($query_saldo_awal, $sistem) or die(mysql_error());
$row_saldo_awal = mysql_fetch_assoc($saldo_awal);
$totalRows_saldo_awal = mysql_num_rows($saldo_awal);

mysql_select_db($database_sistem, $sistem);
$query_unit = "SELECT * FROM user_tb WHERE user_tb.`level`='Unit'";
$unit = mysql_query($query_unit, $sistem) or die(mysql_error());
$row_unit = mysql_fetch_assoc($unit);
$totalRows_unit = mysql_num_rows($unit);

				?>

      <table width="95%" align="center" cellpadding="2" cellspacing="2" class="form_body">
                    <tr>
                      <td height="35" colspan="8" align="center"><table width="100%" border="0" align="center" cellpadding="2" cellspacing="2" class="form_body">
                        <tr align="center">
                          <td background="images/bg1.png"  height="30">kode unit</td>
                          <td background="images/bg1.png">nama unit</td>
                          <td background="images/bg1.png">alamat</td>
                          <td background="images/bg1.png">telp</td>
                          <td background="images/bg1.png">email</td>
                          <td background="images/bg1.png">direktur</td>
                          <td background="images/bg1.png">bendahara</td>
                          <td background="images/bg1.png">nama admin</td>
                        </tr>
                        <tr align="center">
                          <td colspan="8"><hr /></td>
                        </tr>
                        <?php do { ?>
                        <tr align="center">
                          <td><a href="?module=show_nrc&amp;kodenya=<?php echo $row_unit['kode_unit'];?>"><?php echo $row_unit['kode_unit']; ?></a></td>
                          <td><?php echo $row_unit['nama_unit']; ?></td>
                          <td><?php echo $row_unit['alamat']; ?></td>
                          <td><?php echo $row_unit['telp']; ?></td>
                          <td><?php echo $row_unit['email']; ?></td>
                          <td><?php echo $row_unit['direktur']; ?></td>
                          <td><?php echo $row_unit['bendahara']; ?></td>
                          <td><?php echo $row_unit['nama_admin']; ?></td>
                        </tr>
                        <tr align="center">
                          <td colspan="8"><hr /></td>
                        </tr>
                        <?php } while ($row_unit = mysql_fetch_assoc($unit)); ?>
                      </table></td>
                    </tr>
                    <tr>
                      <td height="35" colspan="4" align="center" background="images/bg2.png">AKTIVA</td>
                      <td colspan="4" align="center" background="images/bg2.png">PASIVA</td>
                    </tr>
                    <tr>
                      <td height="35" align="center">AKUN</td>
                      <td height="35" colspan="3" align="left">AKTIVA LANCAR</td>
                      <td align="center">AKUN</td>
                      <td colspan="3" align="left">KEWAJIBAN</td>
                    </tr>
                    <tr>
                      <td colspan="8" align="center"></td>
                    </tr>
                    <tr>
                      <td width="100" height="25" align="center">1110</td>
                      <td width="169" height="25" align="left">KAS</td>
                      <td width="23" height="25" align="right">Rp</td>
                      <td width="64" height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1110']);?></td>
                      <td width="64" height="25" align="center">2110</td>
                      <td width="233" height="25" align="left">HUTANG USAHA</td>
                      <td width="23" height="25" align="right">Rp</td>
                      <td width="100" height="25"><?php echo formatRupiah($row_saldo_awal['col_2110']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1120</td>
                      <td height="25" align="left">BANK</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1120a']);?></td>
                      <td height="25" align="center">2120</td>
                      <td height="25" align="left">Titipan</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25"><?php echo formatRupiah($row_saldo_awal['col_2120']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td rowspan="4" align="left"><table class="isi_tabel" width="200" border="0" cellpadding="1">
                        <?php        mysql_select_db("csabrude_akurat");
					          $sql = mysql_query("SELECT * From bank_tb where kode_unit='$_SESSION[kode]' and jenis='Bank' order by kode_bank asc ");
					          $no = 1;
							
                    while ($r = mysql_fetch_array($sql)) {
                      echo "<tr>
                    <td>$r[kode_bank]</td>
                    <td align='right'>";?>
                        <?php echo formatRupiah($r['nominal']);?><?php echo"</td>
                  </tr>";
		 $no++;
                    }
                    ?>
                      </table></td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1120b']);?></td>
                      <td height="25" align="center">2130</td>
                      <td height="25" align="left">Sumbangan dengan Intensi</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25"><?php echo formatRupiah($row_saldo_awal['col_2130']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1120c']);?></td>
                      <td height="25" align="center">2140</td>
                      <td height="25" align="left">PENDAPATAN DITERIMA DIMUKA</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25"><?php echo formatRupiah($row_saldo_awal['col_2140']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1120d']);?></td>
                      <td height="25" align="center">2150</td>
                      <td height="25" align="left">BIAYA YG MASIH HARUS DIBAYAR</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25"><?php echo formatRupiah($row_saldo_awal['col_2150']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1120e']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1130</td>
                      <td height="25" align="left">DEPOSITO</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1130a']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td rowspan="4" align="left"><table class="isi_tabel" width="200" border="0" cellpadding="1">
                        <?php        mysql_select_db("csabrude_akurat");
					          $sql = mysql_query("SELECT * From bank_tb where kode_unit='$_SESSION[kode]'  and jenis='Deposito' order by kode_bank asc ");
					          $no = 1;
							
                    while ($r = mysql_fetch_array($sql)) {
                      echo "<tr>
                    <td>$r[kode_bank]</td>
                    <td align='right'>";?>
                        <?php echo formatRupiah($r['nominal']);?><?php echo"</td>
                  </tr>";
		 $no++;
                    }
                    ?>
                      </table></td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1130b']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1130c']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1130d']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1130e']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1140</td>
                      <td height="25" align="left">PIUTANG</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1140']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1150</td>
                      <td height="25" align="left">PERSEDIAAN</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1150']);?></td>
                      <td height="25" align="center">&nbsp;</td>
                      <td height="25" align="left">&nbsp;</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1160</td>
                      <td height="25" align="left">Piutang Lain</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1160']);?></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left"></td>
                      <td height="25" align="right"></td>
                      <td height="25"></td>
                    </tr>
                    <tr>
                      <td height="20" colspan="8" align="center"><hr/></td>
                    </tr>
                    <tr>
                      <td height="25" colspan="2" align="center">JUMLAH AKTIVA LANCAR</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right">&nbsp;</td>
                      <td height="25" colspan="2" align="center">JUMLAH KEWAJIBAN</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right">&nbsp;</td>
                    </tr>
                    <tr>
                      <td align="center"></td>
                      <td align="left"></td>
                      <td align="right"></td>
                      <td align="right"></td>
                      <td align="center"></td>
                      <td align="left"></td>
                      <td align="right"></td>
                      <td></td>
                    </tr>
                    <tr>
                      <td height="30" align="center"></td>
                      <td align="left">AKTIVA TETAP</td>
                      <td align="right"></td>
                      <td align="right"></td>
                      <td align="center"></td>
                      <td align="left"></td>
                      <td align="right"></td>
                      <td></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1210</td>
                      <td height="25" align="left">TANAH</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1210']);?></td>
                      <td height="25" align="center">3000</td>
                      <td height="25" align="left">MODAL</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_3000']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1220</td>
                      <td height="25" align="left">GEDUNG</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1220']);?></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left"></td>
                      <td height="25" align="right"></td>
                      <td height="25"></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1230</td>
                      <td height="25" align="left">KENDARAAN</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1230']);?></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left">SHU DITAHAN</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_shu']);?></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1240</td>
                      <td height="25" align="left">INVENTARIS</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1240']);?></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left"></td>
                      <td height="25" align="right"></td>
                      <td height="25"></td>
                    </tr>
                    <tr>
                      <td height="25" align="center"></td>
                      <td height="25" align="left">JUMLAH AKTIVA TETAP</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left">JUMLAH MODAL</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="25" align="center"></td>
                      <td height="25" align="left"></td>
                      <td height="25" align="right"></td>
                      <td height="25" align="right"></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left"></td>
                      <td height="25" align="right"></td>
                      <td height="25"></td>
                    </tr>
                    <tr>
                      <td height="25" align="center">1300</td>
                      <td height="25" align="left">AKUMULASI PENYUSUTAN</td>
                      <td height="25" align="right">Rp</td>
                      <td height="25" align="right"><?php echo formatRupiah($row_saldo_awal['col_1300']);?></td>
                      <td height="25" align="center"></td>
                      <td height="25" align="left"></td>
                      <td height="25" align="right"></td>
                      <td height="25"></td>
                    </tr>
                    <tr>
                      <td align="center"></td>
                      <td align="left"></td>
                      <td align="right"></td>
                      <td align="right"></td>
                      <td align="center"></td>
                      <td align="left"></td>
                      <td align="right"></td>
                      <td></td>
                    </tr>
                    <tr>
                      <td height="20" colspan="8" align="center"><hr/></td>
                    </tr>
                    <tr>
                      <td height="30" align="center"></td>
                      <td align="left">JUMLAH AKTIVA</td>
                      <td align="right">Rp</td>
                      <td align="right">&nbsp;</td>
                      <td align="center"></td>
                      <td align="left">JUMLAH MODAL DAN KEWAJIBAN</td>
                      <td align="right">Rp</td>
                      <td align="right">&nbsp;</td>
                    </tr>
                    <tr height="30">
                      <td background="images/bg1.png" colspan="8" align="center"></td>
                    </tr>
    </table></td>
   </tr>
 </table>
              
    </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script>
</body>
</html>