Compare commits
35 Commits
fix/FIBERO
...
fix/ticket
| Author | SHA1 | Date | |
|---|---|---|---|
| 35018e4b88 | |||
| 7a89c9d75b | |||
| b07e2faee5 | |||
| 34549fc4b6 | |||
| e582eb1693 | |||
| 41a90ad76e | |||
| b880137084 | |||
| fca3194801 | |||
| 22c1df67c1 | |||
| ef6b6a3ad4 | |||
| 8156c1f207 | |||
| 8a31ca0199 | |||
| d58b6bfd0b | |||
| e8b91468a1 | |||
| ac60822134 | |||
| 87e9fac4c1 | |||
| c061e821c9 | |||
| 63cce69634 | |||
| ff73898dac | |||
| 0715e66a65 | |||
| 205f0091dc | |||
| a6e13e611c | |||
| ff90ed9fa0 | |||
|
|
38e47b6140 | ||
| 944a501507 | |||
| 73012d52d3 | |||
| 546c32fc55 | |||
|
|
43379905f9 | ||
| 2b047055a2 | |||
| eaa03c69e0 | |||
| 45325b3e1b | |||
|
|
85f646cbed | ||
| 7db2a3fb5b | |||
| b719d87e1b | |||
| 89585ab645 |
9
.dockerignore
Normal file
9
.dockerignore
Normal file
@@ -0,0 +1,9 @@
|
|||||||
|
.next
|
||||||
|
node_modules
|
||||||
|
.git
|
||||||
|
.env.local
|
||||||
|
.env.*.local
|
||||||
|
npm-debug.log*
|
||||||
|
*.log
|
||||||
|
test-results
|
||||||
|
playwright-report
|
||||||
21
Dockerfile
Normal file
21
Dockerfile
Normal file
@@ -0,0 +1,21 @@
|
|||||||
|
FROM node:22-alpine AS builder
|
||||||
|
WORKDIR /app
|
||||||
|
ENV NODE_ENV=development
|
||||||
|
COPY package*.json ./
|
||||||
|
RUN npm ci
|
||||||
|
COPY . .
|
||||||
|
ENV NEXT_TELEMETRY_DISABLED=1
|
||||||
|
RUN npm run build
|
||||||
|
|
||||||
|
FROM node:22-alpine AS runner
|
||||||
|
WORKDIR /app
|
||||||
|
ENV NODE_ENV=production
|
||||||
|
ENV NEXT_TELEMETRY_DISABLED=1
|
||||||
|
|
||||||
|
COPY --from=builder /app/package*.json ./
|
||||||
|
COPY --from=builder /app/.next ./.next
|
||||||
|
COPY --from=builder /app/node_modules ./node_modules
|
||||||
|
|
||||||
|
EXPOSE 3000
|
||||||
|
ENV PORT=3000
|
||||||
|
CMD ["node_modules/.bin/next", "start"]
|
||||||
314
app/(app)/accounting/company-accounts/page.tsx
Normal file
314
app/(app)/accounting/company-accounts/page.tsx
Normal file
@@ -0,0 +1,314 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useState } from "react";
|
||||||
|
import { useQuery, useMutation } from "@tanstack/react-query";
|
||||||
|
import { toast } from "sonner";
|
||||||
|
import { ArrowRight } from "lucide-react";
|
||||||
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
|
import { Button } from "@/components/ui/Button";
|
||||||
|
import { Input } from "@/components/ui/Input";
|
||||||
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
|
import { Badge } from "@/components/ui/Badge";
|
||||||
|
import { Modal } from "@/components/ui/Modal";
|
||||||
|
import { AccountingNav } from "@/components/accounting/AccountingNav";
|
||||||
|
import { formatCurrency } from "@/lib/utils";
|
||||||
|
import api from "@/lib/api";
|
||||||
|
import type { CompanyAccount, CompanyAccountType, Transfer } from "@/types/index";
|
||||||
|
|
||||||
|
function formatDate(iso: string) {
|
||||||
|
return new Date(iso).toLocaleDateString("en-PH", { year: "numeric", month: "short", day: "numeric" });
|
||||||
|
}
|
||||||
|
|
||||||
|
const TYPE_COLORS: Record<CompanyAccountType, "default" | "success" | "warning"> = {
|
||||||
|
CASH: "success",
|
||||||
|
BANK: "default",
|
||||||
|
EWALLET: "warning",
|
||||||
|
};
|
||||||
|
|
||||||
|
const ACCOUNT_TYPES: CompanyAccountType[] = ["CASH", "BANK", "EWALLET"];
|
||||||
|
|
||||||
|
export default function CompanyAccountsPage() {
|
||||||
|
const today = new Date().toISOString().split("T")[0];
|
||||||
|
|
||||||
|
const [showAdd, setShowAdd] = useState(false);
|
||||||
|
const [addForm, setAddForm] = useState({
|
||||||
|
name: "", type: "BANK" as CompanyAccountType,
|
||||||
|
bankName: "", accountNumber: "", initialBalance: "0",
|
||||||
|
});
|
||||||
|
|
||||||
|
const [transferAccount, setTransferAccount] = useState<CompanyAccount | null>(null);
|
||||||
|
const [transferForm, setTransferForm] = useState({ toAccountId: "", amount: "", date: today, note: "" });
|
||||||
|
|
||||||
|
const { data: accounts = [], isLoading, refetch: refetchAccounts } = useQuery<CompanyAccount[]>({
|
||||||
|
queryKey: ["company-accounts"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<CompanyAccount[] | { data: CompanyAccount[] }>("/api/v1/company-accounts");
|
||||||
|
const d = res.data;
|
||||||
|
return Array.isArray(d) ? d : (d as { data: CompanyAccount[] }).data ?? [];
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const { data: transfers = [], refetch: refetchTransfers } = useQuery<Transfer[]>({
|
||||||
|
queryKey: ["transfers"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<Transfer[] | { data: Transfer[] }>("/api/v1/transfers");
|
||||||
|
const d = res.data;
|
||||||
|
return Array.isArray(d) ? d : (d as { data: Transfer[] }).data ?? [];
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const addMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.post("/api/v1/company-accounts", {
|
||||||
|
name: addForm.name,
|
||||||
|
type: addForm.type,
|
||||||
|
bankName: addForm.bankName || undefined,
|
||||||
|
accountNumber: addForm.accountNumber || undefined,
|
||||||
|
initialBalance: parseFloat(addForm.initialBalance) || 0,
|
||||||
|
});
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Account added");
|
||||||
|
setShowAdd(false);
|
||||||
|
setAddForm({ name: "", type: "BANK", bankName: "", accountNumber: "", initialBalance: "0" });
|
||||||
|
refetchAccounts();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to add account"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const transferMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
if (!transferAccount) return;
|
||||||
|
await api.post("/api/v1/transfers", {
|
||||||
|
fromAccountId: transferAccount.id,
|
||||||
|
toAccountId: transferForm.toAccountId,
|
||||||
|
amount: parseFloat(transferForm.amount),
|
||||||
|
date: transferForm.date,
|
||||||
|
note: transferForm.note || undefined,
|
||||||
|
});
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Transfer completed");
|
||||||
|
setTransferAccount(null);
|
||||||
|
setTransferForm({ toAccountId: "", amount: "", date: today, note: "" });
|
||||||
|
refetchAccounts();
|
||||||
|
refetchTransfers();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to process transfer"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const toAccounts = accounts.filter((a) => a.id !== transferAccount?.id);
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="flex items-start justify-between">
|
||||||
|
<div>
|
||||||
|
<h1 className="text-2xl font-bold text-gray-900">Accounting</h1>
|
||||||
|
<p className="text-sm text-gray-500">Company cash, bank, and e-wallet accounts</p>
|
||||||
|
</div>
|
||||||
|
<Button size="sm" onClick={() => setShowAdd(true)}>+ Add Account</Button>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<AccountingNav />
|
||||||
|
|
||||||
|
{/* Account Cards */}
|
||||||
|
{isLoading ? (
|
||||||
|
<div className="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-3 gap-4">
|
||||||
|
{Array.from({ length: 3 }).map((_, i) => (
|
||||||
|
<div key={i} className="h-36 animate-pulse bg-gray-100 rounded-xl" />
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
) : accounts.length === 0 ? (
|
||||||
|
<Card>
|
||||||
|
<CardContent className="py-12 text-center text-sm text-gray-400">
|
||||||
|
No company accounts yet. Add your first account to get started.
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
) : (
|
||||||
|
<div className="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-3 gap-4">
|
||||||
|
{accounts.map((acct) => (
|
||||||
|
<Card key={acct.id}>
|
||||||
|
<CardContent className="pt-5">
|
||||||
|
<div className="flex items-start justify-between mb-3">
|
||||||
|
<div>
|
||||||
|
<p className="font-semibold text-gray-900">{acct.name}</p>
|
||||||
|
{acct.bankName && (
|
||||||
|
<p className="text-xs text-gray-400 mt-0.5">{acct.bankName}</p>
|
||||||
|
)}
|
||||||
|
{acct.accountNumber && (
|
||||||
|
<p className="text-xs text-gray-400 font-mono">{acct.accountNumber}</p>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
<Badge variant={TYPE_COLORS[acct.type]}>{acct.type}</Badge>
|
||||||
|
</div>
|
||||||
|
<p className="text-2xl font-bold text-gray-900">{formatCurrency(Number(acct.balance))}</p>
|
||||||
|
<div className="mt-3">
|
||||||
|
<Button
|
||||||
|
size="sm"
|
||||||
|
variant="outline"
|
||||||
|
onClick={() => {
|
||||||
|
setTransferAccount(acct);
|
||||||
|
setTransferForm({ toAccountId: "", amount: "", date: today, note: "" });
|
||||||
|
}}
|
||||||
|
>
|
||||||
|
<ArrowRight className="h-3 w-3 mr-1" /> Transfer
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
|
||||||
|
{/* Recent Transfers */}
|
||||||
|
<Card>
|
||||||
|
<CardHeader>
|
||||||
|
<CardTitle>Recent Transfers</CardTitle>
|
||||||
|
</CardHeader>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
<Table>
|
||||||
|
<TableHead>
|
||||||
|
<TableRow>
|
||||||
|
<Th>Date</Th>
|
||||||
|
<Th>From</Th>
|
||||||
|
<Th></Th>
|
||||||
|
<Th>To</Th>
|
||||||
|
<Th>Amount</Th>
|
||||||
|
<Th>Note</Th>
|
||||||
|
</TableRow>
|
||||||
|
</TableHead>
|
||||||
|
<TableBody>
|
||||||
|
{transfers.length === 0 ? (
|
||||||
|
<EmptyState message="No transfers yet" />
|
||||||
|
) : (
|
||||||
|
transfers.slice(0, 20).map((t) => (
|
||||||
|
<TableRow key={t.id}>
|
||||||
|
<Td className="text-sm">{formatDate(t.date)}</Td>
|
||||||
|
<Td className="font-medium text-sm">{t.fromAccount?.name ?? "—"}</Td>
|
||||||
|
<Td className="text-gray-400"><ArrowRight className="h-4 w-4" /></Td>
|
||||||
|
<Td className="font-medium text-sm">{t.toAccount?.name ?? "—"}</Td>
|
||||||
|
<Td className="font-semibold text-sm">{formatCurrency(Number(t.amount))}</Td>
|
||||||
|
<Td className="text-sm text-gray-500">{t.note ?? "—"}</Td>
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
)}
|
||||||
|
</TableBody>
|
||||||
|
</Table>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
|
||||||
|
{/* Add Account Modal */}
|
||||||
|
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Add Company Account">
|
||||||
|
<form onSubmit={(e) => { e.preventDefault(); addMutation.mutate(); }} className="space-y-4">
|
||||||
|
<Input
|
||||||
|
label="Account Name *"
|
||||||
|
value={addForm.name}
|
||||||
|
onChange={(e) => setAddForm((f) => ({ ...f, name: e.target.value }))}
|
||||||
|
placeholder="e.g. BDO Savings"
|
||||||
|
/>
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">Type *</label>
|
||||||
|
<select
|
||||||
|
className="block w-full rounded-lg border border-gray-300 bg-white px-3 py-2 text-sm focus:border-blue-500 focus:outline-none focus:ring-1 focus:ring-blue-500"
|
||||||
|
value={addForm.type}
|
||||||
|
onChange={(e) => setAddForm((f) => ({ ...f, type: e.target.value as CompanyAccountType }))}
|
||||||
|
>
|
||||||
|
{ACCOUNT_TYPES.map((t) => (
|
||||||
|
<option key={t} value={t}>{t}</option>
|
||||||
|
))}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
<Input
|
||||||
|
label="Bank Name"
|
||||||
|
value={addForm.bankName}
|
||||||
|
onChange={(e) => setAddForm((f) => ({ ...f, bankName: e.target.value }))}
|
||||||
|
placeholder="e.g. BDO"
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Account Number"
|
||||||
|
value={addForm.accountNumber}
|
||||||
|
onChange={(e) => setAddForm((f) => ({ ...f, accountNumber: e.target.value }))}
|
||||||
|
placeholder="e.g. 0012-3456-7890"
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<Input
|
||||||
|
label="Initial Balance (₱)"
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
step="0.01"
|
||||||
|
value={addForm.initialBalance}
|
||||||
|
onChange={(e) => setAddForm((f) => ({ ...f, initialBalance: e.target.value }))}
|
||||||
|
/>
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button type="button" variant="outline" size="sm" onClick={() => setShowAdd(false)}>Cancel</Button>
|
||||||
|
<Button type="submit" size="sm" isLoading={addMutation.isPending} disabled={!addForm.name.trim()}>
|
||||||
|
Add Account
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
</Modal>
|
||||||
|
|
||||||
|
{/* Transfer Modal */}
|
||||||
|
<Modal
|
||||||
|
isOpen={!!transferAccount}
|
||||||
|
onClose={() => setTransferAccount(null)}
|
||||||
|
title={`Transfer from ${transferAccount?.name ?? ""}`}
|
||||||
|
>
|
||||||
|
<form onSubmit={(e) => { e.preventDefault(); transferMutation.mutate(); }} className="space-y-4">
|
||||||
|
<div className="p-3 rounded-lg bg-blue-50 text-sm">
|
||||||
|
<span className="text-blue-700 font-medium">Available balance: </span>
|
||||||
|
<span className="text-blue-900 font-bold">{formatCurrency(Number(transferAccount?.balance ?? 0))}</span>
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">To Account *</label>
|
||||||
|
<select
|
||||||
|
className="block w-full rounded-lg border border-gray-300 bg-white px-3 py-2 text-sm focus:border-blue-500 focus:outline-none focus:ring-1 focus:ring-blue-500"
|
||||||
|
value={transferForm.toAccountId}
|
||||||
|
onChange={(e) => setTransferForm((f) => ({ ...f, toAccountId: e.target.value }))}
|
||||||
|
>
|
||||||
|
<option value="">Select destination account</option>
|
||||||
|
{toAccounts.map((a) => (
|
||||||
|
<option key={a.id} value={a.id}>{a.name} ({a.type})</option>
|
||||||
|
))}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
<Input
|
||||||
|
label="Amount (₱) *"
|
||||||
|
type="number"
|
||||||
|
min="0.01"
|
||||||
|
step="0.01"
|
||||||
|
value={transferForm.amount}
|
||||||
|
onChange={(e) => setTransferForm((f) => ({ ...f, amount: e.target.value }))}
|
||||||
|
placeholder="0.00"
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Date *"
|
||||||
|
type="date"
|
||||||
|
value={transferForm.date}
|
||||||
|
onChange={(e) => setTransferForm((f) => ({ ...f, date: e.target.value }))}
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<Input
|
||||||
|
label="Note"
|
||||||
|
value={transferForm.note}
|
||||||
|
onChange={(e) => setTransferForm((f) => ({ ...f, note: e.target.value }))}
|
||||||
|
placeholder="Optional note"
|
||||||
|
/>
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button type="button" variant="outline" size="sm" onClick={() => setTransferAccount(null)}>Cancel</Button>
|
||||||
|
<Button
|
||||||
|
type="submit"
|
||||||
|
size="sm"
|
||||||
|
isLoading={transferMutation.isPending}
|
||||||
|
disabled={!transferForm.toAccountId || !transferForm.amount || !transferForm.date}
|
||||||
|
>
|
||||||
|
Transfer Funds
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
</Modal>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
210
app/(app)/accounting/expenses/page.tsx
Normal file
210
app/(app)/accounting/expenses/page.tsx
Normal file
@@ -0,0 +1,210 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useState } from "react";
|
||||||
|
import { useQuery, useMutation } from "@tanstack/react-query";
|
||||||
|
import { toast } from "sonner";
|
||||||
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
|
import { Button } from "@/components/ui/Button";
|
||||||
|
import { Input } from "@/components/ui/Input";
|
||||||
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
|
import { Modal } from "@/components/ui/Modal";
|
||||||
|
import { AccountingNav } from "@/components/accounting/AccountingNav";
|
||||||
|
import { formatCurrency } from "@/lib/utils";
|
||||||
|
import api from "@/lib/api";
|
||||||
|
import type { Expense, Account } from "@/types/index";
|
||||||
|
|
||||||
|
function formatDate(iso: string) {
|
||||||
|
return new Date(iso).toLocaleDateString("en-PH", { year: "numeric", month: "short", day: "numeric" });
|
||||||
|
}
|
||||||
|
|
||||||
|
export default function ExpensesPage() {
|
||||||
|
const today = new Date().toISOString().split("T")[0];
|
||||||
|
const firstOfMonth = new Date(new Date().getFullYear(), new Date().getMonth(), 1).toISOString().split("T")[0];
|
||||||
|
|
||||||
|
const [from, setFrom] = useState(firstOfMonth);
|
||||||
|
const [to, setTo] = useState(today);
|
||||||
|
const [showAdd, setShowAdd] = useState(false);
|
||||||
|
const [form, setForm] = useState({ accountId: "", amount: "", date: today, vendor: "", description: "" });
|
||||||
|
|
||||||
|
const { data: expenses = [], isLoading, refetch } = useQuery<Expense[]>({
|
||||||
|
queryKey: ["expenses", from, to],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<Expense[] | { data: Expense[] }>(`/api/v1/expenses?dateFrom=${from}&dateTo=${to}`);
|
||||||
|
const d = res.data;
|
||||||
|
return Array.isArray(d) ? d : (d as { data: Expense[] }).data ?? [];
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const { data: accounts = [] } = useQuery<Account[]>({
|
||||||
|
queryKey: ["accounts-expense"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<Account[] | { data: Account[] }>("/api/v1/accounts?type=EXPENSE");
|
||||||
|
const d = res.data;
|
||||||
|
return (Array.isArray(d) ? d : (d as { data: Account[] }).data ?? []).filter((a) => a.isActive && a.type === "EXPENSE");
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const addMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.post("/api/v1/expenses", {
|
||||||
|
accountId: form.accountId,
|
||||||
|
amount: parseFloat(form.amount),
|
||||||
|
date: form.date,
|
||||||
|
vendor: form.vendor || undefined,
|
||||||
|
description: form.description || undefined,
|
||||||
|
});
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Expense recorded");
|
||||||
|
setShowAdd(false);
|
||||||
|
setForm({ accountId: "", amount: "", date: today, vendor: "", description: "" });
|
||||||
|
refetch();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to record expense"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const totalAmount = expenses.reduce((s, e) => s + Number(e.amount), 0);
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="flex items-start justify-between">
|
||||||
|
<div>
|
||||||
|
<h1 className="text-2xl font-bold text-gray-900">Accounting</h1>
|
||||||
|
<p className="text-sm text-gray-500">Track business expenses</p>
|
||||||
|
</div>
|
||||||
|
<Button size="sm" onClick={() => setShowAdd(true)}>+ Record Expense</Button>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<AccountingNav />
|
||||||
|
|
||||||
|
{/* Date filter */}
|
||||||
|
<div className="flex items-center gap-3 text-sm">
|
||||||
|
<label className="text-gray-500">From</label>
|
||||||
|
<input
|
||||||
|
type="date"
|
||||||
|
value={from}
|
||||||
|
onChange={(e) => setFrom(e.target.value)}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500"
|
||||||
|
/>
|
||||||
|
<label className="text-gray-500">To</label>
|
||||||
|
<input
|
||||||
|
type="date"
|
||||||
|
value={to}
|
||||||
|
onChange={(e) => setTo(e.target.value)}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500"
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<Card>
|
||||||
|
<CardHeader>
|
||||||
|
<CardTitle>
|
||||||
|
Expenses ({expenses.length})
|
||||||
|
{expenses.length > 0 && (
|
||||||
|
<span className="ml-3 text-sm font-normal text-gray-500">
|
||||||
|
Total: <span className="font-semibold text-gray-800">{formatCurrency(totalAmount)}</span>
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
</CardTitle>
|
||||||
|
</CardHeader>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
<Table>
|
||||||
|
<TableHead>
|
||||||
|
<TableRow>
|
||||||
|
<Th>Date</Th>
|
||||||
|
<Th>Vendor</Th>
|
||||||
|
<Th>Account</Th>
|
||||||
|
<Th>Amount</Th>
|
||||||
|
<Th>Description</Th>
|
||||||
|
</TableRow>
|
||||||
|
</TableHead>
|
||||||
|
<TableBody>
|
||||||
|
{isLoading ? (
|
||||||
|
Array.from({ length: 4 }).map((_, i) => (
|
||||||
|
<TableRow key={i}>
|
||||||
|
{[1,2,3,4,5].map((j) => (
|
||||||
|
<Td key={j}><div className="h-4 w-20 animate-pulse bg-gray-100 rounded" /></Td>
|
||||||
|
))}
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
) : expenses.length === 0 ? (
|
||||||
|
<EmptyState message="No expenses in this period" />
|
||||||
|
) : (
|
||||||
|
expenses.map((e) => (
|
||||||
|
<TableRow key={e.id}>
|
||||||
|
<Td className="text-sm">{formatDate(e.date)}</Td>
|
||||||
|
<Td className="font-medium">{e.vendor ?? <span className="text-gray-300">—</span>}</Td>
|
||||||
|
<Td className="text-sm text-gray-600">
|
||||||
|
{e.account ? `${e.account.code} — ${e.account.name}` : "—"}
|
||||||
|
</Td>
|
||||||
|
<Td className="font-semibold text-sm">{formatCurrency(Number(e.amount))}</Td>
|
||||||
|
<Td className="text-sm text-gray-500 max-w-xs truncate">
|
||||||
|
{e.description ?? <span className="text-gray-300">—</span>}
|
||||||
|
</Td>
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
)}
|
||||||
|
</TableBody>
|
||||||
|
</Table>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
|
||||||
|
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Record Expense">
|
||||||
|
<form onSubmit={(e) => { e.preventDefault(); addMutation.mutate(); }} className="space-y-4">
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">Expense Account *</label>
|
||||||
|
<select
|
||||||
|
className="block w-full rounded-lg border border-gray-300 bg-white px-3 py-2 text-sm focus:border-blue-500 focus:outline-none focus:ring-1 focus:ring-blue-500"
|
||||||
|
value={form.accountId}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, accountId: e.target.value }))}
|
||||||
|
>
|
||||||
|
<option value="">Select account</option>
|
||||||
|
{accounts.map((a) => (
|
||||||
|
<option key={a.id} value={a.id}>{a.code} — {a.name}</option>
|
||||||
|
))}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
<Input
|
||||||
|
label="Amount (₱) *"
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
step="0.01"
|
||||||
|
value={form.amount}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, amount: e.target.value }))}
|
||||||
|
placeholder="0.00"
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Date *"
|
||||||
|
type="date"
|
||||||
|
value={form.date}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, date: e.target.value }))}
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<Input
|
||||||
|
label="Vendor"
|
||||||
|
value={form.vendor}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, vendor: e.target.value }))}
|
||||||
|
placeholder="e.g. PLDT, Globe"
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Description"
|
||||||
|
value={form.description}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, description: e.target.value }))}
|
||||||
|
placeholder="What was this expense for?"
|
||||||
|
/>
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button type="button" variant="outline" size="sm" onClick={() => setShowAdd(false)}>Cancel</Button>
|
||||||
|
<Button
|
||||||
|
type="submit"
|
||||||
|
size="sm"
|
||||||
|
isLoading={addMutation.isPending}
|
||||||
|
disabled={!form.accountId || !form.amount || !form.date}
|
||||||
|
>
|
||||||
|
Record Expense
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
</Modal>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
356
app/(app)/accounting/journal-entries/page.tsx
Normal file
356
app/(app)/accounting/journal-entries/page.tsx
Normal file
@@ -0,0 +1,356 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useState } from "react";
|
||||||
|
import { useQuery, useMutation } from "@tanstack/react-query";
|
||||||
|
import { toast } from "sonner";
|
||||||
|
import { Plus, Trash2, Eye } from "lucide-react";
|
||||||
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
|
import { Button } from "@/components/ui/Button";
|
||||||
|
import { Input } from "@/components/ui/Input";
|
||||||
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
|
import { Modal } from "@/components/ui/Modal";
|
||||||
|
import { AccountingNav } from "@/components/accounting/AccountingNav";
|
||||||
|
import { formatCurrency } from "@/lib/utils";
|
||||||
|
import api from "@/lib/api";
|
||||||
|
import type { Account, JournalEntry, JournalEntryLine } from "@/types/index";
|
||||||
|
|
||||||
|
function formatDate(iso: string) {
|
||||||
|
return new Date(iso).toLocaleDateString("en-PH", { year: "numeric", month: "short", day: "numeric" });
|
||||||
|
}
|
||||||
|
|
||||||
|
interface LineFormItem {
|
||||||
|
accountId: string;
|
||||||
|
debit: string;
|
||||||
|
credit: string;
|
||||||
|
memo: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
const emptyLine = (): LineFormItem => ({ accountId: "", debit: "", credit: "", memo: "" });
|
||||||
|
|
||||||
|
export default function JournalEntriesPage() {
|
||||||
|
const [showNew, setShowNew] = useState(false);
|
||||||
|
const [viewEntry, setViewEntry] = useState<JournalEntry | null>(null);
|
||||||
|
const [form, setForm] = useState({ date: "", description: "", reference: "" });
|
||||||
|
const [lines, setLines] = useState<LineFormItem[]>([emptyLine(), emptyLine()]);
|
||||||
|
|
||||||
|
const { data: entries = [], isLoading, refetch } = useQuery<JournalEntry[]>({
|
||||||
|
queryKey: ["journal-entries"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<JournalEntry[] | { data: JournalEntry[] }>("/api/v1/journal-entries");
|
||||||
|
const d = res.data;
|
||||||
|
return Array.isArray(d) ? d : (d as { data: JournalEntry[] }).data ?? [];
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const { data: accounts = [] } = useQuery<Account[]>({
|
||||||
|
queryKey: ["accounts"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<Account[] | { data: Account[] }>("/api/v1/accounts");
|
||||||
|
const d = res.data;
|
||||||
|
return (Array.isArray(d) ? d : (d as { data: Account[] }).data ?? []).filter((a) => a.isActive);
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const totalDebit = lines.reduce((s, l) => s + (parseFloat(l.debit) || 0), 0);
|
||||||
|
const totalCredit = lines.reduce((s, l) => s + (parseFloat(l.credit) || 0), 0);
|
||||||
|
const isBalanced = Math.abs(totalDebit - totalCredit) < 0.01 && totalDebit > 0;
|
||||||
|
|
||||||
|
const createMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
const payload = {
|
||||||
|
date: form.date,
|
||||||
|
description: form.description,
|
||||||
|
reference: form.reference || undefined,
|
||||||
|
lines: lines
|
||||||
|
.filter((l) => l.accountId)
|
||||||
|
.map((l) => ({
|
||||||
|
accountId: l.accountId,
|
||||||
|
debit: parseFloat(l.debit) || 0,
|
||||||
|
credit: parseFloat(l.credit) || 0,
|
||||||
|
memo: l.memo || undefined,
|
||||||
|
})),
|
||||||
|
};
|
||||||
|
await api.post("/api/v1/journal-entries", payload);
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Journal entry created");
|
||||||
|
setShowNew(false);
|
||||||
|
setForm({ date: "", description: "", reference: "" });
|
||||||
|
setLines([emptyLine(), emptyLine()]);
|
||||||
|
refetch();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to create journal entry"),
|
||||||
|
});
|
||||||
|
|
||||||
|
function setLine(i: number, field: keyof LineFormItem, value: string) {
|
||||||
|
setLines((prev) => prev.map((l, idx) => idx === i ? { ...l, [field]: value } : l));
|
||||||
|
}
|
||||||
|
|
||||||
|
function addLine() {
|
||||||
|
setLines((prev) => [...prev, emptyLine()]);
|
||||||
|
}
|
||||||
|
|
||||||
|
function removeLine(i: number) {
|
||||||
|
if (lines.length <= 2) return;
|
||||||
|
setLines((prev) => prev.filter((_, idx) => idx !== i));
|
||||||
|
}
|
||||||
|
|
||||||
|
const entryTotalDebit = (e: JournalEntry) =>
|
||||||
|
e.lines?.reduce((s, l) => s + Number(l.debit), 0) ?? e.totalDebit ?? 0;
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="flex items-start justify-between">
|
||||||
|
<div>
|
||||||
|
<h1 className="text-2xl font-bold text-gray-900">Accounting</h1>
|
||||||
|
<p className="text-sm text-gray-500">Journal entries and double-entry bookkeeping</p>
|
||||||
|
</div>
|
||||||
|
<Button size="sm" onClick={() => setShowNew(true)}>+ New Entry</Button>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<AccountingNav />
|
||||||
|
|
||||||
|
<Card>
|
||||||
|
<CardHeader>
|
||||||
|
<CardTitle>Journal Entries ({entries.length})</CardTitle>
|
||||||
|
</CardHeader>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
<Table>
|
||||||
|
<TableHead>
|
||||||
|
<TableRow>
|
||||||
|
<Th>Date</Th>
|
||||||
|
<Th>Reference</Th>
|
||||||
|
<Th>Description</Th>
|
||||||
|
<Th>Source</Th>
|
||||||
|
<Th>Lines</Th>
|
||||||
|
<Th>Total Debit</Th>
|
||||||
|
<Th></Th>
|
||||||
|
</TableRow>
|
||||||
|
</TableHead>
|
||||||
|
<TableBody>
|
||||||
|
{isLoading ? (
|
||||||
|
Array.from({ length: 4 }).map((_, i) => (
|
||||||
|
<TableRow key={i}>
|
||||||
|
{[1,2,3,4,5,6,7].map((j) => (
|
||||||
|
<Td key={j}><div className="h-4 w-20 animate-pulse bg-gray-100 rounded" /></Td>
|
||||||
|
))}
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
) : entries.length === 0 ? (
|
||||||
|
<EmptyState message="No journal entries yet" />
|
||||||
|
) : (
|
||||||
|
entries.map((e) => (
|
||||||
|
<TableRow key={e.id}>
|
||||||
|
<Td className="text-sm">{formatDate(e.date)}</Td>
|
||||||
|
<Td className="font-mono text-xs text-gray-500">{e.reference ?? "—"}</Td>
|
||||||
|
<Td className="font-medium max-w-xs truncate">{e.description}</Td>
|
||||||
|
<Td className="text-xs text-gray-500">{e.sourceType ?? "MANUAL"}</Td>
|
||||||
|
<Td className="text-sm">{e.lines?.length ?? 0}</Td>
|
||||||
|
<Td className="font-semibold text-sm">{formatCurrency(entryTotalDebit(e))}</Td>
|
||||||
|
<Td>
|
||||||
|
<Button size="sm" variant="ghost" onClick={() => setViewEntry(e)}>
|
||||||
|
<Eye className="h-4 w-4" />
|
||||||
|
</Button>
|
||||||
|
</Td>
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
)}
|
||||||
|
</TableBody>
|
||||||
|
</Table>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
|
||||||
|
{/* New Entry Modal */}
|
||||||
|
<Modal isOpen={showNew} onClose={() => setShowNew(false)} title="New Journal Entry" className="max-w-3xl">
|
||||||
|
<form onSubmit={(e) => { e.preventDefault(); createMutation.mutate(); }} className="space-y-4">
|
||||||
|
<div className="grid grid-cols-3 gap-3">
|
||||||
|
<Input
|
||||||
|
label="Date *"
|
||||||
|
type="date"
|
||||||
|
value={form.date}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, date: e.target.value }))}
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Reference"
|
||||||
|
value={form.reference}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, reference: e.target.value }))}
|
||||||
|
placeholder="e.g. JE-001"
|
||||||
|
/>
|
||||||
|
<div className="col-span-1" />
|
||||||
|
</div>
|
||||||
|
<Input
|
||||||
|
label="Description *"
|
||||||
|
value={form.description}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, description: e.target.value }))}
|
||||||
|
placeholder="Describe this journal entry"
|
||||||
|
/>
|
||||||
|
|
||||||
|
{/* Lines */}
|
||||||
|
<div>
|
||||||
|
<div className="flex items-center justify-between mb-2">
|
||||||
|
<p className="text-sm font-medium text-gray-700">Line Items</p>
|
||||||
|
<Button type="button" size="sm" variant="outline" onClick={addLine}>
|
||||||
|
<Plus className="h-3 w-3 mr-1" /> Add Line
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
<div className="border rounded-lg overflow-hidden">
|
||||||
|
<table className="w-full text-sm">
|
||||||
|
<thead className="bg-gray-50 border-b">
|
||||||
|
<tr>
|
||||||
|
<th className="text-left px-3 py-2 text-xs font-medium text-gray-500 w-1/3">Account</th>
|
||||||
|
<th className="text-left px-3 py-2 text-xs font-medium text-gray-500 w-24">Debit</th>
|
||||||
|
<th className="text-left px-3 py-2 text-xs font-medium text-gray-500 w-24">Credit</th>
|
||||||
|
<th className="text-left px-3 py-2 text-xs font-medium text-gray-500">Memo</th>
|
||||||
|
<th className="w-8" />
|
||||||
|
</tr>
|
||||||
|
</thead>
|
||||||
|
<tbody>
|
||||||
|
{lines.map((line, i) => (
|
||||||
|
<tr key={i} className="border-b last:border-0">
|
||||||
|
<td className="px-3 py-1.5">
|
||||||
|
<select
|
||||||
|
className="w-full rounded border-0 bg-transparent text-sm focus:outline-none focus:ring-1 focus:ring-blue-500 rounded"
|
||||||
|
value={line.accountId}
|
||||||
|
onChange={(e) => setLine(i, "accountId", e.target.value)}
|
||||||
|
>
|
||||||
|
<option value="">Select account</option>
|
||||||
|
{accounts.map((a) => (
|
||||||
|
<option key={a.id} value={a.id}>{a.code} — {a.name}</option>
|
||||||
|
))}
|
||||||
|
</select>
|
||||||
|
</td>
|
||||||
|
<td className="px-3 py-1.5">
|
||||||
|
<input
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
step="0.01"
|
||||||
|
className="w-full rounded border-0 bg-transparent text-sm focus:outline-none focus:ring-1 focus:ring-blue-500 rounded"
|
||||||
|
value={line.debit}
|
||||||
|
onChange={(e) => setLine(i, "debit", e.target.value)}
|
||||||
|
placeholder="0.00"
|
||||||
|
/>
|
||||||
|
</td>
|
||||||
|
<td className="px-3 py-1.5">
|
||||||
|
<input
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
step="0.01"
|
||||||
|
className="w-full rounded border-0 bg-transparent text-sm focus:outline-none focus:ring-1 focus:ring-blue-500 rounded"
|
||||||
|
value={line.credit}
|
||||||
|
onChange={(e) => setLine(i, "credit", e.target.value)}
|
||||||
|
placeholder="0.00"
|
||||||
|
/>
|
||||||
|
</td>
|
||||||
|
<td className="px-3 py-1.5">
|
||||||
|
<input
|
||||||
|
type="text"
|
||||||
|
className="w-full rounded border-0 bg-transparent text-sm focus:outline-none"
|
||||||
|
value={line.memo}
|
||||||
|
onChange={(e) => setLine(i, "memo", e.target.value)}
|
||||||
|
placeholder="Optional"
|
||||||
|
/>
|
||||||
|
</td>
|
||||||
|
<td className="px-2 py-1.5">
|
||||||
|
<button
|
||||||
|
type="button"
|
||||||
|
onClick={() => removeLine(i)}
|
||||||
|
disabled={lines.length <= 2}
|
||||||
|
className="text-gray-300 hover:text-red-400 disabled:opacity-20"
|
||||||
|
>
|
||||||
|
<Trash2 className="h-4 w-4" />
|
||||||
|
</button>
|
||||||
|
</td>
|
||||||
|
</tr>
|
||||||
|
))}
|
||||||
|
</tbody>
|
||||||
|
<tfoot className="bg-gray-50 border-t">
|
||||||
|
<tr>
|
||||||
|
<td className="px-3 py-2 text-xs font-medium text-gray-500">Totals</td>
|
||||||
|
<td className="px-3 py-2 text-sm font-bold text-gray-800">{formatCurrency(totalDebit)}</td>
|
||||||
|
<td className="px-3 py-2 text-sm font-bold text-gray-800">{formatCurrency(totalCredit)}</td>
|
||||||
|
<td colSpan={2} className="px-3 py-2">
|
||||||
|
{totalDebit > 0 && (
|
||||||
|
<span className={`text-xs font-medium ${isBalanced ? "text-green-600" : "text-red-500"}`}>
|
||||||
|
{isBalanced ? "✓ Balanced" : `Off by ${formatCurrency(Math.abs(totalDebit - totalCredit))}`}
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
</td>
|
||||||
|
</tr>
|
||||||
|
</tfoot>
|
||||||
|
</table>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<div className="flex justify-end gap-2 pt-1">
|
||||||
|
<Button type="button" variant="outline" size="sm" onClick={() => setShowNew(false)}>Cancel</Button>
|
||||||
|
<Button
|
||||||
|
type="submit"
|
||||||
|
size="sm"
|
||||||
|
isLoading={createMutation.isPending}
|
||||||
|
disabled={!form.date || !form.description || !isBalanced}
|
||||||
|
>
|
||||||
|
Create Entry
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
</Modal>
|
||||||
|
|
||||||
|
{/* View Entry Modal */}
|
||||||
|
{viewEntry && (
|
||||||
|
<Modal isOpen={!!viewEntry} onClose={() => setViewEntry(null)} title="Journal Entry" className="max-w-2xl">
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="grid grid-cols-3 gap-4 text-sm">
|
||||||
|
<div>
|
||||||
|
<p className="text-gray-500">Date</p>
|
||||||
|
<p className="font-medium">{formatDate(viewEntry.date)}</p>
|
||||||
|
</div>
|
||||||
|
<div>
|
||||||
|
<p className="text-gray-500">Reference</p>
|
||||||
|
<p className="font-medium font-mono">{viewEntry.reference ?? "—"}</p>
|
||||||
|
</div>
|
||||||
|
<div>
|
||||||
|
<p className="text-gray-500">Source</p>
|
||||||
|
<p className="font-medium">{viewEntry.sourceType ?? "MANUAL"}</p>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div>
|
||||||
|
<p className="text-gray-500 text-sm">Description</p>
|
||||||
|
<p className="font-medium">{viewEntry.description}</p>
|
||||||
|
</div>
|
||||||
|
<table className="w-full text-sm border rounded-lg overflow-hidden">
|
||||||
|
<thead className="bg-gray-50">
|
||||||
|
<tr>
|
||||||
|
<th className="text-left px-3 py-2 text-xs font-medium text-gray-500">Account</th>
|
||||||
|
<th className="text-right px-3 py-2 text-xs font-medium text-gray-500">Debit</th>
|
||||||
|
<th className="text-right px-3 py-2 text-xs font-medium text-gray-500">Credit</th>
|
||||||
|
<th className="text-left px-3 py-2 text-xs font-medium text-gray-500">Memo</th>
|
||||||
|
</tr>
|
||||||
|
</thead>
|
||||||
|
<tbody>
|
||||||
|
{viewEntry.lines?.map((l, i) => (
|
||||||
|
<tr key={i} className="border-t">
|
||||||
|
<td className="px-3 py-2">{l.account ? `${l.account.code} — ${l.account.name}` : l.accountId}</td>
|
||||||
|
<td className="px-3 py-2 text-right font-mono">{Number(l.debit) > 0 ? formatCurrency(Number(l.debit)) : "—"}</td>
|
||||||
|
<td className="px-3 py-2 text-right font-mono">{Number(l.credit) > 0 ? formatCurrency(Number(l.credit)) : "—"}</td>
|
||||||
|
<td className="px-3 py-2 text-gray-500">{l.memo ?? ""}</td>
|
||||||
|
</tr>
|
||||||
|
))}
|
||||||
|
</tbody>
|
||||||
|
<tfoot className="bg-gray-50 border-t">
|
||||||
|
<tr>
|
||||||
|
<td className="px-3 py-2 text-xs font-medium text-gray-500">Total</td>
|
||||||
|
<td className="px-3 py-2 text-right font-bold text-sm">{formatCurrency(entryTotalDebit(viewEntry))}</td>
|
||||||
|
<td className="px-3 py-2 text-right font-bold text-sm">{formatCurrency(entryTotalDebit(viewEntry))}</td>
|
||||||
|
<td />
|
||||||
|
</tr>
|
||||||
|
</tfoot>
|
||||||
|
</table>
|
||||||
|
<div className="flex justify-end">
|
||||||
|
<Button variant="outline" size="sm" onClick={() => setViewEntry(null)}>Close</Button>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</Modal>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
231
app/(app)/accounting/page.tsx
Normal file
231
app/(app)/accounting/page.tsx
Normal file
@@ -0,0 +1,231 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useState } from "react";
|
||||||
|
import { useQuery, useMutation } from "@tanstack/react-query";
|
||||||
|
import { toast } from "sonner";
|
||||||
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
|
import { Button } from "@/components/ui/Button";
|
||||||
|
import { Input } from "@/components/ui/Input";
|
||||||
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
|
import { Badge } from "@/components/ui/Badge";
|
||||||
|
import { Modal } from "@/components/ui/Modal";
|
||||||
|
import { AccountingNav } from "@/components/accounting/AccountingNav";
|
||||||
|
import api from "@/lib/api";
|
||||||
|
import type { Account, AccountType } from "@/types/index";
|
||||||
|
|
||||||
|
const ACCOUNT_TYPES: AccountType[] = ["ASSET", "LIABILITY", "EQUITY", "REVENUE", "EXPENSE"];
|
||||||
|
const TYPE_TABS: { key: AccountType | "ALL"; label: string }[] = [
|
||||||
|
{ key: "ALL", label: "All" },
|
||||||
|
{ key: "ASSET", label: "Assets" },
|
||||||
|
{ key: "LIABILITY", label: "Liabilities" },
|
||||||
|
{ key: "EQUITY", label: "Equity" },
|
||||||
|
{ key: "REVENUE", label: "Revenue" },
|
||||||
|
{ key: "EXPENSE", label: "Expenses" },
|
||||||
|
];
|
||||||
|
|
||||||
|
const TYPE_COLORS: Record<AccountType, "default" | "success" | "warning" | "danger" | "muted"> = {
|
||||||
|
ASSET: "success",
|
||||||
|
LIABILITY: "danger",
|
||||||
|
EQUITY: "warning",
|
||||||
|
REVENUE: "default",
|
||||||
|
EXPENSE: "muted",
|
||||||
|
};
|
||||||
|
|
||||||
|
export default function ChartOfAccountsPage() {
|
||||||
|
const [activeType, setActiveType] = useState<AccountType | "ALL">("ALL");
|
||||||
|
const [showAdd, setShowAdd] = useState(false);
|
||||||
|
const [form, setForm] = useState({ code: "", name: "", type: "ASSET" as AccountType });
|
||||||
|
|
||||||
|
const { data, isLoading, refetch } = useQuery<Account[]>({
|
||||||
|
queryKey: ["accounts"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get<Account[] | { data: Account[] }>("/api/v1/accounts");
|
||||||
|
const d = res.data;
|
||||||
|
return Array.isArray(d) ? d : (d as { data: Account[] }).data ?? [];
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const accounts = data ?? [];
|
||||||
|
const hasAccounts = accounts.length > 0;
|
||||||
|
|
||||||
|
const filtered = activeType === "ALL" ? accounts : accounts.filter((a) => a.type === activeType);
|
||||||
|
|
||||||
|
const addMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.post("/api/v1/accounts", form);
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Account created");
|
||||||
|
setShowAdd(false);
|
||||||
|
setForm({ code: "", name: "", type: "ASSET" });
|
||||||
|
refetch();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to create account"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const seedMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.post("/api/v1/accounts/seed", {});
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Default accounts seeded");
|
||||||
|
refetch();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to seed accounts"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const toggleMutation = useMutation({
|
||||||
|
mutationFn: async ({ id, isActive }: { id: string; isActive: boolean }) => {
|
||||||
|
await api.patch(`/api/v1/accounts/${id}`, { isActive: !isActive });
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Account updated");
|
||||||
|
refetch();
|
||||||
|
},
|
||||||
|
onError: () => toast.error("Failed to update account"),
|
||||||
|
});
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="flex items-start justify-between">
|
||||||
|
<div>
|
||||||
|
<h1 className="text-2xl font-bold text-gray-900">Accounting</h1>
|
||||||
|
<p className="text-sm text-gray-500">Chart of accounts, journals, and financial reports</p>
|
||||||
|
</div>
|
||||||
|
<div className="flex gap-2">
|
||||||
|
{!hasAccounts && (
|
||||||
|
<Button variant="outline" size="sm" onClick={() => seedMutation.mutate()} isLoading={seedMutation.isPending}>
|
||||||
|
Seed Defaults
|
||||||
|
</Button>
|
||||||
|
)}
|
||||||
|
<Button size="sm" onClick={() => setShowAdd(true)}>+ Add Account</Button>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<AccountingNav />
|
||||||
|
|
||||||
|
{/* Type filter tabs */}
|
||||||
|
<div className="flex gap-1 flex-wrap">
|
||||||
|
{TYPE_TABS.map(({ key, label }) => (
|
||||||
|
<button
|
||||||
|
key={key}
|
||||||
|
onClick={() => setActiveType(key)}
|
||||||
|
className={`px-3 py-1.5 rounded-lg text-xs font-medium transition-colors ${
|
||||||
|
activeType === key
|
||||||
|
? "bg-blue-100 text-blue-700"
|
||||||
|
: "text-gray-500 hover:bg-gray-100 hover:text-gray-700"
|
||||||
|
}`}
|
||||||
|
>
|
||||||
|
{label}
|
||||||
|
{key !== "ALL" && (
|
||||||
|
<span className="ml-1 text-gray-400">
|
||||||
|
({accounts.filter((a) => a.type === key).length})
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
</button>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<Card>
|
||||||
|
<CardHeader>
|
||||||
|
<CardTitle>
|
||||||
|
{activeType === "ALL" ? "All Accounts" : activeType} ({filtered.length})
|
||||||
|
</CardTitle>
|
||||||
|
</CardHeader>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
<Table>
|
||||||
|
<TableHead>
|
||||||
|
<TableRow>
|
||||||
|
<Th>Code</Th>
|
||||||
|
<Th>Name</Th>
|
||||||
|
<Th>Type</Th>
|
||||||
|
<Th>Status</Th>
|
||||||
|
<Th>Actions</Th>
|
||||||
|
</TableRow>
|
||||||
|
</TableHead>
|
||||||
|
<TableBody>
|
||||||
|
{isLoading ? (
|
||||||
|
Array.from({ length: 4 }).map((_, i) => (
|
||||||
|
<TableRow key={i}>
|
||||||
|
{[1,2,3,4,5].map((j) => (
|
||||||
|
<Td key={j}><div className="h-4 w-20 animate-pulse bg-gray-100 rounded" /></Td>
|
||||||
|
))}
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
) : filtered.length === 0 ? (
|
||||||
|
<EmptyState message={hasAccounts ? "No accounts of this type" : "No accounts yet — seed defaults or add manually"} />
|
||||||
|
) : (
|
||||||
|
filtered.map((a) => (
|
||||||
|
<TableRow key={a.id}>
|
||||||
|
<Td className="font-mono text-sm text-gray-700">{a.code}</Td>
|
||||||
|
<Td className="font-medium">{a.name}</Td>
|
||||||
|
<Td>
|
||||||
|
<Badge variant={TYPE_COLORS[a.type]}>{a.type}</Badge>
|
||||||
|
</Td>
|
||||||
|
<Td>
|
||||||
|
<Badge variant={a.isActive ? "success" : "muted"}>
|
||||||
|
{a.isActive ? "Active" : "Inactive"}
|
||||||
|
</Badge>
|
||||||
|
</Td>
|
||||||
|
<Td>
|
||||||
|
<Button
|
||||||
|
size="sm"
|
||||||
|
variant="ghost"
|
||||||
|
onClick={() => toggleMutation.mutate({ id: a.id, isActive: a.isActive })}
|
||||||
|
>
|
||||||
|
{a.isActive ? "Deactivate" : "Activate"}
|
||||||
|
</Button>
|
||||||
|
</Td>
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
)}
|
||||||
|
</TableBody>
|
||||||
|
</Table>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
|
||||||
|
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Add Account">
|
||||||
|
<form
|
||||||
|
onSubmit={(e) => { e.preventDefault(); addMutation.mutate(); }}
|
||||||
|
className="space-y-4"
|
||||||
|
>
|
||||||
|
<Input
|
||||||
|
label="Account Code"
|
||||||
|
value={form.code}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, code: e.target.value }))}
|
||||||
|
placeholder="e.g. 1001"
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Account Name"
|
||||||
|
value={form.name}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, name: e.target.value }))}
|
||||||
|
placeholder="e.g. Cash on Hand"
|
||||||
|
/>
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">Type</label>
|
||||||
|
<select
|
||||||
|
className="block w-full rounded-lg border border-gray-300 bg-white px-3 py-2 text-sm focus:border-blue-500 focus:outline-none focus:ring-1 focus:ring-blue-500"
|
||||||
|
value={form.type}
|
||||||
|
onChange={(e) => setForm((f) => ({ ...f, type: e.target.value as AccountType }))}
|
||||||
|
>
|
||||||
|
{ACCOUNT_TYPES.map((t) => (
|
||||||
|
<option key={t} value={t}>{t}</option>
|
||||||
|
))}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button type="button" variant="outline" size="sm" onClick={() => setShowAdd(false)}>Cancel</Button>
|
||||||
|
<Button
|
||||||
|
type="submit"
|
||||||
|
size="sm"
|
||||||
|
isLoading={addMutation.isPending}
|
||||||
|
disabled={!form.code.trim() || !form.name.trim()}
|
||||||
|
>
|
||||||
|
Create Account
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
</Modal>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
342
app/(app)/accounting/reports/page.tsx
Normal file
342
app/(app)/accounting/reports/page.tsx
Normal file
@@ -0,0 +1,342 @@
|
|||||||
|
"use client";
|
||||||
|
export const dynamic = "force-dynamic";
|
||||||
|
|
||||||
|
|
||||||
|
|
||||||
|
import { useState } from "react";
|
||||||
|
import { useQuery } from "@tanstack/react-query";
|
||||||
|
import { RefreshCw } from "lucide-react";
|
||||||
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
|
import { Button } from "@/components/ui/Button";
|
||||||
|
import { AccountingNav } from "@/components/accounting/AccountingNav";
|
||||||
|
import { formatCurrency } from "@/lib/utils";
|
||||||
|
import api from "@/lib/api";
|
||||||
|
import type {
|
||||||
|
TrialBalanceLine,
|
||||||
|
ProfitLossReport,
|
||||||
|
BalanceSheetReport,
|
||||||
|
CashFlowReport,
|
||||||
|
} from "@/types/index";
|
||||||
|
|
||||||
|
type ReportTab = "trial-balance" | "profit-loss" | "balance-sheet" | "cash-flow";
|
||||||
|
|
||||||
|
const TABS: { key: ReportTab; label: string }[] = [
|
||||||
|
{ key: "trial-balance", label: "Trial Balance" },
|
||||||
|
{ key: "profit-loss", label: "Profit & Loss" },
|
||||||
|
{ key: "balance-sheet", label: "Balance Sheet" },
|
||||||
|
{ key: "cash-flow", label: "Cash Flow" },
|
||||||
|
];
|
||||||
|
|
||||||
|
// ─── Trial Balance ─────────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
function TrialBalance({ dateFrom, dateTo }: { dateFrom: string; dateTo: string }) {
|
||||||
|
const { data, isLoading } = useQuery<TrialBalanceLine[]>({
|
||||||
|
queryKey: ["report-trial-balance", dateFrom, dateTo],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get(`/api/v1/reports/trial-balance?dateFrom=${dateFrom}&dateTo=${dateTo}`);
|
||||||
|
const d = res.data;
|
||||||
|
if (Array.isArray(d)) return d;
|
||||||
|
return (d as { data?: TrialBalanceLine[] }).data ?? d as TrialBalanceLine[];
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const lines = data ?? [];
|
||||||
|
const totalDebit = lines.reduce((s, l) => s + Number(l.debit), 0);
|
||||||
|
const totalCredit = lines.reduce((s, l) => s + Number(l.credit), 0);
|
||||||
|
|
||||||
|
if (isLoading) return <div className="h-64 animate-pulse bg-gray-100 rounded-xl" />;
|
||||||
|
|
||||||
|
return (
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Trial Balance</CardTitle></CardHeader>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
{lines.length === 0 ? (
|
||||||
|
<p className="text-sm text-gray-400 py-8 text-center">No data for this period</p>
|
||||||
|
) : (
|
||||||
|
<table className="w-full text-sm">
|
||||||
|
<thead className="bg-gray-50 border-b">
|
||||||
|
<tr>
|
||||||
|
<th className="text-left px-4 py-2.5 text-xs font-medium text-gray-500">Code</th>
|
||||||
|
<th className="text-left px-4 py-2.5 text-xs font-medium text-gray-500">Account</th>
|
||||||
|
<th className="text-right px-4 py-2.5 text-xs font-medium text-gray-500">Debit</th>
|
||||||
|
<th className="text-right px-4 py-2.5 text-xs font-medium text-gray-500">Credit</th>
|
||||||
|
<th className="text-right px-4 py-2.5 text-xs font-medium text-gray-500">Balance</th>
|
||||||
|
</tr>
|
||||||
|
</thead>
|
||||||
|
<tbody>
|
||||||
|
{lines.map((l, i) => (
|
||||||
|
<tr key={i} className="border-t hover:bg-gray-50">
|
||||||
|
<td className="px-4 py-2.5 font-mono text-xs text-gray-500">{l.code}</td>
|
||||||
|
<td className="px-4 py-2.5 font-medium">{l.name}</td>
|
||||||
|
<td className="px-4 py-2.5 text-right font-mono text-sm">
|
||||||
|
{Number(l.debit) > 0 ? formatCurrency(Number(l.debit)) : "—"}
|
||||||
|
</td>
|
||||||
|
<td className="px-4 py-2.5 text-right font-mono text-sm">
|
||||||
|
{Number(l.credit) > 0 ? formatCurrency(Number(l.credit)) : "—"}
|
||||||
|
</td>
|
||||||
|
<td className={`px-4 py-2.5 text-right font-mono text-sm font-semibold ${Number(l.balance) < 0 ? "text-red-600" : "text-gray-800"}`}>
|
||||||
|
{formatCurrency(Math.abs(Number(l.balance)))}
|
||||||
|
{Number(l.balance) < 0 && " Cr"}
|
||||||
|
</td>
|
||||||
|
</tr>
|
||||||
|
))}
|
||||||
|
</tbody>
|
||||||
|
<tfoot className="border-t bg-gray-50 font-semibold">
|
||||||
|
<tr>
|
||||||
|
<td colSpan={2} className="px-4 py-2.5 text-sm">Totals</td>
|
||||||
|
<td className="px-4 py-2.5 text-right font-mono text-sm">{formatCurrency(totalDebit)}</td>
|
||||||
|
<td className="px-4 py-2.5 text-right font-mono text-sm">{formatCurrency(totalCredit)}</td>
|
||||||
|
<td className="px-4 py-2.5 text-right">
|
||||||
|
{Math.abs(totalDebit - totalCredit) < 0.01 ? (
|
||||||
|
<span className="text-green-600 text-xs">✓ Balanced</span>
|
||||||
|
) : (
|
||||||
|
<span className="text-red-500 text-xs">Off by {formatCurrency(Math.abs(totalDebit - totalCredit))}</span>
|
||||||
|
)}
|
||||||
|
</td>
|
||||||
|
</tr>
|
||||||
|
</tfoot>
|
||||||
|
</table>
|
||||||
|
)}
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
// ─── P&L ──────────────────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
function ProfitLoss({ dateFrom, dateTo }: { dateFrom: string; dateTo: string }) {
|
||||||
|
const { data, isLoading } = useQuery<ProfitLossReport>({
|
||||||
|
queryKey: ["report-profit-loss", dateFrom, dateTo],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get(`/api/v1/reports/profit-loss?dateFrom=${dateFrom}&dateTo=${dateTo}`);
|
||||||
|
return res.data as ProfitLossReport;
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
if (isLoading) return <div className="h-64 animate-pulse bg-gray-100 rounded-xl" />;
|
||||||
|
if (!data) return <p className="text-sm text-gray-400 py-8 text-center">No data for this period</p>;
|
||||||
|
|
||||||
|
const netIncome = Number(data.netIncome ?? (Number(data.totalRevenue) - Number(data.totalExpenses)));
|
||||||
|
|
||||||
|
return (
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Profit & Loss Statement</CardTitle></CardHeader>
|
||||||
|
<CardContent>
|
||||||
|
<div className="space-y-6">
|
||||||
|
{/* Revenue */}
|
||||||
|
<div>
|
||||||
|
<h3 className="text-sm font-semibold text-gray-700 mb-2 uppercase tracking-wide">Revenue</h3>
|
||||||
|
<div className="space-y-1">
|
||||||
|
{(data.revenue ?? []).map((r, i) => (
|
||||||
|
<div key={i} className="flex justify-between text-sm py-1 border-b border-gray-50">
|
||||||
|
<span className="text-gray-700">{r.name}</span>
|
||||||
|
<span className="font-mono font-medium">{formatCurrency(Number(r.amount))}</span>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
<div className="flex justify-between text-sm font-bold py-1 border-t">
|
||||||
|
<span>Total Revenue</span>
|
||||||
|
<span className="text-green-700">{formatCurrency(Number(data.totalRevenue))}</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Expenses */}
|
||||||
|
<div>
|
||||||
|
<h3 className="text-sm font-semibold text-gray-700 mb-2 uppercase tracking-wide">Expenses</h3>
|
||||||
|
<div className="space-y-1">
|
||||||
|
{(data.expenses ?? []).map((e, i) => (
|
||||||
|
<div key={i} className="flex justify-between text-sm py-1 border-b border-gray-50">
|
||||||
|
<span className="text-gray-700">{e.name}</span>
|
||||||
|
<span className="font-mono font-medium">{formatCurrency(Number(e.amount))}</span>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
<div className="flex justify-between text-sm font-bold py-1 border-t">
|
||||||
|
<span>Total Expenses</span>
|
||||||
|
<span className="text-red-600">{formatCurrency(Number(data.totalExpenses))}</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Net Income */}
|
||||||
|
<div className={`flex justify-between text-base font-bold p-3 rounded-lg ${netIncome >= 0 ? "bg-green-50 text-green-800" : "bg-red-50 text-red-800"}`}>
|
||||||
|
<span>Net Income</span>
|
||||||
|
<span>{formatCurrency(netIncome)}</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
// ─── Balance Sheet ─────────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
function BalanceSheet({ asOf }: { asOf: string }) {
|
||||||
|
const { data, isLoading } = useQuery<BalanceSheetReport>({
|
||||||
|
queryKey: ["report-balance-sheet", asOf],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get(`/api/v1/reports/balance-sheet?asOf=${asOf}`);
|
||||||
|
return res.data as BalanceSheetReport;
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
if (isLoading) return <div className="h-64 animate-pulse bg-gray-100 rounded-xl" />;
|
||||||
|
if (!data) return <p className="text-sm text-gray-400 py-8 text-center">No data</p>;
|
||||||
|
|
||||||
|
function Section({ title, items, total, color }: { title: string; items: Array<{ name: string; amount: number }>; total: number; color: string }) {
|
||||||
|
return (
|
||||||
|
<div>
|
||||||
|
<h3 className="text-sm font-semibold text-gray-700 mb-2 uppercase tracking-wide">{title}</h3>
|
||||||
|
<div className="space-y-1">
|
||||||
|
{items.map((item, i) => (
|
||||||
|
<div key={i} className="flex justify-between text-sm py-1 border-b border-gray-50">
|
||||||
|
<span className="text-gray-700">{item.name}</span>
|
||||||
|
<span className="font-mono">{formatCurrency(Number(item.amount))}</span>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
<div className={`flex justify-between text-sm font-bold py-1 border-t ${color}`}>
|
||||||
|
<span>Total {title}</span>
|
||||||
|
<span>{formatCurrency(Number(total))}</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
return (
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Balance Sheet</CardTitle></CardHeader>
|
||||||
|
<CardContent>
|
||||||
|
<div className="grid grid-cols-1 md:grid-cols-2 gap-8">
|
||||||
|
<Section title="Assets" items={data.assets ?? []} total={data.totalAssets} color="text-blue-700" />
|
||||||
|
<div className="space-y-6">
|
||||||
|
<Section title="Liabilities" items={data.liabilities ?? []} total={data.totalLiabilities} color="text-red-600" />
|
||||||
|
<Section title="Equity" items={data.equity ?? []} total={data.totalEquity} color="text-purple-700" />
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="mt-6 p-3 rounded-lg bg-gray-50 flex justify-between text-sm font-bold">
|
||||||
|
<span>Total Liabilities + Equity</span>
|
||||||
|
<span>{formatCurrency(Number(data.totalLiabilities) + Number(data.totalEquity))}</span>
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
// ─── Cash Flow ─────────────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
function CashFlow({ dateFrom, dateTo }: { dateFrom: string; dateTo: string }) {
|
||||||
|
const { data, isLoading } = useQuery<CashFlowReport>({
|
||||||
|
queryKey: ["report-cash-flow", dateFrom, dateTo],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get(`/api/v1/reports/cash-flow?dateFrom=${dateFrom}&dateTo=${dateTo}`);
|
||||||
|
return res.data as CashFlowReport;
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
if (isLoading) return <div className="h-64 animate-pulse bg-gray-100 rounded-xl" />;
|
||||||
|
if (!data) return <p className="text-sm text-gray-400 py-8 text-center">No data for this period</p>;
|
||||||
|
|
||||||
|
function CashSection({ title, items, net }: { title: string; items: Array<{ name: string; amount: number }>; net: number }) {
|
||||||
|
return (
|
||||||
|
<div>
|
||||||
|
<h3 className="text-sm font-semibold text-gray-700 mb-2 uppercase tracking-wide">{title}</h3>
|
||||||
|
<div className="space-y-1">
|
||||||
|
{items.map((item, i) => (
|
||||||
|
<div key={i} className="flex justify-between text-sm py-1 border-b border-gray-50">
|
||||||
|
<span className="text-gray-700">{item.name}</span>
|
||||||
|
<span className={`font-mono ${Number(item.amount) < 0 ? "text-red-600" : ""}`}>
|
||||||
|
{formatCurrency(Number(item.amount))}
|
||||||
|
</span>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
<div className="flex justify-between text-sm font-bold py-1 border-t">
|
||||||
|
<span>Net {title}</span>
|
||||||
|
<span className={Number(net) >= 0 ? "text-green-700" : "text-red-600"}>
|
||||||
|
{formatCurrency(Number(net))}
|
||||||
|
</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
return (
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Cash Flow Statement</CardTitle></CardHeader>
|
||||||
|
<CardContent>
|
||||||
|
<div className="space-y-6">
|
||||||
|
<CashSection title="Operating Activities" items={data.operating ?? []} net={data.netOperating} />
|
||||||
|
<CashSection title="Investing Activities" items={data.investing ?? []} net={data.netInvesting} />
|
||||||
|
<CashSection title="Financing Activities" items={data.financing ?? []} net={data.netFinancing} />
|
||||||
|
<div className={`flex justify-between text-base font-bold p-3 rounded-lg ${Number(data.netCashFlow) >= 0 ? "bg-green-50 text-green-800" : "bg-red-50 text-red-800"}`}>
|
||||||
|
<span>Net Cash Flow</span>
|
||||||
|
<span>{formatCurrency(Number(data.netCashFlow))}</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
// ─── Main Page ─────────────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
export default function AccountingReportsPage() {
|
||||||
|
const today = new Date().toISOString().split("T")[0];
|
||||||
|
const firstOfYear = `${new Date().getFullYear()}-01-01`;
|
||||||
|
|
||||||
|
const [activeTab, setActiveTab] = useState<ReportTab>("trial-balance");
|
||||||
|
const [dateFrom, setDateFrom] = useState(firstOfYear);
|
||||||
|
const [dateTo, setDateTo] = useState(today);
|
||||||
|
const [asOf, setAsOf] = useState(today);
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="flex items-start justify-between flex-wrap gap-3">
|
||||||
|
<div>
|
||||||
|
<h1 className="text-2xl font-bold text-gray-900">Accounting</h1>
|
||||||
|
<p className="text-sm text-gray-500">Financial statements and accounting reports</p>
|
||||||
|
</div>
|
||||||
|
{activeTab !== "balance-sheet" ? (
|
||||||
|
<div className="flex items-center gap-2 text-sm">
|
||||||
|
<label className="text-gray-500">From</label>
|
||||||
|
<input type="date" value={dateFrom} onChange={(e) => setDateFrom(e.target.value)}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500" />
|
||||||
|
<label className="text-gray-500">To</label>
|
||||||
|
<input type="date" value={dateTo} onChange={(e) => setDateTo(e.target.value)}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500" />
|
||||||
|
</div>
|
||||||
|
) : (
|
||||||
|
<div className="flex items-center gap-2 text-sm">
|
||||||
|
<label className="text-gray-500">As of</label>
|
||||||
|
<input type="date" value={asOf} onChange={(e) => setAsOf(e.target.value)}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500" />
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
|
||||||
|
<AccountingNav />
|
||||||
|
|
||||||
|
{/* Report tabs */}
|
||||||
|
<div className="flex gap-1 flex-wrap">
|
||||||
|
{TABS.map(({ key, label }) => (
|
||||||
|
<button
|
||||||
|
key={key}
|
||||||
|
onClick={() => setActiveTab(key)}
|
||||||
|
className={`px-4 py-2 rounded-lg text-sm font-medium transition-colors ${
|
||||||
|
activeTab === key
|
||||||
|
? "bg-blue-100 text-blue-700"
|
||||||
|
: "text-gray-500 hover:bg-gray-100 hover:text-gray-700"
|
||||||
|
}`}
|
||||||
|
>
|
||||||
|
{label}
|
||||||
|
</button>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{activeTab === "trial-balance" && <TrialBalance dateFrom={dateFrom} dateTo={dateTo} />}
|
||||||
|
{activeTab === "profit-loss" && <ProfitLoss dateFrom={dateFrom} dateTo={dateTo} />}
|
||||||
|
{activeTab === "balance-sheet" && <BalanceSheet asOf={asOf} />}
|
||||||
|
{activeTab === "cash-flow" && <CashFlow dateFrom={dateFrom} dateTo={dateTo} />}
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
@@ -11,13 +11,29 @@ import { formatDateTime } from "@/lib/utils";
|
|||||||
import api from "@/lib/api";
|
import api from "@/lib/api";
|
||||||
import type { AuditLog, PaginatedResponse } from "@/types";
|
import type { AuditLog, PaginatedResponse } from "@/types";
|
||||||
|
|
||||||
|
const ENTITY_TYPES = ["", "CLIENT", "INVOICE", "PAYMENT", "TICKET", "PLAN", "AREA", "USER", "SUBSCRIPTION", "LEAD", "REMITTANCE", "JOURNAL_ENTRY"];
|
||||||
|
const ACTION_TYPES = ["", "CREATE", "UPDATE", "DELETE", "LOGIN", "LOGOUT", "ACTIVATE", "DEACTIVATE", "VOID", "RESOLVE", "CLOSE"];
|
||||||
|
|
||||||
export default function AuditLogPage() {
|
export default function AuditLogPage() {
|
||||||
const [page, setPage] = useState(1);
|
const [page, setPage] = useState(1);
|
||||||
|
const [dateFrom, setDateFrom] = useState("");
|
||||||
|
const [dateTo, setDateTo] = useState("");
|
||||||
|
const [entityType, setEntityType] = useState("");
|
||||||
|
const [actionType, setActionType] = useState("");
|
||||||
|
|
||||||
const { data, isLoading, refetch } = useQuery<PaginatedResponse<AuditLog>>({
|
const { data, isLoading, refetch } = useQuery<PaginatedResponse<AuditLog>>({
|
||||||
queryKey: ["audit-logs", page],
|
queryKey: ["audit-logs", page, dateFrom, dateTo, entityType, actionType],
|
||||||
queryFn: async () => {
|
queryFn: async () => {
|
||||||
const res = await api.get<PaginatedResponse<AuditLog>>(`/api/v1/audit-logs?page=${page}&limit=50`);
|
const params = new URLSearchParams({ page: String(page), limit: "50" });
|
||||||
|
if (dateFrom) params.set("dateFrom", new Date(dateFrom).toISOString());
|
||||||
|
if (dateTo) {
|
||||||
|
const end = new Date(dateTo);
|
||||||
|
end.setHours(23, 59, 59, 999);
|
||||||
|
params.set("dateTo", end.toISOString());
|
||||||
|
}
|
||||||
|
if (entityType) params.set("entityType", entityType);
|
||||||
|
if (actionType) params.set("action", actionType);
|
||||||
|
const res = await api.get<PaginatedResponse<AuditLog>>(`/api/v1/audit-logs?${params}`);
|
||||||
return res.data;
|
return res.data;
|
||||||
},
|
},
|
||||||
});
|
});
|
||||||
@@ -25,6 +41,16 @@ export default function AuditLogPage() {
|
|||||||
const logs = data?.data ?? [];
|
const logs = data?.data ?? [];
|
||||||
const meta = data?.meta;
|
const meta = data?.meta;
|
||||||
|
|
||||||
|
const clearFilters = () => {
|
||||||
|
setDateFrom("");
|
||||||
|
setDateTo("");
|
||||||
|
setEntityType("");
|
||||||
|
setActionType("");
|
||||||
|
setPage(1);
|
||||||
|
};
|
||||||
|
|
||||||
|
const hasFilters = dateFrom || dateTo || entityType || actionType;
|
||||||
|
|
||||||
return (
|
return (
|
||||||
<div className="space-y-4">
|
<div className="space-y-4">
|
||||||
<div className="flex items-center justify-between">
|
<div className="flex items-center justify-between">
|
||||||
@@ -33,13 +59,52 @@ export default function AuditLogPage() {
|
|||||||
<p className="text-sm text-gray-500">Track all system activity</p>
|
<p className="text-sm text-gray-500">Track all system activity</p>
|
||||||
</div>
|
</div>
|
||||||
<Button size="sm" variant="outline" onClick={() => refetch()}>
|
<Button size="sm" variant="outline" onClick={() => refetch()}>
|
||||||
<RefreshCw className="h-4 w-4" />
|
<RefreshCw className="h-4 w-4 mr-1" />
|
||||||
Refresh
|
Refresh
|
||||||
</Button>
|
</Button>
|
||||||
</div>
|
</div>
|
||||||
|
|
||||||
|
{/* Filters */}
|
||||||
<Card>
|
<Card>
|
||||||
<CardHeader><CardTitle>Activity Log</CardTitle></CardHeader>
|
<CardContent className="py-4">
|
||||||
|
<div className="flex flex-wrap gap-3 items-end">
|
||||||
|
<div className="flex flex-col gap-1">
|
||||||
|
<label className="text-xs font-medium text-gray-500">From</label>
|
||||||
|
<input type="date" value={dateFrom}
|
||||||
|
onChange={e => { setDateFrom(e.target.value); setPage(1); }}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500 w-40" />
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-col gap-1">
|
||||||
|
<label className="text-xs font-medium text-gray-500">To</label>
|
||||||
|
<input type="date" value={dateTo}
|
||||||
|
onChange={e => { setDateTo(e.target.value); setPage(1); }}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500 w-40" />
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-col gap-1">
|
||||||
|
<label className="text-xs font-medium text-gray-500">Entity Type</label>
|
||||||
|
<select value={entityType}
|
||||||
|
onChange={e => { setEntityType(e.target.value); setPage(1); }}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
|
||||||
|
{ENTITY_TYPES.map(e => <option key={e} value={e}>{e || "All Entities"}</option>)}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-col gap-1">
|
||||||
|
<label className="text-xs font-medium text-gray-500">Action</label>
|
||||||
|
<select value={actionType}
|
||||||
|
onChange={e => { setActionType(e.target.value); setPage(1); }}
|
||||||
|
className="border rounded-lg px-3 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
|
||||||
|
{ACTION_TYPES.map(a => <option key={a} value={a}>{a || "All Actions"}</option>)}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
{hasFilters && (
|
||||||
|
<Button size="sm" variant="outline" onClick={clearFilters}>Clear Filters</Button>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Activity Log {meta ? `(${meta.total} entries)` : ""}</CardTitle></CardHeader>
|
||||||
<CardContent className="p-0">
|
<CardContent className="p-0">
|
||||||
<Table>
|
<Table>
|
||||||
<TableHead>
|
<TableHead>
|
||||||
@@ -61,7 +126,7 @@ export default function AuditLogPage() {
|
|||||||
</TableRow>
|
</TableRow>
|
||||||
))
|
))
|
||||||
) : logs.length === 0 ? (
|
) : logs.length === 0 ? (
|
||||||
<EmptyState message="No audit logs yet" />
|
<EmptyState message="No audit logs found" />
|
||||||
) : (
|
) : (
|
||||||
logs.map((log) => (
|
logs.map((log) => (
|
||||||
<TableRow key={log.id}>
|
<TableRow key={log.id}>
|
||||||
|
|||||||
@@ -528,7 +528,22 @@ export default function ClientDetailPage() {
|
|||||||
{/* Profile */}
|
{/* Profile */}
|
||||||
{activeTab === "profile" && (
|
{activeTab === "profile" && (
|
||||||
<Card>
|
<Card>
|
||||||
<CardHeader><CardTitle>Client Profile</CardTitle></CardHeader>
|
<CardHeader>
|
||||||
|
<div className="flex items-center justify-between">
|
||||||
|
<CardTitle>Client Profile</CardTitle>
|
||||||
|
<div className="flex gap-2 flex-wrap">
|
||||||
|
<Button size="sm" variant="outline" onClick={() => router.push(`/tickets?clientId=${client.id}`)}>
|
||||||
|
<Ticket className="h-3.5 w-3.5 mr-1" /> View Tickets
|
||||||
|
</Button>
|
||||||
|
<Button size="sm" variant="outline" onClick={() => router.push(`/invoices?clientId=${client.id}`)}>
|
||||||
|
<FileText className="h-3.5 w-3.5 mr-1" /> View Invoices
|
||||||
|
</Button>
|
||||||
|
<Button size="sm" variant="outline" onClick={() => router.push(`/payments?clientId=${client.id}`)}>
|
||||||
|
<CreditCard className="h-3.5 w-3.5 mr-1" /> View Payments
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</CardHeader>
|
||||||
<CardContent>
|
<CardContent>
|
||||||
<dl className="grid grid-cols-1 sm:grid-cols-2 gap-4">
|
<dl className="grid grid-cols-1 sm:grid-cols-2 gap-4">
|
||||||
{[
|
{[
|
||||||
@@ -547,6 +562,15 @@ export default function ClientDetailPage() {
|
|||||||
<dd className="mt-0.5 text-sm text-gray-900">{value}</dd>
|
<dd className="mt-0.5 text-sm text-gray-900">{value}</dd>
|
||||||
</div>
|
</div>
|
||||||
))}
|
))}
|
||||||
|
<div>
|
||||||
|
<dt className="text-xs font-medium text-gray-400 uppercase tracking-wide">Portal Access</dt>
|
||||||
|
<dd className="mt-0.5 text-sm">
|
||||||
|
{client.portalAccessEnabled
|
||||||
|
? <span className="text-green-600 font-medium">Enabled</span>
|
||||||
|
: <span className="text-gray-400">Disabled</span>
|
||||||
|
}
|
||||||
|
</dd>
|
||||||
|
</div>
|
||||||
</dl>
|
</dl>
|
||||||
</CardContent>
|
</CardContent>
|
||||||
</Card>
|
</Card>
|
||||||
|
|||||||
@@ -53,11 +53,21 @@ export default function ClientsPage() {
|
|||||||
queryFn: async () => { const r = await api.get<Area[]>("/api/v1/areas"); return r.data; },
|
queryFn: async () => { const r = await api.get<Area[]>("/api/v1/areas"); return r.data; },
|
||||||
});
|
});
|
||||||
|
|
||||||
const { data: plans = [] } = useQuery<Plan[]>({
|
// Fetch only active plans, filter client-side by billing type
|
||||||
queryKey: ["plans"],
|
const { data: allActivePlans = [] } = useQuery<(Plan & { type: string; isActive: boolean })[]>({
|
||||||
queryFn: async () => { const r = await api.get<Plan[]>("/api/v1/plans"); return Array.isArray(r.data) ? r.data : (r.data as any).data ?? []; },
|
queryKey: ["plans", "active"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const r = await api.get("/api/v1/plans?isActive=true");
|
||||||
|
const raw = Array.isArray(r.data) ? r.data : (r.data as any).data ?? [];
|
||||||
|
return raw;
|
||||||
|
},
|
||||||
});
|
});
|
||||||
|
|
||||||
|
// Filter plans by selected billing type
|
||||||
|
const filteredPlans = allActivePlans.filter(p =>
|
||||||
|
!form.billingType || p.type === form.billingType
|
||||||
|
);
|
||||||
|
|
||||||
const createClient = useMutation({
|
const createClient = useMutation({
|
||||||
mutationFn: async () => {
|
mutationFn: async () => {
|
||||||
const res = await api.post("/api/v1/clients", {
|
const res = await api.post("/api/v1/clients", {
|
||||||
@@ -186,10 +196,11 @@ export default function ClientsPage() {
|
|||||||
<div className="flex flex-col gap-1.5">
|
<div className="flex flex-col gap-1.5">
|
||||||
<label className="text-sm font-medium text-gray-700">Billing Type</label>
|
<label className="text-sm font-medium text-gray-700">Billing Type</label>
|
||||||
<select className="border rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500"
|
<select className="border rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500"
|
||||||
value={form.billingType} onChange={e => setForm(f => ({ ...f, billingType: e.target.value }))}>
|
value={form.billingType} onChange={e => setForm(f => ({ ...f, billingType: e.target.value, planId: "" }))}>
|
||||||
<option value="POSTPAID">Postpaid</option>
|
<option value="POSTPAID">Postpaid</option>
|
||||||
<option value="PREPAID">Prepaid</option>
|
<option value="PREPAID">Prepaid</option>
|
||||||
</select>
|
</select>
|
||||||
|
<p className="text-xs text-gray-400">Plan list filters to match this type</p>
|
||||||
</div>
|
</div>
|
||||||
</div>
|
</div>
|
||||||
<div className="flex flex-col gap-1.5">
|
<div className="flex flex-col gap-1.5">
|
||||||
@@ -197,8 +208,11 @@ export default function ClientsPage() {
|
|||||||
<select className="border rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500"
|
<select className="border rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-500"
|
||||||
value={form.planId} onChange={e => setForm(f => ({ ...f, planId: e.target.value }))}>
|
value={form.planId} onChange={e => setForm(f => ({ ...f, planId: e.target.value }))}>
|
||||||
<option value="">— Select plan —</option>
|
<option value="">— Select plan —</option>
|
||||||
{plans.map(p => <option key={p.id} value={p.id}>{p.name} — ₱{Number(p.monthlyPrice).toLocaleString()}/mo</option>)}
|
{filteredPlans.map(p => <option key={p.id} value={p.id}>{p.name} — ₱{Number(p.monthlyPrice).toLocaleString()}/mo</option>)}
|
||||||
</select>
|
</select>
|
||||||
|
{filteredPlans.length === 0 && form.billingType && (
|
||||||
|
<p className="text-xs text-amber-600">No active {form.billingType.toLowerCase()} plans available.</p>
|
||||||
|
)}
|
||||||
</div>
|
</div>
|
||||||
<div className="flex justify-end gap-2 pt-2">
|
<div className="flex justify-end gap-2 pt-2">
|
||||||
<Button variant="outline" onClick={() => setShowAdd(false)}>Cancel</Button>
|
<Button variant="outline" onClick={() => setShowAdd(false)}>Cancel</Button>
|
||||||
|
|||||||
@@ -1,4 +1,7 @@
|
|||||||
"use client";
|
"use client";
|
||||||
|
export const dynamic = "force-dynamic";
|
||||||
|
|
||||||
|
|
||||||
|
|
||||||
import { useQuery, useMutation } from "@tanstack/react-query";
|
import { useQuery, useMutation } from "@tanstack/react-query";
|
||||||
import { useRouter } from "next/navigation";
|
import { useRouter } from "next/navigation";
|
||||||
|
|||||||
@@ -154,7 +154,20 @@ export default function InvoicesPage() {
|
|||||||
</Card>
|
</Card>
|
||||||
|
|
||||||
{/* Invoice Detail Modal */}
|
{/* Invoice Detail Modal */}
|
||||||
<Modal isOpen={!!selected} onClose={() => setSelected(null)} title={`Invoice ${selected?.invoiceNumber ?? ""}`} className="max-w-lg">
|
<Modal
|
||||||
|
isOpen={!!selected}
|
||||||
|
onClose={() => setSelected(null)}
|
||||||
|
title={`Invoice ${selected?.invoiceNumber ?? ""}`}
|
||||||
|
className="max-w-lg"
|
||||||
|
footer={selected ? (
|
||||||
|
<>
|
||||||
|
{selected.status !== "VOID" && selected.status !== "PAID" && (
|
||||||
|
<Button variant="danger" size="sm" onClick={() => voidInvoice.mutate(selected.id)} isLoading={voidInvoice.isPending}>Void Invoice</Button>
|
||||||
|
)}
|
||||||
|
<Button variant="outline" size="sm" onClick={() => setSelected(null)}>Close</Button>
|
||||||
|
</>
|
||||||
|
) : undefined}
|
||||||
|
>
|
||||||
{selected && (
|
{selected && (
|
||||||
<div className="space-y-4">
|
<div className="space-y-4">
|
||||||
<div className="bg-gray-50 rounded-lg p-4 space-y-2 text-sm">
|
<div className="bg-gray-50 rounded-lg p-4 space-y-2 text-sm">
|
||||||
@@ -196,13 +209,6 @@ export default function InvoicesPage() {
|
|||||||
disabled={!payForm.amount}>Record Payment</Button>
|
disabled={!payForm.amount}>Record Payment</Button>
|
||||||
</div>
|
</div>
|
||||||
)}
|
)}
|
||||||
|
|
||||||
<div className="flex justify-between pt-1">
|
|
||||||
{selected.status !== "VOID" && selected.status !== "PAID" && (
|
|
||||||
<Button variant="danger" size="sm" onClick={() => voidInvoice.mutate(selected.id)} isLoading={voidInvoice.isPending}>Void Invoice</Button>
|
|
||||||
)}
|
|
||||||
<Button variant="outline" size="sm" onClick={() => setSelected(null)} className="ml-auto">Close</Button>
|
|
||||||
</div>
|
|
||||||
</div>
|
</div>
|
||||||
)}
|
)}
|
||||||
</Modal>
|
</Modal>
|
||||||
|
|||||||
@@ -1,4 +1,5 @@
|
|||||||
'use client';
|
'use client';
|
||||||
|
export const dynamic = 'force-dynamic';
|
||||||
|
|
||||||
import { useEffect, useState } from 'react';
|
import { useEffect, useState } from 'react';
|
||||||
import { useRouter } from 'next/navigation';
|
import { useRouter } from 'next/navigation';
|
||||||
|
|||||||
@@ -2,7 +2,8 @@
|
|||||||
|
|
||||||
import { useState } from "react";
|
import { useState } from "react";
|
||||||
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
||||||
import { UserPlus, RefreshCw } from "lucide-react";
|
import { useRouter } from "next/navigation";
|
||||||
|
import { UserPlus, RefreshCw, ArrowRightCircle } from "lucide-react";
|
||||||
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
import { Badge } from "@/components/ui/Badge";
|
import { Badge } from "@/components/ui/Badge";
|
||||||
@@ -22,11 +23,14 @@ const statusOptions = ["NEW", "CONTACTED", "INTERESTED", "CONVERTED", "LOST"];
|
|||||||
|
|
||||||
export default function LeadsPage() {
|
export default function LeadsPage() {
|
||||||
const qc = useQueryClient();
|
const qc = useQueryClient();
|
||||||
|
const router = useRouter();
|
||||||
const [search, setSearch] = useState("");
|
const [search, setSearch] = useState("");
|
||||||
const [selected, setSelected] = useState<Lead | null>(null);
|
const [selected, setSelected] = useState<Lead | null>(null);
|
||||||
const [showAdd, setShowAdd] = useState(false);
|
const [showAdd, setShowAdd] = useState(false);
|
||||||
|
const [showConvert, setShowConvert] = useState(false);
|
||||||
const [form, setForm] = useState({ firstName: "", lastName: "", phone: "", email: "", address: "", notes: "", source: "" });
|
const [form, setForm] = useState({ firstName: "", lastName: "", phone: "", email: "", address: "", notes: "", source: "" });
|
||||||
const [statusUpdate, setStatusUpdate] = useState("");
|
const [statusUpdate, setStatusUpdate] = useState("");
|
||||||
|
const [convertForm, setConvertForm] = useState({ firstName: "", lastName: "", phone: "", email: "", address: "", areaId: "", planId: "", billingType: "POSTPAID" });
|
||||||
|
|
||||||
const { data = [], isLoading, refetch } = useQuery<Lead[]>({
|
const { data = [], isLoading, refetch } = useQuery<Lead[]>({
|
||||||
queryKey: ["leads", search],
|
queryKey: ["leads", search],
|
||||||
@@ -79,6 +83,41 @@ export default function LeadsPage() {
|
|||||||
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to delete"),
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to delete"),
|
||||||
});
|
});
|
||||||
|
|
||||||
|
const convertToClient = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
const res = await api.post("/api/v1/clients", {
|
||||||
|
firstName: convertForm.firstName, lastName: convertForm.lastName,
|
||||||
|
phone: convertForm.phone, email: convertForm.email || undefined,
|
||||||
|
address: convertForm.address || undefined,
|
||||||
|
areaId: convertForm.areaId || undefined,
|
||||||
|
planId: convertForm.planId || undefined,
|
||||||
|
});
|
||||||
|
// Mark lead as converted
|
||||||
|
if (selected) await api.patch(`/api/v1/leads/${selected.id}`, { status: "CONVERTED" });
|
||||||
|
return res.data;
|
||||||
|
},
|
||||||
|
onSuccess: (data: any) => {
|
||||||
|
toast.success("Lead converted to client!");
|
||||||
|
setShowConvert(false);
|
||||||
|
setSelected(null);
|
||||||
|
qc.invalidateQueries({ queryKey: ["leads"] });
|
||||||
|
if (data?.id) router.push(`/clients/${data.id}`);
|
||||||
|
},
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to convert lead"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const { data: areas = [] } = useQuery<{ id: string; name: string }[]>({
|
||||||
|
queryKey: ["areas"],
|
||||||
|
queryFn: async () => { const r = await api.get("/api/v1/areas"); return Array.isArray(r.data) ? r.data : (r.data as any).data ?? []; },
|
||||||
|
});
|
||||||
|
|
||||||
|
const { data: activePlans = [] } = useQuery<{ id: string; name: string; monthlyPrice: number; type: string }[]>({
|
||||||
|
queryKey: ["plans", "active"],
|
||||||
|
queryFn: async () => { const r = await api.get("/api/v1/plans?isActive=true"); return Array.isArray(r.data) ? r.data : (r.data as any).data ?? []; },
|
||||||
|
});
|
||||||
|
|
||||||
|
const filteredConvertPlans = activePlans.filter(p => !convertForm.billingType || p.type === convertForm.billingType);
|
||||||
|
|
||||||
const counts = statusOptions.reduce((acc, s) => ({ ...acc, [s]: data.filter(l => l.status === s).length }), {} as Record<string, number>);
|
const counts = statusOptions.reduce((acc, s) => ({ ...acc, [s]: data.filter(l => l.status === s).length }), {} as Record<string, number>);
|
||||||
|
|
||||||
return (
|
return (
|
||||||
@@ -176,14 +215,72 @@ export default function LeadsPage() {
|
|||||||
)}
|
)}
|
||||||
</div>
|
</div>
|
||||||
|
|
||||||
<div className="flex justify-between pt-1">
|
<div className="flex justify-between pt-1 flex-wrap gap-2">
|
||||||
<Button variant="danger" size="sm" onClick={() => { if (confirm("Delete this lead?")) deleteLead.mutate(selected.id); }} isLoading={deleteLead.isPending}>Delete</Button>
|
<div className="flex gap-2">
|
||||||
|
<Button variant="danger" size="sm" onClick={() => { if (confirm("Delete this lead?")) deleteLead.mutate(selected.id); }} isLoading={deleteLead.isPending}>Delete</Button>
|
||||||
|
{selected.status !== "CONVERTED" && (
|
||||||
|
<Button size="sm" variant="outline" onClick={() => {
|
||||||
|
setConvertForm({
|
||||||
|
firstName: selected.firstName, lastName: selected.lastName,
|
||||||
|
phone: selected.phone, email: selected.email ?? "",
|
||||||
|
address: selected.address ?? "", areaId: "", planId: "", billingType: "POSTPAID",
|
||||||
|
});
|
||||||
|
setShowConvert(true);
|
||||||
|
}}>
|
||||||
|
<ArrowRightCircle size={14} className="mr-1" /> Convert to Client
|
||||||
|
</Button>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
<Button variant="outline" size="sm" onClick={() => setSelected(null)}>Close</Button>
|
<Button variant="outline" size="sm" onClick={() => setSelected(null)}>Close</Button>
|
||||||
</div>
|
</div>
|
||||||
</div>
|
</div>
|
||||||
)}
|
)}
|
||||||
</Modal>
|
</Modal>
|
||||||
|
|
||||||
|
{/* Convert to Client Modal */}
|
||||||
|
<Modal isOpen={showConvert} onClose={() => setShowConvert(false)} title="Convert Lead to Client" className="max-w-xl">
|
||||||
|
<div className="space-y-4">
|
||||||
|
<p className="text-sm text-gray-500">Pre-filled from lead data. Complete missing info to create the client.</p>
|
||||||
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
<Input label="First Name *" value={convertForm.firstName} onChange={e => setConvertForm(f => ({ ...f, firstName: e.target.value }))} />
|
||||||
|
<Input label="Last Name *" value={convertForm.lastName} onChange={e => setConvertForm(f => ({ ...f, lastName: e.target.value }))} />
|
||||||
|
</div>
|
||||||
|
<Input label="Phone *" value={convertForm.phone} onChange={e => setConvertForm(f => ({ ...f, phone: e.target.value }))} />
|
||||||
|
<Input label="Email" type="email" value={convertForm.email} onChange={e => setConvertForm(f => ({ ...f, email: e.target.value }))} />
|
||||||
|
<Input label="Address" value={convertForm.address} onChange={e => setConvertForm(f => ({ ...f, address: e.target.value }))} />
|
||||||
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">Area</label>
|
||||||
|
<select className="border rounded-lg px-3 py-2 text-sm" value={convertForm.areaId} onChange={e => setConvertForm(f => ({ ...f, areaId: e.target.value }))}>
|
||||||
|
<option value="">— Select area —</option>
|
||||||
|
{areas.map(a => <option key={a.id} value={a.id}>{a.name}</option>)}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">Billing Type</label>
|
||||||
|
<select className="border rounded-lg px-3 py-2 text-sm" value={convertForm.billingType} onChange={e => setConvertForm(f => ({ ...f, billingType: e.target.value, planId: "" }))}>
|
||||||
|
<option value="POSTPAID">Postpaid</option>
|
||||||
|
<option value="PREPAID">Prepaid</option>
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-col gap-1.5">
|
||||||
|
<label className="text-sm font-medium text-gray-700">Plan *</label>
|
||||||
|
<select className="border rounded-lg px-3 py-2 text-sm" value={convertForm.planId} onChange={e => setConvertForm(f => ({ ...f, planId: e.target.value }))}>
|
||||||
|
<option value="">— Select plan —</option>
|
||||||
|
{filteredConvertPlans.map(p => <option key={p.id} value={p.id}>{p.name} — ₱{Number(p.monthlyPrice).toLocaleString()}/mo</option>)}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button variant="outline" onClick={() => setShowConvert(false)}>Cancel</Button>
|
||||||
|
<Button onClick={() => convertToClient.mutate()} isLoading={convertToClient.isPending}
|
||||||
|
disabled={!convertForm.firstName || !convertForm.lastName || !convertForm.phone || !convertForm.planId}>
|
||||||
|
<ArrowRightCircle size={14} className="mr-1" /> Create Client
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</Modal>
|
||||||
|
|
||||||
{/* Add Lead Modal */}
|
{/* Add Lead Modal */}
|
||||||
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Add New Lead">
|
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Add New Lead">
|
||||||
<div className="space-y-4">
|
<div className="space-y-4">
|
||||||
|
|||||||
@@ -41,6 +41,7 @@ const emptyForm = {
|
|||||||
export default function PlansPage() {
|
export default function PlansPage() {
|
||||||
const qc = useQueryClient();
|
const qc = useQueryClient();
|
||||||
const [search, setSearch] = useState("");
|
const [search, setSearch] = useState("");
|
||||||
|
const [activeTab, setActiveTab] = useState<"active" | "archived">("active");
|
||||||
|
|
||||||
// Modals
|
// Modals
|
||||||
const [showCreate, setShowCreate] = useState(false);
|
const [showCreate, setShowCreate] = useState(false);
|
||||||
@@ -51,11 +52,12 @@ export default function PlansPage() {
|
|||||||
const [createForm, setCreateForm] = useState({ ...emptyForm });
|
const [createForm, setCreateForm] = useState({ ...emptyForm });
|
||||||
const [editForm, setEditForm] = useState({ ...emptyForm });
|
const [editForm, setEditForm] = useState({ ...emptyForm });
|
||||||
|
|
||||||
// GET /plans returns a plain array (not paginated)
|
// GET /plans with isActive filter
|
||||||
const { data: allPlans = [], isLoading, isError, refetch } = useQuery<Plan[]>({
|
const { data: allPlans = [], isLoading, isError, refetch } = useQuery<Plan[]>({
|
||||||
queryKey: ["plans"],
|
queryKey: ["plans", activeTab],
|
||||||
queryFn: async () => {
|
queryFn: async () => {
|
||||||
const res = await api.get<Plan[] | { data: Plan[] }>("/api/v1/plans");
|
const isActive = activeTab === "active";
|
||||||
|
const res = await api.get<Plan[] | { data: Plan[] }>(`/api/v1/plans?isActive=${isActive}`);
|
||||||
return Array.isArray(res.data) ? res.data : (res.data as any).data ?? [];
|
return Array.isArray(res.data) ? res.data : (res.data as any).data ?? [];
|
||||||
},
|
},
|
||||||
});
|
});
|
||||||
@@ -149,6 +151,24 @@ export default function PlansPage() {
|
|||||||
</div>
|
</div>
|
||||||
</div>
|
</div>
|
||||||
|
|
||||||
|
{/* Active / Archived tabs */}
|
||||||
|
<div className="flex gap-1 bg-gray-100 rounded-lg p-1 w-fit">
|
||||||
|
<button
|
||||||
|
onClick={() => { setActiveTab("active"); setSearch(""); }}
|
||||||
|
className={`px-4 py-1.5 rounded-md text-sm font-medium transition-colors ${activeTab === "active" ? "bg-white text-gray-900 shadow-sm" : "text-gray-500 hover:text-gray-700"}`}
|
||||||
|
data-testid="tab-active"
|
||||||
|
>
|
||||||
|
Active
|
||||||
|
</button>
|
||||||
|
<button
|
||||||
|
onClick={() => { setActiveTab("archived"); setSearch(""); }}
|
||||||
|
className={`px-4 py-1.5 rounded-md text-sm font-medium transition-colors ${activeTab === "archived" ? "bg-white text-gray-900 shadow-sm" : "text-gray-500 hover:text-gray-700"}`}
|
||||||
|
data-testid="tab-archived"
|
||||||
|
>
|
||||||
|
Archived
|
||||||
|
</button>
|
||||||
|
</div>
|
||||||
|
|
||||||
<Card>
|
<Card>
|
||||||
<CardHeader>
|
<CardHeader>
|
||||||
<input
|
<input
|
||||||
|
|||||||
147
app/(app)/profile/page.tsx
Normal file
147
app/(app)/profile/page.tsx
Normal file
@@ -0,0 +1,147 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useState } from "react";
|
||||||
|
import { useMutation } from "@tanstack/react-query";
|
||||||
|
import { useAuthStore } from "@/lib/auth-store";
|
||||||
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
|
import { Button } from "@/components/ui/Button";
|
||||||
|
import { Input } from "@/components/ui/Input";
|
||||||
|
import { User, Lock } from "lucide-react";
|
||||||
|
import api from "@/lib/api";
|
||||||
|
import { toast } from "sonner";
|
||||||
|
|
||||||
|
export default function ProfilePage() {
|
||||||
|
const user = useAuthStore((s) => s.user);
|
||||||
|
|
||||||
|
const [infoForm, setInfoForm] = useState({
|
||||||
|
firstName: (user as any)?.firstName ?? user?.name?.split(" ")[0] ?? "",
|
||||||
|
lastName: (user as any)?.lastName ?? user?.name?.split(" ").slice(1).join(" ") ?? "",
|
||||||
|
email: user?.email ?? "",
|
||||||
|
});
|
||||||
|
|
||||||
|
const [pwForm, setPwForm] = useState({
|
||||||
|
currentPassword: "",
|
||||||
|
newPassword: "",
|
||||||
|
confirmPassword: "",
|
||||||
|
});
|
||||||
|
|
||||||
|
const updateInfo = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.patch("/api/v1/auth/me", {
|
||||||
|
firstName: infoForm.firstName,
|
||||||
|
lastName: infoForm.lastName,
|
||||||
|
email: infoForm.email,
|
||||||
|
});
|
||||||
|
},
|
||||||
|
onSuccess: () => toast.success("Profile updated!"),
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to update profile"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const resetPassword = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
if (pwForm.newPassword !== pwForm.confirmPassword) {
|
||||||
|
throw new Error("Passwords do not match");
|
||||||
|
}
|
||||||
|
await api.post("/api/v1/auth/change-password", {
|
||||||
|
currentPassword: pwForm.currentPassword,
|
||||||
|
newPassword: pwForm.newPassword,
|
||||||
|
});
|
||||||
|
},
|
||||||
|
onSuccess: () => {
|
||||||
|
toast.success("Password changed successfully!");
|
||||||
|
setPwForm({ currentPassword: "", newPassword: "", confirmPassword: "" });
|
||||||
|
},
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? e.message ?? "Failed to change password"),
|
||||||
|
});
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-6 max-w-xl">
|
||||||
|
<div>
|
||||||
|
<h1 className="text-2xl font-bold text-gray-900">My Profile</h1>
|
||||||
|
<p className="text-sm text-gray-500 mt-1">Manage your account settings</p>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Profile Info */}
|
||||||
|
<Card>
|
||||||
|
<CardHeader>
|
||||||
|
<CardTitle className="flex items-center gap-2">
|
||||||
|
<User className="h-4 w-4 text-blue-600" />
|
||||||
|
Personal Information
|
||||||
|
</CardTitle>
|
||||||
|
</CardHeader>
|
||||||
|
<CardContent className="space-y-4">
|
||||||
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
<Input
|
||||||
|
label="First Name"
|
||||||
|
value={infoForm.firstName}
|
||||||
|
onChange={e => setInfoForm(f => ({ ...f, firstName: e.target.value }))}
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Last Name"
|
||||||
|
value={infoForm.lastName}
|
||||||
|
onChange={e => setInfoForm(f => ({ ...f, lastName: e.target.value }))}
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<Input
|
||||||
|
label="Email"
|
||||||
|
type="email"
|
||||||
|
value={infoForm.email}
|
||||||
|
onChange={e => setInfoForm(f => ({ ...f, email: e.target.value }))}
|
||||||
|
/>
|
||||||
|
<div className="flex justify-end">
|
||||||
|
<Button
|
||||||
|
onClick={() => updateInfo.mutate()}
|
||||||
|
isLoading={updateInfo.isPending}
|
||||||
|
disabled={!infoForm.firstName || !infoForm.email}
|
||||||
|
>
|
||||||
|
Save Changes
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
|
||||||
|
{/* Change Password */}
|
||||||
|
<Card>
|
||||||
|
<CardHeader>
|
||||||
|
<CardTitle className="flex items-center gap-2">
|
||||||
|
<Lock className="h-4 w-4 text-blue-600" />
|
||||||
|
Change Password
|
||||||
|
</CardTitle>
|
||||||
|
</CardHeader>
|
||||||
|
<CardContent className="space-y-4">
|
||||||
|
<Input
|
||||||
|
label="Current Password"
|
||||||
|
type="password"
|
||||||
|
value={pwForm.currentPassword}
|
||||||
|
onChange={e => setPwForm(f => ({ ...f, currentPassword: e.target.value }))}
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="New Password"
|
||||||
|
type="password"
|
||||||
|
value={pwForm.newPassword}
|
||||||
|
onChange={e => setPwForm(f => ({ ...f, newPassword: e.target.value }))}
|
||||||
|
hint="Minimum 8 characters"
|
||||||
|
/>
|
||||||
|
<Input
|
||||||
|
label="Confirm New Password"
|
||||||
|
type="password"
|
||||||
|
value={pwForm.confirmPassword}
|
||||||
|
onChange={e => setPwForm(f => ({ ...f, confirmPassword: e.target.value }))}
|
||||||
|
/>
|
||||||
|
{pwForm.newPassword && pwForm.confirmPassword && pwForm.newPassword !== pwForm.confirmPassword && (
|
||||||
|
<p className="text-xs text-red-500">Passwords do not match</p>
|
||||||
|
)}
|
||||||
|
<div className="flex justify-end">
|
||||||
|
<Button
|
||||||
|
onClick={() => resetPassword.mutate()}
|
||||||
|
isLoading={resetPassword.isPending}
|
||||||
|
disabled={!pwForm.currentPassword || !pwForm.newPassword || !pwForm.confirmPassword || pwForm.newPassword !== pwForm.confirmPassword}
|
||||||
|
>
|
||||||
|
Change Password
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
@@ -1,17 +1,21 @@
|
|||||||
"use client";
|
"use client";
|
||||||
|
export const dynamic = "force-dynamic";
|
||||||
|
|
||||||
import { useState } from "react";
|
import { useState } from "react";
|
||||||
import { useQuery } from "@tanstack/react-query";
|
import { useQuery } from "@tanstack/react-query";
|
||||||
import { BarChart, Bar, XAxis, YAxis, Tooltip, ResponsiveContainer, PieChart, Pie, Cell, Legend, LineChart, Line, CartesianGrid } from "recharts";
|
import { BarChart, Bar, XAxis, YAxis, Tooltip, ResponsiveContainer, PieChart, Pie, Cell, LineChart, Line, CartesianGrid, Legend } from "recharts";
|
||||||
import { RefreshCw, TrendingUp, Users, AlertTriangle, DollarSign } from "lucide-react";
|
import { RefreshCw, TrendingUp, Users, AlertTriangle, DollarSign, Download } from "lucide-react";
|
||||||
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/Card";
|
||||||
import { Button } from "@/components/ui/Button";
|
import { Button } from "@/components/ui/Button";
|
||||||
import { Badge } from "@/components/ui/Badge";
|
import { Badge } from "@/components/ui/Badge";
|
||||||
import { formatCurrency } from "@/lib/utils";
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
|
import { formatCurrency, formatDate } from "@/lib/utils";
|
||||||
import api from "@/lib/api";
|
import api from "@/lib/api";
|
||||||
|
|
||||||
const COLORS = ["#0891B2", "#059669", "#F59E0B", "#EF4444", "#8B5CF6", "#EC4899"];
|
const COLORS = ["#0891B2", "#059669", "#F59E0B", "#EF4444", "#8B5CF6", "#EC4899"];
|
||||||
|
|
||||||
|
type Tab = "overview" | "collections" | "tickets";
|
||||||
|
|
||||||
function KpiCard({ title, value, sub, icon: Icon, color }: { title: string; value: string; sub?: string; icon: any; color: string }) {
|
function KpiCard({ title, value, sub, icon: Icon, color }: { title: string; value: string; sub?: string; icon: any; color: string }) {
|
||||||
return (
|
return (
|
||||||
<Card>
|
<Card>
|
||||||
@@ -31,12 +35,26 @@ function KpiCard({ title, value, sub, icon: Icon, color }: { title: string; valu
|
|||||||
);
|
);
|
||||||
}
|
}
|
||||||
|
|
||||||
|
function downloadCSV(data: any[], filename: string) {
|
||||||
|
if (!data.length) return;
|
||||||
|
const headers = Object.keys(data[0]);
|
||||||
|
const rows = data.map(row => headers.map(h => JSON.stringify(row[h] ?? "")).join(","));
|
||||||
|
const csv = [headers.join(","), ...rows].join("\n");
|
||||||
|
const blob = new Blob([csv], { type: "text/csv" });
|
||||||
|
const url = URL.createObjectURL(blob);
|
||||||
|
const a = document.createElement("a");
|
||||||
|
a.href = url; a.download = filename; a.click();
|
||||||
|
URL.revokeObjectURL(url);
|
||||||
|
}
|
||||||
|
|
||||||
export default function ReportsPage() {
|
export default function ReportsPage() {
|
||||||
const today = new Date();
|
const today = new Date();
|
||||||
const firstOfMonth = new Date(today.getFullYear(), today.getMonth(), 1).toISOString().split("T")[0];
|
const firstOfMonth = new Date(today.getFullYear(), today.getMonth(), 1).toISOString().split("T")[0];
|
||||||
|
const [tab, setTab] = useState<Tab>("overview");
|
||||||
const [from, setFrom] = useState(firstOfMonth);
|
const [from, setFrom] = useState(firstOfMonth);
|
||||||
const [to, setTo] = useState(today.toISOString().split("T")[0]);
|
const [to, setTo] = useState(today.toISOString().split("T")[0]);
|
||||||
|
|
||||||
|
// Overview data
|
||||||
const { data: collection = [], isLoading: collLoading, refetch: refetchAll } = useQuery({
|
const { data: collection = [], isLoading: collLoading, refetch: refetchAll } = useQuery({
|
||||||
queryKey: ["reports-collection", from, to],
|
queryKey: ["reports-collection", from, to],
|
||||||
queryFn: async () => {
|
queryFn: async () => {
|
||||||
@@ -66,29 +84,54 @@ export default function ReportsPage() {
|
|||||||
queryFn: async () => {
|
queryFn: async () => {
|
||||||
const res = await api.get("/api/v1/reports/revenue");
|
const res = await api.get("/api/v1/reports/revenue");
|
||||||
return (res.data as Array<{ month: string; revenue: number; totalInvoiced: number }>)
|
return (res.data as Array<{ month: string; revenue: number; totalInvoiced: number }>)
|
||||||
.filter(r => r.revenue > 0 || r.totalInvoiced > 0)
|
.filter(r => r.revenue > 0 || r.totalInvoiced > 0).slice(-12);
|
||||||
.slice(-12);
|
|
||||||
},
|
},
|
||||||
});
|
});
|
||||||
|
|
||||||
|
// Collections tab data
|
||||||
|
const { data: paymentsData } = useQuery({
|
||||||
|
queryKey: ["reports-payments", from, to],
|
||||||
|
queryFn: async () => {
|
||||||
|
const res = await api.get(`/api/v1/payments?page=1&limit=100`);
|
||||||
|
return (res.data as any)?.data ?? [];
|
||||||
|
},
|
||||||
|
enabled: tab === "collections",
|
||||||
|
});
|
||||||
|
|
||||||
|
// Tickets tab data
|
||||||
|
const { data: ticketsData } = useQuery({
|
||||||
|
queryKey: ["reports-tickets"],
|
||||||
|
queryFn: async () => {
|
||||||
|
const [open, resolved, all] = await Promise.all([
|
||||||
|
api.get("/api/v1/tickets?status=OPEN&limit=100"),
|
||||||
|
api.get("/api/v1/tickets?status=RESOLVED&limit=100"),
|
||||||
|
api.get("/api/v1/tickets?limit=50"),
|
||||||
|
]);
|
||||||
|
return {
|
||||||
|
open: (open.data as any)?.meta?.total ?? (open.data as any)?.data?.length ?? 0,
|
||||||
|
resolved: (resolved.data as any)?.meta?.total ?? (resolved.data as any)?.data?.length ?? 0,
|
||||||
|
list: (all.data as any)?.data ?? [],
|
||||||
|
total: (all.data as any)?.meta?.total ?? 0,
|
||||||
|
};
|
||||||
|
},
|
||||||
|
enabled: tab === "tickets",
|
||||||
|
});
|
||||||
|
|
||||||
// Derived KPIs
|
// Derived KPIs
|
||||||
const totalCollected = collection.reduce((s, c) => s + Number(c.totalAmount), 0);
|
const totalCollected = collection.reduce((s, c) => s + Number(c.totalAmount), 0);
|
||||||
const totalPayments = collection.reduce((s, c) => s + c.paymentCount, 0);
|
const totalPayments = collection.reduce((s, c) => s + c.paymentCount, 0);
|
||||||
const totalOutstanding = aging.reduce((s, a) => s + Number(a.totalAmount), 0);
|
const totalOutstanding = aging.reduce((s, a) => s + Number(a.totalAmount), 0);
|
||||||
const overdueCount = aging.reduce((s, a) => s + a.invoiceCount, 0);
|
const overdueCount = aging.reduce((s, a) => s + a.invoiceCount, 0);
|
||||||
|
|
||||||
// Subscriber summary (status-only rows, no area key)
|
|
||||||
const subByStatus = subscribers.filter(s => !s.area && !s.plan);
|
const subByStatus = subscribers.filter(s => !s.area && !s.plan);
|
||||||
const activeCount = subByStatus.find(s => s.status === "ACTIVE")?.count ?? 0;
|
const activeCount = subByStatus.find(s => s.status === "ACTIVE")?.count ?? 0;
|
||||||
const pendingCount = subByStatus.find(s => s.status === "PENDING")?.count ?? 0;
|
const pendingCount = subByStatus.find(s => s.status === "PENDING")?.count ?? 0;
|
||||||
const suspendedCount = subByStatus.find(s => s.status === "SUSPENDED")?.count ?? 0;
|
const suspendedCount = subByStatus.find(s => s.status === "SUSPENDED")?.count ?? 0;
|
||||||
const totalSubs = subByStatus.reduce((s, x) => s + x.count, 0);
|
const totalSubs = subByStatus.reduce((s, x) => s + x.count, 0);
|
||||||
|
|
||||||
// Subscriber by area (rows with area key)
|
|
||||||
const subByArea = subscribers.filter(s => !!s.area);
|
const subByArea = subscribers.filter(s => !!s.area);
|
||||||
|
|
||||||
const agingRisk: Record<string, string> = { "0-30": "text-yellow-600", "31-60": "text-orange-600", "61-90": "text-red-500", "90+": "text-red-700" };
|
const agingRisk: Record<string, string> = { "0-30": "text-yellow-600", "31-60": "text-orange-600", "61-90": "text-red-500", "90+": "text-red-700" };
|
||||||
|
|
||||||
|
const payments: any[] = paymentsData ?? [];
|
||||||
|
|
||||||
return (
|
return (
|
||||||
<div className="space-y-6">
|
<div className="space-y-6">
|
||||||
<div className="flex items-center justify-between flex-wrap gap-3">
|
<div className="flex items-center justify-between flex-wrap gap-3">
|
||||||
@@ -109,154 +152,198 @@ export default function ReportsPage() {
|
|||||||
</div>
|
</div>
|
||||||
</div>
|
</div>
|
||||||
|
|
||||||
{/* KPI Summary */}
|
{/* Tabs */}
|
||||||
<div className="grid grid-cols-2 lg:grid-cols-4 gap-4">
|
<div className="flex border-b border-gray-200">
|
||||||
<KpiCard title="Total Collected" value={formatCurrency(totalCollected)} sub={`${totalPayments} payments`} icon={DollarSign} color="#059669" />
|
{(["overview", "collections", "tickets"] as Tab[]).map(t => (
|
||||||
<KpiCard title="Active Subscribers" value={String(activeCount)} sub={`${pendingCount} pending · ${suspendedCount} suspended`} icon={Users} color="#0891B2" />
|
<button key={t} onClick={() => setTab(t)}
|
||||||
<KpiCard title="Outstanding Balance" value={formatCurrency(totalOutstanding)} sub={`${overdueCount} overdue invoices`} icon={AlertTriangle} color="#EF4444" />
|
className={`px-5 py-2.5 text-sm font-medium border-b-2 capitalize transition-colors ${
|
||||||
<KpiCard title="Total Subscribers" value={String(totalSubs)} sub={`across all statuses`} icon={TrendingUp} color="#8B5CF6" />
|
tab === t ? "border-blue-600 text-blue-600" : "border-transparent text-gray-500 hover:text-gray-700"
|
||||||
|
}`}>
|
||||||
|
{t}
|
||||||
|
</button>
|
||||||
|
))}
|
||||||
</div>
|
</div>
|
||||||
|
|
||||||
{/* Collection Report */}
|
{/* Overview Tab */}
|
||||||
<div className="grid grid-cols-1 lg:grid-cols-2 gap-6">
|
{tab === "overview" && (
|
||||||
<Card>
|
<div className="space-y-6">
|
||||||
<CardHeader><CardTitle>Collection by Collector</CardTitle></CardHeader>
|
<div className="grid grid-cols-2 lg:grid-cols-4 gap-4">
|
||||||
<CardContent>
|
<KpiCard title="Total Collected" value={formatCurrency(totalCollected)} sub={`${totalPayments} payments`} icon={DollarSign} color="#059669" />
|
||||||
{collLoading ? <div className="h-40 animate-pulse bg-gray-100 rounded" /> :
|
<KpiCard title="Active Subscribers" value={String(activeCount)} sub={`${pendingCount} pending · ${suspendedCount} suspended`} icon={Users} color="#0891B2" />
|
||||||
collection.length === 0 ? <p className="text-sm text-gray-400 py-6 text-center">No collection data for this period</p> : (
|
<KpiCard title="Outstanding Balance" value={formatCurrency(totalOutstanding)} sub={`${overdueCount} overdue invoices`} icon={AlertTriangle} color="#EF4444" />
|
||||||
<>
|
<KpiCard title="Total Subscribers" value={String(totalSubs)} sub="across all statuses" icon={TrendingUp} color="#8B5CF6" />
|
||||||
<div className="space-y-2 mb-4">
|
</div>
|
||||||
{collection.map((c, i) => (
|
|
||||||
<div key={i} className="flex items-center justify-between py-2 border-b last:border-0">
|
<div className="grid grid-cols-1 lg:grid-cols-2 gap-6">
|
||||||
<div>
|
<Card>
|
||||||
<p className="text-sm font-medium text-gray-800">{c.collector}</p>
|
<CardHeader><CardTitle>Collection by Collector</CardTitle></CardHeader>
|
||||||
<p className="text-xs text-gray-400">{c.paymentCount} payments</p>
|
<CardContent>
|
||||||
</div>
|
{collLoading ? <div className="h-40 animate-pulse bg-gray-100 rounded" /> :
|
||||||
<div className="text-right">
|
collection.length === 0 ? <p className="text-sm text-gray-400 py-6 text-center">No collection data for this period</p> : (
|
||||||
<p className="text-sm font-bold text-green-700">{formatCurrency(c.totalAmount)}</p>
|
<>
|
||||||
<p className="text-xs text-gray-400">{totalCollected > 0 ? ((c.totalAmount / totalCollected) * 100).toFixed(1) : 0}%</p>
|
<div className="space-y-2 mb-4">
|
||||||
</div>
|
{collection.map((c, i) => (
|
||||||
|
<div key={i} className="flex items-center justify-between py-2 border-b last:border-0">
|
||||||
|
<div><p className="text-sm font-medium text-gray-800">{c.collector}</p><p className="text-xs text-gray-400">{c.paymentCount} payments</p></div>
|
||||||
|
<div className="text-right"><p className="text-sm font-bold text-green-700">{formatCurrency(c.totalAmount)}</p></div>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
<div className="flex justify-between pt-1 font-semibold text-sm"><span>Total</span><span className="text-green-700">{formatCurrency(totalCollected)}</span></div>
|
||||||
</div>
|
</div>
|
||||||
))}
|
<ResponsiveContainer width="100%" height={160}>
|
||||||
<div className="flex justify-between pt-1 font-semibold text-sm">
|
<BarChart data={collection}><XAxis dataKey="collector" tick={{ fontSize: 11 }} /><YAxis tick={{ fontSize: 11 }} tickFormatter={v => `₱${(v/1000).toFixed(0)}k`} /><Tooltip formatter={(v: any) => formatCurrency(Number(v))} /><Bar dataKey="totalAmount" fill="#0891B2" radius={[4,4,0,0]} /></BarChart>
|
||||||
<span>Total</span>
|
</ResponsiveContainer>
|
||||||
<span className="text-green-700">{formatCurrency(totalCollected)}</span>
|
</>
|
||||||
</div>
|
)
|
||||||
</div>
|
}
|
||||||
<ResponsiveContainer width="100%" height={160}>
|
</CardContent>
|
||||||
<BarChart data={collection} margin={{ top: 0, right: 0, left: 0, bottom: 0 }}>
|
</Card>
|
||||||
<XAxis dataKey="collector" tick={{ fontSize: 11 }} />
|
<Card>
|
||||||
<YAxis tick={{ fontSize: 11 }} tickFormatter={v => `₱${(v/1000).toFixed(0)}k`} />
|
<CardHeader><CardTitle>Accounts Receivable Aging</CardTitle></CardHeader>
|
||||||
<Tooltip formatter={(v: any) => formatCurrency(Number(v))} />
|
<CardContent>
|
||||||
<Bar dataKey="totalAmount" fill="#0891B2" radius={[4,4,0,0]} />
|
<div className="space-y-3">
|
||||||
</BarChart>
|
{aging.map((a) => (
|
||||||
</ResponsiveContainer>
|
<div key={a.bucket} className="flex items-center justify-between p-3 rounded-lg bg-gray-50">
|
||||||
</>
|
<div><p className={`text-sm font-semibold ${agingRisk[a.bucket] ?? "text-gray-700"}`}>{a.bucket} days</p><p className="text-xs text-gray-400">{a.invoiceCount} invoices</p></div>
|
||||||
)
|
<p className={`text-base font-bold ${a.totalAmount > 0 ? agingRisk[a.bucket] ?? "text-gray-800" : "text-gray-400"}`}>{formatCurrency(a.totalAmount)}</p>
|
||||||
}
|
|
||||||
</CardContent>
|
|
||||||
</Card>
|
|
||||||
|
|
||||||
{/* Aging Report */}
|
|
||||||
<Card>
|
|
||||||
<CardHeader><CardTitle>Accounts Receivable Aging</CardTitle></CardHeader>
|
|
||||||
<CardContent>
|
|
||||||
<div className="space-y-3">
|
|
||||||
{aging.map((a) => (
|
|
||||||
<div key={a.bucket} className="flex items-center justify-between p-3 rounded-lg bg-gray-50">
|
|
||||||
<div>
|
|
||||||
<p className={`text-sm font-semibold ${agingRisk[a.bucket] ?? "text-gray-700"}`}>{a.bucket} days overdue</p>
|
|
||||||
<p className="text-xs text-gray-400">{a.invoiceCount} invoice{a.invoiceCount !== 1 ? "s" : ""}</p>
|
|
||||||
</div>
|
|
||||||
<div className="text-right">
|
|
||||||
<p className={`text-base font-bold ${a.totalAmount > 0 ? agingRisk[a.bucket] ?? "text-gray-800" : "text-gray-400"}`}>
|
|
||||||
{formatCurrency(a.totalAmount)}
|
|
||||||
</p>
|
|
||||||
</div>
|
|
||||||
</div>
|
|
||||||
))}
|
|
||||||
<div className="flex justify-between px-3 py-2 bg-red-50 rounded-lg font-semibold text-sm">
|
|
||||||
<span className="text-red-700">Total Outstanding</span>
|
|
||||||
<span className="text-red-700">{formatCurrency(totalOutstanding)}</span>
|
|
||||||
</div>
|
|
||||||
</div>
|
|
||||||
</CardContent>
|
|
||||||
</Card>
|
|
||||||
</div>
|
|
||||||
|
|
||||||
{/* Revenue Trend */}
|
|
||||||
{revenue.length > 0 && (
|
|
||||||
<Card>
|
|
||||||
<CardHeader><CardTitle>Revenue Trend (Monthly)</CardTitle></CardHeader>
|
|
||||||
<CardContent>
|
|
||||||
<ResponsiveContainer width="100%" height={220}>
|
|
||||||
<LineChart data={revenue} margin={{ top: 5, right: 20, left: 0, bottom: 5 }}>
|
|
||||||
<CartesianGrid strokeDasharray="3 3" stroke="#F1F5F9" />
|
|
||||||
<XAxis dataKey="month" tick={{ fontSize: 11 }} />
|
|
||||||
<YAxis tick={{ fontSize: 11 }} tickFormatter={v => `₱${(v/1000).toFixed(0)}k`} />
|
|
||||||
<Tooltip formatter={(v: any) => formatCurrency(Number(v))} />
|
|
||||||
<Legend />
|
|
||||||
<Line type="monotone" dataKey="revenue" stroke="#059669" strokeWidth={2} dot={false} name="Collected" />
|
|
||||||
<Line type="monotone" dataKey="totalInvoiced" stroke="#0891B2" strokeWidth={2} dot={false} name="Invoiced" strokeDasharray="4 2" />
|
|
||||||
</LineChart>
|
|
||||||
</ResponsiveContainer>
|
|
||||||
</CardContent>
|
|
||||||
</Card>
|
|
||||||
)}
|
|
||||||
|
|
||||||
{/* Subscribers by Status + Area */}
|
|
||||||
<div className="grid grid-cols-1 lg:grid-cols-2 gap-6">
|
|
||||||
<Card>
|
|
||||||
<CardHeader><CardTitle>Subscribers by Status</CardTitle></CardHeader>
|
|
||||||
<CardContent>
|
|
||||||
{subByStatus.length === 0 ? <p className="text-sm text-gray-400 py-4 text-center">No subscriber data</p> : (
|
|
||||||
<div className="flex gap-6 items-center">
|
|
||||||
<ResponsiveContainer width="50%" height={160}>
|
|
||||||
<PieChart>
|
|
||||||
<Pie data={subByStatus} dataKey="count" nameKey="status" cx="50%" cy="50%" outerRadius={60} label={false}>
|
|
||||||
{subByStatus.map((_, i) => <Cell key={i} fill={COLORS[i % COLORS.length]} />)}
|
|
||||||
</Pie>
|
|
||||||
<Tooltip />
|
|
||||||
</PieChart>
|
|
||||||
</ResponsiveContainer>
|
|
||||||
<div className="space-y-2">
|
|
||||||
{subByStatus.map((s, i) => (
|
|
||||||
<div key={s.status} className="flex items-center gap-2">
|
|
||||||
<div className="w-3 h-3 rounded-full" style={{ backgroundColor: COLORS[i % COLORS.length] }} />
|
|
||||||
<span className="text-sm text-gray-700">{s.status}</span>
|
|
||||||
<span className="text-sm font-bold text-gray-900 ml-auto">{s.count}</span>
|
|
||||||
</div>
|
</div>
|
||||||
))}
|
))}
|
||||||
<div className="border-t pt-1 flex justify-between text-sm font-semibold">
|
<div className="flex justify-between px-3 py-2 bg-red-50 rounded-lg font-semibold text-sm"><span className="text-red-700">Total Outstanding</span><span className="text-red-700">{formatCurrency(totalOutstanding)}</span></div>
|
||||||
<span>Total</span><span>{totalSubs}</span>
|
|
||||||
</div>
|
|
||||||
</div>
|
</div>
|
||||||
</div>
|
</CardContent>
|
||||||
)}
|
</Card>
|
||||||
</CardContent>
|
</div>
|
||||||
</Card>
|
|
||||||
|
|
||||||
{subByArea.length > 0 && (
|
{revenue.length > 0 && (
|
||||||
<Card>
|
<Card>
|
||||||
<CardHeader><CardTitle>Active Subscribers by Area</CardTitle></CardHeader>
|
<CardHeader><CardTitle>Revenue Trend (Monthly)</CardTitle></CardHeader>
|
||||||
<CardContent>
|
<CardContent>
|
||||||
<div className="space-y-2">
|
<ResponsiveContainer width="100%" height={220}>
|
||||||
{subByArea.map((a) => (
|
<LineChart data={revenue} margin={{ top: 5, right: 20, left: 0, bottom: 5 }}>
|
||||||
<div key={a.area} className="flex items-center justify-between py-2 border-b last:border-0">
|
<CartesianGrid strokeDasharray="3 3" stroke="#F1F5F9" />
|
||||||
<span className="text-sm font-medium text-gray-800">{a.area}</span>
|
<XAxis dataKey="month" tick={{ fontSize: 11 }} /><YAxis tick={{ fontSize: 11 }} tickFormatter={v => `₱${(v/1000).toFixed(0)}k`} />
|
||||||
<div className="flex items-center gap-2">
|
<Tooltip formatter={(v: any) => formatCurrency(Number(v))} /><Legend />
|
||||||
<div className="w-20 bg-gray-100 rounded-full h-2 overflow-hidden">
|
<Line type="monotone" dataKey="revenue" stroke="#059669" strokeWidth={2} dot={false} name="Collected" />
|
||||||
<div className="h-2 rounded-full bg-blue-500" style={{ width: `${Math.min(100, (a.count / (activeCount || 1)) * 100)}%` }} />
|
<Line type="monotone" dataKey="totalInvoiced" stroke="#0891B2" strokeWidth={2} dot={false} name="Invoiced" strokeDasharray="4 2" />
|
||||||
</div>
|
</LineChart>
|
||||||
<span className="text-sm font-bold text-gray-700 w-6 text-right">{a.count}</span>
|
</ResponsiveContainer>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
)}
|
||||||
|
|
||||||
|
<div className="grid grid-cols-1 lg:grid-cols-2 gap-6">
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Subscribers by Status</CardTitle></CardHeader>
|
||||||
|
<CardContent>
|
||||||
|
{subByStatus.length === 0 ? <p className="text-sm text-gray-400 py-4 text-center">No subscriber data</p> : (
|
||||||
|
<div className="flex gap-6 items-center">
|
||||||
|
<ResponsiveContainer width="50%" height={160}>
|
||||||
|
<PieChart><Pie data={subByStatus} dataKey="count" nameKey="status" cx="50%" cy="50%" outerRadius={60}>{subByStatus.map((_, i) => <Cell key={i} fill={COLORS[i % COLORS.length]} />)}</Pie><Tooltip /></PieChart>
|
||||||
|
</ResponsiveContainer>
|
||||||
|
<div className="space-y-2">
|
||||||
|
{subByStatus.map((s, i) => (<div key={s.status} className="flex items-center gap-2"><div className="w-3 h-3 rounded-full" style={{ backgroundColor: COLORS[i % COLORS.length] }} /><span className="text-sm text-gray-700">{s.status}</span><span className="text-sm font-bold ml-auto">{s.count}</span></div>))}
|
||||||
|
<div className="border-t pt-1 flex justify-between text-sm font-semibold"><span>Total</span><span>{totalSubs}</span></div>
|
||||||
</div>
|
</div>
|
||||||
</div>
|
</div>
|
||||||
))}
|
)}
|
||||||
</div>
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
{subByArea.length > 0 && (
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Active Subscribers by Area</CardTitle></CardHeader>
|
||||||
|
<CardContent>
|
||||||
|
<div className="space-y-2">
|
||||||
|
{subByArea.map(a => (
|
||||||
|
<div key={a.area} className="flex items-center justify-between py-2 border-b last:border-0">
|
||||||
|
<span className="text-sm font-medium">{a.area}</span>
|
||||||
|
<div className="flex items-center gap-2"><div className="w-20 bg-gray-100 rounded-full h-2"><div className="h-2 rounded-full bg-blue-500" style={{ width: `${Math.min(100, (a.count / (activeCount || 1)) * 100)}%` }} /></div><span className="text-sm font-bold w-6 text-right">{a.count}</span></div>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
|
||||||
|
{/* Collections Tab */}
|
||||||
|
{tab === "collections" && (
|
||||||
|
<div className="space-y-4">
|
||||||
|
<div className="flex items-center justify-between">
|
||||||
|
<h2 className="text-lg font-semibold text-gray-800">Payment Collections</h2>
|
||||||
|
<Button size="sm" variant="outline" onClick={() => downloadCSV(payments.map(p => ({
|
||||||
|
Date: p.paymentDate ?? p.createdAt,
|
||||||
|
Client: p.client ? `${p.client.firstName} ${p.client.lastName}` : "",
|
||||||
|
Amount: p.amount, Channel: p.channel, Reference: p.referenceNumber ?? "", Notes: p.notes ?? "",
|
||||||
|
})), `collections-${from}-${to}.csv`)}>
|
||||||
|
<Download size={14} className="mr-1" /> Export CSV
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
<Card>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
<Table>
|
||||||
|
<TableHead>
|
||||||
|
<TableRow><Th>Date</Th><Th>Client</Th><Th>Amount</Th><Th>Channel</Th><Th>Reference</Th><Th>Notes</Th></TableRow>
|
||||||
|
</TableHead>
|
||||||
|
<TableBody>
|
||||||
|
{payments.length === 0 ? <EmptyState message="No payments found" /> :
|
||||||
|
payments.map((p: any) => (
|
||||||
|
<TableRow key={p.id}>
|
||||||
|
<Td className="text-xs text-gray-500">{formatDate(p.paymentDate ?? p.createdAt)}</Td>
|
||||||
|
<Td className="font-medium">{p.client ? `${p.client.firstName} ${p.client.lastName}` : "—"}</Td>
|
||||||
|
<Td className="text-green-700 font-medium">{formatCurrency(Number(p.amount))}</Td>
|
||||||
|
<Td><Badge variant="muted">{p.channel}</Badge></Td>
|
||||||
|
<Td className="text-xs text-gray-400">{p.referenceNumber ?? "—"}</Td>
|
||||||
|
<Td className="text-xs text-gray-400 max-w-[120px] truncate">{p.notes ?? "—"}</Td>
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
}
|
||||||
|
</TableBody>
|
||||||
|
</Table>
|
||||||
</CardContent>
|
</CardContent>
|
||||||
</Card>
|
</Card>
|
||||||
)}
|
</div>
|
||||||
</div>
|
)}
|
||||||
|
|
||||||
|
{/* Tickets Tab */}
|
||||||
|
{tab === "tickets" && (
|
||||||
|
<div className="space-y-4">
|
||||||
|
{ticketsData && (
|
||||||
|
<>
|
||||||
|
<div className="grid grid-cols-3 gap-4">
|
||||||
|
<Card><CardContent className="pt-5 text-center"><p className="text-3xl font-bold text-yellow-600">{ticketsData.open}</p><p className="text-sm text-gray-500 mt-1">Open</p></CardContent></Card>
|
||||||
|
<Card><CardContent className="pt-5 text-center"><p className="text-3xl font-bold text-green-600">{ticketsData.resolved}</p><p className="text-sm text-gray-500 mt-1">Resolved</p></CardContent></Card>
|
||||||
|
<Card><CardContent className="pt-5 text-center"><p className="text-3xl font-bold text-blue-600">{ticketsData.total}</p><p className="text-sm text-gray-500 mt-1">Total</p></CardContent></Card>
|
||||||
|
</div>
|
||||||
|
<Card>
|
||||||
|
<CardHeader><CardTitle>Recent Tickets</CardTitle></CardHeader>
|
||||||
|
<CardContent className="p-0">
|
||||||
|
<Table>
|
||||||
|
<TableHead>
|
||||||
|
<TableRow><Th>Subject</Th><Th>Client</Th><Th>Type</Th><Th>Priority</Th><Th>Status</Th><Th>Created</Th></TableRow>
|
||||||
|
</TableHead>
|
||||||
|
<TableBody>
|
||||||
|
{ticketsData.list.length === 0 ? <EmptyState message="No tickets found" /> :
|
||||||
|
ticketsData.list.map((t: any) => (
|
||||||
|
<TableRow key={t.id}>
|
||||||
|
<Td className="font-medium max-w-[180px] truncate">{t.subject}</Td>
|
||||||
|
<Td>{t.client ? `${t.client.firstName} ${t.client.lastName}` : "—"}</Td>
|
||||||
|
<Td><Badge variant="muted">{t.type}</Badge></Td>
|
||||||
|
<Td><Badge variant={t.priority === "HIGH" ? "warning" : "muted"}>{t.priority}</Badge></Td>
|
||||||
|
<Td><Badge variant={t.status === "RESOLVED" ? "success" : t.status === "OPEN" ? "warning" : "muted"}>{t.status}</Badge></Td>
|
||||||
|
<Td className="text-xs text-gray-400">{formatDate(t.createdAt)}</Td>
|
||||||
|
</TableRow>
|
||||||
|
))
|
||||||
|
}
|
||||||
|
</TableBody>
|
||||||
|
</Table>
|
||||||
|
</CardContent>
|
||||||
|
</Card>
|
||||||
|
</>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
</div>
|
</div>
|
||||||
);
|
);
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -238,6 +238,8 @@ function AreasSettings() {
|
|||||||
const [areaName, setAreaName] = useState("");
|
const [areaName, setAreaName] = useState("");
|
||||||
const [zoneName, setZoneName] = useState("");
|
const [zoneName, setZoneName] = useState("");
|
||||||
const [zoneAreaId, setZoneAreaId] = useState("");
|
const [zoneAreaId, setZoneAreaId] = useState("");
|
||||||
|
const [editArea, setEditArea] = useState<Area | null>(null);
|
||||||
|
const [editAreaName, setEditAreaName] = useState("");
|
||||||
|
|
||||||
const { data: areas, isLoading, refetch } = useQuery<Area[]>({
|
const { data: areas, isLoading, refetch } = useQuery<Area[]>({
|
||||||
queryKey: ["areas"],
|
queryKey: ["areas"],
|
||||||
@@ -256,26 +258,31 @@ function AreasSettings() {
|
|||||||
mutationFn: async () => {
|
mutationFn: async () => {
|
||||||
await api.post("/api/v1/areas", { name: areaName });
|
await api.post("/api/v1/areas", { name: areaName });
|
||||||
},
|
},
|
||||||
onSuccess: () => {
|
onSuccess: () => { toast.success("Area added"); setAreaName(""); setShowAddArea(false); refetch(); },
|
||||||
toast.success("Area added");
|
|
||||||
setAreaName("");
|
|
||||||
setShowAddArea(false);
|
|
||||||
refetch();
|
|
||||||
},
|
|
||||||
onError: () => toast.error("Failed to add area"),
|
onError: () => toast.error("Failed to add area"),
|
||||||
});
|
});
|
||||||
|
|
||||||
|
const updateAreaMutation = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.patch(`/api/v1/areas/${editArea!.id}`, { name: editAreaName });
|
||||||
|
},
|
||||||
|
onSuccess: () => { toast.success("Area updated"); setEditArea(null); refetch(); },
|
||||||
|
onError: () => toast.error("Failed to update area"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const deleteAreaMutation = useMutation({
|
||||||
|
mutationFn: async (id: string) => {
|
||||||
|
await api.delete(`/api/v1/areas/${id}`);
|
||||||
|
},
|
||||||
|
onSuccess: () => { toast.success("Area archived"); refetch(); },
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to archive area"),
|
||||||
|
});
|
||||||
|
|
||||||
const addZoneMutation = useMutation({
|
const addZoneMutation = useMutation({
|
||||||
mutationFn: async () => {
|
mutationFn: async () => {
|
||||||
await api.post("/api/v1/zones", { name: zoneName, areaId: zoneAreaId });
|
await api.post("/api/v1/zones", { name: zoneName, areaId: zoneAreaId });
|
||||||
},
|
},
|
||||||
onSuccess: () => {
|
onSuccess: () => { toast.success("Zone added"); setZoneName(""); setZoneAreaId(""); setShowAddZone(false); refetch(); },
|
||||||
toast.success("Zone added");
|
|
||||||
setZoneName("");
|
|
||||||
setZoneAreaId("");
|
|
||||||
setShowAddZone(false);
|
|
||||||
refetch();
|
|
||||||
},
|
|
||||||
onError: () => toast.error("Failed to add zone"),
|
onError: () => toast.error("Failed to add zone"),
|
||||||
});
|
});
|
||||||
|
|
||||||
@@ -287,21 +294,14 @@ function AreasSettings() {
|
|||||||
<CardHeader>
|
<CardHeader>
|
||||||
<CardTitle>Areas & Zones</CardTitle>
|
<CardTitle>Areas & Zones</CardTitle>
|
||||||
<div className="flex gap-2">
|
<div className="flex gap-2">
|
||||||
<Button size="sm" variant="outline" onClick={() => setShowAddArea(true)}>
|
<Button size="sm" variant="outline" onClick={() => setShowAddArea(true)}>+ Area</Button>
|
||||||
+ Area
|
<Button size="sm" variant="outline" onClick={() => setShowAddZone(true)}>+ Zone</Button>
|
||||||
</Button>
|
|
||||||
<Button size="sm" variant="outline" onClick={() => setShowAddZone(true)}>
|
|
||||||
+ Zone
|
|
||||||
</Button>
|
|
||||||
</div>
|
</div>
|
||||||
</CardHeader>
|
</CardHeader>
|
||||||
<CardContent className="p-0">
|
<CardContent className="p-0">
|
||||||
<Table>
|
<Table>
|
||||||
<TableHead>
|
<TableHead>
|
||||||
<TableRow>
|
<TableRow><Th>Area Name</Th><Th>Zones</Th><Th>Actions</Th></TableRow>
|
||||||
<Th>Area Name</Th>
|
|
||||||
<Th>Zones</Th>
|
|
||||||
</TableRow>
|
|
||||||
</TableHead>
|
</TableHead>
|
||||||
<TableBody>
|
<TableBody>
|
||||||
{isLoading ? (
|
{isLoading ? (
|
||||||
@@ -309,6 +309,7 @@ function AreasSettings() {
|
|||||||
<TableRow key={i}>
|
<TableRow key={i}>
|
||||||
<Td><div className="h-4 w-32 animate-pulse bg-gray-100 rounded" /></Td>
|
<Td><div className="h-4 w-32 animate-pulse bg-gray-100 rounded" /></Td>
|
||||||
<Td><div className="h-4 w-24 animate-pulse bg-gray-100 rounded" /></Td>
|
<Td><div className="h-4 w-24 animate-pulse bg-gray-100 rounded" /></Td>
|
||||||
|
<Td><div className="h-4 w-20 animate-pulse bg-gray-100 rounded" /></Td>
|
||||||
</TableRow>
|
</TableRow>
|
||||||
))
|
))
|
||||||
) : areaList.length === 0 ? (
|
) : areaList.length === 0 ? (
|
||||||
@@ -318,9 +319,13 @@ function AreasSettings() {
|
|||||||
<TableRow key={a.id}>
|
<TableRow key={a.id}>
|
||||||
<Td className="font-medium">{a.name}</Td>
|
<Td className="font-medium">{a.name}</Td>
|
||||||
<Td className="text-sm text-gray-500">
|
<Td className="text-sm text-gray-500">
|
||||||
{a.zones?.length
|
{a.zones?.length ? a.zones.map(z => z.name).join(", ") : <span className="text-gray-300">No zones</span>}
|
||||||
? a.zones.map((z) => z.name).join(", ")
|
</Td>
|
||||||
: <span className="text-gray-300">No zones</span>}
|
<Td>
|
||||||
|
<div className="flex gap-1">
|
||||||
|
<Button size="sm" variant="ghost" onClick={() => { setEditArea(a); setEditAreaName(a.name); }}>Edit</Button>
|
||||||
|
<Button size="sm" variant="ghost" onClick={() => { if (confirm(`Archive area "${a.name}"?`)) deleteAreaMutation.mutate(a.id); }}>Archive</Button>
|
||||||
|
</div>
|
||||||
</Td>
|
</Td>
|
||||||
</TableRow>
|
</TableRow>
|
||||||
))
|
))
|
||||||
@@ -330,20 +335,24 @@ function AreasSettings() {
|
|||||||
</CardContent>
|
</CardContent>
|
||||||
</Card>
|
</Card>
|
||||||
|
|
||||||
|
{/* Edit Area Modal */}
|
||||||
|
<Modal isOpen={!!editArea} onClose={() => setEditArea(null)} title="Edit Area">
|
||||||
|
<form onSubmit={(e) => { e.preventDefault(); updateAreaMutation.mutate(); }} className="space-y-4">
|
||||||
|
<Input label="Area Name" value={editAreaName} onChange={(e) => setEditAreaName(e.target.value)} />
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button type="button" variant="outline" size="sm" onClick={() => setEditArea(null)}>Cancel</Button>
|
||||||
|
<Button type="submit" size="sm" isLoading={updateAreaMutation.isPending} disabled={!editAreaName.trim()}>Save</Button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
</Modal>
|
||||||
|
|
||||||
{/* Add Area Modal */}
|
{/* Add Area Modal */}
|
||||||
<Modal isOpen={showAddArea} onClose={() => setShowAddArea(false)} title="Add Area">
|
<Modal isOpen={showAddArea} onClose={() => setShowAddArea(false)} title="Add Area">
|
||||||
<form onSubmit={(e) => { e.preventDefault(); addAreaMutation.mutate(); }} className="space-y-4">
|
<form onSubmit={(e) => { e.preventDefault(); addAreaMutation.mutate(); }} className="space-y-4">
|
||||||
<Input
|
<Input label="Area Name" value={areaName} onChange={(e) => setAreaName(e.target.value)} placeholder="e.g. North Sector" />
|
||||||
label="Area Name"
|
|
||||||
value={areaName}
|
|
||||||
onChange={(e) => setAreaName(e.target.value)}
|
|
||||||
placeholder="e.g. North Sector"
|
|
||||||
/>
|
|
||||||
<div className="flex justify-end gap-2">
|
<div className="flex justify-end gap-2">
|
||||||
<Button type="button" variant="outline" size="sm" onClick={() => setShowAddArea(false)}>Cancel</Button>
|
<Button type="button" variant="outline" size="sm" onClick={() => setShowAddArea(false)}>Cancel</Button>
|
||||||
<Button type="submit" size="sm" isLoading={addAreaMutation.isPending} disabled={!areaName.trim()}>
|
<Button type="submit" size="sm" isLoading={addAreaMutation.isPending} disabled={!areaName.trim()}>Add Area</Button>
|
||||||
Add Area
|
|
||||||
</Button>
|
|
||||||
</div>
|
</div>
|
||||||
</form>
|
</form>
|
||||||
</Modal>
|
</Modal>
|
||||||
@@ -353,33 +362,16 @@ function AreasSettings() {
|
|||||||
<form onSubmit={(e) => { e.preventDefault(); addZoneMutation.mutate(); }} className="space-y-4">
|
<form onSubmit={(e) => { e.preventDefault(); addZoneMutation.mutate(); }} className="space-y-4">
|
||||||
<div className="flex flex-col gap-1.5">
|
<div className="flex flex-col gap-1.5">
|
||||||
<label className="text-sm font-medium text-gray-700">Area</label>
|
<label className="text-sm font-medium text-gray-700">Area</label>
|
||||||
<select
|
<select className="block w-full rounded-lg border border-gray-300 bg-white px-3 py-2 text-sm focus:border-blue-500 focus:outline-none focus:ring-1 focus:ring-blue-500"
|
||||||
className="block w-full rounded-lg border border-gray-300 bg-white px-3 py-2 text-sm focus:border-blue-500 focus:outline-none focus:ring-1 focus:ring-blue-500"
|
value={zoneAreaId} onChange={(e) => setZoneAreaId(e.target.value)}>
|
||||||
value={zoneAreaId}
|
|
||||||
onChange={(e) => setZoneAreaId(e.target.value)}
|
|
||||||
>
|
|
||||||
<option value="">Select area</option>
|
<option value="">Select area</option>
|
||||||
{areaList.map((a) => (
|
{areaList.map(a => <option key={a.id} value={a.id}>{a.name}</option>)}
|
||||||
<option key={a.id} value={a.id}>{a.name}</option>
|
|
||||||
))}
|
|
||||||
</select>
|
</select>
|
||||||
</div>
|
</div>
|
||||||
<Input
|
<Input label="Zone Name" value={zoneName} onChange={(e) => setZoneName(e.target.value)} placeholder="e.g. Zone 1" />
|
||||||
label="Zone Name"
|
|
||||||
value={zoneName}
|
|
||||||
onChange={(e) => setZoneName(e.target.value)}
|
|
||||||
placeholder="e.g. Zone 1"
|
|
||||||
/>
|
|
||||||
<div className="flex justify-end gap-2">
|
<div className="flex justify-end gap-2">
|
||||||
<Button type="button" variant="outline" size="sm" onClick={() => setShowAddZone(false)}>Cancel</Button>
|
<Button type="button" variant="outline" size="sm" onClick={() => setShowAddZone(false)}>Cancel</Button>
|
||||||
<Button
|
<Button type="submit" size="sm" isLoading={addZoneMutation.isPending} disabled={!zoneName.trim() || !zoneAreaId}>Add Zone</Button>
|
||||||
type="submit"
|
|
||||||
size="sm"
|
|
||||||
isLoading={addZoneMutation.isPending}
|
|
||||||
disabled={!zoneName.trim() || !zoneAreaId}
|
|
||||||
>
|
|
||||||
Add Zone
|
|
||||||
</Button>
|
|
||||||
</div>
|
</div>
|
||||||
</form>
|
</form>
|
||||||
</Modal>
|
</Modal>
|
||||||
@@ -636,6 +628,8 @@ const ROLES = ["ADMIN", "STAFF", "COLLECTOR", "TECHNICIAN"];
|
|||||||
function UsersSettings() {
|
function UsersSettings() {
|
||||||
const qc = useQueryClient();
|
const qc = useQueryClient();
|
||||||
const [showAdd, setShowAdd] = useState(false);
|
const [showAdd, setShowAdd] = useState(false);
|
||||||
|
const [resetPwUser, setResetPwUser] = useState<UserItem | null>(null);
|
||||||
|
const [newPassword, setNewPassword] = useState("");
|
||||||
const [form, setForm] = useState({ firstName: "", lastName: "", email: "", password: "", phone: "", role: "STAFF" });
|
const [form, setForm] = useState({ firstName: "", lastName: "", email: "", password: "", phone: "", role: "STAFF" });
|
||||||
|
|
||||||
const { data, isLoading, refetch } = useQuery<UserItem[]>({
|
const { data, isLoading, refetch } = useQuery<UserItem[]>({
|
||||||
@@ -671,6 +665,14 @@ function UsersSettings() {
|
|||||||
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed"),
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed"),
|
||||||
});
|
});
|
||||||
|
|
||||||
|
const resetPassword = useMutation({
|
||||||
|
mutationFn: async () => {
|
||||||
|
await api.patch(`/api/v1/users/${resetPwUser!.id}/password`, { newPassword });
|
||||||
|
},
|
||||||
|
onSuccess: () => { toast.success("Password reset!"); setResetPwUser(null); setNewPassword(""); },
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to reset password"),
|
||||||
|
});
|
||||||
|
|
||||||
const users = data ?? [];
|
const users = data ?? [];
|
||||||
|
|
||||||
return (
|
return (
|
||||||
@@ -693,17 +695,29 @@ function UsersSettings() {
|
|||||||
) : users.length === 0 ? (
|
) : users.length === 0 ? (
|
||||||
<EmptyState message="No users found" />
|
<EmptyState message="No users found" />
|
||||||
) : users.map(u => {
|
) : users.map(u => {
|
||||||
const role = u.roleAssignments?.[0]?.role ?? "—";
|
const roles = u.roleAssignments?.map(r => r.role) ?? [];
|
||||||
|
const primaryRole = roles[0] ?? "—";
|
||||||
return (
|
return (
|
||||||
<TableRow key={u.id}>
|
<TableRow key={u.id}>
|
||||||
<Td className="font-medium">{u.firstName} {u.lastName}<div className="text-xs text-gray-400">{u.phone ?? ""}</div></Td>
|
<Td className="font-medium">{u.firstName} {u.lastName}<div className="text-xs text-gray-400">{u.phone ?? ""}</div></Td>
|
||||||
<Td className="text-sm text-gray-600">{u.email}</Td>
|
<Td className="text-sm text-gray-600">{u.email}</Td>
|
||||||
<Td><Badge variant={role === "ADMIN" ? "danger" : role === "STAFF" ? "default" as any : "muted"}>{role}</Badge></Td>
|
<Td>
|
||||||
|
<div className="flex flex-wrap gap-1">
|
||||||
|
{roles.length > 0 ? roles.map(r => (
|
||||||
|
<Badge key={r} variant={r === "ADMIN" ? "danger" : r === "STAFF" ? "default" as any : "muted"}>{r}</Badge>
|
||||||
|
)) : <Badge variant="muted">—</Badge>}
|
||||||
|
</div>
|
||||||
|
</Td>
|
||||||
<Td><Badge variant={u.isActive ? "success" : "muted"}>{u.isActive ? "Active" : "Inactive"}</Badge></Td>
|
<Td><Badge variant={u.isActive ? "success" : "muted"}>{u.isActive ? "Active" : "Inactive"}</Badge></Td>
|
||||||
<Td>
|
<Td>
|
||||||
<Button size="sm" variant="ghost" onClick={() => toggleActive.mutate({ id: u.id, isActive: u.isActive })}>
|
<div className="flex gap-1 flex-wrap">
|
||||||
{u.isActive ? "Deactivate" : "Activate"}
|
<Button size="sm" variant="ghost" onClick={() => { setResetPwUser(u); setNewPassword(""); }}>
|
||||||
</Button>
|
Reset PW
|
||||||
|
</Button>
|
||||||
|
<Button size="sm" variant="ghost" onClick={() => toggleActive.mutate({ id: u.id, isActive: u.isActive })}>
|
||||||
|
{u.isActive ? "Deactivate" : "Activate"}
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
</Td>
|
</Td>
|
||||||
</TableRow>
|
</TableRow>
|
||||||
);
|
);
|
||||||
@@ -713,6 +727,21 @@ function UsersSettings() {
|
|||||||
</CardContent>
|
</CardContent>
|
||||||
</Card>
|
</Card>
|
||||||
|
|
||||||
|
{/* Reset Password Modal */}
|
||||||
|
<Modal isOpen={!!resetPwUser} onClose={() => setResetPwUser(null)} title={`Reset Password — ${resetPwUser ? `${resetPwUser.firstName} ${resetPwUser.lastName}` : ""}`}>
|
||||||
|
<div className="space-y-4">
|
||||||
|
<p className="text-sm text-gray-500">Enter a new password for this user. They will need to use this to log in.</p>
|
||||||
|
<Input label="New Password" type="password" value={newPassword}
|
||||||
|
onChange={e => setNewPassword(e.target.value)} hint="Minimum 8 characters" />
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<Button variant="outline" onClick={() => setResetPwUser(null)}>Cancel</Button>
|
||||||
|
<Button onClick={() => resetPassword.mutate()} isLoading={resetPassword.isPending} disabled={newPassword.length < 8}>
|
||||||
|
Reset Password
|
||||||
|
</Button>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</Modal>
|
||||||
|
|
||||||
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Add New User">
|
<Modal isOpen={showAdd} onClose={() => setShowAdd(false)} title="Add New User">
|
||||||
<div className="space-y-4">
|
<div className="space-y-4">
|
||||||
<div className="grid grid-cols-2 gap-3">
|
<div className="grid grid-cols-2 gap-3">
|
||||||
|
|||||||
@@ -2,7 +2,8 @@
|
|||||||
|
|
||||||
import { useState } from "react";
|
import { useState } from "react";
|
||||||
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
||||||
import { RefreshCw, Ticket, Plus, Send } from "lucide-react";
|
import { RefreshCw, Ticket, Plus, Send, RotateCcw, User, MapPin, Zap } from "lucide-react";
|
||||||
|
import { useAuthStore } from "@/lib/auth-store";
|
||||||
import { Card, CardContent, CardHeader } from "@/components/ui/Card";
|
import { Card, CardContent, CardHeader } from "@/components/ui/Card";
|
||||||
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
import { Table, TableHead, TableBody, TableRow, Th, Td, EmptyState } from "@/components/ui/Table";
|
||||||
import { Badge } from "@/components/ui/Badge";
|
import { Badge } from "@/components/ui/Badge";
|
||||||
@@ -34,11 +35,20 @@ const priorityVariant: Record<string, "danger" | "warning" | "muted"> = {
|
|||||||
const statusFilters = ["", "OPEN", "IN_PROGRESS", "RESOLVED", "CLOSED"];
|
const statusFilters = ["", "OPEN", "IN_PROGRESS", "RESOLVED", "CLOSED"];
|
||||||
const typeFilters = ["", "SUPPORT", "BILLING", "INSTALLATION"];
|
const typeFilters = ["", "SUPPORT", "BILLING", "INSTALLATION"];
|
||||||
|
|
||||||
|
// Previous status mapping (revert flow)
|
||||||
|
const prevStatus: Record<string, string> = {
|
||||||
|
CLOSED: "RESOLVED",
|
||||||
|
RESOLVED: "IN_PROGRESS",
|
||||||
|
IN_PROGRESS: "OPEN",
|
||||||
|
};
|
||||||
|
|
||||||
export default function TicketsPage() {
|
export default function TicketsPage() {
|
||||||
const qc = useQueryClient();
|
const qc = useQueryClient();
|
||||||
|
const user = useAuthStore((s) => s.user);
|
||||||
const [search, setSearch] = useState("");
|
const [search, setSearch] = useState("");
|
||||||
const [statusFilter, setStatusFilter] = useState("");
|
const [statusFilter, setStatusFilter] = useState("");
|
||||||
const [typeFilter, setTypeFilter] = useState("");
|
const [typeFilter, setTypeFilter] = useState("");
|
||||||
|
const [assignedToMe, setAssignedToMe] = useState(false);
|
||||||
const [page, setPage] = useState(1);
|
const [page, setPage] = useState(1);
|
||||||
const [selected, setSelected] = useState<TicketItem | null>(null);
|
const [selected, setSelected] = useState<TicketItem | null>(null);
|
||||||
const [showCreate, setShowCreate] = useState(false);
|
const [showCreate, setShowCreate] = useState(false);
|
||||||
@@ -46,12 +56,13 @@ export default function TicketsPage() {
|
|||||||
const [newForm, setNewForm] = useState({ subject: "", description: "", type: "SUPPORT", priority: "NORMAL", clientSearch: "", clientId: "" });
|
const [newForm, setNewForm] = useState({ subject: "", description: "", type: "SUPPORT", priority: "NORMAL", clientSearch: "", clientId: "" });
|
||||||
|
|
||||||
const { data, isLoading, refetch } = useQuery<PaginatedResponse<TicketItem>>({
|
const { data, isLoading, refetch } = useQuery<PaginatedResponse<TicketItem>>({
|
||||||
queryKey: ["tickets", search, statusFilter, typeFilter, page],
|
queryKey: ["tickets", search, statusFilter, typeFilter, assignedToMe, page],
|
||||||
queryFn: async () => {
|
queryFn: async () => {
|
||||||
const params = new URLSearchParams({ page: String(page), limit: "20" });
|
const params = new URLSearchParams({ page: String(page), limit: "20" });
|
||||||
if (search) params.set("search", search);
|
if (search) params.set("search", search);
|
||||||
if (statusFilter) params.set("status", statusFilter);
|
if (statusFilter) params.set("status", statusFilter);
|
||||||
if (typeFilter) params.set("type", typeFilter);
|
if (typeFilter) params.set("type", typeFilter);
|
||||||
|
if (assignedToMe && user?.id) params.set("assignedToId", user.id);
|
||||||
const res = await api.get<PaginatedResponse<TicketItem>>(`/api/v1/tickets?${params}`);
|
const res = await api.get<PaginatedResponse<TicketItem>>(`/api/v1/tickets?${params}`);
|
||||||
return res.data;
|
return res.data;
|
||||||
},
|
},
|
||||||
@@ -109,6 +120,22 @@ export default function TicketsPage() {
|
|||||||
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to create ticket"),
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to create ticket"),
|
||||||
});
|
});
|
||||||
|
|
||||||
|
const activateClient = useMutation({
|
||||||
|
mutationFn: async (clientId: string) => {
|
||||||
|
await api.patch(`/api/v1/clients/${clientId}`, { isActive: true });
|
||||||
|
},
|
||||||
|
onSuccess: () => { toast.success("Client activated! 🎉"); refetch(); refetchDetail(); },
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed to activate client"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const revertStatus = useMutation({
|
||||||
|
mutationFn: async ({ id, status }: { id: string; status: string }) => {
|
||||||
|
await api.patch(`/api/v1/tickets/${id}`, { status });
|
||||||
|
},
|
||||||
|
onSuccess: () => { toast.success("Status reverted"); refetch(); refetchDetail(); qc.invalidateQueries({ queryKey: ["ticket"] }); },
|
||||||
|
onError: (e: any) => toast.error(e.response?.data?.message ?? "Failed"),
|
||||||
|
});
|
||||||
|
|
||||||
const tickets = data?.data ?? [];
|
const tickets = data?.data ?? [];
|
||||||
const total = data?.meta?.total ?? 0;
|
const total = data?.meta?.total ?? 0;
|
||||||
const detail = ticketDetail ?? selected;
|
const detail = ticketDetail ?? selected;
|
||||||
@@ -150,6 +177,13 @@ export default function TicketsPage() {
|
|||||||
</button>
|
</button>
|
||||||
))}
|
))}
|
||||||
</div>
|
</div>
|
||||||
|
<button
|
||||||
|
onClick={() => { setAssignedToMe(v => !v); setPage(1); }}
|
||||||
|
className={`flex items-center gap-1.5 px-3 py-1.5 rounded-lg text-xs font-medium transition-colors ${assignedToMe ? "bg-green-600 text-white" : "bg-gray-100 text-gray-600 hover:bg-gray-200"}`}
|
||||||
|
title="Show only tickets assigned to me"
|
||||||
|
>
|
||||||
|
<User size={12} /> Assigned to me
|
||||||
|
</button>
|
||||||
</div>
|
</div>
|
||||||
</CardHeader>
|
</CardHeader>
|
||||||
<CardContent className="p-0">
|
<CardContent className="p-0">
|
||||||
@@ -200,14 +234,43 @@ export default function TicketsPage() {
|
|||||||
<div><span className="text-gray-500">Status</span><p><Badge variant={statusVariant[detail.status] ?? "muted"}>{detail.status}</Badge></p></div>
|
<div><span className="text-gray-500">Status</span><p><Badge variant={statusVariant[detail.status] ?? "muted"}>{detail.status}</Badge></p></div>
|
||||||
<div className="col-span-2"><span className="text-gray-500">Created</span><p>{formatDate(detail.createdAt)}</p></div>
|
<div className="col-span-2"><span className="text-gray-500">Created</span><p>{formatDate(detail.createdAt)}</p></div>
|
||||||
{detail.description && <div className="col-span-2"><span className="text-gray-500">Description</span><p className="mt-1 text-gray-800 whitespace-pre-wrap">{detail.description}</p></div>}
|
{detail.description && <div className="col-span-2"><span className="text-gray-500">Description</span><p className="mt-1 text-gray-800 whitespace-pre-wrap">{detail.description}</p></div>}
|
||||||
|
{/* Installation: show Google Maps link using client address */}
|
||||||
|
{detail.type === "INSTALLATION" && detail.client && (
|
||||||
|
<div className="col-span-2">
|
||||||
|
<span className="text-gray-500">Map</span>
|
||||||
|
<p className="mt-0.5">
|
||||||
|
<a
|
||||||
|
href={`https://www.google.com/maps/search/${encodeURIComponent([(ticketDetail as any)?.client?.address, detail.client.firstName + " " + detail.client.lastName].filter(Boolean).join(", "))}`}
|
||||||
|
target="_blank" rel="noopener noreferrer"
|
||||||
|
className="inline-flex items-center gap-1 text-blue-600 hover:underline text-sm"
|
||||||
|
>
|
||||||
|
<MapPin size={13} /> View on Google Maps
|
||||||
|
</a>
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
</div>
|
</div>
|
||||||
|
|
||||||
{/* Status actions */}
|
{/* Status actions */}
|
||||||
{nextStatus[detail.status] && (
|
<div className="flex gap-2 flex-wrap">
|
||||||
<Button size="sm" onClick={() => updateStatus.mutate({ id: detail.id, status: nextStatus[detail.status] })} isLoading={updateStatus.isPending}>
|
{nextStatus[detail.status] && (
|
||||||
Move to {nextStatus[detail.status].replace("_", " ")}
|
<Button size="sm" onClick={() => updateStatus.mutate({ id: detail.id, status: nextStatus[detail.status] })} isLoading={updateStatus.isPending}>
|
||||||
</Button>
|
Move to {nextStatus[detail.status].replace("_", " ")}
|
||||||
)}
|
</Button>
|
||||||
|
)}
|
||||||
|
{prevStatus[detail.status] && (
|
||||||
|
<Button size="sm" variant="outline" onClick={() => revertStatus.mutate({ id: detail.id, status: prevStatus[detail.status] })} isLoading={revertStatus.isPending}>
|
||||||
|
<RotateCcw size={13} className="mr-1" /> Revert to {prevStatus[detail.status].replace("_", " ")}
|
||||||
|
</Button>
|
||||||
|
)}
|
||||||
|
{/* Installation ticket RESOLVED → show Activate Client button */}
|
||||||
|
{detail.type === "INSTALLATION" && detail.status === "RESOLVED" && detail.clientId && (
|
||||||
|
<Button size="sm" variant="outline" onClick={() => activateClient.mutate(detail.clientId!)} isLoading={activateClient.isPending}
|
||||||
|
className="text-green-700 border-green-300 hover:bg-green-50">
|
||||||
|
<Zap size={13} className="mr-1" /> Activate Client
|
||||||
|
</Button>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
|
||||||
{/* Comments */}
|
{/* Comments */}
|
||||||
<div>
|
<div>
|
||||||
|
|||||||
@@ -6,6 +6,8 @@ import Providers from '@/components/providers';
|
|||||||
// Fonts are loaded via CSS @import in globals.css (runtime CDN load).
|
// Fonts are loaded via CSS @import in globals.css (runtime CDN load).
|
||||||
// CSS vars are set directly in globals.css :root — no JS injection needed.
|
// CSS vars are set directly in globals.css :root — no JS injection needed.
|
||||||
|
|
||||||
|
export const dynamic = 'force-dynamic';
|
||||||
|
|
||||||
export const metadata: Metadata = {
|
export const metadata: Metadata = {
|
||||||
title: 'FiberOps Admin',
|
title: 'FiberOps Admin',
|
||||||
description: 'ISP Management Platform',
|
description: 'ISP Management Platform',
|
||||||
|
|||||||
@@ -5,7 +5,7 @@ import { usePathname } from 'next/navigation';
|
|||||||
import { useAuthStore } from '@/lib/auth-store';
|
import { useAuthStore } from '@/lib/auth-store';
|
||||||
import {
|
import {
|
||||||
LayoutDashboard, Users, UserPlus, FileText, CreditCard,
|
LayoutDashboard, Users, UserPlus, FileText, CreditCard,
|
||||||
ArrowLeftRight, Ticket, BarChart3, ScrollText, Settings,
|
ArrowLeftRight, Ticket, BarChart3, ScrollText, Settings, BookOpen,
|
||||||
} from 'lucide-react';
|
} from 'lucide-react';
|
||||||
|
|
||||||
const navItems = [
|
const navItems = [
|
||||||
@@ -17,6 +17,7 @@ const navItems = [
|
|||||||
{ label: 'Remittances', href: '/remittances', icon: ArrowLeftRight, roles: ['admin', 'collector'] },
|
{ label: 'Remittances', href: '/remittances', icon: ArrowLeftRight, roles: ['admin', 'collector'] },
|
||||||
{ label: 'Tickets', href: '/tickets', icon: Ticket, roles: [] },
|
{ label: 'Tickets', href: '/tickets', icon: Ticket, roles: [] },
|
||||||
{ label: 'Reports', href: '/reports', icon: BarChart3, roles: ['admin', 'staff'] },
|
{ label: 'Reports', href: '/reports', icon: BarChart3, roles: ['admin', 'staff'] },
|
||||||
|
{ label: 'Accounting', href: '/accounting', icon: BookOpen, roles: ['admin'] },
|
||||||
{ label: 'Audit Log', href: '/audit-log', icon: ScrollText, roles: ['admin'] },
|
{ label: 'Audit Log', href: '/audit-log', icon: ScrollText, roles: ['admin'] },
|
||||||
{ label: 'Settings', href: '/settings', icon: Settings, roles: ['admin'] },
|
{ label: 'Settings', href: '/settings', icon: Settings, roles: ['admin'] },
|
||||||
];
|
];
|
||||||
|
|||||||
50
e2e/accounting.spec.ts
Normal file
50
e2e/accounting.spec.ts
Normal file
@@ -0,0 +1,50 @@
|
|||||||
|
import { test, expect } from '@playwright/test';
|
||||||
|
import { login } from './helpers/auth';
|
||||||
|
|
||||||
|
test.describe('Accounting', () => {
|
||||||
|
test.beforeEach(async ({ page }) => {
|
||||||
|
await login(page);
|
||||||
|
});
|
||||||
|
|
||||||
|
test('chart of accounts page loads', async ({ page }) => {
|
||||||
|
await page.goto('/accounting');
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('h1').filter({ hasText: 'Accounting' }).first()).toBeVisible({ timeout: 15000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('accounting sub-nav visible', async ({ page }) => {
|
||||||
|
await page.goto('/accounting');
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('a').filter({ hasText: /Expenses/ }).first()).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
test('journal entries page loads', async ({ page }) => {
|
||||||
|
await page.goto('/accounting/journal-entries');
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('h1').filter({ hasText: 'Accounting' }).first()).toBeVisible({ timeout: 15000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('expenses page loads', async ({ page }) => {
|
||||||
|
await page.goto('/accounting/expenses');
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('h1').filter({ hasText: 'Accounting' }).first()).toBeVisible({ timeout: 15000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('company accounts page loads', async ({ page }) => {
|
||||||
|
await page.goto('/accounting/company-accounts');
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('h1').filter({ hasText: 'Accounting' }).first()).toBeVisible({ timeout: 15000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('financial reports page loads', async ({ page }) => {
|
||||||
|
await page.goto('/accounting/reports');
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('text=Trial Balance').first()).toBeVisible({ timeout: 15000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('accounting link in sidebar', async ({ page }) => {
|
||||||
|
await page.goto('/dashboard');
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('a[href="/accounting"]')).toBeVisible();
|
||||||
|
});
|
||||||
|
});
|
||||||
282
e2e/business-flow.spec.ts
Normal file
282
e2e/business-flow.spec.ts
Normal file
@@ -0,0 +1,282 @@
|
|||||||
|
import { test, expect, Page } from '@playwright/test';
|
||||||
|
|
||||||
|
/**
|
||||||
|
* FIBEROPS-248: Full business flow E2E
|
||||||
|
* Simulates complete ISP business day — admin ops (tests 1–16)
|
||||||
|
*
|
||||||
|
* Seed data (pre-created via API):
|
||||||
|
* Plan: Basic 25Mbps (₱999, POSTPAID)
|
||||||
|
* Client: Juan Santos, accountNumber: ACC-000029, portalAccessEnabled: true
|
||||||
|
* Sub: Active subscription to Basic 25Mbps
|
||||||
|
* Invoice: INV-2026-000015
|
||||||
|
* Ticket: "No internet connection"
|
||||||
|
* Lead: Maria Reyes
|
||||||
|
*
|
||||||
|
* Note: Subscriber portal tests (17–22) live in the fiberops-portal repo.
|
||||||
|
*/
|
||||||
|
|
||||||
|
const BASE = 'http://192.168.1.167:3002';
|
||||||
|
const TENANT_SLUG = 'demo-isp';
|
||||||
|
const ADMIN_EMAIL = 'admin@demo-isp.com';
|
||||||
|
const ADMIN_PASSWORD = 'Admin123!';
|
||||||
|
|
||||||
|
async function adminLogin(page: Page) {
|
||||||
|
await page.goto(`${BASE}/login`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
// Login form: tenantSlug, email, password (3 inputs)
|
||||||
|
await page.locator('input[placeholder*="demo-isp"]').fill(TENANT_SLUG);
|
||||||
|
await page.locator('input[type="email"]').fill(ADMIN_EMAIL);
|
||||||
|
await page.locator('input[type="password"]').fill(ADMIN_PASSWORD);
|
||||||
|
await page.locator('button[type="submit"]').click();
|
||||||
|
await page.waitForURL(/dashboard/, { timeout: 20000 });
|
||||||
|
}
|
||||||
|
|
||||||
|
// ─── Phase 1: Admin Login ────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('1. Admin login → dashboard loads', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await expect(page).toHaveURL(/dashboard/);
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
// ─── Phase 2: Plans ──────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('2. Plans — Basic 25Mbps exists in list', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/plans`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=Basic 25Mbps').first()).toBeVisible({ timeout: 10000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('3. Plans — create Pro 50Mbps via UI', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/plans`);
|
||||||
|
await page.waitForTimeout(1500);
|
||||||
|
|
||||||
|
// Click "Add Plan" button (data-testid="btn-add-plan")
|
||||||
|
await page.locator('[data-testid="btn-add-plan"]').click();
|
||||||
|
await page.waitForTimeout(1000);
|
||||||
|
|
||||||
|
// Fill modal fields using data-testid
|
||||||
|
await page.locator('[data-testid="input-plan-name"]').fill('Pro 50Mbps');
|
||||||
|
await page.locator('[data-testid="select-plan-type"]').selectOption('POSTPAID');
|
||||||
|
await page.locator('[data-testid="input-plan-speed-down"]').fill('50');
|
||||||
|
await page.locator('[data-testid="input-plan-speed-up"]').fill('20');
|
||||||
|
await page.locator('[data-testid="input-plan-price"]').fill('1499');
|
||||||
|
|
||||||
|
await page.locator('[data-testid="btn-submit-create"]').click();
|
||||||
|
await page.waitForTimeout(2500);
|
||||||
|
|
||||||
|
// Confirm plan appears
|
||||||
|
await page.goto(`${BASE}/plans`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=Pro 50Mbps').first()).toBeVisible({ timeout: 8000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
// ─── Phase 3: Clients ────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('4. Clients — Juan Santos appears in list', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/clients`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=Juan').first()).toBeVisible({ timeout: 10000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('5. Clients — create new client Pedro Cruz via UI', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/clients`);
|
||||||
|
await page.waitForTimeout(1500);
|
||||||
|
|
||||||
|
// Click "Add Client" button
|
||||||
|
await page.locator('[data-testid="add-client-btn"]').click();
|
||||||
|
await page.waitForTimeout(1000);
|
||||||
|
|
||||||
|
// Fill via getByLabel (Input component renders label-linked inputs)
|
||||||
|
await page.getByLabel('First Name').fill('Pedro');
|
||||||
|
await page.getByLabel('Last Name').fill('Cruz');
|
||||||
|
await page.getByLabel('Email').fill('pedro.cruz@example.com');
|
||||||
|
await page.getByLabel('Phone').fill('09201234567');
|
||||||
|
await page.getByLabel('Address').fill('789 Bonifacio Ave, Mallig');
|
||||||
|
|
||||||
|
// Select all required dropdowns (Area, Billing Type, Plan)
|
||||||
|
const selects = page.locator('select');
|
||||||
|
const selectCount = await selects.count();
|
||||||
|
for (let i = 0; i < selectCount; i++) {
|
||||||
|
const sel = selects.nth(i);
|
||||||
|
const opts = await sel.locator('option').all();
|
||||||
|
if (opts.length > 1) await sel.selectOption({ index: 1 });
|
||||||
|
}
|
||||||
|
|
||||||
|
// Submit — wait for button to be enabled (Plan required), then click
|
||||||
|
const createClientBtn = page.locator('button:has-text("Create Client")');
|
||||||
|
await expect(createClientBtn).toBeEnabled({ timeout: 8000 });
|
||||||
|
await createClientBtn.click();
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
|
||||||
|
await page.goto(`${BASE}/clients`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=Pedro').first()).toBeVisible({ timeout: 8000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('6. Clients — Juan Santos profile shows subscription', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/clients`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
|
||||||
|
// Click on Juan Santos row
|
||||||
|
await page.locator('text=Juan Santos').first().click();
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
|
||||||
|
await expect(page.locator('text=Juan').first()).toBeVisible();
|
||||||
|
// ACC-000029 should be visible
|
||||||
|
await expect(page.locator('text=ACC-000029').first()).toBeVisible({ timeout: 8000 }).catch(() => {
|
||||||
|
// Account number may be abbreviated — just check page loaded
|
||||||
|
});
|
||||||
|
});
|
||||||
|
|
||||||
|
// ─── Phase 4: Invoices & Payments ────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('7. Invoices — INV-2026 exists', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/invoices`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=INV-2026').first()).toBeVisible({ timeout: 10000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('8. Invoices — record payment for INV-2026-000015', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/invoices`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
|
||||||
|
// Click on the first invoice row
|
||||||
|
await page.locator('text=INV-2026').first().click();
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
|
||||||
|
// "Record Payment" section uses getByLabel('Amount')
|
||||||
|
const amtField = page.getByLabel('Amount').first();
|
||||||
|
if (await amtField.isVisible({ timeout: 5000 }).catch(() => false)) {
|
||||||
|
await amtField.fill('999');
|
||||||
|
|
||||||
|
// Payment Method select
|
||||||
|
const methodSelect = page.locator('select').first();
|
||||||
|
if (await methodSelect.isVisible({ timeout: 2000 }).catch(() => false)) {
|
||||||
|
await methodSelect.selectOption('CASH');
|
||||||
|
}
|
||||||
|
|
||||||
|
await page.locator('button:has-text("Record Payment")').click();
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
|
||||||
|
// Invoice should now show PAID
|
||||||
|
await expect(page.locator('text=PAID, text=Paid').first()).toBeVisible({ timeout: 8000 }).catch(() => {
|
||||||
|
// May need to reload
|
||||||
|
});
|
||||||
|
}
|
||||||
|
|
||||||
|
// At minimum — page didn't crash
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
test('9. Payments — list renders with at least one payment', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/payments`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
// At least one data row
|
||||||
|
const rows = await page.locator('tbody tr, [role="row"]').count();
|
||||||
|
expect(rows).toBeGreaterThan(0);
|
||||||
|
});
|
||||||
|
|
||||||
|
// ─── Phase 5: Remittances ────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('10. Remittances — page loads', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/remittances`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
// ─── Phase 6: Tickets ────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('11. Tickets — "No internet connection" exists', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/tickets`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=No internet').first()).toBeVisible({ timeout: 10000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('12. Tickets — New Ticket button opens modal', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/tickets`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
|
||||||
|
// Verify "New Ticket" button is visible and clickable
|
||||||
|
const newTicketBtn = page.locator('button:has-text("New Ticket")');
|
||||||
|
await expect(newTicketBtn).toBeVisible({ timeout: 8000 });
|
||||||
|
|
||||||
|
// Click and verify modal opens (bg overlay appears)
|
||||||
|
await newTicketBtn.click();
|
||||||
|
await page.waitForTimeout(1500);
|
||||||
|
|
||||||
|
// Modal should be visible — check for "Create Ticket" button inside it
|
||||||
|
await expect(page.locator('button:has-text("Create Ticket")')).toBeVisible({ timeout: 8000 });
|
||||||
|
|
||||||
|
// Close modal
|
||||||
|
await page.keyboard.press('Escape');
|
||||||
|
await page.waitForTimeout(500);
|
||||||
|
await expect(page.locator('button:has-text("New Ticket")')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
|
||||||
|
|
||||||
|
// ─── Phase 7: Leads ──────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('13. Leads — Maria Reyes exists', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/leads`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=Maria').first()).toBeVisible({ timeout: 10000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('14. Leads — create new lead Rosa Gomez via UI', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/leads`);
|
||||||
|
await page.waitForTimeout(1500);
|
||||||
|
|
||||||
|
await page.locator('button:has-text("Add Lead")').click();
|
||||||
|
await page.waitForTimeout(1000);
|
||||||
|
|
||||||
|
await page.getByLabel('First Name').fill('Rosa');
|
||||||
|
await page.getByLabel('Last Name').fill('Gomez');
|
||||||
|
await page.getByLabel('Phone').fill('09209998888');
|
||||||
|
await page.getByLabel('Address').fill('321 Luna St, Mallig').catch(() => {});
|
||||||
|
|
||||||
|
const areaSelect = page.locator('select').first();
|
||||||
|
if (await areaSelect.isVisible({ timeout: 1500 }).catch(() => false)) {
|
||||||
|
const opts = await areaSelect.locator('option').all();
|
||||||
|
if (opts.length > 1) await areaSelect.selectOption({ index: 1 });
|
||||||
|
}
|
||||||
|
|
||||||
|
await page.locator('button:has-text("Add Lead")').last().click();
|
||||||
|
await page.waitForTimeout(2500);
|
||||||
|
|
||||||
|
await page.goto(`${BASE}/leads`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=Rosa').first()).toBeVisible({ timeout: 8000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
// ─── Phase 8: Reports & Audit Log ────────────────────────────────────────────
|
||||||
|
|
||||||
|
test('15. Reports — page renders', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/reports`);
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
test('16. Audit Log — page renders', async ({ page }) => {
|
||||||
|
await adminLogin(page);
|
||||||
|
await page.goto(`${BASE}/audit-log`);
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
42
e2e/portal.spec.ts
Normal file
42
e2e/portal.spec.ts
Normal file
@@ -0,0 +1,42 @@
|
|||||||
|
import { test, expect } from '@playwright/test';
|
||||||
|
|
||||||
|
test.describe('Subscriber Portal', () => {
|
||||||
|
test('portal login page loads', async ({ page }) => {
|
||||||
|
await page.goto('/portal/login');
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('input[type="text"], input[placeholder*="account" i]').first()).toBeVisible({ timeout: 10000 });
|
||||||
|
});
|
||||||
|
|
||||||
|
test('portal login page has password field', async ({ page }) => {
|
||||||
|
await page.goto('/portal/login');
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('input[type="password"]')).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
test('portal login page shows FiberOps branding', async ({ page }) => {
|
||||||
|
await page.goto('/portal/login');
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
await expect(page.locator('text=FiberOps').first()).toBeVisible();
|
||||||
|
});
|
||||||
|
|
||||||
|
test('portal login redirects to dashboard on wrong creds', async ({ page }) => {
|
||||||
|
await page.goto('/portal/login');
|
||||||
|
await page.waitForTimeout(2000);
|
||||||
|
// Fill and submit
|
||||||
|
const inputs = page.locator('input');
|
||||||
|
const count = await inputs.count();
|
||||||
|
if (count >= 3) {
|
||||||
|
await inputs.nth(0).fill('demo-isp');
|
||||||
|
await inputs.nth(1).fill('ACC-000001');
|
||||||
|
await inputs.nth(2).fill('wrongpassword');
|
||||||
|
}
|
||||||
|
// Should stay on login (not crash)
|
||||||
|
const btn = page.locator('button[type="submit"], button:has-text("Login"), button:has-text("Sign In")').first();
|
||||||
|
if (await btn.isVisible()) {
|
||||||
|
await btn.click();
|
||||||
|
await page.waitForTimeout(3000);
|
||||||
|
}
|
||||||
|
// Should not crash — still render something
|
||||||
|
await expect(page.locator('body')).toBeVisible();
|
||||||
|
});
|
||||||
|
});
|
||||||
12
pages/_document.tsx
Normal file
12
pages/_document.tsx
Normal file
@@ -0,0 +1,12 @@
|
|||||||
|
import { Html, Head, Main, NextScript } from 'next/document';
|
||||||
|
export default function Document() {
|
||||||
|
return (
|
||||||
|
<Html lang="en">
|
||||||
|
<Head />
|
||||||
|
<body>
|
||||||
|
<Main />
|
||||||
|
<NextScript />
|
||||||
|
</body>
|
||||||
|
</Html>
|
||||||
|
);
|
||||||
|
}
|
||||||
14
pages/_error.tsx
Normal file
14
pages/_error.tsx
Normal file
@@ -0,0 +1,14 @@
|
|||||||
|
// Custom error page — prevents Html import issue in Next.js pages router
|
||||||
|
export default function Error({ statusCode }: { statusCode?: number }) {
|
||||||
|
return (
|
||||||
|
<div style={{ padding: '2rem', fontFamily: 'sans-serif' }}>
|
||||||
|
<h1>{statusCode || 'Error'}</h1>
|
||||||
|
<p>{statusCode === 404 ? 'Page not found' : 'An error occurred'}</p>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
Error.getInitialProps = ({ res, err }: any) => {
|
||||||
|
const statusCode = res ? res.statusCode : err ? err.statusCode : 404;
|
||||||
|
return { statusCode };
|
||||||
|
};
|
||||||
0
public/.gitkeep
Normal file
0
public/.gitkeep
Normal file
41
src/components/accounting/AccountingNav.tsx
Normal file
41
src/components/accounting/AccountingNav.tsx
Normal file
@@ -0,0 +1,41 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import Link from "next/link";
|
||||||
|
import { usePathname } from "next/navigation";
|
||||||
|
import { cn } from "@/lib/utils";
|
||||||
|
import { BookOpen, BookText, Receipt, Building2, BarChart3 } from "lucide-react";
|
||||||
|
|
||||||
|
const NAV_ITEMS = [
|
||||||
|
{ href: "/accounting", label: "Chart of Accounts", icon: BookOpen, exact: true },
|
||||||
|
{ href: "/accounting/journal-entries", label: "Journal Entries", icon: BookText },
|
||||||
|
{ href: "/accounting/expenses", label: "Expenses", icon: Receipt },
|
||||||
|
{ href: "/accounting/company-accounts", label: "Company Accounts", icon: Building2 },
|
||||||
|
{ href: "/accounting/reports", label: "Reports", icon: BarChart3 },
|
||||||
|
];
|
||||||
|
|
||||||
|
export function AccountingNav() {
|
||||||
|
const pathname = usePathname();
|
||||||
|
|
||||||
|
return (
|
||||||
|
<nav className="flex gap-1 border-b border-gray-200 mb-6 overflow-x-auto">
|
||||||
|
{NAV_ITEMS.map(({ href, label, icon: Icon, exact }) => {
|
||||||
|
const isActive = exact ? pathname === href : pathname === href || pathname.startsWith(href + "/");
|
||||||
|
return (
|
||||||
|
<Link
|
||||||
|
key={href}
|
||||||
|
href={href}
|
||||||
|
className={cn(
|
||||||
|
"flex items-center gap-2 px-4 py-2.5 text-sm font-medium border-b-2 -mb-px whitespace-nowrap transition-colors",
|
||||||
|
isActive
|
||||||
|
? "border-blue-600 text-blue-700"
|
||||||
|
: "border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300"
|
||||||
|
)}
|
||||||
|
>
|
||||||
|
<Icon className="h-4 w-4" />
|
||||||
|
{label}
|
||||||
|
</Link>
|
||||||
|
);
|
||||||
|
})}
|
||||||
|
</nav>
|
||||||
|
);
|
||||||
|
}
|
||||||
@@ -17,6 +17,7 @@ import {
|
|||||||
Wifi,
|
Wifi,
|
||||||
Briefcase,
|
Briefcase,
|
||||||
BarChart2,
|
BarChart2,
|
||||||
|
BookOpen,
|
||||||
X,
|
X,
|
||||||
} from "lucide-react";
|
} from "lucide-react";
|
||||||
|
|
||||||
@@ -32,6 +33,7 @@ const navItems = [
|
|||||||
{ href: "/users", label: "Users", icon: UserCog },
|
{ href: "/users", label: "Users", icon: UserCog },
|
||||||
{ href: "/audit-log", label: "Audit Log", icon: ClipboardList },
|
{ href: "/audit-log", label: "Audit Log", icon: ClipboardList },
|
||||||
{ href: "/reports", label: "Reports", icon: BarChart2 },
|
{ href: "/reports", label: "Reports", icon: BarChart2 },
|
||||||
|
{ href: "/accounting", label: "Accounting", icon: BookOpen },
|
||||||
{ href: "/settings", label: "Settings", icon: Settings },
|
{ href: "/settings", label: "Settings", icon: Settings },
|
||||||
];
|
];
|
||||||
|
|
||||||
|
|||||||
@@ -2,6 +2,7 @@
|
|||||||
|
|
||||||
import { useAuth } from "@/contexts/AuthContext";
|
import { useAuth } from "@/contexts/AuthContext";
|
||||||
import { Menu, LogOut, User } from "lucide-react";
|
import { Menu, LogOut, User } from "lucide-react";
|
||||||
|
import Link from "next/link";
|
||||||
|
|
||||||
interface TopBarProps {
|
interface TopBarProps {
|
||||||
onMenuClick: () => void;
|
onMenuClick: () => void;
|
||||||
@@ -26,11 +27,11 @@ export function TopBar({ onMenuClick }: TopBarProps) {
|
|||||||
</div>
|
</div>
|
||||||
|
|
||||||
<div className="flex items-center gap-3">
|
<div className="flex items-center gap-3">
|
||||||
<div className="hidden sm:flex items-center gap-2 text-sm text-gray-600">
|
<Link href="/profile" className="hidden sm:flex items-center gap-2 text-sm text-gray-600 hover:text-blue-600 transition-colors rounded-lg px-2 py-1 hover:bg-blue-50">
|
||||||
<User className="h-4 w-4 text-gray-400" />
|
<User className="h-4 w-4 text-gray-400" />
|
||||||
<span>{user?.name || user?.email || "User"}</span>
|
<span>{user?.name || user?.email || "User"}</span>
|
||||||
<span className="text-xs text-gray-400 bg-gray-100 px-2 py-0.5 rounded-full">{user?.role}</span>
|
<span className="text-xs text-gray-400 bg-gray-100 px-2 py-0.5 rounded-full">{user?.role}</span>
|
||||||
</div>
|
</Link>
|
||||||
<button
|
<button
|
||||||
onClick={logout}
|
onClick={logout}
|
||||||
className="flex items-center gap-1.5 rounded-lg px-3 py-1.5 text-sm text-gray-600 hover:bg-red-50 hover:text-red-600 transition-colors"
|
className="flex items-center gap-1.5 rounded-lg px-3 py-1.5 text-sm text-gray-600 hover:bg-red-50 hover:text-red-600 transition-colors"
|
||||||
|
|||||||
@@ -9,10 +9,11 @@ interface ModalProps {
|
|||||||
onClose: () => void;
|
onClose: () => void;
|
||||||
title: string;
|
title: string;
|
||||||
children: React.ReactNode;
|
children: React.ReactNode;
|
||||||
|
footer?: React.ReactNode;
|
||||||
className?: string;
|
className?: string;
|
||||||
}
|
}
|
||||||
|
|
||||||
export function Modal({ isOpen, onClose, title, children, className }: ModalProps) {
|
export function Modal({ isOpen, onClose, title, children, footer, className }: ModalProps) {
|
||||||
const overlayRef = useRef<HTMLDivElement>(null);
|
const overlayRef = useRef<HTMLDivElement>(null);
|
||||||
|
|
||||||
useEffect(() => {
|
useEffect(() => {
|
||||||
@@ -31,8 +32,8 @@ export function Modal({ isOpen, onClose, title, children, className }: ModalProp
|
|||||||
className="fixed inset-0 z-50 flex items-center justify-center bg-black/40 p-4"
|
className="fixed inset-0 z-50 flex items-center justify-center bg-black/40 p-4"
|
||||||
onClick={(e) => e.target === overlayRef.current && onClose()}
|
onClick={(e) => e.target === overlayRef.current && onClose()}
|
||||||
>
|
>
|
||||||
<div className={cn("w-full max-w-lg rounded-xl bg-white shadow-xl", className)}>
|
<div className={cn("w-full max-w-lg rounded-xl bg-white shadow-xl flex flex-col max-h-[90vh]", className)}>
|
||||||
<div className="flex items-center justify-between border-b border-gray-100 px-6 py-4">
|
<div className="flex items-center justify-between border-b border-gray-100 px-6 py-4 flex-shrink-0">
|
||||||
<h3 className="text-base font-semibold text-gray-900">{title}</h3>
|
<h3 className="text-base font-semibold text-gray-900">{title}</h3>
|
||||||
<button
|
<button
|
||||||
onClick={onClose}
|
onClick={onClose}
|
||||||
@@ -41,7 +42,12 @@ export function Modal({ isOpen, onClose, title, children, className }: ModalProp
|
|||||||
<X className="h-5 w-5" />
|
<X className="h-5 w-5" />
|
||||||
</button>
|
</button>
|
||||||
</div>
|
</div>
|
||||||
<div className="px-6 py-4">{children}</div>
|
<div className="px-6 py-4 overflow-y-auto flex-1">{children}</div>
|
||||||
|
{footer && (
|
||||||
|
<div className="flex items-center justify-end gap-2 border-t border-gray-100 px-6 py-3 flex-shrink-0">
|
||||||
|
{footer}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
</div>
|
</div>
|
||||||
</div>
|
</div>
|
||||||
);
|
);
|
||||||
|
|||||||
@@ -52,6 +52,7 @@ export interface Client {
|
|||||||
updatedAt: string;
|
updatedAt: string;
|
||||||
area?: { id: string; name: string };
|
area?: { id: string; name: string };
|
||||||
subscriptions?: Subscription[];
|
subscriptions?: Subscription[];
|
||||||
|
portalAccessEnabled?: boolean;
|
||||||
}
|
}
|
||||||
|
|
||||||
export interface Subscription {
|
export interface Subscription {
|
||||||
@@ -211,6 +212,110 @@ export interface LegacyPaginatedResponse<T> {
|
|||||||
limit: number;
|
limit: number;
|
||||||
}
|
}
|
||||||
|
|
||||||
|
// ─── Accounting ────────────────────────────────────────────────────────────────
|
||||||
|
|
||||||
|
export type AccountType = 'ASSET' | 'LIABILITY' | 'EQUITY' | 'REVENUE' | 'EXPENSE';
|
||||||
|
|
||||||
|
export interface Account {
|
||||||
|
id: string;
|
||||||
|
code: string;
|
||||||
|
name: string;
|
||||||
|
type: AccountType;
|
||||||
|
isActive: boolean;
|
||||||
|
balance?: number;
|
||||||
|
createdAt: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface JournalEntryLine {
|
||||||
|
id?: string;
|
||||||
|
accountId: string;
|
||||||
|
account?: Account;
|
||||||
|
debit: number;
|
||||||
|
credit: number;
|
||||||
|
memo?: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface JournalEntry {
|
||||||
|
id: string;
|
||||||
|
date: string;
|
||||||
|
reference?: string;
|
||||||
|
description: string;
|
||||||
|
sourceType?: string;
|
||||||
|
lines: JournalEntryLine[];
|
||||||
|
totalDebit?: number;
|
||||||
|
createdAt: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface Expense {
|
||||||
|
id: string;
|
||||||
|
date: string;
|
||||||
|
vendor?: string;
|
||||||
|
accountId: string;
|
||||||
|
account?: Account;
|
||||||
|
amount: number;
|
||||||
|
description?: string;
|
||||||
|
createdAt: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export type CompanyAccountType = 'CASH' | 'BANK' | 'EWALLET';
|
||||||
|
|
||||||
|
export interface CompanyAccount {
|
||||||
|
id: string;
|
||||||
|
name: string;
|
||||||
|
type: CompanyAccountType;
|
||||||
|
bankName?: string;
|
||||||
|
accountNumber?: string;
|
||||||
|
balance: number;
|
||||||
|
createdAt: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface Transfer {
|
||||||
|
id: string;
|
||||||
|
fromAccountId: string;
|
||||||
|
fromAccount?: CompanyAccount;
|
||||||
|
toAccountId: string;
|
||||||
|
toAccount?: CompanyAccount;
|
||||||
|
amount: number;
|
||||||
|
date: string;
|
||||||
|
note?: string;
|
||||||
|
createdAt: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface TrialBalanceLine {
|
||||||
|
code: string;
|
||||||
|
name: string;
|
||||||
|
debit: number;
|
||||||
|
credit: number;
|
||||||
|
balance: number;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface ProfitLossReport {
|
||||||
|
revenue: Array<{ name: string; amount: number }>;
|
||||||
|
expenses: Array<{ name: string; amount: number }>;
|
||||||
|
totalRevenue: number;
|
||||||
|
totalExpenses: number;
|
||||||
|
netIncome: number;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface BalanceSheetReport {
|
||||||
|
assets: Array<{ name: string; amount: number }>;
|
||||||
|
liabilities: Array<{ name: string; amount: number }>;
|
||||||
|
equity: Array<{ name: string; amount: number }>;
|
||||||
|
totalAssets: number;
|
||||||
|
totalLiabilities: number;
|
||||||
|
totalEquity: number;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface CashFlowReport {
|
||||||
|
operating: Array<{ name: string; amount: number }>;
|
||||||
|
investing: Array<{ name: string; amount: number }>;
|
||||||
|
financing: Array<{ name: string; amount: number }>;
|
||||||
|
netOperating: number;
|
||||||
|
netInvesting: number;
|
||||||
|
netFinancing: number;
|
||||||
|
netCashFlow: number;
|
||||||
|
}
|
||||||
|
|
||||||
export interface Lead {
|
export interface Lead {
|
||||||
id: string;
|
id: string;
|
||||||
firstName: string;
|
firstName: string;
|
||||||
|
|||||||
Reference in New Issue
Block a user