Quick access to setup scripts and system checks
Import database/clinic_system.sql with optional reset.
Create or reset admin and create sample users from one page.
Open reset tools for pharmacy transactions, operational cleanup, and full item/test master resets.
Check current and next billing, PO, GRN, and transfer numbers by branch and department, and reset numbering when needed.
Review batches that are near expiry or already expired for the selected branch and department.
Inspect current stock, low stock, and expiry status grouped by medicine.
Find duplicate medicine masters using the same normalized name, generic, trade, form, and strength.
Check for rows that point to missing GRN, dispense, transfer, or open-stock parents.
Review branch and department feature access flags in one place.
Download a quick JSON snapshot of core table counts before resets or imports.
Audit and optionally fix PO, GRN, billing, transfer, and open stock draft numbers.
Check PHP, extensions, storage permissions, and DB connection.
Validate required database tables and key columns with row counts.
Create or repair database tables and columns once, instead of checking them on every page load.
Public room display for current/next/skipped queue by doctor and session.