<?php
ob_start();
require_once("../includes/dbsmain.inc.php");
$location_pid = $_REQUEST['location_id'];
if(is_post_back()) {
	$arr_ids = $_REQUEST['arr_ids'];
	if(is_array($arr_ids)) {
		$str_ids = implode(',', $arr_ids); 
		if(isset($_REQUEST['Activate']) || isset($_REQUEST['Activate_x']) ) {
			db_query("update tbl_location set location_status='Active' where location_id in ($str_ids)");
		} else if(isset($_REQUEST['Deactivate']) || isset($_REQUEST['Deactivate_x']) ) {
			db_query("update tbl_location set location_status='Inactive' where location_id in ($str_ids)");
		}else if(isset($_REQUEST['delete_hot']) || isset($_REQUEST['delete_x']) ) {
			db_query("delete from tbl_location where location_id in ($str_ids)");
		}
	}
	header("Location: ".$_SERVER['HTTP_REFERER']);
	exit;
}

$start = intval($start);
$pagesize = intval($pagesize)==0?$pagesize=DEF_PAGE_SIZE:$pagesize;

$order_by == '' ? $order_by = 'location_id' : true;
$order_by2 == '' ? $order_by2 = 'asc' : true;

$catgid=($_REQUEST[id]!=0) ? $_REQUEST[id] : 0;	 
$sql = "select * from tbl_location where 1 and location_pid='$location_pid' ";
$sql = apply_filter($sql, $location_name, 'like','location_name');
//echo $sql;
$sql .= " order by $order_by $order_by2 ";
$sql .= " limit $start, $pagesize ";

$pager = new midas_pager_sql($sql, $pagesize, $start);
if($pager->total_records) {
	$result = db_query($sql);
}
?>
<link href="styles.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/javascript" src="../includes/general.js"></script>
<?php include("top.inc.php");?>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead"><div id="txtPageHead"><?=db_scalar("select location_name from tbl_location where 1 and location_id='$_REQUEST[location_id]'");?> Sub Location list </div></td>
              </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="content"><form method="get" name="form2" id="form2" onSubmit="return confirm_submit(this)">
                    <br />
                    <table  border="0" align="center" cellpadding="2" cellspacing="0" class="tableSearch" style="width:300px; height:90px;border:2px outset #fff;">
                      <tr align="center">
                        <th colspan="2">Search</th>
                      </tr>
                      <tr>
                        <td class="tdLabel">Name</td>
                        <td><input name="location_name" type="text" value="<?=$location_name?>" style="width:200px; height:24px;" /></td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td><input name="pagesize" type="hidden" id="pagesize" value="<?=$pagesize?>" />
                          <input type="image" name="imageField" src="images/buttons/search.gif" />
                          <?php if($_REQUEST['location_name']){ ?>
                          <a href="property_types.php"><span style="vertical-align:top; margin-left:5px; font-size:12px; color:#0000CC; font-weight:bold; font-family:Arial, Helvetica, sans-serif;">View All</span></a>
                          <? } ?></td>
                      </tr>
                    </table>
                  </form>
                  <br />
                  <div align="right"> <a href="location_list.php" style="font-size:12px; font-weight:bold;">Back To Location List</a> </div>
                  <div align="right" style="margin-top:5px;"> <a href="addedit-sublocation.php?id=0&location_pid=<?=$location_pid?>" style="font-size:12px; font-weight:bold;">Add New Sub Location</a> </div>
                  <? if($pager->total_records==0) {?>
                  <div class="msg">Sorry, no records found.</div>
                  <? } else { ?>
                  <div align="right">
                    <? $pager->show_displaying()?>
                  </div>
                  <div>Records Per Page:
                    <?=pagesize_dropdown('pagesize', $pagesize);?>
                  </div>
                 <form method="post" name="form1" id="form1" onsubmit="confirm_submit(this)">
                    <table width="100%"  border="0" cellpadding="0" cellspacing="1" class="tableList" style="border:1px outset #fff;">
                      <tr>
                        <th width="27%" nowrap="nowrap" style="font-size:12px; padding:9px;">Name <?=sort_arrows('location_name')?></th>
                        <th width="8%" nowrap="nowrap" style="font-size:12px; padding:9px;">Status <?=sort_arrows('location_status')?></th>
                        <th width="4%">&nbsp;</th>
                        <th width="4%"><input name="check_all" type="checkbox" id="check_all" value="1" onclick="checkall(this.form)" /></th>
                      </tr>
                      <?php
							while ($line_raw = mysqli_fetch_array($result)) {
								$line = ms_display_value($line_raw);
								@extract($line);
								$css = ($css=='trOdd')?'trEven':'trOdd';
							?>
                      <tr class="<?=$css?>" align="center">
                        <td nowrap="nowrap" style="font-size:12px;"><?=$location_name?></td>
                        <td nowrap="nowrap" style="font-size:12px;"><span style="font-weight:bold; <?php if($location_status=='Active'){ ?> color:#295300; <? }else{ ?> color:#EA0000; <? } ?>"><?=$location_status?></span></td>
                        <td align="center" style="font-size:12px;"><a href="addedit-sublocation.php?id=<?=$location_id?>&location_pid=<?=$location_pid?>"><img src="images/icons/edit.png" alt="Edit" width="16" height="16" border="0" /></a></td>
                        <td align="center"><input name="arr_ids[]" type="checkbox" id="arr_ids[]" value="<?=$location_id?>" /></td>
                      </tr>
                      <? } ?>
                    </table>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td align="right" style="padding:2px">
                          <input type="submit" name="Activate" value="Activate" class="button" onClick="return select_chk()" style="font-size:12px; font-weight:bold; height:26px; background-color:#1F3E00; border-radius:4px; cursor:pointer; width:90px;"/>
                          <input type="submit" name="Deactivate" value="Deactivate" class="button" onClick="return select_chk()" style="font-size:12px; font-weight:bold; height:26px; background-color:#FF6F6F; border-radius:4px; cursor:pointer; width:90px;" />
                          <?php if($_SESSION['sess_admin_type']=='Admin'){ ?>
                          <input type="submit" name="delete" value="Delete" class="button" onClick="return select_chk()" style="font-size:12px; font-weight:bold; height:26px; background-color:#CA0000; border-radius:4px; cursor:pointer; width:90px;"/>
                          <? } ?>
                        </td>
                      </tr>
                    </table>
                  </form>
                  <? $pager->show_pager();?>
                  <? } ?>
                </td>
              </tr>
            </table>
<script language="javascript">
function select_chk(){
var chks = document.getElementsByName('arr_ids[]');
var hasChecked = false;
for (var i = 0; i < chks.length; i++){
if (chks[i].checked){
  hasChecked = true;
  break;
  }
}
if (hasChecked == false){
alert("Please Select At Least One.");
return false;
}
}
</script>            
<?php include("bottom.inc.php");?>