September 2026
Cheque Schedule & Action Calendar
0 Making Reminders
0 Maturing Cheques (AED 0.00)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
Due Today
0
AED 0.00
Prepare Cheques TodayOverdue
0
AED 0.00
Making Date PassedWithin 3 Days
0
AED 0.00
Action Required SoonWithin 7 Days
0
AED 0.00
Prepare Next WeekUpcoming
0
AED 0.00
Scheduled This MonthTotal Monthly
0
AED 0.00
Cleared: 0 (AED 0.00)MySQL2 Database Status
Checking...
Real-time connection verification using mysql2/promise and TanStack Query
Latency
...
Target Host / DB
...
MySQL Version
...
Raw SQL Quickstart Snippets
How to perform typed queries, atomic transactions, and consume them with TanStack Query.
// src/app/api/items/route.ts
import { NextResponse } from 'next/server'
import { query, execute } from '@/lib/db'
export async function GET() {
// Parameterized query with automatic type casting
const items = await query<{ id: number; name: string; created_at: string }>(
'SELECT id, name, created_at FROM items ORDER BY id DESC LIMIT ?',
[10]
)
return NextResponse.json({ items })
}
export async function POST(req: Request) {
const { name } = await req.json()
const result = await execute(
'INSERT INTO items (name) VALUES (?)',
[name]
)
return NextResponse.json({ insertId: result.insertId }, { status: 201 })
} Test connection in CLI:
npm run db:testEdit connection settings in .env.local