<?php require_once("header.php");?>
<?php require_once("left-nav.php");?>
<?php require_once ('../includes/photoshop.php');?>

<?php

$parent_loc_id=$_REQUEST['loc_id'];



if(isset($_POST['submit_location'])){
@extract($_POST);
$location_url=ami_crete_url($location_name);

$check_url=db_scalar("select location_id from tbl_location where location_url='$location_url' ");
if($check_url=="")
{
   
   
 if(isset($_GET['edit_id'])){ 


    $sql="update tbl_location set 
            location_name='$location_name',
           location_description='$city_description',
            location_url='$location_url'
       where location_id= '$_GET[edit_id]' and location_parent_id='$parent_loc_id' ";
             db_query($sql);
       $_SESSION["msg"]="Location updated successfully !";
             header("Location:manage_sub_location.php?loc_id=$parent_loc_id");
             exit;
}else{


     $sql="insert into tbl_location set 
           location_name ='$location_name',
           location_description='$city_description',
           location_parent_id='$parent_loc_id',
           location_url='$location_url',
       location_status='Active',
       location_add_date=now()";
       db_query($sql);
      $_SESSION["msg"]="Location added successfully !";
       header("Location:manage_sub_location.php?loc_id=$parent_loc_id");
       exit;
    
  }
  
}else{
$_SESSION["msg"]="<span style='color:red;'>Location name is already exist!</span>";
header("Location:manage_sub_location.php?loc_id=$parent_loc_id");
exit;  
}  

}   
if(isset($_GET['edit_id'])){
$sql="select * from tbl_location where location_id='$_GET[edit_id]' and location_parent_id='$parent_loc_id'";
$result2=db_query($sql);
$data_new=mysqli_fetch_array($result2);
}

?>



         <!-- Content Wrapper. Contains page content -->
         <div class="content-wrapper">
            <!-- Content Header (Page header) -->
            <section class="content-header">
               <div class="header-icon">
                  <i class="fa fa-pencil-square-o" aria-hidden="true"></i>

               </div>
               <div class="header-title">
                  <h1>Add/Edit city</h1>
                  <small>Add/Edit city content</small>
                  
                  
<a href="manage_sub_location.php?loc_id=<?=$_REQUEST['loc_id']?>"><button id="btn-go-back" type="button" class="btn btn-labeled btn-inverse m-b-5 pull-right">
<span class="btn-label" ><i class="fa fa-chevron-circle-left"></i></span>Go Back
</button></a>

                  
               </div>
               
               
            </section>
            <!-- Main content -->
<script src="ckeditor/ckeditor.js"></script>            
            <section class="content">
            
            <?php if($_SESSION["msg"]!=""){?>               
<div class="alert alert-success alert-dismissable fade in text-center" style="background-color:#dff0d8;border:none; color:#000;margin:10px 0 10px 0">
    <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
    <strong>Success!&nbsp;&nbsp;&nbsp;</strong> <?=$_SESSION["msg"]?>
  </div>
<?php 
unset($_SESSION["msg"]);
}?>     

               <div class="row">
                  <!-- Form controls -->
                  <div class="col-sm-12">
                     <div class="panel panel-bd lobidrag" data-edit-title='false' data-close='false' data-reload='false'>
                        <div class="panel-heading">
                           <div class="btn-group" id="buttonexport">
                              <a href="#">
                                 <h4>General Information</h4>
                              </a>
                           </div>
                        </div>
                        <div class="panel-body">
<form name="form1" method="post" onsubmit="return formValidation()" enctype="multipart/form-data" class="col-sm-12" >
                              


  
<div class="form-group col-lg-12">
                                 <label>City Name</label>
<input type="text" class="form-control" placeholder="Enter Name" name="city_name" id="city_name"  value="<?=$city_name?>">
                              </div>
                                         
                                         
                                         
<!-- <div class="form-group col-lg-12">
                                 <label>city Tag Line</label>
<input type="text" class="form-control" placeholder="Enter tag line" name="city_tag_line" id="city_tag_line"  value="<?=$city_tag_line?>">
                              </div>
                                                                                                   
                            
<div class="form-group col-lg-12">
                                 <label>city Shared Count</label>
<input type="text" class="form-control" placeholder="Enter Shared Count" name="city_shared_count" id="city_shared_count"  value="<?=$city_shared_count?>">
                              </div>      -->                       
                            
                             
                             <div class="form-group col-lg-12">
                                 <label>City Description</label>
 <textarea class="form-control" name="city_description" rows="3" id="editor1"><?=$city_description?></textarea>
                              </div>
                             
<script>

// Replace the <textarea id="editor"> with an CKEditor
// instance, using default configurations.
CKEDITOR.replace( 'editor1');

</script>
                           
                           
<div class="form-group col-lg-3">
 <label>Status</label>
 
<select name="city_status" class="form-control" >
                      <option value="Active" <?php if($city_status=='Active'){ ?> selected="selected" <? } ?>>Active</option>
                      <option value="Inactive" <?php if($city_status=='Inactive'){ ?> selected="selected" <? } ?>>Inactive</option>
                    </select>


</div>                             


<!--<div class="col-lg-12" style="padding:0;background-color:#e8f1f3;margin:20px 0 50px 0">-->
<!--                           <div class="btn-group" id="buttonexport">-->
<!--                              <a href="#" >-->
<!--                                 <h4 style="color:#000;font-weight:600;padding:5px">SEO Related Information</h4>-->
<!--                              </a>-->
<!--                           </div>-->
<!--                        </div>                             -->
                             
                             
<!--                              <div class="form-group col-lg-12">-->
<!--                                 <label>city Meta Title</label>-->
<!--<textarea class="form-control" rows="3" name="city_meta_title" id="city_meta_title" placeholder="Enter city meta title here" ><?=$city_meta_title?></textarea>-->
<!--                              </div>-->
<!--                              <div class="form-group col-lg-12">-->
<!--                                 <label>city Meta Description</label>-->
<!--<textarea class="form-control" rows="3" placeholder="Enter city meta description here" name="city_meta_description" id="city_meta_description"><?=$city_meta_description?></textarea>-->
<!--                              </div>-->
<!--                              <div class="form-group col-lg-12">-->
<!--                                 <label>city Meta Keyword</label>-->
<!--<textarea class="form-control" rows="3" name="city_meta_keywords" placeholder="Enter city meta keywords here" id="city_meta_keywords"><?=$city_meta_keywords?></textarea>-->
<!--                              </div>-->
<!--                              -->
                              
                              
                             
                              <div class="col-lg-12 reset-button">
                                                                 
                                 <button type="submit" class="btn btn-add">Submit</button>
                                
                              </div>
                           </form>
                        </div>
                     </div>
                  </div>
               </div>
            </section>
            <!-- /.content -->
         </div>
<?php require_once("footer.php"); ?>