Hi all,

I am looking for the best way to implement the following features:

1) Opening Times / Closing Times

I need to be able to set standard opening times and closing times on the website.  This can't be text in a section, because the database will need to know whether to process a transaction depending on whether or not the store is open.  The website is a web front end for a physical store and so cannot process orders (or should at least give warnings) outside of opening hours.  I need to be able to add custom dates for when the place will be opened or closed.  Generally this functionality is for like restaurant types of businesses.

2) Extending product code information in the database.

Different businesses require different information in the database, e.g. I might need to be able to store manufacturers part code as well as part code etc.  Ideally, I want to create a 1:1 horizontal table containing the part code uniqueidentifier in mojoPortal and then when querying that table to add a join.  This seems to be the cleanest way of doing this without changing mojoPortal tables, but obviously, it means I have to maintain a list of pages within mojoPortal where I have changed the query.

3) Software to determine distance from a specific location.

This is to do with any kind of food delivery business.  Deliver free within a certain range.  We know the site's post code and wish to compare with the user's post code to determine distance.  What's the best software to achieve this?

Cheers,

Shao