I guess this is something simle for someone who is a bit experienced. Firstly I ll say what is my target with this and then what I am asking for. My target is to make a simple web based application and put it up on the internet so that a doctor will access it and add his customers, scheduled appointments and follow up for these [url removed, login to view] web files for this will be uploaded from me (I have the server background ready,) and I will also run the sql code for creating the database tables on a Mysql db that I will create on my server. What you need to do is:
a) Create 3 database tables:
1)Customers (Customer_ID=numeric-the table primary key), (Name&Surname=text), (Date of birth=date),(AMKA=numeric), (Phone=numeric), (Mobile=numeric), (Street & number = text), (City=text), (Email= text), (Main Comments = text)
From the above only Customer_ID will is not allowed to be empty will submiting a new customer
2)Appointments (Appointment_ID =numeric-the table primary key) (Date = date), (Customer_ID= taken automatically when the user will pick the customer), (Comments = text), (Done = binary) , (Cancelled=binary)
3)Medical history (Medical_history_ID =numeric-the table primary key)( Customer_ID = taken automatically when the user will pick the customer) , (Comments=text)
Create the below web pages:
It will have 3 buttons - "Customers" , "Appointments" , "Quich search"
When the user clicks on "Customers" it will open a page that will have a search field so that the user will be able to search for customers using all the fields found in "Customers" table. It will also have a button "add customer" so that he will be able to add customer.
The search results will give a catalogue with customers and the user will be able to click next to their name the buttons: "review". After this he will go into the customers page where he will be able to click and see all the appointments history and also medical history (using data from the tables mentioned above).
When the user clicks on "Appointments" he will be able to search for Appointments from the search field (using all the fields from the appointments tabel)
It will also have a button "add appointment" so that he will be able to add appointment.
The search results will give a catalogue with appointments and the user will be able to click next to them the button: "review". After this he will go into the appointment page where he will be able to click and right down comments about the appointment, make it "done" , cancel it, change its date etc. (using data from the tables mentioned above).
This is it! I will also provide some mockups regarding the above. The layout will be the simplest [url removed, login to view] someone believes that he could make this using some other tool rather than php and mysql I could listen to any suggestion.
We will need one more table in the database, that will store only one variable. It will be : Password_table , with only one field: "password" ---> text. In there I will put a password and the user would have to insert that specific password in a simple authentication page before entering the programm. The user will not be able to change the password. Also there will not be a "sign in" button. Only one password will exist for everyone. I will only know the password and in order to reset it I will do this directly from the database.
I also attach the mockups, please review them and provide your bids.
24 freelancers are bidding on average $49 for this job
Hello kerville7, I have read your requirements, I'm a PHP/MySQL Expert and I am very confident to do this project. I guarantee COMPLETE satisfaction before payment. Please check PM for more details!
Hello, Ready to start now. We would like to work on this [url removed, login to view] have gone through your requirement and can finish it within time frame. we have a team who are best at their [url removed, login to view] are ready to discuss about your More