I have attached an excel. In this file, it is showing the look of the invoice. and the project should be developed using Spring MVC, Spring JDBC with mysql as database and jsp as frontend. Below is what I want.
-> invoice no. - should be generated automatically
-> invoice to - select from dropdown (a page to add all companies)
->guest name will be entered manually ( enter manually)
->driver name - select from dropdown (a page to add all driver information)
-> vehicle type - select size from dropdown for per hour price (a page to add all sizes and their prices)
AND TABLE SHOULD BE AS FOLLOW:-
->in first column Date should be selected automatically.
-> timeIn, timeOut columns to select time
->less hours columns to less number of hours if any
-> then calculate total number of hours
->hour charges acc to selected size
-> trip charge if any
->toll charge if any
as else you will understand from attached file