Eastridge Primecare Duty Roster
Live site: https://eastridgerosters.vercel.app
A website where doctors at Eastridge Primecare upload their monthly duty rosters, swap or hand over duties with colleagues, and see which shifts are uncovered. Everything is saved in a free Firebase database, and the site itself is hosted free on Vercel.
Shifts
| Shift | Time |
|---|
| Morning | 08:00 – 14:00 |
| Evening | 14:00 – 20:00 |
| Night | 20:00 – 08:00 next day |
What it does
- Accounts: doctors create an account with email and password (Google sign-in optional) and add their name, department and phone. A coordinator approves each account before they can see or change anything.
- On duty now: the home page opens with who's on the current shift and the next one, for every department (doctors also see the next shift for their own department, listed first), with WhatsApp and call buttons. It follows Pakistan time and switches over by itself at 08:00, 14:00 and 20:00 (after midnight it correctly shows the previous night's team).
- Phone app: the site can be installed to the home screen as Eastridge Roster (Android: Install button on the site or Chrome menu → Install app; iPhone: Safari → Share → Add to Home Screen). It opens full-screen, starts instantly, and shows the last-loaded roster without internet; saving waits until the connection is back.
- My roster: tap M / E / N on a calendar, upload a CSV or Excel (.xlsx) file, or paste rows from a spreadsheet. Dates are read day first (03/11/2026 = 3 November).
- Swaps & changes:
- Swap with a colleague or hand a duty over: nothing changes until the colleague accepts, then both rosters update.
- Move your own duty to another day or shift: takes effect immediately.
- Every upload, edit, swap and move is kept in a change log.
- Hospital roster: doctors open on their own department and can switch to any other department or All departments (master rota). They see who is on which shift, but nothing that totals hours or coverage: no summary numbers, no Checks tab, no over-12-hour marks on colleagues, no "Uncovered" labels outside their own department, and their Excel download is only the day-by-day sheet. Coordinators (and MSA staff) see everything. Day-by-day board with Morning / Evening / Night columns, filterable by department, with Pakistan public holidays marked. Islamic holidays for 2027 are expected dates and may move a day with moon sighting.
- Download month as Excel: one file per month with three sheets (By day, By doctor with M/E/N codes and hours, and the Change log). Use it as a backup and for printing.
- Extended duties (over 12 hours): a doctor who saves a duty stretch longer than 12 hours (e.g. Night then Morning = 18 h) is asked for a reason and the request goes to the coordinator, with WhatsApp opening to the MSA office. Coordinators get a pop-up (and a list in the Checks tab) to Approve or Don't approve; WhatsApp then opens to tell the doctor, who also gets a pop-up. Stretches created by swaps or moves are sent for approval automatically; coordinators' own entries are approved automatically.
- Change log: coordinators only. Doctors see just the requests they sent or received (enforced in
firestore.rules).
- Consultants: a tab for every doctor listing the consultants' OPD (clinic number, speciality, time slots and days), with search, a speciality filter, and In OPD today / In clinic now (Pakistan time). The coordinator uploads the hospital's daily OPD report in the Team tab; only the OPD sheet's schedule columns are kept (no attendance or patient numbers). Stored with the MSA number in
settings/contact, so it adds no reads.
- Live clock: Pakistan time with the current shift and time left, worked out on the device (no database use).
- Station cover prompts: when a station (department) has nobody on a shift, today or later, every MO on duty in another station of the same cover group gets a pop-up: "ICU / HDU has no doctor on Night, Fri 30 Oct. Are you covering it as well?". Yes → the roster, On duty now and Checks show "Covered by Dr. X (ER)". No → WhatsApp opens to the MSA office, and the coordinator gets a "Station not covered" pop-up. Other designations are only asked when no MO in the group is on that shift. Cover groups are set in the Team tab (default: ER and the IPD wards cover each other; ICU / HDU, Anaesthesia and Radiology only themselves). Answers are stored in
cover/.
- Cross-department swaps: doctors can swap with or hand over to a colleague in any department. Each duty keeps the department it belongs to (stored as
away on the roster), so after an ER/ICU swap the ICU doctor appears on the ER roster for that shift (tagged ↔ ICU / HDU), and coverage checks, On duty now and the Excel all count it for ER.
- Swap request pop-up: when a colleague sends you a swap or hand-over request, a pop-up appears on whatever page you're on (live, no refresh), with Review now and Later. Each request pops up once per visit, and again next time the site is opened if it's still unanswered.
- WhatsApp nudges: after sending a swap or hand-over request, or accepting / declining one, WhatsApp opens by itself with a ready-written message to the colleague; the doctor just taps Send. If the phone blocks it, a Send on WhatsApp button appears instead, and the WhatsApp buttons in Swaps & changes stay available. Free; it uses the number in their profile and no extra Firebase usage.
- Announcement banner: coordinators post a message from the Team tab (Notice, Important or Urgent, with an optional end date). It shows across the top of every page for everyone, including the sign-in page, and scrolls like a ticker when it's long. Doctors can hide Notice and Important banners; Urgent ones stay until removed.
- Department rota upload (coordinators, under Edit rosters): one Excel/CSV file with many doctors. Accepts doctor · date · shift rows, a By day sheet (names under Morning / Evening / Night), or a By doctor grid (day numbers across, M/E/N in cells). The site's own Excel download can be uploaded straight back. Names are matched to profile names; unknown names are listed before anything is saved.
- Send rota to the MSA: doctors who can't upload get a WhatsApp button that sends their rota to the MSA office. The number is set by a coordinator in the Team tab and stored in the database (
settings/contact), readable only by approved staff.
- Closed months: once a month is over (Pakistan time), doctors can no longer change it; coordinators still can.
- Designation (required for doctors): MO, SMO, Registrar or Senior Registrar. Shown next to names on the board (MO / SMO / Reg / SR), in the Team tab, swap lists and the Excel download. Doctors who signed up before this was added are asked to fill it in.
- Departments: ER · IPD-1 / Gynae · IPD-1 / NICU (Paediatrics) · IPD-2 (Medicine) / Dialysis · OT / IPD-4 (Surgery) · ICU / HDU · Anaesthesia · Radiology · MSA.
- Checks: uncovered shifts per department, anyone on duty more than 12 hours without a break (e.g. Night then Morning = 18 h), and doctors who haven't uploaded.
- Team (coordinators only): approve or reject sign-ups, remove access, and mark staff who don't do duties (e.g. MSA) as not on the duty roster. They keep access but stay off the board, the checks and swap lists.
Screenshots
The home page opens with the hospital photo and the full logo:
On the other tabs the logo shrinks into a slim bar that stays at the top:
On a phone, in dark mode:
Screenshots show the built-in example month; the doctors in them are made up.
One-time setup (about 10 minutes, free)
1. Create the Firebase project
- Go to https://console.firebase.google.com and click Create a project (e.g.
eastridge-rosters). Google Analytics is not needed.
- On the project home, click the Web icon (
</>) to add a web app. Give it any nickname; skip Firebase Hosting.
- Firebase shows a
firebaseConfig block. Copy those values into firebase-config.js in this repository, replacing the placeholders.
2. Turn on sign-in
- Build → Authentication → Get started.
- Under Sign-in method, enable Email/Password.
- Enable Google too (Add new provider → Google → Enable, pick a support email, Save). The "Continue with Google" button is already switched on in
firebase-config.js.
- Under Settings → Authorized domains, click Add domain and add your Vercel address (
eastridgerosters.vercel.app).
3. Create the database and lock it down
- Build → Firestore Database → Create database. Pick a location near you (for Pakistan, e.g.
asia-south1 Mumbai). Start in production mode.
- Open the Rules tab, replace everything with the contents of
firestore.rules from this repository, and click Publish.
4. Put the site online with Vercel (one time)
- Go to https://vercel.com/new and sign in with your GitHub account.
- Find Eastridge-Rosters in the list and click Import. (If it isn't listed, click Adjust GitHub App Permissions and allow the repository.)
- Leave every setting as it is (
vercel.json in this repository already tells Vercel it's a static site) and click Deploy.
- Vercel gives you an address, for this project
https://eastridgerosters.vercel.app. Add that domain to Firebase's Authorized domains (step 2.4).
From then on, every change pushed to main goes live by itself in under a minute.
5. Make yourself the coordinator
- Open the site, click Create an account, and fill in your details. You'll see Waiting for approval and your user ID. Copy it.
- In the Firebase console: Firestore Database → Data → Start collection. Collection ID:
admins. Document ID: paste your user ID. Add any field (e.g. role = coordinator) and Save.
- Reload the site. You're now the coordinator, with a Team tab where you approve doctors.
If you don't do duties yourself, press Reject on your own profile in the Team tab so you don't appear on the roster. You stay coordinator.
6. Invite the doctors
Send them the site link. Each doctor creates an account, then appears in your Team tab to approve.
Who can do what (enforced by firestore.rules)
| Not approved | Approved doctor | Coordinator |
|---|
| See rosters and the change log | ✗ | ✓ | ✓ |
| Upload / edit rosters, swap, hand over, move (current and future months) | ✗ | ✓ | ✓ (for anyone) |
| Change a month that's over | ✗ | ✗ | ✓ |
| See other departments, summary numbers, Checks tab | ✗ | ✗ (own department only) | ✓ |
| Upload a department rota file | ✗ | ✗ | ✓ |
| Accept or decline a swap | ✗ | only if it was sent to them | ✓ |
| Approve doctors, remove access | ✗ | ✗ | ✓ |
| Make someone a coordinator | ✗ | ✗ | Firebase console only |
Approved doctors can technically write any doctor's roster, because accepting a swap updates both rosters. Every change is recorded in the change log with who made it.
Files
| File | What it is |
|---|
index.html | The whole app (one page, no build step). |
manifest.webmanifest, sw.js | Phone-app settings and the offline helper. Bump VERSION in sw.js if phones ever seem stuck on an old copy. |
vercel.json | Vercel settings: static site, no build, caching and security headers. |
assets/ | Hospital logo, favicon and the hospital photo used on the home page. |
docs/ | Screenshots used in this README. |
firebase-config.js | Your Firebase project settings. These values are not secret; access is controlled by the rules. |
firestore.rules | Database security rules. Paste into the Firebase console, or deploy with npm run deploy:rules. |
tests/rules.test.mjs | 59 automated checks of the security rules (npm install && npm run test:rules, needs Java). |
Before firebase-config.js is filled in, the site shows a Connect a database screen with an example month you can explore. Nothing is saved there.
Updating the security rules
Whenever firestore.rules changes in this repository, copy it into Firebase → Firestore Database → Rules and click Publish (or run npm run deploy:rules). The website updates by itself; the rules don't.
Upload file layouts
One row per duty (two shifts on one day can be written M+E):
date,shift
01/11/2026,Morning
02/11/2026,Night
05/11/2026,M+E
One row per day, mark the shifts:
date,morning,evening,night
01/11/2026,X,,
02/11/2026,,,X
Free-tier limits
Each visit downloads only what's needed: doctors' profiles, the month on screen (coordinators also get last month), and swap requests waiting for an answer. The change log loads only when Swaps & changes is opened. With 60 doctors that is about 126 records per doctor visit (185 for a coordinator), against Firebase's free allowance of 50,000 reads a day.
Firebase's free Spark plan allows 50,000 reads and 20,000 writes per day, which is plenty for a hospital department. No credit card is needed.
