timeSeries
timeSeries: {
monthly: {
month: string;
monthKey: string;
revenue: number;
purchases: number;
margin: number;
revenueEur: number;
revenueMad: number;
purchasesEur: number;
purchasesMad: number;
revenueHT: number;
revenueTTC: number;
purchasesHT: number;
purchasesTTC: number;
marginHT: number;
marginTTC: number;
}[];
totalRevenue: number;
totalPurchases: number;
totalMargin: number;
revenueEur: number;
revenueMad: number;
purchasesEur: number;
purchasesMad: number;
revenueHT: number;
revenueTTC: number;
purchasesHT: number;
purchasesTTC: number;
marginHT: number;
marginTTC: number;
}
clients
clients: {
revenue: {
clientId: string;
_sum: { totalAmount: number };
_count: { id: number };
clientName: string;
clientCode: string;
}[];
totalClients: number;
}
suppliers
suppliers: {
purchases: {
supplierId: string;
_sum: { totalAmount: number };
_count: { id: number };
supplierName: string;
supplierCode: string;
}[];
totalSuppliers: number;
}
details
details: {
invoices: {
id: string;
number: string;
date: Date;
amount: number;
currency: string;
client: string;
clientCode: string;
}[];
purchaseOrders: {
id: string;
number: string;
date: Date;
amount: number;
currency: string;
supplier: string;
supplierCode: string;
}[];
}
metadata: {
filters: {
month?: string | null;
clientId?: string | null;
supplierId?: string | null;
year: number;
};
totalInvoices: number;
totalPurchaseOrders: number;
conversionRate: number;
lastUpdated: string;
}