<?php session_start();
 if( !isset($_SESSION['ps_user']) )
 {
	include('login.php');
	    die();
}
 
include('includes/config.php');
if($lang == 'en'){include('languages/en.php');}else if($lang == 'ar'){include('languages/ar.php');}
mysql_connect("$host", "$user", "$pass")or die("cannot connect");
mysql_select_db("$db")or die("cannot select DB");
$now = $_SESSION['ps_user'];
$sql="SELECT * FROM users WHERE Username = '$now'";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
	$usern = $row['type'];
}
if($usern != 1 ){echo "<script>location='devices.php'</script>";}
$id = $_GET['id'];     
 $cat = $_GET['cat'];
 $type = $_GET['type'];
$delete = $_GET['deleteid'];
	 if(isset($delete))
	 {
	 mysql_connect("$host", "$user", "$pass") or die(mysql_error()); 
     mysql_select_db("$db") or die(mysql_error()); 
     mysql_query("DELETE FROM stock WHERE id = $delete ");  
	 }
 ?>
<!DOCTYPE html>
<html lang="en">
<head>

	<meta charset="utf-8">
	<title><?echo $lang_226;?></title>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta name="description" content="<?echo $lang_1;?>">
	<meta name="author" content="Ahmed Saleh">

	<!-- The styles -->
			<? include 'includes/css.php';?>

	<script type="text/javascript">
// Popup window code
function newPopup(url) {
	popupWindow = window.open(
	url,'popUpWindow','height=300,width=300,left=10,top=10,resizable=no,scrollbars=no,toolbar=no,menubar=no,location=no,directories=no,status=yes')
	popupWindow.focus();

}
</script>
<script type="text/javascript">
// Popup window code
function newPopup2(url) {
	popupWindow = window.open(
	url,'popUpWindow','height=700,width=300,left=10,top=10,resizable=no,scrollbars=no,toolbar=no,menubar=no,location=no,directories=no,status=yes')
	popupWindow.focus();
}
</script>	
</head>

<body>
		<!-- topbar starts -->
<?include('includes/navbar.php');?>
<!-- topbar ends -->
		<div class="container-fluid">
		<div class="row-fluid">
				
<!-- left menu starts -->
<?include('includes/menu.php');?>
<!-- left menu ends -->
			
			<noscript>
				<div class="alert alert-block span10">
					<h4 class="alert-heading">Warning!</h4>
					<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
				</div>
			</noscript>
			
			<div id="content" class="span10">
			<div style="border-style:solid;border-width:1px;padding:15px;margin-right: 50px;">
			<a href="control.php"><span>لوحة التحكم</span></a> / <a href="control_food_cat.php"><span>فئات المأكولات</span></a> / <span><?echo $cat;?></span>
			</div>
			 
			<br/>
			<!-- content starts -->
<a href ="control_product_add.php?type=food&&cat=<? echo $cat;?>"  class="btn btn-primary"><?echo $lang_47;?></a>
			<a href ="control_cat_name.php?type=food&cat=<?echo $cat;?>&&old_cat=food" class="btn btn-primary"><?echo $lang_229;?></a>
			<a href ="control_cat_img.php?type=food&cat=<?echo $cat;?>" class="btn btn-primary"><?echo $lang_362;?></a>



<div class="row-fluid">		
				<div class="box span11">
					<div class="box-header well" data-original-title>
						<h2><i class="icon-user"></i> <?echo $cat; ?></h2>
						
					</div>
					<div class="box-content">
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <?
								
include('includes/config.php');
// To connect to the database
mysql_connect("$host", "$user", "$pass")or die("cannot connect");
mysql_select_db("$db")or die("cannot select DB");
$result = mysql_query("SELECT *,SUM(stock),SUM(sold) FROM `stock` WHERE catagory = 'food' AND sub_cat = '$cat' AND name !=' '  GROUP BY name ORDER BY name ASC");

?><thead>
<tr>
								  <th><?echo $lang_49;?></th>
  								  <th><?echo $lang_51;?></th>
								  <th><?echo $lang_117;?></th>
								  <th><?echo $lang_194;?></th>
								  <th><?echo $lang_167;?></th>
</tr>
</thead> 
						  <tbody>
						  <?					
			 	while($row = mysql_fetch_array($result))
  {
  			$aaas =  $row['SUM(stock)'] - $row['SUM(sold)'];
    $idid = $row['id'];

  echo "<tr>";
  echo '<td><a class="btn btn-info" href="control_product.php?id='.$row['id'].'">'.'<i class="icon-edit icon-white"></i>'.' '.$row['name'].'</a></td>';
   echo "<td>" . $row['price'] ."</td>";
  if($row['ing'] == 'no' ){
  echo "<td>" ." ".$lang_114." ". $aaas . "</td>"; } else { echo "<td><b>".$lang_402."</b></td>"; }  echo '<td><a class="btn btn-success" href="control_product.php?id='.$row['id'].'">'.'<i class="icon-zoom-in icon-white"></i>'.$lang_194.'</a></td>';
   ?>    <td class="center">
																		  <span class="label label-important"><a href="control_food.php?deleteid=<? echo $idid;?>&&cat=<?echo $cat; ?>"  onclick="return confirm('<?echo $lang_244;?>')"><?echo $lang_167;?></a></span>
									</td>      <?
   echo "</tr>";
  }?>
						  </tbody>
					  </table>            
					</div>
				</div><!--/span-->
			
			</div><!--/row-->

			
			
			 
			
			
			

					<!-- content ends -->
			</div><!--/#content.span10-->
				</div><!--/fluid-row-->
				
		<hr>

		<div class="modal hide fade" id="myModal">
			<div class="modal-header">
				<button type="button" class="close" data-dismiss="modal">�</button>
				<h3>Settings</h3>
			</div>
			<div class="modal-body">
				<p>Here settings can be configured...</p>
			</div>
			<div class="modal-footer">
				<a href="#" class="btn" data-dismiss="modal">Close</a>
				<a href="#" class="btn btn-primary">Save changes</a>
			</div>
		</div>

		<footer>
			<p class="pull-left">&copy; <a href="http://www.gesture-sys.com/playstation" target="_blank">Gesture For Playstation</a> <?$Year = idate('Y');   echo $Year;?></p>
			
		</footer>
		
	</div><!--/.fluid-container-->
<? include 'includes/js.php';?>
	
		
</body>
</html>
