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 -

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

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

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)
×		Bohea Wooden Jewelry Box	€61	Bohea Wooden Jewelry Box quantity	€61
×		Silva Bag	€68	Silva Bag quantity	€68
×		Clarus Bag	€68	Clarus Bag quantity	€68
×		Herek Waist Bag	€67	Herek Waist Bag quantity	€67
Coupon:

Cart totals

Subtotal	€10.686 (incl. VAT)
Total	€10.686

Proceed to checkout