<?php
session_name("AUTHENUSER");
session_start();
$USERNAME = $_SESSION['SES_USERNAME'];
if(!session_name("AUTHENUSER"))
	{
?>
						<script language="javascript">
						 alert("Waktu Login telah habis.Silahkan Login Kembali");
						document.location="index.php";
						</script>
<?php
	}
if(!$USERNAME)
	{
?>
						<script language="javascript">
						 alert("Harap Login Dahulu.");
						document.location="index.php";
						</script>
<?php
	}
	?>
	<?php include "common/config.php";
	include "include/head.php"; 
		$act  = $_REQUEST['act'];
	$id_kota  = $_REQUEST['id_kota'];
	if($act == 3)
	{
		$delete = mysql_query("update tbl_kota set status_kota = 2,user_update  = '$USERNAME' where id_kota='$id_kota'");
		if($delete)
		{
				?>
				<script language="javascript">
                alert("Delete Kota Success");
                document.location="master_kota.php";
                </script>
				<?php
			}
			else
			{
				?>
				<script language="javascript">
                alert("Delete Kota Failed");
                document.location="master_kota.php";
                </script>
				<?php	
			}
	}
	?>
    
<body>
<?php include "include/head2.php"; ?>
<?php include "include/leftmenu.php"; ?>
<?php include "include/top.php"; ?>
  <h1><i class="icon-th"></i> Master Kota</h1>
</div>

<ol class="breadcrumb">
  <li><a href="add_kota.php">Add Kota</a></li>
<!--  <li><a href="#">Bread</a></li>
  <li><a href="#">Crumbs</a></li>
  <li class="active">Example</li>-->
</ol>
   <div class="main-content">
            <div class="widget">
              <h3 class="section-title first-title"><i class="icon-table"></i> Listing Kota</h3>
              <div class="widget-content-white glossed">
                <div class="padded">
                <table class="table table-striped table-bordered table-hover">
                  <thead>
                    <tr>
                      <th>Kode Kota</th>
                      <th>Nama Provinsi</th>
                      <th>Nama Kota</th>
                      <th>Details</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php
						$sql = mysql_query("select * from tbl_kota a
						inner join tbl_provinsi b on a.id_provinsi = b.id_provinsi
						where status_kota = 1");
						while($fetch = mysql_fetch_array($sql))
						{
								$id_kota = $fetch['id_kota'];
					?>
                        <tr class="gradeX">
                            <td><?php echo $fetch['kode_kota']; ?></td>
                            <td><?php echo $fetch['nama_provinsi']; ?></td>
                            <td><?php echo $fetch['nama_kota']; ?></td>
                            <td class="actions aligncenter"><a href="edit_kota.php?id_kota=<?php echo $id_kota; ?>" class="btn btn-default btn-xs"><i class="icon-pencil"></i> edit</a> &nbsp; <a href="master_kota.php?act=3&id_kota=<?php echo $id_kota; ?>" class="btn btn-default btn-xs"><i class="icon-remove"></i> Delete</a></td>
                       </tr>
                       <?php
						}
						?>
                  </tbody>
                </table>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>

    </div>
  </div>
</div>       

<?php include "include/foot.php"; ?>
<script src='assets/js/for_pages/dashboard.js'></script>
</body>

</html>