when I started on this again, I can ask the question I needed to ask 6 hours
ago !
I have all of this data, each row has patient details, doctors details, and
a drug type, qty, dosage etc. I need to generate "electronic" prescriptions
from this data.
The basic rules for writing a script are:
3 Drugs per script only
No drug can be prescribed twice in one day
Dangerous Drugs, and Authority drugs are on separate scripts again
My intention was to use the cfhttp tag to get the csv data and loop through
it, starting with the first entry I would make a structure, this would
resemble an actual piece of paper being a script. This structure would have
elements being Doctors name, Prescriber Number, Patient Name etc etc, and
for each of the three drugs on this one piece of paper ( structure ) I would
have an array within the structure. Once I built up the structure, I could
then dump it into DB tables for retrieval later on.
The hardest parts I am stumbling on are:
Grabbing the patients and looping through the rest of the data. 200 lines of
data = "" drugs. Do I start the loop, and then try and match the patient
name to the other 200 rows, count how many occurrences there are on that
same day from the first row of data ??? If there are 1 - 3 drugs for this
patient I only need one structure, but if there are 4 - 6 drugs I now need 2
structures.
Araghaghagha just thinking about it doing my head in !
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
