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 -

“Mertek Ahşap Mücevher Kutusu” sepetinize eklendi. Alışverişe devam et

“Herek Bel Çantası” sepetinize eklendi. Alışverişe devam et

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

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

Cart Summary

Remove item	Product	Price	Quantity	Subtotal
×	Cella Ahşap Şekerlik-2	€890	Cella Ahşap Şekerlik-2 quantity	€890 (incl. VAT)
×	Mertek Ahşap Mücevher Kutusu	€1.290	Mertek Ahşap Mücevher Kutusu quantity	€1.290 (incl. VAT)
×	Herek Bel Çantası	€1.190	Herek Bel Çantası quantity	€1.190 (incl. VAT)
×	Silva Bag	€68	Silva Bag quantity	€68
×	Mertek Wooden Jewelry Box	€69	Mertek Wooden Jewelry Box quantity	€69
Coupon:

Cart totals

Subtotal	€3.507 (incl. VAT)
Total	€3.507

Proceed to checkout

Cart Summary

Cart totals

information

ADRESS

whatsapp