School Dormitory manigment dashboard banner

School Dormitory manigment dashboard

4 devlogs
14h 30m 46s

This program will be a management dashboard page where the School Accounting will control the students dormitory fees and others.

bgtulk

That was long time not working on this project…
So here is fast recap of my work:
Payment & Taxes:

  • Payment modal fixes
  • Taxes fixes
    Features:
  • Data validation implementation
  • Block system rework
  • Printing Accommodation functionality
  • Language synchronizatio
    Bug Fixes:
  • Duplicate variable declaration in reports.js
  • SQL GROUP BY error causing 500 error on /api/rooms
  • Template literal line break in updateRoomsByBlock
  • Database name typo: schetovodstvo → shchetovodstvo
  • Old unpaid months now retain the old fee when changed
    Database:
  • Added block column to rooms table
    Localization:
  • Months changed to Bulgarian (Януари-Декември) with default days
  • Full Bulgarian translation (login, buttons, errors)
    UI Changes:
  • Removed “Такса” (Fee) column from student reports
  • Rooms now display “М” and “Г” instead of 2 and 3
    Cleanup & Configuration:
  • Deleted node_modules directory
  • Updated PORT variable in .env file
  • Minor adjustments and changes
Attachment
Attachment
Attachment
0
bgtulk

Todays dev log

settings tab

Added monthly multipliers for fees and base fee setting that can update all students at once. Made dropdown to switch between settings and months now show in proper order jan to dec.

payment tab

Search by egn or class works client-side so its instant. Shows unpaid months from start date with calculated fees based on multipliers. Year filter included and months with 0 multiplier are hidden. Payment modal pays oldest months first, calculates resto, lets you pick cash or bank transfer and saves exact payment time.

database changes

Updated student_payments table with year column for multi-year tracking, payment_method column for cash/bank, changed payment_date to TIMESTAMP and made unique constraint use student_id, month_id and year.

reports

Added daily payments report showing todays transactions with student name, month, amount, time and payment method.

student notes

Added notes field to students table, shows as textarea when editing.

fixes

Payments respect multipliers, students pay from start date forward only, client-side search is instant.

future idea

Fiscal printer plan: web -> backend -> python app -> printer.
let me know if you have any other idea for the connection with the fiscal printer

Attachment
Attachment
Attachment
Attachment
0
bgtulk

Hello!
This is todays devlog:

Backend

  • Implemented room capacity validation check to prevent overbooking.
  • Added API endpoints for fetching and updating individual room details.

Frontend

  • Room Management:

    • Added “Rooms” report to view status of all rooms.
    • Implemented room editing functionality (capacity, usage status, problem reporting).
    • Updated room dropdown in student form to show capacity and free spaces.
  • Validation:

    • Added client-side validation for student forms (Name regex, EGN length, Phone formatting).
  • Refactoring & Cleanup:

    • Extracted inline styles from HTML files to public/styles.css.
    • modularized Dashboard logic into separate files in public/js/ (main.js, students.js, rooms.js, reports.js, navigation.js).
0
bgtulk

Hello,
Today I added the students add page and the view of them
also I made all the tables for the database and make the project structure.
The design is so ahh, but eventually I will make it.

I integrated google translate because my program is in Bulgarian, because the program will actually be used in my school.

Attachment
Attachment
0