Medical Tourism Application
I programmed the entire functionality of this site. It is a database driven application to track all patients, queries, price quotes, receipts, invoices, itineraries, and calendars for a medical tourism company. It includes internal messaging and database generated statistics. There are different options and permissions allowed for different types of users, based on both what side the company is on (hospital, insurance company, administrator, travel agent) and what type of user within the company (administrator, secretary, etc...). I developed it using PHP, MySQL, Javascript, HTML, CSS.
Medical Tourism homepage, including alerts upon login about upcoming events and site maintenance actions, such as automated archiving and deleting after certain amounts of time 
Users - different types based on whether the user is part of an insurance client, medical center, travel agent, or admin; user permissions within each company 
Detailed patients information page, organized by category of information, links to related queries 
Queries page, with special highlights for queries pending a response 
Detailed query, including comments from each company 
List of media sent along with the various patients and queries, automatically deleted after a certain amount of time. Also notice the filter and results per page options, and the multiple pages as there are many results - these features are for every list. 
List of procedures - these show up in the query request form as a list with an "other" option. When a procedure is approved in the system, it is added to this list along with prices for it in different countries. Statistics are generated from the database to compare procedures based on profit and comparing countries/procedures charges against each other 
Calendar generated by database for an inputted amount of time 
Statistics page - extensive database generated statistics for and during an inputted amount of time |
Internal messaging system - messages are highlighted different colors depending on whether they are new in your inbox, or whether they have not yet been read by the recipient yet - so you can check on the status of your messages 
Message view has somewhat of a Facebook look to it, with extra information added 
Form to request an itinerary from a travel agent, javascript is used in the form - query and patient fields are updated upon each change - to make it more user friendly for organizing patients with their queries 
Database generated Receipt 
Form used to create an invoice, includes Javascript to automatically calculate the total of every item. Also used for price quotes and receipts. 
Database generated Price Quote 
Search feature allows searches by database table or all at once and searches every field of every table with organized results |
