<?php include('header.php');?>
<?php include('sidebar.php');?>
<?php 
include('includes/class.usertype.php');
$usertype = new Usertype();
?>
<?php
$maintitle="Location";
$page="locations.php";
$table="tbl_location";
$field_id="locationid";
$mode=$_REQUEST['mode'];
$content_id=$_REQUEST['contentid'];
if(isset($_REQUEST['start'])){
$start=$_REQUEST['start']-1;
}
else {
$start=0;
}
?>
<?php
if(isset($_REQUEST['submit'])=="submit"){ 
$category=$_POST['category'];
$title=$_POST['title'];

unset($values['submit']);
unset($values['mode']);
/*$customurl=array("customurl"=>$slugexist);
$values=array_merge($values,$customurl);*/
$userid=array("user_id"=>$user_id);
$values=array_merge($values,$userid);
if($_REQUEST['mode']=="add"){
$message=mysqli_query($con,"insert into tbl_location(city,location,status) values('$category','$title',1)");
	 $message = "Location Added Successfully";
}
if($_REQUEST['mode']=="edit"){
	$message=mysqli_query($con,"update tbl_location set city='$category',location='$title' where locationid=$content_id");
   $message = "Location Updated Successfully";
}

}
?>

<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1><?php echo $maintitle;?></h1>
      <ol class="breadcrumb">
        <li><a href="dashboard.php"><i class="fa fa-dashboard"></i> <?php echo AL_DASHBOARD;?></a></li>
        <li class="active"><?php echo $maintitle;?></li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="content">
    <?php
	if($mode=="add" || $mode=="edit"){ 
	?>
     <div class="row">
 <!-- Add / Edit / Delete --> 
        <div class="col-sm-12"> 
        <div class="box box-success">
         <div class="box-header">
              <i class="fa fa-building-o"></i>
              <h3 class="box-title"><?php echo $maintitle;?></h3>
              <div class="box-tools pull-right">
                <div class="btn-group">
                <a href="<?php echo $page;?>"><button class="btn btn-danger btn-flat">&nbsp; <?php echo AL_LISTALL;?> <?php echo $maintitle;?></button></a>
                   
                </div>
              </div>
            </div> 
            </div> 
            </div>

 <!-- Add / Edit / Delete --> 
<?php
if($mode=="edit"){
$contentdetails=$helper->select($table,"*",array($field_id=>$_REQUEST['contentid']),array());
}
?>
<div class="col-md-10">
          <!-- Horizontal Form -->
          <div class="box box-info">
            <div class="box-header with-border">
              <h3 class="box-title"> <?php echo AL_ADD;?> <?php echo $maintitle;?></h3>
            </div>
            
            <?php
			if($message!=""){
			?>
            <button class="btn btn-block btn-success btn-flat" type="button"><?php echo $message;?></button>
			<?php	
			}
			?>
            <!-- /.box-header -->
            <!-- form start -->
            <form class="form-horizontal" action="" method="post" enctype="multipart/form-data">
            <input type="hidden" name="mode" value="<?php echo $_REQUEST['mode'];?>"/>
              <div class="box-body">
              <div class="form-group">
                  <label for="inputEmail3" class="col-sm-3 control-label">City</label>

                  <div class="col-sm-4">                   
                      <select class="form-control" name="category">
                         
                          <option value="">Select City</option>
                           <?php
		$sel_cat=mysqli_query($con,"select * from tbl_city where status=1");
		while($res_cat=mysqli_fetch_array($sel_cat)){							  
			    ?>
                            <option <?php if($res_cat['cityid']==$contentdetails[0]['city']){ echo "selected"; } ?> value="<?php  echo $res_cat['cityid'];?>"><?php  echo $res_cat['city'];?></option>                              
                 <?php
			    }
		           ?>                         
                          
                        </select>
                    
                  </div>
                </div>
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-3 control-label">Location</label>

                  <div class="col-sm-8">
                    <input type="text" required="required" name="title" value="<?php echo $contentdetails[0]['location'];?>" class="form-control" id="title" placeholder="Title" >
                  </div>
                </div>
                
                
              </div>
              <!-- /.box-body -->
              <div class="box-footer">
                <button type="reset" class="btn btn-default"><?php echo AL_CANCEL;?></button>
                <input type="submit" name="submit" value="<?php echo AL_SUBMIT;?>" class="btn btn-info pull-right"/>
                 
              </div>
              <!-- /.box-footer -->
            </form>
          </div>
         
        </div>
        </div>
        <?php
	    }
		else {
	    ?>
        <?php
		if($mode=="delete"){
			mysqli_query($con,"delete from tbl_location where locationid=".$_REQUEST['contentid']);
		
		}
		?>
          <?php
		if($mode=="approve"){
			mysqli_query($con,"update tbl_location set status='1' where locationid=".$_REQUEST['contentid']);
		}
		?>
         <?php
		if($mode=="pending"){
			mysqli_query($con,"update tbl_location set status='2' where locationid=".$_REQUEST['contentid']);
		}
		?>
        <div class="row">
        <div class="col-xs-12">
          <div class="box">
            <div class="box-header">
              <i class="fa fa-building-o"></i>
           <h3 class="box-title"><?php echo $maintitle;?></h3>

              <div class="box-tools pull-right" data-toggle="tooltip" title="Add <?php echo $maintitle;?>">
                <div class="btn-group">
                <a href="<?php echo $page;?>?mode=add"><button class="btn btn-danger btn-flat"><i class="glyphicon  glyphicon-plus"></i>&nbsp;<?php echo AL_ADD;?> <?php echo $maintitle;?></button></a>
                   
                </div>
              </div>
            </div>
            <?php
			$listtypes=mysqli_query($con,"select * from tbl_location");		 
			?>
            <!-- /.box-header -->
            <div class="box-body table-responsive no-padding">
            <?php
			if($message!=""){
			?>
            <button class="btn btn-block btn-danger btn-flat" type="button"><?php echo $message['message'];?></button>
			<?php	
			}
			?>
              <table class="table table-hover">
                <tr>
                  <th><?php echo AL_SERIALNO;?></th>
                  <th>City</th>
                  <th>Location</th>
<!--                  <th><?php echo AL_STATUS;?></th>-->
                  <th><?php echo AL_ACTION;?></th>
                </tr>
                <?php
				$i=1;
				while($type=mysqli_fetch_array($listtypes)){
				?>
                 <?php
				  if($_REQUEST['start']>0){
					  $limitpage=$_REQUEST['start'];
				  }
				  else {
					  $limitpage=1;
				  }
				 
                   //$valexist=$helper->datapresent($table,"parent_id",$type[$field_id]);
				   $valexist2=$helper->datapresent("tbl_members","typeid",$type[$field_id]);
				  ?>
                <tr>
                  <td><?php echo $i;?></td>
                    <td><?php  $ca=$type['city']; 
					$sel_cat=mysqli_query($con,"select * from tbl_city where cityid=$ca");
					$res_c=mysqli_fetch_array($sel_cat); echo $res_c['city'];?></td>
                  <td><?php echo $type['location'];?></td>
<!--
                  <td>
                  <?php
				  
				  if($type['status']==1){
				  ?>
<a href="<?php //echo $admin_url;?><?php echo $page;?>?mode=pending&contentid=<?php echo $type[$field_id];?>&start=<?php echo $limitpage;?>"><span class="label label-success"><?php echo AL_APPROVED;?></span></a>
                  <?php
				  }
				  else {
				  ?>
				  <a href="<?php //echo $admin_url;?><?php echo $page;?>?mode=approve&contentid=<?php echo $type[$field_id];?>&start=<?php echo $limitpage;?>"><span class="label label-danger"><?php echo AL_PENDING;?></span></a>
                  <?php
				  }
				  ?>
                  </td>
-->
                  <td>
                  <a href="<?php //echo $admin_url;?><?php echo $page;?>?mode=edit&contentid=<?php echo $type[$field_id];?>&start=<?php echo $limitpage;?>"><span class="label label-primary"><i class="fa fa-edit"></i> <?php echo AL_EDIT;?></span></a>
                  <?php
				  if($valexist2==0){
				  ?>
                   <a href="<?php //echo $admin_url;?><?php echo $page;?>?mode=delete&contentid=<?php echo $type[$field_id];?>&start=<?php echo $limitpage;?>" onclick="return getConfirmation()"><span class="label label-danger"><i class="fa fa-times"></i> <?php echo AL_DELETE;?></span></a>
                   <?php
				  }
				  ?>
                  </td>
                </tr>
                 <?php 
               $subcategories=$usertype->subcategories($type[$field_id],1,$page,$admin_url,$limitpage);
                ?>
                <?php
				$i=$i+1;
				}
				?>
            </table>
              <?php
			   $counter_list= $helper->countofdata($table,array(),$limit,array("status"=>"ASC"));
			 // include('pagination/pagination.php');
			  ?>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->
        </div>
      </div>
      <?php
		}
		?>

    </section>
    <!-- /.content -->
  </div>
<?php include('footer.php');  ?>