<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']); ?>