Oil Change and Preventative Maintenance Workflow

Inicio del flujo de trabajo/proceso.

Create a new entry in the 'Service Orders' data model when a customer requests maintenance.

Retrieve previous service records from the 'Service History' data model using the License Plate ID.

Update the 'Last Service Mileage' field in the 'Vehicle' data model with the current odometer reading.

Calculate the future date by adding 6 months or 5,000 miles (whichever comes first) to the current date.

Create a task for the assigned Mechanic to perform the oil and filter replacement.

Create a task for the technician to follow a checklist for tire pressure, brakes, and fluid levels.

Get entries from the 'Parts Inventory' data model to verify availability of oil filters and specific oil grades.

Reduce the quantity of oil filters and motor oil in the 'Parts Inventory' data model after use.

Aggregate the cost of all parts used in this service order to determine total material expense.

Sum the cost of labor and the aggregated parts cost to produce the final invoice amount.

Create a task for the Shop Foreman to verify that all inspection points were completed and signed off.

Update the 'Service Order' status to 'Completed' and attach the final cost calculation.

Send an email to the customer's email address containing the work performed and the next service due date.

Send an SMS to the customer's phone number notifying them that their vehicle is ready for pickup.

Create a report summarizing all completed oil changes and total revenue generated during the month.

Fin del flujo de trabajo/proceso.