Platform for booking and dispatching septic tank pumping

We have a septic tank pumping and maintenance company, and we need a web application that connects the entire journey from the first customer call to a paid invoice. Homeowners and property managers should be able to book a pumping online: select a property from their account, specify the type of work (scheduled pumping, inspection, emergency visit), see available time slots and confirm the request. Each property has its own card: tank volume and number of chambers, date of last pumping, access notes, gate codes and photos of hatch location. Based on tank volume and household load, the system calculates the recommended pumping interval and automatically sends reminders via email and SMS before the date approaches — this way one-time customers become regular ones. Dispatchers need a route board that groups daily requests by district and arranges stop order to reduce mileage, showing each address on a map with travel time estimate. Masters open requests on phone or tablet, record the pumped volume, sludge and crust depth, condition of partitions and filter, attach before and after photos; completed inspection reports are generated in branded PDF for the client and for the regulatory authority. Emergency visits receive priority in queue and after-hours surcharge rules. When closing a request, the application issues an invoice with line items, taxes and surcharges, accepts online card payment and tracks arrears with automatic overdue notifications. Result: adaptive client portal, dispatcher and master panels, administrative section for prices and service catalog, PDF report and invoice generation, email and SMS notification engine, and documented REST API for future accounting integration. Stack — PHP with MySQL database, maps via cartographic service. A plan is needed to migrate our current customer and property database from spreadsheets.