[Gnumed-devel] Idea for miniproject: travel medicine module

[Ian Haywood]

I will post this when the wiki is back up

A module for travel medicine


two tables in the backend

create table maps
(
	zoom_level integer, -- 0 is the whole-world map, increment from there. 
We probably only need 3 zoom levels.
        region box, -- in latitude/longitude co-ordinates
        map bytea -- the JPEG or whatever, we need a DFSG-free source for these
);

create table travel_info,
(
        region polygon, -- in latitude/longitude co-ordinates
        area text, -- free text description of the area
        comment text, -- the particular comment about
the specific disease & its management, for the doctor
	pat_comment text, -- for the patient, LaTeX fragment to form a 
customised printed handout.
        fk_vacc integer references vacc_indication (pk),
        -- the vaccine to give, if relevant.
);


The widget, maybe popup from keyword "travel" in RFE?

Split horizontally. Top-half: map image from maps.map displayed.
Always start with map where zoom=0 [i.e. the world]

Bottom-half: travel medicine requirements for the mouse's current 
position above on click: that is, you click on the map where the patient 
is going. Calculates by converting mouse co-ordinates to lat-long by 
maps.region, then match to travel_info.region [postgres "~" operator 
does this automatically]
Buttons to popup vaccination dialogue for listed vaccines, and print 
patient handout compiled from all travel_info.pat_comment entries.
Zoom in and out using mouse wheel or +/- for the mouse-challenged, 
calculating mouse position as above to find map to zoom to.
What to people think?

Ian

signature.asc
Description: OpenPGP digital signature