"use client"; import { useState, useEffect } from "react"; import { createClient } from "@/utils/supabase/client"; import { toast } from "sonner"; import { useTenant } from "@/components/shared/TenantProvider"; import { Wallet, ArrowDownRight, ArrowUpRight, Plus, Banknote, Calendar, RefreshCcw } from "lucide-react"; import { format } from "date-fns"; import { ar } from "date-fns/locale"; import Link from "next/link"; import { Button } from "@/components/ui/button"; import { Input } from "@/components/ui/input"; import { Label } from "@/components/ui/label"; import { Textarea } from "@/components/ui/textarea"; import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow, } from "@/components/ui/table"; import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle, } from "@/components/ui/dialog"; import { Select, SelectContent, SelectItem, SelectTrigger, SelectValue, } from "@/components/ui/select"; import { Badge } from "@/components/ui/badge"; export default function TreasuryPage() { const { tenant } = useTenant(); const supabase = createClient(); const [transactions, setTransactions] = useState([]); const [vaultProfit, setVaultProfit] = useState(0); const [loading, setLoading] = useState(true); // Modal State const [isModalOpen, setIsModalOpen] = useState(false); const [isSubmitting, setIsSubmitting] = useState(false); const [isResetModalOpen, setIsResetModalOpen] = useState(false); const [isResetting, setIsResetting] = useState(false); // Form State const [type, setType] = useState<"capital" | "expense" | "income">("expense"); const [amount, setAmount] = useState(""); const [category, setCategory] = useState(""); const [description, setDescription] = useState(""); useEffect(() => { fetchTransactions(); }, [tenant]); const fetchTransactions = async () => { if (!tenant?.id) return; setLoading(true); const [transactionsRes, paidOrdersRes] = await Promise.all([ supabase .from("transactions") .select("*") .eq("tenant_id", tenant.id) .order("transaction_date", { ascending: false }), supabase .from('orders') .select(`id, is_deleted, total_amount, shipping_fee, payment_status, order_items ( quantity, unit_price, product_variants ( normal_cost ) )`) .in('payment_status', ['paid', 'partial', 'refunded']) .eq('tenant_id', tenant.id) ]); if (transactionsRes.error) { if (transactionsRes.error.code === "42P01") { toast.error("عذراً، يبدو أن جدول الخزنة (transactions) لم يتم إنشاؤه بعد في قاعدة البيانات."); } else { toast.error("فشل في جلب بيانات الخزنة"); } } else { setTransactions(transactionsRes.data || []); } // Fetch Vault Profit from paid orders if (paidOrdersRes.data) { let profit = 0; paidOrdersRes.data.filter((o: any) => o.is_deleted !== true).forEach(order => { let orderRevenue = 0; let totalCost = 0; order.order_items?.forEach((item: any) => { const qty = Number(item.quantity) || 0; const price = Number(item.unit_price) || 0; const cost = Number(item.product_variants?.normal_cost) || 0; orderRevenue += qty * price; totalCost += qty * cost; }); // If order is refunded (returned), we only lose the shipping fee, cost of items is not lost if (order.payment_status === 'refunded') { profit -= Number(order.shipping_fee || 0); return; } // Use manual total_amount if present (e.g. from shipping fees or partial deliveries) // Subtract shipping fee to get actual item revenue for profit calculation const itemRevenue = (order.total_amount !== null && order.total_amount !== undefined) ? Number(order.total_amount) - Number(order.shipping_fee || 0) : orderRevenue; profit += (itemRevenue - totalCost); }); setVaultProfit(profit); } setLoading(false); }; const handleAddTransaction = async (e: React.FormEvent) => { e.preventDefault(); if (!tenant?.id) return; if (!amount || Number(amount) <= 0) { toast.error("يرجى إدخال مبلغ صحيح"); return; } setIsSubmitting(true); const { error } = await supabase.from("transactions").insert({ tenant_id: tenant.id, type, amount: Number(amount), category, description, transaction_date: new Date().toISOString() }); if (error) { toast.error("حدث خطأ أثناء حفظ الحركة: " + error.message); } else { toast.success("تم إضافة الحركة بنجاح"); setIsModalOpen(false); // Reset form setAmount(""); setCategory(""); setDescription(""); setType("expense"); fetchTransactions(); } setIsSubmitting(false); }; const handleResetTreasury = async () => { if (!tenant?.id) return; setIsResetting(true); // Delete all manual transactions for this tenant const { error } = await supabase .from('transactions') .delete() .eq('tenant_id', tenant.id); if (error) { toast.error("حدث خطأ أثناء تصفير الخزنة: " + error.message); } else { toast.success("تم تصفير الخزنة (الحركات اليدوية) بنجاح"); setIsResetModalOpen(false); fetchTransactions(); } setIsResetting(false); }; const totalCapital = transactions.filter(t => t.type === "capital").reduce((sum, t) => sum + Number(t.amount), 0); const totalIncome = transactions.filter(t => t.type === "income").reduce((sum, t) => sum + Number(t.amount), 0); const totalExpense = transactions.filter(t => t.type === "expense").reduce((sum, t) => sum + Number(t.amount), 0); const currentBalance = totalCapital + totalIncome + vaultProfit - totalExpense; const getBadgeForType = (txType: string) => { switch (txType) { case "capital": return إيداع رأس مال; case "income": return إيرادات; case "expense": return مصروفات; default: return {txType}; } }; const renderDescription = (desc: string) => { if (!desc) return "-"; const match = desc.match(/للطلب #([a-f0-9\-]+)/); if (match) { const orderId = match[1]; const parts = desc.split(match[0]); return ( {parts[0]}للطلب #{orderId.substring(0,8)}...{parts[1]} ); } return desc; }; return (

الخزنة

إدارة رأس المال، المصروفات، والإيرادات

{/* Summary Cards */}
{/* Balance Card */}

الرصيد الحالي للخزنة

{currentBalance.toLocaleString()} ج.م

{/* Profit Card */}

أرباح الطلبات

{vaultProfit.toLocaleString()} ج.م

{/* Capital Card */}

إجمالي رأس المال

{totalCapital.toLocaleString()} ج.م

{/* Income Card */}

إجمالي الإيرادات المضافة

{totalIncome.toLocaleString()} ج.م

{/* Expense Card */}

إجمالي المصروفات

{totalExpense.toLocaleString()} ج.م

{/* Transactions Table */}

سجل حركات الخزنة

التاريخ نوع الحركة التصنيف المبلغ ملاحظات / بيان {loading ? ( جاري التحميل... ) : transactions.length === 0 ? ( لا توجد حركات في الخزنة حتى الآن ) : ( transactions.map((tx) => (
{format(new Date(tx.transaction_date || tx.created_at), 'dd MMM yyyy, hh:mm a', { locale: ar })}
{getBadgeForType(tx.type)} {tx.category || "-"} {tx.type === 'expense' ? '-' : '+'}{Number(tx.amount).toLocaleString()} ج.م {renderDescription(tx.description)} )) )}
{/* Add Transaction Dialog */} إضافة حركة للخزنة قم بتسجيل حركة مالية جديدة سواء كانت إيداع رأس مال، أو مصروفات.
setAmount(e.target.value)} required className="text-right" />
setCategory(e.target.value)} required />