Health Organizer Code

The program is free!

Documents into problems with notes
problems in examination + filters

Store 

Team changes:
- about form with team information

Add the "Hippocratic Oath" in the about information?

Diary notes

Parking: if there are stairs or not from the parking to the hospital


When you change an existing blood group / rh, asks three times if that change has to be saved (a person can't change blood group!!!)

Unit of measurements conversion

Store unit of measurements and date/time formats into a "translation" (or similar) table. When the USB drive will be written, use that table to convert and to write in the right format each data


Request of reference country to set up the data (i.e. °C or °F, Kg or lbs, etc.)

tHospitals: geografical fields a must

Create a new derived Navigation and edit standard with patient information (ID + NAme)
Create centralized open navigation / add methods in the main to open / add generic and patient orientated window

Examinations "request by" or Examination link that required the new examination.
Problem's history graph: examination A -> B -> C etc.

Copyright: year written automatically
Do not translate the author and the website in the about
Comments in the translation (like: "Do not translate")
Table list of people working on
Add Lazarus/FPC credits and links

Category of doctors (one fixed: "family doctor" that is used to filter the doctors to assign to the patients).
When you change a doctor assigned to a patient, ask if it was a mistake or the new doctor. If it's the new doctor, take an history of this

Name, surname, country, city and all the information to write inside the USB pen MUST BE written also in "clear words" for languages like Japanese/Chinese
Find some Japanese / Chinese doctor to test this...

Highlight (select) the start language in the menù
After a change of language, sort the menu contents in alphabetic order
All the freepascal\fpc\source\fpc\packages\fcl-db\src\base\dbconst.pas translations are missing. Translate them and inform the lazarus/fpc project

In the "safe life" USB  stick, write that I/HOR is not responsable of the data inserted by the user and suggest to contact the referent doctor to be sure the written data are correct.

Check/implement SSL db connection

Trace:
- natural father, mother
- legal father, mother
- brothers, sisters
- rent uterus
- transplants

Parking with GIS

Trigger on each table to trace the changes
Possibility to look at the changes
Delete the changes after X day

Check the xmin and the changes before to save the changes to handle different changes from different users in the same record

Login names for the program = PostgreSQL login user

Notes as extra information of the picture document. I.e. I have a JPG with some results and I store graphical objects information to show/hide on it.
In this way I can highlight some part, type notes, etc., but I also can print out the original document as it is 

Low priority
------------
Look if it is possible to create a class from TSQLTransaction that doesn't any transaction of to avoid the transaction start to avoid the ExecuteDirect in hor_dbopen.pas or implement CreateDb in the connection component or make the transaction a new option

Data import:
http://www.dados.gov.pt/pt/inicio/Inicio.aspx
http://www.infarmed.pt/portal/page/portal/INFARMED
http://www.atlasdasaude.pt/lista-de-medicamentos-infarmed



To create the SQL from the database use:
pg_dump --no-owner --no-privileges --schema-only --username=postgres healthorganizer > mydb.sql
and after edit mydb.sql to comment out the line "COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';"
and to fill the tSettings table:
INSERT INTO "tSettings" ("DbVersion") values (1);