<?php 
require_once("header.php");
require_once("session_check.php");

//CODE FOR DELETE PACKAGE
if(isset($_GET['action']) && $_GET['action'] == "delete")
{
	mysql_query("DELETE FROM `ur_payment_packages` WHERE `package_id` = '".$_GET['package_id']."'") or die(mysql_error());
	
	$_SESSION['del_succ_msg'] = 'Payment package deleted successfully.';
	header("location: package_list.php");
	exit;
}
?>

<?php require_once("left_panel.php");?>
<div class="content">
	<div class="workplace">
		<?php if(isset($_SESSION['add_succ_msg'])) { ?>
			<div class="alert alert-success">                
			<b><?php echo $_SESSION['add_succ_msg'];?></b>
			</div> 
		<?php
		unset($_SESSION['add_succ_msg']);
		}
		?>
		
		<?php if(isset($_SESSION['edit_succ_msg'])) { ?>
			<div class="alert alert-success">                
			<b><?php echo $_SESSION['edit_succ_msg'];?></b>
			</div> 
		<?php
		unset($_SESSION['edit_succ_msg']);
		}
		?>
		
		<?php if(isset($_SESSION['del_succ_msg'])) { ?>
			<div class="alert alert-success">                
			<b><?php echo $_SESSION['del_succ_msg'];?></b>
			</div> 
		<?php
		unset($_SESSION['del_succ_msg']);
		}
		?>
		
		<?php if(isset($_SESSION['change_succ_msg'])) { ?>
			<div class="alert alert-success">                
			<b><?php echo $_SESSION['change_succ_msg'];?></b>
			</div> 
		<?php
		unset($_SESSION['change_succ_msg']);
		}
		?>
		<div class="row-fluid">
			<div class="span12">                    
				<div class="head clearfix">
					<div class="isw-grid"></div>
					<h1>Payment Packages List</h1>                               
				</div>
				<div class="block-fluid table-sorting clearfix">
					<table cellpadding="0" cellspacing="0" width="100%" class="table" id="tSortable">
						<thead>
							<tr>
								<th width="10%">Serial No.</th>
								<th width="40%">Duration</th>
								<th width="30%">Price</th>
								<th width="10%">Status</th>
								<th width="10%">Action</th>
							</tr>
						</thead>
						<tbody>
						<?php
						$package_counter = 1;
						$sql_record = "SELECT * FROM `ur_payment_packages` ORDER BY `package_id` DESC";
						$exe_record = mysql_query($sql_record) or die();
						$num_record = mysql_num_rows($exe_record);
						if($num_record>0)
						{
							while($fetch_record = mysql_fetch_array($exe_record))
							{
								$duration_days = stripslashes($fetch_record['duration_days']);
								$package_price = nl2br(stripslashes($fetch_record['package_price']));
								$package_status = $fetch_record['package_status'];
							?>
							<tr>
								<td><?php echo $package_counter;?></td>
								<td><?php echo $duration_days;?> Days</td>
								<td>Rs. <?php echo $package_price;?></td>
								<td><?php if($package_status == 'Active') { ?><a href="package_list.php?package_id=<?php echo $fetch_record['package_id']?>&action=inactive" title="Click to inactive" onclick="return confirm('Are you sure you want to inactive this package?');"><ul class="the-icons clearfix"><li><i class="isb-unlock"></i></li></ul></a><?php } else { ?><a href="package_list.php?package_id=<?php echo $fetch_record['package_id']?>&action=active" title="Click to active" onclick="return confirm('Are you sure you want to active this package?');"><ul class="the-icons clearfix"><li><i class="isb-lock"></i></li></ul></a><?php } ?></td>
								<td><a href="add_edit_package.php?package_id=<?php echo $fetch_record['package_id']?>&action=edit" title="Edit" style="float:left; display:block; margin:0 5px 0 0;"><ul class="the-icons clearfix"><i class="isb-edit"></i></ul></a><a href="package_list.php?package_id=<?php echo $fetch_record['package_id']?>&action=delete" title="Delete" onclick="return confirm('Are you sure you want to delete this package?');" style="float:left; display:block; margin:0 5px 0 0;"><ul class="the-icons clearfix"><i class="isb-delete"></i></ul></a></td>
								<td>&nbsp;</td>
							</tr>
							<?php
							$package_counter++;
							}
						}
						else
						{
						?>
						<tr><td colspan="5" align="center"><font color="#FF0000">No package found</font></td></tr>
						<?php
						}
						?>
						</tbody>
					</table>
				</div>
			</div>                                
		</div>
	</div>
</div>

<?php require_once("footer.php"); ?>