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 -

“Vento Wooden Wall Clock” has been added to your cart. Continue shopping

“Mertek Wooden Jewelry Box” has been added to your cart. Continue shopping

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

Cart Summary

Remove item	Thumbnail image	Product	Price	Quantity	Subtotal
×		Ruris Anadolu Çanta	€1.190	Ruris Anadolu Çanta quantity	€1.190 (incl. VAT)
×		Rezen Çanta	€990	Rezen Çanta quantity	€990 (incl. VAT)
×		Tima Wooden Desk Clock	€78	Tima Wooden Desk Clock quantity	€78
×		Ruris Anatolian Bag	€61	Ruris Anatolian Bag quantity	€61
×		Marinae Örgü Çanta	€1.790	Marinae Örgü Çanta quantity	€1.790 (incl. VAT)
×		Asar Wooden Key Box	€58	Asar Wooden Key Box quantity	€58
×		Clarus Çanta	€1.490	Clarus Çanta quantity	€1.490 (incl. VAT)
×		Vento Wooden Wall Clock	€76	Vento Wooden Wall Clock quantity	€76
×		Mertek Wooden Jewelry Box	€69	Mertek Wooden Jewelry Box quantity	€69
×		Marinae Crochet Bag	€78	Marinae Crochet Bag quantity	€78
Coupon:

Cart totals

Subtotal	€5.880 (incl. VAT)
Total	€5.880

Proceed to checkout