class MCF_Ledger_Engine { public function get_daily_ledger() { global $wpdb; $table = $wpdb->prefix . 'mcf_ledger'; $rows = $wpdb->get_results(" SELECT order_id, order_date, currency, net_sale, profit, exchange_rate FROM {$table} ORDER BY order_date ASC "); $result = []; foreach ($rows as $row) { if (empty($row->order_date)) { continue; } $date = date('Y-m-d', strtotime($row->order_date)); if (!isset($result[$date])) { $result[$date] = [ 'consolidated' => ['sales'=>0.0,'profit'=>0.0], 'TRY' => ['sales'=>0.0,'profit'=>0.0], 'EUR' => ['sales'=>0.0,'profit'=>0.0], 'orders' => [] ]; } $currency = strtoupper(trim($row->currency)); $net_sale = (float) $row->net_sale; $profit = (float) $row->profit; $exchange_rate = (float) $row->exchange_rate; if ($exchange_rate <= 0) { $exchange_rate = 1; } // Currency raw aggregation if (isset($result[$date][$currency])) { $result[$date][$currency]['sales'] += $net_sale; $result[$date][$currency]['profit'] += $profit; } // TL Consolidation if ($currency === 'EUR') { $sale_tl = $net_sale * $exchange_rate; $profit_tl = $profit * $exchange_rate; } else { $sale_tl = $net_sale; $profit_tl = $profit; } $result[$date]['consolidated']['sales'] += $sale_tl; $result[$date]['consolidated']['profit'] += $profit_tl; $result[$date]['orders'][] = [ 'id' => (int) $row->order_id, 'currency' => $currency, 'profit_tl' => round($profit_tl,2) ]; } return $result; } } Asar Wooden Key Box -

Asar Wooden Key Box

58

Asar Wooden Key Box is an MDF key storage box designed for organizing household and personal keys. Its openable front cover provides easy access while keeping keys neatly stored.

1 in stock

SKU: ASAR_EN Categories: ,

Description

Asar Wooden Key Box is an MDF key storage box designed for organizing household and personal keys. Its openable front cover provides easy access while keeping keys neatly stored.

The interior is suitable for hanging items such as house keys, car keys, and room keys. The exterior features a patterned surface, adding a decorative touch while maintaining practical use.

Product Features:
• MDF body
• Openable front cover
• Patterned exterior design
• Suitable for house, car, and room keys
• Designed for indoor use

Product Dimensions:
Width (W): –
Height (H): –
Depth (D): –

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.