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; } } walnut wood arşivleri -
  • mücevher sandığı ahşap

    Arca Jewellery Box

    €68
    Read moreDone
  • Ahşap Çanta El Yapımı handmade wooden purse

    Lignum Wooden Purse

    €68

    Lignum Wooden Purse is designed as a compact wooden handbag that combines natural materials with a refined and functional form. Its structured silhouette offers a clear and balanced presence, making it suitable for daily use as well as special occasions.

    The case is our gift to you!

    Read moreDone
  • Quadra Wooden Wall Clock

    Quadra Wooden Wall Clock

    €85

    Quadra Wooden Wall Clock is designed as a refined wall clock that combines natural materials with a clean and structured form. Its rectangular silhouette offers a balanced presence on the wall, making it suitable for both modern and classic interiors.

    Read moreDone
  • handmade wooden wall clock

    Vento Wooden Wall Clock

    €76

    Vento Wooden Wall Clock is designed as a clean and balanced wall clock that combines natural materials with a minimalist form. Its square silhouette creates a clear visual presence, making it suitable for modern and understated interior spaces.

    Add to cartDone
  • Ventura Wooden Desk Clock

    Ventura Wooden Desk Clock

    €78

    Ventura Wooden Desk Clock is designed as a compact desk clock that brings together natural materials and a warm, balanced form. Its slim profile and clean structure make it suitable for desks, shelves, and interior spaces where simplicity and character are equally important.

    Read moreDone