Loans per month
$dateToString · $groupDashboard
Live overview built from MongoDB aggregation pipelines
Book titles0—
Copies on shelf0—
Active loans0—
Overdue0—
Fines collected₹0—
Popularity
$bucketMost borrowed
$sort · $limitTop authors
$group · $sumOverdue now
$lookupIndex lab
explain("executionStats")
The same search run two ways. The text index jumps straight to matching documents; the regex has to read every document in the collection.
Issue a book
transactionLibrary rules
$jsonSchema- 3books per borrower at once, enforced by an atomic update and the schema's
maximum - ₹10fine per overdue day, calculated by MongoDB with
$$NOWon return - ONmulti-document transactions, so an issue or return never half-completes
Scan desk
issue or return in two scansWorks with USB barcode scanners (they type the code and press Enter), the camera in Chrome or Edge, or typing. If the borrower already has the book it is returned, otherwise it is issued.
Active loans
| Book | Borrower | Loan period | Status |
|---|
Register borrower
unique indexAll borrowers
Reserve a book
partial unique indexHow the queue works
$setWindowFields- 1A returned copy goes to the first person waiting instead of the shelf
- 3dit is held for them, and they get an email / SMS that it's ready
- →not collected in time? The hold passes to the next person automatically
Queue
| Book | Borrower | Reserved | Status |
|---|
Outstanding₹0—
Collected₹0—
Building on overdue books₹0payable once returned
Unpaid fines
transaction: loan + payment| Borrower | Book | Returned | Fine |
|---|
Recent payments
payments collectionAudit log
Your name
auditLogs.actorReminders
notifications collectionBackups
Outbox
email · SMS| Sent | To | Message | Status |
|---|