Cart -

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; } } Cart -

“Rezen Bag” has been added to your cart. Continue shopping

“Tima Ahşap Masa Saati” sepetinize eklendi. Alışverişe devam et

Cart Summary

Remove item	Thumbnail image	Product	Price	Quantity	Subtotal
×		Vento Wooden Wall Clock	€76	Vento Wooden Wall Clock quantity	€76
×		Rula Ahşap Mücevher Kutusu	€1.290	Rula Ahşap Mücevher Kutusu quantity	€1.290 (incl. VAT)
×		Marinae Crochet Bag	€78	Marinae Crochet Bag quantity	€78
×		Cella Wooden Sugar Bowl - 2	€58	Cella Wooden Sugar Bowl - 2 quantity	€58
×		Elpeden Çanta	€1.090	Elpeden Çanta quantity	€1.090 (incl. VAT)
×		Essent Wooden Desk Clock	€68	Essent Wooden Desk Clock quantity	€68
×		Ahşap Rahle 2	€1.590	Ahşap Rahle 2 quantity	€1.590 (incl. VAT)
×		Merlan Wooden Serving Tray	€61	Merlan Wooden Serving Tray quantity	€61
×		Mertek Ahşap Mücevher Kutusu	€1.290	Mertek Ahşap Mücevher Kutusu quantity	€1.290 (incl. VAT)
×		Cella Ahşap Şekerlik-2	€890	Cella Ahşap Şekerlik-2 quantity	€890 (incl. VAT)
×		Merlan Ahşap Sunum Tahtası	€990	Merlan Ahşap Sunum Tahtası quantity	€990 (incl. VAT)
×		Fennel Ahşap Sunum Tahtası	€1.090	Fennel Ahşap Sunum Tahtası quantity	€1.090 (incl. VAT)
×		Rezen Bag	€61	Rezen Bag quantity	€61
×		Tima Ahşap Masa Saati	€1.790	Tima Ahşap Masa Saati quantity	€1.790 (incl. VAT)
Coupon:

Cart totals

Subtotal	€10.422 (incl. VAT)
Total	€10.422

Proceed to checkout