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 -

“Cella Wooden Sugar Bowl – 2” has been added to your cart. Continue shopping

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

“Asar Ahşap Anahtar Kutusu” sepetinize eklendi. Alışverişe devam et

Cart Summary

Remove item	Thumbnail image	Product	Price	Quantity	Subtotal
×		Merlan Ahşap Sunum Tahtası	€990	Merlan Ahşap Sunum Tahtası quantity	€990 (incl. VAT)
×		Ruris Anadolu Çanta	€1.190	Ruris Anadolu Çanta quantity	€1.190 (incl. VAT)
×		Ruris Anatolian Bag	€61	Ruris Anatolian Bag quantity	€61
×		Marinae Crochet Bag	€78	Marinae Crochet Bag quantity	€78
×		Rarel Çanta	€2.490	Rarel Çanta quantity	€2.490 (incl. VAT)
×		Cella Ahşap Şekerlik-2	€890	Cella Ahşap Şekerlik-2 quantity	€890 (incl. VAT)
×		Clarus Çanta	€1.490	Clarus Çanta quantity	€1.490 (incl. VAT)
×		Silva Çanta	€1.290	Silva Çanta quantity	€1.290 (incl. VAT)
×		Elpeden Bag	€64	Elpeden Bag quantity	€64
×		Mertek Ahşap Mücevher Kutusu	€1.290	Mertek Ahşap Mücevher Kutusu quantity	€1.290 (incl. VAT)
×		Rula Ahşap Mücevher Kutusu	€1.290	Rula Ahşap Mücevher Kutusu quantity	€1.290 (incl. VAT)
×		Cella Wooden Sugar Bowl - 2	€58	Cella Wooden Sugar Bowl - 2 quantity	€58
×		Rarel Bag	€92	Rarel Bag quantity	€92
×		Asar Ahşap Anahtar Kutusu	€890	Asar Ahşap Anahtar Kutusu quantity	€890 (incl. VAT)
Coupon:

Cart totals

Subtotal	€12.163 (incl. VAT)
Total	€12.163

Proceed to checkout