<?PHP
mysql_connect("$server", "$username", "$password");
mysql_select_db("$database");
$query = "Select * from tab_dataperkara where t_id = '1'"; 
$result = mysql_query($query); 
if($row2 = mysql_fetch_array($result)){ 
$tabler = $row2['t_table'];?><style type="text/css">
<!--
body {
	margin-top: 0px;
	margin-left: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style1 {
	color: #FFFFFF;
	font-weight: bold;
}
-->
</style>




<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="26%" rowspan="8" valign="top">    <table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><div align="center">
          <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="392" height="60">
              <param name="movie" value="images/admin.swf">
              <param name="quality" value="high">
              <embed src="images/admin.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="392" height="60"></embed>
          </object>
        </div></td>
      </tr>
    </table>
      <table width="400" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="111" background="images/kiri1_a.jpg"><table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td><strong>10 TAMU TERAKHIR </strong></td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td background="images/kiri1_b.jpg"><table width="350"  border="0" align="center" cellpadding="2" cellspacing="2">
              <tr>
                <td><iframe src="index.bukutamu.php" width="100%" height="200px" frameborder="0" scrolling="no"></iframe></td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td><img src="images/kiri1_c.jpg" width="400" height="57"></td>
        </tr>
      </table>
      <table width="400" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="111" background="images/kiri1_d.jpg"><table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><strong>JADWAL SIDANG HARI INI </strong></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td background="images/kiri1_b.jpg"><table width="350"  border="0" align="center" cellpadding="2" cellspacing="2">
          <tr>
            <td><iframe src="index.jadwalsidang.php" width="100%" height="200px" frameborder="0" scrolling="no"></iframe></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><img src="images/kiri1_c.jpg" width="400" height="57"></td>
      </tr>
    </table>
    <table width="400" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="111" background="images/kiri1_a.jpg"><table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td><strong>BESUK TAHANAN </strong></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td background="images/kiri1_b.jpg"><table width="350"  border="0" align="center" cellpadding="2" cellspacing="2">
          <tr>
            <td><iframe src="index.jadwalpembesuk.php" width="100%" height="200px" frameborder="0" scrolling="no"></iframe></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><img src="images/kiri1_c.jpg" width="400" height="57"></td>
      </tr>
    </table>    </td>
    <td width="74%" background="../themes/camelon_b.jpg"><table width="100%"  border="0" cellspacing="6" cellpadding="6">
      <tr>
        <td><span class="style1">INFORMASI DISPOSISI PERSURATAN</span></td>
      </tr>
      <tr>
        <td height="250"><iframe src="index.disposisisuratkajari.php" width="100%" height="250px" frameborder="0" scrolling="auto" allowTransparency="true"></iframe></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="20%" valign="top"><div align="center"><img src="images/pembinaan.jpg" width="100" height="100"></div></td>
              <td width="80%"><table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#FFFFCC">
                    <td><strong>PEMBINAAN</strong></td>
                  </tr>
                  <tr>
                    <td><hr></td>
                  </tr>
                  <tr>
                    <td valign="top"><b> </b>
                      <table width="100%"  border="0" cellspacing="1" cellpadding="1">
                        <tr>
                          <td><b><strong>
                            <?php

$link = mysql_connect("$server", "$username", "$password"); mysql_select_db("$database", $link);
$result1 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='1'", $link);
$num_rows = mysql_num_rows($result1);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">JAKSA</td><td width="5%">:</td>
<td width="59%">'.$num_rows.'</td></tr></table>');
$result2 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='2'", $link);
$num_rows2 = mysql_num_rows($result2);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">PEMBINAAN</td><td width="5%">:</td>
<td width="59%">'.$num_rows2.'</td></tr></table>');
$result3 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='3'", $link);
$num_rows3 = mysql_num_rows($result3);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">INTELIJEN</td><td width="5%">:</td>
<td width="59%">'.$num_rows3.'</td></tr></table>');
$result4 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='4'", $link);
$num_rows4 = mysql_num_rows($result4);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">PIDUM</td><td width="5%">:</td>
<td width="59%">'.$num_rows4.'</td></tr></table>'); 
$result5 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='5'", $link);
$num_rows5 = mysql_num_rows($result5);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">PIDSUS</td><td width="5%">:</td>
<td width="59%">'.$num_rows5.'</td></tr></table>');

$result6 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='6'", $link);
$num_rows6 = mysql_num_rows($result6);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">DATUN</td><td width="5%">:</td>
<td width="59%">'.$num_rows6.'</td></tr></table>');
$result9 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='7'", $link);
$num_rows9 = mysql_num_rows($result6);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">RANGBUKPAS</td><td width="5%">:</td>
<td width="59%">'.$num_rows9.'</td></tr></table>');


$result8 = mysql_query("SELECT * FROM tab_personil where daftar_jenis ='7'", $link);
$num_rows8 = mysql_num_rows($result8);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">HONORER</td><td width="5%">:</td>
<td width="59%">'.$num_rows8.'</td></tr></table>');
$result7 = mysql_query("SELECT * FROM tab_personil", $link);
$num_rows7 = mysql_num_rows($result7);
print ('<table width="100%"  border="0" cellspacing="2" cellpadding="2"><tr>
<td width="36%">TOTAL</td><td width="5%">:</td>
<td width="59%">'.$num_rows7.' Pegawai & Honorer</td></tr></table>');
?>
                          </strong></b></td>
                        </tr>
                      </table>
                      <b> </b></td>
                    </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="13%" valign="top"><div align="center"><img src="images/tatausaha.png" width="151" height="100"></div></td>
              <td width="87%"><table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#CCCCCC">
                    <td><strong>TATA PERSURATAN &amp; PERPUSTAKAAN </strong></td>
                  </tr>
                  <tr>
                    <td><hr></td>
                  </tr>
                  <tr>
                    <td valign="top"><table width="100%"  border="0" cellspacing="1" cellpadding="1">
                      <tr>
                        <td>Informasi Persuratan </td>
                      </tr>
                      <tr>
                        <td>Perpustakaan
                            <?
$link = mysql_connect("localhost", "root", "benk"); mysql_select_db("cma", $link);
$result = mysql_query("SELECT * FROM perpustakaan", $link);
$num_rows = mysql_num_rows($result);
echo "<b>$num_rows</b> JUDUL BUKU";?></td>
                      </tr>
                    </table></td>
                    </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="20%" valign="top"><div align="center"><img src="images/intel.jpg" width="100" height="100"></div></td>
              <td width="80%"><table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#66FF99">
                    <td><strong>INTELIJEN</strong></td>
                    </tr>
                  <tr>
                    <td><hr></td>
                  </tr>
                  <tr>
                    <td>Indra Waspada </td>
                    </tr>
                  <tr>
                    <td height="100"><iframe src="../intel/notification.php" frameborder="0" width="100%" height="100px" scrolling="auto"></iframe></td>
                  </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="20%" valign="top"><div align="center"><img src="images/pidum.jpg" width="100" height="100"></div></td>
              <td width="80%"><table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#FF6666">
                    <td><strong>TINDAK PIDANA UMUM </strong></td>
                    </tr>
                  <tr>
                    <td><hr></td>
                    </tr>
                  <tr>
                    <td valign="top"><table width="100%"  border="0" cellspacing="2" cellpadding="2">
                      <tr>
                        <td><? 

$result1 = mysql_query("SELECT * FROM $tabler where late_spdp = '3'", $link);
$num_rows1 = mysql_num_rows($result1);
echo "Jumlah Berkas Perkara SPDP tanpa Berkas: <b>$num_rows1</b> Berkas\n<br><br>";

$result = mysql_query("SELECT * FROM $tabler where late_berkas = '3'", $link);
$num_rows = mysql_num_rows($result);
echo "Jumlah Berkas Perkara Berkas Terlambat Dinyatakan Sikap: <b>$num_rows</b> Berkas\n<br><br>";

$result = mysql_query("SELECT * FROM $tabler where late_p21 = '3'", $link);
$num_rows = mysql_num_rows($result);
echo "Jumlah Berkas Perkara Berkas Terlambat P21: <b>$num_rows</b> Berkas\n<br><br>";

$result = mysql_query("SELECT * FROM $tabler where late_p31 = '3'", $link);
$num_rows = mysql_num_rows($result);
echo "Jumlah Berkas Perkara Berkas Terlambat Untuk Dilimpahkan: <b>$num_rows</b> Berkas\n<br><br>";
?>
                            <? } ?></td>
                      </tr>
                    </table></td>
                    </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="20%" valign="top"><div align="center"><img src="images/pidsus.jpg" width="100" height="100"></div></td>
              <td width="80%">                <table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#FF99CC">
                    <td><strong>TINDAK PIDANA KHUSUS </strong></td>
                  </tr>
                  <tr>
                    <td><hr></td>
                  </tr>
                  <tr>
                    <td valign="top"><table width="100%"  border="0" cellspacing="8" cellpadding="8">
                      <tr>
                        <td width="34%">TOTAL PERKARA PENYIDIKAN </td>
                        <td width="4%">:</td>
                        <td width="62%"><b>
                          <?php

$link = mysql_connect("localhost", "root", "benk"); mysql_select_db("cma_pidsus", $link);
$result = mysql_query("SELECT * FROM p_perkara where berkas_p21 !=''", $link);
$num_rows = mysql_num_rows($result);
echo "$num_rows"; ?>
                        </b></td>
                      </tr>
                      <tr>
                        <td>TOTAL PERKARA PENUNTUTAN </td>
                        <td>:</td>
                        <td><b>
                          <?php

$link = mysql_connect("localhost", "root", "benk"); mysql_select_db("cma_pidsus", $link);
$result = mysql_query("SELECT * FROM p_perkara where berkas_limpahp31tgl !=''", $link);
$num_rows = mysql_num_rows($result);
echo "$num_rows"; ?>
                        </b></td>
                      </tr>
                    </table></td>
                    </tr>
                </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="20%"><div align="center"><img src="images/datun.png" width="100" height="100"></div></td>
              <td width="80%">                <table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#FFFF66">
                    <td><strong>PERDATA DAN TATA USAHA NEGARA </strong></td>
                  </tr>
                  <tr>
                    <td><hr></td>
                  </tr>
                  <tr>
                    <td valign="top"><table width="100%"  border="0" cellspacing="2" cellpadding="2">
                      <tr>
                        <td>Dapatkan informasi Laporan Masuk</td>
                      </tr>
                    </table></td>
                    </tr>
                </table></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="6" cellpadding="6" class="panel">
      <tr>
        <td><table width="100%"  border="0" cellspacing="6" cellpadding="6">
            <tr>
              <td width="20%"><div align="center"><img src="images/barangbukti.jpg" width="100" height="100"></div></td>
              <td width="80%">
                <table width="100%"  border="0" cellspacing="3" cellpadding="3">
                  <tr bgcolor="#FF0000">
                    <td><strong>BARANG BUKTI DAN RAMPASAN</strong></td>
                  </tr>
                  <tr>
                    <td><hr></td>
                  </tr>
                  <tr>
                    <td valign="top"><table width="100%"  border="0" cellspacing="2" cellpadding="2">
                      <tr>
                        <td>                         <?PHP
		include("../barbuk/index.db.php");
$sql=mysql_query("Select * from barbuk_db");

while ($row=mysql_fetch_array($sql)){
        print ('<a href="?g=barbuk&i=index&tahun='.$row["t_table"].'" title="HOME">DASHBOARD - '.$row["t_table"].'</a><br>');
}


?></td>
                      </tr>
                    </table></td>
                    </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
    </table>
    <table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
