query("orders", "SELECT * FROM orders WHERE `status` = 0");
$orders = $order_res->num_rows;
$stock_take_res = $db->query("stock_takes", "SELECT * FROM stock_takes WHERE date_done = ''");
$stock_take = $stock_take_res->num_rows;
$order_trans_res = $db->query("order_trans", "SELECT SUM(amount) as total FROM order_trans WHERE user_id = {$_SESSION['user_id']} AND amount > 0 AND date_time BETWEEN '{$firstOfMonth}' AND '{$lastOfMonth}'");
if ($order_trans_res->num_rows > 0) {
$order_trans_rec = $order_trans_res->fetch_assoc();
$order_trans_rec = $order_trans_rec['total'];
} else {
$order_trans_rec = 0;
}
$order_trans_res_1 = $db->query("order_trans", "SELECT SUM(amount) as total FROM order_trans WHERE user_id = {$_SESSION['user_id']} AND amount < 0 AND date_time BETWEEN '{$firstOfMonth}' AND '{$lastOfMonth}'");
if ($order_trans_res_1->num_rows > 0) {
$order_trans_disp = $order_trans_res_1->fetch_assoc();
$order_trans_disp = $order_trans_disp['total'];
} else {
$order_trans_disp = 0;
}
if (strlen($order_trans_disp) < 1) {
$order_trans_disp = 0;
}
?>
create_link("small", "ORDERS", "stock_control.php", $orders);
$dash->create_link("small", "STOCK TAKES", "", $stock_take);
?>
create_link("small", "STOCK RECE.", "stock_control.php", $order_trans_rec);
$dash->create_link("small", "STOCK DISP.", "1", $order_trans_disp);
?>