<?PHP
include("index.cma.db.php");
include("index.globalconfig.php");
$query = "Select * from $mytable"; 
$result = mysql_query($query); 
if($row = mysql_fetch_array($result)){
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>CAMELON | CASE MANAGEMENT APPLICATION | <?PHP echo "$kejari"; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK href="images/index.css" rel="stylesheet" type="text/css">
<link href="images/keyboardstyle.css" type="text/css" rel="stylesheet" />
<style type="text/css">
#fixmetoo { position: absolute; right: 0px; bottom: 0px; width: 100%;
}
body > div#fixmetoo { position: fixed; }
</style>
<style type="text/css">
<!--
body {
	background-image: url();
	margin-top: 0px;
	margin-left: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #006600;
}
-->
</style>
<style type="text/css" media="all">
@import "style.css";
.style2 {font-size: 24px}
</style>
<script type="text/javascript">
var message="Sorry, right-click has been disabled";
///////////////////////////////////
function clickIE() {if (document.all) {(message);return false;}}
function clickNS(e) {if
(document.layers||(document.getElementById&&!document.all)) {
if (e.which==2||e.which==3) {(message);return false;}}}
if (document.layers)
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}
document.oncontextmenu=new Function("return false")
</script></head>

<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#669900"><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="700" height="50">
      <param name="movie" value="themes/top_hijau.swf">
      <param name="quality" value="high">
      <embed src="themes/top_hijau.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="700" height="50"></embed>
    </object></td>
  </tr>
  <tr>
    <td height="40" bgcolor="#CCCC00"><table width="80%"  border="0" align="center" cellpadding="2" cellspacing="2">
      <tr>
        <td><div align="center"><b><?PHP echo "$satker"; ?></b></div></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="73%" valign="top" bgcolor="#999999"><table width="100%"  border="0" cellspacing="6" cellpadding="6">
          <tr>
            <td><strong>INFO TP4 </strong></td>
          </tr>
        </table></td>
      </tr>
    </table>
      <table width="100%"  border="0" cellspacing="6" cellpadding="6">
        <tr>
          <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="100%"><table width="100%"  border="0" cellspacing="4" cellpadding="4">
                    <tr>
                      <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                          <tr>
                            <td width="56%">&nbsp;</td>
                            <td width="18%"><div align="right">Lampiran</div></td>
                            <td width="3%">:</td>
                            <td width="23%">Surat JAM Intelijen Nomor </td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>B-1104/D/Dek/08/2017</td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>Tanggal 28 Agustus 2017 </td>
                          </tr>
                        </table>
                          <table width="100%"  border="0" cellspacing="2" cellpadding="2">
                            <tr>
                              <td><div align="center"><strong>TABEL LAPORAN KEGIATAN </strong></div></td>
                            </tr>
                            <tr>
                              <td><div align="center"><strong>TIM PENGAWAL DAN PENGAMAN PEMERINTAHAN DAN PEMBANGUNAN (TP4) DAERAH </strong></div></td>
                            </tr>
                            <tr>
                              <td><div align="center"><b><?PHP echo "$satker"; ?></b></div></td>
                            </tr>
                        </table></td>
                    </tr>
                </table></td>
              </tr>
              <tr>
                <td><table width="100%"  border="0" cellspacing="4" cellpadding="4">
                    <tr>
                      <td width="100%" bgcolor="#FFFFFF"><?
include("./intel/inc/intel_tp4.db.inc.php");
if(empty($action))
{
if (empty($order)) $order =  2;
if (empty($page))  $page  =  1;
if (empty($hits))  $hits  = 30;
$start = $hits*($page-1);
$query = "SELECT * FROM $mytable";
$res = mysql_query("$query"); 
$xnum = mysql_num_rows($res);
$stw2 = (int)($xnum/$hits);
if ($xnum%$hits > 0) {$stw2++;}
$np = $page+1;
$pp = $page-1;
if ($page == 1) { $pp=1; }
if ($np > $stw2) { $np = $stw2;} 
echo "JUMLAH DATA : <strong>$xnum</strong> | ";
for ($i=1;$i<=$stw2;$i++) {if($page==$i){
echo "Halaman <b>$i</b> ";} 
else{echo " <font size=\"2\"><a href=\"?id=$id1&page=$i\">$i</A></font> ";}}
print ('<br><br>');
$query  = "SELECT * FROM ".$mytable." ";
if(!empty($squery)) { $query .= "WHERE tid LIKE \"%$squery%\" ";}
$query .= "ORDER BY tid DESC LIMIT $start,$hits";
$res = mysql_query($query);
print ('<table id="myTable" width="100%"  border="0" cellspacing="1" cellpadding="1" bgcolor="#B0B0B0">
        <thead><tr>
<td width="3%"><span class="style1"><strong>NO</strong></span></td>
<td width="10%"><span class="style1"><strong>KEGIATAN</strong></span></td>
<td width="5%"><span class="style1"><strong>K/L/D/I</strong></span></td>
<td width="14%"><span class="style1"><strong>JENIS PEKERJAAN/PROYEK</strong></span></td>
<td width="10%"><span class="style1"><strong>PAGU ANGGARAN</strong></span></td>
<td width="8%"><span class="style1"><strong>SUMBER DANA APBN/APBD</strong></span></td>
<td width="10%"><span class="style1"><strong>TAHAPAN PROYEK/PEKERJAAN</strong></span></td>
<td width="10%"><span class="style1"><strong>TAHAPAN PENGAWASAL & PENGAMANAN</strong></span></td>
<td width="10%"><span class="style1"><strong>NO & TANGGAL SURAT PERINTAH</strong></span></td>
<td width="10%"><span class="style1"><strong>PENYERAPAN ANGGARAN <br>(%)</strong></span></td>
<td width="10%"><span class="style1"><strong>KET</strong></span></td>
</tr></thead><tbody>');
 $x=0;
  while($row = mysql_fetch_array($res))
  {
   $x++;
   if($x==2) {$barva = "FFFFFF";$x=0;} else {$barva = "FFFFD9";$x=1;}
print ('<tr bgcolor=#'.$barva.'>');
print ('<td><center>'.$row['tagenda'].'</center></td>');
print ('<td><a href="?g=tp4&d=inc&id='.$row['tkegiatan'].'">'.$row['tkegiatan'].'</a></td>');
print ('<td>'.$row['tkldi'].'</td>');
print ('<td>'.$row['tjenisproyek'].'</td>');
print ('<td><center>'.$row['tpagu'].'</center></td>');
print ('<td>');
if ($row['tdana'] == "1") {
print ('<center><img src="./intel/images/intel_apbn.jpg" width="80" height="30"></center>');
} 
elseif ($row['tdana'] == "1") {

print ('<center><img src="./intel/images/intel_apbd.jpg" width="80" height="30"></center>');
}
print ('</td>');
print ('<td>'.$row['ttahapan'].'</td>');
print ('<td>'.$row['tkawal'].'</td>');
print ('<td>'.$row['tsprint'].'</td>');
print ('<td><center>'.$row['tserap'].'%<center></td>');
print ('<td>'.$row['tket'].'</td>');


print ('</tr>');
}
print ('</tbody></table>');
}
?>
                      </td>
                    </tr>
                </table></td>
              </tr>
          </table></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="77" class="style2">&nbsp;</td>
  </tr>
</table>
<div align="center" class="style2" id="fixmetoo"> 
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="13%" bgcolor="#339933"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td><div align="center"></div>
                    <div align="center"><strong>QUICK NEWS </strong></div></td>
              </tr>
            </table></td>
            <td bgcolor="#66CC00"><table width="100%"  border="0" cellspacing="2" cellpadding="2">
              <tr>
                <td height="40"><marquee>
                                ISI SITUS BERSIFAT INFORMATIF BUKAN MERUPAKAN LEGAL OPINION. APABILA TERDAPAT DATA ELEKTRONIK BASED YANG BERBEDA DENGAN DATA RESMI PAPER, MAKA YANG MENJADI ACUAN ADALAH DATA RESMI PAPER BASED.
                
                </marquee></td>
              </tr>
            </table></td>
          </tr>
      </table></td>
    </tr>
  </table>
</div>
</body>
</html>
<? } ?>
