<?php
require_once("../includes/dbsmain.inc.php");
ob_start();
$location_id=$_REQUEST['id'];
$location_pid = $_REQUEST['location_pid'];
if(is_post_back()){
//*************** UPDATE EXISTING CATEGORY START ************************//
if($_REQUEST['id']!='0') {
$category_url=ami_crete_url($location_name);

$sql = "update tbl_location set        
				location_name='$location_name',
				location_add_date=now(),
				location_status='$location_status'
				where location_id = '$location_id' ";

db_query($sql);
set_session_msg("Sub Location Updated Successfully !");
header("Location:addedit-sublocation.php?id=$_REQUEST[id]&location_pid=$_REQUEST[location_pid]");
exit;
//*************** UPDATE EXISTING CATEGORY END ************************//
}else{
$category_url=ami_crete_url($location_name);

$sql = "insert into tbl_location set 
                location_name='$location_name',
				location_pid='$location_pid',
				location_add_date=now(),
				location_status='$location_status'";
db_query($sql);
set_session_msg("Sub Location Added Successfully !");
header("Location:addedit-sublocation.php?id=$_REQUEST[id]&location_pid=$_REQUEST[location_pid]");
exit;
//*************** INSERT NEW CATEGORY END ************************//
 }
}

if($location_id!='') {
	$result = db_query("select * from tbl_location where location_id = '$location_id'");
	if ($line_raw = mysqli_fetch_array($result)) {
	 @extract($line_raw);
	}
}
?>
<script src="ckeditor/ckeditor.js"></script>
<style>
p.fck {
    width: 90%;
	float:left;
    margin: 0 auto;
 }
</style>
<link href="styles.css" rel="stylesheet" type="text/css">
<?php include("top.inc.php");?>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead"><div id="txtPageHead">Add/Edit Sub Location</div></td>
              </tr>
            </table>
            <div align="right"><a href="location_sublist.php?location_id=<?=$location_pid?>" style="font-size:12px; font-weight:bold; margin-right:15px;">Back to Location List</a>&nbsp;</div>
            <form name="form1" method="post" enctype="multipart/form-data">
              <table width="95%"  border="0" align="center" cellpadding="0" cellspacing="0" class="tableForm">
                <tr>
                  <td width="20%" class="tdLabel">&nbsp;</td>
                  <td width="80%" class="tdData" style="padding-left:7px;"><strong><font color="red">
                    <?=display_sess_msg();?>
                    </font></strong></td>
                </tr>
                <tr>
                  <td width="20%" class="tdLabel" style="font-size:12px; padding:7px;">Name:</td>
                  <td width="80%" class="tdData" style="font-size:12px; padding:7px;"><input name="location_name" style="width:350px; height:28px;" type="text" id="location_name"  value="<?=$location_name?>" class="textfield"  ></td>
                </tr>
                <tr>
                  <td class="tdLabel" style="font-size:12px; padding:7px;">Status:</td>
                  <td class="tdData" style="font-size:12px; padding:7px;"><select name="location_status" style="width:200px; height:26px;">
                      <option value="Active" <?php if($location_status=='Active'){ ?> selected="selected" <? } ?>>Active</option>
                      <option value="Inactive" <?php if($location_status=='Inactive'){ ?> selected="selected" <? } ?>>Inactive</option>
                    </select></td>
                </tr>
                <tr>
                  <td class="tdLabel" style="font-size:12px; padding:7px;">&nbsp;</td>
                  <td class="tdData" style="font-size:12px; padding:7px;"><input type="hidden" name="location_id" value="<?=$location_id?>" />
                    <input type="image" name="imageField" src="images/buttons/submit.gif" style="width:100px; margin-bottom:25px;" /></td>
                </tr>
              </table>
            </form>
            <? include("bottom.inc.php");?>