❗ ❗ NOT PRODUCTION READY YET ❗ ❗
- git clone this repository
- (install npm)
- npm install
- (install mysql file into your mysql)
- Set your db credentials
- run node server.js
- press the button above.
- add clearDB to your heroku application
- upload the mysql file in the ClearDB instance
retrieves opening hours for entity ENT_ID and their channel CHANNEL_ID.
url parameters:
- from (e.g. 2017-12-31)
- to (e.g. 2017-12-31)
Retrieve channels and their opening hours from an entity.
url parameters:
- from (e.g. 2017-12-31)
- to (e.g. 2017-12-31)
retrieves all opening hours for this week grouped by entity and channel and day.
url parameters:
- from (e.g. 2017-12-31)
- to (e.g. 2017-12-31)
Is this specific channel CHANNEL_ID for entity ENT_ID open or not?
url parameters
- timestamp: the timestamp to check if channel is opened (defaults to NOW)
Retrieves the open channels for entity ENT_ID
url parameters
- timestamp: the timestamp to check if channels are opened (defaults to NOW)
Retrieves the open channels for all entities grouped per entity
url parameters
- timestamp: the timestamp to check if channels are opened (defaults to NOW)
List all the available channels.
List all the available entities.
Show the entity detail
On the overview page "entities" you can add/edit the system's entities. Each entity has a set of channels (phone/email/...)
A chat is for example chat, email, phone, ... Each entity can have their own blend of channels and opening hours for each of these. For the moment channels is global, you enter channels and every entity can add opening hours for them for this channel.
On the overview page one can
- jump to the opening hours of different channels of different entities.
- jump to opening hours of samen entity / different channel
- copy opening hours schemas from one channel to another or across entities, and this for longer periods (until the end of the year).
- enter as much timeslots per weekday as wanted (not limited) e.g.: form 9 to 10, from 10 to 11, from 11 to 12, from 13 to 14.
- delete timeslots (close opening hours) (= disable channel)
- ID
- name
- link to remote source
- created (timestamp)
- created_by (user_id)
- ID
- name
- created (timestamp)
- created_by (user_id)
- ID
- entity_id
- channel_id
- day (2017-12-31)
- start_time (timestamp)
- end_time (timestamp)
- created (timestamp)
- created_by (user_id)
- ID
- name
- password (hashed + salted)
- created (timestamp)
- created_by (user_id)
- ID
- user_id
- action
- reference (channel/entity/opening_hous)
- value (serialized objects)