andresbejarano / DentalRegistry

A data-management system for dental clinics. Keeps record of patients, appointments, treatments, procedures and budgets.
20 stars 10 forks source link

Request for notes on features and functionality of Dental Registry #3

Open kuiper01 opened 8 years ago

kuiper01 commented 8 years ago

Hi Andres,

Can you please provide some more notes on the features and functionality of Dental Registry (apart from the summary you provided for the project here on Github i.e "A data-management system for dental clinics. Keeps record of patients, appointments, treatments, procedures and budgets."

The reason for this request is as it stands, one has to try to look through the code and the various php files to determine the functionality. It would be much easier if there was some kind of notes or explanation provided.

Very many thanks.

Regards,

andresbejarano commented 8 years ago

Well, this is an old project I was working on for some local small businesses in the area. It was custom-made software; so, many things regarding dental businesses management, patient records and stuff was (and still is) unknown to me. I stopped giving assistance to this project due to other obligations.

Approach the code in the following way:

  1. Every php file in the main folder is a page with an specific functionality in the system. I tried to name them according to their respective task.
  2. Every php file in the main folder has an associate js file in the js folder. The reason is I wanted to do communication with the DB using Ajax.
  3. Concerning DB communication. All the transactions logic is in the modules/dbhandler.php file. My approach was to group all the required queries to the database in a single file, such that modifications are only done in one place instead of looking through all the php files.
  4. In modules/function.php there are plenty of common functions to all modules. It was the same logic as in modules/dbhandler.php
  5. The version I posted in github is the generic version. I did some other versions based on this one with more functionalities and different DB transaction approaches. Unfortunately I lost the code of those versions. I could save the very initial one.

For sure there are better ways for doing this kind of applications. I coded this during the years when the combination Apache+MySQL+PHP has a hit and Ajax was getting stronger (around 2012).

Hope it helps.

kuiper01 commented 8 years ago

Yes, it does. very many thanks Andres.