HTML/PHP Page with customizable Train Schedule

Programm a HTML/PHP page with a layout very similar to the one shown in the photo (example [login to view URL]). Color-Definitions: - dark Brown #7c3b11 - light Brown #a56323 - dark gray #393939 - light gray #b5b5b5 The blue Color shall be replaced with the dark Brown. The logo in the top right corner shall be a plain dark-brown rectangular (as an image, which can be replaced later) and the text (SBB CFF FFS) shall be replaced with SchoPla Bahn. The watch in the Bottom right corner shall be according to the one on the following url [login to view URL] The widget must be programmed from scratch and may not be copied from the page Above. (i.e. a JS-widget) The page shall be called with a Parameter such as …..php?train_number=123&offset=0 (explanation of parameter offset see bottom section) The contents is taken from a database (to be defined by the programmer) with: TABLE trains - train_id - train_number (example: 123) - train_desc (example: S29) - train_icon (Maybe empty or with an URL to an available Icon) >> use this for your tests: [login to view URL]:[login to view URL] - train_bg (example: FFFFFF for white or 000000 for black) TABLE stations - station_id - parent_train_id - station_time (example: 12:08) - station_name (example: Holderbank AG) - station_icon (Maybe empty or with an URL to an available Icon) >> use this for your tests: [login to view URL]:[login to view URL] The code searches the TABLE trains for the id given as the Parameter with the number given as a parameter in the URL. The description is shown (train_desc, in the photo top left corner) with the backgroundcolor as specified in train_bg. The font shall be white with dark background colors and black with light background colors. The Icon (train_icon) is shown if not empty. The code searches the TABLE stations for all recordes with the parent_train_id == train_id ORDER station_time. The next station with station_time >= current time is shown in the dark bar on the top (in example [login to view URL]: Holderbank AG) with the time as given in the TABLE (Ankunft: 12:08) After that, the next four (4) stations (except for the last station of that train) are shown, ordered by time (e.g. 12:10 Schinznach Bad, 12:16 Brugg) and some gray circles in the gray line. Maybe (as shown in the example [login to view URL]) there are not four stations available, so only 1..2..3 or even none are shown. Note: Icons are show right after the station_name if not = none (as the images given in the link) Note: If there are more stations between the last of the four shown and the final station in the bottom gray bar, the arrow must be dashed (example example Zurich with many [login to view URL]) The last station of the train_id is shown in the Bottom bar as the final target. If the train has reached the final destination (i.e. the time is > than the last station_time of the train specified), the layout according to example final station [login to view URL] is shown. **Explanation for Parameter offset in calling line** The offset specifies the difference between the timestamps specified in TABLE stations (station_time) and the time to be used for the display. Value given in minutes. Example: - offset = 0 - the times as specified in station_time shall be used. >> SELECT ... station_time ... FROM stations ... - offset = 60 - the train is runs on hour later >> SELEC … station_time+("60 minutes") ... FROM stations … This allows to put one train in the database and run it e.g. every hour without adding it several times in the database. The page updates itself automatically. The page shall run on any PC using a web-browser. Deliverables: - all code as needed (html, php, widgets, etc) - dump of database as needed (use mariaDB)