Python EMR_utilities.getData方法代码示例

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def OnAddPt(self, event):
	self.textctrl['Insurance Co'].SetValue(self.insChoice.GetStringSelection())
	checkBoxes = ''
	if self.adv_dirYesRB.GetValue() == True:
	    checkBoxes = ' adv_dir = "1",'
	elif self.adv_dirNoRB.GetValue() == True:
	    checkBoxes = ' adv_dir = "2",'
	else: 
	    checkBoxes = ' adv_dir = "0",'
	if self.proxyBox.IsChecked():
	    checkBoxes = checkBoxes + ' proxy = "1",'
	if self.marriedBox.IsChecked():
	    checkBoxes = checkBoxes + ' marital_status = "1",'
	qry = 'INSERT INTO demographics SET' + checkBoxes
	for label, size, field in self.labels:
	    qry = ' '.join([qry, '%s = "%s",' % (field, self.textctrl[label].GetValue())])
	qry = qry.rstrip(',') + ';'
	#check to make sure patient doesn't already exist
	dupCheck = 'SELECT firstname, lastname, dob FROM demographics WHERE firstname = "%s" AND lastname = "%s";' \
		% (self.textctrl['First Name'].GetValue(), self.textctrl['Last Name'].GetValue())
	dupResults = EMR_utilities.getData(dupCheck)
	if dupResults:
	    wx.MessageBox("A patient with this name already exists.", 'DUPLICATE', wx.OK)
	else:
	    EMR_utilities.updateData(qry)
	    pt_ID = EMR_utilities.getData("SELECT LAST_INSERT_ID();")
	    UpdoxImporter.Importer(str(pt_ID[0]))

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
 def OnSign(self, event):
     #check to see if note has already been signed
     checkQry = 'SELECT stamp FROM notes WHERE patient_ID = "%s" AND date = "%s";' % (self.PtID, self.textctrl['Date'].GetValue())
     nullCheck = EMR_utilities.getData(checkQry)
     try:
         if nullCheck[0]:
             wx.MessageBox('Note has already been signed.', 'Message')
         else:
             #get user
             prnt = wx.GetTopLevelParent(self)
             userQry = EMR_utilities.getData('SELECT full_name FROM users WHERE user_name = "%s";' % prnt.user)
             #add signed text at bottom of note
             note = self.soapNote.GetValue() + '\n\n' + 'ELECTRONICALLY SIGNED BY %s ON %s' % (userQry[0], str(EMR_utilities.dateToday(t='sql')))
             #use timestamper
             cli = timestamping.ts_client.TimeStampClient('http://198.199.64.101:8000')
             data = str(self.PtID) + note + self.textctrl['Date'].GetValue()
             val = cli.stamp(data)
             #update the record for that note to include utctime and stamp 
             noteQry = 'UPDATE notes SET soap = %s, utctime = %s, stamp = %s  WHERE patient_ID = %s AND date = %s'
             values = (note, val['utctime'], val['stamp'], self.PtID, self.textctrl['Date'].GetValue())
             EMR_utilities.valuesUpdateData(noteQry, values)
             self.listctrl.Set("")
             self.loadList() 
     except: 
         # catch *all* exceptions
         e0 = sys.exc_info()[0]
         e1 = sys.exc_info()[1]
         wx.MessageBox("Error: %s, %s" % (e0, e1))

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
 def rowFormatter(self, listItem, model):
     qryBill = 'SELECT billable FROM ICD10billable WHERE icd10 = "%s";' % model.icd10
     qryHCC = 'SELECT hcc FROM hcc WHERE icd10 = "%s";' % model.icd10
     resultsBill = EMR_utilities.getData(qryBill)
     resultsHCC = EMR_utilities.getData(qryHCC)
     if resultsBill[0] == '0':
         listItem.SetTextColour(wx.RED)
     else: pass
     try:
         if resultsHCC[0] == 'Yes':
             listItem.SetBackgroundColour('Light Grey')
     except: pass      

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def OnSave(self, event):
	if self.textctrl['ICD #1'].GetValue():
	    #look to see which note is being saved, new vs old
	    prnt = wx.GetTopLevelParent(self)
	    if self.newsoapNote.IsShownOnScreen():
		qry = 'INSERT INTO notes (patient_ID, soap, date, icd1, icd2, icd3, icd4, icd5, \
		    icd6, icd7, icd8, icd9, icd10, not_billable, user) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'
		values = (self.PtID, self.newsoapNote.GetValue(), EMR_utilities.strToDate(self.textctrl['Date'].GetValue()), 
		    self.textctrl['ICD #1'].GetValue(), self.textctrl['ICD #2'].GetValue(), 
		    self.textctrl['ICD #3'].GetValue(), self.textctrl['ICD #4'].GetValue(), 
		    self.textctrl['ICD #5'].GetValue(), self.textctrl['ICD #6'].GetValue(),
		    self.textctrl['ICD #7'].GetValue(), self.textctrl['ICD #8'].GetValue(),
		    self.textctrl['ICD #9'].GetValue(), self.textctrl['ICD #10'].GetValue(),self.not_billable, prnt.user)
		EMR_utilities.valuesUpdateData(qry, values)
	    else:
		#check to see if note has already been signed
		checkQry = 'SELECT stamp FROM notes WHERE patient_ID = "%s" AND date = "%s";' % (self.PtID, self.textctrl['Date'].GetValue())
		nullCheck = EMR_utilities.getData(checkQry)
		if nullCheck[0]:
		    wx.MessageBox('No changes allowed; note has already been signed.', 'Message')
		else:
		    qry = 'UPDATE notes SET soap = %s, user = %s WHERE patient_ID = %s AND date = %s'
		    values = (self.soapNote.GetValue(), prnt.user, self.PtID, self.textctrl['Date'].GetValue())
		    EMR_utilities.valuesUpdateData(qry, values)
	    self.listctrl.Set("")
	    self.loadList()
	    self.textctrl['Date'].SetValue("")
	    self.soapNote.SetValue("")
	    self.newsoapNote.SetValue("")
	    self.billBtn.Show(True)
	else:
	    wx.MessageBox('You forgot to enter an ICD-9 Code', 'Grave Mistake!')

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
def listBilledICD(pt_ID):
    icdList = []
    billedProblems = []
    problems = []
    for i in range(1,11):
        #collect the icd10 codes billed with each note for every note in a given calendar year
        qry = "SELECT icd%d FROM notes INNER JOIN demographics USING (patient_ID) \
                WHERE date LIKE '2015%%' AND patient_ID = %s AND icd%d != '';" % (i,pt_ID,i)
        results = EMR_utilities.getAllData(qry)
	for r in results:
        #create a list from the tuple
	    icdList.append(r)
    #we make a set which eliminates any duplicates
    billedIcdList = set(icdList) #during 2015 some will be icd9 and some icd10
    for part in EMR_utilities.getAllData('SELECT short_des FROM problems10 WHERE patient_ID = %s;' % pt_ID):
        #collects problem names in a list
        problems.append(part[0])
    for item in billedIcdList:
        #gets list of billed problem's descriptions but pulls only icd10
        try:
            des = EMR_utilities.getData('SELECT short_des FROM icd10 WHERE icd10 = "%s";' % item[0])
            billedProblems.append(des[0])
        except: pass
            #print 'Icd %s not found!' % item[0]    #these should be all the icd9 codes billed
    for val in billedProblems:
        #subtracts billed problem's names from the pt's problem list
        if val in problems:
            problems.remove(val)
    EMR_utilities.MESSAGES = EMR_utilities.MESSAGES + 'ICD codes not billed this year:\n\n'
    for x in problems:
        EMR_utilities.MESSAGES = EMR_utilities.MESSAGES + '--' + x + '\n'	    
        EMR_utilities.MESSAGES = EMR_utilities.MESSAGES + '\n\n'

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def EvtSelListBox(self, event):
	"""Problem: because the notes are displayed based on date, if there are more than one note with the same date
	   they will get displayed together in the text control in series.  To fix this I need to add another column 
	   for note_number to the listctrl which is not visible and then reference that number rather than the date 
	   so that notes can be displayed by their ID number.""" 
	#self.loadList()
	self.textctrl['Date'].SetValue("")
	self.soapNote.SetValue("")
	self.textctrl['Date'].AppendText(event.GetString())
	self.newsoapNote.Show(False)
	self.soapNote.Show(True)
	self.Layout()
	for items in self.results:
	    if str(items[3]) == event.GetString():
		self.soapNote.AppendText(items[2])
		try:
		    for i in range(1,11):
			self.textctrl['ICD #%s' % i].SetValue(items[i + 3])
		except: print 'Error: icd value would not set, line 197, Notes.py. Probably a NULL somewhere.'
		#self.textctrl['ICD #1'].SetValue(items[4])
		#self.textctrl['ICD #2'].SetValue(items[5])
		#self.textctrl['ICD #3'].SetValue(items[6])
		#self.textctrl['ICD #4'].SetValue(items[7])
		#self.textctrl['ICD #5'].SetValue(items[8])
		#self.textctrl['ICD #6'].SetValue(items[9])
		#self.textctrl['ICD #7'].SetValue(items[10])
		#self.textctrl['ICD #8'].SetValue(items[11])
		#self.textctrl['ICD #9'].SetValue(items[12])
		#self.textctrl['ICD #10'].SetValue(items[13])
	    else: pass
	self.note_number = EMR_utilities.getData('SELECT note_number FROM notes WHERE date = "%s";' % (event.GetString()))

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def OnTextEnterICD(self, event):
	#when user enters ' ' create single choice dialog with patient's problem list; inserts ICD code for selected problem
	if event.GetString() == ' ':
	    qry = "SELECT short_des FROM problems10 WHERE patient_ID = %s;" % (self.PtID)
	    results = EMR_utilities.getAllData(qry)
	    ptProbList = []
	    for items in results:
		ptProbList.append(items[0])
	    dialog = wx.SingleChoiceDialog(self, 'Select a problem', "Patient's Problem List", ptProbList)
	    if dialog.ShowModal() == wx.ID_OK:
		try:
		    r = EMR_utilities.getData('SELECT icd10 FROM ICD10billable WHERE short_des = "%s" AND billable = "1";' % dialog.GetStringSelection())
		    event.EventObject.SetValue((r)[0])
		    event.EventObject.MarkDirty()
		except: 
		    wx.MessageBox('Not a billable ICD10 code.  Please fix on problem list.', 'Message')
	    else: pass
	#when user enters '?' pull up problem dialog to search for codes
	elif event.GetString() == 'g':
	    string = wx.GetTextFromUser("Search diagnosis list for ...")
	    qry = 'SELECT disease_name FROM icd_9 WHERE disease_name LIKE "%%%s%%";' % (string)
	    results = EMR_utilities.getAllData(qry)
	    probList = []
	    for items in results:
		probList.append(items[0])
	    dialog = wx.SingleChoiceDialog(self, 'Select a problem', 'Master Problem List', probList)
	    if dialog.ShowModal() == wx.ID_OK:
		q = 'SELECT icd_9 FROM icd_9 WHERE disease_name = "%s";' % (dialog.GetStringSelection())
		event.EventObject.SetValue(EMR_utilities.getData(q)[0])
		event.EventObject.MarkDirty()
	    else: pass
	elif event.GetString() == 'f':
	    #this option allows search of www.icd9data.com for specified term
	    term = wx.GetTextFromUser("Look up ICD-9 Code: eg, rotator+cuff")
	    string = 'https://icd10.clindesk.org/#/?q=%s' % term
	    results = EMR_utilities.HTML_Frame(self, "ICD-9 Help", html_str=string)
            results.Show()
	elif event.GetString() == '?':
	    code = icd10picker(self, self, -1, 'ICD 10 Finder')
	    self.icd10code = ''
	    if code.ShowModal() == wx.ID_OK:
		event.EventObject.SetValue(self.icd10code[0])
		event.EventObject.MarkDirty()
	    else: pass
	    code.Destroy()
	else: pass
	event.Skip()

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def __init__(self, ptID, amount):

	self.ptID = ptID
	lt = "%s/EMR_outputs/%s/Other/rcpt-%s.pdf" % (settings.LINUXPATH, self.ptID, EMR_utilities.dateToday())
	at = "%s/EMR_outputs/%s/Other/rcpt-%s.pdf" % (settings.APPLEPATH, self.ptID, EMR_utilities.dateToday())
	wt = "%s\EMR_outputs\%s\Other\rcpt-%s.pdf" % (settings.WINPATH, self.ptID, EMR_utilities.dateToday())
	filename = EMR_utilities.platformText(lt, at, wt)
	doc = SimpleDocTemplate(filename,pagesize=letter,
                        rightMargin=72,leftMargin=72,
                        topMargin=72,bottomMargin=18)
	Story=[]
	#logo = "/home/mb/Documents/icons/idealmedicalpractice-logo-small.png"
	formatted_time = time.strftime("%d %b %Y")
	full_name = settings.NAME
	address_parts = ["8515 Delmar Blvd #217", "University City, MO 63124"]
 
	#im = Image(logo, 2.5*inch, 2*inch)
	#Story.append(im)
 
	styles=getSampleStyleSheet()
	Story.append(Spacer(1, 12))
	styles.add(ParagraphStyle(name='Justify', alignment=TA_JUSTIFY))
	ptext = '<font size=12>%s</font>' % formatted_time
 
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 12))
 
	# Create return address
	ptext = '<font size=12>%s</font>' % full_name
	Story.append(Paragraph(ptext, styles["Normal"]))
	for part in address_parts:
	    ptext = '<font size=12>%s</font>' % part.strip()
	    Story.append(Paragraph(ptext, styles["Normal"]))
 
	Story.append(Spacer(1, 12))
	ptext = '<font size=12>To Whom it May Concern::</font>'
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 12))

	qry = 'SELECT firstname, lastname FROM demographics WHERE patient_ID = %s;' % ptID 
	results = EMR_utilities.getData(qry)
	ptext = "<font size=12>%s %s was seen in my office today and paid $%s toward their bill.  \
		If there are any further questions, please don't hesitate to contact me at the \
		above address or by phone at (314) 667-5276.</font>" % (results[0], 
									results[1],
									amount)
	Story.append(Paragraph(ptext, styles["Justify"]))
	Story.append(Spacer(1, 12))
 
	ptext = '<font size=12>Sincerely,</font>'
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 48))
	ptext = '<font size=12>%s</font>' % settings.NAME
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 12))
	doc.build(Story)

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def __init__(self, ptID, amount):

	self.ptID = ptID
	filename = "/home/mb/Desktop/GECKO/EMR_outputs/%s/Other/rcpt-%s.pdf" % (self.ptID, EMR_utilities.dateToday())
	doc = SimpleDocTemplate(filename,pagesize=letter,
                        rightMargin=72,leftMargin=72,
                        topMargin=72,bottomMargin=18)
	Story=[]
	logo = "/home/mb/Documents/icons/idealmedicalpractice-logo-small.png"
	formatted_time = time.strftime("%d %b %Y")
	full_name = "Michael Barron MD"
	address_parts = ["1423 S Big Bend Blvd", "Richmond Heights, MO 63117"]
 
	im = Image(logo, 2.5*inch, 2*inch)
	Story.append(im)
 
	styles=getSampleStyleSheet()
	Story.append(Spacer(1, 12))
	styles.add(ParagraphStyle(name='Justify', alignment=TA_JUSTIFY))
	ptext = '<font size=12>%s</font>' % formatted_time
 
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 12))
 
	# Create return address
	ptext = '<font size=12>%s</font>' % full_name
	Story.append(Paragraph(ptext, styles["Normal"]))
	for part in address_parts:
	    ptext = '<font size=12>%s</font>' % part.strip()
	    Story.append(Paragraph(ptext, styles["Normal"]))
 
	Story.append(Spacer(1, 12))
	ptext = '<font size=12>To Whom it May Concern::</font>'
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 12))

	qry = 'SELECT firstname, lastname FROM demographics WHERE patient_ID = %s;' % ptID 
	results = EMR_utilities.getData(qry)
	ptext = "<font size=12>%s %s was seen in my office today and paid $%s toward their bill.  \
		If there are any further questions, please don't hesitate to contact me at the \
		above address or by phone at (314) 667-5276.</font>" % (results[0], 
									results[1],
									amount)
	Story.append(Paragraph(ptext, styles["Justify"]))
	Story.append(Spacer(1, 12))
 
	ptext = '<font size=12>Sincerely,</font>'
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 48))
	ptext = '<font size=12>Michael Barron MD</font>'
	Story.append(Paragraph(ptext, styles["Normal"]))
	Story.append(Spacer(1, 12))
	doc.build(Story)

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def OnCarePlanBtn(self, event):
	#check to make sure a note has been stared
	if self.newsoapNote.GetValue() == '':
	    #if there is a saved note for today, start care plan
	    if self.soapNote.GetValue():
		#check to make sure a care plan has not already been created; can only use it once
		qry = 'SELECT * FROM education WHERE date = "%s" AND patient_ID = "%s";' % (EMR_utilities.dateToday(), self.PtID)
		results = EMR_utilities.getData(qry)
		if results:
		    dlg = wx.MessageDialog(None, "A saved care plan for today already exists.  Look in the Education tab.", "Important", wx.OK)
		    dlg.ShowModal()
		else:
		    if self.GetParent().GetPage(7).neweducNote.GetValue() == '':
			cp = CarePlan.CarePlanFrame(self, self.PtID)
			cp.Show(True)
			cp.notesinstance = self
		    else:
			dlg = wx.MessageDialog(None, "A new care plan for today already exists.  Look in the Education tab.", "Important", wx.OK)
			dlg.ShowModal()
	    #now we know there is neither a new or saved note, so give error message
	    else:
		dlg = wx.MessageDialog(None, "Please start a note before starting care plan.", "Important", wx.OK)
		dlg.ShowModal()
	else:
	    #check to make sure a care plan has not already been created; can only use it once
	    qry = 'SELECT * FROM education WHERE date = "%s" AND patient_ID = "%s";' % (EMR_utilities.dateToday(), self.PtID)
	    results = EMR_utilities.getData(qry)
	    if results:
		dlg = wx.MessageDialog(None, "A saved care plan for today already exists.  Look in the Education tab.", "Important", wx.OK)
		dlg.ShowModal()
	    else:
		if self.GetParent().GetPage(7).neweducNote.GetValue() == '':
		    cp = CarePlan.CarePlanFrame(self, self.PtID)
		    cp.Show(True)
		    cp.notesinstance = self
		else:
		    dlg = wx.MessageDialog(None, "A new care plan for today already exists.  Look in the Education tab.", "Important", wx.OK)
		    dlg.ShowModal() 

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
 def OnNewProb(self, event):
     #opens dialog window with fields for new problem, does lookup based on description only, updates MySQL,
     #then clears the list and resets the lists with new query for problems
     dlg = AddProblemDialog(self, self, -1, 'New Problem')
     dlg.ProbInstance = self
     dlg.CenterOnScreen()
     if dlg.ShowModal() == wx.ID_OK:
         today = datetime.date.today()
         newICD = EMR_utilities.getData('SELECT icd10 FROM ICD10billable WHERE short_des = "%s";' % self.problem)
         query = 'INSERT INTO problems10 SET short_des = "%s", prob_date = "%s", patient_ID = "%s", icd10 = "%s";' % \
             (self.problem, today, self.ptID, newICD[0])
         EMR_utilities.updateData(query)
         self.UpdateList()
     dlg.Destroy()

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def EvtSelListBox(self, event):
        """Problem: because the notes are displayed based on date, if there are more than one note with the same date
	   they will get displayed together in the text control in series.  To fix this I need to add another column 
	   for note_number to the listctrl which is not visible and then reference that number rather than the date 
	   so that notes can be displayed by their ID number."""
        # self.loadList()
        self.textctrl["Date"].SetValue("")
        self.educNote.SetValue("")
        self.textctrl["Date"].AppendText(event.GetString())
        self.neweducNote.Show(False)
        self.educNote.Show(True)
        self.Layout()
        for items in self.results:
            if str(items[3]) == event.GetString():
                self.educNote.AppendText(items[2])
            else:
                pass
        self.educ_number = EMR_utilities.getData(
            'SELECT educ_number FROM education WHERE date = "%s";' % (event.GetString())
        )

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def UpdateVitals(self, event):
	updateqry = 'INSERT INTO vitals SET wt = "%s", ht = "%s", hc = "%s", temp = "%s", sBP = "%s", dBP = "%s", \
	      pulse = "%s", resp = "%s", sats = "%s", vitals_date = "%s", patient_ID = %s;' % (self.textctrl['Wt'].GetValue(), 
	      self.textctrl['Ht'].GetValue(), self.textctrl['HC'].GetValue(), self.textctrl['Temp'].GetValue(), 
	      self.textctrl['SBP'].GetValue(), self.textctrl['DBP'].GetValue(), self.textctrl['Pulse'].GetValue(), 
	      self.textctrl['Resp'].GetValue(), self.textctrl['O2 Sats'].GetValue(), self.textctrl['Date'].GetValue(), 
	      self.PtID)
	EMR_utilities.updateData(updateqry)
	self.UpdateList()
	data = EMR_utilities.getData("SELECT dob, sex FROM demographics WHERE patient_ID = %s;" % self.PtID)
	if data[1] == 'male':
	    sex = 'boy'
	else: sex = 'girl'
	s = data[0].strftime("%B") + ',' + str(data[0].day) + ',' + str(data[0].year) + ',' + sex + ',' + \
		self.textctrl['Ht'].GetValue() + ',' + self.textctrl['Wt'].GetValue() + ',' + self.textctrl['HC'].GetValue()
	with open('/home/mb/Dropbox/iMacros/Datasources/growth.txt', 'w') as f:
	    f.write(s)
	    f.close()
	self.Layout()			#this line from C M and Robin Dunn on the mailing list; see 20 Feb 08 email
	for items in self.textctrl:
	    self.textctrl[items].SetValue("")

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
def getVitals(ptID, baby=0):
	qry = "SELECT temp, sBP, dBP, pulse, resp, sats, wt, ht FROM vitals WHERE patient_ID = %s AND vitals_date = '%s;'" \
	      % (ptID, str(EMR_utilities.dateToday()))
	results = EMR_utilities.getData(qry)
	string = "Vitals: "
	try:
	    bmi = format((decimal.Decimal(results[6])/(decimal.Decimal(results[7])*decimal.Decimal(results[7])))*703, '.1f')
	except:
	    bmi = 'not calculated'
	if baby == 0:
	    if results == None:
		string = string + "none taken today"
	    else:
		string = string + 'T%s %s/%s P%s R%s O2Sats: %s Wt:%s BMI: %s' % (results[0], results[1], results[2], results[3], \
		     results[4], results[5], results[6], bmi)
	    return string
	else: 
	    if results == None:
		string = string + "none taken today"
	    else:
		string = string + 'Wt: %s, Length: %s' % (results[6], results[7])
	    return string

# 需要导入模块: import EMR_utilities [as 别名]
# 或者: from EMR_utilities import getData [as 别名]
    def name_find(self):
	q = "SELECT CONCAT(firstname, ' ', lastname) FROM demographics WHERE patient_ID = %s;" % self.pt_ID
	return EMR_utilities.getData(q)