Skip to content

Database information DriverInfo

Jump to bottom
convenient edited this page Feb 18, 2011 · 5 revisions
  • driver_id, driver ID
  • driver, driver number, this database is weird
  • name, driver name
  • holidays_taken, days holiday taken
  • hours_this_year, hours worked this year
  • hours_this_week hours worked this week
  • driver_availability driver availability on certain date
  • getDrivers() - returns IDs of all drivers in the DB
  • findDriver(string number) - find the driver
  • getName(int driver) - get the name of hte driver
  • getHolidaysTaken(int driver) - get the number of days taken, or booked for holidays
  • setHolidaysTaken(int driver) - as above
  • getHoursThisYear(int driver) - set the number of hours worked this year
  • setHoursThisYear(int driver, int value) - as above
  • getHoursThisWeek(int driver) - obvious
  • setHoursThisWeek(int driver, int value) - obvious
  • String getNumber(int driver) - get the ID number of a driver, i think
  • boolean isAvailable(int driver, Date date) - checks whether a driver is available on
  • boolean isAvailable(int driver) - checks if available TODAY!
  • setAvailable(int driver, Date date, boolean available) - set driver availability on a certain date
  • setAvailable(int driver, boolean available) - sets availability for TODAY!

Clone this wiki locally