<? require_once("../includes/main.inc.php");

/**for  delete  groups **/

if($_REQUEST['action']=='delete'){

	 $page_id=$_GET['page_id'];

	 $sql2 = "delete from `tbl_state` where state_id in ($page_id)";

	 db_query($sql2);

	 set_session_msg("Selected State and Related Data have been deleted successfully");

	 header("Location: ".$_SERVER['HTTP_REFERER']);

	exit;
}

$start = intval($start);

$pagesize = intval($pagesize)==0?$pagesize=50:$pagesize;

$columns = "select `tbl_state`.state_name,`tbl_state`.state_short_name,`tbl_country`.country_name,`tbl_state`.state_id,`tbl_state`.state_status";

$sql = " from `tbl_state` ";

$sql .= " LEFT JOIN `tbl_country` ON `tbl_state`.`country_id` = `tbl_country`.`country_id` ";

$sql .= " where 1 ";

$order_by == '' ? $order_by = '`state_id`' : true;

$order_by2 == '' ? $order_by2 = 'ASC' : true;

$sql_count = "select count(*) ".$sql; 

$sql .= "order by $order_by $order_by2 ";

$sql .= "limit $start, $pagesize ";

$sql = $columns.$sql;

$result = db_query($sql);

$reccnt = db_scalar($sql_count);

?><link href="styles.css" rel="stylesheet" type="text/css">

<? include("top.inc.php");?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td id="pageHead"><div id="txtPageHead">

    Manage State</div></td>

  </tr>

</table>

		<table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td id="content">

        <div align="center"><span class="msg"><?=display_sess_msg();?></span></div><br />

        <a href="district_add.php?page_id=&start=0" class="redcolor">Add New State</a>

      <? if(mysql_num_rows($result)==0){?>

      <div class="msg">Sorry, no records found.</div>

      <? } else{ ?>

      <div align="right"> Showing Records: <?= $start+1?> to   <?=($reccnt<$start+$pagesize)?($reccnt-$start):($start+$pagesize)?>    of   <?=$reccnt?> </div>

      <form method="post" name="form1" id="form1" onSubmit="confirm_submit(this)">

        <table width="100%"  border="0" cellpadding="0" cellspacing="1" class="tableList">

          <tr>

          <th  align="center" width="5%">SL</th>

          <th  align="left" width="25%" style="padding-left:10px;">State Name</th>

          <th  align="left" width="15%" style="padding-left:10px;">State Short Name</th>

          <th  align="center" width="8%">Status</th>

          <th align="center" width="8%">Edit</th>

          <th align="center" width="5%">Delete</th>

          </tr>

      <? 

if($start==0){

	$cnt=0;

}

else{

	$cnt=$start;

}

while ($line_raw = mysql_fetch_array($result)) {

	$cnt++;

$line = ms_display_value($line_raw);

@extract($line);

$css = ($css=='trOdd')?'trEven':'trOdd';

?><tr class="<?=$css?>">

<td  valign="top" align="center"><?=stripslashes($state_id)?></td>

<td align="left" valign="middle" style="padding-left:10px;"><?=stripslashes($state_name)?></td>

<td align="left" valign="middle" style="padding-left:10px;"><?=stripslashes($state_short_name)?></td>

<td align="center" valign="middle"><?php if($state_status=='1'){ echo 'Active'; }else{ echo '<span style="color:red;">InActive</span>'; } ?></td>

<td align="center" valign="top"><a href="district_add.php?page_id=<?=$state_id?>&start=<?=$start?>"><img src="images/icons/edit.png" alt="Edit" width="16" height="16" border="0" /></a></td>

<td align="center" valign="top"><a href="district.php?page_id=<?=$state_id?>&start=<?=$start?>&action=delete" onclick="return stdel_confirm();"><img src="images/icons/trash-20.png" alt="Edit" width="16" height="16" border="0" /></a></td>

</tr>

<? }?>        </table>

 </form>

<? }?>

 <? include("paging.inc.php");?>    </td>

  </tr>

</table>

<script>

function stdel_confirm(){  return confirm("Are you sure want to delete?"); }

</script>

<? include("bottom.inc.php");?>