Pro-Bhupesh/BPCL_HHMS — reverse-engineered prompt

Build me a mobile friendly HHMS app for BPCL to track hose and nozzle replacements at petrol outlets. It should let field technicians raise replacement tickets, officers approve or reject them, warehouse users dispatch stock, and technicians close the job after installation with an optional photo.

Use a simple browser app that can be installed on phones like a PWA, with a clean login screen, role based dashboards, bottom navigation on mobile, and easy ticket cards instead of crowded tables. Store everything in Google Sheets through Google Apps Script so there’s no paid server. Include tickets, outlets, users, stock, settings, and an audit log.

I also want reports for outlet history, frequent replacements, monthly consumption, CSV export, low stock alerts, and a warning if an outlet had a recent replacement in the last 90 days. Please include a setup flow where I can paste the Apps Script web app URL and connect it. Look up current docs online if needed.