def coded_text(self, data): ''' Display all coded text for this code. Coded text comes from ALL files and ALL coders ''' ui = DialogInformation("Coded text : " + self.data['name'], "") cur = self.settings['conn'].cursor() CODENAME = 0 COLOR = 1 SOURCE_NAME = 2 POS0 = 3 POS1 = 4 SELTEXT = 5 OWNER = 6 sql = "select code_name.name, color, source.name, pos0, pos1, seltext, code_text.owner from " sql += "code_text " sql += " join code_name on code_name.cid = code_text.cid join source on fid = source.id " sql += " where code_name.cid =" + str(self.data['cid']) + " " sql += " order by source.name, pos0, code_text.owner " '''sql += " and source.id in (" + str(self.fileIDs) + ") " if coder != "": sql += " and code_text.owner=? " parameters.append(coder) if searchText != "": sql += " and seltext like ? " parameters.append("%" + str(searchText) + "%")''' cur.execute(sql) results = cur.fetchall() html = "" for row in results: color = row[COLOR] title = '<br /><span style=\"background-color:' + color + '\">' title += " File: <em>" + row[SOURCE_NAME] + "</em>" title += ", Coder: <em>" + row[OWNER] + "</em> " title += ", " + str(row[POS0]) + " - " + str(row[POS1]) title += "</span><br />" tmp_html = row[SELTEXT].replace("&", "&") tmp_html = tmp_html.replace("<", "<") tmp_html = tmp_html.replace(">", ">") html += title + tmp_html + "</p>" ui.setHtml(html) ui.exec_()
def case_text(self, data): ''' Display all coded text for this code. Coded text comes from ALL files and ALL coders ''' ui = DialogInformation("Coded text : " + self.data['name'], "") cur = self.settings['conn'].cursor() CODENAME = 0 COLOR = 1 CASE_NAME = 2 POS0 = 3 POS1 = 4 SELTEXT = 5 OWNER = 6 sql = "select code_name.name, color, cases.name, " sql += "code_text.pos0, code_text.pos1, seltext, code_text.owner from code_text " sql += " join code_name on code_name.cid = code_text.cid " sql += " join (case_text join cases on cases.caseid = case_text.caseid) on " sql += " code_text.fid = case_text.fid " sql += " where code_name.cid=" + str(self.data['cid']) + " " sql += " order by cases.name, code_text.pos0, code_text.owner " cur.execute(sql) results = cur.fetchall() html = "" for row in results: color = row[COLOR] title = '<br /><span style=\"background-color:' + color + '\">' title += " Case: <em>" + row[CASE_NAME] + "</em>" title += ", Coder: <em>" + row[OWNER] + "</em> " title += ", " + str(row[POS0]) + " - " + str(row[POS1]) title += "</span><br />" tmp_html = row[SELTEXT].replace("&", "&") tmp_html = tmp_html.replace("<", "<") tmp_html = tmp_html.replace(">", ">") html += title + tmp_html + "</p>" ui.setHtml(html) ui.exec_()