<tbody>
<? foreach(Category::selection(array('@order' => 'name')) as $category): ?>
<tr>
<td><a href="/edit_category/<?php
echo $category->id;
?>
"><img src="/gfx/edit.png" alt="edit" /></a></td>
<td class="name_column"><a href="/category/<?php
echo $category->id;
?>
"><?php
echo $category->name;
?>
</a></td>
<td class="numeric total_value_column"><?php
echo number(Product::sum(array('value', '*', 'count'), array('category_id' => $category->id)));
?>
kr</td>
<td class="numeric sales_value"><?php
echo number($sale = TransactionContent::sum('amount', array('Product.category_id' => $category->id, 'Transaction.timestamp:>' => date('Y-m-d', time() - 60 * 60 * 24 * 30))));
?>
kr</td>
<td class="numeric sales_revenue"><?php
echo number($revenue = $category->revenue(date('Y-m-d', time() - 60 * 60 * 24 * 30)));
?>
kr</td>
<td class="numeric revenue_p"><?php
echo $sale != 0 ? number($revenue / $sale * 100) : '';
?>
%</td>
</tr>
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))));
?>
kr</td>
</tr>
<tr>
<th>Vinst senaste 30 dagarna</th>
<td class="numeric"><?php
echo number($revenue['revenue']);
?>
