CL
CMWDC097S0Active

library management

i want to build a library management system which manages the all request and payment '

Mmithul · ClientFFreelancer · Freelancer
Total deal value$15,500
Authorized$2,000
Captured$2,000
CapturedAuthorized, heldNot funded
M1Library Core Data Model & Basic APIReleased$2,000
Acceptance criteria1Database schema includes "books" table (title, author, ISBN, quantity) and "members" table (name, email, membership_id).2API endpoints exist for creating, reading, updating, and deleting books.3API endpoints exist for creating, reading, updating, and deleting members.4Unit tests cover successful creation and retrieval of a book and a member.5Project uses a specified modern web framework (e.g., Django, Flask, Node.js/Express, Ruby on Rails, FastAPI).
M2Book Lending Logic & User ManagementAwaiting funding$3,500
Acceptance criteria1"users" table schema includes fields for "username", "password_hash", "role" (e.g., 'member', 'admin').2API endpoints for user registration and login return a valid authentication token (e.g., JWT).3"loans" table schema includes "book_id", "member_id", "loan_date", "due_date", "return_date".4API endpoint "/api/loans/borrow" exists, decreases book quantity, creates a loan record, and requires authentication.5API endpoint "/api/loans/return" exists, increases book quantity, updates loan record "return_date", and requires authentication.6Unit tests exist for successful user registration, login, borrowing a book, and returning a book.
M3Book Requesting & Fine CalculationAwaiting funding$4,500
Acceptance criteria1"requests" table schema includes "book_id", "member_id", "request_date", "status" (e.g., 'pending', 'approved', 'denied').2API endpoint "/api/requests/create" allows an authenticated member to request a book.3API endpoint "/api/requests/{id}/approve" allows an authenticated admin to change a request status to 'approved'.4System includes logic to calculate overdue fines based on "loan_date", "due_date", "return_date" and a predefined daily fine rate.5API endpoint "/api/loans/fines/{loan_id}" returns the calculated fine amount for a specific loan.6Unit tests exist for creating a request, approving a request, and calculating fines for an overdue book.
M4Payment Gateway & Admin AnalyticsAwaiting funding$5,500
Acceptance criteria1"payments" table schema includes "loan_id", "amount", "payment_date", "status" (e.g., 'paid', 'failed'), "transaction_id".2Integration with a mock payment gateway (e.g., Stripe test API) exists to process fine payments.3API endpoint "/api/payments/process" exists, accepting "loan_id" and "amount", interacting with the payment gateway, and recording the transaction.4API endpoint "/api/admin/reports/overdue_books" returns a list of all currently overdue books with calculated fines.5API endpoint "/api/admin/reports/top_borrowers" returns members sorted by the number of books borrowed.6Unit tests exist for successfully processing a mock payment and for the "overdue_books" report.