Changeset 2718

Timestamp:

10/26/07 05:56:48 (1 year ago)

Author:

coling

Message:

• Weak attempt at using new ticket workflows (status\!='closed')
  
• Properly esacpe summary
  
• Add status field into the changes XML
  

Files:

• clientsplugin/0.11/cron/send-client-email (modified) (6 diffs)

clientsplugin/0.11/cron/send-client-email

@@ -45 +45 @@
-from trac.util.datefmt import format_date, to_datetime
-from trac.wiki import wiki_to_html
-
+
-
-parser = OptionParser()
@@ -226 +226 @@
-              WHERE tcust.name = 'client'
-                AND tcust.value = %s
-IN ('new','assigned','reopened')
+!= 'closed'
-              """)
-            cur2 = db.cursor()
@@ -235 +235 @@
-              xml.write('<ticket>')
-              xml.write('<id>%s</id>' % tid)
-summary
+escape(summary)
-              xml.write('<description>%s</description>' % wiki_to_html(extract_client_text(description), self.env, self.req))
-              xml.write('<status>%s</status>' % status)
@@ -247 +247 @@
-            # Load in any changes that have happend
-            sql = ("""\
-
+status, t.
-              FROM ticket_custom tcust
-              INNER JOIN ticket t ON tcust.ticket=t.id
@@ -263 +263 @@
-            xml.write('<changes>')
-            lasttid = 0
-
+status, 
-              text = ''
-              if 'status' == cgfield:
-&quot;%s&quot; to &quot;%s&quot;
+"%s" to "%s"
-              elif 'milestone' == cgfield:
-&quot;%s&quot; to &quot;%s&quot;
+"%s" to "%s"
-              elif 'comment' == cgfield:
-                # Todo - extract...
@@ -288 +288 @@
-                xml.write('<ticket>')
-                xml.write('<id>%s</id>' % tid)
-summary
+escape(summary)
-                xml.write('<description>%s</description>' % wiki_to_html(extract_client_text(description), self.env, self.req))
+                xml.write('<status>%s</status>' % status)
-                xml.write('<milestone>%s</milestone>' % milestone)
-                xml.write('<due>%s</due>' % myformat_date(due))