<?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']; $id = $_GET['id']; 
$date = $_GET['date']; 
$sess = $_GET['session']; 
 

$mnmn = $_GET['etype'];
$kjkj = $_GET['id'];
if(isset($mnmn))
{
	mysql_connect("$host", "$user", "$pass") or die(mysql_error()); 
	mysql_select_db("$db") or die(mysql_error()); 
	mysql_query("DELETE FROM reports2 WHERE id = $kjkj"); 
} 

$D = $_GET['day'];
$M = $_GET['month'];
$Y = $_GET['year'];
$rshift = $_GET['shift'];
$Rcash = $_GET['casheer'];
?>
<!DOCTYPE html>
<html lang="en">
<head>

<meta charset="utf-8">
<title><?echo $lang_163;?></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="reports.php"><span>التقارير</span></a> / <a href="reports_month.php?month=<?echo $M;?>&year=<?echo $Y;?>"><span>تقارير شهر <?echo $Y?>-<?echo $M?></span></a> / <a href="reports_month_casheer.php?month=<?echo $M;?>&year=<?echo $Y;?>"><span>تقارير الكاشير</span></a> / <a href="reports_month_casheer_all.php?month=<?echo $M;?>&year=<?echo $Y;?>&se_cash=<?echo $Rcash;?>"><span><?echo $Rcash;?> </span></a> / <span>الدواخل</span>
			</div>
<!-- content starts -->

<div class="row-fluid">		
<div class="box span11">
<div class="box-header well" data-original-title>
<h2><i class="icon-user"></i> <?echo $lang_163;?> </h2>

</div>

<div class="box-content">
<table class="table table-striped table-bordered bootstrap-datatable datatable">
<?

include('includes/config.php');
mysql_connect("$host", "$user", "$pass")or die("cannot connect");
mysql_select_db("$db")or die("cannot select DB");



$query = "SELECT  SUM(price) FROM reports2 where catagory = 'in' AND month = '$M' AND year = '$Y'  AND `casheer` = '$Rcash'"; 


$resulty = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($resulty)){
	$items = $row['SUM(price)'];
	?><h2><?echo $lang_164;?>:<? echo "<font color='green'>". $row['SUM(price)']; ?> 
	</font><?echo $lang_100;?></h2> 
	<?
}

// To connect to the database

$result = mysql_query("SELECT * FROM `reports2` WHERE catagory  = 'in' AND month = '$M' AND year = '$Y'  AND `casheer` = '$Rcash'");
?>
<thead>
<tr>
								<th><?echo $lang_165;?></th>
								<th><?echo $lang_21;?></th>
								<th><?echo $lang_77;?></th>
								<th><?echo $lang_150;?></th>
								<th><?echo $lang_166;?></th>
								<th><?echo $lang_23;?></th>
								<th><?echo $lang_22;?></th>
								<th><?echo $lang_167;?></th>
</tr>
</thead>
 
<tbody>
<?


while($row = mysql_fetch_array($result))
{
	$eid = $row['id'];
$shift_check = $row['shift'];
 if($shift_check == 'One'){$shift_check2= $lang_155;}else{$shift_check2 = $lang_156;}
	echo "<tr>";
	echo "<td>" . $row['id'] . "</td>";
	echo "<td>" . $row['name'] . "</td>";
	echo "<td>" . $row['day'] ."-". $row['month'] . "-" . $row['year']. "</td>";
	echo "<td>" . $shift_check2 . "</td>";
	echo "<td>" . $row['casheer'] . "</td>";
	echo "<td>" . $row['price'] . "</td>";
	echo "<td>" . $row['notes'] . "</td>";
	?><td class="center">
	<span class="label label-important"><a href="out.php?etype=exp&&id=<? echo $eid;?>" ><?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>
