Health Organizer Code

XML file in usb stick + program to show it in full screen for rescue teams

When I select a value from the combobox the timer for the search should be stopped

Rules: i.e. when the blood pressure is less than X then show an alert or similar

Highlight should be placed in TfrmEditStandard (auto visible according to the presence of the fields)

http://sourceforge.net/projects/naps2/ to let user scan files?

When I sort in the navigation, edit is no more available. Why?

Open the files to attach in Read-Only mode (PDF problem...)

Lazarus / FPC:
	Check the error in the column translations (seems to be new, now fixed inside the relative masks, but each time you compile all the translations of the columns are taken away from the .po!)
	Problem of Columns.ImageIndex if the columns were created automatically (see TFrmNavigationStandard).

FAQ on the web site

For Windows, just the following Dlls are necessary to be able to connect to PostgreSQL:
libeay32.dll
libpq.dll
ssleay32.dll

Icons + Lazarus+fpc in about window

All this file should be store in the tickets...

In Portuguese Linux the Desktop folder to save all the attachments doesn't work (the folder is not called "Desktop", but with a Portugues name). However, if you select that folder manually it works.

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);