Build an authentication system (microsystem) based on OpenId able to talk with different applications (micro systems) generating “JWT tokens” this must contain all information about user, company and his authorizations

TOOLS • Working on OpenId, MySql, JSON, Php environments • It would important to use a CRUD application for local development as no complex operation is involved here • All table must have the possibility to import and export data in xls and csv and check for duplicates All duplicates entries must be shown to the superuser for merging/deleting • The best option would be to re-use an existing application or use an atentication/delegation system (but costs need to be discussed) The extra cost will be included in the development cost budget NOTES • All forms must be create in English and Italian (same DB with different labels on the forms) • Same for mails • The translation will be provided during the development process REGISTRATION FORM (SIGN IN- ST I FRON-TEND) User lands on [login to view URL] and in main banner he has just two fields Email and Password and two option log-in sign up If he has already a password he log in and his data are processed trough open Id and this Authorization server then he is redirected to [login to view URL] own menu by WP If he has not yet subscribed but his password is in the Data Base of USER when he enter his password the system shows his data to update them (if necessary); everything can be changed except email=username that is primary key The new registration form will contain following fields: 1. Username -email 2. First Name 3. Family Name 4. Password 5. Category (drop-down menu) (Customer business, Customer individual, Trainer, Training Company) There is an additional field not available on the front-end (6. User Status initially by default=”raw lead”). All these information must be stored into (user table) At the end of the registration we need a Chapta (or something similar) to filter spider and spam REGISTRATION FORM (SIGN IN- ST 2 COMPANY INFO)  In order to complete the registration user receives automatically an email; there will be 2 separated form depending on category: .1. Customer Business, Training Companies, Trainers  IT: Grazie per l’interesse, la preghiamo di completare la registrazione al link sottostante [login to view URL] Cordiali Saluti  EN: Thank you for your interest please complete registration at following link [login to view URL] Kind Regards .2. Customer Individuals  IT: Grazie per l’interesse, la preghiamo di completare la registrazione al link sottostante [login to view URL] Cordiali Saluti  EN: Thank you for your interest please complete registration at following link [login to view URL] Kind Regards • If the customer is an indivual he has no company associated and he have to select just his role= unemployed, graduate, post-graduate • Then insert his personal details (address&contact see below)  The admin (me) will receive a mail with new user details and if everything ok he will updates user status in WP form “raw lead” to “lead”; in order to do that I need to access to application backend and log-in with special super-user credentials  Contact Details (At least one contact for company compulsory)  Contact_ID (in Italy Fiscal code in UK PIN)  Tel, Fax  Place Of Business .... please see enclosed DOC for full description - Proj Charter - ERD schema - Business Process Modelling DIagram