<?php

if (empty($_SESSION['login'])) {
    kick('login?kickback=' . htmlspecialchars(kickback_url()));
}
$categories = Category::selection(array('category_id:!=' => 0));
$products = Product::selection(array('category_id:!=' => 0));
$old_values = ClientData::session('_POST');
unset($_SESSION['_POST']);
?>
<script type="text/javascript">
<!--
function addLine() {
	var hidden=document.getElementById("template");
	var element = hidden.previousSibling;
	while(!String(element).match('HTMLTableRowElement')) {
		element = element.previousSibling;
	}
	var last_element_inputs = element.getElementsByTagName('input');
	for(i=0; i<last_element_inputs.length; i++) {
		if(last_element_inputs[i].value != '') {
			var new_line=hidden.cloneNode(true);
			new_line.removeAttribute('style');
			new_line.removeAttribute('id');
			hidden.parentNode.insertBefore(new_line, hidden);
			return;
		}
	}
}
var products = new Array();
<? foreach($products as $product): ?>
<?php

$transaction = Transaction::last();
$products = Product::selection(array('category_id:!=' => 0, '@order' => 'product_id'));
function get_rand()
{
    $random = rand();
    if (isset($_SESSION['random']) && $random == $_SESSION['random']) {
        $random++;
    }
    return $random;
}
?>
<script type="text/javascript" src="/js/purchase.js"></script>
<script type="text/javascript" src="/js/suggest.js"></script>
<script type="text/javascript">
<!--
var products;
var last_empty;

/**
 * Takes a keyPressed event in recieved amount and deciedes what
 * to do with it.
 */
function keyHook(e) {
	var recieved_elem=document.getElementById('recieved');
	var change_elem=document.getElementById('change');
	var keynum;
	var keychar;
	var finish_transaction=false;
	var last_empty = new Date();
<?php

if (empty($_SESSION['login'])) {
    kick('login?kickback=' . htmlspecialchars(kickback_url()));
}
function mark($bool)
{
    if ($bool) {
        return ' marked';
    } else {
        return '';
    }
}
$products = Product::selection(array('@custom_order' => '`products`.`count` > 0 DESC', '@order' => array('Category.name', 'name'), 'category_id:!=' => 0));
$i = 0;
$revenue = array();
$db->prepare_fetch("\n\tSELECT\n\t\tSUM(`transaction_contents`.`amount` -\n\t\t\t`transaction_contents`.`count` * `products`.`value`\n\t\t) as revenue\n\tFROM\n\t\t`transaction_contents` JOIN\n\t\t`products` ON (`products`.`product_id` = `transaction_contents`.`product_id`) JOIN\n\t\t`transactions` ON (`transaction_contents`.`transaction_id` = `transactions`.`transaction_id`)\n\tWHERE\n\t\t`transactions`.`timestamp` > ?", $revenue, 's', date('Y-m-d', time() - 60 * 60 * 24 * 30));
?>
<table>
	<tr>
		<th>Lagrets värde</th>
		<td class="numeric"><?php 
echo number(Product::sum(array('value', '*', 'count')));
?>
 kr</td>
	</tr>
	<tr>
		<th>Försäljning senaste 30 dagarna</th>
		<td class="numeric"><?php 
echo number(TransactionContent::sum('amount', array('Transaction.timestamp:>' => date('Y-m-d', time() - 60 * 60 * 24 * 30))));
?>