Sylhet Polytechnic Library Management System

The Web Application For digitalize ~(Sylhet Polytechnic Institute)

The Sylhet Polytechnic Library (spi) Management System is a web-based solution primarily developed for Library Administrators to efficiently manage library operations such as book inventory, student membership, book issuing, and returns. It also facilitates controlled student access, ensuring accountability and streamlined management.

– Contributors

Developed Engineers: | AN Mamun

Frontend Live Fontend GitHub Backend Live Backend GitHub

🎯 System Purpose

• To simplify the responsibilities of the library administrator
• To digitize and automate manual library tasks
• To allow students to create accounts, request books, and track borrow history
• To provide a secure and verified onboarding process for students

👥 User Roles

1. Administrator

• Full access to the system
• Verify new student accounts
• Add/update/delete books
• Track issued/returned books
• Manage fines and overdue alerts

2. Student

• Can register an account (inactive by default)
• Must be approved by the admin before access
• Once approved, can:
• Browse available books
• Borrow books (based on borrowing rules)
• Return books
• View personal borrow history

🔐 User Onboarding Flow

Student Registration: - Student signs up and submits their personal and academic information.

Admin Verification: - Admin reviews the student data and activates the account upon approval.

Access Granted: - Once activated, students can log in and use the library system (borrow, return, search books, etc.)

🛠️ Key Features Description

• Student Registration Students register and wait for admin approval
• Admin Panel Admin dashboard to manage books and student accounts
• Book Management Add, edit, delete, and categorize books
• Borrow & Return Issue and return books, track deadlines
• Fine Calculation Automatic fine generation for late returns
• Borrowing History Students and admins can view borrowing logs
• Search & Filter Quickly search books by name, author, category, etc.

Tech Stack

Backend:

• Django – Powerful Python web framework
• Django REST Framework (DRF) – Build RESTful APIs quickly
• JWT Authentication – Secure token-based authentication
• drf-spectacular – Automatic API schema/documentation generation
• PostgreSQL – Production-ready relational database

Frontend:

• React.js – Dynamic frontend development
• Tailwind CSS – Modern utility-first CSS styling
• Supabase – Open source Firebase alternative (for storage or auth if used)

📘 API Documentation

This project provides authentication and admin dashboard APIs using Django REST Framework.

🔐 Authentication APIs

Profile APIs Endpoints

This API is designed for admin users to manage user profiles securely via Token authentication.

🔐 Token Authentication

For all endpoints, admin authentication is required using the token via:

If you're using JavaScript fetch, just set the headers like | For JWT Authentication

headers: {
  'Content-Type': 'application/json',
  'Authorization': 'Token ecb093d6304e1ce411b7cbfabeb4f44a846e08d8'
}

Filters Tags:

?role=student , ?phone=017XXXXXXXX, ?email=user@example.com, ?registration=123456, department=CSE, ?session=20-21, ?nationality_type=NID, ?nationality_number=1234567890,

Books APIs Endpoints

Filters tags:

title,author, isbn, language, category__name

Categories APIs Endpoints

📚 Transaction APIs Endpoints

Filter Tags:

profile, book__title, status,due_date,request_date,borrow_date,return_date

🔍 Available Student Query Parameters (Filters)

You can filter GET requests to endpoints , using the following query parameters:

📎 Live API Docs

View API schema and test endpoints via Spectacular UI:

🔗 Swagger UI
🔗 ReDoc UI (Update links based on deployment)

🛡️ Authentication

All protected endpoints require token-based authentication.
Use the following header format:

Authorization: Token <your_token_here>

Register a new user

{ 
  "username": "string", unique
  "full_name": "string",
  "password": "string", 
  "email": "string", unique
  "phone": "string", unique 
  "roll": "string", unique 
  "registration": "string", unique
  "session": "string", 
  "department": "string",
  "address": "string",
  "blood": "string",
  "gender":"MALE/FEMALE",
  "birthday":"Date",
  "nationality_type": "NID/BIRTH",
  "nationality_number": "string", unique
  "role": "student/admin" // Default - student
} 

Login and receive token

{
  "email": "string",
  "password": "string"
}

Logout and delete token

{
  "token_id": "string"
}

Profile

    {
        "id": 1,
        "user": "anmamun0",
        "full_name": "Nur Mohummod Al Mamun",
        "role": "admin",
        "email": "almamun20044@gmail.com",
        "phone": "01782059949",
        "roll": "676229",
        "registration": "1502221113",
        "session": "2122",
        "address": "Sylhet, Bangladesh - Bangladesh",
        "blood": "O+",
        "nationality_type": "birth",
        "nationality_number": "12345678909876543"
    }

Book

• POST Field example json data

{
  "image": "https://example.com/book.jpg",
  "title": "The Example Book",
  "author": "John Doe",
  "isbn": "9781234567897",
  "language": "English",
  "description": "This is a sample book description.",
  "copies": 10,
  "available": 8,
  "category_ids": [1, 2]
}

Category

{
        "id": 1,
        "name": "Python Programming-hero",
        "slug": "python-programming"
    }

Category model

{
   "id": 1,
   "category": [],
   "image": "https://anmamun0.vercel.app/",
   "title": "Updated -2",
   "author": "hero",
   "isbn": "01",
   "language": "Bangla",
   "description": "asdf",
   "copies": 10,
   "available": 3
}

Transaction Model

 {
   "id": 0,
   "profile": "string",
   "request_date": "2025-05-24T20:41:41.172Z",
   "due_date": 3,
   "borrow_date": "2025-05-24T20:41:41.172Z",
   "return_date": "2025-05-24",
   "status": "pending/borrowed/returned", // Default: pending
   "book": 0
 }

Transaction POST Method

 body:{  
   "due_date": "int", 
   "book": "int"
 }
 headers {
   "Authorization" : "Token 55a1266207cbd56c22a9e5fb508648dfda566e51"
 }