Create a User Interface and a Mysql Database for a appointment management solution
€30-250 EUR
Cancelled
Posted almost 9 years ago
€30-250 EUR
Paid on delivery
Project name: Appointment Management
Summary:
I need a database (mysql) solution and a User Interface to be able to show and edit the data from the database in a very user friendly way. It should look and feel like an native app on smartphones and tablets.
All users will have to register once to be able to login to this solution.
All Appointments will be created and edited only by the user admin. All other users can not make any changes. Exception: Change password, telephone number and address. Each user can see only his own appointments created by the admin. The admin user have full control. He can create, edit and delete all appointments using his smartphone, tablet or desktop in a very user friendly way.
Important: This should be a template! I will use one database per client. You have to think that each client will have his own database on my server. Please code friendly.
User Interfaces (User):
- Login Form (email and password field. Options: forgot password, register. Save credentials checkbox)
- Register Form (Firsname, Surename, Bithday, Telefon number, [login to view URL], Adress)
- Forgot Password Form (insert email address and click on send)
- Change Password Form (old password and twice new password and save button)
- My Appointments Form (Past and Future Appointments. Default it should show future appointments but he has the possibility to switch to Past. appointments.
- Appointment Detail View. When you click on an appointment you see all details and also the description from the appointment He can add each appointment to his smartphone calender). Read only
- Users can not change any entry on the appointment.
User Interfaces (Admin). The admin will work 90% of the time using a desktop:
- Login Form (email and password field. Options: forgot password. Save credentials checkbox)
- Forgot Password Form (insert email address and click on send)
- Change Password Form (old password and twice new password and save button)
- User Overview (Firsname, Surename, Bithday, Telefon number, [login to view URL], Adress). The admin can see all Users.
- User Detail Overwiew. By clicking on a User he can see all user details and make adjustments. The admin can see if a user has activated his account or not.
- Appointments Overwiew (show all appointments sort by date showing date, time, firstname and surename. Future and past appointments switchable). It should be possible to show all appointments by a specific date entered by the admin. The Admin can delete appointments very easy from this view
- Appointment Detail View. When you click on an appointment you see all details and also the description from the appointment. Admin can change all and delete appointment.
- Create new Appointment Form (Select User (name and surename) from the databace (combobox), Choose date and time, insert a description) and save.
- Create new User Form. The admin can create a user. A email will be sent to activate. After the activation the user can login.
- Renew Activation Form. The admin can resend an activation to a specific user. Important for the database: The admin can see if a user have activated his account or not
Compatibility:
All Smartphones, Tablets, Laptops and Desktops
Design / Look and feel:
Please open the website freelancer.com on a smartphone. I want the same look. If you have a better idea please show me.
What should be delivered:
- Database mysql sript that create the database and tables automatically
- A documentation where I can see whare to change the Colors from the forms and text and backgrounds.
- The complete solution with all needed files
- A documentation how to setup on my server. It should be very easy to setup!