1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
|
# -*- coding: utf-8 -*-
#from __future__ import print_function
__doc__ = """GNUmed ATC handling widgets."""
#================================================================
__author__ = "Karsten Hilbert <Karsten.Hilbert@gmx.net>"
__license__ = "GPL v2 or later"
import logging
import sys
import os.path
import wx
if __name__ == '__main__':
sys.path.insert(0, '../../')
from Gnumed.pycommon import gmI18N
gmI18N.activate_locale()
gmI18N.install_domain(domain = 'gnumed')
from Gnumed.pycommon import gmTools
from Gnumed.pycommon import gmMatchProvider
from Gnumed.pycommon import gmDispatcher
from Gnumed.business import gmATC
from Gnumed.wxpython import gmAuthWidgets
from Gnumed.wxpython import gmListWidgets
from Gnumed.wxpython import gmPhraseWheel
_log = logging.getLogger('gm.ui.atc')
#============================================================
def browse_atc_reference_deprecated(parent=None):
if parent is None:
parent = wx.GetApp().GetTopWindow()
#------------------------------------------------------------
def refresh(lctrl):
atcs = gmATC.get_reference_atcs()
items = [ [
a['atc'],
a['term'],
gmTools.coalesce(a['unit'], ''),
gmTools.coalesce(a['administrative_route'], ''),
gmTools.coalesce(a['comment'], ''),
a['version'],
a['lang']
] for a in atcs ]
lctrl.set_string_items(items)
lctrl.set_data(atcs)
#------------------------------------------------------------
gmListWidgets.get_choices_from_list (
parent = parent,
msg = _('\nThe ATC codes as known to GNUmed.\n'),
caption = _('Showing ATC codes.'),
columns = [ 'ATC', _('Term'), _('Unit'), _('Route'), _('Comment'), _('Version'), _('Language') ],
single_selection = True,
refresh_callback = refresh
)
#============================================================
def update_atc_reference_data():
dlg = wx.FileDialog (
parent = None,
message = _('Choose an ATC import config file'),
defaultDir = os.path.expanduser(os.path.join('~', 'gnumed')),
defaultFile = '',
wildcard = "%s (*.conf)|*.conf|%s (*)|*" % (_('config files'), _('all files')),
style = wx.FD_OPEN | wx.FD_FILE_MUST_EXIST
)
result = dlg.ShowModal()
if result == wx.ID_CANCEL:
return
cfg_file = dlg.GetPath()
dlg.DestroyLater()
conn = gmAuthWidgets.get_dbowner_connection(procedure = _('importing ATC reference data'))
if conn is None:
return False
wx.BeginBusyCursor()
if gmATC.atc_import(cfg_fname = cfg_file, conn = conn):
gmDispatcher.send(signal = 'statustext', msg = _('Successfully imported ATC reference data.'))
else:
gmDispatcher.send(signal = 'statustext', msg = _('Importing ATC reference data failed.'), beep = True)
wx.EndBusyCursor()
return True
#============================================================
class cATCPhraseWheel(gmPhraseWheel.cPhraseWheel):
def __init__(self, *args, **kwargs):
gmPhraseWheel.cPhraseWheel.__init__(self, *args, **kwargs)
query = """
SELECT DISTINCT ON (data)
data,
field_label,
list_label
FROM (
(
SELECT
code AS data,
(code || ': ' || term)
AS list_label,
(code || ' (' || term || ')')
AS field_label
FROM ref.atc
WHERE
term %(fragment_condition)s
OR
code %(fragment_condition)s
) UNION ALL (
SELECT
atc as data,
(atc || ': ' || description)
AS list_label,
(atc || ' (' || description || ')')
AS field_label
FROM ref.substance
WHERE
description %(fragment_condition)s
OR
atc %(fragment_condition)s
) UNION ALL (
SELECT
atc_code AS data,
(atc_code || ': ' || description || ' (' || preparation || ')')
AS list_label,
(atc_code || ': ' || description)
AS field_label
FROM ref.drug_product
WHERE
description %(fragment_condition)s
OR
atc_code %(fragment_condition)s
)
-- it would be nice to be able to include ref.vacc_indication but that's hard to do in SQL
) AS candidates
WHERE data IS NOT NULL
ORDER BY data, list_label
LIMIT 50"""
mp = gmMatchProvider.cMatchProvider_SQL2(queries = query)
mp.setThresholds(1, 2, 4)
# mp.word_separators = '[ \t=+&:@]+'
self.SetToolTip(_('Select an ATC (Anatomical-Therapeutic-Chemical) code.'))
self.matcher = mp
self.selection_only = True
#============================================================
# main
#------------------------------------------------------------
if __name__ == '__main__':
if len(sys.argv) < 2:
sys.exit()
if sys.argv[1] != 'test':
sys.exit()
from Gnumed.pycommon import gmPG2
#----------------------------------------
gmPG2.get_connection()
app = wx.PyWidgetTester(size = (600, 80))
app.SetWidget(cATCPhraseWheel, -1)
app.MainLoop()
|
