"use client"; import { useState, useEffect } from "react"; import { Button } from "@/components/ui/button"; import { Download, TrendingUp, TrendingDown, DollarSign, FileText, Sheet } from "lucide-react"; import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs"; import { createClient } from "@/utils/supabase/client"; import { toast } from "sonner"; import { XAxis, YAxis, CartesianGrid, Tooltip, ResponsiveContainer, BarChart, Bar, Legend } from "recharts"; export default function ReportsPage() { const [loading, setLoading] = useState(true); const [salesTotal, setSalesTotal] = useState(0); const [purchasesTotal, setPurchasesTotal] = useState(0); const [dateRange, setDateRange] = useState("monthly"); const [chartData, setChartData] = useState([]); const supabase = createClient(); useEffect(() => { fetchMetrics(); generateMockChartData(); }, [dateRange]); const generateMockChartData = () => { if (dateRange === "monthly") { setChartData([ { name: "الأسبوع 1", sales: 4000, purchases: 2400 }, { name: "الأسبوع 2", sales: 3000, purchases: 1398 }, { name: "الأسبوع 3", sales: 12000, purchases: 9800 }, { name: "الأسبوع 4", sales: 2780, purchases: 3908 }, ]); } else { setChartData([ { name: "الشهر 1", sales: 15000, purchases: 8000 }, { name: "الشهر 2", sales: 23000, purchases: 12000 }, { name: "الشهر 3", sales: 18000, purchases: 9500 }, ]); } }; const fetchMetrics = async () => { setLoading(true); const { data: salesData } = await supabase .from("orders") .select("total_amount, shipping_fee") .not('status', 'in', '("cancelled","returned_inventory","returned_shipping")'); const { data: purchasesData } = await supabase .from("purchases") .select("total_amount"); const tSales = salesData?.reduce((acc, curr) => acc + (Number(curr.total_amount) - Number(curr.shipping_fee || 0)), 0) || 0; const tPurchases = purchasesData?.reduce((acc, curr) => acc + Number(curr.total_amount), 0) || 0; setSalesTotal(tSales); setPurchasesTotal(tPurchases); setLoading(false); }; const exportExcel = async () => { const { data, error } = await supabase .from("orders") .select("id, total_amount, shipping_fee, status, created_at, customers(name)") .order("created_at", { ascending: false }); if (error) { toast.error("حدث خطأ أثناء التصدير"); return; } const ExcelJS = (await import("exceljs")).default; const workbook = new ExcelJS.Workbook(); const worksheet = workbook.addWorksheet("تقرير المبيعات", { views: [{ rightToLeft: true }] }); worksheet.columns = [ { header: "رقم الطلب", key: "id", width: 35 }, { header: "العميل", key: "customer", width: 25 }, { header: "المبلغ (ج.م)", key: "amount", width: 15 }, { header: "الحالة", key: "status", width: 15 }, { header: "التاريخ", key: "date", width: 20 }, ]; worksheet.getRow(1).font = { bold: true, color: { argb: "FFFFFFFF" } }; worksheet.getRow(1).fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FF4F46E5' } }; worksheet.getRow(1).alignment = { horizontal: 'center' }; data.forEach((order: any) => { worksheet.addRow({ id: order.id, customer: order.customers?.name || "غير معروف", amount: Number(order.total_amount) - Number(order.shipping_fee || 0), status: order.status === "pending" ? "قيد الانتظار" : order.status === "shipped" ? "تم الشحن" : "مكتمل", date: new Date(order.created_at).toLocaleDateString("ar-EG") }); }); const buffer = await workbook.xlsx.writeBuffer(); const blob = new Blob([buffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }); const url = URL.createObjectURL(blob); const link = document.createElement("a"); link.href = url; link.download = `تقرير_المبيعات_${new Date().getTime()}.xlsx`; link.click(); toast.success("تم تصدير Excel بنجاح"); }; const exportPDF = async () => { const { data, error } = await supabase .from("orders") .select("id, total_amount, status, created_at, customers(name)") .limit(50) .order("created_at", { ascending: false }); if (error) { toast.error("حدث خطأ أثناء التصدير"); return; } const jsPDF = (await import("jspdf")).default; await import("jspdf-autotable"); const doc = new jsPDF({ orientation: "portrait", unit: "mm", format: "a4" }); doc.setFont("helvetica"); doc.setFontSize(20); doc.text("Sales Report", 105, 15, { align: "center" }); doc.setFontSize(10); doc.text(`Generated on: ${new Date().toLocaleDateString()}`, 105, 22, { align: "center" }); const tableColumn = ["Order ID", "Customer", "Amount (EGP)", "Status", "Date"]; const tableRows: any[] = []; data.forEach((order: any) => { tableRows.push([ order.id.split('-')[0], order.customers?.name || "Unknown", Number(order.total_amount) - Number(order.shipping_fee || 0), order.status, new Date(order.created_at).toLocaleDateString() ]); }); (doc as any).autoTable({ head: [tableColumn], body: tableRows, startY: 30, theme: 'grid', headStyles: { fillColor: [79, 70, 229] }, styles: { fontSize: 9 } }); doc.save(`Sales_Report_${new Date().getTime()}.pdf`); toast.success("تم تصدير PDF بنجاح"); }; return (

التقارير والأرباح

عرض ملخص مالي وتحليل الأداء

إجمالي المبيعات
{loading ? "..." : salesTotal.toLocaleString()} ج.م
إجمالي المشتريات
{loading ? "..." : purchasesTotal.toLocaleString()} ج.م
صافي الربح / الخسارة
= 0 ? 'text-emerald-600' : 'text-red-600'}`}> {loading ? "..." : (salesTotal - purchasesTotal).toLocaleString()} ج.م
نظرة عامة على الأداء تصدير التقارير

مقارنة المبيعات والمشتريات ({dateRange === "monthly" ? "شهري" : "ربع سنوي"})

`${value}`} stroke="#9CA3AF" fontSize={11} />

تقرير Excel

تحميل تقرير مفصل بصيغة Excel.

تقرير PDF

نسخة جاهزة للطباعة بصيغة PDF.
); }