<?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'];
	$kode = mysql_fetch_array(mysql_query("select max(id_kota) as maxid from tbl_kota"));
	$maxid = $kode['maxid'];
	if($maxid == "")
	{
		$kode1 = "KOTA1";
	
	}
	else
	{
		$total = $maxid+1;
		$kode1 = "KOTA".$total;
	}
	if($act == 1)
	{
		$kode  = $_REQUEST['kode'];
		$nama  = $_REQUEST['nama'];
		$provinsi  = $_REQUEST['provinsi'];
		if($provinsi ==  "")
		{
		?>
				<script language="javascript">
                alert("Choose Nama Provinsi");
                document.location="add_kota.php";
                </script>
		<?php	
		}
		elseif($nama ==  "")
		{
		?>
				<script language="javascript">
                alert("Input Nama Kota");
                document.location="add_kota.php";
                </script>
		<?php	
		}
		else
		{
			$insert = mysql_query("insert into tbl_kota (kode_kota,nama_kota,id_provinsi, user_update) values ('$kode','$nama','$provinsi','$USERNAME')");
			if($insert)
			{
				?>
				<script language="javascript">
                alert("Add Kota Success");
                document.location="add_kota.php";
                </script>
				<?php
			}
			else
			{
				?>
				<script language="javascript">
                alert("Add Kota Failed");
                document.location="add_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> Add Kota</h1>
</div>

<!--<ol class="breadcrumb">
  <li><a href="#">Home</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="row">
                <div class="widget">
                  <div class="widget-content-white glossed">
                    <div class="padded">
                      <form method="post" action="add_kota.php?act=1" role="form" class="form-horizontal">
                        <div class="form-group">
                          <label class="col-md-4 control-label">Kode Kota</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="kode" id="kode"  value="<?php echo $kode1; ?>"  readonly="readonly" >
                          </div>
                          </div>
                            <div class="form-group">
                          <label class="col-md-4 control-label">Nama Provinsi</label>
                          <div class="col-md-8">
                            <select class="form-control" name="provinsi" id="provinsi">
                              <?php
                                              $sql3 = "select * from tbl_provinsi where status_provinsi=1 order by nama_provinsi";
                                              $rs3 = mysql_query($sql3);
                                              while($fetch3 = mysql_fetch_array($rs3))
                                              {
                                               ?>
                                        <option value="<?php echo $fetch3['id_provinsi']; ?>"><?php echo  $fetch3['nama_provinsi'];  ?></option>
                                                      <?php
                                              }
                                             ?>
                            </select>
                          </div>
                        </div>
                         <div class="form-group">
                          <label class="col-md-4 control-label">Nama Kota</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="nama" id="nama">
                          </div>
                        </div>
                   
                        <div class="form-group">
                          <div class="col-md-offset-4 col-md-8">
                            <button type="submit" class="btn btn-default">Submit</button>
                            <button type="reset" class="btn btn-default">Reset</button>
                          </div>
                        </div>
                      </form>
                    </div>
                    </div>
                    </div>
                    </div>
                    </div>
                   

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

</html>