From a253c861daed44aad49ae9a195c9b0bc5d309134 Mon Sep 17 00:00:00 2001
From: chai <chaifix@163.com>
Date: Thu, 25 Jan 2018 20:07:15 +0800
Subject: =?UTF-8?q?=E4=BF=AE=E6=94=B9?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 cgi-bin/issue.py | 38 +++++++++++++++++++++++++++++++++++++-
 1 file changed, 37 insertions(+), 1 deletion(-)

(limited to 'cgi-bin/issue.py')

diff --git a/cgi-bin/issue.py b/cgi-bin/issue.py
index 84d84a7..83f6950 100644
--- a/cgi-bin/issue.py
+++ b/cgi-bin/issue.py
@@ -7,10 +7,46 @@ import issuedb
 from issuedb import IssueDBFactory
 sys.stdout = codecs.getwriter('utf8')(sys.stdout.buffer)
 
+print("Content-type:text/html\n")
+
 db = IssueDBFactory.produce()
 cursor = db.cursor() 
 
+tag_unit_html_file = open("tag_unit.html", 'r', encoding='utf8')
 issue_html_file = open("issue.html", 'r', encoding='utf8')
+issue_html = issue_html_file.read()
+tag_unit_html = tag_unit_html_file.read() 
+
+
+issue = ""
+
+#try: 
+issueId = cgi.FieldStorage().getvalue("id")
+cursor.execute("select * from issue where issueId={0}".format(issueId))
+issue_content = cursor.fetchall()
+issue_content = issue_content[0]
+
+if issue_content != None: 
+    taglist = "" 
+    cursor.execute("SELECT * FROM tag WHERE tagId IN (SELECT tagId FROM relation WHERE issueId = {0})".format(issueId))
+    tags_rows = cursor.fetchall() 
+    for tag_row in tags_rows:
+        tag = tag_unit_html.format(\
+            tagid = tag_row[0], \
+            tag_name = tag_row[1],\
+            tag_count = '' \
+        )
+        taglist += tag 
+    issue = issue_html.format( \
+            issueId = issue_content[0], \
+            issueTitle = issue_content[1],\
+            issueDescription = issue_content[2],\
+            issueSolve = issue_content[3],\
+            tags = taglist\
+        )
+print(issue)
+#except Exception, e:
+#print("Error: unable to fetch data \n" + e.message)   
+
 
 
-print("Content-type:text/html\n")
-- 
cgit v1.1-26-g67d0