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

$headerTitleName = "Country List";



/**for  delete  groups **/

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

	 $sql1 = "TRUNCATE TABLE `tbl_country` ";



	 db_query($sql1);

	 

	 set_session_msg("All states and Related Data have been deleted successfully");

			

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

	exit;

}

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

	 $sql1 = "delete from `tbl_country` where country_id in ($page_id)";

	 db_query($sql1);

	 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_country`.* ";

$sql = " from `tbl_country` ";

$sql .= " where 1 ";



$order_by == '' ? $order_by = '`country_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 Services</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="state_add.php?page_id=&start=0" class="redcolor">Add New Services</a>  <a style="margin-left:20px;" href="import_state.php" class="redcolor">Import Services Record in excel</a> <a style="margin-left:20px;" href="state.php?action=alldelete" onclick="return confirm('Are you sure?')" class="redcolor">Delete All Services</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%">Services Id</th>

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

          <!--<th  align="left" width="20%" style="padding-left:10px;">Banner Images</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($country_id)?></td>

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

<?php /*?><td align="left" valign="middle" style="padding-left:10px;">

               <?php $sv_image = $country_banner;

			    if(strlen($country_banner) && file_exists(UP_FILES_FS_PATH."/banner/thumb/".$sv_image)){

                $imgsrc=UP_FILES_WS_PATH."/banner/thumb/".$sv_image;

                $size=getimagesize(UP_FILES_FS_PATH."/banner/thumb/".$sv_image);

				echo '<img src="'.$imgsrc.'" alt="No Image" width="60" height="60"  />';

                }

				else{  echo 'NO Images'; }

                ?>

</td><?php */?>

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

<td align="center" valign="top"><a href="state_add.php?page_id=<?=$country_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="state.php?page_id=<?=$country_id?>&start=<?=$start?>&action=delete" onclick="return stdel_confirm();"><img src="images/icons/trash-20.png" alt="Edit" title="Note - Related <?=$country_name?>, All data will be Deleted !" 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");?>