School Dormitory manigment dashboard banner

School Dormitory manigment dashboard

Created by: bgtulk
3 devlogs
5h 38m 59s

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

bgtulk
bgtulk worked on School Dormitory manigment dashboard
13 days ago
2h 41m logged

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
bgtulk worked on School Dormitory manigment dashboard
14 days ago
1h 36m logged

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
bgtulk worked on School Dormitory manigment dashboard
15 days ago
1h 21m logged

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